ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
209 rows where cases = 2220 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 14
- Kentucky 13
- Georgia 12
- Illinois 10
- Idaho 9
- Kansas 9
- Alabama 8
- Missouri 8
- North Carolina 8
- Texas 8
- Virginia 8
- South Dakota 7
- Arkansas 6
- California 6
- Puerto Rico 6
- Washington 6
- Colorado 5
- Pennsylvania 5
- South Carolina 5
- Utah 5
- West Virginia 5
- Florida 4
- Louisiana 4
- Tennessee 4
- Wisconsin 4
- Indiana 3
- Iowa 3
- Minnesota 3
- New York 3
- Oregon 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456322 | 2456322 | 2022-04-29 | Arroyo | Puerto Rico | 72015 | 2220 | |
2381432 | 2381432 | 2022-04-06 | Adjuntas | Puerto Rico | 72001 | 2220 | |
2313782 | 2313782 | 2022-03-16 | Madison | Virginia | 51113 | 2220 | 37 |
2306726 | 2306726 | 2022-03-14 | McCormick | South Carolina | 45065 | 2220 | 38 |
2303475 | 2303475 | 2022-03-13 | McCormick | South Carolina | 45065 | 2220 | 38 |
2300223 | 2300223 | 2022-03-12 | McCormick | South Carolina | 45065 | 2220 | 38 |
2296971 | 2296971 | 2022-03-11 | McCormick | South Carolina | 45065 | 2220 | 38 |
2289528 | 2289528 | 2022-03-09 | Carroll | Missouri | 29033 | 2220 | 44 |
2290467 | 2290467 | 2022-03-09 | McCormick | South Carolina | 45065 | 2220 | 38 |
2286276 | 2286276 | 2022-03-08 | Carroll | Missouri | 29033 | 2220 | 44 |
2268801 | 2268801 | 2022-03-03 | San Miguel | Colorado | 8113 | 2220 | 8 |
2219482 | 2219482 | 2022-02-15 | Lunenburg | Virginia | 51111 | 2220 | 27 |
2197438 | 2197438 | 2022-02-09 | Johnson | Georgia | 13167 | 2220 | 67 |
2194155 | 2194155 | 2022-02-08 | Evans | Georgia | 13109 | 2220 | 61 |
2188134 | 2188134 | 2022-02-06 | Grant | Kansas | 20067 | 2220 | 34 |
2184881 | 2184881 | 2022-02-05 | Grant | Kansas | 20067 | 2220 | 34 |
2181629 | 2181629 | 2022-02-04 | Grant | Kansas | 20067 | 2220 | 34 |
2178378 | 2178378 | 2022-02-03 | Grant | Kansas | 20067 | 2220 | 34 |
2161184 | 2161184 | 2022-01-29 | Bullock | Alabama | 1011 | 2220 | 47 |
2112358 | 2112358 | 2022-01-13 | Big Horn | Wyoming | 56003 | 2220 | 60 |
2103287 | 2103287 | 2022-01-11 | Marshall | Illinois | 17123 | 2220 | 26 |
2100966 | 2100966 | 2022-01-10 | Ripley | Missouri | 29181 | 2220 | 52 |
2078085 | 2078085 | 2022-01-03 | Perry | Mississippi | 28111 | 2220 | 57 |
2078647 | 2078647 | 2022-01-03 | McLean | North Dakota | 38055 | 2220 | 47 |
2059593 | 2059593 | 2021-12-28 | Dewey | South Dakota | 46041 | 2220 | 35 |
2052983 | 2052983 | 2021-12-26 | Juana Diaz | Puerto Rico | 72075 | 2220 | |
2040771 | 2040771 | 2021-12-22 | Bayfield | Wisconsin | 55007 | 2220 | 31 |
2011686 | 2011686 | 2021-12-14 | Ketchikan Gateway Borough | Alaska | 2130 | 2220 | 12 |
2008435 | 2008435 | 2021-12-13 | Ketchikan Gateway Borough | Alaska | 2130 | 2220 | 12 |
2002004 | 2002004 | 2021-12-11 | Lee | Arkansas | 5077 | 2220 | 53 |
1983691 | 1983691 | 2021-12-05 | Chippewa | Minnesota | 27023 | 2220 | 43 |
1980441 | 1980441 | 2021-12-04 | Chippewa | Minnesota | 27023 | 2220 | 43 |
1977191 | 1977191 | 2021-12-03 | Chippewa | Minnesota | 27023 | 2220 | 43 |
1970842 | 1970842 | 2021-12-01 | Walthall | Mississippi | 28147 | 2220 | 66 |
1948914 | 1948914 | 2021-11-24 | Potter | Pennsylvania | 42105 | 2220 | 54 |
1937540 | 1937540 | 2021-11-21 | Wabash | Illinois | 17185 | 2220 | 22 |
1937881 | 1937881 | 2021-11-21 | Fleming | Kentucky | 21069 | 2220 | 37 |
1934290 | 1934290 | 2021-11-20 | Wabash | Illinois | 17185 | 2220 | 22 |
1934631 | 1934631 | 2021-11-20 | Fleming | Kentucky | 21069 | 2220 | 37 |
1931039 | 1931039 | 2021-11-19 | Wabash | Illinois | 17185 | 2220 | 22 |
1931380 | 1931380 | 2021-11-19 | Fleming | Kentucky | 21069 | 2220 | 37 |
1921533 | 1921533 | 2021-11-16 | Jackson | Kansas | 20085 | 2220 | 20 |
1918283 | 1918283 | 2021-11-15 | Jackson | Kansas | 20085 | 2220 | 20 |
1904928 | 1904928 | 2021-11-11 | Idaho | Idaho | 16049 | 2220 | 36 |
1901678 | 1901678 | 2021-11-10 | Idaho | Idaho | 16049 | 2220 | 36 |
1898913 | 1898913 | 2021-11-09 | Leslie | Kentucky | 21131 | 2220 | 21 |
1874325 | 1874325 | 2021-11-01 | Clay | South Dakota | 46027 | 2220 | 18 |
1836145 | 1836145 | 2021-10-21 | Lamar | Alabama | 1075 | 2220 | 47 |
1835834 | 1835834 | 2021-10-20 | Giles | Virginia | 51071 | 2220 | 30 |
1830764 | 1830764 | 2021-10-19 | Madison | Louisiana | 22065 | 2220 | 52 |
1831666 | 1831666 | 2021-10-19 | Walsh | North Dakota | 38099 | 2220 | 29 |
1827515 | 1827515 | 2021-10-18 | Madison | Louisiana | 22065 | 2220 | 52 |
1769359 | 1769359 | 2021-09-30 | Tallahatchie | Mississippi | 28135 | 2220 | 50 |
1764670 | 1764670 | 2021-09-29 | Macon | Alabama | 1087 | 2220 | 58 |
1746235 | 1746235 | 2021-09-23 | Powell | Kentucky | 21197 | 2220 | 17 |
1747447 | 1747447 | 2021-09-23 | Montour | Pennsylvania | 42093 | 2220 | 68 |
1743636 | 1743636 | 2021-09-22 | Seward | Nebraska | 31159 | 2220 | 34 |
1721653 | 1721653 | 2021-09-15 | Oglala Lakota | South Dakota | 46102 | 2220 | 51 |
1717805 | 1717805 | 2021-09-14 | Bertie | North Carolina | 37015 | 2220 | 46 |
1699944 | 1699944 | 2021-09-09 | Otero | Colorado | 8089 | 2220 | 70 |
1702029 | 1702029 | 2021-09-09 | Las Piedras | Puerto Rico | 72085 | 2220 | |
1698780 | 1698780 | 2021-09-08 | Las Piedras | Puerto Rico | 72085 | 2220 | |
1693561 | 1693561 | 2021-09-07 | Brooks | Georgia | 13027 | 2220 | 55 |
1689814 | 1689814 | 2021-09-05 | Adams | Wisconsin | 55001 | 2220 | 21 |
1686564 | 1686564 | 2021-09-04 | Adams | Wisconsin | 55001 | 2220 | 21 |
1683314 | 1683314 | 2021-09-03 | Adams | Wisconsin | 55001 | 2220 | 21 |
1666693 | 1666693 | 2021-08-29 | Llano | Texas | 48299 | 2220 | 58 |
1663445 | 1663445 | 2021-08-28 | Llano | Texas | 48299 | 2220 | 58 |
1654240 | 1654240 | 2021-08-26 | Washington | Alabama | 1129 | 2220 | 42 |
1622367 | 1622367 | 2021-08-16 | Pike | Illinois | 17149 | 2220 | 57 |
1621568 | 1621568 | 2021-08-15 | Mason | West Virginia | 54053 | 2220 | 38 |
1618320 | 1618320 | 2021-08-14 | Mason | West Virginia | 54053 | 2220 | 38 |
1615072 | 1615072 | 2021-08-13 | Mason | West Virginia | 54053 | 2220 | 38 |
1599211 | 1599211 | 2021-08-09 | Crowley | Colorado | 8025 | 2220 | 17 |
1601978 | 1601978 | 2021-08-09 | Prince Edward | Virginia | 51147 | 2220 | 36 |
1596675 | 1596675 | 2021-08-08 | Pottawatomie | Kansas | 20149 | 2220 | 34 |
1593426 | 1593426 | 2021-08-07 | Pottawatomie | Kansas | 20149 | 2220 | 34 |
1590177 | 1590177 | 2021-08-06 | Pottawatomie | Kansas | 20149 | 2220 | 34 |
1586086 | 1586086 | 2021-08-05 | Cross | Arkansas | 5037 | 2220 | 53 |
1582871 | 1582871 | 2021-08-04 | Phillips | Arkansas | 5107 | 2220 | 48 |
1583930 | 1583930 | 2021-08-04 | Talbot | Maryland | 24041 | 2220 | 45 |
1573537 | 1573537 | 2021-08-01 | Elmore | Idaho | 16039 | 2220 | 19 |
1570289 | 1570289 | 2021-07-31 | Elmore | Idaho | 16039 | 2220 | 19 |
1567041 | 1567041 | 2021-07-30 | Elmore | Idaho | 16039 | 2220 | 19 |
1560749 | 1560749 | 2021-07-28 | Sullivan | Indiana | 18153 | 2220 | 43 |
1558291 | 1558291 | 2021-07-27 | New Madrid | Missouri | 29143 | 2220 | 48 |
1551335 | 1551335 | 2021-07-25 | Simpson | Kentucky | 21213 | 2220 | 43 |
1548088 | 1548088 | 2021-07-24 | Simpson | Kentucky | 21213 | 2220 | 43 |
1544841 | 1544841 | 2021-07-23 | Simpson | Kentucky | 21213 | 2220 | 43 |
1516740 | 1516740 | 2021-07-14 | Coos | Oregon | 41011 | 2220 | 39 |
1491973 | 1491973 | 2021-07-07 | Calaveras | California | 6009 | 2220 | 56 |
1488726 | 1488726 | 2021-07-06 | Calaveras | California | 6009 | 2220 | 56 |
1485459 | 1485459 | 2021-07-05 | Randolph | Arkansas | 5121 | 2220 | 48 |
1478313 | 1478313 | 2021-07-02 | Lampasas | Texas | 48281 | 2220 | 33 |
1474833 | 1474833 | 2021-07-01 | Bledsoe | Tennessee | 47007 | 2220 | 11 |
1432878 | 1432878 | 2021-06-18 | Lee | Texas | 48287 | 2220 | 39 |
1420025 | 1420025 | 2021-06-14 | Sevier | Utah | 49041 | 2220 | 14 |
1415328 | 1415328 | 2021-06-13 | Jasper | Mississippi | 28061 | 2220 | 48 |
1416780 | 1416780 | 2021-06-13 | Sevier | Utah | 49041 | 2220 | 14 |
1412082 | 1412082 | 2021-06-12 | Jasper | Mississippi | 28061 | 2220 | 48 |
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);