ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2020-11-24" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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 |
---|---|---|---|---|---|---|---|
763745 | 763745 | 2020-11-24 | Adjuntas | Puerto Rico | 72001 | 233 | |
763746 | 763746 | 2020-11-24 | Aguada | Puerto Rico | 72003 | 619 | |
763747 | 763747 | 2020-11-24 | Aguadilla | Puerto Rico | 72005 | 818 | |
763748 | 763748 | 2020-11-24 | Aguas Buenas | Puerto Rico | 72007 | 491 | |
763749 | 763749 | 2020-11-24 | Aibonito | Puerto Rico | 72009 | 289 | |
763750 | 763750 | 2020-11-24 | Anasco | Puerto Rico | 72011 | 468 | |
763751 | 763751 | 2020-11-24 | Arecibo | Puerto Rico | 72013 | 1487 | |
763752 | 763752 | 2020-11-24 | Arroyo | Puerto Rico | 72015 | 238 | |
763753 | 763753 | 2020-11-24 | Barceloneta | Puerto Rico | 72017 | 432 | |
763754 | 763754 | 2020-11-24 | Barranquitas | Puerto Rico | 72019 | 794 | |
763755 | 763755 | 2020-11-24 | Bayamon | Puerto Rico | 72021 | 6164 | |
763756 | 763756 | 2020-11-24 | Cabo Rojo | Puerto Rico | 72023 | 614 | |
763757 | 763757 | 2020-11-24 | Caguas | Puerto Rico | 72025 | 3057 | |
763758 | 763758 | 2020-11-24 | Camuy | Puerto Rico | 72027 | 602 | |
763759 | 763759 | 2020-11-24 | Canovanas | Puerto Rico | 72029 | 1117 | |
763760 | 763760 | 2020-11-24 | Carolina | Puerto Rico | 72031 | 5006 | |
763761 | 763761 | 2020-11-24 | Catano | Puerto Rico | 72033 | 763 | |
763762 | 763762 | 2020-11-24 | Cayey | Puerto Rico | 72035 | 698 | |
763763 | 763763 | 2020-11-24 | Ceiba | Puerto Rico | 72037 | 234 | |
763764 | 763764 | 2020-11-24 | Ciales | Puerto Rico | 72039 | 470 | |
763765 | 763765 | 2020-11-24 | Cidra | Puerto Rico | 72041 | 584 | |
763766 | 763766 | 2020-11-24 | Coamo | Puerto Rico | 72043 | 525 | |
763767 | 763767 | 2020-11-24 | Comerio | Puerto Rico | 72045 | 376 | |
763768 | 763768 | 2020-11-24 | Corozal | Puerto Rico | 72047 | 1110 | |
763769 | 763769 | 2020-11-24 | Culebra | Puerto Rico | 72049 | 25 | |
763770 | 763770 | 2020-11-24 | Dorado | Puerto Rico | 72051 | 1410 | |
763771 | 763771 | 2020-11-24 | Fajardo | Puerto Rico | 72053 | 839 | |
763772 | 763772 | 2020-11-24 | Florida | Puerto Rico | 72054 | 493 | |
763773 | 763773 | 2020-11-24 | Guanica | Puerto Rico | 72055 | 197 | |
763774 | 763774 | 2020-11-24 | Guayama | Puerto Rico | 72057 | 510 | |
763775 | 763775 | 2020-11-24 | Guayanilla | Puerto Rico | 72059 | 300 | |
763776 | 763776 | 2020-11-24 | Guaynabo | Puerto Rico | 72061 | 2843 | |
763777 | 763777 | 2020-11-24 | Gurabo | Puerto Rico | 72063 | 1002 | |
763778 | 763778 | 2020-11-24 | Hatillo | Puerto Rico | 72065 | 576 | |
763779 | 763779 | 2020-11-24 | Hormigueros | Puerto Rico | 72067 | 269 | |
763780 | 763780 | 2020-11-24 | Humacao | Puerto Rico | 72069 | 972 | |
763781 | 763781 | 2020-11-24 | Isabela | Puerto Rico | 72071 | 593 | |
763782 | 763782 | 2020-11-24 | Jayuya | Puerto Rico | 72073 | 348 | |
763783 | 763783 | 2020-11-24 | Juana Diaz | Puerto Rico | 72075 | 614 | |
763784 | 763784 | 2020-11-24 | Juncos | Puerto Rico | 72077 | 785 | |
763785 | 763785 | 2020-11-24 | Lajas | Puerto Rico | 72079 | 254 | |
763786 | 763786 | 2020-11-24 | Lares | Puerto Rico | 72081 | 606 | |
763787 | 763787 | 2020-11-24 | Las Marias | Puerto Rico | 72083 | 149 | |
763788 | 763788 | 2020-11-24 | Las Piedras | Puerto Rico | 72085 | 831 | |
763789 | 763789 | 2020-11-24 | Loiza | Puerto Rico | 72087 | 505 | |
763790 | 763790 | 2020-11-24 | Luquillo | Puerto Rico | 72089 | 386 | |
763791 | 763791 | 2020-11-24 | Manati | Puerto Rico | 72091 | 957 | |
763792 | 763792 | 2020-11-24 | Maricao | Puerto Rico | 72093 | 99 | |
763793 | 763793 | 2020-11-24 | Maunabo | Puerto Rico | 72095 | 198 | |
763794 | 763794 | 2020-11-24 | Mayaguez | Puerto Rico | 72097 | 1246 | |
763795 | 763795 | 2020-11-24 | Moca | Puerto Rico | 72099 | 737 | |
763796 | 763796 | 2020-11-24 | Morovis | Puerto Rico | 72101 | 771 | |
763797 | 763797 | 2020-11-24 | Naguabo | Puerto Rico | 72103 | 466 | |
763798 | 763798 | 2020-11-24 | Naranjito | Puerto Rico | 72105 | 998 | |
763799 | 763799 | 2020-11-24 | Orocovis | Puerto Rico | 72107 | 514 | |
763800 | 763800 | 2020-11-24 | Patillas | Puerto Rico | 72109 | 249 | |
763801 | 763801 | 2020-11-24 | Penuelas | Puerto Rico | 72111 | 259 | |
763802 | 763802 | 2020-11-24 | Ponce | Puerto Rico | 72113 | 1592 | |
763803 | 763803 | 2020-11-24 | Quebradillas | Puerto Rico | 72115 | 383 | |
763804 | 763804 | 2020-11-24 | Rincon | Puerto Rico | 72117 | 288 | |
763805 | 763805 | 2020-11-24 | Rio Grande | Puerto Rico | 72119 | 1029 | |
763806 | 763806 | 2020-11-24 | Sabana Grande | Puerto Rico | 72121 | 266 | |
763807 | 763807 | 2020-11-24 | Salinas | Puerto Rico | 72123 | 693 | |
763808 | 763808 | 2020-11-24 | San German | Puerto Rico | 72125 | 388 | |
763809 | 763809 | 2020-11-24 | San Juan | Puerto Rico | 72127 | 12463 | |
763810 | 763810 | 2020-11-24 | San Lorenzo | Puerto Rico | 72129 | 897 | |
763811 | 763811 | 2020-11-24 | San Sebastian | Puerto Rico | 72131 | 1101 | |
763812 | 763812 | 2020-11-24 | Santa Isabel | Puerto Rico | 72133 | 345 | |
763813 | 763813 | 2020-11-24 | Toa Alta | Puerto Rico | 72135 | 2279 | |
763814 | 763814 | 2020-11-24 | Toa Baja | Puerto Rico | 72137 | 2516 | |
763815 | 763815 | 2020-11-24 | Trujillo Alto | Puerto Rico | 72139 | 1978 | |
763816 | 763816 | 2020-11-24 | Unknown | Puerto Rico | 2682 | 1038 | |
763817 | 763817 | 2020-11-24 | Utuado | Puerto Rico | 72141 | 406 | |
763818 | 763818 | 2020-11-24 | Vega Alta | Puerto Rico | 72143 | 1210 | |
763819 | 763819 | 2020-11-24 | Vega Baja | Puerto Rico | 72145 | 1593 | |
763820 | 763820 | 2020-11-24 | Vieques | Puerto Rico | 72147 | 108 | |
763821 | 763821 | 2020-11-24 | Villalba | Puerto Rico | 72149 | 468 | |
763822 | 763822 | 2020-11-24 | Yabucoa | Puerto Rico | 72151 | 563 | |
763823 | 763823 | 2020-11-24 | Yauco | Puerto Rico | 72153 | 725 |
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);