ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where "date" is on date 2021-06-23 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
- 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 |
---|---|---|---|---|---|---|---|
1448671 | 1448671 | 2021-06-23 | Adjuntas | Puerto Rico | 72001 | 553 | |
1448672 | 1448672 | 2021-06-23 | Aguada | Puerto Rico | 72003 | 1556 | |
1448673 | 1448673 | 2021-06-23 | Aguadilla | Puerto Rico | 72005 | 1899 | |
1448674 | 1448674 | 2021-06-23 | Aguas Buenas | Puerto Rico | 72007 | 1382 | |
1448675 | 1448675 | 2021-06-23 | Aibonito | Puerto Rico | 72009 | 813 | |
1448676 | 1448676 | 2021-06-23 | Anasco | Puerto Rico | 72011 | 988 | |
1448677 | 1448677 | 2021-06-23 | Arecibo | Puerto Rico | 72013 | 3554 | |
1448678 | 1448678 | 2021-06-23 | Arroyo | Puerto Rico | 72015 | 461 | |
1448679 | 1448679 | 2021-06-23 | Barceloneta | Puerto Rico | 72017 | 934 | |
1448680 | 1448680 | 2021-06-23 | Barranquitas | Puerto Rico | 72019 | 1614 | |
1448681 | 1448681 | 2021-06-23 | Bayamon | Puerto Rico | 72021 | 12662 | |
1448682 | 1448682 | 2021-06-23 | Cabo Rojo | Puerto Rico | 72023 | 1283 | |
1448683 | 1448683 | 2021-06-23 | Caguas | Puerto Rico | 72025 | 7339 | |
1448684 | 1448684 | 2021-06-23 | Camuy | Puerto Rico | 72027 | 1419 | |
1448685 | 1448685 | 2021-06-23 | Canovanas | Puerto Rico | 72029 | 2393 | |
1448686 | 1448686 | 2021-06-23 | Carolina | Puerto Rico | 72031 | 10306 | |
1448687 | 1448687 | 2021-06-23 | Catano | Puerto Rico | 72033 | 1547 | |
1448688 | 1448688 | 2021-06-23 | Cayey | Puerto Rico | 72035 | 1636 | |
1448689 | 1448689 | 2021-06-23 | Ceiba | Puerto Rico | 72037 | 524 | |
1448690 | 1448690 | 2021-06-23 | Ciales | Puerto Rico | 72039 | 931 | |
1448691 | 1448691 | 2021-06-23 | Cidra | Puerto Rico | 72041 | 1511 | |
1448692 | 1448692 | 2021-06-23 | Coamo | Puerto Rico | 72043 | 1170 | |
1448693 | 1448693 | 2021-06-23 | Comerio | Puerto Rico | 72045 | 876 | |
1448694 | 1448694 | 2021-06-23 | Corozal | Puerto Rico | 72047 | 2076 | |
1448695 | 1448695 | 2021-06-23 | Culebra | Puerto Rico | 72049 | 44 | |
1448696 | 1448696 | 2021-06-23 | Dorado | Puerto Rico | 72051 | 2681 | |
1448697 | 1448697 | 2021-06-23 | Fajardo | Puerto Rico | 72053 | 1690 | |
1448698 | 1448698 | 2021-06-23 | Florida | Puerto Rico | 72054 | 850 | |
1448699 | 1448699 | 2021-06-23 | Guanica | Puerto Rico | 72055 | 340 | |
1448700 | 1448700 | 2021-06-23 | Guayama | Puerto Rico | 72057 | 1093 | |
1448701 | 1448701 | 2021-06-23 | Guayanilla | Puerto Rico | 72059 | 575 | |
1448702 | 1448702 | 2021-06-23 | Guaynabo | Puerto Rico | 72061 | 5295 | |
1448703 | 1448703 | 2021-06-23 | Gurabo | Puerto Rico | 72063 | 2531 | |
1448704 | 1448704 | 2021-06-23 | Hatillo | Puerto Rico | 72065 | 1367 | |
1448705 | 1448705 | 2021-06-23 | Hormigueros | Puerto Rico | 72067 | 519 | |
1448706 | 1448706 | 2021-06-23 | Humacao | Puerto Rico | 72069 | 2515 | |
1448707 | 1448707 | 2021-06-23 | Isabela | Puerto Rico | 72071 | 1632 | |
1448708 | 1448708 | 2021-06-23 | Jayuya | Puerto Rico | 72073 | 594 | |
1448709 | 1448709 | 2021-06-23 | Juana Diaz | Puerto Rico | 72075 | 1399 | |
1448710 | 1448710 | 2021-06-23 | Juncos | Puerto Rico | 72077 | 2541 | |
1448711 | 1448711 | 2021-06-23 | Lajas | Puerto Rico | 72079 | 608 | |
1448712 | 1448712 | 2021-06-23 | Lares | Puerto Rico | 72081 | 1120 | |
1448713 | 1448713 | 2021-06-23 | Las Marias | Puerto Rico | 72083 | 325 | |
1448714 | 1448714 | 2021-06-23 | Las Piedras | Puerto Rico | 72085 | 1960 | |
1448715 | 1448715 | 2021-06-23 | Loiza | Puerto Rico | 72087 | 1451 | |
1448716 | 1448716 | 2021-06-23 | Luquillo | Puerto Rico | 72089 | 929 | |
1448717 | 1448717 | 2021-06-23 | Manati | Puerto Rico | 72091 | 1920 | |
1448718 | 1448718 | 2021-06-23 | Maricao | Puerto Rico | 72093 | 152 | |
1448719 | 1448719 | 2021-06-23 | Maunabo | Puerto Rico | 72095 | 481 | |
1448720 | 1448720 | 2021-06-23 | Mayaguez | Puerto Rico | 72097 | 2544 | |
1448721 | 1448721 | 2021-06-23 | Moca | Puerto Rico | 72099 | 1695 | |
1448722 | 1448722 | 2021-06-23 | Morovis | Puerto Rico | 72101 | 1739 | |
1448723 | 1448723 | 2021-06-23 | Naguabo | Puerto Rico | 72103 | 1213 | |
1448724 | 1448724 | 2021-06-23 | Naranjito | Puerto Rico | 72105 | 2048 | |
1448725 | 1448725 | 2021-06-23 | Orocovis | Puerto Rico | 72107 | 1108 | |
1448726 | 1448726 | 2021-06-23 | Patillas | Puerto Rico | 72109 | 509 | |
1448727 | 1448727 | 2021-06-23 | Penuelas | Puerto Rico | 72111 | 664 | |
1448728 | 1448728 | 2021-06-23 | Ponce | Puerto Rico | 72113 | 4123 | |
1448729 | 1448729 | 2021-06-23 | Quebradillas | Puerto Rico | 72115 | 1028 | |
1448730 | 1448730 | 2021-06-23 | Rincon | Puerto Rico | 72117 | 670 | |
1448731 | 1448731 | 2021-06-23 | Rio Grande | Puerto Rico | 72119 | 2551 | |
1448732 | 1448732 | 2021-06-23 | Sabana Grande | Puerto Rico | 72121 | 551 | |
1448733 | 1448733 | 2021-06-23 | Salinas | Puerto Rico | 72123 | 1209 | |
1448734 | 1448734 | 2021-06-23 | San German | Puerto Rico | 72125 | 829 | |
1448735 | 1448735 | 2021-06-23 | San Juan | Puerto Rico | 72127 | 22671 | |
1448736 | 1448736 | 2021-06-23 | San Lorenzo | Puerto Rico | 72129 | 2047 | |
1448737 | 1448737 | 2021-06-23 | San Sebastian | Puerto Rico | 72131 | 1961 | |
1448738 | 1448738 | 2021-06-23 | Santa Isabel | Puerto Rico | 72133 | 697 | |
1448739 | 1448739 | 2021-06-23 | Toa Alta | Puerto Rico | 72135 | 4770 | |
1448740 | 1448740 | 2021-06-23 | Toa Baja | Puerto Rico | 72137 | 4878 | |
1448741 | 1448741 | 2021-06-23 | Trujillo Alto | Puerto Rico | 72139 | 3672 | |
1448742 | 1448742 | 2021-06-23 | Unknown | Puerto Rico | 5592 | 2543 | |
1448743 | 1448743 | 2021-06-23 | Utuado | Puerto Rico | 72141 | 1081 | |
1448744 | 1448744 | 2021-06-23 | Vega Alta | Puerto Rico | 72143 | 2289 | |
1448745 | 1448745 | 2021-06-23 | Vega Baja | Puerto Rico | 72145 | 3470 | |
1448746 | 1448746 | 2021-06-23 | Vieques | Puerto Rico | 72147 | 205 | |
1448747 | 1448747 | 2021-06-23 | Villalba | Puerto Rico | 72149 | 881 | |
1448748 | 1448748 | 2021-06-23 | Yabucoa | Puerto Rico | 72151 | 1404 | |
1448749 | 1448749 | 2021-06-23 | Yauco | Puerto Rico | 72153 | 1258 |
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);