ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
324 rows where cases = 1527 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 37
- Georgia 34
- Iowa 19
- Alabama 17
- Virginia 16
- Illinois 15
- Missouri 12
- Louisiana 11
- Michigan 11
- Mississippi 11
- Oklahoma 11
- Kansas 10
- Kentucky 10
- Minnesota 9
- Montana 9
- Ohio 7
- Arkansas 6
- Wisconsin 6
- Maine 5
- North Carolina 5
- Oregon 5
- Puerto Rico 5
- West Virginia 5
- South Carolina 4
- South Dakota 4
- Tennessee 4
- Wyoming 4
- Colorado 3
- Indiana 3
- Nebraska 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490490 | 2490490 | 2022-05-10 | Stark | Illinois | 17175 | 1527 | 33 |
2487233 | 2487233 | 2022-05-09 | Stark | Illinois | 17175 | 1527 | 33 |
2472483 | 2472483 | 2022-05-04 | Tillman | Oklahoma | 40141 | 1527 | 35 |
2469227 | 2469227 | 2022-05-03 | Tillman | Oklahoma | 40141 | 1527 | 35 |
2465971 | 2465971 | 2022-05-02 | Tillman | Oklahoma | 40141 | 1527 | 35 |
2462716 | 2462716 | 2022-05-01 | Tillman | Oklahoma | 40141 | 1527 | 35 |
2459460 | 2459460 | 2022-04-30 | Tillman | Oklahoma | 40141 | 1527 | 35 |
2456204 | 2456204 | 2022-04-29 | Tillman | Oklahoma | 40141 | 1527 | 35 |
2452948 | 2452948 | 2022-04-28 | Tillman | Oklahoma | 40141 | 1527 | 35 |
2424080 | 2424080 | 2022-04-19 | Carson | Texas | 48065 | 1527 | 36 |
2420824 | 2420824 | 2022-04-18 | Carson | Texas | 48065 | 1527 | 36 |
2417568 | 2417568 | 2022-04-17 | Carson | Texas | 48065 | 1527 | 36 |
2414312 | 2414312 | 2022-04-16 | Carson | Texas | 48065 | 1527 | 36 |
2411056 | 2411056 | 2022-04-15 | Carson | Texas | 48065 | 1527 | 36 |
2407800 | 2407800 | 2022-04-14 | Carson | Texas | 48065 | 1527 | 36 |
2404544 | 2404544 | 2022-04-13 | Carson | Texas | 48065 | 1527 | 35 |
2401289 | 2401289 | 2022-04-12 | Carson | Texas | 48065 | 1527 | 34 |
2398034 | 2398034 | 2022-04-11 | Carson | Texas | 48065 | 1527 | 34 |
2394779 | 2394779 | 2022-04-10 | Carson | Texas | 48065 | 1527 | 34 |
2391523 | 2391523 | 2022-04-09 | Carson | Texas | 48065 | 1527 | 34 |
2388267 | 2388267 | 2022-04-08 | Carson | Texas | 48065 | 1527 | 34 |
2385012 | 2385012 | 2022-04-07 | Carson | Texas | 48065 | 1527 | 34 |
2380758 | 2380758 | 2022-04-06 | Stillwater | Montana | 30095 | 1527 | 29 |
2381757 | 2381757 | 2022-04-06 | Carson | Texas | 48065 | 1527 | 34 |
2377503 | 2377503 | 2022-04-05 | Stillwater | Montana | 30095 | 1527 | 29 |
2378502 | 2378502 | 2022-04-05 | Carson | Texas | 48065 | 1527 | 34 |
2374250 | 2374250 | 2022-04-04 | Stillwater | Montana | 30095 | 1527 | 29 |
2375248 | 2375248 | 2022-04-04 | Carson | Texas | 48065 | 1527 | 34 |
2371996 | 2371996 | 2022-04-03 | Carson | Texas | 48065 | 1527 | 34 |
2368743 | 2368743 | 2022-04-02 | Carson | Texas | 48065 | 1527 | 34 |
2360108 | 2360108 | 2022-03-31 | Twiggs | Georgia | 13289 | 1527 | 69 |
2356854 | 2356854 | 2022-03-30 | Twiggs | Georgia | 13289 | 1527 | 69 |
2353601 | 2353601 | 2022-03-29 | Twiggs | Georgia | 13289 | 1527 | 69 |
2350349 | 2350349 | 2022-03-28 | Twiggs | Georgia | 13289 | 1527 | 69 |
2347096 | 2347096 | 2022-03-27 | Twiggs | Georgia | 13289 | 1527 | 69 |
2343843 | 2343843 | 2022-03-26 | Twiggs | Georgia | 13289 | 1527 | 69 |
2340590 | 2340590 | 2022-03-25 | Twiggs | Georgia | 13289 | 1527 | 69 |
2337337 | 2337337 | 2022-03-24 | Twiggs | Georgia | 13289 | 1527 | 69 |
2334083 | 2334083 | 2022-03-23 | Twiggs | Georgia | 13289 | 1527 | 69 |
2330829 | 2330829 | 2022-03-22 | Twiggs | Georgia | 13289 | 1527 | 69 |
2327577 | 2327577 | 2022-03-21 | Twiggs | Georgia | 13289 | 1527 | 69 |
2304806 | 2304806 | 2022-03-14 | Twiggs | Georgia | 13289 | 1527 | 68 |
2285295 | 2285295 | 2022-03-08 | Twiggs | Georgia | 13289 | 1527 | 68 |
2199208 | 2199208 | 2022-02-09 | Grant | Oregon | 41023 | 1527 | 18 |
2193988 | 2193988 | 2022-02-08 | Kit Carson | Colorado | 8063 | 1527 | 29 |
2195306 | 2195306 | 2022-02-08 | Shannon | Missouri | 29203 | 1527 | 32 |
2164914 | 2164914 | 2022-01-30 | Lincoln | Georgia | 13181 | 1527 | 35 |
2161659 | 2161659 | 2022-01-29 | Lincoln | Georgia | 13181 | 1527 | 35 |
2158403 | 2158403 | 2022-01-28 | Lincoln | Georgia | 13181 | 1527 | 35 |
2154738 | 2154738 | 2022-01-27 | Aleutians West Census Area | Alaska | 2016 | 1527 | 1 |
2151485 | 2151485 | 2022-01-26 | Aleutians West Census Area | Alaska | 2016 | 1527 | 1 |
2122297 | 2122297 | 2022-01-17 | Newton | Arkansas | 5101 | 1527 | 45 |
2122021 | 2122021 | 2022-01-16 | Pendleton | West Virginia | 54071 | 1527 | 16 |
2110162 | 2110162 | 2022-01-13 | Elliott | Kentucky | 21063 | 1527 | 14 |
2110819 | 2110819 | 2022-01-13 | Cuming | Nebraska | 31039 | 1527 | 15 |
2087796 | 2087796 | 2022-01-06 | Claiborne | Mississippi | 28021 | 1527 | 41 |
2076607 | 2076607 | 2022-01-02 | Sublette | Wyoming | 56035 | 1527 | 23 |
2073356 | 2073356 | 2022-01-01 | Sublette | Wyoming | 56035 | 1527 | 23 |
2070105 | 2070105 | 2021-12-31 | Sublette | Wyoming | 56035 | 1527 | 23 |
2066560 | 2066560 | 2021-12-30 | Charlotte | Virginia | 51037 | 1527 | 30 |
2066854 | 2066854 | 2021-12-30 | Sublette | Wyoming | 56035 | 1527 | 23 |
2035937 | 2035937 | 2021-12-21 | Oregon | Missouri | 29149 | 1527 | 27 |
2008906 | 2008906 | 2021-12-13 | Wilkinson | Georgia | 13319 | 1527 | 46 |
2009139 | 2009139 | 2021-12-13 | Switzerland | Indiana | 18155 | 1527 | 14 |
2011196 | 2011196 | 2021-12-13 | Somervell | Texas | 48425 | 1527 | 25 |
2007945 | 2007945 | 2021-12-12 | Somervell | Texas | 48425 | 1527 | 25 |
1975857 | 1975857 | 2021-12-03 | Bullock | Alabama | 1011 | 1527 | 45 |
1973980 | 1973980 | 2021-12-02 | Murray | Minnesota | 27101 | 1527 | 11 |
1943350 | 1943350 | 2021-11-23 | Bullock | Alabama | 1011 | 1527 | 45 |
1940100 | 1940100 | 2021-11-22 | Bullock | Alabama | 1011 | 1527 | 45 |
1936850 | 1936850 | 2021-11-21 | Bullock | Alabama | 1011 | 1527 | 45 |
1939987 | 1939987 | 2021-11-21 | Ritchie | West Virginia | 54085 | 1527 | 21 |
1933600 | 1933600 | 2021-11-20 | Bullock | Alabama | 1011 | 1527 | 45 |
1921112 | 1921112 | 2021-11-16 | Stewart | Georgia | 13259 | 1527 | 28 |
1917862 | 1917862 | 2021-11-15 | Stewart | Georgia | 13259 | 1527 | 28 |
1914600 | 1914600 | 2021-11-14 | Pulaski | Georgia | 13235 | 1527 | 61 |
1915063 | 1915063 | 2021-11-14 | Pawnee | Kansas | 20145 | 1527 | 19 |
1911350 | 1911350 | 2021-11-13 | Pulaski | Georgia | 13235 | 1527 | 61 |
1911813 | 1911813 | 2021-11-13 | Pawnee | Kansas | 20145 | 1527 | 19 |
1908101 | 1908101 | 2021-11-12 | Pulaski | Georgia | 13235 | 1527 | 61 |
1908564 | 1908564 | 2021-11-12 | Pawnee | Kansas | 20145 | 1527 | 19 |
1905624 | 1905624 | 2021-11-11 | Iron | Michigan | 26071 | 1527 | 61 |
1902375 | 1902375 | 2021-11-10 | Iron | Michigan | 26071 | 1527 | 61 |
1898711 | 1898711 | 2021-11-09 | Montgomery | Iowa | 19137 | 1527 | 42 |
1895461 | 1895461 | 2021-11-08 | Montgomery | Iowa | 19137 | 1527 | 42 |
1892211 | 1892211 | 2021-11-07 | Montgomery | Iowa | 19137 | 1527 | 42 |
1888961 | 1888961 | 2021-11-06 | Montgomery | Iowa | 19137 | 1527 | 42 |
1885711 | 1885711 | 2021-11-05 | Montgomery | Iowa | 19137 | 1527 | 42 |
1882462 | 1882462 | 2021-11-04 | Montgomery | Iowa | 19137 | 1527 | 42 |
1879213 | 1879213 | 2021-11-03 | Montgomery | Iowa | 19137 | 1527 | 42 |
1862108 | 1862108 | 2021-10-29 | Bullock | Alabama | 1011 | 1527 | 44 |
1858859 | 1858859 | 2021-10-28 | Bullock | Alabama | 1011 | 1527 | 44 |
1859152 | 1859152 | 2021-10-28 | Rio Grande | Colorado | 8105 | 1527 | 22 |
1858690 | 1858690 | 2021-10-27 | Pend Oreille | Washington | 53051 | 1527 | 22 |
1855159 | 1855159 | 2021-10-26 | Ochiltree | Texas | 48357 | 1527 | 37 |
1844176 | 1844176 | 2021-10-23 | Montgomery | Missouri | 29139 | 1527 | 19 |
1837694 | 1837694 | 2021-10-21 | Ralls | Missouri | 29173 | 1527 | 14 |
1810665 | 1810665 | 2021-10-13 | Wilkes | Georgia | 13317 | 1527 | 34 |
1807416 | 1807416 | 2021-10-12 | Wilkes | Georgia | 13317 | 1527 | 34 |
1791572 | 1791572 | 2021-10-07 | Linn | Kansas | 20107 | 1527 | 14 |
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);