seeds
1 row where season contains "spring " and season contains "summer " sorted by days_to_harvest
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
12 | 50-75 | 6-8h | 2-3in | ["spring ", "summer ", "fall"] | cosmic purple carrot | 2017 / 2019 | 4.0 |
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 );