ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
66 rows where cases = 6338 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- New York 8
- Michigan 6
- Mississippi 6
- Virginia 6
- Nebraska 5
- Louisiana 4
- North Carolina 4
- Wyoming 4
- South Dakota 3
- California 2
- Indiana 2
- Maryland 2
- Minnesota 2
- Missouri 2
- Ohio 2
- Alabama 1
- Georgia 1
- Kentucky 1
- Massachusetts 1
- New Mexico 1
- Pennsylvania 1
- South Carolina 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2448630 | 2448630 | 2022-04-27 | Sabine | Louisiana | 22085 | 6338 | 111 |
2440759 | 2440759 | 2022-04-24 | Winchester city | Virginia | 51840 | 6338 | 79 |
2437503 | 2437503 | 2022-04-23 | Winchester city | Virginia | 51840 | 6338 | 79 |
2434247 | 2434247 | 2022-04-22 | Winchester city | Virginia | 51840 | 6338 | 79 |
2191861 | 2191861 | 2022-02-07 | Todd | Minnesota | 27153 | 6338 | 54 |
2192558 | 2192558 | 2022-02-07 | Hocking | Ohio | 39073 | 6338 | 109 |
2189708 | 2189708 | 2022-02-06 | Lawrence | South Dakota | 46081 | 6338 | 79 |
2186455 | 2186455 | 2022-02-05 | Lawrence | South Dakota | 46081 | 6338 | 79 |
2183203 | 2183203 | 2022-02-04 | Lawrence | South Dakota | 46081 | 6338 | 79 |
2168140 | 2168140 | 2022-01-31 | Gilmer | Georgia | 13123 | 6338 | 152 |
2110712 | 2110712 | 2022-01-13 | Polk | Missouri | 29167 | 6338 | 83 |
2103963 | 2103963 | 2022-01-11 | Carlton | Minnesota | 27017 | 6338 | 81 |
2055603 | 2055603 | 2021-12-27 | Platte | Nebraska | 31141 | 6338 | 60 |
2052353 | 2052353 | 2021-12-26 | Platte | Nebraska | 31141 | 6338 | 60 |
2049103 | 2049103 | 2021-12-25 | Platte | Nebraska | 31141 | 6338 | 60 |
2045853 | 2045853 | 2021-12-24 | Platte | Nebraska | 31141 | 6338 | 60 |
2042603 | 2042603 | 2021-12-23 | Platte | Nebraska | 31141 | 6338 | 60 |
1986318 | 1986318 | 2021-12-06 | Clinton | Indiana | 18023 | 6338 | 85 |
1966132 | 1966132 | 2021-11-30 | Franklin | Alabama | 1059 | 6338 | 108 |
1961088 | 1961088 | 2021-11-28 | Union | Mississippi | 28145 | 6338 | 97 |
1957837 | 1957837 | 2021-11-27 | Union | Mississippi | 28145 | 6338 | 97 |
1954586 | 1954586 | 2021-11-26 | Union | Mississippi | 28145 | 6338 | 97 |
1951335 | 1951335 | 2021-11-25 | Union | Mississippi | 28145 | 6338 | 97 |
1948084 | 1948084 | 2021-11-24 | Union | Mississippi | 28145 | 6338 | 97 |
1915263 | 1915263 | 2021-11-14 | St. John the Baptist | Louisiana | 22095 | 6338 | 171 |
1917054 | 1917054 | 2021-11-14 | Danville city | Virginia | 51590 | 6338 | 195 |
1912013 | 1912013 | 2021-11-13 | St. John the Baptist | Louisiana | 22095 | 6338 | 171 |
1913804 | 1913804 | 2021-11-13 | Danville city | Virginia | 51590 | 6338 | 195 |
1908764 | 1908764 | 2021-11-12 | St. John the Baptist | Louisiana | 22095 | 6338 | 171 |
1910554 | 1910554 | 2021-11-12 | Danville city | Virginia | 51590 | 6338 | 195 |
1886720 | 1886720 | 2021-11-05 | Montgomery | New York | 36057 | 6338 | 153 |
1836054 | 1836054 | 2021-10-20 | Monroe | Wisconsin | 55081 | 6338 | 54 |
1766096 | 1766096 | 2021-09-29 | Panola | Mississippi | 28107 | 6338 | 127 |
1745376 | 1745376 | 2021-09-23 | Tuolumne | California | 6109 | 6338 | 100 |
1693141 | 1693141 | 2021-09-06 | Fremont | Wyoming | 56013 | 6338 | 96 |
1689892 | 1689892 | 2021-09-05 | Fremont | Wyoming | 56013 | 6338 | 96 |
1686642 | 1686642 | 2021-09-04 | Fremont | Wyoming | 56013 | 6338 | 96 |
1683392 | 1683392 | 2021-09-03 | Fremont | Wyoming | 56013 | 6338 | 96 |
1672233 | 1672233 | 2021-08-31 | Curry | New Mexico | 35009 | 6338 | 89 |
1604270 | 1604270 | 2021-08-10 | Belmont | Ohio | 39013 | 6338 | 180 |
1553696 | 1553696 | 2021-07-26 | San Benito | California | 6069 | 6338 | 63 |
1555432 | 1555432 | 2021-07-26 | Lenoir | North Carolina | 37107 | 6338 | 128 |
1555901 | 1555901 | 2021-07-26 | Cherokee | South Carolina | 45021 | 6338 | 159 |
1463777 | 1463777 | 2021-06-28 | Cecil | Maryland | 24015 | 6338 | 152 |
1460532 | 1460532 | 2021-06-27 | Cecil | Maryland | 24015 | 6338 | 152 |
1460601 | 1460601 | 2021-06-27 | Isabella | Michigan | 26073 | 6338 | 100 |
1457356 | 1457356 | 2021-06-26 | Isabella | Michigan | 26073 | 6338 | 100 |
1454111 | 1454111 | 2021-06-25 | Isabella | Michigan | 26073 | 6338 | 100 |
1450866 | 1450866 | 2021-06-24 | Isabella | Michigan | 26073 | 6338 | 100 |
1448191 | 1448191 | 2021-06-23 | Cayuga | New York | 36011 | 6338 | 92 |
1444946 | 1444946 | 2021-06-22 | Cayuga | New York | 36011 | 6338 | 92 |
1441701 | 1441701 | 2021-06-21 | Cayuga | New York | 36011 | 6338 | 92 |
1438456 | 1438456 | 2021-06-20 | Cayuga | New York | 36011 | 6338 | 92 |
1435209 | 1435209 | 2021-06-19 | Cayuga | New York | 36011 | 6338 | 92 |
1431962 | 1431962 | 2021-06-18 | Cayuga | New York | 36011 | 6338 | 92 |
1428716 | 1428716 | 2021-06-17 | Cayuga | New York | 36011 | 6338 | 92 |
1364249 | 1364249 | 2021-05-28 | Indiana | Pennsylvania | 42063 | 6338 | 176 |
1340545 | 1340545 | 2021-05-21 | Shiawassee | Michigan | 26155 | 6338 | 103 |
1278772 | 1278772 | 2021-05-02 | Berkshire | Massachusetts | 25003 | 6338 | 282 |
1229916 | 1229916 | 2021-04-17 | McCracken | Kentucky | 21145 | 6338 | 119 |
1197114 | 1197114 | 2021-04-07 | Morgan | Indiana | 18109 | 6338 | 140 |
1195109 | 1195109 | 2021-04-06 | Wilkes | North Carolina | 37193 | 6338 | 107 |
1191861 | 1191861 | 2021-04-05 | Wilkes | North Carolina | 37193 | 6338 | 105 |
935346 | 935346 | 2021-01-16 | Craven | North Carolina | 37049 | 6338 | 89 |
924927 | 924927 | 2021-01-13 | Allegan | Michigan | 26005 | 6338 | 88 |
788899 | 788899 | 2020-12-02 | Cole | Missouri | 29051 | 6338 | 60 |
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);