ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
419 rows where cases = 1128 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 36
- Georgia 33
- Iowa 29
- North Carolina 19
- Kentucky 18
- Louisiana 18
- Virginia 18
- Arkansas 17
- Missouri 16
- Nebraska 16
- Illinois 15
- Kansas 14
- Alabama 13
- Minnesota 12
- Montana 12
- Washington 11
- Oklahoma 10
- Puerto Rico 9
- Indiana 8
- Mississippi 8
- Rhode Island 7
- Tennessee 7
- Idaho 6
- Michigan 6
- North Dakota 6
- West Virginia 6
- Colorado 5
- Wisconsin 5
- Wyoming 5
- New Mexico 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502539 | 2502539 | 2022-05-13 | Craig | Virginia | 51045 | 1128 | 18 |
2499281 | 2499281 | 2022-05-12 | Craig | Virginia | 51045 | 1128 | 18 |
2494467 | 2494467 | 2022-05-11 | Unknown | Minnesota | 1128 | 290 | |
2496023 | 2496023 | 2022-05-11 | Craig | Virginia | 51045 | 1128 | 18 |
2406839 | 2406839 | 2022-04-14 | Fillmore | Nebraska | 31059 | 1128 | 13 |
2403583 | 2403583 | 2022-04-13 | Fillmore | Nebraska | 31059 | 1128 | 13 |
2400328 | 2400328 | 2022-04-12 | Fillmore | Nebraska | 31059 | 1128 | 13 |
2397073 | 2397073 | 2022-04-11 | Fillmore | Nebraska | 31059 | 1128 | 13 |
2393818 | 2393818 | 2022-04-10 | Fillmore | Nebraska | 31059 | 1128 | 13 |
2390562 | 2390562 | 2022-04-09 | Fillmore | Nebraska | 31059 | 1128 | 13 |
2387306 | 2387306 | 2022-04-08 | Fillmore | Nebraska | 31059 | 1128 | 13 |
2384051 | 2384051 | 2022-04-07 | Fillmore | Nebraska | 31059 | 1128 | 13 |
2347242 | 2347242 | 2022-03-27 | Putnam | Illinois | 17155 | 1128 | 10 |
2343989 | 2343989 | 2022-03-26 | Putnam | Illinois | 17155 | 1128 | 10 |
2340736 | 2340736 | 2022-03-25 | Putnam | Illinois | 17155 | 1128 | 10 |
2337483 | 2337483 | 2022-03-24 | Putnam | Illinois | 17155 | 1128 | 10 |
2331172 | 2331172 | 2022-03-22 | Ringgold | Iowa | 19159 | 1128 | 33 |
2327920 | 2327920 | 2022-03-21 | Ringgold | Iowa | 19159 | 1128 | 33 |
2324667 | 2324667 | 2022-03-20 | Ringgold | Iowa | 19159 | 1128 | 33 |
2321413 | 2321413 | 2022-03-19 | Ringgold | Iowa | 19159 | 1128 | 33 |
2318159 | 2318159 | 2022-03-18 | Ringgold | Iowa | 19159 | 1128 | 33 |
2314906 | 2314906 | 2022-03-17 | Ringgold | Iowa | 19159 | 1128 | 33 |
2311653 | 2311653 | 2022-03-16 | Ringgold | Iowa | 19159 | 1128 | 33 |
2266946 | 2266946 | 2022-03-02 | Fillmore | Nebraska | 31059 | 1128 | 13 |
2263695 | 2263695 | 2022-03-01 | Fillmore | Nebraska | 31059 | 1128 | 13 |
2265083 | 2265083 | 2022-03-01 | San Juan | Washington | 53055 | 1128 | 1 |
2261833 | 2261833 | 2022-02-28 | San Juan | Washington | 53055 | 1128 | 1 |
2246729 | 2246729 | 2022-02-24 | Stafford | Kansas | 20185 | 1128 | 26 |
2247457 | 2247457 | 2022-02-24 | Howard | Nebraska | 31093 | 1128 | 15 |
2243478 | 2243478 | 2022-02-23 | Stafford | Kansas | 20185 | 1128 | 26 |
2219431 | 2219431 | 2022-02-15 | Charles City | Virginia | 51036 | 1128 | 26 |
2219717 | 2219717 | 2022-02-15 | Hot Springs | Wyoming | 56017 | 1128 | 14 |
2214881 | 2214881 | 2022-02-14 | Pondera | Montana | 30073 | 1128 | 6 |
2206341 | 2206341 | 2022-02-11 | Wheeler | Texas | 48483 | 1128 | 19 |
2200739 | 2200739 | 2022-02-10 | Talbot | Georgia | 13263 | 1128 | 31 |
2179179 | 2179179 | 2022-02-03 | Morrill | Nebraska | 31123 | 1128 | 17 |
2156335 | 2156335 | 2022-01-27 | Toole | Montana | 30101 | 1128 | 22 |
2145322 | 2145322 | 2022-01-24 | Calhoun | Georgia | 13037 | 1128 | 22 |
2134376 | 2134376 | 2022-01-20 | Day | South Dakota | 46037 | 1128 | 32 |
2131735 | 2131735 | 2022-01-19 | Skamania | Washington | 53059 | 1128 | 10 |
2104669 | 2104669 | 2022-01-11 | Ransom | North Dakota | 38073 | 1128 | 23 |
2008213 | 2008213 | 2021-12-12 | Calhoun | West Virginia | 54013 | 1128 | 9 |
1974295 | 1974295 | 2021-12-02 | Dawes | Nebraska | 31045 | 1128 | 21 |
1975200 | 1975200 | 2021-12-02 | Pickett | Tennessee | 47137 | 1128 | 26 |
1967631 | 1967631 | 2021-11-30 | Daviess | Missouri | 29061 | 1128 | 17 |
1964868 | 1964868 | 2021-11-29 | Dickey | North Dakota | 38021 | 1128 | 36 |
1959879 | 1959879 | 2021-11-28 | Lake | Colorado | 8065 | 1128 | 1 |
1961616 | 1961616 | 2021-11-28 | Dickey | North Dakota | 38021 | 1128 | 36 |
1962249 | 1962249 | 2021-11-28 | Brooks | Texas | 48047 | 1128 | 47 |
1956628 | 1956628 | 2021-11-27 | Lake | Colorado | 8065 | 1128 | 1 |
1958998 | 1958998 | 2021-11-27 | Brooks | Texas | 48047 | 1128 | 47 |
1953377 | 1953377 | 2021-11-26 | Lake | Colorado | 8065 | 1128 | 1 |
1955747 | 1955747 | 2021-11-26 | Brooks | Texas | 48047 | 1128 | 47 |
1950126 | 1950126 | 2021-11-25 | Lake | Colorado | 8065 | 1128 | 1 |
1952496 | 1952496 | 2021-11-25 | Brooks | Texas | 48047 | 1128 | 47 |
1949245 | 1949245 | 2021-11-24 | Brooks | Texas | 48047 | 1128 | 47 |
1945287 | 1945287 | 2021-11-23 | Gates | North Carolina | 37073 | 1128 | 18 |
1942036 | 1942036 | 2021-11-22 | Gates | North Carolina | 37073 | 1128 | 18 |
1942104 | 1942104 | 2021-11-22 | Bottineau | North Dakota | 38009 | 1128 | 21 |
1924028 | 1924028 | 2021-11-17 | Woodruff | Arkansas | 5147 | 1128 | 24 |
1920779 | 1920779 | 2021-11-16 | Woodruff | Arkansas | 5147 | 1128 | 24 |
1918920 | 1918920 | 2021-11-15 | Ozark | Missouri | 29153 | 1128 | 30 |
1915670 | 1915670 | 2021-11-14 | Ozark | Missouri | 29153 | 1128 | 30 |
1912420 | 1912420 | 2021-11-13 | Ozark | Missouri | 29153 | 1128 | 30 |
1898531 | 1898531 | 2021-11-09 | Schuyler | Illinois | 17169 | 1128 | 24 |
1895056 | 1895056 | 2021-11-08 | Hancock | Georgia | 13141 | 1128 | 82 |
1868702 | 1868702 | 2021-10-31 | Greenlee | Arizona | 4011 | 1128 | 16 |
1864825 | 1864825 | 2021-10-29 | Hansford | Texas | 48195 | 1128 | 25 |
1861520 | 1861520 | 2021-10-28 | Coleman | Texas | 48083 | 1128 | 53 |
1852515 | 1852515 | 2021-10-26 | Montgomery | Arkansas | 5097 | 1128 | 44 |
1849266 | 1849266 | 2021-10-25 | Montgomery | Arkansas | 5097 | 1128 | 44 |
1846016 | 1846016 | 2021-10-24 | Montgomery | Arkansas | 5097 | 1128 | 44 |
1842766 | 1842766 | 2021-10-23 | Montgomery | Arkansas | 5097 | 1128 | 44 |
1839516 | 1839516 | 2021-10-22 | Montgomery | Arkansas | 5097 | 1128 | 44 |
1842506 | 1842506 | 2021-10-22 | Webster | West Virginia | 54101 | 1128 | 17 |
1816744 | 1816744 | 2021-10-15 | Dallas | Arkansas | 5039 | 1128 | 19 |
1813496 | 1813496 | 2021-10-14 | Dallas | Arkansas | 5039 | 1128 | 19 |
1810103 | 1810103 | 2021-10-12 | Johnson | Wyoming | 56019 | 1128 | 15 |
1792288 | 1792288 | 2021-10-07 | Valley | Montana | 30105 | 1128 | 22 |
1784967 | 1784967 | 2021-10-05 | Ida | Iowa | 19093 | 1128 | 39 |
1781718 | 1781718 | 2021-10-04 | Ida | Iowa | 19093 | 1128 | 39 |
1778468 | 1778468 | 2021-10-03 | Ida | Iowa | 19093 | 1128 | 39 |
1775218 | 1775218 | 2021-10-02 | Ida | Iowa | 19093 | 1128 | 39 |
1771968 | 1771968 | 2021-10-01 | Ida | Iowa | 19093 | 1128 | 39 |
1768719 | 1768719 | 2021-09-30 | Ida | Iowa | 19093 | 1128 | 39 |
1770890 | 1770890 | 2021-09-30 | Northumberland | Virginia | 51133 | 1128 | 25 |
1765470 | 1765470 | 2021-09-29 | Ida | Iowa | 19093 | 1128 | 39 |
1763069 | 1763069 | 2021-09-28 | Custer | Nebraska | 31041 | 1128 | 19 |
1764322 | 1764322 | 2021-09-28 | Buena Vista city | Virginia | 51530 | 1128 | 22 |
1738798 | 1738798 | 2021-09-21 | Newton | Arkansas | 5101 | 1128 | 32 |
1740831 | 1740831 | 2021-09-21 | Major | Oklahoma | 40093 | 1128 | 25 |
1735686 | 1735686 | 2021-09-20 | Rio Grande | Colorado | 8105 | 1128 | 20 |
1737582 | 1737582 | 2021-09-20 | Major | Oklahoma | 40093 | 1128 | 25 |
1734332 | 1734332 | 2021-09-19 | Major | Oklahoma | 40093 | 1128 | 25 |
1731082 | 1731082 | 2021-09-18 | Major | Oklahoma | 40093 | 1128 | 25 |
1727832 | 1727832 | 2021-09-17 | Major | Oklahoma | 40093 | 1128 | 25 |
1724583 | 1724583 | 2021-09-16 | Major | Oklahoma | 40093 | 1128 | 25 |
1721334 | 1721334 | 2021-09-15 | Major | Oklahoma | 40093 | 1128 | 25 |
1715891 | 1715891 | 2021-09-13 | Washakie | Wyoming | 56043 | 1128 | 27 |
1709889 | 1709889 | 2021-09-12 | Miller | Georgia | 13201 | 1128 | 15 |
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);