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

42,439 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

county

state

  • Puerto Rico · 42,439 ✖
Link rowid date ▲ county state fips cases deaths
1844939 1844939 2021-10-23 Adjuntas Puerto Rico 72001 669  
1844940 1844940 2021-10-23 Aguada Puerto Rico 72003 2427  
1844941 1844941 2021-10-23 Aguadilla Puerto Rico 72005 3044  
1844942 1844942 2021-10-23 Aguas Buenas Puerto Rico 72007 1635  
1844943 1844943 2021-10-23 Aibonito Puerto Rico 72009 1032  
1844944 1844944 2021-10-23 Anasco Puerto Rico 72011 1422  
1844945 1844945 2021-10-23 Arecibo Puerto Rico 72013 4609  
1844946 1844946 2021-10-23 Arroyo Puerto Rico 72015 549  
1844947 1844947 2021-10-23 Barceloneta Puerto Rico 72017 1188  
1844948 1844948 2021-10-23 Barranquitas Puerto Rico 72019 1872  
1844949 1844949 2021-10-23 Bayamon Puerto Rico 72021 15795  
1844950 1844950 2021-10-23 Cabo Rojo Puerto Rico 72023 1911  
1844951 1844951 2021-10-23 Caguas Puerto Rico 72025 8917  
1844952 1844952 2021-10-23 Camuy Puerto Rico 72027 1779  
1844953 1844953 2021-10-23 Canovanas Puerto Rico 72029 3080  
1844954 1844954 2021-10-23 Carolina Puerto Rico 72031 12990  
1844955 1844955 2021-10-23 Catano Puerto Rico 72033 1922  
1844956 1844956 2021-10-23 Cayey Puerto Rico 72035 2024  
1844957 1844957 2021-10-23 Ceiba Puerto Rico 72037 667  
1844958 1844958 2021-10-23 Ciales Puerto Rico 72039 1073  
1844959 1844959 2021-10-23 Cidra Puerto Rico 72041 1907  
1844960 1844960 2021-10-23 Coamo Puerto Rico 72043 1416  
1844961 1844961 2021-10-23 Comerio Puerto Rico 72045 1064  
1844962 1844962 2021-10-23 Corozal Puerto Rico 72047 2462  
1844963 1844963 2021-10-23 Culebra Puerto Rico 72049 56  
1844964 1844964 2021-10-23 Dorado Puerto Rico 72051 3376  
1844965 1844965 2021-10-23 Fajardo Puerto Rico 72053 2170  
1844966 1844966 2021-10-23 Florida Puerto Rico 72054 997  
1844967 1844967 2021-10-23 Guanica Puerto Rico 72055 446  
1844968 1844968 2021-10-23 Guayama Puerto Rico 72057 1348  
1844969 1844969 2021-10-23 Guayanilla Puerto Rico 72059 684  
1844970 1844970 2021-10-23 Guaynabo Puerto Rico 72061 6821  
1844971 1844971 2021-10-23 Gurabo Puerto Rico 72063 3055  
1844972 1844972 2021-10-23 Hatillo Puerto Rico 72065 1892  
1844973 1844973 2021-10-23 Hormigueros Puerto Rico 72067 699  
1844974 1844974 2021-10-23 Humacao Puerto Rico 72069 3036  
1844975 1844975 2021-10-23 Isabela Puerto Rico 72071 2541  
1844976 1844976 2021-10-23 Jayuya Puerto Rico 72073 650  
1844977 1844977 2021-10-23 Juana Diaz Puerto Rico 72075 1752  
1844978 1844978 2021-10-23 Juncos Puerto Rico 72077 2987  
1844979 1844979 2021-10-23 Lajas Puerto Rico 72079 814  
1844980 1844980 2021-10-23 Lares Puerto Rico 72081 1406  
1844981 1844981 2021-10-23 Las Marias Puerto Rico 72083 404  
1844982 1844982 2021-10-23 Las Piedras Puerto Rico 72085 2281  
1844983 1844983 2021-10-23 Loiza Puerto Rico 72087 1735  
1844984 1844984 2021-10-23 Luquillo Puerto Rico 72089 1245  
1844985 1844985 2021-10-23 Manati Puerto Rico 72091 2345  
1844986 1844986 2021-10-23 Maricao Puerto Rico 72093 180  
1844987 1844987 2021-10-23 Maunabo Puerto Rico 72095 559  
1844988 1844988 2021-10-23 Mayaguez Puerto Rico 72097 3892  
1844989 1844989 2021-10-23 Moca Puerto Rico 72099 2421  
1844990 1844990 2021-10-23 Morovis Puerto Rico 72101 1978  
1844991 1844991 2021-10-23 Naguabo Puerto Rico 72103 1491  
1844992 1844992 2021-10-23 Naranjito Puerto Rico 72105 2378  
1844993 1844993 2021-10-23 Orocovis Puerto Rico 72107 1216  
1844994 1844994 2021-10-23 Patillas Puerto Rico 72109 558  
1844995 1844995 2021-10-23 Penuelas Puerto Rico 72111 787  
1844996 1844996 2021-10-23 Ponce Puerto Rico 72113 5616  
1844997 1844997 2021-10-23 Quebradillas Puerto Rico 72115 1349  
1844998 1844998 2021-10-23 Rincon Puerto Rico 72117 921  
1844999 1844999 2021-10-23 Rio Grande Puerto Rico 72119 3266  
1845000 1845000 2021-10-23 Sabana Grande Puerto Rico 72121 763  
1845001 1845001 2021-10-23 Salinas Puerto Rico 72123 1437  
1845002 1845002 2021-10-23 San German Puerto Rico 72125 1130  
1845003 1845003 2021-10-23 San Juan Puerto Rico 72127 28837  
1845004 1845004 2021-10-23 San Lorenzo Puerto Rico 72129 2404  
1845005 1845005 2021-10-23 San Sebastian Puerto Rico 72131 2511  
1845006 1845006 2021-10-23 Santa Isabel Puerto Rico 72133 858  
1845007 1845007 2021-10-23 Toa Alta Puerto Rico 72135 5726  
1845008 1845008 2021-10-23 Toa Baja Puerto Rico 72137 6135  
1845009 1845009 2021-10-23 Trujillo Alto Puerto Rico 72139 4552  
1845010 1845010 2021-10-23 Unknown Puerto Rico   5383 3220
1845011 1845011 2021-10-23 Utuado Puerto Rico 72141 1367  
1845012 1845012 2021-10-23 Vega Alta Puerto Rico 72143 2923  
1845013 1845013 2021-10-23 Vega Baja Puerto Rico 72145 4426  
1845014 1845014 2021-10-23 Vieques Puerto Rico 72147 269  
1845015 1845015 2021-10-23 Villalba Puerto Rico 72149 1016  
1845016 1845016 2021-10-23 Yabucoa Puerto Rico 72151 1630  
1845017 1845017 2021-10-23 Yauco Puerto Rico 72153 1450  
1841689 1841689 2021-10-22 Adjuntas Puerto Rico 72001 669  
1841690 1841690 2021-10-22 Aguada Puerto Rico 72003 2426  
1841691 1841691 2021-10-22 Aguadilla Puerto Rico 72005 3044  
1841692 1841692 2021-10-22 Aguas Buenas Puerto Rico 72007 1634  
1841693 1841693 2021-10-22 Aibonito Puerto Rico 72009 1032  
1841694 1841694 2021-10-22 Anasco Puerto Rico 72011 1422  
1841695 1841695 2021-10-22 Arecibo Puerto Rico 72013 4607  
1841696 1841696 2021-10-22 Arroyo Puerto Rico 72015 548  
1841697 1841697 2021-10-22 Barceloneta Puerto Rico 72017 1187  
1841698 1841698 2021-10-22 Barranquitas Puerto Rico 72019 1869  
1841699 1841699 2021-10-22 Bayamon Puerto Rico 72021 15781  
1841700 1841700 2021-10-22 Cabo Rojo Puerto Rico 72023 1909  
1841701 1841701 2021-10-22 Caguas Puerto Rico 72025 8913  
1841702 1841702 2021-10-22 Camuy Puerto Rico 72027 1778  
1841703 1841703 2021-10-22 Canovanas Puerto Rico 72029 3079  
1841704 1841704 2021-10-22 Carolina Puerto Rico 72031 12987  
1841705 1841705 2021-10-22 Catano Puerto Rico 72033 1921  
1841706 1841706 2021-10-22 Cayey Puerto Rico 72035 2021  
1841707 1841707 2021-10-22 Ceiba Puerto Rico 72037 667  
1841708 1841708 2021-10-22 Ciales Puerto Rico 72039 1073  
1841709 1841709 2021-10-22 Cidra Puerto Rico 72041 1904  

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