ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
25 rows where cases = 17459 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 11
- California 5
- Mississippi 4
- Georgia 3
- Tennessee 3
- Connecticut 2
- Louisiana 2
- Michigan 2
- New Jersey 1
- Ohio 1
- Pennsylvania 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2281754 | 2281754 | 2022-03-07 | Yuba | California | 6115 | 17459 | 115 |
2278501 | 2278501 | 2022-03-06 | Yuba | California | 6115 | 17459 | 115 |
2279716 | 2279716 | 2022-03-06 | Lowndes | Mississippi | 28087 | 17459 | 233 |
2275248 | 2275248 | 2022-03-05 | Yuba | California | 6115 | 17459 | 115 |
2276463 | 2276463 | 2022-03-05 | Lowndes | Mississippi | 28087 | 17459 | 233 |
2271995 | 2271995 | 2022-03-04 | Yuba | California | 6115 | 17459 | 115 |
2273210 | 2273210 | 2022-03-04 | Lowndes | Mississippi | 28087 | 17459 | 233 |
2268743 | 2268743 | 2022-03-03 | Yuba | California | 6115 | 17459 | 115 |
2156992 | 2156992 | 2022-01-27 | Somerset | Pennsylvania | 42111 | 17459 | 368 |
1664348 | 1664348 | 2021-08-29 | Coweta | Georgia | 13077 | 17459 | 247 |
1661100 | 1661100 | 2021-08-28 | Coweta | Georgia | 13077 | 17459 | 247 |
1657852 | 1657852 | 2021-08-27 | Coweta | Georgia | 13077 | 17459 | 247 |
1530106 | 1530106 | 2021-07-18 | Sullivan | Tennessee | 47163 | 17459 | 313 |
1526859 | 1526859 | 2021-07-17 | Sullivan | Tennessee | 47163 | 17459 | 313 |
1523612 | 1523612 | 2021-07-16 | Sullivan | Tennessee | 47163 | 17459 | 313 |
1282109 | 1282109 | 2021-05-03 | St. Clair | Michigan | 26147 | 17459 | 389 |
1201044 | 1201044 | 2021-04-08 | Harrison | Mississippi | 28047 | 17459 | 302 |
995397 | 995397 | 2021-02-04 | New London | Connecticut | 9011 | 17459 | 374 |
955583 | 955583 | 2021-01-22 | Ellis | Texas | 48139 | 17459 | 213 |
841441 | 841441 | 2020-12-18 | Stark | Ohio | 39151 | 17459 | 258 |
571186 | 571186 | 2020-09-26 | Jefferson | Louisiana | 22051 | 17459 | 568 |
567944 | 567944 | 2020-09-25 | Jefferson | Louisiana | 22051 | 17459 | 568 |
467813 | 467813 | 2020-08-25 | Oakland | Michigan | 26125 | 17459 | 1155 |
373380 | 373380 | 2020-07-27 | Fairfield | Connecticut | 9001 | 17459 | 1402 |
155886 | 155886 | 2020-05-18 | Bergen | New Jersey | 34003 | 17459 | 1460 |
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);