johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,501 rows where active = 107 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,318
- Japan 34
- Malaysia 14
- Colombia 12
- Germany 10
- Ukraine 9
- Benin 7
- Italy 6
- Russia 6
- Chad 4
- China 4
- India 4
- Netherlands 4
- Niger 4
- Yemen 4
- Georgia 3
- Liberia 3
- Liechtenstein 3
- Mexico 3
- Pakistan 3
- Spain 3
- Australia 2
- Canada 2
- France 2
- Papua New Guinea 2
- Taiwan* 2
- Thailand 2
- Uganda 2
- United Kingdom 2
- Vietnam 2
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3904043 | 3904043 | 2021-07-31 | Mali | 14584 | 532 | 13945 | 107 | 17.570692 | -3.996166000000001 | 2021-08-01 04:21:50 | Mali | |||
3903975 | 3903975 | 2021-07-31 | Japan | Aomori | 2698 | 32 | 2559 | 107 | 40.781541 | 140.828896 | 2021-08-01 04:21:50 | Aomori, Japan | ||
3389015 | 3389015 | 2021-07-29 | Ukraine | Ivano-Frankivsk Oblast | 86842 | 2107 | 84628 | 107 | 48.9226 | 24.7111 | 2021-07-30 04:21:34 | Ivano-Frankivsk Oblast, Ukraine | ||
411920 | 411920 | 2021-07-28 | Ukraine | Ivano-Frankivsk Oblast | 86834 | 2107 | 84620 | 107 | 48.9226 | 24.7111 | 2021-07-29 04:21:33 | Ivano-Frankivsk Oblast, Ukraine | ||
408299 | 408299 | 2021-07-28 | Japan | Fukui | 1520 | 36 | 1377 | 107 | 35.846614 | 136.22465400000002 | 2021-07-29 04:21:33 | Fukui, Japan | ||
1378534 | 1378534 | 2021-07-25 | Japan | Nara | 8617 | 133 | 8377 | 107 | 34.317451 | 135.871644 | 2021-07-26 04:21:28 | Nara, Japan | ||
1330384 | 1330384 | 2021-07-24 | Niger | 5598 | 195 | 5296 | 107 | 17.607789 | 8.081666 | 2021-07-25 04:22:12 | Niger | |||
3137661 | 3137661 | 2021-07-23 | Monaco | 2757 | 33 | 2617 | 107 | 43.7333 | 7.4167 | 2021-07-24 00:21:36 | Monaco | |||
483632 | 483632 | 2021-07-19 | Japan | Tottori | 585 | 2 | 476 | 107 | 35.359069 | 133.863619 | 2021-07-20 04:21:48 | Tottori, Japan | ||
3635579 | 3635579 | 2021-07-14 | Ukraine | Chernivtsi Oblast | 80019 | 1794 | 78118 | 107 | 48.2917 | 25.9352 | 2021-07-15 04:21:48 | Chernivtsi Oblast, Ukraine | ||
578969 | 578969 | 2021-07-13 | Niger | 5546 | 194 | 5245 | 107 | 17.607789 | 8.081666 | 2021-07-14 04:21:35 | Niger | |||
778557 | 778557 | 2021-07-08 | Russia | Chukotka Autonomous Okrug | 880 | 8 | 765 | 107 | 66.0006475 | 169.4900869 | 2021-07-09 04:21:21 | Chukotka Autonomous Okrug, Russia | ||
778350 | 778350 | 2021-07-08 | Italy | P.A. Bolzano | 73357 | 1180 | 72070 | 107 | 46.49933453 | 11.35662422 | 2021-07-09 04:21:21 | P.A. Bolzano, Italy | ||
1893160 | 1893160 | 2021-06-30 | Japan | Kochi | 1824 | 25 | 1692 | 107 | 33.422519 | 133.367307 | 2021-07-01 04:21:19 | Kochi, Japan | ||
3125543 | 3125543 | 2021-06-28 | Japan | Shiga | 5542 | 90 | 5345 | 107 | 35.21582700000001 | 136.138064 | 2021-06-29 04:21:28 | Shiga, Japan | ||
2589872 | 2589872 | 2021-06-27 | Cote d'Ivoire | 48192 | 312 | 47773 | 107 | 7.54 | -5.5471 | 2021-06-28 04:21:29 | Cote d'Ivoire | |||
2295483 | 2295483 | 2021-06-24 | Japan | Port Quarantine | 3089 | 5 | 2978 | 107 | 2021-06-25 04:21:33 | Port Quarantine, Japan | ||||
3358871 | 3358871 | 2021-06-21 | Russia | Jewish Autonomous Okrug | 4608 | 146 | 4355 | 107 | 48.57527615 | 132.66307460000002 | 2021-06-22 04:21:34 | Jewish Autonomous Okrug, Russia | ||
111139 | 111139 | 2021-06-19 | Malaysia | W.P. Putrajaya | 2152 | 13 | 2032 | 107 | 2.9264 | 101.6964 | 2021-06-20 04:21:48 | W.P. Putrajaya, Malaysia | ||
107466 | 107466 | 2021-06-19 | Japan | Iwate | 1632 | 46 | 1479 | 107 | 39.593287 | 141.361777 | 2021-06-20 04:21:48 | Iwate, Japan | ||
2911235 | 2911235 | 2021-06-17 | Liechtenstein | 3119 | 58 | 2954 | 107 | 47.14 | 9.55 | 2021-06-18 04:22:16 | Liechtenstein | |||
2911229 | 2911229 | 2021-06-17 | Laos | 2034 | 3 | 1924 | 107 | 19.85627 | 102.495496 | 2021-06-18 04:22:16 | Laos | |||
2911195 | 2911195 | 2021-06-17 | Japan | Miyagi | 9057 | 85 | 8865 | 107 | 38.446859 | 140.927086 | 2021-06-18 04:22:16 | Miyagi, Japan | ||
2911191 | 2911191 | 2021-06-17 | Japan | Kochi | 1699 | 23 | 1569 | 107 | 33.422519 | 133.367307 | 2021-06-18 04:22:16 | Kochi, Japan | ||
3030353 | 3030353 | 2021-06-16 | Liechtenstein | 3119 | 58 | 2954 | 107 | 47.14 | 9.55 | 2021-06-17 04:22:36 | Liechtenstein | |||
3030304 | 3030304 | 2021-06-16 | Japan | Ishikawa | 3887 | 112 | 3668 | 107 | 36.769464 | 136.771027 | 2021-06-17 04:22:36 | Ishikawa, Japan | ||
1564235 | 1564235 | 2021-06-14 | Pakistan | Gilgit-Baltistan | 5727 | 108 | 5512 | 107 | 35.792146 | 74.982138 | 2021-06-15 04:22:22 | Gilgit-Baltistan, Pakistan | ||
2716987 | 2716987 | 2021-06-10 | Japan | Iwate | 1548 | 46 | 1395 | 107 | 39.593287 | 141.361777 | 2021-06-11 04:23:20 | Iwate, Japan | ||
2586131 | 2586131 | 2021-06-05 | Pakistan | Gilgit-Baltistan | 5633 | 107 | 5419 | 107 | 35.792146 | 74.982138 | 2021-06-06 04:24:03 | Gilgit-Baltistan, Pakistan | ||
2585924 | 2585924 | 2021-06-05 | India | Andaman and Nicobar Islands | 7105 | 122 | 6876 | 107 | 11.225999 | 92.968178 | 2021-06-06 04:24:03 | Andaman and Nicobar Islands, India | ||
1448575 | 1448575 | 2021-06-03 | Italy | Molise | 13599 | 491 | 13001 | 107 | 41.55774754 | 14.65916051 | 2021-06-04 04:23:37 | Molise, Italy | ||
1448452 | 1448452 | 2021-06-03 | Colombia | Vichada | 1940 | 31 | 1802 | 107 | 4.4234 | -69.2878 | 2021-06-04 04:23:37 | Vichada, Colombia | ||
83132 | 83132 | 2021-05-25 | Japan | Shimane | 512 | 0 | 405 | 107 | 35.07076 | 132.55406399999998 | 2021-05-26 04:20:35 | Shimane, Japan | ||
2259421 | 2259421 | 2021-05-19 | Malaysia | W.P. Putrajaya | 1570 | 10 | 1453 | 107 | 2.9264 | 101.6964 | 2021-05-20 04:21:05 | W.P. Putrajaya, Malaysia | ||
2820776 | 2820776 | 2021-05-10 | Japan | Fukui | 960 | 33 | 820 | 107 | 35.846614 | 136.22465400000002 | 2021-05-11 04:20:41 | Fukui, Japan | ||
649567 | 649567 | 2021-05-05 | Uganda | 42102 | 343 | 41652 | 107 | 1.373333 | 32.290275 | 2021-05-06 04:20:38 | Uganda | |||
645732 | 645732 | 2021-05-05 | Chad | 4847 | 170 | 4570 | 107 | 15.4542 | 18.7322 | 2021-05-06 04:20:38 | Chad | |||
982996 | 982996 | 2021-04-17 | Japan | Yamaguchi | 1540 | 43 | 1390 | 107 | 34.201190000000004 | 131.573293 | 2021-04-18 04:20:41 | Yamaguchi, Japan | ||
3883546 | 3883546 | 2021-04-11 | India | Manipur | 29496 | 376 | 29013 | 107 | 24.738975 | 93.882541 | 2021-04-12 04:21:00 | Manipur, India | ||
2983300 | 2983300 | 2021-04-10 | Japan | Toyama | 1035 | 29 | 899 | 107 | 36.637464 | 137.26934599999998 | 2021-04-11 04:20:56 | Toyama, Japan | ||
2646019 | 2646019 | 2021-04-08 | Saint Lucia | 4312 | 63 | 4142 | 107 | 13.9094 | -60.9789 | 2021-04-09 04:21:13 | Saint Lucia | |||
388067 | 388067 | 2021-04-04 | Colombia | Choco | 6762 | 204 | 6451 | 107 | 5.2528 | -76.82600000000002 | 2021-04-05 04:20:35 | Choco, Colombia | ||
1293661 | 1293661 | 2021-03-29 | United Kingdom | Turks and Caicos Islands | 2327 | 17 | 2203 | 107 | 21.694000000000006 | -71.7979 | 2021-03-30 04:26:23 | Turks and Caicos Islands, United Kingdom | ||
1535626 | 1535626 | 2021-03-28 | Australia | Queensland | 1456 | 6 | 1343 | 107 | -27.4698 | 153.0251 | 2021-03-29 04:28:35 | Queensland, Australia | ||
3621414 | 3621414 | 2021-03-17 | Timor-Leste | 216 | 0 | 109 | 107 | -8.874217 | 125.727539 | 2021-03-18 05:26:22 | Timor-Leste | |||
2055913 | 2055913 | 2021-03-15 | Japan | Okayama | 2583 | 35 | 2441 | 107 | 34.89246 | 133.826252 | 2021-03-16 05:25:13 | Okayama, Japan | ||
1732771 | 1732771 | 2021-03-14 | Singapore | 60105 | 30 | 59968 | 107 | 1.2833 | 103.8333 | 2021-03-15 05:25:51 | Singapore | |||
1583832 | 1583832 | 2021-03-13 | Malaysia | Perlis | 320 | 2 | 211 | 107 | 6.4449 | 100.2048 | 2021-03-14 05:25:37 | Perlis, Malaysia | ||
1580214 | 1580214 | 2021-03-13 | Liechtenstein | 2682 | 56 | 2519 | 107 | 47.14 | 9.55 | 2021-03-14 05:25:37 | Liechtenstein | |||
3966196 | 3966196 | 2021-03-10 | Malaysia | Melaka | 6066 | 22 | 5937 | 107 | 2.1896 | 102.2501 | 2021-03-11 05:25:48 | Melaka, Malaysia | ||
3962364 | 3962364 | 2021-03-10 | Colombia | Choco | 6599 | 202 | 6290 | 107 | 5.2528 | -76.82600000000002 | 2021-03-11 05:25:48 | Choco, Colombia | ||
54946 | 54946 | 2021-03-07 | Pakistan | Balochistan | 19117 | 201 | 18809 | 107 | 28.328492 | 65.898403 | 2021-03-08 05:24:48 | Balochistan, Pakistan | ||
3671307 | 3671307 | 2021-03-06 | Malaysia | Terengganu | 3273 | 11 | 3155 | 107 | 5.3117 | 103.1324 | 2021-03-07 05:21:54 | Terengganu, Malaysia | ||
3065878 | 3065878 | 2021-02-27 | Djibouti | 6065 | 63 | 5895 | 107 | 11.8251 | 42.5903 | 2021-02-28 05:22:20 | Djibouti | |||
2185850 | 2185850 | 2021-02-26 | US | New York | Unassigned | 90036 | 224 | 117 | 0 | 107 | 44.74530905 | 0.0 | 2021-02-27 05:22:28 | Unassigned, New York, US |
2183809 | 2183809 | 2021-02-26 | Russia | Nenets Autonomous Okrug | 1018 | 3 | 908 | 107 | 68.27557185 | 57.1686375 | 2021-02-27 05:22:28 | Nenets Autonomous Okrug, Russia | ||
1858012 | 1858012 | 2021-02-25 | Japan | Fukushima | 1909 | 70 | 1732 | 107 | 37.378867 | 140.223295 | 2021-02-26 05:22:40 | Fukushima, Japan | ||
280206 | 280206 | 2021-02-24 | Japan | Miyagi | 3580 | 25 | 3448 | 107 | 38.446859 | 140.927086 | 2021-02-25 05:24:57 | Miyagi, Japan | ||
1939569 | 1939569 | 2021-02-23 | US | Texas | Irion | 48235 | 104 | 1 | 0 | 107 | 31.30375559 | -100.982439 | 2021-02-24 05:29:16 | Irion, Texas, US |
745978 | 745978 | 2021-02-20 | Yemen | 2157 | 618 | 1432 | 107 | 15.552727 | 48.516388 | 2021-02-21 05:24:33 | Yemen | |||
475076 | 475076 | 2021-02-19 | Yemen | 2157 | 618 | 1432 | 107 | 15.552727 | 48.516388 | 2021-02-20 05:22:51 | Yemen | |||
3601101 | 3601101 | 2021-02-17 | Liberia | 1985 | 84 | 1794 | 107 | 6.4280550000000005 | -9.429499 | 2021-02-18 05:22:58 | Liberia | |||
3052241 | 3052241 | 2021-02-16 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-17 05:23:10 | Garden, Nebraska, US |
3050236 | 3050236 | 2021-02-16 | Liberia | 1985 | 84 | 1794 | 107 | 6.4280550000000005 | -9.429499 | 2021-02-17 05:23:10 | Liberia | |||
1340340 | 1340340 | 2021-02-15 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-16 05:24:38 | Garden, Nebraska, US |
2285491 | 2285491 | 2021-02-14 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-15 05:24:49 | Garden, Nebraska, US |
2679891 | 2679891 | 2021-02-13 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-14 05:23:43 | Garden, Nebraska, US |
3541524 | 3541524 | 2021-02-12 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-13 05:22:12 | Garden, Nebraska, US |
3539488 | 3539488 | 2021-02-12 | Japan | Oita | 1251 | 18 | 1126 | 107 | 33.200697 | 131.43323999999998 | 2021-02-13 05:22:12 | Oita, Japan | ||
2641148 | 2641148 | 2021-02-11 | US | Washington | Columbia | 53013 | 111 | 4 | 0 | 107 | 46.29442881 | -117.9051983 | 2021-02-12 05:23:29 | Columbia, Washington, US |
2639787 | 2639787 | 2021-02-11 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-12 05:23:29 | Garden, Nebraska, US |
3982003 | 3982003 | 2021-02-10 | US | Washington | Columbia | 53013 | 111 | 4 | 0 | 107 | 46.29442881 | -117.9051983 | 2021-02-11 05:23:55 | Columbia, Washington, US |
3981655 | 3981655 | 2021-02-10 | US | Texas | Foard | 48155 | 91 | 7 | 0 | 107 | 33.97308618 | -99.7767797 | 2021-02-11 05:23:55 | Foard, Texas, US |
3980642 | 3980642 | 2021-02-10 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-11 05:23:55 | Garden, Nebraska, US |
1531328 | 1531328 | 2021-02-09 | US | Washington | Garfield | 53023 | 111 | 4 | 0 | 107 | 46.43197502 | -117.5454032 | 2021-02-10 05:22:41 | Garfield, Washington, US |
1529962 | 1529962 | 2021-02-09 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-10 05:22:41 | Garden, Nebraska, US |
1527921 | 1527921 | 2021-02-09 | Japan | Miyazaki | 1887 | 20 | 1760 | 107 | 32.193203999999994 | 131.299374 | 2021-02-10 05:22:41 | Miyazaki, Japan | ||
617119 | 617119 | 2021-02-08 | US | Washington | Garfield | 53023 | 111 | 4 | 0 | 107 | 46.43197502 | -117.5454032 | 2021-02-09 05:23:30 | Garfield, Washington, US |
615753 | 615753 | 2021-02-08 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-09 05:23:30 | Garden, Nebraska, US |
613887 | 613887 | 2021-02-08 | Russia | Jewish Autonomous Okrug | 4235 | 109 | 4019 | 107 | 48.57527615 | 132.66307460000002 | 2021-02-09 05:23:30 | Jewish Autonomous Okrug, Russia | ||
1675888 | 1675888 | 2021-02-07 | US | Washington | Garfield | 53023 | 111 | 4 | 0 | 107 | 46.43197502 | -117.5454032 | 2021-02-08 05:22:39 | Garfield, Washington, US |
1674522 | 1674522 | 2021-02-07 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-08 05:22:39 | Garden, Nebraska, US |
978349 | 978349 | 2021-02-06 | US | Washington | Garfield | 53023 | 111 | 4 | 0 | 107 | 46.43197502 | -117.5454032 | 2021-02-07 05:23:00 | Garfield, Washington, US |
976983 | 976983 | 2021-02-06 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-07 05:23:00 | Garden, Nebraska, US |
1591607 | 1591607 | 2021-02-05 | US | Washington | Garfield | 53023 | 111 | 4 | 0 | 107 | 46.43197502 | -117.5454032 | 2021-02-06 05:23:55 | Garfield, Washington, US |
1590241 | 1590241 | 2021-02-05 | US | Nebraska | Garden | 31069 | 108 | 1 | 0 | 107 | 41.61703149 | -102.3313973 | 2021-02-06 05:23:55 | Garden, Nebraska, US |
793809 | 793809 | 2021-02-04 | US | Washington | Columbia | 53013 | 111 | 4 | 0 | 107 | 46.29442881 | -117.9051983 | 2021-02-05 05:22:38 | Columbia, Washington, US |
343701 | 343701 | 2021-02-03 | US | Washington | Columbia | 53013 | 111 | 4 | 0 | 107 | 46.29442881 | -117.9051983 | 2021-02-04 05:22:26 | Columbia, Washington, US |
1685369 | 1685369 | 2021-02-02 | US | Georgia | Taliaferro | 13265 | 107 | 0 | 0 | 107 | 33.56543317 | -82.88136816 | 2021-02-03 05:22:52 | Taliaferro, Georgia, US |
1677339 | 1677339 | 2021-02-01 | US | Georgia | Taliaferro | 13265 | 107 | 0 | 0 | 107 | 33.56543317 | -82.88136816 | 2021-02-02 05:22:49 | Taliaferro, Georgia, US |
2211681 | 2211681 | 2021-01-30 | Japan | Ishikawa | 1455 | 58 | 1290 | 107 | 36.769464 | 136.771027 | 2021-01-31 05:22:42 | Ishikawa, Japan | ||
2569667 | 2569667 | 2021-01-25 | US | Montana | Meagher | 30059 | 114 | 7 | 0 | 107 | 46.59907074 | -110.8898557 | 2021-01-26 05:22:02 | Meagher, Montana, US |
1761299 | 1761299 | 2021-01-24 | US | Montana | Meagher | 30059 | 114 | 7 | 0 | 107 | 46.59907074 | -110.8898557 | 2021-01-25 05:22:16 | Meagher, Montana, US |
2428906 | 2428906 | 2021-01-23 | US | Montana | Meagher | 30059 | 114 | 7 | 0 | 107 | 46.59907074 | -110.8898557 | 2021-01-24 05:22:35 | Meagher, Montana, US |
2427129 | 2427129 | 2021-01-23 | Russia | Nenets Autonomous Okrug | 865 | 0 | 758 | 107 | 68.27557185 | 57.1686375 | 2021-01-24 05:22:35 | Nenets Autonomous Okrug, Russia | ||
2426946 | 2426946 | 2021-01-23 | Japan | Toyama | 843 | 27 | 709 | 107 | 36.637464 | 137.26934599999998 | 2021-01-24 05:22:35 | Toyama, Japan | ||
2468808 | 2468808 | 2021-01-22 | US | Montana | Meagher | 30059 | 114 | 7 | 0 | 107 | 46.59907074 | -110.8898557 | 2021-01-23 05:22:03 | Meagher, Montana, US |
2467402 | 2467402 | 2021-01-22 | US | Colorado | Cheyenne | 8017 | 117 | 6 | 0 | 107 | 38.82777431 | -102.6032558 | 2021-01-23 05:22:03 | Cheyenne, Colorado, US |
2466923 | 2466923 | 2021-01-22 | Netherlands | Curacao | 4543 | 20 | 4416 | 107 | 12.1696 | -68.99 | 2021-01-23 05:22:03 | Curacao, Netherlands | ||
438567 | 438567 | 2021-01-21 | US | Texas | Sherman | 48421 | 226 | 11 | 0 | 107 | 36.27751473 | -101.8933156 | 2021-01-22 05:22:10 | Sherman, Texas, US |
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]);