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-26 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 |
---|---|---|---|---|---|---|---|
180677 | 180677 | 2020-05-26 | Adjuntas | Puerto Rico | 72001 | 20 | |
180678 | 180678 | 2020-05-26 | Aguada | Puerto Rico | 72003 | 17 | |
180679 | 180679 | 2020-05-26 | Aguadilla | Puerto Rico | 72005 | 20 | |
180680 | 180680 | 2020-05-26 | Aguas Buenas | Puerto Rico | 72007 | 34 | |
180681 | 180681 | 2020-05-26 | Aibonito | Puerto Rico | 72009 | 20 | |
180682 | 180682 | 2020-05-26 | Anasco | Puerto Rico | 72011 | 16 | |
180683 | 180683 | 2020-05-26 | Arecibo | Puerto Rico | 72013 | 58 | |
180684 | 180684 | 2020-05-26 | Arroyo | Puerto Rico | 72015 | 15 | |
180685 | 180685 | 2020-05-26 | Barceloneta | Puerto Rico | 72017 | 9 | |
180686 | 180686 | 2020-05-26 | Barranquitas | Puerto Rico | 72019 | 39 | |
180687 | 180687 | 2020-05-26 | Bayamon | Puerto Rico | 72021 | 207 | |
180688 | 180688 | 2020-05-26 | Cabo Rojo | Puerto Rico | 72023 | 29 | |
180689 | 180689 | 2020-05-26 | Caguas | Puerto Rico | 72025 | 103 | |
180690 | 180690 | 2020-05-26 | Camuy | Puerto Rico | 72027 | 9 | |
180691 | 180691 | 2020-05-26 | Canovanas | Puerto Rico | 72029 | 63 | |
180692 | 180692 | 2020-05-26 | Carolina | Puerto Rico | 72031 | 138 | |
180693 | 180693 | 2020-05-26 | Catano | Puerto Rico | 72033 | 16 | |
180694 | 180694 | 2020-05-26 | Cayey | Puerto Rico | 72035 | 48 | |
180695 | 180695 | 2020-05-26 | Ceiba | Puerto Rico | 72037 | 13 | |
180696 | 180696 | 2020-05-26 | Ciales | Puerto Rico | 72039 | 17 | |
180697 | 180697 | 2020-05-26 | Cidra | Puerto Rico | 72041 | 39 | |
180698 | 180698 | 2020-05-26 | Coamo | Puerto Rico | 72043 | 13 | |
180699 | 180699 | 2020-05-26 | Comerio | Puerto Rico | 72045 | 23 | |
180700 | 180700 | 2020-05-26 | Corozal | Puerto Rico | 72047 | 26 | |
180701 | 180701 | 2020-05-26 | Dorado | Puerto Rico | 72051 | 57 | |
180702 | 180702 | 2020-05-26 | Fajardo | Puerto Rico | 72053 | 18 | |
180703 | 180703 | 2020-05-26 | Florida | Puerto Rico | 72054 | 13 | |
180704 | 180704 | 2020-05-26 | Guanica | Puerto Rico | 72055 | 18 | |
180705 | 180705 | 2020-05-26 | Guayama | Puerto Rico | 72057 | 37 | |
180706 | 180706 | 2020-05-26 | Guayanilla | Puerto Rico | 72059 | 17 | |
180707 | 180707 | 2020-05-26 | Guaynabo | Puerto Rico | 72061 | 176 | |
180708 | 180708 | 2020-05-26 | Gurabo | Puerto Rico | 72063 | 44 | |
180709 | 180709 | 2020-05-26 | Hatillo | Puerto Rico | 72065 | 12 | |
180710 | 180710 | 2020-05-26 | Hormigueros | Puerto Rico | 72067 | 17 | |
180711 | 180711 | 2020-05-26 | Humacao | Puerto Rico | 72069 | 42 | |
180712 | 180712 | 2020-05-26 | Isabela | Puerto Rico | 72071 | 23 | |
180713 | 180713 | 2020-05-26 | Jayuya | Puerto Rico | 72073 | 6 | |
180714 | 180714 | 2020-05-26 | Juana Diaz | Puerto Rico | 72075 | 40 | |
180715 | 180715 | 2020-05-26 | Juncos | Puerto Rico | 72077 | 18 | |
180716 | 180716 | 2020-05-26 | Lajas | Puerto Rico | 72079 | 14 | |
180717 | 180717 | 2020-05-26 | Lares | Puerto Rico | 72081 | 28 | |
180718 | 180718 | 2020-05-26 | Las Marias | Puerto Rico | 72083 | 11 | |
180719 | 180719 | 2020-05-26 | Las Piedras | Puerto Rico | 72085 | 25 | |
180720 | 180720 | 2020-05-26 | Loiza | Puerto Rico | 72087 | 10 | |
180721 | 180721 | 2020-05-26 | Luquillo | Puerto Rico | 72089 | 19 | |
180722 | 180722 | 2020-05-26 | Manati | Puerto Rico | 72091 | 25 | |
180723 | 180723 | 2020-05-26 | Maricao | Puerto Rico | 72093 | 3 | |
180724 | 180724 | 2020-05-26 | Maunabo | Puerto Rico | 72095 | 14 | |
180725 | 180725 | 2020-05-26 | Mayaguez | Puerto Rico | 72097 | 80 | |
180726 | 180726 | 2020-05-26 | Moca | Puerto Rico | 72099 | 20 | |
180727 | 180727 | 2020-05-26 | Morovis | Puerto Rico | 72101 | 33 | |
180728 | 180728 | 2020-05-26 | Naguabo | Puerto Rico | 72103 | 22 | |
180729 | 180729 | 2020-05-26 | Naranjito | Puerto Rico | 72105 | 44 | |
180730 | 180730 | 2020-05-26 | Orocovis | Puerto Rico | 72107 | 41 | |
180731 | 180731 | 2020-05-26 | Patillas | Puerto Rico | 72109 | 31 | |
180732 | 180732 | 2020-05-26 | Penuelas | Puerto Rico | 72111 | 7 | |
180733 | 180733 | 2020-05-26 | Ponce | Puerto Rico | 72113 | 92 | |
180734 | 180734 | 2020-05-26 | Quebradillas | Puerto Rico | 72115 | 27 | |
180735 | 180735 | 2020-05-26 | Rincon | Puerto Rico | 72117 | 8 | |
180736 | 180736 | 2020-05-26 | Rio Grande | Puerto Rico | 72119 | 45 | |
180737 | 180737 | 2020-05-26 | Sabana Grande | Puerto Rico | 72121 | 26 | |
180738 | 180738 | 2020-05-26 | Salinas | Puerto Rico | 72123 | 62 | |
180739 | 180739 | 2020-05-26 | San German | Puerto Rico | 72125 | 33 | |
180740 | 180740 | 2020-05-26 | San Juan | Puerto Rico | 72127 | 472 | |
180741 | 180741 | 2020-05-26 | San Lorenzo | Puerto Rico | 72129 | 35 | |
180742 | 180742 | 2020-05-26 | San Sebastian | Puerto Rico | 72131 | 38 | |
180743 | 180743 | 2020-05-26 | Santa Isabel | Puerto Rico | 72133 | 15 | |
180744 | 180744 | 2020-05-26 | Toa Alta | Puerto Rico | 72135 | 82 | |
180745 | 180745 | 2020-05-26 | Toa Baja | Puerto Rico | 72137 | 89 | |
180746 | 180746 | 2020-05-26 | Trujillo Alto | Puerto Rico | 72139 | 57 | |
180747 | 180747 | 2020-05-26 | Unknown | Puerto Rico | 110 | 129 | |
180748 | 180748 | 2020-05-26 | Utuado | Puerto Rico | 72141 | 3 | |
180749 | 180749 | 2020-05-26 | Vega Alta | Puerto Rico | 72143 | 39 | |
180750 | 180750 | 2020-05-26 | Vega Baja | Puerto Rico | 72145 | 37 | |
180751 | 180751 | 2020-05-26 | Vieques | Puerto Rico | 72147 | 19 | |
180752 | 180752 | 2020-05-26 | Villalba | Puerto Rico | 72149 | 24 | |
180753 | 180753 | 2020-05-26 | Yabucoa | Puerto Rico | 72151 | 10 | |
180754 | 180754 | 2020-05-26 | Yauco | Puerto Rico | 72153 | 44 |
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);