ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2021-05-26" and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
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
- Culebra 1
- Dorado 1
- Fajardo 1
- Florida 1
- Guanica 1
- Guayama 1
- …
state 1
- Puerto Rico · 79 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1357793 | 1357793 | 2021-05-26 | Adjuntas | Puerto Rico | 72001 | 551 | |
1357794 | 1357794 | 2021-05-26 | Aguada | Puerto Rico | 72003 | 1538 | |
1357795 | 1357795 | 2021-05-26 | Aguadilla | Puerto Rico | 72005 | 1889 | |
1357796 | 1357796 | 2021-05-26 | Aguas Buenas | Puerto Rico | 72007 | 1374 | |
1357797 | 1357797 | 2021-05-26 | Aibonito | Puerto Rico | 72009 | 811 | |
1357798 | 1357798 | 2021-05-26 | Anasco | Puerto Rico | 72011 | 983 | |
1357799 | 1357799 | 2021-05-26 | Arecibo | Puerto Rico | 72013 | 3526 | |
1357800 | 1357800 | 2021-05-26 | Arroyo | Puerto Rico | 72015 | 451 | |
1357801 | 1357801 | 2021-05-26 | Barceloneta | Puerto Rico | 72017 | 929 | |
1357802 | 1357802 | 2021-05-26 | Barranquitas | Puerto Rico | 72019 | 1602 | |
1357803 | 1357803 | 2021-05-26 | Bayamon | Puerto Rico | 72021 | 12570 | |
1357804 | 1357804 | 2021-05-26 | Cabo Rojo | Puerto Rico | 72023 | 1270 | |
1357805 | 1357805 | 2021-05-26 | Caguas | Puerto Rico | 72025 | 7283 | |
1357806 | 1357806 | 2021-05-26 | Camuy | Puerto Rico | 72027 | 1414 | |
1357807 | 1357807 | 2021-05-26 | Canovanas | Puerto Rico | 72029 | 2361 | |
1357808 | 1357808 | 2021-05-26 | Carolina | Puerto Rico | 72031 | 10197 | |
1357809 | 1357809 | 2021-05-26 | Catano | Puerto Rico | 72033 | 1526 | |
1357810 | 1357810 | 2021-05-26 | Cayey | Puerto Rico | 72035 | 1623 | |
1357811 | 1357811 | 2021-05-26 | Ceiba | Puerto Rico | 72037 | 517 | |
1357812 | 1357812 | 2021-05-26 | Ciales | Puerto Rico | 72039 | 924 | |
1357813 | 1357813 | 2021-05-26 | Cidra | Puerto Rico | 72041 | 1504 | |
1357814 | 1357814 | 2021-05-26 | Coamo | Puerto Rico | 72043 | 1164 | |
1357815 | 1357815 | 2021-05-26 | Comerio | Puerto Rico | 72045 | 875 | |
1357816 | 1357816 | 2021-05-26 | Corozal | Puerto Rico | 72047 | 2070 | |
1357817 | 1357817 | 2021-05-26 | Culebra | Puerto Rico | 72049 | 43 | |
1357818 | 1357818 | 2021-05-26 | Dorado | Puerto Rico | 72051 | 2653 | |
1357819 | 1357819 | 2021-05-26 | Fajardo | Puerto Rico | 72053 | 1663 | |
1357820 | 1357820 | 2021-05-26 | Florida | Puerto Rico | 72054 | 830 | |
1357821 | 1357821 | 2021-05-26 | Guanica | Puerto Rico | 72055 | 338 | |
1357822 | 1357822 | 2021-05-26 | Guayama | Puerto Rico | 72057 | 1081 | |
1357823 | 1357823 | 2021-05-26 | Guayanilla | Puerto Rico | 72059 | 567 | |
1357824 | 1357824 | 2021-05-26 | Guaynabo | Puerto Rico | 72061 | 5260 | |
1357825 | 1357825 | 2021-05-26 | Gurabo | Puerto Rico | 72063 | 2498 | |
1357826 | 1357826 | 2021-05-26 | Hatillo | Puerto Rico | 72065 | 1362 | |
1357827 | 1357827 | 2021-05-26 | Hormigueros | Puerto Rico | 72067 | 506 | |
1357828 | 1357828 | 2021-05-26 | Humacao | Puerto Rico | 72069 | 2491 | |
1357829 | 1357829 | 2021-05-26 | Isabela | Puerto Rico | 72071 | 1619 | |
1357830 | 1357830 | 2021-05-26 | Jayuya | Puerto Rico | 72073 | 591 | |
1357831 | 1357831 | 2021-05-26 | Juana Diaz | Puerto Rico | 72075 | 1379 | |
1357832 | 1357832 | 2021-05-26 | Juncos | Puerto Rico | 72077 | 2528 | |
1357833 | 1357833 | 2021-05-26 | Lajas | Puerto Rico | 72079 | 597 | |
1357834 | 1357834 | 2021-05-26 | Lares | Puerto Rico | 72081 | 1114 | |
1357835 | 1357835 | 2021-05-26 | Las Marias | Puerto Rico | 72083 | 302 | |
1357836 | 1357836 | 2021-05-26 | Las Piedras | Puerto Rico | 72085 | 1951 | |
1357837 | 1357837 | 2021-05-26 | Loiza | Puerto Rico | 72087 | 1443 | |
1357838 | 1357838 | 2021-05-26 | Luquillo | Puerto Rico | 72089 | 916 | |
1357839 | 1357839 | 2021-05-26 | Manati | Puerto Rico | 72091 | 1894 | |
1357840 | 1357840 | 2021-05-26 | Maricao | Puerto Rico | 72093 | 150 | |
1357841 | 1357841 | 2021-05-26 | Maunabo | Puerto Rico | 72095 | 457 | |
1357842 | 1357842 | 2021-05-26 | Mayaguez | Puerto Rico | 72097 | 2468 | |
1357843 | 1357843 | 2021-05-26 | Moca | Puerto Rico | 72099 | 1683 | |
1357844 | 1357844 | 2021-05-26 | Morovis | Puerto Rico | 72101 | 1716 | |
1357845 | 1357845 | 2021-05-26 | Naguabo | Puerto Rico | 72103 | 1205 | |
1357846 | 1357846 | 2021-05-26 | Naranjito | Puerto Rico | 72105 | 2040 | |
1357847 | 1357847 | 2021-05-26 | Orocovis | Puerto Rico | 72107 | 1091 | |
1357848 | 1357848 | 2021-05-26 | Patillas | Puerto Rico | 72109 | 504 | |
1357849 | 1357849 | 2021-05-26 | Penuelas | Puerto Rico | 72111 | 653 | |
1357850 | 1357850 | 2021-05-26 | Ponce | Puerto Rico | 72113 | 4055 | |
1357851 | 1357851 | 2021-05-26 | Quebradillas | Puerto Rico | 72115 | 1022 | |
1357852 | 1357852 | 2021-05-26 | Rincon | Puerto Rico | 72117 | 660 | |
1357853 | 1357853 | 2021-05-26 | Rio Grande | Puerto Rico | 72119 | 2518 | |
1357854 | 1357854 | 2021-05-26 | Sabana Grande | Puerto Rico | 72121 | 530 | |
1357855 | 1357855 | 2021-05-26 | Salinas | Puerto Rico | 72123 | 1206 | |
1357856 | 1357856 | 2021-05-26 | San German | Puerto Rico | 72125 | 813 | |
1357857 | 1357857 | 2021-05-26 | San Juan | Puerto Rico | 72127 | 22450 | |
1357858 | 1357858 | 2021-05-26 | San Lorenzo | Puerto Rico | 72129 | 2027 | |
1357859 | 1357859 | 2021-05-26 | San Sebastian | Puerto Rico | 72131 | 1950 | |
1357860 | 1357860 | 2021-05-26 | Santa Isabel | Puerto Rico | 72133 | 693 | |
1357861 | 1357861 | 2021-05-26 | Toa Alta | Puerto Rico | 72135 | 4732 | |
1357862 | 1357862 | 2021-05-26 | Toa Baja | Puerto Rico | 72137 | 4828 | |
1357863 | 1357863 | 2021-05-26 | Trujillo Alto | Puerto Rico | 72139 | 3634 | |
1357864 | 1357864 | 2021-05-26 | Unknown | Puerto Rico | 5567 | 2483 | |
1357865 | 1357865 | 2021-05-26 | Utuado | Puerto Rico | 72141 | 1066 | |
1357866 | 1357866 | 2021-05-26 | Vega Alta | Puerto Rico | 72143 | 2263 | |
1357867 | 1357867 | 2021-05-26 | Vega Baja | Puerto Rico | 72145 | 3432 | |
1357868 | 1357868 | 2021-05-26 | Vieques | Puerto Rico | 72147 | 204 | |
1357869 | 1357869 | 2021-05-26 | Villalba | Puerto Rico | 72149 | 877 | |
1357870 | 1357870 | 2021-05-26 | Yabucoa | Puerto Rico | 72151 | 1386 | |
1357871 | 1357871 | 2021-05-26 | Yauco | Puerto Rico | 72153 | 1251 |
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);