ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where "date" is on date 2020-09-14 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531374 | 531374 | 2020-09-14 | Alameda | California | 6001 | 20043 | 332 |
531375 | 531375 | 2020-09-14 | Alpine | California | 6003 | 2 | 0 |
531376 | 531376 | 2020-09-14 | Amador | California | 6005 | 278 | 16 |
531377 | 531377 | 2020-09-14 | Butte | California | 6007 | 2640 | 28 |
531378 | 531378 | 2020-09-14 | Calaveras | California | 6009 | 298 | 10 |
531379 | 531379 | 2020-09-14 | Colusa | California | 6011 | 496 | 6 |
531380 | 531380 | 2020-09-14 | Contra Costa | California | 6013 | 15424 | 192 |
531381 | 531381 | 2020-09-14 | Del Norte | California | 6015 | 133 | 1 |
531382 | 531382 | 2020-09-14 | El Dorado | California | 6017 | 1046 | 3 |
531383 | 531383 | 2020-09-14 | Fresno | California | 6019 | 27196 | 337 |
531384 | 531384 | 2020-09-14 | Glenn | California | 6021 | 517 | 3 |
531385 | 531385 | 2020-09-14 | Humboldt | California | 6023 | 473 | 6 |
531386 | 531386 | 2020-09-14 | Imperial | California | 6025 | 11291 | 307 |
531387 | 531387 | 2020-09-14 | Inyo | California | 6027 | 176 | 14 |
531388 | 531388 | 2020-09-14 | Kern | California | 6029 | 30850 | 332 |
531389 | 531389 | 2020-09-14 | Kings | California | 6031 | 7125 | 77 |
531390 | 531390 | 2020-09-14 | Lake | California | 6033 | 397 | 7 |
531391 | 531391 | 2020-09-14 | Lassen | California | 6035 | 727 | 0 |
531392 | 531392 | 2020-09-14 | Los Angeles | California | 6037 | 254656 | 6231 |
531393 | 531393 | 2020-09-14 | Madera | California | 6039 | 4226 | 58 |
531394 | 531394 | 2020-09-14 | Marin | California | 6041 | 6470 | 99 |
531395 | 531395 | 2020-09-14 | Mariposa | California | 6043 | 75 | 2 |
531396 | 531396 | 2020-09-14 | Mendocino | California | 6045 | 802 | 18 |
531397 | 531397 | 2020-09-14 | Merced | California | 6047 | 8616 | 129 |
531398 | 531398 | 2020-09-14 | Modoc | California | 6049 | 22 | 0 |
531399 | 531399 | 2020-09-14 | Mono | California | 6051 | 163 | 2 |
531400 | 531400 | 2020-09-14 | Monterey | California | 6053 | 9011 | 64 |
531401 | 531401 | 2020-09-14 | Napa | California | 6055 | 1564 | 13 |
531402 | 531402 | 2020-09-14 | Nevada | California | 6057 | 494 | 5 |
531403 | 531403 | 2020-09-14 | Orange | California | 6059 | 52166 | 1093 |
531404 | 531404 | 2020-09-14 | Placer | California | 6061 | 3325 | 39 |
531405 | 531405 | 2020-09-14 | Plumas | California | 6063 | 42 | 0 |
531406 | 531406 | 2020-09-14 | Riverside | California | 6065 | 55766 | 1118 |
531407 | 531407 | 2020-09-14 | Sacramento | California | 6067 | 20434 | 356 |
531408 | 531408 | 2020-09-14 | San Benito | California | 6069 | 1240 | 10 |
531409 | 531409 | 2020-09-14 | San Bernardino | California | 6071 | 50709 | 832 |
531410 | 531410 | 2020-09-14 | San Diego | California | 6073 | 42950 | 734 |
531411 | 531411 | 2020-09-14 | San Francisco | California | 6075 | 10381 | 91 |
531412 | 531412 | 2020-09-14 | San Joaquin | California | 6077 | 19364 | 389 |
531413 | 531413 | 2020-09-14 | San Luis Obispo | California | 6079 | 3278 | 26 |
531414 | 531414 | 2020-09-14 | San Mateo | California | 6081 | 9166 | 139 |
531415 | 531415 | 2020-09-14 | Santa Barbara | California | 6083 | 8718 | 106 |
531416 | 531416 | 2020-09-14 | Santa Clara | California | 6085 | 19613 | 284 |
531417 | 531417 | 2020-09-14 | Santa Cruz | California | 6087 | 2065 | 7 |
531418 | 531418 | 2020-09-14 | Shasta | California | 6089 | 612 | 12 |
531419 | 531419 | 2020-09-14 | Sierra | California | 6091 | 6 | 0 |
531420 | 531420 | 2020-09-14 | Siskiyou | California | 6093 | 156 | 0 |
531421 | 531421 | 2020-09-14 | Solano | California | 6095 | 5942 | 50 |
531422 | 531422 | 2020-09-14 | Sonoma | California | 6097 | 6738 | 110 |
531423 | 531423 | 2020-09-14 | Stanislaus | California | 6099 | 15976 | 310 |
531424 | 531424 | 2020-09-14 | Sutter | California | 6101 | 1599 | 10 |
531425 | 531425 | 2020-09-14 | Tehama | California | 6103 | 476 | 1 |
531426 | 531426 | 2020-09-14 | Trinity | California | 6105 | 15 | 0 |
531427 | 531427 | 2020-09-14 | Tulare | California | 6107 | 15270 | 251 |
531428 | 531428 | 2020-09-14 | Tuolumne | California | 6109 | 216 | 3 |
531429 | 531429 | 2020-09-14 | Ventura | California | 6111 | 11855 | 135 |
531430 | 531430 | 2020-09-14 | Yolo | California | 6113 | 2689 | 53 |
531431 | 531431 | 2020-09-14 | Yuba | California | 6115 | 1085 | 7 |
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);