johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3895732 | 3895732 | 2022-05-19 | Chile | Biobio | 357193 | 4289 | 0 | -37.4464 | -72.1416 | 2022-05-20 04:20:57 | Biobio, Chile | |||
3895733 | 3895733 | 2022-05-19 | Chile | Coquimbo | 128895 | 1679 | 0 | -29.959 | -71.3389 | 2022-05-20 04:20:57 | Coquimbo, Chile | |||
3895734 | 3895734 | 2022-05-19 | Chile | Los Lagos | 195948 | 2322 | 0 | -41.9198 | -72.1416 | 2022-05-20 04:20:57 | Los Lagos, Chile | |||
3895735 | 3895735 | 2022-05-19 | Chile | Los Rios | 106702 | 1225 | 0 | -40.231 | -72.3311 | 2022-05-20 04:20:57 | Los Rios, Chile | |||
3895736 | 3895736 | 2022-05-19 | Chile | Magallanes | 52456 | 704 | 0 | -52.368 | -70.9863 | 2022-05-20 04:20:57 | Magallanes, Chile | |||
3895737 | 3895737 | 2022-05-19 | Chile | Maule | 242774 | 2926 | 0 | -35.5183 | -71.6885 | 2022-05-20 04:20:57 | Maule, Chile | |||
3895738 | 3895738 | 2022-05-19 | Chile | Metropolitana | 1400235 | 28349 | 0 | -33.4376 | -70.6505 | 2022-05-20 04:20:57 | Metropolitana, Chile | |||
3895739 | 3895739 | 2022-05-19 | Chile | Nuble | 101891 | 1113 | 0 | -36.7226 | -71.7622 | 2022-05-20 04:20:57 | Nuble, Chile | |||
3895740 | 3895740 | 2022-05-19 | Chile | OHiggins | 152397 | 2522 | 0 | -34.5755 | -71.0022 | 2022-05-20 04:20:57 | OHiggins, Chile | |||
3895741 | 3895741 | 2022-05-19 | Chile | Tarapaca | 80140 | 1087 | 0 | -19.9232 | -69.5132 | 2022-05-20 04:20:57 | Tarapaca, Chile | |||
3895742 | 3895742 | 2022-05-19 | Chile | Unknown | 43 | 2 | 0 | 2022-05-20 04:20:57 | Unknown, Chile | |||||
3895743 | 3895743 | 2022-05-19 | Chile | Valparaiso | 314757 | 5623 | 0 | -33.0472 | -71.6127 | 2022-05-20 04:20:57 | Valparaiso, Chile | |||
3895744 | 3895744 | 2022-05-19 | China | Anhui | 1065 | 6 | 0 | 31.8257 | 117.2264 | 2022-05-20 04:20:57 | Anhui, China | |||
3895745 | 3895745 | 2022-05-19 | China | Beijing | 2975 | 9 | 0 | 40.1824 | 116.4142 | 2022-05-20 04:20:57 | Beijing, China | |||
3895746 | 3895746 | 2022-05-19 | China | Chongqing | 708 | 6 | 0 | 30.0572 | 107.874 | 2022-05-20 04:20:57 | Chongqing, China | |||
3895747 | 3895747 | 2022-05-19 | China | Fujian | 3163 | 1 | 0 | 26.0789 | 117.9874 | 2022-05-20 04:20:57 | Fujian, China | |||
3895748 | 3895748 | 2022-05-19 | China | Gansu | 681 | 2 | 0 | 35.7518 | 104.2861 | 2022-05-20 04:20:57 | Gansu, China | |||
3895749 | 3895749 | 2022-05-19 | China | Guangdong | 7274 | 8 | 0 | 23.3417 | 113.4244 | 2022-05-20 04:20:57 | Guangdong, China | |||
3895750 | 3895750 | 2022-05-19 | China | Guangxi | 1613 | 2 | 0 | 23.8298 | 108.7881 | 2022-05-20 04:20:57 | Guangxi, China | |||
3895751 | 3895751 | 2022-05-19 | China | Guizhou | 185 | 2 | 0 | 26.8154 | 106.8748 | 2022-05-20 04:20:57 | Guizhou, China | |||
3895752 | 3895752 | 2022-05-19 | China | Hainan | 288 | 6 | 0 | 19.1959 | 109.7453 | 2022-05-20 04:20:57 | Hainan, China | |||
3895753 | 3895753 | 2022-05-19 | China | Hebei | 2004 | 7 | 0 | 37.8957 | 114.9042 | 2022-05-20 04:20:57 | Hebei, China | |||
3895754 | 3895754 | 2022-05-19 | China | Heilongjiang | 2983 | 13 | 0 | 47.862 | 127.7615 | 2022-05-20 04:20:57 | Heilongjiang, China | |||
3895755 | 3895755 | 2022-05-19 | China | Henan | 3159 | 22 | 0 | 33.882 | 113.614 | 2022-05-20 04:20:57 | Henan, China | |||
3895756 | 3895756 | 2022-05-19 | China | Hong Kong | 1209688 | 9366 | 0 | 22.3 | 114.2 | 2022-05-20 04:20:57 | Hong Kong, China | |||
3895757 | 3895757 | 2022-05-19 | China | Hubei | 68398 | 4512 | 0 | 30.9756 | 112.2707 | 2022-05-20 04:20:57 | Hubei, China | |||
3895758 | 3895758 | 2022-05-19 | China | Hunan | 1393 | 4 | 0 | 27.6104 | 111.7088 | 2022-05-20 04:20:57 | Hunan, China | |||
3895759 | 3895759 | 2022-05-19 | China | Inner Mongolia | 1753 | 1 | 0 | 44.0935 | 113.9448 | 2022-05-20 04:20:57 | Inner Mongolia, China | |||
3895760 | 3895760 | 2022-05-19 | China | Jiangsu | 2220 | 0 | 0 | 32.9711 | 119.455 | 2022-05-20 04:20:57 | Jiangsu, China | |||
3895761 | 3895761 | 2022-05-19 | China | Jiangxi | 1383 | 1 | 0 | 27.614 | 115.7221 | 2022-05-20 04:20:57 | Jiangxi, China | |||
3895762 | 3895762 | 2022-05-19 | China | Jilin | 40284 | 5 | 0 | 43.6661 | 126.1923 | 2022-05-20 04:20:57 | Jilin, China | |||
3895763 | 3895763 | 2022-05-19 | China | Liaoning | 1671 | 2 | 0 | 41.2956 | 122.6085 | 2022-05-20 04:20:57 | Liaoning, China | |||
3895764 | 3895764 | 2022-05-19 | China | Macau | 82 | 0 | 0 | 22.1667 | 113.55 | 2022-05-20 04:20:57 | Macau, China | |||
3895765 | 3895765 | 2022-05-19 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2022-05-20 04:20:57 | Ningxia, China | |||
3895766 | 3895766 | 2022-05-19 | China | Qinghai | 147 | 0 | 0 | 35.7452 | 95.9956 | 2022-05-20 04:20:57 | Qinghai, China | |||
3895767 | 3895767 | 2022-05-19 | China | Shaanxi | 3278 | 3 | 0 | 35.1917 | 108.8701 | 2022-05-20 04:20:57 | Shaanxi, China | |||
3895768 | 3895768 | 2022-05-19 | China | Shandong | 2735 | 7 | 0 | 36.3427 | 118.1498 | 2022-05-20 04:20:57 | Shandong, China | |||
3895769 | 3895769 | 2022-05-19 | China | Shanghai | 62523 | 587 | 0 | 31.202 | 121.4491 | 2022-05-20 04:20:57 | Shanghai, China | |||
3895770 | 3895770 | 2022-05-19 | China | Shanxi | 420 | 0 | 0 | 37.5777 | 112.2922 | 2022-05-20 04:20:57 | Shanxi, China | |||
3895771 | 3895771 | 2022-05-19 | China | Sichuan | 2232 | 3 | 0 | 30.6171 | 102.7103 | 2022-05-20 04:20:57 | Sichuan, China | |||
3895772 | 3895772 | 2022-05-19 | China | Tianjin | 1843 | 3 | 0 | 39.3054 | 117.323 | 2022-05-20 04:20:57 | Tianjin, China | |||
3895773 | 3895773 | 2022-05-19 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2022-05-20 04:20:57 | Tibet, China | |||
3895774 | 3895774 | 2022-05-19 | China | Unknown | 654332 | 0 | 0 | 2022-05-20 04:20:57 | Unknown, China | |||||
3895775 | 3895775 | 2022-05-19 | China | Xinjiang | 1008 | 3 | 0 | 41.1129 | 85.2401 | 2022-05-20 04:20:57 | Xinjiang, China | |||
3895776 | 3895776 | 2022-05-19 | China | Yunnan | 2133 | 2 | 0 | 24.974 | 101.487 | 2022-05-20 04:20:57 | Yunnan, China | |||
3895777 | 3895777 | 2022-05-19 | China | Zhejiang | 3133 | 1 | 0 | 29.1832 | 120.0934 | 2022-05-20 04:20:57 | Zhejiang, China | |||
3895778 | 3895778 | 2022-05-19 | Colombia | Amazonas | 7576 | 265 | 0 | -1.4429 | -71.5724 | 2022-05-20 04:20:57 | Amazonas, Colombia | |||
3895779 | 3895779 | 2022-05-19 | Colombia | Antioquia | 919819 | 18267 | 0 | 7.1986 | -75.3412 | 2022-05-20 04:20:57 | Antioquia, Colombia | |||
3895780 | 3895780 | 2022-05-19 | Colombia | Arauca | 16327 | 534 | 0 | 7.0762 | -70.7105 | 2022-05-20 04:20:57 | Arauca, Colombia | |||
3895781 | 3895781 | 2022-05-19 | Colombia | Atlantico | 402724 | 10130 | 0 | 10.6966 | -74.8741 | 2022-05-20 04:20:57 | Atlantico, Colombia | |||
3895782 | 3895782 | 2022-05-19 | Colombia | Bolivar | 197587 | 3241 | 0 | 8.6704 | -74.03 | 2022-05-20 04:20:57 | Bolivar, Colombia | |||
3895783 | 3895783 | 2022-05-19 | Colombia | Boyaca | 125328 | 2785 | 0 | 5.4545 | -73.362 | 2022-05-20 04:20:57 | Boyaca, Colombia | |||
3895784 | 3895784 | 2022-05-19 | Colombia | Caldas | 116985 | 2527 | 0 | 5.2983 | -75.2479 | 2022-05-20 04:20:57 | Caldas, Colombia | |||
3895785 | 3895785 | 2022-05-19 | Colombia | Capital District | 1771946 | 29374 | 0 | 4.711 | -74.0721 | 2022-05-20 04:20:57 | Capital District, Colombia | |||
3895786 | 3895786 | 2022-05-19 | Colombia | Caqueta | 24997 | 1026 | 0 | 0.8699 | -73.8419 | 2022-05-20 04:20:57 | Caqueta, Colombia | |||
3895787 | 3895787 | 2022-05-19 | Colombia | Casanare | 41795 | 1002 | 0 | 5.7589 | -71.5724 | 2022-05-20 04:20:57 | Casanare, Colombia | |||
3895788 | 3895788 | 2022-05-19 | Colombia | Cauca | 72342 | 1792 | 0 | 2.705 | -76.826 | 2022-05-20 04:20:57 | Cauca, Colombia | |||
3895789 | 3895789 | 2022-05-19 | Colombia | Cesar | 106616 | 2672 | 0 | 9.3373 | -73.6536 | 2022-05-20 04:20:57 | Cesar, Colombia | |||
3895790 | 3895790 | 2022-05-19 | Colombia | Choco | 18597 | 429 | 0 | 5.2528 | -76.826 | 2022-05-20 04:20:57 | Choco, Colombia | |||
3895791 | 3895791 | 2022-05-19 | Colombia | Cordoba | 119187 | 3931 | 0 | 8.0493 | -75.574 | 2022-05-20 04:20:57 | Cordoba, Colombia | |||
3895792 | 3895792 | 2022-05-19 | Colombia | Cundinamarca | 318653 | 7290 | 0 | 5.026 | -74.03 | 2022-05-20 04:20:57 | Cundinamarca, Colombia | |||
3895793 | 3895793 | 2022-05-19 | Colombia | Guainia | 2767 | 37 | 0 | 2.5854 | -68.5247 | 2022-05-20 04:20:57 | Guainia, Colombia | |||
3895794 | 3895794 | 2022-05-19 | Colombia | Guaviare | 5590 | 105 | 0 | 1.0654 | -73.2603 | 2022-05-20 04:20:57 | Guaviare, Colombia | |||
3895795 | 3895795 | 2022-05-19 | Colombia | Huila | 100395 | 3515 | 0 | 2.5359 | -75.5277 | 2022-05-20 04:20:57 | Huila, Colombia | |||
3895796 | 3895796 | 2022-05-19 | Colombia | La Guajira | 56379 | 1529 | 0 | 11.3548 | -72.5205 | 2022-05-20 04:20:57 | La Guajira, Colombia | |||
3895797 | 3895797 | 2022-05-19 | Colombia | Magdalena | 115093 | 3624 | 0 | 10.4113 | -74.4057 | 2022-05-20 04:20:57 | Magdalena, Colombia | |||
3895798 | 3895798 | 2022-05-19 | Colombia | Meta | 105082 | 2544 | 0 | 3.272 | -73.0877 | 2022-05-20 04:20:57 | Meta, Colombia | |||
3895799 | 3895799 | 2022-05-19 | Colombia | Narino | 104429 | 3317 | 0 | 1.2892 | -77.3579 | 2022-05-20 04:20:57 | Narino, Colombia | |||
3895800 | 3895800 | 2022-05-19 | Colombia | Norte de Santander | 119928 | 5104 | 0 | 7.9463 | -72.8988 | 2022-05-20 04:20:57 | Norte de Santander, Colombia | |||
3895801 | 3895801 | 2022-05-19 | Colombia | Putumayo | 20528 | 776 | 0 | 0.436 | -75.5277 | 2022-05-20 04:20:57 | Putumayo, Colombia | |||
3895802 | 3895802 | 2022-05-19 | Colombia | Quindio | 70854 | 2055 | 0 | 4.461 | -75.6674 | 2022-05-20 04:20:57 | Quindio, Colombia | |||
3895803 | 3895803 | 2022-05-19 | Colombia | Risaralda | 106494 | 2469 | 0 | 5.3158 | -75.9928 | 2022-05-20 04:20:57 | Risaralda, Colombia | |||
3895804 | 3895804 | 2022-05-19 | Colombia | San Andres y Providencia | 10204 | 155 | 0 | 12.5567 | -81.7185 | 2022-05-20 04:20:57 | San Andres y Providencia, Colombia | |||
3895805 | 3895805 | 2022-05-19 | Colombia | Santander | 284056 | 8177 | 0 | 6.6437 | -73.6536 | 2022-05-20 04:20:57 | Santander, Colombia | |||
3895806 | 3895806 | 2022-05-19 | Colombia | Sucre | 65726 | 1715 | 0 | 8.814 | -74.7233 | 2022-05-20 04:20:57 | Sucre, Colombia | |||
3895807 | 3895807 | 2022-05-19 | Colombia | Tolima | 124582 | 4011 | 0 | 4.0925 | -75.1545 | 2022-05-20 04:20:57 | Tolima, Colombia | |||
3895808 | 3895808 | 2022-05-19 | Colombia | Unknown | 0 | 300 | 0 | 2022-05-20 04:20:57 | Unknown, Colombia | |||||
3895809 | 3895809 | 2022-05-19 | Colombia | Valle del Cauca | 541231 | 15051 | 0 | 3.8009 | -76.6413 | 2022-05-20 04:20:57 | Valle del Cauca, Colombia | |||
3895810 | 3895810 | 2022-05-19 | Colombia | Vaupes | 1893 | 22 | 0 | 0.8554 | -70.812 | 2022-05-20 04:20:57 | Vaupes, Colombia | |||
3895811 | 3895811 | 2022-05-19 | Colombia | Vichada | 3401 | 62 | 0 | 4.4234 | -69.2878 | 2022-05-20 04:20:57 | Vichada, Colombia | |||
3895812 | 3895812 | 2022-05-19 | Comoros | 8110 | 160 | 0 | -11.6455 | 43.3333 | 2022-05-20 04:20:57 | Comoros | ||||
3895813 | 3895813 | 2022-05-19 | Congo (Brazzaville) | 24079 | 385 | 0 | -0.228 | 15.8277 | 2022-05-20 04:20:57 | Congo (Brazzaville) | ||||
3895814 | 3895814 | 2022-05-19 | Congo (Kinshasa) | 87633 | 1338 | 0 | -4.0383 | 21.7587 | 2022-05-20 04:20:57 | Congo (Kinshasa) | ||||
3895815 | 3895815 | 2022-05-19 | Costa Rica | 877533 | 8472 | 0 | 9.7489 | -83.7534 | 2022-05-20 04:20:57 | Costa Rica | ||||
3895816 | 3895816 | 2022-05-19 | Cote d'Ivoire | 82034 | 799 | 0 | 7.54 | -5.5471 | 2022-05-20 04:20:57 | Cote d'Ivoire | ||||
3895817 | 3895817 | 2022-05-19 | Croatia | 1133139 | 15950 | 0 | 45.1 | 15.2 | 2022-05-20 04:20:57 | Croatia | ||||
3895818 | 3895818 | 2022-05-19 | Cuba | 1104830 | 8529 | 0 | 21.521757 | -77.781167 | 2022-05-20 04:20:57 | Cuba | ||||
3895819 | 3895819 | 2022-05-19 | Cyprus | 486086 | 1051 | 0 | 35.1264 | 33.4299 | 2022-05-20 04:20:57 | Cyprus | ||||
3895820 | 3895820 | 2022-05-19 | Czechia | 4181475 | 40262 | 0 | 49.8175 | 15.473 | 2022-05-20 04:20:57 | Czechia | ||||
3895821 | 3895821 | 2022-05-19 | Denmark | Faroe Islands | 34658 | 28 | 0 | 61.8926 | -6.9118 | 2022-05-20 04:20:57 | Faroe Islands, Denmark | |||
3895822 | 3895822 | 2022-05-19 | Denmark | Greenland | 11971 | 21 | 0 | 71.7069 | -42.6043 | 2022-05-20 04:20:57 | Greenland, Denmark | |||
3895823 | 3895823 | 2022-05-19 | Denmark | 3130952 | 6312 | 0 | 56.2639 | 9.5018 | 2022-05-20 04:20:57 | Denmark | ||||
3895824 | 3895824 | 2022-05-19 | Diamond Princess | 712 | 13 | 0 | 2022-05-20 04:20:57 | Diamond Princess | ||||||
3895825 | 3895825 | 2022-05-19 | Djibouti | 15631 | 189 | 0 | 11.8251 | 42.5903 | 2022-05-20 04:20:57 | Djibouti | ||||
3895826 | 3895826 | 2022-05-19 | Dominica | 13116 | 63 | 0 | 15.415 | -61.371 | 2022-05-20 04:20:57 | Dominica | ||||
3895827 | 3895827 | 2022-05-19 | Dominican Republic | 581044 | 4377 | 0 | 18.7357 | -70.1627 | 2022-05-20 04:20:57 | Dominican Republic | ||||
3895828 | 3895828 | 2022-05-19 | Ecuador | 873609 | 35613 | 0 | -1.8312 | -78.1834 | 2022-05-20 04:20:57 | Ecuador | ||||
3895829 | 3895829 | 2022-05-19 | Egypt | 515645 | 24690 | 0 | 26.820553 | 30.802498 | 2022-05-20 04:20:57 | Egypt | ||||
3895830 | 3895830 | 2022-05-19 | El Salvador | 162089 | 4130 | 0 | 13.7942 | -88.8965 | 2022-05-20 04:20:57 | El Salvador | ||||
3895831 | 3895831 | 2022-05-19 | Equatorial Guinea | 15910 | 183 | 0 | 1.6508 | 10.2679 | 2022-05-20 04:20:57 | Equatorial Guinea |
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]);