ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
287 rows where cases = 2111 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 28
- Georgia 22
- Texas 20
- North Carolina 18
- Missouri 17
- Mississippi 16
- South Dakota 16
- Kentucky 14
- Virginia 12
- Indiana 10
- Arkansas 8
- Idaho 8
- Illinois 8
- Louisiana 8
- Puerto Rico 8
- Alabama 7
- West Virginia 7
- Tennessee 6
- Minnesota 5
- Montana 5
- Nebraska 4
- North Dakota 4
- Ohio 4
- Pennsylvania 4
- California 3
- Colorado 3
- Kansas 3
- South Carolina 3
- Florida 2
- Maryland 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2497481 | 2497481 | 2022-05-12 | Red River | Louisiana | 22081 | 2111 | 53 |
2494223 | 2494223 | 2022-05-11 | Red River | Louisiana | 22081 | 2111 | 53 |
2430772 | 2430772 | 2022-04-21 | Somervell | Texas | 48425 | 2111 | 36 |
2427516 | 2427516 | 2022-04-20 | Somervell | Texas | 48425 | 2111 | 36 |
2424260 | 2424260 | 2022-04-19 | Somervell | Texas | 48425 | 2111 | 36 |
2421004 | 2421004 | 2022-04-18 | Somervell | Texas | 48425 | 2111 | 36 |
2391235 | 2391235 | 2022-04-09 | Jayuya | Puerto Rico | 72073 | 2111 | |
2387979 | 2387979 | 2022-04-08 | Jayuya | Puerto Rico | 72073 | 2111 | |
2356732 | 2356732 | 2022-03-30 | Candler | Georgia | 13043 | 2111 | 94 |
2353479 | 2353479 | 2022-03-29 | Candler | Georgia | 13043 | 2111 | 94 |
2311199 | 2311199 | 2022-03-16 | Clinch | Georgia | 13065 | 2111 | 40 |
2307946 | 2307946 | 2022-03-15 | Clinch | Georgia | 13065 | 2111 | 40 |
2266861 | 2266861 | 2022-03-02 | Beaverhead | Montana | 30001 | 2111 | 28 |
2258602 | 2258602 | 2022-02-27 | Doddridge | West Virginia | 54017 | 2111 | 17 |
2254635 | 2254635 | 2022-02-26 | Rincon | Puerto Rico | 72117 | 2111 | |
2255351 | 2255351 | 2022-02-26 | Doddridge | West Virginia | 54017 | 2111 | 17 |
2251384 | 2251384 | 2022-02-25 | Rincon | Puerto Rico | 72117 | 2111 | |
2252100 | 2252100 | 2022-02-25 | Doddridge | West Virginia | 54017 | 2111 | 17 |
2246224 | 2246224 | 2022-02-24 | Macon | Georgia | 13193 | 2111 | 48 |
2246770 | 2246770 | 2022-02-24 | Cumberland | Kentucky | 21057 | 2111 | 28 |
2243519 | 2243519 | 2022-02-23 | Cumberland | Kentucky | 21057 | 2111 | 28 |
2244148 | 2244148 | 2022-02-23 | Sanders | Montana | 30089 | 2111 | 45 |
2240897 | 2240897 | 2022-02-22 | Sanders | Montana | 30089 | 2111 | 45 |
2214759 | 2214759 | 2022-02-14 | DeKalb | Missouri | 29063 | 2111 | 42 |
2216005 | 2216005 | 2022-02-14 | Live Oak | Texas | 48297 | 2111 | 40 |
2198507 | 2198507 | 2022-02-09 | Howard | Missouri | 29089 | 2111 | 23 |
2194345 | 2194345 | 2022-02-08 | Hamilton | Illinois | 17065 | 2111 | 31 |
2192168 | 2192168 | 2022-02-07 | Hamilton | Nebraska | 31081 | 2111 | 22 |
2192415 | 2192415 | 2022-02-07 | Jones | North Carolina | 37103 | 2111 | 38 |
2188275 | 2188275 | 2022-02-06 | Livingston | Kentucky | 21139 | 2111 | 51 |
2190206 | 2190206 | 2022-02-06 | Lunenburg | Virginia | 51111 | 2111 | 24 |
2185022 | 2185022 | 2022-02-05 | Livingston | Kentucky | 21139 | 2111 | 51 |
2186953 | 2186953 | 2022-02-05 | Lunenburg | Virginia | 51111 | 2111 | 24 |
2181770 | 2181770 | 2022-02-04 | Livingston | Kentucky | 21139 | 2111 | 51 |
2183700 | 2183700 | 2022-02-04 | Lunenburg | Virginia | 51111 | 2111 | 24 |
2174497 | 2174497 | 2022-02-02 | San Miguel | Colorado | 8113 | 2111 | 7 |
2168444 | 2168444 | 2022-01-31 | Martin | Indiana | 18101 | 2111 | 23 |
2162693 | 2162693 | 2022-01-29 | Carroll | Missouri | 29033 | 2111 | 41 |
2163474 | 2163474 | 2022-01-29 | Forest | Pennsylvania | 42053 | 2111 | 34 |
2142094 | 2142094 | 2022-01-23 | Dooly | Georgia | 13093 | 2111 | 63 |
2142236 | 2142236 | 2022-01-23 | Franklin | Idaho | 16041 | 2111 | 27 |
2143586 | 2143586 | 2022-01-23 | Clay | North Carolina | 37043 | 2111 | 38 |
2138839 | 2138839 | 2022-01-22 | Dooly | Georgia | 13093 | 2111 | 63 |
2138981 | 2138981 | 2022-01-22 | Franklin | Idaho | 16041 | 2111 | 27 |
2140331 | 2140331 | 2022-01-22 | Clay | North Carolina | 37043 | 2111 | 38 |
2135583 | 2135583 | 2022-01-21 | Dooly | Georgia | 13093 | 2111 | 63 |
2135725 | 2135725 | 2022-01-21 | Franklin | Idaho | 16041 | 2111 | 27 |
2137075 | 2137075 | 2022-01-21 | Clay | North Carolina | 37043 | 2111 | 38 |
2132977 | 2132977 | 2022-01-20 | McLean | Kentucky | 21149 | 2111 | 43 |
2134783 | 2134783 | 2022-01-20 | Emery | Utah | 49015 | 2111 | 25 |
2100931 | 2100931 | 2022-01-10 | Lewis | Missouri | 29111 | 2111 | 31 |
2097680 | 2097680 | 2022-01-09 | Lewis | Missouri | 29111 | 2111 | 31 |
2094428 | 2094428 | 2022-01-08 | Lewis | Missouri | 29111 | 2111 | 31 |
2095214 | 2095214 | 2022-01-08 | Barceloneta | Puerto Rico | 72017 | 2111 | |
2011262 | 2011262 | 2021-12-13 | Unknown | Utah | 2111 | 49 | |
1993521 | 1993521 | 2021-12-08 | Amite | Mississippi | 28005 | 2111 | 57 |
1987635 | 1987635 | 2021-12-06 | McLean | North Dakota | 38055 | 2111 | 45 |
1967680 | 1967680 | 2021-11-30 | Pemiscot | Missouri | 29155 | 2111 | 57 |
1965425 | 1965425 | 2021-11-29 | Jackson | Tennessee | 47087 | 2111 | 40 |
1920745 | 1920745 | 2021-11-16 | Little River | Arkansas | 5081 | 2111 | 80 |
1916060 | 1916060 | 2021-11-14 | Mitchell | North Carolina | 37121 | 2111 | 21 |
1912810 | 1912810 | 2021-11-13 | Mitchell | North Carolina | 37121 | 2111 | 21 |
1909560 | 1909560 | 2021-11-12 | Mitchell | North Carolina | 37121 | 2111 | 21 |
1902440 | 1902440 | 2021-11-10 | Cottonwood | Minnesota | 27033 | 2111 | 29 |
1836308 | 1836308 | 2021-10-21 | Inyo | California | 6027 | 2111 | 40 |
1830079 | 1830079 | 2021-10-19 | Jasper | Georgia | 13159 | 2111 | 58 |
1824566 | 1824566 | 2021-10-17 | Lawrence | Mississippi | 28077 | 2111 | 40 |
1821317 | 1821317 | 2021-10-16 | Lawrence | Mississippi | 28077 | 2111 | 40 |
1818068 | 1818068 | 2021-10-15 | Lawrence | Mississippi | 28077 | 2111 | 40 |
1814819 | 1814819 | 2021-10-14 | Lawrence | Mississippi | 28077 | 2111 | 40 |
1810272 | 1810272 | 2021-10-13 | Marion | Arkansas | 5089 | 2111 | 57 |
1810814 | 1810814 | 2021-10-13 | Washington | Illinois | 17189 | 2111 | 34 |
1813325 | 1813325 | 2021-10-13 | Rusk | Wisconsin | 55107 | 2111 | 33 |
1807565 | 1807565 | 2021-10-12 | Washington | Illinois | 17189 | 2111 | 34 |
1787954 | 1787954 | 2021-10-06 | Gooding | Idaho | 16047 | 2111 | 36 |
1790347 | 1790347 | 2021-10-06 | Giles | Virginia | 51071 | 2111 | 28 |
1784377 | 1784377 | 2021-10-05 | Chaffee | Colorado | 8015 | 2111 | 28 |
1786713 | 1786713 | 2021-10-05 | Meigs | Tennessee | 47121 | 2111 | 27 |
1781374 | 1781374 | 2021-10-04 | Oglethorpe | Georgia | 13221 | 2111 | 38 |
1778975 | 1778975 | 2021-10-03 | Fillmore | Minnesota | 27045 | 2111 | 11 |
1775725 | 1775725 | 2021-10-02 | Fillmore | Minnesota | 27045 | 2111 | 11 |
1772475 | 1772475 | 2021-10-01 | Fillmore | Minnesota | 27045 | 2111 | 11 |
1769312 | 1769312 | 2021-09-30 | Greene | Mississippi | 28041 | 2111 | 46 |
1753689 | 1753689 | 2021-09-25 | Walsh | North Dakota | 38099 | 2111 | 27 |
1744754 | 1744754 | 2021-09-22 | Wilbarger | Texas | 48487 | 2111 | 56 |
1735402 | 1735402 | 2021-09-20 | Cleburne | Alabama | 1029 | 2111 | 48 |
1736457 | 1736457 | 2021-09-20 | Lewis | Kentucky | 21135 | 2111 | 49 |
1737368 | 1737368 | 2021-09-20 | Polk | North Carolina | 37149 | 2111 | 40 |
1735289 | 1735289 | 2021-09-19 | Wetzel | West Virginia | 54103 | 2111 | 37 |
1719184 | 1719184 | 2021-09-15 | Macon | Alabama | 1087 | 2111 | 54 |
1716657 | 1716657 | 2021-09-14 | Parke | Indiana | 18121 | 2111 | 19 |
1690636 | 1690636 | 2021-09-06 | Franklin | Indiana | 18047 | 2111 | 36 |
1687386 | 1687386 | 2021-09-05 | Franklin | Indiana | 18047 | 2111 | 36 |
1684136 | 1684136 | 2021-09-04 | Franklin | Indiana | 18047 | 2111 | 36 |
1680885 | 1680885 | 2021-09-03 | Franklin | Indiana | 18047 | 2111 | 36 |
1677988 | 1677988 | 2021-09-02 | Mason | Kentucky | 21161 | 2111 | 44 |
1671315 | 1671315 | 2021-08-31 | Bourbon | Kansas | 20011 | 2111 | 34 |
1668068 | 1668068 | 2021-08-30 | Bourbon | Kansas | 20011 | 2111 | 34 |
1664499 | 1664499 | 2021-08-29 | Gem | Idaho | 16045 | 2111 | 47 |
1661251 | 1661251 | 2021-08-28 | Gem | Idaho | 16045 | 2111 | 47 |
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);