ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
83 rows where cases = 5535 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Michigan 8
- Virginia 8
- Ohio 7
- Oklahoma 7
- Louisiana 6
- Georgia 5
- Missouri 5
- Texas 4
- Washington 4
- Indiana 3
- Minnesota 3
- Alabama 2
- New Hampshire 2
- New York 2
- Wisconsin 2
- Arizona 1
- Arkansas 1
- Colorado 1
- Florida 1
- Iowa 1
- Maine 1
- Maryland 1
- Montana 1
- New Jersey 1
- Oregon 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2381452 | 2381452 | 2022-04-06 | Cidra | Puerto Rico | 72041 | 5535 | |
2315437 | 2315437 | 2022-03-17 | Wabasha | Minnesota | 27157 | 5535 | 16 |
2297272 | 2297272 | 2022-03-11 | Karnes | Texas | 48255 | 5535 | 67 |
2266436 | 2266436 | 2022-03-02 | Franklin | Maine | 23007 | 5535 | 56 |
2243614 | 2243614 | 2022-02-23 | Assumption | Louisiana | 22007 | 5535 | 68 |
2243704 | 2243704 | 2022-02-23 | Garrett | Maryland | 24023 | 5535 | 113 |
2169187 | 2169187 | 2022-01-31 | Adair | Missouri | 29001 | 5535 | 56 |
2165932 | 2165932 | 2022-01-30 | Adair | Missouri | 29001 | 5535 | 56 |
2162677 | 2162677 | 2022-01-29 | Adair | Missouri | 29001 | 5535 | 56 |
2159422 | 2159422 | 2022-01-28 | Adair | Missouri | 29001 | 5535 | 56 |
2156168 | 2156168 | 2022-01-27 | Adair | Missouri | 29001 | 5535 | 56 |
2142822 | 2142822 | 2022-01-23 | Sabine | Louisiana | 22085 | 5535 | 100 |
2139567 | 2139567 | 2022-01-22 | Sabine | Louisiana | 22085 | 5535 | 100 |
2136311 | 2136311 | 2022-01-21 | Sabine | Louisiana | 22085 | 5535 | 100 |
2126649 | 2126649 | 2022-01-18 | Clare | Michigan | 26035 | 5535 | 143 |
2123397 | 2123397 | 2022-01-17 | Clare | Michigan | 26035 | 5535 | 143 |
2120145 | 2120145 | 2022-01-16 | Clare | Michigan | 26035 | 5535 | 143 |
2116893 | 2116893 | 2022-01-15 | Clare | Michigan | 26035 | 5535 | 143 |
2113642 | 2113642 | 2022-01-14 | Clare | Michigan | 26035 | 5535 | 143 |
2109607 | 2109607 | 2022-01-13 | Lee | Georgia | 13177 | 5535 | 87 |
2099200 | 2099200 | 2022-01-09 | Island | Washington | 53029 | 5535 | 57 |
2095949 | 2095949 | 2022-01-08 | Island | Washington | 53029 | 5535 | 57 |
2092697 | 2092697 | 2022-01-07 | Island | Washington | 53029 | 5535 | 57 |
2084773 | 2084773 | 2022-01-05 | Ravalli | Montana | 30081 | 5535 | 129 |
2038982 | 2038982 | 2021-12-22 | Lyon | Minnesota | 27083 | 5535 | 64 |
1964976 | 1964976 | 2021-11-29 | Ottawa | Ohio | 39123 | 5535 | 99 |
1930177 | 1930177 | 2021-11-18 | Okanogan | Washington | 53047 | 5535 | 92 |
1923198 | 1923198 | 2021-11-16 | Scott | Tennessee | 47151 | 5535 | 62 |
1886977 | 1886977 | 2021-11-05 | Putnam | Ohio | 39137 | 5535 | 112 |
1884656 | 1884656 | 2021-11-04 | York | Virginia | 51199 | 5535 | 78 |
1830112 | 1830112 | 2021-10-19 | Pickens | Georgia | 13227 | 5535 | 110 |
1830986 | 1830986 | 2021-10-19 | Morrison | Minnesota | 27097 | 5535 | 66 |
1805488 | 1805488 | 2021-10-11 | Livingston | New York | 36051 | 5535 | 69 |
1778898 | 1778898 | 2021-10-03 | Hillsdale | Michigan | 26059 | 5535 | 110 |
1775648 | 1775648 | 2021-10-02 | Hillsdale | Michigan | 26059 | 5535 | 110 |
1772398 | 1772398 | 2021-10-01 | Hillsdale | Michigan | 26059 | 5535 | 110 |
1764241 | 1764241 | 2021-09-28 | Washington | Texas | 48477 | 5535 | 119 |
1741375 | 1741375 | 2021-09-21 | Howard | Texas | 48227 | 5535 | 113 |
1734207 | 1734207 | 2021-09-19 | Brown | Ohio | 39015 | 5535 | 68 |
1666864 | 1666864 | 2021-08-29 | Campbell | Virginia | 51031 | 5535 | 112 |
1663616 | 1663616 | 2021-08-28 | Campbell | Virginia | 51031 | 5535 | 112 |
1657539 | 1657539 | 2021-08-27 | Boone | Arkansas | 5009 | 5535 | 98 |
1660368 | 1660368 | 2021-08-27 | Campbell | Virginia | 51031 | 5535 | 112 |
1648159 | 1648159 | 2021-08-24 | Liberty | Georgia | 13179 | 5535 | 75 |
1648861 | 1648861 | 2021-08-24 | Webster | Louisiana | 22119 | 5535 | 123 |
1627084 | 1627084 | 2021-08-17 | Washington | Ohio | 39167 | 5535 | 111 |
1424434 | 1424434 | 2021-06-16 | Cerro Gordo | Iowa | 19033 | 5535 | 93 |
1425869 | 1425869 | 2021-06-16 | Linn | Oregon | 41043 | 5535 | 80 |
1381061 | 1381061 | 2021-06-02 | Box Elder | Utah | 49003 | 5535 | 51 |
1329259 | 1329259 | 2021-05-17 | Pittsylvania | Virginia | 51143 | 5535 | 81 |
1322767 | 1322767 | 2021-05-15 | Pittsylvania | Virginia | 51143 | 5535 | 80 |
1319521 | 1319521 | 2021-05-14 | Pittsylvania | Virginia | 51143 | 5535 | 80 |
1305615 | 1305615 | 2021-05-10 | Jefferson | Ohio | 39081 | 5535 | 151 |
1282894 | 1282894 | 2021-05-03 | Lawrence | Ohio | 39087 | 5535 | 102 |
1238679 | 1238679 | 2021-04-20 | Graham | Arizona | 4009 | 5535 | 77 |
1240768 | 1240768 | 2021-04-20 | Le Flore | Oklahoma | 40079 | 5535 | 63 |
1237521 | 1237521 | 2021-04-19 | Le Flore | Oklahoma | 40079 | 5535 | 63 |
1238259 | 1238259 | 2021-04-19 | Albemarle | Virginia | 51003 | 5535 | 82 |
1232562 | 1232562 | 2021-04-18 | Laurens | Georgia | 13175 | 5535 | 165 |
1234274 | 1234274 | 2021-04-18 | Le Flore | Oklahoma | 40079 | 5535 | 63 |
1231026 | 1231026 | 2021-04-17 | Le Flore | Oklahoma | 40079 | 5535 | 63 |
1227778 | 1227778 | 2021-04-16 | Le Flore | Oklahoma | 40079 | 5535 | 63 |
1224530 | 1224530 | 2021-04-15 | Le Flore | Oklahoma | 40079 | 5535 | 63 |
1221283 | 1221283 | 2021-04-14 | Le Flore | Oklahoma | 40079 | 5535 | 63 |
1214665 | 1214665 | 2021-04-12 | Belmont | Ohio | 39013 | 5535 | 158 |
1184100 | 1184100 | 2021-04-03 | Henry | Indiana | 18065 | 5535 | 101 |
1175518 | 1175518 | 2021-03-31 | Sullivan | New York | 36105 | 5535 | 64 |
1157300 | 1157300 | 2021-03-25 | Columbia | Wisconsin | 55021 | 5535 | 68 |
1119135 | 1119135 | 2021-03-14 | Cass | Indiana | 18017 | 5535 | 102 |
1114355 | 1114355 | 2021-03-12 | Cherokee | South Carolina | 45021 | 5535 | 140 |
977394 | 977394 | 2021-01-29 | Strafford | New Hampshire | 33017 | 5535 | 59 |
966278 | 966278 | 2021-01-26 | Bulloch | Georgia | 13031 | 5535 | 71 |
932795 | 932795 | 2021-01-15 | Anderson | Texas | 48001 | 5535 | 73 |
904935 | 904935 | 2021-01-07 | Floyd | Indiana | 18043 | 5535 | 107 |
845823 | 845823 | 2020-12-20 | Elmore | Alabama | 1051 | 5535 | 80 |
842528 | 842528 | 2020-12-18 | Wood | Wisconsin | 55141 | 5535 | 44 |
792409 | 792409 | 2020-12-03 | Rockingham | New Hampshire | 33015 | 5535 | 114 |
738745 | 738745 | 2020-11-17 | Morgan | Alabama | 1103 | 5535 | 42 |
625483 | 625483 | 2020-10-13 | Clay | Florida | 12019 | 5535 | 111 |
507107 | 507107 | 2020-09-06 | Somerset | New Jersey | 34035 | 5535 | 566 |
366895 | 366895 | 2020-07-25 | Adams | Colorado | 8001 | 5535 | 167 |
257883 | 257883 | 2020-06-20 | Bucks | Pennsylvania | 42017 | 5535 | 552 |
49432 | 49432 | 2020-04-11 | Orleans | Louisiana | 22071 | 5535 | 232 |
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);