johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
941 rows where active = 179 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 838
- Japan 17
- India 9
- France 8
- Chile 6
- Mexico 5
- Ukraine 5
- Colombia 4
- Germany 3
- Italy 3
- Malaysia 3
- Netherlands 3
- Burkina Faso 2
- Canada 2
- Cuba 2
- Latvia 2
- Russia 2
- Singapore 2
- Trinidad and Tobago 2
- Andorra 1
- Angola 1
- Australia 1
- Chad 1
- China 1
- Cyprus 1
- Djibouti 1
- Eritrea 1
- Georgia 1
- Jordan 1
- Kyrgyzstan 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378290 | 1378290 | 2021-07-25 | Chile | Arica y Parinacota | 26240 | 500 | 25561 | 179 | -18.594 | -69.4785 | 2021-07-26 04:21:28 | Arica y Parinacota, Chile | ||
1329948 | 1329948 | 2021-07-24 | Australia | Victoria | 20903 | 820 | 19904 | 179 | -37.8136 | 144.9631 | 2021-07-25 04:22:12 | Victoria, Australia | ||
3744716 | 3744716 | 2021-07-12 | Ukraine | Mykolaiv Oblast | 70103 | 1853 | 68071 | 179 | 46.975 | 31.9946 | 2021-07-13 04:21:18 | Mykolaiv Oblast, Ukraine | ||
829382 | 829382 | 2021-07-09 | Chile | Aysen | 7885 | 65 | 7641 | 179 | -45.9864 | -73.7669 | 2021-07-10 04:21:25 | Aysen, Chile | ||
778382 | 778382 | 2021-07-08 | Japan | Kyoto | 16727 | 246 | 16302 | 179 | 35.253815 | 135.443341 | 2021-07-09 04:21:21 | Kyoto, Japan | ||
2765156 | 2765156 | 2021-07-01 | Russia | Magadan Oblast | 8712 | 117 | 8416 | 179 | 62.48858785 | 153.9903764 | 2021-07-02 04:21:47 | Magadan Oblast, Russia | ||
2295240 | 2295240 | 2021-06-24 | Chile | Magallanes | 28740 | 438 | 28123 | 179 | -52.368 | -70.9863 | 2021-06-25 04:21:33 | Magallanes, Chile | ||
825585 | 825585 | 2021-06-06 | Japan | Aomori | 2417 | 30 | 2208 | 179 | 40.781541 | 140.828896 | 2021-06-07 04:22:51 | Aomori, Japan | ||
825441 | 825441 | 2021-06-06 | Colombia | San Andres y Providencia | 5880 | 109 | 5592 | 179 | 12.5567 | -81.7185 | 2021-06-07 04:22:51 | San Andres y Providencia, Colombia | ||
50649 | 50649 | 2021-05-29 | Colombia | San Andres y Providencia | 5436 | 91 | 5166 | 179 | 12.5567 | -81.7185 | 2021-05-30 04:20:55 | San Andres y Providencia, Colombia | ||
2255737 | 2255737 | 2021-05-19 | Japan | Ehime | 2643 | 67 | 2397 | 179 | 33.624835 | 132.856842 | 2021-05-20 04:21:05 | Ehime, Japan | ||
3954378 | 3954378 | 2021-05-11 | Eritrea | 3818 | 12 | 3627 | 179 | 15.1794 | 39.7823 | 2021-05-12 04:21:29 | Eritrea | |||
1551811 | 1551811 | 2021-05-08 | Colombia | Caqueta | 17638 | 659 | 16800 | 179 | 0.8699 | -73.8419 | 2021-05-09 04:20:35 | Caqueta, Colombia | ||
3113518 | 3113518 | 2021-05-06 | Japan | Port Quarantine | 2792 | 3 | 2610 | 179 | 2021-05-07 04:20:40 | Port Quarantine, Japan | ||||
2760965 | 2760965 | 2021-05-03 | Japan | Yamagata | 1538 | 33 | 1326 | 179 | 38.448396 | 140.102154 | 2021-05-04 04:20:34 | Yamagata, Japan | ||
954870 | 954870 | 2021-04-25 | Japan | Fukui | 849 | 33 | 637 | 179 | 35.846614 | 136.22465400000002 | 2021-04-26 04:21:04 | Fukui, Japan | ||
982903 | 982903 | 2021-04-17 | India | Lakshadweep | 945 | 1 | 765 | 179 | 13.6999972 | 72.18333259999999 | 2021-04-18 04:20:41 | Lakshadweep, India | ||
169998 | 169998 | 2021-04-16 | India | Lakshadweep | 945 | 1 | 765 | 179 | 13.6999972 | 72.18333259999999 | 2021-04-17 04:20:40 | Lakshadweep, India | ||
2571459 | 2571459 | 2021-04-13 | Chad | 4652 | 167 | 4306 | 179 | 15.4542 | 18.7322 | 2021-04-14 04:20:41 | Chad | |||
3883861 | 3883861 | 2021-04-11 | Senegal | 39431 | 1078 | 38174 | 179 | 14.4974 | -14.4524 | 2021-04-12 04:21:00 | Senegal | |||
605705 | 605705 | 2021-04-09 | Japan | Kagawa | 967 | 19 | 769 | 179 | 34.217292 | 133.969047 | 2021-04-10 04:20:59 | Kagawa, Japan | ||
3003062 | 3003062 | 2021-04-06 | Burkina Faso | 12845 | 150 | 12516 | 179 | 12.2383 | -1.5616 | 2021-04-07 04:20:53 | Burkina Faso | |||
3085345 | 3085345 | 2021-04-05 | Japan | Wakayama | 1364 | 18 | 1167 | 179 | 33.911879 | 135.505446 | 2021-04-06 04:20:32 | Wakayama, Japan | ||
3643829 | 3643829 | 2021-03-30 | Singapore | 60347 | 30 | 60138 | 179 | 1.2833 | 103.8333 | 2021-03-31 04:26:25 | Singapore | |||
3369338 | 3369338 | 2021-03-21 | Japan | Gunma | 4819 | 94 | 4546 | 179 | 36.504479 | 138.985605 | 2021-03-22 05:25:43 | Gunma, Japan | ||
3621035 | 3621035 | 2021-03-17 | India | Lakshadweep | 639 | 1 | 459 | 179 | 13.6999972 | 72.18333259999999 | 2021-03-18 05:26:22 | Lakshadweep, India | ||
2059568 | 2059568 | 2021-03-15 | Malaysia | Terengganu | 3450 | 13 | 3258 | 179 | 5.3117 | 103.1324 | 2021-03-16 05:25:13 | Terengganu, Malaysia | ||
3962482 | 3962482 | 2021-03-10 | India | Puducherry | 39932 | 670 | 39083 | 179 | 11.882658 | 78.86498 | 2021-03-11 05:25:48 | Puducherry, India | ||
3670673 | 3670673 | 2021-03-06 | US | Texas | Cottle | 48101 | 183 | 7 | 0 | 179 | 34.07783319 | -100.2785062 | 2021-03-07 05:21:54 | Cottle, Texas, US |
1619294 | 1619294 | 2021-03-05 | US | Texas | Cottle | 48101 | 183 | 7 | 0 | 179 | 34.07783319 | -100.2785062 | 2021-03-06 04:23:41 | Cottle, Texas, US |
2210705 | 2210705 | 2021-03-04 | US | Texas | Cottle | 48101 | 183 | 7 | 0 | 179 | 34.07783319 | -100.2785062 | 2021-03-05 05:26:29 | Cottle, Texas, US |
1093126 | 1093126 | 2021-03-03 | US | Texas | Cottle | 48101 | 183 | 7 | 0 | 179 | 34.07783319 | -100.2785062 | 2021-03-04 05:24:24 | Cottle, Texas, US |
3257269 | 3257269 | 2021-03-02 | US | Texas | Jeff Davis | 48243 | 169 | 2 | 0 | 179 | 30.71490589 | -104.1399973 | 2021-03-03 05:23:28 | Jeff Davis, Texas, US |
3257198 | 3257198 | 2021-03-02 | US | Texas | Cottle | 48101 | 183 | 7 | 0 | 179 | 34.07783319 | -100.2785062 | 2021-03-03 05:23:28 | Cottle, Texas, US |
998555 | 998555 | 2021-03-01 | Netherlands | Aruba | 7908 | 74 | 7655 | 179 | 12.5211 | -69.9683 | 2021-03-02 05:23:30 | Aruba, Netherlands | ||
281131 | 281131 | 2021-02-24 | US | Idaho | Unassigned | 90016 | 179 | 0 | 0 | 179 | 48.76684761 | -116.78476880000001 | 2021-02-25 05:24:57 | Unassigned, Idaho, US |
1936413 | 1936413 | 2021-02-23 | India | Puducherry | 39628 | 665 | 38784 | 179 | 11.882658 | 78.86498 | 2021-02-24 05:29:16 | Puducherry, India | ||
2283462 | 2283462 | 2021-02-14 | Japan | Shiga | 2316 | 39 | 2098 | 179 | 35.21582700000001 | 136.138064 | 2021-02-15 05:24:49 | Shiga, Japan | ||
3539735 | 3539735 | 2021-02-12 | Singapore | 59777 | 29 | 59569 | 179 | 1.2833 | 103.8333 | 2021-02-13 05:22:12 | Singapore | |||
1528232 | 1528232 | 2021-02-09 | Trinidad and Tobago | 7617 | 136 | 7302 | 179 | 10.6918 | -61.2225 | 2021-02-10 05:22:41 | Trinidad and Tobago | |||
616428 | 616428 | 2021-02-08 | US | Puerto Rico | Jayuya | 72073 | 179 | 0 | 0 | 179 | 18.211446 | -66.58878 | 2021-02-09 05:23:30 | Jayuya, Puerto Rico, US |
1675197 | 1675197 | 2021-02-07 | US | Puerto Rico | Jayuya | 72073 | 179 | 0 | 0 | 179 | 18.211446 | -66.58878 | 2021-02-08 05:22:39 | Jayuya, Puerto Rico, US |
1589078 | 1589078 | 2021-02-05 | US | Hawaii | Kauai | 15007 | 180 | 1 | 0 | 179 | 22.03935037 | -159.5966786 | 2021-02-06 05:23:55 | Kauai, Hawaii, US |
1588173 | 1588173 | 2021-02-05 | Italy | Valle d'Aosta | 7834 | 407 | 7248 | 179 | 45.73750286 | 7.320149366 | 2021-02-06 05:23:55 | Valle d'Aosta, Italy | ||
791285 | 791285 | 2021-02-04 | US | Hawaii | Kauai | 15007 | 180 | 1 | 0 | 179 | 22.03935037 | -159.5966786 | 2021-02-05 05:22:38 | Kauai, Hawaii, US |
791049 | 791049 | 2021-02-04 | US | Delaware | Unassigned | 90010 | 179 | 0 | 0 | 179 | 39.57992638 | 0.0 | 2021-02-05 05:22:38 | Unassigned, Delaware, US |
1460661 | 1460661 | 2021-01-31 | US | Hawaii | Kauai | 15007 | 180 | 1 | 0 | 179 | 22.03935037 | -159.5966786 | 2021-02-01 05:22:53 | Kauai, Hawaii, US |
2212569 | 2212569 | 2021-01-30 | US | Hawaii | Kauai | 15007 | 180 | 1 | 0 | 179 | 22.03935037 | -159.5966786 | 2021-01-31 05:22:42 | Kauai, Hawaii, US |
1898056 | 1898056 | 2021-01-29 | US | Hawaii | Kauai | 15007 | 180 | 1 | 0 | 179 | 22.03935037 | -159.5966786 | 2021-01-30 05:22:49 | Kauai, Hawaii, US |
3156785 | 3156785 | 2021-01-27 | US | Texas | Oldham | 48359 | 238 | 2 | 0 | 179 | 35.40425596 | -102.6027606 | 2021-01-28 05:22:24 | Oldham, Texas, US |
2571331 | 2571331 | 2021-01-25 | US | Alaska | Copper River | 2066 | 179 | 0 | 0 | 179 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
2567693 | 2567693 | 2021-01-25 | Japan | Oita | 1048 | 16 | 853 | 179 | 33.200697 | 131.43323999999998 | 2021-01-26 05:22:02 | Oita, Japan | ||
1762963 | 1762963 | 2021-01-24 | US | Alaska | Copper River | 2066 | 179 | 0 | 0 | 179 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
1760649 | 1760649 | 2021-01-24 | US | Kansas | Woodson | 20207 | 182 | 3 | 0 | 179 | 37.8865336 | -95.74006277 | 2021-01-25 05:22:16 | Woodson, Kansas, US |
2430570 | 2430570 | 2021-01-23 | US | Alaska | Copper River | 2066 | 179 | 0 | 0 | 179 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
2428256 | 2428256 | 2021-01-23 | US | Kansas | Woodson | 20207 | 182 | 3 | 0 | 179 | 37.8865336 | -95.74006277 | 2021-01-24 05:22:35 | Woodson, Kansas, US |
2470472 | 2470472 | 2021-01-22 | US | Alaska | Copper River | 2066 | 179 | 0 | 0 | 179 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
2468358 | 2468358 | 2021-01-22 | US | Maine | Piscataquis | 23021 | 180 | 1 | 0 | 179 | 45.83839062 | -69.2860223 | 2021-01-23 05:22:03 | Piscataquis, Maine, US |
2468158 | 2468158 | 2021-01-22 | US | Kansas | Woodson | 20207 | 182 | 3 | 0 | 179 | 37.8865336 | -95.74006277 | 2021-01-23 05:22:03 | Woodson, Kansas, US |
2467439 | 2467439 | 2021-01-22 | US | Colorado | Ouray | 8091 | 206 | 3 | 0 | 179 | 38.14717457 | -107.7675136 | 2021-01-23 05:22:03 | Ouray, Colorado, US |
437349 | 437349 | 2021-01-21 | US | Montana | Granite | 30039 | 181 | 2 | 0 | 179 | 46.40605220000001 | -113.4414186 | 2021-01-22 05:22:10 | Granite, Montana, US |
1096080 | 1096080 | 2021-01-20 | US | Montana | Granite | 30039 | 181 | 2 | 0 | 179 | 46.40605220000001 | -113.4414186 | 2021-01-21 05:22:01 | Granite, Montana, US |
909094 | 909094 | 2021-01-19 | US | Idaho | Butte | 16023 | 180 | 1 | 0 | 179 | 43.72592209 | -113.1735463 | 2021-01-20 05:21:54 | Butte, Idaho, US |
240447 | 240447 | 2021-01-18 | US | Texas | Schleicher | 48413 | 132 | 6 | 0 | 179 | 30.89740592 | -100.5384842 | 2021-01-19 05:22:15 | Schleicher, Texas, US |
238157 | 238157 | 2021-01-18 | US | Idaho | Butte | 16023 | 180 | 1 | 0 | 179 | 43.72592209 | -113.1735463 | 2021-01-19 05:22:15 | Butte, Idaho, US |
237142 | 237142 | 2021-01-18 | France | St Martin | 1046 | 12 | 855 | 179 | 18.0708 | -63.0501 | 2021-01-19 05:22:15 | St Martin, France | ||
3504274 | 3504274 | 2021-01-17 | US | Idaho | Butte | 16023 | 180 | 1 | 0 | 179 | 43.72592209 | -113.1735463 | 2021-01-18 05:22:34 | Butte, Idaho, US |
3503259 | 3503259 | 2021-01-17 | France | St Martin | 1046 | 12 | 855 | 179 | 18.0708 | -63.0501 | 2021-01-18 05:22:34 | St Martin, France | ||
3103164 | 3103164 | 2021-01-16 | US | Minnesota | Lake of the Woods | 27077 | 180 | 1 | 0 | 179 | 48.77217001 | -94.90274472 | 2021-01-17 05:22:17 | Lake of the Woods, Minnesota, US |
3102357 | 3102357 | 2021-01-16 | US | Idaho | Butte | 16023 | 180 | 1 | 0 | 179 | 43.72592209 | -113.1735463 | 2021-01-17 05:22:17 | Butte, Idaho, US |
3101342 | 3101342 | 2021-01-16 | France | St Martin | 1046 | 12 | 855 | 179 | 18.0708 | -63.0501 | 2021-01-17 05:22:17 | St Martin, France | ||
3516319 | 3516319 | 2021-01-15 | US | Idaho | Butte | 16023 | 180 | 1 | 0 | 179 | 43.72592209 | -113.1735463 | 2021-01-16 05:22:40 | Butte, Idaho, US |
3515304 | 3515304 | 2021-01-15 | France | St Martin | 1046 | 12 | 855 | 179 | 18.0708 | -63.0501 | 2021-01-16 05:22:40 | St Martin, France | ||
3879477 | 3879477 | 2021-01-14 | France | St Martin | 1046 | 12 | 855 | 179 | 18.0708 | -63.0501 | 2021-01-15 05:22:24 | St Martin, France | ||
3308104 | 3308104 | 2021-01-13 | France | St Martin | 1046 | 12 | 855 | 179 | 18.0708 | -63.0501 | 2021-01-14 05:22:32 | St Martin, France | ||
777037 | 777037 | 2021-01-12 | US | Pennsylvania | Sullivan | 42113 | 182 | 3 | 0 | 179 | 41.44634738 | -76.51246591 | 2021-01-13 05:22:15 | Sullivan, Pennsylvania, US |
774249 | 774249 | 2021-01-12 | France | St Martin | 1046 | 12 | 855 | 179 | 18.0708 | -63.0501 | 2021-01-13 05:22:15 | St Martin, France | ||
156732 | 156732 | 2021-01-08 | US | Puerto Rico | Maunabo | 72095 | 179 | 0 | 0 | 179 | 18.017889 | -65.922235 | 2021-01-09 05:22:18 | Maunabo, Puerto Rico, US |
3037730 | 3037730 | 2021-01-05 | US | Washington | Ferry | 53019 | 181 | 2 | 0 | 179 | 48.471143100000006 | -118.5154041 | 2021-01-06 05:22:16 | Ferry, Washington, US |
3037675 | 3037675 | 2021-01-05 | US | Virginia | Norton | 51720 | 180 | 1 | 0 | 179 | 36.93357076 | -82.62750411 | 2021-01-06 05:22:16 | Norton, Virginia, US |
1064611 | 1064611 | 2021-01-04 | US | Puerto Rico | Sabana Grande | 72121 | 179 | 0 | 0 | 179 | 18.08282 | -66.943758 | 2021-01-05 05:21:49 | Sabana Grande, Puerto Rico, US |
1064208 | 1064208 | 2021-01-04 | US | North Carolina | Tyrrell | 37177 | 182 | 3 | 0 | 179 | 35.87147226 | -76.17055253 | 2021-01-05 05:21:49 | Tyrrell, North Carolina, US |
1063918 | 1063918 | 2021-01-04 | US | Nebraska | Harlan | 31083 | 179 | 0 | 0 | 179 | 40.17658508 | -99.40438879 | 2021-01-05 05:21:49 | Harlan, Nebraska, US |
3232811 | 3232811 | 2021-01-03 | US | North Carolina | Tyrrell | 37177 | 182 | 3 | 0 | 179 | 35.87147226 | -76.17055253 | 2021-01-04 05:22:02 | Tyrrell, North Carolina, US |
3232521 | 3232521 | 2021-01-03 | US | Nebraska | Harlan | 31083 | 179 | 0 | 0 | 179 | 40.17658508 | -99.40438879 | 2021-01-04 05:22:02 | Harlan, Nebraska, US |
3231248 | 3231248 | 2021-01-03 | US | Georgia | Glascock | 13125 | 183 | 4 | 0 | 179 | 33.22879932 | -82.61297636 | 2021-01-04 05:22:02 | Glascock, Georgia, US |
2229590 | 2229590 | 2021-01-02 | US | Nebraska | Harlan | 31083 | 179 | 0 | 0 | 179 | 40.17658508 | -99.40438879 | 2021-01-03 05:22:52 | Harlan, Nebraska, US |
1138954 | 1138954 | 2021-01-01 | US | Nebraska | Harlan | 31083 | 179 | 0 | 0 | 179 | 40.17658508 | -99.40438879 | 2021-01-02 05:22:33 | Harlan, Nebraska, US |
3697560 | 3697560 | 2020-12-31 | US | Nebraska | Harlan | 31083 | 179 | 0 | 0 | 179 | 40.17658508 | -99.40438879 | 2021-01-01 05:23:07 | Harlan, Nebraska, US |
1013184 | 1013184 | 2020-12-30 | US | South Dakota | McPherson | 46089 | 180 | 1 | 0 | 179 | 45.76626028 | -99.22118798 | 2020-12-31 05:22:49 | McPherson, South Dakota, US |
3765031 | 3765031 | 2020-12-28 | US | Washington | Skamania | 53059 | 180 | 1 | 0 | 179 | 46.02408726 | -121.9164403 | 2020-12-29 05:22:37 | Skamania, Washington, US |
2227140 | 2227140 | 2020-12-26 | Ukraine | Sevastopol* | 6343 | 220 | 5944 | 179 | 44.6054 | 33.522 | 2020-12-27 05:22:55 | Sevastopol*, Ukraine | ||
2223545 | 2223545 | 2020-12-26 | Japan | Shiga | 1062 | 11 | 872 | 179 | 35.21582700000001 | 136.138064 | 2020-12-27 05:22:55 | Shiga, Japan | ||
202663 | 202663 | 2020-12-25 | US | Alaska | Aleutians West | 2016 | 179 | 0 | 0 | 179 | 52.3233 | -174.1596 | 2020-12-26 05:22:28 | Aleutians West, Alaska, US |
3691886 | 3691886 | 2020-12-24 | US | Alaska | Aleutians West | 2016 | 179 | 0 | 0 | 179 | 52.3233 | -174.1596 | 2020-12-25 05:22:48 | Aleutians West, Alaska, US |
3691594 | 3691594 | 2020-12-24 | Netherlands | Aruba | 5257 | 47 | 5031 | 179 | 12.5211 | -69.9683 | 2020-12-25 05:22:48 | Aruba, Netherlands | ||
2934353 | 2934353 | 2020-12-19 | US | Texas | Kimble | 48267 | 167 | 6 | 0 | 179 | 30.48678918 | -99.74856473 | 2020-12-20 05:27:32 | Kimble, Texas, US |
2931240 | 2931240 | 2020-12-19 | Japan | Kochi | 478 | 5 | 294 | 179 | 33.422519 | 133.367307 | 2020-12-20 05:27:32 | Kochi, Japan | ||
1904482 | 1904482 | 2020-12-18 | US | Virginia | Cumberland | 51049 | 183 | 4 | 0 | 179 | 37.51328851 | -78.24398086 | 2020-12-19 05:27:52 | Cumberland, Virginia, US |
3152252 | 3152252 | 2020-12-16 | US | Pennsylvania | Forest | 42053 | 181 | 2 | 0 | 179 | 41.51095103 | -79.23229292 | 2020-12-17 05:28:12 | Forest, Pennsylvania, 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]);