ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
163 rows where cases = 3632 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 15
- Georgia 13
- Tennessee 13
- Missouri 12
- Virginia 11
- Kentucky 9
- Kansas 8
- Wisconsin 8
- Indiana 7
- Minnesota 7
- Alabama 5
- New York 5
- Wyoming 5
- Arkansas 4
- Colorado 4
- Iowa 4
- Mississippi 4
- Puerto Rico 4
- Michigan 3
- Pennsylvania 3
- Florida 2
- Montana 2
- Oregon 2
- South Carolina 2
- South Dakota 2
- West Virginia 2
- California 1
- Idaho 1
- Illinois 1
- Louisiana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2483679 | 2483679 | 2022-05-08 | Bacon | Georgia | 13005 | 3632 | 77 |
2480421 | 2480421 | 2022-05-07 | Bacon | Georgia | 13005 | 3632 | 77 |
2477163 | 2477163 | 2022-05-06 | Bacon | Georgia | 13005 | 3632 | 77 |
2473905 | 2473905 | 2022-05-05 | Bacon | Georgia | 13005 | 3632 | 77 |
2470648 | 2470648 | 2022-05-04 | Bacon | Georgia | 13005 | 3632 | 77 |
2469414 | 2469414 | 2022-05-03 | Villalba | Puerto Rico | 72149 | 3632 | |
2443630 | 2443630 | 2022-04-25 | Comanche | Texas | 48093 | 3632 | 78 |
2440374 | 2440374 | 2022-04-24 | Comanche | Texas | 48093 | 3632 | 78 |
2437118 | 2437118 | 2022-04-23 | Comanche | Texas | 48093 | 3632 | 78 |
2382286 | 2382286 | 2022-04-06 | Lafayette | Wisconsin | 55065 | 3632 | 22 |
2379031 | 2379031 | 2022-04-05 | Lafayette | Wisconsin | 55065 | 3632 | 22 |
2375824 | 2375824 | 2022-04-04 | Goshen | Wyoming | 56015 | 3632 | 57 |
2372572 | 2372572 | 2022-04-03 | Goshen | Wyoming | 56015 | 3632 | 57 |
2369319 | 2369319 | 2022-04-02 | Goshen | Wyoming | 56015 | 3632 | 57 |
2366066 | 2366066 | 2022-04-01 | Goshen | Wyoming | 56015 | 3632 | 57 |
2351375 | 2351375 | 2022-03-28 | Macon | Missouri | 29121 | 3632 | 53 |
2339065 | 2339065 | 2022-03-24 | Tillamook | Oregon | 41057 | 3632 | 60 |
2314610 | 2314610 | 2022-03-17 | Gem | Idaho | 16045 | 3632 | 79 |
2313171 | 2313171 | 2022-03-16 | Quebradillas | Puerto Rico | 72115 | 3632 | |
2303397 | 2303397 | 2022-03-13 | Lares | Puerto Rico | 72081 | 3632 | |
2213295 | 2213295 | 2022-02-14 | Washington | Alabama | 1129 | 3632 | 53 |
2210042 | 2210042 | 2022-02-13 | Washington | Alabama | 1129 | 3632 | 53 |
2203333 | 2203333 | 2022-02-10 | Grant | West Virginia | 54023 | 3632 | 52 |
2197732 | 2197732 | 2022-02-09 | Pike | Indiana | 18125 | 3632 | 48 |
2194478 | 2194478 | 2022-02-08 | Pike | Indiana | 18125 | 3632 | 48 |
2196658 | 2196658 | 2022-02-08 | Buckingham | Virginia | 51029 | 3632 | 45 |
2167212 | 2167212 | 2022-01-30 | Llano | Texas | 48299 | 3632 | 88 |
2150780 | 2150780 | 2022-01-25 | Trousdale | Tennessee | 47169 | 3632 | 38 |
2147528 | 2147528 | 2022-01-24 | Trousdale | Tennessee | 47169 | 3632 | 38 |
2144274 | 2144274 | 2022-01-23 | Trousdale | Tennessee | 47169 | 3632 | 38 |
2141019 | 2141019 | 2022-01-22 | Trousdale | Tennessee | 47169 | 3632 | 38 |
2137763 | 2137763 | 2022-01-21 | Trousdale | Tennessee | 47169 | 3632 | 38 |
2133250 | 2133250 | 2022-01-20 | Houston | Minnesota | 27055 | 3632 | 18 |
2134509 | 2134509 | 2022-01-20 | Trousdale | Tennessee | 47169 | 3632 | 38 |
2131257 | 2131257 | 2022-01-19 | Trousdale | Tennessee | 47169 | 3632 | 38 |
2086414 | 2086414 | 2022-01-06 | Marengo | Alabama | 1091 | 3632 | 93 |
2082361 | 2082361 | 2022-01-04 | Hughes | South Dakota | 46065 | 3632 | 53 |
2065472 | 2065472 | 2021-12-30 | Essex | New York | 36031 | 3632 | 48 |
2058426 | 2058426 | 2021-12-28 | Roscommon | Michigan | 26143 | 3632 | 99 |
2055177 | 2055177 | 2021-12-27 | Roscommon | Michigan | 26143 | 3632 | 99 |
2056394 | 2056394 | 2021-12-27 | Bledsoe | Tennessee | 47007 | 3632 | 37 |
2028349 | 2028349 | 2021-12-19 | McDuffie | Georgia | 13189 | 3632 | 78 |
2025098 | 2025098 | 2021-12-18 | McDuffie | Georgia | 13189 | 3632 | 78 |
2021847 | 2021847 | 2021-12-17 | McDuffie | Georgia | 13189 | 3632 | 78 |
1996118 | 1996118 | 2021-12-09 | Owen | Indiana | 18119 | 3632 | 80 |
1989631 | 1989631 | 2021-12-07 | Starke | Indiana | 18149 | 3632 | 77 |
1990208 | 1990208 | 2021-12-07 | Hubbard | Minnesota | 27057 | 3632 | 49 |
1967153 | 1967153 | 2021-11-30 | Harrison | Kentucky | 21097 | 3632 | 51 |
1963278 | 1963278 | 2021-11-29 | Cook | Georgia | 13075 | 3632 | 65 |
1960721 | 1960721 | 2021-11-28 | Woodford | Kentucky | 21239 | 3632 | 31 |
1957470 | 1957470 | 2021-11-27 | Woodford | Kentucky | 21239 | 3632 | 31 |
1954219 | 1954219 | 2021-11-26 | Woodford | Kentucky | 21239 | 3632 | 31 |
1950968 | 1950968 | 2021-11-25 | Woodford | Kentucky | 21239 | 3632 | 31 |
1947717 | 1947717 | 2021-11-24 | Woodford | Kentucky | 21239 | 3632 | 31 |
1938417 | 1938417 | 2021-11-21 | Nodaway | Missouri | 29147 | 3632 | 36 |
1935167 | 1935167 | 2021-11-20 | Nodaway | Missouri | 29147 | 3632 | 36 |
1931461 | 1931461 | 2021-11-19 | Wayne | Kentucky | 21231 | 3632 | 64 |
1931917 | 1931917 | 2021-11-19 | Nodaway | Missouri | 29147 | 3632 | 36 |
1928210 | 1928210 | 2021-11-18 | Wayne | Kentucky | 21231 | 3632 | 64 |
1928666 | 1928666 | 2021-11-18 | Nodaway | Missouri | 29147 | 3632 | 36 |
1925416 | 1925416 | 2021-11-17 | Nodaway | Missouri | 29147 | 3632 | 34 |
1914381 | 1914381 | 2021-11-14 | Montezuma | Colorado | 8083 | 3632 | 41 |
1911131 | 1911131 | 2021-11-13 | Montezuma | Colorado | 8083 | 3632 | 41 |
1907597 | 1907597 | 2021-11-12 | Barbour | Alabama | 1005 | 3632 | 79 |
1907882 | 1907882 | 2021-11-12 | Montezuma | Colorado | 8083 | 3632 | 41 |
1904781 | 1904781 | 2021-11-11 | Dodge | Georgia | 13091 | 3632 | 127 |
1901531 | 1901531 | 2021-11-10 | Dodge | Georgia | 13091 | 3632 | 127 |
1868753 | 1868753 | 2021-10-31 | Logan | Arkansas | 5083 | 3632 | 46 |
1856060 | 1856060 | 2021-10-27 | Grady | Georgia | 13131 | 3632 | 88 |
1853104 | 1853104 | 2021-10-26 | LaGrange | Indiana | 18087 | 3632 | 81 |
1851848 | 1851848 | 2021-10-25 | Hutchinson | Texas | 48233 | 3632 | 86 |
1852239 | 1852239 | 2021-10-25 | Nicholas | West Virginia | 54067 | 3632 | 46 |
1848598 | 1848598 | 2021-10-24 | Hutchinson | Texas | 48233 | 3632 | 86 |
1845348 | 1845348 | 2021-10-23 | Hutchinson | Texas | 48233 | 3632 | 86 |
1839125 | 1839125 | 2021-10-21 | Orange | Virginia | 51137 | 3632 | 52 |
1826100 | 1826100 | 2021-10-17 | Hopewell city | Virginia | 51670 | 3632 | 85 |
1822851 | 1822851 | 2021-10-16 | Hopewell city | Virginia | 51670 | 3632 | 85 |
1819602 | 1819602 | 2021-10-15 | Hopewell city | Virginia | 51670 | 3632 | 85 |
1702399 | 1702399 | 2021-09-09 | Jasper | Texas | 48241 | 3632 | 115 |
1699063 | 1699063 | 2021-09-08 | Cass | Texas | 48067 | 3632 | 107 |
1699587 | 1699587 | 2021-09-08 | Juneau | Wisconsin | 55057 | 3632 | 31 |
1675316 | 1675316 | 2021-09-01 | Ravalli | Montana | 30081 | 3632 | 52 |
1655706 | 1655706 | 2021-08-26 | Dunklin | Missouri | 29069 | 3632 | 52 |
1645386 | 1645386 | 2021-08-23 | McPherson | Kansas | 20113 | 3632 | 87 |
1641326 | 1641326 | 2021-08-22 | Jackson | Arkansas | 5067 | 3632 | 40 |
1642137 | 1642137 | 2021-08-22 | McPherson | Kansas | 20113 | 3632 | 87 |
1638076 | 1638076 | 2021-08-21 | Jackson | Arkansas | 5067 | 3632 | 40 |
1638887 | 1638887 | 2021-08-21 | McPherson | Kansas | 20113 | 3632 | 87 |
1635637 | 1635637 | 2021-08-20 | McPherson | Kansas | 20113 | 3632 | 87 |
1632387 | 1632387 | 2021-08-19 | McPherson | Kansas | 20113 | 3632 | 87 |
1620327 | 1620327 | 2021-08-15 | Otsego | New York | 36077 | 3632 | 47 |
1600561 | 1600561 | 2021-08-09 | Warren | Missouri | 29219 | 3632 | 39 |
1587861 | 1587861 | 2021-08-05 | Wyoming | New York | 36121 | 3632 | 53 |
1584611 | 1584611 | 2021-08-04 | Wyoming | New York | 36121 | 3632 | 53 |
1585276 | 1585276 | 2021-08-04 | Henry | Tennessee | 47079 | 3632 | 76 |
1562606 | 1562606 | 2021-07-28 | Bee | Texas | 48025 | 3632 | 75 |
1427045 | 1427045 | 2021-06-17 | St. Francis | Arkansas | 5123 | 3632 | 44 |
1428061 | 1428061 | 2021-06-17 | Oxford | Maine | 23017 | 3632 | 67 |
1394698 | 1394698 | 2021-06-07 | Montrose | Colorado | 8085 | 3632 | 61 |
1366762 | 1366762 | 2021-05-29 | Marion | Missouri | 29127 | 3632 | 51 |
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);