ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
113 rows where cases = 4866 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 11
- Florida 8
- Georgia 8
- Illinois 8
- Oklahoma 7
- Mississippi 6
- Arkansas 5
- Kansas 5
- California 4
- Indiana 4
- Kentucky 4
- Puerto Rico 4
- West Virginia 4
- New Jersey 3
- Ohio 3
- South Carolina 3
- Virginia 3
- Alabama 2
- Iowa 2
- Michigan 2
- Tennessee 2
- Wisconsin 2
- Hawaii 1
- Maine 1
- Maryland 1
- Minnesota 1
- Nebraska 1
- Nevada 1
- New Hampshire 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500317 | 2500317 | 2022-05-13 | Jay | Indiana | 18075 | 4866 | 78 |
2500349 | 2500349 | 2022-05-13 | Rush | Indiana | 18139 | 4866 | 58 |
2464357 | 2464357 | 2022-05-02 | Clark | Illinois | 17023 | 4866 | 60 |
2449670 | 2449670 | 2022-04-27 | McIntosh | Oklahoma | 40091 | 4866 | 124 |
2446413 | 2446413 | 2022-04-26 | McIntosh | Oklahoma | 40091 | 4866 | 124 |
2443158 | 2443158 | 2022-04-25 | McIntosh | Oklahoma | 40091 | 4866 | 124 |
2439902 | 2439902 | 2022-04-24 | McIntosh | Oklahoma | 40091 | 4866 | 124 |
2436646 | 2436646 | 2022-04-23 | McIntosh | Oklahoma | 40091 | 4866 | 124 |
2433390 | 2433390 | 2022-04-22 | McIntosh | Oklahoma | 40091 | 4866 | 124 |
2430134 | 2430134 | 2022-04-21 | McIntosh | Oklahoma | 40091 | 4866 | 124 |
2375508 | 2375508 | 2022-04-04 | Orange | Vermont | 50017 | 4866 | 14 |
2285225 | 2285225 | 2022-03-08 | Hart | Georgia | 13147 | 4866 | 89 |
2281973 | 2281973 | 2022-03-07 | Hart | Georgia | 13147 | 4866 | 88 |
2271530 | 2271530 | 2022-03-03 | Radford city | Virginia | 51750 | 4866 | 46 |
2258915 | 2258915 | 2022-02-28 | Randolph | Arkansas | 5121 | 4866 | 80 |
2229026 | 2229026 | 2022-02-18 | Milam | Texas | 48331 | 4866 | 97 |
2202565 | 2202565 | 2022-02-10 | Cabo Rojo | Puerto Rico | 72023 | 4866 | |
2180811 | 2180811 | 2022-02-04 | Ashley | Arkansas | 5003 | 4866 | 56 |
2137838 | 2137838 | 2022-01-21 | Dimmit | Texas | 48127 | 4866 | 48 |
2133086 | 2133086 | 2022-01-20 | Hancock | Maine | 23009 | 4866 | 68 |
2123257 | 2123257 | 2022-01-17 | Woodford | Kentucky | 21239 | 4866 | 38 |
2125263 | 2125263 | 2022-01-17 | Mason | West Virginia | 54053 | 4866 | 74 |
2120005 | 2120005 | 2022-01-16 | Woodford | Kentucky | 21239 | 4866 | 38 |
2116753 | 2116753 | 2022-01-15 | Woodford | Kentucky | 21239 | 4866 | 38 |
2113502 | 2113502 | 2022-01-14 | Woodford | Kentucky | 21239 | 4866 | 38 |
2111464 | 2111464 | 2022-01-13 | Aguada | Puerto Rico | 72003 | 4866 | |
2105665 | 2105665 | 2022-01-11 | Russell | Virginia | 51167 | 4866 | 80 |
2089347 | 2089347 | 2022-01-06 | Gloucester | Virginia | 51073 | 4866 | 83 |
2055278 | 2055278 | 2021-12-27 | Adams | Mississippi | 28001 | 4866 | 125 |
2040929 | 2040929 | 2021-12-23 | Winston | Alabama | 1133 | 4866 | 112 |
2009692 | 2009692 | 2021-12-13 | Brown | Minnesota | 27015 | 4866 | 63 |
1990670 | 1990670 | 2021-12-07 | Cibola | New Mexico | 35006 | 4866 | 151 |
1970797 | 1970797 | 2021-12-01 | Itawamba | Mississippi | 28057 | 4866 | 107 |
1937362 | 1937362 | 2021-11-21 | Stephens | Georgia | 13257 | 4866 | 119 |
1939171 | 1939171 | 2021-11-21 | Warren | Pennsylvania | 42123 | 4866 | 147 |
1934112 | 1934112 | 2021-11-20 | Stephens | Georgia | 13257 | 4866 | 119 |
1930860 | 1930860 | 2021-11-19 | Stephens | Georgia | 13257 | 4866 | 119 |
1927271 | 1927271 | 2021-11-18 | St. Francis | Arkansas | 5123 | 4866 | 69 |
1924021 | 1924021 | 2021-11-17 | St. Francis | Arkansas | 5123 | 4866 | 69 |
1924388 | 1924388 | 2021-11-17 | White | Georgia | 13311 | 4866 | 132 |
1830927 | 1830927 | 2021-10-19 | Sanilac | Michigan | 26151 | 4866 | 132 |
1832850 | 1832850 | 2021-10-19 | Park | Wyoming | 56029 | 4866 | 68 |
1827678 | 1827678 | 2021-10-18 | Sanilac | Michigan | 26151 | 4866 | 132 |
1816780 | 1816780 | 2021-10-15 | Poinsett | Arkansas | 5111 | 4866 | 98 |
1801803 | 1801803 | 2021-10-10 | George | Mississippi | 28039 | 4866 | 79 |
1798554 | 1798554 | 2021-10-09 | George | Mississippi | 28039 | 4866 | 79 |
1795305 | 1795305 | 2021-10-08 | George | Mississippi | 28039 | 4866 | 79 |
1769854 | 1769854 | 2021-09-30 | Person | North Carolina | 37145 | 4866 | 85 |
1767300 | 1767300 | 2021-09-29 | Cooke | Texas | 48097 | 4866 | 88 |
1745924 | 1745924 | 2021-09-23 | Wabash | Indiana | 18169 | 4866 | 92 |
1734587 | 1734587 | 2021-09-19 | Marion | South Carolina | 45067 | 4866 | 122 |
1731337 | 1731337 | 2021-09-18 | Marion | South Carolina | 45067 | 4866 | 122 |
1728087 | 1728087 | 2021-09-17 | Marion | South Carolina | 45067 | 4866 | 122 |
1720348 | 1720348 | 2021-09-15 | Calvert | Maryland | 24009 | 4866 | 91 |
1710313 | 1710313 | 2021-09-12 | Cowley | Kansas | 20035 | 4866 | 117 |
1707066 | 1707066 | 2021-09-11 | Cowley | Kansas | 20035 | 4866 | 117 |
1703818 | 1703818 | 2021-09-10 | Cowley | Kansas | 20035 | 4866 | 117 |
1701071 | 1701071 | 2021-09-09 | Alcorn | Mississippi | 28003 | 4866 | 83 |
1631757 | 1631757 | 2021-08-19 | Baker | Florida | 12003 | 4866 | 62 |
1628510 | 1628510 | 2021-08-18 | Baker | Florida | 12003 | 4866 | 62 |
1625263 | 1625263 | 2021-08-17 | Baker | Florida | 12003 | 4866 | 62 |
1622016 | 1622016 | 2021-08-16 | Baker | Florida | 12003 | 4866 | 62 |
1618769 | 1618769 | 2021-08-15 | Baker | Florida | 12003 | 4866 | 62 |
1615521 | 1615521 | 2021-08-14 | Baker | Florida | 12003 | 4866 | 62 |
1612272 | 1612272 | 2021-08-13 | Baker | Florida | 12003 | 4866 | 62 |
1609429 | 1609429 | 2021-08-12 | Gibson | Indiana | 18051 | 4866 | 100 |
1608574 | 1608574 | 2021-08-11 | Marion | West Virginia | 54049 | 4866 | 55 |
1596330 | 1596330 | 2021-08-08 | Effingham | Illinois | 17049 | 4866 | 86 |
1593081 | 1593081 | 2021-08-07 | Effingham | Illinois | 17049 | 4866 | 86 |
1589263 | 1589263 | 2021-08-06 | Russell | Alabama | 1113 | 4866 | 43 |
1589832 | 1589832 | 2021-08-06 | Effingham | Illinois | 17049 | 4866 | 86 |
1534680 | 1534680 | 2021-07-20 | Stephenson | Illinois | 17177 | 4866 | 105 |
1531433 | 1531433 | 2021-07-19 | Stephenson | Illinois | 17177 | 4866 | 105 |
1532598 | 1532598 | 2021-07-19 | Clinton | New York | 36019 | 4866 | 33 |
1515163 | 1515163 | 2021-07-14 | Macoupin | Illinois | 17117 | 4866 | 118 |
1466727 | 1466727 | 2021-06-29 | Crawford | Kansas | 20037 | 4866 | 83 |
1463482 | 1463482 | 2021-06-28 | Crawford | Kansas | 20037 | 4866 | 83 |
1453389 | 1453389 | 2021-06-25 | Maui | Hawaii | 15009 | 4866 | 57 |
1455481 | 1455481 | 2021-06-25 | Burnet | Texas | 48053 | 4866 | 67 |
1452236 | 1452236 | 2021-06-24 | Burnet | Texas | 48053 | 4866 | 67 |
1434217 | 1434217 | 2021-06-19 | Marshall | Iowa | 19127 | 4866 | 76 |
1427726 | 1427726 | 2021-06-17 | Marshall | Iowa | 19127 | 4866 | 76 |
1419527 | 1419527 | 2021-06-14 | Toa Baja | Puerto Rico | 72137 | 4866 | |
1416282 | 1416282 | 2021-06-13 | Toa Baja | Puerto Rico | 72137 | 4866 | |
1407608 | 1407608 | 2021-06-11 | Nevada | California | 6057 | 4866 | 75 |
1386787 | 1386787 | 2021-06-04 | Mercer | Ohio | 39107 | 4866 | 85 |
1319669 | 1319669 | 2021-05-14 | Douglas | Wisconsin | 55031 | 4866 | 57 |
1311775 | 1311775 | 2021-05-12 | Elko | Nevada | 32007 | 4866 | 56 |
1287822 | 1287822 | 2021-05-05 | Ware | Georgia | 13299 | 4866 | 177 |
1251457 | 1251457 | 2021-04-23 | Putnam | West Virginia | 54079 | 4866 | 100 |
1229074 | 1229074 | 2021-04-17 | Tehama | California | 6103 | 4866 | 52 |
1215384 | 1215384 | 2021-04-12 | Medina | Texas | 48325 | 4866 | 103 |
1212137 | 1212137 | 2021-04-11 | Medina | Texas | 48325 | 4866 | 103 |
1208888 | 1208888 | 2021-04-10 | Medina | Texas | 48325 | 4866 | 103 |
1143283 | 1143283 | 2021-03-21 | Seneca | Ohio | 39147 | 4866 | 113 |
1092319 | 1092319 | 2021-03-05 | Harrison | West Virginia | 54033 | 4866 | 70 |
1010696 | 1010696 | 2021-02-08 | Atascosa | Texas | 48013 | 4866 | 118 |
1007450 | 1007450 | 2021-02-07 | Atascosa | Texas | 48013 | 4866 | 118 |
1004204 | 1004204 | 2021-02-06 | Atascosa | Texas | 48013 | 4866 | 117 |
996763 | 996763 | 2021-02-04 | Buffalo | Nebraska | 31019 | 4866 | 54 |
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);