ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where cases = 3855 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 15
- Georgia 12
- Kentucky 9
- Wisconsin 8
- Indiana 7
- Pennsylvania 7
- Texas 6
- North Carolina 5
- Illinois 4
- Louisiana 4
- Minnesota 4
- Tennessee 4
- Arkansas 3
- Michigan 3
- Nebraska 3
- New York 3
- Ohio 3
- Puerto Rico 3
- West Virginia 3
- Missouri 2
- New Hampshire 2
- South Carolina 2
- Virginia 2
- Wyoming 2
- Colorado 1
- Mississippi 1
- New Jersey 1
- New Mexico 1
- Oklahoma 1
- Rhode Island 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493002 | 2493002 | 2022-05-10 | Marquette | Wisconsin | 55077 | 3855 | 61 |
2376722 | 2376722 | 2022-04-05 | Tama | Iowa | 19171 | 3855 | 90 |
2373470 | 2373470 | 2022-04-04 | Tama | Iowa | 19171 | 3855 | 90 |
2370217 | 2370217 | 2022-04-03 | Tama | Iowa | 19171 | 3855 | 90 |
2366964 | 2366964 | 2022-04-02 | Tama | Iowa | 19171 | 3855 | 90 |
2363711 | 2363711 | 2022-04-01 | Tama | Iowa | 19171 | 3855 | 90 |
2360457 | 2360457 | 2022-03-31 | Tama | Iowa | 19171 | 3855 | 90 |
2362523 | 2362523 | 2022-03-31 | Buckingham | Virginia | 51029 | 3855 | 56 |
2357203 | 2357203 | 2022-03-30 | Tama | Iowa | 19171 | 3855 | 90 |
2308186 | 2308186 | 2022-03-15 | Massac | Illinois | 17127 | 3855 | 69 |
2304935 | 2304935 | 2022-03-14 | Massac | Illinois | 17127 | 3855 | 69 |
2299583 | 2299583 | 2022-03-12 | Unknown | New Jersey | 3855 | 0 | |
2233132 | 2233132 | 2022-02-20 | Banks | Georgia | 13011 | 3855 | 79 |
2229881 | 2229881 | 2022-02-19 | Banks | Georgia | 13011 | 3855 | 79 |
2226630 | 2226630 | 2022-02-18 | Banks | Georgia | 13011 | 3855 | 79 |
2223453 | 2223453 | 2022-02-17 | Jeff Davis | Georgia | 13161 | 3855 | 66 |
2225320 | 2225320 | 2022-02-17 | Aguas Buenas | Puerto Rico | 72007 | 3855 | |
2206212 | 2206212 | 2022-02-11 | Houston | Texas | 48225 | 3855 | 100 |
2194540 | 2194540 | 2022-02-08 | Fayette | Iowa | 19065 | 3855 | 68 |
2196952 | 2196952 | 2022-02-08 | Lincoln | Wyoming | 56023 | 3855 | 28 |
2191286 | 2191286 | 2022-02-07 | Fayette | Iowa | 19065 | 3855 | 68 |
2188033 | 2188033 | 2022-02-06 | Fayette | Iowa | 19065 | 3855 | 68 |
2184780 | 2184780 | 2022-02-05 | Fayette | Iowa | 19065 | 3855 | 68 |
2181528 | 2181528 | 2022-02-04 | Fayette | Iowa | 19065 | 3855 | 68 |
2178277 | 2178277 | 2022-02-03 | Fayette | Iowa | 19065 | 3855 | 68 |
2175024 | 2175024 | 2022-02-02 | Fayette | Iowa | 19065 | 3855 | 68 |
2134249 | 2134249 | 2022-01-20 | Coamo | Puerto Rico | 72043 | 3855 | |
2100804 | 2100804 | 2022-01-10 | Clay | Mississippi | 28025 | 3855 | 78 |
2091199 | 2091199 | 2022-01-07 | Perry | Missouri | 29157 | 3855 | 41 |
2076776 | 2076776 | 2022-01-03 | Ouachita | Arkansas | 5103 | 3855 | 91 |
2066798 | 2066798 | 2021-12-30 | Langlade | Wisconsin | 55067 | 3855 | 66 |
1973065 | 1973065 | 2021-12-02 | Harris | Georgia | 13145 | 3855 | 95 |
1966625 | 1966625 | 2021-11-30 | Tattnall | Georgia | 13267 | 3855 | 114 |
1966895 | 1966895 | 2021-11-30 | Washington | Indiana | 18175 | 3855 | 56 |
1939970 | 1939970 | 2021-11-21 | Mason | West Virginia | 54053 | 3855 | 61 |
1924347 | 1924347 | 2021-11-17 | Pike | Georgia | 13231 | 3855 | 70 |
1907569 | 1907569 | 2021-11-11 | Waushara | Wisconsin | 55137 | 3855 | 54 |
1901865 | 1901865 | 2021-11-10 | Posey | Indiana | 18129 | 3855 | 44 |
1830884 | 1830884 | 2021-10-19 | Houghton | Michigan | 26061 | 3855 | 55 |
1832726 | 1832726 | 2021-10-19 | Jackson | West Virginia | 54035 | 3855 | 80 |
1827105 | 1827105 | 2021-10-18 | Jennings | Indiana | 18079 | 3855 | 62 |
1827635 | 1827635 | 2021-10-18 | Houghton | Michigan | 26061 | 3855 | 55 |
1791996 | 1791996 | 2021-10-07 | Mille Lacs | Minnesota | 27095 | 3855 | 64 |
1733182 | 1733182 | 2021-09-19 | Grayson | Kentucky | 21085 | 3855 | 69 |
1733223 | 1733223 | 2021-09-19 | Mercer | Kentucky | 21167 | 3855 | 59 |
1729932 | 1729932 | 2021-09-18 | Grayson | Kentucky | 21085 | 3855 | 69 |
1729973 | 1729973 | 2021-09-18 | Mercer | Kentucky | 21167 | 3855 | 59 |
1726682 | 1726682 | 2021-09-17 | Grayson | Kentucky | 21085 | 3855 | 69 |
1726723 | 1726723 | 2021-09-17 | Mercer | Kentucky | 21167 | 3855 | 59 |
1724293 | 1724293 | 2021-09-16 | Wyoming | New York | 36121 | 3855 | 54 |
1664991 | 1664991 | 2021-08-29 | Logan | Kentucky | 21141 | 3855 | 77 |
1661743 | 1661743 | 2021-08-28 | Logan | Kentucky | 21141 | 3855 | 77 |
1658495 | 1658495 | 2021-08-27 | Logan | Kentucky | 21141 | 3855 | 77 |
1609236 | 1609236 | 2021-08-12 | Upson | Georgia | 13293 | 3855 | 134 |
1604651 | 1604651 | 2021-08-10 | Marion | South Carolina | 45067 | 3855 | 108 |
1591943 | 1591943 | 2021-08-06 | Hopkins | Texas | 48223 | 3855 | 114 |
1585014 | 1585014 | 2021-08-04 | McKean | Pennsylvania | 42083 | 3855 | 75 |
1581764 | 1581764 | 2021-08-03 | McKean | Pennsylvania | 42083 | 3855 | 75 |
1578515 | 1578515 | 2021-08-02 | McKean | Pennsylvania | 42083 | 3855 | 75 |
1575267 | 1575267 | 2021-08-01 | McKean | Pennsylvania | 42083 | 3855 | 75 |
1554245 | 1554245 | 2021-07-26 | Putnam | Indiana | 18133 | 3855 | 62 |
1553424 | 1553424 | 2021-07-25 | Oneida | Wisconsin | 55085 | 3855 | 79 |
1550177 | 1550177 | 2021-07-24 | Oneida | Wisconsin | 55085 | 3855 | 79 |
1546930 | 1546930 | 2021-07-23 | Oneida | Wisconsin | 55085 | 3855 | 79 |
1532578 | 1532578 | 2021-07-19 | Rio Arriba | New Mexico | 35039 | 3855 | 80 |
1503834 | 1503834 | 2021-07-10 | Perry | Pennsylvania | 42099 | 3855 | 101 |
1500588 | 1500588 | 2021-07-09 | Perry | Pennsylvania | 42099 | 3855 | 101 |
1476401 | 1476401 | 2021-07-02 | Lee | Iowa | 19111 | 3855 | 57 |
1473885 | 1473885 | 2021-07-01 | Polk | Missouri | 29167 | 3855 | 42 |
1435486 | 1435486 | 2021-06-19 | Preble | Ohio | 39135 | 3855 | 105 |
1420516 | 1420516 | 2021-06-15 | Independence | Arkansas | 5063 | 3855 | 124 |
1401642 | 1401642 | 2021-06-09 | Jasper | Indiana | 18073 | 3855 | 55 |
1383415 | 1383415 | 2021-06-03 | Scotland | North Carolina | 37165 | 3855 | 87 |
1363737 | 1363737 | 2021-05-28 | Cheshire | New Hampshire | 33005 | 3855 | 34 |
1342591 | 1342591 | 2021-05-22 | Boone | Arkansas | 5009 | 3855 | 80 |
1334119 | 1334119 | 2021-05-19 | Polk | Minnesota | 27119 | 3855 | 69 |
1252362 | 1252362 | 2021-04-24 | Whitley | Indiana | 18183 | 3855 | 39 |
1246429 | 1246429 | 2021-04-22 | Isanti | Minnesota | 27059 | 3855 | 59 |
1239248 | 1239248 | 2021-04-20 | Morgan | Illinois | 17137 | 3855 | 101 |
1224344 | 1224344 | 2021-04-15 | Yadkin | North Carolina | 37197 | 3855 | 47 |
1224409 | 1224409 | 2021-04-15 | Brown | Ohio | 39015 | 3855 | 55 |
1199888 | 1199888 | 2021-04-08 | Logan | Colorado | 8075 | 3855 | 65 |
1183774 | 1183774 | 2021-04-03 | Camden | Georgia | 13039 | 3855 | 32 |
1172931 | 1172931 | 2021-03-30 | Giles | Tennessee | 47055 | 3855 | 98 |
1166280 | 1166280 | 2021-03-28 | Toa Alta | Puerto Rico | 72135 | 3855 | |
1134489 | 1134489 | 2021-03-18 | Lewis | Washington | 53041 | 3855 | 50 |
1114389 | 1114389 | 2021-03-12 | Williamsburg | South Carolina | 45089 | 3855 | 93 |
1106688 | 1106688 | 2021-03-10 | Barry | Michigan | 26015 | 3855 | 48 |
1077575 | 1077575 | 2021-03-01 | Goodhue | Minnesota | 27049 | 3855 | 68 |
1077964 | 1077964 | 2021-03-01 | Platte | Nebraska | 31141 | 3855 | 47 |
1074718 | 1074718 | 2021-02-28 | Platte | Nebraska | 31141 | 3855 | 47 |
1071472 | 1071472 | 2021-02-27 | Platte | Nebraska | 31141 | 3855 | 47 |
1042710 | 1042710 | 2021-02-18 | Logan | Oklahoma | 40083 | 3855 | 26 |
1026833 | 1026833 | 2021-02-13 | Cocke | Tennessee | 47029 | 3855 | 89 |
992504 | 992504 | 2021-02-03 | Monroe | Illinois | 17133 | 3855 | 75 |
966267 | 966267 | 2021-01-26 | Baldwin | Georgia | 13009 | 3855 | 89 |
961245 | 961245 | 2021-01-24 | Genesee | New York | 36037 | 3855 | 103 |
961318 | 961318 | 2021-01-24 | Edgecombe | North Carolina | 37065 | 3855 | 90 |
954782 | 954782 | 2021-01-22 | St. Lawrence | New York | 36089 | 3855 | 63 |
955468 | 955468 | 2021-01-22 | Lincoln | Tennessee | 47103 | 3855 | 46 |
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);