ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where deaths = 3, fips = 30067 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
811739 | 811739 | 2020-12-09 | Park | Montana | 30067 | 746 | 3 |
808494 | 808494 | 2020-12-08 | Park | Montana | 30067 | 735 | 3 |
805249 | 805249 | 2020-12-07 | Park | Montana | 30067 | 729 | 3 |
802004 | 802004 | 2020-12-06 | Park | Montana | 30067 | 719 | 3 |
798759 | 798759 | 2020-12-05 | Park | Montana | 30067 | 703 | 3 |
795514 | 795514 | 2020-12-04 | Park | Montana | 30067 | 701 | 3 |
792269 | 792269 | 2020-12-03 | Park | Montana | 30067 | 673 | 3 |
789024 | 789024 | 2020-12-02 | Park | Montana | 30067 | 670 | 3 |
785779 | 785779 | 2020-12-01 | Park | Montana | 30067 | 666 | 3 |
782535 | 782535 | 2020-11-30 | Park | Montana | 30067 | 653 | 3 |
779289 | 779289 | 2020-11-29 | Park | Montana | 30067 | 637 | 3 |
776044 | 776044 | 2020-11-28 | Park | Montana | 30067 | 631 | 3 |
772799 | 772799 | 2020-11-27 | Park | Montana | 30067 | 615 | 3 |
769554 | 769554 | 2020-11-26 | Park | Montana | 30067 | 603 | 3 |
766308 | 766308 | 2020-11-25 | Park | Montana | 30067 | 592 | 3 |
763063 | 763063 | 2020-11-24 | Park | Montana | 30067 | 562 | 3 |
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);