home / covid

Menu
  • GraphQL API

johns_hopkins_csse_daily_reports

Table actions
  • GraphQL API for johns_hopkins_csse_daily_reports
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

54,982 rows where province_or_state = "Montana" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: day (date), last_update (date)

province_or_state 1

  • Montana · 54,982 ✖

country_or_region 1

  • US 54,982
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2754892 2754892 2022-12-29 US Montana Beaverhead 30001 2438 32 0   45.13434354 -112.8984694 2022-12-30 04:21:04 Beaverhead, Montana, US
2754893 2754893 2022-12-29 US Montana Big Horn 30003 5673 103 0   45.42335905 -107.492347 2022-12-30 04:21:04 Big Horn, Montana, US
2754894 2754894 2022-12-29 US Montana Blaine 30005 2558 33 0   48.43175214 -108.9582723 2022-12-30 04:21:04 Blaine, Montana, US
2754895 2754895 2022-12-29 US Montana Broadwater 30007 1507 22 0   46.33277565 -111.4955813 2022-12-30 04:21:04 Broadwater, Montana, US
2754896 2754896 2022-12-29 US Montana Carbon 30009 2420 29 0   45.22850116 -109.0274047 2022-12-30 04:21:04 Carbon, Montana, US
2754897 2754897 2022-12-29 US Montana Carter 30011 288 5 0   45.5197966 -104.5395536 2022-12-30 04:21:04 Carter, Montana, US
2754898 2754898 2022-12-29 US Montana Cascade 30013 29407 372 0   47.30797024 -111.3467922 2022-12-30 04:21:04 Cascade, Montana, US
2754899 2754899 2022-12-29 US Montana Chouteau 30015 1314 15 0   47.88084126 -110.4353362 2022-12-30 04:21:04 Chouteau, Montana, US
2754900 2754900 2022-12-29 US Montana Custer 30017 3486 52 0   46.25319932 -105.5737526 2022-12-30 04:21:04 Custer, Montana, US
2754901 2754901 2022-12-29 US Montana Daniels 30019 467 9 0   48.78420029 -105.5476343 2022-12-30 04:21:04 Daniels, Montana, US
2754902 2754902 2022-12-29 US Montana Dawson 30021 2738 59 0   47.26584855 -104.8944417 2022-12-30 04:21:04 Dawson, Montana, US
2754903 2754903 2022-12-29 US Montana Deer Lodge 30023 3171 30 0   46.05953325 -113.073353 2022-12-30 04:21:04 Deer Lodge, Montana, US
2754904 2754904 2022-12-29 US Montana Fallon 30025 780 12 0   46.33478338 -104.4183565 2022-12-30 04:21:04 Fallon, Montana, US
2754905 2754905 2022-12-29 US Montana Fergus 30027 2886 60 0   47.26331584 -109.2245206 2022-12-30 04:21:04 Fergus, Montana, US
2754906 2754906 2022-12-29 US Montana Flathead 30029 33311 300 0   48.29575866 -114.0520569 2022-12-30 04:21:04 Flathead, Montana, US
2754907 2754907 2022-12-29 US Montana Gallatin 30031 40580 133 0   45.54486106 -111.1692571 2022-12-30 04:21:04 Gallatin, Montana, US
2754908 2754908 2022-12-29 US Montana Garfield 30033 250 3 0   47.27545948 -107.0002351 2022-12-30 04:21:04 Garfield, Montana, US
2754909 2754909 2022-12-29 US Montana Glacier 30035 4641 77 0   48.70513576 -112.9934235 2022-12-30 04:21:04 Glacier, Montana, US
2754910 2754910 2022-12-29 US Montana Golden Valley 30037 168 5 0   46.3816474 -109.1768522 2022-12-30 04:21:04 Golden Valley, Montana, US
2754911 2754911 2022-12-29 US Montana Granite 30039 657 10 0   46.4060522 -113.4414186 2022-12-30 04:21:04 Granite, Montana, US
2754912 2754912 2022-12-29 US Montana Hill 30041 5337 73 0   48.62879827 -110.1129252 2022-12-30 04:21:04 Hill, Montana, US
2754913 2754913 2022-12-29 US Montana Jefferson 30043 3089 26 0   46.14907081 -112.094396 2022-12-30 04:21:04 Jefferson, Montana, US
2754914 2754914 2022-12-29 US Montana Judith Basin 30045 277 1 0   47.04581276 -110.2660688 2022-12-30 04:21:04 Judith Basin, Montana, US
2754915 2754915 2022-12-29 US Montana Lake 30047 8153 106 0   47.64514965 -114.0898013 2022-12-30 04:21:04 Lake, Montana, US
2754916 2754916 2022-12-29 US Montana Lewis and Clark 30049 21481 201 0   47.12610041 -112.394698 2022-12-30 04:21:04 Lewis and Clark, Montana, US
2754917 2754917 2022-12-29 US Montana Liberty 30051 523 4 0   48.56084317 -111.024307 2022-12-30 04:21:04 Liberty, Montana, US
2754918 2754918 2022-12-29 US Montana Lincoln 30053 5545 95 0   48.54265777 -115.4046155 2022-12-30 04:21:04 Lincoln, Montana, US
2754919 2754919 2022-12-29 US Montana Madison 30057 2359 22 0   45.30080065 -111.9173017 2022-12-30 04:21:04 Madison, Montana, US
2754920 2754920 2022-12-29 US Montana McCone 30055 444 9 0   47.64469406 -105.7944994 2022-12-30 04:21:04 McCone, Montana, US
2754921 2754921 2022-12-29 US Montana Meagher 30059 582 12 0   46.59907074 -110.8898557 2022-12-30 04:21:04 Meagher, Montana, US
2754922 2754922 2022-12-29 US Montana Mineral 30061 1340 17 0   47.15283992 -115.0015239 2022-12-30 04:21:04 Mineral, Montana, US
2754923 2754923 2022-12-29 US Montana Missoula 30063 33115 223 0   47.03728583 -113.9213508 2022-12-30 04:21:04 Missoula, Montana, US
2754924 2754924 2022-12-29 US Montana Musselshell 30065 1082 31 0   46.49684637 -108.39498 2022-12-30 04:21:04 Musselshell, Montana, US
2754925 2754925 2022-12-29 US Montana Park 30067 5057 39 0   45.48965095 -110.5264394 2022-12-30 04:21:04 Park, Montana, US
2754926 2754926 2022-12-29 US Montana Petroleum 30069 42 1 0   47.1182463 -108.2508876 2022-12-30 04:21:04 Petroleum, Montana, US
2754927 2754927 2022-12-29 US Montana Phillips 30071 1133 29 0   48.25936577 -107.9128511 2022-12-30 04:21:04 Phillips, Montana, US
2754928 2754928 2022-12-29 US Montana Pondera 30073 1450 11 0   48.22773388 -112.2252703 2022-12-30 04:21:04 Pondera, Montana, US
2754929 2754929 2022-12-29 US Montana Powder River 30075 414 10 0   45.39617714 -105.636738 2022-12-30 04:21:04 Powder River, Montana, US
2754930 2754930 2022-12-29 US Montana Powell 30077 2173 32 0   46.85538891 -112.9359164 2022-12-30 04:21:04 Powell, Montana, US
2754931 2754931 2022-12-29 US Montana Prairie 30079 290 4 0   46.86048047 -105.379384 2022-12-30 04:21:04 Prairie, Montana, US
2754932 2754932 2022-12-29 US Montana Ravalli 30081 8241 174 0   46.08520862 -114.1189164 2022-12-30 04:21:04 Ravalli, Montana, US
2754933 2754933 2022-12-29 US Montana Richland 30083 2942 37 0   47.78668011 -104.5610786 2022-12-30 04:21:04 Richland, Montana, US
2754934 2754934 2022-12-29 US Montana Roosevelt 30085 3866 76 0   48.29607488 -105.0079268 2022-12-30 04:21:04 Roosevelt, Montana, US
2754935 2754935 2022-12-29 US Montana Rosebud 30087 3089 63 0   46.23397237 -106.729288 2022-12-30 04:21:04 Rosebud, Montana, US
2754936 2754936 2022-12-29 US Montana Sanders 30089 2390 53 0   47.67657534 -115.1329916 2022-12-30 04:21:04 Sanders, Montana, US
2754937 2754937 2022-12-29 US Montana Sheridan 30091 887 13 0   48.72085833 -104.503829 2022-12-30 04:21:04 Sheridan, Montana, US
2754938 2754938 2022-12-29 US Montana Silver Bow 30093 9730 139 0   45.90018933 -112.6620092 2022-12-30 04:21:04 Silver Bow, Montana, US
2754939 2754939 2022-12-29 US Montana Stillwater 30095 1707 32 0   45.67071407 -109.3950061 2022-12-30 04:21:04 Stillwater, Montana, US
2754940 2754940 2022-12-29 US Montana Sweet Grass 30097 900 13 0   45.81367654 -109.9425686 2022-12-30 04:21:04 Sweet Grass, Montana, US
2754941 2754941 2022-12-29 US Montana Teton 30099 1516 27 0   47.83741052 -112.2410688 2022-12-30 04:21:04 Teton, Montana, US
2754942 2754942 2022-12-29 US Montana Toole 30101 1394 25 0   48.65577551 -111.6942414 2022-12-30 04:21:04 Toole, Montana, US
2754943 2754943 2022-12-29 US Montana Treasure 30103 147 1 0   46.2097322 -107.2666516 2022-12-30 04:21:04 Treasure, Montana, US
2754944 2754944 2022-12-29 US Montana Unassigned 90030 0 0 0   48.78420029 0.0 2022-12-30 04:21:04 Unassigned, Montana, US
2754945 2754945 2022-12-29 US Montana Valley 30105 2084 41 0   48.36435097 -106.6669635 2022-12-30 04:21:04 Valley, Montana, US
2754946 2754946 2022-12-29 US Montana Wheatland 30107 453 14 0   46.46652491 -109.8464636 2022-12-30 04:21:04 Wheatland, Montana, US
2754947 2754947 2022-12-29 US Montana Wibaux 30109 244 8 0   46.95925154 -104.2510927 2022-12-30 04:21:04 Wibaux, Montana, US
2754948 2754948 2022-12-29 US Montana Yellowstone 30111 50054 594 0   45.93955949 -108.2691486 2022-12-30 04:21:04 Yellowstone, Montana, US
1075898 1075898 2022-12-28 US Montana Beaverhead 30001 2438 32 0   45.13434354 -112.8984694 2022-12-29 04:21:01 Beaverhead, Montana, US
1075899 1075899 2022-12-28 US Montana Big Horn 30003 5673 103 0   45.42335905 -107.492347 2022-12-29 04:21:01 Big Horn, Montana, US
1075900 1075900 2022-12-28 US Montana Blaine 30005 2558 33 0   48.43175214 -108.9582723 2022-12-29 04:21:01 Blaine, Montana, US
1075901 1075901 2022-12-28 US Montana Broadwater 30007 1507 22 0   46.33277565 -111.4955813 2022-12-29 04:21:01 Broadwater, Montana, US
1075902 1075902 2022-12-28 US Montana Carbon 30009 2420 29 0   45.22850116 -109.0274047 2022-12-29 04:21:01 Carbon, Montana, US
1075903 1075903 2022-12-28 US Montana Carter 30011 288 5 0   45.5197966 -104.5395536 2022-12-29 04:21:01 Carter, Montana, US
1075904 1075904 2022-12-28 US Montana Cascade 30013 29407 372 0   47.30797024 -111.3467922 2022-12-29 04:21:01 Cascade, Montana, US
1075905 1075905 2022-12-28 US Montana Chouteau 30015 1314 15 0   47.88084126 -110.4353362 2022-12-29 04:21:01 Chouteau, Montana, US
1075906 1075906 2022-12-28 US Montana Custer 30017 3486 52 0   46.25319932 -105.5737526 2022-12-29 04:21:01 Custer, Montana, US
1075907 1075907 2022-12-28 US Montana Daniels 30019 467 9 0   48.78420029 -105.5476343 2022-12-29 04:21:01 Daniels, Montana, US
1075908 1075908 2022-12-28 US Montana Dawson 30021 2738 59 0   47.26584855 -104.8944417 2022-12-29 04:21:01 Dawson, Montana, US
1075909 1075909 2022-12-28 US Montana Deer Lodge 30023 3171 30 0   46.05953325 -113.073353 2022-12-29 04:21:01 Deer Lodge, Montana, US
1075910 1075910 2022-12-28 US Montana Fallon 30025 780 12 0   46.33478338 -104.4183565 2022-12-29 04:21:01 Fallon, Montana, US
1075911 1075911 2022-12-28 US Montana Fergus 30027 2886 60 0   47.26331584 -109.2245206 2022-12-29 04:21:01 Fergus, Montana, US
1075912 1075912 2022-12-28 US Montana Flathead 30029 33311 300 0   48.29575866 -114.0520569 2022-12-29 04:21:01 Flathead, Montana, US
1075913 1075913 2022-12-28 US Montana Gallatin 30031 40580 133 0   45.54486106 -111.1692571 2022-12-29 04:21:01 Gallatin, Montana, US
1075914 1075914 2022-12-28 US Montana Garfield 30033 250 3 0   47.27545948 -107.0002351 2022-12-29 04:21:01 Garfield, Montana, US
1075915 1075915 2022-12-28 US Montana Glacier 30035 4641 77 0   48.70513576 -112.9934235 2022-12-29 04:21:01 Glacier, Montana, US
1075916 1075916 2022-12-28 US Montana Golden Valley 30037 168 5 0   46.3816474 -109.1768522 2022-12-29 04:21:01 Golden Valley, Montana, US
1075917 1075917 2022-12-28 US Montana Granite 30039 657 10 0   46.4060522 -113.4414186 2022-12-29 04:21:01 Granite, Montana, US
1075918 1075918 2022-12-28 US Montana Hill 30041 5337 73 0   48.62879827 -110.1129252 2022-12-29 04:21:01 Hill, Montana, US
1075919 1075919 2022-12-28 US Montana Jefferson 30043 3089 26 0   46.14907081 -112.094396 2022-12-29 04:21:01 Jefferson, Montana, US
1075920 1075920 2022-12-28 US Montana Judith Basin 30045 277 1 0   47.04581276 -110.2660688 2022-12-29 04:21:01 Judith Basin, Montana, US
1075921 1075921 2022-12-28 US Montana Lake 30047 8153 106 0   47.64514965 -114.0898013 2022-12-29 04:21:01 Lake, Montana, US
1075922 1075922 2022-12-28 US Montana Lewis and Clark 30049 21481 201 0   47.12610041 -112.394698 2022-12-29 04:21:01 Lewis and Clark, Montana, US
1075923 1075923 2022-12-28 US Montana Liberty 30051 523 4 0   48.56084317 -111.024307 2022-12-29 04:21:01 Liberty, Montana, US
1075924 1075924 2022-12-28 US Montana Lincoln 30053 5545 95 0   48.54265777 -115.4046155 2022-12-29 04:21:01 Lincoln, Montana, US
1075925 1075925 2022-12-28 US Montana Madison 30057 2359 22 0   45.30080065 -111.9173017 2022-12-29 04:21:01 Madison, Montana, US
1075926 1075926 2022-12-28 US Montana McCone 30055 444 9 0   47.64469406 -105.7944994 2022-12-29 04:21:01 McCone, Montana, US
1075927 1075927 2022-12-28 US Montana Meagher 30059 582 12 0   46.59907074 -110.8898557 2022-12-29 04:21:01 Meagher, Montana, US
1075928 1075928 2022-12-28 US Montana Mineral 30061 1340 17 0   47.15283992 -115.0015239 2022-12-29 04:21:01 Mineral, Montana, US
1075929 1075929 2022-12-28 US Montana Missoula 30063 33115 223 0   47.03728583 -113.9213508 2022-12-29 04:21:01 Missoula, Montana, US
1075930 1075930 2022-12-28 US Montana Musselshell 30065 1082 31 0   46.49684637 -108.39498 2022-12-29 04:21:01 Musselshell, Montana, US
1075931 1075931 2022-12-28 US Montana Park 30067 5057 39 0   45.48965095 -110.5264394 2022-12-29 04:21:01 Park, Montana, US
1075932 1075932 2022-12-28 US Montana Petroleum 30069 42 1 0   47.1182463 -108.2508876 2022-12-29 04:21:01 Petroleum, Montana, US
1075933 1075933 2022-12-28 US Montana Phillips 30071 1133 29 0   48.25936577 -107.9128511 2022-12-29 04:21:01 Phillips, Montana, US
1075934 1075934 2022-12-28 US Montana Pondera 30073 1450 11 0   48.22773388 -112.2252703 2022-12-29 04:21:01 Pondera, Montana, US
1075935 1075935 2022-12-28 US Montana Powder River 30075 414 10 0   45.39617714 -105.636738 2022-12-29 04:21:01 Powder River, Montana, US
1075936 1075936 2022-12-28 US Montana Powell 30077 2173 32 0   46.85538891 -112.9359164 2022-12-29 04:21:01 Powell, Montana, US
1075937 1075937 2022-12-28 US Montana Prairie 30079 290 4 0   46.86048047 -105.379384 2022-12-29 04:21:01 Prairie, Montana, US
1075938 1075938 2022-12-28 US Montana Ravalli 30081 8241 174 0   46.08520862 -114.1189164 2022-12-29 04:21:01 Ravalli, Montana, US
1075939 1075939 2022-12-28 US Montana Richland 30083 2942 37 0   47.78668011 -104.5610786 2022-12-29 04:21:01 Richland, Montana, US
1075940 1075940 2022-12-28 US Montana Roosevelt 30085 3866 76 0   48.29607488 -105.0079268 2022-12-29 04:21:01 Roosevelt, Montana, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);
Powered by Datasette · Queries took 955.181ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette