ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58,397 rows where state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Unknown 306
- Adjuntas 253
- Aguada 253
- Aguadilla 253
- Aguas Buenas 253
- Aibonito 253
- Anasco 253
- Arecibo 253
- Arroyo 253
- Barceloneta 253
- Barranquitas 253
- Bayamon 253
- Cabo Rojo 253
- Caguas 253
- Camuy 253
- Canovanas 253
- Carolina 253
- Catano 253
- Cayey 253
- Ceiba 253
- Ciales 253
- Cidra 253
- Coamo 253
- Comerio 253
- Corozal 253
- Dorado 253
- Fajardo 253
- Florida 253
- Guanica 253
- Guayama 253
- …
state 1
- Puerto Rico · 20,003 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922766 | 922766 | 2021-01-12 | Adjuntas | Puerto Rico | 72001 | 432 | |
922767 | 922767 | 2021-01-12 | Aguada | Puerto Rico | 72003 | 1004 | |
922768 | 922768 | 2021-01-12 | Aguadilla | Puerto Rico | 72005 | 1306 | |
922769 | 922769 | 2021-01-12 | Aguas Buenas | Puerto Rico | 72007 | 873 | |
922770 | 922770 | 2021-01-12 | Aibonito | Puerto Rico | 72009 | 469 | |
922771 | 922771 | 2021-01-12 | Anasco | Puerto Rico | 72011 | 720 | |
922772 | 922772 | 2021-01-12 | Arecibo | Puerto Rico | 72013 | 2525 | |
922773 | 922773 | 2021-01-12 | Arroyo | Puerto Rico | 72015 | 321 | |
922774 | 922774 | 2021-01-12 | Barceloneta | Puerto Rico | 72017 | 631 | |
922775 | 922775 | 2021-01-12 | Barranquitas | Puerto Rico | 72019 | 1065 | |
922776 | 922776 | 2021-01-12 | Bayamon | Puerto Rico | 72021 | 8810 | |
922777 | 922777 | 2021-01-12 | Cabo Rojo | Puerto Rico | 72023 | 795 | |
922778 | 922778 | 2021-01-12 | Caguas | Puerto Rico | 72025 | 4865 | |
922779 | 922779 | 2021-01-12 | Camuy | Puerto Rico | 72027 | 975 | |
922780 | 922780 | 2021-01-12 | Canovanas | Puerto Rico | 72029 | 1561 | |
922781 | 922781 | 2021-01-12 | Carolina | Puerto Rico | 72031 | 7036 | |
922782 | 922782 | 2021-01-12 | Catano | Puerto Rico | 72033 | 1077 | |
922783 | 922783 | 2021-01-12 | Cayey | Puerto Rico | 72035 | 1132 | |
922784 | 922784 | 2021-01-12 | Ceiba | Puerto Rico | 72037 | 346 | |
922785 | 922785 | 2021-01-12 | Ciales | Puerto Rico | 72039 | 628 | |
922786 | 922786 | 2021-01-12 | Cidra | Puerto Rico | 72041 | 1046 | |
922787 | 922787 | 2021-01-12 | Coamo | Puerto Rico | 72043 | 854 | |
922788 | 922788 | 2021-01-12 | Comerio | Puerto Rico | 72045 | 639 | |
922789 | 922789 | 2021-01-12 | Corozal | Puerto Rico | 72047 | 1506 | |
922790 | 922790 | 2021-01-12 | Culebra | Puerto Rico | 72049 | 28 | |
922791 | 922791 | 2021-01-12 | Dorado | Puerto Rico | 72051 | 1935 | |
922792 | 922792 | 2021-01-12 | Fajardo | Puerto Rico | 72053 | 1165 | |
922793 | 922793 | 2021-01-12 | Florida | Puerto Rico | 72054 | 646 | |
922794 | 922794 | 2021-01-12 | Guanica | Puerto Rico | 72055 | 231 | |
922795 | 922795 | 2021-01-12 | Guayama | Puerto Rico | 72057 | 715 | |
922796 | 922796 | 2021-01-12 | Guayanilla | Puerto Rico | 72059 | 364 | |
922797 | 922797 | 2021-01-12 | Guaynabo | Puerto Rico | 72061 | 3849 | |
922798 | 922798 | 2021-01-12 | Gurabo | Puerto Rico | 72063 | 1557 | |
922799 | 922799 | 2021-01-12 | Hatillo | Puerto Rico | 72065 | 911 | |
922800 | 922800 | 2021-01-12 | Hormigueros | Puerto Rico | 72067 | 357 | |
922801 | 922801 | 2021-01-12 | Humacao | Puerto Rico | 72069 | 1419 | |
922802 | 922802 | 2021-01-12 | Isabela | Puerto Rico | 72071 | 1036 | |
922803 | 922803 | 2021-01-12 | Jayuya | Puerto Rico | 72073 | 378 | |
922804 | 922804 | 2021-01-12 | Juana Diaz | Puerto Rico | 72075 | 918 | |
922805 | 922805 | 2021-01-12 | Juncos | Puerto Rico | 72077 | 1471 | |
922806 | 922806 | 2021-01-12 | Lajas | Puerto Rico | 72079 | 335 | |
922807 | 922807 | 2021-01-12 | Lares | Puerto Rico | 72081 | 794 | |
922808 | 922808 | 2021-01-12 | Las Marias | Puerto Rico | 72083 | 186 | |
922809 | 922809 | 2021-01-12 | Las Piedras | Puerto Rico | 72085 | 1180 | |
922810 | 922810 | 2021-01-12 | Loiza | Puerto Rico | 72087 | 829 | |
922811 | 922811 | 2021-01-12 | Luquillo | Puerto Rico | 72089 | 563 | |
922812 | 922812 | 2021-01-12 | Manati | Puerto Rico | 72091 | 1420 | |
922813 | 922813 | 2021-01-12 | Maricao | Puerto Rico | 72093 | 101 | |
922814 | 922814 | 2021-01-12 | Maunabo | Puerto Rico | 72095 | 305 | |
922815 | 922815 | 2021-01-12 | Mayaguez | Puerto Rico | 72097 | 1636 | |
922816 | 922816 | 2021-01-12 | Moca | Puerto Rico | 72099 | 1231 | |
922817 | 922817 | 2021-01-12 | Morovis | Puerto Rico | 72101 | 1178 | |
922818 | 922818 | 2021-01-12 | Naguabo | Puerto Rico | 72103 | 673 | |
922819 | 922819 | 2021-01-12 | Naranjito | Puerto Rico | 72105 | 1437 | |
922820 | 922820 | 2021-01-12 | Orocovis | Puerto Rico | 72107 | 711 | |
922821 | 922821 | 2021-01-12 | Patillas | Puerto Rico | 72109 | 328 | |
922822 | 922822 | 2021-01-12 | Penuelas | Puerto Rico | 72111 | 421 | |
922823 | 922823 | 2021-01-12 | Ponce | Puerto Rico | 72113 | 2456 | |
922824 | 922824 | 2021-01-12 | Quebradillas | Puerto Rico | 72115 | 615 | |
922825 | 922825 | 2021-01-12 | Rincon | Puerto Rico | 72117 | 382 | |
922826 | 922826 | 2021-01-12 | Rio Grande | Puerto Rico | 72119 | 1533 | |
922827 | 922827 | 2021-01-12 | Sabana Grande | Puerto Rico | 72121 | 349 | |
922828 | 922828 | 2021-01-12 | Salinas | Puerto Rico | 72123 | 947 | |
922829 | 922829 | 2021-01-12 | San German | Puerto Rico | 72125 | 529 | |
922830 | 922830 | 2021-01-12 | San Juan | Puerto Rico | 72127 | 16266 | |
922831 | 922831 | 2021-01-12 | San Lorenzo | Puerto Rico | 72129 | 1320 | |
922832 | 922832 | 2021-01-12 | San Sebastian | Puerto Rico | 72131 | 1522 | |
922833 | 922833 | 2021-01-12 | Santa Isabel | Puerto Rico | 72133 | 489 | |
922834 | 922834 | 2021-01-12 | Toa Alta | Puerto Rico | 72135 | 3258 | |
922835 | 922835 | 2021-01-12 | Toa Baja | Puerto Rico | 72137 | 3447 | |
922836 | 922836 | 2021-01-12 | Trujillo Alto | Puerto Rico | 72139 | 2587 | |
922837 | 922837 | 2021-01-12 | Unknown | Puerto Rico | 4052 | 1645 | |
922838 | 922838 | 2021-01-12 | Utuado | Puerto Rico | 72141 | 785 | |
922839 | 922839 | 2021-01-12 | Vega Alta | Puerto Rico | 72143 | 1634 | |
922840 | 922840 | 2021-01-12 | Vega Baja | Puerto Rico | 72145 | 2353 | |
922841 | 922841 | 2021-01-12 | Vieques | Puerto Rico | 72147 | 190 | |
922842 | 922842 | 2021-01-12 | Villalba | Puerto Rico | 72149 | 622 | |
922843 | 922843 | 2021-01-12 | Yabucoa | Puerto Rico | 72151 | 866 | |
922844 | 922844 | 2021-01-12 | Yauco | Puerto Rico | 72153 | 916 | |
919521 | 919521 | 2021-01-11 | Adjuntas | Puerto Rico | 72001 | 430 | |
919522 | 919522 | 2021-01-11 | Aguada | Puerto Rico | 72003 | 992 | |
919523 | 919523 | 2021-01-11 | Aguadilla | Puerto Rico | 72005 | 1297 | |
919524 | 919524 | 2021-01-11 | Aguas Buenas | Puerto Rico | 72007 | 869 | |
919525 | 919525 | 2021-01-11 | Aibonito | Puerto Rico | 72009 | 467 | |
919526 | 919526 | 2021-01-11 | Anasco | Puerto Rico | 72011 | 702 | |
919527 | 919527 | 2021-01-11 | Arecibo | Puerto Rico | 72013 | 2499 | |
919528 | 919528 | 2021-01-11 | Arroyo | Puerto Rico | 72015 | 318 | |
919529 | 919529 | 2021-01-11 | Barceloneta | Puerto Rico | 72017 | 630 | |
919530 | 919530 | 2021-01-11 | Barranquitas | Puerto Rico | 72019 | 1051 | |
919531 | 919531 | 2021-01-11 | Bayamon | Puerto Rico | 72021 | 8736 | |
919532 | 919532 | 2021-01-11 | Cabo Rojo | Puerto Rico | 72023 | 795 | |
919533 | 919533 | 2021-01-11 | Caguas | Puerto Rico | 72025 | 4828 | |
919534 | 919534 | 2021-01-11 | Camuy | Puerto Rico | 72027 | 970 | |
919535 | 919535 | 2021-01-11 | Canovanas | Puerto Rico | 72029 | 1545 | |
919536 | 919536 | 2021-01-11 | Carolina | Puerto Rico | 72031 | 6971 | |
919537 | 919537 | 2021-01-11 | Catano | Puerto Rico | 72033 | 1064 | |
919538 | 919538 | 2021-01-11 | Cayey | Puerto Rico | 72035 | 1121 | |
919539 | 919539 | 2021-01-11 | Ceiba | Puerto Rico | 72037 | 339 | |
919540 | 919540 | 2021-01-11 | Ciales | Puerto Rico | 72039 | 618 | |
919541 | 919541 | 2021-01-11 | Cidra | Puerto Rico | 72041 | 1030 |
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);