ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where cases = 3816 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 21
- Georgia 13
- Texas 12
- Wisconsin 10
- Arkansas 8
- Indiana 6
- Tennessee 6
- Minnesota 5
- Kansas 4
- Louisiana 4
- Mississippi 4
- Maryland 3
- New York 3
- Ohio 3
- Pennsylvania 3
- Puerto Rico 3
- Virginia 3
- Wyoming 3
- Illinois 2
- Michigan 2
- Missouri 2
- North Carolina 2
- South Carolina 2
- Alabama 1
- Alaska 1
- California 1
- Colorado 1
- Idaho 1
- Iowa 1
- New Jersey 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492811 | 2492811 | 2022-05-10 | Manassas Park city | Virginia | 51685 | 3816 | 27 |
2486678 | 2486678 | 2022-05-09 | Franklin | Arkansas | 5047 | 3816 | 73 |
2483420 | 2483420 | 2022-05-08 | Franklin | Arkansas | 5047 | 3816 | 73 |
2484637 | 2484637 | 2022-05-08 | Faribault | Minnesota | 27043 | 3816 | 51 |
2480162 | 2480162 | 2022-05-07 | Franklin | Arkansas | 5047 | 3816 | 73 |
2481379 | 2481379 | 2022-05-07 | Faribault | Minnesota | 27043 | 3816 | 51 |
2478121 | 2478121 | 2022-05-06 | Faribault | Minnesota | 27043 | 3816 | 51 |
2440972 | 2440972 | 2022-04-25 | Crenshaw | Alabama | 1041 | 3816 | 99 |
2440895 | 2440895 | 2022-04-24 | Marquette | Wisconsin | 55077 | 3816 | 61 |
2437639 | 2437639 | 2022-04-23 | Marquette | Wisconsin | 55077 | 3816 | 61 |
2434383 | 2434383 | 2022-04-22 | Marquette | Wisconsin | 55077 | 3816 | 61 |
2302096 | 2302096 | 2022-03-13 | Magoffin | Kentucky | 21153 | 3816 | 41 |
2298844 | 2298844 | 2022-03-12 | Magoffin | Kentucky | 21153 | 3816 | 41 |
2295592 | 2295592 | 2022-03-11 | Magoffin | Kentucky | 21153 | 3816 | 41 |
2292340 | 2292340 | 2022-03-10 | Magoffin | Kentucky | 21153 | 3816 | 41 |
2289088 | 2289088 | 2022-03-09 | Magoffin | Kentucky | 21153 | 3816 | 41 |
2285837 | 2285837 | 2022-03-08 | Magoffin | Kentucky | 21153 | 3816 | 41 |
2282585 | 2282585 | 2022-03-07 | Magoffin | Kentucky | 21153 | 3816 | 41 |
2233854 | 2233854 | 2022-02-20 | Webster | Kentucky | 21233 | 3816 | 46 |
2230603 | 2230603 | 2022-02-19 | Webster | Kentucky | 21233 | 3816 | 46 |
2227352 | 2227352 | 2022-02-18 | Webster | Kentucky | 21233 | 3816 | 46 |
2229010 | 2229010 | 2022-02-18 | Llano | Texas | 48299 | 3816 | 91 |
2210374 | 2210374 | 2022-02-13 | Banks | Georgia | 13011 | 3816 | 78 |
2207121 | 2207121 | 2022-02-12 | Banks | Georgia | 13011 | 3816 | 78 |
2203868 | 2203868 | 2022-02-11 | Banks | Georgia | 13011 | 3816 | 78 |
2189848 | 2189848 | 2022-02-06 | Bosque | Texas | 48035 | 3816 | 63 |
2186288 | 2186288 | 2022-02-05 | Aguas Buenas | Puerto Rico | 72007 | 3816 | |
2160221 | 2160221 | 2022-01-28 | Fulton | Pennsylvania | 42057 | 3816 | 58 |
2157440 | 2157440 | 2022-01-27 | Lee | Texas | 48287 | 3816 | 56 |
2149689 | 2149689 | 2022-01-25 | Cooper | Missouri | 29053 | 3816 | 71 |
2130997 | 2130997 | 2022-01-19 | Coamo | Puerto Rico | 72043 | 3816 | |
2096619 | 2096619 | 2022-01-09 | Morgan | Georgia | 13211 | 3816 | 52 |
2093367 | 2093367 | 2022-01-08 | Morgan | Georgia | 13211 | 3816 | 52 |
2090115 | 2090115 | 2022-01-07 | Morgan | Georgia | 13211 | 3816 | 52 |
2086864 | 2086864 | 2022-01-06 | Morgan | Georgia | 13211 | 3816 | 52 |
2083612 | 2083612 | 2022-01-05 | Morgan | Georgia | 13211 | 3816 | 52 |
2077836 | 2077836 | 2022-01-03 | Somerset | Maryland | 24039 | 3816 | 58 |
2051695 | 2051695 | 2021-12-26 | Meade | Kentucky | 21163 | 3816 | 50 |
2048445 | 2048445 | 2021-12-25 | Meade | Kentucky | 21163 | 3816 | 50 |
2044264 | 2044264 | 2021-12-24 | Logan | Arkansas | 5083 | 3816 | 53 |
2045195 | 2045195 | 2021-12-24 | Meade | Kentucky | 21163 | 3816 | 50 |
2041946 | 2041946 | 2021-12-23 | Meade | Kentucky | 21163 | 3816 | 50 |
2038696 | 2038696 | 2021-12-22 | Meade | Kentucky | 21163 | 3816 | 50 |
2028269 | 2028269 | 2021-12-19 | Burke | Georgia | 13033 | 3816 | 86 |
2025018 | 2025018 | 2021-12-18 | Burke | Georgia | 13033 | 3816 | 86 |
2021767 | 2021767 | 2021-12-17 | Burke | Georgia | 13033 | 3816 | 86 |
2018838 | 2018838 | 2021-12-16 | Fulton | Indiana | 18049 | 3816 | 78 |
2009407 | 2009407 | 2021-12-13 | Harrison | Kentucky | 21097 | 3816 | 52 |
1975156 | 1975156 | 2021-12-02 | Fentress | Tennessee | 47049 | 3816 | 71 |
1967010 | 1967010 | 2021-11-30 | Cherokee | Kansas | 20021 | 3816 | 78 |
1963758 | 1963758 | 2021-11-29 | Cherokee | Kansas | 20021 | 3816 | 78 |
1878870 | 1878870 | 2021-11-03 | Tattnall | Georgia | 13267 | 3816 | 107 |
1869604 | 1869604 | 2021-10-31 | Allen | Kentucky | 21003 | 3816 | 69 |
1866355 | 1866355 | 2021-10-30 | Allen | Kentucky | 21003 | 3816 | 69 |
1863106 | 1863106 | 2021-10-29 | Allen | Kentucky | 21003 | 3816 | 69 |
1859315 | 1859315 | 2021-10-28 | Haralson | Georgia | 13143 | 3816 | 118 |
1854289 | 1854289 | 2021-10-26 | Dare | North Carolina | 37055 | 3816 | 12 |
1850266 | 1850266 | 2021-10-25 | Plaquemines | Louisiana | 22075 | 3816 | 40 |
1846430 | 1846430 | 2021-10-24 | Cassia | Idaho | 16031 | 3816 | 36 |
1837176 | 1837176 | 2021-10-21 | Letcher | Kentucky | 21133 | 3816 | 65 |
1834080 | 1834080 | 2021-10-20 | Queen Anne's | Maryland | 24035 | 3816 | 70 |
1834325 | 1834325 | 2021-10-20 | Newton | Mississippi | 28101 | 3816 | 79 |
1831076 | 1831076 | 2021-10-19 | Newton | Mississippi | 28101 | 3816 | 79 |
1832591 | 1832591 | 2021-10-19 | Halifax | Virginia | 51083 | 3816 | 101 |
1810861 | 1810861 | 2021-10-13 | Jennings | Indiana | 18079 | 3816 | 61 |
1804777 | 1804777 | 2021-10-11 | Pointe Coupee | Louisiana | 22077 | 3816 | 82 |
1746177 | 1746177 | 2021-09-23 | Grant | Kentucky | 21081 | 3816 | 29 |
1746520 | 1746520 | 2021-09-23 | Pine | Minnesota | 27115 | 3816 | 26 |
1747212 | 1747212 | 2021-09-23 | Coshocton | Ohio | 39031 | 3816 | 66 |
1708017 | 1708017 | 2021-09-11 | Greene | New York | 36039 | 3816 | 82 |
1692504 | 1692504 | 2021-09-06 | Overton | Tennessee | 47133 | 3816 | 63 |
1689255 | 1689255 | 2021-09-05 | Overton | Tennessee | 47133 | 3816 | 63 |
1686005 | 1686005 | 2021-09-04 | Overton | Tennessee | 47133 | 3816 | 63 |
1682754 | 1682754 | 2021-09-03 | Overton | Tennessee | 47133 | 3816 | 63 |
1657542 | 1657542 | 2021-08-27 | Carroll | Arkansas | 5015 | 3816 | 56 |
1625681 | 1625681 | 2021-08-17 | Jefferson | Indiana | 18077 | 3816 | 88 |
1608881 | 1608881 | 2021-08-12 | Unknown | Arkansas | 3816 | 0 | |
1591106 | 1591106 | 2021-08-06 | Warren | New York | 36113 | 3816 | 64 |
1582508 | 1582508 | 2021-08-03 | Tazewell | Virginia | 51185 | 3816 | 76 |
1575363 | 1575363 | 2021-08-01 | Trujillo Alto | Puerto Rico | 72139 | 3816 | |
1560147 | 1560147 | 2021-07-28 | St. Francis | Arkansas | 5123 | 3816 | 46 |
1533416 | 1533416 | 2021-07-19 | Cooke | Texas | 48097 | 3816 | 72 |
1530169 | 1530169 | 2021-07-18 | Cooke | Texas | 48097 | 3816 | 72 |
1526922 | 1526922 | 2021-07-17 | Cooke | Texas | 48097 | 3816 | 72 |
1511374 | 1511374 | 2021-07-13 | Baxter | Arkansas | 5005 | 3816 | 110 |
1508011 | 1508011 | 2021-07-11 | Teton | Wyoming | 56039 | 3816 | 11 |
1504765 | 1504765 | 2021-07-10 | Teton | Wyoming | 56039 | 3816 | 11 |
1501519 | 1501519 | 2021-07-09 | Teton | Wyoming | 56039 | 3816 | 11 |
1497334 | 1497334 | 2021-07-08 | McKean | Pennsylvania | 42083 | 3816 | 72 |
1430061 | 1430061 | 2021-06-17 | Oneida | Wisconsin | 55085 | 3816 | 77 |
1426816 | 1426816 | 2021-06-16 | Oneida | Wisconsin | 55085 | 3816 | 77 |
1423570 | 1423570 | 2021-06-15 | Oneida | Wisconsin | 55085 | 3816 | 77 |
1414734 | 1414734 | 2021-06-13 | Lee | Iowa | 19111 | 3816 | 56 |
1417078 | 1417078 | 2021-06-13 | Oneida | Wisconsin | 55085 | 3816 | 77 |
1413832 | 1413832 | 2021-06-12 | Oneida | Wisconsin | 55085 | 3816 | 77 |
1410587 | 1410587 | 2021-06-11 | Oneida | Wisconsin | 55085 | 3816 | 77 |
1404096 | 1404096 | 2021-06-09 | Oneida | Wisconsin | 55085 | 3816 | 77 |
1341085 | 1341085 | 2021-05-21 | Cortland | New York | 36023 | 3816 | 60 |
1337417 | 1337417 | 2021-05-20 | Hancock | Mississippi | 28045 | 3816 | 87 |
1302374 | 1302374 | 2021-05-09 | Logan | Ohio | 39091 | 3816 | 76 |
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);