ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
347 rows where cases = 1521 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 37
- Georgia 21
- Texas 18
- Missouri 17
- Virginia 17
- Iowa 16
- North Carolina 15
- Kentucky 14
- Montana 14
- Mississippi 13
- Minnesota 11
- Kansas 10
- Michigan 9
- Nebraska 9
- Tennessee 9
- Indiana 8
- Louisiana 8
- Ohio 7
- Puerto Rico 7
- Vermont 7
- Alabama 6
- Arkansas 6
- Massachusetts 5
- Washington 5
- West Virginia 5
- New York 4
- North Dakota 4
- Oklahoma 4
- South Carolina 4
- South Dakota 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489556 | 2489556 | 2022-05-09 | Mathews | Virginia | 51115 | 1521 | 27 |
2441111 | 2441111 | 2022-04-25 | Montgomery | Arkansas | 5097 | 1521 | 57 |
2415512 | 2415512 | 2022-04-17 | Calhoun | Illinois | 17013 | 1521 | 8 |
2412256 | 2412256 | 2022-04-16 | Calhoun | Illinois | 17013 | 1521 | 8 |
2409000 | 2409000 | 2022-04-15 | Calhoun | Illinois | 17013 | 1521 | 8 |
2405744 | 2405744 | 2022-04-14 | Calhoun | Illinois | 17013 | 1521 | 8 |
2402489 | 2402489 | 2022-04-13 | Calhoun | Illinois | 17013 | 1521 | 8 |
2399234 | 2399234 | 2022-04-12 | Calhoun | Illinois | 17013 | 1521 | 8 |
2395979 | 2395979 | 2022-04-11 | Calhoun | Illinois | 17013 | 1521 | 8 |
2392723 | 2392723 | 2022-04-10 | Calhoun | Illinois | 17013 | 1521 | 8 |
2389467 | 2389467 | 2022-04-09 | Calhoun | Illinois | 17013 | 1521 | 8 |
2386212 | 2386212 | 2022-04-08 | Calhoun | Illinois | 17013 | 1521 | 8 |
2382957 | 2382957 | 2022-04-07 | Calhoun | Illinois | 17013 | 1521 | 8 |
2376448 | 2376448 | 2022-04-05 | Calhoun | Illinois | 17013 | 1521 | 8 |
2373196 | 2373196 | 2022-04-04 | Calhoun | Illinois | 17013 | 1521 | 8 |
2369943 | 2369943 | 2022-04-03 | Calhoun | Illinois | 17013 | 1521 | 8 |
2366690 | 2366690 | 2022-04-02 | Calhoun | Illinois | 17013 | 1521 | 8 |
2363437 | 2363437 | 2022-04-01 | Calhoun | Illinois | 17013 | 1521 | 8 |
2360183 | 2360183 | 2022-03-31 | Calhoun | Illinois | 17013 | 1521 | 8 |
2356929 | 2356929 | 2022-03-30 | Calhoun | Illinois | 17013 | 1521 | 8 |
2353676 | 2353676 | 2022-03-29 | Calhoun | Illinois | 17013 | 1521 | 8 |
2315627 | 2315627 | 2022-03-17 | Shelby | Missouri | 29205 | 1521 | 15 |
2246836 | 2246836 | 2022-02-24 | Owsley | Kentucky | 21189 | 1521 | 23 |
2243585 | 2243585 | 2022-02-23 | Owsley | Kentucky | 21189 | 1521 | 23 |
2200217 | 2200217 | 2022-02-09 | Weston | Wyoming | 56045 | 1521 | 17 |
2191869 | 2191869 | 2022-02-07 | Wilkin | Minnesota | 27167 | 1521 | 22 |
2192468 | 2192468 | 2022-02-07 | Bottineau | North Dakota | 38009 | 1521 | 24 |
2175715 | 2175715 | 2022-02-02 | Clark | Missouri | 29045 | 1521 | 28 |
2154085 | 2154085 | 2022-01-26 | Coleman | Texas | 48083 | 1521 | 64 |
2146489 | 2146489 | 2022-01-24 | Ozark | Missouri | 29153 | 1521 | 48 |
2143402 | 2143402 | 2022-01-23 | Richardson | Nebraska | 31147 | 1521 | 24 |
2140147 | 2140147 | 2022-01-22 | Richardson | Nebraska | 31147 | 1521 | 24 |
2136891 | 2136891 | 2022-01-21 | Richardson | Nebraska | 31147 | 1521 | 24 |
2134716 | 2134716 | 2022-01-20 | Refugio | Texas | 48391 | 1521 | 31 |
2131464 | 2131464 | 2022-01-19 | Refugio | Texas | 48391 | 1521 | 31 |
2121759 | 2121759 | 2022-01-16 | Winkler | Texas | 48495 | 1521 | 33 |
2110782 | 2110782 | 2022-01-13 | Powell | Montana | 30077 | 1521 | 26 |
2074476 | 2074476 | 2022-01-02 | Trimble | Kentucky | 21223 | 1521 | 28 |
2071225 | 2071225 | 2022-01-01 | Trimble | Kentucky | 21223 | 1521 | 28 |
2067974 | 2067974 | 2021-12-31 | Trimble | Kentucky | 21223 | 1521 | 28 |
2064723 | 2064723 | 2021-12-30 | Trimble | Kentucky | 21223 | 1521 | 28 |
2061473 | 2061473 | 2021-12-29 | Trimble | Kentucky | 21223 | 1521 | 28 |
2058798 | 2058798 | 2021-12-28 | Cheyenne | Nebraska | 31033 | 1521 | 19 |
2054338 | 2054338 | 2021-12-27 | Lanier | Georgia | 13173 | 1521 | 17 |
2053100 | 2053100 | 2021-12-26 | Grant | South Dakota | 46051 | 1521 | 47 |
2049850 | 2049850 | 2021-12-25 | Grant | South Dakota | 46051 | 1521 | 47 |
2046600 | 2046600 | 2021-12-24 | Grant | South Dakota | 46051 | 1521 | 47 |
2043350 | 2043350 | 2021-12-23 | Grant | South Dakota | 46051 | 1521 | 47 |
2034195 | 2034195 | 2021-12-20 | Lincoln | Washington | 53043 | 1521 | 25 |
2028326 | 2028326 | 2021-12-19 | Heard | Georgia | 13149 | 1521 | 42 |
2029697 | 2029697 | 2021-12-19 | Quay | New Mexico | 35037 | 1521 | 26 |
2030945 | 2030945 | 2021-12-19 | Lincoln | Washington | 53043 | 1521 | 25 |
2025075 | 2025075 | 2021-12-18 | Heard | Georgia | 13149 | 1521 | 42 |
2026446 | 2026446 | 2021-12-18 | Quay | New Mexico | 35037 | 1521 | 26 |
2027694 | 2027694 | 2021-12-18 | Lincoln | Washington | 53043 | 1521 | 25 |
2021824 | 2021824 | 2021-12-17 | Heard | Georgia | 13149 | 1521 | 42 |
2023195 | 2023195 | 2021-12-17 | Quay | New Mexico | 35037 | 1521 | 26 |
2024443 | 2024443 | 2021-12-17 | Lincoln | Washington | 53043 | 1521 | 25 |
2005888 | 2005888 | 2021-12-12 | Switzerland | Indiana | 18155 | 1521 | 13 |
2002637 | 2002637 | 2021-12-11 | Switzerland | Indiana | 18155 | 1521 | 13 |
1999387 | 1999387 | 2021-12-10 | Switzerland | Indiana | 18155 | 1521 | 13 |
1997065 | 1997065 | 2021-12-09 | Hamilton | Nebraska | 31081 | 1521 | 19 |
1989775 | 1989775 | 2021-12-07 | Ellsworth | Kansas | 20053 | 1521 | 31 |
1989923 | 1989923 | 2021-12-07 | Livingston | Kentucky | 21139 | 1521 | 46 |
1990366 | 1990366 | 2021-12-07 | Carroll | Missouri | 29033 | 1521 | 39 |
1986525 | 1986525 | 2021-12-06 | Ellsworth | Kansas | 20053 | 1521 | 31 |
1964510 | 1964510 | 2021-11-29 | Sanders | Montana | 30089 | 1521 | 29 |
1938094 | 1938094 | 2021-11-21 | Baraga | Michigan | 26013 | 1521 | 47 |
1934844 | 1934844 | 2021-11-20 | Baraga | Michigan | 26013 | 1521 | 47 |
1931594 | 1931594 | 2021-11-19 | Baraga | Michigan | 26013 | 1521 | 47 |
1910849 | 1910849 | 2021-11-13 | Bullock | Alabama | 1011 | 1521 | 44 |
1911444 | 1911444 | 2021-11-13 | Valley | Idaho | 16085 | 1521 | 13 |
1898364 | 1898364 | 2021-11-09 | Stewart | Georgia | 13259 | 1521 | 28 |
1899249 | 1899249 | 2021-11-09 | Swift | Minnesota | 27151 | 1521 | 20 |
1884411 | 1884411 | 2021-11-04 | Rains | Texas | 48379 | 1521 | 47 |
1881162 | 1881162 | 2021-11-03 | Rains | Texas | 48379 | 1521 | 47 |
1877913 | 1877913 | 2021-11-02 | Rains | Texas | 48379 | 1521 | 47 |
1869309 | 1869309 | 2021-10-31 | Benton | Indiana | 18007 | 1521 | 17 |
1866060 | 1866060 | 2021-10-30 | Benton | Indiana | 18007 | 1521 | 17 |
1867029 | 1867029 | 2021-10-30 | Box Butte | Nebraska | 31013 | 1521 | 12 |
1862811 | 1862811 | 2021-10-29 | Benton | Indiana | 18007 | 1521 | 17 |
1863780 | 1863780 | 2021-10-29 | Box Butte | Nebraska | 31013 | 1521 | 12 |
1852192 | 1852192 | 2021-10-25 | Pend Oreille | Washington | 53051 | 1521 | 22 |
1818200 | 1818200 | 2021-10-15 | Ralls | Missouri | 29173 | 1521 | 14 |
1806959 | 1806959 | 2021-10-12 | Valdez-Cordova Census Area | Alaska | 2261 | 1521 | 5 |
1807446 | 1807446 | 2021-10-12 | Franklin | Idaho | 16041 | 1521 | 21 |
1808159 | 1808159 | 2021-10-12 | Luce | Michigan | 26095 | 1521 | 6 |
1804908 | 1804908 | 2021-10-11 | Luce | Michigan | 26095 | 1521 | 6 |
1806866 | 1806866 | 2021-10-11 | Washakie | Wyoming | 56043 | 1521 | 29 |
1791170 | 1791170 | 2021-10-07 | Wilkes | Georgia | 13317 | 1521 | 34 |
1789516 | 1789516 | 2021-10-06 | Vinton | Ohio | 39163 | 1521 | 21 |
1786123 | 1786123 | 2021-10-05 | Washington | North Carolina | 37187 | 1521 | 35 |
1786786 | 1786786 | 2021-10-05 | Childress | Texas | 48075 | 1521 | 20 |
1772662 | 1772662 | 2021-10-01 | Grundy | Missouri | 29079 | 1521 | 47 |
1768349 | 1768349 | 2021-09-30 | Johnson | Georgia | 13167 | 1521 | 57 |
1765100 | 1765100 | 2021-09-29 | Johnson | Georgia | 13167 | 1521 | 57 |
1739437 | 1739437 | 2021-09-21 | Appanoose | Iowa | 19007 | 1521 | 49 |
1740670 | 1740670 | 2021-09-21 | McLean | North Dakota | 38055 | 1521 | 32 |
1736188 | 1736188 | 2021-09-20 | Appanoose | Iowa | 19007 | 1521 | 49 |
1732938 | 1732938 | 2021-09-19 | Appanoose | Iowa | 19007 | 1521 | 49 |
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);