ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where cases = 3813 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 17
- Georgia 10
- Arkansas 9
- Louisiana 8
- Tennessee 8
- Ohio 7
- Indiana 6
- Kentucky 6
- North Carolina 6
- Minnesota 5
- Wisconsin 5
- Missouri 4
- Puerto Rico 4
- Texas 4
- Washington 4
- West Virginia 4
- Oklahoma 3
- Pennsylvania 3
- Vermont 3
- Alabama 2
- California 2
- Michigan 2
- Mississippi 2
- New York 2
- Virginia 2
- Florida 1
- New Hampshire 1
- New Mexico 1
- North Dakota 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467133 | 2467133 | 2022-05-03 | Franklin | Arkansas | 5047 | 3813 | 73 |
2463878 | 2463878 | 2022-05-02 | Franklin | Arkansas | 5047 | 3813 | 73 |
2460622 | 2460622 | 2022-05-01 | Franklin | Arkansas | 5047 | 3813 | 73 |
2457366 | 2457366 | 2022-04-30 | Franklin | Arkansas | 5047 | 3813 | 73 |
2454110 | 2454110 | 2022-04-29 | Franklin | Arkansas | 5047 | 3813 | 73 |
2450854 | 2450854 | 2022-04-28 | Franklin | Arkansas | 5047 | 3813 | 73 |
2447598 | 2447598 | 2022-04-27 | Franklin | Arkansas | 5047 | 3813 | 73 |
2444342 | 2444342 | 2022-04-26 | Franklin | Arkansas | 5047 | 3813 | 73 |
2376733 | 2376733 | 2022-04-05 | Winneshiek | Iowa | 19191 | 3813 | 49 |
2373481 | 2373481 | 2022-04-04 | Winneshiek | Iowa | 19191 | 3813 | 49 |
2370228 | 2370228 | 2022-04-03 | Winneshiek | Iowa | 19191 | 3813 | 49 |
2366975 | 2366975 | 2022-04-02 | Winneshiek | Iowa | 19191 | 3813 | 49 |
2363722 | 2363722 | 2022-04-01 | Winneshiek | Iowa | 19191 | 3813 | 49 |
2360468 | 2360468 | 2022-03-31 | Winneshiek | Iowa | 19191 | 3813 | 49 |
2357214 | 2357214 | 2022-03-30 | Winneshiek | Iowa | 19191 | 3813 | 49 |
2349483 | 2349483 | 2022-03-27 | Lamoille | Vermont | 50015 | 3813 | 17 |
2346230 | 2346230 | 2022-03-26 | Lamoille | Vermont | 50015 | 3813 | 17 |
2342977 | 2342977 | 2022-03-25 | Lamoille | Vermont | 50015 | 3813 | 17 |
2310471 | 2310471 | 2022-03-15 | Buckingham | Virginia | 51029 | 3813 | 55 |
2283490 | 2283490 | 2022-03-07 | Polk | North Carolina | 37149 | 3813 | 52 |
2279332 | 2279332 | 2022-03-06 | Magoffin | Kentucky | 21153 | 3813 | 41 |
2276079 | 2276079 | 2022-03-05 | Magoffin | Kentucky | 21153 | 3813 | 41 |
2272826 | 2272826 | 2022-03-04 | Magoffin | Kentucky | 21153 | 3813 | 41 |
2262877 | 2262877 | 2022-03-01 | Tama | Iowa | 19171 | 3813 | 86 |
2259626 | 2259626 | 2022-02-28 | Tama | Iowa | 19171 | 3813 | 86 |
2256375 | 2256375 | 2022-02-27 | Tama | Iowa | 19171 | 3813 | 86 |
2253124 | 2253124 | 2022-02-26 | Tama | Iowa | 19171 | 3813 | 86 |
2249873 | 2249873 | 2022-02-25 | Tama | Iowa | 19171 | 3813 | 86 |
2246622 | 2246622 | 2022-02-24 | Tama | Iowa | 19171 | 3813 | 86 |
2243371 | 2243371 | 2022-02-23 | Tama | Iowa | 19171 | 3813 | 86 |
2162684 | 2162684 | 2022-01-29 | Benton | Missouri | 29015 | 3813 | 83 |
2150738 | 2150738 | 2022-01-25 | Humphreys | Tennessee | 47085 | 3813 | 61 |
2147486 | 2147486 | 2022-01-24 | Humphreys | Tennessee | 47085 | 3813 | 61 |
2143053 | 2143053 | 2022-01-23 | Roseau | Minnesota | 27135 | 3813 | 38 |
2144232 | 2144232 | 2022-01-23 | Humphreys | Tennessee | 47085 | 3813 | 61 |
2139798 | 2139798 | 2022-01-22 | Roseau | Minnesota | 27135 | 3813 | 38 |
2140977 | 2140977 | 2022-01-22 | Humphreys | Tennessee | 47085 | 3813 | 61 |
2136542 | 2136542 | 2022-01-21 | Roseau | Minnesota | 27135 | 3813 | 38 |
2137721 | 2137721 | 2022-01-21 | Humphreys | Tennessee | 47085 | 3813 | 61 |
2134467 | 2134467 | 2022-01-20 | Humphreys | Tennessee | 47085 | 3813 | 61 |
2131215 | 2131215 | 2022-01-19 | Humphreys | Tennessee | 47085 | 3813 | 61 |
2121247 | 2121247 | 2022-01-16 | Guayama | Puerto Rico | 72057 | 3813 | |
2121269 | 2121269 | 2022-01-16 | Morovis | Puerto Rico | 72101 | 3813 | |
2103401 | 2103401 | 2022-01-11 | Rush | Indiana | 18139 | 3813 | 36 |
2086337 | 2086337 | 2022-01-05 | Vilas | Wisconsin | 55125 | 3813 | 70 |
2067023 | 2067023 | 2021-12-31 | Ouachita | Arkansas | 5103 | 3813 | 91 |
2018516 | 2018516 | 2021-12-16 | Burke | Georgia | 13033 | 3813 | 86 |
2007070 | 2007070 | 2021-12-12 | Martin | North Carolina | 37117 | 3813 | 75 |
2003819 | 2003819 | 2021-12-11 | Martin | North Carolina | 37117 | 3813 | 75 |
2000568 | 2000568 | 2021-12-10 | Martin | North Carolina | 37117 | 3813 | 75 |
1985143 | 1985143 | 2021-12-05 | Milam | Texas | 48331 | 3813 | 90 |
1944932 | 1944932 | 2021-11-23 | Randolph | Missouri | 29175 | 3813 | 79 |
1919444 | 1919444 | 2021-11-15 | Holmes | Ohio | 39075 | 3813 | 132 |
1908676 | 1908676 | 2021-11-12 | McCreary | Kentucky | 21147 | 3813 | 59 |
1904808 | 1904808 | 2021-11-11 | Harris | Georgia | 13145 | 3813 | 92 |
1905427 | 1905427 | 2021-11-11 | McCreary | Kentucky | 21147 | 3813 | 59 |
1901558 | 1901558 | 2021-11-10 | Harris | Georgia | 13145 | 3813 | 92 |
1898308 | 1898308 | 2021-11-09 | Harris | Georgia | 13145 | 3813 | 90 |
1896466 | 1896466 | 2021-11-08 | Lewis | New York | 36049 | 3813 | 39 |
1879117 | 1879117 | 2021-11-03 | Posey | Indiana | 18129 | 3813 | 44 |
1869123 | 1869123 | 2021-10-31 | Tattnall | Georgia | 13267 | 3813 | 106 |
1865874 | 1865874 | 2021-10-30 | Tattnall | Georgia | 13267 | 3813 | 106 |
1862625 | 1862625 | 2021-10-29 | Tattnall | Georgia | 13267 | 3813 | 106 |
1847016 | 1847016 | 2021-10-24 | Plaquemines | Louisiana | 22075 | 3813 | 40 |
1843766 | 1843766 | 2021-10-23 | Plaquemines | Louisiana | 22075 | 3813 | 40 |
1840516 | 1840516 | 2021-10-22 | Plaquemines | Louisiana | 22075 | 3813 | 40 |
1826228 | 1826228 | 2021-10-17 | Jackson | West Virginia | 54035 | 3813 | 79 |
1780739 | 1780739 | 2021-10-03 | Hancock | West Virginia | 54029 | 3813 | 99 |
1743451 | 1743451 | 2021-09-22 | Miller | Missouri | 29131 | 3813 | 73 |
1675622 | 1675622 | 2021-09-01 | Macon | North Carolina | 37113 | 3813 | 44 |
1632522 | 1632522 | 2021-08-19 | Muhlenberg | Kentucky | 21177 | 3813 | 73 |
1629322 | 1629322 | 2021-08-18 | De Soto | Louisiana | 22031 | 3813 | 89 |
1619627 | 1619627 | 2021-08-15 | West Baton Rouge | Louisiana | 22121 | 3813 | 66 |
1616379 | 1616379 | 2021-08-14 | West Baton Rouge | Louisiana | 22121 | 3813 | 66 |
1613130 | 1613130 | 2021-08-13 | West Baton Rouge | Louisiana | 22121 | 3813 | 66 |
1559152 | 1559152 | 2021-07-27 | Colleton | South Carolina | 45029 | 3813 | 133 |
1540495 | 1540495 | 2021-07-22 | Chambers | Alabama | 1017 | 3813 | 124 |
1531514 | 1531514 | 2021-07-19 | Putnam | Indiana | 18133 | 3813 | 62 |
1508203 | 1508203 | 2021-07-12 | Amador | California | 6005 | 3813 | 47 |
1490369 | 1490369 | 2021-07-06 | Rio Arriba | New Mexico | 35039 | 3813 | 80 |
1477853 | 1477853 | 2021-07-02 | McKean | Pennsylvania | 42083 | 3813 | 72 |
1411489 | 1411489 | 2021-06-12 | Lee | Iowa | 19111 | 3813 | 56 |
1404998 | 1404998 | 2021-06-10 | Lee | Iowa | 19111 | 3813 | 56 |
1393059 | 1393059 | 2021-06-06 | Tioga | New York | 36107 | 3813 | 63 |
1371642 | 1371642 | 2021-05-30 | Oneida | Wisconsin | 55085 | 3813 | 77 |
1368396 | 1368396 | 2021-05-29 | Oneida | Wisconsin | 55085 | 3813 | 77 |
1365150 | 1365150 | 2021-05-28 | Oneida | Wisconsin | 55085 | 3813 | 77 |
1344259 | 1344259 | 2021-05-22 | Cheshire | New Hampshire | 33005 | 3813 | 33 |
1334861 | 1334861 | 2021-05-19 | Preble | Ohio | 39135 | 3813 | 99 |
1331614 | 1331614 | 2021-05-18 | Preble | Ohio | 39135 | 3813 | 99 |
1328367 | 1328367 | 2021-05-17 | Preble | Ohio | 39135 | 3813 | 98 |
1316150 | 1316150 | 2021-05-13 | Sanpete | Utah | 49039 | 3813 | 22 |
1270190 | 1270190 | 2021-04-29 | Ponce | Puerto Rico | 72113 | 3813 | |
1265818 | 1265818 | 2021-04-28 | Delta | Michigan | 26041 | 3813 | 88 |
1263635 | 1263635 | 2021-04-27 | Wayne | Pennsylvania | 42127 | 3813 | 77 |
1249058 | 1249058 | 2021-04-23 | Huntington | Indiana | 18069 | 3813 | 82 |
1238995 | 1238995 | 2021-04-20 | Chattahoochee | Georgia | 13053 | 3813 | 15 |
1167013 | 1167013 | 2021-03-28 | Ohio | West Virginia | 54069 | 3813 | 77 |
1153859 | 1153859 | 2021-03-24 | Franklin | Virginia | 51067 | 3813 | 71 |
1121502 | 1121502 | 2021-03-14 | Lewis | Washington | 53041 | 3813 | 50 |
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);