ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where cases = 3921 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 10
- Tennessee 10
- Indiana 9
- Kentucky 9
- Arkansas 8
- Georgia 8
- Minnesota 8
- Louisiana 7
- South Dakota 7
- Missouri 5
- Texas 5
- Colorado 4
- South Carolina 4
- Alabama 3
- Idaho 3
- Michigan 3
- Mississippi 3
- Ohio 3
- Virginia 3
- Wisconsin 3
- Florida 2
- Maryland 2
- Nebraska 2
- New York 2
- North Carolina 2
- Puerto Rico 2
- California 1
- Connecticut 1
- Illinois 1
- Montana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2476435 | 2476435 | 2022-05-05 | Lamoille | Vermont | 50015 | 3921 | 17 |
2463701 | 2463701 | 2022-05-01 | Richland | Wisconsin | 55103 | 3921 | 48 |
2460445 | 2460445 | 2022-04-30 | Richland | Wisconsin | 55103 | 3921 | 48 |
2457189 | 2457189 | 2022-04-29 | Richland | Wisconsin | 55103 | 3921 | 48 |
2426065 | 2426065 | 2022-04-20 | Redwood | Minnesota | 27127 | 3921 | 53 |
2393233 | 2393233 | 2022-04-10 | Washington | Kentucky | 21229 | 3921 | 59 |
2389977 | 2389977 | 2022-04-09 | Washington | Kentucky | 21229 | 3921 | 59 |
2386721 | 2386721 | 2022-04-08 | Washington | Kentucky | 21229 | 3921 | 59 |
2383466 | 2383466 | 2022-04-07 | Washington | Kentucky | 21229 | 3921 | 59 |
2380211 | 2380211 | 2022-04-06 | Washington | Kentucky | 21229 | 3921 | 59 |
2376956 | 2376956 | 2022-04-05 | Washington | Kentucky | 21229 | 3921 | 59 |
2378358 | 2378358 | 2022-04-05 | Oglala Lakota | South Dakota | 46102 | 3921 | 62 |
2373704 | 2373704 | 2022-04-04 | Washington | Kentucky | 21229 | 3921 | 59 |
2375104 | 2375104 | 2022-04-04 | Oglala Lakota | South Dakota | 46102 | 3921 | 62 |
2371852 | 2371852 | 2022-04-03 | Oglala Lakota | South Dakota | 46102 | 3921 | 62 |
2368599 | 2368599 | 2022-04-02 | Oglala Lakota | South Dakota | 46102 | 3921 | 62 |
2365346 | 2365346 | 2022-04-01 | Oglala Lakota | South Dakota | 46102 | 3921 | 62 |
2359971 | 2359971 | 2022-03-31 | Banks | Georgia | 13011 | 3921 | 86 |
2362093 | 2362093 | 2022-03-31 | Oglala Lakota | South Dakota | 46102 | 3921 | 62 |
2358839 | 2358839 | 2022-03-30 | Oglala Lakota | South Dakota | 46102 | 3921 | 62 |
2323945 | 2323945 | 2022-03-20 | Madison | Arkansas | 5087 | 3921 | 60 |
2320691 | 2320691 | 2022-03-19 | Madison | Arkansas | 5087 | 3921 | 60 |
2263019 | 2263019 | 2022-03-01 | Casey | Kentucky | 21045 | 3921 | 66 |
2191937 | 2191937 | 2022-02-07 | Smith | Mississippi | 28129 | 3921 | 65 |
2187371 | 2187371 | 2022-02-06 | Polk | Arkansas | 5113 | 3921 | 132 |
2135180 | 2135180 | 2022-01-21 | Henry | Alabama | 1067 | 3921 | 67 |
2102791 | 2102791 | 2022-01-11 | Phillips | Arkansas | 5107 | 3921 | 84 |
2104205 | 2104205 | 2022-01-11 | Perry | Missouri | 29157 | 3921 | 41 |
2105168 | 2105168 | 2022-01-11 | Chester | Tennessee | 47023 | 3921 | 81 |
2101917 | 2101917 | 2022-01-10 | Chester | Tennessee | 47023 | 3921 | 81 |
2098666 | 2098666 | 2022-01-09 | Chester | Tennessee | 47023 | 3921 | 81 |
2095414 | 2095414 | 2022-01-08 | Chester | Tennessee | 47023 | 3921 | 81 |
2089675 | 2089675 | 2022-01-07 | Randolph | Alabama | 1111 | 3921 | 67 |
2092162 | 2092162 | 2022-01-07 | Chester | Tennessee | 47023 | 3921 | 81 |
2088910 | 2088910 | 2022-01-06 | Chester | Tennessee | 47023 | 3921 | 81 |
2085659 | 2085659 | 2022-01-05 | Chester | Tennessee | 47023 | 3921 | 81 |
2082407 | 2082407 | 2022-01-04 | Chester | Tennessee | 47023 | 3921 | 81 |
2072484 | 2072484 | 2022-01-01 | Juncos | Puerto Rico | 72077 | 3921 | |
2069233 | 2069233 | 2021-12-31 | Juncos | Puerto Rico | 72077 | 3921 | |
2051959 | 2051959 | 2021-12-26 | Dodge | Minnesota | 27039 | 3921 | 13 |
2048709 | 2048709 | 2021-12-25 | Dodge | Minnesota | 27039 | 3921 | 13 |
2045459 | 2045459 | 2021-12-24 | Dodge | Minnesota | 27039 | 3921 | 13 |
2042209 | 2042209 | 2021-12-23 | Dodge | Minnesota | 27039 | 3921 | 13 |
2015053 | 2015053 | 2021-12-15 | Del Norte | California | 6015 | 3921 | 43 |
1993246 | 1993246 | 2021-12-08 | Grant | Louisiana | 22043 | 3921 | 78 |
1933086 | 1933086 | 2021-11-19 | Hutchinson | Texas | 48233 | 3921 | 94 |
1920321 | 1920321 | 2021-11-15 | Gloucester | Virginia | 51073 | 3921 | 79 |
1876360 | 1876360 | 2021-11-02 | Clare | Michigan | 26035 | 3921 | 103 |
1873111 | 1873111 | 2021-11-01 | Clare | Michigan | 26035 | 3921 | 103 |
1869502 | 1869502 | 2021-10-31 | Barton | Kansas | 20009 | 3921 | 58 |
1866253 | 1866253 | 2021-10-30 | Barton | Kansas | 20009 | 3921 | 58 |
1863004 | 1863004 | 2021-10-29 | Barton | Kansas | 20009 | 3921 | 58 |
1848300 | 1848300 | 2021-10-24 | Jasper | South Carolina | 45053 | 3921 | 80 |
1845050 | 1845050 | 2021-10-23 | Jasper | South Carolina | 45053 | 3921 | 80 |
1841800 | 1841800 | 2021-10-22 | Jasper | South Carolina | 45053 | 3921 | 80 |
1834497 | 1834497 | 2021-10-20 | Lake | Montana | 30047 | 3921 | 60 |
1824716 | 1824716 | 2021-10-17 | Stone | Missouri | 29209 | 3921 | 84 |
1810566 | 1810566 | 2021-10-13 | Franklin | Georgia | 13119 | 3921 | 76 |
1801545 | 1801545 | 2021-10-10 | Union | Louisiana | 22111 | 3921 | 102 |
1798296 | 1798296 | 2021-10-09 | Union | Louisiana | 22111 | 3921 | 102 |
1795047 | 1795047 | 2021-10-08 | Union | Louisiana | 22111 | 3921 | 102 |
1755607 | 1755607 | 2021-09-26 | Fayette | Indiana | 18041 | 3921 | 80 |
1752359 | 1752359 | 2021-09-25 | Fayette | Indiana | 18041 | 3921 | 80 |
1749110 | 1749110 | 2021-09-24 | Fayette | Indiana | 18041 | 3921 | 80 |
1741764 | 1741764 | 2021-09-21 | Mineral | West Virginia | 54057 | 3921 | 100 |
1677027 | 1677027 | 2021-09-02 | Carroll | Arkansas | 5015 | 3921 | 59 |
1664354 | 1664354 | 2021-08-29 | Decatur | Georgia | 13087 | 3921 | 81 |
1661106 | 1661106 | 2021-08-28 | Decatur | Georgia | 13087 | 3921 | 81 |
1657858 | 1657858 | 2021-08-27 | Decatur | Georgia | 13087 | 3921 | 81 |
1600849 | 1600849 | 2021-08-09 | Tioga | New York | 36107 | 3921 | 63 |
1597034 | 1597034 | 2021-08-08 | Becker | Minnesota | 27005 | 3921 | 58 |
1593785 | 1593785 | 2021-08-07 | Becker | Minnesota | 27005 | 3921 | 58 |
1590536 | 1590536 | 2021-08-06 | Becker | Minnesota | 27005 | 3921 | 58 |
1558828 | 1558828 | 2021-07-27 | Logan | Ohio | 39091 | 3921 | 79 |
1541097 | 1541097 | 2021-07-22 | Christian | Illinois | 17021 | 3921 | 93 |
1527785 | 1527785 | 2021-07-18 | Montrose | Colorado | 8085 | 3921 | 66 |
1524538 | 1524538 | 2021-07-17 | Montrose | Colorado | 8085 | 3921 | 66 |
1521290 | 1521290 | 2021-07-16 | Montrose | Colorado | 8085 | 3921 | 66 |
1490117 | 1490117 | 2021-07-06 | Polk | Missouri | 29167 | 3921 | 42 |
1486029 | 1486029 | 2021-07-05 | Jasper | Indiana | 18073 | 3921 | 57 |
1482783 | 1482783 | 2021-07-04 | Jasper | Indiana | 18073 | 3921 | 57 |
1479536 | 1479536 | 2021-07-03 | Jasper | Indiana | 18073 | 3921 | 57 |
1476290 | 1476290 | 2021-07-02 | Jasper | Indiana | 18073 | 3921 | 57 |
1410753 | 1410753 | 2021-06-12 | Boone | Arkansas | 5009 | 3921 | 80 |
1267829 | 1267829 | 2021-04-29 | Escambia | Alabama | 1053 | 3921 | 75 |
1245442 | 1245442 | 2021-04-22 | Okeechobee | Florida | 12093 | 3921 | 88 |
1210388 | 1210388 | 2021-04-11 | Franklin | Kentucky | 21073 | 3921 | 46 |
1186403 | 1186403 | 2021-04-03 | Shenandoah | Virginia | 51171 | 3921 | 127 |
1175364 | 1175364 | 2021-03-31 | Platte | Nebraska | 31141 | 3921 | 47 |
1176243 | 1176243 | 2021-03-31 | Weakley | Tennessee | 47183 | 3921 | 60 |
1164863 | 1164863 | 2021-03-28 | Seward | Kansas | 20175 | 3921 | 33 |
1161615 | 1161615 | 2021-03-27 | Seward | Kansas | 20175 | 3921 | 33 |
1158367 | 1158367 | 2021-03-26 | Seward | Kansas | 20175 | 3921 | 33 |
1155120 | 1155120 | 2021-03-25 | Seward | Kansas | 20175 | 3921 | 33 |
1155878 | 1155878 | 2021-03-25 | Platte | Nebraska | 31141 | 3921 | 47 |
1151873 | 1151873 | 2021-03-24 | Seward | Kansas | 20175 | 3921 | 33 |
1148626 | 1148626 | 2021-03-23 | Seward | Kansas | 20175 | 3921 | 33 |
1145379 | 1145379 | 2021-03-22 | Seward | Kansas | 20175 | 3921 | 33 |
1124203 | 1124203 | 2021-03-15 | Campbell | Tennessee | 47013 | 3921 | 59 |
1113800 | 1113800 | 2021-03-12 | Madison | New York | 36053 | 3921 | 85 |
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);