daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,829 rows where "day" is on date 2020-07-02 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-02 | US | Utah | Bear River | 1556 | 3 | 0 | 1553 | 41.52106798 | -113.08328159999999 | 2020-07-03 04:33:54 | Bear River, Utah, US | |
2020-07-02 | US | Utah | Central Utah | 180 | 0 | 0 | 180 | 39.37231946 | -111.5758676 | 2020-07-03 04:33:54 | Central Utah, Utah, US | |
2020-07-02 | US | Massachusetts | Dukes and Nantucket | 66 | 1 | 0 | 65 | 41.40674725 | -70.68763497 | 2020-07-03 04:33:54 | Dukes and Nantucket, Massachusetts, US | |
2020-07-02 | US | Michigan | Federal Correctional Institution (FCI) | 184 | 5 | 0 | 179 | 47.63197653 | 0.0 | 2020-07-03 04:33:54 | Federal Correctional Institution (FCI), Michigan, US | |
2020-07-02 | US | Missouri | Kansas City | 2497 | 31 | 0 | 2466 | 39.0997 | -94.5786 | 2020-07-03 04:33:54 | Kansas City, Missouri, US | |
2020-07-02 | US | Michigan | Michigan Department of Corrections (MDOC) | 4114 | 68 | 0 | 4046 | 47.63197653 | 0.0 | 2020-07-03 04:33:54 | Michigan Department of Corrections (MDOC), Michigan, US | |
2020-07-02 | US | Utah | Southeast Utah | 39 | 0 | 0 | 39 | 38.99617072 | -110.70139579999999 | 2020-07-03 04:33:54 | Southeast Utah, Utah, US | |
2020-07-02 | US | Utah | Southwest Utah | 1584 | 11 | 0 | 1573 | 37.85447192 | -111.4418764 | 2020-07-03 04:33:54 | Southwest Utah, Utah, US | |
2020-07-02 | US | Utah | TriCounty | 52 | 0 | 0 | 52 | 40.12491499 | -109.5174415 | 2020-07-03 04:33:54 | TriCounty, Utah, US | |
2020-07-02 | US | Utah | Weber-Morgan | 1042 | 13 | 0 | 1029 | 41.27116049 | -111.9145117 | 2020-07-03 04:33:54 | Weber-Morgan, Utah, US | |
2020-07-02 | Italy | Abruzzo | 3292 | 464 | 2668 | 160 | 42.35122196 | 13.39843823 | 2020-07-03 04:33:54 | Abruzzo, Italy | ||
2020-07-02 | Brazil | Acre | 14048 | 378 | 7650 | 6020 | -9.0238 | -70.812 | 2020-07-03 04:33:54 | Acre, Brazil | ||
2020-07-02 | Russia | Adygea Republic | 1981 | 14 | 1363 | 604 | 44.6939006 | 40.1520421 | 2020-07-03 04:33:54 | Adygea Republic, Russia | ||
2020-07-02 | Mexico | Aguascalientes | 2399 | 154 | 1933 | 312 | 21.8853 | -102.2916 | 2020-07-03 04:33:54 | Aguascalientes, Mexico | ||
2020-07-02 | Japan | Aichi | 528 | 34 | 478 | 16 | 35.035551 | 137.211621 | 2020-07-03 04:33:54 | Aichi, Japan | ||
2020-07-02 | Japan | Akita | 16 | 0 | 16 | 0 | 39.748679 | 140.408228 | 2020-07-03 04:33:54 | Akita, Japan | ||
2020-07-02 | Brazil | Alagoas | 37328 | 1091 | 29185 | 7052 | -9.5713 | -36.782 | 2020-07-03 04:33:54 | Alagoas, Brazil | ||
2020-07-02 | Canada | Alberta | 8202 | 155 | 7505 | 542 | 53.9333 | -116.5765 | 2020-07-03 04:33:54 | Alberta, Canada | ||
2020-07-02 | Russia | Altai Krai | 4134 | 38 | 2991 | 1105 | 52.693224300000004 | 82.69314240000001 | 2020-07-03 04:33:54 | Altai Krai, Russia | ||
2020-07-02 | Russia | Altai Republic | 745 | 1 | 314 | 430 | 50.7114101 | 86.8572186 | 2020-07-03 04:33:54 | Altai Republic, Russia | ||
2020-07-02 | Brazil | Amapa | 29153 | 427 | 16298 | 12428 | 0.902 | -52.003 | 2020-07-03 04:33:54 | Amapa, Brazil | ||
2020-07-02 | Brazil | Amazonas | 73530 | 2862 | 59883 | 10785 | -3.4168 | -65.8561 | 2020-07-03 04:33:54 | Amazonas, Brazil | ||
2020-07-02 | Colombia | Amazonas | 2319 | 90 | 1951 | 278 | -1.4429 | -71.5724 | 2020-07-03 04:33:54 | Amazonas, Colombia | ||
2020-07-02 | Peru | Amazonas | 2329 | 139 | 0 | 2190 | -5.077253 | -78.050172 | 2020-07-03 04:33:54 | Amazonas, Peru | ||
2020-07-02 | Russia | Amur Oblast | 1765 | 13 | 842 | 910 | 52.8032368 | 128.437295 | 2020-07-03 04:33:54 | Amur Oblast, Russia | ||
2020-07-02 | Peru | Ancash | 8263 | 1242 | 0 | 7021 | -9.407125 | -77.67179499999997 | 2020-07-03 04:33:54 | Ancash, Peru | ||
2020-07-02 | Spain | Andalusia | 13123 | 1428 | 10671 | 1024 | 37.5443 | -4.7278 | 2020-07-03 04:33:54 | Andalusia, Spain | ||
2020-07-02 | India | Andaman and Nicobar Islands | 109 | 0 | 51 | 58 | 11.225999 | 92.968178 | 2020-07-03 04:33:54 | Andaman and Nicobar Islands, India | ||
2020-07-02 | India | Andhra Pradesh | 16097 | 198 | 7313 | 8586 | 15.9129 | 79.74 | 2020-07-03 04:33:54 | Andhra Pradesh, India | ||
2020-07-02 | United Kingdom | Anguilla | 3 | 0 | 3 | 0 | 18.2206 | -63.0686 | 2020-07-03 04:33:54 | Anguilla, United Kingdom | ||
2020-07-02 | China | Anhui | 991 | 6 | 985 | 0 | 31.8257 | 117.2264 | 2020-07-03 04:33:54 | Anhui, China | ||
2020-07-02 | Colombia | Antioquia | 4660 | 30 | 1921 | 2709 | 7.1986 | -75.3412 | 2020-07-03 04:33:54 | Antioquia, Colombia | ||
2020-07-02 | Chile | Antofagasta | 9285 | 163 | 7375 | 1747 | -23.6509 | -70.3975 | 2020-07-03 04:33:54 | Antofagasta, Chile | ||
2020-07-02 | Japan | Aomori | 27 | 1 | 26 | 0 | 40.781541 | 140.828896 | 2020-07-03 04:33:54 | Aomori, Japan | ||
2020-07-02 | Peru | Apurimac | 569 | 31 | 0 | 538 | -14.027713 | -72.975378 | 2020-07-03 04:33:54 | Apurimac, Peru | ||
2020-07-02 | Spain | Aragon | 6380 | 912 | 3772 | 1696 | 41.5976 | -0.9057 | 2020-07-03 04:33:54 | Aragon, Spain | ||
2020-07-02 | Colombia | Arauca | 80 | 0 | 4 | 76 | 7.0762 | -70.7105 | 2020-07-03 04:33:54 | Arauca, Colombia | ||
2020-07-02 | Chile | Araucania | 3267 | 41 | 2983 | 243 | -38.9489 | -72.3311 | 2020-07-03 04:33:54 | Araucania, Chile | ||
2020-07-02 | Peru | Arequipa | 7425 | 774 | 0 | 6651 | -15.843524 | -72.475539 | 2020-07-03 04:33:54 | Arequipa, Peru | ||
2020-07-02 | Chile | Arica y Parinacota | 1832 | 21 | 1408 | 403 | -18.594 | -69.4785 | 2020-07-03 04:33:54 | Arica y Parinacota, Chile | ||
2020-07-02 | Russia | Arkhangelsk Oblast | 5790 | 61 | 2989 | 2740 | 63.5589686 | 43.1221646 | 2020-07-03 04:33:54 | Arkhangelsk Oblast, Russia | ||
2020-07-02 | Netherlands | Aruba | 104 | 3 | 98 | 3 | 12.5211 | -69.9683 | 2020-07-03 04:33:54 | Aruba, Netherlands | ||
2020-07-02 | India | Arunachal Pradesh | 195 | 1 | 66 | 128 | 27.768456 | 96.384277 | 2020-07-03 04:33:54 | Arunachal Pradesh, India | ||
2020-07-02 | India | Assam | 9013 | 12 | 6106 | 2895 | 26.357149 | 92.830441 | 2020-07-03 04:33:54 | Assam, India | ||
2020-07-02 | Russia | Astrakhan Oblast | 3548 | 32 | 2363 | 1153 | 47.1878186 | 47.608851 | 2020-07-03 04:33:54 | Astrakhan Oblast, Russia | ||
2020-07-02 | Spain | Asturias | 2435 | 334 | 1063 | 1038 | 43.3614 | -5.8593 | 2020-07-03 04:33:54 | Asturias, Spain | ||
2020-07-02 | Chile | Atacama | 1135 | 2 | 790 | 343 | -27.5661 | -70.0503 | 2020-07-03 04:33:54 | Atacama, Chile | ||
2020-07-02 | Colombia | Atlantico | 24212 | 1277 | 8149 | 14786 | 10.6966 | -74.8741 | 2020-07-03 04:33:54 | Atlantico, Colombia | ||
2020-07-02 | Australia | Australian Capital Territory | 108 | 3 | 105 | 0 | -35.4735 | 149.0124 | 2020-07-03 04:33:54 | Australian Capital Territory, Australia | ||
2020-07-02 | Peru | Ayacucho | 1865 | 106 | 0 | 1759 | -14.091648 | -74.08344 | 2020-07-03 04:33:54 | Ayacucho, Peru | ||
2020-07-02 | Chile | Aysen | 46 | 0 | 29 | 17 | -45.9864 | -73.7669 | 2020-07-03 04:33:54 | Aysen, Chile | ||
2020-07-02 | Pakistan | Azad Jammu and Kashmir | 1160 | 33 | 686 | 441 | 34.027401 | 73.947253 | 2020-07-03 04:33:54 | Azad Jammu and Kashmir, Pakistan | ||
2020-07-02 | Germany | Baden-Wurttemberg | 35744 | 1838 | 33518 | 423 | 48.6616 | 9.3501 | 2020-07-03 04:33:54 | Baden-Wurttemberg, Germany | ||
2020-07-02 | Brazil | Bahia | 79349 | 1947 | 53334 | 24068 | -12.5797 | -41.7007 | 2020-07-03 04:33:54 | Bahia, Brazil | ||
2020-07-02 | Mexico | Baja California | 9423 | 2007 | 6775 | 641 | 30.8406 | -115.2838 | 2020-07-03 04:33:54 | Baja California, Mexico | ||
2020-07-02 | Mexico | Baja California Sur | 1631 | 79 | 1266 | 286 | 26.0444 | -111.6661 | 2020-07-03 04:33:54 | Baja California Sur, Mexico | ||
2020-07-02 | Spain | Baleares | 2220 | 224 | 1533 | 463 | 39.710358 | 2.995148 | 2020-07-03 04:33:54 | Baleares, Spain | ||
2020-07-02 | Pakistan | Balochistan | 10666 | 122 | 5073 | 5471 | 28.328491999999997 | 65.898403 | 2020-07-03 04:33:54 | Balochistan, Pakistan | ||
2020-07-02 | Russia | Bashkortostan Republic | 5450 | 18 | 3144 | 2288 | 54.8573563 | 57.1439682 | 2020-07-03 04:33:54 | Bashkortostan Republic, Russia | ||
2020-07-02 | Italy | Basilicata | 402 | 27 | 373 | 2 | 40.63947052 | 15.80514834 | 2020-07-03 04:33:54 | Basilicata, Italy | ||
2020-07-02 | Germany | Bayern | 48547 | 2597 | 45210 | 740 | 48.7904 | 11.4979 | 2020-07-03 04:33:54 | Bayern, Germany | ||
2020-07-02 | China | Beijing | 925 | 9 | 592 | 324 | 40.1824 | 116.4142 | 2020-07-03 04:33:54 | Beijing, China | ||
2020-07-02 | Russia | Belgorod Oblast | 4637 | 42 | 3663 | 932 | 50.7080119 | 37.5837615 | 2020-07-03 04:33:54 | Belgorod Oblast, Russia | ||
2020-07-02 | Germany | Berlin | 8302 | 214 | 7515 | 615 | 52.52 | 13.405 | 2020-07-03 04:33:54 | Berlin, Germany | ||
2020-07-02 | United Kingdom | Bermuda | 146 | 9 | 135 | 2 | 32.3078 | -64.7505 | 2020-07-03 04:33:54 | Bermuda, United Kingdom | ||
2020-07-02 | India | Bihar | 10471 | 77 | 8020 | 2374 | 25.679658 | 85.60484 | 2020-07-03 04:33:54 | Bihar, India | ||
2020-07-02 | Chile | Biobio | 6951 | 58 | 5196 | 1697 | -37.4464 | -72.1416 | 2020-07-03 04:33:54 | Biobio, Chile | ||
2020-07-02 | Sweden | Blekinge | 449 | 14 | 0 | 435 | 56.2784 | 15.017999999999999 | 2020-07-03 04:33:54 | Blekinge, Sweden | ||
2020-07-02 | Colombia | Bolivar | 9392 | 388 | 4640 | 4364 | 8.6704 | -74.03 | 2020-07-03 04:33:54 | Bolivar, Colombia | ||
2020-07-02 | Netherlands | Bonaire, Sint Eustatius and Saba | 7 | 0 | 7 | 0 | 12.1784 | -68.2385 | 2020-07-03 04:33:54 | Bonaire, Sint Eustatius and Saba, Netherlands | ||
2020-07-02 | Colombia | Boyaca | 390 | 17 | 228 | 145 | 5.4545 | -73.362 | 2020-07-03 04:33:54 | Boyaca, Colombia | ||
2020-07-02 | Germany | Brandenburg | 3443 | 165 | 3200 | 98 | 52.4125 | 12.5316 | 2020-07-03 04:33:54 | Brandenburg, Germany | ||
2020-07-02 | Germany | Bremen | 1670 | 53 | 1560 | 65 | 53.0793 | 8.8017 | 2020-07-03 04:33:54 | Bremen, Germany | ||
2020-07-02 | Canada | British Columbia | 2940 | 177 | 2603 | 160 | 53.7267 | -127.6476 | 2020-07-03 04:33:54 | British Columbia, Canada | ||
2020-07-02 | United Kingdom | British Virgin Islands | 8 | 1 | 7 | 0 | 18.4207 | -64.64 | 2020-07-03 04:33:54 | British Virgin Islands, United Kingdom | ||
2020-07-02 | Russia | Bryansk Oblast | 6325 | 34 | 4541 | 1750 | 52.887331499999995 | 33.41585300000001 | 2020-07-03 04:33:54 | Bryansk Oblast, Russia | ||
2020-07-02 | Russia | Buryatia Republic | 2991 | 19 | 2059 | 913 | 52.718242599999996 | 109.492143 | 2020-07-03 04:33:54 | Buryatia Republic, Russia | ||
2020-07-02 | Spain | C. Valenciana | 11616 | 1432 | 9970 | 214 | 39.484 | -0.7533 | 2020-07-03 04:33:54 | C. Valenciana, Spain | ||
2020-07-02 | Peru | Cajamarca | 2292 | 176 | 0 | 2116 | -6.430284 | -78.74559599999998 | 2020-07-03 04:33:54 | Cajamarca, Peru | ||
2020-07-02 | Italy | Calabria | 1181 | 97 | 1059 | 25 | 38.90597598 | 16.59440194 | 2020-07-03 04:33:54 | Calabria, Italy | ||
2020-07-02 | Colombia | Caldas | 264 | 8 | 181 | 75 | 5.2983 | -75.2479 | 2020-07-03 04:33:54 | Caldas, Colombia | ||
2020-07-02 | Peru | Callao | 18230 | 2822 | 0 | 15408 | -11.954609 | -77.136042 | 2020-07-03 04:33:54 | Callao, Peru | ||
2020-07-02 | Italy | Campania | 4702 | 432 | 4080 | 190 | 40.83956555 | 14.25084984 | 2020-07-03 04:33:54 | Campania, Italy | ||
2020-07-02 | Mexico | Campeche | 2092 | 223 | 1642 | 227 | 19.8301 | -90.5349 | 2020-07-03 04:33:54 | Campeche, Mexico | ||
2020-07-02 | Spain | Canarias | 2431 | 162 | 1537 | 732 | 28.2916 | -16.6291 | 2020-07-03 04:33:54 | Canarias, Spain | ||
2020-07-02 | Spain | Cantabria | 2364 | 216 | 2287 | 0 | 43.1828 | -3.9878 | 2020-07-03 04:33:54 | Cantabria, Spain | ||
2020-07-02 | Colombia | Capital District | 31417 | 735 | 13065 | 17617 | 4.711 | -74.0721 | 2020-07-03 04:33:54 | Capital District, Colombia | ||
2020-07-02 | Colombia | Caqueta | 39 | 2 | 22 | 15 | 0.8699 | -73.8419 | 2020-07-03 04:33:54 | Caqueta, Colombia | ||
2020-07-02 | Colombia | Casanare | 67 | 0 | 47 | 20 | 5.7589 | -71.5724 | 2020-07-03 04:33:54 | Casanare, Colombia | ||
2020-07-02 | Spain | Castilla - La Mancha | 18187 | 3026 | 6392 | 8769 | 39.2796 | -3.0977 | 2020-07-03 04:33:54 | Castilla - La Mancha, Spain | ||
2020-07-02 | Spain | Castilla y Leon | 19750 | 2787 | 8716 | 8247 | 41.8357 | -4.3976 | 2020-07-03 04:33:54 | Castilla y Leon, Spain | ||
2020-07-02 | Spain | Catalonia | 61888 | 5673 | 26203 | 30012 | 41.5912 | 1.5209 | 2020-07-03 04:33:54 | Catalonia, Spain | ||
2020-07-02 | Colombia | Cauca | 405 | 18 | 161 | 226 | 2.705 | -76.82600000000002 | 2020-07-03 04:33:54 | Cauca, Colombia | ||
2020-07-02 | United Kingdom | Cayman Islands | 201 | 1 | 194 | 6 | 19.3133 | -81.2546 | 2020-07-03 04:33:54 | Cayman Islands, United Kingdom | ||
2020-07-02 | Brazil | Ceara | 116519 | 6307 | 90085 | 19155 | -5.4984 | -39.3206 | 2020-07-03 04:33:54 | Ceara, Brazil | ||
2020-07-02 | Colombia | Cesar | 1071 | 27 | 475 | 569 | 9.3373 | -73.6536 | 2020-07-03 04:33:54 | Cesar, Colombia | ||
2020-07-02 | Spain | Ceuta | 163 | 4 | 163 | 0 | 35.8894 | -5.3213 | 2020-07-03 04:33:54 | Ceuta, Spain | ||
2020-07-02 | India | Chandigarh | 450 | 6 | 389 | 55 | 30.733839 | 76.76827800000002 | 2020-07-03 04:33:54 | Chandigarh, India | ||
2020-07-02 | United Kingdom | Channel Islands | 0 | 0 | 512 | 12 | 49.3723 | -2.3644 | 2020-07-03 04:33:54 | Channel Islands, United Kingdom | ||
2020-07-02 | Russia | Chechen Republic | 1736 | 23 | 1198 | 515 | 43.39761470000001 | 45.6985005 | 2020-07-03 04:33:54 | Chechen Republic, Russia |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;