daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
177 rows where "day" is on date 2020-03-02 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
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-02 | United Kingdom | Pitcairn Islands | 0 | 0 | 0 | -24.3768 | -128.3242 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Tuvalu | 0 | 0 | 0 | -7.1095 | 177.6493 | 2020-03-02T15:03:23 | |||||
2020-03-02 | New Zealand | Niue | 0 | 0 | 0 | -19.0544 | -169.8672 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Nauru | 0 | 0 | 0 | -0.5228 | 166.9315 | 2020-03-02T15:03:23 | |||||
2020-03-02 | United Kingdom | Wales | 0 | 0 | 0 | 52.1307 | -3.7837 | 2020-03-02T15:03:23 | ||||
2020-03-02 | United Kingdom | Scotland | 0 | 0 | 0 | 56.4907 | -4.2026 | 2020-03-02T15:03:23 | ||||
2020-03-02 | United Kingdom | Northern Ireland | 0 | 0 | 0 | 54.7877 | -6.4923 | 2020-03-02T15:03:23 | ||||
2020-03-02 | United Kingdom | England | 0 | 4 | 0 | 52.3555 | -1.1743 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Ukraine | Unknown | 0 | 0 | 0 | 2020-03-02T15:03:23 | ||||||
2020-03-02 | Korea, North | 0 | 0 | 0 | 40.3399 | 127.5101 | 2020-03-02T15:03:23 | |||||
2020-03-02 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-02T15:03:23 | ||||
2020-03-02 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Antarctica | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-03-02T15:03:23 | |||||
2020-03-02 | Winter Olympics 2022 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2020-03-02T15:03:23 | |||||
2020-03-02 | Tonga | 0 | 0 | 0 | -21.179 | -175.1982 | 2020-03-02T15:03:23 | |||||
2020-03-02 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-02T15:03:23 | ||||||
2020-03-02 | Malaysia | W.P. Putrajaya | 0 | 0 | 0 | 2.9264 | 101.6964 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | W.P. Labuan | 0 | 0 | 0 | 5.2831 | 115.2308 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | W.P. Kuala Lumpur | 0 | 0 | 0 | 3.139 | 101.6869 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Terengganu | 0 | 0 | 0 | 5.3117 | 103.1324 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Sarawak | 0 | 0 | 0 | 1.5533 | 110.3592 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Sabah | 0 | 0 | 0 | 5.9788 | 116.0753 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Pulau Pinang | 0 | 0 | 0 | 5.4141 | 100.3288 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Perlis | 0 | 0 | 0 | 6.4449 | 100.2048 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Pahang | 0 | 0 | 0 | 3.8126 | 103.3256 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Negeri Sembilan | 0 | 0 | 0 | 2.7258 | 101.9424 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Melaka | 0 | 0 | 0 | 2.1896 | 102.2501 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Kelantan | 0 | 0 | 0 | 6.1254 | 102.2381 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Kedah | 0 | 0 | 0 | 6.1184 | 100.3685 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Malaysia | Johor | 0 | 0 | 0 | 1.4854 | 103.7618 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Summer Olympics 2020 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-02T15:03:23 | |||||
2020-03-02 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-02T15:03:23 | ||||
2020-03-02 | Palau | 0 | 0 | 0 | 7.515 | 134.5825 | 2020-03-02T15:03:23 | |||||
2020-03-02 | Kiribati | 0 | 0 | 0 | -3.3704 | -168.734 | 2020-03-02T15:03:23 | |||||
2020-03-02 | China | Unknown | 0 | 0 | 0 | 2020-03-02T15:03:23 | ||||||
2020-03-02 | US | Travis, CA (From Diamond Princess) | 0 | 0 | 0 | 38.2721 | -121.9399 | 2020-02-24T23:33:02 | ||||
2020-03-02 | US | Omaha, NE (From Diamond Princess) | 0 | 0 | 0 | 41.2545 | -95.9758 | 2020-02-24T23:33:02 | ||||
2020-03-02 | US | Lackland, TX (From Diamond Princess) | 0 | 0 | 0 | 29.3829 | -98.6134 | 2020-02-24T23:33:02 | ||||
2020-03-02 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2020-03-02 | US | Umatilla, OR | 1 | 0 | 0 | 45.775 | -118.7606 | 2020-03-02T20:23:16 | ||||
2020-03-02 | US | Tempe, AZ | 1 | 0 | 1 | 33.4255 | -111.94 | 2020-02-25T21:23:03 | ||||
2020-03-02 | US | Sonoma County, CA | 1 | 0 | 0 | 38.578 | -122.9888 | 2020-03-02T20:53:02 | ||||
2020-03-02 | US | Sarasota, FL | 1 | 0 | 0 | 27.3364 | -82.5307 | 2020-03-02T03:23:06 | ||||
2020-03-02 | US | San Mateo, CA | 1 | 0 | 0 | 37.563 | -122.3255 | 2020-03-02T20:43:02 | ||||
2020-03-02 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
2020-03-02 | US | Placer County, CA | 1 | 0 | 0 | 39.0916 | -120.8039 | 2020-03-02T23:53:02 | ||||
2020-03-02 | US | Orange, CA | 1 | 0 | 0 | 33.7879 | -117.8531 | 2020-02-01T19:53:03 | ||||
2020-03-02 | US | New York City, NY | 1 | 0 | 0 | 40.7128 | -74.006 | 2020-03-02T01:53:03 | ||||
2020-03-02 | US | Madison, WI | 1 | 0 | 0 | 43.0731 | -89.4012 | 2020-02-05T21:53:02 | ||||
2020-03-02 | US | Los Angeles, CA | 1 | 0 | 0 | 34.0522 | -118.2437 | 2020-02-01T19:53:03 | ||||
2020-03-02 | US | Humboldt County, CA | 1 | 0 | 0 | 40.745 | -123.8695 | 2020-02-21T05:13:09 | ||||
2020-03-02 | US | Hillsborough, FL | 1 | 0 | 0 | 27.9904 | -82.3018 | 2020-03-02T03:13:25 | ||||
2020-03-02 | US | Grafton County, NH | 1 | 0 | 0 | 43.9088 | -71.826 | 2020-03-02T20:33:02 | ||||
2020-03-02 | US | Boston, MA | 1 | 0 | 1 | 42.3601 | -71.0589 | 2020-02-28T21:13:12 | ||||
2020-03-02 | Sri Lanka | 1 | 0 | 1 | 7.0 | 81.0 | 2020-02-08T03:43:03 | |||||
2020-03-02 | Senegal | 1 | 0 | 0 | 14.4974 | -14.4524 | 2020-03-02T20:23:16 | |||||
2020-03-02 | Saudi Arabia | 1 | 0 | 0 | 24.0 | 45.0 | 2020-03-02T23:53:02 | |||||
2020-03-02 | North Macedonia | 1 | 0 | 0 | 41.6086 | 21.7453 | 2020-02-27T16:23:03 | |||||
2020-03-02 | Nigeria | 1 | 0 | 0 | 9.082 | 8.6753 | 2020-02-28T16:23:03 | |||||
2020-03-02 | New Zealand | 1 | 0 | 0 | -40.9006 | 174.886 | 2020-02-28T16:23:03 | |||||
2020-03-02 | Nepal | 1 | 0 | 1 | 28.1667 | 84.25 | 2020-02-12T14:43:03 | |||||
2020-03-02 | Morocco | 1 | 0 | 0 | 31.7917 | -7.0926 | 2020-03-02T22:33:09 | |||||
2020-03-02 | Monaco | 1 | 0 | 0 | 43.7333 | 7.4167 | 2020-02-29T00:33:01 | |||||
2020-03-02 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
2020-03-02 | Luxembourg | 1 | 0 | 0 | 49.8153 | 6.1296 | 2020-03-01T07:13:07 | |||||
2020-03-02 | Lithuania | 0 | 0 | 0 | 55.1694 | 23.8813 | 2020-02-28T16:23:03 | |||||
2020-03-02 | Latvia | 1 | 0 | 0 | 56.8796 | 24.6032 | 2020-03-02T20:13:49 | |||||
2020-03-02 | Ireland | 1 | 0 | 0 | 53.1424 | -7.6921 | 2020-03-01T07:13:07 | |||||
2020-03-02 | Estonia | 1 | 0 | 0 | 58.5953 | 25.0136 | 2020-02-27T16:23:03 | |||||
2020-03-02 | Dominican Republic | 1 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-02T16:33:02 | |||||
2020-03-02 | Canada | London, ON | 1 | 0 | 1 | 42.9849 | -81.2453 | 2020-02-12T18:53:03 | ||||
2020-03-02 | Canada | Montreal, QC | 6 | 0 | 0 | 45.5017 | -73.5673 | 2020-02-28T05:23:07 | ||||
2020-03-02 | Cambodia | 1 | 0 | 1 | 11.55 | 104.9167 | 2020-02-12T07:43:02 | |||||
2020-03-02 | Belarus | 1 | 0 | 0 | 53.7098 | 27.9534 | 2020-02-28T16:23:03 | |||||
2020-03-02 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
2020-03-02 | Armenia | 1 | 0 | 0 | 40.0691 | 45.0382 | 2020-03-01T19:53:02 | |||||
2020-03-02 | Andorra | 1 | 0 | 0 | 42.5063 | 1.5218 | 2020-03-02T20:23:16 | |||||
2020-03-02 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
2020-03-02 | US | San Diego County, CA | 2 | 0 | 1 | 32.7157 | -117.1611 | 2020-02-21T05:43:02 | ||||
2020-03-02 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
2020-03-02 | US | Sacramento County, CA | 2 | 0 | 0 | 38.4747 | -121.3542 | 2020-02-27T20:33:02 | ||||
2020-03-02 | US | Providence, RI | 2 | 0 | 0 | 41.824 | -71.4128 | 2020-03-02T03:43:02 | ||||
2020-03-02 | US | Portland, OR | 2 | 0 | 0 | 45.5051 | -122.675 | 2020-03-02T03:33:08 | ||||
2020-03-02 | Portugal | 2 | 0 | 0 | 39.3999 | -8.2245 | 2020-03-02T22:43:02 | |||||
2020-03-02 | Indonesia | 2 | 0 | 0 | -0.7893 | 113.9213 | 2020-03-02T18:03:04 | |||||
2020-03-02 | Egypt | 2 | 0 | 1 | 26.0 | 30.0 | 2020-03-01T23:33:03 | |||||
2020-03-02 | Brazil | 2 | 0 | 0 | -14.235 | -51.9253 | 2020-02-29T21:03:05 | |||||
2020-03-02 | Australia | Western Australia | 2 | 1 | 0 | -31.9505 | 115.8605 | 2020-03-01T02:43:03 | ||||
2020-03-02 | Russia | 3 | 0 | 2 | 60.0 | 90.0 | 2020-03-02T21:23:04 | |||||
2020-03-02 | Romania | 3 | 0 | 0 | 45.9432 | 24.9668 | 2020-02-28T15:33:03 | |||||
2020-03-02 | Qatar | 3 | 0 | 0 | 25.3548 | 51.1839 | 2020-03-01T23:33:03 | |||||
2020-03-02 | Philippines | 3 | 1 | 1 | 13.0 | 122.0 | 2020-02-12T07:43:02 | |||||
2020-03-02 | Georgia | 3 | 0 | 0 | 42.3154 | 43.3569 | 2020-03-01T15:43:03 | |||||
2020-03-02 | Czech Republic | 3 | 0 | 0 | 49.8175 | 15.473 | 2020-03-02T16:33:02 | |||||
2020-03-02 | Azerbaijan | 3 | 0 | 0 | 40.1431 | 47.5769 | 2020-03-01T02:43:03 | |||||
2020-03-02 | Australia | South Australia | 3 | 0 | 2 | -34.9285 | 138.6007 | 2020-02-29T02:03:10 | ||||
2020-03-02 | Algeria | 3 | 0 | 0 | 28.0339 | 1.6596 | 2020-03-02T00:53:03 | |||||
2020-03-02 | US | Snohomish County, WA | 4 | 1 | 0 | 48.033 | -121.8339 | 2020-03-02T20:53:02 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;