ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where deaths = 2194 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 12
- New York 5
- Connecticut 3
- Ohio 3
- Tennessee 3
- California 2
- Alabama 1
- Indiana 1
- Maryland 1
- Massachusetts 1
- Michigan 1
- New Jersey 1
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2245776 | 2245776 | 2022-02-24 | Jefferson | Alabama | 1073 | 181577 | 2194 |
2149977 | 2149977 | 2022-01-25 | Union | New Jersey | 34039 | 135824 | 2194 |
2139609 | 2139609 | 2022-01-22 | Baltimore | Maryland | 24005 | 122651 | 2194 |
1830363 | 1830363 | 2021-10-19 | Marion | Indiana | 18097 | 135132 | 2194 |
1825719 | 1825719 | 2021-10-17 | Shelby | Tennessee | 47157 | 144705 | 2194 |
1822470 | 1822470 | 2021-10-16 | Shelby | Tennessee | 47157 | 144592 | 2194 |
1819221 | 1819221 | 2021-10-15 | Shelby | Tennessee | 47157 | 144438 | 2194 |
1755195 | 1755195 | 2021-09-26 | New Haven | Connecticut | 9009 | 101994 | 2194 |
1751947 | 1751947 | 2021-09-25 | New Haven | Connecticut | 9009 | 101994 | 2194 |
1748698 | 1748698 | 2021-09-24 | New Haven | Connecticut | 9009 | 101994 | 2194 |
1449816 | 1449816 | 2021-06-24 | Santa Clara | California | 6085 | 120233 | 2194 |
1446571 | 1446571 | 2021-06-23 | Santa Clara | California | 6085 | 120194 | 2194 |
1406224 | 1406224 | 2021-06-10 | Cuyahoga | Ohio | 39035 | 115505 | 2194 |
1402978 | 1402978 | 2021-06-09 | Cuyahoga | Ohio | 39035 | 115469 | 2194 |
1399733 | 1399733 | 2021-06-08 | Cuyahoga | Ohio | 39035 | 115418 | 2194 |
1288524 | 1288524 | 2021-05-05 | Worcester | Massachusetts | 25027 | 75756 | 2194 |
1231239 | 1231239 | 2021-04-17 | Unknown | Puerto Rico | 5159 | 2194 | |
1169031 | 1169031 | 2021-03-29 | Westchester | New York | 36119 | 118963 | 2194 |
413532 | 413532 | 2020-08-08 | Nassau | New York | 36059 | 43628 | 2194 |
410312 | 410312 | 2020-08-07 | Nassau | New York | 36059 | 43580 | 2194 |
407092 | 407092 | 2020-08-06 | Nassau | New York | 36059 | 43534 | 2194 |
146460 | 146460 | 2020-05-15 | Wayne | Michigan | 26163 | 18902 | 2194 |
111300 | 111300 | 2020-05-03 | Nassau | New York | 36059 | 36780 | 2194 |
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);