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
- - 350
- 72043 297
- 72045 297
- 72047 297
- 72051 297
- 72053 297
- 72054 297
- 72055 297
- 72057 297
- 72059 297
- 72061 297
- 72063 297
- 72065 297
- 72067 297
- 72069 297
- 72071 297
- 72073 297
- 72075 297
- 72077 297
- 72079 297
- 72081 297
- 72083 297
- 72085 297
- 72087 297
- 72089 297
- 72091 297
- 72095 297
- 72097 297
- 72099 297
- 72101 297
- 72103 297
- 72105 297
- 72107 297
- 72109 297
- 72111 297
- 72113 297
- 72115 297
- 72117 297
- 72119 297
- 72121 297
- 72123 297
- 72125 297
- 72127 297
- 72129 297
- 72131 297
- 72133 297
- 72135 297
- 72137 297
- 72139 297
- 72141 297
- 72143 297
- 72145 297
- 72149 297
- 72151 297
- 72153 297
- 72001 296
- 72003 296
- 72005 296
- 72007 296
- 72009 296
- 72011 296
- 72013 296
- 72015 296
- 72017 296
- 72019 296
- 72021 296
- 72023 296
- 72025 296
- 72027 296
- 72029 296
- 72031 296
- 72033 296
- 72035 296
- 72037 296
- 72039 296
- 72041 296
- 72147 295
- 72093 286
- 72049 273
county 79
- Unknown 350
- Coamo 297
- Comerio 297
- Corozal 297
- Dorado 297
- Fajardo 297
- Florida 297
- Guanica 297
- Guayama 297
- Guayanilla 297
- Guaynabo 297
- Gurabo 297
- Hatillo 297
- Hormigueros 297
- Humacao 297
- Isabela 297
- Jayuya 297
- Juana Diaz 297
- Juncos 297
- Lajas 297
- Lares 297
- Las Marias 297
- Las Piedras 297
- Loiza 297
- Luquillo 297
- Manati 297
- Maunabo 297
- Mayaguez 297
- Moca 297
- Morovis 297
- Naguabo 297
- Naranjito 297
- Orocovis 297
- Patillas 297
- Penuelas 297
- Ponce 297
- Quebradillas 297
- Rincon 297
- Rio Grande 297
- Sabana Grande 297
- Salinas 297
- San German 297
- San Juan 297
- San Lorenzo 297
- San Sebastian 297
- Santa Isabel 297
- Toa Alta 297
- Toa Baja 297
- Trujillo Alto 297
- Utuado 297
- Vega Alta 297
- Vega Baja 297
- Villalba 297
- Yabucoa 297
- Yauco 297
- Adjuntas 296
- Aguada 296
- Aguadilla 296
- Aguas Buenas 296
- Aibonito 296
- Anasco 296
- Arecibo 296
- Arroyo 296
- Barceloneta 296
- Barranquitas 296
- Bayamon 296
- Cabo Rojo 296
- Caguas 296
- Camuy 296
- Canovanas 296
- Carolina 296
- Catano 296
- Cayey 296
- Ceiba 296
- Ciales 296
- Cidra 296
- Vieques 295
- Maricao 286
- Culebra 273
state 1
- Puerto Rico · 23,458 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1065592 | 1065592 | 2021-02-25 | Coamo | Puerto Rico | 72043 | 943 | |
1065593 | 1065593 | 2021-02-25 | Comerio | Puerto Rico | 72045 | 675 | |
1065594 | 1065594 | 2021-02-25 | Corozal | Puerto Rico | 72047 | 1597 | |
1065595 | 1065595 | 2021-02-25 | Culebra | Puerto Rico | 72049 | 28 | |
1065596 | 1065596 | 2021-02-25 | Dorado | Puerto Rico | 72051 | 2144 | |
1065597 | 1065597 | 2021-02-25 | Fajardo | Puerto Rico | 72053 | 1270 | |
1065598 | 1065598 | 2021-02-25 | Florida | Puerto Rico | 72054 | 675 | |
1065599 | 1065599 | 2021-02-25 | Guanica | Puerto Rico | 72055 | 248 | |
1065600 | 1065600 | 2021-02-25 | Guayama | Puerto Rico | 72057 | 808 | |
1065601 | 1065601 | 2021-02-25 | Guayanilla | Puerto Rico | 72059 | 428 | |
1065602 | 1065602 | 2021-02-25 | Guaynabo | Puerto Rico | 72061 | 4365 | |
1065603 | 1065603 | 2021-02-25 | Gurabo | Puerto Rico | 72063 | 1839 | |
1065604 | 1065604 | 2021-02-25 | Hatillo | Puerto Rico | 72065 | 1040 | |
1065605 | 1065605 | 2021-02-25 | Hormigueros | Puerto Rico | 72067 | 409 | |
1065606 | 1065606 | 2021-02-25 | Humacao | Puerto Rico | 72069 | 1646 | |
1065607 | 1065607 | 2021-02-25 | Isabela | Puerto Rico | 72071 | 1218 | |
1065608 | 1065608 | 2021-02-25 | Jayuya | Puerto Rico | 72073 | 413 | |
1065609 | 1065609 | 2021-02-25 | Juana Diaz | Puerto Rico | 72075 | 1088 | |
1065610 | 1065610 | 2021-02-25 | Juncos | Puerto Rico | 72077 | 1726 | |
1065611 | 1065611 | 2021-02-25 | Lajas | Puerto Rico | 72079 | 411 | |
1065612 | 1065612 | 2021-02-25 | Lares | Puerto Rico | 72081 | 873 | |
1065613 | 1065613 | 2021-02-25 | Las Marias | Puerto Rico | 72083 | 203 | |
1065614 | 1065614 | 2021-02-25 | Las Piedras | Puerto Rico | 72085 | 1418 | |
1065615 | 1065615 | 2021-02-25 | Loiza | Puerto Rico | 72087 | 985 | |
1065616 | 1065616 | 2021-02-25 | Luquillo | Puerto Rico | 72089 | 665 | |
1065617 | 1065617 | 2021-02-25 | Manati | Puerto Rico | 72091 | 1538 | |
1065618 | 1065618 | 2021-02-25 | Maricao | Puerto Rico | 72093 | 117 | |
1065619 | 1065619 | 2021-02-25 | Maunabo | Puerto Rico | 72095 | 321 | |
1065620 | 1065620 | 2021-02-25 | Mayaguez | Puerto Rico | 72097 | 1956 | |
1065621 | 1065621 | 2021-02-25 | Moca | Puerto Rico | 72099 | 1375 | |
1065622 | 1065622 | 2021-02-25 | Morovis | Puerto Rico | 72101 | 1327 | |
1065623 | 1065623 | 2021-02-25 | Naguabo | Puerto Rico | 72103 | 780 | |
1065624 | 1065624 | 2021-02-25 | Naranjito | Puerto Rico | 72105 | 1578 | |
1065625 | 1065625 | 2021-02-25 | Orocovis | Puerto Rico | 72107 | 792 | |
1065626 | 1065626 | 2021-02-25 | Patillas | Puerto Rico | 72109 | 366 | |
1065627 | 1065627 | 2021-02-25 | Penuelas | Puerto Rico | 72111 | 527 | |
1065628 | 1065628 | 2021-02-25 | Ponce | Puerto Rico | 72113 | 3050 | |
1065629 | 1065629 | 2021-02-25 | Quebradillas | Puerto Rico | 72115 | 708 | |
1065630 | 1065630 | 2021-02-25 | Rincon | Puerto Rico | 72117 | 445 | |
1065631 | 1065631 | 2021-02-25 | Rio Grande | Puerto Rico | 72119 | 1774 | |
1065632 | 1065632 | 2021-02-25 | Sabana Grande | Puerto Rico | 72121 | 409 | |
1065633 | 1065633 | 2021-02-25 | Salinas | Puerto Rico | 72123 | 1010 | |
1065634 | 1065634 | 2021-02-25 | San German | Puerto Rico | 72125 | 609 | |
1065635 | 1065635 | 2021-02-25 | San Juan | Puerto Rico | 72127 | 17830 | |
1065636 | 1065636 | 2021-02-25 | San Lorenzo | Puerto Rico | 72129 | 1455 | |
1065637 | 1065637 | 2021-02-25 | San Sebastian | Puerto Rico | 72131 | 1646 | |
1065638 | 1065638 | 2021-02-25 | Santa Isabel | Puerto Rico | 72133 | 559 | |
1065639 | 1065639 | 2021-02-25 | Toa Alta | Puerto Rico | 72135 | 3666 | |
1065640 | 1065640 | 2021-02-25 | Toa Baja | Puerto Rico | 72137 | 3823 | |
1065641 | 1065641 | 2021-02-25 | Trujillo Alto | Puerto Rico | 72139 | 2885 | |
1065642 | 1065642 | 2021-02-25 | Unknown | Puerto Rico | 4418 | 2016 | |
1065643 | 1065643 | 2021-02-25 | Utuado | Puerto Rico | 72141 | 851 | |
1065644 | 1065644 | 2021-02-25 | Vega Alta | Puerto Rico | 72143 | 1819 | |
1065645 | 1065645 | 2021-02-25 | Vega Baja | Puerto Rico | 72145 | 2684 | |
1065646 | 1065646 | 2021-02-25 | Vieques | Puerto Rico | 72147 | 195 | |
1065647 | 1065647 | 2021-02-25 | Villalba | Puerto Rico | 72149 | 752 | |
1065648 | 1065648 | 2021-02-25 | Yabucoa | Puerto Rico | 72151 | 1006 | |
1065649 | 1065649 | 2021-02-25 | Yauco | Puerto Rico | 72153 | 996 | |
1062326 | 1062326 | 2021-02-24 | Adjuntas | Puerto Rico | 72001 | 462 | |
1062327 | 1062327 | 2021-02-24 | Aguada | Puerto Rico | 72003 | 1209 | |
1062328 | 1062328 | 2021-02-24 | Aguadilla | Puerto Rico | 72005 | 1490 | |
1062329 | 1062329 | 2021-02-24 | Aguas Buenas | Puerto Rico | 72007 | 1025 | |
1062330 | 1062330 | 2021-02-24 | Aibonito | Puerto Rico | 72009 | 574 | |
1062331 | 1062331 | 2021-02-24 | Anasco | Puerto Rico | 72011 | 811 | |
1062332 | 1062332 | 2021-02-24 | Arecibo | Puerto Rico | 72013 | 2844 | |
1062333 | 1062333 | 2021-02-24 | Arroyo | Puerto Rico | 72015 | 352 | |
1062334 | 1062334 | 2021-02-24 | Barceloneta | Puerto Rico | 72017 | 716 | |
1062335 | 1062335 | 2021-02-24 | Barranquitas | Puerto Rico | 72019 | 1210 | |
1062336 | 1062336 | 2021-02-24 | Bayamon | Puerto Rico | 72021 | 10063 | |
1062337 | 1062337 | 2021-02-24 | Cabo Rojo | Puerto Rico | 72023 | 915 | |
1062338 | 1062338 | 2021-02-24 | Caguas | Puerto Rico | 72025 | 5596 | |
1062339 | 1062339 | 2021-02-24 | Camuy | Puerto Rico | 72027 | 1108 | |
1062340 | 1062340 | 2021-02-24 | Canovanas | Puerto Rico | 72029 | 1750 | |
1062341 | 1062341 | 2021-02-24 | Carolina | Puerto Rico | 72031 | 7842 | |
1062342 | 1062342 | 2021-02-24 | Catano | Puerto Rico | 72033 | 1218 | |
1062343 | 1062343 | 2021-02-24 | Cayey | Puerto Rico | 72035 | 1292 | |
1062344 | 1062344 | 2021-02-24 | Ceiba | Puerto Rico | 72037 | 401 | |
1062345 | 1062345 | 2021-02-24 | Ciales | Puerto Rico | 72039 | 736 | |
1062346 | 1062346 | 2021-02-24 | Cidra | Puerto Rico | 72041 | 1213 | |
1062347 | 1062347 | 2021-02-24 | Coamo | Puerto Rico | 72043 | 941 | |
1062348 | 1062348 | 2021-02-24 | Comerio | Puerto Rico | 72045 | 675 | |
1062349 | 1062349 | 2021-02-24 | Corozal | Puerto Rico | 72047 | 1597 | |
1062350 | 1062350 | 2021-02-24 | Culebra | Puerto Rico | 72049 | 28 | |
1062351 | 1062351 | 2021-02-24 | Dorado | Puerto Rico | 72051 | 2142 | |
1062352 | 1062352 | 2021-02-24 | Fajardo | Puerto Rico | 72053 | 1269 | |
1062353 | 1062353 | 2021-02-24 | Florida | Puerto Rico | 72054 | 675 | |
1062354 | 1062354 | 2021-02-24 | Guanica | Puerto Rico | 72055 | 248 | |
1062355 | 1062355 | 2021-02-24 | Guayama | Puerto Rico | 72057 | 808 | |
1062356 | 1062356 | 2021-02-24 | Guayanilla | Puerto Rico | 72059 | 428 | |
1062357 | 1062357 | 2021-02-24 | Guaynabo | Puerto Rico | 72061 | 4364 | |
1062358 | 1062358 | 2021-02-24 | Gurabo | Puerto Rico | 72063 | 1839 | |
1062359 | 1062359 | 2021-02-24 | Hatillo | Puerto Rico | 72065 | 1039 | |
1062360 | 1062360 | 2021-02-24 | Hormigueros | Puerto Rico | 72067 | 409 | |
1062361 | 1062361 | 2021-02-24 | Humacao | Puerto Rico | 72069 | 1644 | |
1062362 | 1062362 | 2021-02-24 | Isabela | Puerto Rico | 72071 | 1217 | |
1062363 | 1062363 | 2021-02-24 | Jayuya | Puerto Rico | 72073 | 413 | |
1062364 | 1062364 | 2021-02-24 | Juana Diaz | Puerto Rico | 72075 | 1086 | |
1062365 | 1062365 | 2021-02-24 | Juncos | Puerto Rico | 72077 | 1721 | |
1062366 | 1062366 | 2021-02-24 | Lajas | Puerto Rico | 72079 | 411 | |
1062367 | 1062367 | 2021-02-24 | Lares | Puerto Rico | 72081 | 873 |
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);