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

23,558 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 · 23,558 ✖
Link rowid date ▲ county state fips cases deaths
1068816 1068816 2021-02-26 Adjuntas Puerto Rico 72001 462  
1068817 1068817 2021-02-26 Aguada Puerto Rico 72003 1209  
1068818 1068818 2021-02-26 Aguadilla Puerto Rico 72005 1493  
1068819 1068819 2021-02-26 Aguas Buenas Puerto Rico 72007 1025  
1068820 1068820 2021-02-26 Aibonito Puerto Rico 72009 576  
1068821 1068821 2021-02-26 Anasco Puerto Rico 72011 814  
1068822 1068822 2021-02-26 Arecibo Puerto Rico 72013 2854  
1068823 1068823 2021-02-26 Arroyo Puerto Rico 72015 353  
1068824 1068824 2021-02-26 Barceloneta Puerto Rico 72017 718  
1068825 1068825 2021-02-26 Barranquitas Puerto Rico 72019 1213  
1068826 1068826 2021-02-26 Bayamon Puerto Rico 72021 10079  
1068827 1068827 2021-02-26 Cabo Rojo Puerto Rico 72023 919  
1068828 1068828 2021-02-26 Caguas Puerto Rico 72025 5614  
1068829 1068829 2021-02-26 Camuy Puerto Rico 72027 1111  
1068830 1068830 2021-02-26 Canovanas Puerto Rico 72029 1752  
1068831 1068831 2021-02-26 Carolina Puerto Rico 72031 7863  
1068832 1068832 2021-02-26 Catano Puerto Rico 72033 1219  
1068833 1068833 2021-02-26 Cayey Puerto Rico 72035 1293  
1068834 1068834 2021-02-26 Ceiba Puerto Rico 72037 402  
1068835 1068835 2021-02-26 Ciales Puerto Rico 72039 740  
1068836 1068836 2021-02-26 Cidra Puerto Rico 72041 1217  
1068837 1068837 2021-02-26 Coamo Puerto Rico 72043 943  
1068838 1068838 2021-02-26 Comerio Puerto Rico 72045 678  
1068839 1068839 2021-02-26 Corozal Puerto Rico 72047 1601  
1068840 1068840 2021-02-26 Culebra Puerto Rico 72049 28  
1068841 1068841 2021-02-26 Dorado Puerto Rico 72051 2144  
1068842 1068842 2021-02-26 Fajardo Puerto Rico 72053 1274  
1068843 1068843 2021-02-26 Florida Puerto Rico 72054 675  
1068844 1068844 2021-02-26 Guanica Puerto Rico 72055 248  
1068845 1068845 2021-02-26 Guayama Puerto Rico 72057 808  
1068846 1068846 2021-02-26 Guayanilla Puerto Rico 72059 428  
1068847 1068847 2021-02-26 Guaynabo Puerto Rico 72061 4366  
1068848 1068848 2021-02-26 Gurabo Puerto Rico 72063 1840  
1068849 1068849 2021-02-26 Hatillo Puerto Rico 72065 1047  
1068850 1068850 2021-02-26 Hormigueros Puerto Rico 72067 409  
1068851 1068851 2021-02-26 Humacao Puerto Rico 72069 1653  
1068852 1068852 2021-02-26 Isabela Puerto Rico 72071 1220  
1068853 1068853 2021-02-26 Jayuya Puerto Rico 72073 413  
1068854 1068854 2021-02-26 Juana Diaz Puerto Rico 72075 1089  
1068855 1068855 2021-02-26 Juncos Puerto Rico 72077 1730  
1068856 1068856 2021-02-26 Lajas Puerto Rico 72079 412  
1068857 1068857 2021-02-26 Lares Puerto Rico 72081 874  
1068858 1068858 2021-02-26 Las Marias Puerto Rico 72083 203  
1068859 1068859 2021-02-26 Las Piedras Puerto Rico 72085 1420  
1068860 1068860 2021-02-26 Loiza Puerto Rico 72087 987  
1068861 1068861 2021-02-26 Luquillo Puerto Rico 72089 665  
1068862 1068862 2021-02-26 Manati Puerto Rico 72091 1540  
1068863 1068863 2021-02-26 Maricao Puerto Rico 72093 117  
1068864 1068864 2021-02-26 Maunabo Puerto Rico 72095 321  
1068865 1068865 2021-02-26 Mayaguez Puerto Rico 72097 1961  
1068866 1068866 2021-02-26 Moca Puerto Rico 72099 1376  
1068867 1068867 2021-02-26 Morovis Puerto Rico 72101 1329  
1068868 1068868 2021-02-26 Naguabo Puerto Rico 72103 787  
1068869 1068869 2021-02-26 Naranjito Puerto Rico 72105 1583  
1068870 1068870 2021-02-26 Orocovis Puerto Rico 72107 792  
1068871 1068871 2021-02-26 Patillas Puerto Rico 72109 368  
1068872 1068872 2021-02-26 Penuelas Puerto Rico 72111 531  
1068873 1068873 2021-02-26 Ponce Puerto Rico 72113 3065  
1068874 1068874 2021-02-26 Quebradillas Puerto Rico 72115 712  
1068875 1068875 2021-02-26 Rincon Puerto Rico 72117 447  
1068876 1068876 2021-02-26 Rio Grande Puerto Rico 72119 1776  
1068877 1068877 2021-02-26 Sabana Grande Puerto Rico 72121 411  
1068878 1068878 2021-02-26 Salinas Puerto Rico 72123 1010  
1068879 1068879 2021-02-26 San German Puerto Rico 72125 609  
1068880 1068880 2021-02-26 San Juan Puerto Rico 72127 17860  
1068881 1068881 2021-02-26 San Lorenzo Puerto Rico 72129 1461  
1068882 1068882 2021-02-26 San Sebastian Puerto Rico 72131 1651  
1068883 1068883 2021-02-26 Santa Isabel Puerto Rico 72133 560  
1068884 1068884 2021-02-26 Toa Alta Puerto Rico 72135 3673  
1068885 1068885 2021-02-26 Toa Baja Puerto Rico 72137 3830  
1068886 1068886 2021-02-26 Trujillo Alto Puerto Rico 72139 2890  
1068887 1068887 2021-02-26 Unknown Puerto Rico   4421 2023
1068888 1068888 2021-02-26 Utuado Puerto Rico 72141 852  
1068889 1068889 2021-02-26 Vega Alta Puerto Rico 72143 1819  
1068890 1068890 2021-02-26 Vega Baja Puerto Rico 72145 2686  
1068891 1068891 2021-02-26 Vieques Puerto Rico 72147 195  
1068892 1068892 2021-02-26 Villalba Puerto Rico 72149 756  
1068893 1068893 2021-02-26 Yabucoa Puerto Rico 72151 1007  
1068894 1068894 2021-02-26 Yauco Puerto Rico 72153 998  
1065571 1065571 2021-02-25 Adjuntas Puerto Rico 72001 462  
1065572 1065572 2021-02-25 Aguada Puerto Rico 72003 1209  
1065573 1065573 2021-02-25 Aguadilla Puerto Rico 72005 1491  
1065574 1065574 2021-02-25 Aguas Buenas Puerto Rico 72007 1025  
1065575 1065575 2021-02-25 Aibonito Puerto Rico 72009 574  
1065576 1065576 2021-02-25 Anasco Puerto Rico 72011 811  
1065577 1065577 2021-02-25 Arecibo Puerto Rico 72013 2844  
1065578 1065578 2021-02-25 Arroyo Puerto Rico 72015 353  
1065579 1065579 2021-02-25 Barceloneta Puerto Rico 72017 716  
1065580 1065580 2021-02-25 Barranquitas Puerto Rico 72019 1210  
1065581 1065581 2021-02-25 Bayamon Puerto Rico 72021 10069  
1065582 1065582 2021-02-25 Cabo Rojo Puerto Rico 72023 915  
1065583 1065583 2021-02-25 Caguas Puerto Rico 72025 5602  
1065584 1065584 2021-02-25 Camuy Puerto Rico 72027 1109  
1065585 1065585 2021-02-25 Canovanas Puerto Rico 72029 1751  
1065586 1065586 2021-02-25 Carolina Puerto Rico 72031 7844  
1065587 1065587 2021-02-25 Catano Puerto Rico 72033 1218  
1065588 1065588 2021-02-25 Cayey Puerto Rico 72035 1293  
1065589 1065589 2021-02-25 Ceiba Puerto Rico 72037 401  
1065590 1065590 2021-02-25 Ciales Puerto Rico 72039 740  
1065591 1065591 2021-02-25 Cidra Puerto Rico 72041 1215  

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