ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
169 rows where cases = 3146 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Tennessee 12
- Georgia 11
- Virginia 10
- Kentucky 8
- Iowa 7
- Mississippi 7
- Ohio 7
- Oklahoma 7
- Texas 7
- Alabama 6
- Colorado 6
- Illinois 6
- Indiana 6
- Michigan 6
- Minnesota 6
- Washington 6
- Pennsylvania 5
- Louisiana 4
- Missouri 4
- North Carolina 4
- Wisconsin 4
- New Mexico 3
- Puerto Rico 3
- Alaska 2
- Arizona 2
- Arkansas 2
- Maine 2
- New York 2
- Vermont 2
- West Virginia 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2376697 | 2376697 | 2022-04-05 | Madison | Iowa | 19121 | 3146 | 39 |
2373445 | 2373445 | 2022-04-04 | Madison | Iowa | 19121 | 3146 | 39 |
2370192 | 2370192 | 2022-04-03 | Madison | Iowa | 19121 | 3146 | 39 |
2366939 | 2366939 | 2022-04-02 | Madison | Iowa | 19121 | 3146 | 39 |
2363686 | 2363686 | 2022-04-01 | Madison | Iowa | 19121 | 3146 | 39 |
2360432 | 2360432 | 2022-03-31 | Madison | Iowa | 19121 | 3146 | 39 |
2362722 | 2362722 | 2022-03-31 | Roane | West Virginia | 54087 | 3146 | 38 |
2357178 | 2357178 | 2022-03-30 | Madison | Iowa | 19121 | 3146 | 39 |
2359468 | 2359468 | 2022-03-30 | Roane | West Virginia | 54087 | 3146 | 38 |
2304531 | 2304531 | 2022-03-14 | Crowley | Colorado | 8025 | 3146 | 28 |
2306592 | 2306592 | 2022-03-14 | Potter | Pennsylvania | 42105 | 3146 | 91 |
2301279 | 2301279 | 2022-03-13 | Crowley | Colorado | 8025 | 3146 | 28 |
2298027 | 2298027 | 2022-03-12 | Crowley | Colorado | 8025 | 3146 | 28 |
2294775 | 2294775 | 2022-03-11 | Crowley | Colorado | 8025 | 3146 | 28 |
2265677 | 2265677 | 2022-03-02 | Dade | Georgia | 13083 | 3146 | 28 |
2216149 | 2216149 | 2022-02-14 | Orange | Vermont | 50017 | 3146 | 11 |
2200490 | 2200490 | 2022-02-10 | Gunnison | Colorado | 8051 | 3146 | 13 |
2203307 | 2203307 | 2022-02-10 | Pacific | Washington | 53049 | 3146 | 47 |
2199884 | 2199884 | 2022-02-09 | Lamoille | Vermont | 50015 | 3146 | 14 |
2200053 | 2200053 | 2022-02-09 | Pacific | Washington | 53049 | 3146 | 47 |
2193514 | 2193514 | 2022-02-07 | Westmoreland | Virginia | 51193 | 3146 | 42 |
2186337 | 2186337 | 2022-02-05 | Naguabo | Puerto Rico | 72103 | 3146 | |
2154754 | 2154754 | 2022-01-27 | Northwest Arctic Borough | Alaska | 2188 | 3146 | 11 |
2151501 | 2151501 | 2022-01-26 | Northwest Arctic Borough | Alaska | 2188 | 3146 | 11 |
2142946 | 2142946 | 2022-01-23 | Leelanau | Michigan | 26089 | 3146 | 44 |
2139691 | 2139691 | 2022-01-22 | Leelanau | Michigan | 26089 | 3146 | 44 |
2136435 | 2136435 | 2022-01-21 | Leelanau | Michigan | 26089 | 3146 | 44 |
2083255 | 2083255 | 2022-01-05 | Grant | Arkansas | 5053 | 3146 | 52 |
2082550 | 2082550 | 2022-01-04 | DeWitt | Texas | 48123 | 3146 | 86 |
2053674 | 2053674 | 2021-12-26 | Asotin | Washington | 53003 | 3146 | 52 |
2050424 | 2050424 | 2021-12-25 | Asotin | Washington | 53003 | 3146 | 52 |
2047174 | 2047174 | 2021-12-24 | Asotin | Washington | 53003 | 3146 | 52 |
2041002 | 2041002 | 2021-12-23 | Hempstead | Arkansas | 5057 | 3146 | 46 |
2043924 | 2043924 | 2021-12-23 | Asotin | Washington | 53003 | 3146 | 52 |
2019953 | 2019953 | 2021-12-16 | Taos | New Mexico | 35055 | 3146 | 72 |
2016267 | 2016267 | 2021-12-15 | Wadena | Minnesota | 27159 | 3146 | 43 |
1994469 | 1994469 | 2021-12-08 | Gurabo | Puerto Rico | 72063 | 3146 | |
1990160 | 1990160 | 2021-12-07 | Ogemaw | Michigan | 26129 | 3146 | 75 |
1991218 | 1991218 | 2021-12-07 | Gurabo | Puerto Rico | 72063 | 3146 | |
1986910 | 1986910 | 2021-12-06 | Ogemaw | Michigan | 26129 | 3146 | 75 |
1967625 | 1967625 | 2021-11-30 | Clinton | Missouri | 29049 | 3146 | 95 |
1946886 | 1946886 | 2021-11-24 | Otero | Colorado | 8089 | 3146 | 94 |
1940659 | 1940659 | 2021-11-22 | Blaine | Idaho | 16013 | 3146 | 27 |
1926142 | 1926142 | 2021-11-17 | Juniata | Pennsylvania | 42067 | 3146 | 122 |
1897874 | 1897874 | 2021-11-09 | Fayette | Alabama | 1057 | 3146 | 85 |
1891378 | 1891378 | 2021-11-07 | Hale | Alabama | 1065 | 3146 | 88 |
1894524 | 1894524 | 2021-11-07 | Green Lake | Wisconsin | 55047 | 3146 | 32 |
1891274 | 1891274 | 2021-11-06 | Green Lake | Wisconsin | 55047 | 3146 | 32 |
1888024 | 1888024 | 2021-11-05 | Green Lake | Wisconsin | 55047 | 3146 | 32 |
1874465 | 1874465 | 2021-11-01 | Union | Tennessee | 47173 | 3146 | 46 |
1871216 | 1871216 | 2021-10-31 | Union | Tennessee | 47173 | 3146 | 46 |
1871562 | 1871562 | 2021-10-31 | Dinwiddie | Virginia | 51053 | 3146 | 52 |
1867967 | 1867967 | 2021-10-30 | Union | Tennessee | 47173 | 3146 | 46 |
1868313 | 1868313 | 2021-10-30 | Dinwiddie | Virginia | 51053 | 3146 | 52 |
1864718 | 1864718 | 2021-10-29 | Union | Tennessee | 47173 | 3146 | 46 |
1865064 | 1865064 | 2021-10-29 | Dinwiddie | Virginia | 51053 | 3146 | 52 |
1849537 | 1849537 | 2021-10-25 | Crisp | Georgia | 13081 | 3146 | 108 |
1850602 | 1850602 | 2021-10-25 | Winston | Mississippi | 28159 | 3146 | 91 |
1839459 | 1839459 | 2021-10-22 | La Paz | Arizona | 4012 | 3146 | 97 |
1832223 | 1832223 | 2021-10-19 | Trousdale | Tennessee | 47169 | 3146 | 26 |
1827673 | 1827673 | 2021-10-18 | Otsego | Michigan | 26137 | 3146 | 51 |
1804621 | 1804621 | 2021-10-11 | Anderson | Kentucky | 21005 | 3146 | 40 |
1766265 | 1766265 | 2021-09-29 | Lake | Montana | 30047 | 3146 | 52 |
1757203 | 1757203 | 2021-09-26 | Susquehanna | Pennsylvania | 42115 | 3146 | 63 |
1741935 | 1741935 | 2021-09-22 | Monroe | Alabama | 1099 | 3146 | 52 |
1744029 | 1744029 | 2021-09-22 | Van Wert | Ohio | 39161 | 3146 | 70 |
1739409 | 1739409 | 2021-09-21 | Randolph | Indiana | 18135 | 3146 | 89 |
1740792 | 1740792 | 2021-09-21 | Beckham | Oklahoma | 40009 | 3146 | 59 |
1737543 | 1737543 | 2021-09-20 | Beckham | Oklahoma | 40009 | 3146 | 59 |
1732612 | 1732612 | 2021-09-19 | Jones | Georgia | 13169 | 3146 | 71 |
1734293 | 1734293 | 2021-09-19 | Beckham | Oklahoma | 40009 | 3146 | 59 |
1734683 | 1734683 | 2021-09-19 | Crockett | Tennessee | 47033 | 3146 | 54 |
1729362 | 1729362 | 2021-09-18 | Jones | Georgia | 13169 | 3146 | 71 |
1731043 | 1731043 | 2021-09-18 | Beckham | Oklahoma | 40009 | 3146 | 59 |
1731433 | 1731433 | 2021-09-18 | Crockett | Tennessee | 47033 | 3146 | 54 |
1726112 | 1726112 | 2021-09-17 | Jones | Georgia | 13169 | 3146 | 71 |
1727793 | 1727793 | 2021-09-17 | Beckham | Oklahoma | 40009 | 3146 | 59 |
1728183 | 1728183 | 2021-09-17 | Crockett | Tennessee | 47033 | 3146 | 54 |
1724544 | 1724544 | 2021-09-16 | Beckham | Oklahoma | 40009 | 3146 | 59 |
1721295 | 1721295 | 2021-09-15 | Beckham | Oklahoma | 40009 | 3146 | 59 |
1721373 | 1721373 | 2021-09-15 | Columbia | Oregon | 41009 | 3146 | 37 |
1721959 | 1721959 | 2021-09-15 | Reeves | Texas | 48389 | 3146 | 47 |
1715176 | 1715176 | 2021-09-13 | Bledsoe | Tennessee | 47007 | 3146 | 13 |
1682872 | 1682872 | 2021-09-03 | Gonzales | Texas | 48177 | 3146 | 63 |
1653717 | 1653717 | 2021-08-25 | Milam | Texas | 48331 | 3146 | 58 |
1619778 | 1619778 | 2021-08-15 | Brown | Minnesota | 27015 | 3146 | 40 |
1616530 | 1616530 | 2021-08-14 | Brown | Minnesota | 27015 | 3146 | 40 |
1613282 | 1613282 | 2021-08-13 | Brown | Minnesota | 27015 | 3146 | 40 |
1596864 | 1596864 | 2021-08-08 | Pointe Coupee | Louisiana | 22077 | 3146 | 75 |
1593615 | 1593615 | 2021-08-07 | Pointe Coupee | Louisiana | 22077 | 3146 | 75 |
1590366 | 1590366 | 2021-08-06 | Pointe Coupee | Louisiana | 22077 | 3146 | 75 |
1581339 | 1581339 | 2021-08-03 | Orleans | New York | 36073 | 3146 | 83 |
1581781 | 1581781 | 2021-08-03 | Tioga | Pennsylvania | 42117 | 3146 | 113 |
1574404 | 1574404 | 2021-08-01 | Itawamba | Mississippi | 28057 | 3146 | 80 |
1571156 | 1571156 | 2021-07-31 | Itawamba | Mississippi | 28057 | 3146 | 80 |
1567908 | 1567908 | 2021-07-30 | Itawamba | Mississippi | 28057 | 3146 | 80 |
1512350 | 1512350 | 2021-07-13 | Muhlenberg | Kentucky | 21177 | 3146 | 68 |
1506298 | 1506298 | 2021-07-11 | Dunklin | Missouri | 29069 | 3146 | 50 |
1495069 | 1495069 | 2021-07-08 | Lawrence | Alabama | 1079 | 3146 | 100 |
1491822 | 1491822 | 2021-07-07 | Lawrence | Alabama | 1079 | 3146 | 100 |
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);