ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
384 rows where cases = 1388 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 39
- Georgia 20
- Texas 20
- South Dakota 19
- Virginia 19
- Arkansas 14
- Puerto Rico 14
- Alabama 13
- Kansas 13
- Oklahoma 13
- Illinois 11
- Minnesota 11
- Missouri 11
- Wisconsin 11
- Indiana 10
- North Carolina 10
- Kentucky 9
- Mississippi 9
- North Dakota 9
- Alaska 8
- Colorado 8
- Ohio 8
- Oregon 8
- West Virginia 8
- Michigan 7
- Montana 6
- Tennessee 6
- Wyoming 6
- Pennsylvania 5
- Washington 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467885 | 2467885 | 2022-05-03 | Unknown | Iowa | 1388 | 0 | |
2422751 | 2422751 | 2022-04-19 | Big Stone | Minnesota | 27011 | 1388 | 8 |
2312278 | 2312278 | 2022-03-16 | Atchison | Missouri | 29005 | 1388 | 20 |
2306522 | 2306522 | 2022-03-14 | Lake | Oregon | 41037 | 1388 | 25 |
2303271 | 2303271 | 2022-03-13 | Lake | Oregon | 41037 | 1388 | 25 |
2300019 | 2300019 | 2022-03-12 | Lake | Oregon | 41037 | 1388 | 25 |
2296767 | 2296767 | 2022-03-11 | Lake | Oregon | 41037 | 1388 | 25 |
2294337 | 2294337 | 2022-03-10 | Ferry | Washington | 53019 | 1388 | 28 |
2290263 | 2290263 | 2022-03-09 | Lake | Oregon | 41037 | 1388 | 24 |
2291085 | 2291085 | 2022-03-09 | Ferry | Washington | 53019 | 1388 | 28 |
2262863 | 2262863 | 2022-03-01 | Osceola | Iowa | 19143 | 1388 | 22 |
2259612 | 2259612 | 2022-02-28 | Osceola | Iowa | 19143 | 1388 | 22 |
2256361 | 2256361 | 2022-02-27 | Osceola | Iowa | 19143 | 1388 | 22 |
2256490 | 2256490 | 2022-02-27 | Washington | Kansas | 20201 | 1388 | 20 |
2253110 | 2253110 | 2022-02-26 | Osceola | Iowa | 19143 | 1388 | 22 |
2253239 | 2253239 | 2022-02-26 | Washington | Kansas | 20201 | 1388 | 20 |
2249859 | 2249859 | 2022-02-25 | Osceola | Iowa | 19143 | 1388 | 22 |
2249988 | 2249988 | 2022-02-25 | Washington | Kansas | 20201 | 1388 | 20 |
2246608 | 2246608 | 2022-02-24 | Osceola | Iowa | 19143 | 1388 | 22 |
2246737 | 2246737 | 2022-02-24 | Washington | Kansas | 20201 | 1388 | 20 |
2243357 | 2243357 | 2022-02-23 | Osceola | Iowa | 19143 | 1388 | 22 |
2243486 | 2243486 | 2022-02-23 | Washington | Kansas | 20201 | 1388 | 20 |
2203228 | 2203228 | 2022-02-10 | Mathews | Virginia | 51115 | 1388 | 26 |
2199437 | 2199437 | 2022-02-09 | Brule | South Dakota | 46015 | 1388 | 18 |
2191810 | 2191810 | 2022-02-07 | Grant | Minnesota | 27051 | 1388 | 12 |
2178758 | 2178758 | 2022-02-03 | Oscoda | Michigan | 26135 | 1388 | 53 |
2175506 | 2175506 | 2022-02-02 | Oscoda | Michigan | 26135 | 1388 | 53 |
2171704 | 2171704 | 2022-02-01 | Ohio | Indiana | 18115 | 1388 | 17 |
2128939 | 2128939 | 2022-01-19 | Rio Blanco | Colorado | 8103 | 1388 | 13 |
2109259 | 2109259 | 2022-01-13 | Dallas | Arkansas | 5039 | 1388 | 21 |
2085614 | 2085614 | 2022-01-05 | Hutchinson | South Dakota | 46067 | 1388 | 30 |
2079896 | 2079896 | 2022-01-04 | Greene | Alabama | 1063 | 1388 | 45 |
2079490 | 2079490 | 2022-01-03 | Yoakum | Texas | 48501 | 1388 | 35 |
2074805 | 2074805 | 2022-01-02 | Humphreys | Mississippi | 28053 | 1388 | 39 |
2076085 | 2076085 | 2022-01-02 | Hamilton | Texas | 48193 | 1388 | 29 |
2071554 | 2071554 | 2022-01-01 | Humphreys | Mississippi | 28053 | 1388 | 39 |
2072834 | 2072834 | 2022-01-01 | Hamilton | Texas | 48193 | 1388 | 29 |
2068303 | 2068303 | 2021-12-31 | Humphreys | Mississippi | 28053 | 1388 | 39 |
2069583 | 2069583 | 2021-12-31 | Hamilton | Texas | 48193 | 1388 | 29 |
2065052 | 2065052 | 2021-12-30 | Humphreys | Mississippi | 28053 | 1388 | 39 |
2066332 | 2066332 | 2021-12-30 | Hamilton | Texas | 48193 | 1388 | 29 |
2063082 | 2063082 | 2021-12-29 | Hamilton | Texas | 48193 | 1388 | 29 |
2060346 | 2060346 | 2021-12-28 | Johnson | Wyoming | 56019 | 1388 | 17 |
2057097 | 2057097 | 2021-12-27 | Johnson | Wyoming | 56019 | 1388 | 17 |
2049749 | 2049749 | 2021-12-25 | Orocovis | Puerto Rico | 72107 | 1388 | |
2027951 | 2027951 | 2021-12-19 | Southeast Fairbanks Census Area | Alaska | 2240 | 1388 | 13 |
2024700 | 2024700 | 2021-12-18 | Southeast Fairbanks Census Area | Alaska | 2240 | 1388 | 13 |
2021449 | 2021449 | 2021-12-17 | Southeast Fairbanks Census Area | Alaska | 2240 | 1388 | 13 |
2018198 | 2018198 | 2021-12-16 | Southeast Fairbanks Census Area | Alaska | 2240 | 1388 | 12 |
2014948 | 2014948 | 2021-12-15 | Southeast Fairbanks Census Area | Alaska | 2240 | 1388 | 12 |
2011697 | 2011697 | 2021-12-14 | Southeast Fairbanks Census Area | Alaska | 2240 | 1388 | 12 |
2008446 | 2008446 | 2021-12-13 | Southeast Fairbanks Census Area | Alaska | 2240 | 1388 | 12 |
1993945 | 1993945 | 2021-12-08 | Sierra | New Mexico | 35051 | 1388 | 60 |
1994047 | 1994047 | 2021-12-08 | Graham | North Carolina | 37075 | 1388 | 28 |
1982634 | 1982634 | 2021-12-05 | Lincoln | Colorado | 8073 | 1388 | 8 |
1979384 | 1979384 | 2021-12-04 | Lincoln | Colorado | 8073 | 1388 | 8 |
1976134 | 1976134 | 2021-12-03 | Lincoln | Colorado | 8073 | 1388 | 8 |
1973515 | 1973515 | 2021-12-02 | Coffey | Kansas | 20031 | 1388 | 28 |
1974292 | 1974292 | 2021-12-02 | Cuming | Nebraska | 31039 | 1388 | 15 |
1970265 | 1970265 | 2021-12-01 | Coffey | Kansas | 20031 | 1388 | 28 |
1938461 | 1938461 | 2021-11-21 | Blaine | Montana | 30005 | 1388 | 27 |
1935211 | 1935211 | 2021-11-20 | Blaine | Montana | 30005 | 1388 | 27 |
1935956 | 1935956 | 2021-11-20 | Guayama | Puerto Rico | 72057 | 1388 | |
1931961 | 1931961 | 2021-11-19 | Blaine | Montana | 30005 | 1388 | 27 |
1928023 | 1928023 | 2021-11-18 | Grant | Kansas | 20067 | 1388 | 30 |
1924773 | 1924773 | 2021-11-17 | Grant | Kansas | 20067 | 1388 | 30 |
1921228 | 1921228 | 2021-11-16 | Hamilton | Illinois | 17065 | 1388 | 25 |
1917241 | 1917241 | 2021-11-14 | Tyler | West Virginia | 54095 | 1388 | 24 |
1904506 | 1904506 | 2021-11-11 | Nevada | Arkansas | 5099 | 1388 | 39 |
1906833 | 1906833 | 2021-11-11 | Grant | South Dakota | 46051 | 1388 | 45 |
1903584 | 1903584 | 2021-11-10 | Grant | South Dakota | 46051 | 1388 | 45 |
1900325 | 1900325 | 2021-11-09 | Custer | South Dakota | 46033 | 1388 | 17 |
1896140 | 1896140 | 2021-11-08 | Iron | Missouri | 29093 | 1388 | 15 |
1890150 | 1890150 | 2021-11-06 | Traill | North Dakota | 38097 | 1388 | 21 |
1876470 | 1876470 | 2021-11-02 | Marshall | Minnesota | 27089 | 1388 | 21 |
1869915 | 1869915 | 2021-10-31 | Presque Isle | Michigan | 26141 | 1388 | 39 |
1871710 | 1871710 | 2021-10-31 | Gilmer | West Virginia | 54021 | 1388 | 12 |
1866666 | 1866666 | 2021-10-30 | Presque Isle | Michigan | 26141 | 1388 | 39 |
1863417 | 1863417 | 2021-10-29 | Presque Isle | Michigan | 26141 | 1388 | 39 |
1845908 | 1845908 | 2021-10-24 | Perry | Alabama | 1105 | 1388 | 40 |
1842658 | 1842658 | 2021-10-23 | Perry | Alabama | 1105 | 1388 | 40 |
1813489 | 1813489 | 2021-10-14 | Cleveland | Arkansas | 5025 | 1388 | 32 |
1808410 | 1808410 | 2021-10-12 | Howard | Missouri | 29089 | 1388 | 12 |
1796779 | 1796779 | 2021-10-08 | Addison | Vermont | 50001 | 1388 | 8 |
1790870 | 1790870 | 2021-10-07 | Archuleta | Colorado | 8007 | 1388 | 4 |
1788033 | 1788033 | 2021-10-06 | Marshall | Illinois | 17123 | 1388 | 23 |
1782234 | 1782234 | 2021-10-04 | Jackson | Minnesota | 27063 | 1388 | 12 |
1765206 | 1765206 | 2021-09-29 | Fremont | Idaho | 16043 | 1388 | 15 |
1759579 | 1759579 | 2021-09-27 | Kemper | Mississippi | 28069 | 1388 | 40 |
1760163 | 1760163 | 2021-09-27 | Mercer | North Dakota | 38057 | 1388 | 11 |
1741611 | 1741611 | 2021-09-21 | Galax city | Virginia | 51640 | 1388 | 53 |
1719616 | 1719616 | 2021-09-15 | Lanier | Georgia | 13173 | 1388 | 14 |
1721493 | 1721493 | 2021-09-15 | Coamo | Puerto Rico | 72043 | 1388 | |
1716385 | 1716385 | 2021-09-14 | Montgomery | Georgia | 13209 | 1388 | 27 |
1716470 | 1716470 | 2021-09-14 | Franklin | Idaho | 16041 | 1388 | 19 |
1718245 | 1718245 | 2021-09-14 | Coamo | Puerto Rico | 72043 | 1388 | |
1713110 | 1713110 | 2021-09-13 | Heard | Georgia | 13149 | 1388 | 25 |
1676993 | 1676993 | 2021-09-02 | North Slope Borough | Alaska | 2185 | 1388 | 4 |
1677424 | 1677424 | 2021-09-02 | Seminole | Georgia | 13253 | 1388 | 20 |
1672641 | 1672641 | 2021-08-31 | Woods | Oklahoma | 40151 | 1388 | 18 |
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);