johns_hopkins_csse_daily_reports
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)
These facets timed out: province_or_state, country_or_region, day
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40231 | 40231 | 2020-03-05 | New Zealand | 3 | 0 | 0 | -40.9006 | 174.886 | 2020-03-04T20:13:11 | |||||
40232 | 40232 | 2020-03-05 | Philippines | 3 | 1 | 1 | 13.0 | 122.0 | 2020-02-12T07:43:02 | |||||
40233 | 40233 | 2020-03-05 | Saint Barthelemy | 3 | 0 | 0 | 17.9 | -62.8333 | 2020-03-04T02:43:03 | |||||
40234 | 40234 | 2020-03-05 | US | Orange County, CA | 3 | 0 | 0 | 33.7879 | -117.8531 | 2020-03-04T02:13:11 | ||||
40235 | 40235 | 2020-03-05 | US | San Diego County, CA | 3 | 0 | 1 | 32.7157 | -117.1611 | 2020-03-05T20:33:03 | ||||
40236 | 40236 | 2020-03-05 | Bosnia and Herzegovina | 2 | 0 | 0 | 43.9159 | 17.6791 | 2020-03-05T17:13:30 | |||||
40237 | 40237 | 2020-03-05 | Canada | Montreal, QC | 11 | 0 | 0 | 45.5017 | -73.5673 | 2020-03-05T14:03:04 | ||||
40238 | 40238 | 2020-03-05 | Hungary | 2 | 0 | 0 | 47.1625 | 19.5033 | 2020-03-05T17:13:27 | |||||
40239 | 40239 | 2020-03-05 | Indonesia | 2 | 0 | 0 | -0.7893 | 113.9213 | 2020-03-02T18:03:04 | |||||
40240 | 40240 | 2020-03-05 | Morocco | 2 | 0 | 0 | 31.7917 | -7.0926 | 2020-03-05T13:53:03 | |||||
40241 | 40241 | 2020-03-05 | Slovenia | 2 | 0 | 0 | 46.1512 | 14.9955 | 2020-03-05T17:13:30 | |||||
40242 | 40242 | 2020-03-05 | US | Bergen County, NJ | 2 | 0 | 0 | 40.9263 | -74.077 | 2020-03-05T21:03:12 | ||||
40243 | 40243 | 2020-03-05 | US | Fulton County, GA | 2 | 0 | 0 | 33.8034 | -84.3963 | 2020-03-03T03:33:02 | ||||
40244 | 40244 | 2020-03-05 | US | Grafton County, NH | 2 | 0 | 0 | 43.9088 | -71.826 | 2020-03-03T23:33:03 | ||||
40245 | 40245 | 2020-03-05 | US | Harris County, TX | 2 | 0 | 0 | 29.7752 | -95.3103 | 2020-03-05T21:53:02 | ||||
40246 | 40246 | 2020-03-05 | US | Hillsborough, FL | 2 | 0 | 0 | 27.9904 | -82.3018 | 2020-03-03T18:33:02 | ||||
40247 | 40247 | 2020-03-05 | US | Placer County, CA | 2 | 1 | 0 | 39.0916 | -120.8039 | 2020-03-04T19:53:02 | ||||
40248 | 40248 | 2020-03-05 | US | Providence, RI | 2 | 0 | 0 | 41.824 | -71.4128 | 2020-03-02T03:43:02 | ||||
40249 | 40249 | 2020-03-05 | US | Sacramento County, CA | 2 | 0 | 0 | 38.4747 | -121.3542 | 2020-02-27T20:33:02 | ||||
40250 | 40250 | 2020-03-05 | US | San Benito, CA | 2 | 0 | 0 | 36.5761 | -120.9876 | 2020-02-03T03:53:02 | ||||
40251 | 40251 | 2020-03-05 | US | San Francisco County, CA | 2 | 0 | 0 | 37.7749 | -122.4194 | 2020-03-05T20:33:03 | ||||
40252 | 40252 | 2020-03-05 | US | San Mateo, CA | 2 | 0 | 0 | 37.563 | -122.3255 | 2020-03-03T00:43:02 | ||||
40253 | 40253 | 2020-03-05 | US | Washington County, OR | 2 | 0 | 0 | 45.547 | -123.1386 | 2020-03-03T03:03:02 | ||||
40254 | 40254 | 2020-03-05 | Afghanistan | 5 | 0 | 0 | 33.0 | 65.0 | 2020-02-24T23:33:02 | |||||
40255 | 40255 | 2020-03-05 | Andorra | 1 | 0 | 0 | 42.5063 | 1.5218 | 2020-03-02T20:23:16 | |||||
40256 | 40256 | 2020-03-05 | Argentina | 1 | 0 | 0 | -38.4161 | -63.6167 | 2020-03-04T01:33:07 | |||||
40257 | 40257 | 2020-03-05 | Armenia | 1 | 0 | 0 | 40.0691 | 45.0382 | 2020-03-01T19:53:02 | |||||
40258 | 40258 | 2020-03-05 | Australia | Northern Territory | 1 | 0 | 0 | -12.4634 | 130.8456 | 2020-03-04T19:43:02 | ||||
40259 | 40259 | 2020-03-05 | Australia | Tasmania | 1 | 0 | 0 | -41.4545 | 145.9707 | 2020-03-02T20:53:02 | ||||
40260 | 40260 | 2020-03-05 | Cambodia | 1 | 0 | 1 | 11.55 | 104.9167 | 2020-02-12T07:43:02 | |||||
40261 | 40261 | 2020-03-05 | Canada | London, ON | 1 | 0 | 1 | 42.9849 | -81.2453 | 2020-02-12T18:53:03 | ||||
40262 | 40262 | 2020-03-05 | Dominican Republic | 1 | 0 | 0 | 18.7357 | -70.1627 | 2020-03-02T16:33:02 | |||||
40263 | 40263 | 2020-03-05 | Faroe Islands | 1 | 0 | 0 | 61.8926 | -6.9118 | 2020-03-04T12:53:03 | |||||
40264 | 40264 | 2020-03-05 | Gibraltar | 1 | 0 | 0 | 36.1408 | -5.3536 | 2020-03-04T13:03:13 | |||||
40265 | 40265 | 2020-03-05 | Jordan | 1 | 0 | 0 | 31.24 | 36.51 | 2020-03-03T15:33:02 | |||||
40266 | 40266 | 2020-03-05 | Latvia | 1 | 0 | 0 | 56.8796 | 24.6032 | 2020-03-04T01:33:07 | |||||
40267 | 40267 | 2020-03-05 | Liechtenstein | 1 | 0 | 0 | 47.14 | 9.55 | 2020-03-04T01:33:07 | |||||
40268 | 40268 | 2020-03-05 | Lithuania | 0 | 0 | 0 | 55.1694 | 23.8813 | 2020-02-28T16:23:03 | |||||
40269 | 40269 | 2020-03-05 | Luxembourg | 1 | 0 | 0 | 49.8144 | 6.1317 | 2020-03-03T00:23:16 | |||||
40270 | 40270 | 2020-03-05 | Mainland China | Tibet | 1 | 0 | 1 | 31.6927 | 88.0924 | 2020-02-12T06:43:02 | ||||
40271 | 40271 | 2020-03-05 | Monaco | 1 | 0 | 0 | 43.7333 | 7.4167 | 2020-02-29T00:33:01 | |||||
40272 | 40272 | 2020-03-05 | Nepal | 1 | 0 | 1 | 28.1667 | 84.25 | 2020-02-12T14:43:03 | |||||
40273 | 40273 | 2020-03-05 | Nigeria | 1 | 0 | 0 | 9.082 | 8.6753 | 2020-02-28T16:23:03 | |||||
40274 | 40274 | 2020-03-05 | North Macedonia | 1 | 0 | 0 | 41.6086 | 21.7453 | 2020-02-27T16:23:03 | |||||
40275 | 40275 | 2020-03-05 | Poland | 1 | 0 | 0 | 51.9194 | 19.1451 | 2020-03-04T15:13:18 | |||||
40276 | 40276 | 2020-03-05 | South Africa | 1 | 0 | 0 | -30.5595 | 22.9375 | 2020-03-05T13:53:03 | |||||
40277 | 40277 | 2020-03-05 | Sri Lanka | 1 | 0 | 1 | 7.0 | 81.0 | 2020-02-08T03:43:03 | |||||
40278 | 40278 | 2020-03-05 | Tunisia | 1 | 0 | 0 | 34.0 | 9.0 | 2020-03-04T01:33:07 | |||||
40279 | 40279 | 2020-03-05 | US | Norfolk County, MA | 1 | 0 | 0 | 42.1767 | -71.1449 | 2020-03-03T14:33:03 | ||||
40280 | 40280 | 2020-03-05 | US | Berkeley, CA | 1 | 0 | 0 | 37.8715 | -122.273 | 2020-03-03T23:53:03 | ||||
40281 | 40281 | 2020-03-05 | US | Boston, MA | 1 | 0 | 1 | 42.3601 | -71.0589 | 2020-02-28T21:13:12 | ||||
40282 | 40282 | 2020-03-05 | US | Clark County, NV | 1 | 0 | 0 | 36.0796 | -115.094 | 2020-03-05T20:53:03 | ||||
40283 | 40283 | 2020-03-05 | US | Contra Costa County, CA | 1 | 0 | 0 | 37.8534 | -121.9018 | 2020-03-04T04:23:05 | ||||
40284 | 40284 | 2020-03-05 | US | Fort Bend County, TX | 1 | 0 | 0 | 29.5693 | -95.8143 | 2020-03-05T01:16:59 | ||||
40285 | 40285 | 2020-03-05 | US | Grant County, WA | 1 | 0 | 0 | 47.1981 | -119.3732 | 2020-03-05T20:23:07 | ||||
40286 | 40286 | 2020-03-05 | US | Humboldt County, CA | 1 | 0 | 0 | 40.745 | -123.8695 | 2020-02-21T05:13:09 | ||||
40287 | 40287 | 2020-03-05 | US | Madison, WI | 1 | 0 | 1 | 43.0731 | -89.4012 | 2020-03-03T15:53:03 | ||||
40288 | 40288 | 2020-03-05 | US | Maricopa County, AZ | 1 | 0 | 0 | 33.2918 | -112.4291 | 2020-03-03T17:33:02 | ||||
40289 | 40289 | 2020-03-05 | US | Queens County, NY | 1 | 0 | 0 | 40.7282 | -73.7949 | 2020-03-05T21:43:02 | ||||
40290 | 40290 | 2020-03-05 | US | San Antonio, TX | 1 | 0 | 0 | 29.4241 | -98.4936 | 2020-02-13T18:53:02 | ||||
40291 | 40291 | 2020-03-05 | US | Santa Rosa County, FL | 1 | 0 | 0 | 30.769 | -86.9824 | 2020-03-05T20:03:03 | ||||
40292 | 40292 | 2020-03-05 | US | Sarasota, FL | 1 | 0 | 0 | 27.3364 | -82.5307 | 2020-03-02T03:23:06 | ||||
40293 | 40293 | 2020-03-05 | US | Sonoma County, CA | 1 | 0 | 0 | 38.578 | -122.9888 | 2020-03-02T20:53:02 | ||||
40294 | 40294 | 2020-03-05 | US | Tempe, AZ | 1 | 0 | 1 | 33.4255 | -111.94 | 2020-02-25T21:23:03 | ||||
40295 | 40295 | 2020-03-05 | US | Umatilla, OR | 1 | 0 | 0 | 45.775 | -118.7606 | 2020-03-02T20:23:16 | ||||
40296 | 40296 | 2020-03-05 | US | Wake County, NC | 1 | 0 | 0 | 35.8032 | -78.5661 | 2020-03-03T20:53:02 | ||||
40297 | 40297 | 2020-03-05 | US | Williamson County, TN | 1 | 0 | 0 | 35.9179 | -86.8622 | 2020-03-05T23:33:03 | ||||
40298 | 40298 | 2020-03-05 | Ukraine | 1 | 0 | 0 | 48.3794 | 31.1656 | 2020-03-03T15:33:02 | |||||
40299 | 40299 | 2020-03-05 | Australia | From Diamond Princess | 0 | 0 | 0 | 35.4437 | 139.638 | 2020-02-29T02:03:10 | ||||
40300 | 40300 | 2020-03-05 | US | Lackland, TX (From Diamond Princess) | 0 | 0 | 0 | 29.3829 | -98.6134 | 2020-02-24T23:33:02 | ||||
40301 | 40301 | 2020-03-05 | US | Omaha, NE (From Diamond Princess) | 0 | 0 | 0 | 41.2545 | -95.9758 | 2020-02-24T23:33:02 | ||||
40302 | 40302 | 2020-03-05 | US | Travis, CA (From Diamond Princess) | 0 | 0 | 0 | 38.2721 | -121.9399 | 2020-02-24T23:33:02 | ||||
40303 | 40303 | 2020-03-05 | China | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
40304 | 40304 | 2020-03-05 | Kiribati | 0 | 0 | 0 | -3.3704 | -168.734 | 2020-03-05T14:53:03 | |||||
40305 | 40305 | 2020-03-05 | Palau | 0 | 0 | 0 | 7.515 | 134.5825 | 2020-03-05T14:53:03 | |||||
40306 | 40306 | 2020-03-05 | New Zealand | Cook Islands | 0 | 0 | 0 | -21.2367 | -159.7777 | 2020-03-05T14:53:03 | ||||
40307 | 40307 | 2020-03-05 | Summer Olympics 2020 | 0 | 0 | 0 | 35.6491 | 139.7737 | 2020-03-05T14:53:03 | |||||
40308 | 40308 | 2020-03-05 | Malaysia | Johor | 0 | 0 | 0 | 1.4854 | 103.7618 | 2020-03-05T14:53:03 | ||||
40309 | 40309 | 2020-03-05 | Malaysia | Kedah | 0 | 0 | 0 | 6.1184 | 100.3685 | 2020-03-05T14:53:03 | ||||
40310 | 40310 | 2020-03-05 | Malaysia | Kelantan | 0 | 0 | 0 | 6.1254 | 102.2381 | 2020-03-05T14:53:03 | ||||
40311 | 40311 | 2020-03-05 | Malaysia | Melaka | 0 | 0 | 0 | 2.1896 | 102.2501 | 2020-03-05T14:53:03 | ||||
40312 | 40312 | 2020-03-05 | Malaysia | Negeri Sembilan | 0 | 0 | 0 | 2.7258 | 101.9424 | 2020-03-05T14:53:03 | ||||
40313 | 40313 | 2020-03-05 | Malaysia | Pahang | 0 | 0 | 0 | 3.8126 | 103.3256 | 2020-03-05T14:53:03 | ||||
40314 | 40314 | 2020-03-05 | Malaysia | Perak | 0 | 0 | 0 | 4.5921 | 101.0901 | 2020-03-05T14:53:03 | ||||
40315 | 40315 | 2020-03-05 | Malaysia | Perlis | 0 | 0 | 0 | 6.4449 | 100.2048 | 2020-03-05T14:53:03 | ||||
40316 | 40316 | 2020-03-05 | Malaysia | Pulau Pinang | 0 | 0 | 0 | 5.4141 | 100.3288 | 2020-03-05T14:53:03 | ||||
40317 | 40317 | 2020-03-05 | Malaysia | Sabah | 0 | 0 | 0 | 5.9788 | 116.0753 | 2020-03-05T14:53:03 | ||||
40318 | 40318 | 2020-03-05 | Malaysia | Sarawak | 0 | 0 | 0 | 1.5533 | 110.3592 | 2020-03-05T14:53:03 | ||||
40319 | 40319 | 2020-03-05 | Malaysia | Selangor | 0 | 0 | 0 | 3.0738 | 101.5183 | 2020-03-05T14:53:03 | ||||
40320 | 40320 | 2020-03-05 | Malaysia | Terengganu | 0 | 0 | 0 | 5.3117 | 103.1324 | 2020-03-05T14:53:03 | ||||
40321 | 40321 | 2020-03-05 | Malaysia | W.P. Kuala Lumpur | 0 | 0 | 0 | 3.139 | 101.6869 | 2020-03-05T14:53:03 | ||||
40322 | 40322 | 2020-03-05 | Malaysia | W.P. Labuan | 0 | 0 | 0 | 5.2831 | 115.2308 | 2020-03-05T14:53:03 | ||||
40323 | 40323 | 2020-03-05 | Malaysia | W.P. Putrajaya | 0 | 0 | 0 | 2.9264 | 101.6964 | 2020-03-05T14:53:03 | ||||
40324 | 40324 | 2020-03-05 | Malaysia | Unknown | 0 | 0 | 0 | 2020-03-05T14:53:03 | ||||||
40325 | 40325 | 2020-03-05 | Tonga | 0 | 0 | 0 | -21.179 | -175.1982 | 2020-03-05T14:53:03 | |||||
40326 | 40326 | 2020-03-05 | Winter Olympics 2022 | 0 | 0 | 0 | 39.9042 | 116.4074 | 2020-03-05T14:53:03 | |||||
40327 | 40327 | 2020-03-05 | Antarctica | 0 | 0 | 0 | -71.9499 | 23.347 | 2020-03-05T14:53:03 | |||||
40328 | 40328 | 2020-03-05 | United Kingdom | Jersey | 0 | 0 | 0 | 49.2138 | -2.1358 | 2020-03-05T14:53:03 | ||||
40329 | 40329 | 2020-03-05 | United Kingdom | Guernsey | 0 | 0 | 0 | 49.448196 | -2.58949 | 2020-03-05T14:53:03 | ||||
40330 | 40330 | 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 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]);