ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where deaths = 2278 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Wisconsin 6
- California 4
- Massachusetts 4
- Connecticut 3
- Ohio 3
- Maryland 2
- New Jersey 2
- New York 2
- Pennsylvania 2
- Georgia 1
- Minnesota 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2441181 | 2441181 | 2022-04-25 | Santa Clara | California | 6085 | 330184 | 2278 |
2437925 | 2437925 | 2022-04-24 | Santa Clara | California | 6085 | 330184 | 2278 |
2434669 | 2434669 | 2022-04-23 | Santa Clara | California | 6085 | 330184 | 2278 |
2431413 | 2431413 | 2022-04-22 | Santa Clara | California | 6085 | 330184 | 2278 |
2399076 | 2399076 | 2022-04-12 | Fulton | Georgia | 13121 | 217859 | 2278 |
2395316 | 2395316 | 2022-04-10 | Milwaukee | Wisconsin | 55079 | 269028 | 2278 |
2392060 | 2392060 | 2022-04-09 | Milwaukee | Wisconsin | 55079 | 269028 | 2278 |
2388804 | 2388804 | 2022-04-08 | Milwaukee | Wisconsin | 55079 | 269028 | 2278 |
2385549 | 2385549 | 2022-04-07 | Milwaukee | Wisconsin | 55079 | 268685 | 2278 |
2382294 | 2382294 | 2022-04-06 | Milwaukee | Wisconsin | 55079 | 268548 | 2278 |
2379039 | 2379039 | 2022-04-05 | Milwaukee | Wisconsin | 55079 | 268488 | 2278 |
2283822 | 2283822 | 2022-03-07 | Montgomery | Pennsylvania | 42091 | 150186 | 2278 |
2280570 | 2280570 | 2022-03-06 | Montgomery | Pennsylvania | 42091 | 150108 | 2278 |
2205280 | 2205280 | 2022-02-11 | Passaic | New Jersey | 34031 | 141107 | 2278 |
2205284 | 2205284 | 2022-02-11 | Union | New Jersey | 34039 | 139105 | 2278 |
2168895 | 2168895 | 2022-01-31 | Baltimore | Maryland | 24005 | 124943 | 2278 |
2165640 | 2165640 | 2022-01-30 | Baltimore | Maryland | 24005 | 124837 | 2278 |
2129996 | 2129996 | 2022-01-19 | Hennepin | Minnesota | 27053 | 247696 | 2278 |
1768185 | 1768185 | 2021-09-30 | Fairfield | Connecticut | 9001 | 110289 | 2278 |
1764936 | 1764936 | 2021-09-29 | Fairfield | Connecticut | 9001 | 110235 | 2278 |
1761687 | 1761687 | 2021-09-28 | Fairfield | Connecticut | 9001 | 110105 | 2278 |
1665162 | 1665162 | 2021-08-29 | Worcester | Massachusetts | 25027 | 81711 | 2278 |
1661914 | 1661914 | 2021-08-28 | Worcester | Massachusetts | 25027 | 81711 | 2278 |
1658666 | 1658666 | 2021-08-27 | Worcester | Massachusetts | 25027 | 81711 | 2278 |
1633511 | 1633511 | 2021-08-19 | Cuyahoga | Ohio | 39035 | 121054 | 2278 |
1630264 | 1630264 | 2021-08-18 | Cuyahoga | Ohio | 39035 | 120790 | 2278 |
1627017 | 1627017 | 2021-08-17 | Cuyahoga | Ohio | 39035 | 120525 | 2278 |
1360610 | 1360610 | 2021-05-27 | Westchester | New York | 36119 | 129270 | 2278 |
1161865 | 1161865 | 2021-03-27 | Essex | Massachusetts | 25009 | 88521 | 2278 |
808720 | 808720 | 2020-12-08 | Nassau | New York | 36059 | 66495 | 2278 |
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);