ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where deaths = 308 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 9
- Yolo 14
- Sonoma 7
- Kings 5
- Placer 5
- Tulare 5
- Contra Costa 2
- Imperial 2
- Merced 1
- San Francisco 1
state 1
- California · 42 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2337047 | 2337047 | 2022-03-24 | Yolo | California | 6113 | 39374 | 308 |
2333793 | 2333793 | 2022-03-23 | Yolo | California | 6113 | 39349 | 308 |
2327287 | 2327287 | 2022-03-21 | Yolo | California | 6113 | 39300 | 308 |
2324034 | 2324034 | 2022-03-20 | Yolo | California | 6113 | 39251 | 308 |
2320780 | 2320780 | 2022-03-19 | Yolo | California | 6113 | 39251 | 308 |
2317526 | 2317526 | 2022-03-18 | Yolo | California | 6113 | 39251 | 308 |
2314273 | 2314273 | 2022-03-17 | Yolo | California | 6113 | 39244 | 308 |
2311020 | 2311020 | 2022-03-16 | Yolo | California | 6113 | 39230 | 308 |
2307767 | 2307767 | 2022-03-15 | Yolo | California | 6113 | 39210 | 308 |
2304516 | 2304516 | 2022-03-14 | Yolo | California | 6113 | 39170 | 308 |
2301264 | 2301264 | 2022-03-13 | Yolo | California | 6113 | 39133 | 308 |
2298012 | 2298012 | 2022-03-12 | Yolo | California | 6113 | 39133 | 308 |
2294760 | 2294760 | 2022-03-11 | Yolo | California | 6113 | 39133 | 308 |
2291508 | 2291508 | 2022-03-10 | Yolo | California | 6113 | 39124 | 308 |
1803819 | 1803819 | 2021-10-11 | Kings | California | 6031 | 32015 | 308 |
1800570 | 1800570 | 2021-10-10 | Kings | California | 6031 | 31787 | 308 |
1797321 | 1797321 | 2021-10-09 | Kings | California | 6031 | 31787 | 308 |
1794072 | 1794072 | 2021-10-08 | Kings | California | 6031 | 31787 | 308 |
1790824 | 1790824 | 2021-10-07 | Kings | California | 6031 | 31678 | 308 |
1621909 | 1621909 | 2021-08-16 | Placer | California | 6061 | 29253 | 308 |
1618662 | 1618662 | 2021-08-15 | Placer | California | 6061 | 29148 | 308 |
1615414 | 1615414 | 2021-08-14 | Placer | California | 6061 | 29020 | 308 |
1612165 | 1612165 | 2021-08-13 | Placer | California | 6061 | 28889 | 308 |
1608917 | 1608917 | 2021-08-12 | Placer | California | 6061 | 28720 | 308 |
1138138 | 1138138 | 2021-03-20 | Sonoma | California | 6097 | 28943 | 308 |
1134892 | 1134892 | 2021-03-19 | Sonoma | California | 6097 | 28915 | 308 |
1131645 | 1131645 | 2021-03-18 | Sonoma | California | 6097 | 28882 | 308 |
1128397 | 1128397 | 2021-03-17 | Sonoma | California | 6097 | 28850 | 308 |
1125151 | 1125151 | 2021-03-16 | Sonoma | California | 6097 | 28820 | 308 |
1121905 | 1121905 | 2021-03-15 | Sonoma | California | 6097 | 28798 | 308 |
1118658 | 1118658 | 2021-03-14 | Sonoma | California | 6097 | 28762 | 308 |
972585 | 972585 | 2021-01-28 | San Francisco | California | 6075 | 31085 | 308 |
943363 | 943363 | 2021-01-19 | Merced | California | 6047 | 24452 | 308 |
858970 | 858970 | 2020-12-24 | Contra Costa | California | 6013 | 36752 | 308 |
855725 | 855725 | 2020-12-23 | Contra Costa | California | 6013 | 36313 | 308 |
777883 | 777883 | 2020-11-29 | Tulare | California | 6107 | 20701 | 308 |
774638 | 774638 | 2020-11-28 | Tulare | California | 6107 | 20634 | 308 |
771393 | 771393 | 2020-11-27 | Tulare | California | 6107 | 20649 | 308 |
768148 | 768148 | 2020-11-26 | Tulare | California | 6107 | 20550 | 308 |
764902 | 764902 | 2020-11-25 | Tulare | California | 6107 | 20550 | 308 |
537857 | 537857 | 2020-09-16 | Imperial | California | 6025 | 11435 | 308 |
534621 | 534621 | 2020-09-15 | Imperial | California | 6025 | 11392 | 308 |
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);