daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,030 rows where active = 170 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 910
- Japan 25
- France 9
- Mexico 8
- Malaysia 7
- Zambia 7
- Italy 6
- Russia 5
- China 4
- Colombia 4
- Germany 4
- Burkina Faso 3
- Pakistan 3
- Ukraine 3
- Chile 2
- Estonia 2
- Gambia 2
- Mauritania 2
- South Sudan 2
- Uruguay 2
- Albania 1
- Bolivia 1
- Cuba 1
- Djibouti 1
- El Salvador 1
- Eswatini 1
- Ethiopia 1
- Iceland 1
- Jamaica 1
- Kenya 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-28 | Japan | Nara | 8735 | 133 | 8432 | 170 | 34.317451 | 135.871644 | 2021-07-29 04:21:33 | Nara, Japan | ||
2021-07-22 | Japan | Fukushima | 5242 | 162 | 4910 | 170 | 37.378867 | 140.223295 | 2021-07-23 04:21:29 | Fukushima, Japan | ||
2021-07-20 | Japan | Fukushima | 5205 | 162 | 4873 | 170 | 37.378867 | 140.223295 | 2021-07-21 04:21:40 | Fukushima, Japan | ||
2021-07-20 | Germany | Bremen | 27639 | 489 | 27000 | 170 | 53.0793 | 8.8017 | 2021-07-21 04:21:40 | Bremen, Germany | ||
2021-07-15 | Russia | Chukotka Autonomous Okrug | 943 | 8 | 765 | 170 | 66.0006475 | 169.4900869 | 2021-07-16 04:21:22 | Chukotka Autonomous Okrug, Russia | ||
2021-07-04 | Japan | Kyoto | 16658 | 246 | 16242 | 170 | 35.253815 | 135.443341 | 2021-07-05 04:21:28 | Kyoto, Japan | ||
2021-07-03 | Japan | Fukui | 1324 | 35 | 1119 | 170 | 35.846614 | 136.22465400000002 | 2021-07-04 04:21:38 | Fukui, Japan | ||
2021-07-02 | Kosovo | 107785 | 2262 | 105353 | 170 | 42.602636 | 20.902977 | 2021-07-03 04:21:37 | Kosovo | |||
2021-06-30 | Russia | Magadan Oblast | 8696 | 117 | 8409 | 170 | 62.48858785 | 153.9903764 | 2021-07-01 04:21:19 | Magadan Oblast, Russia | ||
2021-06-18 | Colombia | Guaviare | 3940 | 63 | 3707 | 170 | 1.0654 | -73.2603 | 2021-06-19 04:22:33 | Guaviare, Colombia | ||
2021-06-12 | Albania | 132449 | 2453 | 129826 | 170 | 41.1533 | 20.1683 | 2021-06-13 04:22:44 | Albania | |||
2021-06-09 | China | Guangdong | 2582 | 8 | 2404 | 170 | 23.3417 | 113.4244 | 2021-06-10 04:23:17 | Guangdong, China | ||
2021-06-08 | Japan | Nagasaki | 3013 | 68 | 2775 | 170 | 33.235712 | 129.608033 | 2021-06-09 04:23:31 | Nagasaki, Japan | ||
2021-06-06 | Japan | Nagasaki | 2994 | 68 | 2756 | 170 | 33.235712 | 129.608033 | 2021-06-07 04:22:51 | Nagasaki, Japan | ||
2021-05-12 | Uganda | 42487 | 346 | 41971 | 170 | 1.373333 | 32.290275 | 2021-05-13 04:20:51 | Uganda | |||
2021-05-11 | Russia | Chechen Republic | 12103 | 128 | 11805 | 170 | 43.39761470000001 | 45.6985005 | 2021-05-12 04:21:29 | Chechen Republic, Russia | ||
2021-04-27 | Liechtenstein | 2992 | 56 | 2766 | 170 | 47.14 | 9.55 | 2021-04-28 04:20:32 | Liechtenstein | |||
2021-04-27 | Burkina Faso | 13263 | 156 | 12937 | 170 | 12.2383 | -1.5616 | 2021-04-28 04:20:32 | Burkina Faso | |||
2021-04-26 | Burkina Faso | 13263 | 156 | 12937 | 170 | 12.2383 | -1.5616 | 2021-04-27 04:20:52 | Burkina Faso | |||
2021-04-25 | Burkina Faso | 13263 | 156 | 12937 | 170 | 12.2383 | -1.5616 | 2021-04-26 04:21:04 | Burkina Faso | |||
2021-04-18 | Japan | Gifu | 5236 | 129 | 4937 | 170 | 35.778671 | 137.055925 | 2021-04-19 04:20:57 | Gifu, Japan | ||
2021-04-17 | South Sudan | 10432 | 114 | 10148 | 170 | 6.877000000000002 | 31.307 | 2021-04-18 04:20:41 | South Sudan | |||
2021-04-16 | South Sudan | 10432 | 114 | 10148 | 170 | 6.877000000000002 | 31.307 | 2021-04-17 04:20:40 | South Sudan | |||
2021-04-13 | Japan | Mie | 3034 | 74 | 2790 | 170 | 34.508018 | 136.376013 | 2021-04-14 04:20:41 | Mie, Japan | ||
2021-04-09 | China | Hong Kong | 11563 | 206 | 11186 | 170 | 22.3 | 114.2 | 2021-04-10 04:20:59 | Hong Kong, China | ||
2021-04-08 | China | Hong Kong | 11549 | 205 | 11174 | 170 | 22.3 | 114.2 | 2021-04-09 04:21:13 | Hong Kong, China | ||
2021-04-05 | Japan | Aomori | 1086 | 20 | 896 | 170 | 40.781541 | 140.828896 | 2021-04-06 04:20:32 | Aomori, Japan | ||
2021-03-25 | Saint Vincent and the Grenadines | 1715 | 10 | 1535 | 170 | 12.9843 | -61.2872 | 2021-03-26 05:26:55 | Saint Vincent and the Grenadines | |||
2021-03-17 | Japan | Tochigi | 4335 | 69 | 4096 | 170 | 36.689912 | 139.819213 | 2021-03-18 05:26:22 | Tochigi, Japan | ||
2021-03-13 | France | St Martin | 1581 | 12 | 1399 | 170 | 18.0708 | -63.0501 | 2021-03-14 05:25:37 | St Martin, France | ||
2021-03-12 | France | St Martin | 1581 | 12 | 1399 | 170 | 18.0708 | -63.0501 | 2021-03-13 05:25:15 | St Martin, France | ||
2021-03-11 | France | St Martin | 1581 | 12 | 1399 | 170 | 18.0708 | -63.0501 | 2021-03-12 05:26:50 | St Martin, France | ||
2021-03-10 | France | St Martin | 1581 | 12 | 1399 | 170 | 18.0708 | -63.0501 | 2021-03-11 05:25:48 | St Martin, France | ||
2021-03-09 | France | St Martin | 1581 | 12 | 1399 | 170 | 18.0708 | -63.0501 | 2021-03-10 05:24:35 | St Martin, France | ||
2021-03-08 | Russia | Murmansk Oblast | 47365 | 985 | 46210 | 170 | 68.00004179999999 | 33.9999151 | 2021-03-09 05:28:19 | Murmansk Oblast, Russia | ||
2021-03-08 | France | St Martin | 1581 | 12 | 1399 | 170 | 18.0708 | -63.0501 | 2021-03-09 05:28:19 | St Martin, France | ||
2021-03-07 | France | St Martin | 1581 | 12 | 1399 | 170 | 18.0708 | -63.0501 | 2021-03-08 05:24:48 | St Martin, France | ||
2021-03-06 | US | Nebraska | Boyd | 31015 | 173 | 3 | 0 | 170 | 42.8997274 | -98.76486568 | 2021-03-07 05:21:54 | Boyd, Nebraska, US |
2021-03-06 | Russia | Magadan Oblast | 8166 | 97 | 7899 | 170 | 62.48858785 | 153.9903764 | 2021-03-07 05:21:54 | Magadan Oblast, Russia | ||
2021-03-06 | France | St Martin | 1581 | 12 | 1399 | 170 | 18.0708 | -63.0501 | 2021-03-07 05:21:54 | St Martin, France | ||
2021-03-05 | US | North Dakota | Steele | 38091 | 173 | 2 | 0 | 170 | 47.45611548 | -97.72728747 | 2021-03-06 04:23:41 | Steele, North Dakota, US |
2021-03-05 | US | Nebraska | Boyd | 31015 | 173 | 3 | 0 | 170 | 42.8997274 | -98.76486568 | 2021-03-06 04:23:41 | Boyd, Nebraska, US |
2021-03-05 | Japan | Miyagi | 3724 | 25 | 3529 | 170 | 38.446859 | 140.927086 | 2021-03-06 04:23:41 | Miyagi, Japan | ||
2021-03-04 | US | North Dakota | Steele | 38091 | 172 | 2 | 0 | 170 | 47.45611548 | -97.72728747 | 2021-03-05 05:26:29 | Steele, North Dakota, US |
2021-03-04 | US | Nebraska | Boyd | 31015 | 173 | 3 | 0 | 170 | 42.8997274 | -98.76486568 | 2021-03-05 05:26:29 | Boyd, Nebraska, US |
2021-03-03 | US | North Dakota | Steele | 38091 | 172 | 2 | 0 | 170 | 47.45611548 | -97.72728747 | 2021-03-04 05:24:24 | Steele, North Dakota, US |
2021-03-02 | US | North Dakota | Steele | 38091 | 172 | 2 | 0 | 170 | 47.45611548 | -97.72728747 | 2021-03-03 05:23:28 | Steele, North Dakota, US |
2021-03-02 | US | Kansas | Elk | 20049 | 175 | 5 | 0 | 170 | 37.45338105 | -96.24369667 | 2021-03-03 05:23:28 | Elk, Kansas, US |
2021-03-01 | US | North Dakota | Steele | 38091 | 172 | 2 | 0 | 170 | 47.45611548 | -97.72728747 | 2021-03-02 05:23:30 | Steele, North Dakota, US |
2021-03-01 | US | Kansas | Elk | 20049 | 175 | 5 | 0 | 170 | 37.45338105 | -96.24369667 | 2021-03-02 05:23:30 | Elk, Kansas, US |
2021-02-28 | US | North Dakota | Steele | 38091 | 172 | 2 | 0 | 170 | 47.45611548 | -97.72728747 | 2021-03-01 05:23:01 | Steele, North Dakota, US |
2021-02-27 | US | North Dakota | Steele | 38091 | 172 | 2 | 0 | 170 | 47.45611548 | -97.72728747 | 2021-02-28 05:22:20 | Steele, North Dakota, US |
2021-02-26 | US | North Dakota | Steele | 38091 | 172 | 2 | 0 | 170 | 47.45611548 | -97.72728747 | 2021-02-27 05:22:28 | Steele, North Dakota, US |
2021-02-25 | US | Oklahoma | Cimarron | 40025 | 171 | 1 | 0 | 170 | 36.74817177 | -102.5173885 | 2021-02-26 05:22:40 | Cimarron, Oklahoma, US |
2021-02-25 | US | North Dakota | Steele | 38091 | 172 | 2 | 0 | 170 | 47.45611548 | -97.72728747 | 2021-02-26 05:22:40 | Steele, North Dakota, US |
2021-02-24 | US | North Dakota | Steele | 38091 | 172 | 2 | 0 | 170 | 47.45611548 | -97.72728747 | 2021-02-25 05:24:57 | Steele, North Dakota, US |
2021-02-22 | US | Texas | Jeff Davis | 48243 | 160 | 2 | 0 | 170 | 30.71490589 | -104.1399973 | 2021-02-23 05:23:41 | Jeff Davis, Texas, US |
2021-02-21 | US | Texas | Jeff Davis | 48243 | 160 | 2 | 0 | 170 | 30.71490589 | -104.1399973 | 2021-02-22 05:24:21 | Jeff Davis, Texas, US |
2021-02-19 | US | Nebraska | Dundy | 31057 | 174 | 4 | 0 | 170 | 40.17638677 | -101.6876522 | 2021-02-20 05:22:51 | Dundy, Nebraska, US |
2021-02-17 | US | Nebraska | Sherman | 31163 | 174 | 4 | 0 | 170 | 41.22045983 | -98.97588642 | 2021-02-18 05:22:58 | Sherman, Nebraska, US |
2021-02-16 | US | Nebraska | Sherman | 31163 | 174 | 4 | 0 | 170 | 41.22045983 | -98.97588642 | 2021-02-17 05:23:10 | Sherman, Nebraska, US |
2021-02-15 | US | Nebraska | Sherman | 31163 | 174 | 4 | 0 | 170 | 41.22045983 | -98.97588642 | 2021-02-16 05:24:38 | Sherman, Nebraska, US |
2021-02-14 | US | New York | Unassigned | 90036 | 302 | 132 | 0 | 170 | 44.74530905 | 0.0 | 2021-02-15 05:24:49 | Unassigned, New York, US |
2021-02-14 | US | Nebraska | Sherman | 31163 | 174 | 4 | 0 | 170 | 41.22045983 | -98.97588642 | 2021-02-15 05:24:49 | Sherman, Nebraska, US |
2021-02-13 | US | Nebraska | Sherman | 31163 | 174 | 4 | 0 | 170 | 41.22045983 | -98.97588642 | 2021-02-14 05:23:43 | Sherman, Nebraska, US |
2021-02-13 | Trinidad and Tobago | 7642 | 138 | 7334 | 170 | 10.6918 | -61.2225 | 2021-02-14 05:23:43 | Trinidad and Tobago | |||
2021-02-12 | US | Nebraska | Sherman | 31163 | 174 | 4 | 0 | 170 | 41.22045983 | -98.97588642 | 2021-02-13 05:22:12 | Sherman, Nebraska, US |
2021-02-09 | US | Montana | McCone | 30055 | 170 | 0 | 0 | 170 | 47.64469406 | -105.7944994 | 2021-02-10 05:22:41 | McCone, Montana, US |
2021-02-09 | US | Kentucky | Robertson | 21201 | 182 | 12 | 0 | 170 | 38.51923469 | -84.05055616 | 2021-02-10 05:22:41 | Robertson, Kentucky, US |
2021-02-08 | US | Kentucky | Robertson | 21201 | 182 | 12 | 0 | 170 | 38.51923469 | -84.05055616 | 2021-02-09 05:23:30 | Robertson, Kentucky, US |
2021-02-07 | US | Kentucky | Robertson | 21201 | 182 | 12 | 0 | 170 | 38.51923469 | -84.05055616 | 2021-02-08 05:22:39 | Robertson, Kentucky, US |
2021-02-06 | US | Kentucky | Robertson | 21201 | 182 | 12 | 0 | 170 | 38.51923469 | -84.05055616 | 2021-02-07 05:23:00 | Robertson, Kentucky, US |
2021-02-04 | Japan | Miyazaki | 1869 | 20 | 1679 | 170 | 32.193203999999994 | 131.299374 | 2021-02-05 05:22:38 | Miyazaki, Japan | ||
2021-02-03 | US | Nebraska | Boyd | 31015 | 173 | 3 | 0 | 170 | 42.8997274 | -98.76486568 | 2021-02-04 05:22:26 | Boyd, Nebraska, US |
2021-02-03 | US | Kentucky | Robertson | 21201 | 180 | 10 | 0 | 170 | 38.51923469 | -84.05055616 | 2021-02-04 05:22:26 | Robertson, Kentucky, US |
2021-02-02 | US | Kentucky | Robertson | 21201 | 180 | 10 | 0 | 170 | 38.51923469 | -84.05055616 | 2021-02-03 05:22:52 | Robertson, Kentucky, US |
2021-02-01 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 170 | 0 | 0 | 170 | 58.62403337 | -156.21405890000003 | 2021-02-02 05:22:49 | Bristol Bay plus Lake and Peninsula, Alaska, US |
2021-02-01 | Colombia | Choco | 6098 | 184 | 5744 | 170 | 5.2528 | -76.82600000000002 | 2021-02-02 05:22:49 | Choco, Colombia | ||
2021-01-31 | US | Missouri | Knox | 29103 | 172 | 2 | 0 | 170 | 40.12699751 | -92.14780832 | 2021-02-01 05:22:53 | Knox, Missouri, US |
2021-01-31 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 170 | 0 | 0 | 170 | 58.62403337 | -156.21405890000003 | 2021-02-01 05:22:53 | Bristol Bay plus Lake and Peninsula, Alaska, US |
2021-01-31 | Gambia | 4090 | 128 | 3792 | 170 | 13.4432 | -15.3101 | 2021-02-01 05:22:53 | Gambia | |||
2021-01-30 | US | Missouri | Knox | 29103 | 172 | 2 | 0 | 170 | 40.12699751 | -92.14780832 | 2021-01-31 05:22:42 | Knox, Missouri, US |
2021-01-30 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 170 | 0 | 0 | 170 | 58.62403337 | -156.21405890000003 | 2021-01-31 05:22:42 | Bristol Bay plus Lake and Peninsula, Alaska, US |
2021-01-30 | Gambia | 4090 | 128 | 3792 | 170 | 13.4432 | -15.3101 | 2021-01-31 05:22:42 | Gambia | |||
2021-01-29 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 170 | 0 | 0 | 170 | 58.62403337 | -156.21405890000003 | 2021-01-30 05:22:49 | Bristol Bay plus Lake and Peninsula, Alaska, US |
2021-01-28 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 170 | 0 | 0 | 170 | 58.62403337 | -156.21405890000003 | 2021-01-29 05:22:23 | Bristol Bay plus Lake and Peninsula, Alaska, US |
2021-01-27 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 170 | 0 | 0 | 170 | 58.62403337 | -156.21405890000003 | 2021-01-28 05:22:24 | Bristol Bay plus Lake and Peninsula, Alaska, US |
2021-01-27 | Japan | Kagawa | 608 | 14 | 424 | 170 | 34.217292 | 133.969047 | 2021-01-28 05:22:24 | Kagawa, Japan | ||
2021-01-26 | US | New York | Hamilton | 36041 | 171 | 1 | 0 | 170 | 43.66146647 | -74.49721957 | 2021-01-27 05:23:41 | Hamilton, New York, US |
2021-01-26 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 170 | 0 | 0 | 170 | 58.62403337 | -156.21405890000003 | 2021-01-27 05:23:41 | Bristol Bay plus Lake and Peninsula, Alaska, US |
2021-01-25 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 170 | 0 | 0 | 170 | 58.62403337 | -156.21405890000003 | 2021-01-26 05:22:02 | Bristol Bay plus Lake and Peninsula, Alaska, US |
2021-01-24 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 170 | 0 | 0 | 170 | 58.62403337 | -156.21405890000003 | 2021-01-25 05:22:16 | Bristol Bay plus Lake and Peninsula, Alaska, US |
2021-01-23 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 170 | 0 | 0 | 170 | 58.62403337 | -156.21405890000003 | 2021-01-24 05:22:35 | Bristol Bay plus Lake and Peninsula, Alaska, US |
2021-01-18 | US | Colorado | Costilla | 8023 | 168 | 2 | 0 | 170 | 37.27732493 | -105.4276548 | 2021-01-19 05:22:15 | Costilla, Colorado, US |
2021-01-17 | US | Colorado | Costilla | 8023 | 168 | 2 | 0 | 170 | 37.27732493 | -105.4276548 | 2021-01-18 05:22:34 | Costilla, Colorado, US |
2021-01-16 | US | Colorado | Costilla | 8023 | 166 | 2 | 0 | 170 | 37.27732493 | -105.4276548 | 2021-01-17 05:22:17 | Costilla, Colorado, US |
2021-01-15 | US | Texas | Menard | 48327 | 165 | 5 | 0 | 170 | 30.88990665 | -99.8204794 | 2021-01-16 05:22:40 | Menard, Texas, US |
2021-01-15 | US | Colorado | Sedgwick | 8115 | 182 | 2 | 0 | 170 | 40.87595412 | -102.3519227 | 2021-01-16 05:22:40 | Sedgwick, Colorado, US |
2021-01-15 | US | Colorado | Costilla | 8023 | 165 | 2 | 0 | 170 | 37.27732493 | -105.4276548 | 2021-01-16 05:22:40 | Costilla, Colorado, US |
2021-01-14 | US | Hawaii | Kauai | 15007 | 171 | 1 | 0 | 170 | 22.03935037 | -159.5966786 | 2021-01-15 05:22:24 | Kauai, Hawaii, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;