seeds
1 row where min_full_sun = "sun/part shade" sorted by seed_name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | 60-70 | sun/part shade | .5in | ["perennial"] | flowering chinese leek | 2020 |
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 );