ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
182 rows where cases = 2982 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 22
- Minnesota 16
- Idaho 14
- Mississippi 11
- Arkansas 10
- Iowa 9
- Kentucky 9
- Virginia 9
- Ohio 8
- Missouri 7
- Georgia 5
- Indiana 5
- Puerto Rico 5
- Tennessee 5
- West Virginia 5
- Louisiana 4
- Maryland 4
- North Carolina 4
- Alabama 3
- Michigan 3
- Pennsylvania 3
- California 2
- Colorado 2
- Illinois 2
- Oklahoma 2
- South Dakota 2
- Washington 2
- Wisconsin 2
- Alaska 1
- Florida 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500688 | 2500688 | 2022-05-13 | Todd | Kentucky | 21219 | 2982 | 43 |
2497430 | 2497430 | 2022-05-12 | Todd | Kentucky | 21219 | 2982 | 43 |
2494172 | 2494172 | 2022-05-11 | Todd | Kentucky | 21219 | 2982 | 43 |
2490914 | 2490914 | 2022-05-10 | Todd | Kentucky | 21219 | 2982 | 43 |
2487657 | 2487657 | 2022-05-09 | Todd | Kentucky | 21219 | 2982 | 43 |
2439026 | 2439026 | 2022-04-24 | Aitkin | Minnesota | 27001 | 2982 | 62 |
2435770 | 2435770 | 2022-04-23 | Aitkin | Minnesota | 27001 | 2982 | 62 |
2432514 | 2432514 | 2022-04-22 | Aitkin | Minnesota | 27001 | 2982 | 62 |
2430321 | 2430321 | 2022-04-21 | Orocovis | Puerto Rico | 72107 | 2982 | |
2373170 | 2373170 | 2022-04-04 | Idaho | Idaho | 16049 | 2982 | 51 |
2369917 | 2369917 | 2022-04-03 | Idaho | Idaho | 16049 | 2982 | 51 |
2366664 | 2366664 | 2022-04-02 | Idaho | Idaho | 16049 | 2982 | 51 |
2363411 | 2363411 | 2022-04-01 | Idaho | Idaho | 16049 | 2982 | 51 |
2360157 | 2360157 | 2022-03-31 | Idaho | Idaho | 16049 | 2982 | 51 |
2356903 | 2356903 | 2022-03-30 | Idaho | Idaho | 16049 | 2982 | 51 |
2353650 | 2353650 | 2022-03-29 | Idaho | Idaho | 16049 | 2982 | 51 |
2350398 | 2350398 | 2022-03-28 | Idaho | Idaho | 16049 | 2982 | 51 |
2347145 | 2347145 | 2022-03-27 | Idaho | Idaho | 16049 | 2982 | 51 |
2343892 | 2343892 | 2022-03-26 | Idaho | Idaho | 16049 | 2982 | 51 |
2340639 | 2340639 | 2022-03-25 | Idaho | Idaho | 16049 | 2982 | 51 |
2337386 | 2337386 | 2022-03-24 | Idaho | Idaho | 16049 | 2982 | 51 |
2307640 | 2307640 | 2022-03-15 | Bradley | Arkansas | 5011 | 2982 | 46 |
2304389 | 2304389 | 2022-03-14 | Bradley | Arkansas | 5011 | 2982 | 46 |
2223201 | 2223201 | 2022-02-17 | Plumas | California | 6063 | 2982 | 13 |
2224322 | 2224322 | 2022-02-17 | Chippewa | Minnesota | 27023 | 2982 | 47 |
2216699 | 2216699 | 2022-02-15 | Plumas | California | 6063 | 2982 | 13 |
2173261 | 2173261 | 2022-02-01 | Potter | Pennsylvania | 42105 | 2982 | 86 |
2173634 | 2173634 | 2022-02-01 | Duval | Texas | 48131 | 2982 | 64 |
2150289 | 2150289 | 2022-01-25 | Noble | Ohio | 39121 | 2982 | 52 |
2132958 | 2132958 | 2022-01-20 | Larue | Kentucky | 21123 | 2982 | 59 |
2123900 | 2123900 | 2022-01-17 | York | Nebraska | 31185 | 2982 | 19 |
2121003 | 2121003 | 2022-01-16 | Monroe | Ohio | 39111 | 2982 | 68 |
2092327 | 2092327 | 2022-01-07 | Freestone | Texas | 48161 | 2982 | 75 |
2031250 | 2031250 | 2021-12-20 | Grant | Arkansas | 5053 | 2982 | 52 |
2017385 | 2017385 | 2021-12-15 | Union | South Dakota | 46127 | 2982 | 46 |
2009056 | 2009056 | 2021-12-13 | White | Illinois | 17193 | 2982 | 43 |
2007942 | 2007942 | 2021-12-12 | Shelby | Texas | 48419 | 2982 | 113 |
1995486 | 1995486 | 2021-12-09 | Drew | Arkansas | 5043 | 2982 | 56 |
1995824 | 1995824 | 2021-12-09 | Jeff Davis | Georgia | 13161 | 2982 | 61 |
1989580 | 1989580 | 2021-12-07 | Franklin | Indiana | 18047 | 2982 | 50 |
1989669 | 1989669 | 2021-12-07 | Clay | Iowa | 19041 | 2982 | 36 |
1986419 | 1986419 | 2021-12-06 | Clay | Iowa | 19041 | 2982 | 36 |
1983169 | 1983169 | 2021-12-05 | Clay | Iowa | 19041 | 2982 | 36 |
1979919 | 1979919 | 2021-12-04 | Clay | Iowa | 19041 | 2982 | 36 |
1976669 | 1976669 | 2021-12-03 | Clay | Iowa | 19041 | 2982 | 36 |
1977376 | 1977376 | 2021-12-03 | Cooper | Missouri | 29053 | 2982 | 53 |
1973420 | 1973420 | 2021-12-02 | Clay | Iowa | 19041 | 2982 | 36 |
1974126 | 1974126 | 2021-12-02 | Cooper | Missouri | 29053 | 2982 | 53 |
1970170 | 1970170 | 2021-12-01 | Clay | Iowa | 19041 | 2982 | 36 |
1961008 | 1961008 | 2021-11-28 | Wadena | Minnesota | 27159 | 2982 | 39 |
1962369 | 1962369 | 2021-11-28 | Lee | Texas | 48287 | 2982 | 54 |
1957757 | 1957757 | 2021-11-27 | Wadena | Minnesota | 27159 | 2982 | 39 |
1959118 | 1959118 | 2021-11-27 | Lee | Texas | 48287 | 2982 | 54 |
1954506 | 1954506 | 2021-11-26 | Wadena | Minnesota | 27159 | 2982 | 39 |
1955867 | 1955867 | 2021-11-26 | Lee | Texas | 48287 | 2982 | 54 |
1952616 | 1952616 | 2021-11-25 | Lee | Texas | 48287 | 2982 | 54 |
1949365 | 1949365 | 2021-11-24 | Lee | Texas | 48287 | 2982 | 54 |
1922924 | 1922924 | 2021-11-16 | Wyoming | Pennsylvania | 42131 | 2982 | 65 |
1918568 | 1918568 | 2021-11-15 | Talbot | Maryland | 24041 | 2982 | 55 |
1920221 | 1920221 | 2021-11-15 | Young | Texas | 48503 | 2982 | 71 |
1916971 | 1916971 | 2021-11-14 | Young | Texas | 48503 | 2982 | 71 |
1917124 | 1917124 | 2021-11-14 | Radford city | Virginia | 51750 | 2982 | 35 |
1913721 | 1913721 | 2021-11-13 | Young | Texas | 48503 | 2982 | 71 |
1913874 | 1913874 | 2021-11-13 | Radford city | Virginia | 51750 | 2982 | 35 |
1910471 | 1910471 | 2021-11-12 | Young | Texas | 48503 | 2982 | 71 |
1910624 | 1910624 | 2021-11-12 | Radford city | Virginia | 51750 | 2982 | 35 |
1907222 | 1907222 | 2021-11-11 | Young | Texas | 48503 | 2982 | 71 |
1895085 | 1895085 | 2021-11-08 | Meriwether | Georgia | 13199 | 2982 | 112 |
1862270 | 1862270 | 2021-10-29 | Polk | Arkansas | 5113 | 2982 | 110 |
1863710 | 1863710 | 2021-10-29 | Texas | Missouri | 29215 | 2982 | 42 |
1824327 | 1824327 | 2021-10-17 | Garrett | Maryland | 24023 | 2982 | 77 |
1809980 | 1809980 | 2021-10-12 | Hampshire | West Virginia | 54027 | 2982 | 47 |
1785422 | 1785422 | 2021-10-05 | Menominee | Michigan | 26109 | 2982 | 48 |
1782173 | 1782173 | 2021-10-04 | Menominee | Michigan | 26109 | 2982 | 48 |
1768926 | 1768926 | 2021-09-30 | Harrison | Kentucky | 21097 | 2982 | 29 |
1766994 | 1766994 | 2021-09-29 | Humacao | Puerto Rico | 72069 | 2982 | |
1762806 | 1762806 | 2021-09-28 | Clay | Mississippi | 28025 | 2982 | 74 |
1748237 | 1748237 | 2021-09-23 | Boone | West Virginia | 54005 | 2982 | 38 |
1716040 | 1716040 | 2021-09-14 | Lawrence | Arkansas | 5075 | 2982 | 47 |
1708783 | 1708783 | 2021-09-11 | Austin | Texas | 48015 | 2982 | 45 |
1702486 | 1702486 | 2021-09-09 | Scurry | Texas | 48415 | 2982 | 68 |
1698979 | 1698979 | 2021-09-08 | Johnson | Tennessee | 47091 | 2982 | 41 |
1682258 | 1682258 | 2021-09-03 | Holmes | Ohio | 39075 | 2982 | 103 |
1678997 | 1678997 | 2021-09-02 | Gallia | Ohio | 39053 | 2982 | 53 |
1645074 | 1645074 | 2021-08-23 | Jersey | Illinois | 17083 | 2982 | 71 |
1647226 | 1647226 | 2021-08-23 | Moore | Texas | 48341 | 2982 | 76 |
1642585 | 1642585 | 2021-08-22 | Todd | Minnesota | 27153 | 2982 | 33 |
1643977 | 1643977 | 2021-08-22 | Moore | Texas | 48341 | 2982 | 76 |
1639335 | 1639335 | 2021-08-21 | Todd | Minnesota | 27153 | 2982 | 33 |
1640727 | 1640727 | 2021-08-21 | Moore | Texas | 48341 | 2982 | 76 |
1636085 | 1636085 | 2021-08-20 | Todd | Minnesota | 27153 | 2982 | 33 |
1637335 | 1637335 | 2021-08-20 | Calhoun | Texas | 48057 | 2982 | 26 |
1634421 | 1634421 | 2021-08-19 | Hopewell city | Virginia | 51670 | 2982 | 79 |
1620801 | 1620801 | 2021-08-15 | Dorado | Puerto Rico | 72051 | 2982 | |
1589014 | 1589014 | 2021-08-05 | Winchester city | Virginia | 51840 | 2982 | 48 |
1585765 | 1585765 | 2021-08-04 | Winchester city | Virginia | 51840 | 2982 | 48 |
1582596 | 1582596 | 2021-08-03 | Preston | West Virginia | 54077 | 2982 | 47 |
1557442 | 1557442 | 2021-07-27 | Decatur | Indiana | 18031 | 2982 | 97 |
1538722 | 1538722 | 2021-07-21 | Tippah | Mississippi | 28139 | 2982 | 68 |
1535127 | 1535127 | 2021-07-20 | De Soto | Louisiana | 22031 | 2982 | 79 |
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);