ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
259 rows where cases = 2223 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 22
- Kentucky 22
- Tennessee 16
- Texas 16
- Mississippi 15
- Florida 13
- Alabama 12
- Missouri 12
- Virginia 10
- Indiana 9
- Iowa 9
- Arkansas 8
- Puerto Rico 8
- Michigan 7
- Rhode Island 7
- Illinois 6
- West Virginia 6
- Colorado 5
- Pennsylvania 5
- North Carolina 4
- Utah 4
- Kansas 3
- Louisiana 3
- Massachusetts 3
- Montana 3
- Nebraska 3
- Ohio 3
- Oregon 3
- Washington 3
- Hawaii 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2433560 | 2433560 | 2022-04-22 | Jayuya | Puerto Rico | 72073 | 2223 | |
2421732 | 2421732 | 2022-04-19 | Unknown | Connecticut | 2223 | 1 | |
2384687 | 2384687 | 2022-04-07 | Adjuntas | Puerto Rico | 72001 | 2223 | |
2348955 | 2348955 | 2022-03-27 | Penuelas | Puerto Rico | 72111 | 2223 | |
2338319 | 2338319 | 2022-03-24 | Carroll | Missouri | 29033 | 2223 | 44 |
2335065 | 2335065 | 2022-03-23 | Carroll | Missouri | 29033 | 2223 | 44 |
2331811 | 2331811 | 2022-03-22 | Carroll | Missouri | 29033 | 2223 | 44 |
2332842 | 2332842 | 2022-03-22 | Clay | Tennessee | 47027 | 2223 | 49 |
2328558 | 2328558 | 2022-03-21 | Carroll | Missouri | 29033 | 2223 | 44 |
2329589 | 2329589 | 2022-03-21 | Clay | Tennessee | 47027 | 2223 | 49 |
2326337 | 2326337 | 2022-03-20 | Clay | Tennessee | 47027 | 2223 | 49 |
2323084 | 2323084 | 2022-03-19 | Clay | Tennessee | 47027 | 2223 | 49 |
2319830 | 2319830 | 2022-03-18 | Clay | Tennessee | 47027 | 2223 | 49 |
2316427 | 2316427 | 2022-03-17 | Sabana Grande | Puerto Rico | 72121 | 2223 | |
2316576 | 2316576 | 2022-03-17 | Clay | Tennessee | 47027 | 2223 | 49 |
2317035 | 2317035 | 2022-03-17 | Madison | Virginia | 51113 | 2223 | 37 |
2313174 | 2313174 | 2022-03-16 | Sabana Grande | Puerto Rico | 72121 | 2223 | |
2313323 | 2313323 | 2022-03-16 | Clay | Tennessee | 47027 | 2223 | 49 |
2309921 | 2309921 | 2022-03-15 | Sabana Grande | Puerto Rico | 72121 | 2223 | |
2306668 | 2306668 | 2022-03-14 | Sabana Grande | Puerto Rico | 72121 | 2223 | |
2245454 | 2245454 | 2022-02-23 | Essex | Virginia | 51057 | 2223 | 28 |
2242203 | 2242203 | 2022-02-22 | Essex | Virginia | 51057 | 2223 | 28 |
2224926 | 2224926 | 2022-02-17 | Graham | North Carolina | 37075 | 2223 | 30 |
2220280 | 2220280 | 2022-02-16 | Wilkes | Georgia | 13317 | 2223 | 46 |
2217029 | 2217029 | 2022-02-15 | Wilkes | Georgia | 13317 | 2223 | 46 |
2210151 | 2210151 | 2022-02-13 | Scott | Arkansas | 5127 | 2223 | 38 |
2210526 | 2210526 | 2022-02-13 | Wilkes | Georgia | 13317 | 2223 | 45 |
2207273 | 2207273 | 2022-02-12 | Wilkes | Georgia | 13317 | 2223 | 45 |
2204020 | 2204020 | 2022-02-11 | Wilkes | Georgia | 13317 | 2223 | 45 |
2178984 | 2178984 | 2022-02-03 | Grundy | Missouri | 29079 | 2223 | 62 |
2082574 | 2082574 | 2022-01-04 | Gaines | Texas | 48165 | 2223 | 69 |
2078372 | 2078372 | 2022-01-03 | Unknown | Nebraska | 2223 | 270 | |
2051850 | 2051850 | 2021-12-26 | Nantucket | Massachusetts | 25019 | 2223 | 0 |
2048600 | 2048600 | 2021-12-25 | Nantucket | Massachusetts | 25019 | 2223 | 0 |
2045350 | 2045350 | 2021-12-24 | Nantucket | Massachusetts | 25019 | 2223 | 0 |
2009846 | 2009846 | 2021-12-13 | Walthall | Mississippi | 28147 | 2223 | 66 |
2006355 | 2006355 | 2021-12-12 | Arenac | Michigan | 26011 | 2223 | 49 |
2006595 | 2006595 | 2021-12-12 | Walthall | Mississippi | 28147 | 2223 | 66 |
2003104 | 2003104 | 2021-12-11 | Arenac | Michigan | 26011 | 2223 | 49 |
2003344 | 2003344 | 2021-12-11 | Walthall | Mississippi | 28147 | 2223 | 66 |
1999854 | 1999854 | 2021-12-10 | Arenac | Michigan | 26011 | 2223 | 49 |
2000094 | 2000094 | 2021-12-10 | Walthall | Mississippi | 28147 | 2223 | 66 |
1996843 | 1996843 | 2021-12-09 | Walthall | Mississippi | 28147 | 2223 | 66 |
1997613 | 1997613 | 2021-12-09 | Tillamook | Oregon | 41057 | 2223 | 47 |
1993592 | 1993592 | 2021-12-08 | Walthall | Mississippi | 28147 | 2223 | 66 |
1983640 | 1983640 | 2021-12-05 | Leelanau | Michigan | 26089 | 2223 | 35 |
1980390 | 1980390 | 2021-12-04 | Leelanau | Michigan | 26089 | 2223 | 35 |
1977140 | 1977140 | 2021-12-03 | Leelanau | Michigan | 26089 | 2223 | 35 |
1972358 | 1972358 | 2021-12-01 | Martinsville city | Virginia | 51690 | 2223 | 94 |
1967839 | 1967839 | 2021-11-30 | Otoe | Nebraska | 31131 | 2223 | 16 |
1963206 | 1963206 | 2021-11-29 | Lafayette | Florida | 12067 | 2223 | 49 |
1959955 | 1959955 | 2021-11-28 | Lafayette | Florida | 12067 | 2223 | 49 |
1962190 | 1962190 | 2021-11-28 | Meigs | Tennessee | 47121 | 2223 | 31 |
1956704 | 1956704 | 2021-11-27 | Lafayette | Florida | 12067 | 2223 | 49 |
1958939 | 1958939 | 2021-11-27 | Meigs | Tennessee | 47121 | 2223 | 31 |
1953453 | 1953453 | 2021-11-26 | Lafayette | Florida | 12067 | 2223 | 49 |
1955688 | 1955688 | 2021-11-26 | Meigs | Tennessee | 47121 | 2223 | 31 |
1950202 | 1950202 | 2021-11-25 | Lafayette | Florida | 12067 | 2223 | 49 |
1952437 | 1952437 | 2021-11-25 | Meigs | Tennessee | 47121 | 2223 | 31 |
1946951 | 1946951 | 2021-11-24 | Lafayette | Florida | 12067 | 2223 | 49 |
1949186 | 1949186 | 2021-11-24 | Meigs | Tennessee | 47121 | 2223 | 31 |
1943700 | 1943700 | 2021-11-23 | Lafayette | Florida | 12067 | 2223 | 49 |
1945935 | 1945935 | 2021-11-23 | Meigs | Tennessee | 47121 | 2223 | 31 |
1940450 | 1940450 | 2021-11-22 | Lafayette | Florida | 12067 | 2223 | 49 |
1937200 | 1937200 | 2021-11-21 | Lafayette | Florida | 12067 | 2223 | 49 |
1933950 | 1933950 | 2021-11-20 | Lafayette | Florida | 12067 | 2223 | 49 |
1930698 | 1930698 | 2021-11-19 | Lafayette | Florida | 12067 | 2223 | 51 |
1930005 | 1930005 | 2021-11-18 | Caledonia | Vermont | 50005 | 2223 | 21 |
1882259 | 1882259 | 2021-11-04 | Massac | Illinois | 17127 | 2223 | 56 |
1882672 | 1882672 | 2021-11-04 | Magoffin | Kentucky | 21153 | 2223 | 22 |
1879980 | 1879980 | 2021-11-03 | Glacier | Montana | 30035 | 2223 | 54 |
1878078 | 1878078 | 2021-11-02 | Greene | Virginia | 51079 | 2223 | 41 |
1853186 | 1853186 | 2021-10-26 | Floyd | Iowa | 19067 | 2223 | 45 |
1854649 | 1854649 | 2021-10-26 | Fulton | Pennsylvania | 42057 | 2223 | 29 |
1849937 | 1849937 | 2021-10-25 | Floyd | Iowa | 19067 | 2223 | 45 |
1846687 | 1846687 | 2021-10-24 | Floyd | Iowa | 19067 | 2223 | 45 |
1843437 | 1843437 | 2021-10-23 | Floyd | Iowa | 19067 | 2223 | 45 |
1840187 | 1840187 | 2021-10-22 | Floyd | Iowa | 19067 | 2223 | 45 |
1836938 | 1836938 | 2021-10-21 | Floyd | Iowa | 19067 | 2223 | 45 |
1833689 | 1833689 | 2021-10-20 | Floyd | Iowa | 19067 | 2223 | 45 |
1761933 | 1761933 | 2021-09-28 | Kauai | Hawaii | 15007 | 2223 | 8 |
1736506 | 1736506 | 2021-09-20 | Webster | Kentucky | 21233 | 2223 | 31 |
1722791 | 1722791 | 2021-09-16 | Bleckley | Georgia | 13023 | 2223 | 58 |
1724938 | 1724938 | 2021-09-16 | Decatur | Tennessee | 47039 | 2223 | 41 |
1725514 | 1725514 | 2021-09-16 | McDowell | West Virginia | 54047 | 2223 | 28 |
1720219 | 1720219 | 2021-09-15 | Mason | Kentucky | 21161 | 2223 | 46 |
1710127 | 1710127 | 2021-09-12 | Franklin | Indiana | 18047 | 2223 | 37 |
1706880 | 1706880 | 2021-09-11 | Franklin | Indiana | 18047 | 2223 | 37 |
1703632 | 1703632 | 2021-09-10 | Franklin | Indiana | 18047 | 2223 | 37 |
1671522 | 1671522 | 2021-08-31 | Spencer | Kentucky | 21215 | 2223 | 26 |
1664836 | 1664836 | 2021-08-29 | Dickinson | Kansas | 20041 | 2223 | 50 |
1661588 | 1661588 | 2021-08-28 | Dickinson | Kansas | 20041 | 2223 | 50 |
1658340 | 1658340 | 2021-08-27 | Dickinson | Kansas | 20041 | 2223 | 50 |
1653186 | 1653186 | 2021-08-25 | Union | Oregon | 41061 | 2223 | 30 |
1646475 | 1646475 | 2021-08-23 | Rolette | North Dakota | 38079 | 2223 | 28 |
1634691 | 1634691 | 2021-08-20 | Cherokee | Alabama | 1019 | 2223 | 49 |
1631691 | 1631691 | 2021-08-19 | Crowley | Colorado | 8025 | 2223 | 18 |
1628444 | 1628444 | 2021-08-18 | Crowley | Colorado | 8025 | 2223 | 18 |
1628795 | 1628795 | 2021-08-18 | Cass | Illinois | 17017 | 2223 | 36 |
1625197 | 1625197 | 2021-08-17 | Crowley | Colorado | 8025 | 2223 | 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);