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-12-22 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
852474 | 852474 | 2020-12-22 | Alameda | California | 6001 | 44777 | 609 |
852475 | 852475 | 2020-12-22 | Alpine | California | 6003 | 64 | 0 |
852476 | 852476 | 2020-12-22 | Amador | California | 6005 | 1814 | 23 |
852477 | 852477 | 2020-12-22 | Butte | California | 6007 | 6473 | 83 |
852478 | 852478 | 2020-12-22 | Calaveras | California | 6009 | 963 | 22 |
852479 | 852479 | 2020-12-22 | Colusa | California | 6011 | 1187 | 8 |
852480 | 852480 | 2020-12-22 | Contra Costa | California | 6013 | 35788 | 298 |
852481 | 852481 | 2020-12-22 | Del Norte | California | 6015 | 660 | 2 |
852482 | 852482 | 2020-12-22 | El Dorado | California | 6017 | 4805 | 10 |
852483 | 852483 | 2020-12-22 | Fresno | California | 6019 | 58568 | 617 |
852484 | 852484 | 2020-12-22 | Glenn | California | 6021 | 1323 | 12 |
852485 | 852485 | 2020-12-22 | Humboldt | California | 6023 | 1512 | 16 |
852486 | 852486 | 2020-12-22 | Imperial | California | 6025 | 20994 | 399 |
852487 | 852487 | 2020-12-22 | Inyo | California | 6027 | 482 | 19 |
852488 | 852488 | 2020-12-22 | Kern | California | 6029 | 60260 | 482 |
852489 | 852489 | 2020-12-22 | Kings | California | 6031 | 14883 | 105 |
852490 | 852490 | 2020-12-22 | Lake | California | 6033 | 1538 | 22 |
852491 | 852491 | 2020-12-22 | Lassen | California | 6035 | 4156 | 8 |
852492 | 852492 | 2020-12-22 | Los Angeles | California | 6037 | 647766 | 9016 |
852493 | 852493 | 2020-12-22 | Madera | California | 6039 | 9150 | 111 |
852494 | 852494 | 2020-12-22 | Marin | California | 6041 | 9205 | 136 |
852495 | 852495 | 2020-12-22 | Mariposa | California | 6043 | 205 | 4 |
852496 | 852496 | 2020-12-22 | Mendocino | California | 6045 | 2292 | 25 |
852497 | 852497 | 2020-12-22 | Merced | California | 6047 | 17111 | 225 |
852498 | 852498 | 2020-12-22 | Modoc | California | 6049 | 292 | 0 |
852499 | 852499 | 2020-12-22 | Mono | California | 6051 | 781 | 4 |
852500 | 852500 | 2020-12-22 | Monterey | California | 6053 | 23827 | 180 |
852501 | 852501 | 2020-12-22 | Napa | California | 6055 | 4966 | 25 |
852502 | 852502 | 2020-12-22 | Nevada | California | 6057 | 2361 | 42 |
852503 | 852503 | 2020-12-22 | Orange | California | 6059 | 132772 | 1779 |
852504 | 852504 | 2020-12-22 | Placer | California | 6061 | 11761 | 109 |
852505 | 852505 | 2020-12-22 | Plumas | California | 6063 | 353 | 0 |
852506 | 852506 | 2020-12-22 | Riverside | California | 6065 | 151713 | 1789 |
852507 | 852507 | 2020-12-22 | Sacramento | California | 6067 | 58000 | 786 |
852508 | 852508 | 2020-12-22 | San Benito | California | 6069 | 3074 | 24 |
852509 | 852509 | 2020-12-22 | San Bernardino | California | 6071 | 168307 | 1387 |
852510 | 852510 | 2020-12-22 | San Diego | California | 6073 | 132161 | 1311 |
852511 | 852511 | 2020-12-22 | San Francisco | California | 6075 | 21089 | 176 |
852512 | 852512 | 2020-12-22 | San Joaquin | California | 6077 | 39304 | 592 |
852513 | 852513 | 2020-12-22 | San Luis Obispo | California | 6079 | 9061 | 65 |
852514 | 852514 | 2020-12-22 | San Mateo | California | 6081 | 21558 | 203 |
852515 | 852515 | 2020-12-22 | Santa Barbara | California | 6083 | 15198 | 150 |
852516 | 852516 | 2020-12-22 | Santa Clara | California | 6085 | 58637 | 616 |
852517 | 852517 | 2020-12-22 | Santa Cruz | California | 6087 | 7315 | 73 |
852518 | 852518 | 2020-12-22 | Shasta | California | 6089 | 7299 | 68 |
852519 | 852519 | 2020-12-22 | Sierra | California | 6091 | 23 | 0 |
852520 | 852520 | 2020-12-22 | Siskiyou | California | 6093 | 1067 | 8 |
852521 | 852521 | 2020-12-22 | Solano | California | 6095 | 16573 | 94 |
852522 | 852522 | 2020-12-22 | Sonoma | California | 6097 | 17075 | 177 |
852523 | 852523 | 2020-12-22 | Stanislaus | California | 6099 | 33730 | 544 |
852524 | 852524 | 2020-12-22 | Sutter | California | 6101 | 5863 | 46 |
852525 | 852525 | 2020-12-22 | Tehama | California | 6103 | 2656 | 32 |
852526 | 852526 | 2020-12-22 | Trinity | California | 6105 | 227 | 2 |
852527 | 852527 | 2020-12-22 | Tulare | California | 6107 | 30051 | 360 |
852528 | 852528 | 2020-12-22 | Tuolumne | California | 6109 | 2569 | 20 |
852529 | 852529 | 2020-12-22 | Ventura | California | 6111 | 32144 | 216 |
852530 | 852530 | 2020-12-22 | Yolo | California | 6113 | 7266 | 108 |
852531 | 852531 | 2020-12-22 | Yuba | California | 6115 | 3492 | 16 |
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);