seeds
2 rows where season contains " fall", season contains " summer " and season contains "spring " sorted by min_full_sun
This data as json, CSV (advanced)
id | ideal_temp | min_full_sun ▼ | plant_spacing | season | seed_name | year_produced | need_to_reorder | days_to_harvest | is_flower | num_packets | indertiminate_determinate | notes |
---|---|---|---|---|---|---|---|---|---|---|---|---|
14 | 2-3in | ["spring ", " summer ", " fall"] | scarlet nantes carrots | 2019 | 65-75 | |||||||
10 | 60-80 | full sun | 3-4in | ["spring ", " summer ", " fall"] | Jung Green yu choy | 2020 | 40-45 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [seeds] ( [id] INTEGER PRIMARY KEY, [ideal_temp] TEXT, [min_full_sun] TEXT, [plant_spacing] TEXT, [season] TEXT, [seed_name] TEXT, [year_produced] TEXT, [need_to_reorder] INTEGER, [days_to_harvest] TEXT, [is_flower] TEXT, [num_packets] FLOAT, [indertiminate_determinate] TEXT, [notes] TEXT );