ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
128 rows where cases = 3556 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 14
- Iowa 10
- Michigan 9
- Mississippi 8
- Minnesota 7
- Texas 7
- Alabama 6
- Virginia 6
- Tennessee 5
- Wisconsin 5
- Colorado 4
- New York 4
- Arkansas 3
- Indiana 3
- Kentucky 3
- Missouri 3
- Ohio 3
- Oregon 3
- Pennsylvania 3
- South Carolina 3
- California 2
- Illinois 2
- Louisiana 2
- Maine 2
- Alaska 1
- Maryland 1
- Montana 1
- New Hampshire 1
- New Mexico 1
- North Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2468399 | 2468399 | 2022-05-03 | Sibley | Minnesota | 27143 | 3556 | 24 |
2445039 | 2445039 | 2022-04-26 | Floyd | Iowa | 19067 | 3556 | 62 |
2441783 | 2441783 | 2022-04-25 | Floyd | Iowa | 19067 | 3556 | 62 |
2438527 | 2438527 | 2022-04-24 | Floyd | Iowa | 19067 | 3556 | 62 |
2435271 | 2435271 | 2022-04-23 | Floyd | Iowa | 19067 | 3556 | 62 |
2432015 | 2432015 | 2022-04-22 | Floyd | Iowa | 19067 | 3556 | 62 |
2428759 | 2428759 | 2022-04-21 | Floyd | Iowa | 19067 | 3556 | 62 |
2425503 | 2425503 | 2022-04-20 | Floyd | Iowa | 19067 | 3556 | 62 |
2336818 | 2336818 | 2022-03-24 | Cleburne | Alabama | 1029 | 3556 | 69 |
2333564 | 2333564 | 2022-03-23 | Cleburne | Alabama | 1029 | 3556 | 69 |
2330310 | 2330310 | 2022-03-22 | Cleburne | Alabama | 1029 | 3556 | 69 |
2327058 | 2327058 | 2022-03-21 | Cleburne | Alabama | 1029 | 3556 | 69 |
2313800 | 2313800 | 2022-03-16 | Patrick | Virginia | 51141 | 3556 | 91 |
2266806 | 2266806 | 2022-03-02 | Madison | Missouri | 29123 | 3556 | 50 |
2256947 | 2256947 | 2022-02-27 | Lawrence | Mississippi | 28077 | 3556 | 53 |
2253696 | 2253696 | 2022-02-26 | Lawrence | Mississippi | 28077 | 3556 | 53 |
2250445 | 2250445 | 2022-02-25 | Lawrence | Mississippi | 28077 | 3556 | 53 |
2247194 | 2247194 | 2022-02-24 | Lawrence | Mississippi | 28077 | 3556 | 52 |
2200984 | 2200984 | 2022-02-10 | Parke | Indiana | 18121 | 3556 | 43 |
2187675 | 2187675 | 2022-02-06 | Jefferson | Georgia | 13163 | 3556 | 100 |
2184422 | 2184422 | 2022-02-05 | Jefferson | Georgia | 13163 | 3556 | 100 |
2181170 | 2181170 | 2022-02-04 | Jefferson | Georgia | 13163 | 3556 | 100 |
2183470 | 2183470 | 2022-02-04 | Leon | Texas | 48289 | 3556 | 81 |
2142061 | 2142061 | 2022-01-23 | Brantley | Georgia | 13025 | 3556 | 93 |
2138806 | 2138806 | 2022-01-22 | Brantley | Georgia | 13025 | 3556 | 93 |
2135550 | 2135550 | 2022-01-21 | Brantley | Georgia | 13025 | 3556 | 93 |
2124431 | 2124431 | 2022-01-17 | Fulton | Pennsylvania | 42057 | 3556 | 55 |
2106513 | 2106513 | 2022-01-12 | Hancock | Illinois | 17067 | 3556 | 49 |
2102144 | 2102144 | 2022-01-10 | Lavaca | Texas | 48285 | 3556 | 100 |
2073668 | 2073668 | 2022-01-02 | Teller | Colorado | 8119 | 3556 | 50 |
2070417 | 2070417 | 2022-01-01 | Teller | Colorado | 8119 | 3556 | 50 |
2067166 | 2067166 | 2021-12-31 | Teller | Colorado | 8119 | 3556 | 50 |
2062405 | 2062405 | 2021-12-29 | Rolette | North Dakota | 38079 | 3556 | 36 |
2052947 | 2052947 | 2021-12-26 | Aguadilla | Puerto Rico | 72005 | 3556 | |
2034754 | 2034754 | 2021-12-21 | Appling | Georgia | 13001 | 3556 | 108 |
2035622 | 2035622 | 2021-12-21 | Cheboygan | Michigan | 26031 | 3556 | 79 |
2032372 | 2032372 | 2021-12-20 | Cheboygan | Michigan | 26031 | 3556 | 79 |
2006684 | 2006684 | 2021-12-12 | Perry | Missouri | 29157 | 3556 | 39 |
2004155 | 2004155 | 2021-12-11 | Juniata | Pennsylvania | 42067 | 3556 | 137 |
1963580 | 1963580 | 2021-11-29 | Fulton | Indiana | 18049 | 3556 | 72 |
1965385 | 1965385 | 2021-11-29 | Bledsoe | Tennessee | 47007 | 3556 | 22 |
1944395 | 1944395 | 2021-11-23 | Harrison | Kentucky | 21097 | 3556 | 48 |
1946353 | 1946353 | 2021-11-23 | Mecklenburg | Virginia | 51117 | 3556 | 87 |
1942004 | 1942004 | 2021-11-22 | Ashe | North Carolina | 37009 | 3556 | 53 |
1942344 | 1942344 | 2021-11-22 | Lincoln | Oregon | 41041 | 3556 | 50 |
1921809 | 1921809 | 2021-11-16 | Garrett | Maryland | 24023 | 3556 | 84 |
1921863 | 1921863 | 2021-11-16 | Gladwin | Michigan | 26051 | 3556 | 79 |
1918613 | 1918613 | 2021-11-15 | Gladwin | Michigan | 26051 | 3556 | 79 |
1902468 | 1902468 | 2021-11-10 | Martin | Minnesota | 27091 | 3556 | 42 |
1882864 | 1882864 | 2021-11-04 | Emmet | Michigan | 26047 | 3556 | 51 |
1876103 | 1876103 | 2021-11-02 | Anderson | Kentucky | 21005 | 3556 | 48 |
1828231 | 1828231 | 2021-10-18 | Lewis | New York | 36049 | 3556 | 38 |
1823114 | 1823114 | 2021-10-17 | Barbour | Alabama | 1005 | 3556 | 75 |
1809112 | 1809112 | 2021-10-12 | Jefferson | Oregon | 41031 | 3556 | 50 |
1790446 | 1790446 | 2021-10-06 | Island | Washington | 53029 | 3556 | 43 |
1785528 | 1785528 | 2021-10-05 | Todd | Minnesota | 27153 | 3556 | 35 |
1780325 | 1780325 | 2021-10-03 | Fayette | Texas | 48149 | 3556 | 88 |
1777075 | 1777075 | 2021-10-02 | Fayette | Texas | 48149 | 3556 | 88 |
1771247 | 1771247 | 2021-10-01 | Cleburne | Arkansas | 5023 | 3556 | 88 |
1773825 | 1773825 | 2021-10-01 | Fayette | Texas | 48149 | 3556 | 88 |
1760417 | 1760417 | 2021-09-27 | Elk | Pennsylvania | 42047 | 3556 | 49 |
1761105 | 1761105 | 2021-09-27 | Gloucester | Virginia | 51073 | 3556 | 60 |
1756318 | 1756318 | 2021-09-26 | Grenada | Mississippi | 28043 | 3556 | 104 |
1753070 | 1753070 | 2021-09-25 | Grenada | Mississippi | 28043 | 3556 | 104 |
1749822 | 1749822 | 2021-09-24 | Grenada | Mississippi | 28043 | 3556 | 104 |
1747615 | 1747615 | 2021-09-23 | Davison | South Dakota | 46035 | 3556 | 69 |
1732642 | 1732642 | 2021-09-19 | Pike | Georgia | 13231 | 3556 | 54 |
1729392 | 1729392 | 2021-09-18 | Pike | Georgia | 13231 | 3556 | 54 |
1726142 | 1726142 | 2021-09-17 | Pike | Georgia | 13231 | 3556 | 54 |
1702695 | 1702695 | 2021-09-09 | Smyth | Virginia | 51173 | 3556 | 97 |
1673812 | 1673812 | 2021-09-01 | Lincoln | Arkansas | 5079 | 3556 | 55 |
1670348 | 1670348 | 2021-08-30 | Juneau | Wisconsin | 55057 | 3556 | 32 |
1652758 | 1652758 | 2021-08-25 | Luna | New Mexico | 35029 | 3556 | 92 |
1644910 | 1644910 | 2021-08-23 | Lee | Georgia | 13177 | 3556 | 62 |
1624748 | 1624748 | 2021-08-16 | Wise | Virginia | 51195 | 3556 | 107 |
1564356 | 1564356 | 2021-07-29 | East Feliciana | Louisiana | 22037 | 3556 | 119 |
1565785 | 1565785 | 2021-07-29 | Henry | Tennessee | 47079 | 3556 | 76 |
1554601 | 1554601 | 2021-07-26 | Beauregard | Louisiana | 22011 | 3556 | 80 |
1528831 | 1528831 | 2021-07-18 | Carlton | Minnesota | 27017 | 3556 | 57 |
1525584 | 1525584 | 2021-07-17 | Carlton | Minnesota | 27017 | 3556 | 57 |
1522337 | 1522337 | 2021-07-16 | Carlton | Minnesota | 27017 | 3556 | 57 |
1519088 | 1519088 | 2021-07-15 | Carlton | Minnesota | 27017 | 3556 | 57 |
1492285 | 1492285 | 2021-07-07 | Pickens | Georgia | 13227 | 3556 | 79 |
1434911 | 1434911 | 2021-06-19 | Lawrence | Missouri | 29109 | 3556 | 87 |
1425468 | 1425468 | 2021-06-16 | Allegany | New York | 36003 | 3556 | 87 |
1426068 | 1426068 | 2021-06-16 | Marion | South Carolina | 45067 | 3556 | 108 |
1417332 | 1417332 | 2021-06-14 | Lake | California | 6033 | 3556 | 45 |
1398675 | 1398675 | 2021-06-08 | Calloway | Kentucky | 21035 | 3556 | 50 |
1352505 | 1352505 | 2021-05-25 | Montrose | Colorado | 8085 | 3556 | 58 |
1308856 | 1308856 | 2021-05-11 | Highland | Ohio | 39071 | 3556 | 62 |
1279326 | 1279326 | 2021-05-02 | Cheshire | New Hampshire | 33005 | 3556 | 33 |
1258831 | 1258831 | 2021-04-26 | Putnam | Indiana | 18133 | 3556 | 60 |
1257244 | 1257244 | 2021-04-25 | Colleton | South Carolina | 45029 | 3556 | 126 |
1257862 | 1257862 | 2021-04-25 | Tazewell | Virginia | 51185 | 3556 | 65 |
1229241 | 1229241 | 2021-04-17 | Bryan | Georgia | 13029 | 3556 | 37 |
1215134 | 1215134 | 2021-04-12 | Carroll | Tennessee | 47017 | 3556 | 82 |
1212067 | 1212067 | 2021-04-11 | Grimes | Texas | 48185 | 3556 | 66 |
1208818 | 1208818 | 2021-04-10 | Grimes | Texas | 48185 | 3556 | 66 |
1151741 | 1151741 | 2021-03-24 | Lee | Iowa | 19111 | 3556 | 55 |
1154052 | 1154052 | 2021-03-24 | Clark | Wisconsin | 55019 | 3556 | 62 |
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);