ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where deaths = 95 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 19
county 19
- Napa 13
- Calaveras 7
- San Benito 7
- Solano 6
- Marin 4
- Kings 3
- Lake 3
- Ventura 3
- El Dorado 2
- Monterey 2
- San Luis Obispo 2
- Merced 1
- Sacramento 1
- San Joaquin 1
- Santa Barbara 1
- Santa Clara 1
- Shasta 1
- Stanislaus 1
- Tehama 1
state 1
- California · 60 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2310998 | 2310998 | 2022-03-16 | San Benito | California | 6069 | 13360 | 95 |
2307745 | 2307745 | 2022-03-15 | San Benito | California | 6069 | 13357 | 95 |
2304494 | 2304494 | 2022-03-14 | San Benito | California | 6069 | 13355 | 95 |
2301242 | 2301242 | 2022-03-13 | San Benito | California | 6069 | 13379 | 95 |
2297990 | 2297990 | 2022-03-12 | San Benito | California | 6069 | 13379 | 95 |
2294738 | 2294738 | 2022-03-11 | San Benito | California | 6069 | 13379 | 95 |
2291486 | 2291486 | 2022-03-10 | San Benito | California | 6069 | 13375 | 95 |
2151608 | 2151608 | 2022-01-26 | Calaveras | California | 6009 | 6437 | 95 |
2148356 | 2148356 | 2022-01-25 | Calaveras | California | 6009 | 6343 | 95 |
2145104 | 2145104 | 2022-01-24 | Calaveras | California | 6009 | 6266 | 95 |
2141849 | 2141849 | 2022-01-23 | Calaveras | California | 6009 | 6006 | 95 |
2138594 | 2138594 | 2022-01-22 | Calaveras | California | 6009 | 6006 | 95 |
2135338 | 2135338 | 2022-01-21 | Calaveras | California | 6009 | 6006 | 95 |
2132086 | 2132086 | 2022-01-20 | Calaveras | California | 6009 | 5936 | 95 |
1784362 | 1784362 | 2021-10-05 | Tehama | California | 6103 | 8875 | 95 |
1764830 | 1764830 | 2021-09-29 | Lake | California | 6033 | 6244 | 95 |
1761581 | 1761581 | 2021-09-28 | Lake | California | 6033 | 6215 | 95 |
1761592 | 1761592 | 2021-09-28 | Napa | California | 6055 | 12441 | 95 |
1758333 | 1758333 | 2021-09-27 | Lake | California | 6033 | 6202 | 95 |
1758344 | 1758344 | 2021-09-27 | Napa | California | 6055 | 12427 | 95 |
1755096 | 1755096 | 2021-09-26 | Napa | California | 6055 | 12353 | 95 |
1751848 | 1751848 | 2021-09-25 | Napa | California | 6055 | 12353 | 95 |
1748599 | 1748599 | 2021-09-24 | Napa | California | 6055 | 12353 | 95 |
1745349 | 1745349 | 2021-09-23 | Napa | California | 6055 | 12335 | 95 |
1742100 | 1742100 | 2021-09-22 | Napa | California | 6055 | 12317 | 95 |
1738851 | 1738851 | 2021-09-21 | Napa | California | 6055 | 12288 | 95 |
1735602 | 1735602 | 2021-09-20 | Napa | California | 6055 | 12269 | 95 |
1732352 | 1732352 | 2021-09-19 | Napa | California | 6055 | 12247 | 95 |
1729102 | 1729102 | 2021-09-18 | Napa | California | 6055 | 12232 | 95 |
1725852 | 1725852 | 2021-09-17 | Napa | California | 6055 | 12194 | 95 |
1722603 | 1722603 | 2021-09-16 | Napa | California | 6055 | 12161 | 95 |
1060192 | 1060192 | 2021-02-24 | El Dorado | California | 6017 | 8969 | 95 |
1056946 | 1056946 | 2021-02-23 | El Dorado | California | 6017 | 8940 | 95 |
904437 | 904437 | 2021-01-07 | San Luis Obispo | California | 6079 | 12597 | 95 |
904442 | 904442 | 2021-01-07 | Shasta | California | 6089 | 8741 | 95 |
901192 | 901192 | 2021-01-06 | San Luis Obispo | California | 6079 | 12185 | 95 |
871991 | 871991 | 2020-12-28 | Solano | California | 6095 | 18523 | 95 |
868746 | 868746 | 2020-12-27 | Solano | California | 6095 | 17533 | 95 |
865501 | 865501 | 2020-12-26 | Solano | California | 6095 | 17335 | 95 |
862256 | 862256 | 2020-12-25 | Solano | California | 6095 | 17335 | 95 |
859011 | 859011 | 2020-12-24 | Solano | California | 6095 | 17335 | 95 |
855766 | 855766 | 2020-12-23 | Solano | California | 6095 | 16849 | 95 |
807050 | 807050 | 2020-12-08 | Kings | California | 6031 | 12624 | 95 |
803805 | 803805 | 2020-12-07 | Kings | California | 6031 | 12201 | 95 |
800560 | 800560 | 2020-12-06 | Kings | California | 6031 | 11957 | 95 |
680520 | 680520 | 2020-10-30 | Monterey | California | 6053 | 11705 | 95 |
677277 | 677277 | 2020-10-29 | Monterey | California | 6053 | 11616 | 95 |
489368 | 489368 | 2020-09-01 | Santa Barbara | California | 6083 | 8164 | 95 |
486114 | 486114 | 2020-08-31 | Marin | California | 6041 | 6164 | 95 |
482879 | 482879 | 2020-08-30 | Marin | California | 6041 | 6143 | 95 |
473179 | 473179 | 2020-08-27 | Marin | California | 6041 | 6053 | 95 |
469947 | 469947 | 2020-08-26 | Marin | California | 6041 | 5999 | 95 |
444125 | 444125 | 2020-08-18 | Merced | California | 6047 | 7171 | 95 |
437705 | 437705 | 2020-08-16 | Ventura | California | 6111 | 9379 | 95 |
434479 | 434479 | 2020-08-15 | Ventura | California | 6111 | 9313 | 95 |
431254 | 431254 | 2020-08-14 | Ventura | California | 6111 | 9114 | 95 |
373308 | 373308 | 2020-07-27 | Stanislaus | California | 6099 | 8228 | 95 |
354053 | 354053 | 2020-07-21 | San Joaquin | California | 6077 | 8799 | 95 |
341246 | 341246 | 2020-07-17 | Sacramento | California | 6067 | 6510 | 95 |
78662 | 78662 | 2020-04-22 | Santa Clara | California | 6085 | 1962 | 95 |
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);