johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1018420 | 1018420 | 2022-12-24 | Malaysia | W.P. Labuan | 22904 | 158 | 0 | 5.2831 | 115.2308 | 2022-12-25 04:21:04 | W.P. Labuan, Malaysia | |||
1018421 | 1018421 | 2022-12-24 | Malaysia | W.P. Putrajaya | 32038 | 31 | 0 | 2.9264 | 101.6964 | 2022-12-25 04:21:04 | W.P. Putrajaya, Malaysia | |||
1018422 | 1018422 | 2022-12-24 | Maldives | 185666 | 311 | 0 | 3.2028 | 73.2207 | 2022-12-25 04:21:04 | Maldives | ||||
1018423 | 1018423 | 2022-12-24 | Mali | 32768 | 743 | 0 | 17.570692 | -3.996166 | 2022-12-25 04:21:04 | Mali | ||||
1018424 | 1018424 | 2022-12-24 | Malta | 116231 | 813 | 0 | 35.9375 | 14.3754 | 2022-12-25 04:21:04 | Malta | ||||
1018425 | 1018425 | 2022-12-24 | Marshall Islands | 15547 | 17 | 0 | 7.1315 | 171.1845 | 2022-12-25 04:21:04 | Marshall Islands | ||||
1018426 | 1018426 | 2022-12-24 | Mauritania | 63425 | 997 | 0 | 21.0079 | -10.9408 | 2022-12-25 04:21:04 | Mauritania | ||||
1018427 | 1018427 | 2022-12-24 | Mauritius | 289980 | 1039 | 0 | -20.348404 | 57.552152 | 2022-12-25 04:21:04 | Mauritius | ||||
1018428 | 1018428 | 2022-12-24 | Mexico | Aguascalientes | 85635 | 3594 | 0 | 21.8853 | -102.2916 | 2022-12-25 04:21:04 | Aguascalientes, Mexico | |||
1018429 | 1018429 | 2022-12-24 | Mexico | Baja California | 169422 | 12454 | 0 | 30.8406 | -115.2838 | 2022-12-25 04:21:04 | Baja California, Mexico | |||
1018430 | 1018430 | 2022-12-24 | Mexico | Baja California Sur | 125960 | 2768 | 0 | 26.0444 | -111.6661 | 2022-12-25 04:21:04 | Baja California Sur, Mexico | |||
1018431 | 1018431 | 2022-12-24 | Mexico | Campeche | 43882 | 2288 | 0 | 19.8301 | -90.5349 | 2022-12-25 04:21:04 | Campeche, Mexico | |||
1018432 | 1018432 | 2022-12-24 | Mexico | Chiapas | 54018 | 2439 | 0 | 16.7569 | -93.1292 | 2022-12-25 04:21:04 | Chiapas, Mexico | |||
1018433 | 1018433 | 2022-12-24 | Mexico | Chihuahua | 170004 | 10179 | 0 | 28.633 | -106.0691 | 2022-12-25 04:21:04 | Chihuahua, Mexico | |||
1018434 | 1018434 | 2022-12-24 | Mexico | Ciudad de Mexico | 1782891 | 43682 | 0 | 19.4326 | -99.1332 | 2022-12-25 04:21:04 | Ciudad de Mexico, Mexico | |||
1018435 | 1018435 | 2022-12-24 | Mexico | Coahuila | 181926 | 8975 | 0 | 27.0587 | -101.7068 | 2022-12-25 04:21:04 | Coahuila, Mexico | |||
1018436 | 1018436 | 2022-12-24 | Mexico | Colima | 67942 | 2245 | 0 | 19.1223 | -104.0072 | 2022-12-25 04:21:04 | Colima, Mexico | |||
1018437 | 1018437 | 2022-12-24 | Mexico | Durango | 79660 | 3679 | 0 | 24.5593 | -104.6588 | 2022-12-25 04:21:04 | Durango, Mexico | |||
1018438 | 1018438 | 2022-12-24 | Mexico | Guanajuato | 354923 | 15117 | 0 | 21.019 | -101.2574 | 2022-12-25 04:21:04 | Guanajuato, Mexico | |||
1018439 | 1018439 | 2022-12-24 | Mexico | Guerrero | 117117 | 6861 | 0 | 17.4392 | -99.5451 | 2022-12-25 04:21:04 | Guerrero, Mexico | |||
1018440 | 1018440 | 2022-12-24 | Mexico | Hidalgo | 121586 | 8562 | 0 | 20.0911 | -98.7624 | 2022-12-25 04:21:04 | Hidalgo, Mexico | |||
1018441 | 1018441 | 2022-12-24 | Mexico | Jalisco | 287498 | 20009 | 0 | 20.6595 | -103.3494 | 2022-12-25 04:21:04 | Jalisco, Mexico | |||
1018442 | 1018442 | 2022-12-24 | Mexico | Mexico | 713682 | 47966 | 0 | 19.4969 | -99.7233 | 2022-12-25 04:21:04 | Mexico, Mexico | |||
1018443 | 1018443 | 2022-12-24 | Mexico | Michoacan | 110643 | 8979 | 0 | 19.5665 | -101.7068 | 2022-12-25 04:21:04 | Michoacan, Mexico | |||
1018444 | 1018444 | 2022-12-24 | Mexico | Morelos | 93115 | 5425 | 0 | 18.6813 | -99.1013 | 2022-12-25 04:21:04 | Morelos, Mexico | |||
1018445 | 1018445 | 2022-12-24 | Mexico | Nayarit | 72798 | 3250 | 0 | 21.7514 | -104.8455 | 2022-12-25 04:21:04 | Nayarit, Mexico | |||
1018446 | 1018446 | 2022-12-24 | Mexico | Nuevo Leon | 404231 | 15391 | 0 | 25.5922 | -99.9962 | 2022-12-25 04:21:04 | Nuevo Leon, Mexico | |||
1018447 | 1018447 | 2022-12-24 | Mexico | Oaxaca | 151008 | 6360 | 0 | 17.0732 | -96.7266 | 2022-12-25 04:21:04 | Oaxaca, Mexico | |||
1018448 | 1018448 | 2022-12-24 | Mexico | Puebla | 210923 | 16666 | 0 | 19.0414 | -98.2063 | 2022-12-25 04:21:04 | Puebla, Mexico | |||
1018449 | 1018449 | 2022-12-24 | Mexico | Queretaro | 178998 | 6355 | 0 | 20.5888 | -100.3899 | 2022-12-25 04:21:04 | Queretaro, Mexico | |||
1018450 | 1018450 | 2022-12-24 | Mexico | Quintana Roo | 116789 | 4446 | 0 | 19.1817 | -88.4791 | 2022-12-25 04:21:04 | Quintana Roo, Mexico | |||
1018451 | 1018451 | 2022-12-24 | Mexico | San Luis Potosi | 244772 | 7619 | 0 | 22.1565 | -100.9855 | 2022-12-25 04:21:04 | San Luis Potosi, Mexico | |||
1018452 | 1018452 | 2022-12-24 | Mexico | Sinaloa | 178281 | 9930 | 0 | 25.1721 | -107.4795 | 2022-12-25 04:21:04 | Sinaloa, Mexico | |||
1018453 | 1018453 | 2022-12-24 | Mexico | Sonora | 198350 | 10314 | 0 | 29.2972 | -110.3309 | 2022-12-25 04:21:04 | Sonora, Mexico | |||
1018454 | 1018454 | 2022-12-24 | Mexico | Tabasco | 219108 | 6145 | 0 | 17.8409 | -92.6189 | 2022-12-25 04:21:04 | Tabasco, Mexico | |||
1018455 | 1018455 | 2022-12-24 | Mexico | Tamaulipas | 179641 | 8226 | 0 | 24.2669 | -98.8363 | 2022-12-25 04:21:04 | Tamaulipas, Mexico | |||
1018456 | 1018456 | 2022-12-24 | Mexico | Tlaxcala | 56906 | 3124 | 0 | 19.3139 | -98.2404 | 2022-12-25 04:21:04 | Tlaxcala, Mexico | |||
1018457 | 1018457 | 2022-12-24 | Mexico | Unknown | 0 | 0 | 0 | 2022-12-25 04:21:04 | Unknown, Mexico | |||||
1018458 | 1018458 | 2022-12-24 | Mexico | Veracruz | 227343 | 17065 | 0 | 19.1738 | -96.1342 | 2022-12-25 04:21:04 | Veracruz, Mexico | |||
1018459 | 1018459 | 2022-12-24 | Mexico | Yucatan | 141478 | 6963 | 0 | 20.7099 | -89.0943 | 2022-12-25 04:21:04 | Yucatan, Mexico | |||
1018460 | 1018460 | 2022-12-24 | Mexico | Zacatecas | 80521 | 3937 | 0 | 22.7709 | -102.5832 | 2022-12-25 04:21:04 | Zacatecas, Mexico | |||
1018461 | 1018461 | 2022-12-24 | Micronesia | 22203 | 58 | 0 | 7.4256 | 150.5508 | 2022-12-25 04:21:04 | Micronesia | ||||
1018462 | 1018462 | 2022-12-24 | Moldova | 596193 | 11929 | 0 | 47.4116 | 28.3699 | 2022-12-25 04:21:04 | Moldova | ||||
1018463 | 1018463 | 2022-12-24 | Monaco | 15911 | 65 | 0 | 43.7333 | 7.4167 | 2022-12-25 04:21:04 | Monaco | ||||
1018464 | 1018464 | 2022-12-24 | Mongolia | 1007266 | 2136 | 0 | 46.8625 | 103.8467 | 2022-12-25 04:21:04 | Mongolia | ||||
1018465 | 1018465 | 2022-12-24 | Montenegro | 284544 | 2791 | 0 | 42.708678 | 19.37439 | 2022-12-25 04:21:04 | Montenegro | ||||
1018466 | 1018466 | 2022-12-24 | Morocco | 1271244 | 16294 | 0 | 31.7917 | -7.0926 | 2022-12-25 04:21:04 | Morocco | ||||
1018467 | 1018467 | 2022-12-24 | Mozambique | 230918 | 2229 | 0 | -18.665695 | 35.529562 | 2022-12-25 04:21:04 | Mozambique | ||||
1018468 | 1018468 | 2022-12-24 | Namibia | 170181 | 4080 | 0 | -22.9576 | 18.4904 | 2022-12-25 04:21:04 | Namibia | ||||
1018469 | 1018469 | 2022-12-24 | Nauru | 4621 | 1 | 0 | -0.5228 | 166.9315 | 2022-12-25 04:21:04 | Nauru | ||||
1018470 | 1018470 | 2022-12-24 | Nepal | 1000962 | 12019 | 0 | 28.1667 | 84.25 | 2022-12-25 04:21:04 | Nepal | ||||
1018471 | 1018471 | 2022-12-24 | Netherlands | Aruba | 43752 | 280 | 0 | 12.5211 | -69.9683 | 2022-12-25 04:21:04 | Aruba, Netherlands | |||
1018472 | 1018472 | 2022-12-24 | Netherlands | Bonaire, Sint Eustatius and Saba | 11716 | 39 | 0 | 12.1784 | -68.2385 | 2022-12-25 04:21:04 | Bonaire, Sint Eustatius and Saba, Netherlands | |||
1018473 | 1018473 | 2022-12-24 | Netherlands | Curacao | 45986 | 299 | 0 | 12.1696 | -68.99 | 2022-12-25 04:21:04 | Curacao, Netherlands | |||
1018474 | 1018474 | 2022-12-24 | Netherlands | Drenthe | 215470 | 464 | 0 | 52.862485 | 6.618435 | 2022-12-25 04:21:04 | Drenthe, Netherlands | |||
1018475 | 1018475 | 2022-12-24 | Netherlands | Flevoland | 195079 | 341 | 0 | 52.550383 | 5.515162 | 2022-12-25 04:21:04 | Flevoland, Netherlands | |||
1018476 | 1018476 | 2022-12-24 | Netherlands | Friesland | 291960 | 623 | 0 | 53.087337 | 5.7925 | 2022-12-25 04:21:04 | Friesland, Netherlands | |||
1018477 | 1018477 | 2022-12-24 | Netherlands | Gelderland | 1047795 | 2947 | 0 | 52.061738 | 5.939114 | 2022-12-25 04:21:04 | Gelderland, Netherlands | |||
1018478 | 1018478 | 2022-12-24 | Netherlands | Groningen | 262948 | 366 | 0 | 53.217922 | 6.741514 | 2022-12-25 04:21:04 | Groningen, Netherlands | |||
1018479 | 1018479 | 2022-12-24 | Netherlands | Limburg | 563482 | 2208 | 0 | 51.209227 | 5.93387 | 2022-12-25 04:21:04 | Limburg, Netherlands | |||
1018480 | 1018480 | 2022-12-24 | Netherlands | Noord-Brabant | 1300018 | 3781 | 0 | 51.561174 | 5.184942 | 2022-12-25 04:21:04 | Noord-Brabant, Netherlands | |||
1018481 | 1018481 | 2022-12-24 | Netherlands | Noord-Holland | 1408323 | 3502 | 0 | 52.600906 | 4.918688 | 2022-12-25 04:21:04 | Noord-Holland, Netherlands | |||
1018482 | 1018482 | 2022-12-24 | Netherlands | Overijssel | 596920 | 1458 | 0 | 52.444558 | 6.441722 | 2022-12-25 04:21:04 | Overijssel, Netherlands | |||
1018483 | 1018483 | 2022-12-24 | Netherlands | Sint Maarten | 10988 | 89 | 0 | 18.0425 | -63.0548 | 2022-12-25 04:21:04 | Sint Maarten, Netherlands | |||
1018484 | 1018484 | 2022-12-24 | Netherlands | Unknown | 0 | 0 | 0 | 2022-12-25 04:21:04 | Unknown, Netherlands | |||||
1018485 | 1018485 | 2022-12-24 | Netherlands | Utrecht | 705135 | 1577 | 0 | 52.084251 | 5.163824 | 2022-12-25 04:21:04 | Utrecht, Netherlands | |||
1018486 | 1018486 | 2022-12-24 | Netherlands | Zeeland | 179653 | 402 | 0 | 51.47936 | 3.861559 | 2022-12-25 04:21:04 | Zeeland, Netherlands | |||
1018487 | 1018487 | 2022-12-24 | Netherlands | Zuid-Holland | 1796077 | 5299 | 0 | 51.937835 | 4.462114 | 2022-12-25 04:21:04 | Zuid-Holland, Netherlands | |||
1018488 | 1018488 | 2022-12-24 | New Zealand | Cook Islands | 6389 | 1 | 0 | -21.2367 | -159.7777 | 2022-12-25 04:21:04 | Cook Islands, New Zealand | |||
1018489 | 1018489 | 2022-12-24 | New Zealand | Niue | 362 | 0 | 0 | -19.0544 | -169.8672 | 2022-12-25 04:21:04 | Niue, New Zealand | |||
1018490 | 1018490 | 2022-12-24 | New Zealand | 2062384 | 2288 | 0 | -40.9006 | 174.886 | 2022-12-25 04:21:04 | New Zealand | ||||
1018491 | 1018491 | 2022-12-24 | Nicaragua | 15365 | 245 | 0 | 12.865416 | -85.207229 | 2022-12-25 04:21:04 | Nicaragua | ||||
1018492 | 1018492 | 2022-12-24 | Niger | 9473 | 314 | 0 | 17.607789 | 8.081666 | 2022-12-25 04:21:04 | Niger | ||||
1018493 | 1018493 | 2022-12-24 | Nigeria | 266381 | 3155 | 0 | 9.082 | 8.6753 | 2022-12-25 04:21:04 | Nigeria | ||||
1018494 | 1018494 | 2022-12-24 | North Macedonia | 345402 | 9608 | 0 | 41.6086 | 21.7453 | 2022-12-25 04:21:04 | North Macedonia | ||||
1018495 | 1018495 | 2022-12-24 | Norway | 1473848 | 4670 | 0 | 60.472 | 8.4689 | 2022-12-25 04:21:04 | Norway | ||||
1018496 | 1018496 | 2022-12-24 | Oman | 399154 | 4628 | 0 | 21.512583 | 55.923255 | 2022-12-25 04:21:04 | Oman | ||||
1018497 | 1018497 | 2022-12-24 | Pakistan | Azad Jammu and Kashmir | 44339 | 793 | 0 | 34.027401 | 73.947253 | 2022-12-25 04:21:04 | Azad Jammu and Kashmir, Pakistan | |||
1018498 | 1018498 | 2022-12-24 | Pakistan | Balochistan | 36029 | 378 | 0 | 28.328492 | 65.898403 | 2022-12-25 04:21:04 | Balochistan, Pakistan | |||
1018499 | 1018499 | 2022-12-24 | Pakistan | Gilgit-Baltistan | 12088 | 191 | 0 | 35.792146 | 74.982138 | 2022-12-25 04:21:04 | Gilgit-Baltistan, Pakistan | |||
1018500 | 1018500 | 2022-12-24 | Pakistan | Islamabad | 139656 | 1031 | 0 | 33.665087 | 73.121219 | 2022-12-25 04:21:04 | Islamabad, Pakistan | |||
1018501 | 1018501 | 2022-12-24 | Pakistan | Khyber Pakhtunkhwa | 224853 | 6374 | 0 | 34.485332 | 72.09169 | 2022-12-25 04:21:04 | Khyber Pakhtunkhwa, Pakistan | |||
1018502 | 1018502 | 2022-12-24 | Pakistan | Punjab | 523278 | 13617 | 0 | 30.811346 | 72.139132 | 2022-12-25 04:21:04 | Punjab, Pakistan | |||
1018503 | 1018503 | 2022-12-24 | Pakistan | Sindh | 595408 | 8251 | 0 | 26.009446 | 68.776807 | 2022-12-25 04:21:04 | Sindh, Pakistan | |||
1018504 | 1018504 | 2022-12-24 | Palau | 5968 | 9 | 0 | 7.515 | 134.5825 | 2022-12-25 04:21:04 | Palau | ||||
1018505 | 1018505 | 2022-12-24 | Panama | 1020961 | 8554 | 0 | 8.538 | -80.7821 | 2022-12-25 04:21:04 | Panama | ||||
1018506 | 1018506 | 2022-12-24 | Papua New Guinea | 46663 | 669 | 0 | -6.314993 | 143.95555 | 2022-12-25 04:21:04 | Papua New Guinea | ||||
1018507 | 1018507 | 2022-12-24 | Paraguay | 785534 | 19666 | 0 | -23.4425 | -58.4438 | 2022-12-25 04:21:04 | Paraguay | ||||
1018508 | 1018508 | 2022-12-24 | Peru | Amazonas | 50398 | 1378 | 0 | -5.077253 | -78.050172 | 2022-12-25 04:21:04 | Amazonas, Peru | |||
1018509 | 1018509 | 2022-12-24 | Peru | Ancash | 155329 | 7317 | 0 | -9.407125 | -77.671795 | 2022-12-25 04:21:04 | Ancash, Peru | |||
1018510 | 1018510 | 2022-12-24 | Peru | Apurimac | 45456 | 1686 | 0 | -14.027713 | -72.975378 | 2022-12-25 04:21:04 | Apurimac, Peru | |||
1018511 | 1018511 | 2022-12-24 | Peru | Arequipa | 278369 | 10508 | 0 | -15.843524 | -72.475539 | 2022-12-25 04:21:04 | Arequipa, Peru | |||
1018512 | 1018512 | 2022-12-24 | Peru | Ayacucho | 54940 | 2395 | 0 | -14.091648 | -74.08344 | 2022-12-25 04:21:04 | Ayacucho, Peru | |||
1018513 | 1018513 | 2022-12-24 | Peru | Cajamarca | 110377 | 4547 | 0 | -6.430284 | -78.745596 | 2022-12-25 04:21:04 | Cajamarca, Peru | |||
1018514 | 1018514 | 2022-12-24 | Peru | Callao | 168109 | 10817 | 0 | -11.954609 | -77.136042 | 2022-12-25 04:21:04 | Callao, Peru | |||
1018515 | 1018515 | 2022-12-24 | Peru | Cusco | 142662 | 5255 | 0 | -13.191068 | -72.153609 | 2022-12-25 04:21:04 | Cusco, Peru | |||
1018516 | 1018516 | 2022-12-24 | Peru | Huancavelica | 29560 | 1287 | 0 | -13.023888 | -75.00277 | 2022-12-25 04:21:04 | Huancavelica, Peru | |||
1018517 | 1018517 | 2022-12-24 | Peru | Huanuco | 59935 | 2948 | 0 | -9.421676 | -76.040642 | 2022-12-25 04:21:04 | Huanuco, Peru | |||
1018518 | 1018518 | 2022-12-24 | Peru | Ica | 126792 | 9042 | 0 | -14.235097 | -75.574821 | 2022-12-25 04:21:04 | Ica, Peru | |||
1018519 | 1018519 | 2022-12-24 | Peru | Junin | 151384 | 7569 | 0 | -11.541783 | -74.876968 | 2022-12-25 04:21:04 | Junin, Peru |
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]);