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 2021-02-13 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1024480 | 1024480 | 2021-02-13 | Alameda | California | 6001 | 78306 | 1120 |
1024481 | 1024481 | 2021-02-13 | Alpine | California | 6003 | 76 | 0 |
1024482 | 1024482 | 2021-02-13 | Amador | California | 6005 | 3380 | 38 |
1024483 | 1024483 | 2021-02-13 | Butte | California | 6007 | 10655 | 149 |
1024484 | 1024484 | 2021-02-13 | Calaveras | California | 6009 | 1860 | 25 |
1024485 | 1024485 | 2021-02-13 | Colusa | California | 6011 | 2069 | 11 |
1024486 | 1024486 | 2021-02-13 | Contra Costa | California | 6013 | 60365 | 620 |
1024487 | 1024487 | 2021-02-13 | Del Norte | California | 6015 | 929 | 4 |
1024488 | 1024488 | 2021-02-13 | El Dorado | California | 6017 | 8725 | 90 |
1024489 | 1024489 | 2021-02-13 | Fresno | California | 6019 | 92520 | 1291 |
1024490 | 1024490 | 2021-02-13 | Glenn | California | 6021 | 2615 | 23 |
1024491 | 1024491 | 2021-02-13 | Humboldt | California | 6023 | 3009 | 32 |
1024492 | 1024492 | 2021-02-13 | Imperial | California | 6025 | 26646 | 583 |
1024493 | 1024493 | 2021-02-13 | Inyo | California | 6027 | 1156 | 34 |
1024494 | 1024494 | 2021-02-13 | Kern | California | 6029 | 100025 | 687 |
1024495 | 1024495 | 2021-02-13 | Kings | California | 6031 | 21585 | 208 |
1024496 | 1024496 | 2021-02-13 | Lake | California | 6033 | 3012 | 37 |
1024497 | 1024497 | 2021-02-13 | Lassen | California | 6035 | 5498 | 19 |
1024498 | 1024498 | 2021-02-13 | Los Angeles | California | 6037 | 1165294 | 18984 |
1024499 | 1024499 | 2021-02-13 | Madera | California | 6039 | 15022 | 189 |
1024500 | 1024500 | 2021-02-13 | Marin | California | 6041 | 12720 | 184 |
1024501 | 1024501 | 2021-02-13 | Mariposa | California | 6043 | 386 | 5 |
1024502 | 1024502 | 2021-02-13 | Mendocino | California | 6045 | 3701 | 40 |
1024503 | 1024503 | 2021-02-13 | Merced | California | 6047 | 27701 | 375 |
1024504 | 1024504 | 2021-02-13 | Modoc | California | 6049 | 441 | 4 |
1024505 | 1024505 | 2021-02-13 | Mono | California | 6051 | 1172 | 4 |
1024506 | 1024506 | 2021-02-13 | Monterey | California | 6053 | 41341 | 307 |
1024507 | 1024507 | 2021-02-13 | Napa | California | 6055 | 8786 | 62 |
1024508 | 1024508 | 2021-02-13 | Nevada | California | 6057 | 3729 | 74 |
1024509 | 1024509 | 2021-02-13 | Orange | California | 6059 | 256510 | 3544 |
1024510 | 1024510 | 2021-02-13 | Placer | California | 6061 | 19175 | 222 |
1024511 | 1024511 | 2021-02-13 | Plumas | California | 6063 | 614 | 6 |
1024512 | 1024512 | 2021-02-13 | Riverside | California | 6065 | 285414 | 3524 |
1024513 | 1024513 | 2021-02-13 | Sacramento | California | 6067 | 90251 | 1372 |
1024514 | 1024514 | 2021-02-13 | San Benito | California | 6069 | 5622 | 57 |
1024515 | 1024515 | 2021-02-13 | San Bernardino | California | 6071 | 281604 | 2352 |
1024516 | 1024516 | 2021-02-13 | San Diego | California | 6073 | 251745 | 3009 |
1024517 | 1024517 | 2021-02-13 | San Francisco | California | 6075 | 33182 | 366 |
1024518 | 1024518 | 2021-02-13 | San Joaquin | California | 6077 | 64969 | 992 |
1024519 | 1024519 | 2021-02-13 | San Luis Obispo | California | 6079 | 18889 | 205 |
1024520 | 1024520 | 2021-02-13 | San Mateo | California | 6081 | 37621 | 474 |
1024521 | 1024521 | 2021-02-13 | Santa Barbara | California | 6083 | 30728 | 372 |
1024522 | 1024522 | 2021-02-13 | Santa Clara | California | 6085 | 107110 | 1662 |
1024523 | 1024523 | 2021-02-13 | Santa Cruz | California | 6087 | 14232 | 168 |
1024524 | 1024524 | 2021-02-13 | Shasta | California | 6089 | 10718 | 170 |
1024525 | 1024525 | 2021-02-13 | Sierra | California | 6091 | 45 | 0 |
1024526 | 1024526 | 2021-02-13 | Siskiyou | California | 6093 | 1664 | 13 |
1024527 | 1024527 | 2021-02-13 | Solano | California | 6095 | 29256 | 140 |
1024528 | 1024528 | 2021-02-13 | Sonoma | California | 6097 | 27143 | 287 |
1024529 | 1024529 | 2021-02-13 | Stanislaus | California | 6099 | 54025 | 899 |
1024530 | 1024530 | 2021-02-13 | Sutter | California | 6101 | 8656 | 93 |
1024531 | 1024531 | 2021-02-13 | Tehama | California | 6103 | 4470 | 51 |
1024532 | 1024532 | 2021-02-13 | Trinity | California | 6105 | 270 | 5 |
1024533 | 1024533 | 2021-02-13 | Tulare | California | 6107 | 46016 | 691 |
1024534 | 1024534 | 2021-02-13 | Tuolumne | California | 6109 | 3800 | 52 |
1024535 | 1024535 | 2021-02-13 | Ventura | California | 6111 | 75210 | 732 |
1024536 | 1024536 | 2021-02-13 | Yolo | California | 6113 | 12340 | 172 |
1024537 | 1024537 | 2021-02-13 | Yuba | California | 6115 | 5583 | 36 |
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);