ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where "date" is on date 2020-09-19 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adjuntas 1
- Aguada 1
- Aguadilla 1
- Aguas Buenas 1
- Aibonito 1
- Anasco 1
- Arecibo 1
- Arroyo 1
- Barceloneta 1
- Barranquitas 1
- Bayamon 1
- Cabo Rojo 1
- Caguas 1
- Camuy 1
- Canovanas 1
- Carolina 1
- Catano 1
- Cayey 1
- Ceiba 1
- Ciales 1
- Cidra 1
- Coamo 1
- Comerio 1
- Corozal 1
- Culebra 1
- Dorado 1
- Fajardo 1
- Florida 1
- Guanica 1
- Guayama 1
- …
state 1
- Puerto Rico · 79 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
549693 | 549693 | 2020-09-19 | Adjuntas | Puerto Rico | 72001 | 142 | |
549694 | 549694 | 2020-09-19 | Aguada | Puerto Rico | 72003 | 305 | |
549695 | 549695 | 2020-09-19 | Aguadilla | Puerto Rico | 72005 | 406 | |
549696 | 549696 | 2020-09-19 | Aguas Buenas | Puerto Rico | 72007 | 245 | |
549697 | 549697 | 2020-09-19 | Aibonito | Puerto Rico | 72009 | 145 | |
549698 | 549698 | 2020-09-19 | Anasco | Puerto Rico | 72011 | 217 | |
549699 | 549699 | 2020-09-19 | Arecibo | Puerto Rico | 72013 | 691 | |
549700 | 549700 | 2020-09-19 | Arroyo | Puerto Rico | 72015 | 159 | |
549701 | 549701 | 2020-09-19 | Barceloneta | Puerto Rico | 72017 | 203 | |
549702 | 549702 | 2020-09-19 | Barranquitas | Puerto Rico | 72019 | 406 | |
549703 | 549703 | 2020-09-19 | Bayamon | Puerto Rico | 72021 | 3242 | |
549704 | 549704 | 2020-09-19 | Cabo Rojo | Puerto Rico | 72023 | 309 | |
549705 | 549705 | 2020-09-19 | Caguas | Puerto Rico | 72025 | 1394 | |
549706 | 549706 | 2020-09-19 | Camuy | Puerto Rico | 72027 | 233 | |
549707 | 549707 | 2020-09-19 | Canovanas | Puerto Rico | 72029 | 619 | |
549708 | 549708 | 2020-09-19 | Carolina | Puerto Rico | 72031 | 2344 | |
549709 | 549709 | 2020-09-19 | Catano | Puerto Rico | 72033 | 390 | |
549710 | 549710 | 2020-09-19 | Cayey | Puerto Rico | 72035 | 320 | |
549711 | 549711 | 2020-09-19 | Ceiba | Puerto Rico | 72037 | 107 | |
549712 | 549712 | 2020-09-19 | Ciales | Puerto Rico | 72039 | 212 | |
549713 | 549713 | 2020-09-19 | Cidra | Puerto Rico | 72041 | 285 | |
549714 | 549714 | 2020-09-19 | Coamo | Puerto Rico | 72043 | 258 | |
549715 | 549715 | 2020-09-19 | Comerio | Puerto Rico | 72045 | 222 | |
549716 | 549716 | 2020-09-19 | Corozal | Puerto Rico | 72047 | 540 | |
549717 | 549717 | 2020-09-19 | Culebra | Puerto Rico | 72049 | 22 | |
549718 | 549718 | 2020-09-19 | Dorado | Puerto Rico | 72051 | 652 | |
549719 | 549719 | 2020-09-19 | Fajardo | Puerto Rico | 72053 | 466 | |
549720 | 549720 | 2020-09-19 | Florida | Puerto Rico | 72054 | 242 | |
549721 | 549721 | 2020-09-19 | Guanica | Puerto Rico | 72055 | 92 | |
549722 | 549722 | 2020-09-19 | Guayama | Puerto Rico | 72057 | 276 | |
549723 | 549723 | 2020-09-19 | Guayanilla | Puerto Rico | 72059 | 159 | |
549724 | 549724 | 2020-09-19 | Guaynabo | Puerto Rico | 72061 | 1516 | |
549725 | 549725 | 2020-09-19 | Gurabo | Puerto Rico | 72063 | 470 | |
549726 | 549726 | 2020-09-19 | Hatillo | Puerto Rico | 72065 | 236 | |
549727 | 549727 | 2020-09-19 | Hormigueros | Puerto Rico | 72067 | 153 | |
549728 | 549728 | 2020-09-19 | Humacao | Puerto Rico | 72069 | 435 | |
549729 | 549729 | 2020-09-19 | Isabela | Puerto Rico | 72071 | 242 | |
549730 | 549730 | 2020-09-19 | Jayuya | Puerto Rico | 72073 | 219 | |
549731 | 549731 | 2020-09-19 | Juana Diaz | Puerto Rico | 72075 | 313 | |
549732 | 549732 | 2020-09-19 | Juncos | Puerto Rico | 72077 | 330 | |
549733 | 549733 | 2020-09-19 | Lajas | Puerto Rico | 72079 | 133 | |
549734 | 549734 | 2020-09-19 | Lares | Puerto Rico | 72081 | 299 | |
549735 | 549735 | 2020-09-19 | Las Marias | Puerto Rico | 72083 | 95 | |
549736 | 549736 | 2020-09-19 | Las Piedras | Puerto Rico | 72085 | 418 | |
549737 | 549737 | 2020-09-19 | Loiza | Puerto Rico | 72087 | 230 | |
549738 | 549738 | 2020-09-19 | Luquillo | Puerto Rico | 72089 | 218 | |
549739 | 549739 | 2020-09-19 | Manati | Puerto Rico | 72091 | 485 | |
549740 | 549740 | 2020-09-19 | Maricao | Puerto Rico | 72093 | 78 | |
549741 | 549741 | 2020-09-19 | Maunabo | Puerto Rico | 72095 | 107 | |
549742 | 549742 | 2020-09-19 | Mayaguez | Puerto Rico | 72097 | 742 | |
549743 | 549743 | 2020-09-19 | Moca | Puerto Rico | 72099 | 321 | |
549744 | 549744 | 2020-09-19 | Morovis | Puerto Rico | 72101 | 480 | |
549745 | 549745 | 2020-09-19 | Naguabo | Puerto Rico | 72103 | 182 | |
549746 | 549746 | 2020-09-19 | Naranjito | Puerto Rico | 72105 | 551 | |
549747 | 549747 | 2020-09-19 | Orocovis | Puerto Rico | 72107 | 308 | |
549748 | 549748 | 2020-09-19 | Patillas | Puerto Rico | 72109 | 165 | |
549749 | 549749 | 2020-09-19 | Penuelas | Puerto Rico | 72111 | 107 | |
549750 | 549750 | 2020-09-19 | Ponce | Puerto Rico | 72113 | 776 | |
549751 | 549751 | 2020-09-19 | Quebradillas | Puerto Rico | 72115 | 152 | |
549752 | 549752 | 2020-09-19 | Rincon | Puerto Rico | 72117 | 157 | |
549753 | 549753 | 2020-09-19 | Rio Grande | Puerto Rico | 72119 | 526 | |
549754 | 549754 | 2020-09-19 | Sabana Grande | Puerto Rico | 72121 | 187 | |
549755 | 549755 | 2020-09-19 | Salinas | Puerto Rico | 72123 | 387 | |
549756 | 549756 | 2020-09-19 | San German | Puerto Rico | 72125 | 228 | |
549757 | 549757 | 2020-09-19 | San Juan | Puerto Rico | 72127 | 6591 | |
549758 | 549758 | 2020-09-19 | San Lorenzo | Puerto Rico | 72129 | 415 | |
549759 | 549759 | 2020-09-19 | San Sebastian | Puerto Rico | 72131 | 333 | |
549760 | 549760 | 2020-09-19 | Santa Isabel | Puerto Rico | 72133 | 160 | |
549761 | 549761 | 2020-09-19 | Toa Alta | Puerto Rico | 72135 | 1149 | |
549762 | 549762 | 2020-09-19 | Toa Baja | Puerto Rico | 72137 | 1127 | |
549763 | 549763 | 2020-09-19 | Trujillo Alto | Puerto Rico | 72139 | 929 | |
549764 | 549764 | 2020-09-19 | Unknown | Puerto Rico | 1333 | 605 | |
549765 | 549765 | 2020-09-19 | Utuado | Puerto Rico | 72141 | 127 | |
549766 | 549766 | 2020-09-19 | Vega Alta | Puerto Rico | 72143 | 607 | |
549767 | 549767 | 2020-09-19 | Vega Baja | Puerto Rico | 72145 | 844 | |
549768 | 549768 | 2020-09-19 | Vieques | Puerto Rico | 72147 | 86 | |
549769 | 549769 | 2020-09-19 | Villalba | Puerto Rico | 72149 | 127 | |
549770 | 549770 | 2020-09-19 | Yabucoa | Puerto Rico | 72151 | 259 | |
549771 | 549771 | 2020-09-19 | Yauco | Puerto Rico | 72153 | 357 |
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);