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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3612836 | 3612836 | 2022-01-12 | Chile | Coquimbo | 55784 | 1107 | 0 | -29.959 | -71.3389 | 2022-01-13 08:00:09 | Coquimbo, Chile | |||
3612837 | 3612837 | 2022-01-12 | Chile | Los Lagos | 100577 | 1536 | 0 | -41.9198 | -72.1416 | 2022-01-13 08:00:09 | Los Lagos, Chile | |||
3612838 | 3612838 | 2022-01-12 | Chile | Los Rios | 54756 | 732 | 0 | -40.231 | -72.3311 | 2022-01-13 08:00:09 | Los Rios, Chile | |||
3612839 | 3612839 | 2022-01-12 | Chile | Magallanes | 31261 | 509 | 0 | -52.368 | -70.9863 | 2022-01-13 08:00:09 | Magallanes, Chile | |||
3612840 | 3612840 | 2022-01-12 | Chile | Maule | 110561 | 1872 | 0 | -35.5183 | -71.6885 | 2022-01-13 08:00:09 | Maule, Chile | |||
3612841 | 3612841 | 2022-01-12 | Chile | Metropolitana | 766800 | 19979 | 0 | -33.4376 | -70.6505 | 2022-01-13 08:00:09 | Metropolitana, Chile | |||
3612842 | 3612842 | 2022-01-12 | Chile | Nuble | 40053 | 678 | 0 | -36.7226 | -71.7622 | 2022-01-13 08:00:09 | Nuble, Chile | |||
3612843 | 3612843 | 2022-01-12 | Chile | OHiggins | 73837 | 1635 | 0 | -34.5755 | -71.0022 | 2022-01-13 08:00:09 | OHiggins, Chile | |||
3612844 | 3612844 | 2022-01-12 | Chile | Tarapaca | 49882 | 832 | 0 | -19.9232 | -69.5132 | 2022-01-13 08:00:09 | Tarapaca, Chile | |||
3612845 | 3612845 | 2022-01-12 | Chile | Unknown | 47 | 0 | 0 | 2022-01-13 08:00:09 | Unknown, Chile | |||||
3612846 | 3612846 | 2022-01-12 | Chile | Valparaiso | 141244 | 3650 | 0 | -33.0472 | -71.6127 | 2022-01-13 08:00:09 | Valparaiso, Chile | |||
3612847 | 3612847 | 2022-01-12 | China | Anhui | 1009 | 6 | 0 | 31.8257 | 117.2264 | 2022-01-13 08:00:09 | Anhui, China | |||
3612848 | 3612848 | 2022-01-12 | China | Beijing | 1222 | 9 | 0 | 40.1824 | 116.4142 | 2022-01-13 08:00:09 | Beijing, China | |||
3612849 | 3612849 | 2022-01-12 | China | Chongqing | 611 | 6 | 0 | 30.0572 | 107.874 | 2022-01-13 08:00:09 | Chongqing, China | |||
3612850 | 3612850 | 2022-01-12 | China | Fujian | 1434 | 1 | 0 | 26.0789 | 117.9874 | 2022-01-13 08:00:09 | Fujian, China | |||
3612851 | 3612851 | 2022-01-12 | China | Gansu | 356 | 2 | 0 | 35.7518 | 104.2861 | 2022-01-13 08:00:09 | Gansu, China | |||
3612852 | 3612852 | 2022-01-12 | China | Guangdong | 3602 | 8 | 0 | 23.3417 | 113.4244 | 2022-01-13 08:00:09 | Guangdong, China | |||
3612853 | 3612853 | 2022-01-12 | China | Guangxi | 677 | 2 | 0 | 23.8298 | 108.7881 | 2022-01-13 08:00:09 | Guangxi, China | |||
3612854 | 3612854 | 2022-01-12 | China | Guizhou | 160 | 2 | 0 | 26.8154 | 106.8748 | 2022-01-13 08:00:09 | Guizhou, China | |||
3612855 | 3612855 | 2022-01-12 | China | Hainan | 190 | 6 | 0 | 19.1959 | 109.7453 | 2022-01-13 08:00:09 | Hainan, China | |||
3612856 | 3612856 | 2022-01-12 | China | Hebei | 1458 | 7 | 0 | 37.8957 | 114.9042 | 2022-01-13 08:00:09 | Hebei, China | |||
3612857 | 3612857 | 2022-01-12 | China | Heilongjiang | 2035 | 13 | 0 | 47.861999999999995 | 127.7615 | 2022-01-13 08:00:09 | Heilongjiang, China | |||
3612858 | 3612858 | 2022-01-12 | China | Henan | 2223 | 22 | 0 | 33.882 | 113.61399999999999 | 2022-01-13 08:00:09 | Henan, China | |||
3612859 | 3612859 | 2022-01-12 | China | Hong Kong | 13002 | 213 | 0 | 22.3 | 114.2 | 2022-01-13 08:00:09 | Hong Kong, China | |||
3612860 | 3612860 | 2022-01-12 | China | Hubei | 68320 | 4512 | 0 | 30.9756 | 112.2707 | 2022-01-13 08:00:09 | Hubei, China | |||
3612861 | 3612861 | 2022-01-12 | China | Hunan | 1229 | 4 | 0 | 27.6104 | 111.7088 | 2022-01-13 08:00:09 | Hunan, China | |||
3612862 | 3612862 | 2022-01-12 | China | Inner Mongolia | 1191 | 1 | 0 | 44.0935 | 113.9448 | 2022-01-13 08:00:09 | Inner Mongolia, China | |||
3612863 | 3612863 | 2022-01-12 | China | Jiangsu | 1629 | 0 | 0 | 32.9711 | 119.455 | 2022-01-13 08:00:09 | Jiangsu, China | |||
3612864 | 3612864 | 2022-01-12 | China | Jiangxi | 959 | 1 | 0 | 27.614 | 115.7221 | 2022-01-13 08:00:09 | Jiangxi, China | |||
3612865 | 3612865 | 2022-01-12 | China | Jilin | 590 | 3 | 0 | 43.6661 | 126.1923 | 2022-01-13 08:00:09 | Jilin, China | |||
3612866 | 3612866 | 2022-01-12 | China | Liaoning | 802 | 2 | 0 | 41.2956 | 122.6085 | 2022-01-13 08:00:09 | Liaoning, China | |||
3612867 | 3612867 | 2022-01-12 | China | Macau | 79 | 0 | 0 | 22.1667 | 113.55 | 2022-01-13 08:00:09 | Macau, China | |||
3612868 | 3612868 | 2022-01-12 | China | Ningxia | 122 | 0 | 0 | 37.2692 | 106.1655 | 2022-01-13 08:00:09 | Ningxia, China | |||
3612869 | 3612869 | 2022-01-12 | China | Qinghai | 30 | 0 | 0 | 35.7452 | 95.9956 | 2022-01-13 08:00:09 | Qinghai, China | |||
3612870 | 3612870 | 2022-01-12 | China | Shaanxi | 2804 | 3 | 0 | 35.1917 | 108.8701 | 2022-01-13 08:00:09 | Shaanxi, China | |||
3612871 | 3612871 | 2022-01-12 | China | Shandong | 1050 | 7 | 0 | 36.3427 | 118.1498 | 2022-01-13 08:00:09 | Shandong, China | |||
3612872 | 3612872 | 2022-01-12 | China | Shanghai | 3403 | 7 | 0 | 31.201999999999998 | 121.4491 | 2022-01-13 08:00:09 | Shanghai, China | |||
3612873 | 3612873 | 2022-01-12 | China | Shanxi | 266 | 0 | 0 | 37.5777 | 112.2922 | 2022-01-13 08:00:09 | Shanxi, China | |||
3612874 | 3612874 | 2022-01-12 | China | Sichuan | 1345 | 3 | 0 | 30.6171 | 102.7103 | 2022-01-13 08:00:09 | Sichuan, China | |||
3612875 | 3612875 | 2022-01-12 | China | Tianjin | 752 | 3 | 0 | 39.3054 | 117.323 | 2022-01-13 08:00:09 | Tianjin, China | |||
3612876 | 3612876 | 2022-01-12 | China | Tibet | 1 | 0 | 0 | 31.6927 | 88.0924 | 2022-01-13 08:00:09 | Tibet, China | |||
3612877 | 3612877 | 2022-01-12 | China | Unknown | 13277 | 0 | 0 | 2022-01-13 08:00:09 | Unknown, China | |||||
3612878 | 3612878 | 2022-01-12 | China | Xinjiang | 981 | 3 | 0 | 41.1129 | 85.2401 | 2022-01-13 08:00:09 | Xinjiang, China | |||
3612879 | 3612879 | 2022-01-12 | China | Yunnan | 1838 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-01-13 08:00:09 | Yunnan, China | |||
3612880 | 3612880 | 2022-01-12 | China | Zhejiang | 2090 | 1 | 0 | 29.1832 | 120.0934 | 2022-01-13 08:00:09 | Zhejiang, China | |||
3612881 | 3612881 | 2022-01-12 | Colombia | Amazonas | 7124 | 260 | 0 | -1.4429 | -71.5724 | 2022-01-13 08:00:09 | Amazonas, Colombia | |||
3612882 | 3612882 | 2022-01-12 | Colombia | Antioquia | 852186 | 17029 | 0 | 7.1986 | -75.3412 | 2022-01-13 08:00:09 | Antioquia, Colombia | |||
3612883 | 3612883 | 2022-01-12 | Colombia | Arauca | 14657 | 489 | 0 | 7.0762 | -70.7105 | 2022-01-13 08:00:09 | Arauca, Colombia | |||
3612884 | 3612884 | 2022-01-12 | Colombia | Atlantico | 355646 | 9759 | 0 | 10.6966 | -74.8741 | 2022-01-13 08:00:09 | Atlantico, Colombia | |||
3612885 | 3612885 | 2022-01-12 | Colombia | Bolivar | 173417 | 3063 | 0 | 8.6704 | -74.03 | 2022-01-13 08:00:09 | Bolivar, Colombia | |||
3612886 | 3612886 | 2022-01-12 | Colombia | Boyaca | 111595 | 2587 | 0 | 5.4545 | -73.362 | 2022-01-13 08:00:09 | Boyaca, Colombia | |||
3612887 | 3612887 | 2022-01-12 | Colombia | Caldas | 106271 | 2296 | 0 | 5.2983 | -75.2479 | 2022-01-13 08:00:09 | Caldas, Colombia | |||
3612888 | 3612888 | 2022-01-12 | Colombia | Capital District | 1539418 | 27773 | 0 | 4.711 | -74.0721 | 2022-01-13 08:00:09 | Capital District, Colombia | |||
3612889 | 3612889 | 2022-01-12 | Colombia | Caqueta | 23390 | 947 | 0 | 0.8699 | -73.8419 | 2022-01-13 08:00:09 | Caqueta, Colombia | |||
3612890 | 3612890 | 2022-01-12 | Colombia | Casanare | 36703 | 944 | 0 | 5.7589 | -71.5724 | 2022-01-13 08:00:09 | Casanare, Colombia | |||
3612891 | 3612891 | 2022-01-12 | Colombia | Cauca | 61234 | 1604 | 0 | 2.705 | -76.82600000000002 | 2022-01-13 08:00:09 | Cauca, Colombia | |||
3612892 | 3612892 | 2022-01-12 | Colombia | Cesar | 95047 | 2571 | 0 | 9.3373 | -73.6536 | 2022-01-13 08:00:09 | Cesar, Colombia | |||
3612893 | 3612893 | 2022-01-12 | Colombia | Choco | 17397 | 407 | 0 | 5.2528 | -76.82600000000002 | 2022-01-13 08:00:09 | Choco, Colombia | |||
3612894 | 3612894 | 2022-01-12 | Colombia | Cordoba | 107152 | 3750 | 0 | 8.0493 | -75.574 | 2022-01-13 08:00:09 | Cordoba, Colombia | |||
3612895 | 3612895 | 2022-01-12 | Colombia | Cundinamarca | 276259 | 6870 | 0 | 5.026 | -74.03 | 2022-01-13 08:00:09 | Cundinamarca, Colombia | |||
3612896 | 3612896 | 2022-01-12 | Colombia | Guainia | 2593 | 35 | 0 | 2.5854 | -68.5247 | 2022-01-13 08:00:09 | Guainia, Colombia | |||
3612897 | 3612897 | 2022-01-12 | Colombia | Guaviare | 5250 | 97 | 0 | 1.0654 | -73.2603 | 2022-01-13 08:00:09 | Guaviare, Colombia | |||
3612898 | 3612898 | 2022-01-12 | Colombia | Huila | 91750 | 3213 | 0 | 2.5359 | -75.5277 | 2022-01-13 08:00:09 | Huila, Colombia | |||
3612899 | 3612899 | 2022-01-12 | Colombia | La Guajira | 47929 | 1452 | 0 | 11.3548 | -72.5205 | 2022-01-13 08:00:09 | La Guajira, Colombia | |||
3612900 | 3612900 | 2022-01-12 | Colombia | Magdalena | 103775 | 3495 | 0 | 10.4113 | -74.4057 | 2022-01-13 08:00:09 | Magdalena, Colombia | |||
3612901 | 3612901 | 2022-01-12 | Colombia | Meta | 93034 | 2314 | 0 | 3.272 | -73.0877 | 2022-01-13 08:00:09 | Meta, Colombia | |||
3612902 | 3612902 | 2022-01-12 | Colombia | Narino | 94508 | 3053 | 0 | 1.2892 | -77.3579 | 2022-01-13 08:00:09 | Narino, Colombia | |||
3612903 | 3612903 | 2022-01-12 | Colombia | Norte de Santander | 104178 | 4737 | 0 | 7.9463 | -72.8988 | 2022-01-13 08:00:09 | Norte de Santander, Colombia | |||
3612904 | 3612904 | 2022-01-12 | Colombia | Putumayo | 18279 | 720 | 0 | 0.436 | -75.5277 | 2022-01-13 08:00:09 | Putumayo, Colombia | |||
3612905 | 3612905 | 2022-01-12 | Colombia | Quindio | 62184 | 1867 | 0 | 4.461 | -75.6674 | 2022-01-13 08:00:09 | Quindio, Colombia | |||
3612906 | 3612906 | 2022-01-12 | Colombia | Risaralda | 94257 | 2287 | 0 | 5.3158 | -75.9928 | 2022-01-13 08:00:09 | Risaralda, Colombia | |||
3612907 | 3612907 | 2022-01-12 | Colombia | San Andres y Providencia | 8966 | 152 | 0 | 12.5567 | -81.7185 | 2022-01-13 08:00:09 | San Andres y Providencia, Colombia | |||
3612908 | 3612908 | 2022-01-12 | Colombia | Santander | 244076 | 7567 | 0 | 6.6437 | -73.6536 | 2022-01-13 08:00:09 | Santander, Colombia | |||
3612909 | 3612909 | 2022-01-12 | Colombia | Sucre | 60660 | 1629 | 0 | 8.814 | -74.7233 | 2022-01-13 08:00:09 | Sucre, Colombia | |||
3612910 | 3612910 | 2022-01-12 | Colombia | Tolima | 111342 | 3701 | 0 | 4.0925 | -75.1545 | 2022-01-13 08:00:09 | Tolima, Colombia | |||
3612911 | 3612911 | 2022-01-12 | Colombia | Unknown | 0 | 296 | 0 | 2022-01-13 08:00:09 | Unknown, Colombia | |||||
3612912 | 3612912 | 2022-01-12 | Colombia | Valle del Cauca | 485560 | 13490 | 0 | 3.8009 | -76.6413 | 2022-01-13 08:00:09 | Valle del Cauca, Colombia | |||
3612913 | 3612913 | 2022-01-12 | Colombia | Vaupes | 1800 | 17 | 0 | 0.8554 | -70.812 | 2022-01-13 08:00:09 | Vaupes, Colombia | |||
3612914 | 3612914 | 2022-01-12 | Colombia | Vichada | 3061 | 58 | 0 | 4.4234 | -69.2878 | 2022-01-13 08:00:09 | Vichada, Colombia | |||
3612915 | 3612915 | 2022-01-12 | Comoros | 7715 | 159 | 0 | -11.6455 | 43.3333 | 2022-01-13 08:00:09 | Comoros | ||||
3612916 | 3612916 | 2022-01-12 | Congo (Brazzaville) | 22418 | 370 | 0 | -0.228 | 15.8277 | 2022-01-13 08:00:09 | Congo (Brazzaville) | ||||
3612917 | 3612917 | 2022-01-12 | Congo (Kinshasa) | 81719 | 1225 | 0 | -4.0383 | 21.7587 | 2022-01-13 08:00:09 | Congo (Kinshasa) | ||||
3612918 | 3612918 | 2022-01-12 | Costa Rica | 599965 | 7394 | 0 | 9.7489 | -83.7534 | 2022-01-13 08:00:09 | Costa Rica | ||||
3612919 | 3612919 | 2022-01-12 | Cote d'Ivoire | 78258 | 745 | 0 | 7.54 | -5.5471 | 2022-01-13 08:00:09 | Cote d'Ivoire | ||||
3612920 | 3612920 | 2022-01-12 | Croatia | 785033 | 12983 | 0 | 45.1 | 15.2 | 2022-01-13 08:00:09 | Croatia | ||||
3612921 | 3612921 | 2022-01-12 | Cuba | 985402 | 8330 | 0 | 21.521757 | -77.78116700000002 | 2022-01-13 08:00:09 | Cuba | ||||
3612922 | 3612922 | 2022-01-12 | Cyprus | 215271 | 669 | 0 | 35.1264 | 33.4299 | 2022-01-13 08:00:09 | Cyprus | ||||
3612923 | 3612923 | 2022-01-12 | Czechia | 2562235 | 36765 | 0 | 49.8175 | 15.472999999999999 | 2022-01-13 08:00:09 | Czechia | ||||
3612924 | 3612924 | 2022-01-12 | Denmark | Faroe Islands | 8579 | 15 | 0 | 61.8926 | -6.9118 | 2022-01-13 08:00:09 | Faroe Islands, Denmark | |||
3612925 | 3612925 | 2022-01-12 | Denmark | Greenland | 6453 | 2 | 0 | 71.7069 | -42.6043 | 2022-01-13 08:00:09 | Greenland, Denmark | |||
3612926 | 3612926 | 2022-01-12 | Denmark | 1030638 | 3433 | 0 | 56.2639 | 9.5018 | 2022-01-13 08:00:09 | Denmark | ||||
3612927 | 3612927 | 2022-01-12 | Diamond Princess | 712 | 13 | 0 | 2022-01-13 08:00:09 | Diamond Princess | ||||||
3612928 | 3612928 | 2022-01-12 | Djibouti | 14541 | 189 | 0 | 11.8251 | 42.5903 | 2022-01-13 08:00:09 | Djibouti | ||||
3612929 | 3612929 | 2022-01-12 | Dominica | 7667 | 47 | 0 | 15.415 | -61.371 | 2022-01-13 08:00:09 | Dominica | ||||
3612930 | 3612930 | 2022-01-12 | Dominican Republic | 476504 | 4259 | 0 | 18.7357 | -70.1627 | 2022-01-13 08:00:09 | Dominican Republic | ||||
3612931 | 3612931 | 2022-01-12 | Ecuador | 588871 | 34162 | 0 | -1.8312 | -78.1834 | 2022-01-13 08:00:09 | Ecuador | ||||
3612932 | 3612932 | 2022-01-12 | Egypt | 395688 | 22042 | 0 | 26.820553000000004 | 30.802497999999996 | 2022-01-13 08:00:09 | Egypt | ||||
3612933 | 3612933 | 2022-01-12 | El Salvador | 123025 | 3828 | 0 | 13.7942 | -88.8965 | 2022-01-13 08:00:09 | El Salvador | ||||
3612934 | 3612934 | 2022-01-12 | Equatorial Guinea | 14871 | 177 | 0 | 1.6508 | 10.2679 | 2022-01-13 08:00:09 | Equatorial Guinea | ||||
3612935 | 3612935 | 2022-01-12 | Eritrea | 8653 | 84 | 0 | 15.1794 | 39.7823 | 2022-01-13 08:00:09 | Eritrea |
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]);