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 79
- - 580
- 72001 527
- 72003 527
- 72005 527
- 72007 527
- 72009 527
- 72011 527
- 72013 527
- 72015 527
- 72017 527
- 72019 527
- 72021 527
- 72023 527
- 72025 527
- 72027 527
- 72029 527
- 72031 527
- 72033 527
- 72035 527
- 72037 527
- 72039 527
- 72041 527
- 72043 527
- 72045 527
- 72047 527
- 72051 527
- 72053 527
- 72054 527
- 72055 527
- 72057 527
- 72059 527
- 72061 527
- 72063 527
- 72065 527
- 72067 527
- 72069 527
- 72071 527
- 72073 527
- 72075 527
- 72077 527
- 72079 527
- 72081 527
- 72083 527
- 72085 527
- 72087 527
- 72089 527
- 72091 527
- 72095 527
- 72097 527
- 72099 527
- 72101 527
- 72103 527
- 72105 527
- 72107 527
- 72109 527
- 72111 527
- 72113 527
- 72115 527
- 72117 527
- 72119 527
- 72121 527
- 72123 527
- 72125 527
- 72127 527
- 72129 527
- 72131 527
- 72133 527
- 72135 527
- 72137 527
- 72139 527
- 72141 527
- 72143 527
- 72145 527
- 72149 527
- 72151 527
- 72153 527
- 72147 525
- 72093 516
- 72049 503
county 79
- Unknown 580
- Adjuntas 527
- Aguada 527
- Aguadilla 527
- Aguas Buenas 527
- Aibonito 527
- Anasco 527
- Arecibo 527
- Arroyo 527
- Barceloneta 527
- Barranquitas 527
- Bayamon 527
- Cabo Rojo 527
- Caguas 527
- Camuy 527
- Canovanas 527
- Carolina 527
- Catano 527
- Cayey 527
- Ceiba 527
- Ciales 527
- Cidra 527
- Coamo 527
- Comerio 527
- Corozal 527
- Dorado 527
- Fajardo 527
- Florida 527
- Guanica 527
- Guayama 527
- Guayanilla 527
- Guaynabo 527
- Gurabo 527
- Hatillo 527
- Hormigueros 527
- Humacao 527
- Isabela 527
- Jayuya 527
- Juana Diaz 527
- Juncos 527
- Lajas 527
- Lares 527
- Las Marias 527
- Las Piedras 527
- Loiza 527
- Luquillo 527
- Manati 527
- Maunabo 527
- Mayaguez 527
- Moca 527
- Morovis 527
- Naguabo 527
- Naranjito 527
- Orocovis 527
- Patillas 527
- Penuelas 527
- Ponce 527
- Quebradillas 527
- Rincon 527
- Rio Grande 527
- Sabana Grande 527
- Salinas 527
- San German 527
- San Juan 527
- San Lorenzo 527
- San Sebastian 527
- Santa Isabel 527
- Toa Alta 527
- Toa Baja 527
- Trujillo Alto 527
- Utuado 527
- Vega Alta 527
- Vega Baja 527
- Villalba 527
- Yabucoa 527
- Yauco 527
- Vieques 525
- Maricao 516
- Culebra 503
state 1
- Puerto Rico · 41,649 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1812449 | 1812449 | 2021-10-13 | Adjuntas | Puerto Rico | 72001 | 668 | |
1812450 | 1812450 | 2021-10-13 | Aguada | Puerto Rico | 72003 | 2415 | |
1812451 | 1812451 | 2021-10-13 | Aguadilla | Puerto Rico | 72005 | 3036 | |
1812452 | 1812452 | 2021-10-13 | Aguas Buenas | Puerto Rico | 72007 | 1630 | |
1812453 | 1812453 | 2021-10-13 | Aibonito | Puerto Rico | 72009 | 1021 | |
1812454 | 1812454 | 2021-10-13 | Anasco | Puerto Rico | 72011 | 1420 | |
1812455 | 1812455 | 2021-10-13 | Arecibo | Puerto Rico | 72013 | 4584 | |
1812456 | 1812456 | 2021-10-13 | Arroyo | Puerto Rico | 72015 | 545 | |
1812457 | 1812457 | 2021-10-13 | Barceloneta | Puerto Rico | 72017 | 1184 | |
1812458 | 1812458 | 2021-10-13 | Barranquitas | Puerto Rico | 72019 | 1846 | |
1812459 | 1812459 | 2021-10-13 | Bayamon | Puerto Rico | 72021 | 15686 | |
1812460 | 1812460 | 2021-10-13 | Cabo Rojo | Puerto Rico | 72023 | 1902 | |
1812461 | 1812461 | 2021-10-13 | Caguas | Puerto Rico | 72025 | 8890 | |
1812462 | 1812462 | 2021-10-13 | Camuy | Puerto Rico | 72027 | 1768 | |
1812463 | 1812463 | 2021-10-13 | Canovanas | Puerto Rico | 72029 | 3068 | |
1812464 | 1812464 | 2021-10-13 | Carolina | Puerto Rico | 72031 | 12935 | |
1812465 | 1812465 | 2021-10-13 | Catano | Puerto Rico | 72033 | 1911 | |
1812466 | 1812466 | 2021-10-13 | Cayey | Puerto Rico | 72035 | 1978 | |
1812467 | 1812467 | 2021-10-13 | Ceiba | Puerto Rico | 72037 | 663 | |
1812468 | 1812468 | 2021-10-13 | Ciales | Puerto Rico | 72039 | 1069 | |
1812469 | 1812469 | 2021-10-13 | Cidra | Puerto Rico | 72041 | 1893 | |
1812470 | 1812470 | 2021-10-13 | Coamo | Puerto Rico | 72043 | 1406 | |
1812471 | 1812471 | 2021-10-13 | Comerio | Puerto Rico | 72045 | 1056 | |
1812472 | 1812472 | 2021-10-13 | Corozal | Puerto Rico | 72047 | 2429 | |
1812473 | 1812473 | 2021-10-13 | Culebra | Puerto Rico | 72049 | 56 | |
1812474 | 1812474 | 2021-10-13 | Dorado | Puerto Rico | 72051 | 3369 | |
1812475 | 1812475 | 2021-10-13 | Fajardo | Puerto Rico | 72053 | 2158 | |
1812476 | 1812476 | 2021-10-13 | Florida | Puerto Rico | 72054 | 996 | |
1812477 | 1812477 | 2021-10-13 | Guanica | Puerto Rico | 72055 | 439 | |
1812478 | 1812478 | 2021-10-13 | Guayama | Puerto Rico | 72057 | 1348 | |
1812479 | 1812479 | 2021-10-13 | Guayanilla | Puerto Rico | 72059 | 679 | |
1812480 | 1812480 | 2021-10-13 | Guaynabo | Puerto Rico | 72061 | 6780 | |
1812481 | 1812481 | 2021-10-13 | Gurabo | Puerto Rico | 72063 | 3046 | |
1812482 | 1812482 | 2021-10-13 | Hatillo | Puerto Rico | 72065 | 1869 | |
1812483 | 1812483 | 2021-10-13 | Hormigueros | Puerto Rico | 72067 | 696 | |
1812484 | 1812484 | 2021-10-13 | Humacao | Puerto Rico | 72069 | 3018 | |
1812485 | 1812485 | 2021-10-13 | Isabela | Puerto Rico | 72071 | 2531 | |
1812486 | 1812486 | 2021-10-13 | Jayuya | Puerto Rico | 72073 | 647 | |
1812487 | 1812487 | 2021-10-13 | Juana Diaz | Puerto Rico | 72075 | 1745 | |
1812488 | 1812488 | 2021-10-13 | Juncos | Puerto Rico | 72077 | 2983 | |
1812489 | 1812489 | 2021-10-13 | Lajas | Puerto Rico | 72079 | 805 | |
1812490 | 1812490 | 2021-10-13 | Lares | Puerto Rico | 72081 | 1402 | |
1812491 | 1812491 | 2021-10-13 | Las Marias | Puerto Rico | 72083 | 404 | |
1812492 | 1812492 | 2021-10-13 | Las Piedras | Puerto Rico | 72085 | 2273 | |
1812493 | 1812493 | 2021-10-13 | Loiza | Puerto Rico | 72087 | 1728 | |
1812494 | 1812494 | 2021-10-13 | Luquillo | Puerto Rico | 72089 | 1240 | |
1812495 | 1812495 | 2021-10-13 | Manati | Puerto Rico | 72091 | 2338 | |
1812496 | 1812496 | 2021-10-13 | Maricao | Puerto Rico | 72093 | 178 | |
1812497 | 1812497 | 2021-10-13 | Maunabo | Puerto Rico | 72095 | 557 | |
1812498 | 1812498 | 2021-10-13 | Mayaguez | Puerto Rico | 72097 | 3862 | |
1812499 | 1812499 | 2021-10-13 | Moca | Puerto Rico | 72099 | 2409 | |
1812500 | 1812500 | 2021-10-13 | Morovis | Puerto Rico | 72101 | 1975 | |
1812501 | 1812501 | 2021-10-13 | Naguabo | Puerto Rico | 72103 | 1485 | |
1812502 | 1812502 | 2021-10-13 | Naranjito | Puerto Rico | 72105 | 2373 | |
1812503 | 1812503 | 2021-10-13 | Orocovis | Puerto Rico | 72107 | 1203 | |
1812504 | 1812504 | 2021-10-13 | Patillas | Puerto Rico | 72109 | 556 | |
1812505 | 1812505 | 2021-10-13 | Penuelas | Puerto Rico | 72111 | 782 | |
1812506 | 1812506 | 2021-10-13 | Ponce | Puerto Rico | 72113 | 5526 | |
1812507 | 1812507 | 2021-10-13 | Quebradillas | Puerto Rico | 72115 | 1343 | |
1812508 | 1812508 | 2021-10-13 | Rincon | Puerto Rico | 72117 | 917 | |
1812509 | 1812509 | 2021-10-13 | Rio Grande | Puerto Rico | 72119 | 3243 | |
1812510 | 1812510 | 2021-10-13 | Sabana Grande | Puerto Rico | 72121 | 760 | |
1812511 | 1812511 | 2021-10-13 | Salinas | Puerto Rico | 72123 | 1432 | |
1812512 | 1812512 | 2021-10-13 | San German | Puerto Rico | 72125 | 1120 | |
1812513 | 1812513 | 2021-10-13 | San Juan | Puerto Rico | 72127 | 28677 | |
1812514 | 1812514 | 2021-10-13 | San Lorenzo | Puerto Rico | 72129 | 2396 | |
1812515 | 1812515 | 2021-10-13 | San Sebastian | Puerto Rico | 72131 | 2503 | |
1812516 | 1812516 | 2021-10-13 | Santa Isabel | Puerto Rico | 72133 | 847 | |
1812517 | 1812517 | 2021-10-13 | Toa Alta | Puerto Rico | 72135 | 5698 | |
1812518 | 1812518 | 2021-10-13 | Toa Baja | Puerto Rico | 72137 | 6112 | |
1812519 | 1812519 | 2021-10-13 | Trujillo Alto | Puerto Rico | 72139 | 4540 | |
1812520 | 1812520 | 2021-10-13 | Unknown | Puerto Rico | 5407 | 3199 | |
1812521 | 1812521 | 2021-10-13 | Utuado | Puerto Rico | 72141 | 1365 | |
1812522 | 1812522 | 2021-10-13 | Vega Alta | Puerto Rico | 72143 | 2917 | |
1812523 | 1812523 | 2021-10-13 | Vega Baja | Puerto Rico | 72145 | 4391 | |
1812524 | 1812524 | 2021-10-13 | Vieques | Puerto Rico | 72147 | 266 | |
1812525 | 1812525 | 2021-10-13 | Villalba | Puerto Rico | 72149 | 1015 | |
1812526 | 1812526 | 2021-10-13 | Yabucoa | Puerto Rico | 72151 | 1628 | |
1812527 | 1812527 | 2021-10-13 | Yauco | Puerto Rico | 72153 | 1440 | |
1809200 | 1809200 | 2021-10-12 | Adjuntas | Puerto Rico | 72001 | 668 | |
1809201 | 1809201 | 2021-10-12 | Aguada | Puerto Rico | 72003 | 2414 | |
1809202 | 1809202 | 2021-10-12 | Aguadilla | Puerto Rico | 72005 | 3033 | |
1809203 | 1809203 | 2021-10-12 | Aguas Buenas | Puerto Rico | 72007 | 1630 | |
1809204 | 1809204 | 2021-10-12 | Aibonito | Puerto Rico | 72009 | 1021 | |
1809205 | 1809205 | 2021-10-12 | Anasco | Puerto Rico | 72011 | 1418 | |
1809206 | 1809206 | 2021-10-12 | Arecibo | Puerto Rico | 72013 | 4578 | |
1809207 | 1809207 | 2021-10-12 | Arroyo | Puerto Rico | 72015 | 545 | |
1809208 | 1809208 | 2021-10-12 | Barceloneta | Puerto Rico | 72017 | 1182 | |
1809209 | 1809209 | 2021-10-12 | Barranquitas | Puerto Rico | 72019 | 1846 | |
1809210 | 1809210 | 2021-10-12 | Bayamon | Puerto Rico | 72021 | 15672 | |
1809211 | 1809211 | 2021-10-12 | Cabo Rojo | Puerto Rico | 72023 | 1900 | |
1809212 | 1809212 | 2021-10-12 | Caguas | Puerto Rico | 72025 | 8884 | |
1809213 | 1809213 | 2021-10-12 | Camuy | Puerto Rico | 72027 | 1764 | |
1809214 | 1809214 | 2021-10-12 | Canovanas | Puerto Rico | 72029 | 3066 | |
1809215 | 1809215 | 2021-10-12 | Carolina | Puerto Rico | 72031 | 12923 | |
1809216 | 1809216 | 2021-10-12 | Catano | Puerto Rico | 72033 | 1908 | |
1809217 | 1809217 | 2021-10-12 | Cayey | Puerto Rico | 72035 | 1971 | |
1809218 | 1809218 | 2021-10-12 | Ceiba | Puerto Rico | 72037 | 663 | |
1809219 | 1809219 | 2021-10-12 | Ciales | Puerto Rico | 72039 | 1069 | |
1809220 | 1809220 | 2021-10-12 | Cidra | Puerto Rico | 72041 | 1891 |
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);