johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,456 rows where active = 50 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 2,139
- Japan 61
- Colombia 21
- India 17
- China 16
- United Kingdom 13
- Canada 12
- Australia 11
- Russia 11
- Malaysia 10
- Ukraine 9
- Burundi 6
- Chile 6
- Congo (Brazzaville) 6
- Estonia 6
- Papua New Guinea 6
- Djibouti 5
- Equatorial Guinea 5
- Italy 5
- Vietnam 5
- Cambodia 4
- Iceland 4
- Mexico 4
- Monaco 4
- New Zealand 4
- Pakistan 4
- Chad 3
- France 3
- Saint Vincent and the Grenadines 3
- Taiwan* 3
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3471820 | 3471820 | 2021-08-03 | Ukraine | Volyn Oblast | 62308 | 1205 | 61053 | 50 | 50.7472 | 25.3254 | 2021-08-04 04:21:25 | Volyn Oblast, Ukraine | ||
3468081 | 3468081 | 2021-08-03 | Gabon | 25405 | 164 | 25191 | 50 | -0.8037 | 11.6094 | 2021-08-04 04:21:25 | Gabon | |||
3683355 | 3683355 | 2021-08-02 | Gabon | 25405 | 164 | 25191 | 50 | -0.8037 | 11.6094 | 2021-08-03 04:21:39 | Gabon | |||
3015620 | 3015620 | 2021-08-01 | Saint Vincent and the Grenadines | 2291 | 12 | 2229 | 50 | 12.9843 | -61.2872 | 2021-08-02 04:21:36 | Saint Vincent and the Grenadines | |||
3015107 | 3015107 | 2021-08-01 | Burkina Faso | 13588 | 169 | 13369 | 50 | 12.2383 | -1.5616 | 2021-08-02 04:21:36 | Burkina Faso | |||
3907616 | 3907616 | 2021-07-31 | Ukraine | Volyn Oblast | 62301 | 1204 | 61047 | 50 | 50.7472 | 25.3254 | 2021-08-01 04:21:50 | Volyn Oblast, Ukraine | ||
3904243 | 3904243 | 2021-07-31 | Saint Vincent and the Grenadines | 2291 | 12 | 2229 | 50 | 12.9843 | -61.2872 | 2021-08-01 04:21:50 | Saint Vincent and the Grenadines | |||
3296448 | 3296448 | 2021-07-30 | Saint Vincent and the Grenadines | 2291 | 12 | 2229 | 50 | 12.9843 | -61.2872 | 2021-07-31 04:21:35 | Saint Vincent and the Grenadines | |||
3296131 | 3296131 | 2021-07-30 | India | Ladakh | 20328 | 207 | 20071 | 50 | 34.1526 | 77.5771 | 2021-07-31 04:21:35 | Ladakh, India | ||
1309798 | 1309798 | 2021-07-27 | Ukraine | Volyn Oblast | 62274 | 1204 | 61020 | 50 | 50.7472 | 25.3254 | 2021-07-28 04:21:39 | Volyn Oblast, Ukraine | ||
1333890 | 1333890 | 2021-07-24 | Ukraine | Volyn Oblast | 62269 | 1204 | 61015 | 50 | 50.7472 | 25.3254 | 2021-07-25 04:22:12 | Volyn Oblast, Ukraine | ||
3476009 | 3476009 | 2021-07-22 | Australia | Queensland | 1764 | 7 | 1707 | 50 | -27.4698 | 153.0251 | 2021-07-23 04:21:29 | Queensland, Australia | ||
3331531 | 3331531 | 2021-07-21 | Japan | Akita | 984 | 20 | 914 | 50 | 39.748679 | 140.408228 | 2021-07-22 04:21:19 | Akita, Japan | ||
483591 | 483591 | 2021-07-19 | Japan | Akita | 974 | 20 | 904 | 50 | 39.748679 | 140.408228 | 2021-07-20 04:21:48 | Akita, Japan | ||
483422 | 483422 | 2021-07-19 | Colombia | Amazonas | 6512 | 248 | 6214 | 50 | -1.4429 | -71.5724 | 2021-07-20 04:21:48 | Amazonas, Colombia | ||
2673814 | 2673814 | 2021-07-18 | Japan | Akita | 974 | 20 | 904 | 50 | 39.748679 | 140.408228 | 2021-07-19 04:21:24 | Akita, Japan | ||
2673754 | 2673754 | 2021-07-18 | India | Chandigarh | 61889 | 809 | 61030 | 50 | 30.733839 | 76.76827800000002 | 2021-07-19 04:21:24 | Chandigarh, India | ||
2673582 | 2673582 | 2021-07-18 | Canada | Newfoundland and Labrador | 1433 | 7 | 1376 | 50 | 53.1355 | -57.6604 | 2021-07-19 04:21:24 | Newfoundland and Labrador, Canada | ||
3706151 | 3706151 | 2021-07-17 | Japan | Nagasaki | 3264 | 69 | 3145 | 50 | 33.235712 | 129.608033 | 2021-07-18 04:22:07 | Nagasaki, Japan | ||
3705894 | 3705894 | 2021-07-17 | Canada | Newfoundland and Labrador | 1433 | 7 | 1376 | 50 | 53.1355 | -57.6604 | 2021-07-18 04:22:07 | Newfoundland and Labrador, Canada | ||
2947221 | 2947221 | 2021-07-16 | Colombia | Vichada | 2743 | 45 | 2648 | 50 | 4.4234 | -69.2878 | 2021-07-17 04:22:22 | Vichada, Colombia | ||
2947125 | 2947125 | 2021-07-16 | Canada | Newfoundland and Labrador | 1433 | 7 | 1376 | 50 | 53.1355 | -57.6604 | 2021-07-17 04:22:22 | Newfoundland and Labrador, Canada | ||
296058 | 296058 | 2021-07-15 | Japan | Yamagata | 2075 | 47 | 1978 | 50 | 38.448396 | 140.102154 | 2021-07-16 04:21:22 | Yamagata, Japan | ||
295781 | 295781 | 2021-07-15 | Canada | Newfoundland and Labrador | 1433 | 7 | 1376 | 50 | 53.1355 | -57.6604 | 2021-07-16 04:21:22 | Newfoundland and Labrador, Canada | ||
3631788 | 3631788 | 2021-07-14 | China | Zhejiang | 1388 | 1 | 1337 | 50 | 29.1832 | 120.0934 | 2021-07-15 04:21:48 | Zhejiang, China | ||
3741090 | 3741090 | 2021-07-12 | Japan | Gunma | 8091 | 154 | 7887 | 50 | 36.504479 | 138.985605 | 2021-07-13 04:21:18 | Gunma, Japan | ||
625868 | 625868 | 2021-07-10 | Italy | P.A. Trento | 45810 | 1363 | 44397 | 50 | 46.06893511 | 11.12123097 | 2021-07-11 04:21:43 | P.A. Trento, Italy | ||
1444239 | 1444239 | 2021-07-07 | United Kingdom | Isle of Man | 1650 | 29 | 1571 | 50 | 54.2361 | -4.5481 | 2021-07-08 04:21:26 | Isle of Man, United Kingdom | ||
2693489 | 2693489 | 2021-07-06 | China | Fujian | 690 | 1 | 639 | 50 | 26.0789 | 117.9874 | 2021-07-07 04:21:20 | Fujian, China | ||
1164991 | 1164991 | 2021-07-04 | China | Shanghai | 2218 | 7 | 2161 | 50 | 31.202 | 121.4491 | 2021-07-05 04:21:28 | Shanghai, China | ||
400307 | 400307 | 2021-06-29 | Japan | Toyama | 2040 | 38 | 1952 | 50 | 36.637464 | 137.26934599999998 | 2021-06-30 04:21:41 | Toyama, Japan | ||
3125703 | 3125703 | 2021-06-28 | Russia | Chukotka Autonomous Okrug | 809 | 8 | 751 | 50 | 66.0006475 | 169.4900869 | 2021-06-29 04:21:28 | Chukotka Autonomous Okrug, Russia | ||
3125522 | 3125522 | 2021-06-28 | Japan | Iwate | 1667 | 46 | 1571 | 50 | 39.593287 | 141.361777 | 2021-06-29 04:21:28 | Iwate, Japan | ||
3958204 | 3958204 | 2021-06-26 | Australia | Queensland | 1683 | 7 | 1626 | 50 | -27.4698 | 153.0251 | 2021-06-27 04:21:39 | Queensland, Australia | ||
2422591 | 2422591 | 2021-06-23 | Australia | Victoria | 20699 | 820 | 19829 | 50 | -37.8136 | 144.9631 | 2021-06-24 04:21:55 | Victoria, Australia | ||
2422588 | 2422588 | 2021-06-23 | Australia | Queensland | 1678 | 7 | 1621 | 50 | -27.4698 | 153.0251 | 2021-06-24 04:21:55 | Queensland, Australia | ||
562735 | 562735 | 2021-06-22 | Canada | New Brunswick | 2319 | 45 | 2224 | 50 | 46.5653 | -66.4619 | 2021-06-23 04:21:46 | New Brunswick, Canada | ||
562668 | 562668 | 2021-06-22 | Australia | Victoria | 20697 | 820 | 19827 | 50 | -37.8136 | 144.9631 | 2021-06-23 04:21:46 | Victoria, Australia | ||
2911188 | 2911188 | 2021-06-17 | Japan | Kagawa | 2078 | 29 | 1999 | 50 | 34.217292 | 133.969047 | 2021-06-18 04:22:16 | Kagawa, Japan | ||
523057 | 523057 | 2021-06-09 | Russia | Jewish Autonomous Okrug | 4520 | 144 | 4326 | 50 | 48.57527615 | 132.66307460000002 | 2021-06-10 04:23:17 | Jewish Autonomous Okrug, Russia | ||
3145615 | 3145615 | 2021-06-07 | Japan | Saga | 2528 | 22 | 2456 | 50 | 33.286977 | 130.115738 | 2021-06-08 04:22:35 | Saga, Japan | ||
1708143 | 1708143 | 2021-06-02 | Colombia | Amazonas | 6346 | 241 | 6055 | 50 | -1.4429 | -71.5724 | 2021-06-03 04:23:32 | Amazonas, Colombia | ||
726433 | 726433 | 2021-05-22 | Iceland | 6555 | 29 | 6476 | 50 | 64.9631 | -19.0208 | 2021-05-23 04:20:51 | Iceland | |||
1952448 | 1952448 | 2021-05-21 | Iceland | 6555 | 29 | 6476 | 50 | 64.9631 | -19.0208 | 2021-05-22 04:20:45 | Iceland | |||
1952401 | 1952401 | 2021-05-21 | Eswatini | 18546 | 672 | 17824 | 50 | -26.5225 | 31.4659 | 2021-05-22 04:20:45 | Eswatini | |||
1913147 | 1913147 | 2021-05-20 | Iceland | 6555 | 29 | 6476 | 50 | 64.9631 | -19.0208 | 2021-05-21 04:20:43 | Iceland | |||
2255621 | 2255621 | 2021-05-19 | Eswatini | 18530 | 672 | 17808 | 50 | -26.5225 | 31.4659 | 2021-05-20 04:21:05 | Eswatini | |||
2939173 | 2939173 | 2021-05-16 | Colombia | Guainia | 1540 | 22 | 1468 | 50 | 2.5854 | -68.5247 | 2021-05-17 04:20:34 | Guainia, Colombia | ||
1872975 | 1872975 | 2021-05-15 | Japan | Kochi | 1148 | 20 | 1078 | 50 | 33.422519 | 133.367307 | 2021-05-16 04:20:49 | Kochi, Japan | ||
1872736 | 1872736 | 2021-05-15 | Chad | 4901 | 173 | 4678 | 50 | 15.4542 | 18.7322 | 2021-05-16 04:20:49 | Chad | |||
2004703 | 2004703 | 2021-05-12 | Japan | Tottori | 406 | 2 | 354 | 50 | 35.359069 | 133.863619 | 2021-05-13 04:20:51 | Tottori, Japan | ||
3954534 | 3954534 | 2021-05-11 | Japan | Tottori | 405 | 2 | 353 | 50 | 35.359069 | 133.863619 | 2021-05-12 04:21:29 | Tottori, Japan | ||
2824415 | 2824415 | 2021-05-10 | United Kingdom | Anguilla | 99 | 0 | 49 | 50 | 18.2206 | -63.0686 | 2021-05-11 04:20:41 | Anguilla, United Kingdom | ||
1428747 | 1428747 | 2021-05-09 | United Kingdom | Anguilla | 99 | 0 | 49 | 50 | 18.2206 | -63.0686 | 2021-05-10 04:20:38 | Anguilla, United Kingdom | ||
1424906 | 1424906 | 2021-05-09 | China | Guangdong | 2372 | 8 | 2314 | 50 | 23.3417 | 113.4244 | 2021-05-10 04:20:38 | Guangdong, China | ||
1555615 | 1555615 | 2021-05-08 | United Kingdom | Anguilla | 99 | 0 | 49 | 50 | 18.2206 | -63.0686 | 2021-05-09 04:20:35 | Anguilla, United Kingdom | ||
2760617 | 2760617 | 2021-05-03 | Australia | Queensland | 1568 | 7 | 1511 | 50 | -27.4698 | 153.0251 | 2021-05-04 04:20:34 | Queensland, Australia | ||
2450971 | 2450971 | 2021-05-02 | Russia | Jewish Autonomous Okrug | 4468 | 131 | 4287 | 50 | 48.57527615 | 132.66307460000002 | 2021-05-03 04:20:39 | Jewish Autonomous Okrug, Russia | ||
380083 | 380083 | 2021-04-30 | Fiji | 117 | 2 | 65 | 50 | -17.7134 | 178.065 | 2021-05-01 04:20:47 | Fiji | |||
1636014 | 1636014 | 2021-04-29 | Australia | Queensland | 1559 | 7 | 1502 | 50 | -27.4698 | 153.0251 | 2021-04-30 04:21:03 | Queensland, Australia | ||
3393167 | 3393167 | 2021-04-28 | Canada | Nunavut | 478 | 4 | 424 | 50 | 70.2998 | -83.1076 | 2021-04-29 04:20:55 | Nunavut, Canada | ||
170270 | 170270 | 2021-04-16 | Russia | Nenets Autonomous Okrug | 1093 | 4 | 1039 | 50 | 68.27557185 | 57.1686375 | 2021-04-17 04:20:40 | Nenets Autonomous Okrug, Russia | ||
2645611 | 2645611 | 2021-04-08 | Colombia | San Andres y Providencia | 2880 | 46 | 2784 | 50 | 12.5567 | -81.7185 | 2021-04-09 04:21:13 | San Andres y Providencia, Colombia | ||
3003264 | 3003264 | 2021-04-06 | India | Mizoram | 4508 | 11 | 4447 | 50 | 23.309381 | 92.83822 | 2021-04-07 04:20:53 | Mizoram, India | ||
3003171 | 3003171 | 2021-04-06 | Comoros | 3738 | 146 | 3542 | 50 | -11.6455 | 43.3333 | 2021-04-07 04:20:53 | Comoros | |||
3709962 | 3709962 | 2021-04-03 | China | Shanghai | 1897 | 7 | 1840 | 50 | 31.202 | 121.4491 | 2021-04-04 04:20:49 | Shanghai, China | ||
1302010 | 1302010 | 2021-04-01 | India | Meghalaya | 14067 | 150 | 13867 | 50 | 25.536934 | 91.278882 | 2021-04-02 04:20:36 | Meghalaya, India | ||
1219533 | 1219533 | 2021-03-27 | India | Sikkim | 6226 | 135 | 6041 | 50 | 27.571671 | 88.472712 | 2021-03-28 05:28:10 | Sikkim, India | ||
1880996 | 1880996 | 2021-03-26 | Japan | Hiroshima | 5108 | 106 | 4952 | 50 | 34.605309000000005 | 132.788719 | 2021-03-27 05:25:04 | Hiroshima, Japan | ||
1980626 | 1980626 | 2021-03-25 | Japan | Hiroshima | 5102 | 106 | 4946 | 50 | 34.605309000000005 | 132.788719 | 2021-03-26 05:26:55 | Hiroshima, Japan | ||
3369097 | 3369097 | 2021-03-21 | Canada | New Brunswick | 1490 | 30 | 1410 | 50 | 46.5653 | -66.4619 | 2021-03-22 05:25:43 | New Brunswick, Canada | ||
1744307 | 1744307 | 2021-03-20 | Canada | New Brunswick | 1489 | 30 | 1409 | 50 | 46.5653 | -66.4619 | 2021-03-21 05:25:44 | New Brunswick, Canada | ||
3621115 | 3621115 | 2021-03-17 | Japan | Saga | 1148 | 10 | 1088 | 50 | 33.286977 | 130.115738 | 2021-03-18 05:26:22 | Saga, Japan | ||
352261 | 352261 | 2021-03-11 | India | Sikkim | 6179 | 135 | 5994 | 50 | 27.571671 | 88.472712 | 2021-03-12 05:26:50 | Sikkim, India | ||
3962703 | 3962703 | 2021-03-10 | Russia | Altai Republic | 16364 | 179 | 16135 | 50 | 50.7114101 | 86.8572186 | 2021-03-11 05:25:48 | Altai Republic, Russia | ||
3663573 | 3663573 | 2021-03-09 | India | Sikkim | 6175 | 135 | 5990 | 50 | 27.571671 | 88.472712 | 2021-03-10 05:24:35 | Sikkim, India | ||
2359432 | 2359432 | 2021-03-08 | India | Sikkim | 6174 | 135 | 5989 | 50 | 27.571671 | 88.472712 | 2021-03-09 05:28:19 | Sikkim, India | ||
54770 | 54770 | 2021-03-07 | India | Sikkim | 6174 | 135 | 5989 | 50 | 27.571671 | 88.472712 | 2021-03-08 05:24:48 | Sikkim, India | ||
3669753 | 3669753 | 2021-03-06 | US | Nevada | Eureka | 32011 | 50 | 0 | 0 | 50 | 39.98100864 | -116.2683204 | 2021-03-07 05:21:54 | Eureka, Nevada, US |
1618374 | 1618374 | 2021-03-05 | US | Nevada | Eureka | 32011 | 50 | 0 | 0 | 50 | 39.98100864 | -116.2683204 | 2021-03-06 04:23:41 | Eureka, Nevada, US |
2209785 | 2209785 | 2021-03-04 | US | Nevada | Eureka | 32011 | 50 | 0 | 0 | 50 | 39.98100864 | -116.2683204 | 2021-03-05 05:26:29 | Eureka, Nevada, US |
2208304 | 2208304 | 2021-03-04 | US | Colorado | Unassigned | 90008 | 59 | 0 | 0 | 50 | 40.87595412 | 0.0 | 2021-03-05 05:26:29 | Unassigned, Colorado, US |
2207688 | 2207688 | 2021-03-04 | Japan | Saga | 1072 | 8 | 1014 | 50 | 33.286977 | 130.115738 | 2021-03-05 05:26:29 | Saga, Japan | ||
2207662 | 2207662 | 2021-03-04 | Japan | Gifu | 4649 | 112 | 4487 | 50 | 35.778671 | 137.055925 | 2021-03-05 05:26:29 | Gifu, Japan | ||
1092206 | 1092206 | 2021-03-03 | US | Nevada | Eureka | 32011 | 50 | 0 | 0 | 50 | 39.98100864 | -116.2683204 | 2021-03-04 05:24:24 | Eureka, Nevada, US |
1090122 | 1090122 | 2021-03-03 | Japan | Yamaguchi | 1385 | 39 | 1296 | 50 | 34.201190000000004 | 131.573293 | 2021-03-04 05:24:24 | Yamaguchi, Japan | ||
3256278 | 3256278 | 2021-03-02 | US | Nevada | Eureka | 32011 | 50 | 0 | 0 | 50 | 39.98100864 | -116.2683204 | 2021-03-03 05:23:28 | Eureka, Nevada, US |
1002089 | 1002089 | 2021-03-01 | United Kingdom | Isle of Man | 486 | 25 | 411 | 50 | 54.2361 | -4.5481 | 2021-03-02 05:23:30 | Isle of Man, United Kingdom | ||
1000570 | 1000570 | 2021-03-01 | US | Nevada | Eureka | 32011 | 50 | 0 | 0 | 50 | 39.98100864 | -116.2683204 | 2021-03-02 05:23:30 | Eureka, Nevada, US |
998449 | 998449 | 2021-03-01 | Japan | Hiroshima | 5027 | 102 | 4875 | 50 | 34.605309000000005 | 132.788719 | 2021-03-02 05:23:30 | Hiroshima, Japan | ||
2369628 | 2369628 | 2021-02-28 | US | Nevada | Eureka | 32011 | 50 | 0 | 0 | 50 | 39.98100864 | -116.2683204 | 2021-03-01 05:23:01 | Eureka, Nevada, US |
2367505 | 2367505 | 2021-02-28 | Japan | Gifu | 4616 | 110 | 4456 | 50 | 35.778671 | 137.055925 | 2021-03-01 05:23:01 | Gifu, Japan | ||
3068130 | 3068130 | 2021-02-27 | US | Nevada | Eureka | 32011 | 50 | 0 | 0 | 50 | 39.98100864 | -116.2683204 | 2021-02-28 05:22:20 | Eureka, Nevada, US |
3067991 | 3067991 | 2021-02-27 | US | Montana | Golden Valley | 30037 | 52 | 2 | 0 | 50 | 46.3816474 | -109.1768522 | 2021-02-28 05:22:20 | Golden Valley, Montana, US |
3066032 | 3066032 | 2021-02-27 | Japan | Port Quarantine | 2230 | 2 | 2178 | 50 | 2021-02-28 05:22:20 | Port Quarantine, Japan | ||||
2185714 | 2185714 | 2021-02-26 | US | Nevada | Eureka | 32011 | 50 | 0 | 0 | 50 | 39.98100864 | -116.2683204 | 2021-02-27 05:22:28 | Eureka, Nevada, US |
2185575 | 2185575 | 2021-02-26 | US | Montana | Golden Valley | 30037 | 52 | 2 | 0 | 50 | 46.3816474 | -109.1768522 | 2021-02-27 05:22:28 | Golden Valley, Montana, US |
1860136 | 1860136 | 2021-02-25 | US | Nevada | Eureka | 32011 | 50 | 0 | 0 | 50 | 39.98100864 | -116.2683204 | 2021-02-26 05:22:40 | Eureka, Nevada, US |
1859997 | 1859997 | 2021-02-25 | US | Montana | Golden Valley | 30037 | 52 | 2 | 0 | 50 | 46.3816474 | -109.1768522 | 2021-02-26 05:22:40 | Golden Valley, Montana, US |
1858034 | 1858034 | 2021-02-25 | Japan | Oita | 1289 | 21 | 1218 | 50 | 33.200697 | 131.43323999999998 | 2021-02-26 05:22:40 | Oita, Japan |
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]);