ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
327 rows where cases = 1798 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 30
- Missouri 26
- Illinois 19
- Indiana 19
- Oklahoma 19
- Texas 18
- Georgia 14
- North Carolina 14
- Puerto Rico 14
- Minnesota 13
- Arkansas 12
- Tennessee 11
- Kentucky 10
- Virginia 9
- Ohio 7
- Wisconsin 7
- Alabama 6
- Mississippi 6
- Montana 6
- Florida 5
- Louisiana 5
- Nebraska 5
- New York 5
- Colorado 4
- Michigan 4
- South Carolina 4
- South Dakota 4
- West Virginia 4
- Alaska 3
- Idaho 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499263 | 2499263 | 2022-05-12 | Bland | Virginia | 51021 | 1798 | 24 |
2496005 | 2496005 | 2022-05-11 | Bland | Virginia | 51021 | 1798 | 24 |
2491561 | 2491561 | 2022-05-10 | Thurston | Nebraska | 31173 | 1798 | 23 |
2487916 | 2487916 | 2022-05-09 | Mahnomen | Minnesota | 27087 | 1798 | 17 |
2488303 | 2488303 | 2022-05-09 | Thurston | Nebraska | 31173 | 1798 | 23 |
2331139 | 2331139 | 2022-03-22 | Ida | Iowa | 19093 | 1798 | 48 |
2327887 | 2327887 | 2022-03-21 | Ida | Iowa | 19093 | 1798 | 48 |
2324634 | 2324634 | 2022-03-20 | Ida | Iowa | 19093 | 1798 | 48 |
2321380 | 2321380 | 2022-03-19 | Ida | Iowa | 19093 | 1798 | 48 |
2318126 | 2318126 | 2022-03-18 | Ida | Iowa | 19093 | 1798 | 48 |
2314873 | 2314873 | 2022-03-17 | Ida | Iowa | 19093 | 1798 | 48 |
2311620 | 2311620 | 2022-03-16 | Ida | Iowa | 19093 | 1798 | 48 |
2310535 | 2310535 | 2022-03-15 | Middlesex | Virginia | 51119 | 1798 | 45 |
2306960 | 2306960 | 2022-03-14 | Delta | Texas | 48119 | 1798 | 25 |
2307282 | 2307282 | 2022-03-14 | Middlesex | Virginia | 51119 | 1798 | 45 |
2303709 | 2303709 | 2022-03-13 | Delta | Texas | 48119 | 1798 | 25 |
2287249 | 2287249 | 2022-03-08 | Fall River | South Dakota | 46047 | 1798 | 39 |
2270141 | 2270141 | 2022-03-03 | Madison | Montana | 30057 | 1798 | 20 |
2266784 | 2266784 | 2022-03-02 | Harrison | Missouri | 29081 | 1798 | 30 |
2266888 | 2266888 | 2022-03-02 | Madison | Montana | 30057 | 1798 | 20 |
2263533 | 2263533 | 2022-03-01 | Harrison | Missouri | 29081 | 1798 | 30 |
2263637 | 2263637 | 2022-03-01 | Madison | Montana | 30057 | 1798 | 20 |
2260434 | 2260434 | 2022-02-28 | Cuming | Nebraska | 31039 | 1798 | 15 |
2238328 | 2238328 | 2022-02-21 | Arroyo | Puerto Rico | 72015 | 1798 | |
2216046 | 2216046 | 2022-02-14 | Rains | Texas | 48379 | 1798 | 55 |
2216104 | 2216104 | 2022-02-14 | Winkler | Texas | 48495 | 1798 | 34 |
2212853 | 2212853 | 2022-02-13 | Winkler | Texas | 48495 | 1798 | 34 |
2209600 | 2209600 | 2022-02-12 | Winkler | Texas | 48495 | 1798 | 34 |
2194956 | 2194956 | 2022-02-08 | Alger | Michigan | 26003 | 1798 | 12 |
2190765 | 2190765 | 2022-02-07 | Yuma | Colorado | 8125 | 1798 | 22 |
2191702 | 2191702 | 2022-02-07 | Alger | Michigan | 26003 | 1798 | 12 |
2165463 | 2165463 | 2022-01-30 | Crittenden | Kentucky | 21055 | 1798 | 39 |
2162208 | 2162208 | 2022-01-29 | Crittenden | Kentucky | 21055 | 1798 | 39 |
2158953 | 2158953 | 2022-01-28 | Crittenden | Kentucky | 21055 | 1798 | 39 |
2146511 | 2146511 | 2022-01-24 | St. Clair | Missouri | 29185 | 1798 | 29 |
2142448 | 2142448 | 2022-01-23 | Warren | Indiana | 18171 | 1798 | 24 |
2139193 | 2139193 | 2022-01-22 | Warren | Indiana | 18171 | 1798 | 24 |
2135937 | 2135937 | 2022-01-21 | Warren | Indiana | 18171 | 1798 | 24 |
2132317 | 2132317 | 2022-01-20 | Clinch | Georgia | 13065 | 1798 | 36 |
2125780 | 2125780 | 2022-01-18 | Atkinson | Georgia | 13003 | 1798 | 39 |
2109729 | 2109729 | 2022-01-13 | Valley | Idaho | 16085 | 1798 | 13 |
2112237 | 2112237 | 2022-01-13 | Clay | West Virginia | 54015 | 1798 | 29 |
2099539 | 2099539 | 2022-01-10 | Perry | Arkansas | 5105 | 1798 | 26 |
2049772 | 2049772 | 2021-12-25 | Yabucoa | Puerto Rico | 72151 | 1798 | |
2040905 | 2040905 | 2021-12-23 | Lowndes | Alabama | 1085 | 1798 | 68 |
2031178 | 2031178 | 2021-12-20 | Wilcox | Alabama | 1131 | 1798 | 38 |
2029448 | 2029448 | 2021-12-19 | Ralls | Missouri | 29173 | 1798 | 19 |
2030330 | 2030330 | 2021-12-19 | Bon Homme | South Dakota | 46009 | 1798 | 31 |
2027079 | 2027079 | 2021-12-18 | Bon Homme | South Dakota | 46009 | 1798 | 31 |
2023828 | 2023828 | 2021-12-17 | Bon Homme | South Dakota | 46009 | 1798 | 31 |
2009894 | 2009894 | 2021-12-13 | Grundy | Missouri | 29079 | 1798 | 55 |
2005747 | 2005747 | 2021-12-12 | Jasper | Illinois | 17079 | 1798 | 23 |
2006643 | 2006643 | 2021-12-12 | Grundy | Missouri | 29079 | 1798 | 55 |
2002496 | 2002496 | 2021-12-11 | Jasper | Illinois | 17079 | 1798 | 23 |
1999246 | 1999246 | 2021-12-10 | Jasper | Illinois | 17079 | 1798 | 23 |
1996748 | 1996748 | 2021-12-09 | Rock | Minnesota | 27133 | 1798 | 31 |
1986313 | 1986313 | 2021-12-06 | Brown | Indiana | 18013 | 1798 | 51 |
1974227 | 1974227 | 2021-12-02 | Dawson | Montana | 30021 | 1798 | 49 |
1966918 | 1966918 | 2021-11-30 | Chickasaw | Iowa | 19037 | 1798 | 22 |
1963666 | 1963666 | 2021-11-29 | Chickasaw | Iowa | 19037 | 1798 | 22 |
1960415 | 1960415 | 2021-11-28 | Chickasaw | Iowa | 19037 | 1798 | 22 |
1957164 | 1957164 | 2021-11-27 | Chickasaw | Iowa | 19037 | 1798 | 22 |
1953913 | 1953913 | 2021-11-26 | Chickasaw | Iowa | 19037 | 1798 | 22 |
1950662 | 1950662 | 2021-11-25 | Chickasaw | Iowa | 19037 | 1798 | 22 |
1947411 | 1947411 | 2021-11-24 | Chickasaw | Iowa | 19037 | 1798 | 22 |
1940343 | 1940343 | 2021-11-22 | Archuleta | Colorado | 8007 | 1798 | 7 |
1912350 | 1912350 | 2021-11-13 | Bollinger | Missouri | 29017 | 1798 | 21 |
1909100 | 1909100 | 2021-11-12 | Bollinger | Missouri | 29017 | 1798 | 20 |
1905563 | 1905563 | 2021-11-11 | Kent | Maryland | 24029 | 1798 | 56 |
1903442 | 1903442 | 2021-11-10 | Camuy | Puerto Rico | 72027 | 1798 | |
1900192 | 1900192 | 2021-11-09 | Camuy | Puerto Rico | 72027 | 1798 | |
1896942 | 1896942 | 2021-11-08 | Camuy | Puerto Rico | 72027 | 1798 | |
1893692 | 1893692 | 2021-11-07 | Camuy | Puerto Rico | 72027 | 1798 | |
1868685 | 1868685 | 2021-10-31 | Northwest Arctic Borough | Alaska | 2188 | 1798 | 7 |
1869115 | 1869115 | 2021-10-31 | Screven | Georgia | 13251 | 1798 | 60 |
1865436 | 1865436 | 2021-10-30 | Northwest Arctic Borough | Alaska | 2188 | 1798 | 7 |
1865866 | 1865866 | 2021-10-30 | Screven | Georgia | 13251 | 1798 | 60 |
1862187 | 1862187 | 2021-10-29 | Northwest Arctic Borough | Alaska | 2188 | 1798 | 7 |
1862617 | 1862617 | 2021-10-29 | Screven | Georgia | 13251 | 1798 | 60 |
1859368 | 1859368 | 2021-10-28 | Screven | Georgia | 13251 | 1798 | 58 |
1853550 | 1853550 | 2021-10-26 | Lincoln | Maine | 23015 | 1798 | 6 |
1835095 | 1835095 | 2021-10-20 | Curry | Oregon | 41015 | 1798 | 25 |
1789108 | 1789108 | 2021-10-06 | Otoe | Nebraska | 31131 | 1798 | 13 |
1789491 | 1789491 | 2021-10-06 | Morgan | Ohio | 39115 | 1798 | 30 |
1786305 | 1786305 | 2021-10-05 | Haskell | Oklahoma | 40061 | 1798 | 25 |
1783056 | 1783056 | 2021-10-04 | Haskell | Oklahoma | 40061 | 1798 | 25 |
1783737 | 1783737 | 2021-10-04 | Ward | Texas | 48475 | 1798 | 26 |
1779182 | 1779182 | 2021-10-03 | Linn | Missouri | 29115 | 1798 | 25 |
1779807 | 1779807 | 2021-10-03 | Haskell | Oklahoma | 40061 | 1798 | 25 |
1775932 | 1775932 | 2021-10-02 | Linn | Missouri | 29115 | 1798 | 25 |
1776557 | 1776557 | 2021-10-02 | Haskell | Oklahoma | 40061 | 1798 | 25 |
1773307 | 1773307 | 2021-10-01 | Haskell | Oklahoma | 40061 | 1798 | 25 |
1769466 | 1769466 | 2021-09-30 | Ripley | Missouri | 29181 | 1798 | 21 |
1770057 | 1770057 | 2021-09-30 | Haskell | Oklahoma | 40061 | 1798 | 25 |
1766157 | 1766157 | 2021-09-29 | Dent | Missouri | 29065 | 1798 | 33 |
1766808 | 1766808 | 2021-09-29 | Haskell | Oklahoma | 40061 | 1798 | 25 |
1762845 | 1762845 | 2021-09-28 | Noxubee | Mississippi | 28103 | 1798 | 40 |
1763580 | 1763580 | 2021-09-28 | Noble | Oklahoma | 40103 | 1798 | 27 |
1760331 | 1760331 | 2021-09-27 | Noble | Oklahoma | 40103 | 1798 | 27 |
1755501 | 1755501 | 2021-09-26 | Cumberland | Illinois | 17035 | 1798 | 37 |
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);