ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where cases = 8928 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Oklahoma 8
- Kentucky 5
- Missouri 3
- West Virginia 3
- Arkansas 2
- Georgia 2
- Illinois 2
- Maryland 2
- Mississippi 2
- North Carolina 2
- Pennsylvania 2
- Florida 1
- Guam 1
- Maine 1
- Minnesota 1
- New Hampshire 1
- New Jersey 1
- New York 1
- Ohio 1
- Tennessee 1
- Texas 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2442290 | 2442290 | 2022-04-25 | Carlton | Minnesota | 27017 | 8928 | 96 |
2421090 | 2421090 | 2022-04-18 | Windsor | Vermont | 50027 | 8928 | 50 |
2378968 | 2378968 | 2022-04-05 | Marshall | West Virginia | 54051 | 8928 | 151 |
2375714 | 2375714 | 2022-04-04 | Marshall | West Virginia | 54051 | 8928 | 154 |
2359449 | 2359449 | 2022-03-30 | Marshall | West Virginia | 54051 | 8928 | 154 |
2293565 | 2293565 | 2022-03-10 | Jefferson | Pennsylvania | 42065 | 8928 | 223 |
2241388 | 2241388 | 2022-02-22 | Williams | Ohio | 39171 | 8928 | 155 |
2235601 | 2235601 | 2022-02-20 | Washington | Texas | 48477 | 8928 | 144 |
2215185 | 2215185 | 2022-02-14 | Jackson | North Carolina | 37099 | 8928 | 83 |
2155339 | 2155339 | 2022-01-27 | Montgomery | Illinois | 17135 | 8928 | 98 |
2133385 | 2133385 | 2022-01-20 | Warren | Mississippi | 28149 | 8928 | 184 |
2032899 | 2032899 | 2021-12-20 | Grafton | New Hampshire | 33009 | 8928 | 42 |
2028019 | 2028019 | 2021-12-19 | Mississippi | Arkansas | 5093 | 8928 | 155 |
2015865 | 2015865 | 2021-12-15 | Barren | Kentucky | 21009 | 8928 | 174 |
1963862 | 1963862 | 2021-11-29 | Boyd | Kentucky | 21019 | 8928 | 115 |
1927221 | 1927221 | 2021-11-18 | Crittenden | Arkansas | 5035 | 8928 | 179 |
1879559 | 1879559 | 2021-11-03 | Cecil | Maryland | 24015 | 8928 | 181 |
1818220 | 1818220 | 2021-10-15 | Taney | Missouri | 29213 | 8928 | 151 |
1806148 | 1806148 | 2021-10-11 | Bedford | Tennessee | 47003 | 8928 | 153 |
1765831 | 1765831 | 2021-09-29 | Allegany | Maryland | 24001 | 8928 | 232 |
1619508 | 1619508 | 2021-08-15 | Laurel | Kentucky | 21125 | 8928 | 86 |
1616260 | 1616260 | 2021-08-14 | Laurel | Kentucky | 21125 | 8928 | 86 |
1613011 | 1613011 | 2021-08-13 | Laurel | Kentucky | 21125 | 8928 | 86 |
1581668 | 1581668 | 2021-08-03 | Payne | Oklahoma | 40119 | 8928 | 76 |
1578419 | 1578419 | 2021-08-02 | Payne | Oklahoma | 40119 | 8928 | 76 |
1575171 | 1575171 | 2021-08-01 | Payne | Oklahoma | 40119 | 8928 | 76 |
1571923 | 1571923 | 2021-07-31 | Payne | Oklahoma | 40119 | 8928 | 76 |
1568675 | 1568675 | 2021-07-30 | Payne | Oklahoma | 40119 | 8928 | 76 |
1565427 | 1565427 | 2021-07-29 | Payne | Oklahoma | 40119 | 8928 | 76 |
1562179 | 1562179 | 2021-07-28 | Payne | Oklahoma | 40119 | 8928 | 76 |
1287729 | 1287729 | 2021-05-05 | Fayette | Georgia | 13113 | 8928 | 168 |
1268353 | 1268353 | 2021-04-29 | Unknown | Guam | 8928 | 137 | |
1197049 | 1197049 | 2021-04-07 | Vermilion | Illinois | 17183 | 8928 | 139 |
1191789 | 1191789 | 2021-04-05 | Craven | North Carolina | 37049 | 8928 | 120 |
1168644 | 1168644 | 2021-03-29 | Cass | Missouri | 29037 | 8928 | 98 |
1165396 | 1165396 | 2021-03-28 | Cass | Missouri | 29037 | 8928 | 98 |
1133294 | 1133294 | 2021-03-18 | Putnam | New York | 36079 | 8928 | 88 |
1015760 | 1015760 | 2021-02-10 | York | Maine | 23031 | 8928 | 109 |
974574 | 974574 | 2021-01-28 | Rogers | Oklahoma | 40131 | 8928 | 99 |
892673 | 892673 | 2021-01-03 | Jackson | Mississippi | 28059 | 8928 | 159 |
715017 | 715017 | 2020-11-09 | Chester | Pennsylvania | 42029 | 8928 | 383 |
615838 | 615838 | 2020-10-10 | Chatham | Georgia | 13051 | 8928 | 175 |
237345 | 237345 | 2020-06-14 | Broward | Florida | 12011 | 8928 | 357 |
47272 | 47272 | 2020-04-10 | Bergen | New Jersey | 34003 | 8928 | 390 |
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);