ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21 rows where cases = 420 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Montana · 21 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1769503 | 1769503 | 2021-09-30 | Fallon | Montana | 30025 | 420 | 4 |
1665564 | 1665564 | 2021-08-29 | Mineral | Montana | 30061 | 420 | 9 |
1662316 | 1662316 | 2021-08-28 | Mineral | Montana | 30061 | 420 | 9 |
1659068 | 1659068 | 2021-08-27 | Mineral | Montana | 30061 | 420 | 9 |
1214258 | 1214258 | 2021-04-12 | Sheridan | Montana | 30091 | 420 | 5 |
1211010 | 1211010 | 2021-04-11 | Sheridan | Montana | 30091 | 420 | 5 |
1207761 | 1207761 | 2021-04-10 | Sheridan | Montana | 30091 | 420 | 5 |
1204513 | 1204513 | 2021-04-09 | Sheridan | Montana | 30091 | 420 | 5 |
1201265 | 1201265 | 2021-04-08 | Sheridan | Montana | 30091 | 420 | 5 |
1198016 | 1198016 | 2021-04-07 | Sheridan | Montana | 30091 | 420 | 5 |
1116793 | 1116793 | 2021-03-13 | Broadwater | Montana | 30007 | 420 | 5 |
1113547 | 1113547 | 2021-03-12 | Broadwater | Montana | 30007 | 420 | 5 |
1110301 | 1110301 | 2021-03-11 | Broadwater | Montana | 30007 | 420 | 5 |
1107055 | 1107055 | 2021-03-10 | Broadwater | Montana | 30007 | 420 | 5 |
1042184 | 1042184 | 2021-02-18 | Teton | Montana | 30099 | 420 | 5 |
1038939 | 1038939 | 2021-02-17 | Teton | Montana | 30099 | 420 | 5 |
1035694 | 1035694 | 2021-02-16 | Teton | Montana | 30099 | 420 | 5 |
1032449 | 1032449 | 2021-02-15 | Teton | Montana | 30099 | 420 | 5 |
866925 | 866925 | 2020-12-26 | Sanders | Montana | 30089 | 420 | 3 |
863680 | 863680 | 2020-12-25 | Sanders | Montana | 30089 | 420 | 3 |
860435 | 860435 | 2020-12-24 | Sanders | Montana | 30089 | 420 | 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);