ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
168 rows where cases = 2810 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 23
- Tennessee 18
- Arkansas 12
- Virginia 10
- Kansas 8
- Oklahoma 8
- Missouri 7
- North Carolina 7
- Puerto Rico 7
- Pennsylvania 6
- Colorado 5
- Louisiana 5
- Alabama 4
- Mississippi 4
- Utah 4
- Wisconsin 4
- Florida 3
- Georgia 3
- Illinois 3
- Indiana 3
- Kentucky 3
- Minnesota 3
- Idaho 2
- Michigan 2
- North Dakota 2
- Ohio 2
- South Dakota 2
- Iowa 1
- Maine 1
- Massachusetts 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2428226 | 2428226 | 2022-04-21 | Rio Grande | Colorado | 8105 | 2810 | 46 |
2414009 | 2414009 | 2022-04-16 | Comerio | Puerto Rico | 72045 | 2810 | |
2410753 | 2410753 | 2022-04-15 | Comerio | Puerto Rico | 72045 | 2810 | |
2407497 | 2407497 | 2022-04-14 | Comerio | Puerto Rico | 72045 | 2810 | |
2382641 | 2382641 | 2022-04-07 | Park | Colorado | 8093 | 2810 | 20 |
2339670 | 2339670 | 2022-03-24 | Ward | Texas | 48475 | 2810 | 43 |
2336416 | 2336416 | 2022-03-23 | Ward | Texas | 48475 | 2810 | 43 |
2333162 | 2333162 | 2022-03-22 | Ward | Texas | 48475 | 2810 | 43 |
2329909 | 2329909 | 2022-03-21 | Ward | Texas | 48475 | 2810 | 43 |
2324790 | 2324790 | 2022-03-20 | Wilson | Kansas | 20205 | 2810 | 42 |
2326657 | 2326657 | 2022-03-20 | Ward | Texas | 48475 | 2810 | 43 |
2321536 | 2321536 | 2022-03-19 | Wilson | Kansas | 20205 | 2810 | 42 |
2323404 | 2323404 | 2022-03-19 | Ward | Texas | 48475 | 2810 | 43 |
2318282 | 2318282 | 2022-03-18 | Wilson | Kansas | 20205 | 2810 | 42 |
2302020 | 2302020 | 2022-03-13 | Wilson | Kansas | 20205 | 2810 | 41 |
2298768 | 2298768 | 2022-03-12 | Wilson | Kansas | 20205 | 2810 | 41 |
2295516 | 2295516 | 2022-03-11 | Wilson | Kansas | 20205 | 2810 | 41 |
2262945 | 2262945 | 2022-03-01 | Linn | Kansas | 20107 | 2810 | 24 |
2259694 | 2259694 | 2022-02-28 | Linn | Kansas | 20107 | 2810 | 24 |
2251379 | 2251379 | 2022-02-25 | Orocovis | Puerto Rico | 72107 | 2810 | |
2248128 | 2248128 | 2022-02-24 | Orocovis | Puerto Rico | 72107 | 2810 | |
2244877 | 2244877 | 2022-02-23 | Orocovis | Puerto Rico | 72107 | 2810 | |
2193353 | 2193353 | 2022-02-07 | Morgan | Utah | 49029 | 2810 | 13 |
2190097 | 2190097 | 2022-02-06 | Juab | Utah | 49023 | 2810 | 22 |
2186844 | 2186844 | 2022-02-05 | Juab | Utah | 49023 | 2810 | 22 |
2183591 | 2183591 | 2022-02-04 | Juab | Utah | 49023 | 2810 | 22 |
2176195 | 2176195 | 2022-02-02 | Washington | North Carolina | 37187 | 2810 | 42 |
2143651 | 2143651 | 2022-01-23 | Swain | North Carolina | 37173 | 2810 | 33 |
2140396 | 2140396 | 2022-01-22 | Swain | North Carolina | 37173 | 2810 | 33 |
2137140 | 2137140 | 2022-01-21 | Swain | North Carolina | 37173 | 2810 | 33 |
2106575 | 2106575 | 2022-01-12 | Washington | Illinois | 17189 | 2810 | 37 |
2102245 | 2102245 | 2022-01-10 | Wilbarger | Texas | 48487 | 2810 | 76 |
2087135 | 2087135 | 2022-01-06 | Parke | Indiana | 18121 | 2810 | 39 |
2089311 | 2089311 | 2022-01-06 | Bristol city | Virginia | 51520 | 2810 | 58 |
2081068 | 2081068 | 2022-01-04 | Washington | Maine | 23029 | 2810 | 40 |
2066058 | 2066058 | 2021-12-30 | Lee | South Carolina | 45061 | 2810 | 82 |
2054115 | 2054115 | 2021-12-27 | Chaffee | Colorado | 8015 | 2810 | 38 |
2030569 | 2030569 | 2021-12-19 | Freestone | Texas | 48161 | 2810 | 73 |
2030807 | 2030807 | 2021-12-19 | Buckingham | Virginia | 51029 | 2810 | 41 |
2027318 | 2027318 | 2021-12-18 | Freestone | Texas | 48161 | 2810 | 73 |
2027556 | 2027556 | 2021-12-18 | Buckingham | Virginia | 51029 | 2810 | 41 |
2024305 | 2024305 | 2021-12-17 | Buckingham | Virginia | 51029 | 2810 | 41 |
2008966 | 2008966 | 2021-12-13 | Carroll | Illinois | 17015 | 2810 | 42 |
1966237 | 1966237 | 2021-11-30 | Franklin | Arkansas | 5047 | 2810 | 55 |
1964896 | 1964896 | 2021-11-29 | Richland | North Dakota | 38077 | 2810 | 21 |
1961644 | 1961644 | 2021-11-28 | Richland | North Dakota | 38077 | 2810 | 21 |
1945541 | 1945541 | 2021-11-23 | Marshall | Oklahoma | 40095 | 2810 | 28 |
1942290 | 1942290 | 2021-11-22 | Marshall | Oklahoma | 40095 | 2810 | 28 |
1939040 | 1939040 | 2021-11-21 | Marshall | Oklahoma | 40095 | 2810 | 28 |
1935790 | 1935790 | 2021-11-20 | Marshall | Oklahoma | 40095 | 2810 | 28 |
1932540 | 1932540 | 2021-11-19 | Marshall | Oklahoma | 40095 | 2810 | 28 |
1929289 | 1929289 | 2021-11-18 | Marshall | Oklahoma | 40095 | 2810 | 28 |
1926039 | 1926039 | 2021-11-17 | Marshall | Oklahoma | 40095 | 2810 | 28 |
1905869 | 1905869 | 2021-11-11 | Cooper | Missouri | 29053 | 2810 | 34 |
1902620 | 1902620 | 2021-11-10 | Cooper | Missouri | 29053 | 2810 | 34 |
1904307 | 1904307 | 2021-11-10 | Sawyer | Wisconsin | 55113 | 2810 | 36 |
1881863 | 1881863 | 2021-11-04 | Elbert | Colorado | 8039 | 2810 | 23 |
1883559 | 1883559 | 2021-11-04 | Madison | North Carolina | 37115 | 2810 | 60 |
1881502 | 1881502 | 2021-11-03 | Adams | Wisconsin | 55001 | 2810 | 33 |
1828312 | 1828312 | 2021-10-18 | Hertford | North Carolina | 37091 | 2810 | 70 |
1807957 | 1807957 | 2021-10-12 | Morgan | Kentucky | 21175 | 2810 | 6 |
1800238 | 1800238 | 2021-10-09 | Lewis | West Virginia | 54041 | 2810 | 42 |
1774939 | 1774939 | 2021-10-02 | Blaine | Idaho | 16013 | 2810 | 22 |
1765939 | 1765939 | 2021-09-29 | Otsego | Michigan | 26137 | 2810 | 47 |
1757486 | 1757486 | 2021-09-26 | Sequatchie | Tennessee | 47153 | 2810 | 30 |
1754238 | 1754238 | 2021-09-25 | Sequatchie | Tennessee | 47153 | 2810 | 30 |
1750990 | 1750990 | 2021-09-24 | Sequatchie | Tennessee | 47153 | 2810 | 30 |
1742477 | 1742477 | 2021-09-22 | Minidoka | Idaho | 16067 | 2810 | 39 |
1741459 | 1741459 | 2021-09-21 | Robertson | Texas | 48395 | 2810 | 60 |
1725427 | 1725427 | 2021-09-16 | Salem city | Virginia | 51775 | 2810 | 55 |
1699953 | 1699953 | 2021-09-09 | Routt | Colorado | 8107 | 2810 | 21 |
1683520 | 1683520 | 2021-09-04 | Ashley | Arkansas | 5003 | 2810 | 39 |
1668400 | 1668400 | 2021-08-30 | Franklin | Massachusetts | 25011 | 2810 | 115 |
1650927 | 1650927 | 2021-08-24 | Uinta | Wyoming | 56041 | 2810 | 14 |
1647250 | 1647250 | 2021-08-23 | Reeves | Texas | 48389 | 2810 | 45 |
1644001 | 1644001 | 2021-08-22 | Reeves | Texas | 48389 | 2810 | 45 |
1628631 | 1628631 | 2021-08-18 | Fannin | Georgia | 13111 | 2810 | 75 |
1624871 | 1624871 | 2021-08-16 | Jackson | Wisconsin | 55053 | 2810 | 29 |
1602949 | 1602949 | 2021-08-10 | LaGrange | Indiana | 18087 | 2810 | 75 |
1604298 | 1604298 | 2021-08-10 | Henry | Ohio | 39069 | 2810 | 67 |
1582024 | 1582024 | 2021-08-03 | Haywood | Tennessee | 47075 | 2810 | 62 |
1533442 | 1533442 | 2021-07-19 | Fayette | Texas | 48149 | 2810 | 69 |
1530195 | 1530195 | 2021-07-18 | Fayette | Texas | 48149 | 2810 | 69 |
1526948 | 1526948 | 2021-07-17 | Fayette | Texas | 48149 | 2810 | 69 |
1509622 | 1509622 | 2021-07-12 | Washington | Missouri | 29221 | 2810 | 52 |
1486788 | 1486788 | 2021-07-05 | Audrain | Missouri | 29007 | 2810 | 58 |
1487895 | 1487895 | 2021-07-05 | Smith | Tennessee | 47159 | 2810 | 40 |
1483542 | 1483542 | 2021-07-04 | Audrain | Missouri | 29007 | 2810 | 58 |
1484648 | 1484648 | 2021-07-04 | Smith | Tennessee | 47159 | 2810 | 40 |
1481402 | 1481402 | 2021-07-03 | Smith | Tennessee | 47159 | 2810 | 40 |
1478155 | 1478155 | 2021-07-02 | Smith | Tennessee | 47159 | 2810 | 40 |
1474909 | 1474909 | 2021-07-01 | Smith | Tennessee | 47159 | 2810 | 40 |
1471663 | 1471663 | 2021-06-30 | Smith | Tennessee | 47159 | 2810 | 40 |
1468418 | 1468418 | 2021-06-29 | Smith | Tennessee | 47159 | 2810 | 40 |
1431980 | 1431980 | 2021-06-18 | Lewis | New York | 36049 | 2810 | 36 |
1391232 | 1391232 | 2021-06-06 | Winston | Alabama | 1133 | 2810 | 73 |
1387987 | 1387987 | 2021-06-05 | Winston | Alabama | 1133 | 2810 | 73 |
1384742 | 1384742 | 2021-06-04 | Winston | Alabama | 1133 | 2810 | 73 |
1361478 | 1361478 | 2021-05-27 | Limestone | Texas | 48293 | 2810 | 80 |
1353553 | 1353553 | 2021-05-25 | Cass | Minnesota | 27021 | 2810 | 32 |
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);