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 2022-05-12 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 |
---|---|---|---|---|---|---|---|
2498656 | 2498656 | 2022-05-12 | Adjuntas | Puerto Rico | 72001 | 2781 | |
2498657 | 2498657 | 2022-05-12 | Aguada | Puerto Rico | 72003 | 7524 | |
2498658 | 2498658 | 2022-05-12 | Aguadilla | Puerto Rico | 72005 | 8523 | |
2498659 | 2498659 | 2022-05-12 | Aguas Buenas | Puerto Rico | 72007 | 4697 | |
2498660 | 2498660 | 2022-05-12 | Aibonito | Puerto Rico | 72009 | 4265 | |
2498661 | 2498661 | 2022-05-12 | Anasco | Puerto Rico | 72011 | 4444 | |
2498662 | 2498662 | 2022-05-12 | Arecibo | Puerto Rico | 72013 | 15042 | |
2498663 | 2498663 | 2022-05-12 | Arroyo | Puerto Rico | 72015 | 2691 | |
2498664 | 2498664 | 2022-05-12 | Barceloneta | Puerto Rico | 72017 | 4053 | |
2498665 | 2498665 | 2022-05-12 | Barranquitas | Puerto Rico | 72019 | 5487 | |
2498666 | 2498666 | 2022-05-12 | Bayamon | Puerto Rico | 72021 | 39367 | |
2498667 | 2498667 | 2022-05-12 | Cabo Rojo | Puerto Rico | 72023 | 6582 | |
2498668 | 2498668 | 2022-05-12 | Caguas | Puerto Rico | 72025 | 25063 | |
2498669 | 2498669 | 2022-05-12 | Camuy | Puerto Rico | 72027 | 5988 | |
2498670 | 2498670 | 2022-05-12 | Canovanas | Puerto Rico | 72029 | 7402 | |
2498671 | 2498671 | 2022-05-12 | Carolina | Puerto Rico | 72031 | 32314 | |
2498672 | 2498672 | 2022-05-12 | Catano | Puerto Rico | 72033 | 4748 | |
2498673 | 2498673 | 2022-05-12 | Cayey | Puerto Rico | 72035 | 7199 | |
2498674 | 2498674 | 2022-05-12 | Ceiba | Puerto Rico | 72037 | 1683 | |
2498675 | 2498675 | 2022-05-12 | Ciales | Puerto Rico | 72039 | 3030 | |
2498676 | 2498676 | 2022-05-12 | Cidra | Puerto Rico | 72041 | 7062 | |
2498677 | 2498677 | 2022-05-12 | Coamo | Puerto Rico | 72043 | 5899 | |
2498678 | 2498678 | 2022-05-12 | Comerio | Puerto Rico | 72045 | 3327 | |
2498679 | 2498679 | 2022-05-12 | Corozal | Puerto Rico | 72047 | 7208 | |
2498680 | 2498680 | 2022-05-12 | Culebra | Puerto Rico | 72049 | 207 | |
2498681 | 2498681 | 2022-05-12 | Dorado | Puerto Rico | 72051 | 7773 | |
2498682 | 2498682 | 2022-05-12 | Fajardo | Puerto Rico | 72053 | 5353 | |
2498683 | 2498683 | 2022-05-12 | Florida | Puerto Rico | 72054 | 2886 | |
2498684 | 2498684 | 2022-05-12 | Guanica | Puerto Rico | 72055 | 1760 | |
2498685 | 2498685 | 2022-05-12 | Guayama | Puerto Rico | 72057 | 6246 | |
2498686 | 2498686 | 2022-05-12 | Guayanilla | Puerto Rico | 72059 | 2743 | |
2498687 | 2498687 | 2022-05-12 | Guaynabo | Puerto Rico | 72061 | 18340 | |
2498688 | 2498688 | 2022-05-12 | Gurabo | Puerto Rico | 72063 | 8609 | |
2498689 | 2498689 | 2022-05-12 | Hatillo | Puerto Rico | 72065 | 6232 | |
2498690 | 2498690 | 2022-05-12 | Hormigueros | Puerto Rico | 72067 | 2450 | |
2498691 | 2498691 | 2022-05-12 | Humacao | Puerto Rico | 72069 | 9147 | |
2498692 | 2498692 | 2022-05-12 | Isabela | Puerto Rico | 72071 | 7631 | |
2498693 | 2498693 | 2022-05-12 | Jayuya | Puerto Rico | 72073 | 2885 | |
2498694 | 2498694 | 2022-05-12 | Juana Diaz | Puerto Rico | 72075 | 7613 | |
2498695 | 2498695 | 2022-05-12 | Juncos | Puerto Rico | 72077 | 7251 | |
2498696 | 2498696 | 2022-05-12 | Lajas | Puerto Rico | 72079 | 3322 | |
2498697 | 2498697 | 2022-05-12 | Lares | Puerto Rico | 72081 | 4980 | |
2498698 | 2498698 | 2022-05-12 | Las Marias | Puerto Rico | 72083 | 1375 | |
2498699 | 2498699 | 2022-05-12 | Las Piedras | Puerto Rico | 72085 | 6314 | |
2498700 | 2498700 | 2022-05-12 | Loiza | Puerto Rico | 72087 | 3806 | |
2498701 | 2498701 | 2022-05-12 | Luquillo | Puerto Rico | 72089 | 2912 | |
2498702 | 2498702 | 2022-05-12 | Manati | Puerto Rico | 72091 | 7140 | |
2498703 | 2498703 | 2022-05-12 | Maricao | Puerto Rico | 72093 | 704 | |
2498704 | 2498704 | 2022-05-12 | Maunabo | Puerto Rico | 72095 | 1638 | |
2498705 | 2498705 | 2022-05-12 | Mayaguez | Puerto Rico | 72097 | 11704 | |
2498706 | 2498706 | 2022-05-12 | Moca | Puerto Rico | 72099 | 7068 | |
2498707 | 2498707 | 2022-05-12 | Morovis | Puerto Rico | 72101 | 5601 | |
2498708 | 2498708 | 2022-05-12 | Naguabo | Puerto Rico | 72103 | 3902 | |
2498709 | 2498709 | 2022-05-12 | Naranjito | Puerto Rico | 72105 | 5775 | |
2498710 | 2498710 | 2022-05-12 | Orocovis | Puerto Rico | 72107 | 3417 | |
2498711 | 2498711 | 2022-05-12 | Patillas | Puerto Rico | 72109 | 2739 | |
2498712 | 2498712 | 2022-05-12 | Penuelas | Puerto Rico | 72111 | 2770 | |
2498713 | 2498713 | 2022-05-12 | Ponce | Puerto Rico | 72113 | 21697 | |
2498714 | 2498714 | 2022-05-12 | Quebradillas | Puerto Rico | 72115 | 4727 | |
2498715 | 2498715 | 2022-05-12 | Rincon | Puerto Rico | 72117 | 2547 | |
2498716 | 2498716 | 2022-05-12 | Rio Grande | Puerto Rico | 72119 | 8585 | |
2498717 | 2498717 | 2022-05-12 | Sabana Grande | Puerto Rico | 72121 | 2954 | |
2498718 | 2498718 | 2022-05-12 | Salinas | Puerto Rico | 72123 | 4232 | |
2498719 | 2498719 | 2022-05-12 | San German | Puerto Rico | 72125 | 4647 | |
2498720 | 2498720 | 2022-05-12 | San Juan | Puerto Rico | 72127 | 67106 | |
2498721 | 2498721 | 2022-05-12 | San Lorenzo | Puerto Rico | 72129 | 6402 | |
2498722 | 2498722 | 2022-05-12 | San Sebastian | Puerto Rico | 72131 | 7195 | |
2498723 | 2498723 | 2022-05-12 | Santa Isabel | Puerto Rico | 72133 | 3310 | |
2498724 | 2498724 | 2022-05-12 | Toa Alta | Puerto Rico | 72135 | 13772 | |
2498725 | 2498725 | 2022-05-12 | Toa Baja | Puerto Rico | 72137 | 14714 | |
2498726 | 2498726 | 2022-05-12 | Trujillo Alto | Puerto Rico | 72139 | 11656 | |
2498727 | 2498727 | 2022-05-12 | Unknown | Puerto Rico | 20803 | 4245 | |
2498728 | 2498728 | 2022-05-12 | Utuado | Puerto Rico | 72141 | 4048 | |
2498729 | 2498729 | 2022-05-12 | Vega Alta | Puerto Rico | 72143 | 7127 | |
2498730 | 2498730 | 2022-05-12 | Vega Baja | Puerto Rico | 72145 | 11837 | |
2498731 | 2498731 | 2022-05-12 | Vieques | Puerto Rico | 72147 | 924 | |
2498732 | 2498732 | 2022-05-12 | Villalba | Puerto Rico | 72149 | 3990 | |
2498733 | 2498733 | 2022-05-12 | Yabucoa | Puerto Rico | 72151 | 5436 | |
2498734 | 2498734 | 2022-05-12 | Yauco | Puerto Rico | 72153 | 5389 |
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);