ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
302 rows where cases = 1951 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 21
- Oklahoma 21
- Texas 20
- Virginia 19
- Illinois 16
- Georgia 14
- Missouri 14
- Wisconsin 14
- Puerto Rico 13
- South Carolina 12
- Kentucky 11
- West Virginia 10
- Kansas 9
- Michigan 9
- Arkansas 8
- North Carolina 8
- Alabama 7
- Indiana 6
- Nebraska 6
- Ohio 6
- Idaho 5
- Minnesota 5
- Tennessee 5
- Montana 4
- North Dakota 4
- South Dakota 4
- Utah 4
- Colorado 3
- Oregon 3
- California 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2420868 | 2420868 | 2022-04-18 | Floyd | Texas | 48153 | 1951 | 48 |
2370020 | 2370020 | 2022-04-03 | Schuyler | Illinois | 17169 | 1951 | 29 |
2372182 | 2372182 | 2022-04-03 | Swisher | Texas | 48437 | 1951 | 34 |
2366767 | 2366767 | 2022-04-02 | Schuyler | Illinois | 17169 | 1951 | 29 |
2363514 | 2363514 | 2022-04-01 | Schuyler | Illinois | 17169 | 1951 | 29 |
2360260 | 2360260 | 2022-03-31 | Schuyler | Illinois | 17169 | 1951 | 29 |
2357006 | 2357006 | 2022-03-30 | Schuyler | Illinois | 17169 | 1951 | 29 |
2353753 | 2353753 | 2022-03-29 | Schuyler | Illinois | 17169 | 1951 | 29 |
2330247 | 2330247 | 2022-03-21 | Pepin | Wisconsin | 55091 | 1951 | 18 |
2326995 | 2326995 | 2022-03-20 | Pepin | Wisconsin | 55091 | 1951 | 18 |
2323742 | 2323742 | 2022-03-19 | Pepin | Wisconsin | 55091 | 1951 | 18 |
2320488 | 2320488 | 2022-03-18 | Pepin | Wisconsin | 55091 | 1951 | 18 |
2317234 | 2317234 | 2022-03-17 | Pepin | Wisconsin | 55091 | 1951 | 18 |
2307240 | 2307240 | 2022-03-14 | Fairfax city | Virginia | 51600 | 1951 | 43 |
2292209 | 2292209 | 2022-03-10 | Kingman | Kansas | 20095 | 1951 | 26 |
2288957 | 2288957 | 2022-03-09 | Kingman | Kansas | 20095 | 1951 | 26 |
2284931 | 2284931 | 2022-03-08 | Prairie | Arkansas | 5117 | 1951 | 41 |
2271466 | 2271466 | 2022-03-03 | Fairfax city | Virginia | 51600 | 1951 | 43 |
2268214 | 2268214 | 2022-03-02 | Fairfax city | Virginia | 51600 | 1951 | 43 |
2264961 | 2264961 | 2022-03-01 | Fairfax city | Virginia | 51600 | 1951 | 43 |
2237678 | 2237678 | 2022-02-21 | Custer | Nebraska | 31041 | 1951 | 28 |
2234427 | 2234427 | 2022-02-20 | Custer | Nebraska | 31041 | 1951 | 28 |
2235703 | 2235703 | 2022-02-20 | Fairfax city | Virginia | 51600 | 1951 | 40 |
2235874 | 2235874 | 2022-02-20 | Pocahontas | West Virginia | 54075 | 1951 | 25 |
2231176 | 2231176 | 2022-02-19 | Custer | Nebraska | 31041 | 1951 | 28 |
2232452 | 2232452 | 2022-02-19 | Fairfax city | Virginia | 51600 | 1951 | 40 |
2232623 | 2232623 | 2022-02-19 | Pocahontas | West Virginia | 54075 | 1951 | 25 |
2227925 | 2227925 | 2022-02-18 | Custer | Nebraska | 31041 | 1951 | 28 |
2229201 | 2229201 | 2022-02-18 | Fairfax city | Virginia | 51600 | 1951 | 40 |
2229372 | 2229372 | 2022-02-18 | Pocahontas | West Virginia | 54075 | 1951 | 25 |
2224674 | 2224674 | 2022-02-17 | Custer | Nebraska | 31041 | 1951 | 28 |
2221423 | 2221423 | 2022-02-16 | Custer | Nebraska | 31041 | 1951 | 28 |
2222455 | 2222455 | 2022-02-16 | Hamilton | Texas | 48193 | 1951 | 30 |
2217004 | 2217004 | 2022-02-15 | Taylor | Georgia | 13269 | 1951 | 49 |
2213753 | 2213753 | 2022-02-14 | Taylor | Georgia | 13269 | 1951 | 49 |
2214616 | 2214616 | 2022-02-14 | Pipestone | Minnesota | 27117 | 1951 | 33 |
2201584 | 2201584 | 2022-02-10 | Lake | Minnesota | 27075 | 1951 | 27 |
2195285 | 2195285 | 2022-02-08 | Oregon | Missouri | 29149 | 1951 | 28 |
2192938 | 2192938 | 2022-02-07 | Custer | South Dakota | 46033 | 1951 | 21 |
2177730 | 2177730 | 2022-02-03 | Lincoln | Colorado | 8073 | 1951 | 9 |
2166032 | 2166032 | 2022-01-30 | St. Clair | Missouri | 29185 | 1951 | 29 |
2140458 | 2140458 | 2022-01-22 | Traill | North Dakota | 38097 | 1951 | 21 |
2115207 | 2115207 | 2022-01-14 | Runnels | Texas | 48399 | 1951 | 57 |
2103693 | 2103693 | 2022-01-11 | Lee | Kentucky | 21129 | 1951 | 44 |
2104164 | 2104164 | 2022-01-11 | Grundy | Missouri | 29079 | 1951 | 60 |
2098102 | 2098102 | 2022-01-09 | Perquimans | North Carolina | 37143 | 1951 | 16 |
2094850 | 2094850 | 2022-01-08 | Perquimans | North Carolina | 37143 | 1951 | 16 |
2091598 | 2091598 | 2022-01-07 | Perquimans | North Carolina | 37143 | 1951 | 16 |
2077215 | 2077215 | 2022-01-03 | Washington | Idaho | 16087 | 1951 | 48 |
2051566 | 2051566 | 2021-12-26 | Marshall | Kansas | 20117 | 1951 | 37 |
2048316 | 2048316 | 2021-12-25 | Marshall | Kansas | 20117 | 1951 | 37 |
2044129 | 2044129 | 2021-12-24 | Conecuh | Alabama | 1035 | 1951 | 62 |
2045066 | 2045066 | 2021-12-24 | Marshall | Kansas | 20117 | 1951 | 37 |
2041817 | 2041817 | 2021-12-23 | Marshall | Kansas | 20117 | 1951 | 37 |
2038567 | 2038567 | 2021-12-22 | Marshall | Kansas | 20117 | 1951 | 37 |
2032668 | 2032668 | 2021-12-20 | Lewis | Missouri | 29111 | 1951 | 30 |
2029417 | 2029417 | 2021-12-19 | Lewis | Missouri | 29111 | 1951 | 30 |
2013951 | 2013951 | 2021-12-14 | Barranquitas | Puerto Rico | 72019 | 1951 | |
2013953 | 2013953 | 2021-12-14 | Cabo Rojo | Puerto Rico | 72023 | 1951 | |
2010702 | 2010702 | 2021-12-13 | Cabo Rojo | Puerto Rico | 72023 | 1951 | |
2007451 | 2007451 | 2021-12-12 | Cabo Rojo | Puerto Rico | 72023 | 1951 | |
2003372 | 2003372 | 2021-12-11 | Cedar | Missouri | 29039 | 1951 | 42 |
1939900 | 1939900 | 2021-11-21 | Westmoreland | Virginia | 51193 | 1951 | 37 |
1936650 | 1936650 | 2021-11-20 | Westmoreland | Virginia | 51193 | 1951 | 37 |
1933400 | 1933400 | 2021-11-19 | Westmoreland | Virginia | 51193 | 1951 | 37 |
1920500 | 1920500 | 2021-11-15 | Ashland | Wisconsin | 55003 | 1951 | 19 |
1916127 | 1916127 | 2021-11-14 | McLean | North Dakota | 38055 | 1951 | 41 |
1898683 | 1898683 | 2021-11-09 | Hancock | Iowa | 19081 | 1951 | 39 |
1895433 | 1895433 | 2021-11-08 | Hancock | Iowa | 19081 | 1951 | 39 |
1892183 | 1892183 | 2021-11-07 | Hancock | Iowa | 19081 | 1951 | 39 |
1894209 | 1894209 | 2021-11-07 | Ward | Texas | 48475 | 1951 | 30 |
1888933 | 1888933 | 2021-11-06 | Hancock | Iowa | 19081 | 1951 | 39 |
1885683 | 1885683 | 2021-11-05 | Hancock | Iowa | 19081 | 1951 | 39 |
1882434 | 1882434 | 2021-11-04 | Hancock | Iowa | 19081 | 1951 | 39 |
1882494 | 1882494 | 2021-11-04 | Allen | Kansas | 20001 | 1951 | 27 |
1879185 | 1879185 | 2021-11-03 | Hancock | Iowa | 19081 | 1951 | 39 |
1879245 | 1879245 | 2021-11-03 | Allen | Kansas | 20001 | 1951 | 27 |
1854348 | 1854348 | 2021-10-26 | Swain | North Carolina | 37173 | 1951 | 23 |
1836224 | 1836224 | 2021-10-21 | Bradley | Arkansas | 5011 | 1951 | 41 |
1818736 | 1818736 | 2021-10-15 | Noble | Ohio | 39121 | 1951 | 46 |
1789020 | 1789020 | 2021-10-06 | Park | Montana | 30067 | 1951 | 26 |
1774048 | 1774048 | 2021-10-01 | Windham | Vermont | 50025 | 1951 | 23 |
1770532 | 1770532 | 2021-09-30 | Camp | Texas | 48063 | 1951 | 61 |
1759537 | 1759537 | 2021-09-27 | Wadena | Minnesota | 27159 | 1951 | 27 |
1761021 | 1761021 | 2021-09-27 | Millard | Utah | 49027 | 1951 | 21 |
1755949 | 1755949 | 2021-09-26 | Leslie | Kentucky | 21131 | 1951 | 12 |
1757773 | 1757773 | 2021-09-26 | Millard | Utah | 49027 | 1951 | 21 |
1752701 | 1752701 | 2021-09-25 | Leslie | Kentucky | 21131 | 1951 | 12 |
1754525 | 1754525 | 2021-09-25 | Millard | Utah | 49027 | 1951 | 21 |
1749452 | 1749452 | 2021-09-24 | Leslie | Kentucky | 21131 | 1951 | 12 |
1751277 | 1751277 | 2021-09-24 | Millard | Utah | 49027 | 1951 | 21 |
1747176 | 1747176 | 2021-09-23 | Ramsey | North Dakota | 38071 | 1951 | 31 |
1738756 | 1738756 | 2021-09-21 | Chicot | Arkansas | 5017 | 1951 | 44 |
1732800 | 1732800 | 2021-09-19 | Massac | Illinois | 17127 | 1951 | 47 |
1729550 | 1729550 | 2021-09-18 | Massac | Illinois | 17127 | 1951 | 47 |
1726300 | 1726300 | 2021-09-17 | Massac | Illinois | 17127 | 1951 | 47 |
1728021 | 1728021 | 2021-09-17 | Morovis | Puerto Rico | 72101 | 1951 | |
1709898 | 1709898 | 2021-09-12 | Oglethorpe | Georgia | 13221 | 1951 | 35 |
1712338 | 1712338 | 2021-09-12 | Bristol city | Virginia | 51520 | 1951 | 41 |
1706651 | 1706651 | 2021-09-11 | Oglethorpe | Georgia | 13221 | 1951 | 35 |
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);