ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
88 rows where deaths = 55 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 22
county 22
- Glenn 24
- Yolo 10
- Yuba 10
- Calaveras 7
- San Benito 5
- San Joaquin 5
- Solano 5
- Kern 3
- Madera 2
- Monterey 2
- Placer 2
- Sacramento 2
- Tuolumne 2
- Contra Costa 1
- Fresno 1
- Humboldt 1
- Mendocino 1
- Napa 1
- San Bernardino 1
- San Francisco 1
- Santa Cruz 1
- Siskiyou 1
state 1
- California · 88 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2167886 | 2167886 | 2022-01-31 | Glenn | California | 6021 | 5986 | 55 |
2164631 | 2164631 | 2022-01-30 | Glenn | California | 6021 | 5883 | 55 |
2161376 | 2161376 | 2022-01-29 | Glenn | California | 6021 | 5883 | 55 |
2158120 | 2158120 | 2022-01-28 | Glenn | California | 6021 | 5883 | 55 |
2154867 | 2154867 | 2022-01-27 | Glenn | California | 6021 | 5839 | 55 |
2151614 | 2151614 | 2022-01-26 | Glenn | California | 6021 | 5714 | 55 |
2148362 | 2148362 | 2022-01-25 | Glenn | California | 6021 | 5663 | 55 |
2145110 | 2145110 | 2022-01-24 | Glenn | California | 6021 | 5636 | 55 |
2141855 | 2141855 | 2022-01-23 | Glenn | California | 6021 | 5470 | 55 |
2138600 | 2138600 | 2022-01-22 | Glenn | California | 6021 | 5470 | 55 |
2135344 | 2135344 | 2022-01-21 | Glenn | California | 6021 | 5470 | 55 |
2132092 | 2132092 | 2022-01-20 | Glenn | California | 6021 | 5423 | 55 |
2128839 | 2128839 | 2022-01-19 | Glenn | California | 6021 | 5244 | 55 |
2125585 | 2125585 | 2022-01-18 | Glenn | California | 6021 | 5229 | 55 |
2122333 | 2122333 | 2022-01-17 | Glenn | California | 6021 | 5223 | 55 |
2119081 | 2119081 | 2022-01-16 | Glenn | California | 6021 | 5080 | 55 |
2115829 | 2115829 | 2022-01-15 | Glenn | California | 6021 | 5080 | 55 |
2112578 | 2112578 | 2022-01-14 | Glenn | California | 6021 | 5080 | 55 |
2109326 | 2109326 | 2022-01-13 | Glenn | California | 6021 | 5033 | 55 |
2106075 | 2106075 | 2022-01-12 | Glenn | California | 6021 | 4966 | 55 |
2102824 | 2102824 | 2022-01-11 | Glenn | California | 6021 | 4929 | 55 |
2099573 | 2099573 | 2022-01-10 | Glenn | California | 6021 | 4919 | 55 |
2096322 | 2096322 | 2022-01-09 | Glenn | California | 6021 | 4854 | 55 |
2093070 | 2093070 | 2022-01-08 | Glenn | California | 6021 | 4854 | 55 |
1781108 | 1781108 | 2021-10-04 | Siskiyou | California | 6093 | 4430 | 55 |
1703148 | 1703148 | 2021-09-10 | Yuba | California | 6115 | 9222 | 55 |
1699898 | 1699898 | 2021-09-09 | Yuba | California | 6115 | 9222 | 55 |
1696649 | 1696649 | 2021-09-08 | Yuba | California | 6115 | 9051 | 55 |
1693401 | 1693401 | 2021-09-07 | Yuba | California | 6115 | 8905 | 55 |
1690152 | 1690152 | 2021-09-06 | Yuba | California | 6115 | 8905 | 55 |
1686902 | 1686902 | 2021-09-05 | Yuba | California | 6115 | 8905 | 55 |
1683652 | 1683652 | 2021-09-04 | Yuba | California | 6115 | 8865 | 55 |
1680401 | 1680401 | 2021-09-03 | Yuba | California | 6115 | 8865 | 55 |
1677153 | 1677153 | 2021-09-02 | Yuba | California | 6115 | 8865 | 55 |
1664164 | 1664164 | 2021-08-29 | Yuba | California | 6115 | 8417 | 55 |
1625148 | 1625148 | 2021-08-17 | Mendocino | California | 6045 | 5332 | 55 |
1586155 | 1586155 | 2021-08-05 | Humboldt | California | 6023 | 5447 | 55 |
1352408 | 1352408 | 2021-05-25 | Calaveras | California | 6009 | 2151 | 55 |
1349162 | 1349162 | 2021-05-24 | Calaveras | California | 6009 | 2151 | 55 |
1345915 | 1345915 | 2021-05-23 | Calaveras | California | 6009 | 2148 | 55 |
1342667 | 1342667 | 2021-05-22 | Calaveras | California | 6009 | 2148 | 55 |
1339419 | 1339419 | 2021-05-21 | Calaveras | California | 6009 | 2148 | 55 |
1336172 | 1336172 | 2021-05-20 | Calaveras | California | 6009 | 2145 | 55 |
1332925 | 1332925 | 2021-05-19 | Calaveras | California | 6009 | 2145 | 55 |
1037517 | 1037517 | 2021-02-17 | Tuolumne | California | 6109 | 3857 | 55 |
1034272 | 1034272 | 2021-02-16 | Tuolumne | California | 6109 | 3853 | 55 |
1008288 | 1008288 | 2021-02-08 | San Benito | California | 6069 | 5548 | 55 |
1005042 | 1005042 | 2021-02-07 | San Benito | California | 6069 | 5516 | 55 |
1001796 | 1001796 | 2021-02-06 | San Benito | California | 6069 | 5502 | 55 |
998550 | 998550 | 2021-02-05 | San Benito | California | 6069 | 5488 | 55 |
995304 | 995304 | 2021-02-04 | San Benito | California | 6069 | 5463 | 55 |
988805 | 988805 | 2021-02-02 | Napa | California | 6055 | 8450 | 55 |
826552 | 826552 | 2020-12-14 | Santa Cruz | California | 6087 | 6003 | 55 |
651330 | 651330 | 2020-10-21 | Placer | California | 6061 | 4023 | 55 |
648086 | 648086 | 2020-10-20 | Placer | California | 6061 | 4012 | 55 |
589730 | 589730 | 2020-10-02 | Yolo | California | 6113 | 2847 | 55 |
586489 | 586489 | 2020-10-01 | Yolo | California | 6113 | 2836 | 55 |
583249 | 583249 | 2020-09-30 | Yolo | California | 6113 | 2828 | 55 |
580010 | 580010 | 2020-09-29 | Yolo | California | 6113 | 2825 | 55 |
576769 | 576769 | 2020-09-28 | Yolo | California | 6113 | 2815 | 55 |
573526 | 573526 | 2020-09-27 | Yolo | California | 6113 | 2803 | 55 |
570284 | 570284 | 2020-09-26 | Yolo | California | 6113 | 2795 | 55 |
567042 | 567042 | 2020-09-25 | Yolo | California | 6113 | 2789 | 55 |
563802 | 563802 | 2020-09-24 | Yolo | California | 6113 | 2782 | 55 |
560563 | 560563 | 2020-09-23 | Yolo | California | 6113 | 2773 | 55 |
554081 | 554081 | 2020-09-21 | Solano | California | 6095 | 6180 | 55 |
550842 | 550842 | 2020-09-20 | Solano | California | 6095 | 6090 | 55 |
547603 | 547603 | 2020-09-19 | Solano | California | 6095 | 6090 | 55 |
544365 | 544365 | 2020-09-18 | Solano | California | 6095 | 6090 | 55 |
541129 | 541129 | 2020-09-17 | Solano | California | 6095 | 6059 | 55 |
492579 | 492579 | 2020-09-02 | Madera | California | 6039 | 3876 | 55 |
489346 | 489346 | 2020-09-01 | Madera | California | 6039 | 3836 | 55 |
479651 | 479651 | 2020-08-29 | Monterey | California | 6053 | 7685 | 55 |
476418 | 476418 | 2020-08-28 | Monterey | California | 6053 | 7619 | 55 |
360460 | 360460 | 2020-07-23 | San Francisco | California | 6075 | 5567 | 55 |
306249 | 306249 | 2020-07-06 | San Joaquin | California | 6077 | 5015 | 55 |
303085 | 303085 | 2020-07-05 | San Joaquin | California | 6077 | 4807 | 55 |
299921 | 299921 | 2020-07-04 | San Joaquin | California | 6077 | 4474 | 55 |
296759 | 296759 | 2020-07-03 | San Joaquin | California | 6077 | 4474 | 55 |
293603 | 293603 | 2020-07-02 | San Joaquin | California | 6077 | 4298 | 55 |
249659 | 249659 | 2020-06-18 | Contra Costa | California | 6013 | 2111 | 55 |
240326 | 240326 | 2020-06-15 | Fresno | California | 6019 | 2706 | 55 |
240331 | 240331 | 2020-06-15 | Kern | California | 6029 | 3377 | 55 |
237223 | 237223 | 2020-06-14 | Kern | California | 6029 | 3291 | 55 |
234116 | 234116 | 2020-06-13 | Kern | California | 6029 | 3205 | 55 |
151424 | 151424 | 2020-05-17 | Sacramento | California | 6067 | 1236 | 55 |
148415 | 148415 | 2020-05-16 | Sacramento | California | 6067 | 1221 | 55 |
64816 | 64816 | 2020-04-17 | San Bernardino | California | 6071 | 1096 | 55 |
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);