johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,550 rows where active = 102 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468214 | 3468214 | 2021-08-03 | Japan | Shimane | 759 | 2 | 655 | 102 | 35.07076 | 132.55406399999998 | 2021-08-04 04:21:25 | Shimane, Japan | ||
1333873 | 1333873 | 2021-07-24 | Ukraine | Ivano-Frankivsk Oblast | 86814 | 2107 | 84605 | 102 | 48.9226 | 24.7111 | 2021-07-25 04:22:12 | Ivano-Frankivsk Oblast, Ukraine | ||
1330274 | 1330274 | 2021-07-24 | Japan | Nara | 8598 | 133 | 8363 | 102 | 34.317451 | 135.871644 | 2021-07-25 04:22:12 | Nara, Japan | ||
3476421 | 3476421 | 2021-07-22 | Monaco | 2744 | 33 | 2609 | 102 | 43.7333 | 7.4167 | 2021-07-23 04:21:29 | Monaco | |||
2371780 | 2371780 | 2021-07-20 | Saint Lucia | 5484 | 87 | 5295 | 102 | 13.9094 | -60.9789 | 2021-07-21 04:21:40 | Saint Lucia | |||
3705973 | 3705973 | 2021-07-17 | Colombia | Guaviare | 4900 | 86 | 4712 | 102 | 1.0654 | -73.2603 | 2021-07-18 04:22:07 | Guaviare, Colombia | ||
3705910 | 3705910 | 2021-07-17 | Chile | Aysen | 8016 | 68 | 7846 | 102 | -45.9864 | -73.7669 | 2021-07-18 04:22:07 | Aysen, Chile | ||
3632076 | 3632076 | 2021-07-14 | Netherlands | Curacao | 12453 | 126 | 12225 | 102 | 12.1696 | -68.99 | 2021-07-15 04:21:48 | Curacao, Netherlands | ||
3632011 | 3632011 | 2021-07-14 | Kosovo | 107879 | 2268 | 105509 | 102 | 42.602636 | 20.902977 | 2021-07-15 04:21:48 | Kosovo | |||
578746 | 578746 | 2021-07-13 | Germany | Mecklenburg-Vorpommern | 44187 | 1163 | 42940 | 102 | 53.6127 | 12.4296 | 2021-07-14 04:21:35 | Mecklenburg-Vorpommern, Germany | ||
3744737 | 3744737 | 2021-07-12 | United Kingdom | Isle of Man | 1709 | 29 | 1578 | 102 | 54.2361 | -4.5481 | 2021-07-13 04:21:18 | Isle of Man, United Kingdom | ||
3659604 | 3659604 | 2021-07-11 | Japan | Hiroshima | 11575 | 176 | 11297 | 102 | 34.605309000000005 | 132.788719 | 2021-07-12 04:21:34 | Hiroshima, Japan | ||
833238 | 833238 | 2021-07-09 | Ukraine | Ternopil Oblast | 70083 | 1203 | 68778 | 102 | 49.5535 | 25.5948 | 2021-07-10 04:21:25 | Ternopil Oblast, Ukraine | ||
2693825 | 2693825 | 2021-07-06 | Niger | 5519 | 194 | 5223 | 102 | 17.607789 | 8.081666 | 2021-07-07 04:21:20 | Niger | |||
1165305 | 1165305 | 2021-07-04 | Niger | 5506 | 194 | 5210 | 102 | 17.607789 | 8.081666 | 2021-07-05 04:21:28 | Niger | |||
2071936 | 2071936 | 2021-07-02 | Japan | Kochi | 1841 | 26 | 1713 | 102 | 33.422519 | 133.367307 | 2021-07-03 04:21:37 | Kochi, Japan | ||
1896767 | 1896767 | 2021-06-30 | Ukraine | Ivano-Frankivsk Oblast | 86659 | 2098 | 84459 | 102 | 48.9226 | 24.7111 | 2021-07-01 04:21:19 | Ivano-Frankivsk Oblast, Ukraine | ||
1893174 | 1893174 | 2021-06-30 | Japan | Port Quarantine | 3138 | 5 | 3032 | 102 | 2021-07-01 04:21:19 | Port Quarantine, Japan | ||||
2590021 | 2590021 | 2021-06-27 | Japan | Kochi | 1797 | 24 | 1671 | 102 | 33.422519 | 133.367307 | 2021-06-28 04:21:29 | Kochi, Japan | ||
2884570 | 2884570 | 2021-06-20 | Russia | Jewish Autonomous Okrug | 4600 | 146 | 4352 | 102 | 48.57527615 | 132.66307460000002 | 2021-06-21 04:21:41 | Jewish Autonomous Okrug, Russia | ||
2884401 | 2884401 | 2021-06-20 | Japan | Port Quarantine | 3069 | 4 | 2963 | 102 | 2021-06-21 04:21:41 | Port Quarantine, Japan | ||||
2884304 | 2884304 | 2021-06-20 | India | Andaman and Nicobar Islands | 7406 | 127 | 7177 | 102 | 11.225999 | 92.968178 | 2021-06-21 04:21:41 | Andaman and Nicobar Islands, India | ||
107477 | 107477 | 2021-06-19 | Japan | Nagasaki | 3106 | 69 | 2935 | 102 | 33.235712 | 129.608033 | 2021-06-20 04:21:48 | Nagasaki, Japan | ||
1125617 | 1125617 | 2021-06-18 | Japan | Miyagi | 9061 | 86 | 8873 | 102 | 38.446859 | 140.927086 | 2021-06-19 04:22:33 | Miyagi, Japan | ||
1564347 | 1564347 | 2021-06-14 | Russia | Tyva Republic | 16045 | 203 | 15740 | 102 | 51.4017149 | 93.8582593 | 2021-06-15 04:22:22 | Tyva Republic, Russia | ||
3970693 | 3970693 | 2021-06-11 | Pakistan | Gilgit-Baltistan | 5698 | 108 | 5488 | 102 | 35.792146 | 74.982138 | 2021-06-12 04:22:22 | Gilgit-Baltistan, Pakistan | ||
2716740 | 2716740 | 2021-06-10 | Canada | New Brunswick | 2283 | 44 | 2137 | 102 | 46.5653 | -66.4619 | 2021-06-11 04:23:20 | New Brunswick, Canada | ||
1708114 | 1708114 | 2021-06-02 | China | Guangdong | 2498 | 8 | 2388 | 102 | 23.3417 | 113.4244 | 2021-06-03 04:23:32 | Guangdong, China | ||
1806782 | 1806782 | 2021-05-27 | Japan | Shimane | 526 | 0 | 424 | 102 | 35.07076 | 132.55406399999998 | 2021-05-28 04:20:36 | Shimane, Japan | ||
1806749 | 1806749 | 2021-05-27 | Japan | Ehime | 2695 | 72 | 2521 | 102 | 33.624835 | 132.856842 | 2021-05-28 04:20:36 | Ehime, Japan | ||
1310311 | 1310311 | 2021-05-26 | Pakistan | Gilgit-Baltistan | 5533 | 107 | 5324 | 102 | 35.792146 | 74.982138 | 2021-05-27 04:20:59 | Gilgit-Baltistan, Pakistan | ||
1771485 | 1771485 | 2021-05-23 | Pakistan | Gilgit-Baltistan | 5500 | 107 | 5291 | 102 | 35.792146 | 74.982138 | 2021-05-24 04:20:53 | Gilgit-Baltistan, Pakistan | ||
1952546 | 1952546 | 2021-05-21 | Japan | Port Quarantine | 2902 | 3 | 2797 | 102 | 2021-05-22 04:20:45 | Port Quarantine, Japan | ||||
2943014 | 2943014 | 2021-05-16 | Malaysia | W.P. Putrajaya | 1541 | 10 | 1429 | 102 | 2.9264 | 101.6964 | 2021-05-17 04:20:34 | W.P. Putrajaya, Malaysia | ||
3958180 | 3958180 | 2021-05-11 | Malaysia | W.P. Putrajaya | 1478 | 9 | 1367 | 102 | 2.9264 | 101.6964 | 2021-05-12 04:21:29 | W.P. Putrajaya, Malaysia | ||
1552044 | 1552044 | 2021-05-08 | Mauritius | 1246 | 17 | 1121 | 102 | -20.348404 | 57.552152 | 2021-05-09 04:20:35 | Mauritius | |||
2760938 | 2760938 | 2021-05-03 | Japan | Kochi | 1077 | 20 | 955 | 102 | 33.422519 | 133.367307 | 2021-05-04 04:20:34 | Kochi, Japan | ||
383808 | 383808 | 2021-04-30 | Uganda | 41866 | 342 | 41422 | 102 | 1.373333 | 32.290275 | 2021-05-01 04:20:47 | Uganda | |||
888386 | 888386 | 2021-04-26 | Saint Lucia | 4502 | 73 | 4327 | 102 | 13.9094 | -60.9789 | 2021-04-27 04:20:52 | Saint Lucia | |||
3242593 | 3242593 | 2021-04-21 | Saint Lucia | 4444 | 70 | 4272 | 102 | 13.9094 | -60.9789 | 2021-04-22 04:20:53 | Saint Lucia | |||
3242051 | 3242051 | 2021-04-21 | Bhutan | 986 | 1 | 883 | 102 | 27.5142 | 90.4336 | 2021-04-22 04:20:53 | Bhutan | |||
3129654 | 3129654 | 2021-04-18 | New Zealand | 2596 | 28 | 2468 | 102 | -40.9006 | 174.886 | 2021-04-19 04:20:57 | New Zealand | |||
3129526 | 3129526 | 2021-04-18 | Japan | Fukui | 729 | 31 | 596 | 102 | 35.846614 | 136.22465400000002 | 2021-04-19 04:20:57 | Fukui, Japan | ||
983082 | 983082 | 2021-04-17 | New Zealand | 2595 | 28 | 2467 | 102 | -40.9006 | 174.886 | 2021-04-18 04:20:41 | New Zealand | |||
170086 | 170086 | 2021-04-16 | Japan | Tottori | 330 | 2 | 226 | 102 | 35.359069 | 133.863619 | 2021-04-17 04:20:40 | Tottori, Japan | ||
2552563 | 2552563 | 2021-04-15 | Malaysia | W.P. Putrajaya | 1261 | 9 | 1150 | 102 | 2.9264 | 101.6964 | 2021-04-16 04:20:46 | W.P. Putrajaya, Malaysia | ||
1841803 | 1841803 | 2021-04-14 | Colombia | San Andres y Providencia | 2986 | 47 | 2837 | 102 | 12.5567 | -81.7185 | 2021-04-15 04:20:54 | San Andres y Providencia, Colombia | ||
36563 | 36563 | 2021-04-12 | New Zealand | 2587 | 28 | 2459 | 102 | -40.9006 | 174.886 | 2021-04-13 04:20:37 | New Zealand | |||
3883698 | 3883698 | 2021-04-11 | Monaco | 2375 | 31 | 2242 | 102 | 43.7333 | 7.4167 | 2021-04-12 04:21:00 | Monaco | |||
3883447 | 3883447 | 2021-04-11 | Colombia | San Andres y Providencia | 2955 | 47 | 2806 | 102 | 12.5567 | -81.7185 | 2021-04-12 04:21:00 | San Andres y Providencia, Colombia | ||
3085008 | 3085008 | 2021-04-05 | Barbados | 3679 | 43 | 3534 | 102 | 13.1939 | -59.5432 | 2021-04-06 04:20:32 | Barbados | |||
388181 | 388181 | 2021-04-04 | India | Meghalaya | 14122 | 150 | 13870 | 102 | 25.536934 | 91.278882 | 2021-04-05 04:20:35 | Meghalaya, India | ||
1305665 | 1305665 | 2021-04-01 | Uganda | 40889 | 335 | 40452 | 102 | 1.373333 | 32.290275 | 2021-04-02 04:20:36 | Uganda | |||
2781030 | 2781030 | 2021-03-24 | Japan | Shiga | 2713 | 52 | 2559 | 102 | 35.21582700000001 | 136.138064 | 2021-03-25 05:27:00 | Shiga, Japan | ||
3369354 | 3369354 | 2021-03-21 | Japan | Nagano | 2532 | 41 | 2389 | 102 | 36.132134 | 138.045528 | 2021-03-22 05:25:43 | Nagano, Japan | ||
1736173 | 1736173 | 2021-03-14 | Malaysia | Pahang | 3948 | 16 | 3830 | 102 | 3.8126 | 103.3256 | 2021-03-15 05:25:51 | Pahang, Malaysia | ||
1580487 | 1580487 | 2021-03-13 | Trinidad and Tobago | 7769 | 140 | 7527 | 102 | 10.6918 | -61.2225 | 2021-03-14 05:25:37 | Trinidad and Tobago | |||
352572 | 352572 | 2021-03-11 | Singapore | 60070 | 29 | 59939 | 102 | 1.2833 | 103.8333 | 2021-03-12 05:26:50 | Singapore | |||
352358 | 352358 | 2021-03-11 | Liechtenstein | 2677 | 56 | 2519 | 102 | 47.14 | 9.55 | 2021-03-12 05:26:50 | Liechtenstein | |||
3670838 | 3670838 | 2021-03-06 | US | Texas | Sterling | 48431 | 98 | 4 | 0 | 102 | 31.82781912 | -101.0500746 | 2021-03-07 05:21:54 | Sterling, Texas, US |
1619459 | 1619459 | 2021-03-05 | US | Texas | Sterling | 48431 | 98 | 4 | 0 | 102 | 31.82781912 | -101.0500746 | 2021-03-06 04:23:41 | Sterling, Texas, US |
2210870 | 2210870 | 2021-03-04 | US | Texas | Sterling | 48431 | 98 | 4 | 0 | 102 | 31.82781912 | -101.0500746 | 2021-03-05 05:26:29 | Sterling, Texas, US |
1093291 | 1093291 | 2021-03-03 | US | Texas | Sterling | 48431 | 98 | 4 | 0 | 102 | 31.82781912 | -101.0500746 | 2021-03-04 05:24:24 | Sterling, Texas, US |
1000855 | 1000855 | 2021-03-01 | US | North Dakota | Sheridan | 38083 | 102 | 2 | 0 | 102 | 47.57700669 | -100.3426391 | 2021-03-02 05:23:30 | Sheridan, North Dakota, US |
2369913 | 2369913 | 2021-02-28 | US | North Dakota | Sheridan | 38083 | 102 | 2 | 0 | 102 | 47.57700669 | -100.3426391 | 2021-03-01 05:23:01 | Sheridan, North Dakota, US |
3068415 | 3068415 | 2021-02-27 | US | North Dakota | Sheridan | 38083 | 102 | 2 | 0 | 102 | 47.57700669 | -100.3426391 | 2021-02-28 05:22:20 | Sheridan, North Dakota, US |
1858035 | 1858035 | 2021-02-25 | Japan | Okayama | 2474 | 32 | 2340 | 102 | 34.89246 | 133.826252 | 2021-02-26 05:22:40 | Okayama, Japan | ||
1858028 | 1858028 | 2021-02-25 | Japan | Miyagi | 3585 | 25 | 3458 | 102 | 38.446859 | 140.927086 | 2021-02-26 05:22:40 | Miyagi, Japan | ||
283459 | 283459 | 2021-02-24 | US | Vermont | Grand Isle | 50013 | 102 | 0 | 0 | 102 | 44.7975824 | -73.29679772 | 2021-02-25 05:24:57 | Grand Isle, Vermont, US |
280213 | 280213 | 2021-02-24 | Japan | Okayama | 2474 | 32 | 2340 | 102 | 34.89246 | 133.826252 | 2021-02-25 05:24:57 | Okayama, Japan | ||
1938462 | 1938462 | 2021-02-23 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-24 05:29:16 | Powder River, Montana, US |
532717 | 532717 | 2021-02-22 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-23 05:23:41 | Powder River, Montana, US |
530729 | 530729 | 2021-02-22 | Japan | Miyagi | 3563 | 24 | 3437 | 102 | 38.446859 | 140.927086 | 2021-02-23 05:23:41 | Miyagi, Japan | ||
184051 | 184051 | 2021-02-21 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-22 05:24:21 | Powder River, Montana, US |
182048 | 182048 | 2021-02-21 | Japan | Gifu | 4565 | 103 | 4360 | 102 | 35.778671 | 137.055925 | 2021-02-22 05:24:21 | Gifu, Japan | ||
744325 | 744325 | 2021-02-20 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-21 05:24:33 | Powder River, Montana, US |
742361 | 742361 | 2021-02-20 | Japan | Yamaguchi | 1367 | 35 | 1230 | 102 | 34.201190000000004 | 131.573293 | 2021-02-21 05:24:33 | Yamaguchi, Japan | ||
473423 | 473423 | 2021-02-19 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-20 05:22:51 | Powder River, Montana, US |
1155132 | 1155132 | 2021-02-18 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-19 05:24:16 | Powder River, Montana, US |
3604705 | 3604705 | 2021-02-17 | Yemen | 2151 | 618 | 1431 | 102 | 15.552727 | 48.516388 | 2021-02-18 05:22:58 | Yemen | |||
3603052 | 3603052 | 2021-02-17 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-18 05:22:58 | Powder River, Montana, US |
2677853 | 2677853 | 2021-02-13 | Japan | Nara | 3181 | 43 | 3036 | 102 | 34.317451 | 135.871644 | 2021-02-14 05:23:43 | Nara, Japan | ||
2639733 | 2639733 | 2021-02-11 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-12 05:23:29 | Powder River, Montana, US |
2637782 | 2637782 | 2021-02-11 | Liberia | 1956 | 84 | 1770 | 102 | 6.4280550000000005 | -9.429499 | 2021-02-12 05:23:29 | Liberia | |||
3980588 | 3980588 | 2021-02-10 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-11 05:23:55 | Powder River, Montana, US |
3978637 | 3978637 | 2021-02-10 | Liberia | 1956 | 84 | 1770 | 102 | 6.4280550000000005 | -9.429499 | 2021-02-11 05:23:55 | Liberia | |||
1529908 | 1529908 | 2021-02-09 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-10 05:22:41 | Powder River, Montana, US |
1527957 | 1527957 | 2021-02-09 | Liberia | 1956 | 84 | 1770 | 102 | 6.4280550000000005 | -9.429499 | 2021-02-10 05:22:41 | Liberia | |||
615699 | 615699 | 2021-02-08 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-09 05:23:30 | Powder River, Montana, US |
613748 | 613748 | 2021-02-08 | Liberia | 1956 | 84 | 1770 | 102 | 6.4280550000000005 | -9.429499 | 2021-02-09 05:23:30 | Liberia | |||
1674468 | 1674468 | 2021-02-07 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-08 05:22:39 | Powder River, Montana, US |
1672517 | 1672517 | 2021-02-07 | Liberia | 1956 | 84 | 1770 | 102 | 6.4280550000000005 | -9.429499 | 2021-02-08 05:22:39 | Liberia | |||
976929 | 976929 | 2021-02-06 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-07 05:23:00 | Powder River, Montana, US |
974876 | 974876 | 2021-02-06 | India | Meghalaya | 13845 | 147 | 13596 | 102 | 25.536934 | 91.278882 | 2021-02-07 05:23:00 | Meghalaya, India | ||
1590187 | 1590187 | 2021-02-05 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-06 05:23:55 | Powder River, Montana, US |
793830 | 793830 | 2021-02-04 | US | Washington | San Juan | 53055 | 102 | 0 | 0 | 102 | 48.60182783 | -122.96745 | 2021-02-05 05:22:38 | San Juan, Washington, US |
792394 | 792394 | 2021-02-04 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-05 05:22:38 | Powder River, Montana, US |
342286 | 342286 | 2021-02-03 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-04 05:22:26 | Powder River, Montana, US |
1687131 | 1687131 | 2021-02-02 | US | Oregon | Wallowa | 41063 | 105 | 3 | 0 | 102 | 45.57894064 | -117.18353799999998 | 2021-02-03 05:22:52 | Wallowa, Oregon, US |
1686512 | 1686512 | 2021-02-02 | US | Montana | Powder River | 30075 | 108 | 6 | 0 | 102 | 45.39617714 | -105.636738 | 2021-02-03 05:22:52 | Powder River, Montana, 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]);