ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 9063 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 14
- Alabama 4
- Indiana 4
- Minnesota 3
- Maryland 2
- Montana 2
- New York 2
- South Carolina 2
- California 1
- Idaho 1
- New Jersey 1
- Ohio 1
- Pennsylvania 1
- Tennessee 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2456280 | 2456280 | 2022-04-29 | Jefferson | Pennsylvania | 42065 | 9063 | 233 |
2449318 | 2449318 | 2022-04-27 | Allegany | New York | 36003 | 9063 | 154 |
2347939 | 2347939 | 2022-03-27 | Morrison | Minnesota | 27097 | 9063 | 104 |
2344686 | 2344686 | 2022-03-26 | Morrison | Minnesota | 27097 | 9063 | 104 |
2341433 | 2341433 | 2022-03-25 | Morrison | Minnesota | 27097 | 9063 | 104 |
2210694 | 2210694 | 2022-02-13 | Clinton | Indiana | 18023 | 9063 | 113 |
2207441 | 2207441 | 2022-02-12 | Clinton | Indiana | 18023 | 9063 | 113 |
2204188 | 2204188 | 2022-02-11 | Clinton | Indiana | 18023 | 9063 | 113 |
2200975 | 2200975 | 2022-02-10 | Miami | Indiana | 18103 | 9063 | 148 |
1992125 | 1992125 | 2021-12-08 | Dale | Alabama | 1045 | 9063 | 192 |
1908805 | 1908805 | 2021-11-12 | Cecil | Maryland | 24015 | 9063 | 185 |
1896448 | 1896448 | 2021-11-08 | Cayuga | New York | 36011 | 9063 | 108 |
1754748 | 1754748 | 2021-09-25 | Harrison | West Virginia | 54033 | 9063 | 105 |
1693158 | 1693158 | 2021-09-07 | Autauga | Alabama | 1001 | 9063 | 119 |
1611131 | 1611131 | 2021-08-12 | Darlington | South Carolina | 45031 | 9063 | 185 |
1510089 | 1510089 | 2021-07-12 | Columbiana | Ohio | 39029 | 9063 | 235 |
1504793 | 1504793 | 2021-07-11 | DeKalb | Alabama | 1049 | 9063 | 191 |
1501547 | 1501547 | 2021-07-10 | DeKalb | Alabama | 1049 | 9063 | 191 |
1305159 | 1305159 | 2021-05-10 | Missoula | Montana | 30063 | 9063 | 93 |
1301913 | 1301913 | 2021-05-09 | Missoula | Montana | 30063 | 9063 | 93 |
1265764 | 1265764 | 2021-04-28 | Carroll | Maryland | 24013 | 9063 | 233 |
1120876 | 1120876 | 2021-03-14 | Orangeburg | South Carolina | 45075 | 9063 | 222 |
1112528 | 1112528 | 2021-03-12 | Twin Falls | Idaho | 16083 | 9063 | 125 |
900317 | 900317 | 2021-01-05 | Putnam | Tennessee | 47141 | 9063 | 124 |
669139 | 669139 | 2020-10-26 | Morris | New Jersey | 34027 | 9063 | 834 |
469964 | 469964 | 2020-08-26 | San Francisco | California | 6075 | 9063 | 80 |
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);