daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,843 rows where "day" is on date 2020-07-09 sorted by admin2
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, day
day | country_or_region | province_or_state | admin2 ▼ | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-07-09 | Italy | Abruzzo | 3318 | 464 | 2707 | 147 | 42.35122196 | 13.39843823 | 2020-07-10 04:34:24 | Abruzzo, Italy | ||
2020-07-09 | Brazil | Acre | 15465 | 411 | 8604 | 6450 | -9.0238 | -70.812 | 2020-07-10 04:34:24 | Acre, Brazil | ||
2020-07-09 | Russia | Adygea Republic | 2187 | 14 | 1626 | 547 | 44.6939006 | 40.1520421 | 2020-07-10 04:34:24 | Adygea Republic, Russia | ||
2020-07-09 | Mexico | Aguascalientes | 2775 | 179 | 2240 | 356 | 21.8853 | -102.2916 | 2020-07-10 04:34:24 | Aguascalientes, Mexico | ||
2020-07-09 | Japan | Aichi | 532 | 34 | 480 | 18 | 35.035551 | 137.211621 | 2020-07-10 04:34:24 | Aichi, Japan | ||
2020-07-09 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-07-10 04:34:24 | Akita, Japan | ||
2020-07-09 | Brazil | Alagoas | 43191 | 1230 | 34309 | 7652 | -9.5713 | -36.782 | 2020-07-10 04:34:24 | Alagoas, Brazil | ||
2020-07-09 | Canada | Alberta | 8519 | 161 | 7774 | 584 | 53.9333 | -116.5765 | 2020-07-10 04:34:24 | Alberta, Canada | ||
2020-07-09 | Russia | Altai Krai | 5121 | 49 | 3577 | 1495 | 52.6932243 | 82.69314240000001 | 2020-07-10 04:34:24 | Altai Krai, Russia | ||
2020-07-09 | Russia | Altai Republic | 962 | 1 | 462 | 499 | 50.7114101 | 86.8572186 | 2020-07-10 04:34:24 | Altai Republic, Russia | ||
2020-07-09 | Brazil | Amapa | 30763 | 467 | 19644 | 10652 | 0.902 | -52.003 | 2020-07-10 04:34:24 | Amapa, Brazil | ||
2020-07-09 | Brazil | Amazonas | 81318 | 2985 | 67024 | 11309 | -3.4168 | -65.8561 | 2020-07-10 04:34:24 | Amazonas, Brazil | ||
2020-07-09 | Colombia | Amazonas | 2394 | 99 | 2104 | 191 | -1.4429 | -71.5724 | 2020-07-10 04:34:24 | Amazonas, Colombia | ||
2020-07-09 | Peru | Amazonas | 3167 | 186 | 0 | 2981 | -5.077253 | -78.050172 | 2020-07-10 04:34:24 | Amazonas, Peru | ||
2020-07-09 | Russia | Amur Oblast | 1975 | 22 | 1049 | 904 | 52.8032368 | 128.437295 | 2020-07-10 04:34:24 | Amur Oblast, Russia | ||
2020-07-09 | Peru | Ancash | 9185 | 1387 | 0 | 7798 | -9.407125 | -77.67179499999997 | 2020-07-10 04:34:24 | Ancash, Peru | ||
2020-07-09 | Spain | Andalusia | 13338 | 1435 | 10671 | 1232 | 37.5443 | -4.7278 | 2020-07-10 04:34:24 | Andalusia, Spain | ||
2020-07-09 | India | Andaman and Nicobar Islands | 151 | 0 | 83 | 68 | 11.225999 | 92.96817800000001 | 2020-07-10 04:34:24 | Andaman and Nicobar Islands, India | ||
2020-07-09 | India | Andhra Pradesh | 23814 | 277 | 12154 | 11383 | 15.9129 | 79.74 | 2020-07-10 04:34:24 | Andhra Pradesh, India | ||
2020-07-09 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-07-10 04:34:24 | Anguilla, United Kingdom | ||
2020-07-09 | China | Anhui | 991 | 6 | 985 | 0 | 31.8257 | 117.2264 | 2020-07-10 04:34:24 | Anhui, China | ||
2020-07-09 | Colombia | Antioquia | 7246 | 66 | 2451 | 4729 | 7.1986 | -75.3412 | 2020-07-10 04:34:24 | Antioquia, Colombia | ||
2020-07-09 | Chile | Antofagasta | 11077 | 203 | 9008 | 1866 | -23.6509 | -70.3975 | 2020-07-10 04:34:24 | Antofagasta, Chile | ||
2020-07-09 | Japan | Aomori | 28 | 1 | 26 | 1 | 40.781541 | 140.828896 | 2020-07-10 04:34:24 | Aomori, Japan | ||
2020-07-09 | Peru | Apurimac | 615 | 36 | 0 | 579 | -14.027713 | -72.975378 | 2020-07-10 04:34:24 | Apurimac, Peru | ||
2020-07-09 | Spain | Aragon | 6637 | 913 | 3772 | 1952 | 41.5976 | -0.9057 | 2020-07-10 04:34:24 | Aragon, Spain | ||
2020-07-09 | Colombia | Arauca | 121 | 0 | 8 | 113 | 7.0762 | -70.7105 | 2020-07-10 04:34:24 | Arauca, Colombia | ||
2020-07-09 | Chile | Araucania | 3505 | 47 | 3185 | 273 | -38.9489 | -72.3311 | 2020-07-10 04:34:24 | Araucania, Chile | ||
2020-07-09 | Peru | Arequipa | 8374 | 1032 | 0 | 7342 | -15.843523999999999 | -72.475539 | 2020-07-10 04:34:24 | Arequipa, Peru | ||
2020-07-09 | Chile | Arica y Parinacota | 2273 | 24 | 1706 | 543 | -18.594 | -69.4785 | 2020-07-10 04:34:24 | Arica y Parinacota, Chile | ||
2020-07-09 | Russia | Arkhangelsk Oblast | 6647 | 83 | 3685 | 2879 | 63.5589686 | 43.1221646 | 2020-07-10 04:34:24 | Arkhangelsk Oblast, Russia | ||
2020-07-09 | Netherlands | Aruba | 105 | 3 | 98 | 4 | 12.5211 | -69.9683 | 2020-07-10 04:34:24 | Aruba, Netherlands | ||
2020-07-09 | India | Arunachal Pradesh | 302 | 2 | 120 | 180 | 27.768456 | 96.384277 | 2020-07-10 04:34:24 | Arunachal Pradesh, India | ||
2020-07-09 | India | Assam | 14032 | 22 | 8726 | 5284 | 26.357149 | 92.83044100000001 | 2020-07-10 04:34:24 | Assam, India | ||
2020-07-09 | Russia | Astrakhan Oblast | 3806 | 35 | 2515 | 1256 | 47.1878186 | 47.608851 | 2020-07-10 04:34:24 | Astrakhan Oblast, Russia | ||
2020-07-09 | Spain | Asturias | 2436 | 334 | 1063 | 1039 | 43.3614 | -5.8593 | 2020-07-10 04:34:24 | Asturias, Spain | ||
2020-07-09 | Chile | Atacama | 1429 | 7 | 1036 | 386 | -27.5661 | -70.0503 | 2020-07-10 04:34:24 | Atacama, Chile | ||
2020-07-09 | Colombia | Atlantico | 29572 | 1719 | 11080 | 16773 | 10.6966 | -74.8741 | 2020-07-10 04:34:24 | Atlantico, Colombia | ||
2020-07-09 | Australia | Australian Capital Territory | 113 | 3 | 105 | 5 | -35.4735 | 149.0124 | 2020-07-10 04:34:24 | Australian Capital Territory, Australia | ||
2020-07-09 | Peru | Ayacucho | 2130 | 123 | 0 | 2007 | -14.091648000000001 | -74.08344 | 2020-07-10 04:34:24 | Ayacucho, Peru | ||
2020-07-09 | Chile | Aysen | 49 | 0 | 40 | 9 | -45.9864 | -73.7669 | 2020-07-10 04:34:24 | Aysen, Chile | ||
2020-07-09 | Pakistan | Azad Jammu and Kashmir | 1485 | 41 | 860 | 584 | 34.027401 | 73.947253 | 2020-07-10 04:34:24 | Azad Jammu and Kashmir, Pakistan | ||
2020-07-09 | Germany | Baden-Wurttemberg | 35942 | 1838 | 33624 | 538 | 48.6616 | 9.3501 | 2020-07-10 04:34:24 | Baden-Wurttemberg, Germany | ||
2020-07-09 | Brazil | Bahia | 98319 | 2328 | 69098 | 26893 | -12.5797 | -41.7007 | 2020-07-10 04:34:24 | Bahia, Brazil | ||
2020-07-09 | Mexico | Baja California | 10429 | 2206 | 7685 | 538 | 30.8406 | -115.2838 | 2020-07-10 04:34:24 | Baja California, Mexico | ||
2020-07-09 | Mexico | Baja California Sur | 2109 | 95 | 1572 | 442 | 26.0444 | -111.6661 | 2020-07-10 04:34:24 | Baja California Sur, Mexico | ||
2020-07-09 | Spain | Baleares | 2246 | 224 | 1533 | 489 | 39.710358 | 2.995148 | 2020-07-10 04:34:24 | Baleares, Spain | ||
2020-07-09 | Pakistan | Balochistan | 11099 | 125 | 6931 | 4043 | 28.328492 | 65.898403 | 2020-07-10 04:34:24 | Balochistan, Pakistan | ||
2020-07-09 | Russia | Bashkortostan Republic | 5778 | 19 | 3759 | 2000 | 54.8573563 | 57.1439682 | 2020-07-10 04:34:24 | Bashkortostan Republic, Russia | ||
2020-07-09 | Italy | Basilicata | 405 | 27 | 373 | 5 | 40.63947052 | 15.80514834 | 2020-07-10 04:34:24 | Basilicata, Italy | ||
2020-07-09 | Germany | Bayern | 49023 | 2609 | 45600 | 814 | 48.7904 | 11.4979 | 2020-07-10 04:34:24 | Bayern, Germany | ||
2020-07-09 | China | Beijing | 929 | 9 | 645 | 275 | 40.1824 | 116.4142 | 2020-07-10 04:34:24 | Beijing, China | ||
2020-07-09 | Russia | Belgorod Oblast | 4998 | 42 | 4355 | 601 | 50.7080119 | 37.5837615 | 2020-07-10 04:34:24 | Belgorod Oblast, Russia | ||
2020-07-09 | Germany | Berlin | 8537 | 216 | 7896 | 473 | 52.52 | 13.405 | 2020-07-10 04:34:24 | Berlin, Germany | ||
2020-07-09 | United Kingdom | Bermuda | 149 | 9 | 137 | 3 | 32.3078 | -64.7505 | 2020-07-10 04:34:24 | Bermuda, United Kingdom | ||
2020-07-09 | India | Bihar | 13944 | 115 | 9816 | 4013 | 25.679658 | 85.60484 | 2020-07-10 04:34:24 | Bihar, India | ||
2020-07-09 | Chile | Biobio | 7980 | 67 | 6593 | 1320 | -37.4464 | -72.1416 | 2020-07-10 04:34:24 | Biobio, Chile | ||
2020-07-09 | Sweden | Blekinge | 468 | 14 | 0 | 454 | 56.2784 | 15.018 | 2020-07-10 04:34:24 | Blekinge, Sweden | ||
2020-07-09 | Colombia | Bolivar | 11254 | 450 | 5869 | 4935 | 8.6704 | -74.03 | 2020-07-10 04:34:24 | Bolivar, Colombia | ||
2020-07-09 | Netherlands | Bonaire, Sint Eustatius and Saba | 7 | 0 | 7 | 0 | 12.1784 | -68.2385 | 2020-07-10 04:34:24 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2020-07-09 | Colombia | Boyaca | 446 | 18 | 252 | 176 | 5.4545 | -73.362 | 2020-07-10 04:34:24 | Boyaca, Colombia | ||
2020-07-09 | Germany | Brandenburg | 3483 | 168 | 3300 | 32 | 52.4125 | 12.5316 | 2020-07-10 04:34:24 | Brandenburg, Germany | ||
2020-07-09 | Germany | Bremen | 1684 | 54 | 1600 | 37 | 53.0793 | 8.8017 | 2020-07-10 04:34:24 | Bremen, Germany | ||
2020-07-09 | Canada | British Columbia | 3028 | 186 | 2667 | 175 | 53.7267 | -127.6476 | 2020-07-10 04:34:24 | British Columbia, Canada | ||
2020-07-09 | United Kingdom | British Virgin Islands | 8 | 1 | 7 | 0 | 18.4207 | -64.64 | 2020-07-10 04:34:24 | British Virgin Islands, United Kingdom | ||
2020-07-09 | Russia | Bryansk Oblast | 6643 | 35 | 4886 | 1722 | 52.8873315 | 33.41585300000001 | 2020-07-10 04:34:24 | Bryansk Oblast, Russia | ||
2020-07-09 | Russia | Buryatia Republic | 3257 | 24 | 2371 | 862 | 52.7182426 | 109.492143 | 2020-07-10 04:34:24 | Buryatia Republic, Russia | ||
2020-07-09 | Spain | C. Valenciana | 11718 | 1432 | 9970 | 316 | 39.484 | -0.7533 | 2020-07-10 04:34:24 | C. Valenciana, Spain | ||
2020-07-09 | Peru | Cajamarca | 3110 | 276 | 0 | 2834 | -6.4302839999999994 | -78.74559599999998 | 2020-07-10 04:34:24 | Cajamarca, Peru | ||
2020-07-09 | Italy | Calabria | 1185 | 97 | 1060 | 28 | 38.90597598 | 16.59440194 | 2020-07-10 04:34:24 | Calabria, Italy | ||
2020-07-09 | Colombia | Caldas | 279 | 8 | 205 | 66 | 5.2983 | -75.2479 | 2020-07-10 04:34:24 | Caldas, Colombia | ||
2020-07-09 | Peru | Callao | 18745 | 3008 | 0 | 15737 | -11.954609 | -77.136042 | 2020-07-10 04:34:24 | Callao, Peru | ||
2020-07-09 | Italy | Campania | 4755 | 432 | 4091 | 232 | 40.83956555 | 14.25084984 | 2020-07-10 04:34:24 | Campania, Italy | ||
2020-07-09 | Mexico | Campeche | 2693 | 271 | 2170 | 252 | 19.8301 | -90.5349 | 2020-07-10 04:34:24 | Campeche, Mexico | ||
2020-07-09 | Spain | Canarias | 2451 | 162 | 1537 | 752 | 28.2916 | -16.6291 | 2020-07-10 04:34:24 | Canarias, Spain | ||
2020-07-09 | Spain | Cantabria | 2369 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-10 04:34:24 | Cantabria, Spain | ||
2020-07-09 | Colombia | Capital District | 40737 | 984 | 15566 | 24187 | 4.711 | -74.0721 | 2020-07-10 04:34:24 | Capital District, Colombia | ||
2020-07-09 | Colombia | Caqueta | 82 | 2 | 23 | 57 | 0.8699 | -73.8419 | 2020-07-10 04:34:24 | Caqueta, Colombia | ||
2020-07-09 | Colombia | Casanare | 91 | 0 | 49 | 42 | 5.7589 | -71.5724 | 2020-07-10 04:34:24 | Casanare, Colombia | ||
2020-07-09 | Spain | Castilla - La Mancha | 18330 | 3029 | 6392 | 8909 | 39.2796 | -3.0977 | 2020-07-10 04:34:24 | Castilla - La Mancha, Spain | ||
2020-07-09 | Spain | Castilla y Leon | 19782 | 2791 | 8716 | 8275 | 41.8357 | -4.3976 | 2020-07-10 04:34:24 | Castilla y Leon, Spain | ||
2020-07-09 | Spain | Catalonia | 63307 | 5675 | 26203 | 31429 | 41.5912 | 1.5209 | 2020-07-10 04:34:24 | Catalonia, Spain | ||
2020-07-09 | Colombia | Cauca | 623 | 22 | 189 | 412 | 2.705 | -76.82600000000002 | 2020-07-10 04:34:24 | Cauca, Colombia | ||
2020-07-09 | United Kingdom | Cayman Islands | 201 | 1 | 197 | 3 | 19.3133 | -81.2546 | 2020-07-10 04:34:24 | Cayman Islands, United Kingdom | ||
2020-07-09 | Brazil | Ceara | 131324 | 6774 | 104162 | 20097 | -5.4984 | -39.3206 | 2020-07-10 04:34:24 | Ceara, Brazil | ||
2020-07-09 | Colombia | Cesar | 1359 | 34 | 687 | 638 | 9.3373 | -73.6536 | 2020-07-10 04:34:24 | Cesar, Colombia | ||
2020-07-09 | Spain | Ceuta | 163 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-07-10 04:34:24 | Ceuta, Spain | ||
2020-07-09 | India | Chandigarh | 523 | 7 | 403 | 113 | 30.733839 | 76.76827800000002 | 2020-07-10 04:34:24 | Chandigarh, India | ||
2020-07-09 | United Kingdom | Channel Islands | 0 | 0 | 512 | 18 | 49.3723 | -2.3644 | 2020-07-10 04:34:24 | Channel Islands, United Kingdom | ||
2020-07-09 | Russia | Chechen Republic | 1809 | 26 | 1237 | 546 | 43.39761470000001 | 45.6985005 | 2020-07-10 04:34:24 | Chechen Republic, Russia | ||
2020-07-09 | Russia | Chelyabinsk Oblast | 8391 | 88 | 4652 | 3651 | 54.4223954 | 61.1865846 | 2020-07-10 04:34:24 | Chelyabinsk Oblast, Russia | ||
2020-07-09 | Ukraine | Cherkasy Oblast | 707 | 28 | 552 | 127 | 49.4444 | 32.0598 | 2020-07-10 04:34:24 | Cherkasy Oblast, Ukraine | ||
2020-07-09 | Ukraine | Chernihiv Oblast | 585 | 13 | 224 | 348 | 51.4982 | 31.2893 | 2020-07-10 04:34:24 | Chernihiv Oblast, Ukraine | ||
2020-07-09 | Ukraine | Chernivtsi Oblast | 5074 | 193 | 2473 | 2408 | 48.2917 | 25.9352 | 2020-07-10 04:34:24 | Chernivtsi Oblast, Ukraine | ||
2020-07-09 | India | Chhattisgarh | 3675 | 15 | 2903 | 757 | 21.264705 | 82.035366 | 2020-07-10 04:34:24 | Chhattisgarh, India | ||
2020-07-09 | Mexico | Chiapas | 5086 | 697 | 4121 | 268 | 16.7569 | -93.1292 | 2020-07-10 04:34:24 | Chiapas, Mexico | ||
2020-07-09 | Japan | Chiba | 1056 | 46 | 899 | 111 | 35.510141 | 140.198917 | 2020-07-10 04:34:24 | Chiba, Japan | ||
2020-07-09 | Mexico | Chihuahua | 3652 | 705 | 2714 | 233 | 28.63300000000001 | -106.0691 | 2020-07-10 04:34:24 | Chihuahua, Mexico | ||
2020-07-09 | Colombia | Choco | 2033 | 65 | 802 | 1166 | 5.2528 | -76.82600000000002 | 2020-07-10 04:34:24 | Choco, Colombia | ||
2020-07-09 | China | Chongqing | 582 | 6 | 575 | 1 | 30.0572 | 107.874 | 2020-07-10 04:34:24 | Chongqing, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;