johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,015 rows where "day" is on date 2021-09-27 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, day
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1235327 | 1235327 | 2021-09-27 | Australia | Northern Territory | 209 | 0 | 0 | -12.4634 | 130.8456 | 2021-09-28 04:21:28 | Northern Territory, Australia | |||
1235340 | 1235340 | 2021-09-27 | Belgium | Antwerp | 162695 | 0 | 0 | 51.2195 | 4.4024 | 2021-09-28 04:21:28 | Antwerp, Belgium | |||
1235341 | 1235341 | 2021-09-27 | Belgium | Brussels | 166396 | 0 | 0 | 50.8503 | 4.3517 | 2021-09-28 04:21:28 | Brussels, Belgium | |||
1235342 | 1235342 | 2021-09-27 | Belgium | East Flanders | 140075 | 0 | 0 | 51.0362 | 3.7373 | 2021-09-28 04:21:28 | East Flanders, Belgium | |||
1235343 | 1235343 | 2021-09-27 | Belgium | Flemish Brabant | 98762 | 0 | 0 | 50.9167 | 4.5833 | 2021-09-28 04:21:28 | Flemish Brabant, Belgium | |||
1235344 | 1235344 | 2021-09-27 | Belgium | Hainaut | 173160 | 0 | 0 | 50.5257 | 4.0621 | 2021-09-28 04:21:28 | Hainaut, Belgium | |||
1235345 | 1235345 | 2021-09-27 | Belgium | Liege | 148772 | 0 | 0 | 50.4496 | 5.8492 | 2021-09-28 04:21:28 | Liege, Belgium | |||
1235346 | 1235346 | 2021-09-27 | Belgium | Limburg | 69228 | 0 | 0 | 50.9739 | 5.3420000000000005 | 2021-09-28 04:21:28 | Limburg, Belgium | |||
1235347 | 1235347 | 2021-09-27 | Belgium | Luxembourg | 34298 | 0 | 0 | 50.0547 | 5.4677 | 2021-09-28 04:21:28 | Luxembourg, Belgium | |||
1235348 | 1235348 | 2021-09-27 | Belgium | Namur | 63890 | 0 | 0 | 50.331 | 4.8221 | 2021-09-28 04:21:28 | Namur, Belgium | |||
1235350 | 1235350 | 2021-09-27 | Belgium | Walloon Brabant | 47706 | 0 | 0 | 50.4 | 4.35 | 2021-09-28 04:21:28 | Walloon Brabant, Belgium | |||
1235351 | 1235351 | 2021-09-27 | Belgium | West Flanders | 108971 | 0 | 0 | 51.0536 | 3.1458 | 2021-09-28 04:21:28 | West Flanders, Belgium | |||
1235396 | 1235396 | 2021-09-27 | Canada | Grand Princess | 13 | 0 | 0 | 37.6489 | 0.0 | 2020-12-21 13:27:30 | Grand Princess, Canada | |||
1235404 | 1235404 | 2021-09-27 | Canada | Prince Edward Island | 295 | 0 | 0 | 46.5107 | -63.4168 | 2021-09-28 04:21:28 | Prince Edward Island, Canada | |||
1235406 | 1235406 | 2021-09-27 | Canada | Repatriated Travellers | 13 | 0 | 0 | 2021-09-28 04:21:28 | Repatriated Travellers, Canada | |||||
1235426 | 1235426 | 2021-09-27 | Chile | Unknown | 49 | 0 | 0 | 2021-09-28 04:21:28 | Unknown, Chile | |||||
1235444 | 1235444 | 2021-09-27 | China | Jiangsu | 1598 | 0 | 0 | 32.9711 | 119.455 | 2021-09-28 04:21:28 | Jiangsu, China | |||
1235448 | 1235448 | 2021-09-27 | China | Macau | 67 | 0 | 0 | 22.1667 | 113.55 | 2021-09-28 04:21:28 | Macau, China | |||
1235449 | 1235449 | 2021-09-27 | China | Ningxia | 77 | 0 | 0 | 37.2692 | 106.1655 | 2021-09-28 04:21:28 | Ningxia, China | |||
1235450 | 1235450 | 2021-09-27 | China | Qinghai | 18 | 0 | 0 | 35.7452 | 95.9956 | 2021-09-28 04:21:28 | Qinghai, China | |||
1235454 | 1235454 | 2021-09-27 | China | Shanxi | 260 | 0 | 0 | 37.5777 | 112.2922 | 2021-09-28 04:21:28 | Shanxi, China | |||
1235457 | 1235457 | 2021-09-27 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2021-09-28 04:21:28 | Tibet, China | |||
1235458 | 1235458 | 2021-09-27 | China | Unknown | 11234 | 0 | 0 | 2021-09-28 04:21:28 | Unknown, China | |||||
1235506 | 1235506 | 2021-09-27 | Denmark | Greenland | 565 | 0 | 0 | 71.7069 | -42.6043 | 2021-09-28 04:21:28 | Greenland, Denmark | |||
1235530 | 1235530 | 2021-09-27 | France | Saint Pierre and Miquelon | 31 | 0 | 0 | 46.8852 | -56.3159 | 2021-09-28 04:21:28 | Saint Pierre and Miquelon, France | |||
1235553 | 1235553 | 2021-09-27 | Germany | Unknown | 5202 | 0 | 0 | 2021-09-28 04:21:28 | Unknown, Germany | |||||
1235562 | 1235562 | 2021-09-27 | Holy See | 27 | 0 | 0 | 41.9029 | 12.4534 | 2021-09-28 04:21:28 | Holy See | ||||
1235599 | 1235599 | 2021-09-27 | India | Unknown | 0 | 0 | 0 | 2021-09-28 04:21:28 | Unknown, India | |||||
1235674 | 1235674 | 2021-09-27 | Japan | Unknown | 8 | 0 | 0 | 2021-09-28 04:21:28 | Unknown, Japan | |||||
1235682 | 1235682 | 2021-09-27 | Kiribati | 2 | 0 | 0 | -3.3704 | -168.734 | 2021-09-28 04:21:28 | Kiribati | ||||
1235712 | 1235712 | 2021-09-27 | Malaysia | Unknown | 0 | 0 | 0 | 2021-09-28 04:21:28 | Unknown, Malaysia | |||||
1235719 | 1235719 | 2021-09-27 | Marshall Islands | 4 | 0 | 0 | 7.1315 | 171.1845 | 2021-09-28 04:21:28 | Marshall Islands | ||||
1235751 | 1235751 | 2021-09-27 | Mexico | Unknown | 0 | 0 | 0 | 2021-09-28 04:21:28 | Unknown, Mexico | |||||
1235755 | 1235755 | 2021-09-27 | Micronesia | 1 | 0 | 0 | 7.4256 | 150.5508 | 2021-09-28 04:21:28 | Micronesia | ||||
1235781 | 1235781 | 2021-09-27 | New Zealand | Cook Islands | 1 | 0 | 0 | -21.2367 | -159.7777 | 2021-09-28 04:21:28 | Cook Islands, New Zealand | |||
1235796 | 1235796 | 2021-09-27 | Palau | 5 | 0 | 0 | 7.515 | 134.5825 | 2021-09-28 04:21:28 | Palau | ||||
1235825 | 1235825 | 2021-09-27 | Peru | Unknown | 0 | 0 | 0 | 2021-09-28 04:21:28 | Unknown, Peru | |||||
1235918 | 1235918 | 2021-09-27 | Samoa | 3 | 0 | 0 | -13.759 | -172.1046 | 2021-09-28 04:21:28 | Samoa | ||||
1235929 | 1235929 | 2021-09-27 | Solomon Islands | 20 | 0 | 0 | -9.6457 | 160.1562 | 2021-09-28 04:21:28 | Solomon Islands | ||||
1235952 | 1235952 | 2021-09-27 | Spain | Unknown | 0 | 0 | 0 | 2021-04-25 23:20:49 | Unknown, Spain | |||||
1235955 | 1235955 | 2021-09-27 | Summer Olympics 2020 | 865 | 0 | 0 | 35.6491 | 139.7737 | 2021-09-28 04:21:28 | Summer Olympics 2020 | ||||
1236041 | 1236041 | 2021-09-27 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US | |
1236053 | 1236053 | 2021-09-27 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US | |
1236062 | 1236062 | 2021-09-27 | US | Alaska | Bristol Bay | 2060 | 0 | 0 | 0 | 58.74513976 | -156.701064 | 2021-09-28 04:21:28 | Bristol Bay, Alaska, US | |
1236063 | 1236063 | 2021-09-27 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 351 | 0 | 0 | 58.62403337 | -156.21405890000003 | 2021-09-28 04:21:28 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
1236065 | 1236065 | 2021-09-27 | US | Alaska | Copper River | 2066 | 449 | 0 | 0 | 60.3886 | -162.8905196 | 2021-09-28 04:21:28 | Copper River, Alaska, US | |
1236069 | 1236069 | 2021-09-27 | US | Alaska | Haines | 2100 | 206 | 0 | 0 | 59.09893571 | -135.4679843 | 2021-09-28 04:21:28 | Haines, Alaska, US | |
1236076 | 1236076 | 2021-09-27 | US | Alaska | Nome | 2180 | 1040 | 0 | 0 | 64.90320724 | -164.0353804 | 2021-09-28 04:21:28 | Nome, Alaska, US | |
1236082 | 1236082 | 2021-09-27 | US | Alaska | Skagway | 2230 | 66 | 0 | 0 | 59.56149996 | -135.33377480000001 | 2021-09-28 04:21:28 | Skagway, Alaska, US | |
1236084 | 1236084 | 2021-09-27 | US | Alaska | Unassigned | 90002 | 464 | 0 | 0 | 69.31479216 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Alaska, US | |
1236085 | 1236085 | 2021-09-27 | US | Alaska | Valdez-Cordova | 2261 | 0 | 0 | 0 | 61.47502768 | -144.7126799 | 2021-09-28 04:21:28 | Valdez-Cordova, Alaska, US | |
1236086 | 1236086 | 2021-09-27 | US | Alaska | Wrangell | 2275 | 133 | 0 | 0 | 56.3202004 | -132.05837309999998 | 2021-09-28 04:21:28 | Wrangell, Alaska, US | |
1236099 | 1236099 | 2021-09-27 | US | Arizona | Out of AZ | 80004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-09-28 04:21:28 | Out of AZ, Arizona, US | |
1236103 | 1236103 | 2021-09-27 | US | Arizona | Unassigned | 90004 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Arizona, US | |
1236175 | 1236175 | 2021-09-27 | US | Arkansas | Unassigned | 90005 | 5647 | 0 | 0 | 36.38177105 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Arkansas, US | |
1236183 | 1236183 | 2021-09-27 | US | California | Alpine | 6003 | 101 | 0 | 0 | 38.59678594 | -119.82235940000001 | 2021-09-28 04:21:28 | Alpine, California, US | |
1236212 | 1236212 | 2021-09-27 | US | California | Out of CA | 80006 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-09-28 04:21:28 | Out of CA, California, US | |
1236228 | 1236228 | 2021-09-27 | US | California | Sierra | 6091 | 141 | 0 | 0 | 39.57713498 | -120.52007009999998 | 2021-09-28 04:21:28 | Sierra, California, US | |
1236238 | 1236238 | 2021-09-27 | US | California | Unassigned | 90006 | 143 | 0 | 0 | 41.74228275 | 0.0 | 2021-09-28 04:21:28 | Unassigned, California, US | |
1236269 | 1236269 | 2021-09-27 | US | Colorado | Hinsdale | 8053 | 54 | 0 | 0 | 37.82247444 | -107.3004345 | 2021-09-28 04:21:28 | Hinsdale, Colorado, US | |
1236271 | 1236271 | 2021-09-27 | US | Colorado | Jackson | 8057 | 94 | 0 | 0 | 40.66593870000001 | -106.3408905 | 2021-09-28 04:21:28 | Jackson, Colorado, US | |
1236289 | 1236289 | 2021-09-27 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2021-09-28 04:21:28 | Out of CO, Colorado, US | |
1236299 | 1236299 | 2021-09-27 | US | Colorado | San Juan | 8111 | 86 | 0 | 0 | 37.76248981 | -107.67632890000002 | 2021-09-28 04:21:28 | San Juan, Colorado, US | |
1236304 | 1236304 | 2021-09-27 | US | Colorado | Unassigned | 90008 | 97 | 0 | 0 | 40.87595412 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Colorado, US | |
1236320 | 1236320 | 2021-09-27 | US | Delaware | Unassigned | 90010 | 300 | 0 | 0 | 39.57992638 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Delaware, US | |
1236321 | 1236321 | 2021-09-27 | US | Diamond Princess | 88888 | 49 | 0 | 0 | 35.4437 | 139.638 | 2020-08-04 02:27:56 | Diamond Princess, US | ||
1236559 | 1236559 | 2021-09-27 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Hawaii, US | |
1236572 | 1236572 | 2021-09-27 | US | Idaho | Camas | 16025 | 91 | 0 | 0 | 43.46665742 | -114.8065892 | 2021-09-28 04:21:28 | Camas, Idaho, US | |
1236576 | 1236576 | 2021-09-27 | US | Idaho | Clark | 16033 | 69 | 0 | 0 | 44.28496071 | -112.35057040000001 | 2021-09-28 04:21:28 | Clark, Idaho, US | |
1236602 | 1236602 | 2021-09-27 | US | Idaho | Unassigned | 90016 | 3 | 0 | 0 | 48.76684761 | -116.78476880000001 | 2021-09-28 04:21:28 | Unassigned, Idaho, US | |
1236676 | 1236676 | 2021-09-27 | US | Illinois | Out of IL | 80017 | 9 | 0 | 0 | 42.36542373 | 0.0 | 2021-09-28 04:21:28 | Out of IL, Illinois, US | |
1236889 | 1236889 | 2021-09-27 | US | Iowa | Unassigned | 90019 | 5015 | 0 | 0 | 43.38107862 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Iowa, US | |
1236974 | 1236974 | 2021-09-27 | US | Kansas | Out of KS | 80020 | 0 | 0 | 0 | 39.82799632 | -99.91547333 | 2021-09-28 04:21:28 | Out of KS, Kansas, US | |
1237001 | 1237001 | 2021-09-27 | US | Kansas | Unassigned | 90020 | 0 | 0 | 0 | 39.82799632 | -99.91547333 | 2021-09-28 04:21:28 | Unassigned, Kansas, US | |
1237121 | 1237121 | 2021-09-27 | US | Kentucky | Unassigned | 90021 | 9 | 0 | 0 | 38.97065142 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Kentucky, US | |
1237167 | 1237167 | 2021-09-27 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-09-28 04:21:28 | Out of LA, Louisiana, US | |
1237186 | 1237186 | 2021-09-27 | US | Louisiana | Unassigned | 90022 | 550 | 0 | 0 | 32.83121059 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Louisiana, US | |
1237204 | 1237204 | 2021-09-27 | US | Maine | Out of ME | 80023 | 0 | 0 | 0 | 46.65926321 | 0.0 | 2020-08-07 22:34:20 | Out of ME, Maine, US | |
1237210 | 1237210 | 2021-09-27 | US | Maine | Unassigned | 90023 | 3 | 0 | 0 | 46.65926321 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Maine, US | |
1237335 | 1237335 | 2021-09-27 | US | Michigan | Unassigned | 90026 | 37 | 0 | 0 | 47.63197653 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Michigan, US | |
1237355 | 1237355 | 2021-09-27 | US | Minnesota | Cook | 27031 | 215 | 0 | 0 | 47.90504893 | -90.52629546 | 2021-09-28 04:21:28 | Cook, Minnesota, US | |
1237500 | 1237500 | 2021-09-27 | US | Mississippi | Unassigned | 90028 | 0 | 0 | 0 | 34.88084463 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Mississippi, US | |
1237620 | 1237620 | 2021-09-27 | US | Missouri | Unassigned | 90029 | 0 | 0 | 0 | 40.47945588 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Missouri, US | |
1237680 | 1237680 | 2021-09-27 | US | Montana | Unassigned | 90030 | 0 | 0 | 0 | 48.78420029 | 0.0 | 2021-09-28 04:21:28 | Unassigned, Montana, US | |
1237688 | 1237688 | 2021-09-27 | US | Nebraska | Banner | 31007 | 43 | 0 | 0 | 41.54634427 | -103.7114332 | 2021-09-28 04:21:28 | Banner, Nebraska, US | |
1237689 | 1237689 | 2021-09-27 | US | Nebraska | Blaine | 31009 | 31 | 0 | 0 | 41.91311716 | -99.97677845 | 2021-09-28 04:21:28 | Blaine, Nebraska, US | |
1237726 | 1237726 | 2021-09-27 | US | Nebraska | Harlan | 31083 | 251 | 0 | 0 | 40.17658508 | -99.40438879 | 2021-09-28 04:21:28 | Harlan, Nebraska, US | |
1237727 | 1237727 | 2021-09-27 | US | Nebraska | Hayes | 31085 | 67 | 0 | 0 | 40.52451972 | -101.0603568 | 2021-09-28 04:21:28 | Hayes, Nebraska, US | |
1237736 | 1237736 | 2021-09-27 | US | Nebraska | Keya Paha | 31103 | 60 | 0 | 0 | 42.87990694 | -99.71343729 | 2021-09-28 04:21:28 | Keya Paha, Nebraska, US | |
1237741 | 1237741 | 2021-09-27 | US | Nebraska | Logan | 31113 | 90 | 0 | 0 | 41.56650314 | -100.4817851 | 2021-09-28 04:21:28 | Logan, Nebraska, US | |
1237742 | 1237742 | 2021-09-27 | US | Nebraska | Loup | 31115 | 48 | 0 | 0 | 41.91371961 | -99.45440415 | 2021-09-28 04:21:28 | Loup, Nebraska, US | |
1237767 | 1237767 | 2021-09-27 | US | Nebraska | Sioux | 31165 | 47 | 0 | 0 | 42.48932059 | -103.7576544 | 2021-09-28 04:21:28 | Sioux, Nebraska, US | |
1237777 | 1237777 | 2021-09-27 | US | Nebraska | Wheeler | 31183 | 57 | 0 | 0 | 41.91482725 | -98.52798941 | 2021-09-28 04:21:28 | Wheeler, Nebraska, US | |
1237784 | 1237784 | 2021-09-27 | US | Nevada | Esmeralda | 32009 | 48 | 0 | 0 | 37.78436681 | -117.63199990000001 | 2021-09-28 04:21:28 | Esmeralda, Nevada, US | |
1237785 | 1237785 | 2021-09-27 | US | Nevada | Eureka | 32011 | 130 | 0 | 0 | 39.98100864 | -116.26832040000001 | 2021-09-28 04:21:28 | Eureka, Nevada, US | |
1237794 | 1237794 | 2021-09-27 | US | Nevada | Unassigned | 90032 | 0 | 0 | 0 | 41.40692186 | 0.0 | 2021-01-24 23:22:19 | Unassigned, Nevada, US | |
1237827 | 1237827 | 2021-09-27 | US | New Jersey | Unassigned | 90034 | 717 | 0 | 0 | 41.13891592 | 0.0 | 2021-09-28 04:21:28 | Unassigned, New Jersey, US | |
1237861 | 1237861 | 2021-09-27 | US | New Mexico | Unassigned | 90035 | 4858 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-09-28 04:21:28 | Unassigned, New Mexico, US | |
1238017 | 1238017 | 2021-09-27 | US | North Carolina | Unassigned | 90037 | 1 | 0 | 0 | 36.49360862 | 0.0 | 2021-09-28 04:21:28 | Unassigned, North Carolina, US | |
1238032 | 1238032 | 2021-09-27 | US | North Dakota | Billings | 38007 | 69 | 0 | 0 | 47.02366884 | -103.3762965 | 2021-09-28 04:21:28 | Billings, North Dakota, US |
Advanced export
JSON shape: default, array, newline-delimited
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]);