ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
601 rows where cases = 545 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 40
- Missouri 39
- Puerto Rico 34
- Kansas 29
- Virginia 29
- North Dakota 28
- Georgia 27
- Oklahoma 27
- Kentucky 26
- Nebraska 25
- Minnesota 21
- Mississippi 21
- Arkansas 19
- West Virginia 18
- South Dakota 16
- Indiana 13
- Tennessee 13
- Alabama 12
- North Carolina 12
- Illinois 11
- Iowa 11
- Oregon 9
- Louisiana 8
- Montana 8
- Idaho 7
- Nevada 7
- Rhode Island 7
- California 6
- Colorado 6
- New Mexico 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2475003 | 2475003 | 2022-05-05 | Unknown | Mississippi | 545 | 5 | |
2292608 | 2292608 | 2022-03-10 | Cook | Minnesota | 27031 | 545 | 4 |
2289356 | 2289356 | 2022-03-09 | Cook | Minnesota | 27031 | 545 | 4 |
2286105 | 2286105 | 2022-03-08 | Cook | Minnesota | 27031 | 545 | 4 |
2282853 | 2282853 | 2022-03-07 | Cook | Minnesota | 27031 | 545 | 4 |
2279943 | 2279943 | 2022-03-06 | Cherry | Nebraska | 31031 | 545 | 8 |
2276690 | 2276690 | 2022-03-05 | Cherry | Nebraska | 31031 | 545 | 8 |
2273437 | 2273437 | 2022-03-04 | Cherry | Nebraska | 31031 | 545 | 8 |
2270185 | 2270185 | 2022-03-03 | Cherry | Nebraska | 31031 | 545 | 8 |
2266932 | 2266932 | 2022-03-02 | Cherry | Nebraska | 31031 | 545 | 8 |
2263681 | 2263681 | 2022-03-01 | Cherry | Nebraska | 31031 | 545 | 8 |
2260430 | 2260430 | 2022-02-28 | Cherry | Nebraska | 31031 | 545 | 8 |
2228277 | 2228277 | 2022-02-18 | Renville | North Dakota | 38075 | 545 | 15 |
2225026 | 2225026 | 2022-02-17 | Renville | North Dakota | 38075 | 545 | 15 |
2218524 | 2218524 | 2022-02-15 | Renville | North Dakota | 38075 | 545 | 15 |
2218646 | 2218646 | 2022-02-15 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2218969 | 2218969 | 2022-02-15 | Faulk | South Dakota | 46049 | 545 | 16 |
2215395 | 2215395 | 2022-02-14 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2210907 | 2210907 | 2022-02-13 | Graham | Kansas | 20065 | 545 | 13 |
2212144 | 2212144 | 2022-02-13 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2207654 | 2207654 | 2022-02-12 | Graham | Kansas | 20065 | 545 | 13 |
2208891 | 2208891 | 2022-02-12 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2204401 | 2204401 | 2022-02-11 | Graham | Kansas | 20065 | 545 | 13 |
2205638 | 2205638 | 2022-02-11 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2201148 | 2201148 | 2022-02-10 | Graham | Kansas | 20065 | 545 | 13 |
2202385 | 2202385 | 2022-02-10 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2197894 | 2197894 | 2022-02-09 | Graham | Kansas | 20065 | 545 | 13 |
2199131 | 2199131 | 2022-02-09 | Cimarron | Oklahoma | 40025 | 545 | 5 |
2058703 | 2058703 | 2021-12-28 | Schuyler | Missouri | 29197 | 545 | 22 |
2059626 | 2059626 | 2021-12-28 | Perkins | South Dakota | 46105 | 545 | 16 |
2034654 | 2034654 | 2021-12-21 | Ouray | Colorado | 8091 | 545 | 6 |
2036537 | 2036537 | 2021-12-21 | Ellis | Oklahoma | 40045 | 545 | 6 |
2036869 | 2036869 | 2021-12-21 | Marshall | South Dakota | 46091 | 545 | 8 |
2033287 | 2033287 | 2021-12-20 | Ellis | Oklahoma | 40045 | 545 | 6 |
2030037 | 2030037 | 2021-12-19 | Ellis | Oklahoma | 40045 | 545 | 6 |
2026786 | 2026786 | 2021-12-18 | Ellis | Oklahoma | 40045 | 545 | 6 |
2023535 | 2023535 | 2021-12-17 | Ellis | Oklahoma | 40045 | 545 | 6 |
2020284 | 2020284 | 2021-12-16 | Ellis | Oklahoma | 40045 | 545 | 6 |
2017033 | 2017033 | 2021-12-15 | Ellis | Oklahoma | 40045 | 545 | 6 |
2009723 | 2009723 | 2021-12-13 | Lake of the Woods | Minnesota | 27077 | 545 | 5 |
2010119 | 2010119 | 2021-12-13 | Webster | Nebraska | 31181 | 545 | 9 |
2006868 | 2006868 | 2021-12-12 | Webster | Nebraska | 31181 | 545 | 9 |
2003617 | 2003617 | 2021-12-11 | Webster | Nebraska | 31181 | 545 | 9 |
2000367 | 2000367 | 2021-12-10 | Webster | Nebraska | 31181 | 545 | 9 |
1995623 | 1995623 | 2021-12-09 | Gilpin | Colorado | 8047 | 545 | 4 |
1987628 | 1987628 | 2021-12-06 | Hettinger | North Dakota | 38041 | 545 | 7 |
1983316 | 1983316 | 2021-12-05 | Ness | Kansas | 20135 | 545 | 17 |
1984378 | 1984378 | 2021-12-05 | Hettinger | North Dakota | 38041 | 545 | 7 |
1980066 | 1980066 | 2021-12-04 | Ness | Kansas | 20135 | 545 | 17 |
1981128 | 1981128 | 2021-12-04 | Hettinger | North Dakota | 38041 | 545 | 7 |
1976816 | 1976816 | 2021-12-03 | Ness | Kansas | 20135 | 545 | 17 |
1967763 | 1967763 | 2021-11-30 | Sheridan | Montana | 30091 | 545 | 8 |
1965336 | 1965336 | 2021-11-29 | Douglas | South Dakota | 46043 | 545 | 9 |
1944331 | 1944331 | 2021-11-23 | Sheridan | Kansas | 20179 | 545 | 16 |
1941081 | 1941081 | 2021-11-22 | Sheridan | Kansas | 20179 | 545 | 16 |
1942109 | 1942109 | 2021-11-22 | Cavalier | North Dakota | 38019 | 545 | 5 |
1938859 | 1938859 | 2021-11-21 | Cavalier | North Dakota | 38019 | 545 | 5 |
1935609 | 1935609 | 2021-11-20 | Cavalier | North Dakota | 38019 | 545 | 5 |
1930902 | 1930902 | 2021-11-19 | Adams | Idaho | 16003 | 545 | 12 |
1927652 | 1927652 | 2021-11-18 | Adams | Idaho | 16003 | 545 | 12 |
1924402 | 1924402 | 2021-11-17 | Adams | Idaho | 16003 | 545 | 12 |
1909609 | 1909609 | 2021-11-12 | Cavalier | North Dakota | 38019 | 545 | 5 |
1906360 | 1906360 | 2021-11-11 | Cavalier | North Dakota | 38019 | 545 | 5 |
1899865 | 1899865 | 2021-11-09 | Eddy | North Dakota | 38027 | 545 | 6 |
1883443 | 1883443 | 2021-11-04 | Union | New Mexico | 35059 | 545 | 12 |
1873887 | 1873887 | 2021-11-01 | Nelson | North Dakota | 38063 | 545 | 16 |
1874313 | 1874313 | 2021-11-01 | Aurora | South Dakota | 46003 | 545 | 17 |
1870324 | 1870324 | 2021-10-31 | Kimball | Nebraska | 31105 | 545 | 9 |
1870638 | 1870638 | 2021-10-31 | Nelson | North Dakota | 38063 | 545 | 16 |
1871064 | 1871064 | 2021-10-31 | Aurora | South Dakota | 46003 | 545 | 17 |
1871567 | 1871567 | 2021-10-31 | Falls Church city | Virginia | 51610 | 545 | 8 |
1867815 | 1867815 | 2021-10-30 | Aurora | South Dakota | 46003 | 545 | 17 |
1868318 | 1868318 | 2021-10-30 | Falls Church city | Virginia | 51610 | 545 | 8 |
1864566 | 1864566 | 2021-10-29 | Aurora | South Dakota | 46003 | 545 | 17 |
1865069 | 1865069 | 2021-10-29 | Falls Church city | Virginia | 51610 | 545 | 8 |
1860874 | 1860874 | 2021-10-28 | Emmons | North Dakota | 38029 | 545 | 15 |
1861820 | 1861820 | 2021-10-28 | Falls Church city | Virginia | 51610 | 545 | 8 |
1858561 | 1858561 | 2021-10-27 | Craig | Virginia | 51045 | 545 | 7 |
1858571 | 1858571 | 2021-10-27 | Falls Church city | Virginia | 51610 | 545 | 8 |
1847851 | 1847851 | 2021-10-24 | Tyrrell | North Carolina | 37177 | 545 | 7 |
1844601 | 1844601 | 2021-10-23 | Tyrrell | North Carolina | 37177 | 545 | 7 |
1841351 | 1841351 | 2021-10-22 | Tyrrell | North Carolina | 37177 | 545 | 7 |
1838102 | 1838102 | 2021-10-21 | Tyrrell | North Carolina | 37177 | 545 | 7 |
1834853 | 1834853 | 2021-10-20 | Tyrrell | North Carolina | 37177 | 545 | 7 |
1835198 | 1835198 | 2021-10-20 | Arroyo | Puerto Rico | 72015 | 545 | |
1835825 | 1835825 | 2021-10-20 | Falls Church city | Virginia | 51610 | 545 | 8 |
1831949 | 1831949 | 2021-10-19 | Arroyo | Puerto Rico | 72015 | 545 | |
1832246 | 1832246 | 2021-10-19 | Baylor | Texas | 48023 | 545 | 20 |
1828700 | 1828700 | 2021-10-18 | Arroyo | Puerto Rico | 72015 | 545 | |
1824888 | 1824888 | 2021-10-17 | Mineral | Nevada | 32021 | 545 | 11 |
1825451 | 1825451 | 2021-10-17 | Arroyo | Puerto Rico | 72015 | 545 | |
1821639 | 1821639 | 2021-10-16 | Mineral | Nevada | 32021 | 545 | 11 |
1822202 | 1822202 | 2021-10-16 | Arroyo | Puerto Rico | 72015 | 545 | |
1818390 | 1818390 | 2021-10-15 | Mineral | Nevada | 32021 | 545 | 11 |
1818953 | 1818953 | 2021-10-15 | Arroyo | Puerto Rico | 72015 | 545 | |
1815141 | 1815141 | 2021-10-14 | Mineral | Nevada | 32021 | 545 | 11 |
1815704 | 1815704 | 2021-10-14 | Arroyo | Puerto Rico | 72015 | 545 | |
1811893 | 1811893 | 2021-10-13 | Mineral | Nevada | 32021 | 545 | 11 |
1812456 | 1812456 | 2021-10-13 | Arroyo | Puerto Rico | 72015 | 545 | |
1808644 | 1808644 | 2021-10-12 | Mineral | Nevada | 32021 | 545 | 11 |
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);