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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Mayaguez 739
- Moca 739
- Morovis 739
- Naguabo 739
- Naranjito 739
- Orocovis 739
- Patillas 739
- Penuelas 739
- Ponce 739
- Quebradillas 739
- Rincon 739
- Rio Grande 739
- Sabana Grande 739
- Salinas 739
- San German 739
- San Juan 739
- San Lorenzo 739
- San Sebastian 739
- Santa Isabel 739
- Toa Alta 739
- Toa Baja 739
- Trujillo Alto 739
- Unknown 739
- Utuado 739
- Vega Alta 739
- Vega Baja 739
- Villalba 739
- Yabucoa 739
- Yauco 739
- Adjuntas 738
- …
state 1
- Puerto Rico · 58,297 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117534 | 117534 | 2020-05-05 | Mayaguez | Puerto Rico | 72097 | 44 | |
117535 | 117535 | 2020-05-05 | Moca | Puerto Rico | 72099 | 14 | |
117536 | 117536 | 2020-05-05 | Morovis | Puerto Rico | 72101 | 13 | |
117537 | 117537 | 2020-05-05 | Naguabo | Puerto Rico | 72103 | 10 | |
117538 | 117538 | 2020-05-05 | Naranjito | Puerto Rico | 72105 | 12 | |
117539 | 117539 | 2020-05-05 | Orocovis | Puerto Rico | 72107 | 24 | |
117540 | 117540 | 2020-05-05 | Patillas | Puerto Rico | 72109 | 13 | |
117541 | 117541 | 2020-05-05 | Penuelas | Puerto Rico | 72111 | 2 | |
117542 | 117542 | 2020-05-05 | Ponce | Puerto Rico | 72113 | 54 | |
117543 | 117543 | 2020-05-05 | Quebradillas | Puerto Rico | 72115 | 20 | |
117544 | 117544 | 2020-05-05 | Rincon | Puerto Rico | 72117 | 2 | |
117545 | 117545 | 2020-05-05 | Rio Grande | Puerto Rico | 72119 | 22 | |
117546 | 117546 | 2020-05-05 | Sabana Grande | Puerto Rico | 72121 | 19 | |
117547 | 117547 | 2020-05-05 | Salinas | Puerto Rico | 72123 | 22 | |
117548 | 117548 | 2020-05-05 | San German | Puerto Rico | 72125 | 26 | |
117549 | 117549 | 2020-05-05 | San Juan | Puerto Rico | 72127 | 287 | |
117550 | 117550 | 2020-05-05 | San Lorenzo | Puerto Rico | 72129 | 15 | |
117551 | 117551 | 2020-05-05 | San Sebastian | Puerto Rico | 72131 | 29 | |
117552 | 117552 | 2020-05-05 | Santa Isabel | Puerto Rico | 72133 | 8 | |
117553 | 117553 | 2020-05-05 | Toa Alta | Puerto Rico | 72135 | 51 | |
117554 | 117554 | 2020-05-05 | Toa Baja | Puerto Rico | 72137 | 49 | |
117555 | 117555 | 2020-05-05 | Trujillo Alto | Puerto Rico | 72139 | 36 | |
117556 | 117556 | 2020-05-05 | Unknown | Puerto Rico | 133 | 99 | |
117557 | 117557 | 2020-05-05 | Utuado | Puerto Rico | 72141 | 2 | |
117558 | 117558 | 2020-05-05 | Vega Alta | Puerto Rico | 72143 | 27 | |
117559 | 117559 | 2020-05-05 | Vega Baja | Puerto Rico | 72145 | 21 | |
117560 | 117560 | 2020-05-05 | Villalba | Puerto Rico | 72149 | 6 | |
117561 | 117561 | 2020-05-05 | Yabucoa | Puerto Rico | 72151 | 7 | |
117562 | 117562 | 2020-05-05 | Yauco | Puerto Rico | 72153 | 20 | |
120449 | 120449 | 2020-05-06 | Adjuntas | Puerto Rico | 72001 | 3 | |
120450 | 120450 | 2020-05-06 | Aguada | Puerto Rico | 72003 | 7 | |
120451 | 120451 | 2020-05-06 | Aguadilla | Puerto Rico | 72005 | 11 | |
120452 | 120452 | 2020-05-06 | Aguas Buenas | Puerto Rico | 72007 | 22 | |
120453 | 120453 | 2020-05-06 | Aibonito | Puerto Rico | 72009 | 13 | |
120454 | 120454 | 2020-05-06 | Anasco | Puerto Rico | 72011 | 5 | |
120455 | 120455 | 2020-05-06 | Arecibo | Puerto Rico | 72013 | 43 | |
120456 | 120456 | 2020-05-06 | Arroyo | Puerto Rico | 72015 | 5 | |
120457 | 120457 | 2020-05-06 | Barceloneta | Puerto Rico | 72017 | 4 | |
120458 | 120458 | 2020-05-06 | Barranquitas | Puerto Rico | 72019 | 16 | |
120459 | 120459 | 2020-05-06 | Bayamon | Puerto Rico | 72021 | 109 | |
120460 | 120460 | 2020-05-06 | Cabo Rojo | Puerto Rico | 72023 | 20 | |
120461 | 120461 | 2020-05-06 | Caguas | Puerto Rico | 72025 | 60 | |
120462 | 120462 | 2020-05-06 | Camuy | Puerto Rico | 72027 | 7 | |
120463 | 120463 | 2020-05-06 | Canovanas | Puerto Rico | 72029 | 32 | |
120464 | 120464 | 2020-05-06 | Carolina | Puerto Rico | 72031 | 88 | |
120465 | 120465 | 2020-05-06 | Catano | Puerto Rico | 72033 | 12 | |
120466 | 120466 | 2020-05-06 | Cayey | Puerto Rico | 72035 | 28 | |
120467 | 120467 | 2020-05-06 | Ceiba | Puerto Rico | 72037 | 8 | |
120468 | 120468 | 2020-05-06 | Ciales | Puerto Rico | 72039 | 7 | |
120469 | 120469 | 2020-05-06 | Cidra | Puerto Rico | 72041 | 26 | |
120470 | 120470 | 2020-05-06 | Coamo | Puerto Rico | 72043 | 5 | |
120471 | 120471 | 2020-05-06 | Comerio | Puerto Rico | 72045 | 9 | |
120472 | 120472 | 2020-05-06 | Corozal | Puerto Rico | 72047 | 18 | |
120473 | 120473 | 2020-05-06 | Dorado | Puerto Rico | 72051 | 36 | |
120474 | 120474 | 2020-05-06 | Fajardo | Puerto Rico | 72053 | 8 | |
120475 | 120475 | 2020-05-06 | Florida | Puerto Rico | 72054 | 3 | |
120476 | 120476 | 2020-05-06 | Guanica | Puerto Rico | 72055 | 16 | |
120477 | 120477 | 2020-05-06 | Guayama | Puerto Rico | 72057 | 11 | |
120478 | 120478 | 2020-05-06 | Guayanilla | Puerto Rico | 72059 | 10 | |
120479 | 120479 | 2020-05-06 | Guaynabo | Puerto Rico | 72061 | 107 | |
120480 | 120480 | 2020-05-06 | Gurabo | Puerto Rico | 72063 | 29 | |
120481 | 120481 | 2020-05-06 | Hatillo | Puerto Rico | 72065 | 8 | |
120482 | 120482 | 2020-05-06 | Hormigueros | Puerto Rico | 72067 | 11 | |
120483 | 120483 | 2020-05-06 | Humacao | Puerto Rico | 72069 | 23 | |
120484 | 120484 | 2020-05-06 | Isabela | Puerto Rico | 72071 | 13 | |
120485 | 120485 | 2020-05-06 | Jayuya | Puerto Rico | 72073 | 2 | |
120486 | 120486 | 2020-05-06 | Juana Diaz | Puerto Rico | 72075 | 30 | |
120487 | 120487 | 2020-05-06 | Juncos | Puerto Rico | 72077 | 13 | |
120488 | 120488 | 2020-05-06 | Lajas | Puerto Rico | 72079 | 8 | |
120489 | 120489 | 2020-05-06 | Lares | Puerto Rico | 72081 | 12 | |
120490 | 120490 | 2020-05-06 | Las Marias | Puerto Rico | 72083 | 5 | |
120491 | 120491 | 2020-05-06 | Las Piedras | Puerto Rico | 72085 | 12 | |
120492 | 120492 | 2020-05-06 | Loiza | Puerto Rico | 72087 | 6 | |
120493 | 120493 | 2020-05-06 | Luquillo | Puerto Rico | 72089 | 6 | |
120494 | 120494 | 2020-05-06 | Manati | Puerto Rico | 72091 | 13 | |
120495 | 120495 | 2020-05-06 | Maunabo | Puerto Rico | 72095 | 4 | |
120496 | 120496 | 2020-05-06 | Mayaguez | Puerto Rico | 72097 | 44 | |
120497 | 120497 | 2020-05-06 | Moca | Puerto Rico | 72099 | 14 | |
120498 | 120498 | 2020-05-06 | Morovis | Puerto Rico | 72101 | 16 | |
120499 | 120499 | 2020-05-06 | Naguabo | Puerto Rico | 72103 | 13 | |
120500 | 120500 | 2020-05-06 | Naranjito | Puerto Rico | 72105 | 12 | |
120501 | 120501 | 2020-05-06 | Orocovis | Puerto Rico | 72107 | 25 | |
120502 | 120502 | 2020-05-06 | Patillas | Puerto Rico | 72109 | 17 | |
120503 | 120503 | 2020-05-06 | Penuelas | Puerto Rico | 72111 | 2 | |
120504 | 120504 | 2020-05-06 | Ponce | Puerto Rico | 72113 | 54 | |
120505 | 120505 | 2020-05-06 | Quebradillas | Puerto Rico | 72115 | 20 | |
120506 | 120506 | 2020-05-06 | Rincon | Puerto Rico | 72117 | 2 | |
120507 | 120507 | 2020-05-06 | Rio Grande | Puerto Rico | 72119 | 23 | |
120508 | 120508 | 2020-05-06 | Sabana Grande | Puerto Rico | 72121 | 19 | |
120509 | 120509 | 2020-05-06 | Salinas | Puerto Rico | 72123 | 22 | |
120510 | 120510 | 2020-05-06 | San German | Puerto Rico | 72125 | 26 | |
120511 | 120511 | 2020-05-06 | San Juan | Puerto Rico | 72127 | 294 | |
120512 | 120512 | 2020-05-06 | San Lorenzo | Puerto Rico | 72129 | 16 | |
120513 | 120513 | 2020-05-06 | San Sebastian | Puerto Rico | 72131 | 29 | |
120514 | 120514 | 2020-05-06 | Santa Isabel | Puerto Rico | 72133 | 10 | |
120515 | 120515 | 2020-05-06 | Toa Alta | Puerto Rico | 72135 | 52 | |
120516 | 120516 | 2020-05-06 | Toa Baja | Puerto Rico | 72137 | 50 | |
120517 | 120517 | 2020-05-06 | Trujillo Alto | Puerto Rico | 72139 | 38 | |
120518 | 120518 | 2020-05-06 | Unknown | Puerto Rico | 140 | 99 | |
120519 | 120519 | 2020-05-06 | Utuado | Puerto Rico | 72141 | 2 |
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);