johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
148 rows where "last_update" is on date 2020-03-01 sorted by rowid
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40257 | 40257 | 2020-03-05 | Armenia | 1 | 0 | 0 | 40.0691 | 45.0382 | 2020-03-01T19:53:02 | |||||
62624 | 62624 | 2020-03-07 | Armenia | 1 | 0 | 0 | 40.0691 | 45.0382 | 2020-03-01T19:53:02 | |||||
98881 | 98881 | 2020-03-04 | Finland | 14 | 0 | 1 | 64.0 | 26.0 | 2020-03-01T23:23:02 | |||||
98891 | 98891 | 2020-03-04 | Azerbaijan | 3 | 0 | 0 | 40.1431 | 47.5769 | 2020-03-01T02:43:03 | |||||
98892 | 98892 | 2020-03-04 | Georgia | 3 | 0 | 0 | 42.3154 | 43.3569 | 2020-03-01T15:43:03 | |||||
98898 | 98898 | 2020-03-04 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
98899 | 98899 | 2020-03-04 | Egypt | 2 | 0 | 1 | 26.0 | 30.0 | 2020-03-01T23:33:03 | |||||
98916 | 98916 | 2020-03-04 | Armenia | 1 | 0 | 0 | 40.0691 | 45.0382 | 2020-03-01T19:53:02 | |||||
261086 | 261086 | 2020-03-03 | Greece | 7 | 0 | 0 | 39.0742 | 21.8243 | 2020-03-01T23:23:02 | |||||
261089 | 261089 | 2020-03-03 | Finland | 10 | 0 | 1 | 64.0 | 26.0 | 2020-03-01T23:23:02 | |||||
261098 | 261098 | 2020-03-03 | Azerbaijan | 3 | 0 | 0 | 40.1431 | 47.5769 | 2020-03-01T02:43:03 | |||||
261099 | 261099 | 2020-03-03 | Georgia | 3 | 0 | 0 | 42.3154 | 43.3569 | 2020-03-01T15:43:03 | |||||
261103 | 261103 | 2020-03-03 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
261105 | 261105 | 2020-03-03 | Egypt | 2 | 0 | 1 | 26.0 | 30.0 | 2020-03-01T23:33:03 | |||||
261123 | 261123 | 2020-03-03 | Armenia | 1 | 0 | 0 | 40.0691 | 45.0382 | 2020-03-01T19:53:02 | |||||
562493 | 562493 | 2020-03-01 | Mainland China | Hubei | 66907 | 2761 | 31536 | 30.9756 | 112.2707 | 2020-03-01T10:13:19 | ||||
562494 | 562494 | 2020-03-01 | South Korea | 3736 | 17 | 30 | 36.0 | 128.0 | 2020-03-01T23:43:03 | |||||
562495 | 562495 | 2020-03-01 | Italy | 1694 | 34 | 83 | 43.0 | 12.0 | 2020-03-01T23:23:02 | |||||
562496 | 562496 | 2020-03-01 | Mainland China | Guangdong | 1349 | 7 | 1016 | 23.3417 | 113.4244 | 2020-03-01T14:13:18 | ||||
562497 | 562497 | 2020-03-01 | Mainland China | Henan | 1272 | 22 | 1198 | 33.882 | 113.614 | 2020-03-01T14:13:18 | ||||
562498 | 562498 | 2020-03-01 | Mainland China | Zhejiang | 1205 | 1 | 1046 | 29.1832 | 120.0934 | 2020-03-01T10:13:33 | ||||
562499 | 562499 | 2020-03-01 | Mainland China | Hunan | 1018 | 4 | 866 | 27.6104 | 111.7088 | 2020-03-01T10:03:03 | ||||
562500 | 562500 | 2020-03-01 | Mainland China | Anhui | 990 | 6 | 873 | 31.8257 | 117.2264 | 2020-03-01T10:03:03 | ||||
562501 | 562501 | 2020-03-01 | Iran | 978 | 54 | 175 | 32.0 | 53.0 | 2020-03-01T15:33:03 | |||||
562502 | 562502 | 2020-03-01 | Mainland China | Jiangxi | 935 | 1 | 831 | 27.614 | 115.7221 | 2020-03-01T01:13:10 | ||||
562503 | 562503 | 2020-03-01 | Mainland China | Shandong | 758 | 6 | 443 | 36.3427 | 118.1498 | 2020-03-01T11:33:03 | ||||
562505 | 562505 | 2020-03-01 | Mainland China | Jiangsu | 631 | 0 | 536 | 32.9711 | 119.455 | 2020-03-01T10:03:03 | ||||
562506 | 562506 | 2020-03-01 | Mainland China | Chongqing | 576 | 6 | 450 | 30.0572 | 107.874 | 2020-03-01T23:13:08 | ||||
562507 | 562507 | 2020-03-01 | Mainland China | Sichuan | 538 | 3 | 365 | 30.6171 | 102.7103 | 2020-03-01T11:43:02 | ||||
562508 | 562508 | 2020-03-01 | Mainland China | Heilongjiang | 480 | 13 | 342 | 47.862 | 127.7615 | 2020-03-01T11:33:03 | ||||
562509 | 562509 | 2020-03-01 | Mainland China | Beijing | 413 | 8 | 276 | 40.1824 | 116.4142 | 2020-03-01T02:53:03 | ||||
562510 | 562510 | 2020-03-01 | Mainland China | Shanghai | 337 | 3 | 290 | 31.202 | 121.4491 | 2020-03-01T07:13:07 | ||||
562511 | 562511 | 2020-03-01 | Mainland China | Hebei | 318 | 6 | 294 | 38.0428 | 114.5149 | 2020-03-01T14:13:18 | ||||
562512 | 562512 | 2020-03-01 | Mainland China | Fujian | 296 | 1 | 247 | 26.0789 | 117.9874 | 2020-03-01T09:43:03 | ||||
562513 | 562513 | 2020-03-01 | Japan | 256 | 6 | 32 | 36.0 | 138.0 | 2020-03-01T23:33:03 | |||||
562514 | 562514 | 2020-03-01 | Mainland China | Guangxi | 252 | 2 | 181 | 23.8298 | 108.7881 | 2020-03-01T09:43:03 | ||||
562515 | 562515 | 2020-03-01 | Mainland China | Shaanxi | 245 | 1 | 208 | 35.1917 | 108.8701 | 2020-03-01T09:43:03 | ||||
562516 | 562516 | 2020-03-01 | Mainland China | Yunnan | 174 | 2 | 163 | 24.974 | 101.487 | 2020-03-01T07:13:07 | ||||
562517 | 562517 | 2020-03-01 | Mainland China | Hainan | 168 | 5 | 149 | 19.1959 | 109.7453 | 2020-03-01T10:13:38 | ||||
562519 | 562519 | 2020-03-01 | Mainland China | Tianjin | 136 | 3 | 111 | 39.3054 | 117.323 | 2020-03-01T12:43:02 | ||||
562520 | 562520 | 2020-03-01 | Mainland China | Shanxi | 133 | 0 | 116 | 37.5777 | 112.2922 | 2020-03-01T23:13:08 | ||||
562521 | 562521 | 2020-03-01 | France | 130 | 2 | 12 | 47.0 | 2.0 | 2020-03-01T20:43:02 | |||||
562522 | 562522 | 2020-03-01 | Germany | 130 | 0 | 16 | 51.0 | 9.0 | 2020-03-01T23:23:02 | |||||
562523 | 562523 | 2020-03-01 | Mainland China | Liaoning | 122 | 1 | 103 | 41.2956 | 122.6085 | 2020-03-01T12:23:06 | ||||
562524 | 562524 | 2020-03-01 | Singapore | 106 | 0 | 72 | 1.2833 | 103.8333 | 2020-03-01T23:23:02 | |||||
562525 | 562525 | 2020-03-01 | Hong Kong | Hong Kong | 96 | 2 | 36 | 22.3 | 114.2 | 2020-03-01T14:33:16 | ||||
562526 | 562526 | 2020-03-01 | Mainland China | Jilin | 93 | 1 | 78 | 43.6661 | 126.1923 | 2020-03-01T09:43:03 | ||||
562527 | 562527 | 2020-03-01 | Mainland China | Gansu | 91 | 2 | 84 | 36.0611 | 103.8343 | 2020-03-01T14:33:17 | ||||
562528 | 562528 | 2020-03-01 | Spain | 84 | 0 | 2 | 40.0 | -4.0 | 2020-03-01T23:33:03 | |||||
562529 | 562529 | 2020-03-01 | Mainland China | Xinjiang | 76 | 3 | 64 | 41.1129 | 85.2401 | 2020-03-01T10:03:03 | ||||
562530 | 562530 | 2020-03-01 | Mainland China | Inner Mongolia | 75 | 0 | 52 | 44.0935 | 113.9448 | 2020-03-01T10:03:03 | ||||
562532 | 562532 | 2020-03-01 | Bahrain | 47 | 0 | 0 | 26.0275 | 50.55 | 2020-03-01T23:33:03 | |||||
562535 | 562535 | 2020-03-01 | Thailand | 42 | 1 | 30 | 15.0 | 101.0 | 2020-03-01T07:13:07 | |||||
562536 | 562536 | 2020-03-01 | Taiwan | Taiwan | 40 | 1 | 9 | 23.7 | 121.0 | 2020-03-01T07:43:01 | ||||
562537 | 562537 | 2020-03-01 | United Kingdom | Unknown | 36 | 0 | 8 | 55.0 | -3.0 | 2020-03-01T23:23:02 | ||||
562538 | 562538 | 2020-03-01 | Switzerland | 27 | 0 | 0 | 46.8182 | 8.2275 | 2020-03-01T23:23:02 | |||||
562540 | 562540 | 2020-03-01 | Iraq | 19 | 0 | 0 | 33.0 | 44.0 | 2020-03-01T16:43:02 | |||||
562541 | 562541 | 2020-03-01 | Norway | 19 | 0 | 0 | 60.472 | 8.4689 | 2020-03-01T20:43:02 | |||||
562544 | 562544 | 2020-03-01 | Austria | 7 | 0 | 0 | 47.5162 | 14.5501 | 2020-03-01T23:33:03 | |||||
562545 | 562545 | 2020-03-01 | Canada | Toronto, ON | 14 | 0 | 2 | 43.6532 | -79.3832 | 2020-03-01T23:33:03 | ||||
562546 | 562546 | 2020-03-01 | Sweden | 14 | 0 | 0 | 63.0 | 16.0 | 2020-03-01T23:23:02 | |||||
562547 | 562547 | 2020-03-01 | Israel | 7 | 0 | 0 | 31.0 | 35.0 | 2020-03-01T23:23:02 | |||||
562548 | 562548 | 2020-03-01 | Lebanon | 10 | 0 | 0 | 33.8547 | 35.8623 | 2020-03-01T15:33:03 | |||||
562550 | 562550 | 2020-03-01 | Netherlands | 10 | 0 | 0 | 52.1326 | 5.2913 | 2020-03-01T15:33:03 | |||||
562552 | 562552 | 2020-03-01 | US | Seattle, WA | 9 | 1 | 1 | 47.6062 | -122.3321 | 2020-03-01T21:13:12 | ||||
562555 | 562555 | 2020-03-01 | Croatia | 7 | 0 | 0 | 45.1 | 15.2 | 2020-03-01T23:33:03 | |||||
562556 | 562556 | 2020-03-01 | Greece | 7 | 0 | 0 | 39.0742 | 21.8243 | 2020-03-01T23:23:02 | |||||
562557 | 562557 | 2020-03-01 | Australia | New South Wales | 6 | 0 | 4 | -33.8688 | 151.2093 | 2020-03-01T23:33:03 | ||||
562558 | 562558 | 2020-03-01 | Ecuador | 6 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-01T23:33:03 | |||||
562559 | 562559 | 2020-03-01 | Finland | 9 | 0 | 1 | 64.0 | 26.0 | 2020-03-01T23:23:02 | |||||
562561 | 562561 | 2020-03-01 | Mexico | 5 | 0 | 0 | 23.0 | -102.0 | 2020-03-01T23:33:03 | |||||
562562 | 562562 | 2020-03-01 | Denmark | 4 | 0 | 0 | 56.2639 | 9.5018 | 2020-03-01T23:33:03 | |||||
562565 | 562565 | 2020-03-01 | Azerbaijan | 3 | 0 | 0 | 40.1431 | 47.5769 | 2020-03-01T02:43:03 | |||||
562566 | 562566 | 2020-03-01 | Czech Republic | 3 | 0 | 0 | 49.8175 | 15.473 | 2020-03-01T15:53:06 | |||||
562567 | 562567 | 2020-03-01 | Georgia | 3 | 0 | 0 | 42.3154 | 43.3569 | 2020-03-01T15:43:03 | |||||
562568 | 562568 | 2020-03-01 | Iceland | 3 | 0 | 0 | 64.9631 | -19.0208 | 2020-03-01T23:33:03 | |||||
562571 | 562571 | 2020-03-01 | Qatar | 3 | 0 | 0 | 25.3548 | 51.1839 | 2020-03-01T23:33:03 | |||||
562573 | 562573 | 2020-03-01 | US | Chicago, IL | 3 | 0 | 2 | 41.8781 | -87.6298 | 2020-03-01T03:53:02 | ||||
562575 | 562575 | 2020-03-01 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
562576 | 562576 | 2020-03-01 | Belgium | 2 | 0 | 1 | 50.8333 | 4.0 | 2020-03-01T12:43:02 | |||||
562578 | 562578 | 2020-03-01 | Egypt | 2 | 0 | 1 | 26.0 | 30.0 | 2020-03-01T23:33:03 | |||||
562583 | 562583 | 2020-03-01 | US | Snohomish County, WA | 2 | 0 | 0 | 48.033 | -121.8339 | 2020-03-01T20:23:06 | ||||
562586 | 562586 | 2020-03-01 | Armenia | 1 | 0 | 0 | 40.0691 | 45.0382 | 2020-03-01T19:53:02 | |||||
562591 | 562591 | 2020-03-01 | Dominican Republic | 1 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-01T16:03:06 | |||||
562593 | 562593 | 2020-03-01 | Ireland | 1 | 0 | 0 | 53.1424 | -7.6921 | 2020-03-01T07:13:07 | |||||
562595 | 562595 | 2020-03-01 | Luxembourg | 1 | 0 | 0 | 49.8153 | 6.1296 | 2020-03-01T07:13:07 | |||||
562602 | 562602 | 2020-03-01 | San Marino | 1 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-01T07:13:07 | |||||
562610 | 562610 | 2020-03-01 | US | Providence, RI | 1 | 0 | 0 | 41.824 | -71.4128 | 2020-03-01T15:33:03 | ||||
562617 | 562617 | 2020-03-01 | China | Unknown | 0 | 0 | 0 | 2020-03-01T10:13:19 | ||||||
562618 | 562618 | 2020-03-01 | Kiribati | 0 | 0 | 0 | -3.3704 | -168.734 | 2020-03-01T10:13:19 | |||||
562619 | 562619 | 2020-03-01 | Palau | 0 | 0 | 0 | 7.515 | 134.5825 | 2020-03-01T10:13:19 | |||||
562620 | 562620 | 2020-03-01 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-01T10:13:19 | ||||
562621 | 562621 | 2020-03-01 | Summer Olympics 2020 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-01T10:13:19 | |||||
562622 | 562622 | 2020-03-01 | Malaysia | Johor | 0 | 0 | 0 | 1.4854 | 103.7618 | 2020-03-01T10:13:19 | ||||
562623 | 562623 | 2020-03-01 | Malaysia | Kedah | 0 | 0 | 0 | 6.1184 | 100.3685 | 2020-03-01T10:13:19 | ||||
562624 | 562624 | 2020-03-01 | Malaysia | Kelantan | 0 | 0 | 0 | 6.1254 | 102.2381 | 2020-03-01T10:13:19 | ||||
562625 | 562625 | 2020-03-01 | Malaysia | Melaka | 0 | 0 | 0 | 2.1896 | 102.2501 | 2020-03-01T10:13:19 | ||||
562626 | 562626 | 2020-03-01 | Malaysia | Negeri Sembilan | 0 | 0 | 0 | 2.7258 | 101.9424 | 2020-03-01T10:13:19 | ||||
562627 | 562627 | 2020-03-01 | Malaysia | Pahang | 0 | 0 | 0 | 3.8126 | 103.3256 | 2020-03-01T10:13:19 | ||||
562628 | 562628 | 2020-03-01 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-03-01T10:13:19 |
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]);