daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,298 rows where active = 30 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-04 | New Zealand | 2880 | 28 | 2824 | 30 | -40.9006 | 174.886 | 2021-08-05 04:21:51 | New Zealand | |||
2021-08-02 | New Zealand | 2877 | 28 | 2821 | 30 | -40.9006 | 174.886 | 2021-08-03 04:21:39 | New Zealand | |||
2021-08-01 | India | Chandigarh | 61954 | 811 | 61113 | 30 | 30.733839 | 76.76827800000002 | 2021-08-02 04:21:36 | Chandigarh, India | ||
2021-07-30 | India | Dadra and Nagar Haveli and Daman and Diu | 10644 | 4 | 10610 | 30 | 20.194742 | 73.080901 | 2021-07-31 04:21:35 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2021-07-29 | United Kingdom | Turks and Caicos Islands | 2479 | 18 | 2431 | 30 | 21.694000000000006 | -71.7979 | 2021-07-30 04:21:34 | Turks and Caicos Islands, United Kingdom | ||
2021-07-28 | Burkina Faso | 13560 | 169 | 13361 | 30 | 12.2383 | -1.5616 | 2021-07-29 04:21:33 | Burkina Faso | |||
2021-07-26 | United Kingdom | Turks and Caicos Islands | 2466 | 18 | 2418 | 30 | 21.694000000000006 | -71.7979 | 2021-07-27 04:21:18 | Turks and Caicos Islands, United Kingdom | ||
2021-07-26 | Japan | Saga | 2641 | 24 | 2587 | 30 | 33.286977 | 130.115738 | 2021-07-27 04:21:18 | Saga, Japan | ||
2021-07-25 | Colombia | Vichada | 2789 | 45 | 2714 | 30 | 4.4234 | -69.2878 | 2021-07-26 04:21:28 | Vichada, Colombia | ||
2021-07-25 | Australia | South Australia | 856 | 4 | 822 | 30 | -34.9285 | 138.6007 | 2021-07-26 04:21:28 | South Australia, Australia | ||
2021-07-24 | Denmark | Greenland | 89 | 0 | 59 | 30 | 71.7069 | -42.6043 | 2021-07-25 04:22:12 | Greenland, Denmark | ||
2021-07-24 | Colombia | Vichada | 2788 | 45 | 2713 | 30 | 4.4234 | -69.2878 | 2021-07-25 04:22:12 | Vichada, Colombia | ||
2021-07-21 | Denmark | Greenland | 83 | 0 | 53 | 30 | 71.7069 | -42.6043 | 2021-07-22 04:21:19 | Greenland, Denmark | ||
2021-07-20 | Denmark | Greenland | 83 | 0 | 53 | 30 | 71.7069 | -42.6043 | 2021-07-21 04:21:40 | Greenland, Denmark | ||
2021-07-17 | Japan | Kagoshima | 3770 | 39 | 3701 | 30 | 31.009484000000004 | 130.430665 | 2021-07-18 04:22:07 | Kagoshima, Japan | ||
2021-07-16 | Netherlands | Sint Maarten | 2659 | 34 | 2595 | 30 | 18.0425 | -63.0548 | 2021-07-17 04:22:22 | Sint Maarten, Netherlands | ||
2021-07-16 | Japan | Yamaguchi | 3185 | 80 | 3075 | 30 | 34.201190000000004 | 131.573293 | 2021-07-17 04:22:22 | Yamaguchi, Japan | ||
2021-07-16 | Japan | Toyama | 2075 | 38 | 2007 | 30 | 36.637464 | 137.26934599999998 | 2021-07-17 04:22:22 | Toyama, Japan | ||
2021-07-16 | Japan | Ehime | 2783 | 75 | 2678 | 30 | 33.624835 | 132.856842 | 2021-07-17 04:22:22 | Ehime, Japan | ||
2021-07-15 | Netherlands | Sint Maarten | 2659 | 34 | 2595 | 30 | 18.0425 | -63.0548 | 2021-07-16 04:21:22 | Sint Maarten, Netherlands | ||
2021-07-15 | Japan | Toyama | 2072 | 38 | 2004 | 30 | 36.637464 | 137.26934599999998 | 2021-07-16 04:21:22 | Toyama, Japan | ||
2021-07-15 | Japan | Kumamoto | 6508 | 119 | 6359 | 30 | 32.608154 | 130.74523100000002 | 2021-07-16 04:21:22 | Kumamoto, Japan | ||
2021-07-13 | Japan | Tottori | 496 | 2 | 464 | 30 | 35.359069 | 133.863619 | 2021-07-14 04:21:35 | Tottori, Japan | ||
2021-07-11 | Japan | Kumamoto | 6498 | 119 | 6349 | 30 | 32.608154 | 130.74523100000002 | 2021-07-12 04:21:34 | Kumamoto, Japan | ||
2021-07-08 | Netherlands | Curacao | 12364 | 126 | 12208 | 30 | 12.1696 | -68.99 | 2021-07-09 04:21:21 | Curacao, Netherlands | ||
2021-07-03 | Japan | Okayama | 7595 | 126 | 7439 | 30 | 34.89246 | 133.826252 | 2021-07-04 04:21:38 | Okayama, Japan | ||
2021-06-30 | Netherlands | Aruba | 11138 | 107 | 11001 | 30 | 12.5211 | -69.9683 | 2021-07-01 04:21:19 | Aruba, Netherlands | ||
2021-06-28 | New Zealand | 2741 | 28 | 2685 | 30 | -40.9006 | 174.886 | 2021-06-29 04:21:28 | New Zealand | |||
2021-06-27 | United Kingdom | Gibraltar | 4345 | 94 | 4221 | 30 | 36.1408 | -5.3536 | 2021-06-28 04:21:29 | Gibraltar, United Kingdom | ||
2021-06-27 | Barbados | 4075 | 47 | 3998 | 30 | 13.1939 | -59.5432 | 2021-06-28 04:21:29 | Barbados | |||
2021-06-26 | Malta | 30606 | 420 | 30156 | 30 | 35.9375 | 14.3754 | 2021-06-27 04:21:39 | Malta | |||
2021-06-23 | Japan | Yamagata | 2020 | 47 | 1943 | 30 | 38.448396 | 140.102154 | 2021-06-24 04:21:55 | Yamagata, Japan | ||
2021-06-21 | Netherlands | Aruba | 11112 | 107 | 10975 | 30 | 12.5211 | -69.9683 | 2021-06-22 04:21:34 | Aruba, Netherlands | ||
2021-06-21 | Japan | Aomori | 2453 | 31 | 2392 | 30 | 40.781541 | 140.828896 | 2021-06-22 04:21:34 | Aomori, Japan | ||
2021-06-20 | Malaysia | Perlis | 572 | 6 | 536 | 30 | 6.4449 | 100.2048 | 2021-06-21 04:21:41 | Perlis, Malaysia | ||
2021-06-17 | Russia | Nenets Autonomous Okrug | 1141 | 4 | 1107 | 30 | 68.27557185 | 57.1686375 | 2021-06-18 04:22:16 | Nenets Autonomous Okrug, Russia | ||
2021-06-17 | Russia | Chukotka Autonomous Okrug | 781 | 8 | 743 | 30 | 66.0006475 | 169.4900869 | 2021-06-18 04:22:16 | Chukotka Autonomous Okrug, Russia | ||
2021-06-16 | China | Yunnan | 380 | 2 | 348 | 30 | 24.974 | 101.487 | 2021-06-17 04:22:36 | Yunnan, China | ||
2021-06-13 | Colombia | Vaupes | 1620 | 14 | 1576 | 30 | 0.8554 | -70.812 | 2021-06-14 04:22:46 | Vaupes, Colombia | ||
2021-06-12 | Netherlands | Curacao | 12293 | 123 | 12140 | 30 | 12.1696 | -68.99 | 2021-06-13 04:22:44 | Curacao, Netherlands | ||
2021-06-11 | Netherlands | Curacao | 12293 | 123 | 12140 | 30 | 12.1696 | -68.99 | 2021-06-12 04:22:22 | Curacao, Netherlands | ||
2021-06-11 | Japan | Ehime | 2736 | 75 | 2631 | 30 | 33.624835 | 132.856842 | 2021-06-12 04:22:22 | Ehime, Japan | ||
2021-06-10 | Japan | Saga | 2535 | 23 | 2482 | 30 | 33.286977 | 130.115738 | 2021-06-11 04:23:20 | Saga, Japan | ||
2021-06-10 | China | Sichuan | 1046 | 3 | 1013 | 30 | 30.6171 | 102.7103 | 2021-06-11 04:23:20 | Sichuan, China | ||
2021-06-08 | China | Zhejiang | 1368 | 1 | 1337 | 30 | 29.1832 | 120.0934 | 2021-06-09 04:23:31 | Zhejiang, China | ||
2021-06-07 | China | Zhejiang | 1368 | 1 | 1337 | 30 | 29.1832 | 120.0934 | 2021-06-08 04:22:35 | Zhejiang, China | ||
2021-06-06 | Japan | Akita | 760 | 16 | 714 | 30 | 39.748679 | 140.408228 | 2021-06-07 04:22:51 | Akita, Japan | ||
2021-06-05 | Japan | Tokushima | 1636 | 63 | 1543 | 30 | 33.919178 | 134.242091 | 2021-06-06 04:24:03 | Tokushima, Japan | ||
2021-06-03 | Gambia | 5995 | 179 | 5786 | 30 | 13.4432 | -15.3101 | 2021-06-04 04:23:37 | Gambia | |||
2021-05-31 | China | Sichuan | 1027 | 3 | 994 | 30 | 30.6171 | 102.7103 | 2021-06-01 04:23:09 | Sichuan, China | ||
2021-05-30 | China | Sichuan | 1025 | 3 | 992 | 30 | 30.6171 | 102.7103 | 2021-05-31 03:08:59 | Sichuan, China | ||
2021-05-28 | China | Fujian | 618 | 1 | 587 | 30 | 26.0789 | 117.9874 | 2021-05-29 04:20:41 | Fujian, China | ||
2021-05-25 | China | Sichuan | 1018 | 3 | 985 | 30 | 30.6171 | 102.7103 | 2021-05-26 04:20:35 | Sichuan, China | ||
2021-05-22 | China | Sichuan | 1012 | 3 | 979 | 30 | 30.6171 | 102.7103 | 2021-05-23 04:20:51 | Sichuan, China | ||
2021-05-19 | Chad | 4914 | 173 | 4711 | 30 | 15.4542 | 18.7322 | 2021-05-20 04:21:05 | Chad | |||
2021-05-18 | Liberia | 2131 | 85 | 2016 | 30 | 6.4280550000000005 | -9.429499 | 2021-05-19 04:20:42 | Liberia | |||
2021-05-17 | Colombia | Vaupes | 1401 | 14 | 1357 | 30 | 0.8554 | -70.812 | 2021-05-18 04:20:33 | Vaupes, Colombia | ||
2021-05-17 | China | Sichuan | 1004 | 3 | 971 | 30 | 30.6171 | 102.7103 | 2021-05-18 04:20:33 | Sichuan, China | ||
2021-05-16 | China | Zhejiang | 1355 | 1 | 1324 | 30 | 29.1832 | 120.0934 | 2021-05-17 04:20:34 | Zhejiang, China | ||
2021-05-14 | Monaco | 2490 | 32 | 2428 | 30 | 43.7333 | 7.4167 | 2021-05-15 04:20:58 | Monaco | |||
2021-05-13 | Monaco | 2490 | 32 | 2428 | 30 | 43.7333 | 7.4167 | 2021-05-14 04:20:41 | Monaco | |||
2021-05-10 | Netherlands | Sint Maarten | 2263 | 27 | 2206 | 30 | 18.0425 | -63.0548 | 2021-05-11 04:20:41 | Sint Maarten, Netherlands | ||
2021-05-10 | Colombia | Guaviare | 2446 | 40 | 2376 | 30 | 1.0654 | -73.2603 | 2021-05-11 04:20:41 | Guaviare, Colombia | ||
2021-05-09 | Malaysia | W.P. Labuan | 2484 | 12 | 2442 | 30 | 5.2831 | 115.2308 | 2021-05-10 04:20:38 | W.P. Labuan, Malaysia | ||
2021-05-09 | Netherlands | Sint Maarten | 2260 | 27 | 2203 | 30 | 18.0425 | -63.0548 | 2021-05-10 04:20:38 | Sint Maarten, Netherlands | ||
2021-05-08 | Netherlands | Sint Maarten | 2260 | 27 | 2203 | 30 | 18.0425 | -63.0548 | 2021-05-09 04:20:35 | Sint Maarten, Netherlands | ||
2021-05-08 | China | Sichuan | 992 | 3 | 959 | 30 | 30.6171 | 102.7103 | 2021-05-09 04:20:35 | Sichuan, China | ||
2021-05-07 | Eswatini | 18474 | 671 | 17773 | 30 | -26.5225 | 31.4659 | 2021-05-08 04:21:04 | Eswatini | |||
2021-05-07 | China | Sichuan | 992 | 3 | 959 | 30 | 30.6171 | 102.7103 | 2021-05-08 04:21:04 | Sichuan, China | ||
2021-05-05 | Australia | South Australia | 733 | 4 | 699 | 30 | -34.9285 | 138.6007 | 2021-05-06 04:20:38 | South Australia, Australia | ||
2021-05-05 | Australia | Northern Territory | 167 | 0 | 137 | 30 | -12.4634 | 130.8456 | 2021-05-06 04:20:38 | Northern Territory, Australia | ||
2021-05-04 | Colombia | Guaviare | 2404 | 40 | 2334 | 30 | 1.0654 | -73.2603 | 2021-05-05 04:20:43 | Guaviare, Colombia | ||
2021-05-02 | United Kingdom | Turks and Caicos Islands | 2390 | 17 | 2343 | 30 | 21.694000000000006 | -71.7979 | 2021-05-03 04:20:39 | Turks and Caicos Islands, United Kingdom | ||
2021-05-02 | Colombia | Guaviare | 2388 | 40 | 2318 | 30 | 1.0654 | -73.2603 | 2021-05-03 04:20:39 | Guaviare, Colombia | ||
2021-05-01 | United Kingdom | Turks and Caicos Islands | 2390 | 17 | 2343 | 30 | 21.694000000000006 | -71.7979 | 2021-05-02 04:20:48 | Turks and Caicos Islands, United Kingdom | ||
2021-05-01 | Colombia | Guaviare | 2378 | 40 | 2308 | 30 | 1.0654 | -73.2603 | 2021-05-02 04:20:48 | Guaviare, Colombia | ||
2021-04-24 | Japan | Kochi | 982 | 19 | 933 | 30 | 33.422519 | 133.367307 | 2021-04-25 04:20:32 | Kochi, Japan | ||
2021-04-23 | Sao Tome and Principe | 2292 | 35 | 2227 | 30 | 0.1864 | 6.6131 | 2021-04-24 04:20:38 | Sao Tome and Principe | |||
2021-04-22 | Sao Tome and Principe | 2292 | 35 | 2227 | 30 | 0.1864 | 6.6131 | 2021-04-23 04:20:52 | Sao Tome and Principe | |||
2021-04-22 | Canada | Newfoundland and Labrador | 1052 | 6 | 1016 | 30 | 53.1355 | -57.6604 | 2021-04-23 04:20:52 | Newfoundland and Labrador, Canada | ||
2021-04-19 | Colombia | Guainia | 1387 | 22 | 1335 | 30 | 2.5854 | -68.5247 | 2021-04-20 04:20:41 | Guainia, Colombia | ||
2021-04-17 | Sao Tome and Principe | 2275 | 35 | 2210 | 30 | 0.1864 | 6.6131 | 2021-04-18 04:20:41 | Sao Tome and Principe | |||
2021-04-14 | Colombia | Guainia | 1368 | 22 | 1316 | 30 | 2.5854 | -68.5247 | 2021-04-15 04:20:54 | Guainia, Colombia | ||
2021-04-11 | Japan | Nagasaki | 1660 | 39 | 1591 | 30 | 33.235712 | 129.608033 | 2021-04-12 04:21:00 | Nagasaki, Japan | ||
2021-04-09 | India | Arunachal Pradesh | 16875 | 56 | 16789 | 30 | 27.768456 | 96.384277 | 2021-04-10 04:20:59 | Arunachal Pradesh, India | ||
2021-04-09 | Bhutan | 906 | 1 | 875 | 30 | 27.5142 | 90.4336 | 2021-04-10 04:20:59 | Bhutan | |||
2021-04-07 | Colombia | San Andres y Providencia | 2860 | 46 | 2784 | 30 | 12.5567 | -81.7185 | 2021-04-08 04:21:13 | San Andres y Providencia, Colombia | ||
2021-04-05 | Colombia | San Andres y Providencia | 2800 | 45 | 2725 | 30 | 12.5567 | -81.7185 | 2021-04-06 04:20:32 | San Andres y Providencia, Colombia | ||
2021-04-04 | Japan | Kumamoto | 3520 | 74 | 3416 | 30 | 32.608154 | 130.74523100000002 | 2021-04-05 04:20:35 | Kumamoto, Japan | ||
2021-04-03 | Japan | Toyama | 948 | 29 | 889 | 30 | 36.637464 | 137.26934599999998 | 2021-04-04 04:20:49 | Toyama, Japan | ||
2021-04-03 | Japan | Kumamoto | 3520 | 74 | 3416 | 30 | 32.608154 | 130.74523100000002 | 2021-04-04 04:20:49 | Kumamoto, Japan | ||
2021-04-02 | Japan | Saga | 1206 | 13 | 1163 | 30 | 33.286977 | 130.115738 | 2021-04-03 04:20:44 | Saga, Japan | ||
2021-04-01 | Japan | Kumamoto | 3511 | 74 | 3407 | 30 | 32.608154 | 130.74523100000002 | 2021-04-02 04:20:36 | Kumamoto, Japan | ||
2021-03-28 | Netherlands | Sint Maarten | 2130 | 27 | 2073 | 30 | 18.0425 | -63.0548 | 2021-03-29 04:28:35 | Sint Maarten, Netherlands | ||
2021-03-27 | Netherlands | Sint Maarten | 2130 | 27 | 2073 | 30 | 18.0425 | -63.0548 | 2021-03-28 05:28:10 | Sint Maarten, Netherlands | ||
2021-03-26 | Taiwan* | 1013 | 10 | 973 | 30 | 23.7 | 121.0 | 2021-03-27 05:25:04 | Taiwan* | |||
2021-03-25 | Malaysia | W.P. Labuan | 2304 | 12 | 2262 | 30 | 5.2831 | 115.2308 | 2021-03-26 05:26:55 | W.P. Labuan, Malaysia | ||
2021-03-24 | Malaysia | W.P. Labuan | 2301 | 12 | 2259 | 30 | 5.2831 | 115.2308 | 2021-03-25 05:27:00 | W.P. Labuan, Malaysia | ||
2021-03-24 | Taiwan* | 1009 | 10 | 969 | 30 | 23.7 | 121.0 | 2021-03-25 05:27:00 | Taiwan* | |||
2021-03-21 | India | Tripura | 33464 | 391 | 33043 | 30 | 23.746783 | 91.743565 | 2021-03-22 05:25:43 | Tripura, India |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;