ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where deaths = 138 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 18
county 18
- Napa 13
- Humboldt 6
- Santa Barbara 6
- Yolo 6
- Tuolumne 5
- Fresno 4
- Sutter 4
- Butte 3
- Marin 2
- Shasta 2
- Tehama 2
- Alameda 1
- Contra Costa 1
- El Dorado 1
- San Bernardino 1
- San Francisco 1
- Santa Clara 1
- Ventura 1
state 1
- California · 60 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2330510 | 2330510 | 2022-03-22 | Napa | California | 6055 | 26643 | 138 |
2327258 | 2327258 | 2022-03-21 | Napa | California | 6055 | 26641 | 138 |
2324005 | 2324005 | 2022-03-20 | Napa | California | 6055 | 26613 | 138 |
2320751 | 2320751 | 2022-03-19 | Napa | California | 6055 | 26613 | 138 |
2317497 | 2317497 | 2022-03-18 | Napa | California | 6055 | 26613 | 138 |
2314244 | 2314244 | 2022-03-17 | Napa | California | 6055 | 26597 | 138 |
2310991 | 2310991 | 2022-03-16 | Napa | California | 6055 | 26620 | 138 |
2307738 | 2307738 | 2022-03-15 | Napa | California | 6055 | 26612 | 138 |
2304487 | 2304487 | 2022-03-14 | Napa | California | 6055 | 26602 | 138 |
2301235 | 2301235 | 2022-03-13 | Napa | California | 6055 | 26547 | 138 |
2297983 | 2297983 | 2022-03-12 | Napa | California | 6055 | 26547 | 138 |
2294731 | 2294731 | 2022-03-11 | Napa | California | 6055 | 26547 | 138 |
2291479 | 2291479 | 2022-03-10 | Napa | California | 6055 | 26524 | 138 |
2262193 | 2262193 | 2022-03-01 | Humboldt | California | 6023 | 19609 | 138 |
2258942 | 2258942 | 2022-02-28 | Humboldt | California | 6023 | 19605 | 138 |
2255691 | 2255691 | 2022-02-27 | Humboldt | California | 6023 | 19511 | 138 |
2252440 | 2252440 | 2022-02-26 | Humboldt | California | 6023 | 19511 | 138 |
2249189 | 2249189 | 2022-02-25 | Humboldt | California | 6023 | 19511 | 138 |
2245938 | 2245938 | 2022-02-24 | Humboldt | California | 6023 | 19493 | 138 |
2063848 | 2063848 | 2021-12-30 | Tehama | California | 6103 | 10520 | 138 |
2060598 | 2060598 | 2021-12-29 | Tehama | California | 6103 | 10495 | 138 |
1937086 | 1937086 | 2021-11-21 | Tuolumne | California | 6109 | 7752 | 138 |
1933836 | 1933836 | 2021-11-20 | Tuolumne | California | 6109 | 7752 | 138 |
1930584 | 1930584 | 2021-11-19 | Tuolumne | California | 6109 | 7752 | 138 |
1927334 | 1927334 | 2021-11-18 | Tuolumne | California | 6109 | 7726 | 138 |
1924084 | 1924084 | 2021-11-17 | Tuolumne | California | 6109 | 7720 | 138 |
1784319 | 1784319 | 2021-10-05 | El Dorado | California | 6017 | 16614 | 138 |
1693394 | 1693394 | 2021-09-07 | Sutter | California | 6101 | 12405 | 138 |
1690145 | 1690145 | 2021-09-06 | Sutter | California | 6101 | 12338 | 138 |
1686895 | 1686895 | 2021-09-05 | Sutter | California | 6101 | 12296 | 138 |
1680394 | 1680394 | 2021-09-03 | Sutter | California | 6101 | 12161 | 138 |
985534 | 985534 | 2021-02-01 | Butte | California | 6007 | 10215 | 138 |
982287 | 982287 | 2021-01-31 | Butte | California | 6007 | 10177 | 138 |
979041 | 979041 | 2021-01-30 | Butte | California | 6007 | 10122 | 138 |
972592 | 972592 | 2021-01-28 | Shasta | California | 6089 | 10281 | 138 |
969347 | 969347 | 2021-01-27 | Shasta | California | 6089 | 10212 | 138 |
962870 | 962870 | 2021-01-25 | Yolo | California | 6113 | 11210 | 138 |
959625 | 959625 | 2021-01-24 | Yolo | California | 6113 | 11087 | 138 |
956379 | 956379 | 2021-01-23 | Yolo | California | 6113 | 11014 | 138 |
953134 | 953134 | 2021-01-22 | Yolo | California | 6113 | 10940 | 138 |
949889 | 949889 | 2021-01-21 | Yolo | California | 6113 | 10852 | 138 |
946643 | 946643 | 2021-01-20 | Yolo | California | 6113 | 10789 | 138 |
875209 | 875209 | 2020-12-29 | Marin | California | 6041 | 9663 | 138 |
871964 | 871964 | 2020-12-28 | Marin | California | 6041 | 9616 | 138 |
803831 | 803831 | 2020-12-07 | Santa Barbara | California | 6083 | 12379 | 138 |
800586 | 800586 | 2020-12-06 | Santa Barbara | California | 6083 | 12107 | 138 |
797341 | 797341 | 2020-12-05 | Santa Barbara | California | 6083 | 11947 | 138 |
794096 | 794096 | 2020-12-04 | Santa Barbara | California | 6083 | 11917 | 138 |
790851 | 790851 | 2020-12-03 | Santa Barbara | California | 6083 | 11845 | 138 |
787606 | 787606 | 2020-12-02 | Santa Barbara | California | 6083 | 11720 | 138 |
654582 | 654582 | 2020-10-22 | San Francisco | California | 6075 | 12003 | 138 |
534664 | 534664 | 2020-09-15 | Ventura | California | 6111 | 11903 | 138 |
411870 | 411870 | 2020-08-08 | Contra Costa | California | 6013 | 9022 | 138 |
395784 | 395784 | 2020-08-03 | Fresno | California | 6019 | 15759 | 138 |
392568 | 392568 | 2020-08-02 | Fresno | California | 6019 | 15448 | 138 |
389351 | 389351 | 2020-08-01 | Fresno | California | 6019 | 15083 | 138 |
386134 | 386134 | 2020-07-31 | Fresno | California | 6019 | 14793 | 138 |
293566 | 293566 | 2020-07-02 | Alameda | California | 6001 | 6405 | 138 |
157461 | 157461 | 2020-05-19 | Santa Clara | California | 6085 | 2483 | 138 |
139418 | 139418 | 2020-05-13 | San Bernardino | California | 6071 | 3153 | 138 |
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);