ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
128 rows where deaths = 69 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 19
county 19
- Lassen 46
- Siskiyou 14
- Amador 12
- Tuolumne 12
- San Benito 9
- Lake 6
- Yuba 5
- Napa 4
- Sacramento 4
- San Francisco 3
- Santa Barbara 3
- Alameda 2
- Sutter 2
- Imperial 1
- Kings 1
- Mendocino 1
- Monterey 1
- Riverside 1
- Solano 1
state 1
- California · 128 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499779 | 2499779 | 2022-05-13 | Lassen | California | 6035 | 10751 | 69 |
2496521 | 2496521 | 2022-05-12 | Lassen | California | 6035 | 10750 | 69 |
2493263 | 2493263 | 2022-05-11 | Lassen | California | 6035 | 10747 | 69 |
2490005 | 2490005 | 2022-05-10 | Lassen | California | 6035 | 10744 | 69 |
2486748 | 2486748 | 2022-05-09 | Lassen | California | 6035 | 10740 | 69 |
2483490 | 2483490 | 2022-05-08 | Lassen | California | 6035 | 10740 | 69 |
2480232 | 2480232 | 2022-05-07 | Lassen | California | 6035 | 10740 | 69 |
2476974 | 2476974 | 2022-05-06 | Lassen | California | 6035 | 10740 | 69 |
2473716 | 2473716 | 2022-05-05 | Lassen | California | 6035 | 10735 | 69 |
2470459 | 2470459 | 2022-05-04 | Lassen | California | 6035 | 10735 | 69 |
2467203 | 2467203 | 2022-05-03 | Lassen | California | 6035 | 10735 | 69 |
2463948 | 2463948 | 2022-05-02 | Lassen | California | 6035 | 10728 | 69 |
2460692 | 2460692 | 2022-05-01 | Lassen | California | 6035 | 10728 | 69 |
2457436 | 2457436 | 2022-04-30 | Lassen | California | 6035 | 10728 | 69 |
2454180 | 2454180 | 2022-04-29 | Lassen | California | 6035 | 10726 | 69 |
2450924 | 2450924 | 2022-04-28 | Lassen | California | 6035 | 10726 | 69 |
2447668 | 2447668 | 2022-04-27 | Lassen | California | 6035 | 10726 | 69 |
2444412 | 2444412 | 2022-04-26 | Lassen | California | 6035 | 10726 | 69 |
2441156 | 2441156 | 2022-04-25 | Lassen | California | 6035 | 10725 | 69 |
2437900 | 2437900 | 2022-04-24 | Lassen | California | 6035 | 10725 | 69 |
2434644 | 2434644 | 2022-04-23 | Lassen | California | 6035 | 10725 | 69 |
2431388 | 2431388 | 2022-04-22 | Lassen | California | 6035 | 10725 | 69 |
2428132 | 2428132 | 2022-04-21 | Lassen | California | 6035 | 10725 | 69 |
2424876 | 2424876 | 2022-04-20 | Lassen | California | 6035 | 10725 | 69 |
2421620 | 2421620 | 2022-04-19 | Lassen | California | 6035 | 10723 | 69 |
2418364 | 2418364 | 2022-04-18 | Lassen | California | 6035 | 10723 | 69 |
2415108 | 2415108 | 2022-04-17 | Lassen | California | 6035 | 10723 | 69 |
2411852 | 2411852 | 2022-04-16 | Lassen | California | 6035 | 10723 | 69 |
2408596 | 2408596 | 2022-04-15 | Lassen | California | 6035 | 10723 | 69 |
2405340 | 2405340 | 2022-04-14 | Lassen | California | 6035 | 10722 | 69 |
2402085 | 2402085 | 2022-04-13 | Lassen | California | 6035 | 10722 | 69 |
2398830 | 2398830 | 2022-04-12 | Lassen | California | 6035 | 10722 | 69 |
2395575 | 2395575 | 2022-04-11 | Lassen | California | 6035 | 10721 | 69 |
2392319 | 2392319 | 2022-04-10 | Lassen | California | 6035 | 10721 | 69 |
2389063 | 2389063 | 2022-04-09 | Lassen | California | 6035 | 10721 | 69 |
2385808 | 2385808 | 2022-04-08 | Lassen | California | 6035 | 10721 | 69 |
2382553 | 2382553 | 2022-04-07 | Lassen | California | 6035 | 10720 | 69 |
2379298 | 2379298 | 2022-04-06 | Lassen | California | 6035 | 10717 | 69 |
2376044 | 2376044 | 2022-04-05 | Lassen | California | 6035 | 10717 | 69 |
2372792 | 2372792 | 2022-04-04 | Lassen | California | 6035 | 10714 | 69 |
2369539 | 2369539 | 2022-04-03 | Lassen | California | 6035 | 10713 | 69 |
2366286 | 2366286 | 2022-04-02 | Lassen | California | 6035 | 10713 | 69 |
2363033 | 2363033 | 2022-04-01 | Lassen | California | 6035 | 10713 | 69 |
2359779 | 2359779 | 2022-03-31 | Lassen | California | 6035 | 10713 | 69 |
2356525 | 2356525 | 2022-03-30 | Lassen | California | 6035 | 10713 | 69 |
2353272 | 2353272 | 2022-03-29 | Lassen | California | 6035 | 10713 | 69 |
2028051 | 2028051 | 2021-12-19 | Amador | California | 6005 | 5897 | 69 |
2024800 | 2024800 | 2021-12-18 | Amador | California | 6005 | 5897 | 69 |
2021549 | 2021549 | 2021-12-17 | Amador | California | 6005 | 5897 | 69 |
2018298 | 2018298 | 2021-12-16 | Amador | California | 6005 | 5886 | 69 |
2015048 | 2015048 | 2021-12-15 | Amador | California | 6005 | 5879 | 69 |
2011797 | 2011797 | 2021-12-14 | Amador | California | 6005 | 5868 | 69 |
2008546 | 2008546 | 2021-12-13 | Amador | California | 6005 | 5868 | 69 |
2005295 | 2005295 | 2021-12-12 | Amador | California | 6005 | 5858 | 69 |
2002044 | 2002044 | 2021-12-11 | Amador | California | 6005 | 5858 | 69 |
1998794 | 1998794 | 2021-12-10 | Amador | California | 6005 | 5858 | 69 |
1995543 | 1995543 | 2021-12-09 | Amador | California | 6005 | 5852 | 69 |
1992292 | 1992292 | 2021-12-08 | Amador | California | 6005 | 5848 | 69 |
1940328 | 1940328 | 2021-11-22 | Siskiyou | California | 6093 | 4850 | 69 |
1937078 | 1937078 | 2021-11-21 | Siskiyou | California | 6093 | 4837 | 69 |
1933828 | 1933828 | 2021-11-20 | Siskiyou | California | 6093 | 4837 | 69 |
1930576 | 1930576 | 2021-11-19 | Siskiyou | California | 6093 | 4826 | 69 |
1927326 | 1927326 | 2021-11-18 | Siskiyou | California | 6093 | 4826 | 69 |
1924076 | 1924076 | 2021-11-17 | Siskiyou | California | 6093 | 4809 | 69 |
1920827 | 1920827 | 2021-11-16 | Siskiyou | California | 6093 | 4809 | 69 |
1917577 | 1917577 | 2021-11-15 | Siskiyou | California | 6093 | 4797 | 69 |
1914327 | 1914327 | 2021-11-14 | Siskiyou | California | 6093 | 4797 | 69 |
1911077 | 1911077 | 2021-11-13 | Siskiyou | California | 6093 | 4796 | 69 |
1907828 | 1907828 | 2021-11-12 | Siskiyou | California | 6093 | 4796 | 69 |
1904579 | 1904579 | 2021-11-11 | Siskiyou | California | 6093 | 4796 | 69 |
1901329 | 1901329 | 2021-11-10 | Siskiyou | California | 6093 | 4796 | 69 |
1898079 | 1898079 | 2021-11-09 | Siskiyou | California | 6093 | 4789 | 69 |
1800612 | 1800612 | 2021-10-10 | Yuba | California | 6115 | 10109 | 69 |
1797363 | 1797363 | 2021-10-09 | Yuba | California | 6115 | 10109 | 69 |
1794114 | 1794114 | 2021-10-08 | Yuba | California | 6115 | 10109 | 69 |
1790843 | 1790843 | 2021-10-07 | San Benito | California | 6069 | 7265 | 69 |
1790866 | 1790866 | 2021-10-07 | Yuba | California | 6115 | 10109 | 69 |
1787594 | 1787594 | 2021-10-06 | San Benito | California | 6069 | 7259 | 69 |
1787617 | 1787617 | 2021-10-06 | Yuba | California | 6115 | 10074 | 69 |
1784345 | 1784345 | 2021-10-05 | San Benito | California | 6069 | 7255 | 69 |
1781096 | 1781096 | 2021-10-04 | San Benito | California | 6069 | 7251 | 69 |
1777846 | 1777846 | 2021-10-03 | San Benito | California | 6069 | 7211 | 69 |
1774596 | 1774596 | 2021-10-02 | San Benito | California | 6069 | 7211 | 69 |
1771346 | 1771346 | 2021-10-01 | San Benito | California | 6069 | 7211 | 69 |
1768097 | 1768097 | 2021-09-30 | San Benito | California | 6069 | 7195 | 69 |
1764848 | 1764848 | 2021-09-29 | San Benito | California | 6069 | 7177 | 69 |
1716101 | 1716101 | 2021-09-14 | Mendocino | California | 6045 | 6599 | 69 |
1647883 | 1647883 | 2021-08-24 | Lake | California | 6033 | 5134 | 69 |
1644635 | 1644635 | 2021-08-23 | Lake | California | 6033 | 5104 | 69 |
1641385 | 1641385 | 2021-08-22 | Lake | California | 6033 | 5090 | 69 |
1638135 | 1638135 | 2021-08-21 | Lake | California | 6033 | 5059 | 69 |
1634885 | 1634885 | 2021-08-20 | Lake | California | 6033 | 5026 | 69 |
1631636 | 1631636 | 2021-08-19 | Lake | California | 6033 | 4992 | 69 |
1414124 | 1414124 | 2021-06-13 | Tuolumne | California | 6109 | 4185 | 69 |
1410879 | 1410879 | 2021-06-12 | Tuolumne | California | 6109 | 4185 | 69 |
1407634 | 1407634 | 2021-06-11 | Tuolumne | California | 6109 | 4185 | 69 |
1404388 | 1404388 | 2021-06-10 | Tuolumne | California | 6109 | 4183 | 69 |
1401143 | 1401143 | 2021-06-09 | Tuolumne | California | 6109 | 4179 | 69 |
1397898 | 1397898 | 2021-06-08 | Tuolumne | California | 6109 | 4179 | 69 |
1394651 | 1394651 | 2021-06-07 | Tuolumne | California | 6109 | 4177 | 69 |
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);