ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

county >30

state 1

  • Puerto Rico · 58,397 ✖
Link rowid date ▲ county state fips cases deaths
2501914 2501914 2022-05-13 Adjuntas Puerto Rico 72001 2814  
2501915 2501915 2022-05-13 Aguada Puerto Rico 72003 7628  
2501916 2501916 2022-05-13 Aguadilla Puerto Rico 72005 8584  
2501917 2501917 2022-05-13 Aguas Buenas Puerto Rico 72007 4744  
2501918 2501918 2022-05-13 Aibonito Puerto Rico 72009 4296  
2501919 2501919 2022-05-13 Anasco Puerto Rico 72011 4474  
2501920 2501920 2022-05-13 Arecibo Puerto Rico 72013 15133  
2501921 2501921 2022-05-13 Arroyo Puerto Rico 72015 2760  
2501922 2501922 2022-05-13 Barceloneta Puerto Rico 72017 4087  
2501923 2501923 2022-05-13 Barranquitas Puerto Rico 72019 5533  
2501924 2501924 2022-05-13 Bayamon Puerto Rico 72021 39631  
2501925 2501925 2022-05-13 Cabo Rojo Puerto Rico 72023 6653  
2501926 2501926 2022-05-13 Caguas Puerto Rico 72025 25226  
2501927 2501927 2022-05-13 Camuy Puerto Rico 72027 6042  
2501928 2501928 2022-05-13 Canovanas Puerto Rico 72029 7464  
2501929 2501929 2022-05-13 Carolina Puerto Rico 72031 32563  
2501930 2501930 2022-05-13 Catano Puerto Rico 72033 4771  
2501931 2501931 2022-05-13 Cayey Puerto Rico 72035 7260  
2501932 2501932 2022-05-13 Ceiba Puerto Rico 72037 1697  
2501933 2501933 2022-05-13 Ciales Puerto Rico 72039 3037  
2501934 2501934 2022-05-13 Cidra Puerto Rico 72041 7154  
2501935 2501935 2022-05-13 Coamo Puerto Rico 72043 5973  
2501936 2501936 2022-05-13 Comerio Puerto Rico 72045 3361  
2501937 2501937 2022-05-13 Corozal Puerto Rico 72047 7239  
2501938 2501938 2022-05-13 Culebra Puerto Rico 72049 208  
2501939 2501939 2022-05-13 Dorado Puerto Rico 72051 7845  
2501940 2501940 2022-05-13 Fajardo Puerto Rico 72053 5408  
2501941 2501941 2022-05-13 Florida Puerto Rico 72054 2900  
2501942 2501942 2022-05-13 Guanica Puerto Rico 72055 1805  
2501943 2501943 2022-05-13 Guayama Puerto Rico 72057 6344  
2501944 2501944 2022-05-13 Guayanilla Puerto Rico 72059 2808  
2501945 2501945 2022-05-13 Guaynabo Puerto Rico 72061 18499  
2501946 2501946 2022-05-13 Gurabo Puerto Rico 72063 8681  
2501947 2501947 2022-05-13 Hatillo Puerto Rico 72065 6305  
2501948 2501948 2022-05-13 Hormigueros Puerto Rico 72067 2477  
2501949 2501949 2022-05-13 Humacao Puerto Rico 72069 9262  
2501950 2501950 2022-05-13 Isabela Puerto Rico 72071 7653  
2501951 2501951 2022-05-13 Jayuya Puerto Rico 72073 2896  
2501952 2501952 2022-05-13 Juana Diaz Puerto Rico 72075 7671  
2501953 2501953 2022-05-13 Juncos Puerto Rico 72077 7321  
2501954 2501954 2022-05-13 Lajas Puerto Rico 72079 3359  
2501955 2501955 2022-05-13 Lares Puerto Rico 72081 5066  
2501956 2501956 2022-05-13 Las Marias Puerto Rico 72083 1391  
2501957 2501957 2022-05-13 Las Piedras Puerto Rico 72085 6386  
2501958 2501958 2022-05-13 Loiza Puerto Rico 72087 3826  
2501959 2501959 2022-05-13 Luquillo Puerto Rico 72089 2927  
2501960 2501960 2022-05-13 Manati Puerto Rico 72091 7181  
2501961 2501961 2022-05-13 Maricao Puerto Rico 72093 713  
2501962 2501962 2022-05-13 Maunabo Puerto Rico 72095 1650  
2501963 2501963 2022-05-13 Mayaguez Puerto Rico 72097 11801  
2501964 2501964 2022-05-13 Moca Puerto Rico 72099 7148  
2501965 2501965 2022-05-13 Morovis Puerto Rico 72101 5624  
2501966 2501966 2022-05-13 Naguabo Puerto Rico 72103 3931  
2501967 2501967 2022-05-13 Naranjito Puerto Rico 72105 5810  
2501968 2501968 2022-05-13 Orocovis Puerto Rico 72107 3471  
2501969 2501969 2022-05-13 Patillas Puerto Rico 72109 2777  
2501970 2501970 2022-05-13 Penuelas Puerto Rico 72111 2790  
2501971 2501971 2022-05-13 Ponce Puerto Rico 72113 21975  
2501972 2501972 2022-05-13 Quebradillas Puerto Rico 72115 4777  
2501973 2501973 2022-05-13 Rincon Puerto Rico 72117 2580  
2501974 2501974 2022-05-13 Rio Grande Puerto Rico 72119 8656  
2501975 2501975 2022-05-13 Sabana Grande Puerto Rico 72121 3011  
2501976 2501976 2022-05-13 Salinas Puerto Rico 72123 4249  
2501977 2501977 2022-05-13 San German Puerto Rico 72125 4688  
2501978 2501978 2022-05-13 San Juan Puerto Rico 72127 67510  
2501979 2501979 2022-05-13 San Lorenzo Puerto Rico 72129 6464  
2501980 2501980 2022-05-13 San Sebastian Puerto Rico 72131 7266  
2501981 2501981 2022-05-13 Santa Isabel Puerto Rico 72133 3332  
2501982 2501982 2022-05-13 Toa Alta Puerto Rico 72135 13849  
2501983 2501983 2022-05-13 Toa Baja Puerto Rico 72137 14817  
2501984 2501984 2022-05-13 Trujillo Alto Puerto Rico 72139 11751  
2501985 2501985 2022-05-13 Unknown Puerto Rico   21064 4250
2501986 2501986 2022-05-13 Utuado Puerto Rico 72141 4103  
2501987 2501987 2022-05-13 Vega Alta Puerto Rico 72143 7178  
2501988 2501988 2022-05-13 Vega Baja Puerto Rico 72145 11916  
2501989 2501989 2022-05-13 Vieques Puerto Rico 72147 935  
2501990 2501990 2022-05-13 Villalba Puerto Rico 72149 3999  
2501991 2501991 2022-05-13 Yabucoa Puerto Rico 72151 5508  
2501992 2501992 2022-05-13 Yauco Puerto Rico 72153 5442  
2498656 2498656 2022-05-12 Adjuntas Puerto Rico 72001 2781  
2498657 2498657 2022-05-12 Aguada Puerto Rico 72003 7524  
2498658 2498658 2022-05-12 Aguadilla Puerto Rico 72005 8523  
2498659 2498659 2022-05-12 Aguas Buenas Puerto Rico 72007 4697  
2498660 2498660 2022-05-12 Aibonito Puerto Rico 72009 4265  
2498661 2498661 2022-05-12 Anasco Puerto Rico 72011 4444  
2498662 2498662 2022-05-12 Arecibo Puerto Rico 72013 15042  
2498663 2498663 2022-05-12 Arroyo Puerto Rico 72015 2691  
2498664 2498664 2022-05-12 Barceloneta Puerto Rico 72017 4053  
2498665 2498665 2022-05-12 Barranquitas Puerto Rico 72019 5487  
2498666 2498666 2022-05-12 Bayamon Puerto Rico 72021 39367  
2498667 2498667 2022-05-12 Cabo Rojo Puerto Rico 72023 6582  
2498668 2498668 2022-05-12 Caguas Puerto Rico 72025 25063  
2498669 2498669 2022-05-12 Camuy Puerto Rico 72027 5988  
2498670 2498670 2022-05-12 Canovanas Puerto Rico 72029 7402  
2498671 2498671 2022-05-12 Carolina Puerto Rico 72031 32314  
2498672 2498672 2022-05-12 Catano Puerto Rico 72033 4748  
2498673 2498673 2022-05-12 Cayey Puerto Rico 72035 7199  
2498674 2498674 2022-05-12 Ceiba Puerto Rico 72037 1683  
2498675 2498675 2022-05-12 Ciales Puerto Rico 72039 3030  
2498676 2498676 2022-05-12 Cidra Puerto Rico 72041 7062  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);