ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
225 rows where cases = 2712 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 33
- Mississippi 30
- Iowa 28
- Texas 17
- Virginia 13
- Kentucky 12
- Minnesota 10
- Ohio 9
- Tennessee 9
- Arkansas 8
- Missouri 8
- Georgia 7
- North Carolina 7
- Wisconsin 7
- Indiana 6
- Kansas 5
- South Dakota 5
- Colorado 4
- Idaho 4
- Michigan 4
- Alabama 3
- Alaska 3
- Illinois 3
- Nebraska 3
- New York 3
- Utah 3
- West Virginia 3
- Florida 2
- Louisiana 2
- Montana 2
- Puerto Rico 2
- Delaware 1
- Massachusetts 1
- Wyoming 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2488938 | 2488938 | 2022-05-09 | Penuelas | Puerto Rico | 72111 | 2712 | |
2416269 | 2416269 | 2022-04-17 | Koochiching | Minnesota | 27071 | 2712 | 37 |
2413013 | 2413013 | 2022-04-16 | Koochiching | Minnesota | 27071 | 2712 | 37 |
2409757 | 2409757 | 2022-04-15 | Koochiching | Minnesota | 27071 | 2712 | 37 |
2405734 | 2405734 | 2022-04-14 | Teton | Idaho | 16081 | 2712 | 9 |
2399506 | 2399506 | 2022-04-12 | Shelby | Iowa | 19165 | 2712 | 50 |
2396250 | 2396250 | 2022-04-11 | Shelby | Iowa | 19165 | 2712 | 50 |
2392995 | 2392995 | 2022-04-10 | Shelby | Iowa | 19165 | 2712 | 50 |
2389739 | 2389739 | 2022-04-09 | Shelby | Iowa | 19165 | 2712 | 50 |
2386483 | 2386483 | 2022-04-08 | Shelby | Iowa | 19165 | 2712 | 50 |
2383229 | 2383229 | 2022-04-07 | Shelby | Iowa | 19165 | 2712 | 50 |
2379974 | 2379974 | 2022-04-06 | Shelby | Iowa | 19165 | 2712 | 50 |
2324388 | 2324388 | 2022-03-20 | Shoshone | Idaho | 16079 | 2712 | 75 |
2321134 | 2321134 | 2022-03-19 | Shoshone | Idaho | 16079 | 2712 | 75 |
2317880 | 2317880 | 2022-03-18 | Shoshone | Idaho | 16079 | 2712 | 75 |
2308408 | 2308408 | 2022-03-15 | Union | Iowa | 19175 | 2712 | 49 |
2305157 | 2305157 | 2022-03-14 | Union | Iowa | 19175 | 2712 | 49 |
2301905 | 2301905 | 2022-03-13 | Union | Iowa | 19175 | 2712 | 49 |
2298653 | 2298653 | 2022-03-12 | Union | Iowa | 19175 | 2712 | 49 |
2295401 | 2295401 | 2022-03-11 | Union | Iowa | 19175 | 2712 | 49 |
2292149 | 2292149 | 2022-03-10 | Union | Iowa | 19175 | 2712 | 49 |
2288897 | 2288897 | 2022-03-09 | Union | Iowa | 19175 | 2712 | 49 |
2280235 | 2280235 | 2022-03-06 | Perquimans | North Carolina | 37143 | 2712 | 17 |
2276982 | 2276982 | 2022-03-05 | Perquimans | North Carolina | 37143 | 2712 | 17 |
2273729 | 2273729 | 2022-03-04 | Perquimans | North Carolina | 37143 | 2712 | 17 |
2243149 | 2243149 | 2022-02-23 | Marshall | Illinois | 17123 | 2712 | 32 |
2240094 | 2240094 | 2022-02-22 | Lyon | Iowa | 19119 | 2712 | 48 |
2236843 | 2236843 | 2022-02-21 | Lyon | Iowa | 19119 | 2712 | 48 |
2233592 | 2233592 | 2022-02-20 | Lyon | Iowa | 19119 | 2712 | 48 |
2233743 | 2233743 | 2022-02-20 | Bath | Kentucky | 21011 | 2712 | 37 |
2230341 | 2230341 | 2022-02-19 | Lyon | Iowa | 19119 | 2712 | 48 |
2230492 | 2230492 | 2022-02-19 | Bath | Kentucky | 21011 | 2712 | 37 |
2227090 | 2227090 | 2022-02-18 | Lyon | Iowa | 19119 | 2712 | 48 |
2227241 | 2227241 | 2022-02-18 | Bath | Kentucky | 21011 | 2712 | 37 |
2223839 | 2223839 | 2022-02-17 | Lyon | Iowa | 19119 | 2712 | 48 |
2220588 | 2220588 | 2022-02-16 | Lyon | Iowa | 19119 | 2712 | 48 |
2206844 | 2206844 | 2022-02-12 | Chicot | Arkansas | 5017 | 2712 | 52 |
2168800 | 2168800 | 2022-01-31 | Todd | Kentucky | 21219 | 2712 | 39 |
2167332 | 2167332 | 2022-01-30 | Morgan | Utah | 49029 | 2712 | 13 |
2164077 | 2164077 | 2022-01-29 | Morgan | Utah | 49029 | 2712 | 13 |
2160822 | 2160822 | 2022-01-28 | Morgan | Utah | 49029 | 2712 | 13 |
2119165 | 2119165 | 2022-01-16 | Las Animas | Colorado | 8071 | 2712 | 35 |
2115913 | 2115913 | 2022-01-15 | Las Animas | Colorado | 8071 | 2712 | 35 |
2112662 | 2112662 | 2022-01-14 | Las Animas | Colorado | 8071 | 2712 | 35 |
2103739 | 2103739 | 2022-01-11 | Trigg | Kentucky | 21221 | 2712 | 32 |
2103865 | 2103865 | 2022-01-11 | Nantucket | Massachusetts | 25019 | 2712 | 0 |
2103910 | 2103910 | 2022-01-11 | Kalkaska | Michigan | 26079 | 2712 | 48 |
2105606 | 2105606 | 2022-01-11 | Grayson | Virginia | 51077 | 2712 | 64 |
2100659 | 2100659 | 2022-01-10 | Kalkaska | Michigan | 26079 | 2712 | 48 |
2063630 | 2063630 | 2021-12-30 | Crenshaw | Alabama | 1041 | 2712 | 79 |
2027941 | 2027941 | 2021-12-19 | Kodiak Island Borough | Alaska | 2150 | 2712 | 10 |
2024690 | 2024690 | 2021-12-18 | Kodiak Island Borough | Alaska | 2150 | 2712 | 10 |
2021439 | 2021439 | 2021-12-17 | Kodiak Island Borough | Alaska | 2150 | 2712 | 10 |
1996253 | 1996253 | 2021-12-09 | Atchison | Kansas | 20005 | 2712 | 26 |
1993002 | 1993002 | 2021-12-08 | Atchison | Kansas | 20005 | 2712 | 26 |
1989006 | 1989006 | 2021-12-07 | Madison | Arkansas | 5087 | 2712 | 40 |
1961041 | 1961041 | 2021-11-28 | Holmes | Mississippi | 28051 | 2712 | 89 |
1957790 | 1957790 | 2021-11-27 | Holmes | Mississippi | 28051 | 2712 | 89 |
1954539 | 1954539 | 2021-11-26 | Holmes | Mississippi | 28051 | 2712 | 89 |
1951288 | 1951288 | 2021-11-25 | Holmes | Mississippi | 28051 | 2712 | 89 |
1948037 | 1948037 | 2021-11-24 | Holmes | Mississippi | 28051 | 2712 | 89 |
1928598 | 1928598 | 2021-11-18 | Benton | Missouri | 29015 | 2712 | 70 |
1905133 | 1905133 | 2021-11-11 | Vermillion | Indiana | 18165 | 2712 | 56 |
1905411 | 1905411 | 2021-11-11 | Lawrence | Kentucky | 21127 | 2712 | 42 |
1902161 | 1902161 | 2021-11-10 | Lawrence | Kentucky | 21127 | 2712 | 42 |
1895308 | 1895308 | 2021-11-08 | Carroll | Indiana | 18015 | 2712 | 39 |
1875220 | 1875220 | 2021-11-02 | Clay | Arkansas | 5021 | 2712 | 71 |
1807503 | 1807503 | 2021-10-12 | Hancock | Illinois | 17067 | 2712 | 45 |
1805024 | 1805024 | 2021-10-11 | Wabasha | Minnesota | 27157 | 2712 | 5 |
1764122 | 1764122 | 2021-09-28 | Jackson | Texas | 48239 | 2712 | 47 |
1757375 | 1757375 | 2021-09-26 | Hughes | South Dakota | 46065 | 2712 | 43 |
1754127 | 1754127 | 2021-09-25 | Hughes | South Dakota | 46065 | 2712 | 43 |
1750879 | 1750879 | 2021-09-24 | Hughes | South Dakota | 46065 | 2712 | 43 |
1738386 | 1738386 | 2021-09-20 | Louisa | Virginia | 51109 | 2712 | 40 |
1723152 | 1723152 | 2021-09-16 | Orange | Indiana | 18117 | 2712 | 62 |
1708249 | 1708249 | 2021-09-11 | Hocking | Ohio | 39073 | 2712 | 66 |
1702337 | 1702337 | 2021-09-09 | DeWitt | Texas | 48123 | 2712 | 66 |
1699088 | 1699088 | 2021-09-08 | DeWitt | Texas | 48123 | 2712 | 66 |
1695840 | 1695840 | 2021-09-07 | DeWitt | Texas | 48123 | 2712 | 66 |
1692592 | 1692592 | 2021-09-06 | DeWitt | Texas | 48123 | 2712 | 65 |
1689343 | 1689343 | 2021-09-05 | DeWitt | Texas | 48123 | 2712 | 65 |
1686093 | 1686093 | 2021-09-04 | DeWitt | Texas | 48123 | 2712 | 65 |
1680056 | 1680056 | 2021-09-02 | Upshur | West Virginia | 54097 | 2712 | 42 |
1662278 | 1662278 | 2021-08-28 | Texas | Missouri | 29215 | 2712 | 32 |
1656939 | 1656939 | 2021-08-26 | Lamb | Texas | 48279 | 2712 | 86 |
1647800 | 1647800 | 2021-08-24 | Clark | Arkansas | 5019 | 2712 | 43 |
1644552 | 1644552 | 2021-08-23 | Clark | Arkansas | 5019 | 2712 | 43 |
1647408 | 1647408 | 2021-08-23 | Gloucester | Virginia | 51073 | 2712 | 53 |
1624062 | 1624062 | 2021-08-16 | Juncos | Puerto Rico | 72077 | 2712 | |
1595826 | 1595826 | 2021-08-08 | Cleburne | Arkansas | 5023 | 2712 | 74 |
1584389 | 1584389 | 2021-08-04 | Cass | Nebraska | 31025 | 2712 | 17 |
1581140 | 1581140 | 2021-08-03 | Cass | Nebraska | 31025 | 2712 | 17 |
1557525 | 1557525 | 2021-07-27 | Boone | Iowa | 19015 | 2712 | 34 |
1554278 | 1554278 | 2021-07-26 | Boone | Iowa | 19015 | 2712 | 34 |
1556031 | 1556031 | 2021-07-26 | Grainger | Tennessee | 47057 | 2712 | 50 |
1551031 | 1551031 | 2021-07-25 | Boone | Iowa | 19015 | 2712 | 34 |
1547784 | 1547784 | 2021-07-24 | Boone | Iowa | 19015 | 2712 | 34 |
1544537 | 1544537 | 2021-07-23 | Boone | Iowa | 19015 | 2712 | 34 |
1541289 | 1541289 | 2021-07-22 | Boone | Iowa | 19015 | 2712 | 34 |
1538042 | 1538042 | 2021-07-21 | Boone | Iowa | 19015 | 2712 | 34 |
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);