daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
289 rows where active = 826 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-26 | Bahrain | 268626 | 1383 | 266417 | 826 | 26.0275 | 50.55 | 2021-07-27 04:21:18 | Bahrain | |||
2021-07-25 | Russia | Mari El Republic | 15720 | 360 | 14534 | 826 | 56.5767504 | 47.8817512 | 2021-07-26 04:21:28 | Mari El Republic, Russia | ||
2021-07-13 | Russia | Chuvashia Republic | 28063 | 1619 | 25618 | 826 | 55.4259922 | 47.0849429 | 2021-07-14 04:21:35 | Chuvashia Republic, Russia | ||
2021-06-26 | Moldova | 256527 | 6183 | 249518 | 826 | 47.4116 | 28.3699 | 2021-06-27 04:21:39 | Moldova | |||
2021-06-24 | Moldova | 256387 | 6180 | 249381 | 826 | 47.4116 | 28.3699 | 2021-06-25 04:21:33 | Moldova | |||
2021-06-19 | Russia | Bryansk Oblast | 42026 | 396 | 40804 | 826 | 52.8873315 | 33.41585300000001 | 2021-06-20 04:21:48 | Bryansk Oblast, Russia | ||
2021-06-14 | Bahamas | 12199 | 237 | 11136 | 826 | 25.025885 | -78.035889 | 2021-06-15 04:22:22 | Bahamas | |||
2021-05-25 | Colombia | Cauca | 33179 | 890 | 31463 | 826 | 2.705 | -76.82600000000002 | 2021-05-26 04:20:35 | Cauca, Colombia | ||
2021-05-23 | Colombia | Quindio | 42725 | 1289 | 40610 | 826 | 4.461 | -75.6674 | 2021-05-24 04:20:53 | Quindio, Colombia | ||
2021-05-13 | Japan | Nara | 7089 | 93 | 6170 | 826 | 34.317451 | 135.871644 | 2021-05-14 04:20:41 | Nara, Japan | ||
2021-05-13 | Japan | Gunma | 7035 | 111 | 6098 | 826 | 36.504479 | 138.985605 | 2021-05-14 04:20:41 | Gunma, Japan | ||
2021-05-04 | Chile | Atacama | 18500 | 204 | 17470 | 826 | -27.5661 | -70.0503 | 2021-05-05 04:20:43 | Atacama, Chile | ||
2021-04-28 | Japan | Okayama | 3773 | 40 | 2907 | 826 | 34.89246 | 133.826252 | 2021-04-29 04:20:55 | Okayama, Japan | ||
2021-04-23 | Russia | Yamalo-Nenets Autonomous Okrug | 38426 | 415 | 37185 | 826 | 67.1471631 | 74.3415488 | 2021-04-24 04:20:38 | Yamalo-Nenets Autonomous Okrug, Russia | ||
2021-04-13 | Russia | Astrakhan Oblast | 31641 | 697 | 30118 | 826 | 47.1878186 | 47.608851 | 2021-04-14 04:20:41 | Astrakhan Oblast, Russia | ||
2021-04-09 | Russia | Astrakhan Oblast | 31336 | 689 | 29821 | 826 | 47.1878186 | 47.608851 | 2021-04-10 04:20:59 | Astrakhan Oblast, Russia | ||
2021-04-05 | Colombia | Narino | 50578 | 1702 | 48050 | 826 | 1.2892 | -77.3579 | 2021-04-06 04:20:32 | Narino, Colombia | ||
2021-03-31 | Japan | Aichi | 27394 | 583 | 25985 | 826 | 35.035551 | 137.211621 | 2021-04-01 04:27:05 | Aichi, Japan | ||
2021-03-28 | Colombia | Narino | 50280 | 1689 | 47765 | 826 | 1.2892 | -77.3579 | 2021-03-29 04:28:35 | Narino, Colombia | ||
2021-03-22 | El Salvador | 63490 | 1983 | 60681 | 826 | 13.7942 | -88.8965 | 2021-03-23 05:26:18 | El Salvador | |||
2021-03-15 | Russia | Tyva Republic | 15731 | 194 | 14711 | 826 | 51.4017149 | 93.8582593 | 2021-03-16 05:25:13 | Tyva Republic, Russia | ||
2021-03-06 | US | Montana | Carbon | 30009 | 837 | 11 | 0 | 826 | 45.22850116 | -109.0274047 | 2021-03-07 05:21:54 | Carbon, Montana, US |
2021-03-05 | US | Puerto Rico | Juana Diaz | 72075 | 826 | 0 | 0 | 826 | 18.050764 | -66.49458100000001 | 2021-03-06 04:23:41 | Juana Diaz, Puerto Rico, US |
2021-03-05 | US | Montana | Carbon | 30009 | 837 | 11 | 0 | 826 | 45.22850116 | -109.0274047 | 2021-03-06 04:23:41 | Carbon, Montana, US |
2021-03-04 | US | Montana | Carbon | 30009 | 837 | 11 | 0 | 826 | 45.22850116 | -109.0274047 | 2021-03-05 05:26:29 | Carbon, Montana, US |
2021-03-04 | US | Kentucky | Lyon | 21143 | 839 | 13 | 0 | 826 | 37.02080035 | -88.07886257 | 2021-03-05 05:26:29 | Lyon, Kentucky, US |
2021-03-03 | Uzbekistan | 80035 | 622 | 78587 | 826 | 41.377491 | 64.585262 | 2021-03-04 05:24:24 | Uzbekistan | |||
2021-03-03 | US | Illinois | Marshall | 17123 | 841 | 15 | 0 | 826 | 41.0327901 | -89.34510444 | 2021-03-04 05:24:24 | Marshall, Illinois, US |
2021-03-03 | India | Andhra Pradesh | 890215 | 7170 | 882219 | 826 | 15.9129 | 79.74 | 2021-03-04 05:24:24 | Andhra Pradesh, India | ||
2021-03-02 | Uzbekistan | 79961 | 622 | 78513 | 826 | 41.377491 | 64.585262 | 2021-03-03 05:23:28 | Uzbekistan | |||
2021-03-02 | US | Louisiana | Red River | 22081 | 862 | 36 | 0 | 826 | 32.09530039 | -93.34213308 | 2021-03-03 05:23:28 | Red River, Louisiana, US |
2021-03-02 | US | Illinois | Marshall | 17123 | 841 | 15 | 0 | 826 | 41.0327901 | -89.34510444 | 2021-03-03 05:23:28 | Marshall, Illinois, US |
2021-03-01 | US | Louisiana | Red River | 22081 | 862 | 36 | 0 | 826 | 32.09530039 | -93.34213308 | 2021-03-02 05:23:30 | Red River, Louisiana, US |
2021-02-25 | US | Nebraska | Knox | 31107 | 838 | 12 | 0 | 826 | 42.63758421 | -97.89178836 | 2021-02-26 05:22:40 | Knox, Nebraska, US |
2021-02-25 | Colombia | Risaralda | 45939 | 1136 | 43977 | 826 | 5.3158 | -75.9928 | 2021-02-26 05:22:40 | Risaralda, Colombia | ||
2021-02-22 | Malaysia | Kedah | 7495 | 22 | 6647 | 826 | 6.1184 | 100.3685 | 2021-02-23 05:23:41 | Kedah, Malaysia | ||
2021-02-22 | US | Georgia | Pulaski | 13235 | 864 | 38 | 0 | 826 | 32.23334561 | -83.47549959999998 | 2021-02-23 05:23:41 | Pulaski, Georgia, US |
2021-02-20 | US | Georgia | Pulaski | 13235 | 864 | 38 | 0 | 826 | 32.23334561 | -83.47549959999998 | 2021-02-21 05:24:33 | Pulaski, Georgia, US |
2021-02-19 | US | Georgia | Montgomery | 13209 | 846 | 20 | 0 | 826 | 32.17201038 | -82.53527476 | 2021-02-20 05:22:51 | Montgomery, Georgia, US |
2021-02-19 | US | Alabama | Greene | 1063 | 858 | 32 | 0 | 826 | 32.85504247 | -87.95684022 | 2021-02-20 05:22:51 | Greene, Alabama, US |
2021-02-18 | US | Alabama | Coosa | 1037 | 848 | 22 | 0 | 826 | 32.93690146 | -86.24847739 | 2021-02-19 05:24:16 | Coosa, Alabama, US |
2021-02-17 | India | Haryana | 269322 | 3041 | 265455 | 826 | 29.20004 | 76.332824 | 2021-02-18 05:22:58 | Haryana, India | ||
2021-02-16 | US | Georgia | Wilkinson | 13319 | 847 | 21 | 0 | 826 | 32.80291082 | -83.17140684 | 2021-02-17 05:23:10 | Wilkinson, Georgia, US |
2021-02-15 | US | Georgia | Stewart | 13259 | 847 | 21 | 0 | 826 | 32.07996777 | -84.83208037 | 2021-02-16 05:24:38 | Stewart, Georgia, US |
2021-02-11 | US | New York | Schuyler | 36097 | 837 | 11 | 0 | 826 | 42.39184015 | -76.8773299 | 2021-02-12 05:23:29 | Schuyler, New York, US |
2021-02-11 | US | Missouri | Ripley | 29181 | 839 | 13 | 0 | 826 | 36.65460667 | -90.85990261 | 2021-02-12 05:23:29 | Ripley, Missouri, US |
2021-02-08 | US | Kentucky | Carroll | 21041 | 836 | 10 | 0 | 826 | 38.66599534 | -85.12601074 | 2021-02-09 05:23:30 | Carroll, Kentucky, US |
2021-02-08 | US | Georgia | Irwin | 13155 | 851 | 25 | 0 | 826 | 31.60213036 | -83.27501387 | 2021-02-09 05:23:30 | Irwin, Georgia, US |
2021-02-07 | US | North Carolina | Washington | 37187 | 850 | 24 | 0 | 826 | 35.83810081 | -76.57299037 | 2021-02-08 05:22:39 | Washington, North Carolina, US |
2021-02-06 | US | Georgia | Irwin | 13155 | 851 | 25 | 0 | 826 | 31.60213036 | -83.27501387 | 2021-02-07 05:23:00 | Irwin, Georgia, US |
2021-02-05 | US | Vermont | Franklin | 50011 | 861 | 35 | 0 | 826 | 44.85627605 | -72.91249563 | 2021-02-06 05:23:55 | Franklin, Vermont, US |
2021-02-04 | US | Texas | Yoakum | 48501 | 304 | 25 | 0 | 826 | 33.17320212 | -102.8276433 | 2021-02-05 05:22:38 | Yoakum, Texas, US |
2021-02-02 | US | Georgia | Candler | 13043 | 870 | 44 | 0 | 826 | 32.40209349 | -82.07702563 | 2021-02-03 05:22:52 | Candler, Georgia, US |
2021-02-01 | US | North Carolina | Alleghany | 37005 | 830 | 4 | 0 | 826 | 36.49360862 | -81.12857041 | 2021-02-02 05:22:49 | Alleghany, North Carolina, US |
2021-02-01 | US | Indiana | Crawford | 18025 | 839 | 13 | 0 | 826 | 38.28814402 | -86.44518825 | 2021-02-02 05:22:49 | Crawford, Indiana, US |
2021-01-29 | US | West Virginia | Lewis | 54041 | 838 | 12 | 0 | 826 | 38.9947249 | -80.49988181 | 2021-01-30 05:22:49 | Lewis, West Virginia, US |
2021-01-29 | US | Nebraska | Cheyenne | 31033 | 841 | 15 | 0 | 826 | 41.21999357 | -102.9941693 | 2021-01-30 05:22:49 | Cheyenne, Nebraska, US |
2021-01-29 | US | Georgia | Candler | 13043 | 867 | 41 | 0 | 826 | 32.40209349 | -82.07702563 | 2021-01-30 05:22:49 | Candler, Georgia, US |
2021-01-28 | US | Nebraska | Cheyenne | 31033 | 841 | 15 | 0 | 826 | 41.21999357 | -102.9941693 | 2021-01-29 05:22:23 | Cheyenne, Nebraska, US |
2021-01-27 | US | Kentucky | Martin | 21159 | 837 | 11 | 0 | 826 | 37.79990579 | -82.51247478 | 2021-01-28 05:22:24 | Martin, Kentucky, US |
2021-01-26 | US | Tennessee | Moore | 47127 | 895 | 9 | 0 | 826 | 35.27724699 | -86.36230578 | 2021-01-27 05:23:41 | Moore, Tennessee, US |
2021-01-26 | US | Georgia | Seminole | 13253 | 841 | 15 | 0 | 826 | 30.93464824 | -84.86823924 | 2021-01-27 05:23:41 | Seminole, Georgia, US |
2021-01-23 | US | Minnesota | Swift | 27151 | 844 | 18 | 0 | 826 | 45.2829032 | -95.68264092 | 2021-01-24 05:22:35 | Swift, Minnesota, US |
2021-01-22 | US | Puerto Rico | Catano | 72033 | 826 | 0 | 0 | 826 | 18.437269 | -66.14330600000001 | 2021-01-23 05:22:03 | Catano, Puerto Rico, US |
2021-01-19 | US | Kansas | Allen | 20001 | 837 | 11 | 0 | 826 | 37.88582951 | -95.30030847 | 2021-01-20 05:21:54 | Allen, Kansas, US |
2021-01-19 | US | Indiana | Brown | 18013 | 859 | 33 | 0 | 826 | 39.19605589 | -86.22868909 | 2021-01-20 05:21:54 | Brown, Indiana, US |
2021-01-19 | US | Arkansas | Pike | 5109 | 841 | 15 | 0 | 826 | 34.16250414 | -93.65789349 | 2021-01-20 05:21:54 | Pike, Arkansas, US |
2021-01-18 | US | Kansas | Allen | 20001 | 837 | 11 | 0 | 826 | 37.88582951 | -95.30030847 | 2021-01-19 05:22:15 | Allen, Kansas, US |
2021-01-18 | US | Iowa | Montgomery | 19137 | 848 | 22 | 0 | 826 | 41.03018714 | -95.15642896 | 2021-01-19 05:22:15 | Montgomery, Iowa, US |
2021-01-18 | US | Connecticut | Unassigned | 90009 | 832 | 6 | 0 | 826 | 41.85853803 | 0.0 | 2021-01-19 05:22:15 | Unassigned, Connecticut, US |
2021-01-18 | US | Arkansas | Pike | 5109 | 841 | 15 | 0 | 826 | 34.16250414 | -93.65789349 | 2021-01-19 05:22:15 | Pike, Arkansas, US |
2021-01-17 | US | Kansas | Doniphan | 20043 | 836 | 10 | 0 | 826 | 39.79067154 | -95.14056866 | 2021-01-18 05:22:34 | Doniphan, Kansas, US |
2021-01-17 | Colombia | Cordoba | 31051 | 1692 | 28533 | 826 | 8.0493 | -75.574 | 2021-01-18 05:22:34 | Cordoba, Colombia | ||
2021-01-16 | US | South Dakota | Grant | 46051 | 861 | 35 | 0 | 826 | 45.1723937 | -96.77002276 | 2021-01-17 05:22:17 | Grant, South Dakota, US |
2021-01-16 | US | Puerto Rico | Isabela | 72071 | 826 | 0 | 0 | 826 | 18.44981 | -67.005093 | 2021-01-17 05:22:17 | Isabela, Puerto Rico, US |
2021-01-16 | US | Kansas | Doniphan | 20043 | 836 | 10 | 0 | 826 | 39.79067154 | -95.14056866 | 2021-01-17 05:22:17 | Doniphan, Kansas, US |
2021-01-15 | US | Mississippi | Claiborne | 28021 | 851 | 25 | 0 | 826 | 31.97061673 | -90.90702196 | 2021-01-16 05:22:40 | Claiborne, Mississippi, US |
2021-01-15 | US | Kansas | Doniphan | 20043 | 836 | 10 | 0 | 826 | 39.79067154 | -95.14056866 | 2021-01-16 05:22:40 | Doniphan, Kansas, US |
2021-01-15 | US | California | Del Norte | 6015 | 830 | 2 | 0 | 826 | 41.74228275 | -123.8974063 | 2021-01-16 05:22:40 | Del Norte, California, US |
2021-01-14 | US | Kansas | Marshall | 20117 | 846 | 20 | 0 | 826 | 39.78359669 | -96.52278974 | 2021-01-15 05:22:24 | Marshall, Kansas, US |
2021-01-14 | US | Arkansas | Stone | 5137 | 853 | 27 | 0 | 826 | 35.86251946 | -92.15684085 | 2021-01-15 05:22:24 | Stone, Arkansas, US |
2021-01-13 | US | Kansas | Marshall | 20117 | 846 | 20 | 0 | 826 | 39.78359669 | -96.52278974 | 2021-01-14 05:22:32 | Marshall, Kansas, US |
2021-01-13 | US | Connecticut | Unassigned | 90009 | 829 | 3 | 0 | 826 | 41.85853803 | 0.0 | 2021-01-14 05:22:32 | Unassigned, Connecticut, US |
2021-01-12 | US | North Carolina | Currituck | 37053 | 837 | 11 | 0 | 826 | 36.36123664 | -75.95876401 | 2021-01-13 05:22:15 | Currituck, North Carolina, US |
2021-01-09 | US | Missouri | Barton | 29011 | 834 | 8 | 0 | 826 | 37.50207671 | -94.34757022 | 2021-01-10 05:22:12 | Barton, Missouri, US |
2021-01-09 | US | Minnesota | Murray | 27101 | 831 | 5 | 0 | 826 | 44.02216709 | -95.76328482 | 2021-01-10 05:22:12 | Murray, Minnesota, US |
2021-01-09 | US | Georgia | Johnson | 13167 | 860 | 34 | 0 | 826 | 32.70211082 | -82.66166794 | 2021-01-10 05:22:12 | Johnson, Georgia, US |
2021-01-05 | US | Texas | Callahan | 48059 | 837 | 20 | 0 | 826 | 32.29760619 | -99.37326312 | 2021-01-06 05:22:16 | Callahan, Texas, US |
2021-01-04 | US | West Virginia | Hardy | 54031 | 834 | 8 | 0 | 826 | 39.00683177 | -78.85855301 | 2021-01-05 05:21:49 | Hardy, West Virginia, US |
2021-01-04 | US | Virginia | Galax | 51640 | 862 | 36 | 0 | 826 | 36.66601852 | -80.91703124 | 2021-01-05 05:21:49 | Galax, Virginia, US |
2021-01-04 | US | Oregon | Hood River | 41027 | 843 | 17 | 0 | 826 | 45.51872811 | -121.65520359999998 | 2021-01-05 05:21:49 | Hood River, Oregon, US |
2021-01-03 | US | Oregon | Hood River | 41027 | 843 | 17 | 0 | 826 | 45.51872811 | -121.65520359999998 | 2021-01-04 05:22:02 | Hood River, Oregon, US |
2021-01-03 | US | Kentucky | Harrison | 21097 | 827 | 1 | 0 | 826 | 38.44188174 | -84.32869741 | 2021-01-04 05:22:02 | Harrison, Kentucky, US |
2021-01-03 | Colombia | Magdalena | 25028 | 1085 | 23117 | 826 | 10.4113 | -74.4057 | 2021-01-04 05:22:02 | Magdalena, Colombia | ||
2021-01-02 | US | Virginia | Richmond | 51159 | 831 | 5 | 0 | 826 | 37.937575 | -76.72920628 | 2021-01-03 05:22:52 | Richmond, Virginia, US |
2021-01-02 | US | North Carolina | Chowan | 37041 | 846 | 20 | 0 | 826 | 36.12908077 | -76.60118385 | 2021-01-03 05:22:52 | Chowan, North Carolina, US |
2020-12-30 | US | Alabama | Bullock | 1011 | 846 | 20 | 0 | 826 | 32.10030533 | -85.71265535 | 2020-12-31 05:22:49 | Bullock, Alabama, US |
2020-12-26 | US | Tennessee | Stewart | 47161 | 850 | 19 | 0 | 826 | 36.50235092 | -87.83920548 | 2020-12-27 05:22:55 | Stewart, Tennessee, US |
2020-12-24 | US | Indiana | Pike | 18125 | 852 | 26 | 0 | 826 | 38.40112197 | -87.23574907 | 2020-12-25 05:22:48 | Pike, Indiana, US |
2020-12-22 | US | West Virginia | McDowell | 54047 | 830 | 4 | 0 | 826 | 37.38002939 | -81.65083669 | 2020-12-23 05:22:03 | McDowell, West Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;