ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
230 rows where cases = 2521 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 22
- Georgia 21
- Missouri 15
- Kentucky 14
- Tennessee 12
- Louisiana 11
- Arkansas 10
- Florida 10
- Mississippi 10
- Oklahoma 9
- Montana 7
- Colorado 6
- Illinois 6
- North Carolina 6
- Puerto Rico 6
- Wisconsin 6
- Minnesota 5
- Ohio 5
- Oregon 5
- Kansas 4
- South Carolina 4
- Virginia 4
- Iowa 3
- Michigan 3
- New Mexico 3
- West Virginia 3
- Alabama 2
- Idaho 2
- Indiana 2
- New York 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500407 | 2500407 | 2022-05-13 | Franklin | Iowa | 19069 | 2521 | 42 |
2497149 | 2497149 | 2022-05-12 | Franklin | Iowa | 19069 | 2521 | 42 |
2493891 | 2493891 | 2022-05-11 | Franklin | Iowa | 19069 | 2521 | 42 |
2486707 | 2486707 | 2022-05-09 | Perry | Arkansas | 5105 | 2521 | 37 |
2483449 | 2483449 | 2022-05-08 | Perry | Arkansas | 5105 | 2521 | 37 |
2437243 | 2437243 | 2022-04-23 | Morris | Texas | 48343 | 2521 | 73 |
2417283 | 2417283 | 2022-04-17 | Lajas | Puerto Rico | 72079 | 2521 | |
2369585 | 2369585 | 2022-04-03 | Bent | Colorado | 8011 | 2521 | 47 |
2366332 | 2366332 | 2022-04-02 | Bent | Colorado | 8011 | 2521 | 47 |
2363079 | 2363079 | 2022-04-01 | Bent | Colorado | 8011 | 2521 | 47 |
2361979 | 2361979 | 2022-03-31 | Santa Isabel | Puerto Rico | 72133 | 2521 | |
2359178 | 2359178 | 2022-03-30 | Trinity | Texas | 48455 | 2521 | 72 |
2316674 | 2316674 | 2022-03-17 | Blanco | Texas | 48031 | 2521 | 34 |
2292404 | 2292404 | 2022-03-10 | East Carroll | Louisiana | 22035 | 2521 | 38 |
2289152 | 2289152 | 2022-03-09 | East Carroll | Louisiana | 22035 | 2521 | 38 |
2283067 | 2283067 | 2022-03-07 | Linn | Missouri | 29115 | 2521 | 62 |
2266278 | 2266278 | 2022-03-02 | Edmonson | Kentucky | 21061 | 2521 | 38 |
2263027 | 2263027 | 2022-03-01 | Edmonson | Kentucky | 21061 | 2521 | 38 |
2258909 | 2258909 | 2022-02-28 | Pike | Arkansas | 5109 | 2521 | 40 |
2241272 | 2241272 | 2022-02-22 | Mercer | North Dakota | 38057 | 2521 | 24 |
2237643 | 2237643 | 2022-02-21 | Richland | Montana | 30083 | 2521 | 30 |
2234392 | 2234392 | 2022-02-20 | Richland | Montana | 30083 | 2521 | 30 |
2231141 | 2231141 | 2022-02-19 | Richland | Montana | 30083 | 2521 | 30 |
2227890 | 2227890 | 2022-02-18 | Richland | Montana | 30083 | 2521 | 30 |
2198367 | 2198367 | 2022-02-09 | Stevens | Minnesota | 27149 | 2521 | 13 |
2126859 | 2126859 | 2022-01-18 | Perry | Mississippi | 28111 | 2521 | 57 |
2103876 | 2103876 | 2022-01-11 | Arenac | Michigan | 26011 | 2521 | 55 |
2100625 | 2100625 | 2022-01-10 | Arenac | Michigan | 26011 | 2521 | 55 |
2087332 | 2087332 | 2022-01-06 | Nemaha | Kansas | 20131 | 2521 | 58 |
2084080 | 2084080 | 2022-01-05 | Nemaha | Kansas | 20131 | 2521 | 58 |
2080124 | 2080124 | 2022-01-04 | Crowley | Colorado | 8025 | 2521 | 27 |
2058645 | 2058645 | 2021-12-28 | Gasconade | Missouri | 29073 | 2521 | 87 |
2060315 | 2060315 | 2021-12-28 | Price | Wisconsin | 55099 | 2521 | 22 |
2047517 | 2047517 | 2021-12-25 | Marion | Arkansas | 5089 | 2521 | 70 |
2034518 | 2034518 | 2021-12-21 | Marion | Arkansas | 5089 | 2521 | 69 |
2024230 | 2024230 | 2021-12-17 | Wilbarger | Texas | 48487 | 2521 | 72 |
2017409 | 2017409 | 2021-12-15 | Decatur | Tennessee | 47039 | 2521 | 44 |
2007105 | 2007105 | 2021-12-12 | Warren | North Carolina | 37185 | 2521 | 33 |
2003854 | 2003854 | 2021-12-11 | Warren | North Carolina | 37185 | 2521 | 33 |
2000603 | 2000603 | 2021-12-10 | Warren | North Carolina | 37185 | 2521 | 33 |
1996547 | 1996547 | 2021-12-09 | Knox | Maine | 23013 | 2521 | 17 |
1993178 | 1993178 | 2021-12-08 | Magoffin | Kentucky | 21153 | 2521 | 31 |
1995215 | 1995215 | 2021-12-08 | Grant | West Virginia | 54023 | 2521 | 42 |
1986730 | 1986730 | 2021-12-06 | Bienville | Louisiana | 22013 | 2521 | 99 |
1970737 | 1970737 | 2021-12-01 | Pennington | Minnesota | 27113 | 2521 | 30 |
1960718 | 1960718 | 2021-11-28 | Webster | Kentucky | 21233 | 2521 | 42 |
1957467 | 1957467 | 2021-11-27 | Webster | Kentucky | 21233 | 2521 | 42 |
1954216 | 1954216 | 2021-11-26 | Webster | Kentucky | 21233 | 2521 | 42 |
1950965 | 1950965 | 2021-11-25 | Webster | Kentucky | 21233 | 2521 | 42 |
1947714 | 1947714 | 2021-11-24 | Webster | Kentucky | 21233 | 2521 | 42 |
1944244 | 1944244 | 2021-11-23 | Atchison | Kansas | 20005 | 2521 | 27 |
1940994 | 1940994 | 2021-11-22 | Atchison | Kansas | 20005 | 2521 | 27 |
1905737 | 1905737 | 2021-11-11 | Renville | Minnesota | 27129 | 2521 | 51 |
1907224 | 1907224 | 2021-11-11 | Zavala | Texas | 48507 | 2521 | 55 |
1903975 | 1903975 | 2021-11-10 | Zavala | Texas | 48507 | 2521 | 55 |
1900725 | 1900725 | 2021-11-09 | Zavala | Texas | 48507 | 2521 | 55 |
1897475 | 1897475 | 2021-11-08 | Zavala | Texas | 48507 | 2521 | 55 |
1894225 | 1894225 | 2021-11-07 | Zavala | Texas | 48507 | 2521 | 55 |
1890975 | 1890975 | 2021-11-06 | Zavala | Texas | 48507 | 2521 | 55 |
1887725 | 1887725 | 2021-11-05 | Zavala | Texas | 48507 | 2521 | 54 |
1884475 | 1884475 | 2021-11-04 | Zavala | Texas | 48507 | 2521 | 54 |
1881226 | 1881226 | 2021-11-03 | Zavala | Texas | 48507 | 2521 | 54 |
1877977 | 1877977 | 2021-11-02 | Zavala | Texas | 48507 | 2521 | 54 |
1874728 | 1874728 | 2021-11-01 | Zavala | Texas | 48507 | 2521 | 54 |
1871479 | 1871479 | 2021-10-31 | Zavala | Texas | 48507 | 2521 | 54 |
1868230 | 1868230 | 2021-10-30 | Zavala | Texas | 48507 | 2521 | 54 |
1864981 | 1864981 | 2021-10-29 | Zavala | Texas | 48507 | 2521 | 54 |
1861732 | 1861732 | 2021-10-28 | Zavala | Texas | 48507 | 2521 | 54 |
1856705 | 1856705 | 2021-10-27 | Powell | Kentucky | 21197 | 2521 | 22 |
1857186 | 1857186 | 2021-10-27 | Pike | Missouri | 29163 | 2521 | 37 |
1853456 | 1853456 | 2021-10-26 | Powell | Kentucky | 21197 | 2521 | 22 |
1849067 | 1849067 | 2021-10-24 | Sawyer | Wisconsin | 55113 | 2521 | 31 |
1842750 | 1842750 | 2021-10-23 | Izard | Arkansas | 5065 | 2521 | 55 |
1845817 | 1845817 | 2021-10-23 | Sawyer | Wisconsin | 55113 | 2521 | 31 |
1842567 | 1842567 | 2021-10-22 | Sawyer | Wisconsin | 55113 | 2521 | 31 |
1811731 | 1811731 | 2021-10-13 | Wright | Missouri | 29229 | 2521 | 47 |
1787987 | 1787987 | 2021-10-06 | Clay | Illinois | 17025 | 2521 | 56 |
1781455 | 1781455 | 2021-10-04 | Gem | Idaho | 16045 | 2521 | 52 |
1732259 | 1732259 | 2021-09-19 | Clay | Arkansas | 5021 | 2521 | 54 |
1733324 | 1733324 | 2021-09-19 | Winn | Louisiana | 22127 | 2521 | 57 |
1733975 | 1733975 | 2021-09-19 | Roosevelt | New Mexico | 35041 | 2521 | 65 |
1730074 | 1730074 | 2021-09-18 | Winn | Louisiana | 22127 | 2521 | 57 |
1730725 | 1730725 | 2021-09-18 | Roosevelt | New Mexico | 35041 | 2521 | 65 |
1726824 | 1726824 | 2021-09-17 | Winn | Louisiana | 22127 | 2521 | 57 |
1727475 | 1727475 | 2021-09-17 | Roosevelt | New Mexico | 35041 | 2521 | 65 |
1722860 | 1722860 | 2021-09-16 | Jefferson | Georgia | 13163 | 2521 | 74 |
1718087 | 1718087 | 2021-09-14 | Marshall | Oklahoma | 40095 | 2521 | 25 |
1714839 | 1714839 | 2021-09-13 | Marshall | Oklahoma | 40095 | 2521 | 25 |
1709533 | 1709533 | 2021-09-12 | Franklin | Arkansas | 5047 | 2521 | 47 |
1711593 | 1711593 | 2021-09-12 | Marshall | Oklahoma | 40095 | 2521 | 25 |
1708346 | 1708346 | 2021-09-11 | Marshall | Oklahoma | 40095 | 2521 | 25 |
1705099 | 1705099 | 2021-09-10 | Marshall | Oklahoma | 40095 | 2521 | 25 |
1700352 | 1700352 | 2021-09-09 | Wayne | Illinois | 17191 | 2521 | 56 |
1701849 | 1701849 | 2021-09-09 | Marshall | Oklahoma | 40095 | 2521 | 25 |
1698600 | 1698600 | 2021-09-08 | Marshall | Oklahoma | 40095 | 2521 | 25 |
1667299 | 1667299 | 2021-08-30 | Drew | Arkansas | 5043 | 2521 | 52 |
1668255 | 1668255 | 2021-08-30 | Morgan | Kentucky | 21175 | 2521 | 5 |
1643415 | 1643415 | 2021-08-22 | Columbia | Oregon | 41009 | 2521 | 33 |
1640165 | 1640165 | 2021-08-21 | Columbia | Oregon | 41009 | 2521 | 33 |
1636915 | 1636915 | 2021-08-20 | Columbia | Oregon | 41009 | 2521 | 33 |
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);