ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
33 rows where cases = 8131 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 |
---|---|---|---|---|---|---|---|
2424515 | 2424515 | 2022-04-19 | Stevens | Washington | 53065 | 8131 | 144 |
2421259 | 2421259 | 2022-04-18 | Stevens | Washington | 53065 | 8131 | 144 |
2267222 | 2267222 | 2022-03-02 | Pasquotank | North Carolina | 37139 | 8131 | 111 |
2220755 | 2220755 | 2022-02-16 | Carter | Kentucky | 21043 | 8131 | 96 |
2199889 | 2199889 | 2022-02-09 | Washington | Vermont | 50023 | 8131 | 44 |
2191465 | 2191465 | 2022-02-07 | Bell | Kentucky | 21013 | 8131 | 123 |
2132075 | 2132075 | 2022-01-20 | Union | Arkansas | 5139 | 8131 | 157 |
2079656 | 2079656 | 2022-01-03 | Shenandoah | Virginia | 51171 | 8131 | 187 |
2012018 | 2012018 | 2021-12-14 | Camden | Georgia | 13039 | 8131 | 97 |
1994730 | 1994730 | 2021-12-08 | Anderson | Texas | 48001 | 8131 | 206 |
1922784 | 1922784 | 2021-11-16 | Le Flore | Oklahoma | 40079 | 8131 | 89 |
1919535 | 1919535 | 2021-11-15 | Le Flore | Oklahoma | 40079 | 8131 | 89 |
1916285 | 1916285 | 2021-11-14 | Le Flore | Oklahoma | 40079 | 8131 | 89 |
1913035 | 1913035 | 2021-11-13 | Le Flore | Oklahoma | 40079 | 8131 | 89 |
1909785 | 1909785 | 2021-11-12 | Le Flore | Oklahoma | 40079 | 8131 | 89 |
1906536 | 1906536 | 2021-11-11 | Le Flore | Oklahoma | 40079 | 8131 | 89 |
1903287 | 1903287 | 2021-11-10 | Le Flore | Oklahoma | 40079 | 8131 | 89 |
1854502 | 1854502 | 2021-10-26 | Washington | Ohio | 39167 | 8131 | 147 |
1655723 | 1655723 | 2021-08-26 | Joplin | Missouri | 8131 | 136 | |
1384665 | 1384665 | 2021-06-03 | Natrona | Wyoming | 56025 | 8131 | 138 |
1368632 | 1368632 | 2021-05-30 | White | Arkansas | 5145 | 8131 | 120 |
1336687 | 1336687 | 2021-05-20 | Bartholomew | Indiana | 18005 | 8131 | 161 |
1296031 | 1296031 | 2021-05-07 | Umatilla | Oregon | 41059 | 8131 | 84 |
1241887 | 1241887 | 2021-04-21 | Talladega | Alabama | 1121 | 8131 | 173 |
1213199 | 1213199 | 2021-04-12 | Adams | Illinois | 17001 | 8131 | 145 |
1209135 | 1209135 | 2021-04-10 | Roanoke city | Virginia | 51770 | 8131 | 184 |
1140013 | 1140013 | 2021-03-20 | Marion | Ohio | 39101 | 8131 | 132 |
854559 | 854559 | 2020-12-22 | Cambria | Pennsylvania | 42021 | 8131 | 211 |
797154 | 797154 | 2020-12-05 | Lee | Alabama | 1081 | 8131 | 68 |
751681 | 751681 | 2020-11-21 | Baldwin | Alabama | 1003 | 8131 | 84 |
643315 | 643315 | 2020-10-18 | Forsyth | North Carolina | 37067 | 8131 | 111 |
498892 | 498892 | 2020-09-04 | Montgomery | Alabama | 1101 | 8131 | 166 |
167580 | 167580 | 2020-05-22 | Oakland | Michigan | 26125 | 8131 | 944 |
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);