ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
114 rows where cases = 3733 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 11
- Minnesota 9
- Texas 8
- Virginia 8
- Missouri 7
- Arkansas 6
- Georgia 6
- Indiana 5
- Mississippi 5
- Ohio 5
- Wisconsin 5
- Illinois 3
- Michigan 3
- Oregon 3
- South Dakota 3
- West Virginia 3
- California 2
- Kansas 2
- Kentucky 2
- Maine 2
- North Carolina 2
- Pennsylvania 2
- Washington 2
- Arizona 1
- Florida 1
- Louisiana 1
- Massachusetts 1
- New York 1
- Oklahoma 1
- Puerto Rico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486608 | 2486608 | 2022-05-09 | Washington | Alabama | 1129 | 3733 | 59 |
2463781 | 2463781 | 2022-05-02 | Lamar | Alabama | 1075 | 3733 | 64 |
2460525 | 2460525 | 2022-05-01 | Lamar | Alabama | 1075 | 3733 | 64 |
2457269 | 2457269 | 2022-04-30 | Lamar | Alabama | 1075 | 3733 | 64 |
2454013 | 2454013 | 2022-04-29 | Lamar | Alabama | 1075 | 3733 | 64 |
2450757 | 2450757 | 2022-04-28 | Lamar | Alabama | 1075 | 3733 | 64 |
2451487 | 2451487 | 2022-04-28 | Pike | Indiana | 18125 | 3733 | 49 |
2447501 | 2447501 | 2022-04-27 | Lamar | Alabama | 1075 | 3733 | 64 |
2448231 | 2448231 | 2022-04-27 | Pike | Indiana | 18125 | 3733 | 49 |
2396764 | 2396764 | 2022-04-11 | Renville | Minnesota | 27129 | 3733 | 56 |
2302370 | 2302370 | 2022-03-13 | Faribault | Minnesota | 27043 | 3733 | 50 |
2299118 | 2299118 | 2022-03-12 | Faribault | Minnesota | 27043 | 3733 | 50 |
2295866 | 2295866 | 2022-03-11 | Faribault | Minnesota | 27043 | 3733 | 50 |
2289518 | 2289518 | 2022-03-09 | Bates | Missouri | 29013 | 3733 | 89 |
2278398 | 2278398 | 2022-03-06 | Howard | Arkansas | 5061 | 3733 | 48 |
2186727 | 2186727 | 2022-02-05 | Llano | Texas | 48299 | 3733 | 89 |
2180154 | 2180154 | 2022-02-03 | Freestone | Texas | 48161 | 3733 | 80 |
2149520 | 2149520 | 2022-01-25 | Houston | Minnesota | 27055 | 3733 | 18 |
2121653 | 2121653 | 2022-01-16 | Lavaca | Texas | 48285 | 3733 | 100 |
2109742 | 2109742 | 2022-01-13 | Clark | Illinois | 17023 | 3733 | 55 |
2083166 | 2083166 | 2022-01-05 | Monroe | Alabama | 1099 | 3733 | 66 |
2082987 | 2082987 | 2022-01-04 | Lewis | West Virginia | 54041 | 3733 | 66 |
2061550 | 2061550 | 2021-12-29 | Franklin | Maine | 23007 | 3733 | 43 |
2061841 | 2061841 | 2021-12-29 | Stone | Mississippi | 28131 | 3733 | 67 |
2056402 | 2056402 | 2021-12-27 | Chester | Tennessee | 47023 | 3733 | 81 |
2030574 | 2030574 | 2021-12-19 | Gillespie | Texas | 48171 | 3733 | 83 |
1969092 | 1969092 | 2021-11-30 | Hopewell city | Virginia | 51670 | 3733 | 89 |
1926897 | 1926897 | 2021-11-17 | Waynesboro city | Virginia | 51820 | 3733 | 50 |
1922181 | 1922181 | 2021-11-16 | Randolph | Missouri | 29175 | 3733 | 37 |
1897781 | 1897781 | 2021-11-08 | Kewaunee | Wisconsin | 55061 | 3733 | 44 |
1894448 | 1894448 | 2021-11-07 | Boone | West Virginia | 54005 | 3733 | 59 |
1880447 | 1880447 | 2021-11-03 | Holmes | Ohio | 39075 | 3733 | 126 |
1830017 | 1830017 | 2021-10-19 | Burke | Georgia | 13033 | 3733 | 81 |
1832856 | 1832856 | 2021-10-19 | Uinta | Wyoming | 56041 | 3733 | 26 |
1803515 | 1803515 | 2021-10-10 | Upshur | West Virginia | 54097 | 3733 | 57 |
1787549 | 1787549 | 2021-10-06 | Sevier | Arkansas | 5133 | 3733 | 36 |
1787877 | 1787877 | 2021-10-06 | Pike | Georgia | 13231 | 3733 | 65 |
1778963 | 1778963 | 2021-10-03 | Cass | Minnesota | 27021 | 3733 | 39 |
1775713 | 1775713 | 2021-10-02 | Cass | Minnesota | 27021 | 3733 | 39 |
1772463 | 1772463 | 2021-10-01 | Cass | Minnesota | 27021 | 3733 | 39 |
1743496 | 1743496 | 2021-09-22 | Washington | Missouri | 29221 | 3733 | 58 |
1740960 | 1740960 | 2021-09-21 | Tioga | Pennsylvania | 42117 | 3733 | 116 |
1723482 | 1723482 | 2021-09-16 | Ohio | Kentucky | 21183 | 3733 | 63 |
1711900 | 1711900 | 2021-09-12 | Lawrence | South Dakota | 46081 | 3733 | 51 |
1708653 | 1708653 | 2021-09-11 | Lawrence | South Dakota | 46081 | 3733 | 51 |
1705406 | 1705406 | 2021-09-10 | Lawrence | South Dakota | 46081 | 3733 | 51 |
1668502 | 1668502 | 2021-08-30 | Carlton | Minnesota | 27017 | 3733 | 59 |
1644866 | 1644866 | 2021-08-23 | Decatur | Georgia | 13087 | 3733 | 78 |
1602388 | 1602388 | 2021-08-10 | Yell | Arkansas | 5149 | 3733 | 66 |
1602906 | 1602906 | 2021-08-10 | Adams | Indiana | 18001 | 3733 | 57 |
1545632 | 1545632 | 2021-07-23 | Warren | New York | 36113 | 3733 | 59 |
1542888 | 1542888 | 2021-07-22 | Trujillo Alto | Puerto Rico | 72139 | 3733 | |
1514710 | 1514710 | 2021-07-14 | Lake | California | 6033 | 3733 | 63 |
1512401 | 1512401 | 2021-07-13 | Evangeline | Louisiana | 22039 | 3733 | 99 |
1459332 | 1459332 | 2021-06-27 | Chambers | Alabama | 1017 | 3733 | 124 |
1456087 | 1456087 | 2021-06-26 | Chambers | Alabama | 1017 | 3733 | 124 |
1452842 | 1452842 | 2021-06-25 | Chambers | Alabama | 1017 | 3733 | 124 |
1406383 | 1406383 | 2021-06-10 | Douglas | Oregon | 41019 | 3733 | 80 |
1361556 | 1361556 | 2021-05-27 | Titus | Texas | 48449 | 3733 | 84 |
1322805 | 1322805 | 2021-05-15 | York | Virginia | 51199 | 3733 | 53 |
1319173 | 1319173 | 2021-05-14 | Cooke | Texas | 48097 | 3733 | 72 |
1319559 | 1319559 | 2021-05-14 | York | Virginia | 51199 | 3733 | 53 |
1312081 | 1312081 | 2021-05-12 | Clinton | Ohio | 39027 | 3733 | 63 |
1312261 | 1312261 | 2021-05-12 | Polk | Oregon | 41053 | 3733 | 52 |
1268723 | 1268723 | 2021-04-29 | Ellis | Kansas | 20051 | 3733 | 73 |
1265476 | 1265476 | 2021-04-28 | Ellis | Kansas | 20051 | 3733 | 73 |
1255593 | 1255593 | 2021-04-25 | Steuben | Indiana | 18151 | 3733 | 59 |
1257886 | 1257886 | 2021-04-25 | Grays Harbor | Washington | 53027 | 3733 | 62 |
1254639 | 1254639 | 2021-04-24 | Grays Harbor | Washington | 53027 | 3733 | 62 |
1230274 | 1230274 | 2021-04-17 | Hancock | Mississippi | 28045 | 3733 | 85 |
1227026 | 1227026 | 2021-04-16 | Hancock | Mississippi | 28045 | 3733 | 85 |
1223778 | 1223778 | 2021-04-15 | Hancock | Mississippi | 28045 | 3733 | 85 |
1215987 | 1215987 | 2021-04-13 | Independence | Arkansas | 5063 | 3733 | 121 |
1213393 | 1213393 | 2021-04-12 | Whitley | Indiana | 18183 | 3733 | 39 |
1157499 | 1157499 | 2021-03-26 | Boone | Arkansas | 5009 | 3733 | 79 |
1093644 | 1093644 | 2021-03-06 | Kennebec | Maine | 23011 | 3733 | 51 |
1090717 | 1090717 | 2021-03-05 | Camden | Missouri | 29029 | 3733 | 81 |
1092174 | 1092174 | 2021-03-05 | Franklin | Virginia | 51067 | 3733 | 58 |
1087472 | 1087472 | 2021-03-04 | Camden | Missouri | 29029 | 3733 | 81 |
1052322 | 1052322 | 2021-02-21 | Ashland | Ohio | 39005 | 3733 | 92 |
1041839 | 1041839 | 2021-02-18 | Shiawassee | Michigan | 26155 | 3733 | 77 |
1036029 | 1036029 | 2021-02-16 | Watauga | North Carolina | 37189 | 3733 | 28 |
1020767 | 1020767 | 2021-02-11 | Fauquier | Virginia | 51061 | 3733 | 37 |
1003122 | 1003122 | 2021-02-06 | Johnson | Missouri | 29101 | 3733 | 38 |
1004775 | 1004775 | 2021-02-06 | Polk | Wisconsin | 55095 | 3733 | 43 |
993788 | 993788 | 2021-02-03 | Hoke | North Carolina | 37093 | 3733 | 48 |
969783 | 969783 | 2021-01-27 | Monroe | Illinois | 17133 | 3733 | 71 |
924911 | 924911 | 2021-01-13 | Berkshire | Massachusetts | 25003 | 3733 | 172 |
917731 | 917731 | 2021-01-11 | Ware | Georgia | 13299 | 3733 | 88 |
895003 | 895003 | 2021-01-04 | Tift | Georgia | 13277 | 3733 | 81 |
897353 | 897353 | 2021-01-04 | Box Elder | Utah | 49003 | 3733 | 27 |
878035 | 878035 | 2020-12-29 | Rockingham | Virginia | 51165 | 3733 | 39 |
864256 | 864256 | 2020-12-25 | Deschutes | Oregon | 41017 | 3733 | 21 |
854400 | 854400 | 2020-12-22 | Mercer | Ohio | 39107 | 3733 | 77 |
852039 | 852039 | 2020-12-21 | Lynchburg city | Virginia | 51680 | 3733 | 45 |
847929 | 847929 | 2020-12-20 | Scioto | Ohio | 39145 | 3733 | 35 |
848985 | 848985 | 2020-12-20 | Marinette | Wisconsin | 55075 | 3733 | 39 |
834265 | 834265 | 2020-12-16 | Lafayette | Mississippi | 28071 | 3733 | 69 |
829667 | 829667 | 2020-12-15 | Gila | Arizona | 4007 | 3733 | 114 |
787615 | 787615 | 2020-12-02 | Sutter | California | 6101 | 3733 | 19 |
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);