daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,922 rows where active = 72 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 1,636
- Japan 65
- Malaysia 18
- China 15
- Burundi 12
- Germany 11
- Canada 10
- Colombia 10
- United Kingdom 10
- India 9
- New Zealand 9
- Russia 9
- Ukraine 9
- France 8
- Netherlands 8
- Andorra 7
- Italy 7
- Chad 5
- Chile 4
- Comoros 4
- West Bank and Gaza 4
- Iceland 3
- Malta 3
- Spain 3
- Angola 2
- Burkina Faso 2
- Burma 2
- Cameroon 2
- Eritrea 2
- Guyana 2
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-09-21 | Malaysia | W.P. Labuan | 9933 | 148 | 9713 | 72 | 5.2831 | 115.2308 | 2021-09-22 04:21:45 | W.P. Labuan, Malaysia | ||
2021-08-13 | Malaysia | W.P. Labuan | 9739 | 148 | 9519 | 72 | 5.2831 | 115.2308 | 2021-08-14 04:21:25 | W.P. Labuan, Malaysia | ||
2021-07-30 | China | Guangdong | 2882 | 8 | 2802 | 72 | 23.3417 | 113.4244 | 2021-07-31 04:21:35 | Guangdong, China | ||
2021-07-29 | Ukraine | Ternopil Oblast | 70183 | 1204 | 68907 | 72 | 49.5535 | 25.5948 | 2021-07-30 04:21:34 | Ternopil Oblast, Ukraine | ||
2021-07-29 | China | Guangdong | 2881 | 8 | 2801 | 72 | 23.3417 | 113.4244 | 2021-07-30 04:21:34 | Guangdong, China | ||
2021-07-28 | Ukraine | Ternopil Oblast | 70179 | 1204 | 68903 | 72 | 49.5535 | 25.5948 | 2021-07-29 04:21:33 | Ternopil Oblast, Ukraine | ||
2021-07-28 | Canada | Yukon | 582 | 6 | 504 | 72 | 64.2823 | -135.0 | 2021-07-29 04:21:33 | Yukon, Canada | ||
2021-07-26 | Japan | Kagoshima | 3860 | 39 | 3749 | 72 | 31.009484000000004 | 130.430665 | 2021-07-27 04:21:18 | Kagoshima, Japan | ||
2021-07-25 | Japan | Mie | 5577 | 113 | 5392 | 72 | 34.508018 | 136.376013 | 2021-07-26 04:21:28 | Mie, Japan | ||
2021-07-23 | Japan | Yamanashi | 2232 | 21 | 2139 | 72 | 35.612364 | 138.61148899999998 | 2021-07-24 00:21:36 | Yamanashi, Japan | ||
2021-07-23 | China | Guangdong | 2839 | 8 | 2759 | 72 | 23.3417 | 113.4244 | 2021-07-24 00:21:36 | Guangdong, China | ||
2021-07-22 | Ukraine | Rivne Oblast | 79625 | 1207 | 78346 | 72 | 50.6199 | 26.2516 | 2021-07-23 04:21:29 | Rivne Oblast, Ukraine | ||
2021-07-20 | Ukraine | Rivne Oblast | 79616 | 1207 | 78337 | 72 | 50.6199 | 26.2516 | 2021-07-21 04:21:40 | Rivne Oblast, Ukraine | ||
2021-07-19 | India | Lakshadweep | 10076 | 49 | 9955 | 72 | 13.6999972 | 72.18333259999999 | 2021-07-20 04:21:48 | Lakshadweep, India | ||
2021-07-17 | Chile | Magallanes | 29069 | 472 | 28525 | 72 | -52.368 | -70.9863 | 2021-07-18 04:22:07 | Magallanes, Chile | ||
2021-07-16 | Ukraine | Ternopil Oblast | 70117 | 1203 | 68842 | 72 | 49.5535 | 25.5948 | 2021-07-17 04:22:22 | Ternopil Oblast, Ukraine | ||
2021-07-15 | Japan | Kochi | 1923 | 29 | 1822 | 72 | 33.422519 | 133.367307 | 2021-07-16 04:21:22 | Kochi, Japan | ||
2021-07-14 | Japan | Kochi | 1914 | 28 | 1814 | 72 | 33.422519 | 133.367307 | 2021-07-15 04:21:48 | Kochi, Japan | ||
2021-07-14 | India | Chandigarh | 61851 | 809 | 60970 | 72 | 30.733839 | 76.76827800000002 | 2021-07-15 04:21:48 | Chandigarh, India | ||
2021-07-13 | China | Shanghai | 2257 | 7 | 2178 | 72 | 31.202 | 121.4491 | 2021-07-14 04:21:35 | Shanghai, China | ||
2021-07-12 | Japan | Kochi | 1898 | 27 | 1799 | 72 | 33.422519 | 133.367307 | 2021-07-13 04:21:18 | Kochi, Japan | ||
2021-07-08 | Japan | Shiga | 5599 | 90 | 5437 | 72 | 35.21582700000001 | 136.138064 | 2021-07-09 04:21:21 | Shiga, Japan | ||
2021-07-08 | Albania | 132565 | 2456 | 130037 | 72 | 41.1533 | 20.1683 | 2021-07-09 04:21:21 | Albania | |||
2021-07-03 | Japan | Iwate | 1707 | 47 | 1588 | 72 | 39.593287 | 141.361777 | 2021-07-04 04:21:38 | Iwate, Japan | ||
2021-07-02 | Colombia | Guaviare | 4370 | 77 | 4221 | 72 | 1.0654 | -73.2603 | 2021-07-03 04:21:37 | Guaviare, Colombia | ||
2021-06-27 | Japan | Akita | 835 | 20 | 743 | 72 | 39.748679 | 140.408228 | 2021-06-28 04:21:29 | Akita, Japan | ||
2021-06-25 | Germany | Mecklenburg-Vorpommern | 44121 | 1151 | 42910 | 72 | 53.6127 | 12.4296 | 2021-06-26 04:21:43 | Mecklenburg-Vorpommern, Germany | ||
2021-06-22 | China | Shanghai | 2190 | 7 | 2111 | 72 | 31.202 | 121.4491 | 2021-06-23 04:21:46 | Shanghai, China | ||
2021-06-22 | Andorra | 13864 | 127 | 13665 | 72 | 42.5063 | 1.5218 | 2021-06-23 04:21:46 | Andorra | |||
2021-06-21 | Andorra | 13864 | 127 | 13665 | 72 | 42.5063 | 1.5218 | 2021-06-22 04:21:34 | Andorra | |||
2021-06-19 | Japan | Wakayama | 2657 | 48 | 2537 | 72 | 33.911879 | 135.505446 | 2021-06-20 04:21:48 | Wakayama, Japan | ||
2021-06-17 | Andorra | 13839 | 127 | 13640 | 72 | 42.5063 | 1.5218 | 2021-06-18 04:22:16 | Andorra | |||
2021-06-15 | Japan | Toyama | 1969 | 37 | 1860 | 72 | 36.637464 | 137.26934599999998 | 2021-06-16 04:22:32 | Toyama, Japan | ||
2021-06-15 | Japan | Port Quarantine | 3034 | 4 | 2958 | 72 | 2021-06-16 04:22:32 | Port Quarantine, Japan | ||||
2021-06-13 | Netherlands | Sint Maarten | 2522 | 31 | 2419 | 72 | 18.0425 | -63.0548 | 2021-06-14 04:22:46 | Sint Maarten, Netherlands | ||
2021-06-12 | Netherlands | Sint Maarten | 2522 | 31 | 2419 | 72 | 18.0425 | -63.0548 | 2021-06-13 04:22:44 | Sint Maarten, Netherlands | ||
2021-06-12 | China | Hong Kong | 11877 | 210 | 11595 | 72 | 22.3 | 114.2 | 2021-06-13 04:22:44 | Hong Kong, China | ||
2021-06-07 | Malta | 30571 | 419 | 30080 | 72 | 35.9375 | 14.3754 | 2021-06-08 04:22:35 | Malta | |||
2021-06-06 | Canada | Newfoundland and Labrador | 1352 | 6 | 1274 | 72 | 53.1355 | -57.6604 | 2021-06-07 04:22:51 | Newfoundland and Labrador, Canada | ||
2021-06-05 | Russia | Tyva Republic | 15984 | 203 | 15709 | 72 | 51.4017149 | 93.8582593 | 2021-06-06 04:24:03 | Tyva Republic, Russia | ||
2021-06-02 | Japan | Ehime | 2721 | 72 | 2577 | 72 | 33.624835 | 132.856842 | 2021-06-03 04:23:32 | Ehime, Japan | ||
2021-06-01 | Russia | Tyva Republic | 15966 | 203 | 15691 | 72 | 51.4017149 | 93.8582593 | 2021-06-02 04:24:34 | Tyva Republic, Russia | ||
2021-05-28 | Netherlands | Aruba | 10969 | 107 | 10790 | 72 | 12.5211 | -69.9683 | 2021-05-29 04:20:41 | Aruba, Netherlands | ||
2021-05-24 | Malta | 30506 | 417 | 30017 | 72 | 35.9375 | 14.3754 | 2021-05-25 04:21:08 | Malta | |||
2021-05-21 | China | Hong Kong | 11829 | 210 | 11547 | 72 | 22.3 | 114.2 | 2021-05-22 04:20:45 | Hong Kong, China | ||
2021-05-09 | Canada | Nunavut | 565 | 4 | 489 | 72 | 70.2998 | -83.1076 | 2021-05-10 04:20:38 | Nunavut, Canada | ||
2021-05-06 | Chad | 4854 | 170 | 4612 | 72 | 15.4542 | 18.7322 | 2021-05-07 04:20:40 | Chad | |||
2021-04-27 | Malaysia | W.P. Putrajaya | 1347 | 9 | 1266 | 72 | 2.9264 | 101.6964 | 2021-04-28 04:20:32 | W.P. Putrajaya, Malaysia | ||
2021-04-27 | Monaco | 2442 | 32 | 2338 | 72 | 43.7333 | 7.4167 | 2021-04-28 04:20:32 | Monaco | |||
2021-04-27 | Japan | Akita | 425 | 9 | 344 | 72 | 39.748679 | 140.408228 | 2021-04-28 04:20:32 | Akita, Japan | ||
2021-04-26 | Japan | Akita | 417 | 9 | 336 | 72 | 39.748679 | 140.408228 | 2021-04-27 04:20:52 | Akita, Japan | ||
2021-04-25 | Japan | Akita | 414 | 9 | 333 | 72 | 39.748679 | 140.408228 | 2021-04-26 04:21:04 | Akita, Japan | ||
2021-04-18 | Barbados | 3781 | 44 | 3665 | 72 | 13.1939 | -59.5432 | 2021-04-19 04:20:57 | Barbados | |||
2021-04-16 | Japan | Yamaguchi | 1503 | 43 | 1388 | 72 | 34.201190000000004 | 131.573293 | 2021-04-17 04:20:40 | Yamaguchi, Japan | ||
2021-04-15 | Colombia | Amazonas | 6021 | 227 | 5722 | 72 | -1.4429 | -71.5724 | 2021-04-16 04:20:46 | Amazonas, Colombia | ||
2021-04-09 | Malaysia | W.P. Labuan | 2404 | 12 | 2320 | 72 | 5.2831 | 115.2308 | 2021-04-10 04:20:59 | W.P. Labuan, Malaysia | ||
2021-04-05 | Japan | Tottori | 279 | 2 | 205 | 72 | 35.359069 | 133.863619 | 2021-04-06 04:20:32 | Tottori, Japan | ||
2021-04-02 | Russia | Jewish Autonomous Okrug | 4437 | 125 | 4240 | 72 | 48.57527615 | 132.66307460000002 | 2021-04-03 04:20:44 | Jewish Autonomous Okrug, Russia | ||
2021-03-31 | Japan | Tokushima | 535 | 18 | 445 | 72 | 33.919178 | 134.242091 | 2021-04-01 04:27:05 | Tokushima, Japan | ||
2021-03-30 | New Zealand | 2497 | 28 | 2399 | 72 | -40.9006 | 174.886 | 2021-03-31 04:26:25 | New Zealand | |||
2021-03-20 | Russia | Nenets Autonomous Okrug | 1068 | 4 | 992 | 72 | 68.27557185 | 57.1686375 | 2021-03-21 05:25:44 | Nenets Autonomous Okrug, Russia | ||
2021-03-19 | Chile | Aysen | 3314 | 26 | 3216 | 72 | -45.9864 | -73.7669 | 2021-03-20 05:25:46 | Aysen, Chile | ||
2021-03-11 | Canada | Newfoundland and Labrador | 1011 | 6 | 933 | 72 | 53.1355 | -57.6604 | 2021-03-12 05:26:50 | Newfoundland and Labrador, Canada | ||
2021-03-09 | Belize | 12345 | 316 | 11957 | 72 | 17.1899 | -88.4976 | 2021-03-10 05:24:35 | Belize | |||
2021-03-08 | Russia | Altai Republic | 16359 | 175 | 16112 | 72 | 50.7114101 | 86.8572186 | 2021-03-09 05:28:19 | Altai Republic, Russia | ||
2021-03-06 | New Zealand | 2399 | 28 | 2301 | 72 | -40.9006 | 174.886 | 2021-03-07 05:21:54 | New Zealand | |||
2021-03-03 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-03-04 05:24:24 | Terrell, Texas, US |
2021-03-02 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-03-03 05:23:28 | Terrell, Texas, US |
2021-03-01 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-03-02 05:23:30 | Terrell, Texas, US |
2021-02-28 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-03-01 05:23:01 | Terrell, Texas, US |
2021-02-27 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-28 05:22:20 | Terrell, Texas, US |
2021-02-26 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-27 05:22:28 | Terrell, Texas, US |
2021-02-26 | Japan | Hiroshima | 5023 | 102 | 4849 | 72 | 34.605309000000005 | 132.788719 | 2021-02-27 05:22:28 | Hiroshima, Japan | ||
2021-02-25 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-26 05:22:40 | Terrell, Texas, US |
2021-02-25 | US | Alaska | Denali | 2068 | 72 | 0 | 0 | 72 | 63.67264044 | -150.0076108 | 2021-02-26 05:22:40 | Denali, Alaska, US |
2021-02-24 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-25 05:24:57 | Terrell, Texas, US |
2021-02-24 | US | Alaska | Denali | 2068 | 72 | 0 | 0 | 72 | 63.67264044 | -150.0076108 | 2021-02-25 05:24:57 | Denali, Alaska, US |
2021-02-23 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-24 05:29:16 | Terrell, Texas, US |
2021-02-23 | US | Alaska | Denali | 2068 | 72 | 0 | 0 | 72 | 63.67264044 | -150.0076108 | 2021-02-24 05:29:16 | Denali, Alaska, US |
2021-02-22 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-23 05:23:41 | Terrell, Texas, US |
2021-02-22 | US | Alaska | Denali | 2068 | 72 | 0 | 0 | 72 | 63.67264044 | -150.0076108 | 2021-02-23 05:23:41 | Denali, Alaska, US |
2021-02-21 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-22 05:24:21 | Terrell, Texas, US |
2021-02-21 | China | Shanghai | 1783 | 7 | 1704 | 72 | 31.202 | 121.4491 | 2021-02-22 05:24:21 | Shanghai, China | ||
2021-02-20 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-21 05:24:33 | Terrell, Texas, US |
2021-02-19 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-20 05:22:51 | Terrell, Texas, US |
2021-02-19 | Japan | Kagoshima | 1743 | 24 | 1647 | 72 | 31.009484000000004 | 130.430665 | 2021-02-20 05:22:51 | Kagoshima, Japan | ||
2021-02-18 | Malaysia | W.P. Putrajaya | 1018 | 7 | 939 | 72 | 2.9264 | 101.6964 | 2021-02-19 05:24:16 | W.P. Putrajaya, Malaysia | ||
2021-02-18 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-19 05:24:16 | Terrell, Texas, US |
2021-02-18 | Japan | Oita | 1276 | 20 | 1184 | 72 | 33.200697 | 131.43323999999998 | 2021-02-19 05:24:16 | Oita, Japan | ||
2021-02-18 | Japan | Kagoshima | 1742 | 24 | 1646 | 72 | 31.009484000000004 | 130.430665 | 2021-02-19 05:24:16 | Kagoshima, Japan | ||
2021-02-17 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-18 05:22:58 | Terrell, Texas, US |
2021-02-17 | Japan | Wakayama | 1154 | 17 | 1065 | 72 | 33.911879 | 135.505446 | 2021-02-18 05:22:58 | Wakayama, Japan | ||
2021-02-17 | Japan | Nara | 3224 | 44 | 3108 | 72 | 34.317451 | 135.871644 | 2021-02-18 05:22:58 | Nara, Japan | ||
2021-02-17 | Japan | Miyazaki | 1934 | 21 | 1841 | 72 | 32.193203999999994 | 131.299374 | 2021-02-18 05:22:58 | Miyazaki, Japan | ||
2021-02-16 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-17 05:23:10 | Terrell, Texas, US |
2021-02-16 | US | Nevada | Storey | 32029 | 75 | 3 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-17 05:23:10 | Storey, Nevada, US |
2021-02-16 | Colombia | Amazonas | 4448 | 151 | 4225 | 72 | -1.4429 | -71.5724 | 2021-02-17 05:23:10 | Amazonas, Colombia | ||
2021-02-15 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-16 05:24:38 | Terrell, Texas, US |
2021-02-15 | US | Nevada | Storey | 32029 | 75 | 3 | 0 | 72 | 39.44875482 | -119.5250207 | 2021-02-16 05:24:38 | Storey, Nevada, US |
2021-02-14 | US | Texas | Terrell | 48443 | 67 | 2 | 0 | 72 | 30.22429013 | -102.0766732 | 2021-02-15 05:24:49 | Terrell, Texas, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;