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 260
- Adjuntas 207
- Aguada 207
- Aguadilla 207
- Aguas Buenas 207
- Aibonito 207
- Anasco 207
- Arecibo 207
- Arroyo 207
- Barceloneta 207
- Barranquitas 207
- Bayamon 207
- Cabo Rojo 207
- Caguas 207
- Camuy 207
- Canovanas 207
- Carolina 207
- Catano 207
- Cayey 207
- Ceiba 207
- Ciales 207
- Cidra 207
- Coamo 207
- Comerio 207
- Corozal 207
- Dorado 207
- Fajardo 207
- Florida 207
- Guanica 207
- Guayama 207
- …
state 1
- Puerto Rico · 16,369 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
773481 | 773481 | 2020-11-27 | Adjuntas | Puerto Rico | 72001 | 237 | |
773482 | 773482 | 2020-11-27 | Aguada | Puerto Rico | 72003 | 645 | |
773483 | 773483 | 2020-11-27 | Aguadilla | Puerto Rico | 72005 | 837 | |
773484 | 773484 | 2020-11-27 | Aguas Buenas | Puerto Rico | 72007 | 504 | |
773485 | 773485 | 2020-11-27 | Aibonito | Puerto Rico | 72009 | 298 | |
773486 | 773486 | 2020-11-27 | Anasco | Puerto Rico | 72011 | 488 | |
773487 | 773487 | 2020-11-27 | Arecibo | Puerto Rico | 72013 | 1559 | |
773488 | 773488 | 2020-11-27 | Arroyo | Puerto Rico | 72015 | 242 | |
773489 | 773489 | 2020-11-27 | Barceloneta | Puerto Rico | 72017 | 450 | |
773490 | 773490 | 2020-11-27 | Barranquitas | Puerto Rico | 72019 | 824 | |
773491 | 773491 | 2020-11-27 | Bayamon | Puerto Rico | 72021 | 6302 | |
773492 | 773492 | 2020-11-27 | Cabo Rojo | Puerto Rico | 72023 | 622 | |
773493 | 773493 | 2020-11-27 | Caguas | Puerto Rico | 72025 | 3152 | |
773494 | 773494 | 2020-11-27 | Camuy | Puerto Rico | 72027 | 665 | |
773495 | 773495 | 2020-11-27 | Canovanas | Puerto Rico | 72029 | 1153 | |
773496 | 773496 | 2020-11-27 | Carolina | Puerto Rico | 72031 | 5114 | |
773497 | 773497 | 2020-11-27 | Catano | Puerto Rico | 72033 | 775 | |
773498 | 773498 | 2020-11-27 | Cayey | Puerto Rico | 72035 | 735 | |
773499 | 773499 | 2020-11-27 | Ceiba | Puerto Rico | 72037 | 239 | |
773500 | 773500 | 2020-11-27 | Ciales | Puerto Rico | 72039 | 501 | |
773501 | 773501 | 2020-11-27 | Cidra | Puerto Rico | 72041 | 598 | |
773502 | 773502 | 2020-11-27 | Coamo | Puerto Rico | 72043 | 552 | |
773503 | 773503 | 2020-11-27 | Comerio | Puerto Rico | 72045 | 394 | |
773504 | 773504 | 2020-11-27 | Corozal | Puerto Rico | 72047 | 1134 | |
773505 | 773505 | 2020-11-27 | Culebra | Puerto Rico | 72049 | 25 | |
773506 | 773506 | 2020-11-27 | Dorado | Puerto Rico | 72051 | 1439 | |
773507 | 773507 | 2020-11-27 | Fajardo | Puerto Rico | 72053 | 844 | |
773508 | 773508 | 2020-11-27 | Florida | Puerto Rico | 72054 | 507 | |
773509 | 773509 | 2020-11-27 | Guanica | Puerto Rico | 72055 | 197 | |
773510 | 773510 | 2020-11-27 | Guayama | Puerto Rico | 72057 | 524 | |
773511 | 773511 | 2020-11-27 | Guayanilla | Puerto Rico | 72059 | 307 | |
773512 | 773512 | 2020-11-27 | Guaynabo | Puerto Rico | 72061 | 2909 | |
773513 | 773513 | 2020-11-27 | Gurabo | Puerto Rico | 72063 | 1026 | |
773514 | 773514 | 2020-11-27 | Hatillo | Puerto Rico | 72065 | 604 | |
773515 | 773515 | 2020-11-27 | Hormigueros | Puerto Rico | 72067 | 275 | |
773516 | 773516 | 2020-11-27 | Humacao | Puerto Rico | 72069 | 995 | |
773517 | 773517 | 2020-11-27 | Isabela | Puerto Rico | 72071 | 608 | |
773518 | 773518 | 2020-11-27 | Jayuya | Puerto Rico | 72073 | 356 | |
773519 | 773519 | 2020-11-27 | Juana Diaz | Puerto Rico | 72075 | 639 | |
773520 | 773520 | 2020-11-27 | Juncos | Puerto Rico | 72077 | 808 | |
773521 | 773521 | 2020-11-27 | Lajas | Puerto Rico | 72079 | 258 | |
773522 | 773522 | 2020-11-27 | Lares | Puerto Rico | 72081 | 611 | |
773523 | 773523 | 2020-11-27 | Las Marias | Puerto Rico | 72083 | 152 | |
773524 | 773524 | 2020-11-27 | Las Piedras | Puerto Rico | 72085 | 835 | |
773525 | 773525 | 2020-11-27 | Loiza | Puerto Rico | 72087 | 517 | |
773526 | 773526 | 2020-11-27 | Luquillo | Puerto Rico | 72089 | 388 | |
773527 | 773527 | 2020-11-27 | Manati | Puerto Rico | 72091 | 1002 | |
773528 | 773528 | 2020-11-27 | Maricao | Puerto Rico | 72093 | 99 | |
773529 | 773529 | 2020-11-27 | Maunabo | Puerto Rico | 72095 | 211 | |
773530 | 773530 | 2020-11-27 | Mayaguez | Puerto Rico | 72097 | 1279 | |
773531 | 773531 | 2020-11-27 | Moca | Puerto Rico | 72099 | 770 | |
773532 | 773532 | 2020-11-27 | Morovis | Puerto Rico | 72101 | 806 | |
773533 | 773533 | 2020-11-27 | Naguabo | Puerto Rico | 72103 | 467 | |
773534 | 773534 | 2020-11-27 | Naranjito | Puerto Rico | 72105 | 1018 | |
773535 | 773535 | 2020-11-27 | Orocovis | Puerto Rico | 72107 | 527 | |
773536 | 773536 | 2020-11-27 | Patillas | Puerto Rico | 72109 | 256 | |
773537 | 773537 | 2020-11-27 | Penuelas | Puerto Rico | 72111 | 268 | |
773538 | 773538 | 2020-11-27 | Ponce | Puerto Rico | 72113 | 1632 | |
773539 | 773539 | 2020-11-27 | Quebradillas | Puerto Rico | 72115 | 402 | |
773540 | 773540 | 2020-11-27 | Rincon | Puerto Rico | 72117 | 289 | |
773541 | 773541 | 2020-11-27 | Rio Grande | Puerto Rico | 72119 | 1043 | |
773542 | 773542 | 2020-11-27 | Sabana Grande | Puerto Rico | 72121 | 271 | |
773543 | 773543 | 2020-11-27 | Salinas | Puerto Rico | 72123 | 702 | |
773544 | 773544 | 2020-11-27 | San German | Puerto Rico | 72125 | 396 | |
773545 | 773545 | 2020-11-27 | San Juan | Puerto Rico | 72127 | 12689 | |
773546 | 773546 | 2020-11-27 | San Lorenzo | Puerto Rico | 72129 | 914 | |
773547 | 773547 | 2020-11-27 | San Sebastian | Puerto Rico | 72131 | 1139 | |
773548 | 773548 | 2020-11-27 | Santa Isabel | Puerto Rico | 72133 | 352 | |
773549 | 773549 | 2020-11-27 | Toa Alta | Puerto Rico | 72135 | 2335 | |
773550 | 773550 | 2020-11-27 | Toa Baja | Puerto Rico | 72137 | 2553 | |
773551 | 773551 | 2020-11-27 | Trujillo Alto | Puerto Rico | 72139 | 2010 | |
773552 | 773552 | 2020-11-27 | Unknown | Puerto Rico | 2792 | 1076 | |
773553 | 773553 | 2020-11-27 | Utuado | Puerto Rico | 72141 | 436 | |
773554 | 773554 | 2020-11-27 | Vega Alta | Puerto Rico | 72143 | 1246 | |
773555 | 773555 | 2020-11-27 | Vega Baja | Puerto Rico | 72145 | 1654 | |
773556 | 773556 | 2020-11-27 | Vieques | Puerto Rico | 72147 | 108 | |
773557 | 773557 | 2020-11-27 | Villalba | Puerto Rico | 72149 | 479 | |
773558 | 773558 | 2020-11-27 | Yabucoa | Puerto Rico | 72151 | 572 | |
773559 | 773559 | 2020-11-27 | Yauco | Puerto Rico | 72153 | 732 | |
770236 | 770236 | 2020-11-26 | Adjuntas | Puerto Rico | 72001 | 236 | |
770237 | 770237 | 2020-11-26 | Aguada | Puerto Rico | 72003 | 629 | |
770238 | 770238 | 2020-11-26 | Aguadilla | Puerto Rico | 72005 | 821 | |
770239 | 770239 | 2020-11-26 | Aguas Buenas | Puerto Rico | 72007 | 494 | |
770240 | 770240 | 2020-11-26 | Aibonito | Puerto Rico | 72009 | 291 | |
770241 | 770241 | 2020-11-26 | Anasco | Puerto Rico | 72011 | 474 | |
770242 | 770242 | 2020-11-26 | Arecibo | Puerto Rico | 72013 | 1501 | |
770243 | 770243 | 2020-11-26 | Arroyo | Puerto Rico | 72015 | 239 | |
770244 | 770244 | 2020-11-26 | Barceloneta | Puerto Rico | 72017 | 441 | |
770245 | 770245 | 2020-11-26 | Barranquitas | Puerto Rico | 72019 | 798 | |
770246 | 770246 | 2020-11-26 | Bayamon | Puerto Rico | 72021 | 6207 | |
770247 | 770247 | 2020-11-26 | Cabo Rojo | Puerto Rico | 72023 | 615 | |
770248 | 770248 | 2020-11-26 | Caguas | Puerto Rico | 72025 | 3091 | |
770249 | 770249 | 2020-11-26 | Camuy | Puerto Rico | 72027 | 645 | |
770250 | 770250 | 2020-11-26 | Canovanas | Puerto Rico | 72029 | 1125 | |
770251 | 770251 | 2020-11-26 | Carolina | Puerto Rico | 72031 | 5039 | |
770252 | 770252 | 2020-11-26 | Catano | Puerto Rico | 72033 | 767 | |
770253 | 770253 | 2020-11-26 | Cayey | Puerto Rico | 72035 | 704 | |
770254 | 770254 | 2020-11-26 | Ceiba | Puerto Rico | 72037 | 237 | |
770255 | 770255 | 2020-11-26 | Ciales | Puerto Rico | 72039 | 488 | |
770256 | 770256 | 2020-11-26 | Cidra | Puerto Rico | 72041 | 588 |
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);