daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
544 rows where active = 391 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 436
- Russia 18
- Colombia 8
- Chile 7
- China 7
- Madagascar 7
- Ukraine 7
- Japan 5
- Congo (Brazzaville) 4
- Eritrea 3
- Malaysia 3
- United Kingdom 3
- Congo (Kinshasa) 2
- France 2
- Germany 2
- Mexico 2
- Netherlands 2
- Sierra Leone 2
- West Bank and Gaza 2
- Armenia 1
- Austria 1
- Brazil 1
- Burkina Faso 1
- Cuba 1
- Guinea-Bissau 1
- Guyana 1
- Honduras 1
- India 1
- Israel 1
- Italy 1
- …
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-02 | Ukraine | Chernihiv Oblast | 57787 | 1353 | 56043 | 391 | 51.4982 | 31.2893 | 2021-08-03 04:21:39 | Chernihiv Oblast, Ukraine | ||
2021-07-25 | Colombia | Putumayo | 15108 | 614 | 14103 | 391 | 0.436 | -75.5277 | 2021-07-26 04:21:28 | Putumayo, Colombia | ||
2021-07-23 | Colombia | Arauca | 12287 | 388 | 11508 | 391 | 7.0762 | -70.7105 | 2021-07-24 00:21:36 | Arauca, Colombia | ||
2021-07-22 | Colombia | Arauca | 12287 | 388 | 11508 | 391 | 7.0762 | -70.7105 | 2021-07-23 04:21:29 | Arauca, Colombia | ||
2021-07-20 | India | Rajasthan | 953415 | 8951 | 944073 | 391 | 26.583423 | 73.847973 | 2021-07-21 04:21:40 | Rajasthan, India | ||
2021-07-17 | Germany | Sachsen | 286128 | 10111 | 275700 | 391 | 51.1045 | 13.2017 | 2021-07-18 04:22:07 | Sachsen, Germany | ||
2021-07-13 | Eritrea | 6327 | 30 | 5906 | 391 | 15.1794 | 39.7823 | 2021-07-14 04:21:35 | Eritrea | |||
2021-06-29 | Ukraine | Volyn Oblast | 62132 | 1196 | 60545 | 391 | 50.7472 | 25.3254 | 2021-06-30 04:21:41 | Volyn Oblast, Ukraine | ||
2021-06-19 | Israel | 839830 | 6427 | 833012 | 391 | 31.046051 | 34.851612 | 2021-06-20 04:21:48 | Israel | |||
2021-06-16 | Chile | Aysen | 7052 | 49 | 6612 | 391 | -45.9864 | -73.7669 | 2021-06-17 04:22:36 | Aysen, Chile | ||
2021-06-05 | Colombia | Arauca | 8359 | 246 | 7722 | 391 | 7.0762 | -70.7105 | 2021-06-06 04:24:03 | Arauca, Colombia | ||
2021-06-02 | Russia | Sakhalin Oblast | 23032 | 52 | 22589 | 391 | 49.7219665 | 143.448533 | 2021-06-03 04:23:32 | Sakhalin Oblast, Russia | ||
2021-05-23 | Russia | North Ossetia - Alania Republic | 16939 | 206 | 16342 | 391 | 42.79336110000001 | 44.6324493 | 2021-05-24 04:20:53 | North Ossetia - Alania Republic, Russia | ||
2021-05-13 | Ukraine | Sevastopol* | 14358 | 654 | 13313 | 391 | 44.6054 | 33.522 | 2021-05-14 04:20:41 | Sevastopol*, Ukraine | ||
2021-05-12 | Russia | Sakhalin Oblast | 22676 | 43 | 22242 | 391 | 49.7219665 | 143.448533 | 2021-05-13 04:20:51 | Sakhalin Oblast, Russia | ||
2021-05-06 | Russia | Sakhalin Oblast | 22600 | 42 | 22167 | 391 | 49.7219665 | 143.448533 | 2021-05-07 04:20:40 | Sakhalin Oblast, Russia | ||
2021-04-30 | Russia | Sakhalin Oblast | 22536 | 42 | 22103 | 391 | 49.7219665 | 143.448533 | 2021-05-01 04:20:47 | Sakhalin Oblast, Russia | ||
2021-04-29 | Russia | Adygea Republic | 14414 | 174 | 13849 | 391 | 44.6939006 | 40.1520421 | 2021-04-30 04:21:03 | Adygea Republic, Russia | ||
2021-04-28 | Russia | Adygea Republic | 14404 | 173 | 13840 | 391 | 44.6939006 | 40.1520421 | 2021-04-29 04:20:55 | Adygea Republic, Russia | ||
2021-04-19 | Netherlands | Aruba | 10345 | 92 | 9862 | 391 | 12.5211 | -69.9683 | 2021-04-20 04:20:41 | Aruba, Netherlands | ||
2021-04-16 | Russia | Tyva Republic | 15785 | 200 | 15194 | 391 | 51.4017149 | 93.8582593 | 2021-04-17 04:20:40 | Tyva Republic, Russia | ||
2021-03-31 | Russia | Komi Republic | 41616 | 805 | 40420 | 391 | 63.9881421 | 54.3326073 | 2021-04-01 04:27:05 | Komi Republic, Russia | ||
2021-03-20 | Russia | Sakhalin Oblast | 21891 | 36 | 21464 | 391 | 49.7219665 | 143.448533 | 2021-03-21 05:25:44 | Sakhalin Oblast, Russia | ||
2021-03-10 | Ukraine | Sevastopol* | 12460 | 523 | 11546 | 391 | 44.6054 | 33.522 | 2021-03-11 05:25:48 | Sevastopol*, Ukraine | ||
2021-03-08 | Russia | Komi Republic | 40067 | 760 | 38916 | 391 | 63.9881421 | 54.3326073 | 2021-03-09 05:28:19 | Komi Republic, Russia | ||
2021-03-06 | US | North Dakota | Bowman | 38011 | 395 | 5 | 0 | 391 | 46.11285362 | -103.5203343 | 2021-03-07 05:21:54 | Bowman, North Dakota, US |
2021-03-04 | US | Michigan | Ontonagon | 26131 | 411 | 20 | 0 | 391 | 46.665226200000006 | -89.31390481 | 2021-03-05 05:26:29 | Ontonagon, Michigan, US |
2021-03-03 | US | Virginia | Charles City | 51036 | 402 | 11 | 0 | 391 | 37.35358063 | -77.05634116 | 2021-03-04 05:24:24 | Charles City, Virginia, US |
2021-02-26 | US | Michigan | Ontonagon | 26131 | 411 | 20 | 0 | 391 | 46.665226200000006 | -89.31390481 | 2021-02-27 05:22:28 | Ontonagon, Michigan, US |
2021-02-25 | US | Michigan | Ontonagon | 26131 | 411 | 20 | 0 | 391 | 46.665226200000006 | -89.31390481 | 2021-02-26 05:22:40 | Ontonagon, Michigan, US |
2021-02-25 | Colombia | Sucre | 20414 | 772 | 19251 | 391 | 8.814 | -74.7233 | 2021-02-26 05:22:40 | Sucre, Colombia | ||
2021-02-24 | US | Michigan | Ontonagon | 26131 | 411 | 20 | 0 | 391 | 46.665226200000006 | -89.31390481 | 2021-02-25 05:24:57 | Ontonagon, Michigan, US |
2021-02-24 | Chile | Magallanes | 21628 | 307 | 20930 | 391 | -52.368 | -70.9863 | 2021-02-25 05:24:57 | Magallanes, Chile | ||
2021-02-23 | US | Kansas | Trego | 20195 | 398 | 7 | 0 | 391 | 38.91467218 | -99.87284448 | 2021-02-24 05:29:16 | Trego, Kansas, US |
2021-02-22 | US | Kansas | Trego | 20195 | 398 | 7 | 0 | 391 | 38.91467218 | -99.87284448 | 2021-02-23 05:23:41 | Trego, Kansas, US |
2021-02-21 | US | Oregon | Curry | 41015 | 397 | 6 | 0 | 391 | 42.45911325 | -124.157282 | 2021-02-22 05:24:21 | Curry, Oregon, US |
2021-02-20 | Madagascar | 19598 | 292 | 18915 | 391 | -18.766947 | 46.869107 | 2021-02-21 05:24:33 | Madagascar | |||
2021-02-19 | Madagascar | 19598 | 292 | 18915 | 391 | -18.766947 | 46.869107 | 2021-02-20 05:22:51 | Madagascar | |||
2021-02-18 | US | Montana | Broadwater | 30007 | 396 | 5 | 0 | 391 | 46.33277565 | -111.4955813 | 2021-02-19 05:24:16 | Broadwater, Montana, US |
2021-02-18 | Madagascar | 19598 | 292 | 18915 | 391 | -18.766947 | 46.869107 | 2021-02-19 05:24:16 | Madagascar | |||
2021-02-17 | US | Vermont | Caledonia | 50005 | 396 | 5 | 0 | 391 | 44.46548598 | -72.10314651 | 2021-02-18 05:22:58 | Caledonia, Vermont, US |
2021-02-17 | Madagascar | 19598 | 292 | 18915 | 391 | -18.766947 | 46.869107 | 2021-02-18 05:22:58 | Madagascar | |||
2021-02-17 | Japan | Ibaraki | 5436 | 100 | 4945 | 391 | 36.303588 | 140.319591 | 2021-02-18 05:22:58 | Ibaraki, Japan | ||
2021-02-16 | US | Oregon | Tillamook | 41057 | 393 | 2 | 0 | 391 | 45.46248721 | -123.712066 | 2021-02-17 05:23:10 | Tillamook, Oregon, US |
2021-02-16 | Madagascar | 19598 | 292 | 18915 | 391 | -18.766947 | 46.869107 | 2021-02-17 05:23:10 | Madagascar | |||
2021-02-16 | Chile | Magallanes | 21148 | 296 | 20461 | 391 | -52.368 | -70.9863 | 2021-02-17 05:23:10 | Magallanes, Chile | ||
2021-02-15 | US | Oregon | Tillamook | 41057 | 393 | 2 | 0 | 391 | 45.46248721 | -123.712066 | 2021-02-16 05:24:38 | Tillamook, Oregon, US |
2021-02-15 | Madagascar | 19598 | 292 | 18915 | 391 | -18.766947 | 46.869107 | 2021-02-16 05:24:38 | Madagascar | |||
2021-02-14 | US | Oregon | Tillamook | 41057 | 393 | 2 | 0 | 391 | 45.46248721 | -123.712066 | 2021-02-15 05:24:49 | Tillamook, Oregon, US |
2021-02-14 | US | Montana | Broadwater | 30007 | 396 | 5 | 0 | 391 | 46.33277565 | -111.4955813 | 2021-02-15 05:24:49 | Broadwater, Montana, US |
2021-02-14 | Madagascar | 19598 | 292 | 18915 | 391 | -18.766947 | 46.869107 | 2021-02-15 05:24:49 | Madagascar | |||
2021-02-13 | US | Puerto Rico | San German | 72125 | 391 | 0 | 0 | 391 | 18.111484 | -67.03858100000001 | 2021-02-14 05:23:43 | San German, Puerto Rico, US |
2021-02-13 | US | Oregon | Tillamook | 41057 | 393 | 2 | 0 | 391 | 45.46248721 | -123.712066 | 2021-02-14 05:23:43 | Tillamook, Oregon, US |
2021-02-12 | US | Puerto Rico | San German | 72125 | 391 | 0 | 0 | 391 | 18.111484 | -67.03858100000001 | 2021-02-13 05:22:12 | San German, Puerto Rico, US |
2021-02-12 | US | Illinois | Putnam | 17155 | 394 | 3 | 0 | 391 | 41.2013541 | -89.2869272 | 2021-02-13 05:22:12 | Putnam, Illinois, US |
2021-02-12 | Guinea-Bissau | 2869 | 46 | 2432 | 391 | 11.8037 | -15.1804 | 2021-02-13 05:22:12 | Guinea-Bissau | |||
2021-02-11 | US | Alaska | Aleutians West | 2016 | 391 | 0 | 0 | 391 | 52.3233 | -174.1596 | 2021-02-12 05:23:29 | Aleutians West, Alaska, US |
2021-02-10 | France | Reunion | 10487 | 47 | 10049 | 391 | -21.1151 | 55.5364 | 2021-02-11 05:23:55 | Reunion, France | ||
2021-02-09 | Chile | Atacama | 10811 | 134 | 10286 | 391 | -27.5661 | -70.0503 | 2021-02-10 05:22:41 | Atacama, Chile | ||
2021-02-07 | US | Oklahoma | Beaver | 40007 | 395 | 4 | 0 | 391 | 36.7496847 | -100.4758872 | 2021-02-08 05:22:39 | Beaver, Oklahoma, US |
2021-02-06 | US | Oklahoma | Beaver | 40007 | 395 | 4 | 0 | 391 | 36.7496847 | -100.4758872 | 2021-02-07 05:23:00 | Beaver, Oklahoma, US |
2021-02-03 | United Kingdom | Channel Islands | 0 | 0 | 3302 | 391 | 49.3723 | -2.3644 | 2021-02-04 05:22:26 | Channel Islands, United Kingdom | ||
2021-02-02 | United Kingdom | Channel Islands | 0 | 0 | 3302 | 391 | 49.3723 | -2.3644 | 2021-02-03 05:22:52 | Channel Islands, United Kingdom | ||
2021-02-02 | US | Montana | Teton | 30099 | 396 | 5 | 0 | 391 | 47.83741052 | -112.2410688 | 2021-02-03 05:22:52 | Teton, Montana, US |
2021-02-01 | US | Montana | Teton | 30099 | 396 | 5 | 0 | 391 | 47.83741052 | -112.2410688 | 2021-02-02 05:22:49 | Teton, Montana, US |
2021-01-31 | US | Montana | Teton | 30099 | 396 | 5 | 0 | 391 | 47.83741052 | -112.2410688 | 2021-02-01 05:22:53 | Teton, Montana, US |
2021-01-25 | Netherlands | Aruba | 6742 | 57 | 6294 | 391 | 12.5211 | -69.9683 | 2021-01-26 05:22:02 | Aruba, Netherlands | ||
2021-01-24 | US | Colorado | Conejos | 8021 | 413 | 6 | 0 | 391 | 37.201606 | -106.19174879999998 | 2021-01-25 05:22:16 | Conejos, Colorado, US |
2021-01-23 | US | Illinois | Gallatin | 17059 | 394 | 3 | 0 | 391 | 37.76430935 | -88.22953869 | 2021-01-24 05:22:35 | Gallatin, Illinois, US |
2021-01-19 | US | Vermont | Orange | 50017 | 392 | 1 | 0 | 391 | 44.00470222 | -72.37640104 | 2021-01-20 05:21:54 | Orange, Vermont, US |
2021-01-19 | US | Nebraska | Furnas | 31065 | 395 | 4 | 0 | 391 | 40.17642064 | -99.91247454 | 2021-01-20 05:21:54 | Furnas, Nebraska, US |
2021-01-19 | US | Kansas | Haskell | 20081 | 397 | 6 | 0 | 391 | 37.5620394 | -100.8710738 | 2021-01-20 05:21:54 | Haskell, Kansas, US |
2021-01-18 | US | Wyoming | Crook | 56011 | 400 | 9 | 0 | 391 | 44.58855102 | -104.5697705 | 2021-01-19 05:22:15 | Crook, Wyoming, US |
2021-01-18 | US | Nebraska | Furnas | 31065 | 395 | 4 | 0 | 391 | 40.17642064 | -99.91247454 | 2021-01-19 05:22:15 | Furnas, Nebraska, US |
2021-01-18 | US | Kansas | Haskell | 20081 | 397 | 6 | 0 | 391 | 37.5620394 | -100.8710738 | 2021-01-19 05:22:15 | Haskell, Kansas, US |
2021-01-18 | Japan | Nara | 2595 | 31 | 2173 | 391 | 34.317451 | 135.871644 | 2021-01-19 05:22:15 | Nara, Japan | ||
2021-01-17 | US | Maine | Lincoln | 23015 | 393 | 2 | 0 | 391 | 44.05996956 | -69.54227124 | 2021-01-18 05:22:34 | Lincoln, Maine, US |
2021-01-16 | US | North Dakota | Emmons | 38029 | 403 | 11 | 0 | 391 | 46.28398398 | -100.2389766 | 2021-01-17 05:22:17 | Emmons, North Dakota, US |
2021-01-16 | US | Maine | Lincoln | 23015 | 393 | 2 | 0 | 391 | 44.05996956 | -69.54227124 | 2021-01-17 05:22:17 | Lincoln, Maine, US |
2021-01-15 | US | North Dakota | Emmons | 38029 | 401 | 11 | 0 | 391 | 46.28398398 | -100.2389766 | 2021-01-16 05:22:40 | Emmons, North Dakota, US |
2021-01-15 | US | Georgia | Marion | 13197 | 401 | 10 | 0 | 391 | 32.3483402 | -84.52733571 | 2021-01-16 05:22:40 | Marion, Georgia, US |
2021-01-14 | US | North Carolina | Camden | 37029 | 396 | 5 | 0 | 391 | 36.33804939 | -76.15568396 | 2021-01-15 05:22:24 | Camden, North Carolina, US |
2021-01-13 | US | North Dakota | Emmons | 38029 | 400 | 10 | 0 | 391 | 46.28398398 | -100.2389766 | 2021-01-14 05:22:32 | Emmons, North Dakota, US |
2021-01-12 | US | Iowa | Wayne | 19185 | 412 | 21 | 0 | 391 | 40.73969028 | -93.32752197 | 2021-01-13 05:22:15 | Wayne, Iowa, US |
2021-01-11 | US | Missouri | Carter | 29035 | 397 | 6 | 0 | 391 | 36.94160441 | -90.96051322 | 2021-01-12 05:22:15 | Carter, Missouri, US |
2021-01-11 | US | Georgia | Echols | 13101 | 395 | 4 | 0 | 391 | 30.71101099 | -82.89687287 | 2021-01-12 05:22:15 | Echols, Georgia, US |
2021-01-10 | US | Iowa | Audubon | 19009 | 399 | 8 | 0 | 391 | 41.6844628 | -94.90581859 | 2021-01-11 05:21:50 | Audubon, Iowa, US |
2021-01-08 | US | Mississippi | Sharkey | 28125 | 408 | 17 | 0 | 391 | 32.88149103 | -90.8159538 | 2021-01-09 05:22:18 | Sharkey, Mississippi, US |
2021-01-07 | US | Virginia | Nelson | 51125 | 395 | 4 | 0 | 391 | 37.78790447 | -78.88498513 | 2021-01-08 05:22:42 | Nelson, Virginia, US |
2021-01-06 | US | Nebraska | Thayer | 31169 | 394 | 3 | 0 | 391 | 40.17626377 | -97.59504381 | 2021-01-07 05:22:03 | Thayer, Nebraska, US |
2021-01-05 | US | Virginia | Emporia | 51595 | 421 | 30 | 0 | 391 | 36.69455571 | -77.53406129 | 2021-01-06 05:22:16 | Emporia, Virginia, US |
2021-01-05 | US | Montana | Pondera | 30073 | 394 | 3 | 0 | 391 | 48.22773388 | -112.2252703 | 2021-01-06 05:22:16 | Pondera, Montana, US |
2021-01-04 | US | West Virginia | Tyler | 54095 | 393 | 2 | 0 | 391 | 39.46811972 | -80.88772676 | 2021-01-05 05:21:49 | Tyler, West Virginia, US |
2021-01-04 | US | Virginia | Emporia | 51595 | 421 | 30 | 0 | 391 | 36.69455571 | -77.53406129 | 2021-01-05 05:21:49 | Emporia, Virginia, US |
2021-01-03 | US | Illinois | Calhoun | 17013 | 392 | 1 | 0 | 391 | 39.16840183 | -90.66330078 | 2021-01-04 05:22:02 | Calhoun, Illinois, US |
2021-01-02 | US | Texas | Sutton | 48435 | 348 | 6 | 0 | 391 | 30.49856623 | -100.5382014 | 2021-01-03 05:22:52 | Sutton, Texas, US |
2021-01-01 | US | North Carolina | Jones | 37103 | 407 | 16 | 0 | 391 | 35.02254606 | -77.35870791 | 2021-01-02 05:22:33 | Jones, North Carolina, US |
2021-01-01 | Liechtenstein | 2245 | 44 | 1810 | 391 | 47.14 | 9.55 | 2021-01-02 05:22:33 | Liechtenstein | |||
2020-12-31 | US | Texas | Sutton | 48435 | 348 | 6 | 0 | 391 | 30.49856623 | -100.5382014 | 2021-01-01 05:23:07 | Sutton, Texas, US |
2020-12-31 | US | Puerto Rico | Cabo Rojo | 72023 | 391 | 0 | 0 | 391 | 18.040993 | -67.154391 | 2021-01-01 05:23:07 | Cabo Rojo, Puerto Rico, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;