johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
2,955 rows where "last_update" is on date 2020-04-09 sorted by country_or_region
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3949947 | 3949947 | 2020-04-09 | Afghanistan | 444 | 15 | 32 | 397 | 33.93911 | 67.709953 | 2020-04-09 23:02:19 | Afghanistan | |||
3949948 | 3949948 | 2020-04-09 | Albania | 409 | 23 | 165 | 221 | 41.1533 | 20.1683 | 2020-04-09 23:02:19 | Albania | |||
3949949 | 3949949 | 2020-04-09 | Algeria | 1666 | 235 | 347 | 1084 | 28.0339 | 1.6596 | 2020-04-09 23:02:19 | Algeria | |||
3949950 | 3949950 | 2020-04-09 | Andorra | 583 | 25 | 58 | 500 | 42.5063 | 1.5218 | 2020-04-09 23:02:19 | Andorra | |||
3949951 | 3949951 | 2020-04-09 | Angola | 19 | 2 | 2 | 15 | -11.2027 | 17.8739 | 2020-04-09 23:02:19 | Angola | |||
3950150 | 3950150 | 2020-04-09 | Antarctica | 0 | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-04-09 23:02:37 | Antarctica | |||
3949952 | 3949952 | 2020-04-09 | Antigua and Barbuda | 19 | 2 | 0 | 17 | 17.0608 | -61.7964 | 2020-04-09 23:02:19 | Antigua and Barbuda | |||
3949953 | 3949953 | 2020-04-09 | Argentina | 1795 | 72 | 365 | 1358 | -38.4161 | -63.6167 | 2020-04-09 23:02:19 | Argentina | |||
3949954 | 3949954 | 2020-04-09 | Armenia | 921 | 10 | 138 | 773 | 40.0691 | 45.0382 | 2020-04-09 23:02:19 | Armenia | |||
3949860 | 3949860 | 2020-04-09 | Australia | Australian Capital Territory | 100 | 2 | 47 | 51 | -35.4735 | 149.0124 | 2020-04-09 23:09:19 | Australian Capital Territory, Australia | ||
3949907 | 3949907 | 2020-04-09 | Australia | New South Wales | 2773 | 21 | 4 | 2748 | -33.8688 | 151.2093 | 2020-04-09 23:09:19 | New South Wales, Australia | ||
3949911 | 3949911 | 2020-04-09 | Australia | Northern Territory | 28 | 0 | 2 | 26 | -12.4634 | 130.8456 | 2020-04-09 23:09:19 | Northern Territory, Australia | ||
3949920 | 3949920 | 2020-04-09 | Australia | Queensland | 953 | 4 | 345 | 604 | -27.4698 | 153.0251 | 2020-04-09 23:09:19 | Queensland, Australia | ||
3949934 | 3949934 | 2020-04-09 | Australia | South Australia | 420 | 3 | 120 | 297 | -34.9285 | 138.6007 | 2020-04-09 23:09:19 | South Australia, Australia | ||
3949936 | 3949936 | 2020-04-09 | Australia | Tasmania | 111 | 3 | 48 | 60 | -42.8821 | 147.3272 | 2020-04-09 23:09:19 | Tasmania, Australia | ||
3949940 | 3949940 | 2020-04-09 | Australia | Victoria | 1228 | 12 | 736 | 480 | -37.8136 | 144.9631 | 2020-04-09 23:09:19 | Victoria, Australia | ||
3949942 | 3949942 | 2020-04-09 | Australia | Western Australia | 495 | 6 | 170 | 319 | -31.9505 | 115.8605 | 2020-04-09 23:09:19 | Western Australia, Australia | ||
3949955 | 3949955 | 2020-04-09 | Austria | 12915 | 325 | 5240 | 7709 | 47.5162 | 14.5501 | 2020-04-09 23:02:19 | Austria | |||
3949956 | 3949956 | 2020-04-09 | Azerbaijan | 926 | 9 | 101 | 816 | 40.1431 | 47.5769 | 2020-04-09 23:02:19 | Azerbaijan | |||
3949957 | 3949957 | 2020-04-09 | Bahamas | 41 | 8 | 5 | 28 | 25.025885 | -78.035889 | 2020-04-09 23:02:19 | Bahamas | |||
3949958 | 3949958 | 2020-04-09 | Bahrain | 887 | 5 | 519 | 363 | 26.0275 | 50.55 | 2020-04-09 23:02:19 | Bahrain | |||
3949959 | 3949959 | 2020-04-09 | Bangladesh | 330 | 21 | 33 | 276 | 23.685 | 90.3563 | 2020-04-09 23:02:19 | Bangladesh | |||
3949960 | 3949960 | 2020-04-09 | Barbados | 66 | 3 | 11 | 52 | 13.1939 | -59.5432 | 2020-04-09 23:02:19 | Barbados | |||
3949961 | 3949961 | 2020-04-09 | Belarus | 1486 | 16 | 139 | 1331 | 53.7098 | 27.9534 | 2020-04-09 23:02:19 | Belarus | |||
3949962 | 3949962 | 2020-04-09 | Belgium | 24983 | 2523 | 5164 | 17296 | 50.8333 | 4.469936 | 2020-04-09 23:02:19 | Belgium | |||
3949963 | 3949963 | 2020-04-09 | Belize | 9 | 1 | 0 | 8 | 17.1899 | -88.4976 | 2020-04-09 23:02:19 | ,,Belize | |||
3949964 | 3949964 | 2020-04-09 | Benin | 26 | 1 | 5 | 20 | 9.3077 | 2.3158 | 2020-04-09 23:02:19 | Benin | |||
3949965 | 3949965 | 2020-04-09 | Bhutan | 5 | 0 | 2 | 3 | 27.5142 | 90.4336 | 2020-04-09 23:02:19 | Bhutan | |||
3949966 | 3949966 | 2020-04-09 | Bolivia | 264 | 18 | 2 | 244 | -16.2902 | -63.5887 | 2020-04-09 23:02:19 | Bolivia | |||
3949967 | 3949967 | 2020-04-09 | Bosnia and Herzegovina | 858 | 35 | 101 | 722 | 43.9159 | 17.6791 | 2020-04-09 23:02:19 | Bosnia and Herzegovina | |||
3949968 | 3949968 | 2020-04-09 | Botswana | 13 | 1 | 0 | 12 | -22.3285 | 24.6849 | 2020-04-09 23:02:19 | Botswana | |||
3949969 | 3949969 | 2020-04-09 | Brazil | 18092 | 950 | 173 | 16969 | -14.235 | -51.9253 | 2020-04-09 23:02:19 | Brazil | |||
3949970 | 3949970 | 2020-04-09 | Brunei | 135 | 1 | 92 | 42 | 4.5353 | 114.7277 | 2020-04-09 23:02:19 | Brunei | |||
3949971 | 3949971 | 2020-04-09 | Bulgaria | 618 | 24 | 48 | 546 | 42.7339 | 25.4858 | 2020-04-09 23:02:19 | Bulgaria | |||
3949972 | 3949972 | 2020-04-09 | Burkina Faso | 443 | 24 | 146 | 273 | 12.2383 | -1.5616 | 2020-04-09 23:02:19 | Burkina Faso | |||
3949973 | 3949973 | 2020-04-09 | Burma | 23 | 3 | 2 | 18 | 21.9162 | 95.956 | 2020-04-09 23:02:19 | Burma | |||
3949974 | 3949974 | 2020-04-09 | Burundi | 3 | 0 | 0 | 3 | -3.3731 | 29.9189 | 2020-04-09 23:02:19 | Burundi | |||
3949975 | 3949975 | 2020-04-09 | Cabo Verde | 7 | 1 | 1 | 5 | 16.5388 | -23.0418 | 2020-04-09 23:02:19 | Cabo Verde | |||
3949976 | 3949976 | 2020-04-09 | Cambodia | 119 | 0 | 62 | 57 | 11.55 | 104.9167 | 2020-04-09 23:02:19 | Cambodia | |||
3949977 | 3949977 | 2020-04-09 | Cameroon | 730 | 10 | 60 | 660 | 3.8480000000000003 | 11.5021 | 2020-04-09 23:02:19 | Cameroon | |||
3949856 | 3949856 | 2020-04-09 | Canada | Alberta | 1423 | 29 | 0 | 1394 | 53.9333 | -116.5765 | 2020-04-09 23:09:01 | Alberta, Canada | ||
3949864 | 3949864 | 2020-04-09 | Canada | British Columbia | 1336 | 48 | 0 | 1288 | 53.7267 | -127.6476 | 2020-04-09 23:09:01 | British Columbia, Canada | ||
3949870 | 3949870 | 2020-04-09 | Canada | Diamond Princess | 0 | 1 | 0 | 0 | 0.0 | 0.0 | 2020-04-09 23:09:01 | Diamond Princess, Canada | ||
3949879 | 3949879 | 2020-04-09 | Canada | Grand Princess | 13 | 0 | 0 | 13 | 37.6489 | 0.0 | 2020-04-09 23:09:01 | Grand Princess, Canada | ||
3949901 | 3949901 | 2020-04-09 | Canada | Manitoba | 221 | 3 | 0 | 218 | 53.7609 | -98.8139 | 2020-04-09 23:09:01 | Manitoba, Canada | ||
3949905 | 3949905 | 2020-04-09 | Canada | New Brunswick | 108 | 0 | 0 | 108 | 46.5653 | -66.4619 | 2020-04-09 23:09:01 | New Brunswick, Canada | ||
3949908 | 3949908 | 2020-04-09 | Canada | Newfoundland and Labrador | 236 | 3 | 0 | 230 | 53.1355 | -57.6604 | 2020-04-09 23:09:01 | Newfoundland and Labrador, Canada | ||
3949912 | 3949912 | 2020-04-09 | Canada | Northwest Territories | 5 | 0 | 0 | 5 | 64.8255 | -124.8457 | 2020-04-09 23:09:01 | ,Northwest Territories,Canada | ||
3949913 | 3949913 | 2020-04-09 | Canada | Nova Scotia | 373 | 2 | 0 | 341 | 44.681999999999995 | -63.7443 | 2020-04-09 23:09:01 | Nova Scotia, Canada | ||
3949914 | 3949914 | 2020-04-09 | Canada | Nunavut | 0 | 0 | 0 | 0 | 70.2998 | -83.1076 | 2020-04-09 23:09:01 | Nunavut, Canada | ||
3949915 | 3949915 | 2020-04-09 | Canada | Ontario | 7319 | 200 | 0 | 5559 | 51.2538 | -85.3232 | 2020-04-09 23:09:01 | Ontario, Canada | ||
3949916 | 3949916 | 2020-04-09 | Canada | Prince Edward Island | 25 | 0 | 0 | 25 | 46.5107 | -63.4168 | 2020-04-09 23:09:01 | Prince Edward Island, Canada | ||
3949919 | 3949919 | 2020-04-09 | Canada | Quebec | 11760 | 484 | 0 | 11276 | 52.9399 | -73.5491 | 2020-04-09 23:09:01 | Quebec, Canada | ||
3949921 | 3949921 | 2020-04-09 | Canada | Recovered | 0 | 0 | 5162 | 0 | 0.0 | 0.0 | 2020-04-09 23:09:01 | Recovered, Canada | ||
3949927 | 3949927 | 2020-04-09 | Canada | Saskatchewan | 278 | 3 | 0 | 268 | 52.9399 | -106.4509 | 2020-04-09 23:09:01 | Saskatchewan, Canada | ||
3949944 | 3949944 | 2020-04-09 | Canada | Yukon | 7 | 0 | 0 | 7 | 64.2823 | -135.0 | 2020-04-09 23:09:01 | ,Yukon,Canada | ||
3949978 | 3949978 | 2020-04-09 | Central African Republic | 8 | 0 | 0 | 8 | 6.6111 | 20.9394 | 2020-04-09 23:02:19 | Central African Republic | |||
3949979 | 3949979 | 2020-04-09 | Chad | 11 | 0 | 2 | 9 | 15.4542 | 18.7322 | 2020-04-09 23:02:19 | Chad | |||
3949980 | 3949980 | 2020-04-09 | Chile | 5972 | 57 | 1274 | 4641 | -35.6751 | -71.543 | 2020-04-09 23:02:19 | Chile | |||
43074 | 43074 | 2020-04-13 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
43092 | 43092 | 2020-04-13 | China | Gansu | 139 | 2 | 135 | 2 | 37.8099 | 101.0583 | 2020-04-09 02:02:54 | Gansu, China | ||
43103 | 43103 | 2020-04-13 | China | Hebei | 327 | 6 | 313 | 8 | 39.549 | 116.1306 | 2020-04-09 00:59:02 | Hebei, China | ||
50173 | 50173 | 2020-04-17 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
418701 | 418701 | 2020-04-18 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
522239 | 522239 | 2020-04-21 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
860061 | 860061 | 2020-04-15 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
934167 | 934167 | 2020-04-16 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
1199174 | 1199174 | 2020-04-22 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
1250121 | 1250121 | 2020-04-10 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
1250140 | 1250140 | 2020-04-10 | China | Gansu | 139 | 2 | 135 | 2 | 37.8099 | 101.0583 | 2020-04-09 02:02:54 | Gansu, China | ||
1250151 | 1250151 | 2020-04-10 | China | Hebei | 327 | 6 | 313 | 8 | 39.549 | 116.1306 | 2020-04-09 00:59:02 | Hebei, China | ||
1250162 | 1250162 | 2020-04-10 | China | Liaoning | 144 | 2 | 132 | 10 | 41.2956 | 122.6085 | 2020-04-09 12:08:14 | Liaoning, China | ||
1250192 | 1250192 | 2020-04-10 | China | Shandong | 783 | 7 | 756 | 20 | 36.3427 | 118.1498 | 2020-04-09 00:40:50 | Shandong, China | ||
1250209 | 1250209 | 2020-04-10 | China | Zhejiang | 1267 | 1 | 1235 | 31 | 29.1832 | 120.0934 | 2020-04-09 01:45:42 | Zhejiang, China | ||
1385013 | 1385013 | 2020-04-19 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
2473321 | 2473321 | 2020-04-20 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
2524731 | 2524731 | 2020-04-23 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
2566936 | 2566936 | 2020-04-11 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
2566955 | 2566955 | 2020-04-11 | China | Gansu | 139 | 2 | 135 | 2 | 37.8099 | 101.0583 | 2020-04-09 02:02:54 | Gansu, China | ||
2566966 | 2566966 | 2020-04-11 | China | Hebei | 327 | 6 | 313 | 8 | 39.549 | 116.1306 | 2020-04-09 00:59:02 | Hebei, China | ||
2578100 | 2578100 | 2020-04-12 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:00 | Anhui, China | ||
2578118 | 2578118 | 2020-04-12 | China | Gansu | 139 | 2 | 135 | 2 | 37.8099 | 101.0583 | 2020-04-09 02:02:00 | Gansu, China | ||
2578129 | 2578129 | 2020-04-12 | China | Hebei | 327 | 6 | 313 | 8 | 39.549 | 116.1306 | 2020-04-09 00:59:00 | Hebei, China | ||
3337977 | 3337977 | 2020-04-14 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
3949858 | 3949858 | 2020-04-09 | China | Anhui | 991 | 6 | 984 | 1 | 31.8257 | 117.2264 | 2020-04-09 01:12:20 | Anhui, China | ||
3949861 | 3949861 | 2020-04-09 | China | Beijing | 588 | 8 | 464 | 116 | 40.1824 | 116.4142 | 2020-04-09 01:12:20 | Beijing, China | ||
3949877 | 3949877 | 2020-04-09 | China | Gansu | 139 | 2 | 135 | 2 | 37.8099 | 101.0583 | 2020-04-09 02:02:54 | Gansu, China | ||
3949884 | 3949884 | 2020-04-09 | China | Guangdong | 1539 | 8 | 1423 | 108 | 23.3417 | 113.4244 | 2020-04-09 01:12:20 | Guangdong, China | ||
3949888 | 3949888 | 2020-04-09 | China | Hebei | 327 | 6 | 313 | 8 | 39.549 | 116.1306 | 2020-04-09 00:59:02 | Hebei, China | ||
3949889 | 3949889 | 2020-04-09 | China | Heilongjiang | 609 | 13 | 470 | 126 | 47.861999999999995 | 127.7615 | 2020-04-09 00:52:58 | Heilongjiang, China | ||
3949891 | 3949891 | 2020-04-09 | China | Hong Kong | 973 | 4 | 293 | 676 | 22.3 | 114.2 | 2020-04-09 09:16:48 | Hong Kong, China | ||
3949892 | 3949892 | 2020-04-09 | China | Hubei | 67803 | 3215 | 64187 | 401 | 30.9756 | 112.2707 | 2020-04-09 01:34:36 | Hubei, China | ||
3949894 | 3949894 | 2020-04-09 | China | Inner Mongolia | 126 | 1 | 79 | 46 | 44.0935 | 113.9448 | 2020-04-09 02:42:30 | Inner Mongolia, China | ||
3949899 | 3949899 | 2020-04-09 | China | Liaoning | 144 | 2 | 132 | 10 | 41.2956 | 122.6085 | 2020-04-09 12:08:14 | Liaoning, China | ||
3949929 | 3949929 | 2020-04-09 | China | Shandong | 783 | 7 | 756 | 20 | 36.3427 | 118.1498 | 2020-04-09 00:40:50 | Shandong, China | ||
3949930 | 3949930 | 2020-04-09 | China | Shanghai | 552 | 7 | 422 | 123 | 31.201999999999998 | 121.4491 | 2020-04-09 07:01:54 | Shanghai, China | ||
3949931 | 3949931 | 2020-04-09 | China | Shanxi | 166 | 0 | 134 | 32 | 37.5777 | 112.2922 | 2020-04-09 00:28:41 | Shanxi, China | ||
3949937 | 3949937 | 2020-04-09 | China | Tianjin | 182 | 3 | 152 | 27 | 39.3054 | 117.323 | 2020-04-09 06:51:46 | Tianjin, China | ||
3949946 | 3949946 | 2020-04-09 | China | Zhejiang | 1267 | 1 | 1235 | 31 | 29.1832 | 120.0934 | 2020-04-09 01:45:42 | Zhejiang, China | ||
3950126 | 3950126 | 2020-04-09 | China | Unknown | 2141 | 0 | 0 | 0 | 2020-04-09 23:02:37 | Unknown, China |
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]);