ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
377 rows where cases = 1212 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 33
- Kentucky 25
- Texas 25
- Puerto Rico 23
- Georgia 18
- Virginia 17
- Mississippi 16
- Iowa 13
- South Dakota 13
- North Carolina 12
- Florida 11
- Missouri 11
- Michigan 10
- Colorado 9
- Kansas 9
- Louisiana 8
- Pennsylvania 8
- Wyoming 8
- Arkansas 7
- Idaho 7
- Vermont 7
- Montana 6
- North Dakota 6
- Tennessee 6
- Utah 6
- Wisconsin 6
- Nebraska 5
- West Virginia 5
- California 4
- Illinois 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461529 | 2461529 | 2022-05-01 | Fulton | Kentucky | 21075 | 1212 | 29 |
2458273 | 2458273 | 2022-04-30 | Fulton | Kentucky | 21075 | 1212 | 29 |
2455017 | 2455017 | 2022-04-29 | Fulton | Kentucky | 21075 | 1212 | 29 |
2451761 | 2451761 | 2022-04-28 | Fulton | Kentucky | 21075 | 1212 | 29 |
2448505 | 2448505 | 2022-04-27 | Fulton | Kentucky | 21075 | 1212 | 29 |
2445249 | 2445249 | 2022-04-26 | Fulton | Kentucky | 21075 | 1212 | 29 |
2441993 | 2441993 | 2022-04-25 | Fulton | Kentucky | 21075 | 1212 | 29 |
2377208 | 2377208 | 2022-04-05 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2373956 | 2373956 | 2022-04-04 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2370703 | 2370703 | 2022-04-03 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2367450 | 2367450 | 2022-04-02 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2364197 | 2364197 | 2022-04-01 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2360943 | 2360943 | 2022-03-31 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2357689 | 2357689 | 2022-03-30 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2354436 | 2354436 | 2022-03-29 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2351184 | 2351184 | 2022-03-28 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2347931 | 2347931 | 2022-03-27 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2344678 | 2344678 | 2022-03-26 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2341425 | 2341425 | 2022-03-25 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2338172 | 2338172 | 2022-03-24 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2334918 | 2334918 | 2022-03-23 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2331664 | 2331664 | 2022-03-22 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2328412 | 2328412 | 2022-03-21 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2325159 | 2325159 | 2022-03-20 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2321905 | 2321905 | 2022-03-19 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2318651 | 2318651 | 2022-03-18 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2315398 | 2315398 | 2022-03-17 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2312145 | 2312145 | 2022-03-16 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2308892 | 2308892 | 2022-03-15 | Lincoln | Minnesota | 27081 | 1212 | 6 |
2281173 | 2281173 | 2022-03-06 | Essex | Vermont | 50009 | 1212 | 3 |
2277920 | 2277920 | 2022-03-05 | Essex | Vermont | 50009 | 1212 | 3 |
2274667 | 2274667 | 2022-03-04 | Essex | Vermont | 50009 | 1212 | 3 |
2270217 | 2270217 | 2022-03-03 | Jefferson | Nebraska | 31095 | 1212 | 6 |
2271414 | 2271414 | 2022-03-03 | Essex | Vermont | 50009 | 1212 | 3 |
2268162 | 2268162 | 2022-03-02 | Essex | Vermont | 50009 | 1212 | 3 |
2268207 | 2268207 | 2022-03-02 | Cumberland | Virginia | 51049 | 1212 | 23 |
2221350 | 2221350 | 2022-02-16 | Broadwater | Montana | 30007 | 1212 | 18 |
2197970 | 2197970 | 2022-02-09 | Ballard | Kentucky | 21007 | 1212 | 27 |
2168292 | 2168292 | 2022-01-31 | Alexander | Illinois | 17003 | 1212 | 13 |
2150667 | 2150667 | 2022-01-25 | Kingsbury | South Dakota | 46077 | 1212 | 20 |
2138304 | 2138304 | 2022-01-21 | Wirt | West Virginia | 54105 | 1212 | 19 |
2132865 | 2132865 | 2022-01-20 | Phillips | Kansas | 20147 | 1212 | 28 |
2129612 | 2129612 | 2022-01-19 | Phillips | Kansas | 20147 | 1212 | 28 |
2103997 | 2103997 | 2022-01-11 | Mahnomen | Minnesota | 27087 | 1212 | 17 |
2089309 | 2089309 | 2022-01-06 | Bland | Virginia | 51021 | 1212 | 18 |
2075854 | 2075854 | 2022-01-02 | Hamlin | South Dakota | 46057 | 1212 | 40 |
2072603 | 2072603 | 2022-01-01 | Hamlin | South Dakota | 46057 | 1212 | 40 |
2069352 | 2069352 | 2021-12-31 | Hamlin | South Dakota | 46057 | 1212 | 40 |
2066101 | 2066101 | 2021-12-30 | Hamlin | South Dakota | 46057 | 1212 | 40 |
2059931 | 2059931 | 2021-12-28 | Refugio | Texas | 48391 | 1212 | 31 |
1978193 | 1978193 | 2021-12-03 | Barceloneta | Puerto Rico | 72017 | 1212 | |
1971077 | 1971077 | 2021-12-01 | Knox | Nebraska | 31107 | 1212 | 13 |
1966888 | 1966888 | 2021-11-30 | Union | Indiana | 18161 | 1212 | 17 |
1961138 | 1961138 | 2021-11-28 | Harrison | Missouri | 29081 | 1212 | 21 |
1957887 | 1957887 | 2021-11-27 | Harrison | Missouri | 29081 | 1212 | 21 |
1954636 | 1954636 | 2021-11-26 | Harrison | Missouri | 29081 | 1212 | 21 |
1951385 | 1951385 | 2021-11-25 | Harrison | Missouri | 29081 | 1212 | 21 |
1948134 | 1948134 | 2021-11-24 | Harrison | Missouri | 29081 | 1212 | 21 |
1901398 | 1901398 | 2021-11-10 | San Miguel | Colorado | 8113 | 1212 | 5 |
1881583 | 1881583 | 2021-11-03 | Johnson | Wyoming | 56019 | 1212 | 16 |
1836598 | 1836598 | 2021-10-21 | Miller | Georgia | 13201 | 1212 | 22 |
1833349 | 1833349 | 2021-10-20 | Miller | Georgia | 13201 | 1212 | 21 |
1830100 | 1830100 | 2021-10-19 | Miller | Georgia | 13201 | 1212 | 21 |
1826851 | 1826851 | 2021-10-18 | Miller | Georgia | 13201 | 1212 | 21 |
1827291 | 1827291 | 2021-10-18 | Grant | Kansas | 20067 | 1212 | 27 |
1827978 | 1827978 | 2021-10-18 | Blaine | Montana | 30005 | 1212 | 24 |
1828122 | 1828122 | 2021-10-18 | Wayne | Nebraska | 31179 | 1212 | 8 |
1781167 | 1781167 | 2021-10-04 | Park | Colorado | 8093 | 1212 | 7 |
1778967 | 1778967 | 2021-10-03 | Clearwater | Minnesota | 27029 | 1212 | 18 |
1775717 | 1775717 | 2021-10-02 | Clearwater | Minnesota | 27029 | 1212 | 18 |
1772467 | 1772467 | 2021-10-01 | Clearwater | Minnesota | 27029 | 1212 | 18 |
1769474 | 1769474 | 2021-09-30 | St. Clair | Missouri | 29185 | 1212 | 14 |
1767769 | 1767769 | 2021-09-29 | Roane | West Virginia | 54087 | 1212 | 14 |
1751665 | 1751665 | 2021-09-25 | Greene | Alabama | 1063 | 1212 | 43 |
1754010 | 1754010 | 2021-09-25 | Luquillo | Puerto Rico | 72089 | 1212 | |
1750762 | 1750762 | 2021-09-24 | Luquillo | Puerto Rico | 72089 | 1212 | |
1747143 | 1747143 | 2021-09-23 | Benson | North Dakota | 38005 | 1212 | 20 |
1721799 | 1721799 | 2021-09-15 | Castro | Texas | 48069 | 1212 | 33 |
1718551 | 1718551 | 2021-09-14 | Castro | Texas | 48069 | 1212 | 33 |
1709883 | 1709883 | 2021-09-12 | Macon | Georgia | 13193 | 1212 | 38 |
1706636 | 1706636 | 2021-09-11 | Macon | Georgia | 13193 | 1212 | 38 |
1708042 | 1708042 | 2021-09-11 | Schuyler | New York | 36097 | 1212 | 16 |
1703388 | 1703388 | 2021-09-10 | Macon | Georgia | 13193 | 1212 | 38 |
1701798 | 1701798 | 2021-09-09 | Vinton | Ohio | 39163 | 1212 | 17 |
1691070 | 1691070 | 2021-09-06 | Red River | Louisiana | 22081 | 1212 | 42 |
1687820 | 1687820 | 2021-09-05 | Red River | Louisiana | 22081 | 1212 | 42 |
1684570 | 1684570 | 2021-09-04 | Red River | Louisiana | 22081 | 1212 | 42 |
1680326 | 1680326 | 2021-09-03 | Prairie | Arkansas | 5117 | 1212 | 27 |
1681319 | 1681319 | 2021-09-03 | Red River | Louisiana | 22081 | 1212 | 42 |
1654640 | 1654640 | 2021-08-26 | Heard | Georgia | 13149 | 1212 | 23 |
1624665 | 1624665 | 2021-08-16 | Galax city | Virginia | 51640 | 1212 | 53 |
1600145 | 1600145 | 2021-08-09 | Knox | Maine | 23013 | 1212 | 7 |
1596897 | 1596897 | 2021-08-08 | Knox | Maine | 23013 | 1212 | 7 |
1593648 | 1593648 | 2021-08-07 | Knox | Maine | 23013 | 1212 | 7 |
1586317 | 1586317 | 2021-08-05 | Liberty | Florida | 12077 | 1212 | 16 |
1587512 | 1587512 | 2021-08-05 | Lewis | Missouri | 29111 | 1212 | 21 |
1583067 | 1583067 | 2021-08-04 | Liberty | Florida | 12077 | 1212 | 16 |
1585061 | 1585061 | 2021-08-04 | Coamo | Puerto Rico | 72043 | 1212 | |
1579817 | 1579817 | 2021-08-03 | Liberty | Florida | 12077 | 1212 | 16 |
1576569 | 1576569 | 2021-08-02 | Liberty | Florida | 12077 | 1212 | 16 |
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);