johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,077 rows where active = 35 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 >30
- US 2,632
- Japan 87
- China 41
- Colombia 34
- United Kingdom 26
- Malaysia 25
- Russia 21
- Italy 14
- France 13
- Liberia 13
- Australia 11
- Canada 11
- Eritrea 11
- Netherlands 10
- Papua New Guinea 10
- Ukraine 9
- Barbados 8
- Comoros 8
- Taiwan* 8
- Denmark 6
- India 6
- Cambodia 5
- Sao Tome and Principe 5
- Botswana 4
- Chad 4
- Germany 4
- Antigua and Barbuda 3
- Burkina Faso 3
- Central African Republic 3
- Iceland 3
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
335567 | 335567 | 2021-08-04 | United Kingdom | Turks and Caicos Islands | 2486 | 18 | 2433 | 35 | 21.694000000000006 | -71.7979 | 2021-08-05 04:21:51 | Turks and Caicos Islands, United Kingdom | ||
331764 | 331764 | 2021-08-04 | Colombia | San Andres y Providencia | 6758 | 133 | 6590 | 35 | 12.5567 | -81.7185 | 2021-08-05 04:21:51 | San Andres y Providencia, Colombia | ||
3471838 | 3471838 | 2021-08-03 | United Kingdom | Turks and Caicos Islands | 2486 | 18 | 2433 | 35 | 21.694000000000006 | -71.7979 | 2021-08-04 04:21:25 | Turks and Caicos Islands, United Kingdom | ||
3687112 | 3687112 | 2021-08-02 | United Kingdom | Turks and Caicos Islands | 2486 | 18 | 2433 | 35 | 21.694000000000006 | -71.7979 | 2021-08-03 04:21:39 | Turks and Caicos Islands, United Kingdom | ||
3019011 | 3019011 | 2021-08-01 | United Kingdom | Turks and Caicos Islands | 2486 | 18 | 2433 | 35 | 21.694000000000006 | -71.7979 | 2021-08-02 04:21:36 | Turks and Caicos Islands, United Kingdom | ||
3907634 | 3907634 | 2021-07-31 | United Kingdom | Turks and Caicos Islands | 2484 | 18 | 2431 | 35 | 21.694000000000006 | -71.7979 | 2021-08-01 04:21:50 | Turks and Caicos Islands, United Kingdom | ||
3903730 | 3903730 | 2021-07-31 | Burkina Faso | 13573 | 169 | 13369 | 35 | 12.2383 | -1.5616 | 2021-08-01 04:21:50 | Burkina Faso | |||
3295935 | 3295935 | 2021-07-30 | Burkina Faso | 13573 | 169 | 13369 | 35 | 12.2383 | -1.5616 | 2021-07-31 04:21:35 | Burkina Faso | |||
1306189 | 1306189 | 2021-07-27 | Japan | Saga | 2655 | 24 | 2596 | 35 | 33.286977 | 130.115738 | 2021-07-28 04:21:39 | Saga, Japan | ||
1378775 | 1378775 | 2021-07-25 | Saint Kitts and Nevis | 565 | 3 | 527 | 35 | 17.357822 | -62.782998 | 2021-07-26 04:21:28 | Saint Kitts and Nevis | |||
1333927 | 1333927 | 2021-07-24 | Malaysia | Perlis | 648 | 8 | 605 | 35 | 6.4449 | 100.2048 | 2021-07-25 04:22:12 | Perlis, Malaysia | ||
3137492 | 3137492 | 2021-07-23 | India | Chandigarh | 61917 | 809 | 61073 | 35 | 30.733839 | 76.76827800000002 | 2021-07-24 00:21:36 | Chandigarh, India | ||
2371558 | 2371558 | 2021-07-20 | Japan | Yamaguchi | 3196 | 80 | 3081 | 35 | 34.201190000000004 | 131.573293 | 2021-07-21 04:21:40 | Yamaguchi, Japan | ||
483627 | 483627 | 2021-07-19 | Japan | Shimane | 591 | 2 | 554 | 35 | 35.07076 | 132.55406399999998 | 2021-07-20 04:21:48 | Shimane, Japan | ||
2677474 | 2677474 | 2021-07-18 | United Kingdom | Turks and Caicos Islands | 2453 | 18 | 2400 | 35 | 21.694000000000006 | -71.7979 | 2021-07-19 04:21:24 | Turks and Caicos Islands, United Kingdom | ||
2673860 | 2673860 | 2021-07-18 | Japan | Yamaguchi | 3193 | 80 | 3078 | 35 | 34.201190000000004 | 131.573293 | 2021-07-19 04:21:24 | Yamaguchi, Japan | ||
2673856 | 2673856 | 2021-07-18 | Japan | Toyama | 2085 | 38 | 2012 | 35 | 36.637464 | 137.26934599999998 | 2021-07-19 04:21:24 | Toyama, Japan | ||
3706129 | 3706129 | 2021-07-17 | Japan | Ehime | 2788 | 75 | 2678 | 35 | 33.624835 | 132.856842 | 2021-07-18 04:22:07 | Ehime, Japan | ||
2947376 | 2947376 | 2021-07-16 | Japan | Kumamoto | 6516 | 119 | 6362 | 35 | 32.608154 | 130.74523100000002 | 2021-07-17 04:22:22 | Kumamoto, Japan | ||
2947203 | 2947203 | 2021-07-16 | Colombia | Guainia | 2172 | 28 | 2109 | 35 | 2.5854 | -68.5247 | 2021-07-17 04:22:22 | Guainia, Colombia | ||
296014 | 296014 | 2021-07-15 | Japan | Aomori | 2561 | 31 | 2495 | 35 | 40.781541 | 140.828896 | 2021-07-16 04:21:22 | Aomori, Japan | ||
3632004 | 3632004 | 2021-07-14 | Japan | Yamaguchi | 3180 | 80 | 3065 | 35 | 34.201190000000004 | 131.573293 | 2021-07-15 04:21:48 | Yamaguchi, Japan | ||
3631983 | 3631983 | 2021-07-14 | Japan | Nagasaki | 3236 | 69 | 3132 | 35 | 33.235712 | 129.608033 | 2021-07-15 04:21:48 | Nagasaki, Japan | ||
3659636 | 3659636 | 2021-07-11 | Japan | Tottori | 495 | 2 | 458 | 35 | 35.359069 | 133.863619 | 2021-07-12 04:21:34 | Tottori, Japan | ||
3659624 | 3659624 | 2021-07-11 | Japan | Okayama | 7616 | 126 | 7455 | 35 | 34.89246 | 133.826252 | 2021-07-12 04:21:34 | Okayama, Japan | ||
829639 | 829639 | 2021-07-09 | Japan | Tottori | 494 | 2 | 457 | 35 | 35.359069 | 133.863619 | 2021-07-10 04:21:25 | Tottori, Japan | ||
778403 | 778403 | 2021-07-08 | Japan | Tottori | 494 | 2 | 457 | 35 | 35.359069 | 133.863619 | 2021-07-09 04:21:21 | Tottori, Japan | ||
1440625 | 1440625 | 2021-07-07 | Japan | Tottori | 494 | 2 | 457 | 35 | 35.359069 | 133.863619 | 2021-07-08 04:21:26 | Tottori, Japan | ||
1936092 | 1936092 | 2021-07-05 | United Kingdom | Gibraltar | 4372 | 94 | 4243 | 35 | 36.1408 | -5.3536 | 2021-07-06 04:21:32 | Gibraltar, United Kingdom | ||
1932380 | 1932380 | 2021-07-05 | India | Dadra and Nagar Haveli and Daman and Diu | 10569 | 4 | 10530 | 35 | 20.194742 | 73.080901 | 2021-07-06 04:21:32 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2764957 | 2764957 | 2021-07-01 | Japan | Miyazaki | 3087 | 27 | 3025 | 35 | 32.193203999999994 | 131.299374 | 2021-07-02 04:21:47 | Miyazaki, Japan | ||
1893155 | 1893155 | 2021-06-30 | Japan | Ishikawa | 3931 | 115 | 3781 | 35 | 36.769464 | 136.771027 | 2021-07-01 04:21:19 | Ishikawa, Japan | ||
1893138 | 1893138 | 2021-06-30 | Italy | Valle d'Aosta | 11691 | 473 | 11183 | 35 | 45.73750286 | 7.320149366 | 2021-07-01 04:21:19 | Valle d'Aosta, Italy | ||
1892849 | 1892849 | 2021-06-30 | Barbados | 4081 | 47 | 3999 | 35 | 13.1939 | -59.5432 | 2021-07-01 04:21:19 | Barbados | |||
400288 | 400288 | 2021-06-29 | Japan | Miyazaki | 3081 | 27 | 3019 | 35 | 32.193203999999994 | 131.299374 | 2021-06-30 04:21:41 | Miyazaki, Japan | ||
3125504 | 3125504 | 2021-06-28 | Italy | Valle d'Aosta | 11685 | 473 | 11177 | 35 | 45.73750286 | 7.320149366 | 2021-06-29 04:21:28 | Valle d'Aosta, Italy | ||
1712444 | 1712444 | 2021-06-25 | Netherlands | Curacao | 12327 | 126 | 12166 | 35 | 12.1696 | -68.99 | 2021-06-26 04:21:43 | Curacao, Netherlands | ||
1712230 | 1712230 | 2021-06-25 | Gambia | 6065 | 181 | 5849 | 35 | 13.4432 | -15.3101 | 2021-06-26 04:21:43 | Gambia | |||
2295569 | 2295569 | 2021-06-24 | Netherlands | Curacao | 12327 | 126 | 12166 | 35 | 12.1696 | -68.99 | 2021-06-25 04:21:33 | Curacao, Netherlands | ||
2295567 | 2295567 | 2021-06-24 | Netherlands | Aruba | 11125 | 107 | 10983 | 35 | 12.5211 | -69.9683 | 2021-06-25 04:21:33 | Aruba, Netherlands | ||
2295447 | 2295447 | 2021-06-24 | Italy | Valle d'Aosta | 11678 | 473 | 11170 | 35 | 45.73750286 | 7.320149366 | 2021-06-25 04:21:33 | Valle d'Aosta, Italy | ||
563013 | 563013 | 2021-06-22 | Japan | Yamagata | 2020 | 47 | 1938 | 35 | 38.448396 | 140.102154 | 2021-06-23 04:21:46 | Yamagata, Japan | ||
3358865 | 3358865 | 2021-06-21 | Russia | Chukotka Autonomous Okrug | 786 | 8 | 743 | 35 | 66.0006475 | 169.4900869 | 2021-06-22 04:21:34 | Chukotka Autonomous Okrug, Russia | ||
3358779 | 3358779 | 2021-06-21 | Monaco | 2549 | 33 | 2481 | 35 | 43.7333 | 7.4167 | 2021-06-22 04:21:34 | Monaco | |||
2884597 | 2884597 | 2021-06-20 | Russia | Nenets Autonomous Okrug | 1153 | 4 | 1114 | 35 | 68.27557185 | 57.1686375 | 2021-06-21 04:21:41 | Nenets Autonomous Okrug, Russia | ||
2884564 | 2884564 | 2021-06-20 | Russia | Chukotka Autonomous Okrug | 786 | 8 | 743 | 35 | 66.0006475 | 169.4900869 | 2021-06-21 04:21:41 | Chukotka Autonomous Okrug, Russia | ||
107453 | 107453 | 2021-06-19 | Japan | Aomori | 2453 | 31 | 2387 | 35 | 40.781541 | 140.828896 | 2021-06-20 04:21:48 | Aomori, Japan | ||
107298 | 107298 | 2021-06-19 | Colombia | Guainia | 1991 | 23 | 1933 | 35 | 2.5854 | -68.5247 | 2021-06-20 04:21:48 | Guainia, Colombia | ||
2911291 | 2911291 | 2021-06-17 | Netherlands | Curacao | 12308 | 123 | 12150 | 35 | 12.1696 | -68.99 | 2021-06-18 04:22:16 | Curacao, Netherlands | ||
3030409 | 3030409 | 2021-06-16 | Netherlands | Curacao | 12304 | 123 | 12146 | 35 | 12.1696 | -68.99 | 2021-06-17 04:22:36 | Curacao, Netherlands | ||
3030121 | 3030121 | 2021-06-16 | China | Zhejiang | 1373 | 1 | 1337 | 35 | 29.1832 | 120.0934 | 2021-06-17 04:22:36 | Zhejiang, China | ||
3030091 | 3030091 | 2021-06-16 | China | Fujian | 641 | 1 | 605 | 35 | 26.0789 | 117.9874 | 2021-06-17 04:22:36 | Fujian, China | ||
2339244 | 2339244 | 2021-06-15 | Colombia | Guaviare | 3546 | 60 | 3451 | 35 | 1.0654 | -73.2603 | 2021-06-16 04:22:32 | Guaviare, Colombia | ||
2339227 | 2339227 | 2021-06-15 | China | Zhejiang | 1373 | 1 | 1337 | 35 | 29.1832 | 120.0934 | 2021-06-16 04:22:32 | Zhejiang, China | ||
1563940 | 1563940 | 2021-06-14 | Colombia | Guaviare | 3546 | 60 | 3451 | 35 | 1.0654 | -73.2603 | 2021-06-15 04:22:22 | Guaviare, Colombia | ||
1563923 | 1563923 | 2021-06-14 | China | Zhejiang | 1373 | 1 | 1337 | 35 | 29.1832 | 120.0934 | 2021-06-15 04:22:22 | Zhejiang, China | ||
1563893 | 1563893 | 2021-06-14 | China | Fujian | 638 | 1 | 602 | 35 | 26.0789 | 117.9874 | 2021-06-15 04:22:22 | Fujian, China | ||
1736384 | 1736384 | 2021-06-12 | Denmark | Faroe Islands | 755 | 1 | 719 | 35 | 61.8926 | -6.9118 | 2021-06-13 04:22:44 | Faroe Islands, Denmark | ||
522974 | 522974 | 2021-06-09 | Netherlands | Aruba | 11068 | 107 | 10926 | 35 | 12.5211 | -69.9683 | 2021-06-10 04:23:17 | Aruba, Netherlands | ||
522555 | 522555 | 2021-06-09 | Australia | Queensland | 1642 | 7 | 1600 | 35 | -27.4698 | 153.0251 | 2021-06-10 04:23:17 | Queensland, Australia | ||
3145382 | 3145382 | 2021-06-07 | China | Fujian | 631 | 1 | 595 | 35 | 26.0789 | 117.9874 | 2021-06-08 04:22:35 | Fujian, China | ||
2315303 | 2315303 | 2021-06-04 | Japan | Akita | 760 | 16 | 709 | 35 | 39.748679 | 140.408228 | 2021-06-05 04:23:03 | Akita, Japan | ||
1448592 | 1448592 | 2021-06-03 | Japan | Fukui | 1050 | 34 | 981 | 35 | 35.846614 | 136.22465400000002 | 2021-06-04 04:23:37 | Fukui, Japan | ||
1708112 | 1708112 | 2021-06-02 | China | Fujian | 625 | 1 | 589 | 35 | 26.0789 | 117.9874 | 2021-06-03 04:23:32 | Fujian, China | ||
2104134 | 2104134 | 2021-06-01 | Japan | Fukui | 1040 | 34 | 971 | 35 | 35.846614 | 136.22465400000002 | 2021-06-02 04:24:34 | Fukui, Japan | ||
2103930 | 2103930 | 2021-06-01 | China | Fujian | 624 | 1 | 588 | 35 | 26.0789 | 117.9874 | 2021-06-02 04:24:34 | Fujian, China | ||
1188945 | 1188945 | 2021-05-31 | Russia | Jewish Autonomous Okrug | 4496 | 142 | 4319 | 35 | 48.57527615 | 132.66307460000002 | 2021-06-01 04:23:09 | Jewish Autonomous Okrug, Russia | ||
3089622 | 3089622 | 2021-05-30 | Russia | Jewish Autonomous Okrug | 4495 | 142 | 4318 | 35 | 48.57527615 | 132.66307460000002 | 2021-05-31 03:08:59 | Jewish Autonomous Okrug, Russia | ||
50991 | 50991 | 2021-05-29 | Russia | Jewish Autonomous Okrug | 4494 | 142 | 4317 | 35 | 48.57527615 | 132.66307460000002 | 2021-05-30 04:20:55 | Jewish Autonomous Okrug, Russia | ||
20570 | 20570 | 2021-05-28 | Russia | Jewish Autonomous Okrug | 4493 | 142 | 4316 | 35 | 48.57527615 | 132.66307460000002 | 2021-05-29 04:20:41 | Jewish Autonomous Okrug, Russia | ||
1806945 | 1806945 | 2021-05-27 | Russia | Jewish Autonomous Okrug | 4491 | 142 | 4314 | 35 | 48.57527615 | 132.66307460000002 | 2021-05-28 04:20:36 | Jewish Autonomous Okrug, Russia | ||
1310368 | 1310368 | 2021-05-26 | Russia | Jewish Autonomous Okrug | 4489 | 142 | 4312 | 35 | 48.57527615 | 132.66307460000002 | 2021-05-27 04:20:59 | Jewish Autonomous Okrug, Russia | ||
1309877 | 1309877 | 2021-05-26 | Barbados | 4004 | 47 | 3922 | 35 | 13.1939 | -59.5432 | 2021-05-27 04:20:59 | Barbados | |||
1309870 | 1309870 | 2021-05-26 | Australia | Victoria | 20575 | 820 | 19720 | 35 | -37.8136 | 144.9631 | 2021-05-27 04:20:59 | Victoria, Australia | ||
1771542 | 1771542 | 2021-05-23 | Russia | Jewish Autonomous Okrug | 4486 | 142 | 4309 | 35 | 48.57527615 | 132.66307460000002 | 2021-05-24 04:20:53 | Jewish Autonomous Okrug, Russia | ||
1771403 | 1771403 | 2021-05-23 | Liberia | 2142 | 85 | 2022 | 35 | 6.4280550000000005 | -9.429499 | 2021-05-24 04:20:53 | Liberia | |||
1771207 | 1771207 | 2021-05-23 | Colombia | Vaupes | 1484 | 14 | 1435 | 35 | 0.8554 | -70.812 | 2021-05-24 04:20:53 | Vaupes, Colombia | ||
726752 | 726752 | 2021-05-22 | Russia | Tyva Republic | 15913 | 203 | 15675 | 35 | 51.4017149 | 93.8582593 | 2021-05-23 04:20:51 | Tyva Republic, Russia | ||
726558 | 726558 | 2021-05-22 | Liberia | 2142 | 85 | 2022 | 35 | 6.4280550000000005 | -9.429499 | 2021-05-23 04:20:51 | Liberia | |||
1952573 | 1952573 | 2021-05-21 | Liberia | 2142 | 85 | 2022 | 35 | 6.4280550000000005 | -9.429499 | 2021-05-22 04:20:45 | Liberia | |||
1913272 | 1913272 | 2021-05-20 | Liberia | 2142 | 85 | 2022 | 35 | 6.4280550000000005 | -9.429499 | 2021-05-21 04:20:43 | Liberia | |||
2255597 | 2255597 | 2021-05-19 | Colombia | Vaupes | 1415 | 14 | 1366 | 35 | 0.8554 | -70.812 | 2021-05-20 04:21:05 | Vaupes, Colombia | ||
3574795 | 3574795 | 2021-05-17 | Russia | Jewish Autonomous Okrug | 4478 | 140 | 4303 | 35 | 48.57527615 | 132.66307460000002 | 2021-05-18 04:20:33 | Jewish Autonomous Okrug, Russia | ||
2939190 | 2939190 | 2021-05-16 | Colombia | Vaupes | 1401 | 14 | 1352 | 35 | 0.8554 | -70.812 | 2021-05-17 04:20:34 | Vaupes, Colombia | ||
1872820 | 1872820 | 2021-05-15 | Colombia | Vaupes | 1391 | 13 | 1343 | 35 | 0.8554 | -70.812 | 2021-05-16 04:20:49 | Vaupes, Colombia | ||
1081755 | 1081755 | 2021-05-14 | China | Yunnan | 348 | 2 | 311 | 35 | 24.974 | 101.487 | 2021-05-15 04:20:58 | Yunnan, China | ||
3954529 | 3954529 | 2021-05-11 | Japan | Shimane | 385 | 0 | 350 | 35 | 35.07076 | 132.55406399999998 | 2021-05-12 04:21:29 | Shimane, Japan | ||
3954200 | 3954200 | 2021-05-11 | Barbados | 3950 | 45 | 3870 | 35 | 13.1939 | -59.5432 | 2021-05-12 04:21:29 | Barbados | |||
2820463 | 2820463 | 2021-05-10 | Antigua and Barbuda | 1237 | 32 | 1170 | 35 | 17.0608 | -61.7964 | 2021-05-11 04:20:41 | Antigua and Barbuda | |||
3675351 | 3675351 | 2021-05-04 | Australia | South Australia | 733 | 4 | 694 | 35 | -34.9285 | 138.6007 | 2021-05-05 04:20:43 | South Australia, Australia | ||
3675349 | 3675349 | 2021-05-04 | Australia | Northern Territory | 166 | 0 | 131 | 35 | -12.4634 | 130.8456 | 2021-05-05 04:20:43 | Northern Territory, Australia | ||
2760618 | 2760618 | 2021-05-03 | Australia | South Australia | 730 | 4 | 691 | 35 | -34.9285 | 138.6007 | 2021-05-04 04:20:34 | South Australia, Australia | ||
2760616 | 2760616 | 2021-05-03 | Australia | Northern Territory | 166 | 0 | 131 | 35 | -12.4634 | 130.8456 | 2021-05-04 04:20:34 | Northern Territory, Australia | ||
2450469 | 2450469 | 2021-05-02 | Australia | Northern Territory | 166 | 0 | 131 | 35 | -12.4634 | 130.8456 | 2021-05-03 04:20:39 | Northern Territory, Australia | ||
1636024 | 1636024 | 2021-04-29 | Barbados | 3838 | 44 | 3759 | 35 | 13.1939 | -59.5432 | 2021-04-30 04:21:03 | Barbados | |||
887819 | 887819 | 2021-04-26 | Australia | South Australia | 719 | 4 | 680 | 35 | -34.9285 | 138.6007 | 2021-04-27 04:20:52 | South Australia, Australia | ||
1409372 | 1409372 | 2021-04-23 | Taiwan* | 1090 | 11 | 1044 | 35 | 23.7 | 121.0 | 2021-04-24 04:20:38 | Taiwan* | |||
1408909 | 1408909 | 2021-04-23 | Comoros | 3826 | 146 | 3645 | 35 | -11.6455 | 43.3333 | 2021-04-24 04:20:38 | Comoros | |||
2549145 | 2549145 | 2021-04-15 | Sao Tome and Principe | 2271 | 35 | 2201 | 35 | 0.1864 | 6.6131 | 2021-04-16 04:20:46 | Sao Tome and Principe | |||
1841965 | 1841965 | 2021-04-14 | Japan | Kumamoto | 3561 | 74 | 3452 | 35 | 32.608154 | 130.74523100000002 | 2021-04-15 04:20:54 | Kumamoto, 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]);