ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where deaths = 6, fips = 30009 and state = "Montana" 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 |
---|---|---|---|---|---|---|---|
811710 | 811710 | 2020-12-09 | Carbon | Montana | 30009 | 630 | 6 |
808465 | 808465 | 2020-12-08 | Carbon | Montana | 30009 | 629 | 6 |
805220 | 805220 | 2020-12-07 | Carbon | Montana | 30009 | 621 | 6 |
801975 | 801975 | 2020-12-06 | Carbon | Montana | 30009 | 617 | 6 |
798730 | 798730 | 2020-12-05 | Carbon | Montana | 30009 | 615 | 6 |
795485 | 795485 | 2020-12-04 | Carbon | Montana | 30009 | 613 | 6 |
792240 | 792240 | 2020-12-03 | Carbon | Montana | 30009 | 605 | 6 |
788995 | 788995 | 2020-12-02 | Carbon | Montana | 30009 | 599 | 6 |
785750 | 785750 | 2020-12-01 | Carbon | Montana | 30009 | 595 | 6 |
782506 | 782506 | 2020-11-30 | Carbon | Montana | 30009 | 588 | 6 |
779260 | 779260 | 2020-11-29 | Carbon | Montana | 30009 | 584 | 6 |
776015 | 776015 | 2020-11-28 | Carbon | Montana | 30009 | 581 | 6 |
772770 | 772770 | 2020-11-27 | Carbon | Montana | 30009 | 575 | 6 |
769525 | 769525 | 2020-11-26 | Carbon | Montana | 30009 | 575 | 6 |
766279 | 766279 | 2020-11-25 | Carbon | Montana | 30009 | 568 | 6 |
763034 | 763034 | 2020-11-24 | Carbon | Montana | 30009 | 562 | 6 |
759789 | 759789 | 2020-11-23 | Carbon | Montana | 30009 | 554 | 6 |
756542 | 756542 | 2020-11-22 | Carbon | Montana | 30009 | 547 | 6 |
753296 | 753296 | 2020-11-21 | Carbon | Montana | 30009 | 542 | 6 |
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);