ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58,397 rows where state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Unknown 349
- Las Marias 296
- Las Piedras 296
- Loiza 296
- Luquillo 296
- Manati 296
- Maunabo 296
- Mayaguez 296
- Moca 296
- Morovis 296
- Naguabo 296
- Naranjito 296
- Orocovis 296
- Patillas 296
- Penuelas 296
- Ponce 296
- Quebradillas 296
- Rincon 296
- Rio Grande 296
- Sabana Grande 296
- Salinas 296
- San German 296
- San Juan 296
- San Lorenzo 296
- San Sebastian 296
- Santa Isabel 296
- Toa Alta 296
- Toa Baja 296
- Trujillo Alto 296
- Utuado 296
- …
state 1
- Puerto Rico · 23,358 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1062368 | 1062368 | 2021-02-24 | Las Marias | Puerto Rico | 72083 | 203 | |
1062369 | 1062369 | 2021-02-24 | Las Piedras | Puerto Rico | 72085 | 1417 | |
1062370 | 1062370 | 2021-02-24 | Loiza | Puerto Rico | 72087 | 980 | |
1062371 | 1062371 | 2021-02-24 | Luquillo | Puerto Rico | 72089 | 665 | |
1062372 | 1062372 | 2021-02-24 | Manati | Puerto Rico | 72091 | 1537 | |
1062373 | 1062373 | 2021-02-24 | Maricao | Puerto Rico | 72093 | 117 | |
1062374 | 1062374 | 2021-02-24 | Maunabo | Puerto Rico | 72095 | 321 | |
1062375 | 1062375 | 2021-02-24 | Mayaguez | Puerto Rico | 72097 | 1956 | |
1062376 | 1062376 | 2021-02-24 | Moca | Puerto Rico | 72099 | 1374 | |
1062377 | 1062377 | 2021-02-24 | Morovis | Puerto Rico | 72101 | 1327 | |
1062378 | 1062378 | 2021-02-24 | Naguabo | Puerto Rico | 72103 | 779 | |
1062379 | 1062379 | 2021-02-24 | Naranjito | Puerto Rico | 72105 | 1578 | |
1062380 | 1062380 | 2021-02-24 | Orocovis | Puerto Rico | 72107 | 792 | |
1062381 | 1062381 | 2021-02-24 | Patillas | Puerto Rico | 72109 | 365 | |
1062382 | 1062382 | 2021-02-24 | Penuelas | Puerto Rico | 72111 | 525 | |
1062383 | 1062383 | 2021-02-24 | Ponce | Puerto Rico | 72113 | 3044 | |
1062384 | 1062384 | 2021-02-24 | Quebradillas | Puerto Rico | 72115 | 706 | |
1062385 | 1062385 | 2021-02-24 | Rincon | Puerto Rico | 72117 | 445 | |
1062386 | 1062386 | 2021-02-24 | Rio Grande | Puerto Rico | 72119 | 1771 | |
1062387 | 1062387 | 2021-02-24 | Sabana Grande | Puerto Rico | 72121 | 408 | |
1062388 | 1062388 | 2021-02-24 | Salinas | Puerto Rico | 72123 | 1009 | |
1062389 | 1062389 | 2021-02-24 | San German | Puerto Rico | 72125 | 609 | |
1062390 | 1062390 | 2021-02-24 | San Juan | Puerto Rico | 72127 | 17823 | |
1062391 | 1062391 | 2021-02-24 | San Lorenzo | Puerto Rico | 72129 | 1453 | |
1062392 | 1062392 | 2021-02-24 | San Sebastian | Puerto Rico | 72131 | 1643 | |
1062393 | 1062393 | 2021-02-24 | Santa Isabel | Puerto Rico | 72133 | 559 | |
1062394 | 1062394 | 2021-02-24 | Toa Alta | Puerto Rico | 72135 | 3660 | |
1062395 | 1062395 | 2021-02-24 | Toa Baja | Puerto Rico | 72137 | 3822 | |
1062396 | 1062396 | 2021-02-24 | Trujillo Alto | Puerto Rico | 72139 | 2883 | |
1062397 | 1062397 | 2021-02-24 | Unknown | Puerto Rico | 4416 | 2007 | |
1062398 | 1062398 | 2021-02-24 | Utuado | Puerto Rico | 72141 | 851 | |
1062399 | 1062399 | 2021-02-24 | Vega Alta | Puerto Rico | 72143 | 1818 | |
1062400 | 1062400 | 2021-02-24 | Vega Baja | Puerto Rico | 72145 | 2678 | |
1062401 | 1062401 | 2021-02-24 | Vieques | Puerto Rico | 72147 | 195 | |
1062402 | 1062402 | 2021-02-24 | Villalba | Puerto Rico | 72149 | 752 | |
1062403 | 1062403 | 2021-02-24 | Yabucoa | Puerto Rico | 72151 | 1005 | |
1062404 | 1062404 | 2021-02-24 | Yauco | Puerto Rico | 72153 | 994 | |
1059081 | 1059081 | 2021-02-23 | Adjuntas | Puerto Rico | 72001 | 461 | |
1059082 | 1059082 | 2021-02-23 | Aguada | Puerto Rico | 72003 | 1208 | |
1059083 | 1059083 | 2021-02-23 | Aguadilla | Puerto Rico | 72005 | 1490 | |
1059084 | 1059084 | 2021-02-23 | Aguas Buenas | Puerto Rico | 72007 | 1025 | |
1059085 | 1059085 | 2021-02-23 | Aibonito | Puerto Rico | 72009 | 574 | |
1059086 | 1059086 | 2021-02-23 | Anasco | Puerto Rico | 72011 | 810 | |
1059087 | 1059087 | 2021-02-23 | Arecibo | Puerto Rico | 72013 | 2842 | |
1059088 | 1059088 | 2021-02-23 | Arroyo | Puerto Rico | 72015 | 352 | |
1059089 | 1059089 | 2021-02-23 | Barceloneta | Puerto Rico | 72017 | 717 | |
1059090 | 1059090 | 2021-02-23 | Barranquitas | Puerto Rico | 72019 | 1210 | |
1059091 | 1059091 | 2021-02-23 | Bayamon | Puerto Rico | 72021 | 10057 | |
1059092 | 1059092 | 2021-02-23 | Cabo Rojo | Puerto Rico | 72023 | 915 | |
1059093 | 1059093 | 2021-02-23 | Caguas | Puerto Rico | 72025 | 5592 | |
1059094 | 1059094 | 2021-02-23 | Camuy | Puerto Rico | 72027 | 1108 | |
1059095 | 1059095 | 2021-02-23 | Canovanas | Puerto Rico | 72029 | 1750 | |
1059096 | 1059096 | 2021-02-23 | Carolina | Puerto Rico | 72031 | 7837 | |
1059097 | 1059097 | 2021-02-23 | Catano | Puerto Rico | 72033 | 1218 | |
1059098 | 1059098 | 2021-02-23 | Cayey | Puerto Rico | 72035 | 1292 | |
1059099 | 1059099 | 2021-02-23 | Ceiba | Puerto Rico | 72037 | 401 | |
1059100 | 1059100 | 2021-02-23 | Ciales | Puerto Rico | 72039 | 734 | |
1059101 | 1059101 | 2021-02-23 | Cidra | Puerto Rico | 72041 | 1213 | |
1059102 | 1059102 | 2021-02-23 | Coamo | Puerto Rico | 72043 | 941 | |
1059103 | 1059103 | 2021-02-23 | Comerio | Puerto Rico | 72045 | 675 | |
1059104 | 1059104 | 2021-02-23 | Corozal | Puerto Rico | 72047 | 1597 | |
1059105 | 1059105 | 2021-02-23 | Culebra | Puerto Rico | 72049 | 28 | |
1059106 | 1059106 | 2021-02-23 | Dorado | Puerto Rico | 72051 | 2141 | |
1059107 | 1059107 | 2021-02-23 | Fajardo | Puerto Rico | 72053 | 1269 | |
1059108 | 1059108 | 2021-02-23 | Florida | Puerto Rico | 72054 | 675 | |
1059109 | 1059109 | 2021-02-23 | Guanica | Puerto Rico | 72055 | 248 | |
1059110 | 1059110 | 2021-02-23 | Guayama | Puerto Rico | 72057 | 808 | |
1059111 | 1059111 | 2021-02-23 | Guayanilla | Puerto Rico | 72059 | 427 | |
1059112 | 1059112 | 2021-02-23 | Guaynabo | Puerto Rico | 72061 | 4361 | |
1059113 | 1059113 | 2021-02-23 | Gurabo | Puerto Rico | 72063 | 1837 | |
1059114 | 1059114 | 2021-02-23 | Hatillo | Puerto Rico | 72065 | 1038 | |
1059115 | 1059115 | 2021-02-23 | Hormigueros | Puerto Rico | 72067 | 409 | |
1059116 | 1059116 | 2021-02-23 | Humacao | Puerto Rico | 72069 | 1644 | |
1059117 | 1059117 | 2021-02-23 | Isabela | Puerto Rico | 72071 | 1217 | |
1059118 | 1059118 | 2021-02-23 | Jayuya | Puerto Rico | 72073 | 413 | |
1059119 | 1059119 | 2021-02-23 | Juana Diaz | Puerto Rico | 72075 | 1086 | |
1059120 | 1059120 | 2021-02-23 | Juncos | Puerto Rico | 72077 | 1721 | |
1059121 | 1059121 | 2021-02-23 | Lajas | Puerto Rico | 72079 | 411 | |
1059122 | 1059122 | 2021-02-23 | Lares | Puerto Rico | 72081 | 873 | |
1059123 | 1059123 | 2021-02-23 | Las Marias | Puerto Rico | 72083 | 203 | |
1059124 | 1059124 | 2021-02-23 | Las Piedras | Puerto Rico | 72085 | 1417 | |
1059125 | 1059125 | 2021-02-23 | Loiza | Puerto Rico | 72087 | 980 | |
1059126 | 1059126 | 2021-02-23 | Luquillo | Puerto Rico | 72089 | 665 | |
1059127 | 1059127 | 2021-02-23 | Manati | Puerto Rico | 72091 | 1537 | |
1059128 | 1059128 | 2021-02-23 | Maricao | Puerto Rico | 72093 | 117 | |
1059129 | 1059129 | 2021-02-23 | Maunabo | Puerto Rico | 72095 | 321 | |
1059130 | 1059130 | 2021-02-23 | Mayaguez | Puerto Rico | 72097 | 1954 | |
1059131 | 1059131 | 2021-02-23 | Moca | Puerto Rico | 72099 | 1374 | |
1059132 | 1059132 | 2021-02-23 | Morovis | Puerto Rico | 72101 | 1326 | |
1059133 | 1059133 | 2021-02-23 | Naguabo | Puerto Rico | 72103 | 778 | |
1059134 | 1059134 | 2021-02-23 | Naranjito | Puerto Rico | 72105 | 1578 | |
1059135 | 1059135 | 2021-02-23 | Orocovis | Puerto Rico | 72107 | 791 | |
1059136 | 1059136 | 2021-02-23 | Patillas | Puerto Rico | 72109 | 365 | |
1059137 | 1059137 | 2021-02-23 | Penuelas | Puerto Rico | 72111 | 525 | |
1059138 | 1059138 | 2021-02-23 | Ponce | Puerto Rico | 72113 | 3043 | |
1059139 | 1059139 | 2021-02-23 | Quebradillas | Puerto Rico | 72115 | 706 | |
1059140 | 1059140 | 2021-02-23 | Rincon | Puerto Rico | 72117 | 445 | |
1059141 | 1059141 | 2021-02-23 | Rio Grande | Puerto Rico | 72119 | 1771 | |
1059142 | 1059142 | 2021-02-23 | Sabana Grande | Puerto Rico | 72121 | 408 | |
1059143 | 1059143 | 2021-02-23 | Salinas | Puerto Rico | 72123 | 1007 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);