ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
141 rows where cases = 3097 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 16
- Mississippi 11
- Georgia 10
- Kentucky 9
- Louisiana 8
- Tennessee 8
- Florida 6
- New York 6
- Virginia 6
- Colorado 5
- Texas 5
- Minnesota 4
- Missouri 4
- Pennsylvania 4
- Puerto Rico 4
- South Dakota 4
- Alabama 3
- Illinois 3
- Kansas 3
- North Carolina 3
- Ohio 3
- Idaho 2
- Indiana 2
- Michigan 2
- Oregon 2
- Vermont 2
- Washington 2
- California 1
- South Carolina 1
- West Virginia 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471596 | 2471596 | 2022-05-04 | Chippewa | Minnesota | 27023 | 3097 | 48 |
2472455 | 2472455 | 2022-05-04 | Love | Oklahoma | 40085 | 3097 | 39 |
2469199 | 2469199 | 2022-05-03 | Love | Oklahoma | 40085 | 3097 | 39 |
2465943 | 2465943 | 2022-05-02 | Love | Oklahoma | 40085 | 3097 | 39 |
2466104 | 2466104 | 2022-05-02 | Comerio | Puerto Rico | 72045 | 3097 | |
2462688 | 2462688 | 2022-05-01 | Love | Oklahoma | 40085 | 3097 | 39 |
2459432 | 2459432 | 2022-04-30 | Love | Oklahoma | 40085 | 3097 | 39 |
2456176 | 2456176 | 2022-04-29 | Love | Oklahoma | 40085 | 3097 | 39 |
2452920 | 2452920 | 2022-04-28 | Love | Oklahoma | 40085 | 3097 | 39 |
2449664 | 2449664 | 2022-04-27 | Love | Oklahoma | 40085 | 3097 | 39 |
2446407 | 2446407 | 2022-04-26 | Love | Oklahoma | 40085 | 3097 | 39 |
2443152 | 2443152 | 2022-04-25 | Love | Oklahoma | 40085 | 3097 | 39 |
2439896 | 2439896 | 2022-04-24 | Love | Oklahoma | 40085 | 3097 | 39 |
2436640 | 2436640 | 2022-04-23 | Love | Oklahoma | 40085 | 3097 | 39 |
2433384 | 2433384 | 2022-04-22 | Love | Oklahoma | 40085 | 3097 | 39 |
2430128 | 2430128 | 2022-04-21 | Love | Oklahoma | 40085 | 3097 | 39 |
2244808 | 2244808 | 2022-02-23 | Potter | Pennsylvania | 42105 | 3097 | 90 |
2195147 | 2195147 | 2022-02-08 | Greene | Mississippi | 28041 | 3097 | 51 |
2189896 | 2189896 | 2022-02-06 | Duval | Texas | 48131 | 3097 | 64 |
2157693 | 2157693 | 2022-01-27 | Patrick | Virginia | 51141 | 3097 | 73 |
2084142 | 2084142 | 2022-01-05 | Casey | Kentucky | 21045 | 3097 | 65 |
2034139 | 2034139 | 2021-12-20 | Prince Edward | Virginia | 51147 | 3097 | 54 |
2028802 | 2028802 | 2021-12-19 | Jefferson | Kansas | 20087 | 3097 | 52 |
2030833 | 2030833 | 2021-12-19 | Fluvanna | Virginia | 51065 | 3097 | 29 |
2025551 | 2025551 | 2021-12-18 | Jefferson | Kansas | 20087 | 3097 | 52 |
2027582 | 2027582 | 2021-12-18 | Fluvanna | Virginia | 51065 | 3097 | 29 |
2022300 | 2022300 | 2021-12-17 | Jefferson | Kansas | 20087 | 3097 | 52 |
2024331 | 2024331 | 2021-12-17 | Fluvanna | Virginia | 51065 | 3097 | 29 |
1984214 | 1984214 | 2021-12-05 | Essex | New York | 36031 | 3097 | 38 |
1974937 | 1974937 | 2021-12-02 | Aguadilla | Puerto Rico | 72005 | 3097 | |
1926190 | 1926190 | 2021-11-17 | Canovanas | Puerto Rico | 72029 | 3097 | |
1913209 | 1913209 | 2021-11-13 | Gurabo | Puerto Rico | 72063 | 3097 | |
1879776 | 1879776 | 2021-11-03 | Clay | Mississippi | 28025 | 3097 | 77 |
1876527 | 1876527 | 2021-11-02 | Clay | Mississippi | 28025 | 3097 | 77 |
1873278 | 1873278 | 2021-11-01 | Clay | Mississippi | 28025 | 3097 | 77 |
1836699 | 1836699 | 2021-10-21 | Minidoka | Idaho | 16067 | 3097 | 45 |
1813769 | 1813769 | 2021-10-14 | Brantley | Georgia | 13025 | 3097 | 80 |
1810150 | 1810150 | 2021-10-13 | Henry | Alabama | 1067 | 3097 | 64 |
1801418 | 1801418 | 2021-10-10 | Harrison | Kentucky | 21097 | 3097 | 30 |
1801476 | 1801476 | 2021-10-10 | Simpson | Kentucky | 21213 | 3097 | 50 |
1798169 | 1798169 | 2021-10-09 | Harrison | Kentucky | 21097 | 3097 | 30 |
1798227 | 1798227 | 2021-10-09 | Simpson | Kentucky | 21213 | 3097 | 50 |
1794920 | 1794920 | 2021-10-08 | Harrison | Kentucky | 21097 | 3097 | 30 |
1794978 | 1794978 | 2021-10-08 | Simpson | Kentucky | 21213 | 3097 | 50 |
1796791 | 1796791 | 2021-10-08 | Washington | Vermont | 50023 | 3097 | 18 |
1785619 | 1785619 | 2021-10-05 | Winston | Mississippi | 28159 | 3097 | 91 |
1782284 | 1782284 | 2021-10-04 | Waseca | Minnesota | 27161 | 3097 | 26 |
1767759 | 1767759 | 2021-09-29 | Nicholas | West Virginia | 54067 | 3097 | 33 |
1764145 | 1764145 | 2021-09-28 | Lavaca | Texas | 48285 | 3097 | 91 |
1755171 | 1755171 | 2021-09-26 | Morgan | Colorado | 8087 | 3097 | 98 |
1751923 | 1751923 | 2021-09-25 | Morgan | Colorado | 8087 | 3097 | 98 |
1748674 | 1748674 | 2021-09-24 | Morgan | Colorado | 8087 | 3097 | 98 |
1739324 | 1739324 | 2021-09-21 | Shelby | Illinois | 17173 | 3097 | 46 |
1728894 | 1728894 | 2021-09-18 | Butler | Alabama | 1013 | 3097 | 83 |
1724853 | 1724853 | 2021-09-16 | Beadle | South Dakota | 46005 | 3097 | 43 |
1721010 | 1721010 | 2021-09-15 | Lewis | New York | 36049 | 3097 | 36 |
1715358 | 1715358 | 2021-09-13 | Gray | Texas | 48179 | 3097 | 64 |
1712112 | 1712112 | 2021-09-12 | Gray | Texas | 48179 | 3097 | 64 |
1708865 | 1708865 | 2021-09-11 | Gray | Texas | 48179 | 3097 | 64 |
1696451 | 1696451 | 2021-09-08 | Marengo | Alabama | 1091 | 3097 | 74 |
1693752 | 1693752 | 2021-09-07 | Payette | Idaho | 16075 | 3097 | 40 |
1691327 | 1691327 | 2021-09-06 | Attala | Mississippi | 28007 | 3097 | 82 |
1634040 | 1634040 | 2021-08-19 | Smith | Tennessee | 47159 | 3097 | 40 |
1605868 | 1605868 | 2021-08-11 | Chattooga | Georgia | 13055 | 3097 | 76 |
1586154 | 1586154 | 2021-08-05 | Glenn | California | 6021 | 3097 | 27 |
1574102 | 1574102 | 2021-08-01 | Franklin | Louisiana | 22041 | 3097 | 108 |
1570854 | 1570854 | 2021-07-31 | Franklin | Louisiana | 22041 | 3097 | 108 |
1567606 | 1567606 | 2021-07-30 | Franklin | Louisiana | 22041 | 3097 | 108 |
1550711 | 1550711 | 2021-07-25 | Lumpkin | Georgia | 13187 | 3097 | 82 |
1547464 | 1547464 | 2021-07-24 | Lumpkin | Georgia | 13187 | 3097 | 82 |
1544217 | 1544217 | 2021-07-23 | Lumpkin | Georgia | 13187 | 3097 | 82 |
1536586 | 1536586 | 2021-07-20 | Overton | Tennessee | 47133 | 3097 | 62 |
1488987 | 1488987 | 2021-07-06 | Gilmer | Georgia | 13123 | 3097 | 89 |
1412958 | 1412958 | 2021-06-12 | Tioga | Pennsylvania | 42117 | 3097 | 110 |
1361785 | 1361785 | 2021-05-27 | Kittitas | Washington | 53037 | 3097 | 34 |
1332012 | 1332012 | 2021-05-18 | Yankton | South Dakota | 46135 | 3097 | 33 |
1314526 | 1314526 | 2021-05-13 | Houghton | Michigan | 26061 | 3097 | 40 |
1307768 | 1307768 | 2021-05-11 | Bell | Kentucky | 21013 | 3097 | 54 |
1278959 | 1278959 | 2021-05-02 | Alcorn | Mississippi | 28003 | 3097 | 68 |
1275712 | 1275712 | 2021-05-01 | Alcorn | Mississippi | 28003 | 3097 | 68 |
1271457 | 1271457 | 2021-04-30 | Butts | Georgia | 13035 | 3097 | 82 |
1272465 | 1272465 | 2021-04-30 | Alcorn | Mississippi | 28003 | 3097 | 68 |
1264901 | 1264901 | 2021-04-28 | Hardee | Florida | 12049 | 3097 | 42 |
1260298 | 1260298 | 2021-04-26 | Douglas | Oregon | 41019 | 3097 | 69 |
1216985 | 1216985 | 2021-04-13 | East Feliciana | Louisiana | 22037 | 3097 | 112 |
1213725 | 1213725 | 2021-04-12 | Beauregard | Louisiana | 22011 | 3097 | 74 |
1210490 | 1210490 | 2021-04-11 | East Feliciana | Louisiana | 22037 | 3097 | 112 |
1211918 | 1211918 | 2021-04-11 | Henry | Tennessee | 47079 | 3097 | 75 |
1207241 | 1207241 | 2021-04-10 | East Feliciana | Louisiana | 22037 | 3097 | 112 |
1208669 | 1208669 | 2021-04-10 | Henry | Tennessee | 47079 | 3097 | 75 |
1203993 | 1203993 | 2021-04-09 | East Feliciana | Louisiana | 22037 | 3097 | 112 |
1205421 | 1205421 | 2021-04-09 | Henry | Tennessee | 47079 | 3097 | 75 |
1201454 | 1201454 | 2021-04-08 | Allegany | New York | 36003 | 3097 | 82 |
1178221 | 1178221 | 2021-04-01 | Freeborn | Minnesota | 27047 | 3097 | 27 |
1178941 | 1178941 | 2021-04-01 | Champaign | Ohio | 39021 | 3097 | 53 |
1174249 | 1174249 | 2021-03-31 | Fayette | Illinois | 17051 | 3097 | 57 |
1175904 | 1175904 | 2021-03-31 | Clinton | Pennsylvania | 42035 | 3097 | 58 |
1172854 | 1172854 | 2021-03-30 | Davison | South Dakota | 46035 | 3097 | 67 |
1165777 | 1165777 | 2021-03-28 | Tioga | New York | 36107 | 3097 | 57 |
1120400 | 1120400 | 2021-03-14 | Person | North Carolina | 37145 | 3097 | 67 |
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);