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

15,566 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 · 15,566

country_or_region

  • US 15,566
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391136 2021-01-26 US Puerto Rico Adjuntas 72001 364 0 0 364 18.180117000000006 -66.754367 2021-01-27 05:23:41 Adjuntas, Puerto Rico, US
391137 2021-01-26 US Puerto Rico Aguada 72003 868 0 0 868 18.360255 -67.17513100000001 2021-01-27 05:23:41 Aguada, Puerto Rico, US
391138 2021-01-26 US Puerto Rico Aguadilla 72005 1021 0 0 1021 18.459681 -67.12081500000001 2021-01-27 05:23:41 Aguadilla, Puerto Rico, US
391139 2021-01-26 US Puerto Rico Aguas Buenas 72007 762 0 0 762 18.251619 -66.126806 2021-01-27 05:23:41 Aguas Buenas, Puerto Rico, US
391140 2021-01-26 US Puerto Rico Aibonito 72009 389 0 0 389 18.131361 -66.264131 2021-01-27 05:23:41 Aibonito, Puerto Rico, US
391141 2021-01-26 US Puerto Rico Anasco 72011 559 0 0 559 18.287985 -67.120611 2021-01-27 05:23:41 Anasco, Puerto Rico, US
391142 2021-01-26 US Puerto Rico Arecibo 72013 2097 0 0 2097 18.406631 -66.675077 2021-01-27 05:23:41 Arecibo, Puerto Rico, US
391143 2021-01-26 US Puerto Rico Arroyo 72015 183 0 0 183 17.998457000000005 -66.056546 2021-01-27 05:23:41 Arroyo, Puerto Rico, US
391144 2021-01-26 US Puerto Rico Barceloneta 72017 511 0 0 511 18.445533 -66.56053100000001 2021-01-27 05:23:41 Barceloneta, Puerto Rico, US
391145 2021-01-26 US Puerto Rico Barranquitas 72019 741 0 0 741 18.201592 -66.30963 2021-01-27 05:23:41 Barranquitas, Puerto Rico, US
391146 2021-01-26 US Puerto Rico Bayamon 72021 7177 0 0 7177 18.34946 -66.168435 2021-01-27 05:23:41 Bayamon, Puerto Rico, US
391147 2021-01-26 US Puerto Rico Cabo Rojo 72023 485 0 0 485 18.040993 -67.154391 2021-01-27 05:23:41 Cabo Rojo, Puerto Rico, US
391148 2021-01-26 US Puerto Rico Caguas 72025 4168 0 0 4168 18.211615 -66.050779 2021-01-27 05:23:41 Caguas, Puerto Rico, US
391149 2021-01-26 US Puerto Rico Camuy 72027 792 0 0 792 18.418578 -66.860206 2021-01-27 05:23:41 Camuy, Puerto Rico, US
391150 2021-01-26 US Puerto Rico Canovanas 72029 1235 0 0 1235 18.328802 -65.887612 2021-01-27 05:23:41 Canovanas, Puerto Rico, US
391151 2021-01-26 US Puerto Rico Carolina 72031 5841 0 0 5841 18.374986 -65.95683100000001 2021-01-27 05:23:41 Carolina, Puerto Rico, US
391152 2021-01-26 US Puerto Rico Catano 72033 854 0 0 854 18.437269 -66.14330600000001 2021-01-27 05:23:41 Catano, Puerto Rico, US
391153 2021-01-26 US Puerto Rico Cayey 72035 872 0 0 872 18.102851 -66.14914 2021-01-27 05:23:41 Cayey, Puerto Rico, US
391154 2021-01-26 US Puerto Rico Ceiba 72037 242 0 0 242 18.251818 -65.666416 2021-01-27 05:23:41 Ceiba, Puerto Rico, US
391155 2021-01-26 US Puerto Rico Ciales 72039 525 0 0 525 18.28885 -66.516475 2021-01-27 05:23:41 Ciales, Puerto Rico, US
391156 2021-01-26 US Puerto Rico Cidra 72041 920 0 0 920 18.173559 -66.161179 2021-01-27 05:23:41 Cidra, Puerto Rico, US
391157 2021-01-26 US Puerto Rico Coamo 72043 607 0 0 607 18.097597 -66.36014 2021-01-27 05:23:41 Coamo, Puerto Rico, US
391158 2021-01-26 US Puerto Rico Comerio 72045 501 0 0 501 18.224687 -66.221622 2021-01-27 05:23:41 Comerio, Puerto Rico, US
391159 2021-01-26 US Puerto Rico Corozal 72047 1040 0 0 1040 18.304264 -66.327738 2021-01-27 05:23:41 Corozal, Puerto Rico, US
391160 2021-01-26 US Puerto Rico Culebra 72049 23 0 0 23 18.31586 -65.28813000000001 2021-01-27 05:23:41 Culebra, Puerto Rico, US
391161 2021-01-26 US Puerto Rico Dorado 72051 1413 0 0 1413 18.436115 -66.278669 2021-01-27 05:23:41 Dorado, Puerto Rico, US
391162 2021-01-26 US Puerto Rico Fajardo 72053 752 0 0 752 18.318373 -65.666866 2021-01-27 05:23:41 Fajardo, Puerto Rico, US
391163 2021-01-26 US Puerto Rico Florida 72054 350 0 0 350 18.373715 -66.560488 2021-01-27 05:23:41 Florida, Puerto Rico, US
391164 2021-01-26 US Puerto Rico Guanica 72055 127 0 0 127 17.982429 -66.91964300000001 2021-01-27 05:23:41 Guanica, Puerto Rico, US
391165 2021-01-26 US Puerto Rico Guayama 72057 504 0 0 504 18.007516 -66.13390799999999 2021-01-27 05:23:41 Guayama, Puerto Rico, US
391166 2021-01-26 US Puerto Rico Guayanilla 72059 201 0 0 201 18.039942 -66.79186 2021-01-27 05:23:41 Guayanilla, Puerto Rico, US
391167 2021-01-26 US Puerto Rico Guaynabo 72061 3104 0 0 3104 18.345114 -66.11452299999999 2021-01-27 05:23:41 Guaynabo, Puerto Rico, US
391168 2021-01-26 US Puerto Rico Gurabo 72063 1305 0 0 1305 18.266461 -65.97970500000001 2021-01-27 05:23:41 Gurabo, Puerto Rico, US
391169 2021-01-26 US Puerto Rico Hatillo 72065 725 0 0 725 18.410928 -66.79632600000001 2021-01-27 05:23:41 Hatillo, Puerto Rico, US
391170 2021-01-26 US Puerto Rico Hormigueros 72067 272 0 0 272 18.134532 -67.113972 2021-01-27 05:23:41 Hormigueros, Puerto Rico, US
391171 2021-01-26 US Puerto Rico Humacao 72069 1078 0 0 1078 18.145211 -65.810174 2021-01-27 05:23:41 Humacao, Puerto Rico, US
391172 2021-01-26 US Puerto Rico Isabela 72071 883 0 0 883 18.44981 -67.005093 2021-01-27 05:23:41 Isabela, Puerto Rico, US
391173 2021-01-26 US Puerto Rico Jayuya 72073 157 0 0 157 18.211446 -66.58878 2021-01-27 05:23:41 Jayuya, Puerto Rico, US
391174 2021-01-26 US Puerto Rico Juana Diaz 72075 733 0 0 733 18.050764 -66.49458100000001 2021-01-27 05:23:41 Juana Diaz, Puerto Rico, US
391175 2021-01-26 US Puerto Rico Juncos 72077 1279 0 0 1279 18.223793 -65.909109 2021-01-27 05:23:41 Juncos, Puerto Rico, US
391176 2021-01-26 US Puerto Rico Lajas 72079 194 0 0 194 18.011661 -67.040585 2021-01-27 05:23:41 Lajas, Puerto Rico, US
391177 2021-01-26 US Puerto Rico Lares 72081 487 0 0 487 18.269035 -66.867236 2021-01-27 05:23:41 Lares, Puerto Rico, US
391178 2021-01-26 US Puerto Rico Las Marias 72083 120 0 0 120 18.23679 -66.98362 2021-01-27 05:23:41 Las Marias, Puerto Rico, US
391179 2021-01-26 US Puerto Rico Las Piedras 72085 945 0 0 945 18.187527 -65.86946800000001 2021-01-27 05:23:41 Las Piedras, Puerto Rico, US
391180 2021-01-26 US Puerto Rico Loiza 72087 729 0 0 729 18.425688 -65.89943000000001 2021-01-27 05:23:41 Loiza, Puerto Rico, US
391181 2021-01-26 US Puerto Rico Luquillo 72089 418 0 0 418 18.342114 -65.72509699999999 2021-01-27 05:23:41 Luquillo, Puerto Rico, US
391182 2021-01-26 US Puerto Rico Manati 72091 998 0 0 998 18.420473 -66.490461 2021-01-27 05:23:41 Manati, Puerto Rico, US
391183 2021-01-26 US Puerto Rico Maricao 72093 59 0 0 59 18.171795 -66.942126 2021-01-27 05:23:41 Maricao, Puerto Rico, US
391184 2021-01-26 US Puerto Rico Maunabo 72095 195 0 0 195 18.017889 -65.922235 2021-01-27 05:23:41 Maunabo, Puerto Rico, US
391185 2021-01-26 US Puerto Rico Mayaguez 72097 1219 0 0 1219 18.2013 -67.1452 2021-01-27 05:23:41 Mayaguez, Puerto Rico, US
391186 2021-01-26 US Puerto Rico Moca 72099 1006 0 0 1006 18.377805 -67.080952 2021-01-27 05:23:41 Moca, Puerto Rico, US
391187 2021-01-26 US Puerto Rico Morovis 72101 976 0 0 976 18.316963 -66.420383 2021-01-27 05:23:41 Morovis, Puerto Rico, US
391188 2021-01-26 US Puerto Rico Naguabo 72103 562 0 0 562 18.230637 -65.753897 2021-01-27 05:23:41 Naguabo, Puerto Rico, US
391189 2021-01-26 US Puerto Rico Naranjito 72105 1024 0 0 1024 18.288019 -66.252703 2021-01-27 05:23:41 Naranjito, Puerto Rico, US
391190 2021-01-26 US Puerto Rico Orocovis 72107 533 0 0 533 18.215046 -66.433604 2021-01-27 05:23:41 Orocovis, Puerto Rico, US
391191 2021-01-26 US Puerto Rico Out of PR 72888 219 0 0 219 18.459681 -67.336525 2021-01-27 05:23:41 Out of PR, Puerto Rico, US
391192 2021-01-26 US Puerto Rico Patillas 72109 200 0 0 200 18.03174 -66.012242 2021-01-27 05:23:41 Patillas, Puerto Rico, US
391193 2021-01-26 US Puerto Rico Penuelas 72111 363 0 0 363 18.059645 -66.721572 2021-01-27 05:23:41 Penuelas, Puerto Rico, US
391194 2021-01-26 US Puerto Rico Ponce 72113 2032 0 0 2032 18.059498 -66.613748 2021-01-27 05:23:41 Ponce, Puerto Rico, US
391195 2021-01-26 US Puerto Rico Quebradillas 72115 527 0 0 527 18.439692 -66.926113 2021-01-27 05:23:41 Quebradillas, Puerto Rico, US
391196 2021-01-26 US Puerto Rico Rincon 72117 279 0 0 279 18.335443 -67.23174 2021-01-27 05:23:41 Rincon, Puerto Rico, US
391197 2021-01-26 US Puerto Rico Rio Grande 72119 1256 0 0 1256 18.346329 -65.813742 2021-01-27 05:23:41 Rio Grande, Puerto Rico, US
391198 2021-01-26 US Puerto Rico Sabana Grande 72121 217 0 0 217 18.08282 -66.943758 2021-01-27 05:23:41 Sabana Grande, Puerto Rico, US
391199 2021-01-26 US Puerto Rico Salinas 72123 514 0 0 514 18.010386999999994 -66.256592 2021-01-27 05:23:41 Salinas, Puerto Rico, US
391200 2021-01-26 US Puerto Rico San German 72125 360 0 0 360 18.111484 -67.03858100000001 2021-01-27 05:23:41 San German, Puerto Rico, US
391201 2021-01-26 US Puerto Rico San Juan 72127 12857 0 0 12857 18.386933 -66.061128 2021-01-27 05:23:41 San Juan, Puerto Rico, US
391202 2021-01-26 US Puerto Rico San Lorenzo 72129 1076 0 0 1076 18.147987 -65.976392 2021-01-27 05:23:41 San Lorenzo, Puerto Rico, US
391203 2021-01-26 US Puerto Rico San Sebastian 72131 941 0 0 941 18.328646 -66.971214 2021-01-27 05:23:41 San Sebastian, Puerto Rico, US
391204 2021-01-26 US Puerto Rico Santa Isabel 72133 294 0 0 294 17.994525 -66.388913 2021-01-27 05:23:41 Santa Isabel, Puerto Rico, US
391205 2021-01-26 US Puerto Rico Toa Alta 72135 2630 0 0 2630 18.362406 -66.246616 2021-01-27 05:23:41 Toa Alta, Puerto Rico, US
391206 2021-01-26 US Puerto Rico Toa Baja 72137 2639 0 0 2639 18.431446 -66.213553 2021-01-27 05:23:41 Toa Baja, Puerto Rico, US
391207 2021-01-26 US Puerto Rico Trujillo Alto 72139 2047 0 0 2047 18.336159 -65.99888399999999 2021-01-27 05:23:41 Trujillo Alto, Puerto Rico, US
391208 2021-01-26 US Puerto Rico Unassigned 72999 2757 1783 0 974 18.459681 -67.336525 2021-01-27 05:23:41 Unassigned, Puerto Rico, US
391209 2021-01-26 US Puerto Rico Utuado 72141 636 0 0 636 18.271214 -66.702984 2021-01-27 05:23:41 Utuado, Puerto Rico, US
391210 2021-01-26 US Puerto Rico Vega Alta 72143 1219 0 0 1219 18.409346 -66.33725 2021-01-27 05:23:41 Vega Alta, Puerto Rico, US
391211 2021-01-26 US Puerto Rico Vega Baja 72145 2027 0 0 2027 18.428262 -66.397924 2021-01-27 05:23:41 Vega Baja, Puerto Rico, US
391212 2021-01-26 US Puerto Rico Vieques 72147 111 0 0 111 18.123276 -65.44097099999999 2021-01-27 05:23:41 Vieques, Puerto Rico, US
391213 2021-01-26 US Puerto Rico Villalba 72149 566 0 0 566 18.127951 -66.473115 2021-01-27 05:23:41 Villalba, Puerto Rico, US
391214 2021-01-26 US Puerto Rico Yabucoa 72151 639 0 0 639 18.070399 -65.896289 2021-01-27 05:23:41 Yabucoa, Puerto Rico, US
391215 2021-01-26 US Puerto Rico Yauco 72153 538 0 0 538 18.080374 -66.858814 2021-01-27 05:23:41 Yauco, Puerto Rico, US
21854 2021-01-25 US Puerto Rico Adjuntas 72001 361 0 0 361 18.180117000000006 -66.754367 2021-01-26 05:22:02 Adjuntas, Puerto Rico, US
21855 2021-01-25 US Puerto Rico Aguada 72003 861 0 0 861 18.360255 -67.17513100000001 2021-01-26 05:22:02 Aguada, Puerto Rico, US
21856 2021-01-25 US Puerto Rico Aguadilla 72005 1020 0 0 1020 18.459681 -67.12081500000001 2021-01-26 05:22:02 Aguadilla, Puerto Rico, US
21857 2021-01-25 US Puerto Rico Aguas Buenas 72007 758 0 0 758 18.251619 -66.126806 2021-01-26 05:22:02 Aguas Buenas, Puerto Rico, US
21858 2021-01-25 US Puerto Rico Aibonito 72009 381 0 0 381 18.131361 -66.264131 2021-01-26 05:22:02 Aibonito, Puerto Rico, US
21859 2021-01-25 US Puerto Rico Anasco 72011 559 0 0 559 18.287985 -67.120611 2021-01-26 05:22:02 Anasco, Puerto Rico, US
21860 2021-01-25 US Puerto Rico Arecibo 72013 2085 0 0 2085 18.406631 -66.675077 2021-01-26 05:22:02 Arecibo, Puerto Rico, US
21861 2021-01-25 US Puerto Rico Arroyo 72015 182 0 0 182 17.998457000000005 -66.056546 2021-01-26 05:22:02 Arroyo, Puerto Rico, US
21862 2021-01-25 US Puerto Rico Barceloneta 72017 507 0 0 507 18.445533 -66.56053100000001 2021-01-26 05:22:02 Barceloneta, Puerto Rico, US
21863 2021-01-25 US Puerto Rico Barranquitas 72019 735 0 0 735 18.201592 -66.30963 2021-01-26 05:22:02 Barranquitas, Puerto Rico, US
21864 2021-01-25 US Puerto Rico Bayamon 72021 7081 0 0 7081 18.34946 -66.168435 2021-01-26 05:22:02 Bayamon, Puerto Rico, US
21865 2021-01-25 US Puerto Rico Cabo Rojo 72023 484 0 0 484 18.040993 -67.154391 2021-01-26 05:22:02 Cabo Rojo, Puerto Rico, US
21866 2021-01-25 US Puerto Rico Caguas 72025 4150 0 0 4150 18.211615 -66.050779 2021-01-26 05:22:02 Caguas, Puerto Rico, US
21867 2021-01-25 US Puerto Rico Camuy 72027 789 0 0 789 18.418578 -66.860206 2021-01-26 05:22:02 Camuy, Puerto Rico, US
21868 2021-01-25 US Puerto Rico Canovanas 72029 1231 0 0 1231 18.328802 -65.887612 2021-01-26 05:22:02 Canovanas, Puerto Rico, US
21869 2021-01-25 US Puerto Rico Carolina 72031 5826 0 0 5826 18.374986 -65.95683100000001 2021-01-26 05:22:02 Carolina, Puerto Rico, US
21870 2021-01-25 US Puerto Rico Catano 72033 850 0 0 850 18.437269 -66.14330600000001 2021-01-26 05:22:02 Catano, Puerto Rico, US
21871 2021-01-25 US Puerto Rico Cayey 72035 872 0 0 872 18.102851 -66.14914 2021-01-26 05:22:02 Cayey, Puerto Rico, US
21872 2021-01-25 US Puerto Rico Ceiba 72037 241 0 0 241 18.251818 -65.666416 2021-01-26 05:22:02 Ceiba, Puerto Rico, US
21873 2021-01-25 US Puerto Rico Ciales 72039 522 0 0 522 18.28885 -66.516475 2021-01-26 05:22:02 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] 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]);