ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
281 rows where cases = 1956 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 22
- Arkansas 17
- Illinois 17
- Texas 17
- Oklahoma 15
- Tennessee 14
- Virginia 14
- Missouri 13
- Minnesota 12
- Wisconsin 12
- Kansas 10
- Georgia 9
- Kentucky 9
- Michigan 9
- Ohio 9
- North Carolina 8
- Indiana 6
- Mississippi 6
- Nebraska 5
- North Dakota 5
- South Carolina 5
- West Virginia 5
- Louisiana 4
- South Dakota 4
- Alabama 3
- Florida 3
- Idaho 3
- New Mexico 3
- New York 3
- Washington 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2415589 | 2415589 | 2022-04-17 | Schuyler | Illinois | 17169 | 1956 | 29 |
2412333 | 2412333 | 2022-04-16 | Schuyler | Illinois | 17169 | 1956 | 29 |
2409077 | 2409077 | 2022-04-15 | Schuyler | Illinois | 17169 | 1956 | 29 |
2405821 | 2405821 | 2022-04-14 | Schuyler | Illinois | 17169 | 1956 | 29 |
2402566 | 2402566 | 2022-04-13 | Schuyler | Illinois | 17169 | 1956 | 29 |
2398511 | 2398511 | 2022-04-11 | Pendleton | West Virginia | 54071 | 1956 | 21 |
2327213 | 2327213 | 2022-03-21 | Prairie | Arkansas | 5117 | 1956 | 41 |
2323960 | 2323960 | 2022-03-20 | Prairie | Arkansas | 5117 | 1956 | 41 |
2320706 | 2320706 | 2022-03-19 | Prairie | Arkansas | 5117 | 1956 | 41 |
2317452 | 2317452 | 2022-03-18 | Prairie | Arkansas | 5117 | 1956 | 41 |
2308468 | 2308468 | 2022-03-15 | Kingman | Kansas | 20095 | 1956 | 26 |
2305217 | 2305217 | 2022-03-14 | Kingman | Kansas | 20095 | 1956 | 26 |
2273791 | 2273791 | 2022-03-04 | Pembina | North Dakota | 38067 | 1956 | 16 |
2264520 | 2264520 | 2022-03-01 | Turner | South Dakota | 46125 | 1956 | 62 |
2261270 | 2261270 | 2022-02-28 | Turner | South Dakota | 46125 | 1956 | 62 |
2221567 | 2221567 | 2022-02-16 | Quay | New Mexico | 35037 | 1956 | 47 |
2211343 | 2211343 | 2022-02-13 | Lake | Minnesota | 27075 | 1956 | 27 |
2208090 | 2208090 | 2022-02-12 | Lake | Minnesota | 27075 | 1956 | 27 |
2204837 | 2204837 | 2022-02-11 | Lake | Minnesota | 27075 | 1956 | 27 |
2197458 | 2197458 | 2022-02-09 | Montgomery | Georgia | 13209 | 1956 | 48 |
2196192 | 2196192 | 2022-02-08 | Custer | South Dakota | 46033 | 1956 | 21 |
2183504 | 2183504 | 2022-02-04 | Ochiltree | Texas | 48357 | 1956 | 43 |
2180556 | 2180556 | 2022-02-03 | Doddridge | West Virginia | 54017 | 1956 | 16 |
2146967 | 2146967 | 2022-01-24 | Traill | North Dakota | 38097 | 1956 | 21 |
2143713 | 2143713 | 2022-01-23 | Traill | North Dakota | 38097 | 1956 | 21 |
2126299 | 2126299 | 2022-01-18 | Cloud | Kansas | 20029 | 1956 | 34 |
2127616 | 2127616 | 2022-01-18 | Washita | Oklahoma | 40149 | 1956 | 35 |
2123047 | 2123047 | 2022-01-17 | Cloud | Kansas | 20029 | 1956 | 34 |
2124364 | 2124364 | 2022-01-17 | Washita | Oklahoma | 40149 | 1956 | 35 |
2119795 | 2119795 | 2022-01-16 | Cloud | Kansas | 20029 | 1956 | 34 |
2121112 | 2121112 | 2022-01-16 | Washita | Oklahoma | 40149 | 1956 | 35 |
2116543 | 2116543 | 2022-01-15 | Cloud | Kansas | 20029 | 1956 | 34 |
2117860 | 2117860 | 2022-01-15 | Washita | Oklahoma | 40149 | 1956 | 35 |
2113292 | 2113292 | 2022-01-14 | Cloud | Kansas | 20029 | 1956 | 34 |
2114609 | 2114609 | 2022-01-14 | Washita | Oklahoma | 40149 | 1956 | 35 |
2111357 | 2111357 | 2022-01-13 | Washita | Oklahoma | 40149 | 1956 | 35 |
2107272 | 2107272 | 2022-01-12 | Rock | Minnesota | 27133 | 1956 | 32 |
2108105 | 2108105 | 2022-01-12 | Washita | Oklahoma | 40149 | 1956 | 35 |
2103205 | 2103205 | 2022-01-11 | Franklin | Idaho | 16041 | 1956 | 27 |
2082070 | 2082070 | 2022-01-04 | Nowata | Oklahoma | 40105 | 1956 | 33 |
2078818 | 2078818 | 2022-01-03 | Nowata | Oklahoma | 40105 | 1956 | 33 |
2075567 | 2075567 | 2022-01-02 | Nowata | Oklahoma | 40105 | 1956 | 33 |
2072316 | 2072316 | 2022-01-01 | Nowata | Oklahoma | 40105 | 1956 | 33 |
2069065 | 2069065 | 2021-12-31 | Nowata | Oklahoma | 40105 | 1956 | 33 |
2065814 | 2065814 | 2021-12-30 | Nowata | Oklahoma | 40105 | 1956 | 33 |
2062564 | 2062564 | 2021-12-29 | Nowata | Oklahoma | 40105 | 1956 | 33 |
2035866 | 2035866 | 2021-12-21 | Barton | Missouri | 29011 | 1956 | 40 |
2017004 | 2017004 | 2021-12-15 | Vinton | Ohio | 39163 | 1956 | 41 |
2012719 | 2012719 | 2021-12-14 | Todd | Kentucky | 21219 | 1956 | 36 |
2009863 | 2009863 | 2021-12-13 | Bollinger | Missouri | 29017 | 1956 | 33 |
2006612 | 2006612 | 2021-12-12 | Bollinger | Missouri | 29017 | 1956 | 33 |
1979281 | 1979281 | 2021-12-04 | Stone | Arkansas | 5137 | 1956 | 46 |
1972734 | 1972734 | 2021-12-02 | Desha | Arkansas | 5041 | 1956 | 33 |
1969064 | 1969064 | 2021-11-30 | Dickenson | Virginia | 51051 | 1956 | 30 |
1938132 | 1938132 | 2021-11-21 | Leelanau | Michigan | 26089 | 1956 | 29 |
1934882 | 1934882 | 2021-11-20 | Leelanau | Michigan | 26089 | 1956 | 29 |
1931632 | 1931632 | 2021-11-19 | Leelanau | Michigan | 26089 | 1956 | 29 |
1929442 | 1929442 | 2021-11-18 | Catano | Puerto Rico | 72033 | 1956 | |
1926192 | 1926192 | 2021-11-17 | Catano | Puerto Rico | 72033 | 1956 | |
1905368 | 1905368 | 2021-11-11 | Carroll | Kentucky | 21041 | 1956 | 28 |
1902118 | 1902118 | 2021-11-10 | Carroll | Kentucky | 21041 | 1956 | 28 |
1898465 | 1898465 | 2021-11-09 | Cumberland | Illinois | 17035 | 1956 | 39 |
1892424 | 1892424 | 2021-11-07 | Martin | Kentucky | 21159 | 1956 | 35 |
1889174 | 1889174 | 2021-11-06 | Martin | Kentucky | 21159 | 1956 | 35 |
1885924 | 1885924 | 2021-11-05 | Martin | Kentucky | 21159 | 1956 | 35 |
1881038 | 1881038 | 2021-11-03 | Duval | Texas | 48131 | 1956 | 58 |
1849223 | 1849223 | 2021-10-25 | Bradley | Arkansas | 5011 | 1956 | 41 |
1845973 | 1845973 | 2021-10-24 | Bradley | Arkansas | 5011 | 1956 | 41 |
1842723 | 1842723 | 2021-10-23 | Bradley | Arkansas | 5011 | 1956 | 41 |
1826339 | 1826339 | 2021-10-17 | Big Horn | Wyoming | 56003 | 1956 | 46 |
1821985 | 1821985 | 2021-10-16 | Noble | Ohio | 39121 | 1956 | 46 |
1823090 | 1823090 | 2021-10-16 | Big Horn | Wyoming | 56003 | 1956 | 46 |
1819841 | 1819841 | 2021-10-15 | Big Horn | Wyoming | 56003 | 1956 | 46 |
1809097 | 1809097 | 2021-10-12 | Baker | Oregon | 41001 | 1956 | 28 |
1805847 | 1805847 | 2021-10-11 | Baker | Oregon | 41001 | 1956 | 27 |
1791812 | 1791812 | 2021-10-07 | Franklin | Maine | 23007 | 1956 | 19 |
1781026 | 1781026 | 2021-10-04 | Little River | Arkansas | 5081 | 1956 | 47 |
1777776 | 1777776 | 2021-10-03 | Little River | Arkansas | 5081 | 1956 | 47 |
1778300 | 1778300 | 2021-10-03 | Piatt | Illinois | 17147 | 1956 | 20 |
1775050 | 1775050 | 2021-10-02 | Piatt | Illinois | 17147 | 1956 | 20 |
1771800 | 1771800 | 2021-10-01 | Piatt | Illinois | 17147 | 1956 | 20 |
1764296 | 1764296 | 2021-09-28 | Orleans | Vermont | 50019 | 1956 | 13 |
1761047 | 1761047 | 2021-09-27 | Orleans | Vermont | 50019 | 1956 | 13 |
1758100 | 1758100 | 2021-09-26 | Washburn | Wisconsin | 55129 | 1956 | 25 |
1754016 | 1754016 | 2021-09-25 | Morovis | Puerto Rico | 72101 | 1956 | |
1754852 | 1754852 | 2021-09-25 | Washburn | Wisconsin | 55129 | 1956 | 25 |
1750768 | 1750768 | 2021-09-24 | Morovis | Puerto Rico | 72101 | 1956 | |
1751604 | 1751604 | 2021-09-24 | Washburn | Wisconsin | 55129 | 1956 | 25 |
1747519 | 1747519 | 2021-09-23 | Morovis | Puerto Rico | 72101 | 1956 | |
1744269 | 1744269 | 2021-09-22 | Morovis | Puerto Rico | 72101 | 1956 | |
1740214 | 1740214 | 2021-09-21 | Pemiscot | Missouri | 29155 | 1956 | 41 |
1720531 | 1720531 | 2021-09-15 | Redwood | Minnesota | 27127 | 1956 | 41 |
1714468 | 1714468 | 2021-09-13 | Grant | New Mexico | 35017 | 1956 | 46 |
1690154 | 1690154 | 2021-09-06 | Alamosa | Colorado | 8003 | 1956 | 39 |
1690605 | 1690605 | 2021-09-06 | Washington | Illinois | 17189 | 1956 | 32 |
1691362 | 1691362 | 2021-09-06 | Lawrence | Mississippi | 28077 | 1956 | 30 |
1687355 | 1687355 | 2021-09-05 | Washington | Illinois | 17189 | 1956 | 32 |
1684105 | 1684105 | 2021-09-04 | Washington | Illinois | 17189 | 1956 | 32 |
1680854 | 1680854 | 2021-09-03 | Washington | Illinois | 17189 | 1956 | 32 |
1673915 | 1673915 | 2021-09-01 | Chaffee | Colorado | 8015 | 1956 | 26 |
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);