ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where cases = 8800 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2403212 | 2403212 | 2022-04-13 | Becker | Minnesota | 27005 | 8800 | 92 |
2338389 | 2338389 | 2022-03-24 | Pulaski | Missouri | 29169 | 8800 | 115 |
2291139 | 2291139 | 2022-03-09 | Marshall | West Virginia | 54051 | 8800 | 150 |
2280993 | 2280993 | 2022-03-06 | Hill | Texas | 48217 | 8800 | 191 |
2277740 | 2277740 | 2022-03-05 | Hill | Texas | 48217 | 8800 | 191 |
2263844 | 2263844 | 2022-03-01 | Allegany | New York | 36003 | 8800 | 149 |
2199831 | 2199831 | 2022-02-09 | Washington | Texas | 48477 | 8800 | 143 |
2165205 | 2165205 | 2022-01-30 | Putnam | Indiana | 18133 | 8800 | 106 |
2161950 | 2161950 | 2022-01-29 | Putnam | Indiana | 18133 | 8800 | 106 |
2158695 | 2158695 | 2022-01-28 | Putnam | Indiana | 18133 | 8800 | 106 |
2149321 | 2149321 | 2022-01-25 | Natchitoches | Louisiana | 22069 | 8800 | 145 |
2122840 | 2122840 | 2022-01-17 | Woodford | Illinois | 17203 | 8800 | 112 |
2119588 | 2119588 | 2022-01-16 | Woodford | Illinois | 17203 | 8800 | 112 |
2116336 | 2116336 | 2022-01-15 | Woodford | Illinois | 17203 | 8800 | 112 |
2113085 | 2113085 | 2022-01-14 | Woodford | Illinois | 17203 | 8800 | 112 |
2114464 | 2114464 | 2022-01-14 | Defiance | Ohio | 39039 | 8800 | 134 |
2035620 | 2035620 | 2021-12-21 | Cass | Michigan | 26027 | 8800 | 108 |
2032370 | 2032370 | 2021-12-20 | Cass | Michigan | 26027 | 8800 | 108 |
2019461 | 2019461 | 2021-12-16 | Goodhue | Minnesota | 27049 | 8800 | 106 |
1992260 | 1992260 | 2021-12-08 | Mississippi | Arkansas | 5093 | 8800 | 152 |
1875366 | 1875366 | 2021-11-02 | Fremont | Colorado | 8043 | 8800 | 96 |
1857581 | 1857581 | 2021-10-27 | Pender | North Carolina | 37141 | 8800 | 101 |
1835954 | 1835954 | 2021-10-20 | Walla Walla | Washington | 53071 | 8800 | 98 |
1811283 | 1811283 | 2021-10-13 | St. Charles | Louisiana | 22089 | 8800 | 124 |
1807309 | 1807309 | 2021-10-12 | Effingham | Georgia | 13103 | 8800 | 152 |
1741215 | 1741215 | 2021-09-21 | Lawrence | Tennessee | 47099 | 8800 | 107 |
1737966 | 1737966 | 2021-09-20 | Lawrence | Tennessee | 47099 | 8800 | 107 |
1717194 | 1717194 | 2021-09-14 | Montcalm | Michigan | 26117 | 8800 | 126 |
1713946 | 1713946 | 2021-09-13 | Montcalm | Michigan | 26117 | 8800 | 126 |
1691301 | 1691301 | 2021-09-06 | Rice | Minnesota | 27131 | 8800 | 115 |
1688051 | 1688051 | 2021-09-05 | Rice | Minnesota | 27131 | 8800 | 115 |
1684801 | 1684801 | 2021-09-04 | Rice | Minnesota | 27131 | 8800 | 115 |
1681550 | 1681550 | 2021-09-03 | Rice | Minnesota | 27131 | 8800 | 115 |
1452390 | 1452390 | 2021-06-24 | Orange | Texas | 48361 | 8800 | 154 |
1449144 | 1449144 | 2021-06-23 | Orange | Texas | 48361 | 8800 | 154 |
1445899 | 1445899 | 2021-06-22 | Orange | Texas | 48361 | 8800 | 154 |
1377796 | 1377796 | 2021-06-01 | Walker | Texas | 48471 | 8800 | 131 |
1374550 | 1374550 | 2021-05-31 | Walker | Texas | 48471 | 8800 | 131 |
1371305 | 1371305 | 2021-05-30 | Walker | Texas | 48471 | 8800 | 131 |
1368059 | 1368059 | 2021-05-29 | Walker | Texas | 48471 | 8800 | 131 |
1336540 | 1336540 | 2021-05-20 | Bannock | Idaho | 16005 | 8800 | 109 |
1308358 | 1308358 | 2021-05-11 | St. Francois | Missouri | 29187 | 8800 | 115 |
1257836 | 1257836 | 2021-04-25 | Portsmouth city | Virginia | 51740 | 8800 | 187 |
1226798 | 1226798 | 2021-04-16 | Carroll | Maryland | 24013 | 8800 | 229 |
1219058 | 1219058 | 2021-04-13 | St. Croix | Wisconsin | 55109 | 8800 | 57 |
1194706 | 1194706 | 2021-04-06 | St. Francois | Missouri | 29187 | 8800 | 110 |
1167748 | 1167748 | 2021-03-29 | DeKalb | Illinois | 17037 | 8800 | 122 |
1141842 | 1141842 | 2021-03-21 | Vermilion | Illinois | 17183 | 8800 | 137 |
1100342 | 1100342 | 2021-03-08 | Sherburne | Minnesota | 27141 | 8800 | 74 |
1057148 | 1057148 | 2021-02-23 | Barrow | Georgia | 13013 | 8800 | 115 |
1058567 | 1058567 | 2021-02-23 | Chaves | New Mexico | 35005 | 8800 | 147 |
714877 | 714877 | 2020-11-09 | Summit | Ohio | 39153 | 8800 | 280 |
611718 | 611718 | 2020-10-08 | McLennan | Texas | 48309 | 8800 | 123 |
570368 | 570368 | 2020-09-26 | Brevard | Florida | 12009 | 8800 | 293 |
491919 | 491919 | 2020-09-01 | Montgomery | Texas | 48339 | 8800 | 125 |
349389 | 349389 | 2020-07-19 | Wake | North Carolina | 37183 | 8800 | 89 |
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);