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
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
222073 | 222073 | 2022-05-09 | Mexico | Baja California | 134242 | 12277 | 0 | 30.8406 | -115.2838 | 2022-05-10 04:20:50 | Baja California, Mexico | |||
222074 | 222074 | 2022-05-09 | Mexico | Baja California Sur | 103822 | 2689 | 0 | 26.0444 | -111.6661 | 2022-05-10 04:20:50 | Baja California Sur, Mexico | |||
222075 | 222075 | 2022-05-09 | Mexico | Campeche | 34111 | 2242 | 0 | 19.8301 | -90.5349 | 2022-05-10 04:20:50 | Campeche, Mexico | |||
222076 | 222076 | 2022-05-09 | Mexico | Chiapas | 39224 | 2411 | 0 | 16.7569 | -93.1292 | 2022-05-10 04:20:50 | Chiapas, Mexico | |||
222077 | 222077 | 2022-05-09 | Mexico | Chihuahua | 131652 | 9959 | 0 | 28.633 | -106.0691 | 2022-05-10 04:20:50 | Chihuahua, Mexico | |||
222078 | 222078 | 2022-05-09 | Mexico | Ciudad de Mexico | 1399114 | 42799 | 0 | 19.4326 | -99.1332 | 2022-05-10 04:20:50 | Ciudad de Mexico, Mexico | |||
222079 | 222079 | 2022-05-09 | Mexico | Coahuila | 145507 | 8797 | 0 | 27.0587 | -101.7068 | 2022-05-10 04:20:50 | Coahuila, Mexico | |||
222080 | 222080 | 2022-05-09 | Mexico | Colima | 54791 | 2202 | 0 | 19.1223 | -104.0072 | 2022-05-10 04:20:50 | Colima, Mexico | |||
222081 | 222081 | 2022-05-09 | Mexico | Durango | 68252 | 3616 | 0 | 24.5593 | -104.6588 | 2022-05-10 04:20:50 | Durango, Mexico | |||
222082 | 222082 | 2022-05-09 | Mexico | Guanajuato | 282183 | 14887 | 0 | 21.019 | -101.2574 | 2022-05-10 04:20:50 | Guanajuato, Mexico | |||
222083 | 222083 | 2022-05-09 | Mexico | Guerrero | 98402 | 6758 | 0 | 17.4392 | -99.5451 | 2022-05-10 04:20:50 | Guerrero, Mexico | |||
222084 | 222084 | 2022-05-09 | Mexico | Hidalgo | 93553 | 8410 | 0 | 20.0911 | -98.7624 | 2022-05-10 04:20:50 | Hidalgo, Mexico | |||
222085 | 222085 | 2022-05-09 | Mexico | Jalisco | 245702 | 19620 | 0 | 20.6595 | -103.3494 | 2022-05-10 04:20:50 | Jalisco, Mexico | |||
222086 | 222086 | 2022-05-09 | Mexico | Mexico | 572400 | 47244 | 0 | 19.4969 | -99.7233 | 2022-05-10 04:20:50 | Mexico, Mexico | |||
222087 | 222087 | 2022-05-09 | Mexico | Michoacan | 94180 | 8827 | 0 | 19.5665 | -101.7068 | 2022-05-10 04:20:50 | Michoacan, Mexico | |||
222088 | 222088 | 2022-05-09 | Mexico | Morelos | 70280 | 5270 | 0 | 18.6813 | -99.1013 | 2022-05-10 04:20:50 | Morelos, Mexico | |||
222089 | 222089 | 2022-05-09 | Mexico | Nayarit | 58266 | 3200 | 0 | 21.7514 | -104.8455 | 2022-05-10 04:20:50 | Nayarit, Mexico | |||
222090 | 222090 | 2022-05-09 | Mexico | Nuevo Leon | 319587 | 15005 | 0 | 25.5922 | -99.9962 | 2022-05-10 04:20:50 | Nuevo Leon, Mexico | |||
222091 | 222091 | 2022-05-09 | Mexico | Oaxaca | 120093 | 6191 | 0 | 17.0732 | -96.7266 | 2022-05-10 04:20:50 | Oaxaca, Mexico | |||
222092 | 222092 | 2022-05-09 | Mexico | Puebla | 169683 | 16452 | 0 | 19.0414 | -98.2063 | 2022-05-10 04:20:50 | Puebla, Mexico | |||
222093 | 222093 | 2022-05-09 | Mexico | Queretaro | 142136 | 6195 | 0 | 20.5888 | -100.3899 | 2022-05-10 04:20:50 | Queretaro, Mexico | |||
222094 | 222094 | 2022-05-09 | Mexico | Quintana Roo | 91986 | 4380 | 0 | 19.1817 | -88.4791 | 2022-05-10 04:20:50 | Quintana Roo, Mexico | |||
222095 | 222095 | 2022-05-09 | Mexico | San Luis Potosi | 186388 | 7484 | 0 | 22.1565 | -100.9855 | 2022-05-10 04:20:50 | San Luis Potosi, Mexico | |||
222096 | 222096 | 2022-05-09 | Mexico | Sinaloa | 122053 | 9724 | 0 | 25.1721 | -107.4795 | 2022-05-10 04:20:50 | Sinaloa, Mexico | |||
222097 | 222097 | 2022-05-09 | Mexico | Sonora | 165650 | 10119 | 0 | 29.2972 | -110.3309 | 2022-05-10 04:20:50 | Sonora, Mexico | |||
222098 | 222098 | 2022-05-09 | Mexico | Tabasco | 189805 | 6047 | 0 | 17.8409 | -92.6189 | 2022-05-10 04:20:50 | Tabasco, Mexico | |||
222099 | 222099 | 2022-05-09 | Mexico | Tamaulipas | 146335 | 7992 | 0 | 24.2669 | -98.8363 | 2022-05-10 04:20:50 | Tamaulipas, Mexico | |||
222100 | 222100 | 2022-05-09 | Mexico | Tlaxcala | 43849 | 3073 | 0 | 19.3139 | -98.2404 | 2022-05-10 04:20:50 | Tlaxcala, Mexico | |||
222101 | 222101 | 2022-05-09 | Mexico | Unknown | 0 | 0 | 0 | 2022-05-10 04:20:50 | Unknown, Mexico | |||||
222102 | 222102 | 2022-05-09 | Mexico | Veracruz | 179213 | 16426 | 0 | 19.1738 | -96.1342 | 2022-05-10 04:20:50 | Veracruz, Mexico | |||
222103 | 222103 | 2022-05-09 | Mexico | Yucatan | 109376 | 6809 | 0 | 20.7099 | -89.0943 | 2022-05-10 04:20:50 | Yucatan, Mexico | |||
222104 | 222104 | 2022-05-09 | Mexico | Zacatecas | 67680 | 3858 | 0 | 22.7709 | -102.5832 | 2022-05-10 04:20:50 | Zacatecas, Mexico | |||
222105 | 222105 | 2022-05-09 | Micronesia | 7 | 0 | 0 | 7.4256 | 150.5508 | 2022-05-10 04:20:50 | Micronesia | ||||
222106 | 222106 | 2022-05-09 | Moldova | 517753 | 11503 | 0 | 47.4116 | 28.3699 | 2022-05-10 04:20:50 | Moldova | ||||
222107 | 222107 | 2022-05-09 | Monaco | 11946 | 57 | 0 | 43.7333 | 7.4167 | 2022-05-10 04:20:50 | Monaco | ||||
222108 | 222108 | 2022-05-09 | Mongolia | 922227 | 2111 | 0 | 46.8625 | 103.8467 | 2022-05-10 04:20:50 | Mongolia | ||||
222109 | 222109 | 2022-05-09 | Montenegro | 235837 | 2717 | 0 | 42.708678 | 19.37439 | 2022-05-10 04:20:50 | Montenegro | ||||
222110 | 222110 | 2022-05-09 | Morocco | 1165283 | 16071 | 0 | 31.7917 | -7.0926 | 2022-05-10 04:20:50 | Morocco | ||||
222111 | 222111 | 2022-05-09 | Mozambique | 225430 | 2201 | 0 | -18.665695 | 35.529562 | 2022-05-10 04:20:50 | Mozambique | ||||
222112 | 222112 | 2022-05-09 | Namibia | 159278 | 4027 | 0 | -22.9576 | 18.4904 | 2022-05-10 04:20:50 | Namibia | ||||
222113 | 222113 | 2022-05-09 | Nepal | 978948 | 11952 | 0 | 28.1667 | 84.25 | 2022-05-10 04:20:50 | Nepal | ||||
222114 | 222114 | 2022-05-09 | Netherlands | Aruba | 35189 | 212 | 0 | 12.5211 | -69.9683 | 2022-05-10 04:20:50 | Aruba, Netherlands | |||
222115 | 222115 | 2022-05-09 | Netherlands | Bonaire, Sint Eustatius and Saba | 9902 | 35 | 0 | 12.1784 | -68.2385 | 2022-05-10 04:20:50 | Bonaire, Sint Eustatius and Saba, Netherlands | |||
222116 | 222116 | 2022-05-09 | Netherlands | Curacao | 42567 | 275 | 0 | 12.1696 | -68.99 | 2022-05-10 04:20:50 | Curacao, Netherlands | |||
222117 | 222117 | 2022-05-09 | Netherlands | Drenthe | 202198 | 451 | 0 | 52.862485 | 6.618435 | 2022-05-10 04:20:50 | Drenthe, Netherlands | |||
222118 | 222118 | 2022-05-09 | Netherlands | Flevoland | 183388 | 331 | 0 | 52.550383 | 5.515162 | 2022-05-10 04:20:50 | Flevoland, Netherlands | |||
222119 | 222119 | 2022-05-09 | Netherlands | Friesland | 277378 | 617 | 0 | 53.087337 | 5.7925 | 2022-05-10 04:20:50 | Friesland, Netherlands | |||
222120 | 222120 | 2022-05-09 | Netherlands | Gelderland | 983602 | 2797 | 0 | 52.061738 | 5.939114 | 2022-05-10 04:20:50 | Gelderland, Netherlands | |||
222121 | 222121 | 2022-05-09 | Netherlands | Groningen | 247922 | 355 | 0 | 53.217922 | 6.741514 | 2022-05-10 04:20:50 | Groningen, Netherlands | |||
222122 | 222122 | 2022-05-09 | Netherlands | Limburg | 528170 | 2165 | 0 | 51.209227 | 5.93387 | 2022-05-10 04:20:50 | Limburg, Netherlands | |||
222123 | 222123 | 2022-05-09 | Netherlands | Noord-Brabant | 1233819 | 3695 | 0 | 51.561174 | 5.184942 | 2022-05-10 04:20:50 | Noord-Brabant, Netherlands | |||
222124 | 222124 | 2022-05-09 | Netherlands | Noord-Holland | 1319959 | 3369 | 0 | 52.600906 | 4.918688 | 2022-05-10 04:20:50 | Noord-Holland, Netherlands | |||
222125 | 222125 | 2022-05-09 | Netherlands | Overijssel | 565021 | 1416 | 0 | 52.444558 | 6.441722 | 2022-05-10 04:20:50 | Overijssel, Netherlands | |||
222126 | 222126 | 2022-05-09 | Netherlands | Sint Maarten | 10123 | 86 | 0 | 18.0425 | -63.0548 | 2022-05-10 04:20:50 | Sint Maarten, Netherlands | |||
222127 | 222127 | 2022-05-09 | Netherlands | Unknown | 68 | 0 | 0 | 2022-02-28 23:21:00 | Unknown, Netherlands | |||||
222128 | 222128 | 2022-05-09 | Netherlands | Utrecht | 662650 | 1535 | 0 | 52.084251 | 5.163824 | 2022-05-10 04:20:50 | Utrecht, Netherlands | |||
222129 | 222129 | 2022-05-09 | Netherlands | Zeeland | 167965 | 388 | 0 | 51.47936 | 3.861559 | 2022-05-10 04:20:50 | Zeeland, Netherlands | |||
222130 | 222130 | 2022-05-09 | Netherlands | Zuid-Holland | 1689306 | 5159 | 0 | 51.937835 | 4.462114 | 2022-05-10 04:20:50 | Zuid-Holland, Netherlands | |||
222131 | 222131 | 2022-05-09 | New Zealand | Cook Islands | 5306 | 1 | 0 | -21.2367 | -159.7777 | 2022-05-10 04:20:50 | Cook Islands, New Zealand | |||
222132 | 222132 | 2022-05-09 | New Zealand | 1005674 | 750 | 0 | -40.9006 | 174.886 | 2022-05-10 04:20:50 | New Zealand | ||||
222133 | 222133 | 2022-05-09 | Nicaragua | 14422 | 235 | 0 | 12.865416 | -85.207229 | 2022-05-10 04:20:50 | Nicaragua | ||||
222134 | 222134 | 2022-05-09 | Niger | 8986 | 309 | 0 | 17.607789 | 8.081666 | 2022-05-10 04:20:50 | Niger | ||||
222135 | 222135 | 2022-05-09 | Nigeria | 255766 | 3143 | 0 | 9.082 | 8.6753 | 2022-05-10 04:20:50 | Nigeria | ||||
222136 | 222136 | 2022-05-09 | North Macedonia | 310298 | 9287 | 0 | 41.6086 | 21.7453 | 2022-05-10 04:20:50 | North Macedonia | ||||
222137 | 222137 | 2022-05-09 | Norway | 1428335 | 3006 | 0 | 60.472 | 8.4689 | 2022-05-10 04:20:50 | Norway | ||||
222138 | 222138 | 2022-05-09 | Oman | 389306 | 4259 | 0 | 21.512583 | 55.923255 | 2022-05-10 04:20:50 | Oman | ||||
222139 | 222139 | 2022-05-09 | Pakistan | Azad Jammu and Kashmir | 43314 | 792 | 0 | 34.027401 | 73.947253 | 2022-05-10 04:20:50 | Azad Jammu and Kashmir, Pakistan | |||
222140 | 222140 | 2022-05-09 | Pakistan | Balochistan | 35486 | 378 | 0 | 28.328492 | 65.898403 | 2022-05-10 04:20:50 | Balochistan, Pakistan | |||
222141 | 222141 | 2022-05-09 | Pakistan | Gilgit-Baltistan | 11745 | 191 | 0 | 35.792146 | 74.982138 | 2022-05-10 04:20:50 | Gilgit-Baltistan, Pakistan | |||
222142 | 222142 | 2022-05-09 | Pakistan | Islamabad | 135246 | 1024 | 0 | 33.665087 | 73.121219 | 2022-05-10 04:20:50 | Islamabad, Pakistan | |||
222143 | 222143 | 2022-05-09 | Pakistan | Khyber Pakhtunkhwa | 219554 | 6324 | 0 | 34.485332 | 72.09169 | 2022-05-10 04:20:50 | Khyber Pakhtunkhwa, Pakistan | |||
222144 | 222144 | 2022-05-09 | Pakistan | Punjab | 506499 | 13562 | 0 | 30.811346 | 72.139132 | 2022-05-10 04:20:50 | Punjab, Pakistan | |||
222145 | 222145 | 2022-05-09 | Pakistan | Sindh | 576989 | 8104 | 0 | 26.009446 | 68.776807 | 2022-05-10 04:20:50 | Sindh, Pakistan | |||
222146 | 222146 | 2022-05-09 | Palau | 4732 | 6 | 0 | 7.515 | 134.5825 | 2022-05-10 04:20:50 | Palau | ||||
222147 | 222147 | 2022-05-09 | Panama | 789830 | 8194 | 0 | 8.538 | -80.7821 | 2022-05-10 04:20:50 | Panama | ||||
222148 | 222148 | 2022-05-09 | Papua New Guinea | 43827 | 651 | 0 | -6.314993 | 143.95555 | 2022-05-10 04:20:50 | Papua New Guinea | ||||
222149 | 222149 | 2022-05-09 | Paraguay | 649718 | 18872 | 0 | -23.4425 | -58.4438 | 2022-05-10 04:20:50 | Paraguay | ||||
222150 | 222150 | 2022-05-09 | Peru | Amazonas | 44213 | 1340 | 0 | -5.077253 | -78.050172 | 2022-05-10 04:20:50 | Amazonas, Peru | |||
222151 | 222151 | 2022-05-09 | Peru | Ancash | 128016 | 7153 | 0 | -9.407125 | -77.671795 | 2022-05-10 04:20:50 | Ancash, Peru | |||
222152 | 222152 | 2022-05-09 | Peru | Apurimac | 39083 | 1634 | 0 | -14.027713 | -72.975378 | 2022-05-10 04:20:50 | Apurimac, Peru | |||
222153 | 222153 | 2022-05-09 | Peru | Arequipa | 215268 | 10321 | 0 | -15.843524 | -72.475539 | 2022-05-10 04:20:50 | Arequipa, Peru | |||
222154 | 222154 | 2022-05-09 | Peru | Ayacucho | 48227 | 2329 | 0 | -14.091648 | -74.08344 | 2022-05-10 04:20:50 | Ayacucho, Peru | |||
222155 | 222155 | 2022-05-09 | Peru | Cajamarca | 96206 | 4463 | 0 | -6.430284 | -78.745596 | 2022-05-10 04:20:50 | Cajamarca, Peru | |||
222156 | 222156 | 2022-05-09 | Peru | Callao | 146939 | 10506 | 0 | -11.954609 | -77.136042 | 2022-05-10 04:20:50 | Callao, Peru | |||
222157 | 222157 | 2022-05-09 | Peru | Cusco | 117054 | 5176 | 0 | -13.191068 | -72.153609 | 2022-05-10 04:20:50 | Cusco, Peru | |||
222158 | 222158 | 2022-05-09 | Peru | Huancavelica | 25861 | 1273 | 0 | -13.023888 | -75.00277 | 2022-05-10 04:20:50 | Huancavelica, Peru | |||
222159 | 222159 | 2022-05-09 | Peru | Huanuco | 52180 | 2892 | 0 | -9.421676 | -76.040642 | 2022-05-10 04:20:50 | Huanuco, Peru | |||
222160 | 222160 | 2022-05-09 | Peru | Ica | 103838 | 8935 | 0 | -14.235097 | -75.574821 | 2022-05-10 04:20:50 | Ica, Peru | |||
222161 | 222161 | 2022-05-09 | Peru | Junin | 126383 | 7482 | 0 | -11.541783 | -74.876968 | 2022-05-10 04:20:50 | Junin, Peru | |||
222162 | 222162 | 2022-05-09 | Peru | La Libertad | 146874 | 10956 | 0 | -7.92139 | -78.370238 | 2022-05-10 04:20:50 | La Libertad, Peru | |||
222163 | 222163 | 2022-05-09 | Peru | Lambayeque | 105683 | 9240 | 0 | -6.353049 | -79.824113 | 2022-05-10 04:20:50 | Lambayeque, Peru | |||
222164 | 222164 | 2022-05-09 | Peru | Lima | 1617674 | 93149 | 0 | -11.766533 | -76.604498 | 2022-05-10 04:20:50 | Lima, Peru | |||
222165 | 222165 | 2022-05-09 | Peru | Loreto | 57977 | 4386 | 0 | -4.124847 | -74.424115 | 2022-05-10 04:20:50 | Loreto, Peru | |||
222166 | 222166 | 2022-05-09 | Peru | Madre de Dios | 17864 | 854 | 0 | -11.972699 | -70.53172 | 2022-05-10 04:20:50 | Madre de Dios, Peru | |||
222167 | 222167 | 2022-05-09 | Peru | Moquegua | 48795 | 1625 | 0 | -16.860271 | -70.839046 | 2022-05-10 04:20:50 | Moquegua, Peru | |||
222168 | 222168 | 2022-05-09 | Peru | Pasco | 24007 | 1105 | 0 | -10.39655 | -75.307635 | 2022-05-10 04:20:50 | Pasco, Peru | |||
222169 | 222169 | 2022-05-09 | Peru | Piura | 158653 | 13100 | 0 | -5.133361 | -80.335861 | 2022-05-10 04:20:50 | Piura, Peru | |||
222170 | 222170 | 2022-05-09 | Peru | Puno | 66161 | 4787 | 0 | -14.995827 | -69.922726 | 2022-05-10 04:20:50 | Puno, Peru | |||
222171 | 222171 | 2022-05-09 | Peru | San Martin | 61864 | 3163 | 0 | -7.039531 | -76.729127 | 2022-05-10 04:20:50 | San Martin, Peru | |||
222172 | 222172 | 2022-05-09 | Peru | Tacna | 53785 | 2137 | 0 | -17.644161 | -70.27756 | 2022-05-10 04:20:50 | Tacna, 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]);