ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where "date" is on date 2020-07-27 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
373260 | 373260 | 2020-07-27 | Alameda | California | 6001 | 10510 | 178 |
373261 | 373261 | 2020-07-27 | Alpine | California | 6003 | 2 | 0 |
373262 | 373262 | 2020-07-27 | Amador | California | 6005 | 82 | 0 |
373263 | 373263 | 2020-07-27 | Butte | California | 6007 | 822 | 7 |
373264 | 373264 | 2020-07-27 | Calaveras | California | 6009 | 103 | 1 |
373265 | 373265 | 2020-07-27 | Colusa | California | 6011 | 273 | 2 |
373266 | 373266 | 2020-07-27 | Contra Costa | California | 6013 | 7095 | 104 |
373267 | 373267 | 2020-07-27 | Del Norte | California | 6015 | 88 | 0 |
373268 | 373268 | 2020-07-27 | El Dorado | California | 6017 | 555 | 1 |
373269 | 373269 | 2020-07-27 | Fresno | California | 6019 | 13209 | 112 |
373270 | 373270 | 2020-07-27 | Glenn | California | 6021 | 265 | 1 |
373271 | 373271 | 2020-07-27 | Humboldt | California | 6023 | 217 | 4 |
373272 | 373272 | 2020-07-27 | Imperial | California | 6025 | 9162 | 180 |
373273 | 373273 | 2020-07-27 | Inyo | California | 6027 | 43 | 1 |
373274 | 373274 | 2020-07-27 | Kern | California | 6029 | 17394 | 123 |
373275 | 373275 | 2020-07-27 | Kings | California | 6031 | 3966 | 49 |
373276 | 373276 | 2020-07-27 | Lake | California | 6033 | 175 | 1 |
373277 | 373277 | 2020-07-27 | Lassen | California | 6035 | 558 | 0 |
373278 | 373278 | 2020-07-27 | Los Angeles | California | 6037 | 176028 | 4375 |
373279 | 373279 | 2020-07-27 | Madera | California | 6039 | 1744 | 21 |
373280 | 373280 | 2020-07-27 | Marin | California | 6041 | 4769 | 54 |
373281 | 373281 | 2020-07-27 | Mariposa | California | 6043 | 48 | 2 |
373282 | 373282 | 2020-07-27 | Mendocino | California | 6045 | 274 | 6 |
373283 | 373283 | 2020-07-27 | Merced | California | 6047 | 3510 | 29 |
373284 | 373284 | 2020-07-27 | Mono | California | 6051 | 118 | 1 |
373285 | 373285 | 2020-07-27 | Monterey | California | 6053 | 4082 | 23 |
373286 | 373286 | 2020-07-27 | Napa | California | 6055 | 770 | 8 |
373287 | 373287 | 2020-07-27 | Nevada | California | 6057 | 273 | 1 |
373288 | 373288 | 2020-07-27 | Orange | California | 6059 | 34646 | 566 |
373289 | 373289 | 2020-07-27 | Placer | California | 6061 | 1685 | 15 |
373290 | 373290 | 2020-07-27 | Plumas | California | 6063 | 22 | 0 |
373291 | 373291 | 2020-07-27 | Riverside | California | 6065 | 35636 | 671 |
373292 | 373292 | 2020-07-27 | Sacramento | California | 6067 | 9017 | 114 |
373293 | 373293 | 2020-07-27 | San Benito | California | 6069 | 553 | 2 |
373294 | 373294 | 2020-07-27 | San Bernardino | California | 6071 | 29545 | 384 |
373295 | 373295 | 2020-07-27 | San Diego | California | 6073 | 27570 | 533 |
373296 | 373296 | 2020-07-27 | San Francisco | California | 6075 | 6025 | 56 |
373297 | 373297 | 2020-07-27 | San Joaquin | California | 6077 | 10675 | 118 |
373298 | 373298 | 2020-07-27 | San Luis Obispo | California | 6079 | 1644 | 9 |
373299 | 373299 | 2020-07-27 | San Mateo | California | 6081 | 5124 | 117 |
373300 | 373300 | 2020-07-27 | Santa Barbara | California | 6083 | 5939 | 32 |
373301 | 373301 | 2020-07-27 | Santa Clara | California | 6085 | 9215 | 185 |
373302 | 373302 | 2020-07-27 | Santa Cruz | California | 6087 | 970 | 4 |
373303 | 373303 | 2020-07-27 | Shasta | California | 6089 | 323 | 8 |
373304 | 373304 | 2020-07-27 | Sierra | California | 6091 | 1 | 0 |
373305 | 373305 | 2020-07-27 | Siskiyou | California | 6093 | 66 | 0 |
373306 | 373306 | 2020-07-27 | Solano | California | 6095 | 3288 | 36 |
373307 | 373307 | 2020-07-27 | Sonoma | California | 6097 | 2617 | 24 |
373308 | 373308 | 2020-07-27 | Stanislaus | California | 6099 | 8228 | 95 |
373309 | 373309 | 2020-07-27 | Sutter | California | 6101 | 670 | 6 |
373310 | 373310 | 2020-07-27 | Tehama | California | 6103 | 175 | 1 |
373311 | 373311 | 2020-07-27 | Trinity | California | 6105 | 4 | 0 |
373312 | 373312 | 2020-07-27 | Tulare | California | 6107 | 8534 | 172 |
373313 | 373313 | 2020-07-27 | Tuolumne | California | 6109 | 131 | 2 |
373314 | 373314 | 2020-07-27 | Ventura | California | 6111 | 6844 | 70 |
373315 | 373315 | 2020-07-27 | Yolo | California | 6113 | 1424 | 37 |
373316 | 373316 | 2020-07-27 | Yuba | California | 6115 | 397 | 3 |
Advanced export
JSON shape: default, array, newline-delimited
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);