ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58 rows where date = "2021-04-27" 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 |
---|---|---|---|---|---|---|---|
1261495 | 1261495 | 2021-04-27 | Alameda | California | 6001 | 86251 | 1486 |
1261496 | 1261496 | 2021-04-27 | Alpine | California | 6003 | 88 | 0 |
1261497 | 1261497 | 2021-04-27 | Amador | California | 6005 | 3644 | 47 |
1261498 | 1261498 | 2021-04-27 | Butte | California | 6007 | 11720 | 196 |
1261499 | 1261499 | 2021-04-27 | Calaveras | California | 6009 | 2074 | 50 |
1261500 | 1261500 | 2021-04-27 | Colusa | California | 6011 | 2213 | 16 |
1261501 | 1261501 | 2021-04-27 | Contra Costa | California | 6013 | 67746 | 789 |
1261502 | 1261502 | 2021-04-27 | Del Norte | California | 6015 | 1306 | 7 |
1261503 | 1261503 | 2021-04-27 | El Dorado | California | 6017 | 9849 | 106 |
1261504 | 1261504 | 2021-04-27 | Fresno | California | 6019 | 101099 | 1662 |
1261505 | 1261505 | 2021-04-27 | Glenn | California | 6021 | 2880 | 25 |
1261506 | 1261506 | 2021-04-27 | Humboldt | California | 6023 | 3799 | 38 |
1261507 | 1261507 | 2021-04-27 | Imperial | California | 6025 | 28148 | 719 |
1261508 | 1261508 | 2021-04-27 | Inyo | California | 6027 | 1396 | 36 |
1261509 | 1261509 | 2021-04-27 | Kern | California | 6029 | 108418 | 1345 |
1261510 | 1261510 | 2021-04-27 | Kings | California | 6031 | 22850 | 246 |
1261511 | 1261511 | 2021-04-27 | Lake | California | 6033 | 3428 | 43 |
1261512 | 1261512 | 2021-04-27 | Lassen | California | 6035 | 5685 | 24 |
1261513 | 1261513 | 2021-04-27 | Los Angeles | California | 6037 | 1232742 | 23802 |
1261514 | 1261514 | 2021-04-27 | Madera | California | 6039 | 16353 | 240 |
1261515 | 1261515 | 2021-04-27 | Marin | California | 6041 | 13849 | 227 |
1261516 | 1261516 | 2021-04-27 | Mariposa | California | 6043 | 438 | 7 |
1261517 | 1261517 | 2021-04-27 | Mendocino | California | 6045 | 4009 | 47 |
1261518 | 1261518 | 2021-04-27 | Merced | California | 6047 | 31489 | 454 |
1261519 | 1261519 | 2021-04-27 | Modoc | California | 6049 | 492 | 4 |
1261520 | 1261520 | 2021-04-27 | Mono | California | 6051 | 1258 | 4 |
1261521 | 1261521 | 2021-04-27 | Monterey | California | 6053 | 43390 | 381 |
1261522 | 1261522 | 2021-04-27 | Napa | California | 6055 | 9770 | 79 |
1261523 | 1261523 | 2021-04-27 | Nevada | California | 6057 | 4548 | 75 |
1261524 | 1261524 | 2021-04-27 | Orange | California | 6059 | 269838 | 4939 |
1261525 | 1261525 | 2021-04-27 | Placer | California | 6061 | 22120 | 286 |
1261526 | 1261526 | 2021-04-27 | Plumas | California | 6063 | 670 | 4 |
1261527 | 1261527 | 2021-04-27 | Riverside | California | 6065 | 298259 | 4563 |
1261528 | 1261528 | 2021-04-27 | Sacramento | California | 6067 | 102613 | 1659 |
1261529 | 1261529 | 2021-04-27 | San Benito | California | 6069 | 6013 | 63 |
1261530 | 1261530 | 2021-04-27 | San Bernardino | California | 6071 | 295665 | 4572 |
1261531 | 1261531 | 2021-04-27 | San Diego | California | 6073 | 275604 | 3692 |
1261532 | 1261532 | 2021-04-27 | San Francisco | California | 6075 | 36333 | 532 |
1261533 | 1261533 | 2021-04-27 | San Joaquin | California | 6077 | 72281 | 1346 |
1261534 | 1261534 | 2021-04-27 | San Luis Obispo | California | 6079 | 21138 | 260 |
1261535 | 1261535 | 2021-04-27 | San Mateo | California | 6081 | 41457 | 564 |
1261536 | 1261536 | 2021-04-27 | Santa Barbara | California | 6083 | 34099 | 448 |
1261537 | 1261537 | 2021-04-27 | Santa Clara | California | 6085 | 118036 | 2049 |
1261538 | 1261538 | 2021-04-27 | Santa Cruz | California | 6087 | 15929 | 205 |
1261539 | 1261539 | 2021-04-27 | Shasta | California | 6089 | 11830 | 220 |
1261540 | 1261540 | 2021-04-27 | Sierra | California | 6091 | 51 | 0 |
1261541 | 1261541 | 2021-04-27 | Siskiyou | California | 6093 | 2020 | 21 |
1261542 | 1261542 | 2021-04-27 | Solano | California | 6095 | 32350 | 247 |
1261543 | 1261543 | 2021-04-27 | Sonoma | California | 6097 | 29794 | 318 |
1261544 | 1261544 | 2021-04-27 | Stanislaus | California | 6099 | 61095 | 1040 |
1261545 | 1261545 | 2021-04-27 | Sutter | California | 6101 | 9328 | 110 |
1261546 | 1261546 | 2021-04-27 | Tehama | California | 6103 | 4920 | 53 |
1261547 | 1261547 | 2021-04-27 | Trinity | California | 6105 | 327 | 3 |
1261548 | 1261548 | 2021-04-27 | Tulare | California | 6107 | 49547 | 834 |
1261549 | 1261549 | 2021-04-27 | Tuolumne | California | 6109 | 4101 | 65 |
1261550 | 1261550 | 2021-04-27 | Ventura | California | 6111 | 80554 | 1007 |
1261551 | 1261551 | 2021-04-27 | Yolo | California | 6113 | 13684 | 205 |
1261552 | 1261552 | 2021-04-27 | Yuba | California | 6115 | 6165 | 44 |
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);