ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
207 rows where cases = 2728 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 27
- Ohio 14
- Missouri 13
- Arkansas 11
- Oklahoma 11
- Texas 11
- Kentucky 9
- Wisconsin 8
- Illinois 7
- North Carolina 7
- Indiana 6
- Mississippi 6
- Alabama 5
- Louisiana 5
- Oregon 5
- South Dakota 5
- Tennessee 5
- Virginia 5
- California 4
- Pennsylvania 4
- Colorado 3
- Kansas 3
- Maryland 3
- Minnesota 3
- Puerto Rico 3
- West Virginia 3
- Wyoming 3
- Iowa 2
- Maine 2
- Michigan 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2445573 | 2445573 | 2022-04-26 | Koochiching | Minnesota | 27071 | 2728 | 37 |
2443310 | 2443310 | 2022-04-25 | Ciales | Puerto Rico | 72039 | 2728 | |
2352629 | 2352629 | 2022-03-28 | Pecos | Texas | 48371 | 2728 | 71 |
2349377 | 2349377 | 2022-03-27 | Pecos | Texas | 48371 | 2728 | 71 |
2346124 | 2346124 | 2022-03-26 | Pecos | Texas | 48371 | 2728 | 71 |
2305828 | 2305828 | 2022-03-14 | Lewis | Missouri | 29111 | 2728 | 34 |
2302577 | 2302577 | 2022-03-13 | Lewis | Missouri | 29111 | 2728 | 34 |
2299325 | 2299325 | 2022-03-12 | Lewis | Missouri | 29111 | 2728 | 34 |
2296073 | 2296073 | 2022-03-11 | Lewis | Missouri | 29111 | 2728 | 34 |
2283487 | 2283487 | 2022-03-07 | Perquimans | North Carolina | 37143 | 2728 | 18 |
2283983 | 2283983 | 2022-03-07 | Butte | South Dakota | 46019 | 2728 | 44 |
2280731 | 2280731 | 2022-03-06 | Butte | South Dakota | 46019 | 2728 | 44 |
2277478 | 2277478 | 2022-03-05 | Butte | South Dakota | 46019 | 2728 | 44 |
2274225 | 2274225 | 2022-03-04 | Butte | South Dakota | 46019 | 2728 | 44 |
2270972 | 2270972 | 2022-03-03 | Butte | South Dakota | 46019 | 2728 | 44 |
2265906 | 2265906 | 2022-03-02 | Marshall | Illinois | 17123 | 2728 | 32 |
2255974 | 2255974 | 2022-02-27 | Long | Georgia | 13183 | 2728 | 32 |
2252723 | 2252723 | 2022-02-26 | Long | Georgia | 13183 | 2728 | 32 |
2249472 | 2249472 | 2022-02-25 | Long | Georgia | 13183 | 2728 | 32 |
2246032 | 2246032 | 2022-02-24 | Park | Colorado | 8093 | 2728 | 20 |
2246221 | 2246221 | 2022-02-24 | Long | Georgia | 13183 | 2728 | 31 |
2223422 | 2223422 | 2022-02-17 | Early | Georgia | 13099 | 2728 | 60 |
2217567 | 2217567 | 2022-02-15 | Metcalfe | Kentucky | 21169 | 2728 | 57 |
2215923 | 2215923 | 2022-02-14 | Eastland | Texas | 48133 | 2728 | 101 |
2187412 | 2187412 | 2022-02-06 | Mariposa | California | 6043 | 2728 | 20 |
2184159 | 2184159 | 2022-02-05 | Mariposa | California | 6043 | 2728 | 20 |
2186339 | 2186339 | 2022-02-05 | Orocovis | Puerto Rico | 72107 | 2728 | |
2180907 | 2180907 | 2022-02-04 | Mariposa | California | 6043 | 2728 | 20 |
2175306 | 2175306 | 2022-02-02 | Todd | Kentucky | 21219 | 2728 | 39 |
2172459 | 2172459 | 2022-02-01 | Cedar | Missouri | 29039 | 2728 | 44 |
2167975 | 2167975 | 2022-01-31 | Moffat | Colorado | 8081 | 2728 | 50 |
2153655 | 2153655 | 2022-01-26 | Curry | Oregon | 41015 | 2728 | 41 |
2148281 | 2148281 | 2022-01-25 | Bradley | Arkansas | 5011 | 2728 | 43 |
2139621 | 2139621 | 2022-01-22 | Kent | Maryland | 24029 | 2728 | 62 |
2125600 | 2125600 | 2022-01-18 | Mono | California | 6051 | 2728 | 4 |
2108809 | 2108809 | 2022-01-12 | Alleghany | Virginia | 51005 | 2728 | 90 |
2091739 | 2091739 | 2022-01-07 | Monroe | Ohio | 39111 | 2728 | 67 |
1996025 | 1996025 | 2021-12-09 | Moultrie | Illinois | 17139 | 2728 | 43 |
1992574 | 1992574 | 2021-12-08 | Jefferson | Georgia | 13163 | 2728 | 91 |
1989323 | 1989323 | 2021-12-07 | Jefferson | Georgia | 13163 | 2728 | 91 |
1989461 | 1989461 | 2021-12-07 | Carroll | Illinois | 17015 | 2728 | 42 |
1988514 | 1988514 | 2021-12-06 | Caledonia | Vermont | 50005 | 2728 | 21 |
1982823 | 1982823 | 2021-12-05 | Jefferson | Georgia | 13163 | 2728 | 89 |
1983793 | 1983793 | 2021-12-05 | Holmes | Mississippi | 28051 | 2728 | 89 |
1979573 | 1979573 | 2021-12-04 | Jefferson | Georgia | 13163 | 2728 | 89 |
1980543 | 1980543 | 2021-12-04 | Holmes | Mississippi | 28051 | 2728 | 89 |
1976323 | 1976323 | 2021-12-03 | Jefferson | Georgia | 13163 | 2728 | 89 |
1977293 | 1977293 | 2021-12-03 | Holmes | Mississippi | 28051 | 2728 | 89 |
1937898 | 1937898 | 2021-11-21 | Henry | Kentucky | 21103 | 2728 | 33 |
1934648 | 1934648 | 2021-11-20 | Henry | Kentucky | 21103 | 2728 | 33 |
1931397 | 1931397 | 2021-11-19 | Henry | Kentucky | 21103 | 2728 | 33 |
1931925 | 1931925 | 2021-11-19 | Pike | Missouri | 29163 | 2728 | 49 |
1921381 | 1921381 | 2021-11-16 | Vermillion | Indiana | 18165 | 2728 | 56 |
1871984 | 1871984 | 2021-11-01 | Franklin | Arkansas | 5047 | 2728 | 52 |
1868735 | 1868735 | 2021-10-31 | Franklin | Arkansas | 5047 | 2728 | 52 |
1865486 | 1865486 | 2021-10-30 | Franklin | Arkansas | 5047 | 2728 | 52 |
1859869 | 1859869 | 2021-10-28 | Breckinridge | Kentucky | 21027 | 2728 | 34 |
1854518 | 1854518 | 2021-10-26 | Choctaw | Oklahoma | 40023 | 2728 | 49 |
1851269 | 1851269 | 2021-10-25 | Choctaw | Oklahoma | 40023 | 2728 | 49 |
1851437 | 1851437 | 2021-10-25 | Wyoming | Pennsylvania | 42131 | 2728 | 63 |
1848019 | 1848019 | 2021-10-24 | Choctaw | Oklahoma | 40023 | 2728 | 49 |
1844769 | 1844769 | 2021-10-23 | Choctaw | Oklahoma | 40023 | 2728 | 49 |
1841519 | 1841519 | 2021-10-22 | Choctaw | Oklahoma | 40023 | 2728 | 49 |
1838270 | 1838270 | 2021-10-21 | Choctaw | Oklahoma | 40023 | 2728 | 49 |
1835021 | 1835021 | 2021-10-20 | Choctaw | Oklahoma | 40023 | 2728 | 49 |
1829066 | 1829066 | 2021-10-18 | Freestone | Texas | 48161 | 2728 | 66 |
1818113 | 1818113 | 2021-10-15 | Andrew | Missouri | 29003 | 2728 | 24 |
1807839 | 1807839 | 2021-10-12 | Pottawatomie | Kansas | 20149 | 2728 | 42 |
1804588 | 1804588 | 2021-10-11 | Pottawatomie | Kansas | 20149 | 2728 | 42 |
1802373 | 1802373 | 2021-10-10 | Yancey | North Carolina | 37199 | 2728 | 29 |
1799124 | 1799124 | 2021-10-09 | Yancey | North Carolina | 37199 | 2728 | 29 |
1795875 | 1795875 | 2021-10-08 | Yancey | North Carolina | 37199 | 2728 | 29 |
1793746 | 1793746 | 2021-10-07 | McDowell | West Virginia | 54047 | 2728 | 42 |
1789908 | 1789908 | 2021-10-06 | Cannon | Tennessee | 47015 | 2728 | 39 |
1769947 | 1769947 | 2021-09-30 | Carroll | Ohio | 39019 | 2728 | 52 |
1746776 | 1746776 | 2021-09-23 | Lincoln | Montana | 30053 | 2728 | 43 |
1744501 | 1744501 | 2021-09-22 | Union | Tennessee | 47173 | 2728 | 38 |
1738195 | 1738195 | 2021-09-20 | Panola | Texas | 48365 | 2728 | 98 |
1732166 | 1732166 | 2021-09-19 | Fayette | Alabama | 1057 | 2728 | 71 |
1734387 | 1734387 | 2021-09-19 | Lincoln | Oregon | 41041 | 2728 | 29 |
1734945 | 1734945 | 2021-09-19 | Panola | Texas | 48365 | 2728 | 97 |
1731137 | 1731137 | 2021-09-18 | Lincoln | Oregon | 41041 | 2728 | 29 |
1731695 | 1731695 | 2021-09-18 | Panola | Texas | 48365 | 2728 | 97 |
1727887 | 1727887 | 2021-09-17 | Lincoln | Oregon | 41041 | 2728 | 29 |
1720407 | 1720407 | 2021-09-15 | Emmet | Michigan | 26047 | 2728 | 45 |
1702573 | 1702573 | 2021-09-09 | Rutland | Vermont | 50021 | 2728 | 22 |
1673774 | 1673774 | 2021-09-01 | Ashley | Arkansas | 5003 | 2728 | 39 |
1656317 | 1656317 | 2021-08-26 | Van Wert | Ohio | 39161 | 2728 | 67 |
1656714 | 1656714 | 2021-08-26 | Chester | Tennessee | 47023 | 2728 | 54 |
1651705 | 1651705 | 2021-08-25 | Spencer | Indiana | 18147 | 2728 | 31 |
1632665 | 1632665 | 2021-08-19 | Franklin | Massachusetts | 25011 | 2728 | 114 |
1632850 | 1632850 | 2021-08-19 | Attala | Mississippi | 28007 | 2728 | 77 |
1622147 | 1622147 | 2021-08-16 | Grady | Georgia | 13131 | 2728 | 66 |
1610072 | 1610072 | 2021-08-12 | Meeker | Minnesota | 27093 | 2728 | 45 |
1605745 | 1605745 | 2021-08-11 | Pitkin | Colorado | 8097 | 2728 | 4 |
1601546 | 1601546 | 2021-08-09 | Morgan | Tennessee | 47129 | 2728 | 39 |
1577333 | 1577333 | 2021-08-02 | Assumption | Louisiana | 22007 | 2728 | 37 |
1568564 | 1568564 | 2021-07-30 | Holmes | Ohio | 39075 | 2728 | 102 |
1565316 | 1565316 | 2021-07-29 | Holmes | Ohio | 39075 | 2728 | 102 |
1561466 | 1561466 | 2021-07-28 | Adair | Missouri | 29001 | 2728 | 23 |
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);