ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
152 rows where cases = 3674 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 19
- Illinois 13
- Texas 10
- North Carolina 9
- Florida 8
- Missouri 8
- Michigan 7
- Georgia 6
- New York 6
- California 5
- Mississippi 5
- Puerto Rico 5
- Indiana 4
- Utah 4
- Wisconsin 4
- Maine 3
- Oregon 3
- Virgin Islands 3
- Arkansas 2
- Kansas 2
- Louisiana 2
- Maryland 2
- Nebraska 2
- Ohio 2
- Oklahoma 2
- South Carolina 2
- Tennessee 2
- Washington 2
- West Virginia 2
- Alabama 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500605 | 2500605 | 2022-05-13 | Clinton | Kentucky | 21053 | 3674 | 52 |
2497347 | 2497347 | 2022-05-12 | Clinton | Kentucky | 21053 | 3674 | 52 |
2494089 | 2494089 | 2022-05-11 | Clinton | Kentucky | 21053 | 3674 | 52 |
2490831 | 2490831 | 2022-05-10 | Clinton | Kentucky | 21053 | 3674 | 52 |
2487574 | 2487574 | 2022-05-09 | Clinton | Kentucky | 21053 | 3674 | 52 |
2421925 | 2421925 | 2022-04-19 | Rabun | Georgia | 13241 | 3674 | 96 |
2418669 | 2418669 | 2022-04-18 | Rabun | Georgia | 13241 | 3674 | 96 |
2402390 | 2402390 | 2022-04-13 | Rabun | Georgia | 13241 | 3674 | 96 |
2399135 | 2399135 | 2022-04-12 | Rabun | Georgia | 13241 | 3674 | 96 |
2395880 | 2395880 | 2022-04-11 | Rabun | Georgia | 13241 | 3674 | 96 |
2394999 | 2394999 | 2022-04-10 | Zapata | Texas | 48505 | 3674 | 55 |
2391743 | 2391743 | 2022-04-09 | Zapata | Texas | 48505 | 3674 | 55 |
2388487 | 2388487 | 2022-04-08 | Zapata | Texas | 48505 | 3674 | 54 |
2385232 | 2385232 | 2022-04-07 | Zapata | Texas | 48505 | 3674 | 54 |
2355462 | 2355462 | 2022-03-29 | Quebradillas | Puerto Rico | 72115 | 3674 | |
2352209 | 2352209 | 2022-03-28 | Quebradillas | Puerto Rico | 72115 | 3674 | |
2348957 | 2348957 | 2022-03-27 | Quebradillas | Puerto Rico | 72115 | 3674 | |
2191984 | 2191984 | 2022-02-07 | Dallas | Missouri | 29059 | 3674 | 65 |
2172140 | 2172140 | 2022-02-01 | Sagadahoc | Maine | 23023 | 3674 | 25 |
2172509 | 2172509 | 2022-02-01 | Moniteau | Missouri | 29135 | 3674 | 49 |
2115176 | 2115176 | 2022-01-14 | Montague | Texas | 48337 | 3674 | 104 |
2107638 | 2107638 | 2022-01-12 | Washington | Nebraska | 31177 | 3674 | 30 |
2103642 | 2103642 | 2022-01-11 | Breckinridge | Kentucky | 21027 | 3674 | 57 |
2095217 | 2095217 | 2022-01-08 | Cabo Rojo | Puerto Rico | 72023 | 3674 | |
2077290 | 2077290 | 2022-01-03 | Pike | Illinois | 17149 | 3674 | 61 |
2063283 | 2063283 | 2021-12-29 | Windham | Vermont | 50025 | 3674 | 29 |
2058279 | 2058279 | 2021-12-28 | St. James | Louisiana | 22093 | 3674 | 70 |
2012260 | 2012260 | 2021-12-14 | Lawrence | Illinois | 17101 | 3674 | 46 |
2011241 | 2011241 | 2021-12-13 | Carbon | Utah | 49007 | 3674 | 39 |
2007990 | 2007990 | 2021-12-12 | Carbon | Utah | 49007 | 3674 | 39 |
2004739 | 2004739 | 2021-12-11 | Carbon | Utah | 49007 | 3674 | 39 |
1963972 | 1963972 | 2021-11-29 | Woodford | Kentucky | 21239 | 3674 | 31 |
1964260 | 1964260 | 2021-11-29 | Waseca | Minnesota | 27161 | 3674 | 32 |
1960717 | 1960717 | 2021-11-28 | Wayne | Kentucky | 21231 | 3674 | 68 |
1960869 | 1960869 | 2021-11-28 | Gladwin | Michigan | 26051 | 3674 | 83 |
1957466 | 1957466 | 2021-11-27 | Wayne | Kentucky | 21231 | 3674 | 68 |
1957618 | 1957618 | 2021-11-27 | Gladwin | Michigan | 26051 | 3674 | 83 |
1954215 | 1954215 | 2021-11-26 | Wayne | Kentucky | 21231 | 3674 | 68 |
1954367 | 1954367 | 2021-11-26 | Gladwin | Michigan | 26051 | 3674 | 83 |
1950964 | 1950964 | 2021-11-25 | Wayne | Kentucky | 21231 | 3674 | 68 |
1951116 | 1951116 | 2021-11-25 | Gladwin | Michigan | 26051 | 3674 | 83 |
1947865 | 1947865 | 2021-11-24 | Gladwin | Michigan | 26051 | 3674 | 83 |
1939771 | 1939771 | 2021-11-21 | St. Thomas | Virgin Islands | 78030 | 3674 | 46 |
1936521 | 1936521 | 2021-11-20 | St. Thomas | Virgin Islands | 78030 | 3674 | 46 |
1933271 | 1933271 | 2021-11-19 | St. Thomas | Virgin Islands | 78030 | 3674 | 46 |
1914781 | 1914781 | 2021-11-14 | Shelby | Illinois | 17173 | 3674 | 54 |
1911531 | 1911531 | 2021-11-13 | Shelby | Illinois | 17173 | 3674 | 54 |
1908282 | 1908282 | 2021-11-12 | Shelby | Illinois | 17173 | 3674 | 54 |
1904498 | 1904498 | 2021-11-11 | Logan | Arkansas | 5083 | 3674 | 49 |
1901888 | 1901888 | 2021-11-10 | Washington | Indiana | 18175 | 3674 | 55 |
1804280 | 1804280 | 2021-10-11 | McDonough | Illinois | 17109 | 3674 | 70 |
1806865 | 1806865 | 2021-10-11 | Uinta | Wyoming | 56041 | 3674 | 26 |
1801031 | 1801031 | 2021-10-10 | McDonough | Illinois | 17109 | 3674 | 70 |
1797782 | 1797782 | 2021-10-09 | McDonough | Illinois | 17109 | 3674 | 70 |
1794533 | 1794533 | 2021-10-08 | McDonough | Illinois | 17109 | 3674 | 70 |
1791548 | 1791548 | 2021-10-07 | Franklin | Kansas | 20059 | 3674 | 55 |
1788299 | 1788299 | 2021-10-06 | Franklin | Kansas | 20059 | 3674 | 55 |
1744574 | 1744574 | 2021-09-22 | Dimmit | Texas | 48127 | 3674 | 41 |
1710484 | 1710484 | 2021-09-12 | Mercer | Kentucky | 21167 | 3674 | 57 |
1707237 | 1707237 | 2021-09-11 | Mercer | Kentucky | 21167 | 3674 | 57 |
1703989 | 1703989 | 2021-09-10 | Mercer | Kentucky | 21167 | 3674 | 57 |
1656023 | 1656023 | 2021-08-26 | Allegany | New York | 36003 | 3674 | 88 |
1626421 | 1626421 | 2021-08-17 | Tate | Mississippi | 28137 | 3674 | 89 |
1600505 | 1600505 | 2021-08-09 | Lafayette | Missouri | 29107 | 3674 | 59 |
1597121 | 1597121 | 2021-08-08 | Alcorn | Mississippi | 28003 | 3674 | 74 |
1593872 | 1593872 | 2021-08-07 | Alcorn | Mississippi | 28003 | 3674 | 74 |
1590623 | 1590623 | 2021-08-06 | Alcorn | Mississippi | 28003 | 3674 | 74 |
1586283 | 1586283 | 2021-08-05 | Bradford | Florida | 12007 | 3674 | 58 |
1583033 | 1583033 | 2021-08-04 | Bradford | Florida | 12007 | 3674 | 58 |
1584685 | 1584685 | 2021-08-04 | Person | North Carolina | 37145 | 3674 | 73 |
1579783 | 1579783 | 2021-08-03 | Bradford | Florida | 12007 | 3674 | 58 |
1576535 | 1576535 | 2021-08-02 | Bradford | Florida | 12007 | 3674 | 58 |
1578460 | 1578460 | 2021-08-02 | Malheur | Oregon | 41045 | 3674 | 67 |
1573287 | 1573287 | 2021-08-01 | Bradford | Florida | 12007 | 3674 | 58 |
1570039 | 1570039 | 2021-07-31 | Bradford | Florida | 12007 | 3674 | 58 |
1566791 | 1566791 | 2021-07-30 | Bradford | Florida | 12007 | 3674 | 58 |
1562823 | 1562823 | 2021-07-28 | Upshur | Texas | 48459 | 3674 | 78 |
1540510 | 1540510 | 2021-07-22 | Dallas | Alabama | 1047 | 3674 | 163 |
1537206 | 1537206 | 2021-07-20 | Trempealeau | Wisconsin | 55121 | 3674 | 48 |
1529450 | 1529450 | 2021-07-18 | Jackson | North Carolina | 37099 | 3674 | 56 |
1526203 | 1526203 | 2021-07-17 | Jackson | North Carolina | 37099 | 3674 | 56 |
1522956 | 1522956 | 2021-07-16 | Jackson | North Carolina | 37099 | 3674 | 56 |
1513841 | 1513841 | 2021-07-13 | Macon | Tennessee | 47111 | 3674 | 78 |
1510595 | 1510595 | 2021-07-12 | Macon | Tennessee | 47111 | 3674 | 78 |
1495232 | 1495232 | 2021-07-08 | Lake | California | 6033 | 3674 | 63 |
1470955 | 1470955 | 2021-06-30 | Warren | New York | 36113 | 3674 | 57 |
1464128 | 1464128 | 2021-06-28 | Marion | Missouri | 29127 | 3674 | 53 |
1460883 | 1460883 | 2021-06-27 | Marion | Missouri | 29127 | 3674 | 53 |
1458477 | 1458477 | 2021-06-26 | Trujillo Alto | Puerto Rico | 72139 | 3674 | |
1411683 | 1411683 | 2021-06-12 | Greenup | Kentucky | 21089 | 3674 | 63 |
1411864 | 1411864 | 2021-06-12 | Worcester | Maryland | 24047 | 3674 | 106 |
1408438 | 1408438 | 2021-06-11 | Greenup | Kentucky | 21089 | 3674 | 63 |
1398702 | 1398702 | 2021-06-08 | Greenup | Kentucky | 21089 | 3674 | 63 |
1373303 | 1373303 | 2021-05-31 | Webster | Missouri | 29225 | 3674 | 54 |
1352406 | 1352406 | 2021-05-25 | Amador | California | 6005 | 3674 | 47 |
1352987 | 1352987 | 2021-05-25 | Putnam | Indiana | 18133 | 3674 | 60 |
1349741 | 1349741 | 2021-05-24 | Putnam | Indiana | 18133 | 3674 | 60 |
1332648 | 1332648 | 2021-05-18 | Clark | Wisconsin | 55019 | 3674 | 63 |
1308882 | 1308882 | 2021-05-11 | Ottawa | Ohio | 39123 | 3674 | 79 |
1268470 | 1268470 | 2021-04-29 | Montgomery | Illinois | 17135 | 3674 | 79 |
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);