ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 9238 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 22
- Oklahoma 14
- Mississippi 7
- Arkansas 5
- Utah 4
- West Virginia 4
- Missouri 2
- North Carolina 2
- Pennsylvania 2
- Texas 2
- Wisconsin 2
- Colorado 1
- Illinois 1
- Indiana 1
- Louisiana 1
- Massachusetts 1
- Minnesota 1
- Nebraska 1
- New Hampshire 1
- New York 1
- Ohio 1
- Virginia 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494437 | 2494437 | 2022-05-11 | Morrison | Minnesota | 27097 | 9238 | 105 |
2421596 | 2421596 | 2022-04-19 | Union | Arkansas | 5139 | 9238 | 176 |
2418340 | 2418340 | 2022-04-18 | Union | Arkansas | 5139 | 9238 | 176 |
2415084 | 2415084 | 2022-04-17 | Union | Arkansas | 5139 | 9238 | 175 |
2411828 | 2411828 | 2022-04-16 | Union | Arkansas | 5139 | 9238 | 175 |
2372476 | 2372476 | 2022-04-03 | Preston | West Virginia | 54077 | 9238 | 135 |
2369223 | 2369223 | 2022-04-02 | Preston | West Virginia | 54077 | 9238 | 135 |
2365970 | 2365970 | 2022-04-01 | Preston | West Virginia | 54077 | 9238 | 135 |
2354853 | 2354853 | 2022-03-29 | Carroll | New Hampshire | 33003 | 9238 | 56 |
2311904 | 2311904 | 2022-03-16 | Beauregard | Louisiana | 22011 | 9238 | 141 |
2302442 | 2302442 | 2022-03-13 | Bolivar | Mississippi | 28011 | 9238 | 177 |
2302885 | 2302885 | 2022-03-13 | Franklin | New York | 36033 | 9238 | 44 |
2299190 | 2299190 | 2022-03-12 | Bolivar | Mississippi | 28011 | 9238 | 177 |
2295938 | 2295938 | 2022-03-11 | Bolivar | Mississippi | 28011 | 9238 | 177 |
2292686 | 2292686 | 2022-03-10 | Bolivar | Mississippi | 28011 | 9238 | 177 |
2292778 | 2292778 | 2022-03-10 | Camden | Missouri | 29029 | 9238 | 173 |
2289434 | 2289434 | 2022-03-09 | Bolivar | Mississippi | 28011 | 9238 | 177 |
2286183 | 2286183 | 2022-03-08 | Bolivar | Mississippi | 28011 | 9238 | 177 |
2268389 | 2268389 | 2022-03-02 | Randolph | West Virginia | 54083 | 9238 | 76 |
2247469 | 2247469 | 2022-02-24 | Madison | Nebraska | 31119 | 9238 | 63 |
2236102 | 2236102 | 2022-02-21 | Boone | Arkansas | 5009 | 9238 | 158 |
2217151 | 2217151 | 2022-02-15 | Morgan | Illinois | 17137 | 9238 | 138 |
2175612 | 2175612 | 2022-02-02 | Alcorn | Mississippi | 28003 | 9238 | 132 |
2089562 | 2089562 | 2022-01-06 | Marinette | Wisconsin | 55075 | 9238 | 98 |
1963115 | 1963115 | 2021-11-29 | Eagle | Colorado | 8037 | 9238 | 32 |
1965579 | 1965579 | 2021-11-29 | Harrison | Texas | 48203 | 9238 | 185 |
1945506 | 1945506 | 2021-11-23 | Carter | Oklahoma | 40019 | 9238 | 193 |
1942255 | 1942255 | 2021-11-22 | Carter | Oklahoma | 40019 | 9238 | 193 |
1939005 | 1939005 | 2021-11-21 | Carter | Oklahoma | 40019 | 9238 | 193 |
1935755 | 1935755 | 2021-11-20 | Carter | Oklahoma | 40019 | 9238 | 193 |
1932505 | 1932505 | 2021-11-19 | Carter | Oklahoma | 40019 | 9238 | 193 |
1929254 | 1929254 | 2021-11-18 | Carter | Oklahoma | 40019 | 9238 | 193 |
1926004 | 1926004 | 2021-11-17 | Carter | Oklahoma | 40019 | 9238 | 193 |
1874739 | 1874739 | 2021-11-01 | Iron | Utah | 49021 | 9238 | 57 |
1871490 | 1871490 | 2021-10-31 | Iron | Utah | 49021 | 9238 | 57 |
1868241 | 1868241 | 2021-10-30 | Iron | Utah | 49021 | 9238 | 57 |
1864992 | 1864992 | 2021-10-29 | Iron | Utah | 49021 | 9238 | 57 |
1649666 | 1649666 | 2021-08-24 | Sampson | North Carolina | 37163 | 9238 | 115 |
1561204 | 1561204 | 2021-07-28 | Hampshire | Massachusetts | 25015 | 9238 | 300 |
1545880 | 1545880 | 2021-07-23 | Wayne | Ohio | 39169 | 9238 | 227 |
1504543 | 1504543 | 2021-07-10 | Portsmouth city | Virginia | 51740 | 9238 | 205 |
1429723 | 1429723 | 2021-06-17 | Victoria | Texas | 48469 | 9238 | 223 |
1418650 | 1418650 | 2021-06-14 | Cole | Missouri | 29051 | 9238 | 129 |
1255560 | 1255560 | 2021-04-25 | Kosciusko | Indiana | 18085 | 9238 | 119 |
1195308 | 1195308 | 2021-04-06 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1196289 | 1196289 | 2021-04-06 | Jefferson | Wisconsin | 55055 | 9238 | 127 |
1192060 | 1192060 | 2021-04-05 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1188811 | 1188811 | 2021-04-04 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1185564 | 1185564 | 2021-04-03 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1182317 | 1182317 | 2021-04-02 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1179070 | 1179070 | 2021-04-01 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1175823 | 1175823 | 2021-03-31 | Muskogee | Oklahoma | 40101 | 9238 | 114 |
1036337 | 1036337 | 2021-02-16 | Monroe | Pennsylvania | 42089 | 9238 | 256 |
1032753 | 1032753 | 2021-02-15 | Nash | North Carolina | 37127 | 9238 | 155 |
809906 | 809906 | 2020-12-08 | Benton | Washington | 53005 | 9238 | 151 |
773453 | 773453 | 2020-11-27 | Luzerne | Pennsylvania | 42079 | 9238 | 267 |
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);