⚠️ 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.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

18,606 rows where province_or_state = "Puerto Rico" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Puerto Rico · 18,606

country_or_region

  • US 18,606
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
956026 2021-03-05 US Puerto Rico Adjuntas 72001 377 0 0 377 18.180117000000006 -66.754367 2021-03-06 04:23:41 Adjuntas, Puerto Rico, US
956027 2021-03-05 US Puerto Rico Aguada 72003 990 0 0 990 18.360255 -67.17513100000001 2021-03-06 04:23:41 Aguada, Puerto Rico, US
956028 2021-03-05 US Puerto Rico Aguadilla 72005 1146 0 0 1146 18.459681 -67.12081500000001 2021-03-06 04:23:41 Aguadilla, Puerto Rico, US
956029 2021-03-05 US Puerto Rico Aguas Buenas 72007 849 0 0 849 18.251619 -66.126806 2021-03-06 04:23:41 Aguas Buenas, Puerto Rico, US
956030 2021-03-05 US Puerto Rico Aibonito 72009 441 0 0 441 18.131361 -66.264131 2021-03-06 04:23:41 Aibonito, Puerto Rico, US
956031 2021-03-05 US Puerto Rico Anasco 72011 629 0 0 629 18.287985 -67.120611 2021-03-06 04:23:41 Anasco, Puerto Rico, US
956032 2021-03-05 US Puerto Rico Arecibo 72013 2331 0 0 2331 18.406631 -66.675077 2021-03-06 04:23:41 Arecibo, Puerto Rico, US
956033 2021-03-05 US Puerto Rico Arroyo 72015 197 0 0 197 17.998457000000005 -66.056546 2021-03-06 04:23:41 Arroyo, Puerto Rico, US
956034 2021-03-05 US Puerto Rico Barceloneta 72017 563 0 0 563 18.445533 -66.56053100000001 2021-03-06 04:23:41 Barceloneta, Puerto Rico, US
956035 2021-03-05 US Puerto Rico Barranquitas 72019 839 0 0 839 18.201592 -66.30963 2021-03-06 04:23:41 Barranquitas, Puerto Rico, US
956036 2021-03-05 US Puerto Rico Bayamon 72021 7834 0 0 7834 18.34946 -66.168435 2021-03-06 04:23:41 Bayamon, Puerto Rico, US
956037 2021-03-05 US Puerto Rico Cabo Rojo 72023 562 0 0 562 18.040993 -67.154391 2021-03-06 04:23:41 Cabo Rojo, Puerto Rico, US
956038 2021-03-05 US Puerto Rico Caguas 72025 4609 0 0 4609 18.211615 -66.050779 2021-03-06 04:23:41 Caguas, Puerto Rico, US
956039 2021-03-05 US Puerto Rico Camuy 72027 907 0 0 907 18.418578 -66.860206 2021-03-06 04:23:41 Camuy, Puerto Rico, US
956040 2021-03-05 US Puerto Rico Canovanas 72029 1317 0 0 1317 18.328802 -65.887612 2021-03-06 04:23:41 Canovanas, Puerto Rico, US
956041 2021-03-05 US Puerto Rico Carolina 72031 6279 0 0 6279 18.374986 -65.95683100000001 2021-03-06 04:23:41 Carolina, Puerto Rico, US
956042 2021-03-05 US Puerto Rico Catano 72033 911 0 0 911 18.437269 -66.14330600000001 2021-03-06 04:23:41 Catano, Puerto Rico, US
956043 2021-03-05 US Puerto Rico Cayey 72035 952 0 0 952 18.102851 -66.14914 2021-03-06 04:23:41 Cayey, Puerto Rico, US
956044 2021-03-05 US Puerto Rico Ceiba 72037 272 0 0 272 18.251818 -65.666416 2021-03-06 04:23:41 Ceiba, Puerto Rico, US
956045 2021-03-05 US Puerto Rico Ciales 72039 583 0 0 583 18.28885 -66.516475 2021-03-06 04:23:41 Ciales, Puerto Rico, US
956046 2021-03-05 US Puerto Rico Cidra 72041 1000 0 0 1000 18.173559 -66.161179 2021-03-06 04:23:41 Cidra, Puerto Rico, US
956047 2021-03-05 US Puerto Rico Coamo 72043 655 0 0 655 18.097597 -66.36014 2021-03-06 04:23:41 Coamo, Puerto Rico, US
956048 2021-03-05 US Puerto Rico Comerio 72045 517 0 0 517 18.224687 -66.221622 2021-03-06 04:23:41 Comerio, Puerto Rico, US
956049 2021-03-05 US Puerto Rico Corozal 72047 1097 0 0 1097 18.304264 -66.327738 2021-03-06 04:23:41 Corozal, Puerto Rico, US
956050 2021-03-05 US Puerto Rico Culebra 72049 23 0 0 23 18.31586 -65.28813000000001 2021-03-06 04:23:41 Culebra, Puerto Rico, US
956051 2021-03-05 US Puerto Rico Dorado 72051 1519 0 0 1519 18.436115 -66.278669 2021-03-06 04:23:41 Dorado, Puerto Rico, US
956052 2021-03-05 US Puerto Rico Fajardo 72053 824 0 0 824 18.318373 -65.666866 2021-03-06 04:23:41 Fajardo, Puerto Rico, US
956053 2021-03-05 US Puerto Rico Florida 72054 371 0 0 371 18.373715 -66.560488 2021-03-06 04:23:41 Florida, Puerto Rico, US
956054 2021-03-05 US Puerto Rico Guanica 72055 143 0 0 143 17.982429 -66.91964300000001 2021-03-06 04:23:41 Guanica, Puerto Rico, US
956055 2021-03-05 US Puerto Rico Guayama 72057 565 0 0 565 18.007516 -66.13390799999999 2021-03-06 04:23:41 Guayama, Puerto Rico, US
956056 2021-03-05 US Puerto Rico Guayanilla 72059 238 0 0 238 18.039942 -66.79186 2021-03-06 04:23:41 Guayanilla, Puerto Rico, US
956057 2021-03-05 US Puerto Rico Guaynabo 72061 3350 0 0 3350 18.345114 -66.11452299999999 2021-03-06 04:23:41 Guaynabo, Puerto Rico, US
956058 2021-03-05 US Puerto Rico Gurabo 72063 1522 0 0 1522 18.266461 -65.97970500000001 2021-03-06 04:23:41 Gurabo, Puerto Rico, US
956059 2021-03-05 US Puerto Rico Hatillo 72065 847 0 0 847 18.410928 -66.79632600000001 2021-03-06 04:23:41 Hatillo, Puerto Rico, US
956060 2021-03-05 US Puerto Rico Hormigueros 72067 303 0 0 303 18.134532 -67.113972 2021-03-06 04:23:41 Hormigueros, Puerto Rico, US
956061 2021-03-05 US Puerto Rico Humacao 72069 1221 0 0 1221 18.145211 -65.810174 2021-03-06 04:23:41 Humacao, Puerto Rico, US
956062 2021-03-05 US Puerto Rico Isabela 72071 991 0 0 991 18.44981 -67.005093 2021-03-06 04:23:41 Isabela, Puerto Rico, US
956063 2021-03-05 US Puerto Rico Jayuya 72073 186 0 0 186 18.211446 -66.58878 2021-03-06 04:23:41 Jayuya, Puerto Rico, US
956064 2021-03-05 US Puerto Rico Juana Diaz 72075 826 0 0 826 18.050764 -66.49458100000001 2021-03-06 04:23:41 Juana Diaz, Puerto Rico, US
956065 2021-03-05 US Puerto Rico Juncos 72077 1465 0 0 1465 18.223793 -65.909109 2021-03-06 04:23:41 Juncos, Puerto Rico, US
956066 2021-03-05 US Puerto Rico Lajas 72079 252 0 0 252 18.011661 -67.040585 2021-03-06 04:23:41 Lajas, Puerto Rico, US
956067 2021-03-05 US Puerto Rico Lares 72081 537 0 0 537 18.269035 -66.867236 2021-03-06 04:23:41 Lares, Puerto Rico, US
956068 2021-03-05 US Puerto Rico Las Marias 72083 133 0 0 133 18.23679 -66.98362 2021-03-06 04:23:41 Las Marias, Puerto Rico, US
956069 2021-03-05 US Puerto Rico Las Piedras 72085 1100 0 0 1100 18.187527 -65.86946800000001 2021-03-06 04:23:41 Las Piedras, Puerto Rico, US
956070 2021-03-05 US Puerto Rico Loiza 72087 817 0 0 817 18.425688 -65.89943000000001 2021-03-06 04:23:41 Loiza, Puerto Rico, US
956071 2021-03-05 US Puerto Rico Luquillo 72089 490 0 0 490 18.342114 -65.72509699999999 2021-03-06 04:23:41 Luquillo, Puerto Rico, US
956072 2021-03-05 US Puerto Rico Manati 72091 1063 0 0 1063 18.420473 -66.490461 2021-03-06 04:23:41 Manati, Puerto Rico, US
956073 2021-03-05 US Puerto Rico Maricao 72093 70 0 0 70 18.171795 -66.942126 2021-03-06 04:23:41 Maricao, Puerto Rico, US
956074 2021-03-05 US Puerto Rico Maunabo 72095 205 0 0 205 18.017889 -65.922235 2021-03-06 04:23:41 Maunabo, Puerto Rico, US
956075 2021-03-05 US Puerto Rico Mayaguez 72097 1415 0 0 1415 18.2013 -67.1452 2021-03-06 04:23:41 Mayaguez, Puerto Rico, US
956076 2021-03-05 US Puerto Rico Moca 72099 1084 0 0 1084 18.377805 -67.080952 2021-03-06 04:23:41 Moca, Puerto Rico, US
956077 2021-03-05 US Puerto Rico Morovis 72101 1064 0 0 1064 18.316963 -66.420383 2021-03-06 04:23:41 Morovis, Puerto Rico, US
956078 2021-03-05 US Puerto Rico Naguabo 72103 651 0 0 651 18.230637 -65.753897 2021-03-06 04:23:41 Naguabo, Puerto Rico, US
956079 2021-03-05 US Puerto Rico Naranjito 72105 1106 0 0 1106 18.288019 -66.252703 2021-03-06 04:23:41 Naranjito, Puerto Rico, US
956080 2021-03-05 US Puerto Rico Orocovis 72107 610 0 0 610 18.215046 -66.433604 2021-03-06 04:23:41 Orocovis, Puerto Rico, US
956081 2021-03-05 US Puerto Rico Out of PR 72888 238 0 0 238 18.459681 -67.336525 2021-03-06 04:23:41 Out of PR, Puerto Rico, US
956082 2021-03-05 US Puerto Rico Patillas 72109 227 0 0 227 18.03174 -66.012242 2021-03-06 04:23:41 Patillas, Puerto Rico, US
956083 2021-03-05 US Puerto Rico Penuelas 72111 439 0 0 439 18.059645 -66.721572 2021-03-06 04:23:41 Penuelas, Puerto Rico, US
956084 2021-03-05 US Puerto Rico Ponce 72113 2401 0 0 2401 18.059498 -66.613748 2021-03-06 04:23:41 Ponce, Puerto Rico, US
956085 2021-03-05 US Puerto Rico Quebradillas 72115 597 0 0 597 18.439692 -66.926113 2021-03-06 04:23:41 Quebradillas, Puerto Rico, US
956086 2021-03-05 US Puerto Rico Rincon 72117 323 0 0 323 18.335443 -67.23174 2021-03-06 04:23:41 Rincon, Puerto Rico, US
956087 2021-03-05 US Puerto Rico Rio Grande 72119 1383 0 0 1383 18.346329 -65.813742 2021-03-06 04:23:41 Rio Grande, Puerto Rico, US
956088 2021-03-05 US Puerto Rico Sabana Grande 72121 257 0 0 257 18.08282 -66.943758 2021-03-06 04:23:41 Sabana Grande, Puerto Rico, US
956089 2021-03-05 US Puerto Rico Salinas 72123 554 0 0 554 18.010386999999994 -66.256592 2021-03-06 04:23:41 Salinas, Puerto Rico, US
956090 2021-03-05 US Puerto Rico San German 72125 404 0 0 404 18.111484 -67.03858100000001 2021-03-06 04:23:41 San German, Puerto Rico, US
956091 2021-03-05 US Puerto Rico San Juan 72127 13742 0 0 13742 18.386933 -66.061128 2021-03-06 04:23:41 San Juan, Puerto Rico, US
956092 2021-03-05 US Puerto Rico San Lorenzo 72129 1179 0 0 1179 18.147987 -65.976392 2021-03-06 04:23:41 San Lorenzo, Puerto Rico, US
956093 2021-03-05 US Puerto Rico San Sebastian 72131 1013 0 0 1013 18.328646 -66.971214 2021-03-06 04:23:41 San Sebastian, Puerto Rico, US
956094 2021-03-05 US Puerto Rico Santa Isabel 72133 335 0 0 335 17.994525 -66.388913 2021-03-06 04:23:41 Santa Isabel, Puerto Rico, US
956095 2021-03-05 US Puerto Rico Toa Alta 72135 2887 0 0 2887 18.362406 -66.246616 2021-03-06 04:23:41 Toa Alta, Puerto Rico, US
956096 2021-03-05 US Puerto Rico Toa Baja 72137 2859 0 0 2859 18.431446 -66.213553 2021-03-06 04:23:41 Toa Baja, Puerto Rico, US
956097 2021-03-05 US Puerto Rico Trujillo Alto 72139 2222 0 0 2222 18.336159 -65.99888399999999 2021-03-06 04:23:41 Trujillo Alto, Puerto Rico, US
956098 2021-03-05 US Puerto Rico Unassigned 72999 2929 2056 0 873 18.459681 -67.336525 2021-03-06 04:23:41 Unassigned, Puerto Rico, US
956099 2021-03-05 US Puerto Rico Utuado 72141 675 0 0 675 18.271214 -66.702984 2021-03-06 04:23:41 Utuado, Puerto Rico, US
956100 2021-03-05 US Puerto Rico Vega Alta 72143 1308 0 0 1308 18.409346 -66.33725 2021-03-06 04:23:41 Vega Alta, Puerto Rico, US
956101 2021-03-05 US Puerto Rico Vega Baja 72145 2182 0 0 2182 18.428262 -66.397924 2021-03-06 04:23:41 Vega Baja, Puerto Rico, US
956102 2021-03-05 US Puerto Rico Vieques 72147 113 0 0 113 18.123276 -65.44097099999999 2021-03-06 04:23:41 Vieques, Puerto Rico, US
956103 2021-03-05 US Puerto Rico Villalba 72149 641 0 0 641 18.127951 -66.473115 2021-03-06 04:23:41 Villalba, Puerto Rico, US
956104 2021-03-05 US Puerto Rico Yabucoa 72151 732 0 0 732 18.070399 -65.896289 2021-03-06 04:23:41 Yabucoa, Puerto Rico, US
956105 2021-03-05 US Puerto Rico Yauco 72153 578 0 0 578 18.080374 -66.858814 2021-03-06 04:23:41 Yauco, Puerto Rico, US
903386 2021-03-04 US Puerto Rico Adjuntas 72001 377 0 0 377 18.180117000000006 -66.754367 2021-03-05 05:26:29 Adjuntas, Puerto Rico, US
903387 2021-03-04 US Puerto Rico Aguada 72003 987 0 0 987 18.360255 -67.17513100000001 2021-03-05 05:26:29 Aguada, Puerto Rico, US
903388 2021-03-04 US Puerto Rico Aguadilla 72005 1143 0 0 1143 18.459681 -67.12081500000001 2021-03-05 05:26:29 Aguadilla, Puerto Rico, US
903389 2021-03-04 US Puerto Rico Aguas Buenas 72007 849 0 0 849 18.251619 -66.126806 2021-03-05 05:26:29 Aguas Buenas, Puerto Rico, US
903390 2021-03-04 US Puerto Rico Aibonito 72009 441 0 0 441 18.131361 -66.264131 2021-03-05 05:26:29 Aibonito, Puerto Rico, US
903391 2021-03-04 US Puerto Rico Anasco 72011 629 0 0 629 18.287985 -67.120611 2021-03-05 05:26:29 Anasco, Puerto Rico, US
903392 2021-03-04 US Puerto Rico Arecibo 72013 2324 0 0 2324 18.406631 -66.675077 2021-03-05 05:26:29 Arecibo, Puerto Rico, US
903393 2021-03-04 US Puerto Rico Arroyo 72015 197 0 0 197 17.998457000000005 -66.056546 2021-03-05 05:26:29 Arroyo, Puerto Rico, US
903394 2021-03-04 US Puerto Rico Barceloneta 72017 563 0 0 563 18.445533 -66.56053100000001 2021-03-05 05:26:29 Barceloneta, Puerto Rico, US
903395 2021-03-04 US Puerto Rico Barranquitas 72019 837 0 0 837 18.201592 -66.30963 2021-03-05 05:26:29 Barranquitas, Puerto Rico, US
903396 2021-03-04 US Puerto Rico Bayamon 72021 7823 0 0 7823 18.34946 -66.168435 2021-03-05 05:26:29 Bayamon, Puerto Rico, US
903397 2021-03-04 US Puerto Rico Cabo Rojo 72023 560 0 0 560 18.040993 -67.154391 2021-03-05 05:26:29 Cabo Rojo, Puerto Rico, US
903398 2021-03-04 US Puerto Rico Caguas 72025 4608 0 0 4608 18.211615 -66.050779 2021-03-05 05:26:29 Caguas, Puerto Rico, US
903399 2021-03-04 US Puerto Rico Camuy 72027 906 0 0 906 18.418578 -66.860206 2021-03-05 05:26:29 Camuy, Puerto Rico, US
903400 2021-03-04 US Puerto Rico Canovanas 72029 1317 0 0 1317 18.328802 -65.887612 2021-03-05 05:26:29 Canovanas, Puerto Rico, US
903401 2021-03-04 US Puerto Rico Carolina 72031 6267 0 0 6267 18.374986 -65.95683100000001 2021-03-05 05:26:29 Carolina, Puerto Rico, US
903402 2021-03-04 US Puerto Rico Catano 72033 910 0 0 910 18.437269 -66.14330600000001 2021-03-05 05:26:29 Catano, Puerto Rico, US
903403 2021-03-04 US Puerto Rico Cayey 72035 949 0 0 949 18.102851 -66.14914 2021-03-05 05:26:29 Cayey, Puerto Rico, US
903404 2021-03-04 US Puerto Rico Ceiba 72037 269 0 0 269 18.251818 -65.666416 2021-03-05 05:26:29 Ceiba, Puerto Rico, US
903405 2021-03-04 US Puerto Rico Ciales 72039 583 0 0 583 18.28885 -66.516475 2021-03-05 05:26:29 Ciales, Puerto Rico, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);