ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
210 rows where cases = 2842 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 20
- Wisconsin 17
- Texas 16
- Mississippi 11
- Illinois 10
- Kentucky 10
- West Virginia 10
- Arkansas 8
- Minnesota 8
- Tennessee 8
- Virginia 8
- Alabama 7
- Michigan 7
- Ohio 6
- Puerto Rico 6
- Louisiana 5
- Missouri 5
- North Carolina 5
- Pennsylvania 5
- Indiana 4
- Kansas 4
- California 3
- Colorado 3
- Georgia 2
- Idaho 2
- New Mexico 2
- Oklahoma 2
- South Dakota 2
- Vermont 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486842 | 2486842 | 2022-05-09 | Rio Grande | Colorado | 8105 | 2842 | 46 |
2485670 | 2485670 | 2022-05-08 | Luquillo | Puerto Rico | 72089 | 2842 | |
2482412 | 2482412 | 2022-05-07 | Luquillo | Puerto Rico | 72089 | 2842 | |
2467837 | 2467837 | 2022-05-03 | Hancock | Iowa | 19081 | 2842 | 47 |
2470002 | 2470002 | 2022-05-03 | Lexington city | Virginia | 51678 | 2842 | 40 |
2464582 | 2464582 | 2022-05-02 | Hancock | Iowa | 19081 | 2842 | 47 |
2461326 | 2461326 | 2022-05-01 | Hancock | Iowa | 19081 | 2842 | 47 |
2462846 | 2462846 | 2022-05-01 | Ciales | Puerto Rico | 72039 | 2842 | |
2458070 | 2458070 | 2022-04-30 | Hancock | Iowa | 19081 | 2842 | 47 |
2454814 | 2454814 | 2022-04-29 | Hancock | Iowa | 19081 | 2842 | 47 |
2451558 | 2451558 | 2022-04-28 | Hancock | Iowa | 19081 | 2842 | 47 |
2448302 | 2448302 | 2022-04-27 | Hancock | Iowa | 19081 | 2842 | 47 |
2385011 | 2385011 | 2022-04-07 | Camp | Texas | 48063 | 2842 | 74 |
2378499 | 2378499 | 2022-04-05 | Callahan | Texas | 48059 | 2842 | 72 |
2375245 | 2375245 | 2022-04-04 | Callahan | Texas | 48059 | 2842 | 72 |
2371993 | 2371993 | 2022-04-03 | Callahan | Texas | 48059 | 2842 | 72 |
2368740 | 2368740 | 2022-04-02 | Callahan | Texas | 48059 | 2842 | 72 |
2314047 | 2314047 | 2022-03-17 | Conecuh | Alabama | 1035 | 2842 | 69 |
2311093 | 2311093 | 2022-03-16 | Unknown | Connecticut | 2842 | 8 | |
2281526 | 2281526 | 2022-03-07 | Conecuh | Alabama | 1035 | 2842 | 66 |
2279705 | 2279705 | 2022-03-06 | Jefferson Davis | Mississippi | 28065 | 2842 | 50 |
2276452 | 2276452 | 2022-03-05 | Jefferson Davis | Mississippi | 28065 | 2842 | 50 |
2273199 | 2273199 | 2022-03-04 | Jefferson Davis | Mississippi | 28065 | 2842 | 50 |
2229664 | 2229664 | 2022-02-19 | Stone | Arkansas | 5137 | 2842 | 58 |
2220843 | 2220843 | 2022-02-16 | Todd | Kentucky | 21219 | 2842 | 42 |
2217781 | 2217781 | 2022-02-15 | Missaukee | Michigan | 26113 | 2842 | 57 |
2214530 | 2214530 | 2022-02-14 | Missaukee | Michigan | 26113 | 2842 | 57 |
2205619 | 2205619 | 2022-02-11 | Vinton | Ohio | 39163 | 2842 | 52 |
2159142 | 2159142 | 2022-01-28 | Kent | Maryland | 24029 | 2842 | 62 |
2154801 | 2154801 | 2022-01-27 | Desha | Arkansas | 5041 | 2842 | 35 |
2149026 | 2149026 | 2022-01-25 | Mills | Iowa | 19129 | 2842 | 36 |
2145774 | 2145774 | 2022-01-24 | Mills | Iowa | 19129 | 2842 | 36 |
2142519 | 2142519 | 2022-01-23 | Mills | Iowa | 19129 | 2842 | 36 |
2139264 | 2139264 | 2022-01-22 | Mills | Iowa | 19129 | 2842 | 36 |
2136008 | 2136008 | 2022-01-21 | Mills | Iowa | 19129 | 2842 | 36 |
2132756 | 2132756 | 2022-01-20 | Mills | Iowa | 19129 | 2842 | 36 |
2134280 | 2134280 | 2022-01-20 | Naguabo | Puerto Rico | 72103 | 2842 | |
2129503 | 2129503 | 2022-01-19 | Mills | Iowa | 19129 | 2842 | 36 |
2085863 | 2085863 | 2022-01-05 | Jackson | Texas | 48239 | 2842 | 52 |
2063066 | 2063066 | 2021-12-29 | Freestone | Texas | 48161 | 2842 | 73 |
2054537 | 2054537 | 2021-12-27 | Piatt | Illinois | 17147 | 2842 | 22 |
2056759 | 2056759 | 2021-12-27 | San Juan | Utah | 49037 | 2842 | 45 |
2051758 | 2051758 | 2021-12-26 | Jackson | Louisiana | 22049 | 2842 | 64 |
2052004 | 2052004 | 2021-12-26 | Renville | Minnesota | 27129 | 2842 | 52 |
2048508 | 2048508 | 2021-12-25 | Jackson | Louisiana | 22049 | 2842 | 64 |
2048754 | 2048754 | 2021-12-25 | Renville | Minnesota | 27129 | 2842 | 52 |
2045258 | 2045258 | 2021-12-24 | Jackson | Louisiana | 22049 | 2842 | 64 |
2045504 | 2045504 | 2021-12-24 | Renville | Minnesota | 27129 | 2842 | 52 |
2042009 | 2042009 | 2021-12-23 | Jackson | Louisiana | 22049 | 2842 | 64 |
2042254 | 2042254 | 2021-12-23 | Renville | Minnesota | 27129 | 2842 | 52 |
1985503 | 1985503 | 2021-12-05 | Wetzel | West Virginia | 54103 | 2842 | 61 |
1973543 | 1973543 | 2021-12-02 | Jefferson | Kansas | 20087 | 2842 | 51 |
1970293 | 1970293 | 2021-12-01 | Jefferson | Kansas | 20087 | 2842 | 51 |
1967159 | 1967159 | 2021-11-30 | Jackson | Kentucky | 21109 | 2842 | 51 |
1963916 | 1963916 | 2021-11-29 | Lawrence | Kentucky | 21127 | 2842 | 44 |
1941516 | 1941516 | 2021-11-22 | Calhoun | Mississippi | 28013 | 2842 | 49 |
1905045 | 1905045 | 2021-11-11 | White | Illinois | 17193 | 2842 | 43 |
1901795 | 1901795 | 2021-11-10 | White | Illinois | 17193 | 2842 | 43 |
1894501 | 1894501 | 2021-11-07 | Adams | Wisconsin | 55001 | 2842 | 33 |
1891251 | 1891251 | 2021-11-06 | Adams | Wisconsin | 55001 | 2842 | 33 |
1888001 | 1888001 | 2021-11-05 | Adams | Wisconsin | 55001 | 2842 | 33 |
1876123 | 1876123 | 2021-11-02 | Casey | Kentucky | 21045 | 2842 | 57 |
1872874 | 1872874 | 2021-11-01 | Casey | Kentucky | 21045 | 2842 | 57 |
1861413 | 1861413 | 2021-10-28 | Grundy | Tennessee | 47061 | 2842 | 38 |
1854307 | 1854307 | 2021-10-26 | Hertford | North Carolina | 37091 | 2842 | 71 |
1850629 | 1850629 | 2021-10-25 | Clinton | Missouri | 29049 | 2842 | 77 |
1845344 | 1845344 | 2021-10-23 | Houston | Texas | 48225 | 2842 | 79 |
1842094 | 1842094 | 2021-10-22 | Houston | Texas | 48225 | 2842 | 79 |
1833948 | 1833948 | 2021-10-20 | Morgan | Kentucky | 21175 | 2842 | 9 |
1836075 | 1836075 | 2021-10-20 | Vernon | Wisconsin | 55123 | 2842 | 55 |
1832486 | 1832486 | 2021-10-19 | Young | Texas | 48503 | 2842 | 64 |
1813146 | 1813146 | 2021-10-13 | Radford city | Virginia | 51750 | 2842 | 31 |
1807000 | 1807000 | 2021-10-12 | Drew | Arkansas | 5043 | 2842 | 54 |
1803282 | 1803282 | 2021-10-10 | Franklin | Vermont | 50011 | 2842 | 45 |
1787510 | 1787510 | 2021-10-06 | Grant | Arkansas | 5053 | 2842 | 48 |
1788136 | 1788136 | 2021-10-06 | Orange | Indiana | 18117 | 2842 | 64 |
1784152 | 1784152 | 2021-10-05 | Fayette | Alabama | 1057 | 2842 | 74 |
1782510 | 1782510 | 2021-10-04 | Hill | Montana | 30041 | 2842 | 53 |
1767232 | 1767232 | 2021-09-29 | Sequatchie | Tennessee | 47153 | 2842 | 30 |
1751306 | 1751306 | 2021-09-24 | Washington | Vermont | 50023 | 2842 | 18 |
1746185 | 1746185 | 2021-09-23 | Harrison | Kentucky | 21097 | 2842 | 29 |
1736812 | 1736812 | 2021-09-20 | Chickasaw | Mississippi | 28017 | 2842 | 64 |
1724487 | 1724487 | 2021-09-16 | Hocking | Ohio | 39073 | 2842 | 67 |
1719242 | 1719242 | 2021-09-15 | La Paz | Arizona | 4012 | 2842 | 86 |
1688803 | 1688803 | 2021-09-05 | Van Wert | Ohio | 39161 | 2842 | 68 |
1664541 | 1664541 | 2021-08-29 | Douglas | Illinois | 17041 | 2842 | 42 |
1661293 | 1661293 | 2021-08-28 | Douglas | Illinois | 17041 | 2842 | 42 |
1658045 | 1658045 | 2021-08-27 | Douglas | Illinois | 17041 | 2842 | 42 |
1636781 | 1636781 | 2021-08-20 | Holmes | Ohio | 39075 | 2842 | 103 |
1618556 | 1618556 | 2021-08-15 | Arkansas | Arkansas | 5001 | 2842 | 48 |
1610793 | 1610793 | 2021-08-12 | Hardin | Ohio | 39065 | 2842 | 65 |
1589086 | 1589086 | 2021-08-05 | Mingo | West Virginia | 54059 | 2842 | 44 |
1580383 | 1580383 | 2021-08-03 | Franklin | Kansas | 20059 | 2842 | 46 |
1577134 | 1577134 | 2021-08-02 | Franklin | Kansas | 20059 | 2842 | 46 |
1542057 | 1542057 | 2021-07-22 | Nodaway | Missouri | 29147 | 2842 | 25 |
1538810 | 1538810 | 2021-07-21 | Nodaway | Missouri | 29147 | 2842 | 25 |
1531841 | 1531841 | 2021-07-19 | Perry | Kentucky | 21193 | 2842 | 66 |
1494762 | 1494762 | 2021-07-07 | Halifax | Virginia | 51083 | 2842 | 78 |
1444569 | 1444569 | 2021-06-22 | Prentiss | Mississippi | 28117 | 2842 | 61 |
1446207 | 1446207 | 2021-06-22 | Hancock | West Virginia | 54029 | 2842 | 89 |
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);