4 rows where season contains "fall " and season contains "spring " sorted by days_to_harvest

View and edit SQL

Suggested facets: min_full_sun

season (array)

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
18 50-85 full sun 8-10 ["fall ", " winter ", "spring "] Brunswick Cabbage 2019   100        
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        
75 50-60 partial shade   ["spring ", " winter ", "fall "] jade gem lettuce 2014   55        

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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
);