ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 7043 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- North Carolina 7
- Minnesota 4
- Virginia 4
- Alabama 3
- Mississippi 3
- New York 3
- Ohio 3
- Arkansas 2
- Missouri 2
- Nebraska 2
- California 1
- Florida 1
- Georgia 1
- Illinois 1
- Indiana 1
- Louisiana 1
- New Mexico 1
- Oregon 1
- South Carolina 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2417892 | 2417892 | 2022-04-17 | Halifax | Virginia | 51083 | 7043 | 156 |
2414636 | 2414636 | 2022-04-16 | Halifax | Virginia | 51083 | 7043 | 156 |
2411380 | 2411380 | 2022-04-15 | Halifax | Virginia | 51083 | 7043 | 156 |
2406507 | 2406507 | 2022-04-14 | Lyon | Minnesota | 27083 | 7043 | 72 |
2403251 | 2403251 | 2022-04-13 | Lyon | Minnesota | 27083 | 7043 | 72 |
2273848 | 2273848 | 2022-03-04 | Hardin | Ohio | 39065 | 7043 | 149 |
2265967 | 2265967 | 2022-03-02 | Decatur | Indiana | 18031 | 7043 | 141 |
2256924 | 2256924 | 2022-02-27 | Covington | Mississippi | 28031 | 7043 | 107 |
2253673 | 2253673 | 2022-02-26 | Covington | Mississippi | 28031 | 7043 | 107 |
2250422 | 2250422 | 2022-02-25 | Covington | Mississippi | 28031 | 7043 | 107 |
2198933 | 2198933 | 2022-02-09 | Montgomery | North Carolina | 37123 | 7043 | 119 |
2124215 | 2124215 | 2022-01-17 | Coshocton | Ohio | 39031 | 7043 | 136 |
2062089 | 2062089 | 2021-12-29 | Madison | Nebraska | 31119 | 7043 | 53 |
2032489 | 2032489 | 2021-12-20 | Morrison | Minnesota | 27097 | 7043 | 84 |
2021379 | 2021379 | 2021-12-17 | Covington | Alabama | 1039 | 7043 | 198 |
1966306 | 1966306 | 2021-11-30 | Lake | California | 6033 | 7043 | 110 |
1964264 | 1964264 | 2021-11-29 | Winona | Minnesota | 27169 | 7043 | 57 |
1961596 | 1961596 | 2021-11-28 | Vance | North Carolina | 37181 | 7043 | 104 |
1958345 | 1958345 | 2021-11-27 | Vance | North Carolina | 37181 | 7043 | 104 |
1955094 | 1955094 | 2021-11-26 | Vance | North Carolina | 37181 | 7043 | 104 |
1951843 | 1951843 | 2021-11-25 | Vance | North Carolina | 37181 | 7043 | 104 |
1948592 | 1948592 | 2021-11-24 | Vance | North Carolina | 37181 | 7043 | 104 |
1830736 | 1830736 | 2021-10-19 | Avoyelles | Louisiana | 22009 | 7043 | 177 |
1792301 | 1792301 | 2021-10-07 | Buffalo | Nebraska | 31019 | 7043 | 62 |
1750287 | 1750287 | 2021-09-24 | Wayne | New York | 36117 | 7043 | 78 |
1594349 | 1594349 | 2021-08-07 | Steuben | New York | 36101 | 7043 | 147 |
1552320 | 1552320 | 2021-07-25 | Hancock | Ohio | 39063 | 7043 | 134 |
1512808 | 1512808 | 2021-07-13 | Joplin | Missouri | 7043 | 115 | |
1423512 | 1423512 | 2021-06-15 | Raleigh | West Virginia | 54081 | 7043 | 93 |
1263187 | 1263187 | 2021-04-27 | Ontario | New York | 36069 | 7043 | 92 |
1251694 | 1251694 | 2021-04-24 | Crawford | Arkansas | 5033 | 7043 | 119 |
1217831 | 1217831 | 2021-04-13 | Rutherford | North Carolina | 37161 | 7043 | 206 |
1163944 | 1163944 | 2021-03-28 | Walker | Alabama | 1127 | 7043 | 274 |
1076613 | 1076613 | 2021-03-01 | Walton | Florida | 12131 | 7043 | 81 |
951886 | 951886 | 2021-01-21 | Jackson | Oregon | 41029 | 7043 | 90 |
922035 | 922035 | 2021-01-12 | St. Francois | Missouri | 29187 | 7043 | 79 |
914639 | 914639 | 2021-01-10 | Vermilion | Illinois | 17183 | 7043 | 98 |
904356 | 904356 | 2021-01-07 | Jefferson | Arkansas | 5069 | 7043 | 133 |
779472 | 779472 | 2020-11-29 | McKinley | New Mexico | 35031 | 7043 | 277 |
773572 | 773572 | 2020-11-27 | Beaufort | South Carolina | 45013 | 7043 | 94 |
722513 | 722513 | 2020-11-12 | Lee | Alabama | 1081 | 7043 | 65 |
722208 | 722208 | 2020-11-11 | Henrico | Virginia | 51087 | 7043 | 243 |
554267 | 554267 | 2020-09-21 | Clayton | Georgia | 13063 | 7043 | 158 |
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);