johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by last_update
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update ▼ | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3847319 | 3847319 | 2020-05-13 | Ghana | 5408 | 24 | 514 | 4870 | 7.9465 | -1.0232 | 2020-05-14 03:32:28 | Ghana | |||
3847320 | 3847320 | 2020-05-13 | Greece | 2760 | 155 | 1374 | 1231 | 39.0742 | 21.8243 | 2020-05-14 03:32:28 | Greece | |||
3847321 | 3847321 | 2020-05-13 | Grenada | 21 | 0 | 13 | 8 | 12.1165 | -61.679 | 2020-05-14 03:32:28 | Grenada | |||
3847322 | 3847322 | 2020-05-13 | Guatemala | 1342 | 29 | 121 | 1192 | 15.7835 | -90.2308 | 2020-05-14 03:32:28 | Guatemala | |||
3847323 | 3847323 | 2020-05-13 | Guinea | 2374 | 14 | 856 | 1504 | 9.9456 | -9.6966 | 2020-05-14 03:32:28 | Guinea | |||
3847324 | 3847324 | 2020-05-13 | Guinea-Bissau | 836 | 3 | 26 | 807 | 11.8037 | -15.1804 | 2020-05-14 03:32:28 | Guinea-Bissau | |||
3847325 | 3847325 | 2020-05-13 | Guyana | 113 | 10 | 41 | 62 | 4.860416000000002 | -58.93018000000001 | 2020-05-14 03:32:28 | Guyana | |||
3847326 | 3847326 | 2020-05-13 | Haiti | 209 | 16 | 17 | 176 | 18.9712 | -72.2852 | 2020-05-14 03:32:28 | Haiti | |||
3847327 | 3847327 | 2020-05-13 | Holy See | 12 | 0 | 2 | 10 | 41.9029 | 12.4534 | 2020-05-14 03:32:28 | Holy See | |||
3847328 | 3847328 | 2020-05-13 | Honduras | 2255 | 123 | 237 | 1895 | 15.2 | -86.2419 | 2020-05-14 03:32:28 | Honduras | |||
3847329 | 3847329 | 2020-05-13 | Hungary | 3341 | 430 | 1102 | 1809 | 47.1625 | 19.5033 | 2020-05-14 03:32:28 | Hungary | |||
3847330 | 3847330 | 2020-05-13 | Iceland | 1802 | 10 | 1780 | 12 | 64.9631 | -19.0208 | 2020-05-14 03:32:28 | Iceland | |||
3847331 | 3847331 | 2020-05-13 | India | 78055 | 2551 | 26400 | 49104 | 20.593684 | 78.96288 | 2020-05-14 03:32:28 | India | |||
3847332 | 3847332 | 2020-05-13 | Indonesia | 15438 | 1028 | 3287 | 11123 | -0.7893 | 113.9213 | 2020-05-14 03:32:28 | Indonesia | |||
3847333 | 3847333 | 2020-05-13 | Iran | 112725 | 6783 | 89428 | 16514 | 32.427908 | 53.68804599999999 | 2020-05-14 03:32:28 | Iran | |||
3847334 | 3847334 | 2020-05-13 | Iraq | 3032 | 115 | 1966 | 951 | 33.223191 | 43.679291 | 2020-05-14 03:32:28 | Iraq | |||
3847335 | 3847335 | 2020-05-13 | Ireland | 23401 | 1497 | 19470 | 2434 | 53.1424 | -7.6921 | 2020-05-14 03:32:28 | Ireland | |||
3847336 | 3847336 | 2020-05-13 | Israel | 16489 | 266 | 12398 | 3825 | 31.046051 | 34.851612 | 2020-05-14 03:32:28 | Israel | |||
3847337 | 3847337 | 2020-05-13 | Italy | 222104 | 31106 | 112541 | 78457 | 41.87194 | 12.56738 | 2020-05-14 03:32:28 | Italy | |||
3847338 | 3847338 | 2020-05-13 | Jamaica | 509 | 9 | 113 | 387 | 18.1096 | -77.2975 | 2020-05-14 03:32:28 | Jamaica | |||
3847339 | 3847339 | 2020-05-13 | Japan | 16049 | 678 | 8920 | 6451 | 36.204824 | 138.252924 | 2020-05-14 03:32:28 | Japan | |||
3847340 | 3847340 | 2020-05-13 | Jordan | 582 | 9 | 392 | 181 | 31.24 | 36.51 | 2020-05-14 03:32:28 | Jordan | |||
3847341 | 3847341 | 2020-05-13 | Kazakhstan | 5417 | 33 | 2408 | 2976 | 48.0196 | 66.9237 | 2020-05-14 03:32:28 | Kazakhstan | |||
3847342 | 3847342 | 2020-05-13 | Kenya | 737 | 40 | 281 | 416 | -0.0236 | 37.9062 | 2020-05-14 03:32:28 | Kenya | |||
3847343 | 3847343 | 2020-05-13 | Korea, South | 10991 | 260 | 9762 | 969 | 35.90775700000001 | 127.766922 | 2020-05-14 03:32:28 | Korea, South | |||
3847344 | 3847344 | 2020-05-13 | Kosovo | 919 | 29 | 671 | 219 | 42.602636 | 20.902977 | 2020-05-14 03:32:28 | Kosovo | |||
3847345 | 3847345 | 2020-05-13 | Kuwait | 11028 | 82 | 3263 | 7683 | 29.31166 | 47.481766 | 2020-05-14 03:32:28 | Kuwait | |||
3847346 | 3847346 | 2020-05-13 | Kyrgyzstan | 1044 | 12 | 726 | 306 | 41.20438 | 74.766098 | 2020-05-14 03:32:28 | Kyrgyzstan | |||
3847347 | 3847347 | 2020-05-13 | Laos | 19 | 0 | 14 | 5 | 19.85627 | 102.495496 | 2020-05-14 03:32:28 | Laos | |||
3847348 | 3847348 | 2020-05-13 | Latvia | 951 | 19 | 627 | 305 | 56.8796 | 24.6032 | 2020-05-14 03:32:28 | Latvia | |||
3847349 | 3847349 | 2020-05-13 | Lebanon | 878 | 26 | 236 | 616 | 33.8547 | 35.8623 | 2020-05-14 03:32:28 | Lebanon | |||
3847350 | 3847350 | 2020-05-13 | Lesotho | 1 | 0 | 0 | 1 | -29.609988 | 28.233608 | 2020-05-14 03:32:28 | Lesotho | |||
3847351 | 3847351 | 2020-05-13 | Liberia | 212 | 20 | 101 | 91 | 6.4280550000000005 | -9.429499 | 2020-05-14 03:32:28 | Liberia | |||
3847352 | 3847352 | 2020-05-13 | Libya | 64 | 3 | 28 | 33 | 26.3351 | 17.228331 | 2020-05-14 03:32:28 | Libya | |||
3847353 | 3847353 | 2020-05-13 | Liechtenstein | 83 | 1 | 55 | 27 | 47.14 | 9.55 | 2020-05-14 03:32:28 | Liechtenstein | |||
3847354 | 3847354 | 2020-05-13 | Lithuania | 1431 | 39 | 989 | 474 | 55.1694 | 23.8813 | 2020-05-14 03:32:28 | Lithuania | |||
3847355 | 3847355 | 2020-05-13 | Luxembourg | 3904 | 103 | 3629 | 172 | 49.8153 | 6.1296 | 2020-05-14 03:32:28 | Luxembourg | |||
3847356 | 3847356 | 2020-05-13 | MS Zaandam | 9 | 2 | 0 | 7 | 2020-05-14 03:32:28 | MS Zaandam | |||||
3847357 | 3847357 | 2020-05-13 | Madagascar | 212 | 0 | 107 | 105 | -18.766947 | 46.869107 | 2020-05-14 03:32:28 | Madagascar | |||
3847358 | 3847358 | 2020-05-13 | Malawi | 63 | 3 | 24 | 36 | -13.254307999999998 | 34.301525 | 2020-05-14 03:32:28 | Malawi | |||
3847359 | 3847359 | 2020-05-13 | Maldives | 955 | 4 | 40 | 911 | 3.2028 | 73.2207 | 2020-05-14 03:32:28 | Maldives | |||
3847360 | 3847360 | 2020-05-13 | Mali | 758 | 44 | 412 | 302 | 17.570692 | -3.996166000000001 | 2020-05-14 03:32:28 | Mali | |||
3847361 | 3847361 | 2020-05-13 | Malta | 508 | 6 | 436 | 66 | 35.9375 | 14.3754 | 2020-05-14 03:32:28 | Malta | |||
3847362 | 3847362 | 2020-05-13 | Mauritania | 15 | 2 | 6 | 7 | 21.0079 | -10.9408 | 2020-05-14 03:32:28 | Mauritania | |||
3847363 | 3847363 | 2020-05-13 | Mauritius | 332 | 10 | 322 | 0 | -20.348404 | 57.552152 | 2020-05-14 03:32:28 | Mauritius | |||
3847364 | 3847364 | 2020-05-13 | Mexico | 40186 | 4220 | 26990 | 8976 | 23.6345 | -102.5528 | 2020-05-14 03:32:28 | Mexico | |||
3847365 | 3847365 | 2020-05-13 | Moldova | 5406 | 185 | 2176 | 3045 | 47.4116 | 28.3699 | 2020-05-14 03:32:28 | Moldova | |||
3847366 | 3847366 | 2020-05-13 | Monaco | 96 | 4 | 87 | 5 | 43.7333 | 7.4167 | 2020-05-14 03:32:28 | Monaco | |||
3847367 | 3847367 | 2020-05-13 | Mongolia | 42 | 0 | 15 | 27 | 46.8625 | 103.8467 | 2020-05-14 03:32:28 | Mongolia | |||
3847368 | 3847368 | 2020-05-13 | Montenegro | 324 | 9 | 307 | 8 | 42.708678000000006 | 19.37439 | 2020-05-14 03:32:28 | Montenegro | |||
3847369 | 3847369 | 2020-05-13 | Morocco | 6512 | 188 | 3131 | 3193 | 31.7917 | -7.0926 | 2020-05-14 03:32:28 | Morocco | |||
3847370 | 3847370 | 2020-05-13 | Mozambique | 104 | 0 | 34 | 70 | -18.665695 | 35.529562 | 2020-05-14 03:32:28 | Mozambique | |||
3847371 | 3847371 | 2020-05-13 | Namibia | 16 | 0 | 11 | 5 | -22.9576 | 18.4904 | 2020-05-14 03:32:28 | Namibia | |||
3847372 | 3847372 | 2020-05-13 | Nepal | 250 | 0 | 35 | 215 | 28.1667 | 84.25 | 2020-05-14 03:32:28 | Nepal | |||
3847373 | 3847373 | 2020-05-13 | Netherlands | 43211 | 5562 | 0 | 37649 | 52.1326 | 5.2913 | 2020-05-14 03:32:28 | Netherlands | |||
3847374 | 3847374 | 2020-05-13 | New Zealand | 1497 | 22 | 1411 | 65 | -40.9006 | 174.886 | 2020-05-14 03:32:28 | New Zealand | |||
3847375 | 3847375 | 2020-05-13 | Nicaragua | 16 | 5 | 7 | 10 | 12.865416 | -85.207229 | 2020-05-14 03:32:28 | Nicaragua | |||
3847376 | 3847376 | 2020-05-13 | Niger | 860 | 49 | 658 | 153 | 17.607789 | 8.081666 | 2020-05-14 03:32:28 | Niger | |||
3847377 | 3847377 | 2020-05-13 | Nigeria | 4971 | 164 | 1070 | 3737 | 9.082 | 8.6753 | 2020-05-14 03:32:28 | Nigeria | |||
3847378 | 3847378 | 2020-05-13 | North Macedonia | 1694 | 95 | 1229 | 370 | 41.6086 | 21.7453 | 2020-05-14 03:32:28 | North Macedonia | |||
3847379 | 3847379 | 2020-05-13 | Norway | 8175 | 229 | 32 | 7914 | 60.472 | 8.4689 | 2020-05-14 03:32:28 | Norway | |||
3847380 | 3847380 | 2020-05-13 | Oman | 4019 | 17 | 1289 | 2713 | 21.512583 | 55.92325500000001 | 2020-05-14 03:32:28 | Oman | |||
3847381 | 3847381 | 2020-05-13 | Pakistan | 35298 | 761 | 8899 | 25638 | 30.3753 | 69.3451 | 2020-05-14 03:32:28 | Pakistan | |||
3847382 | 3847382 | 2020-05-13 | Panama | 8944 | 256 | 6067 | 2621 | 8.538 | -80.7821 | 2020-05-14 03:32:28 | Panama | |||
3847383 | 3847383 | 2020-05-13 | Papua New Guinea | 8 | 0 | 8 | 0 | -6.314993 | 143.95555 | 2020-05-14 03:32:28 | Papua New Guinea | |||
3847384 | 3847384 | 2020-05-13 | Paraguay | 740 | 11 | 182 | 547 | -23.4425 | -58.4438 | 2020-05-14 03:32:28 | Paraguay | |||
3847385 | 3847385 | 2020-05-13 | Peru | 76306 | 10760 | 24324 | 41222 | -9.19 | -75.0152 | 2020-05-14 03:32:28 | Peru | |||
3847386 | 3847386 | 2020-05-13 | Philippines | 11618 | 772 | 2251 | 8595 | 12.879721 | 121.774017 | 2020-05-14 03:32:28 | Philippines | |||
3847387 | 3847387 | 2020-05-13 | Poland | 17204 | 861 | 6410 | 9933 | 51.9194 | 19.1451 | 2020-05-14 03:32:28 | Poland | |||
3847388 | 3847388 | 2020-05-13 | Portugal | 28132 | 1175 | 3182 | 23775 | 39.3999 | -8.2245 | 2020-05-14 03:32:28 | Portugal | |||
3847389 | 3847389 | 2020-05-13 | Qatar | 26539 | 14 | 3143 | 23382 | 25.3548 | 51.1839 | 2020-05-14 03:32:28 | Qatar | |||
3847390 | 3847390 | 2020-05-13 | Romania | 16002 | 1036 | 7961 | 7005 | 45.9432 | 24.9668 | 2020-05-14 03:32:28 | Romania | |||
3847391 | 3847391 | 2020-05-13 | Russia | 242271 | 2212 | 48003 | 192056 | 61.52401 | 105.318756 | 2020-05-14 03:32:28 | Russia | |||
3847392 | 3847392 | 2020-05-13 | Rwanda | 287 | 0 | 164 | 123 | -1.9403 | 29.8739 | 2020-05-14 03:32:28 | Rwanda | |||
3847393 | 3847393 | 2020-05-13 | Saint Kitts and Nevis | 15 | 0 | 14 | 1 | 17.357822 | -62.782998 | 2020-05-14 03:32:28 | Saint Kitts and Nevis | |||
3847394 | 3847394 | 2020-05-13 | Saint Lucia | 18 | 0 | 18 | 0 | 13.9094 | -60.9789 | 2020-05-14 03:32:28 | Saint Lucia | |||
3847395 | 3847395 | 2020-05-13 | Saint Vincent and the Grenadines | 17 | 0 | 12 | 5 | 12.9843 | -61.2872 | 2020-05-14 03:32:28 | Saint Vincent and the Grenadines | |||
3847396 | 3847396 | 2020-05-13 | Samoa | 0 | 0 | 0 | 0 | -13.759 | -172.1046 | 2020-05-14 03:32:28 | Samoa | |||
3847397 | 3847397 | 2020-05-13 | San Marino | 647 | 41 | 161 | 445 | 43.9424 | 12.4578 | 2020-05-14 03:32:28 | San Marino | |||
3847398 | 3847398 | 2020-05-13 | Sao Tome and Principe | 220 | 6 | 4 | 210 | 0.18636 | 6.613081 | 2020-05-14 03:32:28 | Sao Tome and Principe | |||
3847399 | 3847399 | 2020-05-13 | Saudi Arabia | 44830 | 273 | 17622 | 26935 | 23.885942 | 45.079162 | 2020-05-14 03:32:28 | Saudi Arabia | |||
3847400 | 3847400 | 2020-05-13 | Senegal | 2105 | 21 | 782 | 1302 | 14.4974 | -14.4524 | 2020-05-14 03:32:28 | Senegal | |||
3847401 | 3847401 | 2020-05-13 | Serbia | 10295 | 222 | 3824 | 6249 | 44.0165 | 21.0059 | 2020-05-14 03:32:28 | Serbia | |||
3847402 | 3847402 | 2020-05-13 | Seychelles | 11 | 0 | 10 | 1 | -4.6796 | 55.492 | 2020-05-14 03:32:28 | Seychelles | |||
3847403 | 3847403 | 2020-05-13 | Sierra Leone | 387 | 26 | 97 | 264 | 8.460555000000001 | -11.779889 | 2020-05-14 03:32:28 | Sierra Leone | |||
3847404 | 3847404 | 2020-05-13 | Singapore | 25346 | 21 | 4809 | 20516 | 1.2833 | 103.8333 | 2020-05-14 03:32:28 | Singapore | |||
3847405 | 3847405 | 2020-05-13 | Slovakia | 1469 | 27 | 1060 | 382 | 48.669 | 19.699 | 2020-05-14 03:32:28 | Slovakia | |||
3847406 | 3847406 | 2020-05-13 | Slovenia | 1463 | 103 | 260 | 1100 | 46.1512 | 14.9955 | 2020-05-14 03:32:28 | Slovenia | |||
3847407 | 3847407 | 2020-05-13 | Somalia | 1219 | 52 | 130 | 1037 | 5.152149 | 46.199616 | 2020-05-14 03:32:28 | Somalia | |||
3847408 | 3847408 | 2020-05-13 | South Africa | 12074 | 219 | 4745 | 7110 | -30.5595 | 22.9375 | 2020-05-14 03:32:28 | South Africa | |||
3847409 | 3847409 | 2020-05-13 | South Sudan | 203 | 0 | 2 | 201 | 6.877000000000002 | 31.307 | 2020-05-14 03:32:28 | South Sudan | |||
3847410 | 3847410 | 2020-05-13 | Spain | 228691 | 27104 | 140823 | 60764 | 40.463667 | -3.74922 | 2020-05-14 03:32:28 | Spain | |||
3847411 | 3847411 | 2020-05-13 | Sri Lanka | 915 | 9 | 382 | 524 | 7.873054 | 80.77179699999998 | 2020-05-14 03:32:28 | Sri Lanka | |||
3847412 | 3847412 | 2020-05-13 | Sudan | 1660 | 90 | 198 | 1372 | 12.8628 | 30.2176 | 2020-05-14 03:32:28 | Sudan | |||
3847413 | 3847413 | 2020-05-13 | Suriname | 10 | 1 | 9 | 0 | 3.9193 | -56.0278 | 2020-05-14 03:32:28 | Suriname | |||
3847414 | 3847414 | 2020-05-13 | Sweden | 27909 | 3460 | 4971 | 19478 | 60.128161 | 18.643501 | 2020-05-14 03:32:28 | Sweden | |||
3847415 | 3847415 | 2020-05-13 | Switzerland | 30413 | 1761 | 27100 | 1552 | 46.8182 | 8.2275 | 2020-05-14 03:32:28 | Switzerland | |||
3847416 | 3847416 | 2020-05-13 | Syria | 48 | 3 | 29 | 16 | 34.802075 | 38.99681500000001 | 2020-05-14 03:32:28 | Syria | |||
3847417 | 3847417 | 2020-05-13 | Taiwan* | 440 | 7 | 375 | 58 | 23.7 | 121.0 | 2020-05-14 03:32:28 | Taiwan* | |||
3847418 | 3847418 | 2020-05-13 | Tajikistan | 729 | 23 | 0 | 706 | 38.861034 | 71.276093 | 2020-05-14 03:32:28 | Tajikistan |
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]);