ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
97 rows where cases = 5959 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Indiana 11
- Missouri 10
- Georgia 9
- Florida 8
- Kentucky 7
- Texas 5
- Alabama 4
- Arkansas 4
- Louisiana 4
- Puerto Rico 4
- Michigan 3
- South Carolina 3
- Virginia 3
- California 2
- Illinois 2
- New York 2
- Tennessee 2
- Washington 2
- Arizona 1
- Colorado 1
- Idaho 1
- Minnesota 1
- Mississippi 1
- North Carolina 1
- Ohio 1
- Pennsylvania 1
- South Dakota 1
- Utah 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2479142 | 2479142 | 2022-05-06 | Hatillo | Puerto Rico | 72065 | 5959 | |
2415916 | 2415916 | 2022-04-17 | Bourbon | Kentucky | 21017 | 5959 | 55 |
2412660 | 2412660 | 2022-04-16 | Bourbon | Kentucky | 21017 | 5959 | 55 |
2409404 | 2409404 | 2022-04-15 | Bourbon | Kentucky | 21017 | 5959 | 55 |
2406148 | 2406148 | 2022-04-14 | Bourbon | Kentucky | 21017 | 5959 | 55 |
2402892 | 2402892 | 2022-04-13 | Bourbon | Kentucky | 21017 | 5959 | 55 |
2399638 | 2399638 | 2022-04-12 | Bourbon | Kentucky | 21017 | 5959 | 55 |
2396382 | 2396382 | 2022-04-11 | Bourbon | Kentucky | 21017 | 5959 | 55 |
2377735 | 2377735 | 2022-04-05 | Seneca | New York | 36099 | 5959 | 89 |
2350380 | 2350380 | 2022-03-28 | Blaine | Idaho | 16013 | 5959 | 30 |
2280696 | 2280696 | 2022-03-06 | Fairfield | South Carolina | 45039 | 5959 | 103 |
2277443 | 2277443 | 2022-03-05 | Fairfield | South Carolina | 45039 | 5959 | 103 |
2274190 | 2274190 | 2022-03-04 | Fairfield | South Carolina | 45039 | 5959 | 103 |
2268643 | 2268643 | 2022-03-03 | Jackson | Arkansas | 5067 | 5959 | 54 |
2265390 | 2265390 | 2022-03-02 | Jackson | Arkansas | 5067 | 5959 | 54 |
2262282 | 2262282 | 2022-03-01 | Montezuma | Colorado | 8083 | 5959 | 67 |
2259536 | 2259536 | 2022-02-28 | Washington | Indiana | 18175 | 5959 | 77 |
2247313 | 2247313 | 2022-02-24 | Nodaway | Missouri | 29147 | 5959 | 42 |
2232854 | 2232854 | 2022-02-20 | Carroll | Arkansas | 5015 | 5959 | 90 |
2211543 | 2211543 | 2022-02-13 | Miller | Missouri | 29131 | 5959 | 111 |
2208290 | 2208290 | 2022-02-12 | Miller | Missouri | 29131 | 5959 | 111 |
2205037 | 2205037 | 2022-02-11 | Miller | Missouri | 29131 | 5959 | 111 |
2201784 | 2201784 | 2022-02-10 | Miller | Missouri | 29131 | 5959 | 111 |
2157040 | 2157040 | 2022-01-27 | Isabela | Puerto Rico | 72071 | 5959 | |
2152580 | 2152580 | 2022-01-26 | Richland | Louisiana | 22083 | 5959 | 83 |
2125427 | 2125427 | 2022-01-18 | Lawrence | Alabama | 1079 | 5959 | 140 |
2105669 | 2105669 | 2022-01-11 | Smyth | Virginia | 51173 | 5959 | 140 |
2028360 | 2028360 | 2021-12-19 | Oconee | Georgia | 13219 | 5959 | 82 |
2029003 | 2029003 | 2021-12-19 | Evangeline | Louisiana | 22039 | 5959 | 143 |
2025109 | 2025109 | 2021-12-18 | Oconee | Georgia | 13219 | 5959 | 82 |
2025752 | 2025752 | 2021-12-18 | Evangeline | Louisiana | 22039 | 5959 | 143 |
2027016 | 2027016 | 2021-12-18 | Unknown | Puerto Rico | 5959 | 3284 | |
2021858 | 2021858 | 2021-12-17 | Oconee | Georgia | 13219 | 5959 | 82 |
2022501 | 2022501 | 2021-12-17 | Evangeline | Louisiana | 22039 | 5959 | 143 |
2014194 | 2014194 | 2021-12-14 | Marion | Tennessee | 47115 | 5959 | 75 |
1965329 | 1965329 | 2021-11-29 | Codington | South Dakota | 46029 | 5959 | 86 |
1961212 | 1961212 | 2021-11-28 | Webster | Missouri | 29225 | 5959 | 116 |
1957961 | 1957961 | 2021-11-27 | Webster | Missouri | 29225 | 5959 | 116 |
1954710 | 1954710 | 2021-11-26 | Webster | Missouri | 29225 | 5959 | 116 |
1951459 | 1951459 | 2021-11-25 | Webster | Missouri | 29225 | 5959 | 116 |
1948208 | 1948208 | 2021-11-24 | Webster | Missouri | 29225 | 5959 | 116 |
1842635 | 1842635 | 2021-10-23 | Franklin | Alabama | 1059 | 5959 | 105 |
1839386 | 1839386 | 2021-10-22 | Franklin | Alabama | 1059 | 5959 | 105 |
1829429 | 1829429 | 2021-10-18 | Douglas | Washington | 53017 | 5959 | 38 |
1791952 | 1791952 | 2021-10-07 | Beltrami | Minnesota | 27007 | 5959 | 76 |
1768634 | 1768634 | 2021-09-30 | Montgomery | Indiana | 18107 | 5959 | 108 |
1732873 | 1732873 | 2021-09-19 | Harrison | Indiana | 18061 | 5959 | 88 |
1729623 | 1729623 | 2021-09-18 | Harrison | Indiana | 18061 | 5959 | 88 |
1726373 | 1726373 | 2021-09-17 | Harrison | Indiana | 18061 | 5959 | 88 |
1727503 | 1727503 | 2021-09-17 | Genesee | New York | 36037 | 5959 | 126 |
1723031 | 1723031 | 2021-09-16 | Jefferson | Illinois | 17081 | 5959 | 131 |
1645898 | 1645898 | 2021-08-23 | Oktibbeha | Mississippi | 28105 | 5959 | 102 |
1628627 | 1628627 | 2021-08-18 | Effingham | Georgia | 13103 | 5959 | 79 |
1625478 | 1625478 | 2021-08-17 | Ware | Georgia | 13299 | 5959 | 191 |
1627301 | 1627301 | 2021-08-17 | Guaynabo | Puerto Rico | 72061 | 5959 | |
1586195 | 1586195 | 2021-08-05 | Tehama | California | 6103 | 5959 | 66 |
1587252 | 1587252 | 2021-08-05 | Marquette | Michigan | 26103 | 5959 | 66 |
1584001 | 1584001 | 2021-08-04 | Marquette | Michigan | 26103 | 5959 | 66 |
1580752 | 1580752 | 2021-08-03 | Marquette | Michigan | 26103 | 5959 | 66 |
1554211 | 1554211 | 2021-07-26 | Henry | Indiana | 18065 | 5959 | 113 |
1540827 | 1540827 | 2021-07-22 | Gadsden | Florida | 12039 | 5959 | 99 |
1537580 | 1537580 | 2021-07-21 | Gadsden | Florida | 12039 | 5959 | 99 |
1534332 | 1534332 | 2021-07-20 | Gadsden | Florida | 12039 | 5959 | 99 |
1531085 | 1531085 | 2021-07-19 | Gadsden | Florida | 12039 | 5959 | 99 |
1527838 | 1527838 | 2021-07-18 | Gadsden | Florida | 12039 | 5959 | 99 |
1528216 | 1528216 | 2021-07-18 | Dearborn | Indiana | 18029 | 5959 | 81 |
1524591 | 1524591 | 2021-07-17 | Gadsden | Florida | 12039 | 5959 | 99 |
1524969 | 1524969 | 2021-07-17 | Dearborn | Indiana | 18029 | 5959 | 81 |
1521343 | 1521343 | 2021-07-16 | Gadsden | Florida | 12039 | 5959 | 99 |
1521721 | 1521721 | 2021-07-16 | Dearborn | Indiana | 18029 | 5959 | 81 |
1475065 | 1475065 | 2021-07-01 | Lamar | Texas | 48277 | 5959 | 157 |
1471819 | 1471819 | 2021-06-30 | Lamar | Texas | 48277 | 5959 | 157 |
1468574 | 1468574 | 2021-06-29 | Lamar | Texas | 48277 | 5959 | 157 |
1413570 | 1413570 | 2021-06-12 | Augusta | Virginia | 51015 | 5959 | 75 |
1410325 | 1410325 | 2021-06-11 | Augusta | Virginia | 51015 | 5959 | 74 |
1378896 | 1378896 | 2021-06-02 | Cass | Indiana | 18017 | 5959 | 110 |
1375650 | 1375650 | 2021-06-01 | Cass | Indiana | 18017 | 5959 | 110 |
1357728 | 1357728 | 2021-05-26 | Armstrong | Pennsylvania | 42005 | 5959 | 142 |
1358576 | 1358576 | 2021-05-26 | Harrison | West Virginia | 54033 | 5959 | 77 |
1309915 | 1309915 | 2021-05-11 | Barron | Wisconsin | 55005 | 5959 | 83 |
1180633 | 1180633 | 2021-04-02 | Spalding | Georgia | 13255 | 5959 | 182 |
1167541 | 1167541 | 2021-03-29 | Catoosa | Georgia | 13047 | 5959 | 66 |
1092805 | 1092805 | 2021-03-06 | Jackson | Florida | 12063 | 5959 | 152 |
1078287 | 1078287 | 2021-03-01 | Ashtabula | Ohio | 39007 | 5959 | 147 |
1043783 | 1043783 | 2021-02-19 | Colbert | Alabama | 1033 | 5959 | 117 |
1026836 | 1026836 | 2021-02-13 | Cumberland | Tennessee | 47035 | 5959 | 111 |
991490 | 991490 | 2021-02-02 | Tooele | Utah | 49045 | 5959 | 23 |
991652 | 991652 | 2021-02-02 | Chelan | Washington | 53007 | 5959 | 51 |
962754 | 962754 | 2021-01-25 | Crawford | Arkansas | 5033 | 5959 | 85 |
891424 | 891424 | 2021-01-03 | El Dorado | California | 6017 | 5959 | 24 |
634273 | 634273 | 2020-10-15 | Bell | Texas | 48027 | 5959 | 94 |
628499 | 628499 | 2020-10-14 | Navajo | Arizona | 4017 | 5959 | 236 |
573985 | 573985 | 2020-09-27 | Winnebago | Illinois | 17201 | 5959 | 153 |
567217 | 567217 | 2020-09-25 | Cherokee | Georgia | 13057 | 5959 | 92 |
439392 | 439392 | 2020-08-16 | Guilford | North Carolina | 37081 | 5959 | 158 |
407987 | 407987 | 2020-08-06 | Lubbock | Texas | 48303 | 5959 | 80 |
290654 | 290654 | 2020-07-01 | DeKalb | Georgia | 13089 | 5959 | 173 |
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);