ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2021-11-19" 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 |
---|---|---|---|---|---|---|---|
1932677 | 1932677 | 2021-11-19 | Adjuntas | Puerto Rico | 72001 | 680 | |
1932678 | 1932678 | 2021-11-19 | Aguada | Puerto Rico | 72003 | 2452 | |
1932679 | 1932679 | 2021-11-19 | Aguadilla | Puerto Rico | 72005 | 3084 | |
1932680 | 1932680 | 2021-11-19 | Aguas Buenas | Puerto Rico | 72007 | 1649 | |
1932681 | 1932681 | 2021-11-19 | Aibonito | Puerto Rico | 72009 | 1057 | |
1932682 | 1932682 | 2021-11-19 | Anasco | Puerto Rico | 72011 | 1432 | |
1932683 | 1932683 | 2021-11-19 | Arecibo | Puerto Rico | 72013 | 4687 | |
1932684 | 1932684 | 2021-11-19 | Arroyo | Puerto Rico | 72015 | 554 | |
1932685 | 1932685 | 2021-11-19 | Barceloneta | Puerto Rico | 72017 | 1204 | |
1932686 | 1932686 | 2021-11-19 | Barranquitas | Puerto Rico | 72019 | 1934 | |
1932687 | 1932687 | 2021-11-19 | Bayamon | Puerto Rico | 72021 | 15987 | |
1932688 | 1932688 | 2021-11-19 | Cabo Rojo | Puerto Rico | 72023 | 1928 | |
1932689 | 1932689 | 2021-11-19 | Caguas | Puerto Rico | 72025 | 9041 | |
1932690 | 1932690 | 2021-11-19 | Camuy | Puerto Rico | 72027 | 1802 | |
1932691 | 1932691 | 2021-11-19 | Canovanas | Puerto Rico | 72029 | 3103 | |
1932692 | 1932692 | 2021-11-19 | Carolina | Puerto Rico | 72031 | 13105 | |
1932693 | 1932693 | 2021-11-19 | Catano | Puerto Rico | 72033 | 1957 | |
1932694 | 1932694 | 2021-11-19 | Cayey | Puerto Rico | 72035 | 2062 | |
1932695 | 1932695 | 2021-11-19 | Ceiba | Puerto Rico | 72037 | 672 | |
1932696 | 1932696 | 2021-11-19 | Ciales | Puerto Rico | 72039 | 1087 | |
1932697 | 1932697 | 2021-11-19 | Cidra | Puerto Rico | 72041 | 1948 | |
1932698 | 1932698 | 2021-11-19 | Coamo | Puerto Rico | 72043 | 1436 | |
1932699 | 1932699 | 2021-11-19 | Comerio | Puerto Rico | 72045 | 1073 | |
1932700 | 1932700 | 2021-11-19 | Corozal | Puerto Rico | 72047 | 2495 | |
1932701 | 1932701 | 2021-11-19 | Culebra | Puerto Rico | 72049 | 56 | |
1932702 | 1932702 | 2021-11-19 | Dorado | Puerto Rico | 72051 | 3397 | |
1932703 | 1932703 | 2021-11-19 | Fajardo | Puerto Rico | 72053 | 2187 | |
1932704 | 1932704 | 2021-11-19 | Florida | Puerto Rico | 72054 | 1005 | |
1932705 | 1932705 | 2021-11-19 | Guanica | Puerto Rico | 72055 | 455 | |
1932706 | 1932706 | 2021-11-19 | Guayama | Puerto Rico | 72057 | 1384 | |
1932707 | 1932707 | 2021-11-19 | Guayanilla | Puerto Rico | 72059 | 700 | |
1932708 | 1932708 | 2021-11-19 | Guaynabo | Puerto Rico | 72061 | 6894 | |
1932709 | 1932709 | 2021-11-19 | Gurabo | Puerto Rico | 72063 | 3117 | |
1932710 | 1932710 | 2021-11-19 | Hatillo | Puerto Rico | 72065 | 1916 | |
1932711 | 1932711 | 2021-11-19 | Hormigueros | Puerto Rico | 72067 | 709 | |
1932712 | 1932712 | 2021-11-19 | Humacao | Puerto Rico | 72069 | 3127 | |
1932713 | 1932713 | 2021-11-19 | Isabela | Puerto Rico | 72071 | 2577 | |
1932714 | 1932714 | 2021-11-19 | Jayuya | Puerto Rico | 72073 | 655 | |
1932715 | 1932715 | 2021-11-19 | Juana Diaz | Puerto Rico | 72075 | 1778 | |
1932716 | 1932716 | 2021-11-19 | Juncos | Puerto Rico | 72077 | 3016 | |
1932717 | 1932717 | 2021-11-19 | Lajas | Puerto Rico | 72079 | 831 | |
1932718 | 1932718 | 2021-11-19 | Lares | Puerto Rico | 72081 | 1415 | |
1932719 | 1932719 | 2021-11-19 | Las Marias | Puerto Rico | 72083 | 404 | |
1932720 | 1932720 | 2021-11-19 | Las Piedras | Puerto Rico | 72085 | 2292 | |
1932721 | 1932721 | 2021-11-19 | Loiza | Puerto Rico | 72087 | 1753 | |
1932722 | 1932722 | 2021-11-19 | Luquillo | Puerto Rico | 72089 | 1263 | |
1932723 | 1932723 | 2021-11-19 | Manati | Puerto Rico | 72091 | 2372 | |
1932724 | 1932724 | 2021-11-19 | Maricao | Puerto Rico | 72093 | 182 | |
1932725 | 1932725 | 2021-11-19 | Maunabo | Puerto Rico | 72095 | 569 | |
1932726 | 1932726 | 2021-11-19 | Mayaguez | Puerto Rico | 72097 | 3966 | |
1932727 | 1932727 | 2021-11-19 | Moca | Puerto Rico | 72099 | 2438 | |
1932728 | 1932728 | 2021-11-19 | Morovis | Puerto Rico | 72101 | 1994 | |
1932729 | 1932729 | 2021-11-19 | Naguabo | Puerto Rico | 72103 | 1508 | |
1932730 | 1932730 | 2021-11-19 | Naranjito | Puerto Rico | 72105 | 2406 | |
1932731 | 1932731 | 2021-11-19 | Orocovis | Puerto Rico | 72107 | 1243 | |
1932732 | 1932732 | 2021-11-19 | Patillas | Puerto Rico | 72109 | 562 | |
1932733 | 1932733 | 2021-11-19 | Penuelas | Puerto Rico | 72111 | 798 | |
1932734 | 1932734 | 2021-11-19 | Ponce | Puerto Rico | 72113 | 5719 | |
1932735 | 1932735 | 2021-11-19 | Quebradillas | Puerto Rico | 72115 | 1375 | |
1932736 | 1932736 | 2021-11-19 | Rincon | Puerto Rico | 72117 | 931 | |
1932737 | 1932737 | 2021-11-19 | Rio Grande | Puerto Rico | 72119 | 3308 | |
1932738 | 1932738 | 2021-11-19 | Sabana Grande | Puerto Rico | 72121 | 784 | |
1932739 | 1932739 | 2021-11-19 | Salinas | Puerto Rico | 72123 | 1454 | |
1932740 | 1932740 | 2021-11-19 | San German | Puerto Rico | 72125 | 1160 | |
1932741 | 1932741 | 2021-11-19 | San Juan | Puerto Rico | 72127 | 29344 | |
1932742 | 1932742 | 2021-11-19 | San Lorenzo | Puerto Rico | 72129 | 2437 | |
1932743 | 1932743 | 2021-11-19 | San Sebastian | Puerto Rico | 72131 | 2531 | |
1932744 | 1932744 | 2021-11-19 | Santa Isabel | Puerto Rico | 72133 | 876 | |
1932745 | 1932745 | 2021-11-19 | Toa Alta | Puerto Rico | 72135 | 5775 | |
1932746 | 1932746 | 2021-11-19 | Toa Baja | Puerto Rico | 72137 | 6185 | |
1932747 | 1932747 | 2021-11-19 | Trujillo Alto | Puerto Rico | 72139 | 4584 | |
1932748 | 1932748 | 2021-11-19 | Unknown | Puerto Rico | 5611 | 3260 | |
1932749 | 1932749 | 2021-11-19 | Utuado | Puerto Rico | 72141 | 1379 | |
1932750 | 1932750 | 2021-11-19 | Vega Alta | Puerto Rico | 72143 | 2944 | |
1932751 | 1932751 | 2021-11-19 | Vega Baja | Puerto Rico | 72145 | 4485 | |
1932752 | 1932752 | 2021-11-19 | Vieques | Puerto Rico | 72147 | 277 | |
1932753 | 1932753 | 2021-11-19 | Villalba | Puerto Rico | 72149 | 1029 | |
1932754 | 1932754 | 2021-11-19 | Yabucoa | Puerto Rico | 72151 | 1647 | |
1932755 | 1932755 | 2021-11-19 | Yauco | Puerto Rico | 72153 | 1478 |
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);