johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
445 rows where active = 460 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
70749 | 70749 | 2021-09-01 | Malaysia | W.P. Putrajaya | 5431 | 22 | 4949 | 460 | 2.9264 | 101.6964 | 2021-09-02 04:21:15 | W.P. Putrajaya, Malaysia | ||
3904090 | 3904090 | 2021-07-31 | Netherlands | Aruba | 11730 | 110 | 11160 | 460 | 12.5211 | -69.9683 | 2021-08-01 04:21:50 | Aruba, Netherlands | ||
1305995 | 1305995 | 2021-07-27 | Colombia | Caqueta | 21934 | 872 | 20602 | 460 | 0.8699 | -73.8419 | 2021-07-28 04:21:39 | Caqueta, Colombia | ||
3479998 | 3479998 | 2021-07-22 | Malaysia | W.P. Labuan | 9526 | 143 | 8923 | 460 | 5.2831 | 115.2308 | 2021-07-23 04:21:29 | W.P. Labuan, Malaysia | ||
578753 | 578753 | 2021-07-13 | Germany | Schleswig-Holstein | 64094 | 1627 | 62050 | 460 | 54.2194 | 9.6961 | 2021-07-14 04:21:35 | Schleswig-Holstein, Germany | ||
2295725 | 2295725 | 2021-06-24 | Senegal | 42677 | 1159 | 41058 | 460 | 14.4974 | -14.4524 | 2021-06-25 04:21:33 | Senegal | |||
2884510 | 2884510 | 2021-06-20 | Pakistan | Azad Jammu and Kashmir | 19967 | 571 | 18936 | 460 | 34.027401 | 73.947253 | 2021-06-21 04:21:41 | Azad Jammu and Kashmir, Pakistan | ||
523062 | 523062 | 2021-06-09 | Russia | Kamchatka Krai | 14781 | 238 | 14083 | 460 | 57.1914882 | 160.03838190000005 | 2021-06-10 04:23:17 | Kamchatka Krai, Russia | ||
2586201 | 2586201 | 2021-06-05 | Russia | Komi Republic | 44319 | 968 | 42891 | 460 | 63.9881421 | 54.3326073 | 2021-06-06 04:24:03 | Komi Republic, Russia | ||
2104381 | 2104381 | 2021-06-01 | Russia | Tula Oblast | 40185 | 2041 | 37684 | 460 | 53.9570701 | 37.3690909 | 2021-06-02 04:24:34 | Tula Oblast, Russia | ||
1771350 | 1771350 | 2021-05-23 | Japan | Fukushima | 4446 | 133 | 3853 | 460 | 37.378867 | 140.223295 | 2021-05-24 04:20:53 | Fukushima, Japan | ||
1873140 | 1873140 | 2021-05-15 | Russia | Amur Oblast | 22501 | 288 | 21753 | 460 | 52.8032368 | 128.437295 | 2021-05-16 04:20:49 | Amur Oblast, Russia | ||
2450795 | 2450795 | 2021-05-02 | Japan | Miyagi | 8118 | 69 | 7589 | 460 | 38.446859 | 140.927086 | 2021-05-03 04:20:39 | Miyagi, Japan | ||
1412717 | 1412717 | 2021-04-23 | Malaysia | Kedah | 9363 | 25 | 8878 | 460 | 6.1184 | 100.3685 | 2021-04-24 04:20:38 | Kedah, Malaysia | ||
3242017 | 3242017 | 2021-04-21 | Andorra | 12917 | 123 | 12334 | 460 | 42.5063 | 1.5218 | 2021-04-22 04:20:53 | Andorra | |||
3003203 | 3003203 | 2021-04-06 | France | Reunion | 16586 | 115 | 16011 | 460 | -21.1151 | 55.5364 | 2021-04-07 04:20:53 | Reunion, France | ||
2780882 | 2780882 | 2021-03-24 | Eswatini | 17301 | 666 | 16175 | 460 | -26.5225 | 31.4659 | 2021-03-25 05:27:00 | Eswatini | |||
702428 | 702428 | 2021-03-16 | Japan | Miyagi | 4185 | 26 | 3699 | 460 | 38.446859 | 140.927086 | 2021-03-17 05:25:07 | Miyagi, Japan | ||
3670473 | 3670473 | 2021-03-06 | US | South Dakota | Corson | 46031 | 472 | 12 | 0 | 460 | 45.70889983 | -101.1970473 | 2021-03-07 05:21:54 | Corson, South Dakota, US |
3669525 | 3669525 | 2021-03-06 | US | Missouri | Iron | 29093 | 465 | 5 | 0 | 460 | 37.55487945 | -90.7735296 | 2021-03-07 05:21:54 | Iron, Missouri, US |
1618146 | 1618146 | 2021-03-05 | US | Missouri | Iron | 29093 | 465 | 5 | 0 | 460 | 37.55487945 | -90.7735296 | 2021-03-06 04:23:41 | Iron, Missouri, US |
1617688 | 1617688 | 2021-03-05 | US | Kentucky | Nicholas | 21181 | 466 | 6 | 0 | 460 | 38.33342292 | -84.01889177 | 2021-03-06 04:23:41 | Nicholas, Kentucky, US |
1091978 | 1091978 | 2021-03-03 | US | Missouri | Iron | 29093 | 465 | 5 | 0 | 460 | 37.55487945 | -90.7735296 | 2021-03-04 05:24:24 | Iron, Missouri, US |
3256050 | 3256050 | 2021-03-02 | US | Missouri | Iron | 29093 | 465 | 5 | 0 | 460 | 37.55487945 | -90.7735296 | 2021-03-03 05:23:28 | Iron, Missouri, US |
1000550 | 1000550 | 2021-03-01 | US | Nebraska | Sheridan | 31161 | 477 | 17 | 0 | 460 | 42.50284406 | -102.4126613 | 2021-03-02 05:23:30 | Sheridan, Nebraska, US |
2369608 | 2369608 | 2021-02-28 | US | Nebraska | Sheridan | 31161 | 477 | 17 | 0 | 460 | 42.50284406 | -102.4126613 | 2021-03-01 05:23:01 | Sheridan, Nebraska, US |
2187051 | 2187051 | 2021-02-26 | US | West Virginia | Doddridge | 54017 | 466 | 6 | 0 | 460 | 39.27057157 | -80.70671527 | 2021-02-27 05:22:28 | Doddridge, West Virginia, US |
2185694 | 2185694 | 2021-02-26 | US | Nebraska | Sheridan | 31161 | 477 | 17 | 0 | 460 | 42.50284406 | -102.4126613 | 2021-02-27 05:22:28 | Sheridan, Nebraska, US |
2185643 | 2185643 | 2021-02-26 | US | Nebraska | Fillmore | 31059 | 470 | 10 | 0 | 460 | 40.52458567 | -97.59646937 | 2021-02-27 05:22:28 | Fillmore, Nebraska, US |
2184735 | 2184735 | 2021-02-26 | US | Iowa | Audubon | 19009 | 469 | 9 | 0 | 460 | 41.6844628 | -94.90581859 | 2021-02-27 05:22:28 | Audubon, Iowa, US |
1861473 | 1861473 | 2021-02-25 | US | West Virginia | Doddridge | 54017 | 466 | 6 | 0 | 460 | 39.27057157 | -80.70671527 | 2021-02-26 05:22:40 | Doddridge, West Virginia, US |
1860065 | 1860065 | 2021-02-25 | US | Nebraska | Fillmore | 31059 | 469 | 9 | 0 | 460 | 40.52458567 | -97.59646937 | 2021-02-26 05:22:40 | Fillmore, Nebraska, US |
283651 | 283651 | 2021-02-24 | US | West Virginia | Doddridge | 54017 | 466 | 6 | 0 | 460 | 39.27057157 | -80.70671527 | 2021-02-25 05:24:57 | Doddridge, West Virginia, US |
1938354 | 1938354 | 2021-02-23 | US | Missouri | Iron | 29093 | 465 | 5 | 0 | 460 | 37.55487945 | -90.7735296 | 2021-02-24 05:29:16 | Iron, Missouri, US |
532738 | 532738 | 2021-02-22 | US | Nebraska | Antelope | 31003 | 466 | 6 | 0 | 460 | 42.17695516 | -98.0666283 | 2021-02-23 05:23:41 | Antelope, Nebraska, US |
184100 | 184100 | 2021-02-21 | US | Nebraska | Fillmore | 31059 | 469 | 9 | 0 | 460 | 40.52458567 | -97.59646937 | 2021-02-22 05:24:21 | Fillmore, Nebraska, US |
184072 | 184072 | 2021-02-21 | US | Nebraska | Antelope | 31003 | 466 | 6 | 0 | 460 | 42.17695516 | -98.0666283 | 2021-02-22 05:24:21 | Antelope, Nebraska, US |
183943 | 183943 | 2021-02-21 | US | Missouri | Iron | 29093 | 465 | 5 | 0 | 460 | 37.55487945 | -90.7735296 | 2021-02-22 05:24:21 | Iron, Missouri, US |
183466 | 183466 | 2021-02-21 | US | Kentucky | Lyon | 21143 | 473 | 13 | 0 | 460 | 37.02080035 | -88.07886257 | 2021-02-22 05:24:21 | Lyon, Kentucky, US |
3051887 | 3051887 | 2021-02-16 | US | Minnesota | Grant | 27051 | 468 | 8 | 0 | 460 | 45.93424769 | -96.01139609 | 2021-02-17 05:23:10 | Grant, Minnesota, US |
3050126 | 3050126 | 2021-02-16 | India | Jharkhand | 119394 | 1084 | 117850 | 460 | 23.654536 | 85.557631 | 2021-02-17 05:23:10 | Jharkhand, India | ||
1340178 | 1340178 | 2021-02-15 | US | Missouri | Iron | 29093 | 464 | 4 | 0 | 460 | 37.55487945 | -90.7735296 | 2021-02-16 05:24:38 | Iron, Missouri, US |
1339986 | 1339986 | 2021-02-15 | US | Minnesota | Grant | 27051 | 468 | 8 | 0 | 460 | 45.93424769 | -96.01139609 | 2021-02-16 05:24:38 | Grant, Minnesota, US |
2285137 | 2285137 | 2021-02-14 | US | Minnesota | Grant | 27051 | 468 | 8 | 0 | 460 | 45.93424769 | -96.01139609 | 2021-02-15 05:24:49 | Grant, Minnesota, US |
2680017 | 2680017 | 2021-02-13 | US | New Mexico | Los Alamos | 35028 | 464 | 4 | 0 | 460 | 35.86631386 | -106.3134985 | 2021-02-14 05:23:43 | Los Alamos, New Mexico, US |
3541574 | 3541574 | 2021-02-12 | US | Nebraska | Thayer | 31169 | 463 | 3 | 0 | 460 | 40.17626377 | -97.59504381 | 2021-02-13 05:22:12 | Thayer, Nebraska, US |
2641000 | 2641000 | 2021-02-11 | US | Vermont | Orange | 50017 | 462 | 2 | 0 | 460 | 44.00470222 | -72.37640104 | 2021-02-12 05:23:29 | Orange, Vermont, US |
1675572 | 1675572 | 2021-02-07 | US | Texas | Hudspeth | 48229 | 623 | 11 | 0 | 460 | 31.45628381 | -105.388178 | 2021-02-08 05:22:39 | Hudspeth, Texas, US |
975875 | 975875 | 2021-02-06 | US | Illinois | Calhoun | 17013 | 462 | 2 | 0 | 460 | 39.16840183 | -90.66330078 | 2021-02-07 05:23:00 | Calhoun, Illinois, US |
343778 | 343778 | 2021-02-03 | US | West Virginia | Roane | 54087 | 466 | 6 | 0 | 460 | 38.71622686 | -81.35243568 | 2021-02-04 05:22:26 | Roane, West Virginia, US |
1688004 | 1688004 | 2021-02-02 | US | West Virginia | Roane | 54087 | 466 | 6 | 0 | 460 | 38.71622686 | -81.35243568 | 2021-02-03 05:22:52 | Roane, West Virginia, US |
1678374 | 1678374 | 2021-02-01 | US | Missouri | Iron | 29093 | 461 | 1 | 0 | 460 | 37.55487945 | -90.7735296 | 2021-02-02 05:22:49 | Iron, Missouri, US |
1461662 | 1461662 | 2021-01-31 | US | Missouri | Iron | 29093 | 461 | 1 | 0 | 460 | 37.55487945 | -90.7735296 | 2021-02-01 05:22:53 | Iron, Missouri, US |
2213570 | 2213570 | 2021-01-30 | US | Missouri | Iron | 29093 | 461 | 1 | 0 | 460 | 37.55487945 | -90.7735296 | 2021-01-31 05:22:42 | Iron, Missouri, US |
1899057 | 1899057 | 2021-01-29 | US | Missouri | Iron | 29093 | 461 | 1 | 0 | 460 | 37.55487945 | -90.7735296 | 2021-01-30 05:22:49 | Iron, Missouri, US |
2483979 | 2483979 | 2021-01-28 | US | Montana | Phillips | 30071 | 473 | 13 | 0 | 460 | 48.25936577 | -107.9128511 | 2021-01-29 05:22:23 | Phillips, Montana, US |
2483519 | 2483519 | 2021-01-28 | US | Maine | Lincoln | 23015 | 462 | 2 | 0 | 460 | 44.05996956 | -69.54227124 | 2021-01-29 05:22:23 | Lincoln, Maine, US |
13277 | 13277 | 2021-01-26 | US | Idaho | Lincoln | 16063 | 470 | 10 | 0 | 460 | 43.0012336 | -114.1358773 | 2021-01-27 05:23:41 | Lincoln, Idaho, US |
2570779 | 2570779 | 2021-01-25 | US | Texas | Hudspeth | 48229 | 621 | 9 | 0 | 460 | 31.45628381 | -105.388178 | 2021-01-26 05:22:02 | Hudspeth, Texas, US |
1762411 | 1762411 | 2021-01-24 | US | Texas | Hudspeth | 48229 | 621 | 9 | 0 | 460 | 31.45628381 | -105.388178 | 2021-01-25 05:22:16 | Hudspeth, Texas, US |
1759326 | 1759326 | 2021-01-24 | Japan | Okayama | 2228 | 18 | 1750 | 460 | 34.89246 | 133.826252 | 2021-01-25 05:22:16 | Okayama, Japan | ||
1096123 | 1096123 | 2021-01-20 | US | Nebraska | Boone | 31011 | 464 | 4 | 0 | 460 | 41.70759415 | -98.06737183 | 2021-01-21 05:22:01 | Boone, Nebraska, US |
238352 | 238352 | 2021-01-18 | US | Indiana | Ohio | 18115 | 470 | 10 | 0 | 460 | 38.955305 | -84.96515993 | 2021-01-19 05:22:15 | Ohio, Indiana, US |
3503473 | 3503473 | 2021-01-17 | Netherlands | Aruba | 6435 | 52 | 5923 | 460 | 12.5211 | -69.9683 | 2021-01-18 05:22:34 | Aruba, Netherlands | ||
3102195 | 3102195 | 2021-01-16 | US | Georgia | Calhoun | 13037 | 472 | 12 | 0 | 460 | 31.53169785 | -84.62725131 | 2021-01-17 05:22:17 | Calhoun, Georgia, US |
3518134 | 3518134 | 2021-01-15 | US | Puerto Rico | Guayama | 72057 | 460 | 0 | 0 | 460 | 18.007516 | -66.13390799999999 | 2021-01-16 05:22:40 | Guayama, Puerto Rico, US |
3881040 | 3881040 | 2021-01-14 | US | Kentucky | Trimble | 21223 | 462 | 2 | 0 | 460 | 38.61056487 | -85.33775972 | 2021-01-15 05:22:24 | Trimble, Kentucky, US |
3879774 | 3879774 | 2021-01-14 | Russia | Jewish Autonomous Okrug | 3944 | 80 | 3404 | 460 | 48.57527615 | 132.66307460000002 | 2021-01-15 05:22:24 | Jewish Autonomous Okrug, Russia | ||
777616 | 777616 | 2021-01-12 | US | Vermont | Addison | 50001 | 464 | 4 | 0 | 460 | 44.03217337 | -73.14130877 | 2021-01-13 05:22:15 | Addison, Vermont, US |
774788 | 774788 | 2021-01-12 | US | Arizona | Greenlee | 4011 | 464 | 4 | 0 | 460 | 33.21498827 | -109.2405279 | 2021-01-13 05:22:15 | Greenlee, Arizona, US |
193381 | 193381 | 2021-01-11 | US | Virginia | Covington | 51580 | 464 | 4 | 0 | 460 | 37.7824656 | -79.98631446 | 2021-01-12 05:22:15 | Covington, Virginia, US |
190186 | 190186 | 2021-01-11 | Netherlands | Curacao | 4464 | 19 | 3985 | 460 | 12.1696 | -68.99 | 2021-01-12 05:22:15 | Curacao, Netherlands | ||
3903073 | 3903073 | 2021-01-09 | US | Texas | Hudspeth | 48229 | 620 | 8 | 0 | 460 | 31.45628381 | -105.388178 | 2021-01-10 05:22:12 | Hudspeth, Texas, US |
157354 | 157354 | 2021-01-08 | US | Virginia | Northumberland | 51133 | 470 | 10 | 0 | 460 | 37.89202088 | -76.41949732 | 2021-01-09 05:22:18 | Northumberland, Virginia, US |
154917 | 154917 | 2021-01-08 | US | Idaho | Lemhi | 16059 | 469 | 9 | 0 | 460 | 44.9438088 | -113.9309747 | 2021-01-09 05:22:18 | Lemhi, Idaho, US |
2542959 | 2542959 | 2021-01-07 | US | Maine | Sagadahoc | 23023 | 461 | 1 | 0 | 460 | 43.95415864 | -69.85074999 | 2021-01-08 05:22:42 | Sagadahoc, Maine, US |
2542445 | 2542445 | 2021-01-07 | US | Illinois | Stark | 17175 | 479 | 19 | 0 | 460 | 41.09309773 | -89.79745866 | 2021-01-08 05:22:42 | Stark, Illinois, US |
2542341 | 2542341 | 2021-01-07 | US | Idaho | Lemhi | 16059 | 469 | 9 | 0 | 460 | 44.9438088 | -113.9309747 | 2021-01-08 05:22:42 | Lemhi, Idaho, US |
2865952 | 2865952 | 2021-01-06 | US | Iowa | Van Buren | 19177 | 472 | 12 | 0 | 460 | 40.75326764 | -91.95017958 | 2021-01-07 05:22:03 | Van Buren, Iowa, US |
3037585 | 3037585 | 2021-01-05 | US | Vermont | Windsor | 50027 | 463 | 3 | 0 | 460 | 43.58010937 | -72.58595157 | 2021-01-06 05:22:16 | Windsor, Vermont, US |
1064243 | 1064243 | 2021-01-04 | US | North Dakota | LaMoure | 38045 | 476 | 16 | 0 | 460 | 46.45681054 | -98.53542355 | 2021-01-05 05:21:49 | LaMoure, North Dakota, US |
3232846 | 3232846 | 2021-01-03 | US | North Dakota | LaMoure | 38045 | 473 | 16 | 0 | 460 | 46.45681054 | -98.53542355 | 2021-01-04 05:22:02 | LaMoure, North Dakota, US |
2230122 | 2230122 | 2021-01-02 | US | Oregon | Crook | 41013 | 467 | 7 | 0 | 460 | 44.14230227 | -120.356297 | 2021-01-03 05:22:52 | Crook, Oregon, US |
2229915 | 2229915 | 2021-01-02 | US | North Dakota | LaMoure | 38045 | 473 | 16 | 0 | 460 | 46.45681054 | -98.53542355 | 2021-01-03 05:22:52 | LaMoure, North Dakota, US |
2228024 | 2228024 | 2021-01-02 | US | Arkansas | Perry | 5105 | 465 | 5 | 0 | 460 | 34.9459153 | -92.94372564 | 2021-01-03 05:22:52 | Perry, Arkansas, US |
1140233 | 1140233 | 2021-01-01 | US | Virginia | King William | 51101 | 464 | 4 | 0 | 460 | 37.70965316 | -77.09384941 | 2021-01-02 05:22:33 | King William, Virginia, US |
1138838 | 1138838 | 2021-01-01 | US | Missouri | St. Clair | 29185 | 465 | 5 | 0 | 460 | 38.03699437 | -93.77631447 | 2021-01-02 05:22:33 | St. Clair, Missouri, US |
1010804 | 1010804 | 2020-12-30 | US | Arkansas | Monroe | 5095 | 467 | 7 | 0 | 460 | 34.6815935 | -91.20540287 | 2020-12-31 05:22:49 | Monroe, Arkansas, US |
1010147 | 1010147 | 2020-12-30 | Colombia | Casanare | 8721 | 182 | 8079 | 460 | 5.7589 | -71.5724 | 2020-12-31 05:22:49 | Casanare, Colombia | ||
766243 | 766243 | 2020-12-29 | Germany | Unknown | 460 | 0 | 0 | 460 | 2020-12-30 05:22:34 | Unknown, Germany | ||||
2224412 | 2224412 | 2020-12-26 | US | Hawaii | Out of HI | 80015 | 462 | 2 | 0 | 460 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Out of HI, Hawaii, US |
3693581 | 3693581 | 2020-12-24 | US | Nebraska | Richardson | 31147 | 475 | 15 | 0 | 460 | 40.1247415 | -95.71755036 | 2020-12-25 05:22:48 | Richardson, Nebraska, US |
3693404 | 3693404 | 2020-12-24 | US | Missouri | Montgomery | 29139 | 468 | 8 | 0 | 460 | 38.94022054 | -91.47000721 | 2020-12-25 05:22:48 | Montgomery, Missouri, US |
3691271 | 3691271 | 2020-12-24 | Chile | Magallanes | 16364 | 227 | 15677 | 460 | -52.368 | -70.9863 | 2020-12-25 05:22:48 | Magallanes, Chile | ||
3771235 | 3771235 | 2020-12-22 | US | Kentucky | Bath | 21011 | 462 | 2 | 0 | 460 | 38.14735938 | -83.74588932 | 2020-12-23 05:22:03 | Bath, Kentucky, US |
928514 | 928514 | 2020-12-21 | US | Georgia | Lanier | 13173 | 470 | 10 | 0 | 460 | 31.038285700000007 | -83.06472457 | 2020-12-22 05:22:33 | Lanier, Georgia, US |
2120948 | 2120948 | 2020-12-20 | US | Iowa | Unassigned | 90019 | 460 | 0 | 0 | 460 | 43.38107862 | 0.0 | 2020-12-21 05:27:58 | Unassigned, Iowa, US |
2120255 | 2120255 | 2020-12-20 | US | California | Inyo | 6027 | 483 | 17 | 0 | 460 | 36.51112084 | -117.41119779999998 | 2020-12-21 05:27:58 | Inyo, California, US |
1903755 | 1903755 | 2020-12-18 | US | Oklahoma | Tillman | 40141 | 468 | 8 | 0 | 460 | 34.37288446 | -98.92426619 | 2020-12-19 05:27:52 | Tillman, Oklahoma, US |
1902711 | 1902711 | 2020-12-18 | US | Maine | Hancock | 23009 | 469 | 9 | 0 | 460 | 44.59816444 | -68.38401854 | 2020-12-19 05:27:52 | Hancock, Maine, 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]);