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 551
- Adjuntas 498
- Aguada 498
- Aguadilla 498
- Aguas Buenas 498
- Aibonito 498
- Anasco 498
- Arecibo 498
- Arroyo 498
- Barceloneta 498
- Barranquitas 498
- Bayamon 498
- Cabo Rojo 498
- Caguas 498
- Camuy 498
- Canovanas 498
- Carolina 498
- Catano 498
- Cayey 498
- Ceiba 498
- Ciales 498
- Cidra 498
- Coamo 498
- Comerio 498
- Corozal 498
- Dorado 498
- Fajardo 498
- Florida 498
- Guanica 498
- Guayama 498
- …
state 1
- Puerto Rico · 39,358 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718224 | 1718224 | 2021-09-14 | Adjuntas | Puerto Rico | 72001 | 654 | |
1718225 | 1718225 | 2021-09-14 | Aguada | Puerto Rico | 72003 | 2365 | |
1718226 | 1718226 | 2021-09-14 | Aguadilla | Puerto Rico | 72005 | 2963 | |
1718227 | 1718227 | 2021-09-14 | Aguas Buenas | Puerto Rico | 72007 | 1600 | |
1718228 | 1718228 | 2021-09-14 | Aibonito | Puerto Rico | 72009 | 994 | |
1718229 | 1718229 | 2021-09-14 | Anasco | Puerto Rico | 72011 | 1397 | |
1718230 | 1718230 | 2021-09-14 | Arecibo | Puerto Rico | 72013 | 4364 | |
1718231 | 1718231 | 2021-09-14 | Arroyo | Puerto Rico | 72015 | 537 | |
1718232 | 1718232 | 2021-09-14 | Barceloneta | Puerto Rico | 72017 | 1137 | |
1718233 | 1718233 | 2021-09-14 | Barranquitas | Puerto Rico | 72019 | 1802 | |
1718234 | 1718234 | 2021-09-14 | Bayamon | Puerto Rico | 72021 | 15184 | |
1718235 | 1718235 | 2021-09-14 | Cabo Rojo | Puerto Rico | 72023 | 1861 | |
1718236 | 1718236 | 2021-09-14 | Caguas | Puerto Rico | 72025 | 8723 | |
1718237 | 1718237 | 2021-09-14 | Camuy | Puerto Rico | 72027 | 1722 | |
1718238 | 1718238 | 2021-09-14 | Canovanas | Puerto Rico | 72029 | 2973 | |
1718239 | 1718239 | 2021-09-14 | Carolina | Puerto Rico | 72031 | 12513 | |
1718240 | 1718240 | 2021-09-14 | Catano | Puerto Rico | 72033 | 1865 | |
1718241 | 1718241 | 2021-09-14 | Cayey | Puerto Rico | 72035 | 1893 | |
1718242 | 1718242 | 2021-09-14 | Ceiba | Puerto Rico | 72037 | 643 | |
1718243 | 1718243 | 2021-09-14 | Ciales | Puerto Rico | 72039 | 1041 | |
1718244 | 1718244 | 2021-09-14 | Cidra | Puerto Rico | 72041 | 1848 | |
1718245 | 1718245 | 2021-09-14 | Coamo | Puerto Rico | 72043 | 1388 | |
1718246 | 1718246 | 2021-09-14 | Comerio | Puerto Rico | 72045 | 1037 | |
1718247 | 1718247 | 2021-09-14 | Corozal | Puerto Rico | 72047 | 2378 | |
1718248 | 1718248 | 2021-09-14 | Culebra | Puerto Rico | 72049 | 48 | |
1718249 | 1718249 | 2021-09-14 | Dorado | Puerto Rico | 72051 | 3304 | |
1718250 | 1718250 | 2021-09-14 | Fajardo | Puerto Rico | 72053 | 2098 | |
1718251 | 1718251 | 2021-09-14 | Florida | Puerto Rico | 72054 | 975 | |
1718252 | 1718252 | 2021-09-14 | Guanica | Puerto Rico | 72055 | 428 | |
1718253 | 1718253 | 2021-09-14 | Guayama | Puerto Rico | 72057 | 1312 | |
1718254 | 1718254 | 2021-09-14 | Guayanilla | Puerto Rico | 72059 | 655 | |
1718255 | 1718255 | 2021-09-14 | Guaynabo | Puerto Rico | 72061 | 6601 | |
1718256 | 1718256 | 2021-09-14 | Gurabo | Puerto Rico | 72063 | 2969 | |
1718257 | 1718257 | 2021-09-14 | Hatillo | Puerto Rico | 72065 | 1771 | |
1718258 | 1718258 | 2021-09-14 | Hormigueros | Puerto Rico | 72067 | 682 | |
1718259 | 1718259 | 2021-09-14 | Humacao | Puerto Rico | 72069 | 2949 | |
1718260 | 1718260 | 2021-09-14 | Isabela | Puerto Rico | 72071 | 2406 | |
1718261 | 1718261 | 2021-09-14 | Jayuya | Puerto Rico | 72073 | 635 | |
1718262 | 1718262 | 2021-09-14 | Juana Diaz | Puerto Rico | 72075 | 1694 | |
1718263 | 1718263 | 2021-09-14 | Juncos | Puerto Rico | 72077 | 2916 | |
1718264 | 1718264 | 2021-09-14 | Lajas | Puerto Rico | 72079 | 768 | |
1718265 | 1718265 | 2021-09-14 | Lares | Puerto Rico | 72081 | 1360 | |
1718266 | 1718266 | 2021-09-14 | Las Marias | Puerto Rico | 72083 | 397 | |
1718267 | 1718267 | 2021-09-14 | Las Piedras | Puerto Rico | 72085 | 2242 | |
1718268 | 1718268 | 2021-09-14 | Loiza | Puerto Rico | 72087 | 1695 | |
1718269 | 1718269 | 2021-09-14 | Luquillo | Puerto Rico | 72089 | 1201 | |
1718270 | 1718270 | 2021-09-14 | Manati | Puerto Rico | 72091 | 2276 | |
1718271 | 1718271 | 2021-09-14 | Maricao | Puerto Rico | 72093 | 178 | |
1718272 | 1718272 | 2021-09-14 | Maunabo | Puerto Rico | 72095 | 542 | |
1718273 | 1718273 | 2021-09-14 | Mayaguez | Puerto Rico | 72097 | 3778 | |
1718274 | 1718274 | 2021-09-14 | Moca | Puerto Rico | 72099 | 2370 | |
1718275 | 1718275 | 2021-09-14 | Morovis | Puerto Rico | 72101 | 1945 | |
1718276 | 1718276 | 2021-09-14 | Naguabo | Puerto Rico | 72103 | 1422 | |
1718277 | 1718277 | 2021-09-14 | Naranjito | Puerto Rico | 72105 | 2343 | |
1718278 | 1718278 | 2021-09-14 | Orocovis | Puerto Rico | 72107 | 1196 | |
1718279 | 1718279 | 2021-09-14 | Patillas | Puerto Rico | 72109 | 550 | |
1718280 | 1718280 | 2021-09-14 | Penuelas | Puerto Rico | 72111 | 767 | |
1718281 | 1718281 | 2021-09-14 | Ponce | Puerto Rico | 72113 | 5234 | |
1718282 | 1718282 | 2021-09-14 | Quebradillas | Puerto Rico | 72115 | 1310 | |
1718283 | 1718283 | 2021-09-14 | Rincon | Puerto Rico | 72117 | 903 | |
1718284 | 1718284 | 2021-09-14 | Rio Grande | Puerto Rico | 72119 | 3142 | |
1718285 | 1718285 | 2021-09-14 | Sabana Grande | Puerto Rico | 72121 | 745 | |
1718286 | 1718286 | 2021-09-14 | Salinas | Puerto Rico | 72123 | 1410 | |
1718287 | 1718287 | 2021-09-14 | San German | Puerto Rico | 72125 | 1099 | |
1718288 | 1718288 | 2021-09-14 | San Juan | Puerto Rico | 72127 | 27989 | |
1718289 | 1718289 | 2021-09-14 | San Lorenzo | Puerto Rico | 72129 | 2342 | |
1718290 | 1718290 | 2021-09-14 | San Sebastian | Puerto Rico | 72131 | 2440 | |
1718291 | 1718291 | 2021-09-14 | Santa Isabel | Puerto Rico | 72133 | 815 | |
1718292 | 1718292 | 2021-09-14 | Toa Alta | Puerto Rico | 72135 | 5587 | |
1718293 | 1718293 | 2021-09-14 | Toa Baja | Puerto Rico | 72137 | 5962 | |
1718294 | 1718294 | 2021-09-14 | Trujillo Alto | Puerto Rico | 72139 | 4432 | |
1718295 | 1718295 | 2021-09-14 | Unknown | Puerto Rico | 5279 | 3028 | |
1718296 | 1718296 | 2021-09-14 | Utuado | Puerto Rico | 72141 | 1294 | |
1718297 | 1718297 | 2021-09-14 | Vega Alta | Puerto Rico | 72143 | 2867 | |
1718298 | 1718298 | 2021-09-14 | Vega Baja | Puerto Rico | 72145 | 4283 | |
1718299 | 1718299 | 2021-09-14 | Vieques | Puerto Rico | 72147 | 260 | |
1718300 | 1718300 | 2021-09-14 | Villalba | Puerto Rico | 72149 | 1005 | |
1718301 | 1718301 | 2021-09-14 | Yabucoa | Puerto Rico | 72151 | 1593 | |
1718302 | 1718302 | 2021-09-14 | Yauco | Puerto Rico | 72153 | 1404 | |
1714976 | 1714976 | 2021-09-13 | Adjuntas | Puerto Rico | 72001 | 654 | |
1714977 | 1714977 | 2021-09-13 | Aguada | Puerto Rico | 72003 | 2365 | |
1714978 | 1714978 | 2021-09-13 | Aguadilla | Puerto Rico | 72005 | 2961 | |
1714979 | 1714979 | 2021-09-13 | Aguas Buenas | Puerto Rico | 72007 | 1600 | |
1714980 | 1714980 | 2021-09-13 | Aibonito | Puerto Rico | 72009 | 994 | |
1714981 | 1714981 | 2021-09-13 | Anasco | Puerto Rico | 72011 | 1397 | |
1714982 | 1714982 | 2021-09-13 | Arecibo | Puerto Rico | 72013 | 4363 | |
1714983 | 1714983 | 2021-09-13 | Arroyo | Puerto Rico | 72015 | 537 | |
1714984 | 1714984 | 2021-09-13 | Barceloneta | Puerto Rico | 72017 | 1137 | |
1714985 | 1714985 | 2021-09-13 | Barranquitas | Puerto Rico | 72019 | 1802 | |
1714986 | 1714986 | 2021-09-13 | Bayamon | Puerto Rico | 72021 | 15183 | |
1714987 | 1714987 | 2021-09-13 | Cabo Rojo | Puerto Rico | 72023 | 1861 | |
1714988 | 1714988 | 2021-09-13 | Caguas | Puerto Rico | 72025 | 8725 | |
1714989 | 1714989 | 2021-09-13 | Camuy | Puerto Rico | 72027 | 1721 | |
1714990 | 1714990 | 2021-09-13 | Canovanas | Puerto Rico | 72029 | 2973 | |
1714991 | 1714991 | 2021-09-13 | Carolina | Puerto Rico | 72031 | 12513 | |
1714992 | 1714992 | 2021-09-13 | Catano | Puerto Rico | 72033 | 1865 | |
1714993 | 1714993 | 2021-09-13 | Cayey | Puerto Rico | 72035 | 1893 | |
1714994 | 1714994 | 2021-09-13 | Ceiba | Puerto Rico | 72037 | 643 | |
1714995 | 1714995 | 2021-09-13 | Ciales | Puerto Rico | 72039 | 1041 | |
1714996 | 1714996 | 2021-09-13 | Cidra | Puerto Rico | 72041 | 1847 |
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);