ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
140 rows where cases = 3399 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 13
- Kansas 12
- Texas 9
- Kentucky 8
- Wisconsin 8
- Georgia 6
- New York 5
- Ohio 5
- Pennsylvania 5
- Alabama 4
- Arkansas 4
- Illinois 4
- Indiana 4
- Puerto Rico 4
- Virginia 4
- West Virginia 4
- Colorado 3
- Florida 3
- Missouri 3
- North Carolina 3
- Oregon 3
- South Carolina 3
- Wyoming 3
- California 2
- Iowa 2
- Louisiana 2
- Maryland 2
- Oklahoma 2
- Tennessee 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2473783 | 2473783 | 2022-05-05 | Gunnison | Colorado | 8051 | 3399 | 14 |
2447256 | 2447256 | 2022-04-26 | Southampton | Virginia | 51175 | 3399 | 91 |
2307483 | 2307483 | 2022-03-14 | Rusk | Wisconsin | 55107 | 3399 | 54 |
2304232 | 2304232 | 2022-03-13 | Rusk | Wisconsin | 55107 | 3399 | 54 |
2300980 | 2300980 | 2022-03-12 | Rusk | Wisconsin | 55107 | 3399 | 54 |
2296409 | 2296409 | 2022-03-11 | Schuyler | New York | 36097 | 3399 | 25 |
2297728 | 2297728 | 2022-03-11 | Rusk | Wisconsin | 55107 | 3399 | 54 |
2259441 | 2259441 | 2022-02-28 | Washington | Illinois | 17189 | 3399 | 40 |
2218600 | 2218600 | 2022-02-15 | Monroe | Ohio | 39111 | 3399 | 72 |
2164287 | 2164287 | 2022-01-29 | Braxton | West Virginia | 54007 | 3399 | 35 |
2152535 | 2152535 | 2022-01-26 | Webster | Kentucky | 21233 | 3399 | 46 |
2149293 | 2149293 | 2022-01-25 | Bienville | Louisiana | 22013 | 3399 | 102 |
2118339 | 2118339 | 2022-01-15 | Freestone | Texas | 48161 | 3399 | 76 |
2101287 | 2101287 | 2022-01-10 | Avery | North Carolina | 37011 | 3399 | 39 |
2089396 | 2089396 | 2022-01-06 | Prince Edward | Virginia | 51147 | 3399 | 54 |
2086149 | 2086149 | 2022-01-05 | Radford city | Virginia | 51750 | 3399 | 39 |
2054369 | 2054369 | 2021-12-27 | Putnam | Georgia | 13237 | 3399 | 89 |
2034412 | 2034412 | 2021-12-21 | Monroe | Alabama | 1099 | 3399 | 66 |
2034488 | 2034488 | 2021-12-21 | Conway | Arkansas | 5029 | 3399 | 48 |
2037489 | 2037489 | 2021-12-21 | McDowell | West Virginia | 54047 | 3399 | 56 |
2031407 | 2031407 | 2021-12-20 | Pitkin | Colorado | 8097 | 3399 | 6 |
2015557 | 2015557 | 2021-12-15 | Wayne | Illinois | 17191 | 3399 | 67 |
2003463 | 2003463 | 2021-12-11 | Vernon | Missouri | 29217 | 3399 | 82 |
1985722 | 1985722 | 2021-12-06 | Clark | Arkansas | 5019 | 3399 | 63 |
1949812 | 1949812 | 2021-11-24 | Taylor | Wisconsin | 55119 | 3399 | 48 |
1945703 | 1945703 | 2021-11-23 | Dorado | Puerto Rico | 72051 | 3399 | |
1941540 | 1941540 | 2021-11-22 | Jasper | Mississippi | 28061 | 3399 | 66 |
1942452 | 1942452 | 2021-11-22 | Dorado | Puerto Rico | 72051 | 3399 | |
1908816 | 1908816 | 2021-11-12 | Somerset | Maryland | 24039 | 3399 | 54 |
1907458 | 1907458 | 2021-11-11 | Hampshire | West Virginia | 54027 | 3399 | 49 |
1849582 | 1849582 | 2021-10-25 | Lamar | Georgia | 13171 | 3399 | 89 |
1801419 | 1801419 | 2021-10-10 | Hart | Kentucky | 21099 | 3399 | 61 |
1798170 | 1798170 | 2021-10-09 | Hart | Kentucky | 21099 | 3399 | 61 |
1794921 | 1794921 | 2021-10-08 | Hart | Kentucky | 21099 | 3399 | 61 |
1786838 | 1786838 | 2021-10-05 | Gray | Texas | 48179 | 3399 | 69 |
1765090 | 1765090 | 2021-09-29 | Hart | Georgia | 13147 | 3399 | 61 |
1691791 | 1691791 | 2021-09-06 | Orleans | New York | 36073 | 3399 | 83 |
1669668 | 1669668 | 2021-08-30 | Lawrence | South Dakota | 46081 | 3399 | 50 |
1634621 | 1634621 | 2021-08-19 | Lincoln | Wisconsin | 55069 | 3399 | 97 |
1630566 | 1630566 | 2021-08-18 | Mayaguez | Puerto Rico | 72097 | 3399 | |
1624773 | 1624773 | 2021-08-16 | Mason | Washington | 53045 | 3399 | 40 |
1600382 | 1600382 | 2021-08-09 | Copiah | Mississippi | 28029 | 3399 | 69 |
1597236 | 1597236 | 2021-08-08 | Dunklin | Missouri | 29069 | 3399 | 50 |
1598947 | 1598947 | 2021-08-08 | Sheridan | Wyoming | 56033 | 3399 | 31 |
1595698 | 1595698 | 2021-08-07 | Sheridan | Wyoming | 56033 | 3399 | 31 |
1592449 | 1592449 | 2021-08-06 | Sheridan | Wyoming | 56033 | 3399 | 31 |
1581752 | 1581752 | 2021-08-03 | Greene | Pennsylvania | 42059 | 3399 | 42 |
1496500 | 1496500 | 2021-07-08 | Pike | Mississippi | 28113 | 3399 | 111 |
1492737 | 1492737 | 2021-07-07 | McPherson | Kansas | 20113 | 3399 | 89 |
1489490 | 1489490 | 2021-07-06 | McPherson | Kansas | 20113 | 3399 | 89 |
1486243 | 1486243 | 2021-07-05 | McPherson | Kansas | 20113 | 3399 | 89 |
1486769 | 1486769 | 2021-07-05 | Sunflower | Mississippi | 28133 | 3399 | 93 |
1482997 | 1482997 | 2021-07-04 | McPherson | Kansas | 20113 | 3399 | 89 |
1483523 | 1483523 | 2021-07-04 | Sunflower | Mississippi | 28133 | 3399 | 93 |
1479750 | 1479750 | 2021-07-03 | McPherson | Kansas | 20113 | 3399 | 89 |
1480277 | 1480277 | 2021-07-03 | Sunflower | Mississippi | 28133 | 3399 | 93 |
1476504 | 1476504 | 2021-07-02 | McPherson | Kansas | 20113 | 3399 | 89 |
1477030 | 1477030 | 2021-07-02 | Sunflower | Mississippi | 28133 | 3399 | 93 |
1473258 | 1473258 | 2021-07-01 | McPherson | Kansas | 20113 | 3399 | 89 |
1473784 | 1473784 | 2021-07-01 | Sunflower | Mississippi | 28133 | 3399 | 93 |
1470538 | 1470538 | 2021-06-30 | Sunflower | Mississippi | 28133 | 3399 | 93 |
1467293 | 1467293 | 2021-06-29 | Sunflower | Mississippi | 28133 | 3399 | 93 |
1448907 | 1448907 | 2021-06-23 | Henry | Tennessee | 47079 | 3399 | 75 |
1360191 | 1360191 | 2021-05-27 | Tate | Mississippi | 28137 | 3399 | 85 |
1328688 | 1328688 | 2021-05-17 | Marlboro | South Carolina | 45069 | 3399 | 56 |
1307533 | 1307533 | 2021-05-11 | Ripley | Indiana | 18137 | 3399 | 70 |
1307687 | 1307687 | 2021-05-11 | Geary | Kansas | 20061 | 3399 | 40 |
1304441 | 1304441 | 2021-05-10 | Geary | Kansas | 20061 | 3399 | 40 |
1291878 | 1291878 | 2021-05-06 | Freeborn | Minnesota | 27047 | 3399 | 29 |
1287811 | 1287811 | 2021-05-05 | Toombs | Georgia | 13279 | 3399 | 113 |
1284565 | 1284565 | 2021-05-04 | Toombs | Georgia | 13279 | 3399 | 113 |
1275307 | 1275307 | 2021-05-01 | Boyle | Kentucky | 21021 | 3399 | 70 |
1270231 | 1270231 | 2021-04-29 | Clarendon | South Carolina | 45027 | 3399 | 111 |
1240478 | 1240478 | 2021-04-20 | Warren | New York | 36113 | 3399 | 56 |
1225791 | 1225791 | 2021-04-16 | Lake | California | 6033 | 3399 | 43 |
1221412 | 1221412 | 2021-04-14 | Snyder | Pennsylvania | 42109 | 3399 | 82 |
1212922 | 1212922 | 2021-04-12 | Baker | Florida | 12003 | 3399 | 60 |
1211666 | 1211666 | 2021-04-11 | Pike | Pennsylvania | 42103 | 3399 | 52 |
1205242 | 1205242 | 2021-04-09 | Ponce | Puerto Rico | 72113 | 3399 | |
1187569 | 1187569 | 2021-04-04 | Montgomery | Kansas | 20125 | 3399 | 6 |
1183642 | 1183642 | 2021-04-03 | La Plata | Colorado | 8067 | 3399 | 37 |
1184322 | 1184322 | 2021-04-03 | Montgomery | Kansas | 20125 | 3399 | 6 |
1181075 | 1181075 | 2021-04-02 | Montgomery | Kansas | 20125 | 3399 | 6 |
1179120 | 1179120 | 2021-04-01 | Malheur | Oregon | 41045 | 3399 | 58 |
1174327 | 1174327 | 2021-03-31 | Adams | Indiana | 18001 | 3399 | 52 |
1172233 | 1172233 | 2021-03-30 | Cortland | New York | 36023 | 3399 | 60 |
1154743 | 1154743 | 2021-03-25 | Bureau | Illinois | 17011 | 3399 | 91 |
1156834 | 1156834 | 2021-03-25 | Fannin | Texas | 48147 | 3399 | 107 |
1153587 | 1153587 | 2021-03-24 | Fannin | Texas | 48147 | 3399 | 107 |
1138949 | 1138949 | 2021-03-20 | Greenup | Kentucky | 21089 | 3399 | 44 |
1137675 | 1137675 | 2021-03-19 | Petersburg city | Virginia | 51730 | 3399 | 74 |
1131596 | 1131596 | 2021-03-18 | Yell | Arkansas | 5149 | 3399 | 63 |
1132456 | 1132456 | 2021-03-18 | Greenup | Kentucky | 21089 | 3399 | 44 |
1119193 | 1119193 | 2021-03-14 | Putnam | Indiana | 18133 | 3399 | 60 |
1100218 | 1100218 | 2021-03-08 | Hillsdale | Michigan | 26059 | 3399 | 76 |
1094775 | 1094775 | 2021-03-06 | Venango | Pennsylvania | 42121 | 3399 | 84 |
1086819 | 1086819 | 2021-03-04 | Marion | Iowa | 19125 | 3399 | 70 |
1086980 | 1086980 | 2021-03-04 | Calloway | Kentucky | 21035 | 3399 | 38 |
1075052 | 1075052 | 2021-02-28 | Clinton | Ohio | 39027 | 3399 | 64 |
1072367 | 1072367 | 2021-02-27 | Bee | Texas | 48025 | 3399 | 64 |
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);