16 rows where season contains "winter"

View and edit SQL

Suggested facets: ideal_temp, min_full_sun, plant_spacing, season, year_produced, days_to_harvest

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
0 45-65 6-12H 8in ["fall", "winter", "spring"] scarlet kale 2020 0          
2 50-80   4-6in ["fall", "winter", "spring", "summer"] bok choi white taisai 2020   50        
3 65-75 full sun 6-8in ["fall", "winter", "spring"] suiho chinese kale 2020   50-65        
5 50-80 full sun 1-2in ["fall", "winter", "spring"] red tatsoi bok choy 2020   40-50        
13       ["fall", "winter", "spring"] chinese luobo radish 2018            
111 55-60 2-6 3-9 ["spring", "fall", "winter"] common chives 2020            
112 45-80 6-12 4 ["spring", "fall", "winter", "summer"] Sugar Daddy Peas 2020            
114 60-80 4-8 8 ["spring", "fall", "winter"] Buttercrunch Lettuce 2020            
119 50-65 8-12 6-10 ["spring", "winter", "fall"] Chinese Celery Dark Green Kintsai 2021   30-59        
122 50-80   2 ["summer", "fall", "winter", "spring"] Ishikura Improved Green Onion 2021   40-50        
147 50-80   6-12 ["summer", "Spring", "fall", "winter"] Sierra Lettuce 2021   40        
148 50-80   6-12 ["Spring", "fall", "winter"] Jericho Lettuce 2021   40        
149 50-95   3-4 ["Spring", "fall", "winter", "summer"] Tokyo Long White Green Onion 2021   60        
151 50-95   3-4 ["Spring", "fall", "winter", "summer"] Calendula 2021     yes      
152 50-95   3-4 ["Spring", "fall", "winter", "summer"] Borrage 2021     yes      
153 50-95   3-4 ["Spring", "fall", "winter", "summer"] Purple Coneflower - Echinecea Purplea 2021     yes      

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