ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
171 rows where cases = 3047 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 14
- Minnesota 14
- Mississippi 13
- Georgia 12
- Indiana 12
- Texas 12
- Missouri 7
- Virginia 7
- Arkansas 6
- California 5
- Idaho 5
- Maryland 5
- Michigan 5
- Pennsylvania 5
- Tennessee 5
- Puerto Rico 4
- Montana 3
- North Carolina 3
- Alabama 2
- Colorado 2
- Illinois 2
- Kentucky 2
- Louisiana 2
- Nebraska 2
- New Mexico 2
- New York 2
- Oklahoma 2
- Oregon 2
- Washington 2
- West Virginia 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445598 | 2445598 | 2022-04-26 | Pope | Minnesota | 27121 | 3047 | 17 |
2447290 | 2447290 | 2022-04-26 | Jefferson | Washington | 53031 | 3047 | 28 |
2444034 | 2444034 | 2022-04-25 | Jefferson | Washington | 53031 | 3047 | 28 |
2377058 | 2377058 | 2022-04-05 | Kent | Maryland | 24029 | 3047 | 66 |
2373806 | 2373806 | 2022-04-04 | Kent | Maryland | 24029 | 3047 | 66 |
2351439 | 2351439 | 2022-03-28 | Custer | Montana | 30017 | 3047 | 46 |
2331920 | 2331920 | 2022-03-22 | Custer | Montana | 30017 | 3047 | 46 |
2274555 | 2274555 | 2022-03-04 | Nolan | Texas | 48353 | 3047 | 95 |
2259268 | 2259268 | 2022-02-28 | Telfair | Georgia | 13271 | 3047 | 80 |
2223323 | 2223323 | 2022-02-17 | Franklin | Florida | 12037 | 3047 | 46 |
2220072 | 2220072 | 2022-02-16 | Franklin | Florida | 12037 | 3047 | 46 |
2216821 | 2216821 | 2022-02-15 | Franklin | Florida | 12037 | 3047 | 46 |
2213570 | 2213570 | 2022-02-14 | Franklin | Florida | 12037 | 3047 | 46 |
2210318 | 2210318 | 2022-02-13 | Franklin | Florida | 12037 | 3047 | 46 |
2207065 | 2207065 | 2022-02-12 | Franklin | Florida | 12037 | 3047 | 46 |
2203812 | 2203812 | 2022-02-11 | Franklin | Florida | 12037 | 3047 | 46 |
2197177 | 2197177 | 2022-02-09 | Mono | California | 6051 | 3047 | 5 |
2196750 | 2196750 | 2022-02-08 | Rockbridge | Virginia | 51163 | 3047 | 73 |
2172935 | 2172935 | 2022-02-01 | Swain | North Carolina | 37173 | 3047 | 33 |
2156406 | 2156406 | 2022-01-27 | Otoe | Nebraska | 31131 | 3047 | 16 |
2153823 | 2153823 | 2022-01-26 | Utuado | Puerto Rico | 72141 | 3047 | |
2143018 | 2143018 | 2022-01-23 | Kanabec | Minnesota | 27065 | 3047 | 50 |
2139763 | 2139763 | 2022-01-22 | Kanabec | Minnesota | 27065 | 3047 | 50 |
2136507 | 2136507 | 2022-01-21 | Kanabec | Minnesota | 27065 | 3047 | 50 |
2117234 | 2117234 | 2022-01-15 | Ste. Genevieve | Missouri | 29186 | 3047 | 35 |
2112961 | 2112961 | 2022-01-14 | Gem | Idaho | 16045 | 3047 | 72 |
2101786 | 2101786 | 2022-01-10 | Yabucoa | Puerto Rico | 72151 | 3047 | |
2089387 | 2089387 | 2022-01-06 | Nottoway | Virginia | 51135 | 3047 | 71 |
2083371 | 2083371 | 2022-01-05 | Chaffee | Colorado | 8015 | 3047 | 38 |
2085162 | 2085162 | 2022-01-05 | Richland | North Dakota | 38077 | 3047 | 21 |
2081257 | 2081257 | 2022-01-04 | Redwood | Minnesota | 27127 | 3047 | 49 |
2063747 | 2063747 | 2021-12-30 | Grant | Arkansas | 5053 | 3047 | 52 |
2055289 | 2055289 | 2021-12-27 | Clarke | Mississippi | 28023 | 3047 | 96 |
2057099 | 2057099 | 2021-12-27 | Lincoln | Wyoming | 56023 | 3047 | 27 |
2053441 | 2053441 | 2021-12-26 | San Jacinto | Texas | 48407 | 3047 | 82 |
2050191 | 2050191 | 2021-12-25 | San Jacinto | Texas | 48407 | 3047 | 82 |
2046941 | 2046941 | 2021-12-24 | San Jacinto | Texas | 48407 | 3047 | 82 |
2043691 | 2043691 | 2021-12-23 | San Jacinto | Texas | 48407 | 3047 | 82 |
2035416 | 2035416 | 2021-12-21 | Henry | Kentucky | 21103 | 3047 | 36 |
2037275 | 2037275 | 2021-12-21 | Caledonia | Vermont | 50005 | 3047 | 21 |
2017391 | 2017391 | 2021-12-15 | Benton | Tennessee | 47005 | 3047 | 60 |
1991225 | 1991225 | 2021-12-07 | Juncos | Puerto Rico | 72077 | 3047 | |
1986091 | 1986091 | 2021-12-06 | Meriwether | Georgia | 13199 | 3047 | 120 |
1974010 | 1974010 | 2021-12-02 | Wadena | Minnesota | 27159 | 3047 | 40 |
1971192 | 1971192 | 2021-12-01 | San Miguel | New Mexico | 35047 | 3047 | 30 |
1941489 | 1941489 | 2021-11-22 | Roseau | Minnesota | 27135 | 3047 | 31 |
1943306 | 1943306 | 2021-11-22 | Sawyer | Wisconsin | 55113 | 3047 | 37 |
1935486 | 1935486 | 2021-11-20 | Seneca | New York | 36099 | 3047 | 65 |
1925615 | 1925615 | 2021-11-17 | Humboldt | Nevada | 32013 | 3047 | 39 |
1896858 | 1896858 | 2021-11-08 | Wasco | Oregon | 41065 | 3047 | 41 |
1871720 | 1871720 | 2021-10-31 | Lewis | West Virginia | 54041 | 3047 | 54 |
1853964 | 1853964 | 2021-10-26 | Vernon | Missouri | 29217 | 3047 | 65 |
1823841 | 1823841 | 2021-10-17 | Fulton | Indiana | 18049 | 3047 | 67 |
1820592 | 1820592 | 2021-10-16 | Fulton | Indiana | 18049 | 3047 | 67 |
1817343 | 1817343 | 2021-10-15 | Fulton | Indiana | 18049 | 3047 | 67 |
1819726 | 1819726 | 2021-10-15 | Hampshire | West Virginia | 54027 | 3047 | 47 |
1814574 | 1814574 | 2021-10-14 | Caroline | Maryland | 24011 | 3047 | 43 |
1815729 | 1815729 | 2021-10-14 | Gurabo | Puerto Rico | 72063 | 3047 | |
1755312 | 1755312 | 2021-09-26 | Crisp | Georgia | 13081 | 3047 | 103 |
1752064 | 1752064 | 2021-09-25 | Crisp | Georgia | 13081 | 3047 | 103 |
1748815 | 1748815 | 2021-09-24 | Crisp | Georgia | 13081 | 3047 | 103 |
1746357 | 1746357 | 2021-09-23 | Somerset | Maryland | 24039 | 3047 | 46 |
1743457 | 1743457 | 2021-09-22 | New Madrid | Missouri | 29143 | 3047 | 51 |
1733445 | 1733445 | 2021-09-19 | Oceana | Michigan | 26127 | 3047 | 63 |
1733512 | 1733512 | 2021-09-19 | Meeker | Minnesota | 27093 | 3047 | 49 |
1730195 | 1730195 | 2021-09-18 | Oceana | Michigan | 26127 | 3047 | 63 |
1730262 | 1730262 | 2021-09-18 | Meeker | Minnesota | 27093 | 3047 | 49 |
1726945 | 1726945 | 2021-09-17 | Oceana | Michigan | 26127 | 3047 | 63 |
1727012 | 1727012 | 2021-09-17 | Meeker | Minnesota | 27093 | 3047 | 49 |
1727960 | 1727960 | 2021-09-17 | Susquehanna | Pennsylvania | 42115 | 3047 | 62 |
1722135 | 1722135 | 2021-09-15 | Lee | Virginia | 51105 | 3047 | 51 |
1710147 | 1710147 | 2021-09-12 | LaGrange | Indiana | 18087 | 3047 | 76 |
1706900 | 1706900 | 2021-09-11 | LaGrange | Indiana | 18087 | 3047 | 76 |
1703652 | 1703652 | 2021-09-10 | LaGrange | Indiana | 18087 | 3047 | 76 |
1676829 | 1676829 | 2021-09-01 | Door | Wisconsin | 55029 | 3047 | 37 |
1664503 | 1664503 | 2021-08-29 | Jerome | Idaho | 16053 | 3047 | 28 |
1661255 | 1661255 | 2021-08-28 | Jerome | Idaho | 16053 | 3047 | 28 |
1658007 | 1658007 | 2021-08-27 | Jerome | Idaho | 16053 | 3047 | 28 |
1648721 | 1648721 | 2021-08-24 | Grant | Kentucky | 21081 | 3047 | 25 |
1621371 | 1621371 | 2021-08-15 | Accomack | Virginia | 51001 | 3047 | 47 |
1618123 | 1618123 | 2021-08-14 | Accomack | Virginia | 51001 | 3047 | 47 |
1614875 | 1614875 | 2021-08-13 | Accomack | Virginia | 51001 | 3047 | 47 |
1610285 | 1610285 | 2021-08-12 | Randolph | Missouri | 29175 | 3047 | 33 |
1579015 | 1579015 | 2021-08-02 | Palo Pinto | Texas | 48363 | 3047 | 78 |
1574181 | 1574181 | 2021-08-01 | Queen Anne's | Maryland | 24035 | 3047 | 53 |
1575767 | 1575767 | 2021-08-01 | Palo Pinto | Texas | 48363 | 3047 | 78 |
1572519 | 1572519 | 2021-07-31 | Palo Pinto | Texas | 48363 | 3047 | 78 |
1564701 | 1564701 | 2021-07-29 | Tippah | Mississippi | 28139 | 3047 | 68 |
1562675 | 1562675 | 2021-07-28 | Frio | Texas | 48163 | 3047 | 53 |
1554137 | 1554137 | 2021-07-26 | McDonough | Illinois | 17109 | 3047 | 63 |
1551021 | 1551021 | 2021-07-25 | Wells | Indiana | 18179 | 3047 | 83 |
1547774 | 1547774 | 2021-07-24 | Wells | Indiana | 18179 | 3047 | 83 |
1544527 | 1544527 | 2021-07-23 | Wells | Indiana | 18179 | 3047 | 83 |
1540683 | 1540683 | 2021-07-22 | Glenn | California | 6021 | 3047 | 27 |
1531178 | 1531178 | 2021-07-19 | Decatur | Georgia | 13087 | 3047 | 73 |
1527643 | 1527643 | 2021-07-18 | Johnson | Arkansas | 5071 | 3047 | 38 |
1524396 | 1524396 | 2021-07-17 | Johnson | Arkansas | 5071 | 3047 | 38 |
1521148 | 1521148 | 2021-07-16 | Johnson | Arkansas | 5071 | 3047 | 38 |
1518336 | 1518336 | 2021-07-15 | Jefferson | Idaho | 16051 | 3047 | 33 |
1515042 | 1515042 | 2021-07-14 | Unknown | Georgia | 3047 | 6 |
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);