daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,966 rows where "day" is on date 2020-07-24 sorted by fips
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-24 | US | Utah | Bear River | 2049 | 5 | 0 | 2044 | 41.52106798 | -113.08328159999999 | 2020-07-25 04:47:39 | Bear River, Utah, US | |
2020-07-24 | US | Utah | Central Utah | 328 | 1 | 0 | 327 | 39.37231946 | -111.5758676 | 2020-07-25 04:47:39 | Central Utah, Utah, US | |
2020-07-24 | US | Massachusetts | Dukes and Nantucket | 94 | 1 | 0 | 93 | 41.40674725 | -70.68763497 | 2020-07-25 04:47:39 | Dukes and Nantucket, Massachusetts, US | |
2020-07-24 | US | Michigan | Federal Correctional Institution (FCI) | 189 | 5 | 0 | 184 | 47.63197653 | 0.0 | 2020-07-25 04:47:39 | Federal Correctional Institution (FCI), Michigan, US | |
2020-07-24 | US | Missouri | Kansas City | 4558 | 43 | 0 | 4515 | 39.0997 | -94.5786 | 2020-07-25 04:47:39 | Kansas City, Missouri, US | |
2020-07-24 | US | Michigan | Michigan Department of Corrections (MDOC) | 4123 | 68 | 0 | 4055 | 47.63197653 | 0.0 | 2020-07-25 04:47:39 | Michigan Department of Corrections (MDOC), Michigan, US | |
2020-07-24 | US | Utah | Southeast Utah | 69 | 0 | 0 | 69 | 38.99617072 | -110.70139579999999 | 2020-07-25 04:47:39 | Southeast Utah, Utah, US | |
2020-07-24 | US | Utah | Southwest Utah | 2672 | 22 | 0 | 2650 | 37.85447192 | -111.4418764 | 2020-07-25 04:47:39 | Southwest Utah, Utah, US | |
2020-07-24 | US | Utah | TriCounty | 132 | 0 | 0 | 132 | 40.12491499 | -109.5174415 | 2020-07-25 04:47:39 | TriCounty, Utah, US | |
2020-07-24 | US | Utah | Weber-Morgan | 2268 | 24 | 0 | 2244 | 41.27116049 | -111.9145117 | 2020-07-25 04:47:39 | Weber-Morgan, Utah, US | |
2020-07-24 | Italy | Abruzzo | 3356 | 470 | 2773 | 113 | 42.35122196 | 13.39843823 | 2020-07-25 04:47:39 | Abruzzo, Italy | ||
2020-07-24 | Brazil | Acre | 18393 | 480 | 9858 | 8055 | -9.0238 | -70.812 | 2020-07-25 04:47:39 | Acre, Brazil | ||
2020-07-24 | Russia | Adygea Republic | 2496 | 18 | 1978 | 500 | 44.6939006 | 40.1520421 | 2020-07-25 04:47:39 | Adygea Republic, Russia | ||
2020-07-24 | Mexico | Aguascalientes | 3692 | 231 | 2935 | 526 | 21.8853 | -102.2916 | 2020-07-25 04:47:39 | Aguascalientes, Mexico | ||
2020-07-24 | Japan | Aichi | 942 | 35 | 496 | 411 | 35.035551 | 137.211621 | 2020-07-25 04:47:39 | Aichi, Japan | ||
2020-07-24 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748679 | 140.408228 | 2020-07-25 04:47:39 | Akita, Japan | ||
2020-07-24 | Brazil | Alagoas | 53713 | 1471 | 46392 | 5850 | -9.5713 | -36.782 | 2020-07-25 04:47:39 | Alagoas, Brazil | ||
2020-07-24 | Canada | Alberta | 10086 | 178 | 8567 | 1341 | 53.9333 | -116.5765 | 2020-07-25 04:47:39 | Alberta, Canada | ||
2020-07-24 | Russia | Altai Krai | 8253 | 59 | 5926 | 2268 | 52.693224300000004 | 82.69314240000001 | 2020-07-25 04:47:39 | Altai Krai, Russia | ||
2020-07-24 | Russia | Altai Republic | 1387 | 1 | 916 | 470 | 50.7114101 | 86.8572186 | 2020-07-25 04:47:39 | Altai Republic, Russia | ||
2020-07-24 | Brazil | Amapa | 35026 | 552 | 23296 | 11178 | 0.902 | -52.003 | 2020-07-25 04:47:39 | Amapa, Brazil | ||
2020-07-24 | Brazil | Amazonas | 95424 | 3199 | 77890 | 14335 | -3.4168 | -65.8561 | 2020-07-25 04:47:39 | Amazonas, Brazil | ||
2020-07-24 | Colombia | Amazonas | 2479 | 101 | 2296 | 82 | -1.4429 | -71.5724 | 2020-07-25 04:47:39 | Amazonas, Colombia | ||
2020-07-24 | Peru | Amazonas | 4529 | 294 | 0 | 4235 | -5.077253 | -78.050172 | 2020-07-25 04:47:39 | Amazonas, Peru | ||
2020-07-24 | Russia | Amur Oblast | 2534 | 45 | 1730 | 759 | 52.8032368 | 128.437295 | 2020-07-25 04:47:39 | Amur Oblast, Russia | ||
2020-07-24 | Peru | Ancash | 10902 | 1675 | 0 | 9227 | -9.407125 | -77.67179499999997 | 2020-07-25 04:47:39 | Ancash, Peru | ||
2020-07-24 | Spain | Andalusia | 14328 | 1436 | 10671 | 2221 | 37.5443 | -4.7278 | 2020-07-25 04:47:39 | Andalusia, Spain | ||
2020-07-24 | India | Andaman and Nicobar Islands | 259 | 0 | 174 | 85 | 11.225999 | 92.968178 | 2020-07-25 04:47:39 | Andaman and Nicobar Islands, India | ||
2020-07-24 | India | Andhra Pradesh | 80858 | 933 | 39935 | 39990 | 15.9129 | 79.74 | 2020-07-25 04:47:39 | Andhra Pradesh, India | ||
2020-07-24 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-07-25 04:47:39 | Anguilla, United Kingdom | ||
2020-07-24 | China | Anhui | 991 | 6 | 985 | 0 | 31.8257 | 117.2264 | 2020-07-25 04:47:39 | Anhui, China | ||
2020-07-24 | Colombia | Antioquia | 21922 | 301 | 6011 | 15610 | 7.1986 | -75.3412 | 2020-07-25 04:47:39 | Antioquia, Colombia | ||
2020-07-24 | Chile | Antofagasta | 13807 | 310 | 12194 | 1303 | -23.6509 | -70.3975 | 2020-07-25 04:47:39 | Antofagasta, Chile | ||
2020-07-24 | Japan | Aomori | 31 | 1 | 26 | 4 | 40.781541 | 140.828896 | 2020-07-25 04:47:39 | Aomori, Japan | ||
2020-07-24 | Peru | Apurimac | 776 | 49 | 0 | 727 | -14.027713 | -72.975378 | 2020-07-25 04:47:39 | Apurimac, Peru | ||
2020-07-24 | Spain | Aragon | 9772 | 915 | 3772 | 5085 | 41.5976 | -0.9057 | 2020-07-25 04:47:39 | Aragon, Spain | ||
2020-07-24 | Colombia | Arauca | 174 | 1 | 106 | 67 | 7.0762 | -70.7105 | 2020-07-25 04:47:39 | Arauca, Colombia | ||
2020-07-24 | Chile | Araucania | 3852 | 74 | 3577 | 201 | -38.9489 | -72.3311 | 2020-07-25 04:47:39 | Araucania, Chile | ||
2020-07-24 | Peru | Arequipa | 11703 | 1815 | 0 | 9888 | -15.843524 | -72.475539 | 2020-07-25 04:47:39 | Arequipa, Peru | ||
2020-07-24 | Chile | Arica y Parinacota | 3627 | 43 | 2671 | 913 | -18.594 | -69.4785 | 2020-07-25 04:47:39 | Arica y Parinacota, Chile | ||
2020-07-24 | Russia | Arkhangelsk Oblast | 8225 | 148 | 6559 | 1518 | 63.5589686 | 43.1221646 | 2020-07-25 04:47:39 | Arkhangelsk Oblast, Russia | ||
2020-07-24 | Netherlands | Aruba | 118 | 3 | 101 | 14 | 12.5211 | -69.9683 | 2020-07-25 04:47:39 | Aruba, Netherlands | ||
2020-07-24 | India | Arunachal Pradesh | 1056 | 3 | 392 | 661 | 27.768456 | 96.384277 | 2020-07-25 04:47:39 | Arunachal Pradesh, India | ||
2020-07-24 | India | Assam | 29921 | 76 | 21761 | 8084 | 26.357149 | 92.830441 | 2020-07-25 04:47:39 | Assam, India | ||
2020-07-24 | Russia | Astrakhan Oblast | 4341 | 42 | 3349 | 950 | 47.1878186 | 47.608851 | 2020-07-25 04:47:39 | Astrakhan Oblast, Russia | ||
2020-07-24 | Spain | Asturias | 2454 | 334 | 1063 | 1057 | 43.3614 | -5.8593 | 2020-07-25 04:47:39 | Asturias, Spain | ||
2020-07-24 | Chile | Atacama | 2109 | 10 | 1659 | 440 | -27.5661 | -70.0503 | 2020-07-25 04:47:39 | Atacama, Chile | ||
2020-07-24 | Colombia | Atlantico | 47005 | 2332 | 29592 | 15081 | 10.6966 | -74.8741 | 2020-07-25 04:47:39 | Atlantico, Colombia | ||
2020-07-24 | Australia | Australian Capital Territory | 113 | 3 | 109 | 1 | -35.4735 | 149.0124 | 2020-07-25 04:47:39 | Australian Capital Territory, Australia | ||
2020-07-24 | Peru | Ayacucho | 3170 | 211 | 0 | 2959 | -14.091648 | -74.08344 | 2020-07-25 04:47:39 | Ayacucho, Peru | ||
2020-07-24 | Chile | Aysen | 70 | 1 | 59 | 10 | -45.9864 | -73.7669 | 2020-07-25 04:47:39 | Aysen, Chile | ||
2020-07-24 | Pakistan | Azad Jammu and Kashmir | 2012 | 49 | 1409 | 554 | 34.027401 | 73.947253 | 2020-07-25 04:47:39 | Azad Jammu and Kashmir, Pakistan | ||
2020-07-24 | Germany | Baden-Wurttemberg | 36731 | 1839 | 34260 | 727 | 48.6616 | 9.3501 | 2020-07-25 04:47:39 | Baden-Wurttemberg, Germany | ||
2020-07-24 | Brazil | Bahia | 142767 | 3096 | 120862 | 18809 | -12.5797 | -41.7007 | 2020-07-25 04:47:39 | Bahia, Brazil | ||
2020-07-24 | Mexico | Baja California | 12655 | 2469 | 9332 | 854 | 30.8406 | -115.2838 | 2020-07-25 04:47:39 | Baja California, Mexico | ||
2020-07-24 | Mexico | Baja California Sur | 3586 | 136 | 2546 | 904 | 26.0444 | -111.6661 | 2020-07-25 04:47:39 | Baja California Sur, Mexico | ||
2020-07-24 | Spain | Baleares | 2343 | 224 | 1533 | 586 | 39.710358 | 2.995148 | 2020-07-25 04:47:39 | Baleares, Spain | ||
2020-07-24 | Pakistan | Balochistan | 11550 | 136 | 9899 | 1515 | 28.328491999999997 | 65.898403 | 2020-07-25 04:47:39 | Balochistan, Pakistan | ||
2020-07-24 | Russia | Bashkortostan Republic | 6500 | 21 | 4781 | 1698 | 54.8573563 | 57.1439682 | 2020-07-25 04:47:39 | Bashkortostan Republic, Russia | ||
2020-07-24 | Italy | Basilicata | 447 | 28 | 373 | 46 | 40.63947052 | 15.80514834 | 2020-07-25 04:47:39 | Basilicata, Italy | ||
2020-07-24 | Germany | Bayern | 50112 | 2619 | 46600 | 908 | 48.7904 | 11.4979 | 2020-07-25 04:47:39 | Bayern, Germany | ||
2020-07-24 | China | Beijing | 929 | 9 | 867 | 53 | 40.1824 | 116.4142 | 2020-07-25 04:47:39 | Beijing, China | ||
2020-07-24 | Russia | Belgorod Oblast | 5656 | 46 | 5349 | 261 | 50.7080119 | 37.5837615 | 2020-07-25 04:47:39 | Belgorod Oblast, Russia | ||
2020-07-24 | Germany | Berlin | 8894 | 222 | 8418 | 315 | 52.52 | 13.405 | 2020-07-25 04:47:39 | Berlin, Germany | ||
2020-07-24 | United Kingdom | Bermuda | 153 | 9 | 139 | 5 | 32.3078 | -64.7505 | 2020-07-25 04:47:39 | Bermuda, United Kingdom | ||
2020-07-24 | India | Bihar | 33926 | 220 | 22343 | 11363 | 25.679658 | 85.60484 | 2020-07-25 04:47:39 | Bihar, India | ||
2020-07-24 | Chile | Biobio | 10165 | 103 | 8695 | 1367 | -37.4464 | -72.1416 | 2020-07-25 04:47:39 | Biobio, Chile | ||
2020-07-24 | Sweden | Blekinge | 480 | 14 | 0 | 466 | 56.2784 | 15.017999999999999 | 2020-07-25 04:47:39 | Blekinge, Sweden | ||
2020-07-24 | Colombia | Bolivar | 16118 | 528 | 10947 | 4643 | 8.6704 | -74.03 | 2020-07-25 04:47:39 | Bolivar, Colombia | ||
2020-07-24 | Netherlands | Bonaire, Sint Eustatius and Saba | 11 | 0 | 7 | 4 | 12.1784 | -68.2385 | 2020-07-25 04:47:39 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2020-07-24 | Colombia | Boyaca | 734 | 24 | 386 | 324 | 5.4545 | -73.362 | 2020-07-25 04:47:39 | Boyaca, Colombia | ||
2020-07-24 | Germany | Brandenburg | 3523 | 168 | 3300 | 71 | 52.4125 | 12.5316 | 2020-07-25 04:47:39 | Brandenburg, Germany | ||
2020-07-24 | Germany | Bremen | 1733 | 55 | 1635 | 55 | 53.0793 | 8.8017 | 2020-07-25 04:47:39 | Bremen, Germany | ||
2020-07-24 | Canada | British Columbia | 3392 | 190 | 2898 | 304 | 53.7267 | -127.6476 | 2020-07-25 04:47:39 | British Columbia, Canada | ||
2020-07-24 | United Kingdom | British Virgin Islands | 8 | 1 | 7 | 0 | 18.4207 | -64.64 | 2020-07-25 04:47:39 | British Virgin Islands, United Kingdom | ||
2020-07-24 | Russia | Bryansk Oblast | 7164 | 35 | 5685 | 1444 | 52.887331499999995 | 33.41585300000001 | 2020-07-25 04:47:39 | Bryansk Oblast, Russia | ||
2020-07-24 | Russia | Buryatia Republic | 3824 | 37 | 2994 | 793 | 52.718242599999996 | 109.492143 | 2020-07-25 04:47:39 | Buryatia Republic, Russia | ||
2020-07-24 | Spain | C. Valenciana | 12442 | 1433 | 9970 | 1039 | 39.484 | -0.7533 | 2020-07-25 04:47:39 | C. Valenciana, Spain | ||
2020-07-24 | Peru | Cajamarca | 4785 | 561 | 0 | 4224 | -6.430284 | -78.74559599999998 | 2020-07-25 04:47:39 | Cajamarca, Peru | ||
2020-07-24 | Italy | Calabria | 1246 | 97 | 1071 | 78 | 38.90597598 | 16.59440194 | 2020-07-25 04:47:39 | Calabria, Italy | ||
2020-07-24 | Colombia | Caldas | 583 | 7 | 258 | 318 | 5.2983 | -75.2479 | 2020-07-25 04:47:39 | Caldas, Colombia | ||
2020-07-24 | Peru | Callao | 20333 | 3414 | 0 | 16919 | -11.954609 | -77.136042 | 2020-07-25 04:47:39 | Callao, Peru | ||
2020-07-24 | Italy | Campania | 4880 | 434 | 4114 | 332 | 40.83956555 | 14.25084984 | 2020-07-25 04:47:39 | Campania, Italy | ||
2020-07-24 | Mexico | Campeche | 4039 | 419 | 3110 | 510 | 19.8301 | -90.5349 | 2020-07-25 04:47:39 | Campeche, Mexico | ||
2020-07-24 | Spain | Canarias | 2578 | 162 | 1537 | 879 | 28.2916 | -16.6291 | 2020-07-25 04:47:39 | Canarias, Spain | ||
2020-07-24 | Spain | Cantabria | 2419 | 217 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-25 04:47:39 | Cantabria, Spain | ||
2020-07-24 | Colombia | Capital District | 77889 | 2000 | 32222 | 43667 | 4.711 | -74.0721 | 2020-07-25 04:47:39 | Capital District, Colombia | ||
2020-07-24 | Colombia | Caqueta | 489 | 8 | 55 | 426 | 0.8699 | -73.8419 | 2020-07-25 04:47:39 | Caqueta, Colombia | ||
2020-07-24 | Colombia | Casanare | 202 | 4 | 96 | 102 | 5.7589 | -71.5724 | 2020-07-25 04:47:39 | Casanare, Colombia | ||
2020-07-24 | Spain | Castilla - La Mancha | 18539 | 3032 | 6392 | 9115 | 39.2796 | -3.0977 | 2020-07-25 04:47:39 | Castilla - La Mancha, Spain | ||
2020-07-24 | Spain | Castilla y Leon | 20017 | 2796 | 8716 | 8505 | 41.8357 | -4.3976 | 2020-07-25 04:47:39 | Castilla y Leon, Spain | ||
2020-07-24 | Spain | Catalonia | 72919 | 5680 | 26203 | 41036 | 41.5912 | 1.5209 | 2020-07-25 04:47:39 | Catalonia, Spain | ||
2020-07-24 | Colombia | Cauca | 1416 | 43 | 539 | 834 | 2.705 | -76.82600000000002 | 2020-07-25 04:47:39 | Cauca, Colombia | ||
2020-07-24 | United Kingdom | Cayman Islands | 203 | 1 | 202 | 0 | 19.3133 | -81.2546 | 2020-07-25 04:47:39 | Cayman Islands, United Kingdom | ||
2020-07-24 | Brazil | Ceara | 159953 | 7456 | 129221 | 22177 | -5.4984 | -39.3206 | 2020-07-25 04:47:39 | Ceara, Brazil | ||
2020-07-24 | Colombia | Cesar | 2367 | 46 | 1259 | 1062 | 9.3373 | -73.6536 | 2020-07-25 04:47:39 | Cesar, Colombia | ||
2020-07-24 | Spain | Ceuta | 164 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-07-25 04:47:39 | Ceuta, Spain | ||
2020-07-24 | India | Chandigarh | 823 | 13 | 535 | 275 | 30.733839 | 76.76827800000002 | 2020-07-25 04:47:39 | Chandigarh, India | ||
2020-07-24 | United Kingdom | Channel Islands | 0 | 0 | 533 | 4 | 49.3723 | -2.3644 | 2020-07-25 04:47:39 | Channel Islands, United Kingdom | ||
2020-07-24 | Russia | Chechen Republic | 1971 | 31 | 1326 | 614 | 43.39761470000001 | 45.6985005 | 2020-07-25 04:47:39 | Chechen Republic, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;