ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where county = "Marion", deaths = 63 and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2103703 | 2103703 | 2022-01-11 | Marion | Kentucky | 21155 | 4749 | 63 |
2100452 | 2100452 | 2022-01-10 | Marion | Kentucky | 21155 | 4699 | 63 |
2097201 | 2097201 | 2022-01-09 | Marion | Kentucky | 21155 | 4665 | 63 |
2093949 | 2093949 | 2022-01-08 | Marion | Kentucky | 21155 | 4665 | 63 |
2090697 | 2090697 | 2022-01-07 | Marion | Kentucky | 21155 | 4665 | 63 |
2087446 | 2087446 | 2022-01-06 | Marion | Kentucky | 21155 | 4629 | 63 |
2084194 | 2084194 | 2022-01-05 | Marion | Kentucky | 21155 | 4599 | 63 |
2080942 | 2080942 | 2022-01-04 | Marion | Kentucky | 21155 | 4564 | 63 |
2077690 | 2077690 | 2022-01-03 | Marion | Kentucky | 21155 | 4523 | 63 |
2074439 | 2074439 | 2022-01-02 | Marion | Kentucky | 21155 | 4457 | 63 |
2071188 | 2071188 | 2022-01-01 | Marion | Kentucky | 21155 | 4457 | 63 |
2067937 | 2067937 | 2021-12-31 | Marion | Kentucky | 21155 | 4457 | 63 |
2064686 | 2064686 | 2021-12-30 | Marion | Kentucky | 21155 | 4457 | 63 |
2061436 | 2061436 | 2021-12-29 | Marion | Kentucky | 21155 | 4457 | 63 |
2058187 | 2058187 | 2021-12-28 | Marion | Kentucky | 21155 | 4453 | 63 |
2054938 | 2054938 | 2021-12-27 | Marion | Kentucky | 21155 | 4422 | 63 |
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);