ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

46 rows where date = "2020-03-27" and state = "California" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths, date (date)

fips >30

state 1

  • California · 46 ✖
Link rowid date ▲ county state fips cases deaths
14143 14143 2020-03-27 Alameda California 6001 241 4
14144 14144 2020-03-27 Amador California 6005 1 0
14145 14145 2020-03-27 Butte California 6007 5 0
14146 14146 2020-03-27 Calaveras California 6009 3 0
14147 14147 2020-03-27 Colusa California 6011 1 0
14148 14148 2020-03-27 Contra Costa California 6013 151 2
14149 14149 2020-03-27 El Dorado California 6017 12 0
14150 14150 2020-03-27 Fresno California 6019 31 0
14151 14151 2020-03-27 Humboldt California 6023 14 0
14152 14152 2020-03-27 Imperial California 6025 21 0
14153 14153 2020-03-27 Inyo California 6027 5 0
14154 14154 2020-03-27 Kern California 6029 41 1
14155 14155 2020-03-27 Kings California 6031 1 0
14156 14156 2020-03-27 Los Angeles California 6037 1465 27
14157 14157 2020-03-27 Madera California 6039 11 1
14158 14158 2020-03-27 Marin California 6041 69 1
14159 14159 2020-03-27 Mendocino California 6045 2 0
14160 14160 2020-03-27 Merced California 6047 7 0
14161 14161 2020-03-27 Mono California 6051 8 0
14162 14162 2020-03-27 Monterey California 6053 27 1
14163 14163 2020-03-27 Napa California 6055 10 0
14164 14164 2020-03-27 Nevada California 6057 12 0
14165 14165 2020-03-27 Orange California 6059 321 3
14166 14166 2020-03-27 Placer California 6061 41 1
14167 14167 2020-03-27 Riverside California 6065 185 8
14168 14168 2020-03-27 Sacramento California 6067 164 6
14169 14169 2020-03-27 San Benito California 6069 11 1
14170 14170 2020-03-27 San Bernardino California 6071 64 3
14171 14171 2020-03-27 San Diego California 6073 417 5
14172 14172 2020-03-27 San Francisco California 6075 282 3
14173 14173 2020-03-27 San Joaquin California 6077 93 4
14174 14174 2020-03-27 San Luis Obispo California 6079 59 0
14175 14175 2020-03-27 San Mateo California 6081 239 6
14176 14176 2020-03-27 Santa Barbara California 6083 47 0
14177 14177 2020-03-27 Santa Clara California 6085 574 21
14178 14178 2020-03-27 Santa Cruz California 6087 34 0
14179 14179 2020-03-27 Shasta California 6089 3 1
14180 14180 2020-03-27 Siskiyou California 6093 3 0
14181 14181 2020-03-27 Solano California 6095 39 0
14182 14182 2020-03-27 Sonoma California 6097 50 1
14183 14183 2020-03-27 Stanislaus California 6099 23 0
14184 14184 2020-03-27 Sutter California 6101 2 0
14185 14185 2020-03-27 Tulare California 6107 24 0
14186 14186 2020-03-27 Ventura California 6111 83 3
14187 14187 2020-03-27 Yolo California 6113 16 1
14188 14188 2020-03-27 Yuba California 6115 3 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);