ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
142 rows where cases = 3103 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 18
- Minnesota 14
- Arkansas 10
- Texas 10
- Georgia 9
- Puerto Rico 7
- Louisiana 6
- Mississippi 6
- Kentucky 5
- Tennessee 5
- Virginia 5
- Alabama 4
- Arizona 4
- Idaho 4
- Ohio 4
- Colorado 3
- Indiana 3
- Pennsylvania 3
- Illinois 2
- Missouri 2
- North Carolina 2
- South Carolina 2
- West Virginia 2
- Wisconsin 2
- Iowa 1
- Maryland 1
- Michigan 1
- Montana 1
- Nebraska 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495259 | 2495259 | 2022-05-11 | Love | Oklahoma | 40085 | 3103 | 39 |
2492001 | 2492001 | 2022-05-10 | Love | Oklahoma | 40085 | 3103 | 39 |
2488743 | 2488743 | 2022-05-09 | Love | Oklahoma | 40085 | 3103 | 39 |
2485486 | 2485486 | 2022-05-08 | Love | Oklahoma | 40085 | 3103 | 39 |
2482228 | 2482228 | 2022-05-07 | Love | Oklahoma | 40085 | 3103 | 39 |
2478970 | 2478970 | 2022-05-06 | Love | Oklahoma | 40085 | 3103 | 39 |
2475712 | 2475712 | 2022-05-05 | Love | Oklahoma | 40085 | 3103 | 39 |
2289859 | 2289859 | 2022-03-09 | Torrance | New Mexico | 35057 | 3103 | 51 |
2268391 | 2268391 | 2022-03-02 | Roane | West Virginia | 54087 | 3103 | 36 |
2255962 | 2255962 | 2022-02-27 | Jasper | Georgia | 13159 | 3103 | 68 |
2252711 | 2252711 | 2022-02-26 | Jasper | Georgia | 13159 | 3103 | 68 |
2249460 | 2249460 | 2022-02-25 | Jasper | Georgia | 13159 | 3103 | 68 |
2248059 | 2248059 | 2022-02-24 | Potter | Pennsylvania | 42105 | 3103 | 90 |
2239496 | 2239496 | 2022-02-22 | Crowley | Colorado | 8025 | 3103 | 28 |
2236245 | 2236245 | 2022-02-21 | Crowley | Colorado | 8025 | 3103 | 28 |
2224640 | 2224640 | 2022-02-17 | Roosevelt | Montana | 30085 | 3103 | 70 |
2195678 | 2195678 | 2022-02-08 | Mitchell | North Carolina | 37121 | 3103 | 33 |
2168188 | 2168188 | 2022-01-31 | Oglethorpe | Georgia | 13221 | 3103 | 46 |
2166842 | 2166842 | 2022-01-30 | Utuado | Puerto Rico | 72141 | 3103 | |
2151401 | 2151401 | 2022-01-25 | Goshen | Wyoming | 56015 | 3103 | 53 |
2141840 | 2141840 | 2022-01-23 | Van Buren | Arkansas | 5141 | 3103 | 46 |
2115052 | 2115052 | 2022-01-14 | Colorado | Texas | 48089 | 3103 | 56 |
2077218 | 2077218 | 2022-01-03 | Bond | Illinois | 17005 | 3103 | 34 |
2075722 | 2075722 | 2022-01-02 | Fajardo | Puerto Rico | 72053 | 3103 | |
2058211 | 2058211 | 2021-12-28 | Powell | Kentucky | 21197 | 3103 | 28 |
2043854 | 2043854 | 2021-12-23 | King George | Virginia | 51099 | 3103 | 25 |
2040379 | 2040379 | 2021-12-22 | Lamb | Texas | 48279 | 3103 | 97 |
1994439 | 1994439 | 2021-12-08 | Aguadilla | Puerto Rico | 72005 | 3103 | |
1932691 | 1932691 | 2021-11-19 | Canovanas | Puerto Rico | 72029 | 3103 | |
1919709 | 1919709 | 2021-11-15 | Gurabo | Puerto Rico | 72063 | 3103 | |
1915522 | 1915522 | 2021-11-14 | Clay | Mississippi | 28025 | 3103 | 77 |
1912272 | 1912272 | 2021-11-13 | Clay | Mississippi | 28025 | 3103 | 77 |
1913965 | 1913965 | 2021-11-13 | Lincoln | West Virginia | 54043 | 3103 | 46 |
1908159 | 1908159 | 2021-11-12 | Blaine | Idaho | 16013 | 3103 | 27 |
1909022 | 1909022 | 2021-11-12 | Clay | Mississippi | 28025 | 3103 | 77 |
1904910 | 1904910 | 2021-11-11 | Blaine | Idaho | 16013 | 3103 | 27 |
1901105 | 1901105 | 2021-11-10 | Cherokee | Alabama | 1019 | 3103 | 62 |
1901660 | 1901660 | 2021-11-10 | Blaine | Idaho | 16013 | 3103 | 27 |
1878898 | 1878898 | 2021-11-03 | Worth | Georgia | 13321 | 3103 | 91 |
1877892 | 1877892 | 2021-11-02 | Montague | Texas | 48337 | 3103 | 94 |
1858519 | 1858519 | 2021-10-27 | Franklin | Vermont | 50011 | 3103 | 50 |
1826463 | 1826463 | 2021-10-18 | La Paz | Arizona | 4012 | 3103 | 97 |
1823214 | 1823214 | 2021-10-17 | La Paz | Arizona | 4012 | 3103 | 97 |
1819965 | 1819965 | 2021-10-16 | La Paz | Arizona | 4012 | 3103 | 97 |
1813399 | 1813399 | 2021-10-14 | Henry | Alabama | 1067 | 3103 | 65 |
1814677 | 1814677 | 2021-10-14 | Otsego | Michigan | 26137 | 3103 | 51 |
1790747 | 1790747 | 2021-10-07 | Conway | Arkansas | 5029 | 3103 | 42 |
1792116 | 1792116 | 2021-10-07 | Winston | Mississippi | 28159 | 3103 | 91 |
1784554 | 1784554 | 2021-10-05 | Crisp | Georgia | 13081 | 3103 | 106 |
1780928 | 1780928 | 2021-10-04 | Pickens | Alabama | 1107 | 3103 | 77 |
1764791 | 1764791 | 2021-09-29 | Phillips | Arkansas | 5107 | 3103 | 69 |
1761498 | 1761498 | 2021-09-28 | Clark | Arkansas | 5019 | 3103 | 51 |
1747968 | 1747968 | 2021-09-23 | Scurry | Texas | 48415 | 3103 | 75 |
1744931 | 1744931 | 2021-09-22 | Staunton city | Virginia | 51790 | 3103 | 76 |
1725687 | 1725687 | 2021-09-17 | Monroe | Alabama | 1099 | 3103 | 46 |
1653611 | 1653611 | 2021-08-25 | Deaf Smith | Texas | 48117 | 3103 | 68 |
1642325 | 1642325 | 2021-08-22 | Grant | Louisiana | 22043 | 3103 | 62 |
1639075 | 1639075 | 2021-08-21 | Grant | Louisiana | 22043 | 3103 | 62 |
1635825 | 1635825 | 2021-08-20 | Grant | Louisiana | 22043 | 3103 | 62 |
1629551 | 1629551 | 2021-08-18 | Le Sueur | Minnesota | 27079 | 3103 | 28 |
1629771 | 1629771 | 2021-08-18 | Randolph | Missouri | 29175 | 3103 | 33 |
1631112 | 1631112 | 2021-08-18 | Accomack | Virginia | 51001 | 3103 | 47 |
1627063 | 1627063 | 2021-08-17 | Perry | Ohio | 39127 | 3103 | 50 |
1622868 | 1622868 | 2021-08-16 | Union | Louisiana | 22111 | 3103 | 88 |
1597039 | 1597039 | 2021-08-08 | Brown | Minnesota | 27015 | 3103 | 40 |
1593790 | 1593790 | 2021-08-07 | Brown | Minnesota | 27015 | 3103 | 40 |
1590541 | 1590541 | 2021-08-06 | Brown | Minnesota | 27015 | 3103 | 40 |
1540604 | 1540604 | 2021-07-22 | Carroll | Arkansas | 5015 | 3103 | 47 |
1473834 | 1473834 | 2021-07-01 | Dunklin | Missouri | 29069 | 3103 | 50 |
1385313 | 1385313 | 2021-06-04 | Iroquois | Illinois | 17075 | 3103 | 69 |
1379557 | 1379557 | 2021-06-02 | Mille Lacs | Minnesota | 27095 | 3103 | 54 |
1376312 | 1376312 | 2021-06-01 | Mille Lacs | Minnesota | 27095 | 3103 | 54 |
1373066 | 1373066 | 2021-05-31 | Mille Lacs | Minnesota | 27095 | 3103 | 54 |
1369821 | 1369821 | 2021-05-30 | Mille Lacs | Minnesota | 27095 | 3103 | 54 |
1366575 | 1366575 | 2021-05-29 | Mille Lacs | Minnesota | 27095 | 3103 | 54 |
1363329 | 1363329 | 2021-05-28 | Mille Lacs | Minnesota | 27095 | 3103 | 54 |
1354742 | 1354742 | 2021-05-25 | Yankton | South Dakota | 46135 | 3103 | 34 |
1311014 | 1311014 | 2021-05-12 | Bell | Kentucky | 21013 | 3103 | 54 |
1292807 | 1292807 | 2021-05-06 | Clarion | Pennsylvania | 42031 | 3103 | 91 |
1280146 | 1280146 | 2021-05-02 | Scott | Tennessee | 47151 | 3103 | 45 |
1276899 | 1276899 | 2021-05-01 | Scott | Tennessee | 47151 | 3103 | 45 |
1273652 | 1273652 | 2021-04-30 | Scott | Tennessee | 47151 | 3103 | 45 |
1263490 | 1263490 | 2021-04-27 | Jackson | Oklahoma | 40065 | 3103 | 56 |
1260243 | 1260243 | 2021-04-26 | Jackson | Oklahoma | 40065 | 3103 | 56 |
1256904 | 1256904 | 2021-04-25 | Guernsey | Ohio | 39059 | 3103 | 50 |
1256996 | 1256996 | 2021-04-25 | Jackson | Oklahoma | 40065 | 3103 | 56 |
1253749 | 1253749 | 2021-04-24 | Jackson | Oklahoma | 40065 | 3103 | 56 |
1250502 | 1250502 | 2021-04-23 | Jackson | Oklahoma | 40065 | 3103 | 56 |
1247255 | 1247255 | 2021-04-22 | Jackson | Oklahoma | 40065 | 3103 | 56 |
1243204 | 1243204 | 2021-04-21 | Nicollet | Minnesota | 27103 | 3103 | 43 |
1244008 | 1244008 | 2021-04-21 | Jackson | Oklahoma | 40065 | 3103 | 56 |
1240984 | 1240984 | 2021-04-20 | Vega Baja | Puerto Rico | 72145 | 3103 | |
1226973 | 1226973 | 2021-04-16 | Pine | Minnesota | 27115 | 3103 | 21 |
1223481 | 1223481 | 2021-04-15 | East Feliciana | Louisiana | 22037 | 3103 | 112 |
1215958 | 1215958 | 2021-04-13 | Baxter | Arkansas | 5005 | 3103 | 102 |
1212711 | 1212711 | 2021-04-12 | Baxter | Arkansas | 5005 | 3103 | 102 |
1213746 | 1213746 | 2021-04-12 | Jefferson Davis | Louisiana | 22053 | 3103 | 92 |
1215165 | 1215165 | 2021-04-12 | Henry | Tennessee | 47079 | 3103 | 75 |
1209463 | 1209463 | 2021-04-11 | Baxter | Arkansas | 5005 | 3103 | 102 |
1206214 | 1206214 | 2021-04-10 | Baxter | Arkansas | 5005 | 3103 | 102 |
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);