daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
364 rows where active = 657 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2021-07-25 | Ukraine | Kharkiv Oblast | 149158 | 3591 | 144910 | 657 | 49.9935 | 36.2304 | 2021-07-26 04:21:28 | Kharkiv Oblast, Ukraine | ||
2021-07-23 | Netherlands | Curacao | 13135 | 126 | 12352 | 657 | 12.1696 | -68.99 | 2021-07-24 00:21:36 | Curacao, Netherlands | ||
2021-07-16 | India | Delhi | 1435419 | 25023 | 1409739 | 657 | 28.646519 | 77.10898 | 2021-07-17 04:22:22 | Delhi, India | ||
2021-06-30 | Italy | Basilicata | 26948 | 590 | 25701 | 657 | 40.63947052 | 15.80514834 | 2021-07-01 04:21:19 | Basilicata, Italy | ||
2021-06-30 | Chile | Atacama | 24650 | 278 | 23715 | 657 | -27.5661 | -70.0503 | 2021-07-01 04:21:19 | Atacama, Chile | ||
2021-06-26 | Japan | Fukuoka | 35414 | 519 | 34238 | 657 | 33.526032 | 130.666949 | 2021-06-27 04:21:39 | Fukuoka, Japan | ||
2021-06-16 | Russia | Yamalo-Nenets Autonomous Okrug | 39468 | 424 | 38387 | 657 | 67.1471631 | 74.3415488 | 2021-06-17 04:22:36 | Yamalo-Nenets Autonomous Okrug, Russia | ||
2021-05-15 | Japan | Ishikawa | 3174 | 96 | 2421 | 657 | 36.769464 | 136.771027 | 2021-05-16 04:20:49 | Ishikawa, Japan | ||
2021-05-08 | Colombia | Cauca | 31267 | 837 | 29773 | 657 | 2.705 | -76.82600000000002 | 2021-05-09 04:20:35 | Cauca, Colombia | ||
2021-05-07 | Colombia | Casanare | 16255 | 362 | 15236 | 657 | 5.7589 | -71.5724 | 2021-05-08 04:21:04 | Casanare, Colombia | ||
2021-05-02 | Russia | Smolensk Oblast | 29549 | 897 | 27995 | 657 | 55.03434960000001 | 33.0192065 | 2021-05-03 04:20:39 | Smolensk Oblast, Russia | ||
2021-04-18 | Colombia | Meta | 45031 | 1029 | 43345 | 657 | 3.272 | -73.0877 | 2021-04-19 04:20:57 | Meta, Colombia | ||
2021-04-04 | Colombia | Bolivar | 70166 | 1414 | 68095 | 657 | 8.6704 | -74.03 | 2021-04-05 04:20:35 | Bolivar, Colombia | ||
2021-03-31 | Russia | Tyva Republic | 15761 | 197 | 14907 | 657 | 51.4017149 | 93.8582593 | 2021-04-01 04:27:05 | Tyva Republic, Russia | ||
2021-03-19 | Guinea-Bissau | 3536 | 55 | 2824 | 657 | 11.8037 | -15.1804 | 2021-03-20 05:25:46 | Guinea-Bissau | |||
2021-03-13 | Cambodia | 1305 | 1 | 647 | 657 | 11.55 | 104.9167 | 2021-03-14 05:25:37 | Cambodia | |||
2021-03-05 | US | Virginia | Lancaster | 51103 | 670 | 13 | 0 | 657 | 37.71889653 | -76.46400482 | 2021-03-06 04:23:41 | Lancaster, Virginia, US |
2021-03-04 | US | Virginia | Lancaster | 51103 | 670 | 13 | 0 | 657 | 37.71889653 | -76.46400482 | 2021-03-05 05:26:29 | Lancaster, Virginia, US |
2021-03-04 | US | Oregon | Baker | 41001 | 666 | 9 | 0 | 657 | 44.70915557 | -117.6749883 | 2021-03-05 05:26:29 | Baker, Oregon, US |
2021-03-04 | US | New Mexico | Sierra | 35051 | 702 | 45 | 0 | 657 | 33.13028233 | -107.1925893 | 2021-03-05 05:26:29 | Sierra, New Mexico, US |
2021-03-04 | US | New Mexico | Colfax | 35007 | 703 | 46 | 0 | 657 | 36.60569702 | -104.64726740000002 | 2021-03-05 05:26:29 | Colfax, New Mexico, US |
2021-03-01 | US | Illinois | Brown | 17009 | 663 | 6 | 0 | 657 | 39.96209138 | -90.75068024 | 2021-03-02 05:23:30 | Brown, Illinois, US |
2021-02-28 | US | Illinois | Brown | 17009 | 663 | 6 | 0 | 657 | 39.96209138 | -90.75068024 | 2021-03-01 05:23:01 | Brown, Illinois, US |
2021-02-27 | US | Illinois | Brown | 17009 | 663 | 6 | 0 | 657 | 39.96209138 | -90.75068024 | 2021-02-28 05:22:20 | Brown, Illinois, US |
2021-02-26 | US | Minnesota | Wilkin | 27167 | 667 | 10 | 0 | 657 | 46.35721532 | -96.4684375 | 2021-02-27 05:22:28 | Wilkin, Minnesota, US |
2021-02-26 | US | Colorado | Lake | 8065 | 673 | 0 | 0 | 657 | 39.20278823 | -106.3555697 | 2021-02-27 05:22:28 | Lake, Colorado, US |
2021-02-23 | US | North Dakota | Bottineau | 38009 | 682 | 20 | 0 | 657 | 48.79106111 | -100.8378166 | 2021-02-24 05:29:16 | Bottineau, North Dakota, US |
2021-02-22 | US | South Dakota | Hamlin | 46057 | 695 | 38 | 0 | 657 | 44.67385954 | -97.18829593 | 2021-02-23 05:23:41 | Hamlin, South Dakota, US |
2021-02-21 | US | South Dakota | Hamlin | 46057 | 695 | 38 | 0 | 657 | 44.67385954 | -97.18829593 | 2021-02-22 05:24:21 | Hamlin, South Dakota, US |
2021-02-18 | US | Virginia | Northampton | 51131 | 689 | 32 | 0 | 657 | 37.34062933 | -75.87751591 | 2021-02-19 05:24:16 | Northampton, Virginia, US |
2021-02-17 | India | Jammu and Kashmir | 125547 | 1951 | 122939 | 657 | 33.75943 | 76.612638 | 2021-02-18 05:22:58 | Jammu and Kashmir, India | ||
2021-02-16 | US | Texas | Blanco | 48031 | 745 | 16 | 0 | 657 | 30.26640707 | -98.3999852 | 2021-02-17 05:23:10 | Blanco, Texas, US |
2021-02-16 | US | Kansas | Phillips | 20147 | 679 | 22 | 0 | 657 | 39.78465501 | -99.34668865 | 2021-02-17 05:23:10 | Phillips, Kansas, US |
2021-02-15 | US | Kansas | Phillips | 20147 | 679 | 22 | 0 | 657 | 39.78465501 | -99.34668865 | 2021-02-16 05:24:38 | Phillips, Kansas, US |
2021-02-14 | US | Vermont | Addison | 50001 | 665 | 8 | 0 | 657 | 44.03217337 | -73.14130877 | 2021-02-15 05:24:49 | Addison, Vermont, US |
2021-02-14 | US | Montana | Madison | 30057 | 664 | 7 | 0 | 657 | 45.30080065 | -111.9173017 | 2021-02-15 05:24:49 | Madison, Montana, US |
2021-02-12 | US | Virginia | Poquoson | 51735 | 667 | 10 | 0 | 657 | 37.14259351 | -76.35798148 | 2021-02-13 05:22:12 | Poquoson, Virginia, US |
2021-02-12 | US | South Dakota | Tripp | 46123 | 672 | 15 | 0 | 657 | 43.34459388 | -99.8854891 | 2021-02-13 05:22:12 | Tripp, South Dakota, US |
2021-02-12 | US | Minnesota | Lac qui Parle | 27073 | 673 | 16 | 0 | 657 | 44.9973857 | -96.17488219 | 2021-02-13 05:22:12 | Lac qui Parle, Minnesota, US |
2021-02-11 | US | Oklahoma | Coal | 40029 | 669 | 12 | 0 | 657 | 34.58840127 | -96.29798747 | 2021-02-12 05:23:29 | Coal, Oklahoma, US |
2021-02-11 | US | Minnesota | Lac qui Parle | 27073 | 673 | 16 | 0 | 657 | 44.9973857 | -96.17488219 | 2021-02-12 05:23:29 | Lac qui Parle, Minnesota, US |
2021-02-11 | US | Illinois | Pulaski | 17153 | 661 | 4 | 0 | 657 | 37.22631423 | -89.13085001 | 2021-02-12 05:23:29 | Pulaski, Illinois, US |
2021-02-10 | US | Oklahoma | Coal | 40029 | 667 | 10 | 0 | 657 | 34.58840127 | -96.29798747 | 2021-02-11 05:23:55 | Coal, Oklahoma, US |
2021-02-06 | US | Mississippi | Choctaw | 28019 | 671 | 14 | 0 | 657 | 33.34598242 | -89.24809382 | 2021-02-07 05:23:00 | Choctaw, Mississippi, US |
2021-02-04 | US | Virginia | Nelson | 51125 | 663 | 6 | 0 | 657 | 37.78790447 | -78.88498513 | 2021-02-05 05:22:38 | Nelson, Virginia, US |
2021-02-04 | US | Illinois | Schuyler | 17169 | 662 | 5 | 0 | 657 | 40.1571798 | -90.61114163 | 2021-02-05 05:22:38 | Schuyler, Illinois, US |
2021-02-03 | US | Montana | Blaine | 30005 | 681 | 24 | 0 | 657 | 48.43175214 | -108.9582723 | 2021-02-04 05:22:26 | Blaine, Montana, US |
2021-02-01 | US | Washington | Pacific | 53049 | 665 | 8 | 0 | 657 | 46.55418369 | -123.7285716 | 2021-02-02 05:22:49 | Pacific, Washington, US |
2021-02-01 | US | Texas | Winkler | 48495 | 666 | 17 | 0 | 657 | 31.85008651 | -103.0485163 | 2021-02-02 05:22:49 | Winkler, Texas, US |
2021-02-01 | US | Missouri | Oregon | 29149 | 660 | 3 | 0 | 657 | 36.68710164 | -91.4033755 | 2021-02-02 05:22:49 | Oregon, Missouri, US |
2021-02-01 | US | Georgia | Terrell | 13273 | 694 | 37 | 0 | 657 | 31.77527543 | -84.44069698 | 2021-02-02 05:22:49 | Terrell, Georgia, US |
2021-02-01 | US | Arkansas | Dallas | 5039 | 669 | 12 | 0 | 657 | 33.97042763 | -92.65167437 | 2021-02-02 05:22:49 | Dallas, Arkansas, US |
2021-01-31 | US | Texas | Winkler | 48495 | 666 | 17 | 0 | 657 | 31.85008651 | -103.0485163 | 2021-02-01 05:22:53 | Winkler, Texas, US |
2021-01-31 | US | Georgia | Terrell | 13273 | 694 | 37 | 0 | 657 | 31.77527543 | -84.44069698 | 2021-02-01 05:22:53 | Terrell, Georgia, US |
2021-01-30 | US | Minnesota | Lake | 27075 | 673 | 16 | 0 | 657 | 47.64270764 | -91.44557998 | 2021-01-31 05:22:42 | Lake, Minnesota, US |
2021-01-30 | US | Georgia | Terrell | 13273 | 694 | 37 | 0 | 657 | 31.77527543 | -84.44069698 | 2021-01-31 05:22:42 | Terrell, Georgia, US |
2021-01-28 | US | Texas | Floyd | 48153 | 907 | 28 | 0 | 657 | 34.07227468 | -101.3031546 | 2021-01-29 05:22:23 | Floyd, Texas, US |
2021-01-25 | US | Georgia | Wilcox | 13315 | 697 | 40 | 0 | 657 | 31.97496928 | -83.43438555 | 2021-01-26 05:22:02 | Wilcox, Georgia, US |
2021-01-24 | US | Iowa | Lucas | 19117 | 667 | 10 | 0 | 657 | 41.02958964 | -93.32780803 | 2021-01-25 05:22:16 | Lucas, Iowa, US |
2021-01-20 | Japan | Miyagi | 3090 | 22 | 2411 | 657 | 38.446859 | 140.927086 | 2021-01-21 05:22:01 | Miyagi, Japan | ||
2021-01-19 | US | Texas | Morris | 48343 | 818 | 15 | 0 | 657 | 33.11304005 | -94.73255695 | 2021-01-20 05:21:54 | Morris, Texas, US |
2021-01-18 | US | North Carolina | Pamlico | 37137 | 663 | 6 | 0 | 657 | 35.15253315 | -76.66559823 | 2021-01-19 05:22:15 | Pamlico, North Carolina, US |
2021-01-18 | US | Maine | Hancock | 23009 | 685 | 28 | 0 | 657 | 44.59816444 | -68.38401854 | 2021-01-19 05:22:15 | Hancock, Maine, US |
2021-01-18 | US | Arkansas | Prairie | 5117 | 674 | 17 | 0 | 657 | 34.83624419 | -91.55162157 | 2021-01-19 05:22:15 | Prairie, Arkansas, US |
2021-01-17 | US | Tennessee | Pickett | 47137 | 700 | 19 | 0 | 657 | 36.55606529 | -85.07763299999998 | 2021-01-18 05:22:34 | Pickett, Tennessee, US |
2021-01-17 | US | North Carolina | Pamlico | 37137 | 663 | 6 | 0 | 657 | 35.15253315 | -76.66559823 | 2021-01-18 05:22:34 | Pamlico, North Carolina, US |
2021-01-16 | US | Utah | Unassigned | 90049 | 657 | 0 | 0 | 657 | 41.72330587 | 0.0 | 2021-01-17 05:22:17 | Unassigned, Utah, US |
2021-01-15 | US | Oregon | Clatsop | 41007 | 661 | 4 | 0 | 657 | 45.99712889 | -123.660711 | 2021-01-16 05:22:40 | Clatsop, Oregon, US |
2021-01-13 | US | Texas | Newton | 48351 | 601 | 19 | 0 | 657 | 30.78548982 | -93.74408813 | 2021-01-14 05:22:32 | Newton, Texas, US |
2021-01-13 | US | Nebraska | Merrick | 31121 | 668 | 11 | 0 | 657 | 41.16624273 | -98.0374887 | 2021-01-14 05:22:32 | Merrick, Nebraska, US |
2021-01-12 | US | Missouri | Howard | 29089 | 661 | 4 | 0 | 657 | 39.1435761 | -92.69756691 | 2021-01-13 05:22:15 | Howard, Missouri, US |
2021-01-12 | US | Michigan | Manistee | 26101 | 676 | 19 | 0 | 657 | 44.33352407 | -86.05626916 | 2021-01-13 05:22:15 | Manistee, Michigan, US |
2021-01-12 | US | Illinois | Hamilton | 17065 | 670 | 13 | 0 | 657 | 38.08163641 | -88.53883373 | 2021-01-13 05:22:15 | Hamilton, Illinois, US |
2021-01-11 | US | Missouri | Howard | 29089 | 661 | 4 | 0 | 657 | 39.1435761 | -92.69756691 | 2021-01-12 05:22:15 | Howard, Missouri, US |
2021-01-10 | US | Virginia | Greene | 51079 | 661 | 4 | 0 | 657 | 38.29545894 | -78.46525378 | 2021-01-11 05:21:50 | Greene, Virginia, US |
2021-01-10 | US | Georgia | Screven | 13251 | 672 | 15 | 0 | 657 | 32.74976524 | -81.60779441 | 2021-01-11 05:21:50 | Screven, Georgia, US |
2021-01-09 | US | Missouri | Douglas | 29067 | 677 | 20 | 0 | 657 | 36.9325593 | -92.49905109 | 2021-01-10 05:22:12 | Douglas, Missouri, US |
2021-01-09 | US | Kentucky | Carroll | 21041 | 664 | 7 | 0 | 657 | 38.66599534 | -85.12601074 | 2021-01-10 05:22:12 | Carroll, Kentucky, US |
2021-01-09 | Japan | Kumamoto | 2369 | 32 | 1680 | 657 | 32.608154 | 130.74523100000002 | 2021-01-10 05:22:12 | Kumamoto, Japan | ||
2021-01-06 | US | Minnesota | Clearwater | 27029 | 671 | 14 | 0 | 657 | 47.57992111 | -95.37790562 | 2021-01-07 05:22:03 | Clearwater, Minnesota, US |
2021-01-05 | US | Georgia | Clinch | 13065 | 671 | 14 | 0 | 657 | 30.91395822 | -82.70432472 | 2021-01-06 05:22:16 | Clinch, Georgia, US |
2021-01-03 | Belize | 10901 | 250 | 9994 | 657 | 17.1899 | -88.4976 | 2021-01-04 05:22:02 | Belize | |||
2021-01-01 | US | Oklahoma | Blaine | 40011 | 660 | 3 | 0 | 657 | 35.87518314 | -98.43307003 | 2021-01-02 05:22:33 | Blaine, Oklahoma, US |
2020-12-31 | US | Oklahoma | Blaine | 40011 | 660 | 3 | 0 | 657 | 35.87518314 | -98.43307003 | 2021-01-01 05:23:07 | Blaine, Oklahoma, US |
2020-12-31 | US | Missouri | Wayne | 29223 | 663 | 6 | 0 | 657 | 37.11303869 | -90.46001416 | 2021-01-01 05:23:07 | Wayne, Missouri, US |
2020-12-29 | US | Nebraska | Knox | 31107 | 662 | 5 | 0 | 657 | 42.63758421 | -97.89178836 | 2020-12-30 05:22:34 | Knox, Nebraska, US |
2020-12-28 | US | Nebraska | Knox | 31107 | 662 | 5 | 0 | 657 | 42.63758421 | -97.89178836 | 2020-12-29 05:22:37 | Knox, Nebraska, US |
2020-12-28 | US | Iowa | Clarke | 19039 | 663 | 6 | 0 | 657 | 41.02868181 | -93.78499767 | 2020-12-29 05:22:37 | Clarke, Iowa, US |
2020-12-27 | US | South Dakota | Custer | 46033 | 666 | 9 | 0 | 657 | 43.67741105 | -103.4534521 | 2020-12-28 05:22:06 | Custer, South Dakota, US |
2020-12-26 | US | South Dakota | Custer | 46033 | 666 | 9 | 0 | 657 | 43.67741105 | -103.4534521 | 2020-12-27 05:22:55 | Custer, South Dakota, US |
2020-12-26 | US | Minnesota | Marshall | 27089 | 669 | 12 | 0 | 657 | 48.35825983 | -96.37017407 | 2020-12-27 05:22:55 | Marshall, Minnesota, US |
2020-12-25 | US | South Dakota | Custer | 46033 | 666 | 9 | 0 | 657 | 43.67741105 | -103.4534521 | 2020-12-26 05:22:28 | Custer, South Dakota, US |
2020-12-25 | US | Indiana | Brown | 18013 | 667 | 10 | 0 | 657 | 39.19605589 | -86.22868909 | 2020-12-26 05:22:28 | Brown, Indiana, US |
2020-12-24 | US | South Dakota | Custer | 46033 | 666 | 9 | 0 | 657 | 43.67741105 | -103.4534521 | 2020-12-25 05:22:48 | Custer, South Dakota, US |
2020-12-23 | US | Missouri | Dallas | 29059 | 675 | 18 | 0 | 657 | 37.6811355 | -93.02127031 | 2020-12-24 05:23:04 | Dallas, Missouri, US |
2020-12-23 | US | Louisiana | St. Helena | 22091 | 661 | 4 | 0 | 657 | 30.82210324 | -90.71013176 | 2020-12-24 05:23:04 | St. Helena, Louisiana, US |
2020-12-23 | US | Iowa | Howard | 19089 | 672 | 15 | 0 | 657 | 43.35671042 | -92.31702714 | 2020-12-24 05:23:04 | Howard, Iowa, US |
2020-12-22 | US | New York | Washington | 36115 | 671 | 14 | 0 | 657 | 43.31153794 | -73.43043448 | 2020-12-23 05:22:03 | Washington, New York, US |
2020-12-21 | US | Oklahoma | Washita | 40149 | 660 | 3 | 0 | 657 | 35.29071824 | -98.99180434 | 2020-12-22 05:22:33 | Washita, Oklahoma, US |
2020-12-20 | US | Virginia | Sussex | 51183 | 670 | 13 | 0 | 657 | 36.92432914 | -77.25791182 | 2020-12-21 05:27:58 | Sussex, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;