covid

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Custom SQL query returning 101 rows (hide)

Query parameters

rowiddaycountry_or_regionprovince_or_stateadmin2fipsconfirmeddeathsrecoveredactivelatitudelongitudelast_updatecombined_key
235203 2021-06-24 Spain Andalusia     612979 10026 10671 592282 37.5443 -4.7278 2021-06-25 04:21:33 Andalusia, Spain
235204 2021-06-24 Spain Aragon     126446 3544 3772 119130 41.5976 -0.9057 2021-06-25 04:21:33 Aragon, Spain
235205 2021-06-24 Spain Asturias     53646 1976 1063 50607 43.3614 -5.8593 2021-06-25 04:21:33 Asturias, Spain
235206 2021-06-24 Spain Baleares     61430 844 1533 59053 39.710358 2.995148 2021-06-25 04:21:33 Baleares, Spain
235207 2021-06-24 Spain C. Valenciana     398973 7410 9970 381593 39.484 -0.7533 2021-06-25 04:21:33 C. Valenciana, Spain
235208 2021-06-24 Spain Canarias     59883 787 1537 57559 28.2916 -16.6291 2021-06-25 04:21:33 Canarias, Spain
235209 2021-06-24 Spain Cantabria     31191 568 2287 28336 43.1828 -3.9878 2021-06-25 04:21:33 Cantabria, Spain
235210 2021-06-24 Spain Castilla - La Mancha     196166 6008 6392 183766 39.2796 -3.0977 2021-06-25 04:21:33 Castilla - La Mancha, Spain
235211 2021-06-24 Spain Castilla y Leon     234890 6918 8716 219256 41.8357 -4.3976 2021-06-25 04:21:33 Castilla y Leon, Spain
235212 2021-06-24 Spain Catalonia     638516 14731 26203 597582 41.5912 1.5209 2021-06-25 04:21:33 Catalonia, Spain
235213 2021-06-24 Spain Ceuta     5977 116 163 5698 35.8894 -5.3213 2021-06-25 04:21:33 Ceuta, Spain
235214 2021-06-24 Spain Extremadura     77018 1807 2652 72559 39.4937 -6.0679 2021-06-25 04:21:33 Extremadura, Spain
235215 2021-06-24 Spain Galicia     129039 2421 9204 117414 42.5751 -8.1339 2021-06-25 04:21:33 Galicia, Spain
235216 2021-06-24 Spain La Rioja     31810 777 3107 27926 42.2871 -2.5396 2021-06-25 04:21:33 La Rioja, Spain
235217 2021-06-24 Spain Madrid     728659 15419 40736 672504 40.4168 -3.7038 2021-06-25 04:21:33 Madrid, Spain
235218 2021-06-24 Spain Melilla     9238 97 125 9016 35.2923 -2.9381 2021-06-25 04:21:33 Melilla, Spain
235219 2021-06-24 Spain Murcia     114477 1606 2180 110691 37.9922 -1.1307 2021-06-25 04:21:33 Murcia, Spain
235220 2021-06-24 Spain Navarra     63680 1182 3905 58593 42.6954 -1.6761 2021-06-25 04:21:33 Navarra, Spain
235221 2021-06-24 Spain Pais Vasco     203521 4529 16160 182832 42.9896 -2.6189 2021-06-25 04:21:33 Pais Vasco, Spain
235222 2021-06-24 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
472151 2021-06-23 Spain Andalusia     611513 10025 10671 590817 37.5443 -4.7278 2021-06-24 04:21:55 Andalusia, Spain
472152 2021-06-23 Spain Aragon     126354 3543 3772 119039 41.5976 -0.9057 2021-06-24 04:21:55 Aragon, Spain
472153 2021-06-23 Spain Asturias     53585 1976 1063 50546 43.3614 -5.8593 2021-06-24 04:21:55 Asturias, Spain
472154 2021-06-23 Spain Baleares     61351 844 1533 58974 39.710358 2.995148 2021-06-24 04:21:55 Baleares, Spain
472155 2021-06-23 Spain C. Valenciana     398973 7410 9970 381593 39.484 -0.7533 2021-06-24 04:21:55 C. Valenciana, Spain
472156 2021-06-23 Spain Canarias     59670 787 1537 57346 28.2916 -16.6291 2021-06-24 04:21:55 Canarias, Spain
472157 2021-06-23 Spain Cantabria     31101 568 2287 28246 43.1828 -3.9878 2021-06-24 04:21:55 Cantabria, Spain
472158 2021-06-23 Spain Castilla - La Mancha     196050 6004 6392 183654 39.2796 -3.0977 2021-06-24 04:21:55 Castilla - La Mancha, Spain
472159 2021-06-23 Spain Castilla y Leon     234790 6917 8716 219157 41.8357 -4.3976 2021-06-24 04:21:55 Castilla y Leon, Spain
472160 2021-06-23 Spain Catalonia     637252 14729 26203 596320 41.5912 1.5209 2021-06-24 04:21:55 Catalonia, Spain
472161 2021-06-23 Spain Ceuta     5976 116 163 5697 35.8894 -5.3213 2021-06-24 04:21:55 Ceuta, Spain
472162 2021-06-23 Spain Extremadura     76966 1807 2652 72507 39.4937 -6.0679 2021-06-24 04:21:55 Extremadura, Spain
472163 2021-06-23 Spain Galicia     128920 2421 9204 117295 42.5751 -8.1339 2021-06-24 04:21:55 Galicia, Spain
472164 2021-06-23 Spain La Rioja     31778 776 3107 27895 42.2871 -2.5396 2021-06-24 04:21:55 La Rioja, Spain
472165 2021-06-23 Spain Madrid     728107 15412 40736 671959 40.4168 -3.7038 2021-06-24 04:21:55 Madrid, Spain
472166 2021-06-23 Spain Melilla     9236 97 125 9014 35.2923 -2.9381 2021-06-24 04:21:55 Melilla, Spain
472167 2021-06-23 Spain Murcia     114398 1606 2180 110612 37.9922 -1.1307 2021-06-24 04:21:55 Murcia, Spain
472168 2021-06-23 Spain Navarra     63643 1181 3905 58557 42.6954 -1.6761 2021-06-24 04:21:55 Navarra, Spain
472169 2021-06-23 Spain Pais Vasco     203369 4529 16160 182680 42.9896 -2.6189 2021-06-24 04:21:55 Pais Vasco, Spain
472170 2021-06-23 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
627209 2021-06-22 Spain Andalusia     610335 10019 10671 589645 37.5443 -4.7278 2021-06-23 04:21:46 Andalusia, Spain
627210 2021-06-22 Spain Aragon     126243 3539 3772 118932 41.5976 -0.9057 2021-06-23 04:21:46 Aragon, Spain
627211 2021-06-22 Spain Asturias     53516 1975 1063 50478 43.3614 -5.8593 2021-06-23 04:21:46 Asturias, Spain
627212 2021-06-22 Spain Baleares     61283 844 1533 58906 39.710358 2.995148 2021-06-23 04:21:46 Baleares, Spain
627213 2021-06-22 Spain C. Valenciana     398694 7407 9970 381317 39.484 -0.7533 2021-06-23 04:21:46 C. Valenciana, Spain
627214 2021-06-22 Spain Canarias     59484 786 1537 57161 28.2916 -16.6291 2021-06-23 04:21:46 Canarias, Spain
627215 2021-06-22 Spain Cantabria     31060 568 2287 28205 43.1828 -3.9878 2021-06-23 04:21:46 Cantabria, Spain
627216 2021-06-22 Spain Castilla - La Mancha     195942 6000 6392 183550 39.2796 -3.0977 2021-06-23 04:21:46 Castilla - La Mancha, Spain
627217 2021-06-22 Spain Castilla y Leon     234686 6917 8716 219053 41.8357 -4.3976 2021-06-23 04:21:46 Castilla y Leon, Spain
627218 2021-06-22 Spain Catalonia     636053 14728 26203 595122 41.5912 1.5209 2021-06-23 04:21:46 Catalonia, Spain
627219 2021-06-22 Spain Ceuta     5975 116 163 5696 35.8894 -5.3213 2021-06-23 04:21:46 Ceuta, Spain
627220 2021-06-22 Spain Extremadura     76916 1807 2652 72457 39.4937 -6.0679 2021-06-23 04:21:46 Extremadura, Spain
627221 2021-06-22 Spain Galicia     128834 2421 9204 117209 42.5751 -8.1339 2021-06-23 04:21:46 Galicia, Spain
627222 2021-06-22 Spain La Rioja     31752 775 3107 27870 42.2871 -2.5396 2021-06-23 04:21:46 La Rioja, Spain
627223 2021-06-22 Spain Madrid     727592 15409 40736 671447 40.4168 -3.7038 2021-06-23 04:21:46 Madrid, Spain
627224 2021-06-22 Spain Melilla     9232 97 125 9010 35.2923 -2.9381 2021-06-23 04:21:46 Melilla, Spain
627225 2021-06-22 Spain Murcia     114310 1606 2180 110524 37.9922 -1.1307 2021-06-23 04:21:46 Murcia, Spain
627226 2021-06-22 Spain Navarra     63585 1180 3905 58500 42.6954 -1.6761 2021-06-23 04:21:46 Navarra, Spain
627227 2021-06-22 Spain Pais Vasco     203199 4525 16160 182514 42.9896 -2.6189 2021-06-23 04:21:46 Pais Vasco, Spain
627228 2021-06-22 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
227229 2021-06-21 Spain Andalusia     609412 10016 10671 588725 37.5443 -4.7278 2021-06-22 04:21:34 Andalusia, Spain
227230 2021-06-21 Spain Aragon     126177 3537 3772 118868 41.5976 -0.9057 2021-06-22 04:21:34 Aragon, Spain
227231 2021-06-21 Spain Asturias     53474 1975 1063 50436 43.3614 -5.8593 2021-06-22 04:21:34 Asturias, Spain
227232 2021-06-21 Spain Baleares     61224 843 1533 58848 39.710358 2.995148 2021-06-22 04:21:34 Baleares, Spain
227233 2021-06-21 Spain C. Valenciana     398362 7408 9970 380984 39.484 -0.7533 2021-06-22 04:21:34 C. Valenciana, Spain
227234 2021-06-21 Spain Canarias     59309 786 1537 56986 28.2916 -16.6291 2021-06-22 04:21:34 Canarias, Spain
227235 2021-06-21 Spain Cantabria     31007 568 2287 28152 43.1828 -3.9878 2021-06-22 04:21:34 Cantabria, Spain
227236 2021-06-21 Spain Castilla - La Mancha     195755 5997 6392 183366 39.2796 -3.0977 2021-06-22 04:21:34 Castilla - La Mancha, Spain
227237 2021-06-21 Spain Castilla y Leon     234561 6915 8716 218930 41.8357 -4.3976 2021-06-22 04:21:34 Castilla y Leon, Spain
227238 2021-06-21 Spain Catalonia     634903 14714 26203 593986 41.5912 1.5209 2021-06-22 04:21:34 Catalonia, Spain
227239 2021-06-21 Spain Ceuta     5973 116 163 5694 35.8894 -5.3213 2021-06-22 04:21:34 Ceuta, Spain
227240 2021-06-21 Spain Extremadura     76861 1807 2652 72402 39.4937 -6.0679 2021-06-22 04:21:34 Extremadura, Spain
227241 2021-06-21 Spain Galicia     128734 2421 9204 117109 42.5751 -8.1339 2021-06-22 04:21:34 Galicia, Spain
227242 2021-06-21 Spain La Rioja     31735 775 3107 27853 42.2871 -2.5396 2021-06-22 04:21:34 La Rioja, Spain
227243 2021-06-21 Spain Madrid     727091 15408 40736 670947 40.4168 -3.7038 2021-06-22 04:21:34 Madrid, Spain
227244 2021-06-21 Spain Melilla     9229 97 125 9007 35.2923 -2.9381 2021-06-22 04:21:34 Melilla, Spain
227245 2021-06-21 Spain Murcia     114245 1606 2180 110459 37.9922 -1.1307 2021-06-22 04:21:34 Murcia, Spain
227246 2021-06-21 Spain Navarra     63545 1180 3905 58460 42.6954 -1.6761 2021-06-22 04:21:34 Navarra, Spain
227247 2021-06-21 Spain Pais Vasco     203054 4520 16160 182374 42.9896 -2.6189 2021-06-22 04:21:34 Pais Vasco, Spain
227248 2021-06-21 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1472751 2021-06-20 Spain Andalusia     606879 10009 10671 586199 37.5443 -4.7278 2021-06-21 04:21:41 Andalusia, Spain
1472752 2021-06-20 Spain Aragon     125999 3538 3772 118689 41.5976 -0.9057 2021-06-21 04:21:41 Aragon, Spain
1472753 2021-06-20 Spain Asturias     53324 1974 1063 50287 43.3614 -5.8593 2021-06-21 04:21:41 Asturias, Spain
1472754 2021-06-20 Spain Baleares     61120 843 1533 58744 39.710358 2.995148 2021-06-21 04:21:41 Baleares, Spain
1472755 2021-06-20 Spain C. Valenciana     397911 7407 9970 380534 39.484 -0.7533 2021-06-21 04:21:41 C. Valenciana, Spain
1472756 2021-06-20 Spain Canarias     58829 784 1537 56508 28.2916 -16.6291 2021-06-21 04:21:41 Canarias, Spain
1472757 2021-06-20 Spain Cantabria     30796 567 2287 27942 43.1828 -3.9878 2021-06-21 04:21:41 Cantabria, Spain
1472758 2021-06-20 Spain Castilla - La Mancha     195595 5992 6392 183211 39.2796 -3.0977 2021-06-21 04:21:41 Castilla - La Mancha, Spain
1472759 2021-06-20 Spain Castilla y Leon     234291 6913 8716 218662 41.8357 -4.3976 2021-06-21 04:21:41 Castilla y Leon, Spain
1472760 2021-06-20 Spain Catalonia     634247 14714 26203 593330 41.5912 1.5209 2021-06-21 04:21:41 Catalonia, Spain
1472761 2021-06-20 Spain Ceuta     5973 116 163 5694 35.8894 -5.3213 2021-06-21 04:21:41 Ceuta, Spain
1472762 2021-06-20 Spain Extremadura     76755 1805 2652 72298 39.4937 -6.0679 2021-06-21 04:21:41 Extremadura, Spain
1472763 2021-06-20 Spain Galicia     128511 2418 9204 116889 42.5751 -8.1339 2021-06-21 04:21:41 Galicia, Spain
1472764 2021-06-20 Spain La Rioja     31645 775 3107 27763 42.2871 -2.5396 2021-06-21 04:21:41 La Rioja, Spain
1472765 2021-06-20 Spain Madrid     726171 15402 40736 670033 40.4168 -3.7038 2021-06-21 04:21:41 Madrid, Spain
1472766 2021-06-20 Spain Melilla     9222 97 125 9000 35.2923 -2.9381 2021-06-21 04:21:41 Melilla, Spain
1472767 2021-06-20 Spain Murcia     114090 1604 2180 110306 37.9922 -1.1307 2021-06-21 04:21:41 Murcia, Spain
1472768 2021-06-20 Spain Navarra     63423 1179 3905 58339 42.6954 -1.6761 2021-06-21 04:21:41 Navarra, Spain
1472769 2021-06-20 Spain Pais Vasco     202661 4515 16160 181986 42.9896 -2.6189 2021-06-21 04:21:41 Pais Vasco, Spain
1472770 2021-06-20 Spain Unknown     0 0 0 0     2021-04-25 23:20:49 Unknown, Spain
1303992 2021-06-19 Spain Andalusia     606879 10009 10671 586199 37.5443 -4.7278 2021-06-20 04:21:48 Andalusia, Spain