ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 7083 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2452976 | 2452976 | 2022-04-28 | Lincoln | Oregon | 41041 | 7083 | 85 |
2450452 | 2450452 | 2022-04-27 | Halifax | Virginia | 51083 | 7083 | 159 |
2395899 | 2395899 | 2022-04-11 | Toombs | Georgia | 13279 | 7083 | 199 |
2376467 | 2376467 | 2022-04-05 | Fayette | Illinois | 17051 | 7083 | 104 |
2373215 | 2373215 | 2022-04-04 | Fayette | Illinois | 17051 | 7083 | 104 |
2356948 | 2356948 | 2022-03-30 | Fayette | Illinois | 17051 | 7083 | 104 |
2333562 | 2333562 | 2022-03-23 | Clarke | Alabama | 1025 | 7083 | 98 |
2330923 | 2330923 | 2022-03-22 | Fayette | Illinois | 17051 | 7083 | 103 |
2272942 | 2272942 | 2022-03-04 | Hancock | Maine | 23009 | 7083 | 77 |
2266778 | 2266778 | 2022-03-02 | Dunklin | Missouri | 29069 | 7083 | 110 |
2225229 | 2225229 | 2022-02-17 | Jefferson | Oregon | 41031 | 7083 | 78 |
2225658 | 2225658 | 2022-02-17 | Cooke | Texas | 48097 | 7083 | 126 |
2213713 | 2213713 | 2022-02-14 | Lumpkin | Georgia | 13187 | 7083 | 119 |
2160783 | 2160783 | 2022-01-28 | Upshur | Texas | 48459 | 7083 | 164 |
2023725 | 2023725 | 2021-12-17 | Guaynabo | Puerto Rico | 72061 | 7083 | |
2009522 | 2009522 | 2021-12-13 | St. Bernard | Louisiana | 22087 | 7083 | 98 |
1990253 | 1990253 | 2021-12-07 | Steele | Minnesota | 27147 | 7083 | 34 |
1987503 | 1987503 | 2021-12-06 | Washington | New York | 36115 | 7083 | 84 |
1921157 | 1921157 | 2021-11-16 | Bingham | Idaho | 16011 | 7083 | 126 |
1919884 | 1919884 | 2021-11-15 | Cheatham | Tennessee | 47021 | 7083 | 75 |
1853393 | 1853393 | 2021-10-26 | Floyd | Kentucky | 21071 | 7083 | 111 |
1805297 | 1805297 | 2021-10-11 | Buffalo | Nebraska | 31019 | 7083 | 62 |
1802048 | 1802048 | 2021-10-10 | Buffalo | Nebraska | 31019 | 7083 | 62 |
1798799 | 1798799 | 2021-10-09 | Buffalo | Nebraska | 31019 | 7083 | 62 |
1795550 | 1795550 | 2021-10-08 | Buffalo | Nebraska | 31019 | 7083 | 62 |
1778876 | 1778876 | 2021-10-03 | Barry | Michigan | 26015 | 7083 | 76 |
1775626 | 1775626 | 2021-10-02 | Barry | Michigan | 26015 | 7083 | 76 |
1772376 | 1772376 | 2021-10-01 | Barry | Michigan | 26015 | 7083 | 76 |
1758881 | 1758881 | 2021-09-27 | Lawrence | Indiana | 18093 | 7083 | 157 |
1614688 | 1614688 | 2021-08-13 | Hunt | Texas | 48231 | 7083 | 185 |
1589344 | 1589344 | 2021-08-06 | Greene | Arkansas | 5055 | 7083 | 82 |
1575507 | 1575507 | 2021-08-01 | Cumberland | Tennessee | 47035 | 7083 | 143 |
1572259 | 1572259 | 2021-07-31 | Cumberland | Tennessee | 47035 | 7083 | 143 |
1569011 | 1569011 | 2021-07-30 | Cumberland | Tennessee | 47035 | 7083 | 143 |
1544936 | 1544936 | 2021-07-23 | Allegany | Maryland | 24001 | 7083 | 212 |
1355829 | 1355829 | 2021-05-26 | Monroe | Florida | 12087 | 7083 | 50 |
1202917 | 1202917 | 2021-04-09 | Walker | Alabama | 1127 | 7083 | 275 |
1148155 | 1148155 | 2021-03-23 | Rockdale | Georgia | 13247 | 7083 | 160 |
1029325 | 1029325 | 2021-02-14 | Merrimack | New Hampshire | 33013 | 7083 | 103 |
999539 | 999539 | 2021-02-05 | Carroll | Maryland | 24013 | 7083 | 200 |
858873 | 858873 | 2020-12-24 | Apache | Arizona | 4001 | 7083 | 223 |
850890 | 850890 | 2020-12-21 | Broome | New York | 36007 | 7083 | 189 |
424788 | 424788 | 2020-08-12 | Santa Barbara | California | 6083 | 7083 | 73 |
336405 | 336405 | 2020-07-15 | Morris | New Jersey | 34027 | 7083 | 824 |
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);