johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,561 rows where active = 98 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331943 | 331943 | 2021-08-04 | Japan | Shimane | 763 | 2 | 663 | 98 | 35.07076 | 132.55406399999998 | 2021-08-05 04:21:51 | Shimane, Japan | ||
3904007 | 3904007 | 2021-07-31 | Japan | Saga | 2747 | 24 | 2625 | 98 | 33.286977 | 130.115738 | 2021-08-01 04:21:50 | Saga, Japan | ||
3296202 | 3296202 | 2021-07-30 | Japan | Miyazaki | 3214 | 27 | 3089 | 98 | 32.193203999999994 | 131.299374 | 2021-07-31 04:21:35 | Miyazaki, Japan | ||
408364 | 408364 | 2021-07-28 | Mali | 14563 | 531 | 13934 | 98 | 17.570692 | -3.996166000000001 | 2021-07-29 04:21:33 | Mali | |||
1306424 | 1306424 | 2021-07-27 | Saint Lucia | 5529 | 88 | 5343 | 98 | 13.9094 | -60.9789 | 2021-07-28 04:21:39 | Saint Lucia | |||
3218567 | 3218567 | 2021-07-26 | Saint Lucia | 5529 | 88 | 5343 | 98 | 13.9094 | -60.9789 | 2021-07-27 04:21:18 | Saint Lucia | |||
1378533 | 1378533 | 2021-07-25 | Japan | Nagasaki | 3332 | 69 | 3165 | 98 | 33.235712 | 129.608033 | 2021-07-26 04:21:28 | Nagasaki, Japan | ||
1333891 | 1333891 | 2021-07-24 | Ukraine | Zakarpattia Oblast | 62204 | 1608 | 60498 | 98 | 48.6208 | 22.2879 | 2021-07-25 04:22:12 | Zakarpattia Oblast, Ukraine | ||
3476338 | 3476338 | 2021-07-22 | Japan | Nara | 8571 | 133 | 8340 | 98 | 34.317451 | 135.871644 | 2021-07-23 04:21:29 | Nara, Japan | ||
3331640 | 3331640 | 2021-07-21 | Monaco | 2728 | 33 | 2597 | 98 | 43.7333 | 7.4167 | 2021-07-22 04:21:19 | Monaco | |||
3331545 | 3331545 | 2021-07-21 | Japan | Iwate | 1874 | 47 | 1729 | 98 | 39.593287 | 141.361777 | 2021-07-22 04:21:19 | Iwate, Japan | ||
299634 | 299634 | 2021-07-15 | Ukraine | Chernivtsi Oblast | 80029 | 1794 | 78137 | 98 | 48.2917 | 25.9352 | 2021-07-16 04:21:22 | Chernivtsi Oblast, Ukraine | ||
3740859 | 3740859 | 2021-07-12 | Canada | Yukon | 480 | 6 | 376 | 98 | 64.2823 | -135.0 | 2021-07-13 04:21:18 | Yukon, Canada | ||
3659622 | 3659622 | 2021-07-11 | Japan | Niigata | 3488 | 53 | 3337 | 98 | 37.521819 | 138.918647 | 2021-07-12 04:21:34 | Niigata, Japan | ||
625893 | 625893 | 2021-07-10 | Japan | Iwate | 1774 | 47 | 1629 | 98 | 39.593287 | 141.361777 | 2021-07-11 04:21:43 | Iwate, Japan | ||
625892 | 625892 | 2021-07-10 | Japan | Ishikawa | 4023 | 115 | 3810 | 98 | 36.769464 | 136.771027 | 2021-07-11 04:21:43 | Ishikawa, Japan | ||
829612 | 829612 | 2021-07-09 | Japan | Iwate | 1766 | 47 | 1621 | 98 | 39.593287 | 141.361777 | 2021-07-10 04:21:25 | Iwate, Japan | ||
778590 | 778590 | 2021-07-08 | Russia | Nenets Autonomous Okrug | 1280 | 10 | 1172 | 98 | 68.27557185 | 57.1686375 | 2021-07-09 04:21:21 | Nenets Autonomous Okrug, Russia | ||
1165079 | 1165079 | 2021-07-04 | Germany | Bremen | 27458 | 487 | 26890 | 98 | 53.0793 | 8.8017 | 2021-07-05 04:21:28 | Bremen, Germany | ||
2589990 | 2589990 | 2021-06-27 | Italy | Molise | 13717 | 491 | 13128 | 98 | 41.55774754 | 14.65916051 | 2021-06-28 04:21:29 | Molise, Italy | ||
3358806 | 3358806 | 2021-06-21 | Niger | 5469 | 193 | 5178 | 98 | 17.607789 | 8.081666 | 2021-06-22 04:21:34 | Niger | |||
2884505 | 2884505 | 2021-06-20 | Niger | 5469 | 193 | 5178 | 98 | 17.607789 | 8.081666 | 2021-06-21 04:21:41 | Niger | |||
107588 | 107588 | 2021-06-19 | Niger | 5469 | 193 | 5178 | 98 | 17.607789 | 8.081666 | 2021-06-20 04:21:48 | Niger | |||
107470 | 107470 | 2021-06-19 | Japan | Kochi | 1715 | 23 | 1594 | 98 | 33.422519 | 133.367307 | 2021-06-20 04:21:48 | Kochi, Japan | ||
3030511 | 3030511 | 2021-06-16 | Russia | Magadan Oblast | 8541 | 113 | 8330 | 98 | 62.48858785 | 153.9903764 | 2021-06-17 04:22:36 | Magadan Oblast, Russia | ||
3381596 | 3381596 | 2021-06-13 | Russia | Magadan Oblast | 8527 | 112 | 8317 | 98 | 62.48858785 | 153.9903764 | 2021-06-14 04:22:46 | Magadan Oblast, Russia | ||
3381143 | 3381143 | 2021-06-13 | Canada | New Brunswick | 2298 | 45 | 2155 | 98 | 46.5653 | -66.4619 | 2021-06-14 04:22:46 | New Brunswick, Canada | ||
3970318 | 3970318 | 2021-06-11 | Canada | New Brunswick | 2284 | 44 | 2142 | 98 | 46.5653 | -66.4619 | 2021-06-12 04:22:22 | New Brunswick, Canada | ||
2717115 | 2717115 | 2021-06-10 | Pakistan | Gilgit-Baltistan | 5682 | 108 | 5476 | 98 | 35.792146 | 74.982138 | 2021-06-11 04:23:20 | Gilgit-Baltistan, Pakistan | ||
3472232 | 3472232 | 2021-06-08 | Iceland | 6604 | 30 | 6476 | 98 | 64.9631 | -19.0208 | 2021-06-09 04:23:31 | Iceland | |||
3145516 | 3145516 | 2021-06-07 | Iceland | 6604 | 30 | 6476 | 98 | 64.9631 | -19.0208 | 2021-06-08 04:22:35 | Iceland | |||
825804 | 825804 | 2021-06-06 | Russia | Magadan Oblast | 8493 | 111 | 8284 | 98 | 62.48858785 | 153.9903764 | 2021-06-07 04:22:51 | Magadan Oblast, Russia | ||
825518 | 825518 | 2021-06-06 | Iceland | 6604 | 30 | 6476 | 98 | 64.9631 | -19.0208 | 2021-06-07 04:22:51 | Iceland | |||
1448435 | 1448435 | 2021-06-03 | Colombia | Guaviare | 3199 | 53 | 3048 | 98 | 1.0654 | -73.2603 | 2021-06-04 04:23:37 | Guaviare, Colombia | ||
1448277 | 1448277 | 2021-06-03 | Andorra | 13752 | 127 | 13527 | 98 | 42.5063 | 1.5218 | 2021-06-04 04:23:37 | Andorra | |||
2821100 | 2821100 | 2021-05-10 | Taiwan* | 1199 | 12 | 1089 | 98 | 23.7 | 121.0 | 2021-05-11 04:20:41 | Taiwan* | |||
2821025 | 2821025 | 2021-05-10 | Russia | Tyva Republic | 15855 | 202 | 15555 | 98 | 51.4017149 | 93.8582593 | 2021-05-11 04:20:41 | Tyva Republic, Russia | ||
1551990 | 1551990 | 2021-05-08 | Japan | Kochi | 1117 | 20 | 999 | 98 | 33.422519 | 133.367307 | 2021-05-09 04:20:35 | Kochi, Japan | ||
3675374 | 3675374 | 2021-05-04 | Belize | 12675 | 323 | 12254 | 98 | 17.1899 | -88.4976 | 2021-05-05 04:20:43 | Belize | |||
170310 | 170310 | 2021-04-16 | Saint Lucia | 4398 | 65 | 4235 | 98 | 13.9094 | -60.9789 | 2021-04-17 04:20:40 | Saint Lucia | |||
1841899 | 1841899 | 2021-04-14 | India | Lakshadweep | 845 | 1 | 746 | 98 | 13.6999972 | 72.18333259999999 | 2021-04-15 04:20:54 | Lakshadweep, India | ||
36472 | 36472 | 2021-04-12 | Japan | Tottori | 307 | 2 | 207 | 98 | 35.359069 | 133.863619 | 2021-04-13 04:20:37 | Tottori, Japan | ||
36365 | 36365 | 2021-04-12 | Iceland | 6267 | 29 | 6140 | 98 | 64.9631 | -19.0208 | 2021-04-13 04:20:37 | Iceland | |||
605523 | 605523 | 2021-04-09 | Colombia | Arauca | 5823 | 175 | 5550 | 98 | 7.0762 | -70.7105 | 2021-04-10 04:20:59 | Arauca, Colombia | ||
2645973 | 2645973 | 2021-04-08 | Russia | Magadan Oblast | 8271 | 99 | 8074 | 98 | 62.48858785 | 153.9903764 | 2021-04-09 04:21:13 | Magadan Oblast, Russia | ||
2247615 | 2247615 | 2021-04-07 | Russia | Magadan Oblast | 8268 | 99 | 8071 | 98 | 62.48858785 | 153.9903764 | 2021-04-08 04:21:13 | Magadan Oblast, Russia | ||
3709994 | 3709994 | 2021-04-03 | Colombia | Putumayo | 8221 | 325 | 7798 | 98 | 0.436 | -75.5277 | 2021-04-04 04:20:49 | Putumayo, Colombia | ||
1301907 | 1301907 | 2021-04-01 | Colombia | Putumayo | 8209 | 324 | 7787 | 98 | 0.436 | -75.5277 | 2021-04-02 04:20:36 | Putumayo, Colombia | ||
637960 | 637960 | 2021-03-31 | Japan | Shiga | 2770 | 55 | 2617 | 98 | 35.21582700000001 | 136.138064 | 2021-04-01 04:27:05 | Shiga, Japan | ||
1289850 | 1289850 | 2021-03-29 | Colombia | Choco | 6681 | 204 | 6379 | 98 | 5.2528 | -76.82600000000002 | 2021-03-30 04:26:23 | Choco, Colombia | ||
1880684 | 1880684 | 2021-03-26 | Australia | Queensland | 1443 | 6 | 1339 | 98 | -27.4698 | 153.0251 | 2021-03-27 05:25:04 | Queensland, Australia | ||
2781027 | 2781027 | 2021-03-24 | Japan | Port Quarantine | 2353 | 2 | 2253 | 98 | 2021-03-25 05:27:00 | Port Quarantine, Japan | ||||
1798672 | 1798672 | 2021-03-23 | Japan | Port Quarantine | 2347 | 2 | 2247 | 98 | 2021-03-24 05:25:40 | Port Quarantine, Japan | ||||
1203832 | 1203832 | 2021-03-22 | Japan | Nagano | 2542 | 41 | 2403 | 98 | 36.132134 | 138.045528 | 2021-03-23 05:26:18 | Nagano, Japan | ||
1837765 | 1837765 | 2021-03-12 | Colombia | Arauca | 5638 | 172 | 5368 | 98 | 7.0762 | -70.7105 | 2021-03-13 05:25:15 | Arauca, Colombia | ||
55140 | 55140 | 2021-03-07 | Trinidad and Tobago | 7736 | 139 | 7499 | 98 | 10.6918 | -61.2225 | 2021-03-08 05:24:48 | Trinidad and Tobago | |||
1619698 | 1619698 | 2021-03-05 | US | Washington | Wahkiakum | 53069 | 98 | 0 | 0 | 98 | 46.29180039999999 | -123.4250831 | 2021-03-06 04:23:41 | Wahkiakum, Washington, US |
3065953 | 3065953 | 2021-02-27 | India | Lakshadweep | 359 | 1 | 260 | 98 | 13.6999972 | 72.18333259999999 | 2021-02-28 05:22:20 | Lakshadweep, India | ||
282288 | 282288 | 2021-02-24 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-25 05:24:57 | Rock, Nebraska, US |
1938556 | 1938556 | 2021-02-23 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-24 05:29:16 | Rock, Nebraska, US |
532811 | 532811 | 2021-02-22 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-23 05:23:41 | Rock, Nebraska, US |
530736 | 530736 | 2021-02-22 | Japan | Okayama | 2470 | 32 | 2340 | 98 | 34.89246 | 133.826252 | 2021-02-23 05:23:41 | Okayama, Japan | ||
184145 | 184145 | 2021-02-21 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-22 05:24:21 | Rock, Nebraska, US |
744419 | 744419 | 2021-02-20 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-21 05:24:33 | Rock, Nebraska, US |
473517 | 473517 | 2021-02-19 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-20 05:22:51 | Rock, Nebraska, US |
1155226 | 1155226 | 2021-02-18 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-19 05:24:16 | Rock, Nebraska, US |
3603146 | 3603146 | 2021-02-17 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-18 05:22:58 | Rock, Nebraska, US |
3053263 | 3053263 | 2021-02-16 | US | Texas | Glasscock | 48173 | 91 | 2 | 0 | 98 | 31.86942909 | -101.5207776 | 2021-02-17 05:23:10 | Glasscock, Texas, US |
3052281 | 3052281 | 2021-02-16 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-17 05:23:10 | Rock, Nebraska, US |
1341939 | 1341939 | 2021-02-15 | Yemen | 2145 | 617 | 1430 | 98 | 15.552727 | 48.516388 | 2021-02-16 05:24:38 | Yemen | |||
1341491 | 1341491 | 2021-02-15 | US | Texas | Sterling | 48431 | 94 | 4 | 0 | 98 | 31.82781912 | -101.0500746 | 2021-02-16 05:24:38 | Sterling, Texas, US |
1341362 | 1341362 | 2021-02-15 | US | Texas | Glasscock | 48173 | 91 | 2 | 0 | 98 | 31.86942909 | -101.5207776 | 2021-02-16 05:24:38 | Glasscock, Texas, US |
1340380 | 1340380 | 2021-02-15 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-16 05:24:38 | Rock, Nebraska, US |
2287090 | 2287090 | 2021-02-14 | Yemen | 2145 | 617 | 1430 | 98 | 15.552727 | 48.516388 | 2021-02-15 05:24:49 | Yemen | |||
2286642 | 2286642 | 2021-02-14 | US | Texas | Sterling | 48431 | 94 | 4 | 0 | 98 | 31.82781912 | -101.0500746 | 2021-02-15 05:24:49 | Sterling, Texas, US |
2286513 | 2286513 | 2021-02-14 | US | Texas | Glasscock | 48173 | 91 | 2 | 0 | 98 | 31.86942909 | -101.5207776 | 2021-02-15 05:24:49 | Glasscock, Texas, US |
2681042 | 2681042 | 2021-02-13 | US | Texas | Sterling | 48431 | 94 | 4 | 0 | 98 | 31.82781912 | -101.0500746 | 2021-02-14 05:23:43 | Sterling, Texas, US |
2680913 | 2680913 | 2021-02-13 | US | Texas | Glasscock | 48173 | 91 | 2 | 0 | 98 | 31.86942909 | -101.5207776 | 2021-02-14 05:23:43 | Glasscock, Texas, US |
3542675 | 3542675 | 2021-02-12 | US | Texas | Sterling | 48431 | 94 | 4 | 0 | 98 | 31.82781912 | -101.0500746 | 2021-02-13 05:22:12 | Sterling, Texas, US |
3541564 | 3541564 | 2021-02-12 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-13 05:22:12 | Rock, Nebraska, US |
2639827 | 2639827 | 2021-02-11 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-12 05:23:29 | Rock, Nebraska, US |
2637921 | 2637921 | 2021-02-11 | Russia | Jewish Autonomous Okrug | 4255 | 110 | 4047 | 98 | 48.57527615 | 132.66307460000002 | 2021-02-12 05:23:29 | Jewish Autonomous Okrug, Russia | ||
2637784 | 2637784 | 2021-02-11 | Liechtenstein | 2609 | 54 | 2457 | 98 | 47.14 | 9.55 | 2021-02-12 05:23:29 | Liechtenstein | |||
3980682 | 3980682 | 2021-02-10 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-11 05:23:55 | Rock, Nebraska, US |
1530984 | 1530984 | 2021-02-09 | US | Texas | Glasscock | 48173 | 91 | 2 | 0 | 98 | 31.86942909 | -101.5207776 | 2021-02-10 05:22:41 | Glasscock, Texas, US |
1530002 | 1530002 | 2021-02-09 | US | Nebraska | Rock | 31149 | 100 | 2 | 0 | 98 | 42.42252217 | -99.44832069 | 2021-02-10 05:22:41 | Rock, Nebraska, US |
1527959 | 1527959 | 2021-02-09 | Liechtenstein | 2603 | 54 | 2451 | 98 | 47.14 | 9.55 | 2021-02-10 05:22:41 | Liechtenstein | |||
616775 | 616775 | 2021-02-08 | US | Texas | Glasscock | 48173 | 91 | 2 | 0 | 98 | 31.86942909 | -101.5207776 | 2021-02-09 05:23:30 | Glasscock, Texas, US |
1675544 | 1675544 | 2021-02-07 | US | Texas | Glasscock | 48173 | 91 | 2 | 0 | 98 | 31.86942909 | -101.5207776 | 2021-02-08 05:22:39 | Glasscock, Texas, US |
978005 | 978005 | 2021-02-06 | US | Texas | Glasscock | 48173 | 91 | 2 | 0 | 98 | 31.86942909 | -101.5207776 | 2021-02-07 05:23:00 | Glasscock, Texas, US |
793599 | 793599 | 2021-02-04 | US | Texas | Sterling | 48431 | 94 | 4 | 0 | 98 | 31.82781912 | -101.0500746 | 2021-02-05 05:22:38 | Sterling, Texas, US |
793470 | 793470 | 2021-02-04 | US | Texas | Glasscock | 48173 | 91 | 2 | 0 | 98 | 31.86942909 | -101.5207776 | 2021-02-05 05:22:38 | Glasscock, Texas, US |
343491 | 343491 | 2021-02-03 | US | Texas | Sterling | 48431 | 94 | 4 | 0 | 98 | 31.82781912 | -101.0500746 | 2021-02-04 05:22:26 | Sterling, Texas, US |
340279 | 340279 | 2021-02-03 | Japan | Ehime | 997 | 21 | 878 | 98 | 33.624835 | 132.856842 | 2021-02-04 05:22:26 | Ehime, Japan | ||
1687717 | 1687717 | 2021-02-02 | US | Texas | Sterling | 48431 | 94 | 4 | 0 | 98 | 31.82781912 | -101.0500746 | 2021-02-03 05:22:52 | Sterling, Texas, US |
1684333 | 1684333 | 2021-02-02 | Colombia | Amazonas | 3811 | 141 | 3572 | 98 | -1.4429 | -71.5724 | 2021-02-03 05:22:52 | Amazonas, Colombia | ||
1679897 | 1679897 | 2021-02-01 | US | Washington | Columbia | 53013 | 102 | 4 | 0 | 98 | 46.29442881 | -117.9051983 | 2021-02-02 05:22:49 | Columbia, Washington, US |
1679687 | 1679687 | 2021-02-01 | US | Texas | Sterling | 48431 | 94 | 4 | 0 | 98 | 31.82781912 | -101.0500746 | 2021-02-02 05:22:49 | Sterling, Texas, US |
1462975 | 1462975 | 2021-01-31 | US | Texas | Sterling | 48431 | 94 | 4 | 0 | 98 | 31.82781912 | -101.0500746 | 2021-02-01 05:22:53 | Sterling, Texas, US |
2214883 | 2214883 | 2021-01-30 | US | Texas | Sterling | 48431 | 94 | 4 | 0 | 98 | 31.82781912 | -101.0500746 | 2021-01-31 05:22:42 | Sterling, 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]);