johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,983 rows where active = 66 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331709 | 331709 | 2021-08-04 | China | Guangdong | 2896 | 8 | 2822 | 66 | 23.3417 | 113.4244 | 2021-08-05 04:21:51 | Guangdong, China | ||
3385659 | 3385659 | 2021-07-29 | Saint Vincent and the Grenadines | 2288 | 12 | 2210 | 66 | 12.9843 | -61.2872 | 2021-07-30 04:21:34 | Saint Vincent and the Grenadines | |||
3385423 | 3385423 | 2021-07-29 | Japan | Saga | 2699 | 24 | 2609 | 66 | 33.286977 | 130.115738 | 2021-07-30 04:21:34 | Saga, Japan | ||
3385087 | 3385087 | 2021-07-29 | Australia | Queensland | 1793 | 7 | 1720 | 66 | -27.4698 | 153.0251 | 2021-07-30 04:21:34 | Queensland, Australia | ||
408564 | 408564 | 2021-07-28 | Saint Vincent and the Grenadines | 2288 | 12 | 2210 | 66 | 12.9843 | -61.2872 | 2021-07-29 04:21:33 | Saint Vincent and the Grenadines | |||
408097 | 408097 | 2021-07-28 | China | Guangdong | 2872 | 8 | 2798 | 66 | 23.3417 | 113.4244 | 2021-07-29 04:21:33 | Guangdong, China | ||
1306425 | 1306425 | 2021-07-27 | Saint Vincent and the Grenadines | 2280 | 12 | 2202 | 66 | 12.9843 | -61.2872 | 2021-07-28 04:21:39 | Saint Vincent and the Grenadines | |||
1306013 | 1306013 | 2021-07-27 | Colombia | San Andres y Providencia | 6712 | 133 | 6513 | 66 | 12.5567 | -81.7185 | 2021-07-28 04:21:39 | San Andres y Providencia, Colombia | ||
1305853 | 1305853 | 2021-07-27 | Australia | Queensland | 1790 | 7 | 1717 | 66 | -27.4698 | 153.0251 | 2021-07-28 04:21:39 | Queensland, Australia | ||
3218317 | 3218317 | 2021-07-26 | Japan | Kochi | 1999 | 29 | 1904 | 66 | 33.422519 | 133.367307 | 2021-07-27 04:21:18 | Kochi, Japan | ||
1382148 | 1382148 | 2021-07-25 | Ukraine | Ternopil Oblast | 70160 | 1204 | 68890 | 66 | 49.5535 | 25.5948 | 2021-07-26 04:21:28 | Ternopil Oblast, Ukraine | ||
1378310 | 1378310 | 2021-07-25 | China | Guangdong | 2853 | 8 | 2779 | 66 | 23.3417 | 113.4244 | 2021-07-26 04:21:28 | Guangdong, China | ||
1330050 | 1330050 | 2021-07-24 | China | Guangdong | 2845 | 8 | 2771 | 66 | 23.3417 | 113.4244 | 2021-07-25 04:22:12 | Guangdong, China | ||
3709766 | 3709766 | 2021-07-17 | Ukraine | Ternopil Oblast | 70119 | 1204 | 68849 | 66 | 49.5535 | 25.5948 | 2021-07-18 04:22:07 | Ternopil Oblast, Ukraine | ||
3631655 | 3631655 | 2021-07-14 | Australia | Queensland | 1752 | 7 | 1679 | 66 | -27.4698 | 153.0251 | 2021-07-15 04:21:48 | Queensland, Australia | ||
3659417 | 3659417 | 2021-07-11 | China | Shanghai | 2247 | 7 | 2174 | 66 | 31.202 | 121.4491 | 2021-07-12 04:21:34 | Shanghai, China | ||
1440619 | 1440619 | 2021-07-07 | Japan | Shiga | 5588 | 90 | 5432 | 66 | 35.21582700000001 | 136.138064 | 2021-07-08 04:21:26 | Shiga, Japan | ||
1440585 | 1440585 | 2021-07-07 | Japan | Aomori | 2531 | 31 | 2434 | 66 | 40.781541 | 140.828896 | 2021-07-08 04:21:26 | Aomori, Japan | ||
1440271 | 1440271 | 2021-07-07 | Albania | 132557 | 2456 | 130035 | 66 | 41.1533 | 20.1683 | 2021-07-08 04:21:26 | Albania | |||
1932457 | 1932457 | 2021-07-05 | Japan | Kumamoto | 6492 | 118 | 6308 | 66 | 32.608154 | 130.74523100000002 | 2021-07-06 04:21:32 | Kumamoto, Japan | ||
1165170 | 1165170 | 2021-07-04 | Japan | Aomori | 2520 | 31 | 2423 | 66 | 40.781541 | 140.828896 | 2021-07-05 04:21:28 | Aomori, Japan | ||
2071615 | 2071615 | 2021-07-02 | Australia | Queensland | 1714 | 7 | 1641 | 66 | -27.4698 | 153.0251 | 2021-07-03 04:21:37 | Queensland, Australia | ||
3125530 | 3125530 | 2021-06-28 | Japan | Miyagi | 9113 | 90 | 8957 | 66 | 38.446859 | 140.927086 | 2021-06-29 04:21:28 | Miyagi, Japan | ||
3125230 | 3125230 | 2021-06-28 | Benin | 8170 | 104 | 8000 | 66 | 9.3077 | 2.3158 | 2021-06-29 04:21:28 | Benin | |||
2589725 | 2589725 | 2021-06-27 | Benin | 8170 | 104 | 8000 | 66 | 9.3077 | 2.3158 | 2021-06-28 04:21:29 | Benin | |||
2589690 | 2589690 | 2021-06-27 | Albania | 132512 | 2456 | 129990 | 66 | 41.1533 | 20.1683 | 2021-06-28 04:21:29 | Albania | |||
3958229 | 3958229 | 2021-06-26 | Benin | 8170 | 104 | 8000 | 66 | 9.3077 | 2.3158 | 2021-06-27 04:21:39 | Benin | |||
1712048 | 1712048 | 2021-06-25 | Benin | 8170 | 104 | 8000 | 66 | 9.3077 | 2.3158 | 2021-06-26 04:21:43 | Benin | |||
2295173 | 2295173 | 2021-06-24 | Benin | 8170 | 104 | 8000 | 66 | 9.3077 | 2.3158 | 2021-06-25 04:21:33 | Benin | |||
2422613 | 2422613 | 2021-06-23 | Benin | 8170 | 104 | 8000 | 66 | 9.3077 | 2.3158 | 2021-06-24 04:21:55 | Benin | |||
562690 | 562690 | 2021-06-22 | Benin | 8170 | 104 | 8000 | 66 | 9.3077 | 2.3158 | 2021-06-23 04:21:46 | Benin | |||
1125404 | 1125404 | 2021-06-18 | China | Hong Kong | 11884 | 210 | 11608 | 66 | 22.3 | 114.2 | 2021-06-19 04:22:33 | Hong Kong, China | ||
1736332 | 1736332 | 2021-06-12 | China | Shanghai | 2155 | 7 | 2082 | 66 | 31.202 | 121.4491 | 2021-06-13 04:22:44 | Shanghai, China | ||
2716837 | 2716837 | 2021-06-10 | Colombia | Vichada | 2111 | 32 | 2013 | 66 | 4.4234 | -69.2878 | 2021-06-11 04:23:20 | Vichada, Colombia | ||
2716795 | 2716795 | 2021-06-10 | China | Shanghai | 2141 | 7 | 2068 | 66 | 31.202 | 121.4491 | 2021-06-11 04:23:20 | Shanghai, China | ||
3472120 | 3472120 | 2021-06-08 | China | Shanghai | 2132 | 7 | 2059 | 66 | 31.202 | 121.4491 | 2021-06-09 04:23:31 | Shanghai, China | ||
3472066 | 3472066 | 2021-06-08 | Canada | Newfoundland and Labrador | 1357 | 7 | 1284 | 66 | 53.1355 | -57.6604 | 2021-06-09 04:23:31 | Newfoundland and Labrador, Canada | ||
3145698 | 3145698 | 2021-06-07 | Netherlands | Aruba | 11059 | 107 | 10886 | 66 | 12.5211 | -69.9683 | 2021-06-08 04:22:35 | Aruba, Netherlands | ||
829263 | 829263 | 2021-06-06 | Malaysia | Perlis | 537 | 5 | 466 | 66 | 6.4449 | 100.2048 | 2021-06-07 04:22:51 | Perlis, Malaysia | ||
1188816 | 1188816 | 2021-05-31 | Malta | 30535 | 419 | 30050 | 66 | 35.9375 | 14.3754 | 2021-06-01 04:23:09 | Malta | |||
3089245 | 3089245 | 2021-05-30 | China | Shanghai | 2095 | 7 | 2022 | 66 | 31.202 | 121.4491 | 2021-05-31 03:08:59 | Shanghai, China | ||
20441 | 20441 | 2021-05-28 | Malta | 30526 | 419 | 30041 | 66 | 35.9375 | 14.3754 | 2021-05-29 04:20:41 | Malta | |||
1771248 | 1771248 | 2021-05-23 | Gambia | 5968 | 175 | 5727 | 66 | 13.4432 | -15.3101 | 2021-05-24 04:20:53 | Gambia | |||
1771166 | 1771166 | 2021-05-23 | China | Shanghai | 2069 | 7 | 1996 | 66 | 31.202 | 121.4491 | 2021-05-24 04:20:53 | Shanghai, China | ||
726403 | 726403 | 2021-05-22 | Gambia | 5968 | 175 | 5727 | 66 | 13.4432 | -15.3101 | 2021-05-23 04:20:51 | Gambia | |||
1952418 | 1952418 | 2021-05-21 | Gambia | 5968 | 175 | 5727 | 66 | 13.4432 | -15.3101 | 2021-05-22 04:20:45 | Gambia | |||
1913117 | 1913117 | 2021-05-20 | Gambia | 5968 | 175 | 5727 | 66 | 13.4432 | -15.3101 | 2021-05-21 04:20:43 | Gambia | |||
2255738 | 2255738 | 2021-05-19 | Japan | Fukui | 1004 | 34 | 904 | 66 | 35.846614 | 136.22465400000002 | 2021-05-20 04:21:05 | Fukui, Japan | ||
2255580 | 2255580 | 2021-05-19 | Colombia | Guainia | 1572 | 22 | 1484 | 66 | 2.5854 | -68.5247 | 2021-05-20 04:21:05 | Guainia, Colombia | ||
3574493 | 3574493 | 2021-05-17 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-18 04:20:33 | New Caledonia, France | ||
2939223 | 2939223 | 2021-05-16 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-17 04:20:34 | New Caledonia, France | ||
1872853 | 1872853 | 2021-05-15 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-16 04:20:49 | New Caledonia, France | ||
1081822 | 1081822 | 2021-05-14 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-15 04:20:58 | New Caledonia, France | ||
1081757 | 1081757 | 2021-05-14 | Colombia | Amazonas | 6226 | 238 | 5922 | 66 | -1.4429 | -71.5724 | 2021-05-15 04:20:58 | Amazonas, Colombia | ||
3054088 | 3054088 | 2021-05-13 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-14 04:20:41 | New Caledonia, France | ||
2004558 | 2004558 | 2021-05-12 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-13 04:20:51 | New Caledonia, France | ||
3954389 | 3954389 | 2021-05-11 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-12 04:21:29 | New Caledonia, France | ||
2820668 | 2820668 | 2021-05-10 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-11 04:20:41 | New Caledonia, France | ||
1425000 | 1425000 | 2021-05-09 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-10 04:20:38 | New Caledonia, France | ||
1552031 | 1552031 | 2021-05-08 | Liberia | 2113 | 85 | 1962 | 66 | 6.4280550000000005 | -9.429499 | 2021-05-09 04:20:35 | Liberia | |||
1551868 | 1551868 | 2021-05-08 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-09 04:20:35 | New Caledonia, France | ||
2502089 | 2502089 | 2021-05-07 | Liberia | 2113 | 85 | 1962 | 66 | 6.4280550000000005 | -9.429499 | 2021-05-08 04:21:04 | Liberia | |||
2501926 | 2501926 | 2021-05-07 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-08 04:21:04 | New Caledonia, France | ||
3113382 | 3113382 | 2021-05-06 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-07 04:20:40 | New Caledonia, France | ||
646012 | 646012 | 2021-05-05 | Liberia | 2110 | 85 | 1959 | 66 | 6.4280550000000005 | -9.429499 | 2021-05-06 04:20:38 | Liberia | |||
645849 | 645849 | 2021-05-05 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-06 04:20:38 | New Caledonia, France | ||
3679296 | 3679296 | 2021-05-04 | United Kingdom | Anguilla | 95 | 0 | 29 | 66 | 18.2206 | -63.0686 | 2021-05-05 04:20:43 | Anguilla, United Kingdom | ||
3675549 | 3675549 | 2021-05-04 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-05 04:20:43 | New Caledonia, France | ||
2764563 | 2764563 | 2021-05-03 | United Kingdom | Anguilla | 95 | 0 | 29 | 66 | 18.2206 | -63.0686 | 2021-05-04 04:20:34 | Anguilla, United Kingdom | ||
2760816 | 2760816 | 2021-05-03 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-04 04:20:34 | New Caledonia, France | ||
2760742 | 2760742 | 2021-05-03 | China | Shanghai | 1999 | 7 | 1926 | 66 | 31.202 | 121.4491 | 2021-05-04 04:20:34 | Shanghai, China | ||
2454416 | 2454416 | 2021-05-02 | United Kingdom | Anguilla | 95 | 0 | 29 | 66 | 18.2206 | -63.0686 | 2021-05-03 04:20:39 | Anguilla, United Kingdom | ||
2450669 | 2450669 | 2021-05-02 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-03 04:20:39 | New Caledonia, France | ||
2824682 | 2824682 | 2021-05-01 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-02 04:20:48 | New Caledonia, France | ||
380090 | 380090 | 2021-04-30 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-05-01 04:20:47 | New Caledonia, France | ||
380016 | 380016 | 2021-04-30 | China | Shanghai | 1987 | 7 | 1914 | 66 | 31.202 | 121.4491 | 2021-05-01 04:20:47 | Shanghai, China | ||
1636335 | 1636335 | 2021-04-29 | Japan | Kochi | 1026 | 19 | 941 | 66 | 33.422519 | 133.367307 | 2021-04-30 04:21:03 | Kochi, Japan | ||
1636213 | 1636213 | 2021-04-29 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-30 04:21:03 | New Caledonia, France | ||
3393292 | 3393292 | 2021-04-28 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-29 04:20:55 | New Caledonia, France | ||
3702008 | 3702008 | 2021-04-27 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-28 04:20:32 | New Caledonia, France | ||
888017 | 888017 | 2021-04-26 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-27 04:20:52 | New Caledonia, France | ||
955048 | 955048 | 2021-04-25 | Russia | Altai Republic | 16793 | 230 | 16497 | 66 | 50.7114101 | 86.8572186 | 2021-04-26 04:21:04 | Altai Republic, Russia | ||
954762 | 954762 | 2021-04-25 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-26 04:21:04 | New Caledonia, France | ||
3923909 | 3923909 | 2021-04-24 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-25 04:20:32 | New Caledonia, France | ||
3923835 | 3923835 | 2021-04-24 | China | Shanghai | 1967 | 7 | 1894 | 66 | 31.202 | 121.4491 | 2021-04-25 04:20:32 | Shanghai, China | ||
3923710 | 3923710 | 2021-04-24 | Australia | Queensland | 1529 | 7 | 1456 | 66 | -27.4698 | 153.0251 | 2021-04-25 04:20:32 | Queensland, Australia | ||
1408940 | 1408940 | 2021-04-23 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-24 04:20:38 | New Caledonia, France | ||
1568003 | 1568003 | 2021-04-22 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-23 04:20:52 | New Caledonia, France | ||
3242224 | 3242224 | 2021-04-21 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-22 04:20:53 | New Caledonia, France | ||
2020620 | 2020620 | 2021-04-20 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-21 04:21:14 | New Caledonia, France | ||
2410741 | 2410741 | 2021-04-19 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-20 04:20:41 | New Caledonia, France | ||
3129418 | 3129418 | 2021-04-18 | France | New Caledonia | 124 | 0 | 58 | 66 | -20.904305 | 165.618042 | 2021-04-19 04:20:57 | New Caledonia, France | ||
2549141 | 2549141 | 2021-04-15 | Saint Lucia | 4355 | 64 | 4225 | 66 | 13.9094 | -60.9789 | 2021-04-16 04:20:46 | Saint Lucia | |||
2549074 | 2549074 | 2021-04-15 | Russia | Jewish Autonomous Okrug | 4459 | 125 | 4268 | 66 | 48.57527615 | 132.66307460000002 | 2021-04-16 04:20:46 | Jewish Autonomous Okrug, Russia | ||
2548923 | 2548923 | 2021-04-15 | Japan | Yamanashi | 1057 | 19 | 972 | 66 | 35.612364 | 138.61148899999998 | 2021-04-16 04:20:46 | Yamanashi, Japan | ||
2548813 | 2548813 | 2021-04-15 | India | Arunachal Pradesh | 16920 | 56 | 16798 | 66 | 27.768456 | 96.384277 | 2021-04-16 04:20:46 | Arunachal Pradesh, India | ||
1842144 | 1842144 | 2021-04-14 | Russia | Jewish Autonomous Okrug | 4458 | 125 | 4267 | 66 | 48.57527615 | 132.66307460000002 | 2021-04-15 04:20:54 | Jewish Autonomous Okrug, Russia | ||
1841979 | 1841979 | 2021-04-14 | Japan | Saga | 1297 | 13 | 1218 | 66 | 33.286977 | 130.115738 | 2021-04-15 04:20:54 | Saga, Japan | ||
1841653 | 1841653 | 2021-04-14 | Barbados | 3744 | 44 | 3634 | 66 | 13.1939 | -59.5432 | 2021-04-15 04:20:54 | Barbados | |||
2571878 | 2571878 | 2021-04-13 | Russia | Jewish Autonomous Okrug | 4457 | 125 | 4266 | 66 | 48.57527615 | 132.66307460000002 | 2021-04-14 04:20:41 | Jewish Autonomous Okrug, Russia |
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]);