ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
105 rows where cases = 4665 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 14
- Kentucky 8
- Mississippi 8
- Virginia 7
- West Virginia 6
- Arkansas 5
- Georgia 5
- Louisiana 5
- Ohio 5
- North Carolina 4
- Alabama 3
- New York 3
- Pennsylvania 3
- Texas 3
- Washington 3
- Colorado 2
- Florida 2
- Illinois 2
- Michigan 2
- Minnesota 2
- Puerto Rico 2
- Tennessee 2
- California 1
- Hawaii 1
- Massachusetts 1
- Missouri 1
- Nebraska 1
- New Hampshire 1
- North Dakota 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2446623 | 2446623 | 2022-04-26 | Yabucoa | Puerto Rico | 72151 | 4665 | |
2381441 | 2381441 | 2022-04-06 | Barranquitas | Puerto Rico | 72019 | 4665 | |
2356751 | 2356751 | 2022-03-30 | Crisp | Georgia | 13081 | 4665 | 135 |
2353834 | 2353834 | 2022-03-29 | Perry | Indiana | 18123 | 4665 | 68 |
2350246 | 2350246 | 2022-03-28 | Crisp | Georgia | 13081 | 4665 | 135 |
2350582 | 2350582 | 2022-03-28 | Perry | Indiana | 18123 | 4665 | 68 |
2347329 | 2347329 | 2022-03-27 | Perry | Indiana | 18123 | 4665 | 68 |
2344076 | 2344076 | 2022-03-26 | Perry | Indiana | 18123 | 4665 | 68 |
2340823 | 2340823 | 2022-03-25 | Perry | Indiana | 18123 | 4665 | 68 |
2337570 | 2337570 | 2022-03-24 | Perry | Indiana | 18123 | 4665 | 68 |
2334316 | 2334316 | 2022-03-23 | Perry | Indiana | 18123 | 4665 | 68 |
2256593 | 2256593 | 2022-02-27 | Powell | Kentucky | 21197 | 4665 | 37 |
2253342 | 2253342 | 2022-02-26 | Powell | Kentucky | 21197 | 4665 | 37 |
2250091 | 2250091 | 2022-02-25 | Powell | Kentucky | 21197 | 4665 | 37 |
2248841 | 2248841 | 2022-02-24 | Barbour | West Virginia | 54001 | 4665 | 74 |
2217759 | 2217759 | 2022-02-15 | Iosco | Michigan | 26069 | 4665 | 129 |
2218413 | 2218413 | 2022-02-15 | Currituck | North Carolina | 37053 | 4665 | 32 |
2214508 | 2214508 | 2022-02-14 | Iosco | Michigan | 26069 | 4665 | 129 |
2191903 | 2191903 | 2022-02-07 | Jasper | Mississippi | 28061 | 4665 | 67 |
2164582 | 2164582 | 2022-01-30 | Lawrence | Arkansas | 5075 | 4665 | 65 |
2161327 | 2161327 | 2022-01-29 | Lawrence | Arkansas | 5075 | 4665 | 65 |
2158071 | 2158071 | 2022-01-28 | Lawrence | Arkansas | 5075 | 4665 | 65 |
2135267 | 2135267 | 2022-01-21 | Clark | Arkansas | 5019 | 4665 | 66 |
2115495 | 2115495 | 2022-01-14 | Hampshire | West Virginia | 54027 | 4665 | 60 |
2097201 | 2097201 | 2022-01-09 | Marion | Kentucky | 21155 | 4665 | 63 |
2093949 | 2093949 | 2022-01-08 | Marion | Kentucky | 21155 | 4665 | 63 |
2090697 | 2090697 | 2022-01-07 | Marion | Kentucky | 21155 | 4665 | 63 |
2086925 | 2086925 | 2022-01-06 | Kauai | Hawaii | 15007 | 4665 | 18 |
2087139 | 2087139 | 2022-01-06 | Posey | Indiana | 18129 | 4665 | 46 |
2062145 | 2062145 | 2021-12-29 | Coos | New Hampshire | 33007 | 4665 | 84 |
2033772 | 2033772 | 2021-12-20 | Cass | Texas | 48067 | 4665 | 159 |
2027760 | 2027760 | 2021-12-18 | Upshur | West Virginia | 54097 | 4665 | 72 |
1998266 | 1998266 | 2021-12-09 | Bennington | Vermont | 50003 | 4665 | 39 |
1983077 | 1983077 | 2021-12-05 | Fayette | Indiana | 18041 | 4665 | 100 |
1979827 | 1979827 | 2021-12-04 | Fayette | Indiana | 18041 | 4665 | 100 |
1976577 | 1976577 | 2021-12-03 | Fayette | Indiana | 18041 | 4665 | 100 |
1964186 | 1964186 | 2021-11-29 | Brown | Minnesota | 27015 | 4665 | 57 |
1942189 | 1942189 | 2021-11-22 | Hardin | Ohio | 39065 | 4665 | 98 |
1919210 | 1919210 | 2021-11-15 | Greene | New York | 36039 | 4665 | 87 |
1905761 | 1905761 | 2021-11-11 | Adams | Mississippi | 28001 | 4665 | 125 |
1902512 | 1902512 | 2021-11-10 | Adams | Mississippi | 28001 | 4665 | 125 |
1899262 | 1899262 | 2021-11-09 | Adams | Mississippi | 28001 | 4665 | 124 |
1899771 | 1899771 | 2021-11-09 | Cherokee | North Carolina | 37039 | 4665 | 77 |
1891385 | 1891385 | 2021-11-07 | Lawrence | Alabama | 1079 | 4665 | 121 |
1893250 | 1893250 | 2021-11-07 | Wyoming | New York | 36121 | 4665 | 59 |
1856013 | 1856013 | 2021-10-27 | Butts | Georgia | 13035 | 4665 | 113 |
1834333 | 1834333 | 2021-10-20 | Prentiss | Mississippi | 28117 | 4665 | 81 |
1826839 | 1826839 | 2021-10-18 | Lee | Georgia | 13177 | 4665 | 79 |
1810421 | 1810421 | 2021-10-13 | Summit | Colorado | 8117 | 4665 | 10 |
1811265 | 1811265 | 2021-10-13 | Jefferson Davis | Louisiana | 22053 | 4665 | 124 |
1804740 | 1804740 | 2021-10-11 | Allen | Louisiana | 22003 | 4665 | 110 |
1784829 | 1784829 | 2021-10-05 | Adams | Indiana | 18001 | 4665 | 70 |
1741909 | 1741909 | 2021-09-22 | Dallas | Alabama | 1047 | 4665 | 182 |
1682234 | 1682234 | 2021-09-03 | Clinton | Ohio | 39027 | 4665 | 72 |
1655736 | 1655736 | 2021-08-26 | Marion | Missouri | 29127 | 4665 | 57 |
1644280 | 1644280 | 2021-08-22 | Whitman | Washington | 53075 | 4665 | 54 |
1641030 | 1641030 | 2021-08-21 | Whitman | Washington | 53075 | 4665 | 54 |
1637780 | 1637780 | 2021-08-20 | Whitman | Washington | 53075 | 4665 | 54 |
1622371 | 1622371 | 2021-08-16 | Randolph | Illinois | 17157 | 4665 | 95 |
1617260 | 1617260 | 2021-08-14 | Ashland | Ohio | 39005 | 4665 | 99 |
1577621 | 1577621 | 2021-08-02 | Winona | Minnesota | 27169 | 4665 | 52 |
1560125 | 1560125 | 2021-07-28 | Miller | Arkansas | 5091 | 4665 | 37 |
1554935 | 1554935 | 2021-07-26 | Marshall | Mississippi | 28093 | 4665 | 106 |
1507888 | 1507888 | 2021-07-11 | Marion | West Virginia | 54049 | 4665 | 52 |
1504642 | 1504642 | 2021-07-10 | Marion | West Virginia | 54049 | 4665 | 52 |
1501396 | 1501396 | 2021-07-09 | Marion | West Virginia | 54049 | 4665 | 52 |
1452575 | 1452575 | 2021-06-24 | James City | Virginia | 51095 | 4665 | 72 |
1446084 | 1446084 | 2021-06-22 | James City | Virginia | 51095 | 4665 | 72 |
1439594 | 1439594 | 2021-06-20 | James City | Virginia | 51095 | 4665 | 72 |
1436343 | 1436343 | 2021-06-19 | Henry | Virginia | 51089 | 4665 | 124 |
1425089 | 1425089 | 2021-06-16 | Panola | Mississippi | 28107 | 4665 | 110 |
1426605 | 1426605 | 2021-06-16 | Henry | Virginia | 51089 | 4665 | 124 |
1400640 | 1400640 | 2021-06-08 | Henry | Virginia | 51089 | 4665 | 124 |
1346165 | 1346165 | 2021-05-23 | Effingham | Georgia | 13103 | 4665 | 69 |
1317558 | 1317558 | 2021-05-14 | Jessamine | Kentucky | 21113 | 4665 | 64 |
1308711 | 1308711 | 2021-05-11 | Hoke | North Carolina | 37093 | 4665 | 55 |
1278714 | 1278714 | 2021-05-02 | St. Mary | Louisiana | 22101 | 4665 | 134 |
1275467 | 1275467 | 2021-05-01 | St. Mary | Louisiana | 22101 | 4665 | 134 |
1271301 | 1271301 | 2021-04-30 | Broomfield | Colorado | 8014 | 4665 | 75 |
1272220 | 1272220 | 2021-04-30 | St. Mary | Louisiana | 22101 | 4665 | 134 |
1250369 | 1250369 | 2021-04-23 | Stark | North Dakota | 38089 | 4665 | 51 |
1188677 | 1188677 | 2021-04-04 | Auglaize | Ohio | 39011 | 4665 | 84 |
1185430 | 1185430 | 2021-04-03 | Auglaize | Ohio | 39011 | 4665 | 84 |
1181223 | 1181223 | 2021-04-02 | Scott | Kentucky | 21209 | 4665 | 32 |
1163358 | 1163358 | 2021-03-27 | Harrison | Texas | 48203 | 4665 | 104 |
1138542 | 1138542 | 2021-03-20 | Jackson | Illinois | 17077 | 4665 | 73 |
1136557 | 1136557 | 2021-03-19 | Wayne | New York | 36117 | 4665 | 65 |
1090902 | 1090902 | 2021-03-05 | Dodge | Nebraska | 31053 | 4665 | 56 |
1078773 | 1078773 | 2021-03-01 | Fayette | Tennessee | 47047 | 4665 | 71 |
990530 | 990530 | 2021-02-02 | Franklin | North Carolina | 37069 | 4665 | 41 |
947159 | 947159 | 2021-01-20 | Noble | Indiana | 18113 | 4665 | 60 |
932614 | 932614 | 2021-01-15 | Kershaw | South Carolina | 45055 | 4665 | 86 |
921672 | 921672 | 2021-01-12 | Hampshire | Massachusetts | 25015 | 4665 | 211 |
921927 | 921927 | 2021-01-12 | Washington | Mississippi | 28151 | 4665 | 121 |
897011 | 897011 | 2021-01-04 | Carter | Tennessee | 47019 | 4665 | 89 |
897455 | 897455 | 2021-01-04 | Hampton city | Virginia | 51650 | 4665 | 49 |
878614 | 878614 | 2020-12-30 | Nassau | Florida | 12089 | 4665 | 66 |
867548 | 867548 | 2020-12-26 | Crawford | Pennsylvania | 42039 | 4665 | 70 |
809562 | 809562 | 2020-12-08 | Guadalupe | Texas | 48187 | 4665 | 88 |
793927 | 793927 | 2020-12-04 | St. Clair | Alabama | 1115 | 4665 | 57 |
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);