ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
35 rows where deaths = 179 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
county 9
- Merced 7
- Shasta 7
- El Dorado 6
- San Mateo 4
- Sutter 4
- Tuolumne 3
- Santa Clara 2
- Contra Costa 1
- Sacramento 1
state 1
- California · 35 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2285003 | 2285003 | 2022-03-08 | Tuolumne | California | 6109 | 13126 | 179 |
2281751 | 2281751 | 2022-03-07 | Tuolumne | California | 6109 | 13126 | 179 |
2268740 | 2268740 | 2022-03-03 | Tuolumne | California | 6109 | 12963 | 179 |
2151612 | 2151612 | 2022-01-26 | El Dorado | California | 6017 | 25911 | 179 |
2148360 | 2148360 | 2022-01-25 | El Dorado | California | 6017 | 25700 | 179 |
2145108 | 2145108 | 2022-01-24 | El Dorado | California | 6017 | 25497 | 179 |
2141853 | 2141853 | 2022-01-23 | El Dorado | California | 6017 | 24845 | 179 |
2138598 | 2138598 | 2022-01-22 | El Dorado | California | 6017 | 24845 | 179 |
2135342 | 2135342 | 2022-01-21 | El Dorado | California | 6017 | 24845 | 179 |
1881834 | 1881834 | 2021-11-04 | Sutter | California | 6101 | 14228 | 179 |
1878585 | 1878585 | 2021-11-03 | Sutter | California | 6101 | 14203 | 179 |
1875336 | 1875336 | 2021-11-02 | Sutter | California | 6101 | 14187 | 179 |
1872087 | 1872087 | 2021-11-01 | Sutter | California | 6101 | 14173 | 179 |
1102423 | 1102423 | 2021-03-09 | Shasta | California | 6089 | 11137 | 179 |
1099177 | 1099177 | 2021-03-08 | Shasta | California | 6089 | 11102 | 179 |
1095929 | 1095929 | 2021-03-07 | Shasta | California | 6089 | 11086 | 179 |
1092683 | 1092683 | 2021-03-06 | Shasta | California | 6089 | 11086 | 179 |
1089437 | 1089437 | 2021-03-05 | Shasta | California | 6089 | 11086 | 179 |
1086192 | 1086192 | 2021-03-04 | Shasta | California | 6089 | 11086 | 179 |
1082946 | 1082946 | 2021-03-03 | Shasta | California | 6089 | 11054 | 179 |
826549 | 826549 | 2020-12-14 | San Mateo | California | 6081 | 18584 | 179 |
823302 | 823302 | 2020-12-13 | San Mateo | California | 6081 | 17724 | 179 |
820056 | 820056 | 2020-12-12 | San Mateo | California | 6081 | 17724 | 179 |
816810 | 816810 | 2020-12-11 | San Mateo | California | 6081 | 17176 | 179 |
777853 | 777853 | 2020-11-29 | Merced | California | 6047 | 11688 | 179 |
774608 | 774608 | 2020-11-28 | Merced | California | 6047 | 11550 | 179 |
771363 | 771363 | 2020-11-27 | Merced | California | 6047 | 11537 | 179 |
768118 | 768118 | 2020-11-26 | Merced | California | 6047 | 11537 | 179 |
764872 | 764872 | 2020-11-25 | Merced | California | 6047 | 11537 | 179 |
761627 | 761627 | 2020-11-24 | Merced | California | 6047 | 11460 | 179 |
758382 | 758382 | 2020-11-23 | Merced | California | 6047 | 11388 | 179 |
489333 | 489333 | 2020-09-01 | Contra Costa | California | 6013 | 14035 | 179 |
421559 | 421559 | 2020-08-11 | Sacramento | California | 6067 | 12273 | 179 |
354057 | 354057 | 2020-07-21 | Santa Clara | California | 6085 | 8046 | 179 |
350855 | 350855 | 2020-07-20 | Santa Clara | California | 6085 | 7795 | 179 |
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);