ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16 rows where cases = 522 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- Montana · 16 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2240872 | 2240872 | 2022-02-22 | Granite | Montana | 30039 | 522 | 7 |
1964478 | 1964478 | 2021-11-29 | Fallon | Montana | 30025 | 522 | 8 |
1961227 | 1961227 | 2021-11-28 | Fallon | Montana | 30025 | 522 | 8 |
1957976 | 1957976 | 2021-11-27 | Fallon | Montana | 30025 | 522 | 8 |
1954725 | 1954725 | 2021-11-26 | Fallon | Montana | 30025 | 522 | 8 |
1951474 | 1951474 | 2021-11-25 | Fallon | Montana | 30025 | 522 | 8 |
1948223 | 1948223 | 2021-11-24 | Fallon | Montana | 30025 | 522 | 8 |
1906005 | 1906005 | 2021-11-11 | Sheridan | Montana | 30091 | 522 | 8 |
1902756 | 1902756 | 2021-11-10 | Sheridan | Montana | 30091 | 522 | 8 |
1743531 | 1743531 | 2021-09-22 | Mineral | Montana | 30061 | 522 | 9 |
1629806 | 1629806 | 2021-08-18 | Chouteau | Montana | 30015 | 522 | 7 |
1626559 | 1626559 | 2021-08-17 | Chouteau | Montana | 30015 | 522 | 7 |
1451204 | 1451204 | 2021-06-24 | Broadwater | Montana | 30007 | 522 | 5 |
1447958 | 1447958 | 2021-06-23 | Broadwater | Montana | 30007 | 522 | 5 |
782504 | 782504 | 2020-11-30 | Blaine | Montana | 30005 | 522 | 18 |
548986 | 548986 | 2020-09-19 | Cascade | Montana | 30013 | 522 | 5 |
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);