johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
161 rows where "day" is on date 2020-03-01 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date)
These facets timed out: province_or_state
country_or_region >30
- Mainland China 31
- US 20
- Malaysia 17
- United Kingdom 8
- Australia 6
- Canada 4
- New Zealand 3
- Afghanistan 1
- Algeria 1
- Antarctica 1
- Armenia 1
- Austria 1
- Azerbaijan 1
- Bahrain 1
- Belarus 1
- Belgium 1
- Brazil 1
- Cambodia 1
- China 1
- Croatia 1
- Czech Republic 1
- Denmark 1
- Dominican Republic 1
- Ecuador 1
- Egypt 1
- Estonia 1
- Finland 1
- France 1
- Georgia 1
- Germany 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
562653 | 562653 | 2020-03-01 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-03-01T10:13:19 | ||||
562652 | 562652 | 2020-03-01 | Tuvalu | 0 | 0 | 0 | -7.1095 | 177.6493 | 2020-03-01T10:13:19 | |||||
562651 | 562651 | 2020-03-01 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-01T10:13:19 | ||||
562650 | 562650 | 2020-03-01 | Nauru | 0 | 0 | 0 | -0.5228 | 166.9315 | 2020-03-01T10:13:19 | |||||
562649 | 562649 | 2020-03-01 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2020-03-01T10:13:19 | ||||
562648 | 562648 | 2020-03-01 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-03-01T10:13:19 | ||||
562647 | 562647 | 2020-03-01 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 2020-03-01T10:13:19 | ||||
562646 | 562646 | 2020-03-01 | United Kingdom | England | 0 | 3 | 0 | 52.3555 | -1.1743 | 2020-03-01T10:13:19 | ||||
562645 | 562645 | 2020-03-01 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-01T10:13:19 | ||||||
562644 | 562644 | 2020-03-01 | Korea, North | 0 | 0 | 0 | 40.3399 | 127.5101 | 2020-03-01T10:13:19 | |||||
562643 | 562643 | 2020-03-01 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-01T10:13:19 | ||||
562642 | 562642 | 2020-03-01 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-01T10:13:19 | ||||
562641 | 562641 | 2020-03-01 | Antarctica | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-03-01T10:13:19 | |||||
562640 | 562640 | 2020-03-01 | Winter Olympics 2022 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2020-03-01T10:13:19 | |||||
562639 | 562639 | 2020-03-01 | Tonga | 0 | 0 | 0 | -21.179 | -175.1982 | 2020-03-01T10:13:19 | |||||
562638 | 562638 | 2020-03-01 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-01T10:13:19 | ||||||
562637 | 562637 | 2020-03-01 | Malaysia | W.P. Putrajaya | 0 | 0 | 0 | 2.9264 | 101.6964 | 2020-03-01T10:13:19 | ||||
562636 | 562636 | 2020-03-01 | Malaysia | W.P. Labuan | 0 | 0 | 0 | 5.2831 | 115.2308 | 2020-03-01T10:13:19 | ||||
562635 | 562635 | 2020-03-01 | Malaysia | W.P. Kuala Lumpur | 0 | 0 | 0 | 3.139 | 101.6869 | 2020-03-01T10:13:19 | ||||
562634 | 562634 | 2020-03-01 | Malaysia | Terengganu | 0 | 0 | 0 | 5.3117 | 103.1324 | 2020-03-01T10:13:19 | ||||
562633 | 562633 | 2020-03-01 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-01T10:13:19 | ||||
562632 | 562632 | 2020-03-01 | Malaysia | Sarawak | 0 | 0 | 0 | 1.5533 | 110.3592 | 2020-03-01T10:13:19 | ||||
562631 | 562631 | 2020-03-01 | Malaysia | Sabah | 0 | 0 | 0 | 5.9788 | 116.0753 | 2020-03-01T10:13:19 | ||||
562630 | 562630 | 2020-03-01 | Malaysia | Pulau Pinang | 0 | 0 | 0 | 5.4141 | 100.3288 | 2020-03-01T10:13:19 | ||||
562629 | 562629 | 2020-03-01 | Malaysia | Perlis | 0 | 0 | 0 | 6.4449 | 100.2048 | 2020-03-01T10:13:19 | ||||
562628 | 562628 | 2020-03-01 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-03-01T10:13:19 | ||||
562627 | 562627 | 2020-03-01 | Malaysia | Pahang | 0 | 0 | 0 | 3.8126 | 103.3256 | 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 | ||||
562625 | 562625 | 2020-03-01 | Malaysia | Melaka | 0 | 0 | 0 | 2.1896 | 102.2501 | 2020-03-01T10:13:19 | ||||
562624 | 562624 | 2020-03-01 | Malaysia | Kelantan | 0 | 0 | 0 | 6.1254 | 102.2381 | 2020-03-01T10:13:19 | ||||
562623 | 562623 | 2020-03-01 | Malaysia | Kedah | 0 | 0 | 0 | 6.1184 | 100.3685 | 2020-03-01T10:13:19 | ||||
562622 | 562622 | 2020-03-01 | Malaysia | Johor | 0 | 0 | 0 | 1.4854 | 103.7618 | 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 | |||||
562620 | 562620 | 2020-03-01 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-01T10:13:19 | ||||
562619 | 562619 | 2020-03-01 | Palau | 0 | 0 | 0 | 7.515 | 134.5825 | 2020-03-01T10:13:19 | |||||
562618 | 562618 | 2020-03-01 | Kiribati | 0 | 0 | 0 | -3.3704 | -168.734 | 2020-03-01T10:13:19 | |||||
562617 | 562617 | 2020-03-01 | China | Unknown | 0 | 0 | 0 | 2020-03-01T10:13:19 | ||||||
562616 | 562616 | 2020-03-01 | US | Travis, CA (From Diamond Princess) | 0 | 0 | 0 | 38.2721 | -121.9399 | 2020-02-24T23:33:02 | ||||
562615 | 562615 | 2020-03-01 | US | Omaha, NE (From Diamond Princess) | 0 | 0 | 0 | 41.2545 | -95.9758 | 2020-02-24T23:33:02 | ||||
562614 | 562614 | 2020-03-01 | US | Lackland, TX (From Diamond Princess) | 0 | 0 | 0 | 29.3829 | -98.6134 | 2020-02-24T23:33:02 | ||||
562613 | 562613 | 2020-03-01 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
562612 | 562612 | 2020-03-01 | US | Tempe, AZ | 1 | 0 | 1 | 33.4255 | -111.94 | 2020-02-25T21:23:03 | ||||
562611 | 562611 | 2020-03-01 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
562610 | 562610 | 2020-03-01 | US | Providence, RI | 1 | 0 | 0 | 41.824 | -71.4128 | 2020-03-01T15:33:03 | ||||
562609 | 562609 | 2020-03-01 | US | Portland, OR | 1 | 0 | 0 | 45.5051 | -122.675 | 2020-02-29T02:23:11 | ||||
562608 | 562608 | 2020-03-01 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
562607 | 562607 | 2020-03-01 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
562606 | 562606 | 2020-03-01 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
562605 | 562605 | 2020-03-01 | US | Humboldt County, CA | 1 | 0 | 0 | 40.745 | -123.8695 | 2020-02-21T05:13:09 | ||||
562604 | 562604 | 2020-03-01 | US | Boston, MA | 1 | 0 | 1 | 42.3601 | -71.0589 | 2020-02-28T21:13:12 | ||||
562603 | 562603 | 2020-03-01 | Sri Lanka | 1 | 0 | 1 | 7.0 | 81.0 | 2020-02-08T03:43:03 | |||||
562602 | 562602 | 2020-03-01 | San Marino | 1 | 1 | 0 | 43.9424 | 12.4578 | 2020-03-01T07:13:07 | |||||
562601 | 562601 | 2020-03-01 | North Macedonia | 1 | 0 | 0 | 41.6086 | 21.7453 | 2020-02-27T16:23:03 | |||||
562600 | 562600 | 2020-03-01 | Nigeria | 1 | 0 | 0 | 9.082 | 8.6753 | 2020-02-28T16:23:03 | |||||
562599 | 562599 | 2020-03-01 | New Zealand | 1 | 0 | 0 | -40.9006 | 174.886 | 2020-02-28T16:23:03 | |||||
562598 | 562598 | 2020-03-01 | Nepal | 1 | 0 | 1 | 28.1667 | 84.25 | 2020-02-12T14:43:03 | |||||
562597 | 562597 | 2020-03-01 | Monaco | 1 | 0 | 0 | 43.7333 | 7.4167 | 2020-02-29T00:33:01 | |||||
562596 | 562596 | 2020-03-01 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
562595 | 562595 | 2020-03-01 | Luxembourg | 1 | 0 | 0 | 49.8153 | 6.1296 | 2020-03-01T07:13:07 | |||||
562594 | 562594 | 2020-03-01 | Lithuania | 0 | 0 | 0 | 55.1694 | 23.8813 | 2020-02-28T16:23:03 | |||||
562593 | 562593 | 2020-03-01 | Ireland | 1 | 0 | 0 | 53.1424 | -7.6921 | 2020-03-01T07:13:07 | |||||
562592 | 562592 | 2020-03-01 | Estonia | 1 | 0 | 0 | 58.5953 | 25.0136 | 2020-02-27T16:23:03 | |||||
562591 | 562591 | 2020-03-01 | Dominican Republic | 1 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-01T16:03:06 | |||||
562590 | 562590 | 2020-03-01 | Canada | London, ON | 1 | 0 | 1 | 42.9849 | -81.2453 | 2020-02-12T18:53:03 | ||||
562589 | 562589 | 2020-03-01 | Canada | Montreal, QC | 3 | 0 | 0 | 45.5017 | -73.5673 | 2020-02-28T05:23:07 | ||||
562588 | 562588 | 2020-03-01 | Cambodia | 1 | 0 | 1 | 11.55 | 104.9167 | 2020-02-12T07:43:02 | |||||
562587 | 562587 | 2020-03-01 | Belarus | 1 | 0 | 0 | 53.7098 | 27.9534 | 2020-02-28T16:23:03 | |||||
562586 | 562586 | 2020-03-01 | Armenia | 1 | 0 | 0 | 40.0691 | 45.0382 | 2020-03-01T19:53:02 | |||||
562585 | 562585 | 2020-03-01 | Algeria | 1 | 0 | 0 | 28.0339 | 1.6596 | 2020-02-25T23:43:03 | |||||
562584 | 562584 | 2020-03-01 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
562583 | 562583 | 2020-03-01 | US | Snohomish County, WA | 2 | 0 | 0 | 48.033 | -121.8339 | 2020-03-01T20:23:06 | ||||
562582 | 562582 | 2020-03-01 | US | San Diego County, CA | 2 | 0 | 1 | 32.7157 | -117.1611 | 2020-02-21T05:43:02 | ||||
562581 | 562581 | 2020-03-01 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
562580 | 562580 | 2020-03-01 | US | Sacramento County, CA | 2 | 0 | 0 | 38.4747 | -121.3542 | 2020-02-27T20:33:02 | ||||
562579 | 562579 | 2020-03-01 | Russia | 2 | 0 | 2 | 60.0 | 90.0 | 2020-02-12T14:43:03 | |||||
562578 | 562578 | 2020-03-01 | Egypt | 2 | 0 | 1 | 26.0 | 30.0 | 2020-03-01T23:33:03 | |||||
562577 | 562577 | 2020-03-01 | Brazil | 2 | 0 | 0 | -14.235 | -51.9253 | 2020-02-29T21:03:05 | |||||
562576 | 562576 | 2020-03-01 | Belgium | 2 | 0 | 1 | 50.8333 | 4.0 | 2020-03-01T12:43:02 | |||||
562575 | 562575 | 2020-03-01 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
562574 | 562574 | 2020-03-01 | US | Santa Clara, CA | 3 | 0 | 1 | 37.3541 | -121.9552 | 2020-02-29T01:33:03 | ||||
562573 | 562573 | 2020-03-01 | US | Chicago, IL | 3 | 0 | 2 | 41.8781 | -87.6298 | 2020-03-01T03:53:02 | ||||
562572 | 562572 | 2020-03-01 | Romania | 3 | 0 | 0 | 45.9432 | 24.9668 | 2020-02-28T15:33:03 | |||||
562571 | 562571 | 2020-03-01 | Qatar | 3 | 0 | 0 | 25.3548 | 51.1839 | 2020-03-01T23:33:03 | |||||
562570 | 562570 | 2020-03-01 | Philippines | 3 | 1 | 1 | 13.0 | 122.0 | 2020-02-12T07:43:02 | |||||
562569 | 562569 | 2020-03-01 | India | 3 | 0 | 3 | 21.0 | 78.0 | 2020-02-16T07:43:02 | |||||
562568 | 562568 | 2020-03-01 | Iceland | 3 | 0 | 0 | 64.9631 | -19.0208 | 2020-03-01T23:33:03 | |||||
562567 | 562567 | 2020-03-01 | Georgia | 3 | 0 | 0 | 42.3154 | 43.3569 | 2020-03-01T15:43:03 | |||||
562566 | 562566 | 2020-03-01 | Czech Republic | 3 | 0 | 0 | 49.8175 | 15.473 | 2020-03-01T15:53:06 | |||||
562565 | 562565 | 2020-03-01 | Azerbaijan | 3 | 0 | 0 | 40.1431 | 47.5769 | 2020-03-01T02:43:03 | |||||
562564 | 562564 | 2020-03-01 | Australia | South Australia | 3 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-29T02:03:10 | ||||
562563 | 562563 | 2020-03-01 | Pakistan | 4 | 0 | 0 | 30.3753 | 69.3451 | 2020-02-29T18:03:05 | |||||
562562 | 562562 | 2020-03-01 | Denmark | 4 | 0 | 0 | 56.2639 | 9.5018 | 2020-03-01T23:33:03 | |||||
562561 | 562561 | 2020-03-01 | Mexico | 5 | 0 | 0 | 23.0 | -102.0 | 2020-03-01T23:33:03 | |||||
562560 | 562560 | 2020-03-01 | Oman | 6 | 0 | 1 | 21.0 | 57.0 | 2020-02-29T12:33:03 | |||||
562559 | 562559 | 2020-03-01 | Finland | 9 | 0 | 1 | 64.0 | 26.0 | 2020-03-01T23:23:02 | |||||
562558 | 562558 | 2020-03-01 | Ecuador | 6 | 0 | 0 | -1.8312 | -78.1834 | 2020-03-01T23:33:03 | |||||
562557 | 562557 | 2020-03-01 | Australia | New South Wales | 6 | 0 | 4 | -33.8688 | 151.2093 | 2020-03-01T23:33:03 | ||||
562556 | 562556 | 2020-03-01 | Greece | 7 | 0 | 0 | 39.0742 | 21.8243 | 2020-03-01T23:23:02 | |||||
562555 | 562555 | 2020-03-01 | Croatia | 7 | 0 | 0 | 45.1 | 15.2 | 2020-03-01T23:33:03 | |||||
562554 | 562554 | 2020-03-01 | Australia | Victoria | 7 | 0 | 4 | -37.8136 | 144.9631 | 2020-02-29T02:03:10 |
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]);