seeds
2 rows where season contains " summer", season contains "fall " and season contains "spring " sorted by is_flower
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
16 | 55-75 | full sun | 3-4 | ["fall ", " winter ", "spring ", " summer"] | shimonita negi green onion | 2020 | 120-140 | |||||
86 | full sun | 8-12 | ["fall ", "winter ", "spring ", " summer"] | cilantro | 2017 | 40-60 |
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 );