ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
48 rows where deaths = 256 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- San Luis Obispo 19
- Solano 9
- Imperial 5
- Tulare 5
- Kings 4
- Santa Cruz 3
- Butte 1
- Contra Costa 1
- Kern 1
state 1
- California · 48 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2324021 | 2324021 | 2022-03-20 | Santa Cruz | California | 6087 | 49126 | 256 |
2320767 | 2320767 | 2022-03-19 | Santa Cruz | California | 6087 | 49126 | 256 |
2317513 | 2317513 | 2022-03-18 | Santa Cruz | California | 6087 | 49126 | 256 |
1810307 | 1810307 | 2021-10-13 | Butte | California | 6007 | 23129 | 256 |
1625141 | 1625141 | 2021-08-17 | Kings | California | 6031 | 26140 | 256 |
1621894 | 1621894 | 2021-08-16 | Kings | California | 6031 | 26059 | 256 |
1618647 | 1618647 | 2021-08-15 | Kings | California | 6031 | 25970 | 256 |
1615399 | 1615399 | 2021-08-14 | Kings | California | 6031 | 25854 | 256 |
1388154 | 1388154 | 2021-06-05 | Solano | California | 6095 | 33496 | 256 |
1384909 | 1384909 | 2021-06-04 | Solano | California | 6095 | 33496 | 256 |
1381663 | 1381663 | 2021-06-03 | Solano | California | 6095 | 33474 | 256 |
1378418 | 1378418 | 2021-06-02 | Solano | California | 6095 | 33435 | 256 |
1375172 | 1375172 | 2021-06-01 | Solano | California | 6095 | 33402 | 256 |
1371927 | 1371927 | 2021-05-31 | Solano | California | 6095 | 33298 | 256 |
1368682 | 1368682 | 2021-05-30 | Solano | California | 6095 | 33298 | 256 |
1365436 | 1365436 | 2021-05-29 | Solano | California | 6095 | 33298 | 256 |
1355697 | 1355697 | 2021-05-26 | Solano | California | 6095 | 33223 | 256 |
1232311 | 1232311 | 2021-04-18 | San Luis Obispo | California | 6079 | 20917 | 256 |
1229062 | 1229062 | 2021-04-17 | San Luis Obispo | California | 6079 | 20917 | 256 |
1225814 | 1225814 | 2021-04-16 | San Luis Obispo | California | 6079 | 20917 | 256 |
1222567 | 1222567 | 2021-04-15 | San Luis Obispo | California | 6079 | 20878 | 256 |
1219319 | 1219319 | 2021-04-14 | San Luis Obispo | California | 6079 | 20857 | 256 |
1216071 | 1216071 | 2021-04-13 | San Luis Obispo | California | 6079 | 20827 | 256 |
1212824 | 1212824 | 2021-04-12 | San Luis Obispo | California | 6079 | 20754 | 256 |
1209576 | 1209576 | 2021-04-11 | San Luis Obispo | California | 6079 | 20723 | 256 |
1206327 | 1206327 | 2021-04-10 | San Luis Obispo | California | 6079 | 20723 | 256 |
1203079 | 1203079 | 2021-04-09 | San Luis Obispo | California | 6079 | 20723 | 256 |
1199831 | 1199831 | 2021-04-08 | San Luis Obispo | California | 6079 | 20704 | 256 |
1196582 | 1196582 | 2021-04-07 | San Luis Obispo | California | 6079 | 20671 | 256 |
1193334 | 1193334 | 2021-04-06 | San Luis Obispo | California | 6079 | 20649 | 256 |
1190084 | 1190084 | 2021-04-05 | San Luis Obispo | California | 6079 | 20606 | 256 |
1186837 | 1186837 | 2021-04-04 | San Luis Obispo | California | 6079 | 20547 | 256 |
1183590 | 1183590 | 2021-04-03 | San Luis Obispo | California | 6079 | 20547 | 256 |
1180343 | 1180343 | 2021-04-02 | San Luis Obispo | California | 6079 | 20547 | 256 |
1177096 | 1177096 | 2021-04-01 | San Luis Obispo | California | 6079 | 20522 | 256 |
1173849 | 1173849 | 2021-03-31 | San Luis Obispo | California | 6079 | 20505 | 256 |
745380 | 745380 | 2020-11-19 | Contra Costa | California | 6013 | 21959 | 256 |
554087 | 554087 | 2020-09-21 | Tulare | California | 6107 | 15687 | 256 |
550848 | 550848 | 2020-09-20 | Tulare | California | 6107 | 15599 | 256 |
547609 | 547609 | 2020-09-19 | Tulare | California | 6107 | 15599 | 256 |
544371 | 544371 | 2020-09-18 | Tulare | California | 6107 | 15599 | 256 |
541135 | 541135 | 2020-09-17 | Tulare | California | 6107 | 15517 | 256 |
473173 | 473173 | 2020-08-27 | Kern | California | 6029 | 28854 | 256 |
440888 | 440888 | 2020-08-17 | Imperial | California | 6025 | 10058 | 256 |
437662 | 437662 | 2020-08-16 | Imperial | California | 6025 | 10058 | 256 |
434436 | 434436 | 2020-08-15 | Imperial | California | 6025 | 10058 | 256 |
431211 | 431211 | 2020-08-14 | Imperial | California | 6025 | 10035 | 256 |
427983 | 427983 | 2020-08-13 | Imperial | California | 6025 | 9957 | 256 |
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);