daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

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

80 rows where last_update = "2021-01-31 05:22:42" and province_or_state = "Puerto Rico" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • Puerto Rico · 80 ✖

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-01-30 US Puerto Rico Adjuntas 72001 366 0 0 366 18.180117000000006 -66.754367 2021-01-31 05:22:42 Adjuntas, Puerto Rico, US
2021-01-30 US Puerto Rico Aguada 72003 878 0 0 878 18.360255 -67.17513100000001 2021-01-31 05:22:42 Aguada, Puerto Rico, US
2021-01-30 US Puerto Rico Aguadilla 72005 1027 0 0 1027 18.459681 -67.12081500000001 2021-01-31 05:22:42 Aguadilla, Puerto Rico, US
2021-01-30 US Puerto Rico Aguas Buenas 72007 771 0 0 771 18.251619 -66.126806 2021-01-31 05:22:42 Aguas Buenas, Puerto Rico, US
2021-01-30 US Puerto Rico Aibonito 72009 409 0 0 409 18.131361 -66.264131 2021-01-31 05:22:42 Aibonito, Puerto Rico, US
2021-01-30 US Puerto Rico Anasco 72011 565 0 0 565 18.287985 -67.120611 2021-01-31 05:22:42 Anasco, Puerto Rico, US
2021-01-30 US Puerto Rico Arecibo 72013 2119 0 0 2119 18.406631 -66.675077 2021-01-31 05:22:42 Arecibo, Puerto Rico, US
2021-01-30 US Puerto Rico Arroyo 72015 187 0 0 187 17.998457000000005 -66.056546 2021-01-31 05:22:42 Arroyo, Puerto Rico, US
2021-01-30 US Puerto Rico Barceloneta 72017 520 0 0 520 18.445533 -66.56053100000001 2021-01-31 05:22:42 Barceloneta, Puerto Rico, US
2021-01-30 US Puerto Rico Barranquitas 72019 755 0 0 755 18.201592 -66.30963 2021-01-31 05:22:42 Barranquitas, Puerto Rico, US
2021-01-30 US Puerto Rico Bayamon 72021 7261 0 0 7261 18.34946 -66.168435 2021-01-31 05:22:42 Bayamon, Puerto Rico, US
2021-01-30 US Puerto Rico Cabo Rojo 72023 499 0 0 499 18.040993 -67.154391 2021-01-31 05:22:42 Cabo Rojo, Puerto Rico, US
2021-01-30 US Puerto Rico Caguas 72025 4223 0 0 4223 18.211615 -66.050779 2021-01-31 05:22:42 Caguas, Puerto Rico, US
2021-01-30 US Puerto Rico Camuy 72027 807 0 0 807 18.418578 -66.860206 2021-01-31 05:22:42 Camuy, Puerto Rico, US
2021-01-30 US Puerto Rico Canovanas 72029 1255 0 0 1255 18.328802 -65.887612 2021-01-31 05:22:42 Canovanas, Puerto Rico, US
2021-01-30 US Puerto Rico Carolina 72031 5920 0 0 5920 18.374986 -65.95683100000001 2021-01-31 05:22:42 Carolina, Puerto Rico, US
2021-01-30 US Puerto Rico Catano 72033 863 0 0 863 18.437269 -66.14330600000001 2021-01-31 05:22:42 Catano, Puerto Rico, US
2021-01-30 US Puerto Rico Cayey 72035 885 0 0 885 18.102851 -66.14914 2021-01-31 05:22:42 Cayey, Puerto Rico, US
2021-01-30 US Puerto Rico Ceiba 72037 244 0 0 244 18.251818 -65.666416 2021-01-31 05:22:42 Ceiba, Puerto Rico, US
2021-01-30 US Puerto Rico Ciales 72039 541 0 0 541 18.28885 -66.516475 2021-01-31 05:22:42 Ciales, Puerto Rico, US
2021-01-30 US Puerto Rico Cidra 72041 936 0 0 936 18.173559 -66.161179 2021-01-31 05:22:42 Cidra, Puerto Rico, US
2021-01-30 US Puerto Rico Coamo 72043 617 0 0 617 18.097597 -66.36014 2021-01-31 05:22:42 Coamo, Puerto Rico, US
2021-01-30 US Puerto Rico Comerio 72045 503 0 0 503 18.224687 -66.221622 2021-01-31 05:22:42 Comerio, Puerto Rico, US
2021-01-30 US Puerto Rico Corozal 72047 1044 0 0 1044 18.304264 -66.327738 2021-01-31 05:22:42 Corozal, Puerto Rico, US
2021-01-30 US Puerto Rico Culebra 72049 23 0 0 23 18.31586 -65.28813000000001 2021-01-31 05:22:42 Culebra, Puerto Rico, US
2021-01-30 US Puerto Rico Dorado 72051 1435 0 0 1435 18.436115 -66.278669 2021-01-31 05:22:42 Dorado, Puerto Rico, US
2021-01-30 US Puerto Rico Fajardo 72053 760 0 0 760 18.318373 -65.666866 2021-01-31 05:22:42 Fajardo, Puerto Rico, US
2021-01-30 US Puerto Rico Florida 72054 355 0 0 355 18.373715 -66.560488 2021-01-31 05:22:42 Florida, Puerto Rico, US
2021-01-30 US Puerto Rico Guanica 72055 128 0 0 128 17.982429 -66.91964300000001 2021-01-31 05:22:42 Guanica, Puerto Rico, US
2021-01-30 US Puerto Rico Guayama 72057 510 0 0 510 18.007516 -66.13390799999999 2021-01-31 05:22:42 Guayama, Puerto Rico, US
2021-01-30 US Puerto Rico Guayanilla 72059 206 0 0 206 18.039942 -66.79186 2021-01-31 05:22:42 Guayanilla, Puerto Rico, US
2021-01-30 US Puerto Rico Guaynabo 72061 3148 0 0 3148 18.345114 -66.11452299999999 2021-01-31 05:22:42 Guaynabo, Puerto Rico, US
2021-01-30 US Puerto Rico Gurabo 72063 1319 0 0 1319 18.266461 -65.97970500000001 2021-01-31 05:22:42 Gurabo, Puerto Rico, US
2021-01-30 US Puerto Rico Hatillo 72065 734 0 0 734 18.410928 -66.79632600000001 2021-01-31 05:22:42 Hatillo, Puerto Rico, US
2021-01-30 US Puerto Rico Hormigueros 72067 277 0 0 277 18.134532 -67.113972 2021-01-31 05:22:42 Hormigueros, Puerto Rico, US
2021-01-30 US Puerto Rico Humacao 72069 1097 0 0 1097 18.145211 -65.810174 2021-01-31 05:22:42 Humacao, Puerto Rico, US
2021-01-30 US Puerto Rico Isabela 72071 903 0 0 903 18.44981 -67.005093 2021-01-31 05:22:42 Isabela, Puerto Rico, US
2021-01-30 US Puerto Rico Jayuya 72073 162 0 0 162 18.211446 -66.58878 2021-01-31 05:22:42 Jayuya, Puerto Rico, US
2021-01-30 US Puerto Rico Juana Diaz 72075 753 0 0 753 18.050764 -66.49458100000001 2021-01-31 05:22:42 Juana Diaz, Puerto Rico, US
2021-01-30 US Puerto Rico Juncos 72077 1294 0 0 1294 18.223793 -65.909109 2021-01-31 05:22:42 Juncos, Puerto Rico, US
2021-01-30 US Puerto Rico Lajas 72079 198 0 0 198 18.011661 -67.040585 2021-01-31 05:22:42 Lajas, Puerto Rico, US
2021-01-30 US Puerto Rico Lares 72081 494 0 0 494 18.269035 -66.867236 2021-01-31 05:22:42 Lares, Puerto Rico, US
2021-01-30 US Puerto Rico Las Marias 72083 123 0 0 123 18.23679 -66.98362 2021-01-31 05:22:42 Las Marias, Puerto Rico, US
2021-01-30 US Puerto Rico Las Piedras 72085 968 0 0 968 18.187527 -65.86946800000001 2021-01-31 05:22:42 Las Piedras, Puerto Rico, US
2021-01-30 US Puerto Rico Loiza 72087 745 0 0 745 18.425688 -65.89943000000001 2021-01-31 05:22:42 Loiza, Puerto Rico, US
2021-01-30 US Puerto Rico Luquillo 72089 441 0 0 441 18.342114 -65.72509699999999 2021-01-31 05:22:42 Luquillo, Puerto Rico, US
2021-01-30 US Puerto Rico Manati 72091 1013 0 0 1013 18.420473 -66.490461 2021-01-31 05:22:42 Manati, Puerto Rico, US
2021-01-30 US Puerto Rico Maricao 72093 61 0 0 61 18.171795 -66.942126 2021-01-31 05:22:42 Maricao, Puerto Rico, US
2021-01-30 US Puerto Rico Maunabo 72095 201 0 0 201 18.017889 -65.922235 2021-01-31 05:22:42 Maunabo, Puerto Rico, US
2021-01-30 US Puerto Rico Mayaguez 72097 1241 0 0 1241 18.2013 -67.1452 2021-01-31 05:22:42 Mayaguez, Puerto Rico, US
2021-01-30 US Puerto Rico Moca 72099 1031 0 0 1031 18.377805 -67.080952 2021-01-31 05:22:42 Moca, Puerto Rico, US
2021-01-30 US Puerto Rico Morovis 72101 999 0 0 999 18.316963 -66.420383 2021-01-31 05:22:42 Morovis, Puerto Rico, US
2021-01-30 US Puerto Rico Naguabo 72103 570 0 0 570 18.230637 -65.753897 2021-01-31 05:22:42 Naguabo, Puerto Rico, US
2021-01-30 US Puerto Rico Naranjito 72105 1033 0 0 1033 18.288019 -66.252703 2021-01-31 05:22:42 Naranjito, Puerto Rico, US
2021-01-30 US Puerto Rico Orocovis 72107 551 0 0 551 18.215046 -66.433604 2021-01-31 05:22:42 Orocovis, Puerto Rico, US
2021-01-30 US Puerto Rico Out of PR 72888 224 0 0 224 18.459681 -67.336525 2021-01-31 05:22:42 Out of PR, Puerto Rico, US
2021-01-30 US Puerto Rico Patillas 72109 201 0 0 201 18.03174 -66.012242 2021-01-31 05:22:42 Patillas, Puerto Rico, US
2021-01-30 US Puerto Rico Penuelas 72111 381 0 0 381 18.059645 -66.721572 2021-01-31 05:22:42 Penuelas, Puerto Rico, US
2021-01-30 US Puerto Rico Ponce 72113 2098 0 0 2098 18.059498 -66.613748 2021-01-31 05:22:42 Ponce, Puerto Rico, US
2021-01-30 US Puerto Rico Quebradillas 72115 546 0 0 546 18.439692 -66.926113 2021-01-31 05:22:42 Quebradillas, Puerto Rico, US
2021-01-30 US Puerto Rico Rincon 72117 284 0 0 284 18.335443 -67.23174 2021-01-31 05:22:42 Rincon, Puerto Rico, US
2021-01-30 US Puerto Rico Rio Grande 72119 1272 0 0 1272 18.346329 -65.813742 2021-01-31 05:22:42 Rio Grande, Puerto Rico, US
2021-01-30 US Puerto Rico Sabana Grande 72121 221 0 0 221 18.08282 -66.943758 2021-01-31 05:22:42 Sabana Grande, Puerto Rico, US
2021-01-30 US Puerto Rico Salinas 72123 521 0 0 521 18.010386999999994 -66.256592 2021-01-31 05:22:42 Salinas, Puerto Rico, US
2021-01-30 US Puerto Rico San German 72125 366 0 0 366 18.111484 -67.03858100000001 2021-01-31 05:22:42 San German, Puerto Rico, US
2021-01-30 US Puerto Rico San Juan 72127 12987 0 0 12987 18.386933 -66.061128 2021-01-31 05:22:42 San Juan, Puerto Rico, US
2021-01-30 US Puerto Rico San Lorenzo 72129 1085 0 0 1085 18.147987 -65.976392 2021-01-31 05:22:42 San Lorenzo, Puerto Rico, US
2021-01-30 US Puerto Rico San Sebastian 72131 958 0 0 958 18.328646 -66.971214 2021-01-31 05:22:42 San Sebastian, Puerto Rico, US
2021-01-30 US Puerto Rico Santa Isabel 72133 299 0 0 299 17.994525 -66.388913 2021-01-31 05:22:42 Santa Isabel, Puerto Rico, US
2021-01-30 US Puerto Rico Toa Alta 72135 2650 0 0 2650 18.362406 -66.246616 2021-01-31 05:22:42 Toa Alta, Puerto Rico, US
2021-01-30 US Puerto Rico Toa Baja 72137 2671 0 0 2671 18.431446 -66.213553 2021-01-31 05:22:42 Toa Baja, Puerto Rico, US
2021-01-30 US Puerto Rico Trujillo Alto 72139 2067 0 0 2067 18.336159 -65.99888399999999 2021-01-31 05:22:42 Trujillo Alto, Puerto Rico, US
2021-01-30 US Puerto Rico Unassigned 72999 2788 1823 0 965 18.459681 -67.336525 2021-01-31 05:22:42 Unassigned, Puerto Rico, US
2021-01-30 US Puerto Rico Utuado 72141 639 0 0 639 18.271214 -66.702984 2021-01-31 05:22:42 Utuado, Puerto Rico, US
2021-01-30 US Puerto Rico Vega Alta 72143 1232 0 0 1232 18.409346 -66.33725 2021-01-31 05:22:42 Vega Alta, Puerto Rico, US
2021-01-30 US Puerto Rico Vega Baja 72145 2055 0 0 2055 18.428262 -66.397924 2021-01-31 05:22:42 Vega Baja, Puerto Rico, US
2021-01-30 US Puerto Rico Vieques 72147 111 0 0 111 18.123276 -65.44097099999999 2021-01-31 05:22:42 Vieques, Puerto Rico, US
2021-01-30 US Puerto Rico Villalba 72149 585 0 0 585 18.127951 -66.473115 2021-01-31 05:22:42 Villalba, Puerto Rico, US
2021-01-30 US Puerto Rico Yabucoa 72151 650 0 0 650 18.070399 -65.896289 2021-01-31 05:22:42 Yabucoa, Puerto Rico, US
2021-01-30 US Puerto Rico Yauco 72153 547 0 0 547 18.080374 -66.858814 2021-01-31 05:22:42 Yauco, Puerto Rico, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;