ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
202 rows where deaths = 14 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Marin 26
- Siskiyou 26
- Calaveras 21
- Inyo 16
- Glenn 12
- Amador 11
- Plumas 10
- Colusa 9
- Napa 9
- Shasta 7
- San Benito 6
- Imperial 5
- Sonoma 4
- Lake 3
- Orange 3
- San Joaquin 3
- Santa Barbara 3
- Tehama 3
- Yuba 3
- Butte 2
- Placer 2
- Stanislaus 2
- Tuolumne 2
- Contra Costa 1
- Del Norte 1
- Humboldt 1
- Kern 1
- Mendocino 1
- Monterey 1
- Riverside 1
- …
state 1
- California · 202 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2392333 | 2392333 | 2022-04-10 | Plumas | California | 6063 | 3247 | 14 |
2389077 | 2389077 | 2022-04-09 | Plumas | California | 6063 | 3247 | 14 |
2385822 | 2385822 | 2022-04-08 | Plumas | California | 6063 | 3247 | 14 |
2382567 | 2382567 | 2022-04-07 | Plumas | California | 6063 | 3210 | 14 |
2379312 | 2379312 | 2022-04-06 | Plumas | California | 6063 | 3210 | 14 |
2376058 | 2376058 | 2022-04-05 | Plumas | California | 6063 | 3210 | 14 |
2372806 | 2372806 | 2022-04-04 | Plumas | California | 6063 | 3163 | 14 |
2369553 | 2369553 | 2022-04-03 | Plumas | California | 6063 | 3163 | 14 |
2366300 | 2366300 | 2022-04-02 | Plumas | California | 6063 | 3163 | 14 |
2363047 | 2363047 | 2022-04-01 | Plumas | California | 6063 | 3163 | 14 |
1625133 | 1625133 | 2021-08-17 | Del Norte | California | 6015 | 2275 | 14 |
1141382 | 1141382 | 2021-03-21 | Siskiyou | California | 6093 | 1850 | 14 |
1138136 | 1138136 | 2021-03-20 | Siskiyou | California | 6093 | 1850 | 14 |
1134890 | 1134890 | 2021-03-19 | Siskiyou | California | 6093 | 1850 | 14 |
1131643 | 1131643 | 2021-03-18 | Siskiyou | California | 6093 | 1846 | 14 |
1128354 | 1128354 | 2021-03-17 | Colusa | California | 6011 | 2155 | 14 |
1128395 | 1128395 | 2021-03-17 | Siskiyou | California | 6093 | 1842 | 14 |
1125108 | 1125108 | 2021-03-16 | Colusa | California | 6011 | 2155 | 14 |
1125149 | 1125149 | 2021-03-16 | Siskiyou | California | 6093 | 1837 | 14 |
1121862 | 1121862 | 2021-03-15 | Colusa | California | 6011 | 2155 | 14 |
1121903 | 1121903 | 2021-03-15 | Siskiyou | California | 6093 | 1835 | 14 |
1118615 | 1118615 | 2021-03-14 | Colusa | California | 6011 | 2155 | 14 |
1118656 | 1118656 | 2021-03-14 | Siskiyou | California | 6093 | 1831 | 14 |
1115368 | 1115368 | 2021-03-13 | Colusa | California | 6011 | 2155 | 14 |
1115409 | 1115409 | 2021-03-13 | Siskiyou | California | 6093 | 1831 | 14 |
1112122 | 1112122 | 2021-03-12 | Colusa | California | 6011 | 2155 | 14 |
1112163 | 1112163 | 2021-03-12 | Siskiyou | California | 6093 | 1831 | 14 |
1108876 | 1108876 | 2021-03-11 | Colusa | California | 6011 | 2155 | 14 |
1108917 | 1108917 | 2021-03-11 | Siskiyou | California | 6093 | 1826 | 14 |
1105630 | 1105630 | 2021-03-10 | Colusa | California | 6011 | 2153 | 14 |
1105671 | 1105671 | 2021-03-10 | Siskiyou | California | 6093 | 1823 | 14 |
1102384 | 1102384 | 2021-03-09 | Colusa | California | 6011 | 2152 | 14 |
1102425 | 1102425 | 2021-03-09 | Siskiyou | California | 6093 | 1815 | 14 |
1099179 | 1099179 | 2021-03-08 | Siskiyou | California | 6093 | 1804 | 14 |
1095931 | 1095931 | 2021-03-07 | Siskiyou | California | 6093 | 1790 | 14 |
1092685 | 1092685 | 2021-03-06 | Siskiyou | California | 6093 | 1790 | 14 |
1089439 | 1089439 | 2021-03-05 | Siskiyou | California | 6093 | 1790 | 14 |
1086194 | 1086194 | 2021-03-04 | Siskiyou | California | 6093 | 1786 | 14 |
1082948 | 1082948 | 2021-03-03 | Siskiyou | California | 6093 | 1784 | 14 |
1079702 | 1079702 | 2021-03-02 | Siskiyou | California | 6093 | 1779 | 14 |
1076457 | 1076457 | 2021-03-01 | Siskiyou | California | 6093 | 1760 | 14 |
1073211 | 1073211 | 2021-02-28 | Siskiyou | California | 6093 | 1755 | 14 |
1069965 | 1069965 | 2021-02-27 | Siskiyou | California | 6093 | 1755 | 14 |
1066720 | 1066720 | 2021-02-26 | Siskiyou | California | 6093 | 1755 | 14 |
1063475 | 1063475 | 2021-02-25 | Siskiyou | California | 6093 | 1740 | 14 |
1060230 | 1060230 | 2021-02-24 | Siskiyou | California | 6093 | 1728 | 14 |
894673 | 894673 | 2021-01-04 | Glenn | California | 6021 | 1581 | 14 |
891426 | 891426 | 2021-01-03 | Glenn | California | 6021 | 1546 | 14 |
888179 | 888179 | 2021-01-02 | Glenn | California | 6021 | 1520 | 14 |
884934 | 884934 | 2021-01-01 | Glenn | California | 6021 | 1484 | 14 |
881689 | 881689 | 2020-12-31 | Glenn | California | 6021 | 1458 | 14 |
878444 | 878444 | 2020-12-30 | Glenn | California | 6021 | 1454 | 14 |
875199 | 875199 | 2020-12-29 | Glenn | California | 6021 | 1435 | 14 |
871954 | 871954 | 2020-12-28 | Glenn | California | 6021 | 1434 | 14 |
868709 | 868709 | 2020-12-27 | Glenn | California | 6021 | 1413 | 14 |
865464 | 865464 | 2020-12-26 | Glenn | California | 6021 | 1390 | 14 |
862219 | 862219 | 2020-12-25 | Glenn | California | 6021 | 1363 | 14 |
858974 | 858974 | 2020-12-24 | Glenn | California | 6021 | 1349 | 14 |
836305 | 836305 | 2020-12-17 | Yuba | California | 6115 | 3212 | 14 |
833013 | 833013 | 2020-12-16 | Humboldt | California | 6023 | 1357 | 14 |
833059 | 833059 | 2020-12-16 | Yuba | California | 6115 | 3122 | 14 |
829812 | 829812 | 2020-12-15 | Yuba | California | 6115 | 3058 | 14 |
807089 | 807089 | 2020-12-08 | Tuolumne | California | 6109 | 1321 | 14 |
803844 | 803844 | 2020-12-07 | Tuolumne | California | 6109 | 1260 | 14 |
758409 | 758409 | 2020-11-23 | Sutter | California | 6101 | 2948 | 14 |
693520 | 693520 | 2020-11-03 | Tehama | California | 6103 | 971 | 14 |
690277 | 690277 | 2020-11-02 | Tehama | California | 6103 | 965 | 14 |
687032 | 687032 | 2020-11-01 | Tehama | California | 6103 | 953 | 14 |
651327 | 651327 | 2020-10-21 | Napa | California | 6055 | 1914 | 14 |
651334 | 651334 | 2020-10-21 | San Benito | California | 6069 | 1411 | 14 |
648083 | 648083 | 2020-10-20 | Napa | California | 6055 | 1909 | 14 |
648090 | 648090 | 2020-10-20 | San Benito | California | 6069 | 1407 | 14 |
644838 | 644838 | 2020-10-19 | Napa | California | 6055 | 1889 | 14 |
644845 | 644845 | 2020-10-19 | San Benito | California | 6069 | 1403 | 14 |
641590 | 641590 | 2020-10-18 | Napa | California | 6055 | 1867 | 14 |
641597 | 641597 | 2020-10-18 | San Benito | California | 6069 | 1401 | 14 |
638343 | 638343 | 2020-10-17 | Napa | California | 6055 | 1856 | 14 |
638350 | 638350 | 2020-10-17 | San Benito | California | 6069 | 1401 | 14 |
635087 | 635087 | 2020-10-16 | Lake | California | 6033 | 642 | 14 |
635098 | 635098 | 2020-10-16 | Napa | California | 6055 | 1852 | 14 |
635105 | 635105 | 2020-10-16 | San Benito | California | 6069 | 1396 | 14 |
631841 | 631841 | 2020-10-15 | Lake | California | 6033 | 642 | 14 |
631852 | 631852 | 2020-10-15 | Napa | California | 6055 | 1841 | 14 |
628597 | 628597 | 2020-10-14 | Lake | California | 6033 | 639 | 14 |
628608 | 628608 | 2020-10-14 | Napa | California | 6055 | 1833 | 14 |
625365 | 625365 | 2020-10-13 | Napa | California | 6055 | 1824 | 14 |
609131 | 609131 | 2020-10-08 | Calaveras | California | 6009 | 329 | 14 |
605888 | 605888 | 2020-10-07 | Calaveras | California | 6009 | 329 | 14 |
602646 | 602646 | 2020-10-06 | Calaveras | California | 6009 | 329 | 14 |
602685 | 602685 | 2020-10-06 | Santa Cruz | California | 6087 | 2527 | 14 |
599403 | 599403 | 2020-10-05 | Calaveras | California | 6009 | 324 | 14 |
596160 | 596160 | 2020-10-04 | Calaveras | California | 6009 | 324 | 14 |
592918 | 592918 | 2020-10-03 | Calaveras | California | 6009 | 324 | 14 |
589678 | 589678 | 2020-10-02 | Calaveras | California | 6009 | 324 | 14 |
586437 | 586437 | 2020-10-01 | Calaveras | California | 6009 | 322 | 14 |
583197 | 583197 | 2020-09-30 | Calaveras | California | 6009 | 322 | 14 |
579958 | 579958 | 2020-09-29 | Calaveras | California | 6009 | 322 | 14 |
576717 | 576717 | 2020-09-28 | Calaveras | California | 6009 | 317 | 14 |
573474 | 573474 | 2020-09-27 | Calaveras | California | 6009 | 317 | 14 |
570232 | 570232 | 2020-09-26 | Calaveras | California | 6009 | 317 | 14 |
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);