ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
256 rows where cases = 1936 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 19
- Tennessee 18
- Arkansas 16
- Iowa 16
- Indiana 15
- Georgia 14
- Kentucky 12
- Michigan 12
- Texas 12
- Illinois 11
- Missouri 11
- West Virginia 10
- Kansas 9
- Oklahoma 8
- North Carolina 7
- Puerto Rico 6
- Mississippi 5
- Nevada 5
- Ohio 5
- Alabama 4
- Florida 4
- Minnesota 4
- Pennsylvania 4
- South Carolina 4
- Wisconsin 4
- Idaho 3
- California 2
- Colorado 2
- Maryland 2
- Montana 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499733 | 2499733 | 2022-05-13 | Monroe | Arkansas | 5095 | 1936 | 35 |
2496475 | 2496475 | 2022-05-12 | Monroe | Arkansas | 5095 | 1936 | 35 |
2493217 | 2493217 | 2022-05-11 | Monroe | Arkansas | 5095 | 1936 | 35 |
2339942 | 2339942 | 2022-03-24 | Pendleton | West Virginia | 54071 | 1936 | 17 |
2313624 | 2313624 | 2022-03-16 | Swisher | Texas | 48437 | 1936 | 33 |
2297227 | 2297227 | 2022-03-11 | Gaines | Texas | 48165 | 1936 | 83 |
2278942 | 2278942 | 2022-03-06 | Schuyler | Illinois | 17169 | 1936 | 29 |
2275689 | 2275689 | 2022-03-05 | Schuyler | Illinois | 17169 | 1936 | 29 |
2272436 | 2272436 | 2022-03-04 | Schuyler | Illinois | 17169 | 1936 | 29 |
2258695 | 2258695 | 2022-02-27 | Pepin | Wisconsin | 55091 | 1936 | 18 |
2255444 | 2255444 | 2022-02-26 | Pepin | Wisconsin | 55091 | 1936 | 18 |
2252193 | 2252193 | 2022-02-25 | Pepin | Wisconsin | 55091 | 1936 | 18 |
2246425 | 2246425 | 2022-02-24 | Schuyler | Illinois | 17169 | 1936 | 29 |
2243174 | 2243174 | 2022-02-23 | Schuyler | Illinois | 17169 | 1936 | 29 |
2241019 | 2241019 | 2022-02-22 | White Pine | Nevada | 32033 | 1936 | 19 |
2237768 | 2237768 | 2022-02-21 | White Pine | Nevada | 32033 | 1936 | 19 |
2234517 | 2234517 | 2022-02-20 | White Pine | Nevada | 32033 | 1936 | 19 |
2231266 | 2231266 | 2022-02-19 | White Pine | Nevada | 32033 | 1936 | 19 |
2226403 | 2226403 | 2022-02-18 | Prairie | Arkansas | 5117 | 1936 | 39 |
2228015 | 2228015 | 2022-02-18 | White Pine | Nevada | 32033 | 1936 | 19 |
2219619 | 2219619 | 2022-02-15 | Pocahontas | West Virginia | 54075 | 1936 | 25 |
2199934 | 2199934 | 2022-02-09 | Fairfax city | Virginia | 51600 | 1936 | 39 |
2194258 | 2194258 | 2022-02-08 | Wilcox | Georgia | 13315 | 1936 | 63 |
2191025 | 2191025 | 2022-02-07 | Boundary | Idaho | 16021 | 1936 | 55 |
2171812 | 2171812 | 2022-02-01 | Palo Alto | Iowa | 19147 | 1936 | 35 |
2168559 | 2168559 | 2022-01-31 | Palo Alto | Iowa | 19147 | 1936 | 35 |
2165304 | 2165304 | 2022-01-30 | Palo Alto | Iowa | 19147 | 1936 | 35 |
2162049 | 2162049 | 2022-01-29 | Palo Alto | Iowa | 19147 | 1936 | 35 |
2158794 | 2158794 | 2022-01-28 | Palo Alto | Iowa | 19147 | 1936 | 35 |
2155540 | 2155540 | 2022-01-27 | Palo Alto | Iowa | 19147 | 1936 | 35 |
2157755 | 2157755 | 2022-01-27 | Lincoln | Washington | 53043 | 1936 | 26 |
2151809 | 2151809 | 2022-01-26 | Atkinson | Georgia | 13003 | 1936 | 39 |
2152287 | 2152287 | 2022-01-26 | Palo Alto | Iowa | 19147 | 1936 | 35 |
2154502 | 2154502 | 2022-01-26 | Lincoln | Washington | 53043 | 1936 | 26 |
2137541 | 2137541 | 2022-01-21 | Rincon | Puerto Rico | 72117 | 1936 | |
2133521 | 2133521 | 2022-01-20 | Deer Lodge | Montana | 30023 | 1936 | 28 |
2134289 | 2134289 | 2022-01-20 | Sabana Grande | Puerto Rico | 72121 | 1936 | |
2129106 | 2129106 | 2022-01-19 | Heard | Georgia | 13149 | 1936 | 43 |
2129221 | 2129221 | 2022-01-19 | Fremont | Idaho | 16043 | 1936 | 20 |
2126680 | 2126680 | 2022-01-18 | Mackinac | Michigan | 26097 | 1936 | 25 |
2123428 | 2123428 | 2022-01-17 | Mackinac | Michigan | 26097 | 1936 | 25 |
2120176 | 2120176 | 2022-01-16 | Mackinac | Michigan | 26097 | 1936 | 25 |
2116924 | 2116924 | 2022-01-15 | Mackinac | Michigan | 26097 | 1936 | 25 |
2113673 | 2113673 | 2022-01-14 | Mackinac | Michigan | 26097 | 1936 | 25 |
2080865 | 2080865 | 2022-01-04 | Wilson | Kansas | 20205 | 1936 | 35 |
2077613 | 2077613 | 2022-01-03 | Wilson | Kansas | 20205 | 1936 | 35 |
2060799 | 2060799 | 2021-12-29 | Early | Georgia | 13099 | 1936 | 58 |
2012209 | 2012209 | 2021-12-14 | Washington | Idaho | 16087 | 1936 | 47 |
2006217 | 2006217 | 2021-12-12 | Todd | Kentucky | 21219 | 1936 | 36 |
2007141 | 2007141 | 2021-12-12 | Mercer | North Dakota | 38057 | 1936 | 20 |
2002966 | 2002966 | 2021-12-11 | Todd | Kentucky | 21219 | 1936 | 36 |
2004511 | 2004511 | 2021-12-11 | Callahan | Texas | 48059 | 1936 | 57 |
1999716 | 1999716 | 2021-12-10 | Todd | Kentucky | 21219 | 1936 | 36 |
1996911 | 1996911 | 2021-12-09 | Linn | Missouri | 29115 | 1936 | 57 |
1987108 | 1987108 | 2021-12-06 | Bollinger | Missouri | 29017 | 1936 | 31 |
1966321 | 1966321 | 2021-11-30 | Plumas | California | 6063 | 1936 | 7 |
1963069 | 1963069 | 2021-11-29 | Plumas | California | 6063 | 1936 | 7 |
1965194 | 1965194 | 2021-11-29 | Barranquitas | Puerto Rico | 72019 | 1936 | |
1943476 | 1943476 | 2021-11-23 | Desha | Arkansas | 5041 | 1936 | 33 |
1904077 | 1904077 | 2021-11-10 | Greensville | Virginia | 51081 | 1936 | 26 |
1898932 | 1898932 | 2021-11-09 | Metcalfe | Kentucky | 21169 | 1936 | 42 |
1887199 | 1887199 | 2021-11-05 | Cidra | Puerto Rico | 72041 | 1936 | |
1878967 | 1878967 | 2021-11-03 | Cumberland | Illinois | 17035 | 1936 | 39 |
1879426 | 1879426 | 2021-11-03 | Martin | Kentucky | 21159 | 1936 | 35 |
1876061 | 1876061 | 2021-11-02 | Nemaha | Kansas | 20131 | 1936 | 56 |
1872812 | 1872812 | 2021-11-01 | Nemaha | Kansas | 20131 | 1936 | 56 |
1874842 | 1874842 | 2021-11-01 | King William | Virginia | 51101 | 1936 | 24 |
1827434 | 1827434 | 2021-10-18 | Lyon | Kentucky | 21143 | 1936 | 26 |
1824051 | 1824051 | 2021-10-17 | Jackson | Kansas | 20085 | 1936 | 19 |
1820802 | 1820802 | 2021-10-16 | Jackson | Kansas | 20085 | 1936 | 19 |
1817553 | 1817553 | 2021-10-15 | Jackson | Kansas | 20085 | 1936 | 19 |
1814332 | 1814332 | 2021-10-14 | Osage | Kansas | 20139 | 1936 | 34 |
1811083 | 1811083 | 2021-10-13 | Osage | Kansas | 20139 | 1936 | 34 |
1784240 | 1784240 | 2021-10-05 | Bradley | Arkansas | 5011 | 1936 | 38 |
1764778 | 1764778 | 2021-09-29 | Little River | Arkansas | 5081 | 1936 | 45 |
1751041 | 1751041 | 2021-09-24 | Camp | Texas | 48063 | 1936 | 59 |
1747712 | 1747712 | 2021-09-23 | Lake | Tennessee | 47095 | 1936 | 31 |
1743270 | 1743270 | 2021-09-22 | Pennington | Minnesota | 27113 | 1936 | 22 |
1715233 | 1715233 | 2021-09-13 | Meigs | Tennessee | 47121 | 1936 | 24 |
1702594 | 1702594 | 2021-09-09 | Bristol city | Virginia | 51520 | 1936 | 41 |
1694549 | 1694549 | 2021-09-07 | Renville | Minnesota | 27129 | 1936 | 46 |
1688147 | 1688147 | 2021-09-05 | Walthall | Mississippi | 28147 | 1936 | 53 |
1683563 | 1683563 | 2021-09-04 | Marion | Arkansas | 5089 | 1936 | 50 |
1684897 | 1684897 | 2021-09-04 | Walthall | Mississippi | 28147 | 1936 | 53 |
1681646 | 1681646 | 2021-09-03 | Walthall | Mississippi | 28147 | 1936 | 53 |
1673811 | 1673811 | 2021-09-01 | Lee | Arkansas | 5077 | 1936 | 40 |
1673539 | 1673539 | 2021-08-31 | McDowell | West Virginia | 54047 | 1936 | 27 |
1668725 | 1668725 | 2021-08-30 | Macon | Missouri | 29121 | 1936 | 19 |
1660685 | 1660685 | 2021-08-28 | Clay | Alabama | 1027 | 1936 | 60 |
1652771 | 1652771 | 2021-08-25 | Taos | New Mexico | 35055 | 1936 | 56 |
1648082 | 1648082 | 2021-08-24 | Bleckley | Georgia | 13023 | 1936 | 52 |
1642285 | 1642285 | 2021-08-22 | Rockcastle | Kentucky | 21203 | 1936 | 24 |
1639035 | 1639035 | 2021-08-21 | Rockcastle | Kentucky | 21203 | 1936 | 24 |
1635785 | 1635785 | 2021-08-20 | Rockcastle | Kentucky | 21203 | 1936 | 24 |
1624333 | 1624333 | 2021-08-16 | Bosque | Texas | 48035 | 1936 | 39 |
1621049 | 1621049 | 2021-08-15 | Sequatchie | Tennessee | 47153 | 1936 | 30 |
1617801 | 1617801 | 2021-08-14 | Sequatchie | Tennessee | 47153 | 1936 | 30 |
1614553 | 1614553 | 2021-08-13 | Sequatchie | Tennessee | 47153 | 1936 | 30 |
1603097 | 1603097 | 2021-08-10 | Wright | Iowa | 19197 | 1936 | 40 |
1599848 | 1599848 | 2021-08-09 | Wright | Iowa | 19197 | 1936 | 40 |
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);