ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
235 rows where cases = 2164 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 19
- Missouri 17
- North Carolina 16
- Kentucky 14
- Georgia 13
- Mississippi 12
- Virginia 11
- Texas 10
- Iowa 9
- Illinois 7
- Nebraska 7
- South Dakota 7
- West Virginia 7
- Minnesota 6
- Alabama 5
- California 5
- Colorado 5
- Kansas 5
- Ohio 5
- South Carolina 5
- Tennessee 5
- Wisconsin 5
- Montana 4
- New York 4
- North Dakota 4
- Pennsylvania 4
- Virgin Islands 4
- Florida 3
- Arizona 2
- Arkansas 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501237 | 2501237 | 2022-05-13 | Sanders | Montana | 30089 | 2164 | 47 |
2484647 | 2484647 | 2022-05-08 | Jackson | Minnesota | 27063 | 2164 | 17 |
2481389 | 2481389 | 2022-05-07 | Jackson | Minnesota | 27063 | 2164 | 17 |
2478131 | 2478131 | 2022-05-06 | Jackson | Minnesota | 27063 | 2164 | 17 |
2422171 | 2422171 | 2022-04-19 | Martin | Indiana | 18101 | 2164 | 25 |
2418915 | 2418915 | 2022-04-18 | Martin | Indiana | 18101 | 2164 | 25 |
2382114 | 2382114 | 2022-04-06 | Northumberland | Virginia | 51133 | 2164 | 45 |
2353823 | 2353823 | 2022-03-29 | Martin | Indiana | 18101 | 2164 | 25 |
2350571 | 2350571 | 2022-03-28 | Martin | Indiana | 18101 | 2164 | 25 |
2347318 | 2347318 | 2022-03-27 | Martin | Indiana | 18101 | 2164 | 25 |
2344065 | 2344065 | 2022-03-26 | Martin | Indiana | 18101 | 2164 | 25 |
2340812 | 2340812 | 2022-03-25 | Martin | Indiana | 18101 | 2164 | 25 |
2337559 | 2337559 | 2022-03-24 | Martin | Indiana | 18101 | 2164 | 25 |
2334305 | 2334305 | 2022-03-23 | Martin | Indiana | 18101 | 2164 | 25 |
2319992 | 2319992 | 2022-03-18 | Franklin | Texas | 48159 | 2164 | 41 |
2305841 | 2305841 | 2022-03-14 | Monroe | Missouri | 29137 | 2164 | 40 |
2302061 | 2302061 | 2022-03-13 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2302471 | 2302471 | 2022-03-13 | Kemper | Mississippi | 28069 | 2164 | 47 |
2298809 | 2298809 | 2022-03-12 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2299219 | 2299219 | 2022-03-12 | Kemper | Mississippi | 28069 | 2164 | 47 |
2295557 | 2295557 | 2022-03-11 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2295967 | 2295967 | 2022-03-11 | Kemper | Mississippi | 28069 | 2164 | 47 |
2292305 | 2292305 | 2022-03-10 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2292715 | 2292715 | 2022-03-10 | Kemper | Mississippi | 28069 | 2164 | 47 |
2289053 | 2289053 | 2022-03-09 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2289463 | 2289463 | 2022-03-09 | Kemper | Mississippi | 28069 | 2164 | 47 |
2285396 | 2285396 | 2022-03-08 | Hamilton | Illinois | 17065 | 2164 | 34 |
2285802 | 2285802 | 2022-03-08 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2286212 | 2286212 | 2022-03-08 | Kemper | Mississippi | 28069 | 2164 | 47 |
2282144 | 2282144 | 2022-03-07 | Hamilton | Illinois | 17065 | 2164 | 34 |
2282550 | 2282550 | 2022-03-07 | Gallatin | Kentucky | 21077 | 2164 | 45 |
2271647 | 2271647 | 2022-03-03 | Tyler | West Virginia | 54095 | 2164 | 30 |
2210079 | 2210079 | 2022-02-13 | Greenlee | Arizona | 4011 | 2164 | 31 |
2200794 | 2200794 | 2022-02-10 | Clearwater | Idaho | 16035 | 2164 | 31 |
2198642 | 2198642 | 2022-02-09 | Box Butte | Nebraska | 31013 | 2164 | 16 |
2188943 | 2188943 | 2022-02-06 | Phelps | Nebraska | 31137 | 2164 | 11 |
2190313 | 2190313 | 2022-02-06 | Clay | West Virginia | 54015 | 2164 | 31 |
2185690 | 2185690 | 2022-02-05 | Phelps | Nebraska | 31137 | 2164 | 11 |
2182438 | 2182438 | 2022-02-04 | Phelps | Nebraska | 31137 | 2164 | 11 |
2179190 | 2179190 | 2022-02-03 | Red Willow | Nebraska | 31145 | 2164 | 19 |
2161429 | 2161429 | 2022-01-29 | Bent | Colorado | 8011 | 2164 | 46 |
2154920 | 2154920 | 2022-01-27 | Bent | Colorado | 8011 | 2164 | 46 |
2151853 | 2151853 | 2022-01-26 | Dooly | Georgia | 13093 | 2164 | 63 |
2147884 | 2147884 | 2022-01-24 | Floyd | Virginia | 51063 | 2164 | 33 |
2105150 | 2105150 | 2022-01-11 | Todd | South Dakota | 46121 | 2164 | 40 |
2082848 | 2082848 | 2022-01-04 | Greensville | Virginia | 51081 | 2164 | 30 |
2029870 | 2029870 | 2021-12-19 | Barnes | North Dakota | 38003 | 2164 | 40 |
2030346 | 2030346 | 2021-12-19 | Dewey | South Dakota | 46041 | 2164 | 34 |
2027095 | 2027095 | 2021-12-18 | Dewey | South Dakota | 46041 | 2164 | 34 |
2023394 | 2023394 | 2021-12-17 | McLean | North Dakota | 38055 | 2164 | 47 |
2023844 | 2023844 | 2021-12-17 | Dewey | South Dakota | 46041 | 2164 | 34 |
2020593 | 2020593 | 2021-12-16 | Dewey | South Dakota | 46041 | 2164 | 34 |
2007012 | 2007012 | 2021-12-12 | Yates | New York | 36123 | 2164 | 34 |
1993287 | 1993287 | 2021-12-08 | West Carroll | Louisiana | 22123 | 2164 | 52 |
1993633 | 1993633 | 2021-12-08 | Dent | Missouri | 29065 | 2164 | 62 |
1989874 | 1989874 | 2021-12-07 | Carroll | Kentucky | 21041 | 2164 | 32 |
1964975 | 1964975 | 2021-11-29 | Noble | Ohio | 39121 | 2164 | 47 |
1937314 | 1937314 | 2021-11-21 | Jasper | Georgia | 13159 | 2164 | 60 |
1934064 | 1934064 | 2021-11-20 | Jasper | Georgia | 13159 | 2164 | 60 |
1930812 | 1930812 | 2021-11-19 | Jasper | Georgia | 13159 | 2164 | 60 |
1923203 | 1923203 | 2021-11-16 | Stewart | Tennessee | 47161 | 2164 | 35 |
1918798 | 1918798 | 2021-11-15 | Lawrence | Mississippi | 28077 | 2164 | 40 |
1910725 | 1910725 | 2021-11-12 | Monroe | West Virginia | 54063 | 2164 | 26 |
1898001 | 1898001 | 2021-11-09 | Marion | Arkansas | 5089 | 2164 | 59 |
1877806 | 1877806 | 2021-11-02 | Gaines | Texas | 48165 | 2164 | 60 |
1874952 | 1874952 | 2021-11-01 | Braxton | West Virginia | 54007 | 2164 | 21 |
1870224 | 1870224 | 2021-10-31 | Custer | Montana | 30017 | 2164 | 35 |
1866975 | 1866975 | 2021-10-30 | Custer | Montana | 30017 | 2164 | 35 |
1863726 | 1863726 | 2021-10-29 | Custer | Montana | 30017 | 2164 | 35 |
1836078 | 1836078 | 2021-10-20 | Washburn | Wisconsin | 55129 | 2164 | 27 |
1827895 | 1827895 | 2021-10-18 | Gasconade | Missouri | 29073 | 2164 | 49 |
1824646 | 1824646 | 2021-10-17 | Gasconade | Missouri | 29073 | 2164 | 49 |
1821397 | 1821397 | 2021-10-16 | Gasconade | Missouri | 29073 | 2164 | 49 |
1818148 | 1818148 | 2021-10-15 | Gasconade | Missouri | 29073 | 2164 | 49 |
1813619 | 1813619 | 2021-10-14 | Chaffee | Colorado | 8015 | 2164 | 30 |
1793786 | 1793786 | 2021-10-07 | Crawford | Wisconsin | 55023 | 2164 | 22 |
1776266 | 1776266 | 2021-10-02 | Schoharie | New York | 36095 | 2164 | 21 |
1765151 | 1765151 | 2021-09-29 | Telfair | Georgia | 13271 | 2164 | 65 |
1746152 | 1746152 | 2021-09-23 | Butler | Kentucky | 21031 | 2164 | 29 |
1747367 | 1747367 | 2021-09-23 | Clatsop | Oregon | 41007 | 2164 | 26 |
1733037 | 1733037 | 2021-09-19 | Atchison | Kansas | 20005 | 2164 | 23 |
1729787 | 1729787 | 2021-09-18 | Atchison | Kansas | 20005 | 2164 | 23 |
1726537 | 1726537 | 2021-09-17 | Atchison | Kansas | 20005 | 2164 | 23 |
1723885 | 1723885 | 2021-09-16 | Yalobusha | Mississippi | 28161 | 2164 | 47 |
1723949 | 1723949 | 2021-09-16 | Madison | Missouri | 29123 | 2164 | 19 |
1722260 | 1722260 | 2021-09-15 | Lincoln | West Virginia | 54043 | 2164 | 31 |
1697133 | 1697133 | 2021-09-08 | Franklin | Indiana | 18047 | 2164 | 37 |
1692366 | 1692366 | 2021-09-06 | Saluda | South Carolina | 45081 | 2164 | 49 |
1670090 | 1670090 | 2021-08-30 | St. Croix | Virgin Islands | 78010 | 2164 | 17 |
1666843 | 1666843 | 2021-08-29 | St. Croix | Virgin Islands | 78010 | 2164 | 17 |
1663595 | 1663595 | 2021-08-28 | St. Croix | Virgin Islands | 78010 | 2164 | 17 |
1660347 | 1660347 | 2021-08-27 | St. Croix | Virgin Islands | 78010 | 2164 | 17 |
1656687 | 1656687 | 2021-08-26 | Oglala Lakota | South Dakota | 46102 | 2164 | 51 |
1656789 | 1656789 | 2021-08-26 | Union | Tennessee | 47173 | 2164 | 35 |
1653848 | 1653848 | 2021-08-25 | Washington | Vermont | 50023 | 2164 | 16 |
1648076 | 1648076 | 2021-08-24 | Banks | Georgia | 13011 | 2164 | 47 |
1632826 | 1632826 | 2021-08-19 | Roseau | Minnesota | 27135 | 2164 | 21 |
1624689 | 1624689 | 2021-08-16 | Louisa | Virginia | 51109 | 2164 | 35 |
1618500 | 1618500 | 2021-08-15 | Randolph | Alabama | 1111 | 2164 | 53 |
1616762 | 1616762 | 2021-08-14 | Moniteau | Missouri | 29135 | 2164 | 33 |
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);