ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where cases = 4565 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 15
- Oklahoma 8
- Wisconsin 8
- Indiana 6
- North Carolina 6
- Ohio 6
- Arkansas 5
- Louisiana 5
- New York 5
- Texas 5
- Florida 4
- Montana 4
- Tennessee 4
- West Virginia 4
- Idaho 3
- Puerto Rico 3
- Virginia 3
- Georgia 2
- Illinois 2
- Kansas 2
- Minnesota 2
- Mississippi 2
- Nebraska 2
- North Dakota 2
- South Dakota 2
- California 1
- Kentucky 1
- Maryland 1
- Michigan 1
- Missouri 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492954 | 2492954 | 2022-05-10 | Taylor | West Virginia | 54091 | 4565 | 73 |
2489696 | 2489696 | 2022-05-09 | Taylor | West Virginia | 54091 | 4565 | 73 |
2467138 | 2467138 | 2022-05-03 | Hempstead | Arkansas | 5057 | 4565 | 68 |
2339191 | 2339191 | 2022-03-24 | Morovis | Puerto Rico | 72101 | 4565 | |
2308330 | 2308330 | 2022-03-15 | Buchanan | Iowa | 19019 | 4565 | 57 |
2305079 | 2305079 | 2022-03-14 | Buchanan | Iowa | 19019 | 4565 | 57 |
2301827 | 2301827 | 2022-03-13 | Buchanan | Iowa | 19019 | 4565 | 57 |
2298575 | 2298575 | 2022-03-12 | Buchanan | Iowa | 19019 | 4565 | 57 |
2295323 | 2295323 | 2022-03-11 | Buchanan | Iowa | 19019 | 4565 | 57 |
2292071 | 2292071 | 2022-03-10 | Buchanan | Iowa | 19019 | 4565 | 57 |
2288819 | 2288819 | 2022-03-09 | Buchanan | Iowa | 19019 | 4565 | 57 |
2287228 | 2287228 | 2022-03-08 | Beadle | South Dakota | 46005 | 4565 | 57 |
2283976 | 2283976 | 2022-03-07 | Beadle | South Dakota | 46005 | 4565 | 57 |
2249168 | 2249168 | 2022-02-25 | Sharp | Arkansas | 5135 | 4565 | 97 |
2237628 | 2237628 | 2022-02-21 | Lincoln | Montana | 30053 | 4565 | 79 |
2234377 | 2234377 | 2022-02-20 | Lincoln | Montana | 30053 | 4565 | 79 |
2235892 | 2235892 | 2022-02-20 | Adams | Wisconsin | 55001 | 4565 | 49 |
2231126 | 2231126 | 2022-02-19 | Lincoln | Montana | 30053 | 4565 | 79 |
2232641 | 2232641 | 2022-02-19 | Adams | Wisconsin | 55001 | 4565 | 49 |
2227875 | 2227875 | 2022-02-18 | Lincoln | Montana | 30053 | 4565 | 79 |
2229390 | 2229390 | 2022-02-18 | Adams | Wisconsin | 55001 | 4565 | 49 |
2220305 | 2220305 | 2022-02-16 | Cassia | Idaho | 16031 | 4565 | 51 |
2218607 | 2218607 | 2022-02-15 | Paulding | Ohio | 39125 | 4565 | 69 |
2209521 | 2209521 | 2022-02-12 | Montague | Texas | 48337 | 4565 | 116 |
2182198 | 2182198 | 2022-02-04 | Andrew | Missouri | 29003 | 4565 | 46 |
2179398 | 2179398 | 2022-02-03 | Hertford | North Carolina | 37091 | 4565 | 80 |
2172298 | 2172298 | 2022-02-01 | Hubbard | Minnesota | 27057 | 4565 | 53 |
2165213 | 2165213 | 2022-01-30 | Starke | Indiana | 18149 | 4565 | 92 |
2161958 | 2161958 | 2022-01-29 | Starke | Indiana | 18149 | 4565 | 92 |
2158703 | 2158703 | 2022-01-28 | Starke | Indiana | 18149 | 4565 | 92 |
2152845 | 2152845 | 2022-01-26 | Clay | Mississippi | 28025 | 4565 | 80 |
2111513 | 2111513 | 2022-01-13 | Moca | Puerto Rico | 72099 | 4565 | |
2087579 | 2087579 | 2022-01-06 | Caroline | Maryland | 24011 | 4565 | 57 |
2029002 | 2029002 | 2021-12-19 | East Feliciana | Louisiana | 22037 | 4565 | 145 |
2025751 | 2025751 | 2021-12-18 | East Feliciana | Louisiana | 22037 | 4565 | 145 |
2022500 | 2022500 | 2021-12-17 | East Feliciana | Louisiana | 22037 | 4565 | 145 |
2019980 | 2019980 | 2021-12-16 | Lewis | New York | 36049 | 4565 | 40 |
2020845 | 2020845 | 2021-12-16 | Hockley | Texas | 48219 | 4565 | 139 |
1972993 | 1972993 | 2021-12-02 | Washington | Florida | 12133 | 4565 | 72 |
1974081 | 1974081 | 2021-12-02 | Simpson | Mississippi | 28127 | 4565 | 117 |
1969743 | 1969743 | 2021-12-01 | Washington | Florida | 12133 | 4565 | 72 |
1966493 | 1966493 | 2021-11-30 | Washington | Florida | 12133 | 4565 | 72 |
1926833 | 1926833 | 2021-11-17 | Isle of Wight | Virginia | 51093 | 4565 | 91 |
1897785 | 1897785 | 2021-11-08 | Lincoln | Wisconsin | 55069 | 4565 | 112 |
1883999 | 1883999 | 2021-11-04 | Trujillo Alto | Puerto Rico | 72139 | 4565 | |
1849033 | 1849033 | 2021-10-24 | Green | Wisconsin | 55045 | 4565 | 30 |
1845783 | 1845783 | 2021-10-23 | Green | Wisconsin | 55045 | 4565 | 30 |
1842533 | 1842533 | 2021-10-22 | Green | Wisconsin | 55045 | 4565 | 30 |
1808560 | 1808560 | 2021-10-12 | Dakota | Nebraska | 31043 | 4565 | 82 |
1794056 | 1794056 | 2021-10-08 | Yell | Arkansas | 5149 | 4565 | 76 |
1784072 | 1784072 | 2021-10-04 | Oneida | Wisconsin | 55085 | 4565 | 85 |
1755448 | 1755448 | 2021-09-26 | Bonner | Idaho | 16017 | 4565 | 62 |
1758021 | 1758021 | 2021-09-26 | Randolph | West Virginia | 54083 | 4565 | 28 |
1752200 | 1752200 | 2021-09-25 | Bonner | Idaho | 16017 | 4565 | 62 |
1714960 | 1714960 | 2021-09-13 | Pike | Pennsylvania | 42103 | 4565 | 56 |
1697781 | 1697781 | 2021-09-08 | Morrison | Minnesota | 27097 | 4565 | 62 |
1692929 | 1692929 | 2021-09-06 | Petersburg city | Virginia | 51730 | 4565 | 93 |
1679477 | 1679477 | 2021-09-02 | Henry | Tennessee | 47079 | 4565 | 76 |
1674442 | 1674442 | 2021-09-01 | Steuben | Indiana | 18151 | 4565 | 66 |
1648566 | 1648566 | 2021-08-24 | Wapello | Iowa | 19179 | 4565 | 124 |
1645187 | 1645187 | 2021-08-23 | Miami | Indiana | 18103 | 4565 | 75 |
1645318 | 1645318 | 2021-08-23 | Wapello | Iowa | 19179 | 4565 | 124 |
1642069 | 1642069 | 2021-08-22 | Wapello | Iowa | 19179 | 4565 | 124 |
1638819 | 1638819 | 2021-08-21 | Wapello | Iowa | 19179 | 4565 | 124 |
1635569 | 1635569 | 2021-08-20 | Wapello | Iowa | 19179 | 4565 | 124 |
1632319 | 1632319 | 2021-08-19 | Wapello | Iowa | 19179 | 4565 | 124 |
1629072 | 1629072 | 2021-08-18 | Wapello | Iowa | 19179 | 4565 | 124 |
1614029 | 1614029 | 2021-08-13 | Defiance | Ohio | 39039 | 4565 | 99 |
1560684 | 1560684 | 2021-07-28 | Clinton | Indiana | 18023 | 4565 | 60 |
1530039 | 1530039 | 2021-07-18 | Cocke | Tennessee | 47029 | 4565 | 101 |
1526792 | 1526792 | 2021-07-17 | Cocke | Tennessee | 47029 | 4565 | 101 |
1523545 | 1523545 | 2021-07-16 | Cocke | Tennessee | 47029 | 4565 | 101 |
1489164 | 1489164 | 2021-07-06 | Franklin | Illinois | 17055 | 4565 | 90 |
1462053 | 1462053 | 2021-06-27 | Hill | Texas | 48217 | 4565 | 110 |
1458808 | 1458808 | 2021-06-26 | Hill | Texas | 48217 | 4565 | 110 |
1441721 | 1441721 | 2021-06-21 | Madison | New York | 36053 | 4565 | 89 |
1438476 | 1438476 | 2021-06-20 | Madison | New York | 36053 | 4565 | 89 |
1435229 | 1435229 | 2021-06-19 | Madison | New York | 36053 | 4565 | 89 |
1409493 | 1409493 | 2021-06-11 | Knox | Ohio | 39083 | 4565 | 112 |
1406248 | 1406248 | 2021-06-10 | Knox | Ohio | 39083 | 4565 | 112 |
1403002 | 1403002 | 2021-06-09 | Knox | Ohio | 39083 | 4565 | 112 |
1292439 | 1292439 | 2021-05-06 | Beaufort | North Carolina | 37013 | 4565 | 95 |
1263478 | 1263478 | 2021-04-27 | Delaware | Oklahoma | 40041 | 4565 | 90 |
1260231 | 1260231 | 2021-04-26 | Delaware | Oklahoma | 40041 | 4565 | 90 |
1256984 | 1256984 | 2021-04-25 | Delaware | Oklahoma | 40041 | 4565 | 90 |
1253737 | 1253737 | 2021-04-24 | Delaware | Oklahoma | 40041 | 4565 | 90 |
1250490 | 1250490 | 2021-04-23 | Delaware | Oklahoma | 40041 | 4565 | 90 |
1247243 | 1247243 | 2021-04-22 | Delaware | Oklahoma | 40041 | 4565 | 90 |
1243996 | 1243996 | 2021-04-21 | Delaware | Oklahoma | 40041 | 4565 | 90 |
1237467 | 1237467 | 2021-04-19 | Shelby | Ohio | 39149 | 4565 | 90 |
1235210 | 1235210 | 2021-04-18 | Mercer | West Virginia | 54055 | 4565 | 125 |
1195157 | 1195157 | 2021-04-06 | Stark | North Dakota | 38089 | 4565 | 50 |
1149638 | 1149638 | 2021-03-23 | Vance | North Carolina | 37181 | 4565 | 85 |
1143207 | 1143207 | 2021-03-21 | Williams | North Dakota | 38105 | 4565 | 36 |
1127981 | 1127981 | 2021-03-16 | Cowlitz | Washington | 53015 | 4565 | 72 |
1107338 | 1107338 | 2021-03-10 | Wayne | New York | 36117 | 4565 | 65 |
1048022 | 1048022 | 2021-02-20 | Boyd | Kentucky | 21019 | 4565 | 43 |
1044405 | 1044405 | 2021-02-19 | Jackson | Illinois | 17077 | 4565 | 71 |
1029235 | 1029235 | 2021-02-14 | Dodge | Nebraska | 31053 | 4565 | 52 |
973620 | 973620 | 2021-01-28 | Chippewa | Michigan | 26033 | 4565 | 35 |
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);