ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
202 rows where cases = 2867 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 17
- Minnesota 15
- Texas 14
- Virginia 13
- Arkansas 10
- Michigan 10
- Tennessee 9
- Iowa 8
- Oklahoma 8
- Mississippi 7
- Georgia 6
- North Carolina 6
- Louisiana 5
- Missouri 5
- Ohio 5
- West Virginia 5
- Wisconsin 5
- Alabama 4
- Illinois 4
- Kansas 4
- New York 4
- Puerto Rico 4
- South Dakota 4
- Florida 3
- Idaho 3
- Indiana 3
- Maryland 3
- Nevada 3
- New Mexico 3
- California 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500413 | 2500413 | 2022-05-13 | Hancock | Iowa | 19081 | 2867 | 47 |
2497155 | 2497155 | 2022-05-12 | Hancock | Iowa | 19081 | 2867 | 47 |
2493897 | 2493897 | 2022-05-11 | Hancock | Iowa | 19081 | 2867 | 47 |
2491635 | 2491635 | 2022-05-10 | Los Alamos | New Mexico | 35028 | 2867 | 16 |
2488927 | 2488927 | 2022-05-09 | Luquillo | Puerto Rico | 72089 | 2867 | |
2472918 | 2472918 | 2022-05-04 | Camp | Texas | 48063 | 2867 | 74 |
2467291 | 2467291 | 2022-05-03 | Park | Colorado | 8093 | 2867 | 20 |
2469662 | 2469662 | 2022-05-03 | Camp | Texas | 48063 | 2867 | 74 |
2466406 | 2466406 | 2022-05-02 | Camp | Texas | 48063 | 2867 | 74 |
2463151 | 2463151 | 2022-05-01 | Camp | Texas | 48063 | 2867 | 74 |
2459895 | 2459895 | 2022-04-30 | Camp | Texas | 48063 | 2867 | 74 |
2438784 | 2438784 | 2022-04-24 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2435528 | 2435528 | 2022-04-23 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2432272 | 2432272 | 2022-04-22 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2429016 | 2429016 | 2022-04-21 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2425760 | 2425760 | 2022-04-20 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2422504 | 2422504 | 2022-04-19 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2419248 | 2419248 | 2022-04-18 | Metcalfe | Kentucky | 21169 | 2867 | 64 |
2415992 | 2415992 | 2022-04-17 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2412736 | 2412736 | 2022-04-16 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2409480 | 2409480 | 2022-04-15 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2406224 | 2406224 | 2022-04-14 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2402968 | 2402968 | 2022-04-13 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2399714 | 2399714 | 2022-04-12 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2396458 | 2396458 | 2022-04-11 | Metcalfe | Kentucky | 21169 | 2867 | 63 |
2353316 | 2353316 | 2022-03-29 | Archuleta | Colorado | 8007 | 2867 | 15 |
2252391 | 2252391 | 2022-02-26 | Lee | Arkansas | 5077 | 2867 | 56 |
2225507 | 2225507 | 2022-02-17 | Todd | South Dakota | 46121 | 2867 | 47 |
2214618 | 2214618 | 2022-02-14 | Pope | Minnesota | 27121 | 2867 | 17 |
2200427 | 2200427 | 2022-02-10 | Mariposa | California | 6043 | 2867 | 20 |
2183109 | 2183109 | 2022-02-04 | Villalba | Puerto Rico | 72149 | 2867 | |
2172787 | 2172787 | 2022-02-01 | Torrance | New Mexico | 35057 | 2867 | 47 |
2098051 | 2098051 | 2022-01-09 | Chowan | North Carolina | 37041 | 2867 | 45 |
2094799 | 2094799 | 2022-01-08 | Chowan | North Carolina | 37041 | 2867 | 45 |
2091547 | 2091547 | 2022-01-07 | Chowan | North Carolina | 37041 | 2867 | 45 |
2092725 | 2092725 | 2022-01-07 | Braxton | West Virginia | 54007 | 2867 | 32 |
2082029 | 2082029 | 2022-01-04 | Choctaw | Oklahoma | 40023 | 2867 | 52 |
2078777 | 2078777 | 2022-01-03 | Choctaw | Oklahoma | 40023 | 2867 | 52 |
2075526 | 2075526 | 2022-01-02 | Choctaw | Oklahoma | 40023 | 2867 | 52 |
2072275 | 2072275 | 2022-01-01 | Choctaw | Oklahoma | 40023 | 2867 | 52 |
2069024 | 2069024 | 2021-12-31 | Choctaw | Oklahoma | 40023 | 2867 | 52 |
2065773 | 2065773 | 2021-12-30 | Choctaw | Oklahoma | 40023 | 2867 | 52 |
2062523 | 2062523 | 2021-12-29 | Choctaw | Oklahoma | 40023 | 2867 | 52 |
2063304 | 2063304 | 2021-12-29 | Buckingham | Virginia | 51029 | 2867 | 41 |
2034497 | 2034497 | 2021-12-21 | Franklin | Arkansas | 5047 | 2867 | 58 |
2018718 | 2018718 | 2021-12-16 | Carroll | Illinois | 17015 | 2867 | 42 |
2008478 | 2008478 | 2021-12-13 | Clay | Arkansas | 5021 | 2867 | 77 |
2011519 | 2011519 | 2021-12-13 | Burnett | Wisconsin | 55013 | 2867 | 35 |
2005227 | 2005227 | 2021-12-12 | Clay | Arkansas | 5021 | 2867 | 77 |
2005502 | 2005502 | 2021-12-12 | Banks | Georgia | 13011 | 2867 | 68 |
2002251 | 2002251 | 2021-12-11 | Banks | Georgia | 13011 | 2867 | 68 |
1999001 | 1999001 | 2021-12-10 | Banks | Georgia | 13011 | 2867 | 68 |
1942832 | 1942832 | 2021-11-22 | Houston | Texas | 48225 | 2867 | 86 |
1939582 | 1939582 | 2021-11-21 | Houston | Texas | 48225 | 2867 | 86 |
1936332 | 1936332 | 2021-11-20 | Houston | Texas | 48225 | 2867 | 86 |
1933082 | 1933082 | 2021-11-19 | Houston | Texas | 48225 | 2867 | 86 |
1927706 | 1927706 | 2021-11-18 | Clark | Illinois | 17023 | 2867 | 50 |
1929831 | 1929831 | 2021-11-18 | Houston | Texas | 48225 | 2867 | 86 |
1907370 | 1907370 | 2021-11-11 | Powhatan | Virginia | 51145 | 2867 | 28 |
1870123 | 1870123 | 2021-10-31 | Clinton | Missouri | 29049 | 2867 | 77 |
1842233 | 1842233 | 2021-10-22 | Young | Texas | 48503 | 2867 | 66 |
1832996 | 1832996 | 2021-10-20 | Grant | Arkansas | 5053 | 2867 | 47 |
1830966 | 1830966 | 2021-10-19 | Hubbard | Minnesota | 27057 | 2867 | 44 |
1829390 | 1829390 | 2021-10-18 | Radford city | Virginia | 51750 | 2867 | 31 |
1813331 | 1813331 | 2021-10-13 | Taylor | Wisconsin | 55119 | 2867 | 44 |
1798334 | 1798334 | 2021-10-09 | Garrett | Maryland | 24023 | 2867 | 74 |
1790761 | 1790761 | 2021-10-07 | Hempstead | Arkansas | 5057 | 2867 | 27 |
1787502 | 1787502 | 2021-10-06 | Cross | Arkansas | 5037 | 2867 | 59 |
1769484 | 1769484 | 2021-09-30 | Vernon | Missouri | 29217 | 2867 | 64 |
1758721 | 1758721 | 2021-09-27 | Minidoka | Idaho | 16067 | 2867 | 39 |
1745144 | 1745144 | 2021-09-23 | Cherokee | Alabama | 1019 | 2867 | 52 |
1722193 | 1722193 | 2021-09-15 | Waynesboro city | Virginia | 51820 | 2867 | 39 |
1718297 | 1718297 | 2021-09-14 | Vega Alta | Puerto Rico | 72143 | 2867 | |
1693282 | 1693282 | 2021-09-07 | Conway | Arkansas | 5029 | 2867 | 41 |
1694225 | 1694225 | 2021-09-07 | Letcher | Kentucky | 21133 | 2867 | 52 |
1689962 | 1689962 | 2021-09-06 | Pickens | Alabama | 1107 | 2867 | 63 |
1682910 | 1682910 | 2021-09-03 | Jones | Texas | 48253 | 2867 | 61 |
1641334 | 1641334 | 2021-08-22 | Logan | Arkansas | 5083 | 2867 | 27 |
1642446 | 1642446 | 2021-08-22 | Dickinson | Michigan | 26043 | 2867 | 74 |
1639196 | 1639196 | 2021-08-21 | Dickinson | Michigan | 26043 | 2867 | 74 |
1635946 | 1635946 | 2021-08-20 | Dickinson | Michigan | 26043 | 2867 | 74 |
1624113 | 1624113 | 2021-08-16 | Barnwell | South Carolina | 45011 | 2867 | 58 |
1607959 | 1607959 | 2021-08-11 | Meade | South Dakota | 46093 | 2867 | 31 |
1601981 | 1601981 | 2021-08-09 | Pulaski | Virginia | 51155 | 2867 | 69 |
1596881 | 1596881 | 2021-08-08 | Union | Louisiana | 22111 | 2867 | 85 |
1593632 | 1593632 | 2021-08-07 | Union | Louisiana | 22111 | 2867 | 85 |
1594325 | 1594325 | 2021-08-07 | Lewis | New York | 36049 | 2867 | 36 |
1590383 | 1590383 | 2021-08-06 | Union | Louisiana | 22111 | 2867 | 85 |
1574485 | 1574485 | 2021-08-01 | Crawford | Missouri | 29055 | 2867 | 41 |
1566385 | 1566385 | 2021-07-29 | Door | Wisconsin | 55029 | 2867 | 37 |
1563137 | 1563137 | 2021-07-28 | Door | Wisconsin | 55029 | 2867 | 37 |
1548192 | 1548192 | 2021-07-24 | Dorchester | Maryland | 24019 | 2867 | 65 |
1545342 | 1545342 | 2021-07-23 | Washington | Missouri | 29221 | 2867 | 53 |
1530811 | 1530811 | 2021-07-19 | Winston | Alabama | 1133 | 2867 | 72 |
1530636 | 1530636 | 2021-07-18 | Randolph | West Virginia | 54083 | 2867 | 15 |
1527389 | 1527389 | 2021-07-17 | Randolph | West Virginia | 54083 | 2867 | 15 |
1524142 | 1524142 | 2021-07-16 | Randolph | West Virginia | 54083 | 2867 | 15 |
1517930 | 1517930 | 2021-07-15 | Sevier | Arkansas | 5133 | 2867 | 24 |
1518710 | 1518710 | 2021-07-15 | Miami | Kansas | 20121 | 2867 | 42 |
1515463 | 1515463 | 2021-07-14 | Miami | Kansas | 20121 | 2867 | 42 |
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);