ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where cases = 8020 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 |
---|---|---|---|---|---|---|---|
2421582 | 2421582 | 2022-04-19 | Poinsett | Arkansas | 5111 | 8020 | 126 |
2418326 | 2418326 | 2022-04-18 | Poinsett | Arkansas | 5111 | 8020 | 126 |
2397700 | 2397700 | 2022-04-11 | Tioga | Pennsylvania | 42117 | 8020 | 192 |
2394445 | 2394445 | 2022-04-10 | Tioga | Pennsylvania | 42117 | 8020 | 192 |
2198626 | 2198626 | 2022-02-09 | Silver Bow | Montana | 30093 | 8020 | 118 |
2172083 | 2172083 | 2022-02-01 | Evangeline | Louisiana | 22039 | 8020 | 148 |
2155898 | 2155898 | 2022-01-27 | Worcester | Maryland | 24047 | 8020 | 144 |
2153029 | 2153029 | 2022-01-26 | Webster | Missouri | 29225 | 8020 | 128 |
2122155 | 2122155 | 2022-01-17 | Covington | Alabama | 1039 | 8020 | 203 |
2107994 | 2107994 | 2022-01-12 | Mercer | Ohio | 39107 | 8020 | 112 |
2064068 | 2064068 | 2021-12-30 | Habersham | Georgia | 13137 | 8020 | 221 |
2054899 | 2054899 | 2021-12-27 | Floyd | Kentucky | 21071 | 8020 | 146 |
2054969 | 2054969 | 2021-12-27 | Shelby | Kentucky | 21211 | 8020 | 128 |
1971679 | 1971679 | 2021-12-01 | Venango | Pennsylvania | 42121 | 8020 | 170 |
1948921 | 1948921 | 2021-11-24 | Union | Pennsylvania | 42119 | 8020 | 109 |
1848103 | 1848103 | 2021-10-24 | Klamath | Oregon | 41035 | 8020 | 119 |
1844853 | 1844853 | 2021-10-23 | Klamath | Oregon | 41035 | 8020 | 119 |
1841603 | 1841603 | 2021-10-22 | Klamath | Oregon | 41035 | 8020 | 119 |
1837491 | 1837491 | 2021-10-21 | Otter Tail | Minnesota | 27111 | 8020 | 105 |
1779890 | 1779890 | 2021-10-03 | Yamhill | Oregon | 41071 | 8020 | 104 |
1776640 | 1776640 | 2021-10-02 | Yamhill | Oregon | 41071 | 8020 | 104 |
1773390 | 1773390 | 2021-10-01 | Yamhill | Oregon | 41071 | 8020 | 104 |
1747754 | 1747754 | 2021-09-23 | Warren | Tennessee | 47177 | 8020 | 101 |
1699340 | 1699340 | 2021-09-08 | Augusta | Virginia | 51015 | 8020 | 90 |
1674421 | 1674421 | 2021-09-01 | Morgan | Indiana | 18109 | 8020 | 157 |
1671512 | 1671512 | 2021-08-31 | Pike | Kentucky | 21195 | 8020 | 126 |
1666169 | 1666169 | 2021-08-29 | Linn | Oregon | 41043 | 8020 | 82 |
1662921 | 1662921 | 2021-08-28 | Linn | Oregon | 41043 | 8020 | 82 |
1659673 | 1659673 | 2021-08-27 | Linn | Oregon | 41043 | 8020 | 82 |
1630631 | 1630631 | 2021-08-18 | Laurens | South Carolina | 45059 | 8020 | 173 |
1598379 | 1598379 | 2021-08-08 | Coryell | Texas | 48099 | 8020 | 94 |
1595130 | 1595130 | 2021-08-07 | Coryell | Texas | 48099 | 8020 | 94 |
1518266 | 1518266 | 2021-07-15 | Rockdale | Georgia | 13247 | 8020 | 180 |
1511336 | 1511336 | 2021-07-13 | Fairbanks North Star Borough | Alaska | 2090 | 8020 | 44 |
1508089 | 1508089 | 2021-07-12 | Fairbanks North Star Borough | Alaska | 2090 | 8020 | 44 |
1403219 | 1403219 | 2021-06-09 | Somerset | Pennsylvania | 42111 | 8020 | 214 |
1357544 | 1357544 | 2021-05-26 | Erie | Ohio | 39043 | 8020 | 158 |
1342583 | 1342583 | 2021-05-22 | Santa Cruz | Arizona | 4023 | 8020 | 180 |
1253847 | 1253847 | 2021-04-24 | Clearfield | Pennsylvania | 42033 | 8020 | 135 |
1094562 | 1094562 | 2021-03-06 | Marion | Ohio | 39101 | 8020 | 127 |
979248 | 979248 | 2021-01-30 | Barrow | Georgia | 13013 | 8020 | 94 |
928815 | 928815 | 2021-01-14 | Schenectady | New York | 36093 | 8020 | 114 |
853762 | 853762 | 2020-12-22 | Rankin | Mississippi | 28121 | 8020 | 149 |
797320 | 797320 | 2020-12-05 | Marin | California | 6041 | 8020 | 131 |
789483 | 789483 | 2020-12-02 | Lorain | Ohio | 39093 | 8020 | 106 |
765325 | 765325 | 2020-11-25 | McLean | Illinois | 17113 | 8020 | 52 |
740953 | 740953 | 2020-11-17 | Washington | Oregon | 41067 | 8020 | 92 |
642377 | 642377 | 2020-10-18 | Wyandotte | Kansas | 20209 | 8020 | 145 |
355889 | 355889 | 2020-07-21 | Hamilton | Ohio | 39061 | 8020 | 219 |
159995 | 159995 | 2020-05-19 | Fairfax | Virginia | 51059 | 8020 | 292 |
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);