ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
490 rows where cases = 988 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 45
- Georgia 36
- Puerto Rico 35
- Missouri 30
- Iowa 29
- Kansas 24
- Kentucky 23
- Louisiana 23
- Virginia 18
- Minnesota 14
- North Carolina 14
- Mississippi 13
- Tennessee 13
- Michigan 12
- Nebraska 12
- Colorado 11
- Illinois 11
- Florida 9
- Wisconsin 9
- Arkansas 8
- Indiana 8
- Montana 7
- New York 7
- Oklahoma 7
- South Dakota 7
- Idaho 6
- Ohio 6
- Alabama 5
- California 5
- New Mexico 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500752 | 2500752 | 2022-05-13 | Tensas | Louisiana | 22107 | 988 | 11 |
2497494 | 2497494 | 2022-05-12 | Tensas | Louisiana | 22107 | 988 | 11 |
2494236 | 2494236 | 2022-05-11 | Tensas | Louisiana | 22107 | 988 | 11 |
2490978 | 2490978 | 2022-05-10 | Tensas | Louisiana | 22107 | 988 | 11 |
2487721 | 2487721 | 2022-05-09 | Tensas | Louisiana | 22107 | 988 | 11 |
2484463 | 2484463 | 2022-05-08 | Tensas | Louisiana | 22107 | 988 | 11 |
2481205 | 2481205 | 2022-05-07 | Tensas | Louisiana | 22107 | 988 | 11 |
2477947 | 2477947 | 2022-05-06 | Tensas | Louisiana | 22107 | 988 | 11 |
2474689 | 2474689 | 2022-05-05 | Tensas | Louisiana | 22107 | 988 | 11 |
2471432 | 2471432 | 2022-05-04 | Tensas | Louisiana | 22107 | 988 | 11 |
2468176 | 2468176 | 2022-05-03 | Tensas | Louisiana | 22107 | 988 | 11 |
2464921 | 2464921 | 2022-05-02 | Tensas | Louisiana | 22107 | 988 | 11 |
2461665 | 2461665 | 2022-05-01 | Tensas | Louisiana | 22107 | 988 | 11 |
2458409 | 2458409 | 2022-04-30 | Tensas | Louisiana | 22107 | 988 | 11 |
2455153 | 2455153 | 2022-04-29 | Tensas | Louisiana | 22107 | 988 | 11 |
2451897 | 2451897 | 2022-04-28 | Tensas | Louisiana | 22107 | 988 | 11 |
2448641 | 2448641 | 2022-04-27 | Tensas | Louisiana | 22107 | 988 | 11 |
2445385 | 2445385 | 2022-04-26 | Tensas | Louisiana | 22107 | 988 | 11 |
2398116 | 2398116 | 2022-04-11 | Hudspeth | Texas | 48229 | 988 | 18 |
2394861 | 2394861 | 2022-04-10 | Hudspeth | Texas | 48229 | 988 | 18 |
2391605 | 2391605 | 2022-04-09 | Hudspeth | Texas | 48229 | 988 | 18 |
2388349 | 2388349 | 2022-04-08 | Hudspeth | Texas | 48229 | 988 | 18 |
2385094 | 2385094 | 2022-04-07 | Hudspeth | Texas | 48229 | 988 | 18 |
2381839 | 2381839 | 2022-04-06 | Hudspeth | Texas | 48229 | 988 | 18 |
2378584 | 2378584 | 2022-04-05 | Hudspeth | Texas | 48229 | 988 | 18 |
2375330 | 2375330 | 2022-04-04 | Hudspeth | Texas | 48229 | 988 | 18 |
2372078 | 2372078 | 2022-04-03 | Hudspeth | Texas | 48229 | 988 | 18 |
2368825 | 2368825 | 2022-04-02 | Hudspeth | Texas | 48229 | 988 | 18 |
2365572 | 2365572 | 2022-04-01 | Hudspeth | Texas | 48229 | 988 | 18 |
2362319 | 2362319 | 2022-03-31 | Hudspeth | Texas | 48229 | 988 | 18 |
2283095 | 2283095 | 2022-03-07 | Putnam | Missouri | 29171 | 988 | 22 |
2279842 | 2279842 | 2022-03-06 | Putnam | Missouri | 29171 | 988 | 22 |
2276589 | 2276589 | 2022-03-05 | Putnam | Missouri | 29171 | 988 | 22 |
2273336 | 2273336 | 2022-03-04 | Putnam | Missouri | 29171 | 988 | 22 |
2188566 | 2188566 | 2022-02-06 | Kittson | Minnesota | 27069 | 988 | 26 |
2185313 | 2185313 | 2022-02-05 | Kittson | Minnesota | 27069 | 988 | 26 |
2182061 | 2182061 | 2022-02-04 | Kittson | Minnesota | 27069 | 988 | 26 |
2172592 | 2172592 | 2022-02-01 | Phillips | Montana | 30071 | 988 | 28 |
2169339 | 2169339 | 2022-01-31 | Phillips | Montana | 30071 | 988 | 28 |
2169516 | 2169516 | 2022-01-31 | Hidalgo | New Mexico | 35023 | 988 | 12 |
2170169 | 2170169 | 2022-01-31 | Corson | South Dakota | 46031 | 988 | 16 |
2128340 | 2128340 | 2022-01-18 | Charles City | Virginia | 51036 | 988 | 22 |
2087301 | 2087301 | 2022-01-06 | Gray | Kansas | 20069 | 988 | 23 |
2084049 | 2084049 | 2022-01-05 | Gray | Kansas | 20069 | 988 | 23 |
2072160 | 2072160 | 2022-01-01 | Sioux | North Dakota | 38085 | 988 | 18 |
2058054 | 2058054 | 2021-12-28 | Kearny | Kansas | 20093 | 988 | 17 |
2054805 | 2054805 | 2021-12-27 | Kearny | Kansas | 20093 | 988 | 17 |
2052138 | 2052138 | 2021-12-26 | Dade | Missouri | 29057 | 988 | 38 |
2048888 | 2048888 | 2021-12-25 | Dade | Missouri | 29057 | 988 | 38 |
2045638 | 2045638 | 2021-12-24 | Dade | Missouri | 29057 | 988 | 38 |
2042388 | 2042388 | 2021-12-23 | Dade | Missouri | 29057 | 988 | 38 |
2034436 | 2034436 | 2021-12-21 | Dillingham Census Area | Alaska | 2070 | 988 | 10 |
2031186 | 2031186 | 2021-12-20 | Dillingham Census Area | Alaska | 2070 | 988 | 10 |
2029195 | 2029195 | 2021-12-19 | Big Stone | Minnesota | 27011 | 988 | 7 |
2025944 | 2025944 | 2021-12-18 | Big Stone | Minnesota | 27011 | 988 | 7 |
2022693 | 2022693 | 2021-12-17 | Big Stone | Minnesota | 27011 | 988 | 7 |
2018653 | 2018653 | 2021-12-16 | Wheeler | Georgia | 13309 | 988 | 36 |
2015403 | 2015403 | 2021-12-15 | Wheeler | Georgia | 13309 | 988 | 36 |
2017386 | 2017386 | 2021-12-15 | Walworth | South Dakota | 46129 | 988 | 19 |
2012494 | 2012494 | 2021-12-14 | Van Buren | Iowa | 19177 | 988 | 23 |
2009243 | 2009243 | 2021-12-13 | Van Buren | Iowa | 19177 | 988 | 23 |
2005992 | 2005992 | 2021-12-12 | Van Buren | Iowa | 19177 | 988 | 23 |
2007608 | 2007608 | 2021-12-12 | Kingsbury | South Dakota | 46077 | 988 | 19 |
2002741 | 2002741 | 2021-12-11 | Van Buren | Iowa | 19177 | 988 | 23 |
2004357 | 2004357 | 2021-12-11 | Kingsbury | South Dakota | 46077 | 988 | 19 |
1999491 | 1999491 | 2021-12-10 | Van Buren | Iowa | 19177 | 988 | 23 |
2001106 | 2001106 | 2021-12-10 | Kingsbury | South Dakota | 46077 | 988 | 19 |
1996240 | 1996240 | 2021-12-09 | Van Buren | Iowa | 19177 | 988 | 23 |
1992989 | 1992989 | 2021-12-08 | Van Buren | Iowa | 19177 | 988 | 23 |
1965744 | 1965744 | 2021-11-29 | Kane | Utah | 49025 | 988 | 12 |
1925873 | 1925873 | 2021-11-17 | McHenry | North Dakota | 38049 | 988 | 24 |
1905715 | 1905715 | 2021-11-11 | Mahnomen | Minnesota | 27087 | 988 | 13 |
1903927 | 1903927 | 2021-11-10 | San Saba | Texas | 48411 | 988 | 27 |
1904202 | 1904202 | 2021-11-10 | Calhoun | West Virginia | 54013 | 988 | 5 |
1900677 | 1900677 | 2021-11-09 | San Saba | Texas | 48411 | 988 | 27 |
1897427 | 1897427 | 2021-11-08 | San Saba | Texas | 48411 | 988 | 27 |
1876402 | 1876402 | 2021-11-02 | Montmorency | Michigan | 26119 | 988 | 26 |
1873153 | 1873153 | 2021-11-01 | Montmorency | Michigan | 26119 | 988 | 26 |
1873411 | 1873411 | 2021-11-01 | Maries | Missouri | 29125 | 988 | 19 |
1870162 | 1870162 | 2021-10-31 | Maries | Missouri | 29125 | 988 | 19 |
1866913 | 1866913 | 2021-10-30 | Maries | Missouri | 29125 | 988 | 19 |
1859131 | 1859131 | 2021-10-28 | Kit Carson | Colorado | 8063 | 988 | 19 |
1855357 | 1855357 | 2021-10-26 | Madison | Virginia | 51113 | 988 | 21 |
1815200 | 1815200 | 2021-10-14 | Quay | New Mexico | 35037 | 988 | 18 |
1811529 | 1811529 | 2021-10-13 | Wilkin | Minnesota | 27167 | 988 | 14 |
1812947 | 1812947 | 2021-10-13 | San Saba | Texas | 48411 | 988 | 26 |
1804127 | 1804127 | 2021-10-11 | Randolph | Georgia | 13243 | 988 | 40 |
1800878 | 1800878 | 2021-10-10 | Randolph | Georgia | 13243 | 988 | 40 |
1797629 | 1797629 | 2021-10-09 | Randolph | Georgia | 13243 | 988 | 40 |
1794380 | 1794380 | 2021-10-08 | Randolph | Georgia | 13243 | 988 | 40 |
1790251 | 1790251 | 2021-10-06 | Beaver | Utah | 49001 | 988 | 11 |
1765252 | 1765252 | 2021-09-29 | Edwards | Illinois | 17047 | 988 | 17 |
1750744 | 1750744 | 2021-09-24 | Florida | Puerto Rico | 72054 | 988 | |
1745217 | 1745217 | 2021-09-23 | Nome Census Area | Alaska | 2180 | 988 | 0 |
1727178 | 1727178 | 2021-09-17 | Hickory | Missouri | 29085 | 988 | 17 |
1724056 | 1724056 | 2021-09-16 | Valley | Montana | 30105 | 988 | 18 |
1701025 | 1701025 | 2021-09-09 | Marshall | Minnesota | 27089 | 988 | 18 |
1693690 | 1693690 | 2021-09-07 | Twiggs | Georgia | 13289 | 988 | 49 |
1694067 | 1694067 | 2021-09-07 | Clay | Kansas | 20027 | 988 | 31 |
1694632 | 1694632 | 2021-09-07 | Quitman | Mississippi | 28119 | 988 | 21 |
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);