ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
80 rows where deaths = 70 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 24
county 24
- Amador 15
- Siskiyou 8
- Calaveras 7
- Madera 7
- Kern 6
- Shasta 6
- Marin 4
- Monterey 3
- Nevada 3
- Santa Cruz 3
- San Francisco 2
- Sonoma 2
- Sutter 2
- Yolo 2
- Alameda 1
- Fresno 1
- Merced 1
- Placer 1
- San Diego 1
- San Joaquin 1
- San Luis Obispo 1
- Santa Clara 1
- Tuolumne 1
- Ventura 1
state 1
- California · 80 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2076803 | 2076803 | 2022-01-03 | Amador | California | 6005 | 5991 | 70 |
2073552 | 2073552 | 2022-01-02 | Amador | California | 6005 | 5991 | 70 |
2070301 | 2070301 | 2022-01-01 | Amador | California | 6005 | 5991 | 70 |
2067050 | 2067050 | 2021-12-31 | Amador | California | 6005 | 5991 | 70 |
2063799 | 2063799 | 2021-12-30 | Amador | California | 6005 | 5983 | 70 |
2060549 | 2060549 | 2021-12-29 | Amador | California | 6005 | 5976 | 70 |
2057300 | 2057300 | 2021-12-28 | Amador | California | 6005 | 5967 | 70 |
2054051 | 2054051 | 2021-12-27 | Amador | California | 6005 | 5937 | 70 |
2050801 | 2050801 | 2021-12-26 | Amador | California | 6005 | 5937 | 70 |
2047551 | 2047551 | 2021-12-25 | Amador | California | 6005 | 5937 | 70 |
2044301 | 2044301 | 2021-12-24 | Amador | California | 6005 | 5937 | 70 |
2041052 | 2041052 | 2021-12-23 | Amador | California | 6005 | 5926 | 70 |
2037802 | 2037802 | 2021-12-22 | Amador | California | 6005 | 5921 | 70 |
2034552 | 2034552 | 2021-12-21 | Amador | California | 6005 | 5914 | 70 |
2031302 | 2031302 | 2021-12-20 | Amador | California | 6005 | 5908 | 70 |
1966336 | 1966336 | 2021-11-30 | Siskiyou | California | 6093 | 4920 | 70 |
1963084 | 1963084 | 2021-11-29 | Siskiyou | California | 6093 | 4907 | 70 |
1959833 | 1959833 | 2021-11-28 | Siskiyou | California | 6093 | 4864 | 70 |
1956582 | 1956582 | 2021-11-27 | Siskiyou | California | 6093 | 4864 | 70 |
1953331 | 1953331 | 2021-11-26 | Siskiyou | California | 6093 | 4864 | 70 |
1950080 | 1950080 | 2021-11-25 | Siskiyou | California | 6093 | 4864 | 70 |
1946829 | 1946829 | 2021-11-24 | Siskiyou | California | 6093 | 4864 | 70 |
1943578 | 1943578 | 2021-11-23 | Siskiyou | California | 6093 | 4857 | 70 |
1761569 | 1761569 | 2021-09-28 | Calaveras | California | 6009 | 3564 | 70 |
1758321 | 1758321 | 2021-09-27 | Calaveras | California | 6009 | 3555 | 70 |
1755073 | 1755073 | 2021-09-26 | Calaveras | California | 6009 | 3511 | 70 |
1751825 | 1751825 | 2021-09-25 | Calaveras | California | 6009 | 3511 | 70 |
1748576 | 1748576 | 2021-09-24 | Calaveras | California | 6009 | 3511 | 70 |
1745326 | 1745326 | 2021-09-23 | Calaveras | California | 6009 | 3498 | 70 |
1742077 | 1742077 | 2021-09-22 | Calaveras | California | 6009 | 3469 | 70 |
1417370 | 1417370 | 2021-06-14 | Tuolumne | California | 6109 | 4199 | 70 |
923897 | 923897 | 2021-01-13 | Nevada | California | 6057 | 3030 | 70 |
920652 | 920652 | 2021-01-12 | Nevada | California | 6057 | 3013 | 70 |
917407 | 917407 | 2021-01-11 | Nevada | California | 6057 | 2978 | 70 |
914184 | 914184 | 2021-01-10 | Sutter | California | 6101 | 7072 | 70 |
910939 | 910939 | 2021-01-09 | Sutter | California | 6101 | 7018 | 70 |
871983 | 871983 | 2020-12-28 | San Luis Obispo | California | 6079 | 10154 | 70 |
871988 | 871988 | 2020-12-28 | Shasta | California | 6089 | 7792 | 70 |
868743 | 868743 | 2020-12-27 | Shasta | California | 6089 | 7641 | 70 |
865498 | 865498 | 2020-12-26 | Shasta | California | 6089 | 7612 | 70 |
862253 | 862253 | 2020-12-25 | Shasta | California | 6089 | 7567 | 70 |
859008 | 859008 | 2020-12-24 | Shasta | California | 6089 | 7567 | 70 |
855763 | 855763 | 2020-12-23 | Shasta | California | 6089 | 7567 | 70 |
846027 | 846027 | 2020-12-20 | Santa Cruz | California | 6087 | 7054 | 70 |
842781 | 842781 | 2020-12-19 | Santa Cruz | California | 6087 | 6838 | 70 |
839536 | 839536 | 2020-12-18 | Santa Cruz | California | 6087 | 6689 | 70 |
781106 | 781106 | 2020-11-30 | Placer | California | 6061 | 6622 | 70 |
738936 | 738936 | 2020-11-17 | Yolo | California | 6113 | 3892 | 70 |
735692 | 735692 | 2020-11-16 | Yolo | California | 6113 | 3863 | 70 |
609146 | 609146 | 2020-10-08 | Madera | California | 6039 | 4739 | 70 |
605903 | 605903 | 2020-10-07 | Madera | California | 6039 | 4706 | 70 |
602661 | 602661 | 2020-10-06 | Madera | California | 6039 | 4706 | 70 |
599418 | 599418 | 2020-10-05 | Madera | California | 6039 | 4706 | 70 |
596175 | 596175 | 2020-10-04 | Madera | California | 6039 | 4642 | 70 |
592933 | 592933 | 2020-10-03 | Madera | California | 6039 | 4642 | 70 |
589693 | 589693 | 2020-10-02 | Madera | California | 6039 | 4642 | 70 |
563772 | 563772 | 2020-09-24 | Monterey | California | 6053 | 9772 | 70 |
560533 | 560533 | 2020-09-23 | Monterey | California | 6053 | 9701 | 70 |
557297 | 557297 | 2020-09-22 | Monterey | California | 6053 | 9645 | 70 |
453833 | 453833 | 2020-08-21 | Sonoma | California | 6097 | 4942 | 70 |
450605 | 450605 | 2020-08-20 | Sonoma | California | 6097 | 4863 | 70 |
444139 | 444139 | 2020-08-18 | San Francisco | California | 6075 | 8430 | 70 |
440913 | 440913 | 2020-08-17 | San Francisco | California | 6075 | 8349 | 70 |
418328 | 418328 | 2020-08-10 | Merced | California | 6047 | 5736 | 70 |
399011 | 399011 | 2020-08-04 | Marin | California | 6041 | 5180 | 70 |
395795 | 395795 | 2020-08-03 | Marin | California | 6041 | 5115 | 70 |
392579 | 392579 | 2020-08-02 | Marin | California | 6041 | 5078 | 70 |
389362 | 389362 | 2020-08-01 | Marin | California | 6041 | 5058 | 70 |
373314 | 373314 | 2020-07-27 | Ventura | California | 6111 | 6844 | 70 |
328481 | 328481 | 2020-07-13 | San Joaquin | California | 6077 | 6988 | 70 |
287275 | 287275 | 2020-06-30 | Kern | California | 6029 | 4665 | 70 |
284129 | 284129 | 2020-06-29 | Kern | California | 6029 | 4558 | 70 |
280983 | 280983 | 2020-06-28 | Kern | California | 6029 | 4488 | 70 |
277836 | 277836 | 2020-06-27 | Kern | California | 6029 | 4366 | 70 |
274688 | 274688 | 2020-06-26 | Kern | California | 6029 | 4310 | 70 |
271548 | 271548 | 2020-06-25 | Kern | California | 6029 | 4192 | 70 |
265278 | 265278 | 2020-06-23 | Fresno | California | 6019 | 3672 | 70 |
124439 | 124439 | 2020-05-08 | Alameda | California | 6001 | 1982 | 70 |
64817 | 64817 | 2020-04-17 | San Diego | California | 6073 | 2158 | 70 |
62090 | 62090 | 2020-04-16 | Santa Clara | California | 6085 | 1833 | 70 |
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);