ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where "date" is on date 2020-09-27 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
- 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 · 55 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
574897 | 574897 | 2020-09-27 | Beaverhead | Montana | 30001 | 85 | 1 |
574898 | 574898 | 2020-09-27 | Big Horn | Montana | 30003 | 900 | 22 |
574899 | 574899 | 2020-09-27 | Blaine | Montana | 30005 | 21 | 0 |
574900 | 574900 | 2020-09-27 | Broadwater | Montana | 30007 | 17 | 0 |
574901 | 574901 | 2020-09-27 | Carbon | Montana | 30009 | 116 | 0 |
574902 | 574902 | 2020-09-27 | Carter | Montana | 30011 | 4 | 0 |
574903 | 574903 | 2020-09-27 | Cascade | Montana | 30013 | 677 | 5 |
574904 | 574904 | 2020-09-27 | Chouteau | Montana | 30015 | 29 | 0 |
574905 | 574905 | 2020-09-27 | Custer | Montana | 30017 | 116 | 2 |
574906 | 574906 | 2020-09-27 | Daniels | Montana | 30019 | 5 | 0 |
574907 | 574907 | 2020-09-27 | Dawson | Montana | 30021 | 78 | 1 |
574908 | 574908 | 2020-09-27 | Deer Lodge | Montana | 30023 | 116 | 0 |
574909 | 574909 | 2020-09-27 | Fallon | Montana | 30025 | 5 | 0 |
574910 | 574910 | 2020-09-27 | Fergus | Montana | 30027 | 63 | 1 |
574911 | 574911 | 2020-09-27 | Flathead | Montana | 30029 | 1034 | 17 |
574912 | 574912 | 2020-09-27 | Gallatin | Montana | 30031 | 1361 | 4 |
574913 | 574913 | 2020-09-27 | Garfield | Montana | 30033 | 17 | 0 |
574914 | 574914 | 2020-09-27 | Glacier | Montana | 30035 | 279 | 1 |
574915 | 574915 | 2020-09-27 | Golden Valley | Montana | 30037 | 5 | 0 |
574916 | 574916 | 2020-09-27 | Granite | Montana | 30039 | 22 | 0 |
574917 | 574917 | 2020-09-27 | Hill | Montana | 30041 | 152 | 3 |
574918 | 574918 | 2020-09-27 | Jefferson | Montana | 30043 | 77 | 0 |
574919 | 574919 | 2020-09-27 | Judith Basin | Montana | 30045 | 7 | 0 |
574920 | 574920 | 2020-09-27 | Lake | Montana | 30047 | 276 | 1 |
574921 | 574921 | 2020-09-27 | Lewis and Clark | Montana | 30049 | 275 | 3 |
574922 | 574922 | 2020-09-27 | Liberty | Montana | 30051 | 19 | 0 |
574923 | 574923 | 2020-09-27 | Lincoln | Montana | 30053 | 117 | 3 |
574924 | 574924 | 2020-09-27 | Madison | Montana | 30057 | 102 | 1 |
574925 | 574925 | 2020-09-27 | McCone | Montana | 30055 | 19 | 0 |
574926 | 574926 | 2020-09-27 | Meagher | Montana | 30059 | 25 | 2 |
574927 | 574927 | 2020-09-27 | Mineral | Montana | 30061 | 2 | 0 |
574928 | 574928 | 2020-09-27 | Missoula | Montana | 30063 | 750 | 3 |
574929 | 574929 | 2020-09-27 | Musselshell | Montana | 30065 | 35 | 1 |
574930 | 574930 | 2020-09-27 | Park | Montana | 30067 | 98 | 0 |
574931 | 574931 | 2020-09-27 | Phillips | Montana | 30071 | 121 | 0 |
574932 | 574932 | 2020-09-27 | Pondera | Montana | 30073 | 29 | 0 |
574933 | 574933 | 2020-09-27 | Powder River | Montana | 30075 | 9 | 0 |
574934 | 574934 | 2020-09-27 | Powell | Montana | 30077 | 12 | 0 |
574935 | 574935 | 2020-09-27 | Prairie | Montana | 30079 | 2 | 0 |
574936 | 574936 | 2020-09-27 | Ravalli | Montana | 30081 | 140 | 2 |
574937 | 574937 | 2020-09-27 | Richland | Montana | 30083 | 79 | 2 |
574938 | 574938 | 2020-09-27 | Roosevelt | Montana | 30085 | 354 | 4 |
574939 | 574939 | 2020-09-27 | Rosebud | Montana | 30087 | 635 | 19 |
574940 | 574940 | 2020-09-27 | Sanders | Montana | 30089 | 46 | 1 |
574941 | 574941 | 2020-09-27 | Sheridan | Montana | 30091 | 13 | 0 |
574942 | 574942 | 2020-09-27 | Silver Bow | Montana | 30093 | 255 | 0 |
574943 | 574943 | 2020-09-27 | Stillwater | Montana | 30095 | 69 | 2 |
574944 | 574944 | 2020-09-27 | Sweet Grass | Montana | 30097 | 43 | 1 |
574945 | 574945 | 2020-09-27 | Teton | Montana | 30099 | 21 | 0 |
574946 | 574946 | 2020-09-27 | Toole | Montana | 30101 | 76 | 6 |
574947 | 574947 | 2020-09-27 | Treasure | Montana | 30103 | 3 | 0 |
574948 | 574948 | 2020-09-27 | Valley | Montana | 30105 | 83 | 0 |
574949 | 574949 | 2020-09-27 | Wheatland | Montana | 30107 | 17 | 1 |
574950 | 574950 | 2020-09-27 | Wibaux | Montana | 30109 | 9 | 0 |
574951 | 574951 | 2020-09-27 | Yellowstone | Montana | 30111 | 3206 | 64 |
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);