johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,680 rows where "last_update" is on date 2020-06-03 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
Link | rowid | day | country_or_region | province_or_state ▼ | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2556047 | 2556047 | 2020-06-02 | Afghanistan | 16578 | 274 | 1450 | 14854 | 33.93911 | 67.709953 | 2020-06-03 02:33:13 | Afghanistan | |||
2556048 | 2556048 | 2020-06-02 | Albania | 1164 | 33 | 891 | 240 | 41.1533 | 20.1683 | 2020-06-03 02:33:13 | Albania | |||
2556049 | 2556049 | 2020-06-02 | Algeria | 9626 | 667 | 6067 | 2892 | 28.0339 | 1.6596 | 2020-06-03 02:33:13 | Algeria | |||
2556050 | 2556050 | 2020-06-02 | Andorra | 844 | 51 | 733 | 60 | 42.5063 | 1.5218 | 2020-06-03 02:33:13 | Andorra | |||
2556051 | 2556051 | 2020-06-02 | Angola | 86 | 4 | 18 | 64 | -11.2027 | 17.8739 | 2020-06-03 02:33:13 | Angola | |||
2556052 | 2556052 | 2020-06-02 | Antigua and Barbuda | 26 | 3 | 20 | 3 | 17.0608 | -61.7964 | 2020-06-03 02:33:13 | Antigua and Barbuda | |||
2556053 | 2556053 | 2020-06-02 | Argentina | 18319 | 569 | 5709 | 12041 | -38.4161 | -63.6167 | 2020-06-03 02:33:13 | Argentina | |||
2556054 | 2556054 | 2020-06-02 | Armenia | 10009 | 158 | 3427 | 6424 | 40.0691 | 45.0382 | 2020-06-03 02:33:13 | Armenia | |||
2556055 | 2556055 | 2020-06-02 | Austria | 16647 | 745 | 15629 | 461 | 47.5162 | 14.5501 | 2020-06-03 02:33:13 | Austria | |||
2556056 | 2556056 | 2020-06-02 | Azerbaijan | 5935 | 71 | 3564 | 2300 | 40.1431 | 47.5769 | 2020-06-03 02:33:13 | Azerbaijan | |||
2556057 | 2556057 | 2020-06-02 | Bahamas | 102 | 11 | 49 | 42 | 25.025885 | -78.035889 | 2020-06-03 02:33:13 | Bahamas | |||
2556058 | 2556058 | 2020-06-02 | Bahrain | 12311 | 19 | 7407 | 4885 | 26.0275 | 50.55 | 2020-06-03 02:33:13 | Bahrain | |||
2556059 | 2556059 | 2020-06-02 | Bangladesh | 52445 | 709 | 11120 | 40616 | 23.685 | 90.3563 | 2020-06-03 02:33:13 | Bangladesh | |||
2556060 | 2556060 | 2020-06-02 | Barbados | 92 | 7 | 76 | 9 | 13.1939 | -59.5432 | 2020-06-03 02:33:13 | Barbados | |||
2556061 | 2556061 | 2020-06-02 | Belarus | 44255 | 243 | 19195 | 24817 | 53.7098 | 27.9534 | 2020-06-03 02:33:13 | Belarus | |||
2556062 | 2556062 | 2020-06-02 | Belgium | 58615 | 9505 | 15934 | 33176 | 50.8333 | 4.469936 | 2020-06-03 02:33:13 | Belgium | |||
2556063 | 2556063 | 2020-06-02 | Belize | 18 | 2 | 16 | 0 | 17.1899 | -88.4976 | 2020-06-03 02:33:13 | Belize | |||
2556064 | 2556064 | 2020-06-02 | Benin | 244 | 3 | 148 | 93 | 9.3077 | 2.3158 | 2020-06-03 02:33:13 | Benin | |||
2556065 | 2556065 | 2020-06-02 | Bhutan | 47 | 0 | 9 | 38 | 27.5142 | 90.4336 | 2020-06-03 02:33:13 | Bhutan | |||
2556066 | 2556066 | 2020-06-02 | Bolivia | 10991 | 376 | 1298 | 9317 | -16.2902 | -63.5887 | 2020-06-03 02:33:13 | Bolivia | |||
2556067 | 2556067 | 2020-06-02 | Bosnia and Herzegovina | 2535 | 157 | 1910 | 468 | 43.9159 | 17.6791 | 2020-06-03 02:33:13 | Bosnia and Herzegovina | |||
2556068 | 2556068 | 2020-06-02 | Botswana | 40 | 1 | 23 | 16 | -22.3285 | 24.6849 | 2020-06-03 02:33:13 | Botswana | |||
2556069 | 2556069 | 2020-06-02 | Brunei | 141 | 2 | 138 | 1 | 4.5353 | 114.7277 | 2020-06-03 02:33:13 | Brunei | |||
2556070 | 2556070 | 2020-06-02 | Bulgaria | 2538 | 144 | 1123 | 1271 | 42.7339 | 25.4858 | 2020-06-03 02:33:13 | Bulgaria | |||
2556071 | 2556071 | 2020-06-02 | Burkina Faso | 881 | 53 | 720 | 108 | 12.2383 | -1.5616 | 2020-06-03 02:33:13 | Burkina Faso | |||
2556072 | 2556072 | 2020-06-02 | Burma | 232 | 6 | 143 | 83 | 21.9162 | 95.956 | 2020-06-03 02:33:13 | Burma | |||
2556073 | 2556073 | 2020-06-02 | Burundi | 63 | 1 | 33 | 29 | -3.3731 | 29.9189 | 2020-06-03 02:33:13 | Burundi | |||
2556074 | 2556074 | 2020-06-02 | Cabo Verde | 466 | 5 | 237 | 224 | 16.5388 | -23.0418 | 2020-06-03 02:33:13 | Cabo Verde | |||
2556075 | 2556075 | 2020-06-02 | Cambodia | 125 | 0 | 123 | 2 | 11.55 | 104.9167 | 2020-06-03 02:33:13 | Cambodia | |||
2556076 | 2556076 | 2020-06-02 | Cameroon | 6585 | 200 | 3676 | 2709 | 3.8480000000000003 | 11.5021 | 2020-06-03 02:33:13 | Cameroon | |||
2556077 | 2556077 | 2020-06-02 | Central African Republic | 1069 | 4 | 23 | 1042 | 6.6111 | 20.9394 | 2020-06-03 02:33:13 | Central African Republic | |||
2556078 | 2556078 | 2020-06-02 | Chad | 803 | 66 | 562 | 175 | 15.4542 | 18.7322 | 2020-06-03 02:33:13 | Chad | |||
2556079 | 2556079 | 2020-06-02 | Comoros | 132 | 2 | 27 | 103 | -11.6455 | 43.3333 | 2020-06-03 02:33:13 | Comoros | |||
2556080 | 2556080 | 2020-06-02 | Congo (Brazzaville) | 611 | 20 | 179 | 412 | -0.228 | 15.8277 | 2020-06-03 02:33:13 | Congo (Brazzaville) | |||
2556081 | 2556081 | 2020-06-02 | Congo (Kinshasa) | 3326 | 72 | 482 | 2772 | -4.0383 | 21.7587 | 2020-06-03 02:33:13 | Congo (Kinshasa) | |||
2556082 | 2556082 | 2020-06-02 | Costa Rica | 1105 | 10 | 682 | 413 | 9.7489 | -83.7534 | 2020-06-03 02:33:13 | Costa Rica | |||
2556083 | 2556083 | 2020-06-02 | Cote d'Ivoire | 3024 | 33 | 1501 | 1490 | 7.54 | -5.5471 | 2020-06-03 02:33:13 | Cote d'Ivoire | |||
2556084 | 2556084 | 2020-06-02 | Croatia | 2246 | 103 | 2088 | 55 | 45.1 | 15.2 | 2020-06-03 02:33:13 | Croatia | |||
2556085 | 2556085 | 2020-06-02 | Cuba | 2092 | 83 | 1827 | 182 | 21.521757 | -77.78116700000002 | 2020-06-03 02:33:13 | Cuba | |||
2556086 | 2556086 | 2020-06-02 | Cyprus | 949 | 17 | 790 | 142 | 35.1264 | 33.4299 | 2020-06-03 02:33:13 | Cyprus | |||
2556087 | 2556087 | 2020-06-02 | Czechia | 9364 | 323 | 6686 | 2355 | 49.8175 | 15.472999999999999 | 2020-06-03 02:33:13 | Czechia | |||
2556088 | 2556088 | 2020-06-02 | Denmark | 11734 | 580 | 10489 | 665 | 56.2639 | 9.5018 | 2020-06-03 02:33:13 | Denmark | |||
2556089 | 2556089 | 2020-06-02 | Diamond Princess | 712 | 13 | 651 | 48 | 2020-06-03 02:33:13 | Diamond Princess | |||||
2556090 | 2556090 | 2020-06-02 | Djibouti | 3779 | 25 | 1607 | 2147 | 11.8251 | 42.5903 | 2020-06-03 02:33:13 | Djibouti | |||
2556091 | 2556091 | 2020-06-02 | Dominica | 18 | 0 | 16 | 2 | 15.415 | -61.371 | 2020-06-03 02:33:13 | Dominica | |||
2556092 | 2556092 | 2020-06-02 | Dominican Republic | 17752 | 515 | 11075 | 6162 | 18.7357 | -70.1627 | 2020-06-03 02:33:13 | Dominican Republic | |||
2556093 | 2556093 | 2020-06-02 | Ecuador | 40414 | 3438 | 20019 | 16957 | -1.8312 | -78.1834 | 2020-06-03 02:33:13 | Ecuador | |||
2556094 | 2556094 | 2020-06-02 | Egypt | 27536 | 1052 | 6827 | 19657 | 26.820553000000004 | 30.802497999999996 | 2020-06-03 02:33:13 | Egypt | |||
2556095 | 2556095 | 2020-06-02 | El Salvador | 2653 | 49 | 1160 | 1444 | 13.7942 | -88.8965 | 2020-06-03 02:33:13 | El Salvador | |||
2556096 | 2556096 | 2020-06-02 | Equatorial Guinea | 1306 | 12 | 200 | 1094 | 1.6508 | 10.2679 | 2020-06-03 02:33:13 | Equatorial Guinea | |||
2556097 | 2556097 | 2020-06-02 | Eritrea | 39 | 0 | 39 | 0 | 15.1794 | 39.7823 | 2020-06-03 02:33:13 | Eritrea | |||
2556098 | 2556098 | 2020-06-02 | Estonia | 1870 | 68 | 1632 | 170 | 58.5953 | 25.0136 | 2020-06-03 02:33:13 | Estonia | |||
2556099 | 2556099 | 2020-06-02 | Eswatini | 294 | 3 | 198 | 93 | -26.5225 | 31.4659 | 2020-06-03 02:33:13 | Eswatini | |||
2556100 | 2556100 | 2020-06-02 | Ethiopia | 1344 | 14 | 231 | 1099 | 9.145 | 40.4897 | 2020-06-03 02:33:13 | Ethiopia | |||
2556101 | 2556101 | 2020-06-02 | Fiji | 18 | 0 | 15 | 3 | -17.7134 | 178.065 | 2020-06-03 02:33:13 | Fiji | |||
2556102 | 2556102 | 2020-06-02 | Finland | 7003 | 305 | 5500 | 1067 | 61.92411 | 25.748151 | 2020-06-03 02:33:13 | Finland | |||
2556103 | 2556103 | 2020-06-02 | France | 187133 | 28886 | 66485 | 91762 | 46.2276 | 2.2137 | 2020-06-03 02:33:13 | France | |||
2556104 | 2556104 | 2020-06-02 | Gabon | 2803 | 20 | 779 | 2004 | -0.8037 | 11.6094 | 2020-06-03 02:33:13 | Gabon | |||
2556105 | 2556105 | 2020-06-02 | Gambia | 25 | 1 | 20 | 4 | 13.4432 | -15.3101 | 2020-06-03 02:33:13 | Gambia | |||
2556106 | 2556106 | 2020-06-02 | Georgia | 796 | 12 | 634 | 149 | 42.3154 | 43.3569 | 2020-06-03 02:33:13 | Georgia | |||
2556107 | 2556107 | 2020-06-02 | Ghana | 8297 | 38 | 2986 | 5273 | 7.9465 | -1.0232 | 2020-06-03 02:33:13 | Ghana | |||
2556108 | 2556108 | 2020-06-02 | Greece | 2937 | 179 | 1374 | 1384 | 39.0742 | 21.8243 | 2020-06-03 02:33:13 | Greece | |||
2556109 | 2556109 | 2020-06-02 | Grenada | 23 | 0 | 18 | 5 | 12.1165 | -61.678999999999995 | 2020-06-03 02:33:13 | Grenada | |||
2556110 | 2556110 | 2020-06-02 | Guatemala | 5586 | 123 | 824 | 4639 | 15.7835 | -90.2308 | 2020-06-03 02:33:13 | Guatemala | |||
2556111 | 2556111 | 2020-06-02 | Guinea | 3886 | 23 | 2267 | 1596 | 9.9456 | -9.6966 | 2020-06-03 02:33:13 | Guinea | |||
2556112 | 2556112 | 2020-06-02 | Guinea-Bissau | 1339 | 8 | 53 | 1278 | 11.8037 | -15.1804 | 2020-06-03 02:33:13 | Guinea-Bissau | |||
2556113 | 2556113 | 2020-06-02 | Guyana | 153 | 12 | 70 | 71 | 4.860416000000002 | -58.93018000000001 | 2020-06-03 02:33:13 | Guyana | |||
2556114 | 2556114 | 2020-06-02 | Haiti | 2124 | 44 | 24 | 2056 | 18.9712 | -72.2852 | 2020-06-03 02:33:13 | Haiti | |||
2556115 | 2556115 | 2020-06-02 | Holy See | 12 | 0 | 2 | 10 | 41.9029 | 12.4534 | 2020-06-03 02:33:13 | Holy See | |||
2556116 | 2556116 | 2020-06-02 | Honduras | 5527 | 225 | 563 | 4739 | 15.2 | -86.2419 | 2020-06-03 02:33:13 | Honduras | |||
2556117 | 2556117 | 2020-06-02 | Hungary | 3921 | 532 | 2160 | 1229 | 47.1625 | 19.5033 | 2020-06-03 02:33:13 | Hungary | |||
2556118 | 2556118 | 2020-06-02 | Iceland | 1806 | 10 | 1794 | 2 | 64.9631 | -19.0208 | 2020-06-03 02:33:13 | Iceland | |||
2556119 | 2556119 | 2020-06-02 | India | 207191 | 5829 | 100285 | 101077 | 20.593684 | 78.96288 | 2020-06-03 02:33:13 | India | |||
2556120 | 2556120 | 2020-06-02 | Indonesia | 27549 | 1663 | 7935 | 17951 | -0.7893 | 113.9213 | 2020-06-03 02:33:13 | Indonesia | |||
2556121 | 2556121 | 2020-06-02 | Iran | 157562 | 7942 | 123077 | 26543 | 32.427908 | 53.68804599999999 | 2020-06-03 02:33:13 | Iran | |||
2556122 | 2556122 | 2020-06-02 | Iraq | 7387 | 235 | 3508 | 3644 | 33.223191 | 43.679291 | 2020-06-03 02:33:13 | Iraq | |||
2556123 | 2556123 | 2020-06-02 | Ireland | 25066 | 1658 | 22089 | 1319 | 53.1424 | -7.6921 | 2020-06-03 02:33:13 | Ireland | |||
2556124 | 2556124 | 2020-06-02 | Israel | 17300 | 292 | 14821 | 2187 | 31.046051000000002 | 34.851612 | 2020-06-03 02:33:13 | Israel | |||
2556125 | 2556125 | 2020-06-02 | Jamaica | 590 | 9 | 356 | 225 | 18.1096 | -77.2975 | 2020-06-03 02:33:13 | Jamaica | |||
2556126 | 2556126 | 2020-06-02 | Jordan | 755 | 9 | 549 | 197 | 31.24 | 36.51 | 2020-06-03 02:33:13 | Jordan | |||
2556127 | 2556127 | 2020-06-02 | Kazakhstan | 11571 | 44 | 5941 | 5586 | 48.0196 | 66.9237 | 2020-06-03 02:33:13 | Kazakhstan | |||
2556128 | 2556128 | 2020-06-02 | Kenya | 2093 | 71 | 499 | 1523 | -0.0236 | 37.9062 | 2020-06-03 02:33:13 | Kenya | |||
2556129 | 2556129 | 2020-06-02 | Korea, South | 11590 | 273 | 10467 | 850 | 35.90775700000001 | 127.766922 | 2020-06-03 02:33:13 | Korea, South | |||
2556130 | 2556130 | 2020-06-02 | Kosovo | 1064 | 30 | 829 | 205 | 42.602636 | 20.902977 | 2020-06-03 02:33:13 | Kosovo | |||
2556131 | 2556131 | 2020-06-02 | Kuwait | 28649 | 226 | 14281 | 14142 | 29.311659999999996 | 47.481766 | 2020-06-03 02:33:13 | Kuwait | |||
2556132 | 2556132 | 2020-06-02 | Kyrgyzstan | 1845 | 17 | 1219 | 609 | 41.20438 | 74.766098 | 2020-06-03 02:33:13 | Kyrgyzstan | |||
2556133 | 2556133 | 2020-06-02 | Laos | 19 | 0 | 16 | 3 | 19.856270000000002 | 102.495496 | 2020-06-03 02:33:13 | Laos | |||
2556134 | 2556134 | 2020-06-02 | Latvia | 1071 | 24 | 760 | 287 | 56.8796 | 24.6032 | 2020-06-03 02:33:13 | Latvia | |||
2556135 | 2556135 | 2020-06-02 | Lebanon | 1242 | 27 | 719 | 496 | 33.8547 | 35.8623 | 2020-06-03 02:33:13 | Lebanon | |||
2556136 | 2556136 | 2020-06-02 | Lesotho | 2 | 0 | 1 | 1 | -29.609988 | 28.233608 | 2020-06-03 02:33:13 | Lesotho | |||
2556137 | 2556137 | 2020-06-02 | Liberia | 296 | 27 | 167 | 102 | 6.4280550000000005 | -9.429499 | 2020-06-03 02:33:13 | Liberia | |||
2556138 | 2556138 | 2020-06-02 | Libya | 182 | 5 | 52 | 125 | 26.3351 | 17.228331 | 2020-06-03 02:33:13 | Libya | |||
2556139 | 2556139 | 2020-06-02 | Liechtenstein | 83 | 1 | 55 | 27 | 47.14 | 9.55 | 2020-06-03 02:33:13 | Liechtenstein | |||
2556140 | 2556140 | 2020-06-02 | Lithuania | 1615 | 55 | 1291 | 330 | 55.1694 | 23.8813 | 2020-06-03 02:33:13 | Lithuania | |||
2556141 | 2556141 | 2020-06-02 | Luxembourg | 4020 | 110 | 3848 | 62 | 49.8153 | 6.1296 | 2020-06-03 02:33:13 | Luxembourg | |||
2556142 | 2556142 | 2020-06-02 | MS Zaandam | 9 | 2 | 0 | 7 | 2020-06-03 02:33:13 | MS Zaandam | |||||
2556143 | 2556143 | 2020-06-02 | Madagascar | 845 | 6 | 185 | 654 | -18.766947000000002 | 46.869107 | 2020-06-03 02:33:13 | Madagascar | |||
2556144 | 2556144 | 2020-06-02 | Malawi | 358 | 4 | 42 | 312 | -13.254307999999998 | 34.301525 | 2020-06-03 02:33:13 | Malawi | |||
2556145 | 2556145 | 2020-06-02 | Maldives | 1841 | 7 | 608 | 1226 | 3.2028 | 73.2207 | 2020-06-03 02:33:13 | Maldives | |||
2556146 | 2556146 | 2020-06-02 | Mali | 1351 | 78 | 769 | 504 | 17.570692 | -3.996166000000001 | 2020-06-03 02:33:13 | Mali |
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]);