daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
372 rows where active = 663 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-21 | Romania | 1081875 | 34260 | 1046952 | 663 | 45.9432 | 24.9668 | 2021-07-22 04:21:19 | Romania | |||
2021-07-20 | Madagascar | 42551 | 937 | 40951 | 663 | -18.766947 | 46.869107 | 2021-07-21 04:21:40 | Madagascar | |||
2021-07-01 | Italy | Basilicata | 26964 | 590 | 25711 | 663 | 40.63947052 | 15.80514834 | 2021-07-02 04:21:47 | Basilicata, Italy | ||
2021-06-17 | Ukraine | Sevastopol* | 15458 | 706 | 14089 | 663 | 44.6054 | 33.522 | 2021-06-18 04:22:16 | Sevastopol*, Ukraine | ||
2021-06-07 | Japan | Okayama | 7488 | 113 | 6712 | 663 | 34.89246 | 133.826252 | 2021-06-08 04:22:35 | Okayama, Japan | ||
2021-06-01 | Russia | Kurgan Oblast | 21402 | 419 | 20320 | 663 | 55.7655302 | 64.5632681 | 2021-06-02 04:24:34 | Kurgan Oblast, Russia | ||
2021-05-29 | Togo | 13432 | 125 | 12644 | 663 | 8.6195 | 0.8248 | 2021-05-30 04:20:55 | Togo | |||
2021-05-28 | Togo | 13432 | 125 | 12644 | 663 | 8.6195 | 0.8248 | 2021-05-29 04:20:41 | Togo | |||
2021-05-20 | Italy | P.A. Trento | 45067 | 1354 | 43050 | 663 | 46.06893511 | 11.12123097 | 2021-05-21 04:20:43 | P.A. Trento, Italy | ||
2021-05-17 | Japan | Ishikawa | 3249 | 97 | 2489 | 663 | 36.769464 | 136.771027 | 2021-05-18 04:20:33 | Ishikawa, Japan | ||
2021-04-03 | Malaysia | Perak | 13503 | 44 | 12796 | 663 | 4.5921 | 101.0901 | 2021-04-04 04:20:49 | Perak, Malaysia | ||
2021-04-03 | Russia | Kamchatka Krai | 14163 | 201 | 13299 | 663 | 57.1914882 | 160.03838190000005 | 2021-04-04 04:20:49 | Kamchatka Krai, Russia | ||
2021-03-30 | Russia | Mari El Republic | 12521 | 203 | 11655 | 663 | 56.5767504 | 47.8817512 | 2021-03-31 04:26:25 | Mari El Republic, Russia | ||
2021-03-12 | Colombia | Norte de Santander | 51251 | 2737 | 47851 | 663 | 7.9463 | -72.8988 | 2021-03-13 05:25:15 | Norte de Santander, Colombia | ||
2021-03-09 | India | Goa | 55538 | 802 | 54073 | 663 | 15.359682 | 74.057396 | 2021-03-10 05:24:35 | Goa, India | ||
2021-03-06 | US | Virginia | Lunenburg | 51111 | 669 | 6 | 0 | 663 | 36.94618528 | -78.24133319 | 2021-03-07 05:21:54 | Lunenburg, Virginia, US |
2021-03-05 | US | Nebraska | Kearney | 31099 | 668 | 5 | 0 | 663 | 40.50663314 | -98.94877182 | 2021-03-06 04:23:41 | Kearney, Nebraska, US |
2021-03-03 | US | Minnesota | Wilkin | 27167 | 674 | 11 | 0 | 663 | 46.35721532 | -96.4684375 | 2021-03-04 05:24:24 | Wilkin, Minnesota, US |
2021-03-03 | US | Indiana | Union | 18161 | 673 | 10 | 0 | 663 | 39.62550777 | -84.92497066 | 2021-03-04 05:24:24 | Union, Indiana, US |
2021-03-01 | US | Illinois | Pulaski | 17153 | 669 | 6 | 0 | 663 | 37.22631423 | -89.13085001 | 2021-03-02 05:23:30 | Pulaski, Illinois, US |
2021-02-28 | US | Texas | Blanco | 48031 | 753 | 18 | 0 | 663 | 30.26640707 | -98.3999852 | 2021-03-01 05:23:01 | Blanco, Texas, US |
2021-02-27 | US | Texas | Blanco | 48031 | 753 | 18 | 0 | 663 | 30.26640707 | -98.3999852 | 2021-02-28 05:22:20 | Blanco, Texas, US |
2021-02-26 | US | New Mexico | Colfax | 35007 | 708 | 45 | 0 | 663 | 36.60569702 | -104.64726740000002 | 2021-02-27 05:22:28 | Colfax, New Mexico, US |
2021-02-26 | US | Iowa | Osceola | 19143 | 677 | 14 | 0 | 663 | 43.37824276 | -95.62422844 | 2021-02-27 05:22:28 | Osceola, Iowa, US |
2021-02-25 | US | Oklahoma | Jefferson | 40067 | 673 | 10 | 0 | 663 | 34.11130184 | -97.83182974 | 2021-02-26 05:22:40 | Jefferson, Oklahoma, US |
2021-02-25 | US | Arkansas | Newton | 5101 | 689 | 26 | 0 | 663 | 35.91947491 | -93.21612969 | 2021-02-26 05:22:40 | Newton, Arkansas, US |
2021-02-24 | US | Texas | Franklin | 48159 | 805 | 24 | 0 | 663 | 33.17653242 | -95.21917243 | 2021-02-25 05:24:57 | Franklin, Texas, US |
2021-02-24 | US | South Dakota | Hamlin | 46057 | 701 | 38 | 0 | 663 | 44.67385954 | -97.18829593 | 2021-02-25 05:24:57 | Hamlin, South Dakota, US |
2021-02-24 | US | Oklahoma | Jefferson | 40067 | 673 | 10 | 0 | 663 | 34.11130184 | -97.83182974 | 2021-02-25 05:24:57 | Jefferson, Oklahoma, US |
2021-02-24 | US | Arkansas | Newton | 5101 | 689 | 26 | 0 | 663 | 35.91947491 | -93.21612969 | 2021-02-25 05:24:57 | Newton, Arkansas, US |
2021-02-23 | US | Oklahoma | Jefferson | 40067 | 671 | 8 | 0 | 663 | 34.11130184 | -97.83182974 | 2021-02-24 05:29:16 | Jefferson, Oklahoma, US |
2021-02-23 | US | Minnesota | Lac qui Parle | 27073 | 679 | 16 | 0 | 663 | 44.9973857 | -96.17488219 | 2021-02-24 05:29:16 | Lac qui Parle, Minnesota, US |
2021-02-23 | US | Arkansas | Newton | 5101 | 689 | 26 | 0 | 663 | 35.91947491 | -93.21612969 | 2021-02-24 05:29:16 | Newton, Arkansas, US |
2021-02-22 | Ukraine | Sevastopol* | 11567 | 475 | 10429 | 663 | 44.6054 | 33.522 | 2021-02-23 05:23:41 | Sevastopol*, Ukraine | ||
2021-02-22 | US | Minnesota | Lac qui Parle | 27073 | 679 | 16 | 0 | 663 | 44.9973857 | -96.17488219 | 2021-02-23 05:23:41 | Lac qui Parle, Minnesota, US |
2021-02-22 | US | Illinois | Pulaski | 17153 | 668 | 5 | 0 | 663 | 37.22631423 | -89.13085001 | 2021-02-23 05:23:41 | Pulaski, Illinois, US |
2021-02-21 | US | Minnesota | Lac qui Parle | 27073 | 679 | 16 | 0 | 663 | 44.9973857 | -96.17488219 | 2021-02-22 05:24:21 | Lac qui Parle, Minnesota, US |
2021-02-21 | US | Illinois | Pulaski | 17153 | 668 | 5 | 0 | 663 | 37.22631423 | -89.13085001 | 2021-02-22 05:24:21 | Pulaski, Illinois, US |
2021-02-19 | US | Nebraska | Dawes | 31045 | 681 | 18 | 0 | 663 | 42.71985036 | -103.1313774 | 2021-02-20 05:22:51 | Dawes, Nebraska, US |
2021-02-19 | US | Colorado | Rio Grande | 8105 | 715 | 13 | 0 | 663 | 37.5836865 | -106.3847838 | 2021-02-20 05:22:51 | Rio Grande, Colorado, US |
2021-02-19 | Colombia | Bolivar | 66237 | 1339 | 64235 | 663 | 8.6704 | -74.03 | 2021-02-20 05:22:51 | Bolivar, Colombia | ||
2021-02-18 | US | Kansas | Phillips | 20147 | 685 | 22 | 0 | 663 | 39.78465501 | -99.34668865 | 2021-02-19 05:24:16 | Phillips, Kansas, US |
2021-02-17 | US | Oklahoma | Coal | 40029 | 676 | 13 | 0 | 663 | 34.58840127 | -96.29798747 | 2021-02-18 05:22:58 | Coal, Oklahoma, US |
2021-02-17 | US | Kansas | Phillips | 20147 | 685 | 22 | 0 | 663 | 39.78465501 | -99.34668865 | 2021-02-18 05:22:58 | Phillips, Kansas, US |
2021-02-13 | US | Puerto Rico | Utuado | 72141 | 663 | 0 | 0 | 663 | 18.271214 | -66.702984 | 2021-02-14 05:23:43 | Utuado, Puerto Rico, US |
2021-02-11 | US | Kansas | Coffey | 20031 | 677 | 14 | 0 | 663 | 38.2365018 | -95.73379515 | 2021-02-12 05:23:29 | Coffey, Kansas, US |
2021-02-10 | US | West Virginia | Summers | 54089 | 684 | 21 | 0 | 663 | 37.65390597 | -80.86009693 | 2021-02-11 05:23:55 | Summers, West Virginia, US |
2021-02-10 | US | Montana | Stillwater | 30095 | 675 | 12 | 0 | 663 | 45.67071407 | -109.3950061 | 2021-02-11 05:23:55 | Stillwater, Montana, US |
2021-02-10 | US | Missouri | Oregon | 29149 | 666 | 3 | 0 | 663 | 36.68710164 | -91.4033755 | 2021-02-11 05:23:55 | Oregon, Missouri, US |
2021-02-10 | US | Kansas | Coffey | 20031 | 677 | 14 | 0 | 663 | 38.2365018 | -95.73379515 | 2021-02-11 05:23:55 | Coffey, Kansas, US |
2021-02-09 | US | Montana | Stillwater | 30095 | 675 | 12 | 0 | 663 | 45.67071407 | -109.3950061 | 2021-02-10 05:22:41 | Stillwater, Montana, US |
2021-02-08 | US | Colorado | Yuma | 8125 | 817 | 17 | 0 | 663 | 40.00346839 | -102.4258673 | 2021-02-09 05:23:30 | Yuma, Colorado, US |
2021-02-07 | Ukraine | Sevastopol* | 10384 | 417 | 9304 | 663 | 44.6054 | 33.522 | 2021-02-08 05:22:39 | Sevastopol*, Ukraine | ||
2021-02-06 | US | Kentucky | Livingston | 21139 | 679 | 16 | 0 | 663 | 37.21137452 | -88.34797529 | 2021-02-07 05:23:00 | Livingston, Kentucky, US |
2021-02-06 | US | Georgia | Lincoln | 13181 | 682 | 19 | 0 | 663 | 33.79201475 | -82.45024131 | 2021-02-07 05:23:00 | Lincoln, Georgia, US |
2021-02-04 | US | Washington | Pacific | 53049 | 671 | 8 | 0 | 663 | 46.55418369 | -123.7285716 | 2021-02-05 05:22:38 | Pacific, Washington, US |
2021-02-04 | US | Georgia | Lincoln | 13181 | 681 | 18 | 0 | 663 | 33.79201475 | -82.45024131 | 2021-02-05 05:22:38 | Lincoln, Georgia, US |
2021-02-03 | US | Georgia | Terrell | 13273 | 700 | 37 | 0 | 663 | 31.77527543 | -84.44069698 | 2021-02-04 05:22:26 | Terrell, Georgia, US |
2021-02-02 | US | Texas | Floyd | 48153 | 914 | 29 | 0 | 663 | 34.07227468 | -101.3031546 | 2021-02-03 05:22:52 | Floyd, Texas, US |
2021-02-02 | Andorra | 10017 | 102 | 9252 | 663 | 42.5063 | 1.5218 | 2021-02-03 05:22:52 | Andorra | |||
2021-01-30 | US | Virginia | Clarke | 51043 | 671 | 8 | 0 | 663 | 39.11271747 | -77.99199425 | 2021-01-31 05:22:42 | Clarke, Virginia, US |
2021-01-28 | US | Texas | Presidio | 48377 | 620 | 22 | 0 | 663 | 29.99954402 | -104.2408079 | 2021-01-29 05:22:23 | Presidio, Texas, US |
2021-01-28 | US | Iowa | Lucas | 19117 | 674 | 11 | 0 | 663 | 41.02958964 | -93.32780803 | 2021-01-29 05:22:23 | Lucas, Iowa, US |
2021-01-28 | US | Arkansas | Perry | 5105 | 670 | 7 | 0 | 663 | 34.9459153 | -92.94372564 | 2021-01-29 05:22:23 | Perry, Arkansas, US |
2021-01-26 | US | Indiana | Switzerland | 18155 | 669 | 6 | 0 | 663 | 38.82767338 | -85.03022429 | 2021-01-27 05:23:41 | Switzerland, Indiana, US |
2021-01-25 | US | Indiana | Switzerland | 18155 | 669 | 6 | 0 | 663 | 38.82767338 | -85.03022429 | 2021-01-26 05:22:02 | Switzerland, Indiana, US |
2021-01-24 | US | Arkansas | Nevada | 5099 | 686 | 23 | 0 | 663 | 33.66340119 | -93.30632432 | 2021-01-25 05:22:16 | Nevada, Arkansas, US |
2021-01-23 | Burundi | 1438 | 2 | 773 | 663 | -3.3731 | 29.9189 | 2021-01-24 05:22:35 | Burundi | |||
2021-01-22 | US | Virginia | Buena Vista | 51530 | 672 | 9 | 0 | 663 | 37.73484642 | -79.35296097 | 2021-01-23 05:22:03 | Buena Vista, Virginia, US |
2021-01-21 | US | Texas | Morris | 48343 | 824 | 15 | 0 | 663 | 33.11304005 | -94.73255695 | 2021-01-22 05:22:10 | Morris, Texas, US |
2021-01-18 | US | Oklahoma | Unassigned | 90040 | 663 | 0 | 0 | 663 | 36.83532655 | 0.0 | 2021-01-19 05:22:15 | Unassigned, Oklahoma, US |
2021-01-18 | US | Missouri | Gentry | 29075 | 680 | 17 | 0 | 663 | 40.21097916 | -94.40944419 | 2021-01-19 05:22:15 | Gentry, Missouri, US |
2021-01-15 | US | Iowa | Davis | 19051 | 684 | 21 | 0 | 663 | 40.74773536 | -92.41005468 | 2021-01-16 05:22:40 | Davis, Iowa, US |
2021-01-14 | US | Nebraska | Merrick | 31121 | 674 | 11 | 0 | 663 | 41.16624273 | -98.0374887 | 2021-01-15 05:22:24 | Merrick, Nebraska, US |
2021-01-13 | US | Vermont | Bennington | 50003 | 666 | 3 | 0 | 663 | 43.03519828 | -73.09048868 | 2021-01-14 05:22:32 | Bennington, Vermont, US |
2021-01-06 | US | New York | Essex | 36031 | 679 | 16 | 0 | 663 | 44.11630765 | -73.77297842 | 2021-01-07 05:22:03 | Essex, New York, US |
2021-01-05 | US | Puerto Rico | Aguas Buenas | 72007 | 663 | 0 | 0 | 663 | 18.251619 | -66.126806 | 2021-01-06 05:22:16 | Aguas Buenas, Puerto Rico, US |
2021-01-05 | US | North Dakota | Dickey | 38021 | 693 | 32 | 0 | 663 | 46.11017712 | -98.5049008 | 2021-01-06 05:22:16 | Dickey, North Dakota, US |
2021-01-03 | US | Georgia | Dooly | 13093 | 688 | 25 | 0 | 663 | 32.15630737 | -83.79746561 | 2021-01-04 05:22:02 | Dooly, Georgia, US |
2021-01-03 | Japan | Okayama | 1440 | 15 | 762 | 663 | 34.89246 | 133.826252 | 2021-01-04 05:22:02 | Okayama, Japan | ||
2021-01-02 | US | Missouri | Gasconade | 29073 | 692 | 29 | 0 | 663 | 38.43947277 | -91.50847147 | 2021-01-03 05:22:52 | Gasconade, Missouri, US |
2021-01-01 | US | Virginia | Franklin City | 51620 | 680 | 17 | 0 | 663 | 36.6831435 | -76.93859681 | 2021-01-02 05:22:33 | Franklin City, Virginia, US |
2021-01-01 | US | South Dakota | Custer | 46033 | 672 | 9 | 0 | 663 | 43.67741105 | -103.4534521 | 2021-01-02 05:22:33 | Custer, South Dakota, US |
2021-01-01 | US | Minnesota | Marshall | 27089 | 675 | 12 | 0 | 663 | 48.35825983 | -96.37017407 | 2021-01-02 05:22:33 | Marshall, Minnesota, US |
2020-12-31 | US | South Dakota | Custer | 46033 | 672 | 9 | 0 | 663 | 43.67741105 | -103.4534521 | 2021-01-01 05:23:07 | Custer, South Dakota, US |
2020-12-31 | US | Minnesota | Marshall | 27089 | 675 | 12 | 0 | 663 | 48.35825983 | -96.37017407 | 2021-01-01 05:23:07 | Marshall, Minnesota, US |
2020-12-30 | US | South Dakota | Custer | 46033 | 672 | 9 | 0 | 663 | 43.67741105 | -103.4534521 | 2020-12-31 05:22:49 | Custer, South Dakota, US |
2020-12-29 | Russia | Altai Republic | 13719 | 95 | 12961 | 663 | 50.7114101 | 86.8572186 | 2020-12-30 05:22:34 | Altai Republic, Russia | ||
2020-12-28 | US | Montana | Toole | 30101 | 671 | 8 | 0 | 663 | 48.65577551 | -111.6942414 | 2020-12-29 05:22:37 | Toole, Montana, US |
2020-12-28 | US | Iowa | Ida | 19093 | 685 | 22 | 0 | 663 | 42.38696136 | -95.51355387 | 2020-12-29 05:22:37 | Ida, Iowa, US |
2020-12-25 | US | Montana | Toole | 30101 | 671 | 8 | 0 | 663 | 48.65577551 | -111.6942414 | 2020-12-26 05:22:28 | Toole, Montana, US |
2020-12-24 | US | Montana | Toole | 30101 | 671 | 8 | 0 | 663 | 48.65577551 | -111.6942414 | 2020-12-25 05:22:48 | Toole, Montana, US |
2020-12-24 | US | Missouri | Dent | 29065 | 670 | 7 | 0 | 663 | 37.60663134 | -91.50790473 | 2020-12-25 05:22:48 | Dent, Missouri, US |
2020-12-24 | US | Maine | Somerset | 23025 | 684 | 21 | 0 | 663 | 45.51229767 | -69.95995554 | 2020-12-25 05:22:48 | Somerset, Maine, US |
2020-12-23 | US | New York | Washington | 36115 | 677 | 14 | 0 | 663 | 43.31153794 | -73.43043448 | 2020-12-24 05:23:04 | Washington, New York, US |
2020-12-22 | US | West Virginia | Lincoln | 54043 | 671 | 8 | 0 | 663 | 38.172154 | -82.07017953 | 2020-12-23 05:22:03 | Lincoln, West Virginia, US |
2020-12-21 | US | South Dakota | Spink | 46115 | 685 | 22 | 0 | 663 | 44.93837606 | -98.34626602 | 2020-12-22 05:22:33 | Spink, South Dakota, US |
2020-12-20 | US | Kentucky | Lewis | 21135 | 685 | 22 | 0 | 663 | 38.53184419 | -83.37735618 | 2020-12-21 05:27:58 | Lewis, Kentucky, US |
2020-12-20 | US | Illinois | Menard | 17129 | 668 | 5 | 0 | 663 | 40.02742725 | -89.80246001 | 2020-12-21 05:27:58 | Menard, Illinois, US |
2020-12-19 | US | Virginia | Powhatan | 51145 | 669 | 6 | 0 | 663 | 37.55016038 | -77.91267882 | 2020-12-20 05:27:32 | Powhatan, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;