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 >30
county >30
- Unknown 622
- Adjuntas 569
- Aguada 569
- Aguadilla 569
- Aguas Buenas 569
- Aibonito 569
- Anasco 569
- Arecibo 569
- Arroyo 569
- Barceloneta 569
- Barranquitas 569
- Bayamon 569
- Cabo Rojo 569
- Caguas 569
- Camuy 569
- Canovanas 569
- Carolina 569
- Catano 569
- Cayey 569
- Ceiba 569
- Ciales 569
- Cidra 569
- Coamo 569
- Comerio 569
- Corozal 569
- Dorado 569
- Fajardo 569
- Florida 569
- Guanica 569
- Guayama 569
- …
state 1
- Puerto Rico · 44,967 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1948929 | 1948929 | 2021-11-24 | Adjuntas | Puerto Rico | 72001 | 684 | |
1948930 | 1948930 | 2021-11-24 | Aguada | Puerto Rico | 72003 | 2456 | |
1948931 | 1948931 | 2021-11-24 | Aguadilla | Puerto Rico | 72005 | 3090 | |
1948932 | 1948932 | 2021-11-24 | Aguas Buenas | Puerto Rico | 72007 | 1651 | |
1948933 | 1948933 | 2021-11-24 | Aibonito | Puerto Rico | 72009 | 1059 | |
1948934 | 1948934 | 2021-11-24 | Anasco | Puerto Rico | 72011 | 1432 | |
1948935 | 1948935 | 2021-11-24 | Arecibo | Puerto Rico | 72013 | 4689 | |
1948936 | 1948936 | 2021-11-24 | Arroyo | Puerto Rico | 72015 | 557 | |
1948937 | 1948937 | 2021-11-24 | Barceloneta | Puerto Rico | 72017 | 1209 | |
1948938 | 1948938 | 2021-11-24 | Barranquitas | Puerto Rico | 72019 | 1934 | |
1948939 | 1948939 | 2021-11-24 | Bayamon | Puerto Rico | 72021 | 15996 | |
1948940 | 1948940 | 2021-11-24 | Cabo Rojo | Puerto Rico | 72023 | 1933 | |
1948941 | 1948941 | 2021-11-24 | Caguas | Puerto Rico | 72025 | 9065 | |
1948942 | 1948942 | 2021-11-24 | Camuy | Puerto Rico | 72027 | 1804 | |
1948943 | 1948943 | 2021-11-24 | Canovanas | Puerto Rico | 72029 | 3113 | |
1948944 | 1948944 | 2021-11-24 | Carolina | Puerto Rico | 72031 | 13124 | |
1948945 | 1948945 | 2021-11-24 | Catano | Puerto Rico | 72033 | 1959 | |
1948946 | 1948946 | 2021-11-24 | Cayey | Puerto Rico | 72035 | 2067 | |
1948947 | 1948947 | 2021-11-24 | Ceiba | Puerto Rico | 72037 | 675 | |
1948948 | 1948948 | 2021-11-24 | Ciales | Puerto Rico | 72039 | 1088 | |
1948949 | 1948949 | 2021-11-24 | Cidra | Puerto Rico | 72041 | 1958 | |
1948950 | 1948950 | 2021-11-24 | Coamo | Puerto Rico | 72043 | 1442 | |
1948951 | 1948951 | 2021-11-24 | Comerio | Puerto Rico | 72045 | 1078 | |
1948952 | 1948952 | 2021-11-24 | Corozal | Puerto Rico | 72047 | 2496 | |
1948953 | 1948953 | 2021-11-24 | Culebra | Puerto Rico | 72049 | 56 | |
1948954 | 1948954 | 2021-11-24 | Dorado | Puerto Rico | 72051 | 3400 | |
1948955 | 1948955 | 2021-11-24 | Fajardo | Puerto Rico | 72053 | 2196 | |
1948956 | 1948956 | 2021-11-24 | Florida | Puerto Rico | 72054 | 1005 | |
1948957 | 1948957 | 2021-11-24 | Guanica | Puerto Rico | 72055 | 456 | |
1948958 | 1948958 | 2021-11-24 | Guayama | Puerto Rico | 72057 | 1390 | |
1948959 | 1948959 | 2021-11-24 | Guayanilla | Puerto Rico | 72059 | 703 | |
1948960 | 1948960 | 2021-11-24 | Guaynabo | Puerto Rico | 72061 | 6903 | |
1948961 | 1948961 | 2021-11-24 | Gurabo | Puerto Rico | 72063 | 3127 | |
1948962 | 1948962 | 2021-11-24 | Hatillo | Puerto Rico | 72065 | 1917 | |
1948963 | 1948963 | 2021-11-24 | Hormigueros | Puerto Rico | 72067 | 710 | |
1948964 | 1948964 | 2021-11-24 | Humacao | Puerto Rico | 72069 | 3133 | |
1948965 | 1948965 | 2021-11-24 | Isabela | Puerto Rico | 72071 | 2580 | |
1948966 | 1948966 | 2021-11-24 | Jayuya | Puerto Rico | 72073 | 655 | |
1948967 | 1948967 | 2021-11-24 | Juana Diaz | Puerto Rico | 72075 | 1781 | |
1948968 | 1948968 | 2021-11-24 | Juncos | Puerto Rico | 72077 | 3024 | |
1948969 | 1948969 | 2021-11-24 | Lajas | Puerto Rico | 72079 | 833 | |
1948970 | 1948970 | 2021-11-24 | Lares | Puerto Rico | 72081 | 1415 | |
1948971 | 1948971 | 2021-11-24 | Las Marias | Puerto Rico | 72083 | 404 | |
1948972 | 1948972 | 2021-11-24 | Las Piedras | Puerto Rico | 72085 | 2296 | |
1948973 | 1948973 | 2021-11-24 | Loiza | Puerto Rico | 72087 | 1757 | |
1948974 | 1948974 | 2021-11-24 | Luquillo | Puerto Rico | 72089 | 1263 | |
1948975 | 1948975 | 2021-11-24 | Manati | Puerto Rico | 72091 | 2374 | |
1948976 | 1948976 | 2021-11-24 | Maricao | Puerto Rico | 72093 | 182 | |
1948977 | 1948977 | 2021-11-24 | Maunabo | Puerto Rico | 72095 | 571 | |
1948978 | 1948978 | 2021-11-24 | Mayaguez | Puerto Rico | 72097 | 3986 | |
1948979 | 1948979 | 2021-11-24 | Moca | Puerto Rico | 72099 | 2442 | |
1948980 | 1948980 | 2021-11-24 | Morovis | Puerto Rico | 72101 | 1996 | |
1948981 | 1948981 | 2021-11-24 | Naguabo | Puerto Rico | 72103 | 1513 | |
1948982 | 1948982 | 2021-11-24 | Naranjito | Puerto Rico | 72105 | 2411 | |
1948983 | 1948983 | 2021-11-24 | Orocovis | Puerto Rico | 72107 | 1245 | |
1948984 | 1948984 | 2021-11-24 | Patillas | Puerto Rico | 72109 | 565 | |
1948985 | 1948985 | 2021-11-24 | Penuelas | Puerto Rico | 72111 | 798 | |
1948986 | 1948986 | 2021-11-24 | Ponce | Puerto Rico | 72113 | 5739 | |
1948987 | 1948987 | 2021-11-24 | Quebradillas | Puerto Rico | 72115 | 1375 | |
1948988 | 1948988 | 2021-11-24 | Rincon | Puerto Rico | 72117 | 932 | |
1948989 | 1948989 | 2021-11-24 | Rio Grande | Puerto Rico | 72119 | 3325 | |
1948990 | 1948990 | 2021-11-24 | Sabana Grande | Puerto Rico | 72121 | 785 | |
1948991 | 1948991 | 2021-11-24 | Salinas | Puerto Rico | 72123 | 1459 | |
1948992 | 1948992 | 2021-11-24 | San German | Puerto Rico | 72125 | 1160 | |
1948993 | 1948993 | 2021-11-24 | San Juan | Puerto Rico | 72127 | 29401 | |
1948994 | 1948994 | 2021-11-24 | San Lorenzo | Puerto Rico | 72129 | 2444 | |
1948995 | 1948995 | 2021-11-24 | San Sebastian | Puerto Rico | 72131 | 2541 | |
1948996 | 1948996 | 2021-11-24 | Santa Isabel | Puerto Rico | 72133 | 878 | |
1948997 | 1948997 | 2021-11-24 | Toa Alta | Puerto Rico | 72135 | 5791 | |
1948998 | 1948998 | 2021-11-24 | Toa Baja | Puerto Rico | 72137 | 6194 | |
1948999 | 1948999 | 2021-11-24 | Trujillo Alto | Puerto Rico | 72139 | 4588 | |
1949000 | 1949000 | 2021-11-24 | Unknown | Puerto Rico | 5678 | 3266 | |
1949001 | 1949001 | 2021-11-24 | Utuado | Puerto Rico | 72141 | 1381 | |
1949002 | 1949002 | 2021-11-24 | Vega Alta | Puerto Rico | 72143 | 2944 | |
1949003 | 1949003 | 2021-11-24 | Vega Baja | Puerto Rico | 72145 | 4490 | |
1949004 | 1949004 | 2021-11-24 | Vieques | Puerto Rico | 72147 | 277 | |
1949005 | 1949005 | 2021-11-24 | Villalba | Puerto Rico | 72149 | 1034 | |
1949006 | 1949006 | 2021-11-24 | Yabucoa | Puerto Rico | 72151 | 1650 | |
1949007 | 1949007 | 2021-11-24 | Yauco | Puerto Rico | 72153 | 1484 | |
1945678 | 1945678 | 2021-11-23 | Adjuntas | Puerto Rico | 72001 | 681 | |
1945679 | 1945679 | 2021-11-23 | Aguada | Puerto Rico | 72003 | 2454 | |
1945680 | 1945680 | 2021-11-23 | Aguadilla | Puerto Rico | 72005 | 3089 | |
1945681 | 1945681 | 2021-11-23 | Aguas Buenas | Puerto Rico | 72007 | 1650 | |
1945682 | 1945682 | 2021-11-23 | Aibonito | Puerto Rico | 72009 | 1058 | |
1945683 | 1945683 | 2021-11-23 | Anasco | Puerto Rico | 72011 | 1432 | |
1945684 | 1945684 | 2021-11-23 | Arecibo | Puerto Rico | 72013 | 4688 | |
1945685 | 1945685 | 2021-11-23 | Arroyo | Puerto Rico | 72015 | 557 | |
1945686 | 1945686 | 2021-11-23 | Barceloneta | Puerto Rico | 72017 | 1208 | |
1945687 | 1945687 | 2021-11-23 | Barranquitas | Puerto Rico | 72019 | 1934 | |
1945688 | 1945688 | 2021-11-23 | Bayamon | Puerto Rico | 72021 | 15994 | |
1945689 | 1945689 | 2021-11-23 | Cabo Rojo | Puerto Rico | 72023 | 1933 | |
1945690 | 1945690 | 2021-11-23 | Caguas | Puerto Rico | 72025 | 9059 | |
1945691 | 1945691 | 2021-11-23 | Camuy | Puerto Rico | 72027 | 1804 | |
1945692 | 1945692 | 2021-11-23 | Canovanas | Puerto Rico | 72029 | 3110 | |
1945693 | 1945693 | 2021-11-23 | Carolina | Puerto Rico | 72031 | 13120 | |
1945694 | 1945694 | 2021-11-23 | Catano | Puerto Rico | 72033 | 1959 | |
1945695 | 1945695 | 2021-11-23 | Cayey | Puerto Rico | 72035 | 2066 | |
1945696 | 1945696 | 2021-11-23 | Ceiba | Puerto Rico | 72037 | 675 | |
1945697 | 1945697 | 2021-11-23 | Ciales | Puerto Rico | 72039 | 1088 | |
1945698 | 1945698 | 2021-11-23 | Cidra | Puerto Rico | 72041 | 1957 |
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);