ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57 rows where cases = 9935 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Rhode Island 12
- Michigan 8
- Oklahoma 7
- Alabama 5
- Ohio 4
- Georgia 3
- North Carolina 3
- Wisconsin 3
- Kansas 2
- California 1
- Colorado 1
- Illinois 1
- Louisiana 1
- Mississippi 1
- Nebraska 1
- New Mexico 1
- New York 1
- Puerto Rico 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490983 | 2490983 | 2022-05-10 | Vernon | Louisiana | 22115 | 9935 | 191 |
2445474 | 2445474 | 2022-04-26 | Delta | Michigan | 26041 | 9935 | 157 |
2442218 | 2442218 | 2022-04-25 | Delta | Michigan | 26041 | 9935 | 157 |
2438962 | 2438962 | 2022-04-24 | Delta | Michigan | 26041 | 9935 | 157 |
2435706 | 2435706 | 2022-04-23 | Delta | Michigan | 26041 | 9935 | 157 |
2432450 | 2432450 | 2022-04-22 | Delta | Michigan | 26041 | 9935 | 157 |
2429194 | 2429194 | 2022-04-21 | Delta | Michigan | 26041 | 9935 | 157 |
2425938 | 2425938 | 2022-04-20 | Delta | Michigan | 26041 | 9935 | 157 |
2299627 | 2299627 | 2022-03-12 | Columbia | New York | 36021 | 9935 | 140 |
2285714 | 2285714 | 2022-03-08 | Lyon | Kansas | 20111 | 9935 | 115 |
2286511 | 2286511 | 2022-03-08 | Scotts Bluff | Nebraska | 31157 | 9935 | 102 |
2282462 | 2282462 | 2022-03-07 | Lyon | Kansas | 20111 | 9935 | 115 |
2269129 | 2269129 | 2022-03-03 | Fulton | Illinois | 17057 | 9935 | 133 |
2223039 | 2223039 | 2022-02-17 | Russell | Alabama | 1113 | 9935 | 77 |
2218679 | 2218679 | 2022-02-15 | Mayes | Oklahoma | 40097 | 9935 | 144 |
2215428 | 2215428 | 2022-02-14 | Mayes | Oklahoma | 40097 | 9935 | 144 |
2212177 | 2212177 | 2022-02-13 | Mayes | Oklahoma | 40097 | 9935 | 144 |
2208924 | 2208924 | 2022-02-12 | Mayes | Oklahoma | 40097 | 9935 | 144 |
2205671 | 2205671 | 2022-02-11 | Mayes | Oklahoma | 40097 | 9935 | 144 |
2202418 | 2202418 | 2022-02-10 | Mayes | Oklahoma | 40097 | 9935 | 144 |
2199164 | 2199164 | 2022-02-09 | Mayes | Oklahoma | 40097 | 9935 | 144 |
2192567 | 2192567 | 2022-02-07 | Logan | Ohio | 39091 | 9935 | 151 |
2186359 | 2186359 | 2022-02-05 | Vega Baja | Puerto Rico | 72145 | 9935 | |
2098069 | 2098069 | 2022-01-09 | Granville | North Carolina | 37077 | 9935 | 107 |
2092894 | 2092894 | 2022-01-08 | Dale | Alabama | 1045 | 9935 | 198 |
2094817 | 2094817 | 2022-01-08 | Granville | North Carolina | 37077 | 9935 | 107 |
2091565 | 2091565 | 2022-01-07 | Granville | North Carolina | 37077 | 9935 | 107 |
2072248 | 2072248 | 2022-01-01 | Seneca | Ohio | 39147 | 9935 | 188 |
2068997 | 2068997 | 2021-12-31 | Seneca | Ohio | 39147 | 9935 | 188 |
1741311 | 1741311 | 2021-09-21 | Coryell | Texas | 48099 | 9935 | 123 |
1649827 | 1649827 | 2021-08-24 | Wayne | Ohio | 39169 | 9935 | 230 |
1609153 | 1609153 | 2021-08-12 | Glynn | Georgia | 13127 | 9935 | 186 |
1576174 | 1576174 | 2021-08-01 | St. Croix | Wisconsin | 55109 | 9935 | 72 |
1572926 | 1572926 | 2021-07-31 | St. Croix | Wisconsin | 55109 | 9935 | 72 |
1569678 | 1569678 | 2021-07-30 | St. Croix | Wisconsin | 55109 | 9935 | 72 |
1420396 | 1420396 | 2021-06-15 | Cullman | Alabama | 1043 | 9935 | 201 |
1362170 | 1362170 | 2021-05-28 | Napa | California | 6055 | 9935 | 82 |
1352685 | 1352685 | 2021-05-25 | Jackson | Georgia | 13157 | 9935 | 152 |
1348139 | 1348139 | 2021-05-23 | Washington | Rhode Island | 44009 | 9935 | 169 |
1344891 | 1344891 | 2021-05-22 | Washington | Rhode Island | 44009 | 9935 | 169 |
1341643 | 1341643 | 2021-05-21 | Washington | Rhode Island | 44009 | 9935 | 169 |
1338395 | 1338395 | 2021-05-20 | Washington | Rhode Island | 44009 | 9935 | 169 |
1335148 | 1335148 | 2021-05-19 | Washington | Rhode Island | 44009 | 9935 | 169 |
1331901 | 1331901 | 2021-05-18 | Washington | Rhode Island | 44009 | 9935 | 169 |
1328654 | 1328654 | 2021-05-17 | Washington | Rhode Island | 44009 | 9935 | 169 |
1325408 | 1325408 | 2021-05-16 | Washington | Rhode Island | 44009 | 9935 | 169 |
1322162 | 1322162 | 2021-05-15 | Washington | Rhode Island | 44009 | 9935 | 169 |
1318916 | 1318916 | 2021-05-14 | Washington | Rhode Island | 44009 | 9935 | 169 |
1315668 | 1315668 | 2021-05-13 | Washington | Rhode Island | 44009 | 9935 | 169 |
1312422 | 1312422 | 2021-05-12 | Washington | Rhode Island | 44009 | 9935 | 169 |
1284079 | 1284079 | 2021-05-04 | Limestone | Alabama | 1083 | 9935 | 150 |
1280832 | 1280832 | 2021-05-03 | Limestone | Alabama | 1083 | 9935 | 150 |
1259516 | 1259516 | 2021-04-26 | Lee | Mississippi | 28081 | 9935 | 171 |
1243114 | 1243114 | 2021-04-21 | Lenawee | Michigan | 26091 | 9935 | 148 |
1120262 | 1120262 | 2021-03-14 | Santa Fe | New Mexico | 35049 | 9935 | 140 |
1099443 | 1099443 | 2021-03-08 | Newton | Georgia | 13217 | 9935 | 204 |
599459 | 599459 | 2020-10-05 | Arapahoe | Colorado | 8005 | 9935 | 374 |
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);