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

79 rows where date = "2021-06-03" and state = "Puerto Rico" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Puerto Rico · 79 ✖
Link rowid date ▲ county state fips cases deaths
1383759 1383759 2021-06-03 Adjuntas Puerto Rico 72001 551  
1383760 1383760 2021-06-03 Aguada Puerto Rico 72003 1546  
1383761 1383761 2021-06-03 Aguadilla Puerto Rico 72005 1889  
1383762 1383762 2021-06-03 Aguas Buenas Puerto Rico 72007 1379  
1383763 1383763 2021-06-03 Aibonito Puerto Rico 72009 811  
1383764 1383764 2021-06-03 Anasco Puerto Rico 72011 988  
1383765 1383765 2021-06-03 Arecibo Puerto Rico 72013 3532  
1383766 1383766 2021-06-03 Arroyo Puerto Rico 72015 454  
1383767 1383767 2021-06-03 Barceloneta Puerto Rico 72017 931  
1383768 1383768 2021-06-03 Barranquitas Puerto Rico 72019 1606  
1383769 1383769 2021-06-03 Bayamon Puerto Rico 72021 12619  
1383770 1383770 2021-06-03 Cabo Rojo Puerto Rico 72023 1276  
1383771 1383771 2021-06-03 Caguas Puerto Rico 72025 7309  
1383772 1383772 2021-06-03 Camuy Puerto Rico 72027 1416  
1383773 1383773 2021-06-03 Canovanas Puerto Rico 72029 2381  
1383774 1383774 2021-06-03 Carolina Puerto Rico 72031 10233  
1383775 1383775 2021-06-03 Catano Puerto Rico 72033 1539  
1383776 1383776 2021-06-03 Cayey Puerto Rico 72035 1629  
1383777 1383777 2021-06-03 Ceiba Puerto Rico 72037 523  
1383778 1383778 2021-06-03 Ciales Puerto Rico 72039 928  
1383779 1383779 2021-06-03 Cidra Puerto Rico 72041 1506  
1383780 1383780 2021-06-03 Coamo Puerto Rico 72043 1165  
1383781 1383781 2021-06-03 Comerio Puerto Rico 72045 876  
1383782 1383782 2021-06-03 Corozal Puerto Rico 72047 2072  
1383783 1383783 2021-06-03 Culebra Puerto Rico 72049 43  
1383784 1383784 2021-06-03 Dorado Puerto Rico 72051 2655  
1383785 1383785 2021-06-03 Fajardo Puerto Rico 72053 1679  
1383786 1383786 2021-06-03 Florida Puerto Rico 72054 831  
1383787 1383787 2021-06-03 Guanica Puerto Rico 72055 339  
1383788 1383788 2021-06-03 Guayama Puerto Rico 72057 1088  
1383789 1383789 2021-06-03 Guayanilla Puerto Rico 72059 573  
1383790 1383790 2021-06-03 Guaynabo Puerto Rico 72061 5272  
1383791 1383791 2021-06-03 Gurabo Puerto Rico 72063 2511  
1383792 1383792 2021-06-03 Hatillo Puerto Rico 72065 1363  
1383793 1383793 2021-06-03 Hormigueros Puerto Rico 72067 508  
1383794 1383794 2021-06-03 Humacao Puerto Rico 72069 2504  
1383795 1383795 2021-06-03 Isabela Puerto Rico 72071 1625  
1383796 1383796 2021-06-03 Jayuya Puerto Rico 72073 591  
1383797 1383797 2021-06-03 Juana Diaz Puerto Rico 72075 1382  
1383798 1383798 2021-06-03 Juncos Puerto Rico 72077 2530  
1383799 1383799 2021-06-03 Lajas Puerto Rico 72079 602  
1383800 1383800 2021-06-03 Lares Puerto Rico 72081 1118  
1383801 1383801 2021-06-03 Las Marias Puerto Rico 72083 314  
1383802 1383802 2021-06-03 Las Piedras Puerto Rico 72085 1955  
1383803 1383803 2021-06-03 Loiza Puerto Rico 72087 1448  
1383804 1383804 2021-06-03 Luquillo Puerto Rico 72089 921  
1383805 1383805 2021-06-03 Manati Puerto Rico 72091 1905  
1383806 1383806 2021-06-03 Maricao Puerto Rico 72093 150  
1383807 1383807 2021-06-03 Maunabo Puerto Rico 72095 458  
1383808 1383808 2021-06-03 Mayaguez Puerto Rico 72097 2496  
1383809 1383809 2021-06-03 Moca Puerto Rico 72099 1687  
1383810 1383810 2021-06-03 Morovis Puerto Rico 72101 1733  
1383811 1383811 2021-06-03 Naguabo Puerto Rico 72103 1207  
1383812 1383812 2021-06-03 Naranjito Puerto Rico 72105 2041  
1383813 1383813 2021-06-03 Orocovis Puerto Rico 72107 1101  
1383814 1383814 2021-06-03 Patillas Puerto Rico 72109 505  
1383815 1383815 2021-06-03 Penuelas Puerto Rico 72111 660  
1383816 1383816 2021-06-03 Ponce Puerto Rico 72113 4082  
1383817 1383817 2021-06-03 Quebradillas Puerto Rico 72115 1024  
1383818 1383818 2021-06-03 Rincon Puerto Rico 72117 667  
1383819 1383819 2021-06-03 Rio Grande Puerto Rico 72119 2537  
1383820 1383820 2021-06-03 Sabana Grande Puerto Rico 72121 539  
1383821 1383821 2021-06-03 Salinas Puerto Rico 72123 1208  
1383822 1383822 2021-06-03 San German Puerto Rico 72125 818  
1383823 1383823 2021-06-03 San Juan Puerto Rico 72127 22527  
1383824 1383824 2021-06-03 San Lorenzo Puerto Rico 72129 2034  
1383825 1383825 2021-06-03 San Sebastian Puerto Rico 72131 1956  
1383826 1383826 2021-06-03 Santa Isabel Puerto Rico 72133 695  
1383827 1383827 2021-06-03 Toa Alta Puerto Rico 72135 4751  
1383828 1383828 2021-06-03 Toa Baja Puerto Rico 72137 4854  
1383829 1383829 2021-06-03 Trujillo Alto Puerto Rico 72139 3658  
1383830 1383830 2021-06-03 Unknown Puerto Rico   5589 2512
1383831 1383831 2021-06-03 Utuado Puerto Rico 72141 1074  
1383832 1383832 2021-06-03 Vega Alta Puerto Rico 72143 2275  
1383833 1383833 2021-06-03 Vega Baja Puerto Rico 72145 3442  
1383834 1383834 2021-06-03 Vieques Puerto Rico 72147 204  
1383835 1383835 2021-06-03 Villalba Puerto Rico 72149 878  
1383836 1383836 2021-06-03 Yabucoa Puerto Rico 72151 1393  
1383837 1383837 2021-06-03 Yauco Puerto Rico 72153 1255  

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