ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
158 rows where cases = 3503 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 13
- Texas 11
- Kansas 9
- Oklahoma 9
- South Carolina 9
- Minnesota 8
- Tennessee 8
- Georgia 7
- Louisiana 7
- Florida 6
- Indiana 6
- Missouri 5
- North Carolina 5
- Pennsylvania 5
- Wisconsin 5
- Alabama 4
- Arkansas 4
- Michigan 4
- Ohio 4
- Illinois 3
- New York 3
- Virgin Islands 3
- Virginia 3
- California 2
- Iowa 2
- Mississippi 2
- West Virginia 2
- Colorado 1
- Delaware 1
- Maryland 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2419522 | 2419522 | 2022-04-18 | Kanabec | Minnesota | 27065 | 3503 | 55 |
2370733 | 2370733 | 2022-04-03 | Sibley | Minnesota | 27143 | 3503 | 24 |
2367480 | 2367480 | 2022-04-02 | Sibley | Minnesota | 27143 | 3503 | 24 |
2364227 | 2364227 | 2022-04-01 | Sibley | Minnesota | 27143 | 3503 | 24 |
2358662 | 2358662 | 2022-03-30 | Aibonito | Puerto Rico | 72009 | 3503 | |
2259137 | 2259137 | 2022-02-28 | Bacon | Georgia | 13005 | 3503 | 72 |
2248376 | 2248376 | 2022-02-24 | Bandera | Texas | 48019 | 3503 | 73 |
2235615 | 2235615 | 2022-02-20 | Zapata | Texas | 48505 | 3503 | 50 |
2211162 | 2211162 | 2022-02-13 | West Carroll | Louisiana | 22123 | 3503 | 57 |
2207909 | 2207909 | 2022-02-12 | West Carroll | Louisiana | 22123 | 3503 | 57 |
2204656 | 2204656 | 2022-02-11 | West Carroll | Louisiana | 22123 | 3503 | 57 |
2174704 | 2174704 | 2022-02-02 | Rabun | Georgia | 13241 | 3503 | 85 |
2175219 | 2175219 | 2022-02-02 | Casey | Kentucky | 21045 | 3503 | 65 |
2169670 | 2169670 | 2022-01-31 | Polk | North Carolina | 37149 | 3503 | 49 |
2156061 | 2156061 | 2022-01-27 | Redwood | Minnesota | 27127 | 3503 | 50 |
2150941 | 2150941 | 2022-01-25 | Llano | Texas | 48299 | 3503 | 87 |
2128763 | 2128763 | 2022-01-19 | Clay | Arkansas | 5021 | 3503 | 77 |
2129711 | 2129711 | 2022-01-19 | Lewis | Kentucky | 21135 | 3503 | 71 |
2107494 | 2107494 | 2022-01-12 | Big Horn | Montana | 30003 | 3503 | 86 |
2080975 | 2080975 | 2022-01-04 | Spencer | Kentucky | 21215 | 3503 | 44 |
2075253 | 2075253 | 2022-01-02 | Schoharie | New York | 36095 | 3503 | 29 |
2075909 | 2075909 | 2022-01-02 | Crockett | Tennessee | 47033 | 3503 | 75 |
2072658 | 2072658 | 2022-01-01 | Crockett | Tennessee | 47033 | 3503 | 75 |
2069407 | 2069407 | 2021-12-31 | Crockett | Tennessee | 47033 | 3503 | 75 |
2066156 | 2066156 | 2021-12-30 | Crockett | Tennessee | 47033 | 3503 | 75 |
2055469 | 2055469 | 2021-12-27 | Texas | Missouri | 29215 | 3503 | 71 |
2032684 | 2032684 | 2021-12-20 | New Madrid | Missouri | 29143 | 3503 | 71 |
2029433 | 2029433 | 2021-12-19 | New Madrid | Missouri | 29143 | 3503 | 71 |
2026182 | 2026182 | 2021-12-18 | New Madrid | Missouri | 29143 | 3503 | 71 |
2018872 | 2018872 | 2021-12-16 | Orange | Indiana | 18117 | 3503 | 79 |
2019368 | 2019368 | 2021-12-16 | Cheboygan | Michigan | 26031 | 3503 | 79 |
2016118 | 2016118 | 2021-12-15 | Cheboygan | Michigan | 26031 | 3503 | 79 |
2008832 | 2008832 | 2021-12-13 | Lamar | Georgia | 13171 | 3503 | 99 |
2008211 | 2008211 | 2021-12-12 | Brooke | West Virginia | 54009 | 3503 | 81 |
1995516 | 1995516 | 2021-12-09 | Ouachita | Arkansas | 5103 | 3503 | 87 |
1997654 | 1997654 | 2021-12-09 | Juniata | Pennsylvania | 42067 | 3503 | 134 |
1995066 | 1995066 | 2021-12-08 | Dinwiddie | Virginia | 51053 | 3503 | 60 |
1985750 | 1985750 | 2021-12-06 | Lawrence | Arkansas | 5075 | 3503 | 62 |
1985773 | 1985773 | 2021-12-06 | Randolph | Arkansas | 5121 | 3503 | 64 |
1985277 | 1985277 | 2021-12-05 | St. Croix | Virgin Islands | 78010 | 3503 | 37 |
1982027 | 1982027 | 2021-12-04 | St. Croix | Virgin Islands | 78010 | 3503 | 37 |
1978777 | 1978777 | 2021-12-03 | St. Croix | Virgin Islands | 78010 | 3503 | 37 |
1967095 | 1967095 | 2021-11-30 | Sumner | Kansas | 20191 | 3503 | 62 |
1963843 | 1963843 | 2021-11-29 | Sumner | Kansas | 20191 | 3503 | 62 |
1930112 | 1930112 | 2021-11-18 | Page | Virginia | 51139 | 3503 | 84 |
1905073 | 1905073 | 2021-11-11 | Fountain | Indiana | 18045 | 3503 | 62 |
1899419 | 1899419 | 2021-11-09 | Nodaway | Missouri | 29147 | 3503 | 34 |
1894527 | 1894527 | 2021-11-07 | Jackson | Wisconsin | 55053 | 3503 | 34 |
1891277 | 1891277 | 2021-11-06 | Jackson | Wisconsin | 55053 | 3503 | 34 |
1888027 | 1888027 | 2021-11-05 | Jackson | Wisconsin | 55053 | 3503 | 34 |
1877631 | 1877631 | 2021-11-02 | Bledsoe | Tennessee | 47007 | 3503 | 18 |
1853302 | 1853302 | 2021-10-26 | Labette | Kansas | 20099 | 3503 | 60 |
1850053 | 1850053 | 2021-10-25 | Labette | Kansas | 20099 | 3503 | 60 |
1828935 | 1828935 | 2021-10-18 | Johnson | Tennessee | 47091 | 3503 | 47 |
1821961 | 1821961 | 2021-10-16 | Hocking | Ohio | 39073 | 3503 | 78 |
1807402 | 1807402 | 2021-10-12 | Union | Georgia | 13291 | 3503 | 115 |
1808967 | 1808967 | 2021-10-12 | Holmes | Ohio | 39075 | 3503 | 120 |
1790085 | 1790085 | 2021-10-06 | Gonzales | Texas | 48177 | 3503 | 78 |
1787292 | 1787292 | 2021-10-05 | Door | Wisconsin | 55029 | 3503 | 38 |
1778532 | 1778532 | 2021-10-03 | Cherokee | Kansas | 20021 | 3503 | 77 |
1775282 | 1775282 | 2021-10-02 | Cherokee | Kansas | 20021 | 3503 | 77 |
1772032 | 1772032 | 2021-10-01 | Cherokee | Kansas | 20021 | 3503 | 77 |
1743367 | 1743367 | 2021-09-22 | Stone | Mississippi | 28131 | 3503 | 59 |
1716555 | 1716555 | 2021-09-14 | McDonough | Illinois | 17109 | 3503 | 67 |
1697548 | 1697548 | 2021-09-08 | Grant | Louisiana | 22043 | 3503 | 70 |
1699111 | 1699111 | 2021-09-08 | Frio | Texas | 48163 | 3503 | 59 |
1699463 | 1699463 | 2021-09-08 | Wythe | Virginia | 51197 | 3503 | 86 |
1633726 | 1633726 | 2021-08-19 | Greene | Pennsylvania | 42059 | 3503 | 42 |
1533173 | 1533173 | 2021-07-19 | Clarendon | South Carolina | 45027 | 3503 | 113 |
1486325 | 1486325 | 2021-07-05 | Floyd | Kentucky | 21071 | 3503 | 73 |
1483079 | 1483079 | 2021-07-04 | Floyd | Kentucky | 21071 | 3503 | 73 |
1479832 | 1479832 | 2021-07-03 | Floyd | Kentucky | 21071 | 3503 | 73 |
1476586 | 1476586 | 2021-07-02 | Floyd | Kentucky | 21071 | 3503 | 73 |
1477695 | 1477695 | 2021-07-02 | Williams | Ohio | 39171 | 3503 | 78 |
1473340 | 1473340 | 2021-07-01 | Floyd | Kentucky | 21071 | 3503 | 72 |
1470094 | 1470094 | 2021-06-30 | Floyd | Kentucky | 21071 | 3503 | 72 |
1466849 | 1466849 | 2021-06-29 | Floyd | Kentucky | 21071 | 3503 | 72 |
1463604 | 1463604 | 2021-06-28 | Floyd | Kentucky | 21071 | 3503 | 72 |
1461298 | 1461298 | 2021-06-27 | Person | North Carolina | 37145 | 3503 | 71 |
1461770 | 1461770 | 2021-06-27 | Marlboro | South Carolina | 45069 | 3503 | 57 |
1458053 | 1458053 | 2021-06-26 | Person | North Carolina | 37145 | 3503 | 71 |
1458525 | 1458525 | 2021-06-26 | Marlboro | South Carolina | 45069 | 3503 | 57 |
1454808 | 1454808 | 2021-06-25 | Person | North Carolina | 37145 | 3503 | 71 |
1455280 | 1455280 | 2021-06-25 | Marlboro | South Carolina | 45069 | 3503 | 57 |
1452035 | 1452035 | 2021-06-24 | Marlboro | South Carolina | 45069 | 3503 | 57 |
1445544 | 1445544 | 2021-06-22 | Marlboro | South Carolina | 45069 | 3503 | 57 |
1442299 | 1442299 | 2021-06-21 | Marlboro | South Carolina | 45069 | 3503 | 57 |
1428719 | 1428719 | 2021-06-17 | Chenango | New York | 36017 | 3503 | 76 |
1411699 | 1411699 | 2021-06-12 | Knox | Kentucky | 21121 | 3503 | 45 |
1362492 | 1362492 | 2021-05-28 | Upson | Georgia | 13293 | 3503 | 131 |
1362660 | 1362660 | 2021-05-28 | Adams | Indiana | 18001 | 3503 | 56 |
1359413 | 1359413 | 2021-05-27 | Adams | Indiana | 18001 | 3503 | 56 |
1355338 | 1355338 | 2021-05-25 | Marshall | West Virginia | 54051 | 3503 | 77 |
1351606 | 1351606 | 2021-05-24 | Bee | Texas | 48025 | 3503 | 72 |
1347572 | 1347572 | 2021-05-23 | Allegany | New York | 36003 | 3503 | 84 |
1348360 | 1348360 | 2021-05-23 | Bee | Texas | 48025 | 3503 | 72 |
1333093 | 1333093 | 2021-05-19 | Levy | Florida | 12075 | 3503 | 54 |
1315889 | 1315889 | 2021-05-13 | Bee | Texas | 48025 | 3503 | 72 |
1307085 | 1307085 | 2021-05-11 | Baker | Florida | 12003 | 3503 | 60 |
1303839 | 1303839 | 2021-05-10 | Baker | Florida | 12003 | 3503 | 60 |
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);