ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
102 rows where cases = 6936 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Indiana 16
- Georgia 15
- Minnesota 9
- Tennessee 8
- Virginia 8
- Louisiana 7
- Texas 7
- Mississippi 5
- Michigan 4
- New York 4
- North Carolina 3
- Arkansas 2
- Arizona 1
- Colorado 1
- Illinois 1
- Maryland 1
- Missouri 1
- New Hampshire 1
- Ohio 1
- Oklahoma 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2482433 | 2482433 | 2022-05-07 | San Sebastian | Puerto Rico | 72131 | 6936 | |
2471405 | 2471405 | 2022-05-04 | Jefferson Davis | Louisiana | 22053 | 6936 | 157 |
2467450 | 2467450 | 2022-05-03 | Gilmer | Georgia | 13123 | 6936 | 178 |
2468149 | 2468149 | 2022-05-03 | Jefferson Davis | Louisiana | 22053 | 6936 | 157 |
2464195 | 2464195 | 2022-05-02 | Gilmer | Georgia | 13123 | 6936 | 178 |
2464894 | 2464894 | 2022-05-02 | Jefferson Davis | Louisiana | 22053 | 6936 | 157 |
2460939 | 2460939 | 2022-05-01 | Gilmer | Georgia | 13123 | 6936 | 178 |
2461638 | 2461638 | 2022-05-01 | Jefferson Davis | Louisiana | 22053 | 6936 | 157 |
2457683 | 2457683 | 2022-04-30 | Gilmer | Georgia | 13123 | 6936 | 178 |
2458382 | 2458382 | 2022-04-30 | Jefferson Davis | Louisiana | 22053 | 6936 | 157 |
2454427 | 2454427 | 2022-04-29 | Gilmer | Georgia | 13123 | 6936 | 178 |
2455126 | 2455126 | 2022-04-29 | Jefferson Davis | Louisiana | 22053 | 6936 | 157 |
2451171 | 2451171 | 2022-04-28 | Gilmer | Georgia | 13123 | 6936 | 178 |
2447915 | 2447915 | 2022-04-27 | Gilmer | Georgia | 13123 | 6936 | 178 |
2428672 | 2428672 | 2022-04-21 | Jennings | Indiana | 18079 | 6936 | 108 |
2425416 | 2425416 | 2022-04-20 | Jennings | Indiana | 18079 | 6936 | 108 |
2421901 | 2421901 | 2022-04-19 | Madison | Georgia | 13195 | 6936 | 106 |
2422160 | 2422160 | 2022-04-19 | Jennings | Indiana | 18079 | 6936 | 108 |
2418645 | 2418645 | 2022-04-18 | Madison | Georgia | 13195 | 6936 | 106 |
2418904 | 2418904 | 2022-04-18 | Jennings | Indiana | 18079 | 6936 | 108 |
2415389 | 2415389 | 2022-04-17 | Madison | Georgia | 13195 | 6936 | 106 |
2412133 | 2412133 | 2022-04-16 | Madison | Georgia | 13195 | 6936 | 106 |
2408877 | 2408877 | 2022-04-15 | Madison | Georgia | 13195 | 6936 | 106 |
2392859 | 2392859 | 2022-04-10 | Jennings | Indiana | 18079 | 6936 | 108 |
2389603 | 2389603 | 2022-04-09 | Jennings | Indiana | 18079 | 6936 | 108 |
2386348 | 2386348 | 2022-04-08 | Jennings | Indiana | 18079 | 6936 | 108 |
2382027 | 2382027 | 2022-04-06 | Accomack | Virginia | 51001 | 6936 | 105 |
2378772 | 2378772 | 2022-04-05 | Accomack | Virginia | 51001 | 6936 | 105 |
2373968 | 2373968 | 2022-04-04 | Nobles | Minnesota | 27105 | 6936 | 60 |
2375518 | 2375518 | 2022-04-04 | Accomack | Virginia | 51001 | 6936 | 105 |
2370079 | 2370079 | 2022-04-03 | Jennings | Indiana | 18079 | 6936 | 108 |
2370715 | 2370715 | 2022-04-03 | Nobles | Minnesota | 27105 | 6936 | 60 |
2372266 | 2372266 | 2022-04-03 | Accomack | Virginia | 51001 | 6936 | 105 |
2366826 | 2366826 | 2022-04-02 | Jennings | Indiana | 18079 | 6936 | 108 |
2367462 | 2367462 | 2022-04-02 | Nobles | Minnesota | 27105 | 6936 | 60 |
2369013 | 2369013 | 2022-04-02 | Accomack | Virginia | 51001 | 6936 | 105 |
2363573 | 2363573 | 2022-04-01 | Jennings | Indiana | 18079 | 6936 | 108 |
2364209 | 2364209 | 2022-04-01 | Nobles | Minnesota | 27105 | 6936 | 60 |
2365760 | 2365760 | 2022-04-01 | Accomack | Virginia | 51001 | 6936 | 105 |
2360955 | 2360955 | 2022-03-31 | Nobles | Minnesota | 27105 | 6936 | 60 |
2357701 | 2357701 | 2022-03-30 | Nobles | Minnesota | 27105 | 6936 | 60 |
2352746 | 2352746 | 2022-03-28 | Accomack | Virginia | 51001 | 6936 | 105 |
2330781 | 2330781 | 2022-03-22 | Madison | Georgia | 13195 | 6936 | 102 |
2288498 | 2288498 | 2022-03-09 | Madison | Georgia | 13195 | 6936 | 97 |
2288757 | 2288757 | 2022-03-09 | Jennings | Indiana | 18079 | 6936 | 104 |
2285506 | 2285506 | 2022-03-08 | Jennings | Indiana | 18079 | 6936 | 103 |
2282254 | 2282254 | 2022-03-07 | Jennings | Indiana | 18079 | 6936 | 103 |
2269884 | 2269884 | 2022-03-03 | Pine | Minnesota | 27115 | 6936 | 66 |
2269960 | 2269960 | 2022-03-03 | Marion | Mississippi | 28091 | 6936 | 134 |
2263380 | 2263380 | 2022-03-01 | Pine | Minnesota | 27115 | 6936 | 64 |
2200397 | 2200397 | 2022-02-10 | St. Francis | Arkansas | 5123 | 6936 | 79 |
2195146 | 2195146 | 2022-02-08 | George | Mississippi | 28039 | 6936 | 81 |
2148870 | 2148870 | 2022-01-25 | Adams | Indiana | 18001 | 6936 | 104 |
2063791 | 2063791 | 2021-12-30 | Unknown | Arkansas | 6936 | 0 | |
2063443 | 2063443 | 2021-12-29 | Mason | Washington | 53045 | 6936 | 93 |
2056523 | 2056523 | 2021-12-27 | Cherokee | Texas | 48073 | 6936 | 229 |
2034651 | 2034651 | 2021-12-21 | Montrose | Colorado | 8085 | 6936 | 137 |
1969061 | 1969061 | 2021-11-30 | Culpeper | Virginia | 51047 | 6936 | 92 |
1945216 | 1945216 | 2021-11-23 | Livingston | New York | 36051 | 6936 | 74 |
1941968 | 1941968 | 2021-11-22 | Montgomery | New York | 36057 | 6936 | 159 |
1925715 | 1925715 | 2021-11-17 | Madison | New York | 36053 | 6936 | 107 |
1899842 | 1899842 | 2021-11-09 | Vance | North Carolina | 37181 | 6936 | 102 |
1883892 | 1883892 | 2021-11-04 | Huntingdon | Pennsylvania | 42061 | 6936 | 164 |
1874637 | 1874637 | 2021-11-01 | Medina | Texas | 48325 | 6936 | 165 |
1838937 | 1838937 | 2021-10-21 | San Patricio | Texas | 48409 | 6936 | 280 |
1835688 | 1835688 | 2021-10-20 | San Patricio | Texas | 48409 | 6936 | 279 |
1832439 | 1832439 | 2021-10-19 | San Patricio | Texas | 48409 | 6936 | 277 |
1781490 | 1781490 | 2021-10-04 | Clinton | Illinois | 17027 | 6936 | 109 |
1779219 | 1779219 | 2021-10-03 | Scott | Missouri | 29201 | 6936 | 110 |
1710678 | 1710678 | 2021-09-12 | Isabella | Michigan | 26073 | 6936 | 103 |
1710836 | 1710836 | 2021-09-12 | Hancock | Mississippi | 28045 | 6936 | 104 |
1707431 | 1707431 | 2021-09-11 | Isabella | Michigan | 26073 | 6936 | 103 |
1707589 | 1707589 | 2021-09-11 | Hancock | Mississippi | 28045 | 6936 | 104 |
1704184 | 1704184 | 2021-09-10 | Isabella | Michigan | 26073 | 6936 | 103 |
1704342 | 1704342 | 2021-09-10 | Hancock | Mississippi | 28045 | 6936 | 104 |
1652779 | 1652779 | 2021-08-25 | Cayuga | New York | 36011 | 6936 | 94 |
1621045 | 1621045 | 2021-08-15 | Roane | Tennessee | 47145 | 6936 | 112 |
1617797 | 1617797 | 2021-08-14 | Roane | Tennessee | 47145 | 6936 | 112 |
1614549 | 1614549 | 2021-08-13 | Roane | Tennessee | 47145 | 6936 | 112 |
1536537 | 1536537 | 2021-07-20 | Cumberland | Tennessee | 47035 | 6936 | 141 |
1451587 | 1451587 | 2021-06-24 | Wilkes | North Carolina | 37193 | 6936 | 117 |
1417838 | 1417838 | 2021-06-14 | Boone | Indiana | 18011 | 6936 | 107 |
1368546 | 1368546 | 2021-05-30 | Gila | Arizona | 4007 | 6936 | 229 |
1353487 | 1353487 | 2021-05-25 | Gratiot | Michigan | 26057 | 6936 | 122 |
1348267 | 1348267 | 2021-05-23 | Coffee | Tennessee | 47031 | 6936 | 124 |
1345019 | 1345019 | 2021-05-22 | Coffee | Tennessee | 47031 | 6936 | 124 |
1341771 | 1341771 | 2021-05-21 | Coffee | Tennessee | 47031 | 6936 | 124 |
1338523 | 1338523 | 2021-05-20 | Coffee | Tennessee | 47031 | 6936 | 124 |
1321839 | 1321839 | 2021-05-15 | Hancock | Ohio | 39063 | 6936 | 128 |
1276938 | 1276938 | 2021-05-01 | Bowie | Texas | 48037 | 6936 | 212 |
1132637 | 1132637 | 2021-03-18 | Wicomico | Maryland | 24045 | 6936 | 147 |
1125646 | 1125646 | 2021-03-16 | Grant | Indiana | 18053 | 6936 | 169 |
1111356 | 1111356 | 2021-03-11 | Coryell | Texas | 48099 | 6936 | 80 |
1100933 | 1100933 | 2021-03-08 | Stanly | North Carolina | 37167 | 6936 | 111 |
1087301 | 1087301 | 2021-03-04 | Clay | Minnesota | 27027 | 6936 | 87 |
978765 | 978765 | 2021-01-29 | Chippewa | Wisconsin | 55017 | 6936 | 81 |
975462 | 975462 | 2021-01-28 | Cabell | West Virginia | 54011 | 6936 | 143 |
781337 | 781337 | 2020-11-30 | Forsyth | Georgia | 13117 | 6936 | 62 |
760592 | 760592 | 2020-11-23 | Berkeley | South Carolina | 45015 | 6936 | 103 |
737233 | 737233 | 2020-11-16 | Hillsborough | New Hampshire | 33011 | 6936 | 328 |
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);