ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17 rows where cases = 16583 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 |
---|---|---|---|---|---|---|---|
2206348 | 2206348 | 2022-02-11 | Wise | Texas | 48497 | 16583 | 237 |
2183375 | 2183375 | 2022-02-04 | Coryell | Texas | 48099 | 16583 | 180 |
2044248 | 2044248 | 2021-12-24 | Garland | Arkansas | 5051 | 16583 | 416 |
2029780 | 2029780 | 2021-12-19 | Burke | North Carolina | 37023 | 16583 | 248 |
2026529 | 2026529 | 2021-12-18 | Burke | North Carolina | 37023 | 16583 | 248 |
2023278 | 2023278 | 2021-12-17 | Burke | North Carolina | 37023 | 16583 | 248 |
1976451 | 1976451 | 2021-12-03 | Twin Falls | Idaho | 16083 | 16583 | 232 |
1973202 | 1973202 | 2021-12-02 | Twin Falls | Idaho | 16083 | 16583 | 232 |
1923917 | 1923917 | 2021-11-17 | Fairbanks North Star Borough | Alaska | 2090 | 16583 | 105 |
1702324 | 1702324 | 2021-09-09 | Comal | Texas | 48091 | 16583 | 389 |
1494534 | 1494534 | 2021-07-07 | Kaufman | Texas | 48257 | 16583 | 266 |
1471936 | 1471936 | 2021-06-30 | Cache | Utah | 49005 | 16583 | 50 |
1433463 | 1433463 | 2021-06-19 | Navajo | Arizona | 4017 | 16583 | 550 |
1373796 | 1373796 | 2021-05-31 | Licking | Ohio | 39089 | 16583 | 218 |
1370551 | 1370551 | 2021-05-30 | Licking | Ohio | 39089 | 16583 | 218 |
1193843 | 1193843 | 2021-04-06 | Hendricks | Indiana | 18063 | 16583 | 327 |
915882 | 915882 | 2021-01-10 | Durham | North Carolina | 37063 | 16583 | 150 |
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);