daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,956 rows where "day" is on date 2020-07-19 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-19 | Italy | Abruzzo | 3336 | 468 | 2751 | 117 | 42.35122196 | 13.39843823 | 2020-07-20 05:34:40 | Abruzzo, Italy | ||
2020-07-19 | Brazil | Acre | 17295 | 460 | 9858 | 6977 | -9.0238 | -70.812 | 2020-07-20 05:34:40 | Acre, Brazil | ||
2020-07-19 | Russia | Adygea Republic | 2364 | 16 | 1901 | 447 | 44.6939006 | 40.1520421 | 2020-07-20 05:34:40 | Adygea Republic, Russia | ||
2020-07-19 | Mexico | Aguascalientes | 3417 | 207 | 2654 | 556 | 21.8853 | -102.2916 | 2020-07-20 05:34:40 | Aguascalientes, Mexico | ||
2020-07-19 | Japan | Aichi | 643 | 34 | 485 | 124 | 35.035551 | 137.211621 | 2020-07-20 05:34:40 | Aichi, Japan | ||
2020-07-19 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748678999999996 | 140.408228 | 2020-07-20 05:34:40 | Akita, Japan | ||
2020-07-19 | Brazil | Alagoas | 50079 | 1397 | 43005 | 5676 | -9.5713 | -36.782 | 2020-07-20 05:34:40 | Alagoas, Brazil | ||
2020-07-19 | Canada | Alberta | 9219 | 167 | 8193 | 859 | 53.9333 | -116.5765 | 2020-07-20 05:34:40 | Alberta, Canada | ||
2020-07-19 | Russia | Altai Krai | 7382 | 56 | 4712 | 2614 | 52.6932243 | 82.69314240000001 | 2020-07-20 05:34:40 | Altai Krai, Russia | ||
2020-07-19 | Russia | Altai Republic | 1239 | 1 | 764 | 474 | 50.7114101 | 86.8572186 | 2020-07-20 05:34:40 | Altai Republic, Russia | ||
2020-07-19 | Brazil | Amapa | 33705 | 507 | 22346 | 10852 | 0.902 | -52.003 | 2020-07-20 05:34:40 | Amapa, Brazil | ||
2020-07-19 | Brazil | Amazonas | 90913 | 3149 | 76009 | 11755 | -3.4168 | -65.8561 | 2020-07-20 05:34:40 | Amazonas, Brazil | ||
2020-07-19 | Colombia | Amazonas | 2454 | 101 | 2275 | 78 | -1.4429 | -71.5724 | 2020-07-20 05:34:40 | Amazonas, Colombia | ||
2020-07-19 | Peru | Amazonas | 3534 | 255 | 0 | 3279 | -5.077253 | -78.050172 | 2020-07-20 05:34:40 | Amazonas, Peru | ||
2020-07-19 | Russia | Amur Oblast | 2393 | 33 | 1456 | 904 | 52.8032368 | 128.437295 | 2020-07-20 05:34:40 | Amur Oblast, Russia | ||
2020-07-19 | Peru | Ancash | 9926 | 1576 | 0 | 8350 | -9.407125 | -77.67179499999997 | 2020-07-20 05:34:40 | Ancash, Peru | ||
2020-07-19 | Spain | Andalusia | 13731 | 1435 | 10671 | 1625 | 37.5443 | -4.7278 | 2020-07-20 05:34:40 | Andalusia, Spain | ||
2020-07-19 | India | Andaman and Nicobar Islands | 203 | 0 | 145 | 58 | 11.225999 | 92.96817800000001 | 2020-07-20 05:34:40 | Andaman and Nicobar Islands, India | ||
2020-07-19 | India | Andhra Pradesh | 49650 | 642 | 22890 | 26118 | 15.9129 | 79.74 | 2020-07-20 05:34:40 | Andhra Pradesh, India | ||
2020-07-19 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-07-20 05:34:40 | Anguilla, United Kingdom | ||
2020-07-19 | China | Anhui | 991 | 6 | 985 | 0 | 31.8257 | 117.2264 | 2020-07-20 05:34:40 | Anhui, China | ||
2020-07-19 | Colombia | Antioquia | 15647 | 193 | 4348 | 11106 | 7.1986 | -75.3412 | 2020-07-20 05:34:40 | Antioquia, Colombia | ||
2020-07-19 | Chile | Antofagasta | 13109 | 280 | 11281 | 1548 | -23.6509 | -70.3975 | 2020-07-20 05:34:40 | Antofagasta, Chile | ||
2020-07-19 | Japan | Aomori | 31 | 1 | 26 | 4 | 40.781541 | 140.828896 | 2020-07-20 05:34:40 | Aomori, Japan | ||
2020-07-19 | Peru | Apurimac | 668 | 42 | 0 | 626 | -14.027713 | -72.975378 | 2020-07-20 05:34:40 | Apurimac, Peru | ||
2020-07-19 | Spain | Aragon | 7639 | 915 | 3772 | 2952 | 41.5976 | -0.9057 | 2020-07-20 05:34:40 | Aragon, Spain | ||
2020-07-19 | Colombia | Arauca | 165 | 0 | 83 | 82 | 7.0762 | -70.7105 | 2020-07-20 05:34:40 | Arauca, Colombia | ||
2020-07-19 | Chile | Araucania | 3724 | 71 | 3474 | 179 | -38.9489 | -72.3311 | 2020-07-20 05:34:40 | Araucania, Chile | ||
2020-07-19 | Peru | Arequipa | 9560 | 1527 | 0 | 8033 | -15.843523999999999 | -72.475539 | 2020-07-20 05:34:40 | Arequipa, Peru | ||
2020-07-19 | Chile | Arica y Parinacota | 3056 | 36 | 2260 | 760 | -18.594 | -69.4785 | 2020-07-20 05:34:40 | Arica y Parinacota, Chile | ||
2020-07-19 | Russia | Arkhangelsk Oblast | 7819 | 129 | 5492 | 2198 | 63.5589686 | 43.1221646 | 2020-07-20 05:34:40 | Arkhangelsk Oblast, Russia | ||
2020-07-19 | Netherlands | Aruba | 113 | 3 | 100 | 10 | 12.5211 | -69.9683 | 2020-07-20 05:34:40 | Aruba, Netherlands | ||
2020-07-19 | India | Arunachal Pradesh | 740 | 3 | 282 | 455 | 27.768456 | 96.384277 | 2020-07-20 05:34:40 | Arunachal Pradesh, India | ||
2020-07-19 | India | Assam | 23999 | 57 | 16023 | 7919 | 26.357149 | 92.83044100000001 | 2020-07-20 05:34:40 | Assam, India | ||
2020-07-19 | Russia | Astrakhan Oblast | 4176 | 39 | 2964 | 1173 | 47.1878186 | 47.608851 | 2020-07-20 05:34:40 | Astrakhan Oblast, Russia | ||
2020-07-19 | Spain | Asturias | 2442 | 334 | 1063 | 1045 | 43.3614 | -5.8593 | 2020-07-20 05:34:40 | Asturias, Spain | ||
2020-07-19 | Chile | Atacama | 1857 | 9 | 1437 | 411 | -27.5661 | -70.0503 | 2020-07-20 05:34:40 | Atacama, Chile | ||
2020-07-19 | Colombia | Atlantico | 43813 | 2176 | 24428 | 17209 | 10.6966 | -74.8741 | 2020-07-20 05:34:40 | Atlantico, Colombia | ||
2020-07-19 | Australia | Australian Capital Territory | 113 | 3 | 107 | 3 | -35.4735 | 149.0124 | 2020-07-20 05:34:40 | Australian Capital Territory, Australia | ||
2020-07-19 | Peru | Ayacucho | 2442 | 173 | 0 | 2269 | -14.091648000000001 | -74.08344 | 2020-07-20 05:34:40 | Ayacucho, Peru | ||
2020-07-19 | Chile | Aysen | 69 | 1 | 49 | 19 | -45.9864 | -73.7669 | 2020-07-20 05:34:40 | Aysen, Chile | ||
2020-07-19 | Pakistan | Azad Jammu and Kashmir | 1915 | 47 | 1201 | 667 | 34.027401 | 73.947253 | 2020-07-20 05:34:40 | Azad Jammu and Kashmir, Pakistan | ||
2020-07-19 | Germany | Baden-Wurttemberg | 36342 | 1838 | 34050 | 464 | 48.6616 | 9.3501 | 2020-07-20 05:34:40 | Baden-Wurttemberg, Germany | ||
2020-07-19 | Brazil | Bahia | 122169 | 2840 | 99704 | 19625 | -12.5797 | -41.7007 | 2020-07-20 05:34:40 | Bahia, Brazil | ||
2020-07-19 | Mexico | Baja California | 11934 | 2344 | 8702 | 888 | 30.8406 | -115.2838 | 2020-07-20 05:34:40 | Baja California, Mexico | ||
2020-07-19 | Mexico | Baja California Sur | 3107 | 117 | 2095 | 895 | 26.0444 | -111.6661 | 2020-07-20 05:34:40 | Baja California Sur, Mexico | ||
2020-07-19 | Spain | Baleares | 2290 | 224 | 1533 | 533 | 39.710358 | 2.995148 | 2020-07-20 05:34:40 | Baleares, Spain | ||
2020-07-19 | Pakistan | Balochistan | 11436 | 132 | 8688 | 2616 | 28.328492 | 65.898403 | 2020-07-20 05:34:40 | Balochistan, Pakistan | ||
2020-07-19 | Russia | Bashkortostan Republic | 6307 | 20 | 4630 | 1657 | 54.8573563 | 57.1439682 | 2020-07-20 05:34:40 | Bashkortostan Republic, Russia | ||
2020-07-19 | Italy | Basilicata | 408 | 28 | 373 | 7 | 40.63947052 | 15.80514834 | 2020-07-20 05:34:40 | Basilicata, Italy | ||
2020-07-19 | Germany | Bayern | 49710 | 2616 | 46200 | 894 | 48.7904 | 11.4979 | 2020-07-20 05:34:40 | Bayern, Germany | ||
2020-07-19 | China | Beijing | 929 | 9 | 752 | 168 | 40.1824 | 116.4142 | 2020-07-20 05:34:40 | Beijing, China | ||
2020-07-19 | Russia | Belgorod Oblast | 5441 | 43 | 5004 | 394 | 50.7080119 | 37.5837615 | 2020-07-20 05:34:40 | Belgorod Oblast, Russia | ||
2020-07-19 | Germany | Berlin | 8774 | 221 | 8250 | 307 | 52.52 | 13.405 | 2020-07-20 05:34:40 | Berlin, Germany | ||
2020-07-19 | United Kingdom | Bermuda | 153 | 9 | 137 | 7 | 32.3078 | -64.7505 | 2020-07-20 05:34:40 | Bermuda, United Kingdom | ||
2020-07-19 | India | Bihar | 26569 | 217 | 16308 | 10044 | 25.679658 | 85.60484 | 2020-07-20 05:34:40 | Bihar, India | ||
2020-07-19 | Chile | Biobio | 9441 | 96 | 7998 | 1347 | -37.4464 | -72.1416 | 2020-07-20 05:34:40 | Biobio, Chile | ||
2020-07-19 | Sweden | Blekinge | 478 | 14 | 0 | 464 | 56.2784 | 15.018 | 2020-07-20 05:34:40 | Blekinge, Sweden | ||
2020-07-19 | Colombia | Bolivar | 14972 | 502 | 9507 | 4963 | 8.6704 | -74.03 | 2020-07-20 05:34:40 | Bolivar, Colombia | ||
2020-07-19 | Netherlands | Bonaire, Sint Eustatius and Saba | 10 | 0 | 7 | 3 | 12.1784 | -68.2385 | 2020-07-20 05:34:40 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2020-07-19 | Colombia | Boyaca | 640 | 20 | 334 | 286 | 5.4545 | -73.362 | 2020-07-20 05:34:40 | Boyaca, Colombia | ||
2020-07-19 | Germany | Brandenburg | 3476 | 167 | 3260 | 77 | 52.4125 | 12.5316 | 2020-07-20 05:34:40 | Brandenburg, Germany | ||
2020-07-19 | Germany | Bremen | 1718 | 55 | 1623 | 41 | 53.0793 | 8.8017 | 2020-07-20 05:34:40 | Bremen, Germany | ||
2020-07-19 | Canada | British Columbia | 3198 | 189 | 2802 | 207 | 53.7267 | -127.6476 | 2020-07-20 05:34:40 | British Columbia, Canada | ||
2020-07-19 | United Kingdom | British Virgin Islands | 8 | 1 | 7 | 0 | 18.4207 | -64.64 | 2020-07-20 05:34:40 | British Virgin Islands, United Kingdom | ||
2020-07-19 | Russia | Bryansk Oblast | 7038 | 35 | 5416 | 1587 | 52.8873315 | 33.41585300000001 | 2020-07-20 05:34:40 | Bryansk Oblast, Russia | ||
2020-07-19 | Russia | Buryatia Republic | 3651 | 32 | 2804 | 815 | 52.7182426 | 109.492143 | 2020-07-20 05:34:40 | Buryatia Republic, Russia | ||
2020-07-19 | Spain | C. Valenciana | 11933 | 1432 | 9970 | 531 | 39.484 | -0.7533 | 2020-07-20 05:34:40 | C. Valenciana, Spain | ||
2020-07-19 | Peru | Cajamarca | 3857 | 453 | 0 | 3404 | -6.4302839999999994 | -78.74559599999998 | 2020-07-20 05:34:40 | Cajamarca, Peru | ||
2020-07-19 | Italy | Calabria | 1239 | 97 | 1070 | 72 | 38.90597598 | 16.59440194 | 2020-07-20 05:34:40 | Calabria, Italy | ||
2020-07-19 | Colombia | Caldas | 392 | 7 | 245 | 140 | 5.2983 | -75.2479 | 2020-07-20 05:34:40 | Caldas, Colombia | ||
2020-07-19 | Peru | Callao | 19307 | 3278 | 0 | 16029 | -11.954609 | -77.136042 | 2020-07-20 05:34:40 | Callao, Peru | ||
2020-07-19 | Italy | Campania | 4827 | 433 | 4100 | 294 | 40.83956555 | 14.25084984 | 2020-07-20 05:34:40 | Campania, Italy | ||
2020-07-19 | Mexico | Campeche | 3552 | 357 | 2749 | 446 | 19.8301 | -90.5349 | 2020-07-20 05:34:40 | Campeche, Mexico | ||
2020-07-19 | Spain | Canarias | 2483 | 162 | 1537 | 784 | 28.2916 | -16.6291 | 2020-07-20 05:34:40 | Canarias, Spain | ||
2020-07-19 | Spain | Cantabria | 2381 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-20 05:34:40 | Cantabria, Spain | ||
2020-07-19 | Colombia | Capital District | 63265 | 1555 | 24447 | 37263 | 4.711 | -74.0721 | 2020-07-20 05:34:40 | Capital District, Colombia | ||
2020-07-19 | Colombia | Caqueta | 324 | 5 | 38 | 281 | 0.8699 | -73.8419 | 2020-07-20 05:34:40 | Caqueta, Colombia | ||
2020-07-19 | Colombia | Casanare | 155 | 2 | 73 | 80 | 5.7589 | -71.5724 | 2020-07-20 05:34:40 | Casanare, Colombia | ||
2020-07-19 | Spain | Castilla - La Mancha | 18431 | 3034 | 6392 | 9005 | 39.2796 | -3.0977 | 2020-07-20 05:34:40 | Castilla - La Mancha, Spain | ||
2020-07-19 | Spain | Castilla y Leon | 19870 | 2793 | 8716 | 8361 | 41.8357 | -4.3976 | 2020-07-20 05:34:40 | Castilla y Leon, Spain | ||
2020-07-19 | Spain | Catalonia | 67217 | 5678 | 26203 | 35336 | 41.5912 | 1.5209 | 2020-07-20 05:34:40 | Catalonia, Spain | ||
2020-07-19 | Colombia | Cauca | 1107 | 35 | 352 | 720 | 2.705 | -76.82600000000002 | 2020-07-20 05:34:40 | Cauca, Colombia | ||
2020-07-19 | United Kingdom | Cayman Islands | 203 | 1 | 200 | 2 | 19.3133 | -81.2546 | 2020-07-20 05:34:40 | Cayman Islands, United Kingdom | ||
2020-07-19 | Brazil | Ceara | 147378 | 7179 | 120079 | 19715 | -5.4984 | -39.3206 | 2020-07-20 05:34:40 | Ceara, Brazil | ||
2020-07-19 | Colombia | Cesar | 1997 | 38 | 1114 | 845 | 9.3373 | -73.6536 | 2020-07-20 05:34:40 | Cesar, Colombia | ||
2020-07-19 | Spain | Ceuta | 164 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-07-20 05:34:40 | Ceuta, Spain | ||
2020-07-19 | India | Chandigarh | 717 | 12 | 488 | 217 | 30.733839 | 76.76827800000002 | 2020-07-20 05:34:40 | Chandigarh, India | ||
2020-07-19 | United Kingdom | Channel Islands | 0 | 0 | 529 | 7 | 49.3723 | -2.3644 | 2020-07-20 05:34:40 | Channel Islands, United Kingdom | ||
2020-07-19 | Russia | Chechen Republic | 1919 | 29 | 1300 | 590 | 43.39761470000001 | 45.6985005 | 2020-07-20 05:34:40 | Chechen Republic, Russia | ||
2020-07-19 | Russia | Chelyabinsk Oblast | 9682 | 88 | 5404 | 4190 | 54.4223954 | 61.1865846 | 2020-07-20 05:34:40 | Chelyabinsk Oblast, Russia | ||
2020-07-19 | Ukraine | Cherkasy Oblast | 833 | 34 | 615 | 184 | 49.4444 | 32.0598 | 2020-07-20 05:34:40 | Cherkasy Oblast, Ukraine | ||
2020-07-19 | Ukraine | Chernihiv Oblast | 642 | 14 | 309 | 319 | 51.4982 | 31.2893 | 2020-07-20 05:34:40 | Chernihiv Oblast, Ukraine | ||
2020-07-19 | Ukraine | Chernivtsi Oblast | 5311 | 205 | 3424 | 1682 | 48.2917 | 25.9352 | 2020-07-20 05:34:40 | Chernivtsi Oblast, Ukraine | ||
2020-07-19 | India | Chhattisgarh | 5407 | 24 | 3775 | 1608 | 21.264705 | 82.035366 | 2020-07-20 05:34:40 | Chhattisgarh, India | ||
2020-07-19 | Mexico | Chiapas | 5432 | 817 | 4418 | 197 | 16.7569 | -93.1292 | 2020-07-20 05:34:40 | Chiapas, Mexico | ||
2020-07-19 | Japan | Chiba | 1291 | 46 | 967 | 278 | 35.510141 | 140.198917 | 2020-07-20 05:34:40 | Chiba, Japan | ||
2020-07-19 | Mexico | Chihuahua | 4357 | 803 | 3004 | 550 | 28.63300000000001 | -106.0691 | 2020-07-20 05:34:40 | Chihuahua, Mexico | ||
2020-07-19 | Colombia | Choco | 2498 | 81 | 1458 | 959 | 5.2528 | -76.82600000000002 | 2020-07-20 05:34:40 | Choco, Colombia | ||
2020-07-19 | China | Chongqing | 583 | 6 | 576 | 1 | 30.0572 | 107.874 | 2020-07-20 05:34:40 | Chongqing, China |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;