ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
28 rows where cases = 16081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- Tennessee 7
- California 6
- Colorado 3
- North Carolina 3
- Alabama 2
- New York 2
- Arizona 1
- Kentucky 1
- Rhode Island 1
- Texas 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494915 | 2494915 | 2022-05-11 | Cattaraugus | New York | 36009 | 16081 | 222 |
2437960 | 2437960 | 2022-04-24 | Eagle | Colorado | 8037 | 16081 | 35 |
2434704 | 2434704 | 2022-04-23 | Eagle | Colorado | 8037 | 16081 | 35 |
2431448 | 2431448 | 2022-04-22 | Eagle | Colorado | 8037 | 16081 | 35 |
2402090 | 2402090 | 2022-04-13 | Mendocino | California | 6045 | 16081 | 120 |
2398835 | 2398835 | 2022-04-12 | Mendocino | California | 6045 | 16081 | 120 |
2395580 | 2395580 | 2022-04-11 | Mendocino | California | 6045 | 16081 | 120 |
2392324 | 2392324 | 2022-04-10 | Mendocino | California | 6045 | 16081 | 120 |
2389068 | 2389068 | 2022-04-09 | Mendocino | California | 6045 | 16081 | 120 |
2385813 | 2385813 | 2022-04-08 | Mendocino | California | 6045 | 16081 | 120 |
2355618 | 2355618 | 2022-03-29 | Cumberland | Tennessee | 47035 | 16081 | 320 |
2352365 | 2352365 | 2022-03-28 | Cumberland | Tennessee | 47035 | 16081 | 320 |
2349113 | 2349113 | 2022-03-27 | Cumberland | Tennessee | 47035 | 16081 | 320 |
2345860 | 2345860 | 2022-03-26 | Cumberland | Tennessee | 47035 | 16081 | 320 |
2342607 | 2342607 | 2022-03-25 | Cumberland | Tennessee | 47035 | 16081 | 320 |
2339354 | 2339354 | 2022-03-24 | Cumberland | Tennessee | 47035 | 16081 | 320 |
2336100 | 2336100 | 2022-03-23 | Cumberland | Tennessee | 47035 | 16081 | 320 |
2159823 | 2159823 | 2022-01-28 | Tompkins | New York | 36109 | 16081 | 76 |
1969374 | 1969374 | 2021-12-01 | Cullman | Alabama | 1043 | 16081 | 304 |
1945262 | 1945262 | 2021-11-23 | Burke | North Carolina | 37023 | 16081 | 245 |
1608708 | 1608708 | 2021-08-12 | Calhoun | Alabama | 1015 | 16081 | 337 |
1340342 | 1340342 | 2021-05-21 | Warren | Kentucky | 21227 | 16081 | 171 |
1309512 | 1309512 | 2021-05-11 | Kaufman | Texas | 48257 | 16081 | 258 |
1115135 | 1115135 | 2021-03-12 | Rock | Wisconsin | 55105 | 16081 | 176 |
1074947 | 1074947 | 2021-02-28 | New Hanover | North Carolina | 37129 | 16081 | 150 |
1071701 | 1071701 | 2021-02-27 | New Hanover | North Carolina | 37129 | 16081 | 150 |
1034129 | 1034129 | 2021-02-16 | Coconino | Arizona | 4005 | 16081 | 302 |
919604 | 919604 | 2021-01-11 | Unknown | Rhode Island | 16081 | 97 |
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);