ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where deaths = 2289 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 7
- Connecticut 7
- Georgia 5
- Ohio 4
- Pennsylvania 3
- New York 2
- California 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476715 | 2476715 | 2022-05-05 | Milwaukee | Wisconsin | 55079 | 274254 | 2289 |
2421866 | 2421866 | 2022-04-19 | Fulton | Georgia | 13121 | 218245 | 2289 |
2418610 | 2418610 | 2022-04-18 | Fulton | Georgia | 13121 | 218245 | 2289 |
2415354 | 2415354 | 2022-04-17 | Fulton | Georgia | 13121 | 218237 | 2289 |
2412098 | 2412098 | 2022-04-16 | Fulton | Georgia | 13121 | 218237 | 2289 |
2408842 | 2408842 | 2022-04-15 | Fulton | Georgia | 13121 | 218237 | 2289 |
2306585 | 2306585 | 2022-03-14 | Montgomery | Pennsylvania | 42091 | 150637 | 2289 |
2303334 | 2303334 | 2022-03-13 | Montgomery | Pennsylvania | 42091 | 150609 | 2289 |
2300082 | 2300082 | 2022-03-12 | Montgomery | Pennsylvania | 42091 | 150568 | 2289 |
2094734 | 2094734 | 2022-01-08 | Erie | New York | 36029 | 168530 | 2289 |
1992299 | 1992299 | 2021-12-08 | Fresno | California | 6019 | 158450 | 2289 |
1807177 | 1807177 | 2021-10-12 | Fairfield | Connecticut | 9001 | 111333 | 2289 |
1803926 | 1803926 | 2021-10-11 | Fairfield | Connecticut | 9001 | 111001 | 2289 |
1800677 | 1800677 | 2021-10-10 | Fairfield | Connecticut | 9001 | 111001 | 2289 |
1797428 | 1797428 | 2021-10-09 | Fairfield | Connecticut | 9001 | 111001 | 2289 |
1794179 | 1794179 | 2021-10-08 | Fairfield | Connecticut | 9001 | 111001 | 2289 |
1790931 | 1790931 | 2021-10-07 | Fairfield | Connecticut | 9001 | 110901 | 2289 |
1787682 | 1787682 | 2021-10-06 | Fairfield | Connecticut | 9001 | 110809 | 2289 |
1669245 | 1669245 | 2021-08-30 | Cuyahoga | Ohio | 39035 | 124453 | 2289 |
1665998 | 1665998 | 2021-08-29 | Cuyahoga | Ohio | 39035 | 124150 | 2289 |
1662750 | 1662750 | 2021-08-28 | Cuyahoga | Ohio | 39035 | 123867 | 2289 |
1659502 | 1659502 | 2021-08-27 | Cuyahoga | Ohio | 39035 | 123497 | 2289 |
1415784 | 1415784 | 2021-06-13 | Westchester | New York | 36119 | 129644 | 2289 |
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);