johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,124 rows where active = 135 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 981
- Japan 27
- Colombia 11
- France 8
- Russia 8
- India 6
- Italy 5
- Bhutan 4
- Canada 4
- Malaysia 4
- Niger 4
- Ukraine 4
- Belize 3
- Chile 3
- Mexico 3
- Monaco 3
- Rwanda 3
- Saint Lucia 3
- Uruguay 3
- Burkina Faso 2
- Germany 2
- Mongolia 2
- Senegal 2
- Spain 2
- Sri Lanka 2
- Taiwan* 2
- Thailand 2
- United Kingdom 2
- Andorra 1
- Australia 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3687077 | 3687077 | 2021-08-02 | Ukraine | Ivano-Frankivsk Oblast | 86889 | 2108 | 84646 | 135 | 48.9226 | 24.7111 | 2021-08-03 04:21:39 | Ivano-Frankivsk Oblast, Ukraine | ||
3683561 | 3683561 | 2021-08-02 | Monaco | 2897 | 33 | 2729 | 135 | 43.7333 | 7.4167 | 2021-08-03 04:21:39 | Monaco | |||
3683475 | 3683475 | 2021-08-02 | Japan | Miyazaki | 3260 | 27 | 3098 | 135 | 32.193203999999994 | 131.299374 | 2021-08-03 04:21:39 | Miyazaki, Japan | ||
3907605 | 3907605 | 2021-07-31 | Ukraine | Kirovohrad Oblast | 20744 | 860 | 19749 | 135 | 48.5079 | 32.2623 | 2021-08-01 04:21:50 | Kirovohrad Oblast, Ukraine | ||
3295902 | 3295902 | 2021-07-30 | Bhutan | 2508 | 2 | 2371 | 135 | 27.5142 | 90.4336 | 2021-07-31 04:21:35 | Bhutan | |||
3385499 | 3385499 | 2021-07-29 | Monaco | 2853 | 33 | 2685 | 135 | 43.7333 | 7.4167 | 2021-07-30 04:21:34 | Monaco | |||
1378552 | 1378552 | 2021-07-25 | Japan | Wakayama | 2804 | 49 | 2620 | 135 | 33.911879 | 135.505446 | 2021-07-26 04:21:28 | Wakayama, Japan | ||
3331572 | 3331572 | 2021-07-21 | Japan | Tottori | 615 | 2 | 478 | 135 | 35.359069 | 133.863619 | 2021-07-22 04:21:19 | Tottori, Japan | ||
3741350 | 3741350 | 2021-07-12 | Saint Lucia | 5416 | 86 | 5195 | 135 | 13.9094 | -60.9789 | 2021-07-13 04:21:18 | Saint Lucia | |||
3741349 | 3741349 | 2021-07-12 | Saint Kitts and Nevis | 538 | 3 | 400 | 135 | 17.357822 | -62.782998 | 2021-07-13 04:21:18 | Saint Kitts and Nevis | |||
3659823 | 3659823 | 2021-07-11 | Russia | Nenets Autonomous Okrug | 1326 | 10 | 1181 | 135 | 68.27557185 | 57.1686375 | 2021-07-12 04:21:34 | Nenets Autonomous Okrug, Russia | ||
778314 | 778314 | 2021-07-08 | India | Ladakh | 20155 | 205 | 19815 | 135 | 34.1526 | 77.5771 | 2021-07-09 04:21:21 | Ladakh, India | ||
1936075 | 1936075 | 2021-07-05 | Ukraine | Rivne Oblast | 79521 | 1205 | 78181 | 135 | 50.6199 | 26.2516 | 2021-07-06 04:21:32 | Rivne Oblast, Ukraine | ||
1495612 | 1495612 | 2021-07-03 | Japan | Hiroshima | 11518 | 175 | 11208 | 135 | 34.605309000000005 | 132.788719 | 2021-07-04 04:21:38 | Hiroshima, Japan | ||
107645 | 107645 | 2021-06-19 | Russia | Chechen Republic | 12503 | 145 | 12223 | 135 | 43.39761470000001 | 45.6985005 | 2021-06-20 04:21:48 | Chechen Republic, Russia | ||
107498 | 107498 | 2021-06-19 | Japan | Yamaguchi | 3101 | 71 | 2895 | 135 | 34.201190000000004 | 131.573293 | 2021-06-20 04:21:48 | Yamaguchi, Japan | ||
2911457 | 2911457 | 2021-06-17 | South Sudan | 10764 | 115 | 10514 | 135 | 6.877000000000002 | 31.307 | 2021-06-18 04:22:16 | South Sudan | |||
522859 | 522859 | 2021-06-09 | Japan | Aomori | 2440 | 30 | 2275 | 135 | 40.781541 | 140.828896 | 2021-06-10 04:23:17 | Aomori, Japan | ||
522579 | 522579 | 2021-06-09 | Belize | 12916 | 325 | 12456 | 135 | 17.1899 | -88.4976 | 2021-06-10 04:23:17 | Belize | |||
3472019 | 3472019 | 2021-06-08 | Belize | 12909 | 325 | 12449 | 135 | 17.1899 | -88.4976 | 2021-06-09 04:23:31 | Belize | |||
1708356 | 1708356 | 2021-06-02 | Japan | Wakayama | 2629 | 45 | 2449 | 135 | 33.911879 | 135.505446 | 2021-06-03 04:23:32 | Wakayama, Japan | ||
2104265 | 2104265 | 2021-06-01 | Niger | 5410 | 192 | 5083 | 135 | 17.607789 | 8.081666 | 2021-06-02 04:24:34 | Niger | |||
2104163 | 2104163 | 2021-06-01 | Japan | Saga | 2510 | 19 | 2356 | 135 | 33.286977 | 130.115738 | 2021-06-02 04:24:34 | Saga, Japan | ||
1188881 | 1188881 | 2021-05-31 | Niger | 5410 | 192 | 5083 | 135 | 17.607789 | 8.081666 | 2021-06-01 04:23:09 | Niger | |||
3089558 | 3089558 | 2021-05-30 | Niger | 5410 | 192 | 5083 | 135 | 17.607789 | 8.081666 | 2021-05-31 03:08:59 | Niger | |||
50927 | 50927 | 2021-05-29 | Niger | 5410 | 192 | 5083 | 135 | 17.607789 | 8.081666 | 2021-05-30 04:20:55 | Niger | |||
1310217 | 1310217 | 2021-05-26 | Japan | Yamanashi | 1506 | 19 | 1352 | 135 | 35.612364 | 138.61148899999998 | 2021-05-27 04:20:59 | Yamanashi, Japan | ||
1309937 | 1309937 | 2021-05-26 | Canada | New Brunswick | 2163 | 43 | 1985 | 135 | 46.5653 | -66.4619 | 2021-05-27 04:20:59 | New Brunswick, Canada | ||
82863 | 82863 | 2021-05-25 | Canada | New Brunswick | 2153 | 43 | 1975 | 135 | 46.5653 | -66.4619 | 2021-05-26 04:20:35 | New Brunswick, Canada | ||
1412825 | 1412825 | 2021-05-24 | Canada | New Brunswick | 2144 | 43 | 1966 | 135 | 46.5653 | -66.4619 | 2021-05-25 04:21:08 | New Brunswick, Canada | ||
726538 | 726538 | 2021-05-22 | Japan | Tokushima | 1613 | 60 | 1418 | 135 | 33.919178 | 134.242091 | 2021-05-23 04:20:51 | Tokushima, Japan | ||
726502 | 726502 | 2021-05-22 | Japan | Ehime | 2665 | 71 | 2459 | 135 | 33.624835 | 132.856842 | 2021-05-23 04:20:51 | Ehime, Japan | ||
1913403 | 1913403 | 2021-05-20 | Russia | Chechen Republic | 12187 | 131 | 11921 | 135 | 43.39761470000001 | 45.6985005 | 2021-05-21 04:20:43 | Chechen Republic, Russia | ||
2255457 | 2255457 | 2021-05-19 | Bhutan | 1322 | 1 | 1186 | 135 | 27.5142 | 90.4336 | 2021-05-20 04:21:05 | Bhutan | |||
2390619 | 2390619 | 2021-05-18 | Colombia | Guaviare | 2631 | 40 | 2456 | 135 | 1.0654 | -73.2603 | 2021-05-19 04:20:42 | Guaviare, Colombia | ||
2004385 | 2004385 | 2021-05-12 | Bhutan | 1257 | 1 | 1121 | 135 | 27.5142 | 90.4336 | 2021-05-13 04:20:51 | Bhutan | |||
1425369 | 1425369 | 2021-05-09 | Saint Lucia | 4654 | 75 | 4444 | 135 | 13.9094 | -60.9789 | 2021-05-10 04:20:38 | Saint Lucia | |||
3675376 | 3675376 | 2021-05-04 | Bhutan | 1135 | 1 | 999 | 135 | 27.5142 | 90.4336 | 2021-05-05 04:20:43 | Bhutan | |||
2410870 | 2410870 | 2021-04-19 | Japan | Nagasaki | 1779 | 40 | 1604 | 135 | 33.235712 | 129.608033 | 2021-04-20 04:20:41 | Nagasaki, Japan | ||
2410714 | 2410714 | 2021-04-19 | Cote d'Ivoire | 45570 | 274 | 45161 | 135 | 7.54 | -5.5471 | 2021-04-20 04:20:41 | Cote d'Ivoire | |||
169902 | 169902 | 2021-04-16 | Colombia | San Andres y Providencia | 3048 | 49 | 2864 | 135 | 12.5567 | -81.7185 | 2021-04-17 04:20:40 | San Andres y Providencia, Colombia | ||
3003345 | 3003345 | 2021-04-06 | Japan | Tokushima | 605 | 19 | 451 | 135 | 33.919178 | 134.242091 | 2021-04-07 04:20:53 | Tokushima, Japan | ||
3085316 | 3085316 | 2021-04-05 | Japan | Kagawa | 914 | 19 | 760 | 135 | 34.217292 | 133.969047 | 2021-04-06 04:20:32 | Kagawa, Japan | ||
3085260 | 3085260 | 2021-04-05 | India | Nagaland | 12365 | 92 | 12138 | 135 | 26.06702 | 94.470302 | 2021-04-06 04:20:32 | Nagaland, India | ||
1301750 | 1301750 | 2021-04-01 | Australia | Queensland | 1485 | 6 | 1344 | 135 | -27.4698 | 153.0251 | 2021-04-02 04:20:36 | Queensland, Australia | ||
1289959 | 1289959 | 2021-03-29 | India | Ladakh | 10007 | 130 | 9742 | 135 | 34.1526 | 77.5771 | 2021-03-30 04:26:23 | Ladakh, India | ||
1980641 | 1980641 | 2021-03-25 | Japan | Nagano | 2614 | 41 | 2438 | 135 | 36.132134 | 138.045528 | 2021-03-26 05:26:55 | Nagano, Japan | ||
1204077 | 1204077 | 2021-03-22 | Sao Tome and Principe | 2157 | 34 | 1988 | 135 | 0.1864 | 6.6131 | 2021-03-23 05:26:18 | Sao Tome and Principe | |||
1203916 | 1203916 | 2021-03-22 | Monaco | 2182 | 27 | 2020 | 135 | 43.7333 | 7.4167 | 2021-03-23 05:26:18 | Monaco | |||
1744722 | 1744722 | 2021-03-20 | Russia | Altai Republic | 16533 | 187 | 16211 | 135 | 50.7114101 | 86.8572186 | 2021-03-21 05:25:44 | Altai Republic, Russia | ||
352335 | 352335 | 2021-03-11 | Japan | Tochigi | 4224 | 68 | 4021 | 135 | 36.689912 | 139.819213 | 2021-03-12 05:26:50 | Tochigi, Japan | ||
3253869 | 3253869 | 2021-03-02 | Belize | 12320 | 315 | 11870 | 135 | 17.1899 | -88.4976 | 2021-03-03 05:23:28 | Belize | |||
2183417 | 2183417 | 2021-02-26 | Colombia | Arauca | 5568 | 168 | 5265 | 135 | 7.0762 | -70.7105 | 2021-02-27 05:22:28 | Arauca, Colombia | ||
283053 | 283053 | 2021-02-24 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-25 05:24:57 | Hyde, South Dakota, US |
1940115 | 1940115 | 2021-02-23 | Yemen | 2187 | 620 | 1432 | 135 | 15.552727 | 48.516388 | 2021-02-24 05:29:16 | Yemen | |||
1939321 | 1939321 | 2021-02-23 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-24 05:29:16 | Hyde, South Dakota, US |
533576 | 533576 | 2021-02-22 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-23 05:23:41 | Hyde, South Dakota, US |
184910 | 184910 | 2021-02-21 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-22 05:24:21 | Hyde, South Dakota, US |
745184 | 745184 | 2021-02-20 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-21 05:24:33 | Hyde, South Dakota, US |
742099 | 742099 | 2021-02-20 | Chile | Aysen | 2956 | 23 | 2798 | 135 | -45.9864 | -73.7669 | 2021-02-21 05:24:33 | Aysen, Chile | ||
474282 | 474282 | 2021-02-19 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-20 05:22:51 | Hyde, South Dakota, US |
473053 | 473053 | 2021-02-19 | US | Michigan | Keweenaw | 26083 | 137 | 2 | 0 | 135 | 47.63197653 | -88.41434263 | 2021-02-20 05:22:51 | Keweenaw, Michigan, US |
1156767 | 1156767 | 2021-02-18 | United Kingdom | Channel Islands | 0 | 0 | 3796 | 135 | 49.3723 | -2.3644 | 2021-02-19 05:24:16 | Channel Islands, United Kingdom | ||
1155991 | 1155991 | 2021-02-18 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-19 05:24:16 | Hyde, South Dakota, US |
1155751 | 1155751 | 2021-02-18 | US | Oregon | Wallowa | 41063 | 139 | 4 | 0 | 135 | 45.57894064 | -117.18353799999998 | 2021-02-19 05:24:16 | Wallowa, Oregon, US |
3603911 | 3603911 | 2021-02-17 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-18 05:22:58 | Hyde, South Dakota, US |
3603671 | 3603671 | 2021-02-17 | US | Oregon | Wallowa | 41063 | 139 | 4 | 0 | 135 | 45.57894064 | -117.18353799999998 | 2021-02-18 05:22:58 | Wallowa, Oregon, US |
3053046 | 3053046 | 2021-02-16 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-17 05:23:10 | Hyde, South Dakota, US |
1341145 | 1341145 | 2021-02-15 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-16 05:24:38 | Hyde, South Dakota, US |
1341006 | 1341006 | 2021-02-15 | US | Puerto Rico | Guanica | 72055 | 135 | 0 | 0 | 135 | 17.982429 | -66.91964300000001 | 2021-02-16 05:24:38 | Guanica, Puerto Rico, US |
1338299 | 1338299 | 2021-02-15 | Japan | Miyazaki | 1931 | 21 | 1775 | 135 | 32.193203999999994 | 131.299374 | 2021-02-16 05:24:38 | Miyazaki, Japan | ||
2286296 | 2286296 | 2021-02-14 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-15 05:24:49 | Hyde, South Dakota, US |
2286157 | 2286157 | 2021-02-14 | US | Puerto Rico | Guanica | 72055 | 135 | 0 | 0 | 135 | 17.982429 | -66.91964300000001 | 2021-02-15 05:24:49 | Guanica, Puerto Rico, US |
2680696 | 2680696 | 2021-02-13 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-14 05:23:43 | Hyde, South Dakota, US |
3542329 | 3542329 | 2021-02-12 | US | South Dakota | Hyde | 46069 | 136 | 1 | 0 | 135 | 44.54747703 | -99.48572582 | 2021-02-13 05:22:12 | Hyde, South Dakota, US |
1530960 | 1530960 | 2021-02-09 | US | Texas | Dickens | 48125 | 184 | 8 | 0 | 135 | 33.61616822 | -100.7788855 | 2021-02-10 05:22:41 | Dickens, Texas, US |
1527926 | 1527926 | 2021-02-09 | Japan | Oita | 1237 | 18 | 1084 | 135 | 33.200697 | 131.43323999999998 | 2021-02-10 05:22:41 | Oita, Japan | ||
616962 | 616962 | 2021-02-08 | US | Vermont | Essex | 50009 | 135 | 0 | 0 | 135 | 44.72736416 | -71.73579864 | 2021-02-09 05:23:30 | Essex, Vermont, US |
1591298 | 1591298 | 2021-02-05 | US | Texas | Jeff Davis | 48243 | 125 | 2 | 0 | 135 | 30.71490589 | -104.1399973 | 2021-02-06 05:23:55 | Jeff Davis, Texas, US |
1591182 | 1591182 | 2021-02-05 | US | Texas | Armstrong | 48011 | 212 | 6 | 0 | 135 | 34.96507426 | -101.3574874 | 2021-02-06 05:23:55 | Armstrong, Texas, US |
793505 | 793505 | 2021-02-04 | US | Texas | Jeff Davis | 48243 | 124 | 1 | 0 | 135 | 30.71490589 | -104.1399973 | 2021-02-05 05:22:38 | Jeff Davis, Texas, US |
793389 | 793389 | 2021-02-04 | US | Texas | Armstrong | 48011 | 212 | 6 | 0 | 135 | 34.96507426 | -101.3574874 | 2021-02-05 05:22:38 | Armstrong, Texas, US |
1899126 | 1899126 | 2021-01-29 | US | Missouri | Worth | 29227 | 136 | 1 | 0 | 135 | 40.47945588 | -94.42328751 | 2021-01-30 05:22:49 | Worth, Missouri, US |
2483942 | 2483942 | 2021-01-28 | US | Missouri | Worth | 29227 | 136 | 1 | 0 | 135 | 40.47945588 | -94.42328751 | 2021-01-29 05:22:23 | Worth, Missouri, US |
3155577 | 3155577 | 2021-01-27 | US | Missouri | Worth | 29227 | 136 | 1 | 0 | 135 | 40.47945588 | -94.42328751 | 2021-01-28 05:22:24 | Worth, Missouri, US |
14312 | 14312 | 2021-01-26 | US | Missouri | Worth | 29227 | 136 | 1 | 0 | 135 | 40.47945588 | -94.42328751 | 2021-01-27 05:23:41 | Worth, Missouri, US |
2569636 | 2569636 | 2021-01-25 | US | Missouri | Worth | 29227 | 136 | 1 | 0 | 135 | 40.47945588 | -94.42328751 | 2021-01-26 05:22:02 | Worth, Missouri, US |
1761362 | 1761362 | 2021-01-24 | US | Nebraska | Garfield | 31071 | 138 | 3 | 0 | 135 | 41.91428955 | -98.99111827 | 2021-01-25 05:22:16 | Garfield, Nebraska, US |
2428969 | 2428969 | 2021-01-23 | US | Nebraska | Garfield | 31071 | 138 | 3 | 0 | 135 | 41.91428955 | -98.99111827 | 2021-01-24 05:22:35 | Garfield, Nebraska, US |
2468871 | 2468871 | 2021-01-22 | US | Nebraska | Garfield | 31071 | 138 | 3 | 0 | 135 | 41.91428955 | -98.99111827 | 2021-01-23 05:22:03 | Garfield, Nebraska, US |
437422 | 437422 | 2021-01-21 | US | Nebraska | Garfield | 31071 | 138 | 3 | 0 | 135 | 41.91428955 | -98.99111827 | 2021-01-22 05:22:10 | Garfield, Nebraska, US |
435314 | 435314 | 2021-01-21 | India | Meghalaya | 13721 | 146 | 13440 | 135 | 25.536934 | 91.278882 | 2021-01-22 05:22:10 | Meghalaya, India | ||
3503969 | 3503969 | 2021-01-17 | US | Colorado | Gilpin | 8047 | 158 | 3 | 0 | 135 | 39.85646523 | -105.5252597 | 2021-01-18 05:22:34 | Gilpin, Colorado, US |
3102052 | 3102052 | 2021-01-16 | US | Colorado | Gilpin | 8047 | 156 | 3 | 0 | 135 | 39.85646523 | -105.5252597 | 2021-01-17 05:22:17 | Gilpin, Colorado, US |
3516014 | 3516014 | 2021-01-15 | US | Colorado | Gilpin | 8047 | 154 | 3 | 0 | 135 | 39.85646523 | -105.5252597 | 2021-01-16 05:22:40 | Gilpin, Colorado, US |
3881768 | 3881768 | 2021-01-14 | US | New Mexico | Mora | 35033 | 140 | 5 | 0 | 135 | 36.01095101 | -104.9497716 | 2021-01-15 05:22:24 | Mora, New Mexico, US |
189970 | 189970 | 2021-01-11 | France | St Martin | 1002 | 12 | 855 | 135 | 18.0708 | -63.0501 | 2021-01-12 05:22:15 | St Martin, France | ||
2627223 | 2627223 | 2021-01-10 | US | Kansas | Woodson | 20207 | 137 | 2 | 0 | 135 | 37.8865336 | -95.74006277 | 2021-01-11 05:21:50 | Woodson, Kansas, US |
2625773 | 2625773 | 2021-01-10 | France | St Martin | 1002 | 12 | 855 | 135 | 18.0708 | -63.0501 | 2021-01-11 05:21:50 | St Martin, France | ||
3901311 | 3901311 | 2021-01-09 | US | Kansas | Woodson | 20207 | 137 | 2 | 0 | 135 | 37.8865336 | -95.74006277 | 2021-01-10 05:22:12 | Woodson, Kansas, 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]);