ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
15 rows where deaths = 12 and fips = 30071 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
899370 | 899370 | 2021-01-05 | Phillips | Montana | 30071 | 436 | 12 |
896125 | 896125 | 2021-01-04 | Phillips | Montana | 30071 | 430 | 12 |
892878 | 892878 | 2021-01-03 | Phillips | Montana | 30071 | 430 | 12 |
889632 | 889632 | 2021-01-02 | Phillips | Montana | 30071 | 430 | 12 |
886386 | 886386 | 2021-01-01 | Phillips | Montana | 30071 | 426 | 12 |
883141 | 883141 | 2020-12-31 | Phillips | Montana | 30071 | 426 | 12 |
879896 | 879896 | 2020-12-30 | Phillips | Montana | 30071 | 423 | 12 |
876651 | 876651 | 2020-12-29 | Phillips | Montana | 30071 | 421 | 12 |
873406 | 873406 | 2020-12-28 | Phillips | Montana | 30071 | 421 | 12 |
870161 | 870161 | 2020-12-27 | Phillips | Montana | 30071 | 418 | 12 |
866916 | 866916 | 2020-12-26 | Phillips | Montana | 30071 | 418 | 12 |
863671 | 863671 | 2020-12-25 | Phillips | Montana | 30071 | 416 | 12 |
860426 | 860426 | 2020-12-24 | Phillips | Montana | 30071 | 416 | 12 |
857181 | 857181 | 2020-12-23 | Phillips | Montana | 30071 | 409 | 12 |
853936 | 853936 | 2020-12-22 | Phillips | Montana | 30071 | 398 | 12 |
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);