4 rows where season contains "annual (summer)" sorted by seed_name

View and edit SQL

Suggested facets: ideal_temp, plant_spacing, year_produced

season (array)

  • annual (summer) · 4
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
137 80-90   14-16 ["annual (summer)"] Hungarian Paprika Peppers 2021   50        
71   full sun   ["annual (summer)"] korean dark green pepper 2019            
66 65-75   10-12 ["annual (summer)"] malabar spinich 2020   60       will vine
61 80-90 full sun 14-16 ["annual (summer)"] thai pepper prik chi faa 2020            

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