ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-07-17" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1524437 | 1524437 | 2021-07-17 | Alameda | California | 6001 | 93498 | 1271 |
1524438 | 1524438 | 2021-07-17 | Alpine | California | 6003 | 89 | 0 |
1524439 | 1524439 | 2021-07-17 | Amador | California | 6005 | 3819 | 48 |
1524440 | 1524440 | 2021-07-17 | Butte | California | 6007 | 14804 | 202 |
1524441 | 1524441 | 2021-07-17 | Calaveras | California | 6009 | 2253 | 58 |
1524442 | 1524442 | 2021-07-17 | Colusa | California | 6011 | 2322 | 18 |
1524443 | 1524443 | 2021-07-17 | Contra Costa | California | 6013 | 73679 | 824 |
1524444 | 1524444 | 2021-07-17 | Del Norte | California | 6015 | 1522 | 8 |
1524445 | 1524445 | 2021-07-17 | El Dorado | California | 6017 | 11442 | 118 |
1524446 | 1524446 | 2021-07-17 | Fresno | California | 6019 | 112322 | 1730 |
1524447 | 1524447 | 2021-07-17 | Glenn | California | 6021 | 3042 | 27 |
1524448 | 1524448 | 2021-07-17 | Humboldt | California | 6023 | 4791 | 53 |
1524449 | 1524449 | 2021-07-17 | Imperial | California | 6025 | 31787 | 741 |
1524450 | 1524450 | 2021-07-17 | Inyo | California | 6027 | 1444 | 38 |
1524451 | 1524451 | 2021-07-17 | Kern | California | 6029 | 111687 | 1414 |
1524452 | 1524452 | 2021-07-17 | Kings | California | 6031 | 24385 | 248 |
1524453 | 1524453 | 2021-07-17 | Lake | California | 6033 | 3774 | 64 |
1524454 | 1524454 | 2021-07-17 | Lassen | California | 6035 | 5858 | 26 |
1524455 | 1524455 | 2021-07-17 | Los Angeles | California | 6037 | 1266908 | 24582 |
1524456 | 1524456 | 2021-07-17 | Madera | California | 6039 | 17783 | 248 |
1524457 | 1524457 | 2021-07-17 | Marin | California | 6041 | 14567 | 234 |
1524458 | 1524458 | 2021-07-17 | Mariposa | California | 6043 | 472 | 7 |
1524459 | 1524459 | 2021-07-17 | Mendocino | California | 6045 | 4502 | 50 |
1524460 | 1524460 | 2021-07-17 | Merced | California | 6047 | 32621 | 483 |
1524461 | 1524461 | 2021-07-17 | Modoc | California | 6049 | 573 | 7 |
1524462 | 1524462 | 2021-07-17 | Mono | California | 6051 | 1304 | 5 |
1524463 | 1524463 | 2021-07-17 | Monterey | California | 6053 | 45324 | 518 |
1524464 | 1524464 | 2021-07-17 | Napa | California | 6055 | 10158 | 81 |
1524465 | 1524465 | 2021-07-17 | Nevada | California | 6057 | 5269 | 75 |
1524466 | 1524466 | 2021-07-17 | Orange | California | 6059 | 275358 | 5136 |
1524467 | 1524467 | 2021-07-17 | Placer | California | 6061 | 25827 | 304 |
1524468 | 1524468 | 2021-07-17 | Plumas | California | 6063 | 742 | 6 |
1524469 | 1524469 | 2021-07-17 | Riverside | California | 6065 | 309823 | 4647 |
1524470 | 1524470 | 2021-07-17 | Sacramento | California | 6067 | 112421 | 1759 |
1524471 | 1524471 | 2021-07-17 | San Benito | California | 6069 | 6301 | 63 |
1524472 | 1524472 | 2021-07-17 | San Bernardino | California | 6071 | 305351 | 5218 |
1524473 | 1524473 | 2021-07-17 | San Diego | California | 6073 | 301517 | 3786 |
1524474 | 1524474 | 2021-07-17 | San Francisco | California | 6075 | 39411 | 560 |
1524475 | 1524475 | 2021-07-17 | San Joaquin | California | 6077 | 78564 | 1446 |
1524476 | 1524476 | 2021-07-17 | San Luis Obispo | California | 6079 | 22262 | 264 |
1524477 | 1524477 | 2021-07-17 | San Mateo | California | 6081 | 43819 | 584 |
1524478 | 1524478 | 2021-07-17 | Santa Barbara | California | 6083 | 36141 | 461 |
1524479 | 1524479 | 2021-07-17 | Santa Clara | California | 6085 | 120817 | 2098 |
1524480 | 1524480 | 2021-07-17 | Santa Cruz | California | 6087 | 17217 | 207 |
1524481 | 1524481 | 2021-07-17 | Shasta | California | 6089 | 14533 | 242 |
1524482 | 1524482 | 2021-07-17 | Sierra | California | 6091 | 76 | 0 |
1524483 | 1524483 | 2021-07-17 | Siskiyou | California | 6093 | 2478 | 40 |
1524484 | 1524484 | 2021-07-17 | Solano | California | 6095 | 34635 | 263 |
1524485 | 1524485 | 2021-07-17 | Sonoma | California | 6097 | 31917 | 327 |
1524486 | 1524486 | 2021-07-17 | Stanislaus | California | 6099 | 64381 | 1082 |
1524487 | 1524487 | 2021-07-17 | Sutter | California | 6101 | 9871 | 114 |
1524488 | 1524488 | 2021-07-17 | Tehama | California | 6103 | 5790 | 64 |
1524489 | 1524489 | 2021-07-17 | Trinity | California | 6105 | 400 | 3 |
1524490 | 1524490 | 2021-07-17 | Tulare | California | 6107 | 59483 | 854 |
1524491 | 1524491 | 2021-07-17 | Tuolumne | California | 6109 | 4322 | 73 |
1524492 | 1524492 | 2021-07-17 | Ventura | California | 6111 | 85414 | 1041 |
1524493 | 1524493 | 2021-07-17 | Yolo | California | 6113 | 14734 | 213 |
1524494 | 1524494 | 2021-07-17 | Yuba | California | 6115 | 6691 | 52 |
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);