ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
54 rows where "date" is on date 2020-09-06 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Beaverhead 1
- Big Horn 1
- Blaine 1
- Broadwater 1
- Carbon 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
- Mineral 1
- …
state 1
- Montana · 54 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
506919 | 506919 | 2020-09-06 | Beaverhead | Montana | 30001 | 72 | 1 |
506920 | 506920 | 2020-09-06 | Big Horn | Montana | 30003 | 727 | 16 |
506921 | 506921 | 2020-09-06 | Blaine | Montana | 30005 | 15 | 0 |
506922 | 506922 | 2020-09-06 | Broadwater | Montana | 30007 | 16 | 0 |
506923 | 506923 | 2020-09-06 | Carbon | Montana | 30009 | 93 | 0 |
506924 | 506924 | 2020-09-06 | Cascade | Montana | 30013 | 373 | 5 |
506925 | 506925 | 2020-09-06 | Chouteau | Montana | 30015 | 11 | 0 |
506926 | 506926 | 2020-09-06 | Custer | Montana | 30017 | 69 | 2 |
506927 | 506927 | 2020-09-06 | Daniels | Montana | 30019 | 3 | 0 |
506928 | 506928 | 2020-09-06 | Dawson | Montana | 30021 | 52 | 1 |
506929 | 506929 | 2020-09-06 | Deer Lodge | Montana | 30023 | 80 | 0 |
506930 | 506930 | 2020-09-06 | Fallon | Montana | 30025 | 4 | 0 |
506931 | 506931 | 2020-09-06 | Fergus | Montana | 30027 | 38 | 0 |
506932 | 506932 | 2020-09-06 | Flathead | Montana | 30029 | 684 | 9 |
506933 | 506933 | 2020-09-06 | Gallatin | Montana | 30031 | 1119 | 3 |
506934 | 506934 | 2020-09-06 | Garfield | Montana | 30033 | 16 | 0 |
506935 | 506935 | 2020-09-06 | Glacier | Montana | 30035 | 143 | 1 |
506936 | 506936 | 2020-09-06 | Golden Valley | Montana | 30037 | 3 | 0 |
506937 | 506937 | 2020-09-06 | Granite | Montana | 30039 | 21 | 0 |
506938 | 506938 | 2020-09-06 | Hill | Montana | 30041 | 98 | 2 |
506939 | 506939 | 2020-09-06 | Jefferson | Montana | 30043 | 41 | 0 |
506940 | 506940 | 2020-09-06 | Judith Basin | Montana | 30045 | 6 | 0 |
506941 | 506941 | 2020-09-06 | Lake | Montana | 30047 | 222 | 1 |
506942 | 506942 | 2020-09-06 | Lewis and Clark | Montana | 30049 | 207 | 3 |
506943 | 506943 | 2020-09-06 | Liberty | Montana | 30051 | 8 | 0 |
506944 | 506944 | 2020-09-06 | Lincoln | Montana | 30053 | 93 | 2 |
506945 | 506945 | 2020-09-06 | Madison | Montana | 30057 | 95 | 1 |
506946 | 506946 | 2020-09-06 | McCone | Montana | 30055 | 14 | 0 |
506947 | 506947 | 2020-09-06 | Meagher | Montana | 30059 | 4 | 0 |
506948 | 506948 | 2020-09-06 | Mineral | Montana | 30061 | 2 | 0 |
506949 | 506949 | 2020-09-06 | Missoula | Montana | 30063 | 445 | 3 |
506950 | 506950 | 2020-09-06 | Musselshell | Montana | 30065 | 19 | 0 |
506951 | 506951 | 2020-09-06 | Park | Montana | 30067 | 67 | 0 |
506952 | 506952 | 2020-09-06 | Phillips | Montana | 30071 | 114 | 0 |
506953 | 506953 | 2020-09-06 | Pondera | Montana | 30073 | 16 | 0 |
506954 | 506954 | 2020-09-06 | Powder River | Montana | 30075 | 2 | 0 |
506955 | 506955 | 2020-09-06 | Powell | Montana | 30077 | 10 | 0 |
506956 | 506956 | 2020-09-06 | Prairie | Montana | 30079 | 1 | 0 |
506957 | 506957 | 2020-09-06 | Ravalli | Montana | 30081 | 113 | 2 |
506958 | 506958 | 2020-09-06 | Richland | Montana | 30083 | 64 | 2 |
506959 | 506959 | 2020-09-06 | Roosevelt | Montana | 30085 | 62 | 1 |
506960 | 506960 | 2020-09-06 | Rosebud | Montana | 30087 | 355 | 5 |
506961 | 506961 | 2020-09-06 | Sanders | Montana | 30089 | 41 | 0 |
506962 | 506962 | 2020-09-06 | Sheridan | Montana | 30091 | 5 | 0 |
506963 | 506963 | 2020-09-06 | Silver Bow | Montana | 30093 | 131 | 0 |
506964 | 506964 | 2020-09-06 | Stillwater | Montana | 30095 | 40 | 2 |
506965 | 506965 | 2020-09-06 | Sweet Grass | Montana | 30097 | 34 | 1 |
506966 | 506966 | 2020-09-06 | Teton | Montana | 30099 | 18 | 0 |
506967 | 506967 | 2020-09-06 | Toole | Montana | 30101 | 57 | 6 |
506968 | 506968 | 2020-09-06 | Treasure | Montana | 30103 | 3 | 0 |
506969 | 506969 | 2020-09-06 | Valley | Montana | 30105 | 51 | 0 |
506970 | 506970 | 2020-09-06 | Wheatland | Montana | 30107 | 3 | 0 |
506971 | 506971 | 2020-09-06 | Wibaux | Montana | 30109 | 8 | 0 |
506972 | 506972 | 2020-09-06 | Yellowstone | Montana | 30111 | 2284 | 48 |
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);