ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where deaths = 87 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 16
county 16
- Kings 20
- Mendocino 7
- Tuolumne 6
- Lake 5
- Napa 5
- Nevada 4
- San Benito 4
- Santa Barbara 3
- Fresno 1
- Humboldt 1
- Kern 1
- Monterey 1
- San Diego 1
- San Francisco 1
- Siskiyou 1
- Stanislaus 1
state 1
- California · 62 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2171175 | 2171175 | 2022-02-01 | Siskiyou | California | 6093 | 6679 | 87 |
2119105 | 2119105 | 2022-01-16 | San Benito | California | 6069 | 10177 | 87 |
2115853 | 2115853 | 2022-01-15 | San Benito | California | 6069 | 10177 | 87 |
2112602 | 2112602 | 2022-01-14 | San Benito | California | 6069 | 10177 | 87 |
2109350 | 2109350 | 2022-01-13 | San Benito | California | 6069 | 10046 | 87 |
1849316 | 1849316 | 2021-10-25 | Mendocino | California | 6045 | 7667 | 87 |
1846066 | 1846066 | 2021-10-24 | Mendocino | California | 6045 | 7667 | 87 |
1842816 | 1842816 | 2021-10-23 | Mendocino | California | 6045 | 7667 | 87 |
1839566 | 1839566 | 2021-10-22 | Mendocino | California | 6045 | 7667 | 87 |
1836317 | 1836317 | 2021-10-21 | Mendocino | California | 6045 | 7636 | 87 |
1833068 | 1833068 | 2021-10-20 | Mendocino | California | 6045 | 7600 | 87 |
1829819 | 1829819 | 2021-10-19 | Mendocino | California | 6045 | 7584 | 87 |
1777840 | 1777840 | 2021-10-03 | Nevada | California | 6057 | 8763 | 87 |
1774590 | 1774590 | 2021-10-02 | Nevada | California | 6057 | 8763 | 87 |
1771340 | 1771340 | 2021-10-01 | Nevada | California | 6057 | 8763 | 87 |
1768091 | 1768091 | 2021-09-30 | Nevada | California | 6057 | 8723 | 87 |
1738840 | 1738840 | 2021-09-21 | Lake | California | 6033 | 6058 | 87 |
1735586 | 1735586 | 2021-09-20 | Humboldt | California | 6023 | 8295 | 87 |
1735591 | 1735591 | 2021-09-20 | Lake | California | 6033 | 6036 | 87 |
1732341 | 1732341 | 2021-09-19 | Lake | California | 6033 | 6010 | 87 |
1729091 | 1729091 | 2021-09-18 | Lake | California | 6033 | 5989 | 87 |
1725841 | 1725841 | 2021-09-17 | Lake | California | 6033 | 5964 | 87 |
1670628 | 1670628 | 2021-08-31 | Napa | California | 6055 | 11648 | 87 |
1667381 | 1667381 | 2021-08-30 | Napa | California | 6055 | 11621 | 87 |
1664161 | 1664161 | 2021-08-29 | Tuolumne | California | 6109 | 5652 | 87 |
1660886 | 1660886 | 2021-08-28 | Napa | California | 6055 | 11529 | 87 |
1660913 | 1660913 | 2021-08-28 | Tuolumne | California | 6109 | 5621 | 87 |
1657638 | 1657638 | 2021-08-27 | Napa | California | 6055 | 11463 | 87 |
1657665 | 1657665 | 2021-08-27 | Tuolumne | California | 6109 | 5603 | 87 |
1654390 | 1654390 | 2021-08-26 | Napa | California | 6055 | 11417 | 87 |
1654417 | 1654417 | 2021-08-26 | Tuolumne | California | 6109 | 5569 | 87 |
1651170 | 1651170 | 2021-08-25 | Tuolumne | California | 6109 | 5506 | 87 |
1647921 | 1647921 | 2021-08-24 | Tuolumne | California | 6109 | 5465 | 87 |
781091 | 781091 | 2020-11-30 | Kings | California | 6031 | 11366 | 87 |
777845 | 777845 | 2020-11-29 | Kings | California | 6031 | 11270 | 87 |
774600 | 774600 | 2020-11-28 | Kings | California | 6031 | 11093 | 87 |
771355 | 771355 | 2020-11-27 | Kings | California | 6031 | 10687 | 87 |
768110 | 768110 | 2020-11-26 | Kings | California | 6031 | 10496 | 87 |
764864 | 764864 | 2020-11-25 | Kings | California | 6031 | 10440 | 87 |
761619 | 761619 | 2020-11-24 | Kings | California | 6031 | 10359 | 87 |
758374 | 758374 | 2020-11-23 | Kings | California | 6031 | 10259 | 87 |
742142 | 742142 | 2020-11-18 | Kings | California | 6031 | 9708 | 87 |
738895 | 738895 | 2020-11-17 | Kings | California | 6031 | 9664 | 87 |
735651 | 735651 | 2020-11-16 | Kings | California | 6031 | 9601 | 87 |
732405 | 732405 | 2020-11-15 | Kings | California | 6031 | 9515 | 87 |
729160 | 729160 | 2020-11-14 | Kings | California | 6031 | 9434 | 87 |
725917 | 725917 | 2020-11-13 | Kings | California | 6031 | 9372 | 87 |
722674 | 722674 | 2020-11-12 | Kings | California | 6031 | 9277 | 87 |
719431 | 719431 | 2020-11-11 | Kings | California | 6031 | 9236 | 87 |
716188 | 716188 | 2020-11-10 | Kings | California | 6031 | 9141 | 87 |
712944 | 712944 | 2020-11-09 | Kings | California | 6031 | 9070 | 87 |
709700 | 709700 | 2020-11-08 | Kings | California | 6031 | 9002 | 87 |
706456 | 706456 | 2020-11-07 | Kings | California | 6031 | 8889 | 87 |
654571 | 654571 | 2020-10-22 | Monterey | California | 6053 | 11284 | 87 |
515230 | 515230 | 2020-09-09 | San Francisco | California | 6075 | 10077 | 87 |
460281 | 460281 | 2020-08-23 | Santa Barbara | California | 6083 | 7685 | 87 |
457054 | 457054 | 2020-08-22 | Santa Barbara | California | 6083 | 7653 | 87 |
453826 | 453826 | 2020-08-21 | Santa Barbara | California | 6083 | 7653 | 87 |
366886 | 366886 | 2020-07-25 | Stanislaus | California | 6099 | 7861 | 87 |
315734 | 315734 | 2020-07-09 | Fresno | California | 6019 | 7627 | 87 |
312564 | 312564 | 2020-07-08 | Kern | California | 6029 | 5769 | 87 |
75872 | 75872 | 2020-04-21 | San Diego | California | 6073 | 2434 | 87 |
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);