ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2022-05-09" 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 |
---|---|---|---|---|---|---|---|
2488882 | 2488882 | 2022-05-09 | Adjuntas | Puerto Rico | 72001 | 2684 | |
2488883 | 2488883 | 2022-05-09 | Aguada | Puerto Rico | 72003 | 7357 | |
2488884 | 2488884 | 2022-05-09 | Aguadilla | Puerto Rico | 72005 | 8297 | |
2488885 | 2488885 | 2022-05-09 | Aguas Buenas | Puerto Rico | 72007 | 4583 | |
2488886 | 2488886 | 2022-05-09 | Aibonito | Puerto Rico | 72009 | 4179 | |
2488887 | 2488887 | 2022-05-09 | Anasco | Puerto Rico | 72011 | 4348 | |
2488888 | 2488888 | 2022-05-09 | Arecibo | Puerto Rico | 72013 | 14808 | |
2488889 | 2488889 | 2022-05-09 | Arroyo | Puerto Rico | 72015 | 2635 | |
2488890 | 2488890 | 2022-05-09 | Barceloneta | Puerto Rico | 72017 | 3944 | |
2488891 | 2488891 | 2022-05-09 | Barranquitas | Puerto Rico | 72019 | 5409 | |
2488892 | 2488892 | 2022-05-09 | Bayamon | Puerto Rico | 72021 | 38749 | |
2488893 | 2488893 | 2022-05-09 | Cabo Rojo | Puerto Rico | 72023 | 6371 | |
2488894 | 2488894 | 2022-05-09 | Caguas | Puerto Rico | 72025 | 24588 | |
2488895 | 2488895 | 2022-05-09 | Camuy | Puerto Rico | 72027 | 5858 | |
2488896 | 2488896 | 2022-05-09 | Canovanas | Puerto Rico | 72029 | 7291 | |
2488897 | 2488897 | 2022-05-09 | Carolina | Puerto Rico | 72031 | 31824 | |
2488898 | 2488898 | 2022-05-09 | Catano | Puerto Rico | 72033 | 4699 | |
2488899 | 2488899 | 2022-05-09 | Cayey | Puerto Rico | 72035 | 7041 | |
2488900 | 2488900 | 2022-05-09 | Ceiba | Puerto Rico | 72037 | 1646 | |
2488901 | 2488901 | 2022-05-09 | Ciales | Puerto Rico | 72039 | 2975 | |
2488902 | 2488902 | 2022-05-09 | Cidra | Puerto Rico | 72041 | 6909 | |
2488903 | 2488903 | 2022-05-09 | Coamo | Puerto Rico | 72043 | 5761 | |
2488904 | 2488904 | 2022-05-09 | Comerio | Puerto Rico | 72045 | 3253 | |
2488905 | 2488905 | 2022-05-09 | Corozal | Puerto Rico | 72047 | 7074 | |
2488906 | 2488906 | 2022-05-09 | Culebra | Puerto Rico | 72049 | 200 | |
2488907 | 2488907 | 2022-05-09 | Dorado | Puerto Rico | 72051 | 7662 | |
2488908 | 2488908 | 2022-05-09 | Fajardo | Puerto Rico | 72053 | 5220 | |
2488909 | 2488909 | 2022-05-09 | Florida | Puerto Rico | 72054 | 2848 | |
2488910 | 2488910 | 2022-05-09 | Guanica | Puerto Rico | 72055 | 1722 | |
2488911 | 2488911 | 2022-05-09 | Guayama | Puerto Rico | 72057 | 6116 | |
2488912 | 2488912 | 2022-05-09 | Guayanilla | Puerto Rico | 72059 | 2650 | |
2488913 | 2488913 | 2022-05-09 | Guaynabo | Puerto Rico | 72061 | 17976 | |
2488914 | 2488914 | 2022-05-09 | Gurabo | Puerto Rico | 72063 | 8451 | |
2488915 | 2488915 | 2022-05-09 | Hatillo | Puerto Rico | 72065 | 6095 | |
2488916 | 2488916 | 2022-05-09 | Hormigueros | Puerto Rico | 72067 | 2401 | |
2488917 | 2488917 | 2022-05-09 | Humacao | Puerto Rico | 72069 | 8983 | |
2488918 | 2488918 | 2022-05-09 | Isabela | Puerto Rico | 72071 | 7481 | |
2488919 | 2488919 | 2022-05-09 | Jayuya | Puerto Rico | 72073 | 2785 | |
2488920 | 2488920 | 2022-05-09 | Juana Diaz | Puerto Rico | 72075 | 7382 | |
2488921 | 2488921 | 2022-05-09 | Juncos | Puerto Rico | 72077 | 7137 | |
2488922 | 2488922 | 2022-05-09 | Lajas | Puerto Rico | 72079 | 3207 | |
2488923 | 2488923 | 2022-05-09 | Lares | Puerto Rico | 72081 | 4802 | |
2488924 | 2488924 | 2022-05-09 | Las Marias | Puerto Rico | 72083 | 1332 | |
2488925 | 2488925 | 2022-05-09 | Las Piedras | Puerto Rico | 72085 | 6218 | |
2488926 | 2488926 | 2022-05-09 | Loiza | Puerto Rico | 72087 | 3762 | |
2488927 | 2488927 | 2022-05-09 | Luquillo | Puerto Rico | 72089 | 2867 | |
2488928 | 2488928 | 2022-05-09 | Manati | Puerto Rico | 72091 | 7026 | |
2488929 | 2488929 | 2022-05-09 | Maricao | Puerto Rico | 72093 | 669 | |
2488930 | 2488930 | 2022-05-09 | Maunabo | Puerto Rico | 72095 | 1598 | |
2488931 | 2488931 | 2022-05-09 | Mayaguez | Puerto Rico | 72097 | 11401 | |
2488932 | 2488932 | 2022-05-09 | Moca | Puerto Rico | 72099 | 6933 | |
2488933 | 2488933 | 2022-05-09 | Morovis | Puerto Rico | 72101 | 5509 | |
2488934 | 2488934 | 2022-05-09 | Naguabo | Puerto Rico | 72103 | 3797 | |
2488935 | 2488935 | 2022-05-09 | Naranjito | Puerto Rico | 72105 | 5699 | |
2488936 | 2488936 | 2022-05-09 | Orocovis | Puerto Rico | 72107 | 3351 | |
2488937 | 2488937 | 2022-05-09 | Patillas | Puerto Rico | 72109 | 2684 | |
2488938 | 2488938 | 2022-05-09 | Penuelas | Puerto Rico | 72111 | 2712 | |
2488939 | 2488939 | 2022-05-09 | Ponce | Puerto Rico | 72113 | 21199 | |
2488940 | 2488940 | 2022-05-09 | Quebradillas | Puerto Rico | 72115 | 4640 | |
2488941 | 2488941 | 2022-05-09 | Rincon | Puerto Rico | 72117 | 2511 | |
2488942 | 2488942 | 2022-05-09 | Rio Grande | Puerto Rico | 72119 | 8443 | |
2488943 | 2488943 | 2022-05-09 | Sabana Grande | Puerto Rico | 72121 | 2865 | |
2488944 | 2488944 | 2022-05-09 | Salinas | Puerto Rico | 72123 | 4156 | |
2488945 | 2488945 | 2022-05-09 | San German | Puerto Rico | 72125 | 4528 | |
2488946 | 2488946 | 2022-05-09 | San Juan | Puerto Rico | 72127 | 66204 | |
2488947 | 2488947 | 2022-05-09 | San Lorenzo | Puerto Rico | 72129 | 6280 | |
2488948 | 2488948 | 2022-05-09 | San Sebastian | Puerto Rico | 72131 | 7029 | |
2488949 | 2488949 | 2022-05-09 | Santa Isabel | Puerto Rico | 72133 | 3237 | |
2488950 | 2488950 | 2022-05-09 | Toa Alta | Puerto Rico | 72135 | 13559 | |
2488951 | 2488951 | 2022-05-09 | Toa Baja | Puerto Rico | 72137 | 14512 | |
2488952 | 2488952 | 2022-05-09 | Trujillo Alto | Puerto Rico | 72139 | 11457 | |
2488953 | 2488953 | 2022-05-09 | Unknown | Puerto Rico | 20349 | 4232 | |
2488954 | 2488954 | 2022-05-09 | Utuado | Puerto Rico | 72141 | 3967 | |
2488955 | 2488955 | 2022-05-09 | Vega Alta | Puerto Rico | 72143 | 7008 | |
2488956 | 2488956 | 2022-05-09 | Vega Baja | Puerto Rico | 72145 | 11658 | |
2488957 | 2488957 | 2022-05-09 | Vieques | Puerto Rico | 72147 | 880 | |
2488958 | 2488958 | 2022-05-09 | Villalba | Puerto Rico | 72149 | 3909 | |
2488959 | 2488959 | 2022-05-09 | Yabucoa | Puerto Rico | 72151 | 5308 | |
2488960 | 2488960 | 2022-05-09 | Yauco | Puerto Rico | 72153 | 5213 |
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);