ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
75 rows where deaths = 116 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2311021 | 2311021 | 2022-03-16 | Yuba | California | 6115 | 17534 | 116 |
2307768 | 2307768 | 2022-03-15 | Yuba | California | 6115 | 17534 | 116 |
2304517 | 2304517 | 2022-03-14 | Yuba | California | 6115 | 17534 | 116 |
2301265 | 2301265 | 2022-03-13 | Yuba | California | 6115 | 17534 | 116 |
2298013 | 2298013 | 2022-03-12 | Yuba | California | 6115 | 17534 | 116 |
2294761 | 2294761 | 2022-03-11 | Yuba | California | 6115 | 17534 | 116 |
2284953 | 2284953 | 2022-03-08 | Calaveras | California | 6009 | 7596 | 116 |
2281701 | 2281701 | 2022-03-07 | Calaveras | California | 6009 | 7590 | 116 |
2281719 | 2281719 | 2022-03-07 | Mendocino | California | 6045 | 15836 | 116 |
2278448 | 2278448 | 2022-03-06 | Calaveras | California | 6009 | 7590 | 116 |
2275195 | 2275195 | 2022-03-05 | Calaveras | California | 6009 | 7590 | 116 |
2271942 | 2271942 | 2022-03-04 | Calaveras | California | 6009 | 7590 | 116 |
2268690 | 2268690 | 2022-03-03 | Calaveras | California | 6009 | 7579 | 116 |
2265437 | 2265437 | 2022-03-02 | Calaveras | California | 6009 | 7572 | 116 |
2265490 | 2265490 | 2022-03-02 | Yuba | California | 6115 | 17427 | 116 |
2174409 | 2174409 | 2022-02-02 | Napa | California | 6055 | 23305 | 116 |
2060563 | 2060563 | 2021-12-29 | Lake | California | 6033 | 7216 | 116 |
2057314 | 2057314 | 2021-12-28 | Lake | California | 6033 | 7209 | 116 |
2054065 | 2054065 | 2021-12-27 | Lake | California | 6033 | 7191 | 116 |
2050815 | 2050815 | 2021-12-26 | Lake | California | 6033 | 7191 | 116 |
2047565 | 2047565 | 2021-12-25 | Lake | California | 6033 | 7191 | 116 |
2044315 | 2044315 | 2021-12-24 | Lake | California | 6033 | 7191 | 116 |
2041066 | 2041066 | 2021-12-23 | Lake | California | 6033 | 7180 | 116 |
2037816 | 2037816 | 2021-12-22 | Lake | California | 6033 | 7172 | 116 |
2034566 | 2034566 | 2021-12-21 | Lake | California | 6033 | 7167 | 116 |
2031316 | 2031316 | 2021-12-20 | Lake | California | 6033 | 7167 | 116 |
1891544 | 1891544 | 2021-11-07 | Humboldt | California | 6023 | 9558 | 116 |
1888294 | 1888294 | 2021-11-06 | Humboldt | California | 6023 | 9558 | 116 |
1885044 | 1885044 | 2021-11-05 | Humboldt | California | 6023 | 9558 | 116 |
1881795 | 1881795 | 2021-11-04 | Humboldt | California | 6023 | 9535 | 116 |
1878546 | 1878546 | 2021-11-03 | Humboldt | California | 6023 | 9490 | 116 |
1878586 | 1878586 | 2021-11-03 | Tehama | California | 6103 | 9915 | 116 |
1875297 | 1875297 | 2021-11-02 | Humboldt | California | 6023 | 9482 | 116 |
1875337 | 1875337 | 2021-11-02 | Tehama | California | 6103 | 9905 | 116 |
1872048 | 1872048 | 2021-11-01 | Humboldt | California | 6023 | 9472 | 116 |
1872088 | 1872088 | 2021-11-01 | Tehama | California | 6103 | 9884 | 116 |
1579652 | 1579652 | 2021-08-03 | El Dorado | California | 6017 | 12118 | 116 |
1449782 | 1449782 | 2021-06-24 | El Dorado | California | 6017 | 10395 | 116 |
1446537 | 1446537 | 2021-06-23 | El Dorado | California | 6017 | 10380 | 116 |
1443292 | 1443292 | 2021-06-22 | El Dorado | California | 6017 | 10375 | 116 |
1440047 | 1440047 | 2021-06-21 | El Dorado | California | 6017 | 10372 | 116 |
1436800 | 1436800 | 2021-06-20 | El Dorado | California | 6017 | 10363 | 116 |
1433553 | 1433553 | 2021-06-19 | El Dorado | California | 6017 | 10353 | 116 |
1430307 | 1430307 | 2021-06-18 | El Dorado | California | 6017 | 10353 | 116 |
1427062 | 1427062 | 2021-06-17 | El Dorado | California | 6017 | 10353 | 116 |
1423817 | 1423817 | 2021-06-16 | El Dorado | California | 6017 | 10351 | 116 |
1420569 | 1420569 | 2021-06-15 | El Dorado | California | 6017 | 10339 | 116 |
1417324 | 1417324 | 2021-06-14 | El Dorado | California | 6017 | 10339 | 116 |
923872 | 923872 | 2021-01-13 | Butte | California | 6007 | 8891 | 116 |
875208 | 875208 | 2020-12-29 | Madera | California | 6039 | 10172 | 116 |
871963 | 871963 | 2020-12-28 | Madera | California | 6039 | 10015 | 116 |
868718 | 868718 | 2020-12-27 | Madera | California | 6039 | 9908 | 116 |
865473 | 865473 | 2020-12-26 | Madera | California | 6039 | 9770 | 116 |
862228 | 862228 | 2020-12-25 | Madera | California | 6039 | 9547 | 116 |
858983 | 858983 | 2020-12-24 | Madera | California | 6039 | 9371 | 116 |
855738 | 855738 | 2020-12-23 | Madera | California | 6039 | 9305 | 116 |
771366 | 771366 | 2020-11-27 | Monterey | California | 6053 | 14750 | 116 |
768121 | 768121 | 2020-11-26 | Monterey | California | 6053 | 14695 | 116 |
764875 | 764875 | 2020-11-25 | Monterey | California | 6053 | 14369 | 116 |
761630 | 761630 | 2020-11-24 | Monterey | California | 6053 | 14265 | 116 |
625379 | 625379 | 2020-10-13 | Santa Barbara | California | 6083 | 9503 | 116 |
622136 | 622136 | 2020-10-12 | Santa Barbara | California | 6083 | 9475 | 116 |
618893 | 618893 | 2020-10-11 | Santa Barbara | California | 6083 | 9417 | 116 |
615651 | 615651 | 2020-10-10 | Santa Barbara | California | 6083 | 9408 | 116 |
612410 | 612410 | 2020-10-09 | Santa Barbara | California | 6083 | 9408 | 116 |
567006 | 567006 | 2020-09-25 | Marin | California | 6041 | 6694 | 116 |
495849 | 495849 | 2020-09-03 | Ventura | California | 6111 | 11031 | 116 |
492615 | 492615 | 2020-09-02 | Ventura | California | 6111 | 10899 | 116 |
489382 | 489382 | 2020-09-01 | Ventura | California | 6111 | 10866 | 116 |
486149 | 486149 | 2020-08-31 | Ventura | California | 6111 | 10775 | 116 |
382913 | 382913 | 2020-07-30 | Contra Costa | California | 6013 | 7577 | 116 |
306224 | 306224 | 2020-07-06 | Imperial | California | 6025 | 7190 | 116 |
265321 | 265321 | 2020-06-23 | Tulare | California | 6107 | 3434 | 116 |
246541 | 246541 | 2020-06-17 | Alameda | California | 6001 | 4554 | 116 |
109815 | 109815 | 2020-05-03 | Santa Clara | California | 6085 | 2231 | 116 |
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);