ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
310 rows where cases = 1676 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 34
- Georgia 21
- Kentucky 17
- Minnesota 17
- Puerto Rico 17
- Illinois 16
- Virginia 16
- Iowa 14
- Missouri 12
- Mississippi 11
- Florida 10
- Alabama 9
- Arkansas 9
- Louisiana 9
- Nebraska 8
- Alaska 7
- Colorado 7
- North Carolina 7
- Oregon 7
- Tennessee 7
- Wisconsin 7
- Indiana 6
- South Carolina 5
- Utah 5
- West Virginia 5
- Ohio 4
- Oklahoma 4
- Wyoming 3
- California 2
- Michigan 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2415201 | 2415201 | 2022-04-17 | Rio Blanco | Colorado | 8103 | 1676 | 13 |
2411945 | 2411945 | 2022-04-16 | Rio Blanco | Colorado | 8103 | 1676 | 13 |
2408689 | 2408689 | 2022-04-15 | Rio Blanco | Colorado | 8103 | 1676 | 13 |
2405433 | 2405433 | 2022-04-14 | Rio Blanco | Colorado | 8103 | 1676 | 13 |
2397617 | 2397617 | 2022-04-11 | Grant | Oregon | 41023 | 1676 | 22 |
2394362 | 2394362 | 2022-04-10 | Grant | Oregon | 41023 | 1676 | 22 |
2391106 | 2391106 | 2022-04-09 | Grant | Oregon | 41023 | 1676 | 22 |
2387850 | 2387850 | 2022-04-08 | Grant | Oregon | 41023 | 1676 | 22 |
2384595 | 2384595 | 2022-04-07 | Grant | Oregon | 41023 | 1676 | 22 |
2375908 | 2375908 | 2022-04-05 | Aleutians West Census Area | Alaska | 2016 | 1676 | 1 |
2378624 | 2378624 | 2022-04-05 | Marion | Texas | 48315 | 1676 | 59 |
2372656 | 2372656 | 2022-04-04 | Aleutians West Census Area | Alaska | 2016 | 1676 | 1 |
2375370 | 2375370 | 2022-04-04 | Marion | Texas | 48315 | 1676 | 59 |
2369403 | 2369403 | 2022-04-03 | Aleutians West Census Area | Alaska | 2016 | 1676 | 1 |
2372118 | 2372118 | 2022-04-03 | Marion | Texas | 48315 | 1676 | 59 |
2366150 | 2366150 | 2022-04-02 | Aleutians West Census Area | Alaska | 2016 | 1676 | 1 |
2368865 | 2368865 | 2022-04-02 | Marion | Texas | 48315 | 1676 | 59 |
2362897 | 2362897 | 2022-04-01 | Aleutians West Census Area | Alaska | 2016 | 1676 | 1 |
2365612 | 2365612 | 2022-04-01 | Marion | Texas | 48315 | 1676 | 59 |
2359643 | 2359643 | 2022-03-31 | Aleutians West Census Area | Alaska | 2016 | 1676 | 1 |
2362359 | 2362359 | 2022-03-31 | Marion | Texas | 48315 | 1676 | 59 |
2356389 | 2356389 | 2022-03-30 | Aleutians West Census Area | Alaska | 2016 | 1676 | 1 |
2359105 | 2359105 | 2022-03-30 | Marion | Texas | 48315 | 1676 | 59 |
2355851 | 2355851 | 2022-03-29 | Marion | Texas | 48315 | 1676 | 59 |
2351540 | 2351540 | 2022-03-28 | Knox | Nebraska | 31107 | 1676 | 13 |
2352598 | 2352598 | 2022-03-28 | Marion | Texas | 48315 | 1676 | 59 |
2349346 | 2349346 | 2022-03-27 | Marion | Texas | 48315 | 1676 | 59 |
2346093 | 2346093 | 2022-03-26 | Marion | Texas | 48315 | 1676 | 59 |
2286290 | 2286290 | 2022-03-08 | Daviess | Missouri | 29061 | 1676 | 26 |
2270223 | 2270223 | 2022-03-03 | Knox | Nebraska | 31107 | 1676 | 13 |
2257413 | 2257413 | 2022-02-27 | Camden | North Carolina | 37029 | 1676 | 9 |
2254162 | 2254162 | 2022-02-26 | Camden | North Carolina | 37029 | 1676 | 9 |
2250911 | 2250911 | 2022-02-25 | Camden | North Carolina | 37029 | 1676 | 9 |
2247258 | 2247258 | 2022-02-24 | Chariton | Missouri | 29041 | 1676 | 34 |
2216666 | 2216666 | 2022-02-15 | Woodruff | Arkansas | 5147 | 1676 | 25 |
2160294 | 2160294 | 2022-01-28 | Hormigueros | Puerto Rico | 72067 | 1676 | |
2152955 | 2152955 | 2022-01-26 | Harrison | Missouri | 29081 | 1676 | 27 |
2153070 | 2153070 | 2022-01-26 | Powell | Montana | 30077 | 1676 | 26 |
2146595 | 2146595 | 2022-01-24 | Butler | Nebraska | 31023 | 1676 | 12 |
2135091 | 2135091 | 2022-01-20 | Menominee | Wisconsin | 55078 | 1676 | 12 |
2129671 | 2129671 | 2022-01-19 | Crittenden | Kentucky | 21055 | 1676 | 39 |
2096598 | 2096598 | 2022-01-09 | Johnson | Georgia | 13167 | 1676 | 64 |
2093346 | 2093346 | 2022-01-08 | Johnson | Georgia | 13167 | 1676 | 64 |
2090094 | 2090094 | 2022-01-07 | Johnson | Georgia | 13167 | 1676 | 64 |
2086843 | 2086843 | 2022-01-06 | Johnson | Georgia | 13167 | 1676 | 64 |
2083591 | 2083591 | 2022-01-05 | Johnson | Georgia | 13167 | 1676 | 64 |
2080937 | 2080937 | 2022-01-04 | Livingston | Kentucky | 21139 | 1676 | 49 |
2070116 | 2070116 | 2022-01-01 | Bullock | Alabama | 1011 | 1676 | 46 |
2066865 | 2066865 | 2021-12-31 | Bullock | Alabama | 1011 | 1676 | 46 |
2058158 | 2058158 | 2021-12-28 | Hancock | Kentucky | 21091 | 1676 | 19 |
2058646 | 2058646 | 2021-12-28 | Gentry | Missouri | 29075 | 1676 | 28 |
2056665 | 2056665 | 2021-12-27 | Ochiltree | Texas | 48357 | 1676 | 39 |
2036960 | 2036960 | 2021-12-21 | Perry | Tennessee | 47135 | 1676 | 35 |
2027022 | 2027022 | 2021-12-18 | Yabucoa | Puerto Rico | 72151 | 1676 | |
2017712 | 2017712 | 2021-12-15 | Trinity | Texas | 48455 | 1676 | 63 |
2012044 | 2012044 | 2021-12-14 | Dooly | Georgia | 13093 | 1676 | 62 |
1972325 | 1972325 | 2021-12-01 | Franklin city | Virginia | 51620 | 1676 | 44 |
1969075 | 1969075 | 2021-11-30 | Franklin city | Virginia | 51620 | 1676 | 44 |
1965825 | 1965825 | 2021-11-29 | Franklin city | Virginia | 51620 | 1676 | 44 |
1944222 | 1944222 | 2021-11-23 | Sac | Iowa | 19161 | 1676 | 26 |
1940972 | 1940972 | 2021-11-22 | Sac | Iowa | 19161 | 1676 | 26 |
1937722 | 1937722 | 2021-11-21 | Sac | Iowa | 19161 | 1676 | 26 |
1934472 | 1934472 | 2021-11-20 | Sac | Iowa | 19161 | 1676 | 26 |
1931221 | 1931221 | 2021-11-19 | Sac | Iowa | 19161 | 1676 | 26 |
1927970 | 1927970 | 2021-11-18 | Sac | Iowa | 19161 | 1676 | 26 |
1924720 | 1924720 | 2021-11-17 | Sac | Iowa | 19161 | 1676 | 26 |
1917985 | 1917985 | 2021-11-15 | Jasper | Illinois | 17079 | 1676 | 23 |
1915837 | 1915837 | 2021-11-14 | Red Willow | Nebraska | 31145 | 1676 | 15 |
1912587 | 1912587 | 2021-11-13 | Red Willow | Nebraska | 31145 | 1676 | 15 |
1909337 | 1909337 | 2021-11-12 | Red Willow | Nebraska | 31145 | 1676 | 15 |
1906868 | 1906868 | 2021-11-11 | Todd | South Dakota | 46121 | 1676 | 36 |
1902490 | 1902490 | 2021-11-10 | Rock | Minnesota | 27133 | 1676 | 27 |
1903619 | 1903619 | 2021-11-10 | Todd | South Dakota | 46121 | 1676 | 36 |
1898444 | 1898444 | 2021-11-09 | Teton | Idaho | 16081 | 1676 | 5 |
1883222 | 1883222 | 2021-11-04 | Dawson | Montana | 30021 | 1676 | 47 |
1878059 | 1878059 | 2021-11-02 | Dickenson | Virginia | 51051 | 1676 | 27 |
1850624 | 1850624 | 2021-10-25 | Cedar | Missouri | 29039 | 1676 | 30 |
1847374 | 1847374 | 2021-10-24 | Cedar | Missouri | 29039 | 1676 | 30 |
1849104 | 1849104 | 2021-10-24 | Washakie | Wyoming | 56043 | 1676 | 33 |
1845854 | 1845854 | 2021-10-23 | Washakie | Wyoming | 56043 | 1676 | 33 |
1842604 | 1842604 | 2021-10-22 | Washakie | Wyoming | 56043 | 1676 | 33 |
1828395 | 1828395 | 2021-10-18 | Mercer | North Dakota | 38057 | 1676 | 12 |
1810282 | 1810282 | 2021-10-13 | Pike | Arkansas | 5109 | 1676 | 35 |
1812091 | 1812091 | 2021-10-13 | Pamlico | North Carolina | 37137 | 1676 | 24 |
1808279 | 1808279 | 2021-10-12 | Watonwan | Minnesota | 27165 | 1676 | 11 |
1806511 | 1806511 | 2021-10-11 | Morgan | Utah | 49029 | 1676 | 11 |
1806649 | 1806649 | 2021-10-11 | Richmond | Virginia | 51159 | 1676 | 13 |
1803261 | 1803261 | 2021-10-10 | Morgan | Utah | 49029 | 1676 | 11 |
1803399 | 1803399 | 2021-10-10 | Richmond | Virginia | 51159 | 1676 | 13 |
1800012 | 1800012 | 2021-10-09 | Morgan | Utah | 49029 | 1676 | 11 |
1800150 | 1800150 | 2021-10-09 | Richmond | Virginia | 51159 | 1676 | 13 |
1796763 | 1796763 | 2021-10-08 | Morgan | Utah | 49029 | 1676 | 11 |
1796901 | 1796901 | 2021-10-08 | Richmond | Virginia | 51159 | 1676 | 13 |
1790795 | 1790795 | 2021-10-07 | Scott | Arkansas | 5127 | 1676 | 26 |
1784790 | 1784790 | 2021-10-05 | Menard | Illinois | 17129 | 1676 | 17 |
1778691 | 1778691 | 2021-10-03 | Lee | Kentucky | 21129 | 1676 | 29 |
1775441 | 1775441 | 2021-10-02 | Lee | Kentucky | 21129 | 1676 | 29 |
1772191 | 1772191 | 2021-10-01 | Lee | Kentucky | 21129 | 1676 | 29 |
1768942 | 1768942 | 2021-09-30 | Lee | Kentucky | 21129 | 1676 | 29 |
1767681 | 1767681 | 2021-09-29 | Westmoreland | Virginia | 51193 | 1676 | 31 |
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);