ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where cases = 7807 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 23
- Georgia 9
- Oklahoma 8
- California 7
- Texas 7
- Virginia 5
- Minnesota 4
- Mississippi 4
- Florida 3
- Indiana 3
- Kansas 3
- Nebraska 3
- Ohio 3
- Illinois 2
- New York 2
- South Carolina 2
- West Virginia 2
- Alabama 1
- Colorado 1
- Maryland 1
- North Carolina 1
- South Dakota 1
- Tennessee 1
- Vermont 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2369877 | 2369877 | 2022-04-03 | Wayne | Georgia | 13305 | 7807 | 206 |
2366624 | 2366624 | 2022-04-02 | Wayne | Georgia | 13305 | 7807 | 206 |
2363371 | 2363371 | 2022-04-01 | Wayne | Georgia | 13305 | 7807 | 206 |
2360117 | 2360117 | 2022-03-31 | Wayne | Georgia | 13305 | 7807 | 206 |
2342872 | 2342872 | 2022-03-25 | Polk | Texas | 48373 | 7807 | 247 |
2339619 | 2339619 | 2022-03-24 | Polk | Texas | 48373 | 7807 | 247 |
2336365 | 2336365 | 2022-03-23 | Polk | Texas | 48373 | 7807 | 247 |
2264446 | 2264446 | 2022-03-01 | Marlboro | South Carolina | 45069 | 7807 | 103 |
2261196 | 2261196 | 2022-02-28 | Marlboro | South Carolina | 45069 | 7807 | 103 |
2200264 | 2200264 | 2022-02-10 | Marion | Alabama | 1093 | 7807 | 139 |
2168191 | 2168191 | 2022-01-31 | Pickens | Georgia | 13227 | 7807 | 140 |
2154330 | 2154330 | 2022-01-26 | Bennington | Vermont | 50003 | 7807 | 54 |
2134947 | 2134947 | 2022-01-20 | Tazewell | Virginia | 51185 | 7807 | 126 |
2120613 | 2120613 | 2022-01-16 | Madison | Nebraska | 31119 | 7807 | 55 |
2117361 | 2117361 | 2022-01-15 | Madison | Nebraska | 31119 | 7807 | 55 |
2114110 | 2114110 | 2022-01-14 | Madison | Nebraska | 31119 | 7807 | 55 |
2097598 | 2097598 | 2022-01-09 | Pontotoc | Mississippi | 28115 | 7807 | 114 |
2094346 | 2094346 | 2022-01-08 | Pontotoc | Mississippi | 28115 | 7807 | 114 |
2091094 | 2091094 | 2022-01-07 | Pontotoc | Mississippi | 28115 | 7807 | 114 |
2058468 | 2058468 | 2021-12-28 | Isanti | Minnesota | 27059 | 7807 | 95 |
2036535 | 2036535 | 2021-12-21 | Delaware | Oklahoma | 40041 | 7807 | 168 |
2037235 | 2037235 | 2021-12-21 | Wilson | Texas | 48493 | 7807 | 143 |
2033285 | 2033285 | 2021-12-20 | Delaware | Oklahoma | 40041 | 7807 | 168 |
2030035 | 2030035 | 2021-12-19 | Delaware | Oklahoma | 40041 | 7807 | 168 |
2026784 | 2026784 | 2021-12-18 | Delaware | Oklahoma | 40041 | 7807 | 168 |
2023533 | 2023533 | 2021-12-17 | Delaware | Oklahoma | 40041 | 7807 | 168 |
2020282 | 2020282 | 2021-12-16 | Delaware | Oklahoma | 40041 | 7807 | 168 |
2017031 | 2017031 | 2021-12-15 | Delaware | Oklahoma | 40041 | 7807 | 168 |
2008075 | 2008075 | 2021-12-12 | Fauquier | Virginia | 51061 | 7807 | 91 |
2004824 | 2004824 | 2021-12-11 | Fauquier | Virginia | 51061 | 7807 | 91 |
2001573 | 2001573 | 2021-12-10 | Fauquier | Virginia | 51061 | 7807 | 91 |
1995849 | 1995849 | 2021-12-09 | Murray | Georgia | 13213 | 7807 | 149 |
1963072 | 1963072 | 2021-11-29 | San Benito | California | 6069 | 7807 | 77 |
1959841 | 1959841 | 2021-11-28 | Tuolumne | California | 6109 | 7807 | 141 |
1956590 | 1956590 | 2021-11-27 | Tuolumne | California | 6109 | 7807 | 141 |
1953339 | 1953339 | 2021-11-26 | Tuolumne | California | 6109 | 7807 | 141 |
1950088 | 1950088 | 2021-11-25 | Tuolumne | California | 6109 | 7807 | 141 |
1946837 | 1946837 | 2021-11-24 | Tuolumne | California | 6109 | 7807 | 141 |
1940744 | 1940744 | 2021-11-22 | Knox | Illinois | 17095 | 7807 | 206 |
1872376 | 1872376 | 2021-11-01 | Thomas | Georgia | 13275 | 7807 | 181 |
1859063 | 1859063 | 2021-10-28 | Mendocino | California | 6045 | 7807 | 88 |
1854422 | 1854422 | 2021-10-26 | Athens | Ohio | 39009 | 7807 | 83 |
1841490 | 1841490 | 2021-10-22 | Sandusky | Ohio | 39143 | 7807 | 151 |
1824495 | 1824495 | 2021-10-17 | Otter Tail | Minnesota | 27111 | 7807 | 104 |
1821246 | 1821246 | 2021-10-16 | Otter Tail | Minnesota | 27111 | 7807 | 104 |
1817997 | 1817997 | 2021-10-15 | Otter Tail | Minnesota | 27111 | 7807 | 104 |
1745399 | 1745399 | 2021-09-23 | Eagle | Colorado | 8037 | 7807 | 30 |
1743782 | 1743782 | 2021-09-22 | Sullivan | New York | 36105 | 7807 | 81 |
1709266 | 1709266 | 2021-09-11 | Harrison | West Virginia | 54033 | 7807 | 91 |
1619237 | 1619237 | 2021-08-15 | Wayne | Indiana | 18177 | 7807 | 206 |
1615989 | 1615989 | 2021-08-14 | Wayne | Indiana | 18177 | 7807 | 206 |
1612740 | 1612740 | 2021-08-13 | Wayne | Indiana | 18177 | 7807 | 206 |
1551131 | 1551131 | 2021-07-25 | Butler | Kansas | 20015 | 7807 | 93 |
1547884 | 1547884 | 2021-07-24 | Butler | Kansas | 20015 | 7807 | 93 |
1544637 | 1544637 | 2021-07-23 | Butler | Kansas | 20015 | 7807 | 93 |
1391702 | 1391702 | 2021-06-06 | Walker | Georgia | 13295 | 7807 | 88 |
1365714 | 1365714 | 2021-05-29 | Rockdale | Georgia | 13247 | 7807 | 173 |
1279625 | 1279625 | 2021-05-02 | Erie | Ohio | 39043 | 7807 | 154 |
1270847 | 1270847 | 2021-04-29 | Suffolk city | Virginia | 51800 | 7807 | 185 |
1263865 | 1263865 | 2021-04-27 | Greene | Tennessee | 47059 | 7807 | 153 |
1116385 | 1116385 | 2021-03-13 | Carroll | Maryland | 24013 | 7807 | 217 |
1088461 | 1088461 | 2021-03-04 | Lincoln | South Dakota | 46083 | 7807 | 77 |
1079325 | 1079325 | 2021-03-01 | Cabell | West Virginia | 54011 | 7807 | 160 |
1065452 | 1065452 | 2021-02-25 | Pottawatomie | Oklahoma | 40125 | 7807 | 76 |
1055419 | 1055419 | 2021-02-22 | Brunswick | North Carolina | 37019 | 7807 | 131 |
1008668 | 1008668 | 2021-02-08 | Adams | Illinois | 17001 | 7807 | 138 |
977490 | 977490 | 2021-01-29 | Rensselaer | New York | 36083 | 7807 | 116 |
894806 | 894806 | 2021-01-04 | Charlotte | Florida | 12015 | 7807 | 241 |
889438 | 889438 | 2021-01-02 | Lee | Mississippi | 28081 | 7807 | 118 |
621306 | 621306 | 2020-10-11 | Brazos | Texas | 48041 | 7807 | 65 |
618063 | 618063 | 2020-10-10 | Brazos | Texas | 48041 | 7807 | 65 |
614821 | 614821 | 2020-10-09 | Brazos | Texas | 48041 | 7807 | 65 |
466883 | 466883 | 2020-08-25 | Pasco | Florida | 12101 | 7807 | 171 |
453960 | 453960 | 2020-08-21 | Marion | Florida | 12083 | 7807 | 121 |
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);