ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
91 rows where cases = 4776 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 9
- North Carolina 8
- Ohio 6
- Wisconsin 6
- Mississippi 5
- Virginia 5
- Alabama 4
- Iowa 4
- Michigan 4
- Texas 4
- Illinois 3
- Kansas 3
- Tennessee 3
- West Virginia 3
- Minnesota 2
- Missouri 2
- Oregon 2
- Puerto Rico 2
- Washington 2
- Arkansas 1
- California 1
- Colorado 1
- Indiana 1
- Kentucky 1
- Louisiana 1
- Montana 1
- New Hampshire 1
- New Mexico 1
- New York 1
- Pennsylvania 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2459537 | 2459537 | 2022-04-30 | Juniata | Pennsylvania | 42067 | 4776 | 176 |
2399017 | 2399017 | 2022-04-12 | Appling | Georgia | 13001 | 4776 | 124 |
2329731 | 2329731 | 2022-03-21 | Deaf Smith | Texas | 48117 | 4776 | 111 |
2326479 | 2326479 | 2022-03-20 | Deaf Smith | Texas | 48117 | 4776 | 111 |
2323226 | 2323226 | 2022-03-19 | Deaf Smith | Texas | 48117 | 4776 | 111 |
2292543 | 2292543 | 2022-03-10 | Iosco | Michigan | 26069 | 4776 | 136 |
2289291 | 2289291 | 2022-03-09 | Iosco | Michigan | 26069 | 4776 | 136 |
2247356 | 2247356 | 2022-02-24 | Big Horn | Montana | 30003 | 4776 | 92 |
2235952 | 2235952 | 2022-02-20 | Taylor | Wisconsin | 55119 | 4776 | 67 |
2232701 | 2232701 | 2022-02-19 | Taylor | Wisconsin | 55119 | 4776 | 67 |
2229450 | 2229450 | 2022-02-18 | Taylor | Wisconsin | 55119 | 4776 | 67 |
2221310 | 2221310 | 2022-02-16 | Perry | Missouri | 29157 | 4776 | 44 |
2217837 | 2217837 | 2022-02-15 | Hubbard | Minnesota | 27057 | 4776 | 56 |
2193451 | 2193451 | 2022-02-07 | King George | Virginia | 51099 | 4776 | 30 |
2073392 | 2073392 | 2022-01-02 | Geneva | Alabama | 1061 | 4776 | 137 |
2065707 | 2065707 | 2021-12-30 | Henry | Ohio | 39069 | 4776 | 85 |
2026951 | 2026951 | 2021-12-18 | Arecibo | Puerto Rico | 72013 | 4776 | |
2016391 | 2016391 | 2021-12-15 | Dunklin | Missouri | 29069 | 4776 | 93 |
2016826 | 2016826 | 2021-12-15 | Montgomery | North Carolina | 37123 | 4776 | 110 |
2016922 | 2016922 | 2021-12-15 | Adams | Ohio | 39001 | 4776 | 112 |
1983768 | 1983768 | 2021-12-05 | Adams | Mississippi | 28001 | 4776 | 125 |
1984277 | 1984277 | 2021-12-05 | Cherokee | North Carolina | 37039 | 4776 | 78 |
1980518 | 1980518 | 2021-12-04 | Adams | Mississippi | 28001 | 4776 | 125 |
1981027 | 1981027 | 2021-12-04 | Cherokee | North Carolina | 37039 | 4776 | 78 |
1977268 | 1977268 | 2021-12-03 | Adams | Mississippi | 28001 | 4776 | 125 |
1977777 | 1977777 | 2021-12-03 | Cherokee | North Carolina | 37039 | 4776 | 78 |
1966511 | 1966511 | 2021-11-30 | Butts | Georgia | 13035 | 4776 | 123 |
1963993 | 1963993 | 2021-11-29 | Franklin | Louisiana | 22041 | 4776 | 140 |
1872133 | 1872133 | 2021-11-01 | Logan | Colorado | 8075 | 4776 | 83 |
1858866 | 1858866 | 2021-10-28 | Clarke | Alabama | 1025 | 4776 | 84 |
1855617 | 1855617 | 2021-10-27 | Clarke | Alabama | 1025 | 4776 | 84 |
1852873 | 1852873 | 2021-10-26 | Stephens | Georgia | 13257 | 4776 | 107 |
1846291 | 1846291 | 2021-10-24 | Decatur | Georgia | 13087 | 4776 | 97 |
1843041 | 1843041 | 2021-10-23 | Decatur | Georgia | 13087 | 4776 | 97 |
1839791 | 1839791 | 2021-10-22 | Decatur | Georgia | 13087 | 4776 | 97 |
1837944 | 1837944 | 2021-10-21 | Rio Arriba | New Mexico | 35039 | 4776 | 83 |
1826539 | 1826539 | 2021-10-18 | St. Francis | Arkansas | 5123 | 4776 | 66 |
1784897 | 1784897 | 2021-10-05 | Ripley | Indiana | 18137 | 4776 | 81 |
1769311 | 1769311 | 2021-09-30 | George | Mississippi | 28039 | 4776 | 76 |
1765112 | 1765112 | 2021-09-29 | Madison | Georgia | 13195 | 4776 | 65 |
1751508 | 1751508 | 2021-09-24 | Marshall | West Virginia | 54051 | 4776 | 96 |
1734701 | 1734701 | 2021-09-19 | Hardeman | Tennessee | 47069 | 4776 | 71 |
1731451 | 1731451 | 2021-09-18 | Hardeman | Tennessee | 47069 | 4776 | 71 |
1728201 | 1728201 | 2021-09-17 | Hardeman | Tennessee | 47069 | 4776 | 71 |
1664871 | 1664871 | 2021-08-29 | Lyon | Kansas | 20111 | 4776 | 88 |
1661623 | 1661623 | 2021-08-28 | Lyon | Kansas | 20111 | 4776 | 88 |
1658375 | 1658375 | 2021-08-27 | Lyon | Kansas | 20111 | 4776 | 88 |
1643116 | 1643116 | 2021-08-22 | Davie | North Carolina | 37059 | 4776 | 43 |
1639866 | 1639866 | 2021-08-21 | Davie | North Carolina | 37059 | 4776 | 43 |
1636616 | 1636616 | 2021-08-20 | Davie | North Carolina | 37059 | 4776 | 43 |
1598691 | 1598691 | 2021-08-08 | Henry | Virginia | 51089 | 4776 | 124 |
1595442 | 1595442 | 2021-08-07 | Henry | Virginia | 51089 | 4776 | 124 |
1592193 | 1592193 | 2021-08-06 | Henry | Virginia | 51089 | 4776 | 124 |
1554850 | 1554850 | 2021-07-26 | Mower | Minnesota | 27099 | 4776 | 33 |
1530691 | 1530691 | 2021-07-18 | Monroe | Wisconsin | 55081 | 4776 | 48 |
1527444 | 1527444 | 2021-07-17 | Monroe | Wisconsin | 55081 | 4776 | 48 |
1524197 | 1524197 | 2021-07-16 | Monroe | Wisconsin | 55081 | 4776 | 48 |
1518170 | 1518170 | 2021-07-15 | Chattahoochee | Georgia | 13053 | 4776 | 17 |
1520625 | 1520625 | 2021-07-15 | Wilson | Texas | 48493 | 4776 | 70 |
1489161 | 1489161 | 2021-07-06 | Effingham | Illinois | 17049 | 4776 | 85 |
1442095 | 1442095 | 2021-06-21 | Klamath | Oregon | 41035 | 4776 | 78 |
1438850 | 1438850 | 2021-06-20 | Klamath | Oregon | 41035 | 4776 | 78 |
1426736 | 1426736 | 2021-06-16 | Jefferson | West Virginia | 54037 | 4776 | 56 |
1408450 | 1408450 | 2021-06-11 | Jessamine | Kentucky | 21113 | 4776 | 70 |
1404803 | 1404803 | 2021-06-10 | Macoupin | Illinois | 17117 | 4776 | 117 |
1273163 | 1273163 | 2021-04-30 | Mercer | Ohio | 39107 | 4776 | 85 |
1245932 | 1245932 | 2021-04-22 | Marshall | Iowa | 19127 | 4776 | 75 |
1243892 | 1243892 | 2021-04-21 | Auglaize | Ohio | 39011 | 4776 | 83 |
1227009 | 1227009 | 2021-04-16 | Bolivar | Mississippi | 28011 | 4776 | 129 |
1218208 | 1218208 | 2021-04-13 | Guaynabo | Puerto Rico | 72061 | 4776 | |
1215825 | 1215825 | 2021-04-12 | Campbell | Wyoming | 56005 | 4776 | 60 |
1194426 | 1194426 | 2021-04-06 | Shiawassee | Michigan | 26155 | 4776 | 86 |
1187250 | 1187250 | 2021-04-04 | Jackson | Illinois | 17077 | 4776 | 73 |
1178737 | 1178737 | 2021-04-01 | Herkimer | New York | 36043 | 4776 | 107 |
1157911 | 1157911 | 2021-03-26 | Tift | Georgia | 13277 | 4776 | 123 |
1089097 | 1089097 | 2021-03-04 | Raleigh | West Virginia | 54081 | 4776 | 58 |
1071831 | 1071831 | 2021-02-27 | Huron | Ohio | 39077 | 4776 | 117 |
1066151 | 1066151 | 2021-02-25 | Chittenden | Vermont | 50007 | 4776 | 88 |
1019097 | 1019097 | 2021-02-11 | Marquette | Michigan | 26103 | 4776 | 55 |
999147 | 999147 | 2021-02-05 | Clinton | Iowa | 19045 | 4776 | 76 |
986234 | 986234 | 2021-02-01 | Webster | Iowa | 19187 | 4776 | 81 |
969927 | 969927 | 2021-01-27 | Cerro Gordo | Iowa | 19033 | 4776 | 72 |
909589 | 909589 | 2021-01-08 | Scioto | Ohio | 39145 | 4776 | 51 |
894492 | 894492 | 2021-01-04 | Colbert | Alabama | 1033 | 4776 | 60 |
891014 | 891014 | 2021-01-02 | Roanoke | Virginia | 51161 | 4776 | 68 |
884582 | 884582 | 2020-12-31 | Thurston | Washington | 53067 | 4776 | 56 |
867252 | 867252 | 2020-12-26 | Sampson | North Carolina | 37163 | 4776 | 59 |
776184 | 776184 | 2020-11-28 | Rockingham | New Hampshire | 33015 | 4776 | 109 |
647039 | 647039 | 2020-10-19 | Aiken | South Carolina | 45003 | 4776 | 86 |
589300 | 589300 | 2020-10-01 | Benton | Washington | 53005 | 4776 | 135 |
357258 | 357258 | 2020-07-22 | San Mateo | California | 6081 | 4776 | 114 |
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);