ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where cases = 3879 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 17
- Iowa 15
- Virginia 12
- Kentucky 11
- Michigan 7
- Illinois 6
- Kansas 6
- Ohio 6
- South Carolina 6
- Louisiana 4
- Oregon 4
- Georgia 3
- Indiana 3
- Puerto Rico 3
- Tennessee 3
- Wyoming 3
- Alabama 2
- Alaska 2
- Arkansas 2
- Missouri 2
- Nebraska 2
- North Carolina 2
- Pennsylvania 2
- Wisconsin 2
- Colorado 1
- Hawaii 1
- Maryland 1
- Minnesota 1
- New Hampshire 1
- New York 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489844 | 2489844 | 2022-05-10 | Macon | Alabama | 1087 | 3879 | 84 |
2490695 | 2490695 | 2022-05-10 | Winneshiek | Iowa | 19191 | 3879 | 50 |
2487438 | 2487438 | 2022-05-09 | Winneshiek | Iowa | 19191 | 3879 | 50 |
2484180 | 2484180 | 2022-05-08 | Winneshiek | Iowa | 19191 | 3879 | 50 |
2480922 | 2480922 | 2022-05-07 | Winneshiek | Iowa | 19191 | 3879 | 50 |
2477664 | 2477664 | 2022-05-06 | Winneshiek | Iowa | 19191 | 3879 | 50 |
2474406 | 2474406 | 2022-05-05 | Winneshiek | Iowa | 19191 | 3879 | 50 |
2471149 | 2471149 | 2022-05-04 | Winneshiek | Iowa | 19191 | 3879 | 50 |
2466455 | 2466455 | 2022-05-02 | Freestone | Texas | 48161 | 3879 | 82 |
2463200 | 2463200 | 2022-05-01 | Freestone | Texas | 48161 | 3879 | 82 |
2331235 | 2331235 | 2022-03-22 | Jackson | Kansas | 20085 | 3879 | 29 |
2331687 | 2331687 | 2022-03-22 | Redwood | Minnesota | 27127 | 3879 | 53 |
2327983 | 2327983 | 2022-03-21 | Jackson | Kansas | 20085 | 3879 | 29 |
2301682 | 2301682 | 2022-03-13 | Mason | Illinois | 17125 | 3879 | 61 |
2304001 | 2304001 | 2022-03-13 | Goochland | Virginia | 51075 | 3879 | 45 |
2298430 | 2298430 | 2022-03-12 | Mason | Illinois | 17125 | 3879 | 61 |
2300749 | 2300749 | 2022-03-12 | Goochland | Virginia | 51075 | 3879 | 45 |
2295178 | 2295178 | 2022-03-11 | Mason | Illinois | 17125 | 3879 | 61 |
2297497 | 2297497 | 2022-03-11 | Goochland | Virginia | 51075 | 3879 | 45 |
2291926 | 2291926 | 2022-03-10 | Mason | Illinois | 17125 | 3879 | 61 |
2277342 | 2277342 | 2022-03-05 | Aguas Buenas | Puerto Rico | 72007 | 3879 | |
2271377 | 2271377 | 2022-03-03 | Young | Texas | 48503 | 3879 | 88 |
2216566 | 2216566 | 2022-02-15 | Northwest Arctic Borough | Alaska | 2188 | 3879 | 11 |
2219643 | 2219643 | 2022-02-15 | Burnett | Wisconsin | 55013 | 3879 | 41 |
2213315 | 2213315 | 2022-02-14 | Northwest Arctic Borough | Alaska | 2188 | 3879 | 11 |
2216129 | 2216129 | 2022-02-14 | San Juan | Utah | 49037 | 3879 | 47 |
2132661 | 2132661 | 2022-01-20 | Perry | Indiana | 18123 | 3879 | 61 |
2074446 | 2074446 | 2022-01-02 | Meade | Kentucky | 21163 | 3879 | 50 |
2071195 | 2071195 | 2022-01-01 | Meade | Kentucky | 21163 | 3879 | 50 |
2067944 | 2067944 | 2021-12-31 | Meade | Kentucky | 21163 | 3879 | 50 |
2064693 | 2064693 | 2021-12-30 | Meade | Kentucky | 21163 | 3879 | 50 |
2061443 | 2061443 | 2021-12-29 | Meade | Kentucky | 21163 | 3879 | 50 |
2062610 | 2062610 | 2021-12-29 | Lincoln | Oregon | 41041 | 3879 | 58 |
2056652 | 2056652 | 2021-12-27 | Milam | Texas | 48331 | 3879 | 91 |
2034102 | 2034102 | 2021-12-20 | Hopewell city | Virginia | 51670 | 3879 | 95 |
2030882 | 2030882 | 2021-12-19 | Page | Virginia | 51139 | 3879 | 90 |
2027631 | 2027631 | 2021-12-18 | Page | Virginia | 51139 | 3879 | 90 |
2024380 | 2024380 | 2021-12-17 | Page | Virginia | 51139 | 3879 | 90 |
2020020 | 2020020 | 2021-12-16 | Ashe | North Carolina | 37009 | 3879 | 57 |
2015381 | 2015381 | 2021-12-15 | Tattnall | Georgia | 13267 | 3879 | 115 |
1989313 | 1989313 | 2021-12-07 | Haralson | Georgia | 13143 | 3879 | 130 |
1923335 | 1923335 | 2021-11-16 | Hutchinson | Texas | 48233 | 3879 | 93 |
1919129 | 1919129 | 2021-11-15 | Coos | New Hampshire | 33007 | 3879 | 67 |
1906763 | 1906763 | 2021-11-11 | Abbeville | South Carolina | 45001 | 3879 | 50 |
1903514 | 1903514 | 2021-11-10 | Abbeville | South Carolina | 45001 | 3879 | 50 |
1860014 | 1860014 | 2021-10-28 | Pointe Coupee | Louisiana | 22077 | 3879 | 83 |
1836006 | 1836006 | 2021-10-20 | Upshur | West Virginia | 54097 | 3879 | 62 |
1812770 | 1812770 | 2021-10-13 | Calhoun | Texas | 48057 | 3879 | 34 |
1792225 | 1792225 | 2021-10-07 | Stone | Missouri | 29209 | 3879 | 83 |
1769441 | 1769441 | 2021-09-30 | Miller | Missouri | 29131 | 3879 | 74 |
1734598 | 1734598 | 2021-09-19 | Union | South Carolina | 45087 | 3879 | 88 |
1731348 | 1731348 | 2021-09-18 | Union | South Carolina | 45087 | 3879 | 88 |
1728098 | 1728098 | 2021-09-17 | Union | South Carolina | 45087 | 3879 | 88 |
1725123 | 1725123 | 2021-09-16 | Hockley | Texas | 48219 | 3879 | 124 |
1696822 | 1696822 | 2021-09-08 | Chattooga | Georgia | 13055 | 3879 | 78 |
1626086 | 1626086 | 2021-08-17 | Jefferson Davis | Louisiana | 22053 | 3879 | 102 |
1613175 | 1613175 | 2021-08-13 | Worcester | Maryland | 24047 | 3879 | 106 |
1545808 | 1545808 | 2021-07-23 | Clinton | Ohio | 39027 | 3879 | 66 |
1534842 | 1534842 | 2021-07-20 | Lee | Iowa | 19111 | 3879 | 58 |
1531595 | 1531595 | 2021-07-19 | Lee | Iowa | 19111 | 3879 | 58 |
1528348 | 1528348 | 2021-07-18 | Lee | Iowa | 19111 | 3879 | 58 |
1525101 | 1525101 | 2021-07-17 | Lee | Iowa | 19111 | 3879 | 58 |
1521853 | 1521853 | 2021-07-16 | Lee | Iowa | 19111 | 3879 | 58 |
1518605 | 1518605 | 2021-07-15 | Lee | Iowa | 19111 | 3879 | 58 |
1515358 | 1515358 | 2021-07-14 | Lee | Iowa | 19111 | 3879 | 58 |
1486350 | 1486350 | 2021-07-05 | Knox | Kentucky | 21121 | 3879 | 46 |
1483104 | 1483104 | 2021-07-04 | Knox | Kentucky | 21121 | 3879 | 46 |
1479857 | 1479857 | 2021-07-03 | Knox | Kentucky | 21121 | 3879 | 46 |
1476611 | 1476611 | 2021-07-02 | Knox | Kentucky | 21121 | 3879 | 46 |
1474430 | 1474430 | 2021-07-01 | Preble | Ohio | 39135 | 3879 | 106 |
1454937 | 1454937 | 2021-06-25 | Logan | Ohio | 39091 | 3879 | 78 |
1450648 | 1450648 | 2021-06-24 | Knox | Kentucky | 21121 | 3879 | 46 |
1438842 | 1438842 | 2021-06-20 | Douglas | Oregon | 41019 | 3879 | 82 |
1381544 | 1381544 | 2021-06-03 | Boone | Arkansas | 5009 | 3879 | 80 |
1377191 | 1377191 | 2021-06-01 | Polk | Oregon | 41053 | 3879 | 53 |
1332505 | 1332505 | 2021-05-18 | Petersburg city | Virginia | 51730 | 3879 | 86 |
1294404 | 1294404 | 2021-05-07 | Fulton | Illinois | 17057 | 3879 | 62 |
1291267 | 1291267 | 2021-05-06 | Huntington | Indiana | 18069 | 3879 | 82 |
1200161 | 1200161 | 2021-04-08 | Maui | Hawaii | 15009 | 3879 | 43 |
1202430 | 1202430 | 2021-04-08 | Rusk | Texas | 48401 | 3879 | 105 |
1198220 | 1198220 | 2021-04-07 | Fulton | New York | 36035 | 3879 | 85 |
1153969 | 1153969 | 2021-03-24 | Lewis | Washington | 53041 | 3879 | 51 |
1147823 | 1147823 | 2021-03-23 | Union | Arkansas | 5139 | 3879 | 107 |
1150263 | 1150263 | 2021-03-23 | Weakley | Tennessee | 47183 | 3879 | 60 |
1139643 | 1139643 | 2021-03-20 | Platte | Nebraska | 31141 | 3879 | 47 |
1132575 | 1132575 | 2021-03-18 | St. Bernard | Louisiana | 22087 | 3879 | 48 |
1123937 | 1123937 | 2021-03-15 | Bedford | Pennsylvania | 42009 | 3879 | 129 |
1119673 | 1119673 | 2021-03-14 | Barry | Michigan | 26015 | 3879 | 49 |
1116426 | 1116426 | 2021-03-13 | Barry | Michigan | 26015 | 3879 | 49 |
1107837 | 1107837 | 2021-03-10 | Toa Baja | Puerto Rico | 72137 | 3879 | |
1103932 | 1103932 | 2021-03-09 | Platte | Nebraska | 31141 | 3879 | 47 |
1104591 | 1104591 | 2021-03-09 | Toa Baja | Puerto Rico | 72137 | 3879 | |
1099198 | 1099198 | 2021-03-08 | Broomfield | Colorado | 8014 | 3879 | 74 |
1093170 | 1093170 | 2021-03-06 | DeKalb | Indiana | 18033 | 3879 | 82 |
1090524 | 1090524 | 2021-03-05 | Shiawassee | Michigan | 26155 | 3879 | 80 |
1080452 | 1080452 | 2021-03-02 | Seward | Kansas | 20175 | 3879 | 33 |
1077207 | 1077207 | 2021-03-01 | Seward | Kansas | 20175 | 3879 | 33 |
1056470 | 1056470 | 2021-02-22 | Fauquier | Virginia | 51061 | 3879 | 45 |
1052368 | 1052368 | 2021-02-21 | Madison | Ohio | 39097 | 3879 | 47 |
1052690 | 1052690 | 2021-02-21 | Dillon | South Carolina | 45033 | 3879 | 76 |
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);