daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
507 rows where active = 451 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 25
- US 436
- Russia 16
- Colombia 10
- Japan 8
- Chile 5
- Congo (Brazzaville) 3
- Germany 3
- India 3
- Malaysia 2
- Mexico 2
- Netherlands 2
- North Macedonia 2
- Papua New Guinea 2
- Seychelles 2
- Italy 1
- Mauritania 1
- Mauritius 1
- San Marino 1
- Sierra Leone 1
- Suriname 1
- Sweden 1
- Switzerland 1
- Timor-Leste 1
- Trinidad and Tobago 1
- Ukraine 1
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-08-02 | Seychelles | 18411 | 86 | 17874 | 451 | -4.6796 | 55.492 | 2021-08-03 04:21:39 | Seychelles | |||
2021-07-29 | Colombia | Caqueta | 22026 | 874 | 20701 | 451 | 0.8699 | -73.8419 | 2021-07-30 04:21:34 | Caqueta, Colombia | ||
2021-07-10 | Malaysia | Terengganu | 11723 | 82 | 11190 | 451 | 5.3117 | 103.1324 | 2021-07-11 04:21:43 | Terengganu, Malaysia | ||
2021-06-28 | Mauritius | 1880 | 18 | 1411 | 451 | -20.348404 | 57.552152 | 2021-06-29 04:21:28 | Mauritius | |||
2021-06-23 | Germany | Sachsen-Anhalt | 99185 | 3417 | 95370 | 451 | 51.9503 | 11.6923 | 2021-06-24 04:21:55 | Sachsen-Anhalt, Germany | ||
2021-06-21 | Colombia | Arauca | 9553 | 289 | 8813 | 451 | 7.0762 | -70.7105 | 2021-06-22 04:21:34 | Arauca, Colombia | ||
2021-06-20 | Papua New Guinea | 16933 | 173 | 16309 | 451 | -6.314993 | 143.95555 | 2021-06-21 04:21:41 | Papua New Guinea | |||
2021-06-20 | Chile | Aysen | 7324 | 53 | 6820 | 451 | -45.9864 | -73.7669 | 2021-06-21 04:21:41 | Aysen, Chile | ||
2021-06-19 | Papua New Guinea | 16933 | 173 | 16309 | 451 | -6.314993 | 143.95555 | 2021-06-20 04:21:48 | Papua New Guinea | |||
2021-06-15 | Mauritania | 20151 | 477 | 19223 | 451 | 21.0079 | -10.9408 | 2021-06-16 04:22:32 | Mauritania | |||
2021-06-13 | Russia | North Ossetia - Alania Republic | 17113 | 222 | 16440 | 451 | 42.79336110000001 | 44.6324493 | 2021-06-14 04:22:46 | North Ossetia - Alania Republic, Russia | ||
2021-06-13 | Germany | Saarland | 41260 | 1016 | 39800 | 451 | 49.3964 | 7.023 | 2021-06-14 04:22:46 | Saarland, Germany | ||
2021-06-09 | North Macedonia | 155469 | 5467 | 149551 | 451 | 41.6086 | 21.7453 | 2021-06-10 04:23:17 | North Macedonia | |||
2021-06-08 | North Macedonia | 155441 | 5462 | 149528 | 451 | 41.6086 | 21.7453 | 2021-06-09 04:23:31 | North Macedonia | |||
2021-06-01 | Russia | Komi Republic | 44180 | 967 | 42762 | 451 | 63.9881421 | 54.3326073 | 2021-06-02 04:24:34 | Komi Republic, Russia | ||
2021-05-23 | Russia | Khanty-Mansi Autonomous Okrug | 57095 | 796 | 55848 | 451 | 61.0259025 | 69.0982628 | 2021-05-24 04:20:53 | Khanty-Mansi Autonomous Okrug, Russia | ||
2021-05-16 | Japan | Niigata | 2848 | 27 | 2370 | 451 | 37.521819 | 138.918647 | 2021-05-17 04:20:34 | Niigata, Japan | ||
2021-05-16 | Italy | Valle d'Aosta | 11384 | 467 | 10466 | 451 | 45.73750286 | 7.320149366 | 2021-05-17 04:20:34 | Valle d'Aosta, Italy | ||
2021-05-04 | Japan | Miyagi | 8167 | 69 | 7647 | 451 | 38.446859 | 140.927086 | 2021-05-05 04:20:43 | Miyagi, Japan | ||
2021-04-30 | Russia | North Ossetia - Alania Republic | 16722 | 198 | 16073 | 451 | 42.79336110000001 | 44.6324493 | 2021-05-01 04:20:47 | North Ossetia - Alania Republic, Russia | ||
2021-04-27 | Russia | North Ossetia - Alania Republic | 16696 | 196 | 16049 | 451 | 42.79336110000001 | 44.6324493 | 2021-04-28 04:20:32 | North Ossetia - Alania Republic, Russia | ||
2021-04-18 | Netherlands | Aruba | 10324 | 92 | 9781 | 451 | 12.5211 | -69.9683 | 2021-04-19 04:20:57 | Aruba, Netherlands | ||
2021-04-11 | Suriname | 9302 | 182 | 8669 | 451 | 3.9193 | -56.0278 | 2021-04-12 04:21:00 | Suriname | |||
2021-04-01 | Timor-Leste | 643 | 0 | 192 | 451 | -8.874217 | 125.727539 | 2021-04-02 04:20:36 | Timor-Leste | |||
2021-03-18 | Russia | Murmansk Oblast | 48099 | 1034 | 46614 | 451 | 68.00004179999999 | 33.9999151 | 2021-03-19 05:26:09 | Murmansk Oblast, Russia | ||
2021-03-06 | US | Iowa | Wayne | 19185 | 472 | 21 | 0 | 451 | 40.73969028 | -93.32752197 | 2021-03-07 05:21:54 | Wayne, Iowa, US |
2021-03-05 | US | Iowa | Wayne | 19185 | 472 | 21 | 0 | 451 | 40.73969028 | -93.32752197 | 2021-03-06 04:23:41 | Wayne, Iowa, US |
2021-03-04 | US | California | Modoc | 6049 | 451 | 3 | 0 | 451 | 41.58965602 | -120.7244817 | 2021-03-05 05:26:29 | Modoc, California, US |
2021-03-02 | India | Uttarakhand | 97089 | 1692 | 94946 | 451 | 30.156447 | 79.197608 | 2021-03-03 05:23:28 | Uttarakhand, India | ||
2021-02-28 | US | Kentucky | Nicholas | 21181 | 457 | 6 | 0 | 451 | 38.33342292 | -84.01889177 | 2021-03-01 05:23:01 | Nicholas, Kentucky, US |
2021-02-28 | Colombia | Huila | 49618 | 1727 | 47440 | 451 | 2.5359 | -75.5277 | 2021-03-01 05:23:01 | Huila, Colombia | ||
2021-02-25 | US | North Dakota | Eddy | 38027 | 453 | 6 | 0 | 451 | 47.71701474 | -98.90432337 | 2021-02-26 05:22:40 | Eddy, North Dakota, US |
2021-02-24 | US | North Dakota | Eddy | 38027 | 452 | 6 | 0 | 451 | 47.71701474 | -98.90432337 | 2021-02-25 05:24:57 | Eddy, North Dakota, US |
2021-02-23 | US | North Dakota | Eddy | 38027 | 452 | 6 | 0 | 451 | 47.71701474 | -98.90432337 | 2021-02-24 05:29:16 | Eddy, North Dakota, US |
2021-02-22 | US | North Dakota | Eddy | 38027 | 452 | 6 | 0 | 451 | 47.71701474 | -98.90432337 | 2021-02-23 05:23:41 | Eddy, North Dakota, US |
2021-02-22 | Seychelles | 2401 | 10 | 1940 | 451 | -4.6796 | 55.492 | 2021-02-23 05:23:41 | Seychelles | |||
2021-02-19 | US | Texas | Sabine | 48403 | 507 | 38 | 0 | 451 | 31.34318809 | -93.85440451 | 2021-02-20 05:22:51 | Sabine, Texas, US |
2021-02-19 | US | South Dakota | Corson | 46031 | 463 | 12 | 0 | 451 | 45.70889983 | -101.1970473 | 2021-02-20 05:22:51 | Corson, South Dakota, US |
2021-02-18 | US | Texas | Sabine | 48403 | 507 | 38 | 0 | 451 | 31.34318809 | -93.85440451 | 2021-02-19 05:24:16 | Sabine, Texas, US |
2021-02-17 | US | Texas | Sabine | 48403 | 507 | 38 | 0 | 451 | 31.34318809 | -93.85440451 | 2021-02-18 05:22:58 | Sabine, Texas, US |
2021-02-16 | US | Texas | Sabine | 48403 | 507 | 38 | 0 | 451 | 31.34318809 | -93.85440451 | 2021-02-17 05:23:10 | Sabine, Texas, US |
2021-02-15 | US | Texas | Sabine | 48403 | 507 | 38 | 0 | 451 | 31.34318809 | -93.85440451 | 2021-02-16 05:24:38 | Sabine, Texas, US |
2021-02-14 | US | Texas | Sabine | 48403 | 507 | 38 | 0 | 451 | 31.34318809 | -93.85440451 | 2021-02-15 05:24:49 | Sabine, Texas, US |
2021-02-13 | US | Texas | Sabine | 48403 | 507 | 38 | 0 | 451 | 31.34318809 | -93.85440451 | 2021-02-14 05:23:43 | Sabine, Texas, US |
2021-02-11 | US | South Dakota | Corson | 46031 | 462 | 11 | 0 | 451 | 45.70889983 | -101.1970473 | 2021-02-12 05:23:29 | Corson, South Dakota, US |
2021-02-10 | US | South Dakota | Corson | 46031 | 462 | 11 | 0 | 451 | 45.70889983 | -101.1970473 | 2021-02-11 05:23:55 | Corson, South Dakota, US |
2021-02-10 | US | Nebraska | Morrill | 31123 | 466 | 15 | 0 | 451 | 41.71711774 | -103.0061405 | 2021-02-11 05:23:55 | Morrill, Nebraska, US |
2021-02-08 | US | Kentucky | Fulton | 21075 | 456 | 5 | 0 | 451 | 36.55238827 | -89.20140068 | 2021-02-09 05:23:30 | Fulton, Kentucky, US |
2021-02-06 | US | Nebraska | Fillmore | 31059 | 460 | 9 | 0 | 451 | 40.52458567 | -97.59646937 | 2021-02-07 05:23:00 | Fillmore, Nebraska, US |
2021-02-06 | US | Missouri | Hickory | 29085 | 462 | 11 | 0 | 451 | 37.94163617 | -93.3203037 | 2021-02-07 05:23:00 | Hickory, Missouri, US |
2021-02-06 | US | Kentucky | Fulton | 21075 | 455 | 4 | 0 | 451 | 36.55238827 | -89.20140068 | 2021-02-07 05:23:00 | Fulton, Kentucky, US |
2021-02-05 | US | South Dakota | Deuel | 46039 | 459 | 8 | 0 | 451 | 44.75994309 | -96.66943645 | 2021-02-06 05:23:55 | Deuel, South Dakota, US |
2021-02-05 | US | Nebraska | Fillmore | 31059 | 460 | 9 | 0 | 451 | 40.52458567 | -97.59646937 | 2021-02-06 05:23:55 | Fillmore, Nebraska, US |
2021-02-04 | US | Wisconsin | Florence | 55037 | 463 | 12 | 0 | 451 | 45.84963535 | -88.39804137 | 2021-02-05 05:22:38 | Florence, Wisconsin, US |
2021-02-02 | US | South Dakota | Edmunds | 46045 | 460 | 9 | 0 | 451 | 45.41846445 | -99.21545423 | 2021-02-03 05:22:52 | Edmunds, South Dakota, US |
2021-02-02 | US | Nebraska | Thayer | 31169 | 454 | 3 | 0 | 451 | 40.17626377 | -97.59504381 | 2021-02-03 05:22:52 | Thayer, Nebraska, US |
2021-02-02 | US | Illinois | Calhoun | 17013 | 453 | 2 | 0 | 451 | 39.16840183 | -90.66330078 | 2021-02-03 05:22:52 | Calhoun, Illinois, US |
2021-02-02 | US | Georgia | Marion | 13197 | 462 | 11 | 0 | 451 | 32.3483402 | -84.52733571 | 2021-02-03 05:22:52 | Marion, Georgia, US |
2021-02-01 | US | South Dakota | Edmunds | 46045 | 460 | 9 | 0 | 451 | 45.41846445 | -99.21545423 | 2021-02-02 05:22:49 | Edmunds, South Dakota, US |
2021-02-01 | US | Nebraska | Thayer | 31169 | 454 | 3 | 0 | 451 | 40.17626377 | -97.59504381 | 2021-02-02 05:22:49 | Thayer, Nebraska, US |
2021-02-01 | US | Illinois | Calhoun | 17013 | 453 | 2 | 0 | 451 | 39.16840183 | -90.66330078 | 2021-02-02 05:22:49 | Calhoun, Illinois, US |
2021-01-31 | US | South Dakota | Edmunds | 46045 | 460 | 9 | 0 | 451 | 45.41846445 | -99.21545423 | 2021-02-01 05:22:53 | Edmunds, South Dakota, US |
2021-01-31 | US | Nebraska | Thayer | 31169 | 454 | 3 | 0 | 451 | 40.17626377 | -97.59504381 | 2021-02-01 05:22:53 | Thayer, Nebraska, US |
2021-01-31 | US | Illinois | Calhoun | 17013 | 453 | 2 | 0 | 451 | 39.16840183 | -90.66330078 | 2021-02-01 05:22:53 | Calhoun, Illinois, US |
2021-01-30 | US | Nevada | White Pine | 32033 | 456 | 5 | 0 | 451 | 39.44157041 | -114.899966 | 2021-01-31 05:22:42 | White Pine, Nevada, US |
2021-01-30 | US | Nebraska | Thayer | 31169 | 454 | 3 | 0 | 451 | 40.17626377 | -97.59504381 | 2021-01-31 05:22:42 | Thayer, Nebraska, US |
2021-01-30 | US | Illinois | Calhoun | 17013 | 453 | 2 | 0 | 451 | 39.16840183 | -90.66330078 | 2021-01-31 05:22:42 | Calhoun, Illinois, US |
2021-01-29 | US | Nebraska | Thayer | 31169 | 454 | 3 | 0 | 451 | 40.17626377 | -97.59504381 | 2021-01-30 05:22:49 | Thayer, Nebraska, US |
2021-01-29 | US | Illinois | Calhoun | 17013 | 453 | 2 | 0 | 451 | 39.16840183 | -90.66330078 | 2021-01-30 05:22:49 | Calhoun, Illinois, US |
2021-01-28 | US | Nebraska | Thayer | 31169 | 454 | 3 | 0 | 451 | 40.17626377 | -97.59504381 | 2021-01-29 05:22:23 | Thayer, Nebraska, US |
2021-01-27 | Japan | Hiroshima | 4701 | 91 | 4159 | 451 | 34.605309000000005 | 132.788719 | 2021-01-28 05:22:24 | Hiroshima, Japan | ||
2021-01-25 | US | Montana | Phillips | 30071 | 464 | 13 | 0 | 451 | 48.25936577 | -107.9128511 | 2021-01-26 05:22:02 | Phillips, Montana, US |
2021-01-24 | US | Montana | Phillips | 30071 | 464 | 13 | 0 | 451 | 48.25936577 | -107.9128511 | 2021-01-25 05:22:16 | Phillips, Montana, US |
2021-01-23 | US | Montana | Phillips | 30071 | 464 | 13 | 0 | 451 | 48.25936577 | -107.9128511 | 2021-01-24 05:22:35 | Phillips, Montana, US |
2021-01-22 | US | Montana | Phillips | 30071 | 464 | 13 | 0 | 451 | 48.25936577 | -107.9128511 | 2021-01-23 05:22:03 | Phillips, Montana, US |
2021-01-20 | US | Texas | Newton | 48351 | 396 | 20 | 0 | 451 | 30.78548982 | -93.74408813 | 2021-01-21 05:22:01 | Newton, Texas, US |
2021-01-20 | US | Missouri | Iron | 29093 | 452 | 1 | 0 | 451 | 37.55487945 | -90.7735296 | 2021-01-21 05:22:01 | Iron, Missouri, US |
2021-01-19 | US | Idaho | Lincoln | 16063 | 461 | 10 | 0 | 451 | 43.0012336 | -114.1358773 | 2021-01-20 05:21:54 | Lincoln, Idaho, US |
2021-01-18 | US | North Carolina | Gates | 37073 | 463 | 12 | 0 | 451 | 36.44667547 | -76.69749701 | 2021-01-19 05:22:15 | Gates, North Carolina, US |
2021-01-17 | US | Texas | McCulloch | 48307 | 440 | 12 | 0 | 451 | 31.1925468 | -99.34682807 | 2021-01-18 05:22:34 | McCulloch, Texas, US |
2021-01-17 | US | North Carolina | Gates | 37073 | 463 | 12 | 0 | 451 | 36.44667547 | -76.69749701 | 2021-01-18 05:22:34 | Gates, North Carolina, US |
2021-01-17 | US | Missouri | Iron | 29093 | 452 | 1 | 0 | 451 | 37.55487945 | -90.7735296 | 2021-01-18 05:22:34 | Iron, Missouri, US |
2021-01-17 | US | Colorado | Park | 8093 | 483 | 5 | 0 | 451 | 39.120926 | -105.7182065 | 2021-01-18 05:22:34 | Park, Colorado, US |
2021-01-16 | US | Missouri | Iron | 29093 | 452 | 1 | 0 | 451 | 37.55487945 | -90.7735296 | 2021-01-17 05:22:17 | Iron, Missouri, US |
2021-01-16 | US | Minnesota | Big Stone | 27011 | 454 | 3 | 0 | 451 | 45.42712824 | -96.41403739 | 2021-01-17 05:22:17 | Big Stone, Minnesota, US |
2021-01-13 | US | Kentucky | Trimble | 21223 | 453 | 2 | 0 | 451 | 38.61056487 | -85.33775972 | 2021-01-14 05:22:32 | Trimble, Kentucky, US |
2021-01-11 | US | North Carolina | Jones | 37103 | 467 | 16 | 0 | 451 | 35.02254606 | -77.35870791 | 2021-01-12 05:22:15 | Jones, North Carolina, US |
2021-01-08 | US | Oklahoma | Cotton | 40033 | 462 | 11 | 0 | 451 | 34.28845626 | -98.37053567 | 2021-01-09 05:22:18 | Cotton, Oklahoma, US |
2021-01-07 | US | Kansas | Greenwood | 20073 | 457 | 6 | 0 | 451 | 37.8774388 | -96.23250453 | 2021-01-08 05:22:42 | Greenwood, Kansas, US |
2021-01-07 | Japan | Okinawa | 5677 | 84 | 5142 | 451 | 25.768923 | 126.668016 | 2021-01-08 05:22:42 | Okinawa, Japan | ||
2021-01-06 | US | Kansas | Greenwood | 20073 | 457 | 6 | 0 | 451 | 37.8774388 | -96.23250453 | 2021-01-07 05:22:03 | Greenwood, Kansas, US |
2021-01-06 | US | Iowa | Decatur | 19053 | 455 | 4 | 0 | 451 | 40.73742757 | -93.78645949 | 2021-01-07 05:22:03 | Decatur, Iowa, US |
2021-01-05 | US | Texas | San Jacinto | 48407 | 1060 | 19 | 0 | 451 | 30.57933681 | -95.16260304 | 2021-01-06 05:22:16 | San Jacinto, Texas, US |
2021-01-04 | US | Iowa | Van Buren | 19177 | 463 | 12 | 0 | 451 | 40.75326764 | -91.95017958 | 2021-01-05 05:21:49 | Van Buren, Iowa, US |
2021-01-03 | Colombia | Casanare | 8905 | 184 | 8270 | 451 | 5.7589 | -71.5724 | 2021-01-04 05:22:02 | Casanare, Colombia | ||
2021-01-02 | US | Illinois | Brown | 17009 | 456 | 5 | 0 | 451 | 39.96209138 | -90.75068024 | 2021-01-03 05:22:52 | Brown, Illinois, US |
2021-01-01 | US | Michigan | Crawford | 26039 | 457 | 6 | 0 | 451 | 44.68255561 | -84.61006219 | 2021-01-02 05:22:33 | Crawford, Michigan, US |
2020-12-31 | US | Michigan | Crawford | 26039 | 457 | 6 | 0 | 451 | 44.68255561 | -84.61006219 | 2021-01-01 05:23:07 | Crawford, Michigan, US |
2020-12-30 | US | Puerto Rico | Yauco | 72153 | 451 | 0 | 0 | 451 | 18.080374 | -66.858814 | 2020-12-31 05:22:49 | Yauco, Puerto Rico, US |
2020-12-30 | US | Mississippi | Jefferson | 28063 | 465 | 14 | 0 | 451 | 31.73397872 | -91.03764977 | 2020-12-31 05:22:49 | Jefferson, Mississippi, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;