daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by combined_key
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 254,491
- Georgia 162,920
- Virginia 135,590
- Kentucky 121,675
- Missouri 117,101
- Kansas 105,758
- Illinois 104,685
- North Carolina 102,044
- Iowa 100,603
- Tennessee 98,183
- Indiana 94,151
- Nebraska 92,863
- Ohio 90,027
- Minnesota 88,465
- Michigan 87,758
- Mississippi 83,968
- Oklahoma 79,376
- Arkansas 76,709
- Wisconsin 73,611
- Puerto Rico 71,726
- Alabama 69,765
- Pennsylvania 68,850
- Florida 68,836
- Louisiana 66,723
- South Dakota 66,362
- Colorado 66,146
- New York 64,046
- California 59,941
- West Virginia 56,193
- Montana 54,982
- …
country_or_region >30
- US 3,284,537
- Russia 78,307
- Japan 46,430
- China 34,865
- India 34,605
- Colombia 32,189
- Mexico 31,389
- Ukraine 26,597
- Brazil 25,862
- Peru 24,679
- Italy 20,264
- Sweden 19,824
- United Kingdom 19,730
- Spain 19,298
- Malaysia 18,241
- Germany 16,427
- Chile 16,296
- Canada 16,227
- Netherlands 15,842
- France 11,972
- Belgium 9,618
- Australia 8,420
- Pakistan 6,636
- New Zealand 3,188
- Denmark 3,077
- Mainland China 1,517
- Antarctica 1,073
- Kiribati 1,073
- Korea, North 1,073
- Nauru 1,073
- …
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-03-05 | New Zealand | 3 | 0 | 0 | -40.9006 | 174.886 | 2020-03-04T20:13:11 | |||||
2020-03-05 | Philippines | 3 | 1 | 1 | 13.0 | 122.0 | 2020-02-12T07:43:02 | |||||
2020-03-05 | Saint Barthelemy | 3 | 0 | 0 | 17.9 | -62.8333 | 2020-03-04T02:43:03 | |||||
2020-03-05 | US | Orange County, CA | 3 | 0 | 0 | 33.7879 | -117.8531 | 2020-03-04T02:13:11 | ||||
2020-03-05 | US | San Diego County, CA | 3 | 0 | 1 | 32.7157 | -117.1611 | 2020-03-05T20:33:03 | ||||
2020-03-05 | Bosnia and Herzegovina | 2 | 0 | 0 | 43.9159 | 17.6791 | 2020-03-05T17:13:30 | |||||
2020-03-05 | Canada | Montreal, QC | 11 | 0 | 0 | 45.5017 | -73.5673 | 2020-03-05T14:03:04 | ||||
2020-03-05 | Hungary | 2 | 0 | 0 | 47.1625 | 19.5033 | 2020-03-05T17:13:27 | |||||
2020-03-05 | Indonesia | 2 | 0 | 0 | -0.7893 | 113.9213 | 2020-03-02T18:03:04 | |||||
2020-03-05 | Morocco | 2 | 0 | 0 | 31.7917 | -7.0926 | 2020-03-05T13:53:03 | |||||
2020-03-05 | Slovenia | 2 | 0 | 0 | 46.1512 | 14.9955 | 2020-03-05T17:13:30 | |||||
2020-03-05 | US | Bergen County, NJ | 2 | 0 | 0 | 40.9263 | -74.077 | 2020-03-05T21:03:12 | ||||
2020-03-05 | US | Fulton County, GA | 2 | 0 | 0 | 33.8034 | -84.3963 | 2020-03-03T03:33:02 | ||||
2020-03-05 | US | Grafton County, NH | 2 | 0 | 0 | 43.9088 | -71.826 | 2020-03-03T23:33:03 | ||||
2020-03-05 | US | Harris County, TX | 2 | 0 | 0 | 29.7752 | -95.3103 | 2020-03-05T21:53:02 | ||||
2020-03-05 | US | Hillsborough, FL | 2 | 0 | 0 | 27.9904 | -82.3018 | 2020-03-03T18:33:02 | ||||
2020-03-05 | US | Placer County, CA | 2 | 1 | 0 | 39.0916 | -120.8039 | 2020-03-04T19:53:02 | ||||
2020-03-05 | US | Providence, RI | 2 | 0 | 0 | 41.824 | -71.4128 | 2020-03-02T03:43:02 | ||||
2020-03-05 | US | Sacramento County, CA | 2 | 0 | 0 | 38.4747 | -121.3542 | 2020-02-27T20:33:02 | ||||
2020-03-05 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
2020-03-05 | US | San Francisco County, CA | 2 | 0 | 0 | 37.7749 | -122.4194 | 2020-03-05T20:33:03 | ||||
2020-03-05 | US | San Mateo, CA | 2 | 0 | 0 | 37.563 | -122.3255 | 2020-03-03T00:43:02 | ||||
2020-03-05 | US | Washington County, OR | 2 | 0 | 0 | 45.547 | -123.1386 | 2020-03-03T03:03:02 | ||||
2020-03-05 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
2020-03-05 | Andorra | 1 | 0 | 0 | 42.5063 | 1.5218 | 2020-03-02T20:23:16 | |||||
2020-03-05 | Argentina | 1 | 0 | 0 | -38.4161 | -63.6167 | 2020-03-04T01:33:07 | |||||
2020-03-05 | Armenia | 1 | 0 | 0 | 40.0691 | 45.0382 | 2020-03-01T19:53:02 | |||||
2020-03-05 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-04T19:43:02 | ||||
2020-03-05 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
2020-03-05 | Cambodia | 1 | 0 | 1 | 11.55 | 104.9167 | 2020-02-12T07:43:02 | |||||
2020-03-05 | Canada | London, ON | 1 | 0 | 1 | 42.9849 | -81.2453 | 2020-02-12T18:53:03 | ||||
2020-03-05 | Dominican Republic | 1 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-02T16:33:02 | |||||
2020-03-05 | Faroe Islands | 1 | 0 | 0 | 61.8926 | -6.9118 | 2020-03-04T12:53:03 | |||||
2020-03-05 | Gibraltar | 1 | 0 | 0 | 36.1408 | -5.3536 | 2020-03-04T13:03:13 | |||||
2020-03-05 | Jordan | 1 | 0 | 0 | 31.24 | 36.51 | 2020-03-03T15:33:02 | |||||
2020-03-05 | Latvia | 1 | 0 | 0 | 56.8796 | 24.6032 | 2020-03-04T01:33:07 | |||||
2020-03-05 | Liechtenstein | 1 | 0 | 0 | 47.14 | 9.55 | 2020-03-04T01:33:07 | |||||
2020-03-05 | Lithuania | 0 | 0 | 0 | 55.1694 | 23.8813 | 2020-02-28T16:23:03 | |||||
2020-03-05 | Luxembourg | 1 | 0 | 0 | 49.8144 | 6.1317 | 2020-03-03T00:23:16 | |||||
2020-03-05 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
2020-03-05 | Monaco | 1 | 0 | 0 | 43.7333 | 7.4167 | 2020-02-29T00:33:01 | |||||
2020-03-05 | Nepal | 1 | 0 | 1 | 28.1667 | 84.25 | 2020-02-12T14:43:03 | |||||
2020-03-05 | Nigeria | 1 | 0 | 0 | 9.082 | 8.6753 | 2020-02-28T16:23:03 | |||||
2020-03-05 | North Macedonia | 1 | 0 | 0 | 41.6086 | 21.7453 | 2020-02-27T16:23:03 | |||||
2020-03-05 | Poland | 1 | 0 | 0 | 51.9194 | 19.1451 | 2020-03-04T15:13:18 | |||||
2020-03-05 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-05T13:53:03 | |||||
2020-03-05 | Sri Lanka | 1 | 0 | 1 | 7.0 | 81.0 | 2020-02-08T03:43:03 | |||||
2020-03-05 | Tunisia | 1 | 0 | 0 | 34.0 | 9.0 | 2020-03-04T01:33:07 | |||||
2020-03-05 | US | Norfolk County, MA | 1 | 0 | 0 | 42.1767 | -71.1449 | 2020-03-03T14:33:03 | ||||
2020-03-05 | US | Berkeley, CA | 1 | 0 | 0 | 37.8715 | -122.273 | 2020-03-03T23:53:03 | ||||
2020-03-05 | US | Boston, MA | 1 | 0 | 1 | 42.3601 | -71.0589 | 2020-02-28T21:13:12 | ||||
2020-03-05 | US | Clark County, NV | 1 | 0 | 0 | 36.0796 | -115.094 | 2020-03-05T20:53:03 | ||||
2020-03-05 | US | Contra Costa County, CA | 1 | 0 | 0 | 37.8534 | -121.9018 | 2020-03-04T04:23:05 | ||||
2020-03-05 | US | Fort Bend County, TX | 1 | 0 | 0 | 29.5693 | -95.8143 | 2020-03-05T01:16:59 | ||||
2020-03-05 | US | Grant County, WA | 1 | 0 | 0 | 47.1981 | -119.3732 | 2020-03-05T20:23:07 | ||||
2020-03-05 | US | Humboldt County, CA | 1 | 0 | 0 | 40.745 | -123.8695 | 2020-02-21T05:13:09 | ||||
2020-03-05 | US | Madison, WI | 1 | 0 | 1 | 43.0731 | -89.4012 | 2020-03-03T15:53:03 | ||||
2020-03-05 | US | Maricopa County, AZ | 1 | 0 | 0 | 33.2918 | -112.4291 | 2020-03-03T17:33:02 | ||||
2020-03-05 | US | Queens County, NY | 1 | 0 | 0 | 40.7282 | -73.7949 | 2020-03-05T21:43:02 | ||||
2020-03-05 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
2020-03-05 | US | Santa Rosa County, FL | 1 | 0 | 0 | 30.769 | -86.9824 | 2020-03-05T20:03:03 | ||||
2020-03-05 | US | Sarasota, FL | 1 | 0 | 0 | 27.3364 | -82.5307 | 2020-03-02T03:23:06 | ||||
2020-03-05 | US | Sonoma County, CA | 1 | 0 | 0 | 38.578 | -122.9888 | 2020-03-02T20:53:02 | ||||
2020-03-05 | US | Tempe, AZ | 1 | 0 | 1 | 33.4255 | -111.94 | 2020-02-25T21:23:03 | ||||
2020-03-05 | US | Umatilla, OR | 1 | 0 | 0 | 45.775 | -118.7606 | 2020-03-02T20:23:16 | ||||
2020-03-05 | US | Wake County, NC | 1 | 0 | 0 | 35.8032 | -78.5661 | 2020-03-03T20:53:02 | ||||
2020-03-05 | US | Williamson County, TN | 1 | 0 | 0 | 35.9179 | -86.8622 | 2020-03-05T23:33:03 | ||||
2020-03-05 | Ukraine | 1 | 0 | 0 | 48.3794 | 31.1656 | 2020-03-03T15:33:02 | |||||
2020-03-05 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
2020-03-05 | US | Lackland, TX (From Diamond Princess) | 0 | 0 | 0 | 29.3829 | -98.6134 | 2020-02-24T23:33:02 | ||||
2020-03-05 | US | Omaha, NE (From Diamond Princess) | 0 | 0 | 0 | 41.2545 | -95.9758 | 2020-02-24T23:33:02 | ||||
2020-03-05 | US | Travis, CA (From Diamond Princess) | 0 | 0 | 0 | 38.2721 | -121.9399 | 2020-02-24T23:33:02 | ||||
2020-03-05 | China | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
2020-03-05 | Kiribati | 0 | 0 | 0 | -3.3704 | -168.734 | 2020-03-05T14:53:03 | |||||
2020-03-05 | Palau | 0 | 0 | 0 | 7.515 | 134.5825 | 2020-03-05T14:53:03 | |||||
2020-03-05 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Summer Olympics 2020 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-05T14:53:03 | |||||
2020-03-05 | Malaysia | Johor | 0 | 0 | 0 | 1.4854 | 103.7618 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Kedah | 0 | 0 | 0 | 6.1184 | 100.3685 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Kelantan | 0 | 0 | 0 | 6.1254 | 102.2381 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Melaka | 0 | 0 | 0 | 2.1896 | 102.2501 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Negeri Sembilan | 0 | 0 | 0 | 2.7258 | 101.9424 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Pahang | 0 | 0 | 0 | 3.8126 | 103.3256 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Perlis | 0 | 0 | 0 | 6.4449 | 100.2048 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Pulau Pinang | 0 | 0 | 0 | 5.4141 | 100.3288 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Sabah | 0 | 0 | 0 | 5.9788 | 116.0753 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Sarawak | 0 | 0 | 0 | 1.5533 | 110.3592 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Terengganu | 0 | 0 | 0 | 5.3117 | 103.1324 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | W.P. Kuala Lumpur | 0 | 0 | 0 | 3.139 | 101.6869 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | W.P. Labuan | 0 | 0 | 0 | 5.2831 | 115.2308 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | W.P. Putrajaya | 0 | 0 | 0 | 2.9264 | 101.6964 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
2020-03-05 | Tonga | 0 | 0 | 0 | -21.179 | -175.1982 | 2020-03-05T14:53:03 | |||||
2020-03-05 | Winter Olympics 2022 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2020-03-05T14:53:03 | |||||
2020-03-05 | Antarctica | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-03-05T14:53:03 | |||||
2020-03-05 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-05T14:53:03 | ||||
2020-03-05 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-05T14:53:03 | ||||
2020-03-05 | Korea, North | 0 | 0 | 0 | 40.3399 | 127.5101 | 2020-03-05T14:53:03 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;