johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,201 rows where "day" is on date 2020-04-28 sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
271855 | 271855 | 2020-04-28 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-04-29 02:32:29 | Pitcairn Islands, United Kingdom | ||
271854 | 271854 | 2020-04-28 | Tuvalu | 0 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2020-04-29 02:32:29 | Tuvalu | |||
271853 | 271853 | 2020-04-28 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-04-29 02:32:29 | Niue, New Zealand | ||
271852 | 271852 | 2020-04-28 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2020-04-29 02:32:29 | Nauru | |||
271851 | 271851 | 2020-04-28 | United Kingdom | Wales | 82604 | 0 | 1573 | 0 | 0 | 52.1307 | -3.7837 | 2020-04-29 02:32:29 | Wales, United Kingdom | |
271850 | 271850 | 2020-04-28 | United Kingdom | Scotland | 82603 | 0 | 2666 | 0 | 0 | 56.4907 | -4.2026 | 2020-04-29 02:32:29 | Scotland, United Kingdom | |
271849 | 271849 | 2020-04-28 | United Kingdom | Northern Ireland | 82602 | 0 | 477 | 0 | 0 | 54.7877 | -6.4923 | 2020-04-29 02:32:29 | Northern Ireland, United Kingdom | |
271848 | 271848 | 2020-04-28 | United Kingdom | England | 82601 | 0 | 32622 | 0 | 0 | 52.3555 | -1.1743 | 2020-04-29 02:32:29 | England, United Kingdom | |
271847 | 271847 | 2020-04-28 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-04-29 02:32:29 | Unknown, Ukraine | ||||
271846 | 271846 | 2020-04-28 | Korea, North | 0 | 0 | 0 | 0 | 40.3399 | 127.5101 | 2020-04-29 02:32:29 | Korea, North | |||
271845 | 271845 | 2020-04-28 | United Kingdom | Guernsey | 247 | 16 | 0 | 0 | 49.448196 | -2.58949 | 2020-04-29 02:32:29 | Guernsey, United Kingdom | ||
271844 | 271844 | 2020-04-28 | United Kingdom | Jersey | 277 | 19 | 0 | 0 | 49.2138 | -2.1358 | 2020-04-29 02:32:29 | Jersey, United Kingdom | ||
271843 | 271843 | 2020-04-28 | Antarctica | 0 | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-04-29 02:32:29 | Antarctica | |||
271842 | 271842 | 2020-04-28 | Winter Olympics 2022 | 0 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2020-04-29 02:32:29 | Winter Olympics 2022 | |||
271841 | 271841 | 2020-04-28 | Tonga | 0 | 0 | 0 | 0 | -21.179 | -175.1982 | 2020-04-29 02:32:29 | Tonga | |||
271840 | 271840 | 2020-04-28 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-04-29 02:32:29 | Unknown, Malaysia | ||||
271839 | 271839 | 2020-04-28 | Malaysia | W.P. Putrajaya | 80 | 1 | 47 | 32 | 2.9264 | 101.6964 | 2020-04-29 02:32:29 | W.P. Putrajaya, Malaysia | ||
271838 | 271838 | 2020-04-28 | Malaysia | W.P. Labuan | 16 | 0 | 14 | 2 | 5.2831 | 115.2308 | 2020-04-29 02:32:29 | W.P. Labuan, Malaysia | ||
271837 | 271837 | 2020-04-28 | Malaysia | W.P. Kuala Lumpur | 1210 | 15 | 763 | 432 | 3.139 | 101.6869 | 2020-04-29 02:32:29 | W.P. Kuala Lumpur, Malaysia | ||
271836 | 271836 | 2020-04-28 | Malaysia | Terengganu | 112 | 1 | 71 | 40 | 5.3117 | 103.1324 | 2020-04-29 02:32:29 | Terengganu, Malaysia | ||
271835 | 271835 | 2020-04-28 | Malaysia | Selangor | 1405 | 18 | 1087 | 300 | 3.0738 | 101.5183 | 2020-04-29 02:32:29 | Selangor, Malaysia | ||
271834 | 271834 | 2020-04-28 | Malaysia | Sarawak | 495 | 16 | 213 | 266 | 1.5533 | 110.3592 | 2020-04-29 02:32:29 | Sarawak, Malaysia | ||
271833 | 271833 | 2020-04-28 | Malaysia | Sabah | 314 | 4 | 219 | 91 | 5.9788 | 116.0753 | 2020-04-29 02:32:29 | Sabah, Malaysia | ||
271832 | 271832 | 2020-04-28 | Malaysia | Pulau Pinang | 119 | 1 | 111 | 7 | 5.4141 | 100.3288 | 2020-04-29 02:32:29 | Pulau Pinang, Malaysia | ||
271831 | 271831 | 2020-04-28 | Malaysia | Perlis | 18 | 2 | 8 | 8 | 6.4449 | 100.2048 | 2020-04-29 02:32:29 | Perlis, Malaysia | ||
271830 | 271830 | 2020-04-28 | Malaysia | Perak | 252 | 6 | 237 | 9 | 4.5921 | 101.0901 | 2020-04-29 02:32:29 | Perak, Malaysia | ||
271829 | 271829 | 2020-04-28 | Malaysia | Pahang | 291 | 3 | 219 | 69 | 3.8126 | 103.3256 | 2020-04-29 02:32:29 | Pahang, Malaysia | ||
271828 | 271828 | 2020-04-28 | Malaysia | Negeri Sembilan | 437 | 7 | 347 | 83 | 2.7258 | 101.9424 | 2020-04-29 02:32:29 | Negeri Sembilan, Malaysia | ||
271827 | 271827 | 2020-04-28 | Malaysia | Melaka | 189 | 5 | 111 | 73 | 2.1896 | 102.2501 | 2020-04-29 02:32:29 | Melaka, Malaysia | ||
271826 | 271826 | 2020-04-28 | Malaysia | Kelantan | 155 | 3 | 143 | 9 | 6.1254 | 102.2381 | 2020-04-29 02:32:29 | Kelantan, Malaysia | ||
271825 | 271825 | 2020-04-28 | Malaysia | Kedah | 95 | 1 | 84 | 10 | 6.1184 | 100.3685 | 2020-04-29 02:32:29 | Kedah, Malaysia | ||
271824 | 271824 | 2020-04-28 | Malaysia | Johor | 663 | 17 | 357 | 289 | 1.4854 | 103.7618 | 2020-04-29 02:32:29 | Johor, Malaysia | ||
271823 | 271823 | 2020-04-28 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-04-29 02:32:29 | Summer Olympics 2020 | |||
271822 | 271822 | 2020-04-28 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-04-29 02:32:29 | Cook Islands, New Zealand | ||
271821 | 271821 | 2020-04-28 | Palau | 0 | 0 | 0 | 0 | 7.515 | 134.5825 | 2020-04-29 02:32:29 | Palau | |||
271820 | 271820 | 2020-04-28 | Kiribati | 0 | 0 | 0 | 0 | -3.3704 | -168.734 | 2020-04-29 02:32:29 | Kiribati | |||
271819 | 271819 | 2020-04-28 | China | Unknown | 2814 | 0 | 0 | 0 | 2020-04-29 02:32:29 | Unknown, China | ||||
271818 | 271818 | 2020-04-28 | Zimbabwe | 32 | 4 | 5 | 23 | -19.015438 | 29.154857 | 2020-04-29 02:32:29 | Zimbabwe | |||
271817 | 271817 | 2020-04-28 | Zambia | 95 | 3 | 42 | 50 | -13.133897 | 27.849332 | 2020-04-29 02:32:29 | Zambia | |||
271816 | 271816 | 2020-04-28 | Yemen | 1 | 0 | 0 | 1 | 15.552726999999999 | 48.516388 | 2020-04-29 02:32:29 | Yemen | |||
271815 | 271815 | 2020-04-28 | West Bank and Gaza | 343 | 2 | 71 | 270 | 31.9522 | 35.2332 | 2020-04-29 02:32:29 | West Bank and Gaza | |||
271814 | 271814 | 2020-04-28 | Vietnam | 270 | 0 | 222 | 48 | 14.058323999999999 | 108.277199 | 2020-04-29 02:32:29 | Vietnam | |||
271813 | 271813 | 2020-04-28 | Venezuela | 329 | 10 | 142 | 177 | 6.4238 | -66.5897 | 2020-04-29 02:32:29 | Venezuela | |||
271812 | 271812 | 2020-04-28 | Uzbekistan | 1939 | 8 | 992 | 939 | 41.377491 | 64.585262 | 2020-04-29 02:32:29 | Uzbekistan | |||
271811 | 271811 | 2020-04-28 | Uruguay | 625 | 15 | 394 | 216 | -32.5228 | -55.7658 | 2020-04-29 02:32:29 | Uruguay | |||
271810 | 271810 | 2020-04-28 | United Kingdom | Unknown | 161145 | 60 | 0 | 139467 | 55.3781 | -3.436 | 2020-04-29 02:32:29 | United Kingdom | ||
271809 | 271809 | 2020-04-28 | United Arab Emirates | 11380 | 89 | 2181 | 9110 | 23.424076 | 53.847818000000004 | 2020-04-29 02:32:29 | United Arab Emirates | |||
271808 | 271808 | 2020-04-28 | Ukraine | 9410 | 239 | 992 | 8179 | 48.3794 | 31.1656 | 2020-04-29 02:32:29 | Ukraine | |||
271807 | 271807 | 2020-04-28 | Uganda | 79 | 0 | 52 | 27 | 1.373333 | 32.290275 | 2020-04-29 02:32:29 | Uganda | |||
271806 | 271806 | 2020-04-28 | Turkey | 114653 | 2992 | 38809 | 72852 | 38.9637 | 35.2433 | 2020-04-29 02:32:29 | Turkey | |||
271805 | 271805 | 2020-04-28 | Tunisia | 975 | 40 | 279 | 656 | 33.886917 | 9.537499 | 2020-04-29 02:32:29 | Tunisia | |||
271804 | 271804 | 2020-04-28 | Trinidad and Tobago | 116 | 8 | 59 | 49 | 10.6918 | -61.2225 | 2020-04-29 02:32:29 | Trinidad and Tobago | |||
271803 | 271803 | 2020-04-28 | Togo | 99 | 6 | 63 | 30 | 8.6195 | 0.8248 | 2020-04-29 02:32:29 | Togo | |||
271802 | 271802 | 2020-04-28 | Timor-Leste | 24 | 0 | 6 | 18 | -8.874217 | 125.727539 | 2020-04-29 02:32:29 | Timor-Leste | |||
271801 | 271801 | 2020-04-28 | Thailand | 2938 | 54 | 2652 | 232 | 15.870032 | 100.992541 | 2020-04-29 02:32:29 | Thailand | |||
271800 | 271800 | 2020-04-28 | Tanzania | 299 | 10 | 48 | 241 | -6.369028 | 34.888822 | 2020-04-29 02:32:29 | Tanzania | |||
271799 | 271799 | 2020-04-28 | Taiwan* | 429 | 6 | 307 | 116 | 23.7 | 121.0 | 2020-04-29 02:32:29 | Taiwan* | |||
271798 | 271798 | 2020-04-28 | Syria | 43 | 3 | 21 | 19 | 34.802075 | 38.99681500000001 | 2020-04-29 02:32:29 | Syria | |||
271797 | 271797 | 2020-04-28 | Switzerland | 29264 | 1637 | 22600 | 5027 | 46.8182 | 8.2275 | 2020-04-29 02:32:29 | Switzerland | |||
271796 | 271796 | 2020-04-28 | Sweden | 19621 | 2355 | 1005 | 16261 | 60.128161 | 18.643501 | 2020-04-29 02:32:29 | Sweden | |||
271795 | 271795 | 2020-04-28 | Suriname | 10 | 1 | 7 | 2 | 3.9193 | -56.0278 | 2020-04-29 02:32:29 | Suriname | |||
271794 | 271794 | 2020-04-28 | Sudan | 318 | 25 | 31 | 262 | 12.8628 | 30.2176 | 2020-04-29 02:32:29 | Sudan | |||
271793 | 271793 | 2020-04-28 | Sri Lanka | 619 | 7 | 134 | 478 | 7.873054 | 80.77179699999998 | 2020-04-29 02:32:29 | Sri Lanka | |||
271792 | 271792 | 2020-04-28 | Spain | 232128 | 23822 | 123903 | 84403 | 40.463667 | -3.7492199999999998 | 2020-04-29 02:32:29 | Spain | |||
271791 | 271791 | 2020-04-28 | South Sudan | 34 | 0 | 0 | 34 | 6.8770000000000024 | 31.307 | 2020-04-29 02:32:29 | South Sudan | |||
271790 | 271790 | 2020-04-28 | South Africa | 4996 | 93 | 2073 | 2830 | -30.5595 | 22.9375 | 2020-04-29 02:32:29 | South Africa | |||
271789 | 271789 | 2020-04-28 | Somalia | 528 | 28 | 19 | 481 | 5.152149 | 46.199616 | 2020-04-29 02:32:29 | Somalia | |||
271788 | 271788 | 2020-04-28 | Slovenia | 1408 | 86 | 223 | 1099 | 46.1512 | 14.9955 | 2020-04-29 02:32:29 | Slovenia | |||
271787 | 271787 | 2020-04-28 | Slovakia | 1384 | 20 | 423 | 941 | 48.669 | 19.699 | 2020-04-29 02:32:29 | Slovakia | |||
271786 | 271786 | 2020-04-28 | Singapore | 14951 | 14 | 1128 | 13809 | 1.2833 | 103.8333 | 2020-04-29 02:32:29 | Singapore | |||
271785 | 271785 | 2020-04-28 | Sierra Leone | 104 | 4 | 12 | 88 | 8.460555000000001 | -11.779889 | 2020-04-29 02:32:29 | Sierra Leone | |||
271784 | 271784 | 2020-04-28 | Seychelles | 11 | 0 | 6 | 5 | -4.6796 | 55.492 | 2020-04-29 02:32:29 | Seychelles | |||
271783 | 271783 | 2020-04-28 | Serbia | 6630 | 125 | 870 | 5635 | 44.0165 | 21.0059 | 2020-04-29 02:32:29 | Serbia | |||
271782 | 271782 | 2020-04-28 | Senegal | 823 | 9 | 296 | 518 | 14.4974 | -14.4524 | 2020-04-29 02:32:29 | Senegal | |||
271781 | 271781 | 2020-04-28 | Saudi Arabia | 20077 | 152 | 2784 | 17141 | 23.885942 | 45.079162 | 2020-04-29 02:32:29 | Saudi Arabia | |||
271780 | 271780 | 2020-04-28 | Sao Tome and Principe | 8 | 0 | 4 | 4 | 0.18636 | 6.613081 | 2020-04-29 02:32:29 | Sao Tome and Principe | |||
271779 | 271779 | 2020-04-28 | San Marino | 538 | 41 | 64 | 433 | 43.9424 | 12.4578 | 2020-04-29 02:32:29 | San Marino | |||
271778 | 271778 | 2020-04-28 | Samoa | 0 | 0 | 0 | 0 | -13.759 | -172.1046 | 2020-04-29 02:32:29 | Samoa | |||
271777 | 271777 | 2020-04-28 | Saint Vincent and the Grenadines | 15 | 0 | 8 | 7 | 12.9843 | -61.2872 | 2020-04-29 02:32:29 | Saint Vincent and the Grenadines | |||
271776 | 271776 | 2020-04-28 | Saint Lucia | 15 | 0 | 15 | 0 | 13.9094 | -60.9789 | 2020-04-29 02:32:29 | Saint Lucia | |||
271775 | 271775 | 2020-04-28 | Saint Kitts and Nevis | 15 | 0 | 4 | 11 | 17.357822 | -62.782998 | 2020-04-29 02:32:29 | Saint Kitts and Nevis | |||
271774 | 271774 | 2020-04-28 | Rwanda | 212 | 0 | 95 | 117 | -1.9403 | 29.8739 | 2020-04-29 02:32:29 | Rwanda | |||
271773 | 271773 | 2020-04-28 | Russia | 93558 | 867 | 8456 | 84235 | 61.52401 | 105.31875600000001 | 2020-04-29 02:32:29 | Russia | |||
271772 | 271772 | 2020-04-28 | Romania | 11616 | 663 | 3404 | 7549 | 45.9432 | 24.9668 | 2020-04-29 02:32:29 | Romania | |||
271771 | 271771 | 2020-04-28 | Qatar | 11921 | 10 | 1134 | 10777 | 25.3548 | 51.1839 | 2020-04-29 02:32:29 | Qatar | |||
271770 | 271770 | 2020-04-28 | Portugal | 24322 | 948 | 1389 | 21985 | 39.3999 | -8.2245 | 2020-04-29 02:32:29 | Portugal | |||
271769 | 271769 | 2020-04-28 | Poland | 12218 | 596 | 2655 | 8967 | 51.9194 | 19.1451 | 2020-04-29 02:32:29 | Poland | |||
271768 | 271768 | 2020-04-28 | Philippines | 7958 | 530 | 975 | 6453 | 12.879721 | 121.77401699999999 | 2020-04-29 02:32:29 | Philippines | |||
271767 | 271767 | 2020-04-28 | Peru | 31190 | 4106 | 9179 | 17905 | -9.19 | -75.0152 | 2020-04-29 02:32:29 | Peru | |||
271766 | 271766 | 2020-04-28 | Paraguay | 239 | 9 | 102 | 128 | -23.4425 | -58.4438 | 2020-04-29 02:32:29 | Paraguay | |||
271765 | 271765 | 2020-04-28 | Papua New Guinea | 8 | 0 | 0 | 8 | -6.314993 | 143.95555 | 2020-04-29 02:32:29 | Papua New Guinea | |||
271764 | 271764 | 2020-04-28 | Panama | 6021 | 167 | 455 | 5399 | 8.538 | -80.7821 | 2020-04-29 02:32:29 | Panama | |||
271763 | 271763 | 2020-04-28 | Pakistan | 14612 | 312 | 3233 | 11067 | 30.3753 | 69.3451 | 2020-04-29 02:32:29 | Pakistan | |||
271762 | 271762 | 2020-04-28 | Oman | 2131 | 10 | 364 | 1757 | 21.512583 | 55.92325500000001 | 2020-04-29 02:32:29 | Oman | |||
271761 | 271761 | 2020-04-28 | Norway | 7660 | 206 | 32 | 7422 | 60.472 | 8.4689 | 2020-04-29 02:32:29 | Norway | |||
271760 | 271760 | 2020-04-28 | North Macedonia | 1421 | 71 | 589 | 761 | 41.6086 | 21.7453 | 2020-04-29 02:32:29 | North Macedonia | |||
271759 | 271759 | 2020-04-28 | Nigeria | 1532 | 44 | 255 | 1233 | 9.082 | 8.6753 | 2020-04-29 02:32:29 | Nigeria | |||
271758 | 271758 | 2020-04-28 | Niger | 709 | 31 | 403 | 275 | 17.607789 | 8.081666 | 2020-04-29 02:32:29 | Niger | |||
271757 | 271757 | 2020-04-28 | Nicaragua | 13 | 3 | 7 | 3 | 12.865416 | -85.207229 | 2020-04-29 02:32:29 | Nicaragua | |||
271756 | 271756 | 2020-04-28 | New Zealand | 1474 | 20 | 1229 | 226 | -40.9006 | 174.886 | 2020-04-29 02:32:29 | New Zealand |
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]);