johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66 rows where active = 0 and "day" is on date 2020-03-31 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 18
- US 31
- China 9
- United Kingdom 8
- Canada 3
- New Zealand 2
- Antarctica 1
- Kiribati 1
- Korea, North 1
- Malaysia 1
- Nauru 1
- Palau 1
- Saint Vincent and the Grenadines 1
- Samoa 1
- Summer Olympics 2020 1
- Tonga 1
- Tuvalu 1
- Ukraine 1
- Winter Olympics 2022 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3816092 | 3816092 | 2020-03-31 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-03-31 23:43:56 | Pitcairn Islands, United Kingdom | ||
3816091 | 3816091 | 2020-03-31 | Tuvalu | 0 | 0 | 0 | 0 | -7.1095 | 177.6493 | 2020-03-31 23:43:56 | Tuvalu | |||
3816090 | 3816090 | 2020-03-31 | New Zealand | Niue | 0 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-31 23:43:56 | Niue, New Zealand | ||
3816089 | 3816089 | 2020-03-31 | Nauru | 0 | 0 | 0 | 0 | -0.5228 | 166.9315 | 2020-03-31 23:43:56 | Nauru | |||
3816088 | 3816088 | 2020-03-31 | United Kingdom | Wales | 82604 | 0 | 174 | 0 | 0 | 52.1307 | -3.7837 | 2020-03-31 23:43:56 | Wales, United Kingdom | |
3816087 | 3816087 | 2020-03-31 | United Kingdom | Scotland | 82603 | 0 | 297 | 0 | 0 | 56.4907 | -4.2026 | 2020-03-31 23:43:56 | Scotland, United Kingdom | |
3816086 | 3816086 | 2020-03-31 | United Kingdom | Northern Ireland | 82602 | 0 | 52 | 0 | 0 | 54.7877 | -6.4923 | 2020-03-31 23:43:56 | Northern Ireland, United Kingdom | |
3816085 | 3816085 | 2020-03-31 | United Kingdom | England | 82601 | 0 | 4604 | 0 | 0 | 52.3555 | -1.1743 | 2020-03-31 23:43:56 | England, United Kingdom | |
3816084 | 3816084 | 2020-03-31 | Ukraine | Unknown | 0 | 0 | 0 | 0 | 2020-03-31 23:43:56 | Unknown, Ukraine | ||||
3816083 | 3816083 | 2020-03-31 | Korea, North | 0 | 0 | 0 | 0 | 40.3399 | 127.5101 | 2020-03-31 23:43:56 | Korea, North | |||
3816082 | 3816082 | 2020-03-31 | United Kingdom | Guernsey | 55 | 1 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-31 23:43:56 | Guernsey, United Kingdom | ||
3816081 | 3816081 | 2020-03-31 | United Kingdom | Jersey | 59 | 2 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-31 23:43:56 | Jersey, United Kingdom | ||
3816080 | 3816080 | 2020-03-31 | Antarctica | 0 | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-03-31 23:43:56 | Antarctica | |||
3816079 | 3816079 | 2020-03-31 | Winter Olympics 2022 | 0 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2020-03-31 23:43:56 | Winter Olympics 2022 | |||
3816078 | 3816078 | 2020-03-31 | Tonga | 0 | 0 | 0 | 0 | -21.179 | -175.1982 | 2020-03-31 23:43:56 | Tonga | |||
3816077 | 3816077 | 2020-03-31 | Malaysia | Unknown | 0 | 0 | 0 | 0 | 2020-03-31 23:43:56 | Unknown, Malaysia | ||||
3816060 | 3816060 | 2020-03-31 | Summer Olympics 2020 | 0 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-31 23:43:56 | Summer Olympics 2020 | |||
3816059 | 3816059 | 2020-03-31 | New Zealand | Cook Islands | 0 | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-31 23:43:56 | Cook Islands, New Zealand | ||
3816058 | 3816058 | 2020-03-31 | Palau | 0 | 0 | 0 | 0 | 7.515 | 134.5825 | 2020-03-31 23:43:56 | Palau | |||
3816057 | 3816057 | 2020-03-31 | Kiribati | 0 | 0 | 0 | 0 | -3.3704 | -168.734 | 2020-03-31 23:43:56 | Kiribati | |||
3816056 | 3816056 | 2020-03-31 | China | Unknown | 1541 | 0 | 0 | 0 | 2020-03-31 23:43:56 | Unknown, China | ||||
3816018 | 3816018 | 2020-03-31 | Samoa | 0 | 0 | 0 | 0 | -13.759 | -172.1046 | 2020-03-31 23:49:13 | Samoa | |||
3816017 | 3816017 | 2020-03-31 | Saint Vincent and the Grenadines | 1 | 0 | 1 | 0 | 12.9843 | -61.2872 | 2020-03-31 23:43:43 | Saint Vincent and the Grenadines | |||
3815876 | 3815876 | 2020-03-31 | China | Xinjiang | 76 | 3 | 73 | 0 | 41.1129 | 85.2401 | 2020-03-08 05:31:02 | Xinjiang, China | ||
3815871 | 3815871 | 2020-03-31 | China | Tibet | 1 | 0 | 1 | 0 | 31.6927 | 88.0924 | 2020-02-23 11:19:02 | Tibet, China | ||
3815859 | 3815859 | 2020-03-31 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 0 | 0 | 0 | 0 | -7.9467 | -14.3559 | 2020-03-31 23:43:43 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | ||
3815856 | 3815856 | 2020-03-31 | US | Recovered | 0 | 0 | 7024 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Recovered, US | ||
3815855 | 3815855 | 2020-03-31 | Canada | Recovered | 0 | 0 | 1592 | 0 | 0.0 | 0.0 | 2020-03-31 23:49:13 | Recovered, Canada | ||
3815852 | 3815852 | 2020-03-31 | China | Qinghai | 18 | 0 | 18 | 0 | 35.7452 | 95.9956 | 2020-02-23 11:19:02 | Qinghai, China | ||
3815848 | 3815848 | 2020-03-31 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-03-31 23:49:13 | Nunavut, Canada | ||
3815843 | 3815843 | 2020-03-31 | China | Ningxia | 75 | 0 | 75 | 0 | 37.2692 | 106.1655 | 2020-03-16 08:47:05 | Ningxia, China | ||
3815827 | 3815827 | 2020-03-31 | China | Hunan | 1018 | 4 | 1014 | 0 | 27.6104 | 111.7088 | 2020-03-14 08:25:05 | Hunan, China | ||
3815821 | 3815821 | 2020-03-31 | China | Hainan | 168 | 6 | 162 | 0 | 19.1959 | 109.7453 | 2020-03-24 04:29:15 | Hainan, China | ||
3815820 | 3815820 | 2020-03-31 | China | Guizhou | 146 | 2 | 144 | 0 | 26.8154 | 106.8748 | 2020-03-18 01:37:43 | Guizhou, China | ||
3815805 | 3815805 | 2020-03-31 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:49:13 | Diamond Princess, Canada | ||
3815794 | 3815794 | 2020-03-31 | China | Anhui | 990 | 6 | 984 | 0 | 31.8257 | 117.2264 | 2020-03-08 05:19:01 | Anhui, China | ||
3815683 | 3815683 | 2020-03-31 | US | Wisconsin | Waupaca | 55135 | 1 | 1 | 0 | 0 | 44.47068056 | -88.96534501 | 2020-03-31 23:43:56 | Waupaca, Wisconsin, US |
3815576 | 3815576 | 2020-03-31 | US | Wisconsin | Unassigned | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Wisconsin, US | |
3815574 | 3815574 | 2020-03-31 | US | Virginia | Unassigned | 0 | 12 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned,Virginia,US | |
3815570 | 3815570 | 2020-03-31 | US | New York | Unassigned | 0 | 468 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, New York, US | |
3815568 | 3815568 | 2020-03-31 | US | New Hampshire | Unassigned | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, New Hampshire, US | |
3815565 | 3815565 | 2020-03-31 | US | Missouri | Unassigned | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Missouri, US | |
3815564 | 3815564 | 2020-03-31 | US | Minnesota | Unassigned | 0 | 3 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Minnesota, US | |
3815553 | 3815553 | 2020-03-31 | US | Delaware | Unassigned | 0 | 3 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Delaware, US | |
3815550 | 3815550 | 2020-03-31 | US | California | Unassigned | 0 | 0 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, California, US | |
3815548 | 3815548 | 2020-03-31 | US | Arizona | Unassigned | 0 | 13 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Arizona, US | |
3815547 | 3815547 | 2020-03-31 | US | Alaska | Unassigned | 0 | 2 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Alaska, US | |
3815546 | 3815546 | 2020-03-31 | US | Alabama | Unassigned | 0 | 8 | 0 | 0 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Alabama, US | |
3815338 | 3815338 | 2020-03-31 | US | Indiana | Scott | 18143 | 1 | 1 | 0 | 0 | 38.68672078 | -85.74627859 | 2020-03-31 23:43:56 | Scott, Indiana, US |
3815199 | 3815199 | 2020-03-31 | US | Ohio | Preble | 39135 | 1 | 1 | 0 | 0 | 39.7420247 | -84.64787018 | 2020-03-31 23:43:56 | Preble, Ohio, US |
3814923 | 3814923 | 2020-03-31 | US | Michigan | Missaukee | 26113 | 1 | 1 | 0 | 0 | 44.33772443 | -85.09256478 | 2020-03-31 23:43:56 | Missaukee, Michigan, US |
3814901 | 3814901 | 2020-03-31 | US | North Dakota | Mercer | 38057 | 0 | 0 | 0 | 0 | 47.31213126 | -101.8318399 | 2020-03-31 23:43:56 | Mercer, North Dakota, US |
3814874 | 3814874 | 2020-03-31 | US | North Dakota | McHenry | 38049 | 1 | 1 | 0 | 0 | 48.23104458 | -100.6324822 | 2020-03-31 23:43:56 | McHenry, North Dakota, US |
3814562 | 3814562 | 2020-03-31 | US | Georgia | Jeff Davis | 13161 | 0 | 0 | 0 | 0 | 31.80405727 | -82.63724870000001 | 2020-03-31 23:43:56 | Jeff Davis, Georgia, US |
3814528 | 3814528 | 2020-03-31 | US | Wisconsin | Iron | 55051 | 1 | 1 | 0 | 0 | 46.26302338 | -90.24295041 | 2020-03-31 23:43:56 | Iron, Wisconsin, US |
3814463 | 3814463 | 2020-03-31 | US | Missouri | Henry | 29083 | 1 | 1 | 0 | 0 | 38.38482826 | -93.79293734 | 2020-03-31 23:43:56 | Henry, Missouri, US |
3814450 | 3814450 | 2020-03-31 | US | Georgia | Heard | 13149 | 1 | 1 | 0 | 0 | 33.29686567 | -85.12886832 | 2020-03-31 23:43:56 | Heard, Georgia, US |
3814319 | 3814319 | 2020-03-31 | US | Ohio | Gallia | 39053 | 1 | 1 | 0 | 0 | 38.82708533 | -82.31647569 | 2020-03-31 23:43:56 | Gallia, Ohio, US |
3814233 | 3814233 | 2020-03-31 | US | Alabama | Escambia | 1053 | 0 | 0 | 0 | 0 | 31.1256789 | -87.15918694 | 2020-03-31 23:43:56 | Escambia, Alabama, US |
3814165 | 3814165 | 2020-03-31 | US | Michigan | Dickinson | 26043 | 0 | 0 | 0 | 0 | 46.00999672 | -87.86961634 | 2020-03-31 23:43:56 | Dickinson, Michigan, US |
3814148 | 3814148 | 2020-03-31 | US | Tennessee | Decatur | 47039 | 0 | 0 | 0 | 0 | 35.60048904 | -88.11043779 | 2020-03-31 23:43:56 | Decatur, Tennessee, US |
3814101 | 3814101 | 2020-03-31 | US | Colorado | Crowley | 8025 | 1 | 1 | 0 | 0 | 38.32608609 | -103.7844965 | 2020-03-31 23:43:56 | Crowley, Colorado, US |
3814067 | 3814067 | 2020-03-31 | US | Arkansas | Conway | 5029 | 1 | 1 | 0 | 0 | 35.26205537 | -92.70506566 | 2020-03-31 23:43:56 | Conway, Arkansas, US |
3813849 | 3813849 | 2020-03-31 | US | South Dakota | Butte | 46019 | 0 | 0 | 0 | 0 | 44.90608745 | -103.5079318 | 2020-03-31 23:43:56 | Butte, South Dakota, US |
3813676 | 3813676 | 2020-03-31 | US | Texas | Aransas | 48007 | 0 | 0 | 0 | 0 | 28.10556197 | -96.9995047 | 2020-03-31 23:43:56 | Aransas, Texas, US |
3813665 | 3813665 | 2020-03-31 | US | Texas | Andrews | 48003 | 0 | 0 | 0 | 0 | 32.30468633 | -102.63765479999999 | 2020-03-31 23:43:56 | Andrews, Texas, 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]);