ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
221 rows where cases = 2436 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 25
- Wisconsin 14
- Georgia 12
- Illinois 11
- Iowa 10
- Tennessee 10
- Alabama 9
- Kentucky 9
- Missouri 9
- Colorado 8
- Kansas 8
- Michigan 8
- Louisiana 7
- Ohio 7
- West Virginia 7
- Indiana 6
- Minnesota 6
- Mississippi 6
- Puerto Rico 6
- South Carolina 6
- Texas 6
- North Carolina 4
- South Dakota 4
- Arkansas 3
- New York 3
- California 2
- Oklahoma 2
- Oregon 2
- Pennsylvania 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502099 | 2502099 | 2022-05-13 | Roberts | South Dakota | 46109 | 2436 | 53 |
2498841 | 2498841 | 2022-05-12 | Roberts | South Dakota | 46109 | 2436 | 53 |
2495583 | 2495583 | 2022-05-11 | Roberts | South Dakota | 46109 | 2436 | 53 |
2382241 | 2382241 | 2022-04-06 | Ritchie | West Virginia | 54085 | 2436 | 31 |
2378986 | 2378986 | 2022-04-05 | Ritchie | West Virginia | 54085 | 2436 | 31 |
2309062 | 2309062 | 2022-03-15 | Grundy | Missouri | 29079 | 2436 | 67 |
2238957 | 2238957 | 2022-02-21 | Floyd | Virginia | 51063 | 2436 | 42 |
2206888 | 2206888 | 2022-02-12 | Perry | Arkansas | 5105 | 2436 | 30 |
2174490 | 2174490 | 2022-02-02 | Prowers | Colorado | 8099 | 2436 | 45 |
2177129 | 2177129 | 2022-02-02 | Amelia | Virginia | 51007 | 2436 | 48 |
2155381 | 2155381 | 2022-01-27 | Brown | Indiana | 18013 | 2436 | 59 |
2142657 | 2142657 | 2022-01-23 | Wilson | Kansas | 20205 | 2436 | 35 |
2139402 | 2139402 | 2022-01-22 | Wilson | Kansas | 20205 | 2436 | 35 |
2136146 | 2136146 | 2022-01-21 | Wilson | Kansas | 20205 | 2436 | 35 |
2133283 | 2133283 | 2022-01-20 | Pope | Minnesota | 27121 | 2436 | 14 |
2129302 | 2129302 | 2022-01-19 | Marshall | Illinois | 17123 | 2436 | 28 |
2119003 | 2119003 | 2022-01-16 | Chicot | Arkansas | 5017 | 2436 | 49 |
2087502 | 2087502 | 2022-01-06 | Caldwell | Louisiana | 22021 | 2436 | 42 |
2083700 | 2083700 | 2022-01-05 | Idaho | Idaho | 16049 | 2436 | 42 |
2080636 | 2080636 | 2022-01-04 | Pulaski | Indiana | 18131 | 2436 | 70 |
2035707 | 2035707 | 2021-12-21 | Cottonwood | Minnesota | 27033 | 2436 | 33 |
2037294 | 2037294 | 2021-12-21 | Alleghany | Virginia | 51005 | 2436 | 85 |
2020496 | 2020496 | 2021-12-16 | Naranjito | Puerto Rico | 72105 | 2436 | |
2004235 | 2004235 | 2021-12-11 | Manati | Puerto Rico | 72091 | 2436 | |
2000984 | 2000984 | 2021-12-10 | Manati | Puerto Rico | 72091 | 2436 | |
1946553 | 1946553 | 2021-11-23 | Richland | Wisconsin | 55103 | 2436 | 29 |
1940499 | 1940499 | 2021-11-22 | Brooks | Georgia | 13027 | 2436 | 73 |
1940879 | 1940879 | 2021-11-22 | Tipton | Indiana | 18159 | 2436 | 67 |
1932376 | 1932376 | 2021-11-19 | McKenzie | North Dakota | 38053 | 2436 | 21 |
1929491 | 1929491 | 2021-11-18 | San Lorenzo | Puerto Rico | 72129 | 2436 | |
1925192 | 1925192 | 2021-11-17 | Faribault | Minnesota | 27043 | 2436 | 31 |
1926226 | 1926226 | 2021-11-17 | Moca | Puerto Rico | 72099 | 2436 | |
1914352 | 1914352 | 2021-11-14 | Crowley | Colorado | 8025 | 2436 | 24 |
1910887 | 1910887 | 2021-11-13 | Macon | Alabama | 1087 | 2436 | 64 |
1911102 | 1911102 | 2021-11-13 | Crowley | Colorado | 8025 | 2436 | 24 |
1907853 | 1907853 | 2021-11-12 | Crowley | Colorado | 8025 | 2436 | 24 |
1909977 | 1909977 | 2021-11-12 | Moca | Puerto Rico | 72099 | 2436 | |
1898046 | 1898046 | 2021-11-09 | Inyo | California | 6027 | 2436 | 41 |
1892245 | 1892245 | 2021-11-07 | Atchison | Kansas | 20005 | 2436 | 26 |
1888139 | 1888139 | 2021-11-06 | Macon | Alabama | 1087 | 2436 | 63 |
1888995 | 1888995 | 2021-11-06 | Atchison | Kansas | 20005 | 2436 | 26 |
1884889 | 1884889 | 2021-11-05 | Macon | Alabama | 1087 | 2436 | 63 |
1885745 | 1885745 | 2021-11-05 | Atchison | Kansas | 20005 | 2436 | 26 |
1877612 | 1877612 | 2021-11-02 | Oglala Lakota | South Dakota | 46102 | 2436 | 53 |
1874792 | 1874792 | 2021-11-01 | Buchanan | Virginia | 51027 | 2436 | 61 |
1853747 | 1853747 | 2021-10-26 | Redwood | Minnesota | 27127 | 2436 | 43 |
1830238 | 1830238 | 2021-10-19 | Ford | Illinois | 17053 | 2436 | 67 |
1827057 | 1827057 | 2021-10-18 | Warren | Illinois | 17187 | 2436 | 68 |
1810672 | 1810672 | 2021-10-13 | Kauai | Hawaii | 15007 | 2436 | 8 |
1811186 | 1811186 | 2021-10-13 | Lewis | Kentucky | 21135 | 2436 | 55 |
1797262 | 1797262 | 2021-10-09 | Izard | Arkansas | 5065 | 2436 | 55 |
1788452 | 1788452 | 2021-10-06 | Mason | Kentucky | 21161 | 2436 | 58 |
1770845 | 1770845 | 2021-09-30 | Fluvanna | Virginia | 51065 | 2436 | 22 |
1762341 | 1762341 | 2021-09-28 | Neosho | Kansas | 20133 | 2436 | 47 |
1759093 | 1759093 | 2021-09-27 | Neosho | Kansas | 20133 | 2436 | 47 |
1754302 | 1754302 | 2021-09-25 | Colorado | Texas | 48089 | 2436 | 47 |
1746413 | 1746413 | 2021-09-23 | Iosco | Michigan | 26069 | 2436 | 83 |
1743164 | 1743164 | 2021-09-22 | Iosco | Michigan | 26069 | 2436 | 83 |
1744514 | 1744514 | 2021-09-22 | Aransas | Texas | 48007 | 2436 | 54 |
1736795 | 1736795 | 2021-09-20 | Wabasha | Minnesota | 27157 | 2436 | 4 |
1723604 | 1723604 | 2021-09-16 | Garrett | Maryland | 24023 | 2436 | 69 |
1716502 | 1716502 | 2021-09-14 | Cass | Illinois | 17017 | 2436 | 37 |
1717459 | 1717459 | 2021-09-14 | Moniteau | Missouri | 29135 | 2436 | 37 |
1710034 | 1710034 | 2021-09-12 | Hancock | Illinois | 17067 | 2436 | 44 |
1706787 | 1706787 | 2021-09-11 | Hancock | Illinois | 17067 | 2436 | 44 |
1703539 | 1703539 | 2021-09-10 | Hancock | Illinois | 17067 | 2436 | 44 |
1699149 | 1699149 | 2021-09-08 | Jackson | Texas | 48239 | 2436 | 38 |
1695416 | 1695416 | 2021-09-07 | Union | Oregon | 41061 | 2436 | 34 |
1676764 | 1676764 | 2021-09-01 | Brooke | West Virginia | 54009 | 2436 | 61 |
1655601 | 1655601 | 2021-08-26 | Clarke | Mississippi | 28023 | 2436 | 81 |
1653888 | 1653888 | 2021-08-25 | Dinwiddie | Virginia | 51053 | 2436 | 46 |
1648537 | 1648537 | 2021-08-24 | Mahaska | Iowa | 19123 | 2436 | 51 |
1645289 | 1645289 | 2021-08-23 | Mahaska | Iowa | 19123 | 2436 | 51 |
1645802 | 1645802 | 2021-08-23 | Martin | Minnesota | 27091 | 2436 | 33 |
1642040 | 1642040 | 2021-08-22 | Mahaska | Iowa | 19123 | 2436 | 51 |
1642680 | 1642680 | 2021-08-22 | Andrew | Missouri | 29003 | 2436 | 23 |
1644221 | 1644221 | 2021-08-22 | Salem city | Virginia | 51775 | 2436 | 50 |
1638790 | 1638790 | 2021-08-21 | Mahaska | Iowa | 19123 | 2436 | 51 |
1640971 | 1640971 | 2021-08-21 | Salem city | Virginia | 51775 | 2436 | 50 |
1635540 | 1635540 | 2021-08-20 | Mahaska | Iowa | 19123 | 2436 | 51 |
1637721 | 1637721 | 2021-08-20 | Salem city | Virginia | 51775 | 2436 | 50 |
1632290 | 1632290 | 2021-08-19 | Mahaska | Iowa | 19123 | 2436 | 51 |
1632678 | 1632678 | 2021-08-19 | Alpena | Michigan | 26007 | 2436 | 66 |
1629043 | 1629043 | 2021-08-18 | Mahaska | Iowa | 19123 | 2436 | 51 |
1629431 | 1629431 | 2021-08-18 | Alpena | Michigan | 26007 | 2436 | 66 |
1599145 | 1599145 | 2021-08-09 | Colusa | California | 6011 | 2436 | 18 |
1582714 | 1582714 | 2021-08-04 | Butler | Alabama | 1013 | 2436 | 72 |
1584313 | 1584313 | 2021-08-04 | Texas | Missouri | 29215 | 2436 | 27 |
1578171 | 1578171 | 2021-08-02 | Martin | North Carolina | 37117 | 2436 | 46 |
1550879 | 1550879 | 2021-07-25 | Lawrence | Illinois | 17101 | 2436 | 36 |
1547632 | 1547632 | 2021-07-24 | Lawrence | Illinois | 17101 | 2436 | 36 |
1544385 | 1544385 | 2021-07-23 | Lawrence | Illinois | 17101 | 2436 | 36 |
1507598 | 1507598 | 2021-07-11 | Scurry | Texas | 48415 | 2436 | 62 |
1494224 | 1494224 | 2021-07-07 | Jasper | South Carolina | 45053 | 2436 | 50 |
1490977 | 1490977 | 2021-07-06 | Jasper | South Carolina | 45053 | 2436 | 50 |
1487730 | 1487730 | 2021-07-05 | Jasper | South Carolina | 45053 | 2436 | 50 |
1472767 | 1472767 | 2021-07-01 | Hart | Georgia | 13147 | 2436 | 57 |
1469521 | 1469521 | 2021-06-30 | Hart | Georgia | 13147 | 2436 | 57 |
1471117 | 1471117 | 2021-06-30 | Adams | Ohio | 39001 | 2436 | 56 |
1466276 | 1466276 | 2021-06-29 | Hart | Georgia | 13147 | 2436 | 57 |
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);