johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
170 rows where "last_update" is on date 2020-03-13 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
339692 | 339692 | 2020-03-21 | China | Hebei | 318 | 6 | 310 | 38.0428 | 114.5149 | 2020-03-13T11:09:03 | ||||
339740 | 339740 | 2020-03-21 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
339902 | 339902 | 2020-03-21 | Holy See | 1 | 0 | 0 | 41.9029 | 12.4534 | 2020-03-13T22:22:02 | |||||
339903 | 339903 | 2020-03-21 | Nepal | 1 | 0 | 1 | 28.3949 | 84.124 | 2020-03-13T22:22:03 | |||||
1176915 | 1176915 | 2020-03-18 | China | Hebei | 318 | 6 | 310 | 38.0428 | 114.5149 | 2020-03-13T11:09:03 | ||||
1176958 | 1176958 | 2020-03-18 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
1177123 | 1177123 | 2020-03-18 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-13T22:22:02 | |||||
1177134 | 1177134 | 2020-03-18 | Holy See | 1 | 0 | 0 | 41.9029 | 12.4534 | 2020-03-13T22:22:02 | |||||
1177137 | 1177137 | 2020-03-18 | Nepal | 1 | 0 | 1 | 28.3949 | 84.124 | 2020-03-13T22:22:03 | |||||
1177142 | 1177142 | 2020-03-18 | Togo | 1 | 0 | 0 | 8.6195 | 0.8248 | 2020-03-13T22:22:02 | |||||
1463485 | 1463485 | 2020-03-15 | Cruise Ship | Diamond Princess | 696 | 7 | 325 | 35.4498 | 139.6649 | 2020-03-13T14:13:25 | ||||
1463495 | 1463495 | 2020-03-15 | China | Hebei | 318 | 6 | 310 | 38.0428 | 114.5149 | 2020-03-13T11:09:03 | ||||
1463497 | 1463497 | 2020-03-15 | China | Guangxi | 252 | 2 | 243 | 23.8298 | 108.7881 | 2020-03-13T11:09:03 | ||||
1463519 | 1463519 | 2020-03-15 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
1463536 | 1463536 | 2020-03-15 | China | Jilin | 93 | 1 | 91 | 43.6661 | 126.1923 | 2020-03-13T11:09:03 | ||||
1463585 | 1463585 | 2020-03-15 | Belarus | 27 | 0 | 3 | 53.7098 | 27.9534 | 2020-03-13T22:21:59 | |||||
1463610 | 1463610 | 2020-03-15 | Azerbaijan | 23 | 1 | 6 | 40.1431 | 47.5769 | 2020-03-13T12:13:36 | |||||
1463611 | 1463611 | 2020-03-15 | North Macedonia | 14 | 0 | 1 | 41.6086 | 21.7453 | 2020-03-13T23:33:05 | |||||
1463623 | 1463623 | 2020-03-15 | Senegal | 24 | 0 | 1 | 14.4974 | -14.4524 | 2020-03-13T23:33:05 | |||||
1463626 | 1463626 | 2020-03-15 | Jamaica | 10 | 0 | 0 | 18.1096 | -77.2975 | 2020-03-13T22:22:02 | |||||
1463638 | 1463638 | 2020-03-15 | Paraguay | 8 | 0 | 0 | -23.4425 | -58.4438 | 2020-03-13T23:33:06 | |||||
1463650 | 1463650 | 2020-03-15 | Cuba | 4 | 0 | 0 | 21.5218 | -77.7812 | 2020-03-13T23:53:02 | |||||
1463660 | 1463660 | 2020-03-15 | Ukraine | 3 | 1 | 0 | 48.3794 | 31.1656 | 2020-03-13T22:22:02 | |||||
1463662 | 1463662 | 2020-03-15 | Aruba | 2 | 0 | 0 | 12.5211 | -69.9683 | 2020-03-13T23:53:03 | |||||
1463663 | 1463663 | 2020-03-15 | Burkina Faso | 3 | 0 | 0 | 12.2383 | -1.5616 | 2020-03-13T22:22:02 | |||||
1463664 | 1463664 | 2020-03-15 | Cameroon | 2 | 0 | 0 | 3.848 | 11.5021 | 2020-03-13T22:22:02 | |||||
1463667 | 1463667 | 2020-03-15 | Congo (Kinshasa) | 2 | 0 | 0 | -4.0383 | 21.7587 | 2020-03-13T22:22:02 | |||||
1463673 | 1463673 | 2020-03-15 | Nigeria | 2 | 0 | 0 | 9.082 | 8.6753 | 2020-03-13T22:22:02 | |||||
1463676 | 1463676 | 2020-03-15 | Andorra | 1 | 0 | 1 | 42.5063 | 1.5218 | 2020-03-13T22:22:02 | |||||
1463680 | 1463680 | 2020-03-15 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-13T22:22:02 | |||||
1463683 | 1463683 | 2020-03-15 | Cayman Islands | 1 | 0 | 0 | 19.3133 | -81.2546 | 2020-03-13T12:33:03 | |||||
1463687 | 1463687 | 2020-03-15 | Cote d'Ivoire | 1 | 0 | 0 | 7.54 | -5.5471 | 2020-03-13T22:22:02 | |||||
1463691 | 1463691 | 2020-03-15 | Ethiopia | 1 | 0 | 0 | 9.145 | 40.4897 | 2020-03-13T23:33:06 | |||||
1463695 | 1463695 | 2020-03-15 | Guadeloupe | 3 | 0 | 0 | 16.265 | -61.551 | 2020-03-13T12:33:03 | |||||
1463697 | 1463697 | 2020-03-15 | Guernsey | 1 | 0 | 0 | 49.45 | -2.58 | 2020-03-13T22:22:03 | |||||
1463699 | 1463699 | 2020-03-15 | Holy See | 1 | 0 | 0 | 41.9029 | 12.4534 | 2020-03-13T22:22:02 | |||||
1463700 | 1463700 | 2020-03-15 | Kenya | 3 | 0 | 0 | -0.0236 | 37.9062 | 2020-03-13T22:22:03 | |||||
1463702 | 1463702 | 2020-03-15 | Mongolia | 1 | 0 | 0 | 46.8625 | 103.8467 | 2020-03-13T22:22:02 | |||||
1463703 | 1463703 | 2020-03-15 | Nepal | 1 | 0 | 1 | 28.3949 | 84.124 | 2020-03-13T22:22:03 | |||||
1463709 | 1463709 | 2020-03-15 | Togo | 1 | 0 | 0 | 8.6195 | 0.8248 | 2020-03-13T22:22:02 | |||||
1463710 | 1463710 | 2020-03-15 | US | Alaska | 1 | 0 | 0 | 61.3707 | -152.4044 | 2020-03-13T14:53:03 | ||||
1526923 | 1526923 | 2020-03-19 | China | Hebei | 318 | 6 | 310 | 38.0428 | 114.5149 | 2020-03-13T11:09:03 | ||||
1526964 | 1526964 | 2020-03-19 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
1527129 | 1527129 | 2020-03-19 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-13T22:22:02 | |||||
1527140 | 1527140 | 2020-03-19 | Holy See | 1 | 0 | 0 | 41.9029 | 12.4534 | 2020-03-13T22:22:02 | |||||
1527141 | 1527141 | 2020-03-19 | Nepal | 1 | 0 | 1 | 28.3949 | 84.124 | 2020-03-13T22:22:03 | |||||
1527146 | 1527146 | 2020-03-19 | Togo | 1 | 0 | 0 | 8.6195 | 0.8248 | 2020-03-13T22:22:02 | |||||
2111107 | 2111107 | 2020-03-14 | Cruise Ship | Diamond Princess | 696 | 7 | 325 | 35.4498 | 139.6649 | 2020-03-13T14:13:25 | ||||
2111110 | 2111110 | 2020-03-14 | China | Jiangsu | 631 | 0 | 630 | 32.9711 | 119.455 | 2020-03-13T11:09:03 | ||||
2111120 | 2111120 | 2020-03-14 | China | Hebei | 318 | 6 | 310 | 38.0428 | 114.5149 | 2020-03-13T11:09:03 | ||||
2111122 | 2111122 | 2020-03-14 | China | Guangxi | 252 | 2 | 243 | 23.8298 | 108.7881 | 2020-03-13T11:09:03 | ||||
2111135 | 2111135 | 2020-03-14 | Brazil | 151 | 0 | 0 | -14.235 | -51.9253 | 2020-03-13T22:21:58 | |||||
2111140 | 2111140 | 2020-03-14 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
2111156 | 2111156 | 2020-03-14 | China | Jilin | 93 | 1 | 91 | 43.6661 | 126.1923 | 2020-03-13T11:09:03 | ||||
2111158 | 2111158 | 2020-03-14 | United Arab Emirates | 85 | 0 | 17 | 23.4241 | 53.8478 | 2020-03-13T22:21:58 | |||||
2111200 | 2111200 | 2020-03-14 | Belarus | 27 | 0 | 3 | 53.7098 | 27.9534 | 2020-03-13T22:21:59 | |||||
2111217 | 2111217 | 2020-03-14 | Oman | 19 | 0 | 9 | 21.4735 | 55.9754 | 2020-03-13T23:33:05 | |||||
2111225 | 2111225 | 2020-03-14 | Canada | Quebec | 55 | 0 | 0 | 52.9399 | -73.5491 | 2020-03-13T13:33:03 | ||||
2111227 | 2111227 | 2020-03-14 | US | Iowa | 17 | 0 | 0 | 42.0115 | -93.2105 | 2020-03-13T23:53:03 | ||||
2111229 | 2111229 | 2020-03-14 | Azerbaijan | 15 | 1 | 3 | 40.1431 | 47.5769 | 2020-03-13T12:13:36 | |||||
2111230 | 2111230 | 2020-03-14 | North Macedonia | 14 | 0 | 1 | 41.6086 | 21.7453 | 2020-03-13T23:33:05 | |||||
2111231 | 2111231 | 2020-03-14 | US | Kentucky | 14 | 0 | 0 | 37.6681 | -84.6701 | 2020-03-13T23:53:03 | ||||
2111241 | 2111241 | 2020-03-14 | Senegal | 10 | 0 | 1 | 14.4974 | -14.4524 | 2020-03-13T23:33:05 | |||||
2111249 | 2111249 | 2020-03-14 | Jamaica | 8 | 0 | 0 | 18.1096 | -77.2975 | 2020-03-13T22:22:02 | |||||
2111256 | 2111256 | 2020-03-14 | Paraguay | 7 | 0 | 0 | -23.4425 | -58.4438 | 2020-03-13T23:33:06 | |||||
2111264 | 2111264 | 2020-03-14 | Turkey | 5 | 0 | 0 | 38.9637 | 35.2433 | 2020-03-13T23:33:06 | |||||
2111268 | 2111268 | 2020-03-14 | Cuba | 4 | 0 | 0 | 21.5218 | -77.7812 | 2020-03-13T23:53:02 | |||||
2111274 | 2111274 | 2020-03-14 | Bangladesh | 3 | 0 | 0 | 23.685 | 90.3563 | 2020-03-13T22:22:02 | |||||
2111279 | 2111279 | 2020-03-14 | Ukraine | 3 | 1 | 0 | 48.3794 | 31.1656 | 2020-03-13T22:22:02 | |||||
2111280 | 2111280 | 2020-03-14 | Aruba | 2 | 0 | 0 | 12.5211 | -69.9683 | 2020-03-13T23:53:03 | |||||
2111281 | 2111281 | 2020-03-14 | Burkina Faso | 2 | 0 | 0 | 12.2383 | -1.5616 | 2020-03-13T22:22:02 | |||||
2111282 | 2111282 | 2020-03-14 | Cameroon | 2 | 0 | 0 | 3.848 | 11.5021 | 2020-03-13T22:22:02 | |||||
2111284 | 2111284 | 2020-03-14 | Congo (Kinshasa) | 2 | 0 | 0 | -4.0383 | 21.7587 | 2020-03-13T22:22:02 | |||||
2111286 | 2111286 | 2020-03-14 | Honduras | 2 | 0 | 0 | 15.2 | -86.2419 | 2020-03-13T22:22:02 | |||||
2111290 | 2111290 | 2020-03-14 | Nigeria | 2 | 0 | 0 | 9.082 | 8.6753 | 2020-03-13T22:22:02 | |||||
2111297 | 2111297 | 2020-03-14 | Andorra | 1 | 0 | 1 | 42.5063 | 1.5218 | 2020-03-13T22:22:02 | |||||
2111298 | 2111298 | 2020-03-14 | Antigua and Barbuda | 1 | 0 | 0 | 17.0608 | -61.7964 | 2020-03-13T22:22:06 | |||||
2111301 | 2111301 | 2020-03-14 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-13T22:22:02 | |||||
2111303 | 2111303 | 2020-03-14 | Cayman Islands | 1 | 0 | 0 | 19.3133 | -81.2546 | 2020-03-13T12:33:03 | |||||
2111305 | 2111305 | 2020-03-14 | Cote d'Ivoire | 1 | 0 | 0 | 7.54 | -5.5471 | 2020-03-13T22:22:02 | |||||
2111308 | 2111308 | 2020-03-14 | Ethiopia | 1 | 0 | 0 | 9.145 | 40.4897 | 2020-03-13T23:33:06 | |||||
2111311 | 2111311 | 2020-03-14 | Guadeloupe | 1 | 0 | 0 | 16.265 | -61.551 | 2020-03-13T12:33:03 | |||||
2111313 | 2111313 | 2020-03-14 | Guernsey | 1 | 0 | 0 | 49.45 | -2.58 | 2020-03-13T22:22:03 | |||||
2111314 | 2111314 | 2020-03-14 | Guinea | 1 | 0 | 0 | 9.9456 | -9.6966 | 2020-03-13T15:33:33 | |||||
2111316 | 2111316 | 2020-03-14 | Holy See | 1 | 0 | 0 | 41.9029 | 12.4534 | 2020-03-13T22:22:02 | |||||
2111318 | 2111318 | 2020-03-14 | Kenya | 1 | 0 | 0 | -0.0236 | 37.9062 | 2020-03-13T22:22:03 | |||||
2111320 | 2111320 | 2020-03-14 | Mongolia | 1 | 0 | 0 | 46.8625 | 103.8467 | 2020-03-13T22:22:02 | |||||
2111321 | 2111321 | 2020-03-14 | Nepal | 1 | 0 | 1 | 28.3949 | 84.124 | 2020-03-13T22:22:03 | |||||
2111327 | 2111327 | 2020-03-14 | Togo | 1 | 0 | 0 | 8.6195 | 0.8248 | 2020-03-13T22:22:02 | |||||
2147099 | 2147099 | 2020-03-23 | China | Shanxi | 133 | 0 | 133 | 0 | 37.5777 | 112.2922 | 2020-03-13 08:56:40 | Shanxi, China | ||
2255137 | 2255137 | 2020-03-16 | Cruise Ship | Diamond Princess | 696 | 7 | 325 | 35.4498 | 139.6649 | 2020-03-13T14:13:25 | ||||
2255148 | 2255148 | 2020-03-16 | China | Hebei | 318 | 6 | 310 | 38.0428 | 114.5149 | 2020-03-13T11:09:03 | ||||
2255183 | 2255183 | 2020-03-16 | China | Shanxi | 133 | 0 | 133 | 37.5777 | 112.2922 | 2020-03-13T11:09:03 | ||||
2255318 | 2255318 | 2020-03-16 | Cuba | 4 | 0 | 0 | 21.5218 | -77.7812 | 2020-03-13T23:53:02 | |||||
2255332 | 2255332 | 2020-03-16 | Aruba | 2 | 0 | 0 | 12.5211 | -69.9683 | 2020-03-13T23:53:03 | |||||
2255335 | 2255335 | 2020-03-16 | Congo (Kinshasa) | 2 | 0 | 0 | -4.0383 | 21.7587 | 2020-03-13T22:22:02 | |||||
2255341 | 2255341 | 2020-03-16 | Nigeria | 2 | 0 | 0 | 9.082 | 8.6753 | 2020-03-13T22:22:02 | |||||
2255346 | 2255346 | 2020-03-16 | Bhutan | 1 | 0 | 0 | 27.5142 | 90.4336 | 2020-03-13T22:22:02 | |||||
2255352 | 2255352 | 2020-03-16 | Cote d'Ivoire | 1 | 0 | 0 | 7.54 | -5.5471 | 2020-03-13T22:22:02 | |||||
2255358 | 2255358 | 2020-03-16 | Guernsey | 1 | 0 | 0 | 49.45 | -2.58 | 2020-03-13T22:22: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]);