ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
78 rows where "date" is on date 2020-05-28 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Adjuntas 1
- Aguada 1
- Aguadilla 1
- Aguas Buenas 1
- Aibonito 1
- Anasco 1
- Arecibo 1
- Arroyo 1
- Barceloneta 1
- Barranquitas 1
- Bayamon 1
- Cabo Rojo 1
- Caguas 1
- Camuy 1
- Canovanas 1
- Carolina 1
- Catano 1
- Cayey 1
- Ceiba 1
- Ciales 1
- Cidra 1
- Coamo 1
- Comerio 1
- Corozal 1
- Dorado 1
- Fajardo 1
- Florida 1
- Guanica 1
- Guayama 1
- Guayanilla 1
- …
state 1
- Puerto Rico · 78 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
186784 | 186784 | 2020-05-28 | Adjuntas | Puerto Rico | 72001 | 21 | |
186785 | 186785 | 2020-05-28 | Aguada | Puerto Rico | 72003 | 19 | |
186786 | 186786 | 2020-05-28 | Aguadilla | Puerto Rico | 72005 | 20 | |
186787 | 186787 | 2020-05-28 | Aguas Buenas | Puerto Rico | 72007 | 35 | |
186788 | 186788 | 2020-05-28 | Aibonito | Puerto Rico | 72009 | 20 | |
186789 | 186789 | 2020-05-28 | Anasco | Puerto Rico | 72011 | 20 | |
186790 | 186790 | 2020-05-28 | Arecibo | Puerto Rico | 72013 | 60 | |
186791 | 186791 | 2020-05-28 | Arroyo | Puerto Rico | 72015 | 15 | |
186792 | 186792 | 2020-05-28 | Barceloneta | Puerto Rico | 72017 | 11 | |
186793 | 186793 | 2020-05-28 | Barranquitas | Puerto Rico | 72019 | 40 | |
186794 | 186794 | 2020-05-28 | Bayamon | Puerto Rico | 72021 | 216 | |
186795 | 186795 | 2020-05-28 | Cabo Rojo | Puerto Rico | 72023 | 40 | |
186796 | 186796 | 2020-05-28 | Caguas | Puerto Rico | 72025 | 109 | |
186797 | 186797 | 2020-05-28 | Camuy | Puerto Rico | 72027 | 9 | |
186798 | 186798 | 2020-05-28 | Canovanas | Puerto Rico | 72029 | 63 | |
186799 | 186799 | 2020-05-28 | Carolina | Puerto Rico | 72031 | 143 | |
186800 | 186800 | 2020-05-28 | Catano | Puerto Rico | 72033 | 17 | |
186801 | 186801 | 2020-05-28 | Cayey | Puerto Rico | 72035 | 49 | |
186802 | 186802 | 2020-05-28 | Ceiba | Puerto Rico | 72037 | 12 | |
186803 | 186803 | 2020-05-28 | Ciales | Puerto Rico | 72039 | 18 | |
186804 | 186804 | 2020-05-28 | Cidra | Puerto Rico | 72041 | 39 | |
186805 | 186805 | 2020-05-28 | Coamo | Puerto Rico | 72043 | 14 | |
186806 | 186806 | 2020-05-28 | Comerio | Puerto Rico | 72045 | 24 | |
186807 | 186807 | 2020-05-28 | Corozal | Puerto Rico | 72047 | 27 | |
186808 | 186808 | 2020-05-28 | Dorado | Puerto Rico | 72051 | 60 | |
186809 | 186809 | 2020-05-28 | Fajardo | Puerto Rico | 72053 | 21 | |
186810 | 186810 | 2020-05-28 | Florida | Puerto Rico | 72054 | 13 | |
186811 | 186811 | 2020-05-28 | Guanica | Puerto Rico | 72055 | 21 | |
186812 | 186812 | 2020-05-28 | Guayama | Puerto Rico | 72057 | 37 | |
186813 | 186813 | 2020-05-28 | Guayanilla | Puerto Rico | 72059 | 18 | |
186814 | 186814 | 2020-05-28 | Guaynabo | Puerto Rico | 72061 | 184 | |
186815 | 186815 | 2020-05-28 | Gurabo | Puerto Rico | 72063 | 45 | |
186816 | 186816 | 2020-05-28 | Hatillo | Puerto Rico | 72065 | 16 | |
186817 | 186817 | 2020-05-28 | Hormigueros | Puerto Rico | 72067 | 18 | |
186818 | 186818 | 2020-05-28 | Humacao | Puerto Rico | 72069 | 43 | |
186819 | 186819 | 2020-05-28 | Isabela | Puerto Rico | 72071 | 23 | |
186820 | 186820 | 2020-05-28 | Jayuya | Puerto Rico | 72073 | 7 | |
186821 | 186821 | 2020-05-28 | Juana Diaz | Puerto Rico | 72075 | 41 | |
186822 | 186822 | 2020-05-28 | Juncos | Puerto Rico | 72077 | 18 | |
186823 | 186823 | 2020-05-28 | Lajas | Puerto Rico | 72079 | 14 | |
186824 | 186824 | 2020-05-28 | Lares | Puerto Rico | 72081 | 29 | |
186825 | 186825 | 2020-05-28 | Las Marias | Puerto Rico | 72083 | 11 | |
186826 | 186826 | 2020-05-28 | Las Piedras | Puerto Rico | 72085 | 25 | |
186827 | 186827 | 2020-05-28 | Loiza | Puerto Rico | 72087 | 12 | |
186828 | 186828 | 2020-05-28 | Luquillo | Puerto Rico | 72089 | 19 | |
186829 | 186829 | 2020-05-28 | Manati | Puerto Rico | 72091 | 26 | |
186830 | 186830 | 2020-05-28 | Maricao | Puerto Rico | 72093 | 3 | |
186831 | 186831 | 2020-05-28 | Maunabo | Puerto Rico | 72095 | 15 | |
186832 | 186832 | 2020-05-28 | Mayaguez | Puerto Rico | 72097 | 84 | |
186833 | 186833 | 2020-05-28 | Moca | Puerto Rico | 72099 | 22 | |
186834 | 186834 | 2020-05-28 | Morovis | Puerto Rico | 72101 | 34 | |
186835 | 186835 | 2020-05-28 | Naguabo | Puerto Rico | 72103 | 22 | |
186836 | 186836 | 2020-05-28 | Naranjito | Puerto Rico | 72105 | 50 | |
186837 | 186837 | 2020-05-28 | Orocovis | Puerto Rico | 72107 | 42 | |
186838 | 186838 | 2020-05-28 | Patillas | Puerto Rico | 72109 | 31 | |
186839 | 186839 | 2020-05-28 | Penuelas | Puerto Rico | 72111 | 11 | |
186840 | 186840 | 2020-05-28 | Ponce | Puerto Rico | 72113 | 94 | |
186841 | 186841 | 2020-05-28 | Quebradillas | Puerto Rico | 72115 | 27 | |
186842 | 186842 | 2020-05-28 | Rincon | Puerto Rico | 72117 | 10 | |
186843 | 186843 | 2020-05-28 | Rio Grande | Puerto Rico | 72119 | 47 | |
186844 | 186844 | 2020-05-28 | Sabana Grande | Puerto Rico | 72121 | 29 | |
186845 | 186845 | 2020-05-28 | Salinas | Puerto Rico | 72123 | 63 | |
186846 | 186846 | 2020-05-28 | San German | Puerto Rico | 72125 | 35 | |
186847 | 186847 | 2020-05-28 | San Juan | Puerto Rico | 72127 | 493 | |
186848 | 186848 | 2020-05-28 | San Lorenzo | Puerto Rico | 72129 | 37 | |
186849 | 186849 | 2020-05-28 | San Sebastian | Puerto Rico | 72131 | 40 | |
186850 | 186850 | 2020-05-28 | Santa Isabel | Puerto Rico | 72133 | 17 | |
186851 | 186851 | 2020-05-28 | Toa Alta | Puerto Rico | 72135 | 85 | |
186852 | 186852 | 2020-05-28 | Toa Baja | Puerto Rico | 72137 | 95 | |
186853 | 186853 | 2020-05-28 | Trujillo Alto | Puerto Rico | 72139 | 59 | |
186854 | 186854 | 2020-05-28 | Unknown | Puerto Rico | 114 | 131 | |
186855 | 186855 | 2020-05-28 | Utuado | Puerto Rico | 72141 | 3 | |
186856 | 186856 | 2020-05-28 | Vega Alta | Puerto Rico | 72143 | 39 | |
186857 | 186857 | 2020-05-28 | Vega Baja | Puerto Rico | 72145 | 38 | |
186858 | 186858 | 2020-05-28 | Vieques | Puerto Rico | 72147 | 20 | |
186859 | 186859 | 2020-05-28 | Villalba | Puerto Rico | 72149 | 24 | |
186860 | 186860 | 2020-05-28 | Yabucoa | Puerto Rico | 72151 | 11 | |
186861 | 186861 | 2020-05-28 | Yauco | Puerto Rico | 72153 | 50 |
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);