ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
260 rows where cases = 1974 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 22
- Kentucky 20
- Georgia 15
- Indiana 13
- Texas 13
- Missouri 12
- Tennessee 12
- Virginia 12
- Kansas 10
- Arkansas 9
- Mississippi 9
- Alabama 8
- Iowa 8
- North Dakota 8
- Michigan 7
- Puerto Rico 6
- West Virginia 6
- Colorado 5
- Florida 5
- North Carolina 5
- Utah 5
- Wyoming 5
- Illinois 4
- Maine 4
- Ohio 4
- Nebraska 3
- Nevada 3
- New Mexico 3
- New York 3
- Oregon 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2466884 | 2466884 | 2022-05-02 | Pendleton | West Virginia | 54071 | 1974 | 22 |
2451631 | 2451631 | 2022-04-28 | Clay | Kansas | 20027 | 1974 | 35 |
2452764 | 2452764 | 2022-04-28 | Pembina | North Dakota | 38067 | 1974 | 16 |
2448375 | 2448375 | 2022-04-27 | Clay | Kansas | 20027 | 1974 | 35 |
2449508 | 2449508 | 2022-04-27 | Pembina | North Dakota | 38067 | 1974 | 16 |
2445119 | 2445119 | 2022-04-26 | Clay | Kansas | 20027 | 1974 | 35 |
2446251 | 2446251 | 2022-04-26 | Pembina | North Dakota | 38067 | 1974 | 16 |
2441863 | 2441863 | 2022-04-25 | Clay | Kansas | 20027 | 1974 | 35 |
2442996 | 2442996 | 2022-04-25 | Pembina | North Dakota | 38067 | 1974 | 16 |
2438607 | 2438607 | 2022-04-24 | Clay | Kansas | 20027 | 1974 | 35 |
2439740 | 2439740 | 2022-04-24 | Pembina | North Dakota | 38067 | 1974 | 16 |
2435351 | 2435351 | 2022-04-23 | Clay | Kansas | 20027 | 1974 | 35 |
2436484 | 2436484 | 2022-04-23 | Pembina | North Dakota | 38067 | 1974 | 16 |
2432095 | 2432095 | 2022-04-22 | Clay | Kansas | 20027 | 1974 | 35 |
2433228 | 2433228 | 2022-04-22 | Pembina | North Dakota | 38067 | 1974 | 16 |
2337327 | 2337327 | 2022-03-24 | Taylor | Georgia | 13269 | 1974 | 52 |
2334073 | 2334073 | 2022-03-23 | Taylor | Georgia | 13269 | 1974 | 52 |
2283345 | 2283345 | 2022-03-07 | Quay | New Mexico | 35037 | 1974 | 49 |
2248686 | 2248686 | 2022-02-24 | Buena Vista city | Virginia | 51530 | 1974 | 39 |
2228598 | 2228598 | 2022-02-18 | Guayanilla | Puerto Rico | 72059 | 1974 | |
2224012 | 2224012 | 2022-02-17 | Crittenden | Kentucky | 21055 | 1974 | 42 |
2217043 | 2217043 | 2022-02-15 | Benewah | Idaho | 16009 | 1974 | 37 |
2215072 | 2215072 | 2022-02-14 | Sierra | New Mexico | 35051 | 1974 | 69 |
2211356 | 2211356 | 2022-02-13 | Murray | Minnesota | 27101 | 1974 | 15 |
2208103 | 2208103 | 2022-02-12 | Murray | Minnesota | 27101 | 1974 | 15 |
2204850 | 2204850 | 2022-02-11 | Murray | Minnesota | 27101 | 1974 | 15 |
2191899 | 2191899 | 2022-02-07 | Humphreys | Mississippi | 28053 | 1974 | 40 |
2193569 | 2193569 | 2022-02-07 | Gilmer | West Virginia | 54021 | 1974 | 17 |
2179162 | 2179162 | 2022-02-03 | Holt | Nebraska | 31089 | 1974 | 18 |
2173431 | 2173431 | 2022-02-01 | Grant | South Dakota | 46051 | 1974 | 48 |
2168100 | 2168100 | 2022-01-31 | Candler | Georgia | 13043 | 1974 | 91 |
2169304 | 2169304 | 2022-01-31 | Beaverhead | Montana | 30001 | 1974 | 24 |
2149707 | 2149707 | 2022-01-25 | Howard | Missouri | 29089 | 1974 | 22 |
2146339 | 2146339 | 2022-01-24 | Claiborne | Mississippi | 28021 | 1974 | 42 |
2057942 | 2057942 | 2021-12-28 | Franklin | Iowa | 19069 | 1974 | 35 |
2058308 | 2058308 | 2021-12-28 | Piscataquis | Maine | 23021 | 1974 | 19 |
2054693 | 2054693 | 2021-12-27 | Franklin | Iowa | 19069 | 1974 | 35 |
2051443 | 2051443 | 2021-12-26 | Franklin | Iowa | 19069 | 1974 | 35 |
2048193 | 2048193 | 2021-12-25 | Franklin | Iowa | 19069 | 1974 | 35 |
2044943 | 2044943 | 2021-12-24 | Franklin | Iowa | 19069 | 1974 | 35 |
2041694 | 2041694 | 2021-12-23 | Franklin | Iowa | 19069 | 1974 | 35 |
2038444 | 2038444 | 2021-12-22 | Franklin | Iowa | 19069 | 1974 | 35 |
2036600 | 2036600 | 2021-12-21 | Curry | Oregon | 41015 | 1974 | 39 |
2023703 | 2023703 | 2021-12-17 | Barranquitas | Puerto Rico | 72019 | 1974 | |
2005237 | 2005237 | 2021-12-12 | Desha | Arkansas | 5041 | 1974 | 33 |
2001986 | 2001986 | 2021-12-11 | Desha | Arkansas | 5041 | 1974 | 33 |
1997043 | 1997043 | 2021-12-09 | Colfax | Nebraska | 31037 | 1974 | 23 |
1967514 | 1967514 | 2021-11-30 | Watonwan | Minnesota | 27165 | 1974 | 20 |
1961505 | 1961505 | 2021-11-28 | Yates | New York | 36123 | 1974 | 33 |
1962656 | 1962656 | 2021-11-28 | Westmoreland | Virginia | 51193 | 1974 | 38 |
1959405 | 1959405 | 2021-11-27 | Westmoreland | Virginia | 51193 | 1974 | 38 |
1956154 | 1956154 | 2021-11-26 | Westmoreland | Virginia | 51193 | 1974 | 38 |
1946867 | 1946867 | 2021-11-24 | Gunnison | Colorado | 8051 | 1974 | 12 |
1946036 | 1946036 | 2021-11-23 | Duval | Texas | 48131 | 1974 | 59 |
1936285 | 1936285 | 2021-11-20 | Duval | Texas | 48131 | 1974 | 59 |
1929784 | 1929784 | 2021-11-18 | Duval | Texas | 48131 | 1974 | 59 |
1923749 | 1923749 | 2021-11-16 | Ashland | Wisconsin | 55003 | 1974 | 19 |
1918582 | 1918582 | 2021-11-15 | Nantucket | Massachusetts | 25019 | 1974 | 0 |
1915172 | 1915172 | 2021-11-14 | Martin | Kentucky | 21159 | 1974 | 36 |
1911922 | 1911922 | 2021-11-13 | Martin | Kentucky | 21159 | 1974 | 36 |
1908673 | 1908673 | 2021-11-12 | Martin | Kentucky | 21159 | 1974 | 36 |
1899436 | 1899436 | 2021-11-09 | Ripley | Missouri | 29181 | 1974 | 24 |
1895669 | 1895669 | 2021-11-08 | Lyon | Kentucky | 21143 | 1974 | 26 |
1892308 | 1892308 | 2021-11-07 | Nemaha | Kansas | 20131 | 1974 | 56 |
1892419 | 1892419 | 2021-11-07 | Lyon | Kentucky | 21143 | 1974 | 26 |
1889058 | 1889058 | 2021-11-06 | Nemaha | Kansas | 20131 | 1974 | 56 |
1889169 | 1889169 | 2021-11-06 | Lyon | Kentucky | 21143 | 1974 | 26 |
1885808 | 1885808 | 2021-11-05 | Nemaha | Kansas | 20131 | 1974 | 56 |
1885919 | 1885919 | 2021-11-05 | Lyon | Kentucky | 21143 | 1974 | 26 |
1855891 | 1855891 | 2021-10-27 | Moffat | Colorado | 8081 | 1974 | 42 |
1832837 | 1832837 | 2021-10-19 | Big Horn | Wyoming | 56003 | 1974 | 50 |
1815594 | 1815594 | 2021-10-14 | Baker | Oregon | 41001 | 1974 | 28 |
1795060 | 1795060 | 2021-10-08 | Franklin | Maine | 23007 | 1974 | 19 |
1788048 | 1788048 | 2021-10-06 | Piatt | Illinois | 17147 | 1974 | 20 |
1774270 | 1774270 | 2021-10-01 | Taylor | West Virginia | 54091 | 1974 | 35 |
1759166 | 1759166 | 2021-09-27 | Fleming | Kentucky | 21069 | 1974 | 28 |
1746163 | 1746163 | 2021-09-23 | Clinton | Kentucky | 21053 | 1974 | 33 |
1735471 | 1735471 | 2021-09-20 | North Slope Borough | Alaska | 2185 | 1974 | 4 |
1736859 | 1736859 | 2021-09-20 | Perry | Mississippi | 28111 | 1974 | 53 |
1712801 | 1712801 | 2021-09-13 | Marion | Arkansas | 5089 | 1974 | 54 |
1710753 | 1710753 | 2021-09-12 | Houston | Minnesota | 27055 | 1974 | 16 |
1707506 | 1707506 | 2021-09-11 | Houston | Minnesota | 27055 | 1974 | 16 |
1704259 | 1704259 | 2021-09-10 | Houston | Minnesota | 27055 | 1974 | 16 |
1689923 | 1689923 | 2021-09-06 | Cleburne | Alabama | 1029 | 1974 | 46 |
1690673 | 1690673 | 2021-09-06 | Parke | Indiana | 18121 | 1974 | 18 |
1687423 | 1687423 | 2021-09-05 | Parke | Indiana | 18121 | 1974 | 18 |
1684173 | 1684173 | 2021-09-04 | Parke | Indiana | 18121 | 1974 | 18 |
1680922 | 1680922 | 2021-09-03 | Parke | Indiana | 18121 | 1974 | 18 |
1667181 | 1667181 | 2021-08-30 | Clay | Alabama | 1027 | 1974 | 60 |
1669715 | 1669715 | 2021-08-30 | Decatur | Tennessee | 47039 | 1974 | 39 |
1652042 | 1652042 | 2021-08-25 | Union | Kentucky | 21225 | 1974 | 19 |
1648782 | 1648782 | 2021-08-24 | Rockcastle | Kentucky | 21203 | 1974 | 25 |
1644941 | 1644941 | 2021-08-23 | Rabun | Georgia | 13241 | 1974 | 52 |
1647313 | 1647313 | 2021-08-23 | Carbon | Utah | 49007 | 1974 | 20 |
1644064 | 1644064 | 2021-08-22 | Carbon | Utah | 49007 | 1974 | 20 |
1644412 | 1644412 | 2021-08-22 | Carbon | Wyoming | 56007 | 1974 | 29 |
1640814 | 1640814 | 2021-08-21 | Carbon | Utah | 49007 | 1974 | 20 |
1641162 | 1641162 | 2021-08-21 | Carbon | Wyoming | 56007 | 1974 | 29 |
1637912 | 1637912 | 2021-08-20 | Carbon | Wyoming | 56007 | 1974 | 29 |
1596470 | 1596470 | 2021-08-08 | Perry | Indiana | 18123 | 1974 | 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);