ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where deaths = 158 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 12
- Tehama 13
- Ventura 6
- Yolo 6
- San Francisco 4
- Butte 2
- Tuolumne 2
- Contra Costa 1
- Merced 1
- Monterey 1
- Orange 1
- San Bernardino 1
- San Luis Obispo 1
state 1
- California · 39 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2288251 | 2288251 | 2022-03-09 | Tehama | California | 6103 | 14554 | 158 |
2285000 | 2285000 | 2022-03-08 | Tehama | California | 6103 | 14548 | 158 |
2281748 | 2281748 | 2022-03-07 | Tehama | California | 6103 | 14545 | 158 |
2278495 | 2278495 | 2022-03-06 | Tehama | California | 6103 | 14521 | 158 |
2275242 | 2275242 | 2022-03-05 | Tehama | California | 6103 | 14521 | 158 |
2271989 | 2271989 | 2022-03-04 | Tehama | California | 6103 | 14521 | 158 |
2268737 | 2268737 | 2022-03-03 | Tehama | California | 6103 | 14512 | 158 |
2265484 | 2265484 | 2022-03-02 | Tehama | California | 6103 | 14504 | 158 |
2262233 | 2262233 | 2022-03-01 | Tehama | California | 6103 | 14498 | 158 |
2258982 | 2258982 | 2022-02-28 | Tehama | California | 6103 | 14496 | 158 |
2255731 | 2255731 | 2022-02-27 | Tehama | California | 6103 | 14459 | 158 |
2252480 | 2252480 | 2022-02-26 | Tehama | California | 6103 | 14459 | 158 |
2249229 | 2249229 | 2022-02-25 | Tehama | California | 6103 | 14459 | 158 |
2151658 | 2151658 | 2022-01-26 | Tuolumne | California | 6109 | 11273 | 158 |
2148406 | 2148406 | 2022-01-25 | Tuolumne | California | 6109 | 11107 | 158 |
1056941 | 1056941 | 2021-02-23 | Butte | California | 6007 | 10855 | 158 |
1053695 | 1053695 | 2021-02-22 | Butte | California | 6007 | 10855 | 158 |
1008310 | 1008310 | 2021-02-08 | Yolo | California | 6113 | 12135 | 158 |
1005064 | 1005064 | 2021-02-07 | Yolo | California | 6113 | 12061 | 158 |
1001818 | 1001818 | 2021-02-06 | Yolo | California | 6113 | 12025 | 158 |
998572 | 998572 | 2021-02-05 | Yolo | California | 6113 | 11982 | 158 |
995326 | 995326 | 2021-02-04 | Yolo | California | 6113 | 11933 | 158 |
992080 | 992080 | 2021-02-03 | Yolo | California | 6113 | 11886 | 158 |
962853 | 962853 | 2021-01-25 | San Luis Obispo | California | 6079 | 16957 | 158 |
826535 | 826535 | 2020-12-14 | Monterey | California | 6053 | 18913 | 158 |
761641 | 761641 | 2020-11-24 | San Francisco | California | 6075 | 14665 | 158 |
758396 | 758396 | 2020-11-23 | San Francisco | California | 6075 | 14545 | 158 |
755149 | 755149 | 2020-11-22 | San Francisco | California | 6075 | 14448 | 158 |
751903 | 751903 | 2020-11-21 | San Francisco | California | 6075 | 14330 | 158 |
690249 | 690249 | 2020-11-02 | Merced | California | 6047 | 9779 | 158 |
628636 | 628636 | 2020-10-14 | Ventura | California | 6111 | 13645 | 158 |
625393 | 625393 | 2020-10-13 | Ventura | California | 6111 | 13617 | 158 |
622150 | 622150 | 2020-10-12 | Ventura | California | 6111 | 13604 | 158 |
618907 | 618907 | 2020-10-11 | Ventura | California | 6111 | 13520 | 158 |
615665 | 615665 | 2020-10-10 | Ventura | California | 6111 | 13469 | 158 |
612424 | 612424 | 2020-10-09 | Ventura | California | 6111 | 13399 | 158 |
447335 | 447335 | 2020-08-19 | Contra Costa | California | 6013 | 11886 | 158 |
203205 | 203205 | 2020-06-03 | Orange | California | 6059 | 6790 | 158 |
160480 | 160480 | 2020-05-20 | San Bernardino | California | 6071 | 3795 | 158 |
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);