johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,608 rows where "day" is on date 2020-04-02 sorted by latitude
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3701627 | 3701627 | 2020-04-02 | Diamond Princess | 712 | 11 | 619 | 82 | 4/2/20 23:25 | Diamond Princess | |||||
3701682 | 3701682 | 2020-04-02 | MS Zaandam | 9 | 2 | 0 | 7 | 4/2/20 23:25 | ,,MS Zaandam | |||||
3701761 | 3701761 | 2020-04-02 | China | Unknown | 1715 | 0 | 0 | 0 | 4/2/20 23:25 | Unknown, China | ||||
3701782 | 3701782 | 2020-04-02 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 4/2/20 23:25 | Unknown, Malaysia | ||||
3701789 | 3701789 | 2020-04-02 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 4/2/20 23:25 | Unknown, Ukraine | ||||
3701669 | 3701669 | 2020-04-02 | Kenya | 110 | 3 | 4 | 103 | -0.0236 | 37.9062 | 4/2/20 23:25 | Kenya | |||
3701794 | 3701794 | 2020-04-02 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 4/2/20 23:25 | Nauru | |||
3701659 | 3701659 | 2020-04-02 | Indonesia | 1790 | 170 | 112 | 1508 | -0.7893 | 113.9213 | 4/2/20 23:25 | Indonesia | |||
3701642 | 3701642 | 2020-04-02 | Gabon | 21 | 1 | 0 | 20 | -0.8037 | 11.6094 | 4/2/20 23:25 | Gabon | |||
3701631 | 3701631 | 2020-04-02 | Ecuador | 3163 | 120 | 65 | 2978 | -1.8312 | -78.1834 | 4/2/20 23:25 | Ecuador | |||
3701718 | 3701718 | 2020-04-02 | Rwanda | 84 | 0 | 0 | 84 | -1.9403 | 29.8739 | 4/2/20 23:25 | Rwanda | |||
3701587 | 3701587 | 2020-04-02 | Angola | 8 | 2 | 1 | 5 | -11.2027 | 17.8739 | 4/2/20 23:25 | Angola | |||
3701548 | 3701548 | 2020-04-02 | Australia | Northern Territory | 21 | 0 | 0 | 21 | -12.4634 | 130.8456 | 4/2/20 23:32 | Northern Territory, Australia | ||
3701540 | 3701540 | 2020-04-02 | France | Mayotte | 116 | 1 | 10 | 105 | -12.8275 | 45.166244 | 4/2/20 23:25 | Mayotte, France | ||
3701758 | 3701758 | 2020-04-02 | Zambia | 39 | 1 | 0 | 38 | -13.133897 | 27.849332 | 4/2/20 23:25 | Zambia | |||
3701684 | 3701684 | 2020-04-02 | Malawi | 3 | 0 | 0 | 3 | -13.254308 | 34.301525 | 4/2/20 23:25 | Malawi | |||
3701722 | 3701722 | 2020-04-02 | Samoa | 0 | 0 | 0 | 0 | -13.759 | -172.1046 | 4/2/20 23:31 | Samoa | |||
3701605 | 3701605 | 2020-04-02 | Brazil | 8044 | 324 | 127 | 7593 | -14.235 | -51.9253 | 4/2/20 23:25 | Brazil | |||
3701602 | 3701602 | 2020-04-02 | Bolivia | 123 | 8 | 1 | 114 | -16.2902 | -63.5887 | 4/2/20 23:25 | Bolivia | |||
3701512 | 3701512 | 2020-04-02 | France | French Polynesia | 37 | 0 | 0 | 37 | -17.6797 | -149.4068 | 4/2/20 23:25 | French Polynesia, France | ||
3701639 | 3701639 | 2020-04-02 | Fiji | 7 | 0 | 0 | 7 | -17.7134 | 178.065 | 4/2/20 23:25 | Fiji | |||
3701696 | 3701696 | 2020-04-02 | Mozambique | 10 | 0 | 0 | 10 | -18.665695 | 35.529562 | 4/2/20 23:25 | Mozambique | |||
3701683 | 3701683 | 2020-04-02 | Madagascar | 59 | 0 | 0 | 59 | -18.766947 | 46.869107 | 4/2/20 23:25 | Madagascar | |||
3701759 | 3701759 | 2020-04-02 | Zimbabwe | 9 | 1 | 0 | 8 | -19.015438 | 29.154857 | 4/2/20 23:25 | Zimbabwe | |||
3701795 | 3701795 | 2020-04-02 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 4/2/20 23:25 | Niue, New Zealand | ||
3701689 | 3701689 | 2020-04-02 | Mauritius | 154 | 5 | 0 | 162 | -20.348404 | 57.552152 | 4/2/20 23:25 | Mauritius | |||
3701543 | 3701543 | 2020-04-02 | France | New Caledonia | 18 | 0 | 1 | 17 | -20.904305 | 165.618042 | 4/2/20 23:25 | New Caledonia, France | ||
3701560 | 3701560 | 2020-04-02 | France | Reunion | 308 | 0 | 40 | 268 | -21.1151 | 55.5364 | 4/2/20 23:25 | Reunion, France | ||
3701783 | 3701783 | 2020-04-02 | Tonga | 0 | 0 | 0 | 0 | -21.179 | -175.1982 | 4/2/20 23:25 | Tonga | |||
3701764 | 3701764 | 2020-04-02 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 4/2/20 23:25 | Cook Islands, New Zealand | ||
3701604 | 3701604 | 2020-04-02 | Botswana | 4 | 1 | 0 | 3 | -22.3285 | 24.6849 | 4/2/20 23:25 | Botswana | |||
3701697 | 3701697 | 2020-04-02 | Namibia | 14 | 0 | 3 | 11 | -22.9576 | 18.4904 | 4/2/20 23:25 | Namibia | |||
3701710 | 3701710 | 2020-04-02 | Paraguay | 92 | 3 | 2 | 87 | -23.4425 | -58.4438 | 4/2/20 23:25 | Paraguay | |||
3701797 | 3701797 | 2020-04-02 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 4/2/20 23:25 | Pitcairn Islands, United Kingdom | ||
3701637 | 3701637 | 2020-04-02 | Eswatini | 9 | 0 | 0 | 9 | -26.5225 | 31.4659 | 4/2/20 23:25 | Eswatini | |||
3701557 | 3701557 | 2020-04-02 | Australia | Queensland | 835 | 4 | 8 | 823 | -27.4698 | 153.0251 | 4/2/20 23:32 | Queensland, Australia | ||
3701762 | 3701762 | 2020-04-02 | Kiribati | 0 | 0 | 0 | 0 | -3.3704 | -168.734 | 4/2/20 23:25 | Kiribati | |||
3701610 | 3701610 | 2020-04-02 | Burundi | 3 | 0 | 0 | 3 | -3.3731 | 29.9189 | 4/2/20 23:25 | Burundi | |||
3701733 | 3701733 | 2020-04-02 | South Africa | 1462 | 5 | 50 | 1407 | -30.5595 | 22.9375 | 4/2/20 23:25 | South Africa | |||
3701578 | 3701578 | 2020-04-02 | Australia | Western Australia | 400 | 2 | 64 | 334 | -31.9505 | 115.8605 | 4/2/20 23:32 | Western Australia, Australia | ||
3701753 | 3701753 | 2020-04-02 | Uruguay | 350 | 4 | 62 | 284 | -32.5228 | -55.7658 | 4/2/20 23:25 | Uruguay | |||
3701544 | 3701544 | 2020-04-02 | Australia | New South Wales | 2298 | 10 | 4 | 2284 | -33.8688 | 151.2093 | 4/2/20 23:32 | New South Wales, Australia | ||
3701570 | 3701570 | 2020-04-02 | Australia | South Australia | 367 | 0 | 6 | 361 | -34.9285 | 138.6007 | 4/2/20 23:32 | South Australia, Australia | ||
3701498 | 3701498 | 2020-04-02 | Australia | Australian Capital Territory | 87 | 1 | 11 | 75 | -35.4735 | 149.0124 | 4/2/20 23:32 | Australian Capital Territory, Australia | ||
3701616 | 3701616 | 2020-04-02 | Chile | 3404 | 18 | 335 | 3051 | -35.6751 | -71.543 | 4/2/20 23:25 | Chile | |||
3701576 | 3701576 | 2020-04-02 | Australia | Victoria | 1036 | 5 | 422 | 609 | -37.8136 | 144.9631 | 4/2/20 23:32 | Victoria, Australia | ||
3701589 | 3701589 | 2020-04-02 | Argentina | 1133 | 36 | 256 | 841 | -38.4161 | -63.6167 | 4/2/20 23:25 | Argentina | |||
3701618 | 3701618 | 2020-04-02 | Congo (Brazzaville) | 22 | 2 | 2 | 18 | -4.2634 | 15.2832 | 4/2/20 23:25 | Congo (Brazzaville) | |||
3701619 | 3701619 | 2020-04-02 | Congo (Kinshasa) | 134 | 13 | 3 | 118 | -4.322447 | 15.307045 | 4/2/20 23:25 | Congo (Kinshasa) | |||
3701727 | 3701727 | 2020-04-02 | Seychelles | 10 | 0 | 0 | 10 | -4.6796 | 55.492 | 4/2/20 23:25 | Seychelles | |||
3701700 | 3701700 | 2020-04-02 | New Zealand | 797 | 1 | 92 | 704 | -40.9006 | 174.886 | 4/2/20 23:25 | New Zealand | |||
3701572 | 3701572 | 2020-04-02 | Australia | Tasmania | 72 | 2 | 5 | 65 | -42.8821 | 147.3272 | 4/2/20 23:32 | Tasmania, Australia | ||
3701709 | 3701709 | 2020-04-02 | Papua New Guinea | 1 | 0 | 0 | 1 | -6.314993 | 143.95555 | 4/2/20 23:25 | Papua New Guinea | |||
3701742 | 3701742 | 2020-04-02 | Tanzania | 20 | 1 | 2 | 17 | -6.369028 | 34.888822 | 4/2/20 23:25 | Tanzania | |||
3701796 | 3701796 | 2020-04-02 | Tuvalu | 0 | 0 | 0 | 0 | -7.1095 | 177.6493 | 4/2/20 23:25 | Tuvalu | |||
3701562 | 3701562 | 2020-04-02 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 0 | 0 | 0 | 0 | -7.9467 | -14.3559 | 4/2/20 23:25 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3701785 | 3701785 | 2020-04-02 | Antarctica | 0 | 0 | 0 | 0 | -71.9499 | 23.347 | 4/2/20 23:25 | Antarctica | |||
3701744 | 3701744 | 2020-04-02 | Timor-Leste | 1 | 0 | 0 | 1 | -8.874217 | 125.727539 | 4/2/20 23:25 | Timor-Leste | |||
3701711 | 3701711 | 2020-04-02 | Peru | 1414 | 183 | 537 | 694 | -9.19 | -75.0152 | 4/2/20 23:25 | Peru | |||
3701508 | 3701508 | 2020-04-02 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 4/2/20 23:31 | Diamond Princess, Canada | ||
3701558 | 3701558 | 2020-04-02 | Canada | Recovered | 0 | 0 | 1735 | 0 | 0.0 | 0.0 | 4/2/20 23:31 | Recovered, Canada | ||
3701559 | 3701559 | 2020-04-02 | US | Recovered | 0 | 0 | 9001 | 0 | 0.0 | 0.0 | 4/2/20 23:25 | Recovered, US | ||
3701729 | 3701729 | 2020-04-02 | Singapore | 1049 | 4 | 266 | 779 | 1.2833 | 103.8333 | 4/2/20 23:25 | Singapore | |||
3701749 | 3701749 | 2020-04-02 | Uganda | 45 | 0 | 0 | 45 | 1.373333 | 32.290275 | 4/2/20 23:25 | Uganda | |||
3701766 | 3701766 | 2020-04-02 | Malaysia | Johor | 399 | 13 | 85 | 301 | 1.4854 | 103.7618 | 4/2/20 23:25 | Johor, Malaysia | ||
3701776 | 3701776 | 2020-04-02 | Malaysia | Sarawak | 210 | 9 | 15 | 186 | 1.5533 | 110.3592 | 4/2/20 23:25 | Sarawak, Malaysia | ||
3701634 | 3701634 | 2020-04-02 | Equatorial Guinea | 15 | 0 | 1 | 14 | 1.6508 | 10.2679 | 4/2/20 23:25 | Equatorial Guinea | |||
3701746 | 3701746 | 2020-04-02 | Trinidad and Tobago | 94 | 5 | 1 | 88 | 10.6918 | -61.2225 | 4/2/20 23:25 | Trinidad and Tobago | |||
3701612 | 3701612 | 2020-04-02 | Cambodia | 110 | 0 | 34 | 76 | 11.55 | 104.9167 | 4/2/20 23:25 | Cambodia | |||
3701651 | 3701651 | 2020-04-02 | Guinea-Bissau | 9 | 0 | 0 | 9 | 11.8037 | -15.1804 | 4/2/20 23:25 | Guinea-Bissau | |||
3701628 | 3701628 | 2020-04-02 | Djibouti | 40 | 0 | 0 | 40 | 11.8251 | 42.5903 | 4/2/20 23:25 | Djibouti | |||
3701648 | 3701648 | 2020-04-02 | Grenada | 10 | 0 | 0 | 10 | 12.1165 | -61.679 | 4/2/20 23:25 | Grenada | |||
3701507 | 3701507 | 2020-04-02 | Netherlands | Curacao | 11 | 1 | 3 | 7 | 12.1696 | -68.99 | 4/2/20 23:25 | Curacao, Netherlands | ||
3701501 | 3701501 | 2020-04-02 | Netherlands | Bonaire, Sint Eustatius and Saba | 2 | 0 | 0 | 2 | 12.1784 | -68.2385 | 4/2/20 23:25 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
3701608 | 3701608 | 2020-04-02 | Burkina Faso | 288 | 16 | 50 | 222 | 12.2383 | -1.5616 | 4/2/20 23:25 | Burkina Faso | |||
3701497 | 3701497 | 2020-04-02 | Netherlands | Aruba | 60 | 0 | 1 | 59 | 12.5211 | -69.9683 | 4/2/20 23:25 | Aruba, Netherlands | ||
3701736 | 3701736 | 2020-04-02 | Sudan | 7 | 2 | 2 | 3 | 12.8628 | 30.2176 | 4/2/20 23:25 | Sudan | |||
3701701 | 3701701 | 2020-04-02 | Nicaragua | 5 | 1 | 0 | 4 | 12.865416 | -85.207229 | 4/2/20 23:25 | Nicaragua | |||
3701712 | 3701712 | 2020-04-02 | Philippines | 2633 | 107 | 51 | 2475 | 12.879721 | 121.774017 | 4/2/20 23:25 | Philippines | |||
3701721 | 3701721 | 2020-04-02 | Saint Vincent and the Grenadines | 2 | 0 | 1 | 1 | 12.9843 | -61.2872 | 4/2/20 23:25 | Saint Vincent and the Grenadines | |||
3701596 | 3701596 | 2020-04-02 | Barbados | 46 | 0 | 0 | 46 | 13.1939 | -59.5432 | 4/2/20 23:25 | Barbados | |||
3701643 | 3701643 | 2020-04-02 | Gambia | 4 | 1 | 2 | 1 | 13.4432 | -15.3101 | 4/2/20 23:25 | Gambia | |||
3701520 | 3701520 | 2020-04-02 | US | Guam | 66 | 82 | 3 | 0 | 79 | 13.4443 | 144.7937 | 4/2/20 23:25 | Guam, US | |
3701633 | 3701633 | 2020-04-02 | El Salvador | 41 | 2 | 0 | 39 | 13.7942 | -88.8965 | 4/2/20 23:25 | El Salvador | |||
3701720 | 3701720 | 2020-04-02 | Saint Lucia | 13 | 0 | 1 | 12 | 13.9094 | -60.9789 | 4/2/20 23:25 | Saint Lucia | |||
3701756 | 3701756 | 2020-04-02 | Vietnam | 233 | 0 | 75 | 158 | 14.058324 | 108.277199 | 4/2/20 23:25 | Vietnam | |||
3701725 | 3701725 | 2020-04-02 | Senegal | 195 | 1 | 55 | 139 | 14.4974 | -14.4524 | 4/2/20 23:25 | Senegal | |||
3701539 | 3701539 | 2020-04-02 | France | Martinique | 138 | 3 | 27 | 108 | 14.6415 | -61.0242 | 4/2/20 23:25 | Martinique, France | ||
3701547 | 3701547 | 2020-04-02 | US | Northern Mariana Islands | 6 | 0 | 0 | 6 | 15.0979 | 145.6739 | 4/2/20 23:25 | ,Northern Mariana Islands,US | ||
3701635 | 3701635 | 2020-04-02 | Eritrea | 22 | 0 | 0 | 22 | 15.1794 | 39.7823 | 4/2/20 23:25 | Eritrea | |||
3701655 | 3701655 | 2020-04-02 | Honduras | 219 | 14 | 3 | 202 | 15.2 | -86.2419 | 4/2/20 23:25 | Honduras | |||
3701629 | 3701629 | 2020-04-02 | Dominica | 12 | 0 | 0 | 12 | 15.415 | -61.371 | 4/2/20 23:25 | Dominica | |||
3701615 | 3701615 | 2020-04-02 | Chad | 8 | 0 | 0 | 8 | 15.4542 | 18.7322 | 4/2/20 23:25 | Chad | |||
3701649 | 3701649 | 2020-04-02 | Guatemala | 47 | 1 | 12 | 34 | 15.7835 | -90.2308 | 4/2/20 23:25 | Guatemala | |||
3701743 | 3701743 | 2020-04-02 | Thailand | 1875 | 15 | 505 | 1355 | 15.870032 | 100.992541 | 4/2/20 23:25 | Thailand | |||
3701519 | 3701519 | 2020-04-02 | France | Guadeloupe | 128 | 6 | 24 | 98 | 16.265 | -61.551 | 4/2/20 23:25 | Guadeloupe, France | ||
3701611 | 3701611 | 2020-04-02 | Cabo Verde | 6 | 1 | 0 | 5 | 16.5388 | -23.0418 | 4/2/20 23:25 | Cabo Verde | |||
3701541 | 3701541 | 2020-04-02 | United Kingdom | Montserrat | 5 | 0 | 0 | 5 | 16.742498 | -62.187366 | 4/2/20 23:25 | Montserrat, United Kingdom | ||
3701588 | 3701588 | 2020-04-02 | Antigua and Barbuda | 9 | 0 | 0 | 9 | 17.0608 | -61.7964 | 4/2/20 23:25 | Antigua and Barbuda | |||
3701599 | 3701599 | 2020-04-02 | Belize | 3 | 0 | 0 | 3 | 17.1899 | -88.4976 | 4/2/20 23:25 | ,,Belize |
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]);