daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
354 rows where active = 672 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-08-03 | India | Uttar Pradesh | 1708562 | 22765 | 1685125 | 672 | 26.925425 | 80.560982 | 2021-08-04 04:21:25 | Uttar Pradesh, India | ||
2021-07-28 | India | Uttarakhand | 341934 | 7361 | 333901 | 672 | 30.156447 | 79.197608 | 2021-07-29 04:21:33 | Uttarakhand, India | ||
2021-07-12 | Canada | British Columbia | 148154 | 1760 | 145722 | 672 | 53.7267 | -127.6476 | 2021-07-13 04:21:18 | British Columbia, Canada | ||
2021-06-29 | Italy | Basilicata | 26940 | 590 | 25678 | 672 | 40.63947052 | 15.80514834 | 2021-06-30 04:21:41 | Basilicata, Italy | ||
2021-06-19 | Russia | Kaliningrad Oblast | 34869 | 519 | 33678 | 672 | 54.7293041 | 21.1489473 | 2021-06-20 04:21:48 | Kaliningrad Oblast, Russia | ||
2021-05-26 | Russia | Novgorod Oblast | 30810 | 156 | 29982 | 672 | 58.2843833 | 32.5169757 | 2021-05-27 04:20:59 | Novgorod Oblast, Russia | ||
2021-05-20 | India | Dadra and Nagar Haveli and Daman and Diu | 9850 | 4 | 9174 | 672 | 20.194742 | 73.080901 | 2021-05-21 04:20:43 | Dadra and Nagar Haveli and Daman and Diu, India | ||
2021-05-16 | Japan | Fukushima | 4245 | 131 | 3442 | 672 | 37.378867 | 140.223295 | 2021-05-17 04:20:34 | Fukushima, Japan | ||
2021-05-13 | Japan | Shizuoka | 7167 | 130 | 6365 | 672 | 34.916975 | 138.40778400000002 | 2021-05-14 04:20:41 | Shizuoka, Japan | ||
2021-05-12 | Colombia | Cauca | 31603 | 843 | 30088 | 672 | 2.705 | -76.82600000000002 | 2021-05-13 04:20:51 | Cauca, Colombia | ||
2021-05-10 | Chile | Magallanes | 26310 | 377 | 25261 | 672 | -52.368 | -70.9863 | 2021-05-11 04:20:41 | Magallanes, Chile | ||
2021-05-05 | Russia | Ivanovo Oblast | 34720 | 1157 | 32891 | 672 | 56.9167446 | 41.43521370000001 | 2021-05-06 04:20:38 | Ivanovo Oblast, Russia | ||
2021-05-04 | Malaysia | Perak | 15064 | 47 | 14345 | 672 | 4.5921 | 101.0901 | 2021-05-05 04:20:43 | Perak, Malaysia | ||
2021-04-23 | Italy | P.A. Bolzano | 70730 | 1158 | 68900 | 672 | 46.49933453 | 11.35662422 | 2021-04-24 04:20:38 | P.A. Bolzano, Italy | ||
2021-04-23 | Chile | Magallanes | 24577 | 366 | 23539 | 672 | -52.368 | -70.9863 | 2021-04-24 04:20:38 | Magallanes, Chile | ||
2021-04-02 | Russia | Kamchatka Krai | 14149 | 201 | 13276 | 672 | 57.1914882 | 160.03838190000005 | 2021-04-03 04:20:44 | Kamchatka Krai, Russia | ||
2021-03-28 | Colombia | Sucre | 22649 | 838 | 21139 | 672 | 8.814 | -74.7233 | 2021-03-29 04:28:35 | Sucre, Colombia | ||
2021-03-27 | Colombia | Sucre | 22546 | 838 | 21036 | 672 | 8.814 | -74.7233 | 2021-03-28 05:28:10 | Sucre, Colombia | ||
2021-03-17 | India | Uttarakhand | 98041 | 1704 | 95665 | 672 | 30.156447 | 79.197608 | 2021-03-18 05:26:22 | Uttarakhand, India | ||
2021-03-10 | Colombia | Norte de Santander | 51190 | 2736 | 47782 | 672 | 7.9463 | -72.8988 | 2021-03-11 05:25:48 | Norte de Santander, Colombia | ||
2021-03-06 | US | Wyoming | Sublette | 56035 | 679 | 7 | 0 | 672 | 42.76558279 | -109.9130922 | 2021-03-07 05:21:54 | Sublette, Wyoming, US |
2021-03-05 | US | Wyoming | Sublette | 56035 | 679 | 7 | 0 | 672 | 42.76558279 | -109.9130922 | 2021-03-06 04:23:41 | Sublette, Wyoming, US |
2021-03-04 | US | Wyoming | Sublette | 56035 | 679 | 7 | 0 | 672 | 42.76558279 | -109.9130922 | 2021-03-05 05:26:29 | Sublette, Wyoming, US |
2021-03-03 | US | Texas | Franklin | 48159 | 815 | 25 | 0 | 672 | 33.17653242 | -95.21917243 | 2021-03-04 05:24:24 | Franklin, Texas, US |
2021-03-02 | US | Illinois | Schuyler | 17169 | 677 | 5 | 0 | 672 | 40.1571798 | -90.61114163 | 2021-03-03 05:23:28 | Schuyler, Illinois, US |
2021-03-02 | Chile | Tarapaca | 24867 | 432 | 23763 | 672 | -19.9232 | -69.5132 | 2021-03-03 05:23:28 | Tarapaca, Chile | ||
2021-03-01 | US | Illinois | Schuyler | 17169 | 677 | 5 | 0 | 672 | 40.1571798 | -90.61114163 | 2021-03-02 05:23:30 | Schuyler, Illinois, US |
2021-02-28 | US | Illinois | Schuyler | 17169 | 677 | 5 | 0 | 672 | 40.1571798 | -90.61114163 | 2021-03-01 05:23:01 | Schuyler, Illinois, US |
2021-02-27 | US | South Dakota | Hamlin | 46057 | 709 | 37 | 0 | 672 | 44.67385954 | -97.18829593 | 2021-02-28 05:22:20 | Hamlin, South Dakota, US |
2021-02-27 | US | Puerto Rico | Utuado | 72141 | 672 | 0 | 0 | 672 | 18.271214 | -66.702984 | 2021-02-28 05:22:20 | Utuado, Puerto Rico, US |
2021-02-27 | US | Illinois | Schuyler | 17169 | 677 | 5 | 0 | 672 | 40.1571798 | -90.61114163 | 2021-02-28 05:22:20 | Schuyler, Illinois, US |
2021-02-26 | US | South Dakota | Hamlin | 46057 | 710 | 38 | 0 | 672 | 44.67385954 | -97.18829593 | 2021-02-27 05:22:28 | Hamlin, South Dakota, US |
2021-02-23 | US | Virginia | Northampton | 51131 | 704 | 32 | 0 | 672 | 37.34062933 | -75.87751591 | 2021-02-24 05:29:16 | Northampton, Virginia, US |
2021-02-22 | US | Virginia | Northampton | 51131 | 704 | 32 | 0 | 672 | 37.34062933 | -75.87751591 | 2021-02-23 05:23:41 | Northampton, Virginia, US |
2021-02-22 | US | South Dakota | Tripp | 46123 | 688 | 16 | 0 | 672 | 43.34459388 | -99.8854891 | 2021-02-23 05:23:41 | Tripp, South Dakota, US |
2021-02-22 | US | Montana | Madison | 30057 | 679 | 7 | 0 | 672 | 45.30080065 | -111.9173017 | 2021-02-23 05:23:41 | Madison, Montana, US |
2021-02-21 | US | South Dakota | Tripp | 46123 | 688 | 16 | 0 | 672 | 43.34459388 | -99.8854891 | 2021-02-22 05:24:21 | Tripp, South Dakota, US |
2021-02-17 | US | Virginia | Poquoson | 51735 | 682 | 10 | 0 | 672 | 37.14259351 | -76.35798148 | 2021-02-18 05:22:58 | Poquoson, Virginia, US |
2021-02-16 | US | West Virginia | Gilmer | 54021 | 679 | 7 | 0 | 672 | 38.9251277 | -80.85952723 | 2021-02-17 05:23:10 | Gilmer, West Virginia, US |
2021-02-16 | US | Iowa | Lucas | 19117 | 691 | 19 | 0 | 672 | 41.02958964 | -93.32780803 | 2021-02-17 05:23:10 | Lucas, Iowa, US |
2021-02-13 | US | Montana | Stillwater | 30095 | 684 | 12 | 0 | 672 | 45.67071407 | -109.3950061 | 2021-02-14 05:23:43 | Stillwater, Montana, US |
2021-02-12 | US | Colorado | Yuma | 8125 | 821 | 17 | 0 | 672 | 40.00346839 | -102.4258673 | 2021-02-13 05:22:12 | Yuma, Colorado, US |
2021-02-11 | US | Maine | Washington | 23029 | 685 | 13 | 0 | 672 | 45.01607142 | -67.62813524 | 2021-02-12 05:23:29 | Washington, Maine, US |
2021-02-11 | US | Colorado | Yuma | 8125 | 821 | 17 | 0 | 672 | 40.00346839 | -102.4258673 | 2021-02-12 05:23:29 | Yuma, Colorado, US |
2021-02-10 | US | Texas | Winkler | 48495 | 682 | 18 | 0 | 672 | 31.85008651 | -103.0485163 | 2021-02-11 05:23:55 | Winkler, Texas, US |
2021-02-10 | US | South Dakota | Brule | 46015 | 681 | 9 | 0 | 672 | 43.71756379 | -99.08118954 | 2021-02-11 05:23:55 | Brule, South Dakota, US |
2021-02-10 | US | Georgia | Lincoln | 13181 | 691 | 19 | 0 | 672 | 33.79201475 | -82.45024131 | 2021-02-11 05:23:55 | Lincoln, Georgia, US |
2021-02-09 | US | Texas | Coleman | 48083 | 771 | 27 | 0 | 672 | 31.76736834 | -99.45240766 | 2021-02-10 05:22:41 | Coleman, Texas, US |
2021-02-09 | US | South Dakota | Brule | 46015 | 681 | 9 | 0 | 672 | 43.71756379 | -99.08118954 | 2021-02-10 05:22:41 | Brule, South Dakota, US |
2021-02-09 | US | Georgia | McIntosh | 13191 | 685 | 13 | 0 | 672 | 31.49683595 | -81.40163426 | 2021-02-10 05:22:41 | McIntosh, Georgia, US |
2021-02-07 | US | Washington | Pacific | 53049 | 680 | 8 | 0 | 672 | 46.55418369 | -123.7285716 | 2021-02-08 05:22:39 | Pacific, Washington, US |
2021-02-06 | US | Washington | Pacific | 53049 | 680 | 8 | 0 | 672 | 46.55418369 | -123.7285716 | 2021-02-07 05:23:00 | Pacific, Washington, US |
2021-02-05 | US | Virginia | Floyd | 51063 | 690 | 18 | 0 | 672 | 36.9302126 | -80.36738849 | 2021-02-06 05:23:55 | Floyd, Virginia, US |
2021-02-05 | US | Tennessee | Van Buren | 47175 | 788 | 15 | 0 | 672 | 35.69864497 | -85.45221699 | 2021-02-06 05:23:55 | Van Buren, Tennessee, US |
2021-02-04 | US | Virginia | Floyd | 51063 | 690 | 18 | 0 | 672 | 36.9302126 | -80.36738849 | 2021-02-05 05:22:38 | Floyd, Virginia, US |
2021-02-04 | US | Texas | Rains | 48379 | 434 | 23 | 0 | 672 | 32.87109387 | -95.79232691 | 2021-02-05 05:22:38 | Rains, Texas, US |
2021-02-03 | US | South Dakota | Brule | 46015 | 680 | 8 | 0 | 672 | 43.71756379 | -99.08118954 | 2021-02-04 05:22:26 | Brule, South Dakota, US |
2021-02-02 | US | Virginia | Clarke | 51043 | 681 | 9 | 0 | 672 | 39.11271747 | -77.99199425 | 2021-02-03 05:22:52 | Clarke, Virginia, US |
2021-02-02 | US | South Dakota | Brule | 46015 | 680 | 8 | 0 | 672 | 43.71756379 | -99.08118954 | 2021-02-03 05:22:52 | Brule, South Dakota, US |
2021-02-01 | US | South Dakota | Brule | 46015 | 680 | 8 | 0 | 672 | 43.71756379 | -99.08118954 | 2021-02-02 05:22:49 | Brule, South Dakota, US |
2021-01-30 | US | Tennessee | Van Buren | 47175 | 778 | 10 | 0 | 672 | 35.69864497 | -85.45221699 | 2021-01-31 05:22:42 | Van Buren, Tennessee, US |
2021-01-30 | US | Georgia | Lanier | 13173 | 682 | 10 | 0 | 672 | 31.038285700000007 | -83.06472457 | 2021-01-31 05:22:42 | Lanier, Georgia, US |
2021-01-28 | Cabo Verde | 13784 | 131 | 12981 | 672 | 16.5388 | -23.0418 | 2021-01-29 05:22:23 | Cabo Verde | |||
2021-01-26 | US | Kentucky | Bath | 21011 | 684 | 12 | 0 | 672 | 38.14735938 | -83.74588932 | 2021-01-27 05:23:41 | Bath, Kentucky, US |
2021-01-25 | US | Tennessee | Pickett | 47137 | 713 | 20 | 0 | 672 | 36.55606529 | -85.07763299999998 | 2021-01-26 05:22:02 | Pickett, Tennessee, US |
2021-01-24 | US | Tennessee | Pickett | 47137 | 712 | 20 | 0 | 672 | 36.55606529 | -85.07763299999998 | 2021-01-25 05:22:16 | Pickett, Tennessee, US |
2021-01-24 | US | Kansas | Linn | 20107 | 676 | 4 | 0 | 672 | 38.21267844 | -94.84254089 | 2021-01-25 05:22:16 | Linn, Kansas, US |
2021-01-23 | US | Kansas | Linn | 20107 | 676 | 4 | 0 | 672 | 38.21267844 | -94.84254089 | 2021-01-24 05:22:35 | Linn, Kansas, US |
2021-01-22 | US | North Carolina | Washington | 37187 | 693 | 21 | 0 | 672 | 35.83810081 | -76.57299037 | 2021-01-23 05:22:03 | Washington, North Carolina, US |
2021-01-22 | US | Kansas | Linn | 20107 | 676 | 4 | 0 | 672 | 38.21267844 | -94.84254089 | 2021-01-23 05:22:03 | Linn, Kansas, US |
2021-01-21 | US | Texas | Swisher | 48437 | 832 | 14 | 0 | 672 | 34.53028891 | -101.7349174 | 2021-01-22 05:22:10 | Swisher, Texas, US |
2021-01-21 | US | Minnesota | Clearwater | 27029 | 686 | 14 | 0 | 672 | 47.57992111 | -95.37790562 | 2021-01-22 05:22:10 | Clearwater, Minnesota, US |
2021-01-21 | US | Georgia | Heard | 13149 | 685 | 13 | 0 | 672 | 33.29686567 | -85.12886832 | 2021-01-22 05:22:10 | Heard, Georgia, US |
2021-01-20 | US | Texas | Swisher | 48437 | 832 | 14 | 0 | 672 | 34.53028891 | -101.7349174 | 2021-01-21 05:22:01 | Swisher, Texas, US |
2021-01-19 | US | Georgia | Treutlen | 13283 | 690 | 18 | 0 | 672 | 32.40422134 | -82.56904553 | 2021-01-20 05:21:54 | Treutlen, Georgia, US |
2021-01-14 | US | Texas | Archer | 48009 | 704 | 8 | 0 | 672 | 33.61569967 | -98.68754589 | 2021-01-15 05:22:24 | Archer, Texas, US |
2021-01-13 | Japan | Okayama | 1929 | 16 | 1241 | 672 | 34.89246 | 133.826252 | 2021-01-14 05:22:32 | Okayama, Japan | ||
2021-01-12 | US | Montana | Toole | 30101 | 680 | 8 | 0 | 672 | 48.65577551 | -111.6942414 | 2021-01-13 05:22:15 | Toole, Montana, US |
2021-01-12 | US | Kansas | Anderson | 20003 | 674 | 2 | 0 | 672 | 38.21413251 | -95.29272815 | 2021-01-13 05:22:15 | Anderson, Kansas, US |
2021-01-11 | US | Virginia | Greene | 51079 | 676 | 4 | 0 | 672 | 38.29545894 | -78.46525378 | 2021-01-12 05:22:15 | Greene, Virginia, US |
2021-01-11 | US | Montana | Toole | 30101 | 680 | 8 | 0 | 672 | 48.65577551 | -111.6942414 | 2021-01-12 05:22:15 | Toole, Montana, US |
2021-01-11 | US | Kentucky | Carroll | 21041 | 679 | 7 | 0 | 672 | 38.66599534 | -85.12601074 | 2021-01-12 05:22:15 | Carroll, Kentucky, US |
2021-01-11 | US | Kansas | Anderson | 20003 | 674 | 2 | 0 | 672 | 38.21413251 | -95.29272815 | 2021-01-12 05:22:15 | Anderson, Kansas, US |
2021-01-10 | US | Kentucky | Metcalfe | 21169 | 679 | 7 | 0 | 672 | 36.99459295 | -85.63123699 | 2021-01-11 05:21:50 | Metcalfe, Kentucky, US |
2021-01-09 | US | Montana | Valley | 30105 | 681 | 9 | 0 | 672 | 48.36435097 | -106.6669635 | 2021-01-10 05:22:12 | Valley, Montana, US |
2021-01-09 | US | Montana | Toole | 30101 | 680 | 8 | 0 | 672 | 48.65577551 | -111.6942414 | 2021-01-10 05:22:12 | Toole, Montana, US |
2021-01-08 | US | Montana | Valley | 30105 | 681 | 9 | 0 | 672 | 48.36435097 | -106.6669635 | 2021-01-09 05:22:18 | Valley, Montana, US |
2021-01-07 | US | Missouri | Sullivan | 29211 | 682 | 10 | 0 | 672 | 40.2099105 | -93.11150106 | 2021-01-08 05:22:42 | Sullivan, Missouri, US |
2021-01-06 | US | Minnesota | Marshall | 27089 | 687 | 15 | 0 | 672 | 48.35825983 | -96.37017407 | 2021-01-07 05:22:03 | Marshall, Minnesota, US |
2021-01-06 | Russia | Jewish Autonomous Okrug | 3842 | 74 | 3096 | 672 | 48.57527615 | 132.66307460000002 | 2021-01-07 05:22:03 | Jewish Autonomous Okrug, Russia | ||
2021-01-05 | US | Georgia | Dooly | 13093 | 698 | 26 | 0 | 672 | 32.15630737 | -83.79746561 | 2021-01-06 05:22:16 | Dooly, Georgia, US |
2021-01-04 | US | Minnesota | Stevens | 27149 | 678 | 6 | 0 | 672 | 45.58613007 | -96.00163705 | 2021-01-05 05:21:49 | Stevens, Minnesota, US |
2021-01-03 | US | North Carolina | Alleghany | 37005 | 674 | 2 | 0 | 672 | 36.49360862 | -81.12857041 | 2021-01-04 05:22:02 | Alleghany, North Carolina, US |
2021-01-03 | US | Missouri | Ralls | 29173 | 679 | 7 | 0 | 672 | 39.52817427 | -91.51838643 | 2021-01-04 05:22:02 | Ralls, Missouri, US |
2021-01-03 | US | Kansas | Allen | 20001 | 683 | 11 | 0 | 672 | 37.88582951 | -95.30030847 | 2021-01-04 05:22:02 | Allen, Kansas, US |
2021-01-03 | US | Iowa | Ida | 19093 | 701 | 29 | 0 | 672 | 42.38696136 | -95.51355387 | 2021-01-04 05:22:02 | Ida, Iowa, US |
2021-01-02 | US | Missouri | Ripley | 29181 | 680 | 8 | 0 | 672 | 36.65460667 | -90.85990261 | 2021-01-03 05:22:52 | Ripley, Missouri, US |
2021-01-02 | US | Mississippi | Benton | 28009 | 693 | 21 | 0 | 672 | 34.81681228 | -89.18945516 | 2021-01-03 05:22:52 | Benton, Mississippi, US |
2021-01-02 | US | Kansas | Allen | 20001 | 683 | 11 | 0 | 672 | 37.88582951 | -95.30030847 | 2021-01-03 05:22:52 | Allen, Kansas, US |
2021-01-01 | US | Oklahoma | Nowata | 40105 | 681 | 9 | 0 | 672 | 36.79843529 | -95.61902331 | 2021-01-02 05:22:33 | Nowata, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;