seeds

2 rows where season contains "spring", season contains "summer", season contains "winter" and year_produced = 2020 sorted by seed_name

✎ View and edit SQL

This data as json, CSV (advanced)

season (array) ✖

year_produced ✖

  • 2020 · 2 ✖
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
112 45-80 6-12 4 ["spring", "fall", "winter", "summer"] Sugar Daddy Peas 2020            
2 50-80   4-6in ["fall", "winter", "spring", "summer"] bok choi white taisai 2020   50        

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