ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
287 rows where deaths = 11 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Modoc 48
- Trinity 35
- Placer 25
- San Benito 17
- Santa Barbara 16
- Colusa 14
- Lake 14
- Merced 13
- Sutter 12
- Shasta 10
- Glenn 8
- Napa 8
- Siskiyou 8
- Yuba 8
- Amador 6
- Monterey 5
- Imperial 4
- Inyo 4
- Madera 4
- San Joaquin 4
- Contra Costa 3
- Lassen 3
- Sonoma 3
- Tulare 3
- Kern 2
- Marin 2
- Santa Clara 2
- Tuolumne 2
- Los Angeles 1
- San Luis Obispo 1
- …
state 1
- California · 287 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2171153 | 2171153 | 2022-02-01 | Modoc | California | 6049 | 1485 | 11 |
2167900 | 2167900 | 2022-01-31 | Modoc | California | 6049 | 1485 | 11 |
2164645 | 2164645 | 2022-01-30 | Modoc | California | 6049 | 1485 | 11 |
2161390 | 2161390 | 2022-01-29 | Modoc | California | 6049 | 1485 | 11 |
2158134 | 2158134 | 2022-01-28 | Modoc | California | 6049 | 1485 | 11 |
2154881 | 2154881 | 2022-01-27 | Modoc | California | 6049 | 1466 | 11 |
2151628 | 2151628 | 2022-01-26 | Modoc | California | 6049 | 1427 | 11 |
2148376 | 2148376 | 2022-01-25 | Modoc | California | 6049 | 1410 | 11 |
2145124 | 2145124 | 2022-01-24 | Modoc | California | 6049 | 1349 | 11 |
2141869 | 2141869 | 2022-01-23 | Modoc | California | 6049 | 1349 | 11 |
2138614 | 2138614 | 2022-01-22 | Modoc | California | 6049 | 1349 | 11 |
2135358 | 2135358 | 2022-01-21 | Modoc | California | 6049 | 1349 | 11 |
2132106 | 2132106 | 2022-01-20 | Modoc | California | 6049 | 1299 | 11 |
2128853 | 2128853 | 2022-01-19 | Modoc | California | 6049 | 1282 | 11 |
2125599 | 2125599 | 2022-01-18 | Modoc | California | 6049 | 1210 | 11 |
2122347 | 2122347 | 2022-01-17 | Modoc | California | 6049 | 1210 | 11 |
2119095 | 2119095 | 2022-01-16 | Modoc | California | 6049 | 1210 | 11 |
2115843 | 2115843 | 2022-01-15 | Modoc | California | 6049 | 1210 | 11 |
2112592 | 2112592 | 2022-01-14 | Modoc | California | 6049 | 1210 | 11 |
2109340 | 2109340 | 2022-01-13 | Modoc | California | 6049 | 1199 | 11 |
2106089 | 2106089 | 2022-01-12 | Modoc | California | 6049 | 1191 | 11 |
2102838 | 2102838 | 2022-01-11 | Modoc | California | 6049 | 1175 | 11 |
2099587 | 2099587 | 2022-01-10 | Modoc | California | 6049 | 1142 | 11 |
2096336 | 2096336 | 2022-01-09 | Modoc | California | 6049 | 1142 | 11 |
2093084 | 2093084 | 2022-01-08 | Modoc | California | 6049 | 1142 | 11 |
2089832 | 2089832 | 2022-01-07 | Modoc | California | 6049 | 1142 | 11 |
2086581 | 2086581 | 2022-01-06 | Modoc | California | 6049 | 1139 | 11 |
2083329 | 2083329 | 2022-01-05 | Modoc | California | 6049 | 1133 | 11 |
2080077 | 2080077 | 2022-01-04 | Modoc | California | 6049 | 1116 | 11 |
2076825 | 2076825 | 2022-01-03 | Modoc | California | 6049 | 1116 | 11 |
2073574 | 2073574 | 2022-01-02 | Modoc | California | 6049 | 1116 | 11 |
2070323 | 2070323 | 2022-01-01 | Modoc | California | 6049 | 1116 | 11 |
2067072 | 2067072 | 2021-12-31 | Modoc | California | 6049 | 1116 | 11 |
2063821 | 2063821 | 2021-12-30 | Modoc | California | 6049 | 1116 | 11 |
2060571 | 2060571 | 2021-12-29 | Modoc | California | 6049 | 1113 | 11 |
2057322 | 2057322 | 2021-12-28 | Modoc | California | 6049 | 1111 | 11 |
2054073 | 2054073 | 2021-12-27 | Modoc | California | 6049 | 1106 | 11 |
2050823 | 2050823 | 2021-12-26 | Modoc | California | 6049 | 1106 | 11 |
2047573 | 2047573 | 2021-12-25 | Modoc | California | 6049 | 1106 | 11 |
2044323 | 2044323 | 2021-12-24 | Modoc | California | 6049 | 1106 | 11 |
2041074 | 2041074 | 2021-12-23 | Modoc | California | 6049 | 1106 | 11 |
2037824 | 2037824 | 2021-12-22 | Modoc | California | 6049 | 1103 | 11 |
2034574 | 2034574 | 2021-12-21 | Modoc | California | 6049 | 1101 | 11 |
2031324 | 2031324 | 2021-12-20 | Modoc | California | 6049 | 1093 | 11 |
2028073 | 2028073 | 2021-12-19 | Modoc | California | 6049 | 1093 | 11 |
2024822 | 2024822 | 2021-12-18 | Modoc | California | 6049 | 1093 | 11 |
2021571 | 2021571 | 2021-12-17 | Modoc | California | 6049 | 1093 | 11 |
2018320 | 2018320 | 2021-12-16 | Modoc | California | 6049 | 1091 | 11 |
1891585 | 1891585 | 2021-11-07 | Trinity | California | 6105 | 928 | 11 |
1888335 | 1888335 | 2021-11-06 | Trinity | California | 6105 | 928 | 11 |
1885085 | 1885085 | 2021-11-05 | Trinity | California | 6105 | 928 | 11 |
1881836 | 1881836 | 2021-11-04 | Trinity | California | 6105 | 926 | 11 |
1878587 | 1878587 | 2021-11-03 | Trinity | California | 6105 | 917 | 11 |
1875338 | 1875338 | 2021-11-02 | Trinity | California | 6105 | 915 | 11 |
1872089 | 1872089 | 2021-11-01 | Trinity | California | 6105 | 912 | 11 |
1868840 | 1868840 | 2021-10-31 | Trinity | California | 6105 | 896 | 11 |
1865591 | 1865591 | 2021-10-30 | Trinity | California | 6105 | 896 | 11 |
1862342 | 1862342 | 2021-10-29 | Trinity | California | 6105 | 896 | 11 |
1859093 | 1859093 | 2021-10-28 | Trinity | California | 6105 | 894 | 11 |
1855844 | 1855844 | 2021-10-27 | Trinity | California | 6105 | 890 | 11 |
1852595 | 1852595 | 2021-10-26 | Trinity | California | 6105 | 884 | 11 |
1849346 | 1849346 | 2021-10-25 | Trinity | California | 6105 | 881 | 11 |
1846096 | 1846096 | 2021-10-24 | Trinity | California | 6105 | 881 | 11 |
1842846 | 1842846 | 2021-10-23 | Trinity | California | 6105 | 881 | 11 |
1839596 | 1839596 | 2021-10-22 | Trinity | California | 6105 | 881 | 11 |
1836347 | 1836347 | 2021-10-21 | Trinity | California | 6105 | 878 | 11 |
1833098 | 1833098 | 2021-10-20 | Trinity | California | 6105 | 873 | 11 |
1829849 | 1829849 | 2021-10-19 | Trinity | California | 6105 | 870 | 11 |
1826600 | 1826600 | 2021-10-18 | Trinity | California | 6105 | 868 | 11 |
1823351 | 1823351 | 2021-10-17 | Trinity | California | 6105 | 861 | 11 |
1820102 | 1820102 | 2021-10-16 | Trinity | California | 6105 | 861 | 11 |
1816853 | 1816853 | 2021-10-15 | Trinity | California | 6105 | 861 | 11 |
1813605 | 1813605 | 2021-10-14 | Trinity | California | 6105 | 859 | 11 |
1810356 | 1810356 | 2021-10-13 | Trinity | California | 6105 | 854 | 11 |
1807107 | 1807107 | 2021-10-12 | Trinity | California | 6105 | 853 | 11 |
1803856 | 1803856 | 2021-10-11 | Trinity | California | 6105 | 847 | 11 |
1800607 | 1800607 | 2021-10-10 | Trinity | California | 6105 | 838 | 11 |
1797358 | 1797358 | 2021-10-09 | Trinity | California | 6105 | 838 | 11 |
1794109 | 1794109 | 2021-10-08 | Trinity | California | 6105 | 838 | 11 |
1790861 | 1790861 | 2021-10-07 | Trinity | California | 6105 | 834 | 11 |
1787612 | 1787612 | 2021-10-06 | Trinity | California | 6105 | 829 | 11 |
1784363 | 1784363 | 2021-10-05 | Trinity | California | 6105 | 823 | 11 |
1781114 | 1781114 | 2021-10-04 | Trinity | California | 6105 | 821 | 11 |
1030977 | 1030977 | 2021-02-15 | Colusa | California | 6011 | 2069 | 11 |
1027730 | 1027730 | 2021-02-14 | Colusa | California | 6011 | 2069 | 11 |
1024485 | 1024485 | 2021-02-13 | Colusa | California | 6011 | 2069 | 11 |
1021240 | 1021240 | 2021-02-12 | Colusa | California | 6011 | 2069 | 11 |
1017995 | 1017995 | 2021-02-11 | Colusa | California | 6011 | 2069 | 11 |
1014750 | 1014750 | 2021-02-10 | Colusa | California | 6011 | 2056 | 11 |
1011505 | 1011505 | 2021-02-09 | Colusa | California | 6011 | 2046 | 11 |
1008259 | 1008259 | 2021-02-08 | Colusa | California | 6011 | 2020 | 11 |
1005013 | 1005013 | 2021-02-07 | Colusa | California | 6011 | 2004 | 11 |
1001767 | 1001767 | 2021-02-06 | Colusa | California | 6011 | 1989 | 11 |
998521 | 998521 | 2021-02-05 | Colusa | California | 6011 | 1989 | 11 |
995275 | 995275 | 2021-02-04 | Colusa | California | 6011 | 1989 | 11 |
992029 | 992029 | 2021-02-03 | Colusa | California | 6011 | 1989 | 11 |
988783 | 988783 | 2021-02-02 | Colusa | California | 6011 | 1972 | 11 |
910906 | 910906 | 2021-01-09 | Lassen | California | 6035 | 4972 | 11 |
907661 | 907661 | 2021-01-08 | Lassen | California | 6035 | 4972 | 11 |
904415 | 904415 | 2021-01-07 | Lassen | California | 6035 | 4947 | 11 |
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);