johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,473 rows where "day" is on date 2020-03-29 sorted by province_or_state
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2875669 | 2875669 | 2020-03-29 | Afghanistan | 114 | 4 | 2 | 108 | 33.93911 | 67.709953 | 3/29/20 23:08 | Afghanistan | |||
2875670 | 2875670 | 2020-03-29 | Albania | 212 | 10 | 33 | 169 | 41.1533 | 20.1683 | 3/29/20 23:08 | Albania | |||
2875671 | 2875671 | 2020-03-29 | Algeria | 511 | 31 | 31 | 449 | 28.0339 | 1.6596 | 3/29/20 23:08 | Algeria | |||
2875672 | 2875672 | 2020-03-29 | Andorra | 334 | 6 | 1 | 327 | 42.5063 | 1.5218 | 3/29/20 23:08 | Andorra | |||
2875673 | 2875673 | 2020-03-29 | Angola | 7 | 2 | 0 | 5 | -11.2027 | 17.8739 | 3/29/20 23:08 | Angola | |||
2875674 | 2875674 | 2020-03-29 | Antigua and Barbuda | 7 | 0 | 0 | 7 | 17.0608 | -61.7964 | 3/29/20 23:08 | Antigua and Barbuda | |||
2875675 | 2875675 | 2020-03-29 | Argentina | 745 | 19 | 72 | 654 | -38.4161 | -63.6167 | 3/29/20 23:08 | Argentina | |||
2875676 | 2875676 | 2020-03-29 | Armenia | 424 | 3 | 30 | 391 | 40.0691 | 45.0382 | 3/29/20 23:08 | Armenia | |||
2875677 | 2875677 | 2020-03-29 | Austria | 8100 | 101 | 479 | 8223 | 47.5162 | 14.5501 | 3/29/20 23:08 | Austria | |||
2875678 | 2875678 | 2020-03-29 | Azerbaijan | 209 | 4 | 15 | 190 | 40.1431 | 47.5769 | 3/29/20 23:08 | Azerbaijan | |||
2875679 | 2875679 | 2020-03-29 | Bahamas | 11 | 0 | 1 | 10 | 25.025885 | -78.035889 | 3/29/20 23:08 | Bahamas | |||
2875680 | 2875680 | 2020-03-29 | Bahrain | 499 | 4 | 272 | 223 | 26.0275 | 50.55 | 3/29/20 23:08 | Bahrain | |||
2875681 | 2875681 | 2020-03-29 | Bangladesh | 48 | 5 | 15 | 28 | 23.685 | 90.3563 | 3/29/20 23:08 | Bangladesh | |||
2875682 | 2875682 | 2020-03-29 | Barbados | 33 | 0 | 0 | 33 | 13.1939 | -59.5432 | 3/29/20 23:08 | Barbados | |||
2875683 | 2875683 | 2020-03-29 | Belarus | 94 | 0 | 32 | 62 | 53.7098 | 27.9534 | 3/29/20 23:08 | Belarus | |||
2875684 | 2875684 | 2020-03-29 | Belgium | 10836 | 431 | 1359 | 9046 | 50.8333 | 4.469936 | 3/29/20 23:08 | Belgium | |||
2875685 | 2875685 | 2020-03-29 | Belize | 2 | 0 | 0 | 2 | 17.1899 | -88.4976 | 3/29/20 23:08 | ,,Belize | |||
2875686 | 2875686 | 2020-03-29 | Benin | 6 | 0 | 0 | 6 | 9.3077 | 2.3158 | 3/29/20 23:08 | Benin | |||
2875687 | 2875687 | 2020-03-29 | Bhutan | 4 | 0 | 0 | 4 | 27.5142 | 90.4336 | 3/29/20 23:08 | Bhutan | |||
2875688 | 2875688 | 2020-03-29 | Bolivia | 81 | 1 | 0 | 80 | -16.2902 | -63.5887 | 3/29/20 23:08 | Bolivia | |||
2875689 | 2875689 | 2020-03-29 | Bosnia and Herzegovina | 323 | 6 | 8 | 309 | 43.9159 | 17.6791 | 3/29/20 23:08 | Bosnia and Herzegovina | |||
2875690 | 2875690 | 2020-03-29 | Brazil | 4256 | 136 | 6 | 4114 | -14.235 | -51.9253 | 3/29/20 23:08 | Brazil | |||
2875691 | 2875691 | 2020-03-29 | Brunei | 126 | 1 | 34 | 91 | 4.5353 | 114.7277 | 3/29/20 23:08 | Brunei | |||
2875692 | 2875692 | 2020-03-29 | Bulgaria | 346 | 8 | 14 | 324 | 42.7339 | 25.4858 | 3/29/20 23:08 | Bulgaria | |||
2875693 | 2875693 | 2020-03-29 | Burkina Faso | 222 | 12 | 23 | 187 | 12.2383 | -1.5616 | 3/29/20 23:08 | Burkina Faso | |||
2875694 | 2875694 | 2020-03-29 | Burma | 10 | 0 | 0 | 10 | 21.9162 | 95.956 | 3/29/20 23:08 | Burma | |||
2875695 | 2875695 | 2020-03-29 | Cabo Verde | 6 | 1 | 0 | 5 | 16.5388 | -23.0418 | 3/29/20 23:08 | Cabo Verde | |||
2875696 | 2875696 | 2020-03-29 | Cambodia | 103 | 0 | 21 | 82 | 11.55 | 104.9167 | 3/29/20 23:08 | Cambodia | |||
2875697 | 2875697 | 2020-03-29 | Cameroon | 139 | 6 | 5 | 128 | 3.848 | 11.5021 | 3/29/20 23:08 | Cameroon | |||
2875698 | 2875698 | 2020-03-29 | Central African Republic | 3 | 0 | 0 | 3 | 6.6111 | 20.9394 | 3/29/20 23:08 | Central African Republic | |||
2875699 | 2875699 | 2020-03-29 | Chad | 3 | 0 | 0 | 3 | 15.4542 | 18.7322 | 3/29/20 23:08 | Chad | |||
2875700 | 2875700 | 2020-03-29 | Chile | 2139 | 7 | 75 | 2057 | -35.6751 | -71.543 | 3/29/20 23:08 | Chile | |||
2875701 | 2875701 | 2020-03-29 | Colombia | 702 | 10 | 10 | 682 | 4.5709 | -74.2973 | 3/29/20 23:08 | Colombia | |||
2875702 | 2875702 | 2020-03-29 | Congo (Brazzaville) | 19 | 0 | 0 | 19 | -4.2634 | 15.2832 | 3/29/20 23:08 | Congo (Brazzaville) | |||
2875703 | 2875703 | 2020-03-29 | Congo (Kinshasa) | 65 | 6 | 2 | 57 | -4.322447 | 15.307045 | 3/29/20 23:08 | Congo (Kinshasa) | |||
2875704 | 2875704 | 2020-03-29 | Costa Rica | 314 | 2 | 3 | 309 | 9.7489 | -83.7534 | 3/29/20 23:08 | Costa Rica | |||
2875705 | 2875705 | 2020-03-29 | Cote d'Ivoire | 165 | 1 | 4 | 160 | 7.54 | -5.5471 | 3/29/20 23:08 | Cote d'Ivoire | |||
2875706 | 2875706 | 2020-03-29 | Croatia | 713 | 6 | 52 | 655 | 45.1 | 15.2 | 3/29/20 23:08 | Croatia | |||
2875707 | 2875707 | 2020-03-29 | Cuba | 139 | 3 | 4 | 132 | 21.521757 | -77.781167 | 3/29/20 23:08 | Cuba | |||
2875708 | 2875708 | 2020-03-29 | Cyprus | 179 | 5 | 15 | 159 | 35.1264 | 33.4299 | 3/29/20 23:08 | Cyprus | |||
2875709 | 2875709 | 2020-03-29 | Czechia | 2817 | 16 | 11 | 2790 | 49.8175 | 15.473 | 3/29/20 23:08 | Czechia | |||
2875710 | 2875710 | 2020-03-29 | Denmark | 2395 | 72 | 1 | 2322 | 56.2639 | 9.5018 | 3/29/20 23:08 | Denmark | |||
2875711 | 2875711 | 2020-03-29 | Diamond Princess | 712 | 10 | 603 | 99 | 0.0 | 0.0 | 3/29/20 23:08 | Diamond Princess | |||
2875712 | 2875712 | 2020-03-29 | Djibouti | 18 | 0 | 0 | 18 | 11.8251 | 42.5903 | 3/29/20 23:08 | Djibouti | |||
2875713 | 2875713 | 2020-03-29 | Dominica | 11 | 0 | 0 | 11 | 15.415 | -61.371 | 3/29/20 23:08 | Dominica | |||
2875714 | 2875714 | 2020-03-29 | Dominican Republic | 859 | 39 | 3 | 817 | 18.7357 | -70.1627 | 3/29/20 23:08 | Dominican Republic | |||
2875715 | 2875715 | 2020-03-29 | Ecuador | 1924 | 58 | 3 | 1863 | -1.8312 | -78.1834 | 3/29/20 23:08 | Ecuador | |||
2875716 | 2875716 | 2020-03-29 | Egypt | 609 | 40 | 132 | 437 | 26.820553 | 30.802498 | 3/29/20 23:08 | Egypt | |||
2875717 | 2875717 | 2020-03-29 | El Salvador | 24 | 0 | 0 | 24 | 13.7942 | -88.8965 | 3/29/20 23:08 | El Salvador | |||
2875718 | 2875718 | 2020-03-29 | Equatorial Guinea | 12 | 0 | 0 | 12 | 1.6508 | 10.2679 | 3/29/20 23:08 | Equatorial Guinea | |||
2875719 | 2875719 | 2020-03-29 | Eritrea | 12 | 0 | 0 | 12 | 15.1794 | 39.7823 | 3/29/20 23:08 | Eritrea | |||
2875720 | 2875720 | 2020-03-29 | Estonia | 679 | 3 | 20 | 656 | 58.5953 | 25.0136 | 3/29/20 23:08 | Estonia | |||
2875721 | 2875721 | 2020-03-29 | Eswatini | 9 | 0 | 0 | 9 | -26.5225 | 31.4659 | 3/29/20 23:08 | Eswatini | |||
2875722 | 2875722 | 2020-03-29 | Ethiopia | 21 | 0 | 1 | 20 | 9.145 | 40.4897 | 3/29/20 23:08 | Ethiopia | |||
2875723 | 2875723 | 2020-03-29 | Fiji | 5 | 0 | 0 | 5 | -17.7134 | 178.065 | 3/29/20 23:08 | Fiji | |||
2875724 | 2875724 | 2020-03-29 | Finland | 1473 | 31 | 10 | 1219 | 61.92411 | 25.748151 | 3/29/20 23:08 | Finland | |||
2875725 | 2875725 | 2020-03-29 | France | 39761 | 2603 | 7202 | 29956 | 46.2276 | 2.2137 | 3/29/20 23:08 | France | |||
2875726 | 2875726 | 2020-03-29 | Gabon | 7 | 1 | 0 | 6 | -0.8037 | 11.6094 | 3/29/20 23:08 | Gabon | |||
2875727 | 2875727 | 2020-03-29 | Gambia | 4 | 1 | 0 | 3 | 13.4432 | -15.3101 | 3/29/20 23:08 | Gambia | |||
2875728 | 2875728 | 2020-03-29 | Georgia | 91 | 0 | 18 | 73 | 42.3154 | 43.3569 | 3/29/20 23:08 | Georgia | |||
2875729 | 2875729 | 2020-03-29 | Germany | 62095 | 533 | 9211 | 52351 | 51.165691 | 10.451526 | 3/29/20 23:08 | Germany | |||
2875730 | 2875730 | 2020-03-29 | Ghana | 152 | 5 | 2 | 145 | 7.9465 | -1.0232 | 3/29/20 23:08 | Ghana | |||
2875731 | 2875731 | 2020-03-29 | Greece | 1156 | 38 | 52 | 1066 | 39.0742 | 21.8243 | 3/29/20 23:08 | Greece | |||
2875732 | 2875732 | 2020-03-29 | Grenada | 9 | 0 | 0 | 9 | 12.1165 | -61.679 | 3/29/20 23:08 | Grenada | |||
2875733 | 2875733 | 2020-03-29 | Guatemala | 34 | 1 | 10 | 23 | 15.7835 | -90.2308 | 3/29/20 23:08 | Guatemala | |||
2875734 | 2875734 | 2020-03-29 | Guinea | 16 | 0 | 0 | 16 | 9.9456 | -9.6966 | 3/29/20 23:08 | Guinea | |||
2875735 | 2875735 | 2020-03-29 | Guinea-Bissau | 2 | 0 | 0 | 2 | 11.8037 | -15.1804 | 3/29/20 23:08 | Guinea-Bissau | |||
2875736 | 2875736 | 2020-03-29 | Guyana | 8 | 1 | 0 | 7 | 4.860416 | -58.93018 | 3/29/20 23:08 | Guyana | |||
2875737 | 2875737 | 2020-03-29 | Haiti | 8 | 0 | 1 | 7 | 18.9712 | -72.2852 | 3/29/20 23:08 | Haiti | |||
2875738 | 2875738 | 2020-03-29 | Holy See | 6 | 0 | 0 | 6 | 41.9029 | 12.4534 | 3/29/20 23:08 | Holy See | |||
2875739 | 2875739 | 2020-03-29 | Honduras | 110 | 3 | 3 | 104 | 15.2 | -86.2419 | 3/29/20 23:08 | Honduras | |||
2875740 | 2875740 | 2020-03-29 | Hungary | 408 | 13 | 34 | 361 | 47.1625 | 19.5033 | 3/29/20 23:08 | Hungary | |||
2875741 | 2875741 | 2020-03-29 | Iceland | 1020 | 2 | 135 | 883 | 64.9631 | -19.0208 | 3/29/20 23:08 | Iceland | |||
2875742 | 2875742 | 2020-03-29 | India | 1024 | 27 | 95 | 902 | 20.593684 | 78.96288 | 3/29/20 23:08 | India | |||
2875743 | 2875743 | 2020-03-29 | Indonesia | 1285 | 114 | 64 | 1107 | -0.7893 | 113.9213 | 3/29/20 23:08 | Indonesia | |||
2875744 | 2875744 | 2020-03-29 | Iran | 38309 | 2640 | 12391 | 23278 | 32.427908 | 53.688046 | 3/29/20 23:08 | Iran | |||
2875745 | 2875745 | 2020-03-29 | Iraq | 547 | 42 | 143 | 362 | 33.223191 | 43.679291 | 3/29/20 23:08 | Iraq | |||
2875746 | 2875746 | 2020-03-29 | Ireland | 2615 | 46 | 5 | 2564 | 53.1424 | -7.6921 | 3/29/20 23:08 | Ireland | |||
2875747 | 2875747 | 2020-03-29 | Israel | 4433 | 16 | 105 | 4312 | 31.046051 | 34.851612 | 3/29/20 23:08 | Israel | |||
2875748 | 2875748 | 2020-03-29 | Italy | 97689 | 10779 | 13030 | 73880 | 41.87194 | 12.56738 | 3/29/20 23:08 | Italy | |||
2875749 | 2875749 | 2020-03-29 | Jamaica | 32 | 1 | 2 | 29 | 18.1096 | -77.2975 | 3/29/20 23:08 | Jamaica | |||
2875750 | 2875750 | 2020-03-29 | Japan | 1866 | 54 | 424 | 1388 | 36.204824 | 138.252924 | 3/29/20 23:08 | Japan | |||
2875751 | 2875751 | 2020-03-29 | Jordan | 259 | 3 | 18 | 238 | 31.24 | 36.51 | 3/29/20 23:08 | Jordan | |||
2875752 | 2875752 | 2020-03-29 | Kazakhstan | 284 | 1 | 20 | 263 | 48.0196 | 66.9237 | 3/29/20 23:08 | Kazakhstan | |||
2875753 | 2875753 | 2020-03-29 | Kenya | 42 | 1 | 1 | 40 | -0.0236 | 37.9062 | 3/29/20 23:08 | Kenya | |||
2875754 | 2875754 | 2020-03-29 | Korea, South | 9583 | 152 | 5033 | 4398 | 35.907757 | 127.766922 | 3/29/20 23:08 | Korea, South | |||
2875755 | 2875755 | 2020-03-29 | Kosovo | 94 | 1 | 1 | 92 | 42.602636 | 20.902977 | 3/29/20 23:08 | Kosovo | |||
2875756 | 2875756 | 2020-03-29 | Kuwait | 255 | 0 | 67 | 188 | 29.31166 | 47.481766 | 3/29/20 23:08 | Kuwait | |||
2875757 | 2875757 | 2020-03-29 | Kyrgyzstan | 84 | 0 | 0 | 84 | 41.20438 | 74.766098 | 3/29/20 23:08 | Kyrgyzstan | |||
2875758 | 2875758 | 2020-03-29 | Laos | 8 | 0 | 0 | 8 | 19.85627 | 102.495496 | 3/29/20 23:08 | Laos | |||
2875759 | 2875759 | 2020-03-29 | Latvia | 347 | 0 | 1 | 346 | 56.8796 | 24.6032 | 3/29/20 23:08 | Latvia | |||
2875760 | 2875760 | 2020-03-29 | Lebanon | 438 | 10 | 30 | 398 | 33.8547 | 35.8623 | 3/29/20 23:08 | Lebanon | |||
2875761 | 2875761 | 2020-03-29 | Liberia | 3 | 0 | 0 | 3 | 6.428055 | -9.429499 | 3/29/20 23:08 | Liberia | |||
2875762 | 2875762 | 2020-03-29 | Libya | 8 | 0 | 0 | 8 | 26.3351 | 17.228331 | 3/29/20 23:08 | Libya | |||
2875763 | 2875763 | 2020-03-29 | Liechtenstein | 63 | 0 | 0 | 63 | 47.14 | 9.55 | 3/29/20 23:08 | Liechtenstein | |||
2875764 | 2875764 | 2020-03-29 | Lithuania | 263 | 4 | 0 | 374 | 55.1694 | 23.8813 | 3/29/20 23:08 | Lithuania | |||
2875765 | 2875765 | 2020-03-29 | Luxembourg | 1950 | 21 | 40 | 1889 | 49.8153 | 6.1296 | 3/29/20 23:08 | Luxembourg | |||
2875766 | 2875766 | 2020-03-29 | MS Zaandam | 2 | 0 | 0 | 2 | 0.0 | 0.0 | 3/29/20 23:08 | ,,MS Zaandam | |||
2875767 | 2875767 | 2020-03-29 | Madagascar | 39 | 0 | 0 | 39 | -18.766947 | 46.869107 | 3/29/20 23:08 | Madagascar | |||
2875768 | 2875768 | 2020-03-29 | Maldives | 17 | 0 | 13 | 4 | 3.2028 | 73.2207 | 3/29/20 23:08 | Maldives |
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]);