daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

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

57 rows where day = "2020-12-28" and province_or_state = "Montana" sorted by day descending

✎ View and edit SQL

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

province_or_state 1

  • Montana · 57 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2020-12-28 US Montana Beaverhead 30001 760 8 0 752 45.13434354 -112.8984694 2020-12-29 05:22:37 Beaverhead, Montana, US
2020-12-28 US Montana Big Horn 30003 2027 57 0 1970 45.42335905 -107.492347 2020-12-29 05:22:37 Big Horn, Montana, US
2020-12-28 US Montana Blaine 30005 601 22 0 579 48.43175214 -108.9582723 2020-12-29 05:22:37 Blaine, Montana, US
2020-12-28 US Montana Broadwater 30007 287 2 0 285 46.33277565 -111.4955813 2020-12-29 05:22:37 Broadwater, Montana, US
2020-12-28 US Montana Carbon 30009 672 8 0 664 45.22850116 -109.0274047 2020-12-29 05:22:37 Carbon, Montana, US
2020-12-28 US Montana Carter 30011 137 4 0 133 45.5197966 -104.5395536 2020-12-29 05:22:37 Carter, Montana, US
2020-12-28 US Montana Cascade 30013 6569 95 0 6474 47.30797024 -111.3467922 2020-12-29 05:22:37 Cascade, Montana, US
2020-12-28 US Montana Chouteau 30015 360 4 0 356 47.88084126 -110.4353362 2020-12-29 05:22:37 Chouteau, Montana, US
2020-12-28 US Montana Custer 30017 946 8 0 938 46.25319932 -105.57375259999998 2020-12-29 05:22:37 Custer, Montana, US
2020-12-28 US Montana Daniels 30019 137 5 0 132 48.78420029 -105.54763429999998 2020-12-29 05:22:37 Daniels, Montana, US
2020-12-28 US Montana Dawson 30021 931 22 0 909 47.26584855 -104.89444170000002 2020-12-29 05:22:37 Dawson, Montana, US
2020-12-28 US Montana Deer Lodge 30023 838 10 0 828 46.05953325 -113.073353 2020-12-29 05:22:37 Deer Lodge, Montana, US
2020-12-28 US Montana Fallon 30025 265 1 0 264 46.33478338 -104.4183565 2020-12-29 05:22:37 Fallon, Montana, US
2020-12-28 US Montana Fergus 30027 850 13 0 837 47.26331584 -109.2245206 2020-12-29 05:22:37 Fergus, Montana, US
2020-12-28 US Montana Flathead 30029 8685 56 0 8629 48.29575866 -114.0520569 2020-12-29 05:22:37 Flathead, Montana, US
2020-12-28 US Montana Gallatin 30031 9049 37 0 9012 45.54486106 -111.1692571 2020-12-29 05:22:37 Gallatin, Montana, US
2020-12-28 US Montana Garfield 30033 69 2 0 67 47.27545948 -107.0002351 2020-12-29 05:22:37 Garfield, Montana, US
2020-12-28 US Montana Glacier 30035 1308 22 0 1286 48.70513576 -112.9934235 2020-12-29 05:22:37 Glacier, Montana, US
2020-12-28 US Montana Golden Valley 30037 42 0 0 42 46.3816474 -109.1768522 2020-12-29 05:22:37 Golden Valley, Montana, US
2020-12-28 US Montana Granite 30039 162 2 0 160 46.40605220000001 -113.4414186 2020-12-29 05:22:37 Granite, Montana, US
2020-12-28 US Montana Hill 30041 1612 34 0 1578 48.62879827 -110.1129252 2020-12-29 05:22:37 Hill, Montana, US
2020-12-28 US Montana Jefferson 30043 757 3 0 754 46.14907081 -112.094396 2020-12-29 05:22:37 Jefferson, Montana, US
2020-12-28 US Montana Judith Basin 30045 77 0 0 77 47.04581276 -110.2660688 2020-12-29 05:22:37 Judith Basin, Montana, US
2020-12-28 US Montana Lake 30047 1431 16 0 1415 47.64514965 -114.0898013 2020-12-29 05:22:37 Lake, Montana, US
2020-12-28 US Montana Lewis and Clark 30049 4686 37 0 4649 47.12610041 -112.394698 2020-12-29 05:22:37 Lewis and Clark, Montana, US
2020-12-28 US Montana Liberty 30051 100 1 0 99 48.56084317 -111.024307 2020-12-29 05:22:37 Liberty, Montana, US
2020-12-28 US Montana Lincoln 30053 1052 9 0 1043 48.54265777 -115.4046155 2020-12-29 05:22:37 Lincoln, Montana, US
2020-12-28 US Montana Madison 30057 497 3 0 494 45.30080065 -111.9173017 2020-12-29 05:22:37 Madison, Montana, US
2020-12-28 US Montana McCone 30055 141 0 0 141 47.64469406 -105.7944994 2020-12-29 05:22:37 McCone, Montana, US
2020-12-28 US Montana Meagher 30059 111 7 0 104 46.59907074 -110.8898557 2020-12-29 05:22:37 Meagher, Montana, US
2020-12-28 US Montana Mineral 30061 169 0 0 169 47.15283992 -115.0015239 2020-12-29 05:22:37 Mineral, Montana, US
2020-12-28 US Montana Missoula 30063 6270 51 0 6219 47.03728583 -113.92135079999998 2020-12-29 05:22:37 Missoula, Montana, US
2020-12-28 US Montana Musselshell 30065 264 7 0 257 46.49684637 -108.39498 2020-12-29 05:22:37 Musselshell, Montana, US
2020-12-28 US Montana Park 30067 852 5 0 847 45.48965095 -110.52643940000002 2020-12-29 05:22:37 Park, Montana, US
2020-12-28 US Montana Petroleum 30069 10 1 0 9 47.1182463 -108.2508876 2020-12-29 05:22:37 Petroleum, Montana, US
2020-12-28 US Montana Phillips 30071 421 12 0 409 48.25936577 -107.9128511 2020-12-29 05:22:37 Phillips, Montana, US
2020-12-28 US Montana Pondera 30073 384 3 0 381 48.22773388 -112.2252703 2020-12-29 05:22:37 Pondera, Montana, US
2020-12-28 US Montana Powder River 30075 101 5 0 96 45.39617714 -105.636738 2020-12-29 05:22:37 Powder River, Montana, US
2020-12-28 US Montana Powell 30077 786 5 0 781 46.85538891 -112.9359164 2020-12-29 05:22:37 Powell, Montana, US
2020-12-28 US Montana Prairie 30079 124 2 0 122 46.86048047 -105.379384 2020-12-29 05:22:37 Prairie, Montana, US
2020-12-28 US Montana Ravalli 30081 2081 25 0 2056 46.08520862 -114.11891640000002 2020-12-29 05:22:37 Ravalli, Montana, US
2020-12-28 US Montana Richland 30083 864 9 0 855 47.78668011 -104.5610786 2020-12-29 05:22:37 Richland, Montana, US
2020-12-28 US Montana Roosevelt 30085 1381 42 0 1339 48.29607488 -105.0079268 2020-12-29 05:22:37 Roosevelt, Montana, US
2020-12-28 US Montana Rosebud 30087 1027 28 0 999 46.23397237 -106.72928799999998 2020-12-29 05:22:37 Rosebud, Montana, US
2020-12-28 US Montana Sanders 30089 421 3 0 418 47.67657534 -115.1329916 2020-12-29 05:22:37 Sanders, Montana, US
2020-12-28 US Montana Sheridan 30091 348 5 0 343 48.72085833 -104.503829 2020-12-29 05:22:37 Sheridan, Montana, US
2020-12-28 US Montana Silver Bow 30093 2960 34 0 2926 45.90018933 -112.6620092 2020-12-29 05:22:37 Silver Bow, Montana, US
2020-12-28 US Montana Stillwater 30095 534 8 0 526 45.67071407 -109.3950061 2020-12-29 05:22:37 Stillwater, Montana, US
2020-12-28 US Montana Sweet Grass 30097 311 6 0 305 45.81367654 -109.9425686 2020-12-29 05:22:37 Sweet Grass, Montana, US
2020-12-28 US Montana Teton 30099 300 3 0 297 47.83741052 -112.2410688 2020-12-29 05:22:37 Teton, Montana, US
2020-12-28 US Montana Toole 30101 671 8 0 663 48.65577551 -111.6942414 2020-12-29 05:22:37 Toole, Montana, US
2020-12-28 US Montana Treasure 30103 43 1 0 42 46.20973220000001 -107.2666516 2020-12-29 05:22:37 Treasure, Montana, US
2020-12-28 US Montana Unassigned 90030 0 0 0 0 48.78420029 0.0 2020-12-21 13:27:30 Unassigned, Montana, US
2020-12-28 US Montana Valley 30105 637 7 0 630 48.36435097 -106.6669635 2020-12-29 05:22:37 Valley, Montana, US
2020-12-28 US Montana Wheatland 30107 139 6 0 133 46.46652491 -109.8464636 2020-12-29 05:22:37 Wheatland, Montana, US
2020-12-28 US Montana Wibaux 30109 113 4 0 109 46.95925154 -104.2510927 2020-12-29 05:22:37 Wibaux, Montana, US
2020-12-28 US Montana Yellowstone 30111 13629 159 0 13470 45.93955949 -108.2691486 2020-12-29 05:22:37 Yellowstone, Montana, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;