ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where cases = 3687 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Georgia 10
- Tennessee 9
- Texas 9
- Kentucky 8
- Alabama 6
- Virginia 6
- Michigan 5
- Minnesota 5
- Mississippi 4
- California 3
- Illinois 3
- Maryland 3
- Ohio 3
- Pennsylvania 3
- South Carolina 3
- Wisconsin 3
- Alaska 2
- Colorado 2
- Indiana 2
- Louisiana 2
- Missouri 2
- North Carolina 2
- Arkansas 1
- Idaho 1
- Nebraska 1
- New Jersey 1
- Oklahoma 1
- South Dakota 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500961 | 2500961 | 2022-05-13 | Pennington | Minnesota | 27113 | 3687 | 41 |
2490310 | 2490310 | 2022-05-10 | Rabun | Georgia | 13241 | 3687 | 98 |
2487053 | 2487053 | 2022-05-09 | Rabun | Georgia | 13241 | 3687 | 98 |
2307277 | 2307277 | 2022-03-14 | Manassas Park city | Virginia | 51685 | 3687 | 25 |
2288050 | 2288050 | 2022-03-09 | Lamar | Alabama | 1075 | 3687 | 62 |
2287542 | 2287542 | 2022-03-08 | Madison | Texas | 48313 | 3687 | 53 |
2284290 | 2284290 | 2022-03-07 | Madison | Texas | 48313 | 3687 | 53 |
2281038 | 2281038 | 2022-03-06 | Madison | Texas | 48313 | 3687 | 53 |
2277785 | 2277785 | 2022-03-05 | Madison | Texas | 48313 | 3687 | 53 |
2200302 | 2200302 | 2022-02-10 | Northwest Arctic Borough | Alaska | 2188 | 3687 | 11 |
2197048 | 2197048 | 2022-02-09 | Northwest Arctic Borough | Alaska | 2188 | 3687 | 11 |
2190476 | 2190476 | 2022-02-07 | Crenshaw | Alabama | 1041 | 3687 | 84 |
2133808 | 2133808 | 2022-01-20 | Bertie | North Carolina | 37015 | 3687 | 57 |
2105160 | 2105160 | 2022-01-11 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2101909 | 2101909 | 2022-01-10 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2098658 | 2098658 | 2022-01-09 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2095406 | 2095406 | 2022-01-08 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2092154 | 2092154 | 2022-01-07 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2087144 | 2087144 | 2022-01-06 | Rush | Indiana | 18139 | 3687 | 36 |
2088902 | 2088902 | 2022-01-06 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2084542 | 2084542 | 2022-01-05 | Chickasaw | Mississippi | 28017 | 3687 | 75 |
2085651 | 2085651 | 2022-01-05 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2082399 | 2082399 | 2022-01-04 | Bledsoe | Tennessee | 47007 | 3687 | 39 |
2063758 | 2063758 | 2021-12-30 | Lawrence | Arkansas | 5075 | 3687 | 63 |
2057538 | 2057538 | 2021-12-28 | Cook | Georgia | 13075 | 3687 | 65 |
2019119 | 2019119 | 2021-12-16 | Bourbon | Kentucky | 21017 | 3687 | 42 |
2009121 | 2009121 | 2021-12-13 | Owen | Indiana | 18119 | 3687 | 81 |
1998151 | 1998151 | 2021-12-09 | Moore | Texas | 48341 | 3687 | 90 |
1986949 | 1986949 | 2021-12-06 | Dodge | Minnesota | 27039 | 3687 | 12 |
1936847 | 1936847 | 2021-11-21 | Barbour | Alabama | 1005 | 3687 | 80 |
1937849 | 1937849 | 2021-11-21 | Anderson | Kentucky | 21005 | 3687 | 51 |
1934599 | 1934599 | 2021-11-20 | Anderson | Kentucky | 21005 | 3687 | 51 |
1931348 | 1931348 | 2021-11-19 | Anderson | Kentucky | 21005 | 3687 | 51 |
1887971 | 1887971 | 2021-11-05 | Mason | West Virginia | 54053 | 3687 | 57 |
1858593 | 1858593 | 2021-10-27 | Hopewell city | Virginia | 51670 | 3687 | 88 |
1829529 | 1829529 | 2021-10-18 | Door | Wisconsin | 55029 | 3687 | 38 |
1816304 | 1816304 | 2021-10-14 | Botetourt | Virginia | 51023 | 3687 | 45 |
1801642 | 1801642 | 2021-10-10 | Houghton | Michigan | 26061 | 3687 | 54 |
1798393 | 1798393 | 2021-10-09 | Houghton | Michigan | 26061 | 3687 | 54 |
1795144 | 1795144 | 2021-10-08 | Houghton | Michigan | 26061 | 3687 | 54 |
1791690 | 1791690 | 2021-10-07 | Letcher | Kentucky | 21133 | 3687 | 61 |
1769214 | 1769214 | 2021-09-30 | Cass | Minnesota | 27021 | 3687 | 39 |
1746601 | 1746601 | 2021-09-23 | Newton | Mississippi | 28101 | 3687 | 75 |
1743029 | 1743029 | 2021-09-22 | Grant | Louisiana | 22043 | 3687 | 74 |
1731211 | 1731211 | 2021-09-18 | Tioga | Pennsylvania | 42117 | 3687 | 115 |
1707742 | 1707742 | 2021-09-11 | Saline | Missouri | 29195 | 3687 | 44 |
1704508 | 1704508 | 2021-09-10 | Stone | Missouri | 29209 | 3687 | 67 |
1698865 | 1698865 | 2021-09-08 | Union | South Carolina | 45087 | 3687 | 84 |
1645874 | 1645874 | 2021-08-23 | Itawamba | Mississippi | 28057 | 3687 | 84 |
1646397 | 1646397 | 2021-08-23 | Montgomery | North Carolina | 37123 | 3687 | 97 |
1586493 | 1586493 | 2021-08-05 | Upson | Georgia | 13293 | 3687 | 133 |
1588712 | 1588712 | 2021-08-05 | Kendall | Texas | 48259 | 3687 | 74 |
1547005 | 1547005 | 2021-07-24 | Dallas | Alabama | 1047 | 3687 | 163 |
1539820 | 1539820 | 2021-07-21 | Macon | Tennessee | 47111 | 3687 | 78 |
1537017 | 1537017 | 2021-07-20 | Prince George | Virginia | 51149 | 3687 | 32 |
1490853 | 1490853 | 2021-07-06 | Snyder | Pennsylvania | 42109 | 3687 | 86 |
1437832 | 1437832 | 2021-06-20 | Worcester | Maryland | 24047 | 3687 | 106 |
1433646 | 1433646 | 2021-06-19 | Montrose | Colorado | 8085 | 3687 | 63 |
1434585 | 1434585 | 2021-06-19 | Worcester | Maryland | 24047 | 3687 | 106 |
1431338 | 1431338 | 2021-06-18 | Worcester | Maryland | 24047 | 3687 | 106 |
1427912 | 1427912 | 2021-06-17 | Greenup | Kentucky | 21089 | 3687 | 63 |
1426050 | 1426050 | 2021-06-16 | Colleton | South Carolina | 45029 | 3687 | 129 |
1419557 | 1419557 | 2021-06-14 | Colleton | South Carolina | 45029 | 3687 | 129 |
1384864 | 1384864 | 2021-06-04 | Amador | California | 6005 | 3687 | 47 |
1381618 | 1381618 | 2021-06-03 | Amador | California | 6005 | 3687 | 47 |
1378193 | 1378193 | 2021-06-02 | Chambers | Alabama | 1017 | 3687 | 124 |
1378775 | 1378775 | 2021-06-02 | Nez Perce | Idaho | 16069 | 3687 | 55 |
1352132 | 1352132 | 2021-05-24 | Clark | Wisconsin | 55019 | 3687 | 63 |
1342881 | 1342881 | 2021-05-22 | Bryan | Georgia | 13029 | 3687 | 40 |
1284705 | 1284705 | 2021-05-04 | Montgomery | Illinois | 17135 | 3687 | 79 |
1273123 | 1273123 | 2021-04-30 | Clinton | Ohio | 39027 | 3687 | 61 |
1267403 | 1267403 | 2021-04-28 | Titus | Texas | 48449 | 3687 | 83 |
1252221 | 1252221 | 2021-04-24 | Logan | Illinois | 17107 | 3687 | 69 |
1249720 | 1249720 | 2021-04-23 | Steele | Minnesota | 27147 | 3687 | 14 |
1209298 | 1209298 | 2021-04-10 | Oneida | Wisconsin | 55085 | 3687 | 74 |
1086999 | 1086999 | 2021-03-04 | Franklin | Kentucky | 21073 | 3687 | 30 |
1069454 | 1069454 | 2021-02-26 | Franklin | Virginia | 51067 | 3687 | 51 |
1063652 | 1063652 | 2021-02-25 | Camden | Georgia | 13039 | 3687 | 30 |
1059574 | 1059574 | 2021-02-23 | Rusk | Texas | 48401 | 3687 | 90 |
979970 | 979970 | 2021-01-30 | Whitley | Kentucky | 21235 | 3687 | 14 |
969805 | 969805 | 2021-01-27 | Stephenson | Illinois | 17177 | 3687 | 78 |
970372 | 970372 | 2021-01-27 | Cass | Michigan | 26027 | 3687 | 57 |
971283 | 971283 | 2021-01-27 | Custer | Oklahoma | 40039 | 3687 | 56 |
938042 | 938042 | 2021-01-17 | Nobles | Minnesota | 27105 | 3687 | 46 |
921716 | 921716 | 2021-01-12 | Isabella | Michigan | 26073 | 3687 | 58 |
910725 | 910725 | 2021-01-09 | Dale | Alabama | 1045 | 3687 | 64 |
885272 | 885272 | 2021-01-01 | Unknown | Georgia | 3687 | 6 | |
865535 | 865535 | 2020-12-26 | Garfield | Colorado | 8045 | 3687 | 26 |
858172 | 858172 | 2020-12-23 | Bowie | Texas | 48037 | 3687 | 118 |
844665 | 844665 | 2020-12-19 | Mercer | Ohio | 39107 | 3687 | 76 |
778785 | 778785 | 2020-11-29 | Iberia | Louisiana | 22045 | 3687 | 106 |
765099 | 765099 | 2020-11-25 | Dougherty | Georgia | 13095 | 3687 | 203 |
731019 | 731019 | 2020-11-14 | Allen | Ohio | 39003 | 3687 | 81 |
650379 | 650379 | 2020-10-20 | Pennington | South Dakota | 46103 | 3687 | 44 |
641823 | 641823 | 2020-10-18 | Floyd | Georgia | 13115 | 3687 | 55 |
640405 | 640405 | 2020-10-17 | Centre | Pennsylvania | 42027 | 3687 | 15 |
578268 | 578268 | 2020-09-28 | Sarpy | Nebraska | 31153 | 3687 | 26 |
542330 | 542330 | 2020-09-17 | Harrison | Mississippi | 28047 | 3687 | 71 |
521163 | 521163 | 2020-09-10 | Arlington | Virginia | 51013 | 3687 | 144 |
502492 | 502492 | 2020-09-05 | Clarke | Georgia | 13059 | 3687 | 34 |
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);