ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
56 rows where "date" is on date 2020-11-02 and state = "Montana" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Beaverhead 1
- Big Horn 1
- Blaine 1
- Broadwater 1
- Carbon 1
- Carter 1
- Cascade 1
- Chouteau 1
- Custer 1
- Daniels 1
- Dawson 1
- Deer Lodge 1
- Fallon 1
- Fergus 1
- Flathead 1
- Gallatin 1
- Garfield 1
- Glacier 1
- Golden Valley 1
- Granite 1
- Hill 1
- Jefferson 1
- Judith Basin 1
- Lake 1
- Lewis and Clark 1
- Liberty 1
- Lincoln 1
- Madison 1
- McCone 1
- Meagher 1
- …
state 1
- Montana · 56 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
691653 | 691653 | 2020-11-02 | Beaverhead | Montana | 30001 | 305 | 1 |
691654 | 691654 | 2020-11-02 | Big Horn | Montana | 30003 | 1433 | 39 |
691655 | 691655 | 2020-11-02 | Blaine | Montana | 30005 | 373 | 7 |
691656 | 691656 | 2020-11-02 | Broadwater | Montana | 30007 | 94 | 0 |
691657 | 691657 | 2020-11-02 | Carbon | Montana | 30009 | 277 | 1 |
691658 | 691658 | 2020-11-02 | Carter | Montana | 30011 | 77 | 2 |
691659 | 691659 | 2020-11-02 | Cascade | Montana | 30013 | 2241 | 16 |
691660 | 691660 | 2020-11-02 | Chouteau | Montana | 30015 | 122 | 0 |
691661 | 691661 | 2020-11-02 | Custer | Montana | 30017 | 345 | 3 |
691662 | 691662 | 2020-11-02 | Daniels | Montana | 30019 | 49 | 3 |
691663 | 691663 | 2020-11-02 | Dawson | Montana | 30021 | 279 | 4 |
691664 | 691664 | 2020-11-02 | Deer Lodge | Montana | 30023 | 491 | 1 |
691665 | 691665 | 2020-11-02 | Fallon | Montana | 30025 | 85 | 0 |
691666 | 691666 | 2020-11-02 | Fergus | Montana | 30027 | 270 | 2 |
691667 | 691667 | 2020-11-02 | Flathead | Montana | 30029 | 3686 | 27 |
691668 | 691668 | 2020-11-02 | Gallatin | Montana | 30031 | 3655 | 9 |
691669 | 691669 | 2020-11-02 | Garfield | Montana | 30033 | 30 | 0 |
691670 | 691670 | 2020-11-02 | Glacier | Montana | 30035 | 1012 | 16 |
691671 | 691671 | 2020-11-02 | Golden Valley | Montana | 30037 | 16 | 0 |
691672 | 691672 | 2020-11-02 | Granite | Montana | 30039 | 74 | 0 |
691673 | 691673 | 2020-11-02 | Hill | Montana | 30041 | 913 | 20 |
691674 | 691674 | 2020-11-02 | Jefferson | Montana | 30043 | 186 | 0 |
691675 | 691675 | 2020-11-02 | Judith Basin | Montana | 30045 | 18 | 0 |
691676 | 691676 | 2020-11-02 | Lake | Montana | 30047 | 645 | 6 |
691677 | 691677 | 2020-11-02 | Lewis and Clark | Montana | 30049 | 1136 | 6 |
691678 | 691678 | 2020-11-02 | Liberty | Montana | 30051 | 38 | 0 |
691679 | 691679 | 2020-11-02 | Lincoln | Montana | 30053 | 336 | 5 |
691680 | 691680 | 2020-11-02 | Madison | Montana | 30057 | 211 | 1 |
691681 | 691681 | 2020-11-02 | McCone | Montana | 30055 | 67 | 0 |
691682 | 691682 | 2020-11-02 | Meagher | Montana | 30059 | 84 | 5 |
691683 | 691683 | 2020-11-02 | Mineral | Montana | 30061 | 17 | 0 |
691684 | 691684 | 2020-11-02 | Missoula | Montana | 30063 | 2484 | 21 |
691685 | 691685 | 2020-11-02 | Musselshell | Montana | 30065 | 128 | 2 |
691686 | 691686 | 2020-11-02 | Park | Montana | 30067 | 286 | 0 |
691687 | 691687 | 2020-11-02 | Petroleum | Montana | 30069 | 4 | 0 |
691688 | 691688 | 2020-11-02 | Phillips | Montana | 30071 | 195 | 1 |
691689 | 691689 | 2020-11-02 | Pondera | Montana | 30073 | 192 | 1 |
691690 | 691690 | 2020-11-02 | Powder River | Montana | 30075 | 65 | 5 |
691691 | 691691 | 2020-11-02 | Powell | Montana | 30077 | 193 | 0 |
691692 | 691692 | 2020-11-02 | Prairie | Montana | 30079 | 33 | 0 |
691693 | 691693 | 2020-11-02 | Ravalli | Montana | 30081 | 556 | 4 |
691694 | 691694 | 2020-11-02 | Richland | Montana | 30083 | 361 | 5 |
691695 | 691695 | 2020-11-02 | Roosevelt | Montana | 30085 | 1024 | 30 |
691696 | 691696 | 2020-11-02 | Rosebud | Montana | 30087 | 864 | 21 |
691697 | 691697 | 2020-11-02 | Sanders | Montana | 30089 | 108 | 2 |
691698 | 691698 | 2020-11-02 | Sheridan | Montana | 30091 | 91 | 0 |
691699 | 691699 | 2020-11-02 | Silver Bow | Montana | 30093 | 679 | 2 |
691700 | 691700 | 2020-11-02 | Stillwater | Montana | 30095 | 231 | 3 |
691701 | 691701 | 2020-11-02 | Sweet Grass | Montana | 30097 | 104 | 2 |
691702 | 691702 | 2020-11-02 | Teton | Montana | 30099 | 92 | 1 |
691703 | 691703 | 2020-11-02 | Toole | Montana | 30101 | 336 | 8 |
691704 | 691704 | 2020-11-02 | Treasure | Montana | 30103 | 24 | 1 |
691705 | 691705 | 2020-11-02 | Valley | Montana | 30105 | 401 | 5 |
691706 | 691706 | 2020-11-02 | Wheatland | Montana | 30107 | 74 | 3 |
691707 | 691707 | 2020-11-02 | Wibaux | Montana | 30109 | 45 | 0 |
691708 | 691708 | 2020-11-02 | Yellowstone | Montana | 30111 | 7182 | 96 |
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);