johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by confirmed
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region, last_update
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed ▼ | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8030 | 8030 | 2021-10-28 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2021-10-29 04:22:03 | Niue, New Zealand | ||
8031 | 8031 | 2021-10-28 | Tuvalu | 0 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2021-10-29 04:22:03 | Tuvalu | |||
8032 | 8032 | 2021-10-28 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2021-10-29 04:22:03 | Pitcairn Islands, United Kingdom | ||
8100 | 8100 | 2020-10-25 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-10-26 04:25:02 | Diamond Princess, Canada | ||
8107 | 8107 | 2020-10-25 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-10-26 04:25:02 | Nunavut, Canada | ||
8195 | 8195 | 2020-10-25 | Colombia | Unknown | 0 | -154 | -8072 | 8226 | 2020-10-26 04:25:02 | Unknown, Colombia | ||||
8286 | 8286 | 2020-10-25 | India | Lakshadweep | 0 | 0 | 0 | 0 | 13.6999972 | 72.18333259999999 | 2020-10-26 04:25:02 | Lakshadweep, India | ||
8301 | 8301 | 2020-10-25 | India | Unknown | 0 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, India | ||||
8504 | 8504 | 2020-10-25 | Peru | Unknown | 0 | 0 | 803846 | 0 | 2020-10-26 04:25:02 | Unknown, Peru | ||||
8597 | 8597 | 2020-10-25 | Samoa | 0 | 0 | 0 | 0 | -13.759 | -172.1046 | 2020-10-26 04:25:02 | Samoa | |||
8631 | 8631 | 2020-10-25 | Spain | Unknown | 0 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, Spain | ||||
8719 | 8719 | 2020-10-25 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-10-26 04:25:02 | Out of AL, Alabama, US |
8731 | 8731 | 2020-10-25 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Alabama, US |
8740 | 8740 | 2020-10-25 | US | Alaska | Bristol Bay | 2060 | 0 | 0 | 0 | 0 | 58.74513976 | -156.701064 | 2020-10-26 04:25:02 | Bristol Bay, Alaska, US |
8761 | 8761 | 2020-10-25 | US | Alaska | Valdez-Cordova | 2261 | 0 | 0 | 0 | 0 | 61.47502768 | -144.7126799 | 2020-10-26 04:25:02 | Valdez-Cordova, Alaska, US |
8778 | 8778 | 2020-10-25 | US | Arizona | Unassigned | 90004 | 0 | 1 | 0 | 0 | 35.83883429 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Arizona, US |
8912 | 8912 | 2020-10-25 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2020-10-26 04:25:02 | Unassigned, California, US |
8963 | 8963 | 2020-10-25 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2020-10-26 04:25:02 | Out of CO, Colorado, US |
9233 | 9233 | 2020-10-25 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Hawaii, US |
9276 | 9276 | 2020-10-25 | US | Idaho | Unassigned | 90016 | 0 | 0 | 0 | 0 | 48.76684761 | -116.78476880000001 | 2020-10-26 04:25:02 | Unassigned, Idaho, US |
9463 | 9463 | 2020-10-25 | US | Indiana | Unassigned | 90018 | 0 | 89 | 0 | 0 | 41.64423868 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Indiana, US |
9674 | 9674 | 2020-10-25 | US | Kansas | Unassigned | 90020 | 0 | 19 | 0 | 0 | 39.82799632 | -99.91547333 | 2020-10-26 04:25:02 | Unassigned, Kansas, US |
9794 | 9794 | 2020-10-25 | US | Kentucky | Unassigned | 90021 | 0 | 0 | 0 | 0 | 38.97065142 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Kentucky, US |
9840 | 9840 | 2020-10-25 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2020-10-26 04:25:02 | Out of LA, Louisiana, US |
9877 | 9877 | 2020-10-25 | US | Maine | Out of ME | 80023 | 0 | 0 | 0 | 0 | 46.65926321 | 0.0 | 2020-08-07 22:34:20 | Out of ME, Maine, US |
9883 | 9883 | 2020-10-25 | US | Maine | Unassigned | 90023 | 0 | 0 | 0 | 0 | 46.65926321 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Maine, US |
9908 | 9908 | 2020-10-25 | US | Maryland | Unassigned | 90024 | 0 | 10 | 0 | 0 | 39.62357628 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Maryland, US |
10173 | 10173 | 2020-10-25 | US | Mississippi | Unassigned | 90028 | 0 | 0 | 0 | 0 | 34.88084463 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Mississippi, US |
10353 | 10353 | 2020-10-25 | US | Montana | Unassigned | 90030 | 0 | 0 | 0 | 0 | 48.78420029 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Montana, US |
10457 | 10457 | 2020-10-25 | US | Nevada | Esmeralda | 32009 | 0 | 0 | 0 | 0 | 37.78436681 | -117.6319999 | 2020-10-26 04:25:02 | Esmeralda, Nevada, US |
10467 | 10467 | 2020-10-25 | US | Nevada | Unassigned | 90032 | 0 | 0 | 0 | 0 | 41.40692186 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Nevada, US |
10576 | 10576 | 2020-10-25 | US | New York | Out of NY | 80036 | 0 | 111 | 0 | 0 | 44.74530905 | 0.0 | 2020-10-26 04:25:02 | Out of NY, New York, US |
10594 | 10594 | 2020-10-25 | US | New York | Unassigned | 90036 | 0 | 21 | 0 | 0 | 44.74530905 | 0.0 | 2020-10-26 04:25:02 | Unassigned, New York, US |
10690 | 10690 | 2020-10-25 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2020-10-26 04:25:02 | Unassigned, North Carolina, US |
10751 | 10751 | 2020-10-25 | US | North Dakota | Unassigned | 90038 | 0 | 0 | 0 | 0 | 48.814938700000006 | 0.0 | 2020-10-26 04:25:02 | Unassigned, North Dakota, US |
10836 | 10836 | 2020-10-25 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2020-10-26 04:25:02 | Unassigned, Ohio, US |
10904 | 10904 | 2020-10-25 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-10-26 04:25:02 | Out of OK, Oklahoma, US |
10955 | 10955 | 2020-10-25 | US | Oregon | Unassigned | 90041 | 0 | 0 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2020-10-26 04:25:02 | Unassigned, Oregon, US |
11021 | 11021 | 2020-10-25 | US | Pennsylvania | Unassigned | 90042 | 0 | 0 | 0 | 0 | 41.99253829 | -80.34921611 | 2020-10-26 04:25:02 | Unassigned, Pennsylvania, US |
11110 | 11110 | 2020-10-25 | US | Recovered | 0 | 0 | 3422878 | 0 | 0.0 | 0.0 | 2020-10-26 04:25:02 | Recovered, US | ||
11160 | 11160 | 2020-10-25 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2020-10-26 04:25:02 | Unassigned, South Carolina, US |
11226 | 11226 | 2020-10-25 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2020-10-26 04:25:02 | Unassigned, South Dakota, US |
11593 | 11593 | 2020-10-25 | US | Utah | Unassigned | 90049 | 0 | 0 | 0 | 0 | 41.72330587 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Utah, US |
11736 | 11736 | 2020-10-25 | US | Virginia | Unassigned | 90051 | 0 | 0 | 0 | 0 | 39.20172582 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Virginia, US |
11835 | 11835 | 2020-10-25 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-10-26 04:25:02 | Unassigned, West Virginia, US |
11905 | 11905 | 2020-10-25 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Wisconsin, US |
11937 | 11937 | 2020-10-25 | US | Wyoming | Unassigned | 90056 | 0 | 0 | 0 | 0 | 44.79048913 | -110.6563997 | 2020-10-26 04:25:02 | Unassigned, Wyoming, US |
11973 | 11973 | 2020-10-25 | United Kingdom | Channel Islands | 0 | 0 | 671 | 76 | 49.3723 | -2.3644 | 2020-10-26 04:25:02 | Channel Islands, United Kingdom | ||
11983 | 11983 | 2020-10-25 | United Kingdom | Unknown | 0 | 75 | 0 | 0 | 55.3781 | -3.436 | 2020-10-26 04:25:02 | Unknown, United Kingdom | ||
11996 | 11996 | 2020-10-25 | Kiribati | 0 | 0 | 0 | 0 | -3.3704 | -168.734 | 2020-10-26 04:25:02 | Kiribati | |||
11997 | 11997 | 2020-10-25 | Palau | 0 | 0 | 0 | 0 | 7.515 | 134.5825 | 2020-10-26 04:25:02 | Palau | |||
11998 | 11998 | 2020-10-25 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-10-26 04:25:02 | Cook Islands, New Zealand | ||
11999 | 11999 | 2020-10-25 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-10-26 04:25:02 | Summer Olympics 2020 | |||
12016 | 12016 | 2020-10-25 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, Malaysia | ||||
12017 | 12017 | 2020-10-25 | Tonga | 0 | 0 | 0 | 0 | -21.179 | -175.1982 | 2020-10-26 04:25:02 | Tonga | |||
12018 | 12018 | 2020-10-25 | Winter Olympics 2022 | 0 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2020-10-26 04:25:02 | Winter Olympics 2022 | |||
12019 | 12019 | 2020-10-25 | Antarctica | 0 | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-10-26 04:25:02 | Antarctica | |||
12022 | 12022 | 2020-10-25 | Korea, North | 0 | 0 | 0 | 0 | 40.3399 | 127.5101 | 2020-10-26 04:25:02 | Korea, North | |||
12023 | 12023 | 2020-10-25 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-10-26 04:25:02 | Unknown, Ukraine | ||||
12024 | 12024 | 2020-10-25 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2020-10-26 04:25:02 | Nauru | |||
12025 | 12025 | 2020-10-25 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-10-26 04:25:02 | Niue, New Zealand | ||
12026 | 12026 | 2020-10-25 | Tuvalu | 0 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2020-10-26 04:25:02 | Tuvalu | |||
12027 | 12027 | 2020-10-25 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-10-26 04:25:02 | Pitcairn Islands, United Kingdom | ||
12106 | 12106 | 2021-01-26 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-12-21 13:27:30 | Diamond Princess, Canada | ||
12309 | 12309 | 2021-01-26 | India | Unknown | 0 | 0 | 0 | 0 | 2021-01-27 05:23:41 | Unknown, India | ||||
12443 | 12443 | 2021-01-26 | Mexico | Unknown | 0 | 0 | 1348660 | 0 | 2021-01-27 05:23:41 | Unknown, Mexico | ||||
12642 | 12642 | 2021-01-26 | Spain | Unknown | 0 | 0 | 0 | 0 | 2021-01-27 05:23:41 | Unknown, Spain | ||||
12730 | 12730 | 2021-01-26 | US | Alabama | Out of AL | 80001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Out of AL, Alabama, US |
12742 | 12742 | 2021-01-26 | US | Alabama | Unassigned | 90001 | 0 | 0 | 0 | 0 | 34.90171875 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Alabama, US |
12751 | 12751 | 2021-01-26 | US | Alaska | Bristol Bay | 2060 | 0 | 0 | 0 | 0 | 58.74513976 | -156.701064 | 2021-01-27 05:23:41 | Bristol Bay, Alaska, US |
12772 | 12772 | 2021-01-26 | US | Alaska | Valdez-Cordova | 2261 | 0 | 0 | 0 | 0 | 61.47502768 | -144.7126799 | 2021-01-27 05:23:41 | Valdez-Cordova, Alaska, US |
12786 | 12786 | 2021-01-26 | US | Arizona | Out of AZ | 80004 | 0 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-01-27 05:23:41 | Out of AZ, Arizona, US |
12790 | 12790 | 2021-01-26 | US | Arizona | Unassigned | 90004 | 0 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Arizona, US |
12924 | 12924 | 2021-01-26 | US | California | Unassigned | 90006 | 0 | 0 | 0 | 0 | 41.74228275 | 0.0 | 2021-01-27 05:23:41 | Unassigned, California, US |
12975 | 12975 | 2021-01-26 | US | Colorado | Out of CO | 80008 | 0 | 0 | 0 | 0 | 40.87595412 | 0.0 | 2021-01-27 05:23:41 | Out of CO, Colorado, US |
13245 | 13245 | 2021-01-26 | US | Hawaii | Unassigned | 90015 | 0 | 0 | 0 | 0 | 22.03935037 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Hawaii, US |
13288 | 13288 | 2021-01-26 | US | Idaho | Unassigned | 90016 | 0 | 0 | 0 | 0 | 48.76684761 | -116.78476880000001 | 2021-01-27 05:23:41 | Unassigned, Idaho, US |
13475 | 13475 | 2021-01-26 | US | Indiana | Unassigned | 90018 | 0 | 152 | 0 | 0 | 41.64423868 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Indiana, US |
13660 | 13660 | 2021-01-26 | US | Kansas | Out of KS | 80020 | 0 | 0 | 0 | 0 | 39.82799632 | -99.91547333 | 2021-01-27 05:23:41 | Out of KS, Kansas, US |
13687 | 13687 | 2021-01-26 | US | Kansas | Unassigned | 90020 | 0 | 0 | 0 | 0 | 39.82799632 | -99.91547333 | 2021-01-27 05:23:41 | Unassigned, Kansas, US |
13807 | 13807 | 2021-01-26 | US | Kentucky | Unassigned | 90021 | 0 | 0 | 0 | 0 | 38.97065142 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Kentucky, US |
13853 | 13853 | 2021-01-26 | US | Louisiana | Out of LA | 80022 | 0 | 0 | 0 | 0 | 32.83121059 | 0.0 | 2021-01-27 05:23:41 | Out of LA, Louisiana, US |
13890 | 13890 | 2021-01-26 | US | Maine | Out of ME | 80023 | 0 | 0 | 0 | 0 | 46.65926321 | 0.0 | 2020-08-07 22:34:20 | Out of ME, Maine, US |
13921 | 13921 | 2021-01-26 | US | Maryland | Unassigned | 90024 | 0 | 70 | 0 | 0 | 39.62357628 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Maryland, US |
14186 | 14186 | 2021-01-26 | US | Mississippi | Unassigned | 90028 | 0 | 0 | 0 | 0 | 34.88084463 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Mississippi, US |
14366 | 14366 | 2021-01-26 | US | Montana | Unassigned | 90030 | 0 | 0 | 0 | 0 | 48.78420029 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Montana, US |
14480 | 14480 | 2021-01-26 | US | Nevada | Unassigned | 90032 | 0 | 0 | 0 | 0 | 41.40692186 | 0.0 | 2021-01-24 23:22:19 | Unassigned, Nevada, US |
14589 | 14589 | 2021-01-26 | US | New York | Out of NY | 80036 | 0 | 176 | 0 | 0 | 44.74530905 | 0.0 | 2021-01-27 05:23:41 | Out of NY, New York, US |
14703 | 14703 | 2021-01-26 | US | North Carolina | Unassigned | 90037 | 0 | 0 | 0 | 0 | 36.49360862 | 0.0 | 2021-01-27 05:23:41 | Unassigned, North Carolina, US |
14764 | 14764 | 2021-01-26 | US | North Dakota | Unassigned | 90038 | 0 | 25 | 0 | 0 | 48.814938700000006 | 0.0 | 2021-01-27 05:23:41 | Unassigned, North Dakota, US |
14849 | 14849 | 2021-01-26 | US | Ohio | Unassigned | 90039 | 0 | 0 | 0 | 0 | 41.70860332 | -84.64787018 | 2021-01-27 05:23:41 | Unassigned, Ohio, US |
14917 | 14917 | 2021-01-26 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-01-27 05:23:41 | Out of OK, Oklahoma, US |
14968 | 14968 | 2021-01-26 | US | Oregon | Unassigned | 90041 | 0 | 0 | 0 | 0 | 45.99712889 | -124.15728200000001 | 2020-12-21 13:27:30 | Unassigned, Oregon, US |
15034 | 15034 | 2021-01-26 | US | Pennsylvania | Unassigned | 90042 | 0 | 0 | 0 | 0 | 41.99253829 | -80.34921611 | 2021-01-27 05:23:41 | Unassigned, Pennsylvania, US |
15123 | 15123 | 2021-01-26 | US | Recovered | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 2021-01-27 05:23:41 | Recovered, US | ||
15173 | 15173 | 2021-01-26 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-01-27 05:23:41 | Unassigned, South Carolina, US |
15239 | 15239 | 2021-01-26 | US | South Dakota | Unassigned | 90046 | 0 | 0 | 0 | 0 | 45.77074915 | -99.99661148 | 2021-01-27 05:23:41 | Unassigned, South Dakota, US |
15749 | 15749 | 2021-01-26 | US | Virginia | Unassigned | 90051 | 0 | 0 | 0 | 0 | 39.20172582 | 0.0 | 2020-12-21 13:27:30 | Unassigned, Virginia, US |
15848 | 15848 | 2021-01-26 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-01-27 05:23:41 | Unassigned, West Virginia, US |
15918 | 15918 | 2021-01-26 | US | Wisconsin | Unassigned | 90055 | 0 | 0 | 0 | 0 | 46.52868768 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Wisconsin, 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]);