daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,816 rows where "last_update" is on date 2020-06-26 sorted by province_or_state
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, last_update
day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-06-25 | Mauritania | 3739 | 119 | 1225 | 2395 | 21.0079 | -10.9408 | 2020-06-26 04:33:43 | Mauritania | |||
2020-06-25 | Mauritius | 341 | 10 | 326 | 5 | -20.348404000000002 | 57.552152 | 2020-06-26 04:33:43 | Mauritius | |||
2020-06-25 | Moldova | 15453 | 502 | 8599 | 6352 | 47.4116 | 28.3699 | 2020-06-26 04:33:43 | Moldova | |||
2020-06-25 | Monaco | 102 | 4 | 95 | 3 | 43.7333 | 7.4167 | 2020-06-26 04:33:43 | Monaco | |||
2020-06-25 | Mongolia | 216 | 0 | 170 | 49 | 46.8625 | 103.8467 | 2020-06-26 04:33:43 | Mongolia | |||
2020-06-25 | Montenegro | 414 | 9 | 315 | 90 | 42.708678000000006 | 19.37439 | 2020-06-26 04:33:43 | Montenegro | |||
2020-06-25 | Morocco | 11338 | 217 | 8500 | 2621 | 31.7917 | -7.0926 | 2020-06-26 04:33:43 | Morocco | |||
2020-06-25 | Mozambique | 788 | 5 | 221 | 562 | -18.665695 | 35.529562 | 2020-06-26 04:33:43 | Mozambique | |||
2020-06-25 | Namibia | 102 | 0 | 21 | 81 | -22.9576 | 18.4904 | 2020-06-26 04:33:43 | Namibia | |||
2020-06-25 | Nepal | 11162 | 26 | 2650 | 8486 | 28.1667 | 84.25 | 2020-06-26 04:33:43 | Nepal | |||
2020-06-25 | Netherlands | 49914 | 6100 | 0 | 43814 | 52.1326 | 5.2913 | 2020-06-26 04:33:43 | Netherlands | |||
2020-06-25 | New Zealand | 1520 | 23 | 1484 | 14 | -40.9006 | 174.886 | 2020-06-26 04:33:43 | New Zealand | |||
2020-06-25 | Nicaragua | 2014 | 74 | 1238 | 858 | 12.865416 | -85.207229 | 2020-06-26 04:33:43 | Nicaragua | |||
2020-06-25 | Niger | 1056 | 67 | 917 | 72 | 17.607789 | 8.081666 | 2020-06-26 04:33:43 | Niger | |||
2020-06-25 | Nigeria | 22614 | 549 | 7822 | 14243 | 9.082 | 8.6753 | 2020-06-26 04:33:43 | Nigeria | |||
2020-06-25 | North Macedonia | 5595 | 265 | 2166 | 3164 | 41.6086 | 21.7453 | 2020-06-26 04:33:43 | North Macedonia | |||
2020-06-25 | Norway | 8788 | 249 | 8138 | 401 | 60.472 | 8.4689 | 2020-06-26 04:33:43 | Norway | |||
2020-06-25 | Oman | 34902 | 144 | 18520 | 16238 | 21.512583 | 55.92325500000001 | 2020-06-26 04:33:43 | Oman | |||
2020-06-25 | Panama | 29037 | 564 | 14800 | 13673 | 8.538 | -80.7821 | 2020-06-26 04:33:43 | Panama | |||
2020-06-25 | Papua New Guinea | 10 | 0 | 8 | 2 | -6.314993 | 143.95555 | 2020-06-26 04:33:43 | Papua New Guinea | |||
2020-06-25 | Paraguay | 1569 | 13 | 976 | 580 | -23.4425 | -58.4438 | 2020-06-26 04:33:43 | Paraguay | |||
2020-06-25 | Philippines | 33069 | 1212 | 8910 | 22947 | 12.879721 | 121.77401699999999 | 2020-06-26 04:33:43 | Philippines | |||
2020-06-25 | Poland | 33119 | 1412 | 18654 | 13053 | 51.9194 | 19.1451 | 2020-06-26 04:33:43 | Poland | |||
2020-06-25 | Portugal | 40415 | 1549 | 26382 | 12484 | 39.3999 | -8.2245 | 2020-06-26 04:33:43 | Portugal | |||
2020-06-25 | Qatar | 91838 | 106 | 74544 | 17188 | 25.3548 | 51.1839 | 2020-06-26 04:33:43 | Qatar | |||
2020-06-25 | Romania | 25286 | 1565 | 17906 | 5815 | 45.9432 | 24.9668 | 2020-06-26 04:33:43 | Romania | |||
2020-06-25 | Rwanda | 850 | 2 | 385 | 463 | -1.9403 | 29.8739 | 2020-06-26 04:33:43 | Rwanda | |||
2020-06-25 | Saint Kitts and Nevis | 15 | 0 | 15 | 0 | 17.357822 | -62.782998 | 2020-06-26 04:33:43 | Saint Kitts and Nevis | |||
2020-06-25 | Saint Lucia | 19 | 0 | 19 | 0 | 13.9094 | -60.9789 | 2020-06-26 04:33:43 | Saint Lucia | |||
2020-06-25 | Saint Vincent and the Grenadines | 29 | 0 | 29 | 0 | 12.9843 | -61.2872 | 2020-06-26 04:33:43 | Saint Vincent and the Grenadines | |||
2020-06-25 | Samoa | 0 | 0 | 0 | 0 | -13.759 | -172.1046 | 2020-06-26 04:33:43 | Samoa | |||
2020-06-25 | San Marino | 713 | 42 | 653 | 18 | 43.9424 | 12.4578 | 2020-06-26 04:33:43 | San Marino | |||
2020-06-25 | Sao Tome and Principe | 711 | 13 | 214 | 484 | 0.18636 | 6.613081 | 2020-06-26 04:33:43 | Sao Tome and Principe | |||
2020-06-25 | Saudi Arabia | 170639 | 1428 | 117882 | 51329 | 23.885942 | 45.079162 | 2020-06-26 04:33:43 | Saudi Arabia | |||
2020-06-25 | Senegal | 6233 | 94 | 4162 | 1977 | 14.4974 | -14.4524 | 2020-06-26 04:33:43 | Senegal | |||
2020-06-25 | Serbia | 13372 | 264 | 12154 | 954 | 44.0165 | 21.0059 | 2020-06-26 04:33:43 | Serbia | |||
2020-06-25 | Seychelles | 11 | 0 | 11 | 0 | -4.6796 | 55.492 | 2020-06-26 04:33:43 | Seychelles | |||
2020-06-25 | Sierra Leone | 1354 | 56 | 869 | 429 | 8.460555000000001 | -11.779889 | 2020-06-26 04:33:43 | Sierra Leone | |||
2020-06-25 | Singapore | 42736 | 26 | 36604 | 6106 | 1.2833 | 103.8333 | 2020-06-26 04:33:43 | Singapore | |||
2020-06-25 | Slovakia | 1630 | 28 | 1452 | 150 | 48.669 | 19.699 | 2020-06-26 04:33:43 | Slovakia | |||
2020-06-25 | Slovenia | 1547 | 109 | 1376 | 62 | 46.1512 | 14.9955 | 2020-06-26 04:33:43 | Slovenia | |||
2020-06-25 | Somalia | 2878 | 90 | 868 | 1920 | 5.152149 | 46.199616 | 2020-06-26 04:33:43 | Somalia | |||
2020-06-25 | South Africa | 118375 | 2292 | 59974 | 56109 | -30.5595 | 22.9375 | 2020-06-26 04:33:43 | South Africa | |||
2020-06-25 | South Sudan | 1942 | 36 | 224 | 1682 | 6.8770000000000024 | 31.307 | 2020-06-26 04:33:43 | South Sudan | |||
2020-06-25 | Sri Lanka | 2010 | 11 | 1602 | 397 | 7.873054 | 80.77179699999998 | 2020-06-26 04:33:43 | Sri Lanka | |||
2020-06-25 | Sudan | 8887 | 556 | 3806 | 4525 | 12.8628 | 30.2176 | 2020-06-26 04:33:43 | Sudan | |||
2020-06-25 | Suriname | 373 | 10 | 176 | 187 | 3.9193 | -56.0278 | 2020-06-26 04:33:43 | Suriname | |||
2020-06-25 | Switzerland | 31428 | 1808 | 29000 | 620 | 46.8182 | 8.2275 | 2020-06-26 04:33:43 | Switzerland | |||
2020-06-25 | Syria | 242 | 7 | 96 | 139 | 34.802075 | 38.99681500000001 | 2020-06-26 04:33:43 | Syria | |||
2020-06-25 | Taiwan* | 447 | 7 | 435 | 5 | 23.7 | 121.0 | 2020-06-26 04:33:43 | Taiwan* | |||
2020-06-25 | Tajikistan | 5630 | 52 | 4267 | 1311 | 38.861034000000004 | 71.276093 | 2020-06-26 04:33:43 | Tajikistan | |||
2020-06-25 | Tanzania | 509 | 21 | 183 | 305 | -6.369028 | 34.888822 | 2020-06-26 04:33:43 | Tanzania | |||
2020-06-25 | Thailand | 3158 | 58 | 3038 | 62 | 15.870032 | 100.992541 | 2020-06-26 04:33:43 | Thailand | |||
2020-06-25 | Timor-Leste | 24 | 0 | 24 | 0 | -8.874217 | 125.727539 | 2020-06-26 04:33:43 | Timor-Leste | |||
2020-06-25 | Togo | 588 | 14 | 394 | 180 | 8.6195 | 0.8248 | 2020-06-26 04:33:43 | Togo | |||
2020-06-25 | Trinidad and Tobago | 123 | 8 | 109 | 6 | 10.6918 | -61.2225 | 2020-06-26 04:33:43 | Trinidad and Tobago | |||
2020-06-25 | Tunisia | 1162 | 50 | 1023 | 89 | 33.886917 | 9.537499 | 2020-06-26 04:33:43 | Tunisia | |||
2020-06-25 | Turkey | 193115 | 5046 | 165706 | 22363 | 38.9637 | 35.2433 | 2020-06-26 04:33:43 | Turkey | |||
2020-06-25 | Uganda | 821 | 0 | 731 | 90 | 1.373333 | 32.290275 | 2020-06-26 04:33:43 | Uganda | |||
2020-06-25 | United Arab Emirates | 46563 | 308 | 35165 | 11090 | 23.424076 | 53.847818000000004 | 2020-06-26 04:33:43 | United Arab Emirates | |||
2020-06-25 | Uruguay | 907 | 26 | 818 | 63 | -32.5228 | -55.7658 | 2020-06-26 04:33:43 | Uruguay | |||
2020-06-25 | Uzbekistan | 7177 | 20 | 4877 | 2280 | 41.377491 | 64.585262 | 2020-06-26 04:33:43 | Uzbekistan | |||
2020-06-25 | Venezuela | 4563 | 39 | 1327 | 3197 | 6.4238 | -66.5897 | 2020-06-26 04:33:43 | Venezuela | |||
2020-06-25 | Vietnam | 352 | 0 | 329 | 23 | 14.058323999999999 | 108.277199 | 2020-06-26 04:33:43 | Vietnam | |||
2020-06-25 | West Bank and Gaza | 1382 | 3 | 446 | 933 | 31.9522 | 35.2332 | 2020-06-26 04:33:43 | West Bank and Gaza | |||
2020-06-25 | Yemen | 1076 | 288 | 386 | 402 | 15.552726999999999 | 48.516388 | 2020-06-26 04:33:43 | Yemen | |||
2020-06-25 | Zambia | 1497 | 18 | 1223 | 256 | -13.133897 | 27.849332 | 2020-06-26 04:33:43 | Zambia | |||
2020-06-25 | Zimbabwe | 551 | 6 | 128 | 417 | -19.015438 | 29.154857 | 2020-06-26 04:33:43 | Zimbabwe | |||
2020-06-25 | Kiribati | 0 | 0 | 0 | 0 | -3.3704 | -168.734 | 2020-06-26 04:33:43 | Kiribati | |||
2020-06-25 | Palau | 0 | 0 | 0 | 0 | 7.515 | 134.5825 | 2020-06-26 04:33:43 | Palau | |||
2020-06-25 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-06-26 04:33:43 | Summer Olympics 2020 | |||
2020-06-25 | Tonga | 0 | 0 | 0 | 0 | -21.179 | -175.1982 | 2020-06-26 04:33:43 | Tonga | |||
2020-06-25 | Winter Olympics 2022 | 0 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2020-06-26 04:33:43 | Winter Olympics 2022 | |||
2020-06-25 | Antarctica | 0 | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-06-26 04:33:43 | Antarctica | |||
2020-06-25 | Korea, North | 0 | 0 | 0 | 0 | 40.3399 | 127.5101 | 2020-06-26 04:33:43 | Korea, North | |||
2020-06-25 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2020-06-26 04:33:43 | Nauru | |||
2020-06-25 | Tuvalu | 0 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2020-06-26 04:33:43 | Tuvalu | |||
2020-06-25 | Italy | Abruzzo | 3284 | 461 | 2452 | 371 | 42.35122196 | 13.39843823 | 2020-06-26 04:33:43 | Abruzzo, Italy | ||
2020-06-25 | Brazil | Acre | 12304 | 335 | 6270 | 5699 | -9.0238 | -70.812 | 2020-06-26 04:33:43 | Acre, Brazil | ||
2020-06-25 | Russia | Adygea Republic | 1682 | 12 | 1119 | 551 | 44.6939006 | 40.1520421 | 2020-06-26 04:33:43 | Adygea Republic, Russia | ||
2020-06-25 | Mexico | Aguascalientes | 2071 | 122 | 1568 | 381 | 21.8853 | -102.2916 | 2020-06-26 04:33:43 | Aguascalientes, Mexico | ||
2020-06-25 | Japan | Aichi | 526 | 34 | 471 | 21 | 35.035551 | 137.211621 | 2020-06-26 04:33:43 | Aichi, Japan | ||
2020-06-25 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-06-26 04:33:43 | Akita, Japan | ||
2020-06-25 | US | Alabama | Autauga | 1001 | 493 | 10 | 0 | 483 | 32.53952745 | -86.64408227 | 2020-06-26 04:33:43 | Autauga, Alabama, US |
2020-06-25 | US | Alabama | Baldwin | 1003 | 505 | 9 | 0 | 496 | 30.72774991 | -87.72207058 | 2020-06-26 04:33:43 | Baldwin, Alabama, US |
2020-06-25 | US | Alabama | Barbour | 1005 | 313 | 1 | 0 | 312 | 31.868263 | -85.3871286 | 2020-06-26 04:33:43 | Barbour, Alabama, US |
2020-06-25 | US | Alabama | Bibb | 1007 | 161 | 1 | 0 | 160 | 32.99642064 | -87.12511459999996 | 2020-06-26 04:33:43 | Bibb, Alabama, US |
2020-06-25 | US | Alabama | Blount | 1009 | 186 | 1 | 0 | 185 | 33.98210918 | -86.56790593 | 2020-06-26 04:33:43 | Blount, Alabama, US |
2020-06-25 | US | Alabama | Bullock | 1011 | 340 | 10 | 0 | 330 | 32.10030533 | -85.71265535 | 2020-06-26 04:33:43 | Bullock, Alabama, US |
2020-06-25 | US | Alabama | Butler | 1013 | 586 | 27 | 0 | 559 | 31.75300095 | -86.68057478 | 2020-06-26 04:33:43 | Butler, Alabama, US |
2020-06-25 | US | Alabama | Calhoun | 1015 | 236 | 5 | 0 | 231 | 33.77483727 | -85.82630386 | 2020-06-26 04:33:43 | Calhoun, Alabama, US |
2020-06-25 | US | Alabama | Chambers | 1017 | 558 | 27 | 0 | 531 | 32.91360079 | -85.39072749 | 2020-06-26 04:33:43 | Chambers, Alabama, US |
2020-06-25 | US | Alabama | Cherokee | 1019 | 66 | 7 | 0 | 59 | 34.17805983 | -85.60638968 | 2020-06-26 04:33:43 | Cherokee, Alabama, US |
2020-06-25 | US | Alabama | Chilton | 1021 | 192 | 2 | 0 | 190 | 32.85044126 | -86.7173256 | 2020-06-26 04:33:43 | Chilton, Alabama, US |
2020-06-25 | US | Alabama | Choctaw | 1023 | 188 | 12 | 0 | 176 | 32.02227341 | -88.26564429999998 | 2020-06-26 04:33:43 | Choctaw, Alabama, US |
2020-06-25 | US | Alabama | Clarke | 1025 | 244 | 5 | 0 | 239 | 31.68099859 | -87.83548597 | 2020-06-26 04:33:43 | Clarke, Alabama, US |
2020-06-25 | US | Alabama | Clay | 1027 | 33 | 2 | 0 | 31 | 33.26984193 | -85.85836077 | 2020-06-26 04:33:43 | Clay, Alabama, US |
2020-06-25 | US | Alabama | Cleburne | 1029 | 22 | 1 | 0 | 21 | 33.67679204 | -85.52005899 | 2020-06-26 04:33:43 | Cleburne, Alabama, US |
2020-06-25 | US | Alabama | Coffee | 1031 | 331 | 1 | 0 | 330 | 31.39932826 | -85.98901039 | 2020-06-26 04:33:43 | Coffee, Alabama, US |
2020-06-25 | US | Alabama | Colbert | 1033 | 342 | 5 | 0 | 337 | 34.69847452 | -87.80168544 | 2020-06-26 04:33:43 | Colbert, Alabama, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;