ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
242 rows where cases = 2084 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 21
- Kentucky 15
- Texas 15
- Wisconsin 14
- Florida 11
- Illinois 11
- Minnesota 11
- South Carolina 11
- Arkansas 10
- Kansas 9
- Missouri 9
- Tennessee 9
- Mississippi 8
- Virginia 8
- Alabama 7
- Colorado 7
- Louisiana 7
- North Carolina 6
- Iowa 5
- Pennsylvania 5
- Puerto Rico 5
- Indiana 4
- New York 4
- Michigan 3
- North Dakota 3
- West Virginia 3
- Arizona 2
- Maine 2
- Maryland 2
- Montana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448831 | 2448831 | 2022-04-27 | Lake | Minnesota | 27075 | 2084 | 28 |
2449890 | 2449890 | 2022-04-27 | Allendale | South Carolina | 45005 | 2084 | 24 |
2446633 | 2446633 | 2022-04-26 | Allendale | South Carolina | 45005 | 2084 | 24 |
2443378 | 2443378 | 2022-04-25 | Allendale | South Carolina | 45005 | 2084 | 24 |
2440122 | 2440122 | 2022-04-24 | Allendale | South Carolina | 45005 | 2084 | 24 |
2436866 | 2436866 | 2022-04-23 | Allendale | South Carolina | 45005 | 2084 | 24 |
2433610 | 2433610 | 2022-04-22 | Allendale | South Carolina | 45005 | 2084 | 24 |
2430354 | 2430354 | 2022-04-21 | Allendale | South Carolina | 45005 | 2084 | 24 |
2427098 | 2427098 | 2022-04-20 | Allendale | South Carolina | 45005 | 2084 | 24 |
2423842 | 2423842 | 2022-04-19 | Allendale | South Carolina | 45005 | 2084 | 24 |
2271925 | 2271925 | 2022-03-04 | Searcy | Arkansas | 5129 | 2084 | 41 |
2270870 | 2270870 | 2022-03-03 | Jayuya | Puerto Rico | 72073 | 2084 | |
2265297 | 2265297 | 2022-03-02 | Perry | Alabama | 1105 | 2084 | 43 |
2262047 | 2262047 | 2022-03-01 | Perry | Alabama | 1105 | 2084 | 43 |
2263024 | 2263024 | 2022-03-01 | Crittenden | Kentucky | 21055 | 2084 | 44 |
2256506 | 2256506 | 2022-02-27 | Bracken | Kentucky | 21023 | 2084 | 24 |
2253255 | 2253255 | 2022-02-26 | Bracken | Kentucky | 21023 | 2084 | 24 |
2250004 | 2250004 | 2022-02-25 | Bracken | Kentucky | 21023 | 2084 | 24 |
2248371 | 2248371 | 2022-02-24 | Archer | Texas | 48009 | 2084 | 28 |
2244087 | 2244087 | 2022-02-23 | St. Clair | Missouri | 29185 | 2084 | 31 |
2245120 | 2245120 | 2022-02-23 | Archer | Texas | 48009 | 2084 | 28 |
2241869 | 2241869 | 2022-02-22 | Archer | Texas | 48009 | 2084 | 27 |
2201878 | 2201878 | 2022-02-10 | Sanders | Montana | 30089 | 2084 | 44 |
2174295 | 2174295 | 2022-02-02 | Greenlee | Arizona | 4011 | 2084 | 30 |
2176139 | 2176139 | 2022-02-02 | Graham | North Carolina | 37075 | 2084 | 30 |
2171406 | 2171406 | 2022-02-01 | Heard | Georgia | 13149 | 2084 | 44 |
2154843 | 2154843 | 2022-01-27 | Scott | Arkansas | 5127 | 2084 | 35 |
2156963 | 2156963 | 2022-01-27 | Forest | Pennsylvania | 42053 | 2084 | 34 |
2143052 | 2143052 | 2022-01-23 | Rock | Minnesota | 27133 | 2084 | 32 |
2139797 | 2139797 | 2022-01-22 | Rock | Minnesota | 27133 | 2084 | 32 |
2136541 | 2136541 | 2022-01-21 | Rock | Minnesota | 27133 | 2084 | 32 |
2131614 | 2131614 | 2022-01-19 | Floyd | Virginia | 51063 | 2084 | 33 |
2117163 | 2117163 | 2022-01-15 | Douglas | Missouri | 29067 | 2084 | 68 |
2109053 | 2109053 | 2022-01-12 | Forest | Wisconsin | 55041 | 2084 | 45 |
2087030 | 2087030 | 2022-01-06 | Marshall | Illinois | 17123 | 2084 | 26 |
2065987 | 2065987 | 2021-12-30 | Loiza | Puerto Rico | 72087 | 2084 | |
2041134 | 2041134 | 2021-12-23 | Gunnison | Colorado | 8051 | 2084 | 13 |
1884997 | 1884997 | 2021-11-05 | Little River | Arkansas | 5081 | 2084 | 77 |
1879819 | 1879819 | 2021-11-03 | Perry | Mississippi | 28111 | 2084 | 56 |
1881352 | 1881352 | 2021-11-03 | Martinsville city | Virginia | 51690 | 2084 | 90 |
1876570 | 1876570 | 2021-11-02 | Perry | Mississippi | 28111 | 2084 | 56 |
1829759 | 1829759 | 2021-10-19 | Lee | Arkansas | 5077 | 2084 | 48 |
1826510 | 1826510 | 2021-10-18 | Lee | Arkansas | 5077 | 2084 | 48 |
1823261 | 1823261 | 2021-10-17 | Lee | Arkansas | 5077 | 2084 | 48 |
1814402 | 1814402 | 2021-10-14 | Fleming | Kentucky | 21069 | 2084 | 32 |
1811153 | 1811153 | 2021-10-13 | Fleming | Kentucky | 21069 | 2084 | 32 |
1791283 | 1791283 | 2021-10-07 | Mason | Illinois | 17125 | 2084 | 52 |
1783296 | 1783296 | 2021-10-04 | Bamberg | South Carolina | 45009 | 2084 | 63 |
1778322 | 1778322 | 2021-10-03 | Washington | Illinois | 17189 | 2084 | 34 |
1775072 | 1775072 | 2021-10-02 | Washington | Illinois | 17189 | 2084 | 34 |
1771822 | 1771822 | 2021-10-01 | Washington | Illinois | 17189 | 2084 | 34 |
1772326 | 1772326 | 2021-10-01 | Waldo | Maine | 23027 | 2084 | 30 |
1769077 | 1769077 | 2021-09-30 | Waldo | Maine | 23027 | 2084 | 29 |
1765126 | 1765126 | 2021-09-29 | Oglethorpe | Georgia | 13221 | 2084 | 37 |
1749944 | 1749944 | 2021-09-24 | Macon | Missouri | 29121 | 2084 | 20 |
1748078 | 1748078 | 2021-09-23 | Buchanan | Virginia | 51027 | 2084 | 47 |
1743420 | 1743420 | 2021-09-22 | Gasconade | Missouri | 29073 | 2084 | 48 |
1733207 | 1733207 | 2021-09-19 | Lewis | Kentucky | 21135 | 2084 | 48 |
1729957 | 1729957 | 2021-09-18 | Lewis | Kentucky | 21135 | 2084 | 48 |
1726707 | 1726707 | 2021-09-17 | Lewis | Kentucky | 21135 | 2084 | 48 |
1725257 | 1725257 | 2021-09-16 | Wilbarger | Texas | 48487 | 2084 | 56 |
1702645 | 1702645 | 2021-09-09 | King George | Virginia | 51099 | 2084 | 21 |
1693853 | 1693853 | 2021-09-07 | Warren | Illinois | 17187 | 2084 | 54 |
1656733 | 1656733 | 2021-08-26 | Grundy | Tennessee | 47061 | 2084 | 36 |
1652971 | 1652971 | 2021-08-25 | Richland | North Dakota | 38077 | 2084 | 17 |
1631769 | 1631769 | 2021-08-19 | Dixie | Florida | 12029 | 2084 | 24 |
1628522 | 1628522 | 2021-08-18 | Dixie | Florida | 12029 | 2084 | 24 |
1631339 | 1631339 | 2021-08-18 | Adams | Wisconsin | 55001 | 2084 | 21 |
1625275 | 1625275 | 2021-08-17 | Dixie | Florida | 12029 | 2084 | 24 |
1622028 | 1622028 | 2021-08-16 | Dixie | Florida | 12029 | 2084 | 24 |
1618781 | 1618781 | 2021-08-15 | Dixie | Florida | 12029 | 2084 | 24 |
1620335 | 1620335 | 2021-08-15 | Seneca | New York | 36099 | 2084 | 57 |
1615533 | 1615533 | 2021-08-14 | Dixie | Florida | 12029 | 2084 | 24 |
1612284 | 1612284 | 2021-08-13 | Dixie | Florida | 12029 | 2084 | 24 |
1605628 | 1605628 | 2021-08-11 | Sharp | Arkansas | 5135 | 2084 | 53 |
1603706 | 1603706 | 2021-08-10 | Benton | Missouri | 29015 | 2084 | 37 |
1590421 | 1590421 | 2021-08-06 | Garrett | Maryland | 24023 | 2084 | 66 |
1585093 | 1585093 | 2021-08-04 | Naranjito | Puerto Rico | 72105 | 2084 | |
1579123 | 1579123 | 2021-08-02 | Franklin | Vermont | 50011 | 2084 | 39 |
1579386 | 1579386 | 2021-08-02 | Green Lake | Wisconsin | 55047 | 2084 | 25 |
1576138 | 1576138 | 2021-08-01 | Green Lake | Wisconsin | 55047 | 2084 | 25 |
1572890 | 1572890 | 2021-07-31 | Green Lake | Wisconsin | 55047 | 2084 | 25 |
1569642 | 1569642 | 2021-07-30 | Green Lake | Wisconsin | 55047 | 2084 | 25 |
1561375 | 1561375 | 2021-07-28 | Wabasha | Minnesota | 27157 | 2084 | 3 |
1557450 | 1557450 | 2021-07-27 | Fulton | Indiana | 18049 | 2084 | 45 |
1558127 | 1558127 | 2021-07-27 | Wabasha | Minnesota | 27157 | 2084 | 3 |
1554880 | 1554880 | 2021-07-26 | Wabasha | Minnesota | 27157 | 2084 | 3 |
1556088 | 1556088 | 2021-07-26 | Unicoi | Tennessee | 47171 | 2084 | 50 |
1533867 | 1533867 | 2021-07-19 | Mason | West Virginia | 54053 | 2084 | 37 |
1527986 | 1527986 | 2021-07-18 | Meriwether | Georgia | 13199 | 2084 | 91 |
1528106 | 1528106 | 2021-07-18 | Cass | Illinois | 17017 | 2084 | 36 |
1524739 | 1524739 | 2021-07-17 | Meriwether | Georgia | 13199 | 2084 | 91 |
1524859 | 1524859 | 2021-07-17 | Cass | Illinois | 17017 | 2084 | 36 |
1521491 | 1521491 | 2021-07-16 | Meriwether | Georgia | 13199 | 2084 | 91 |
1521611 | 1521611 | 2021-07-16 | Cass | Illinois | 17017 | 2084 | 36 |
1508489 | 1508489 | 2021-07-12 | Lamar | Georgia | 13171 | 2084 | 58 |
1462855 | 1462855 | 2021-06-28 | Montezuma | Colorado | 8083 | 2084 | 25 |
1459610 | 1459610 | 2021-06-27 | Montezuma | Colorado | 8083 | 2084 | 25 |
1460405 | 1460405 | 2021-06-27 | Meade | Kentucky | 21163 | 2084 | 26 |
1457160 | 1457160 | 2021-06-26 | Meade | Kentucky | 21163 | 2084 | 26 |
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);