ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2022-02-23" 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 |
---|---|---|---|---|---|---|---|
2244823 | 2244823 | 2022-02-23 | Adjuntas | Puerto Rico | 72001 | 2129 | |
2244824 | 2244824 | 2022-02-23 | Aguada | Puerto Rico | 72003 | 5943 | |
2244825 | 2244825 | 2022-02-23 | Aguadilla | Puerto Rico | 72005 | 6906 | |
2244826 | 2244826 | 2022-02-23 | Aguas Buenas | Puerto Rico | 72007 | 3867 | |
2244827 | 2244827 | 2022-02-23 | Aibonito | Puerto Rico | 72009 | 3453 | |
2244828 | 2244828 | 2022-02-23 | Anasco | Puerto Rico | 72011 | 3436 | |
2244829 | 2244829 | 2022-02-23 | Arecibo | Puerto Rico | 72013 | 12142 | |
2244830 | 2244830 | 2022-02-23 | Arroyo | Puerto Rico | 72015 | 1799 | |
2244831 | 2244831 | 2022-02-23 | Barceloneta | Puerto Rico | 72017 | 3094 | |
2244832 | 2244832 | 2022-02-23 | Barranquitas | Puerto Rico | 72019 | 4553 | |
2244833 | 2244833 | 2022-02-23 | Bayamon | Puerto Rico | 72021 | 32916 | |
2244834 | 2244834 | 2022-02-23 | Cabo Rojo | Puerto Rico | 72023 | 4906 | |
2244835 | 2244835 | 2022-02-23 | Caguas | Puerto Rico | 72025 | 20777 | |
2244836 | 2244836 | 2022-02-23 | Camuy | Puerto Rico | 72027 | 4558 | |
2244837 | 2244837 | 2022-02-23 | Canovanas | Puerto Rico | 72029 | 6269 | |
2244838 | 2244838 | 2022-02-23 | Carolina | Puerto Rico | 72031 | 26980 | |
2244839 | 2244839 | 2022-02-23 | Catano | Puerto Rico | 72033 | 4011 | |
2244840 | 2244840 | 2022-02-23 | Cayey | Puerto Rico | 72035 | 5623 | |
2244841 | 2244841 | 2022-02-23 | Ceiba | Puerto Rico | 72037 | 1339 | |
2244842 | 2244842 | 2022-02-23 | Ciales | Puerto Rico | 72039 | 2463 | |
2244843 | 2244843 | 2022-02-23 | Cidra | Puerto Rico | 72041 | 5410 | |
2244844 | 2244844 | 2022-02-23 | Coamo | Puerto Rico | 72043 | 4344 | |
2244845 | 2244845 | 2022-02-23 | Comerio | Puerto Rico | 72045 | 2729 | |
2244846 | 2244846 | 2022-02-23 | Corozal | Puerto Rico | 72047 | 5985 | |
2244847 | 2244847 | 2022-02-23 | Culebra | Puerto Rico | 72049 | 160 | |
2244848 | 2244848 | 2022-02-23 | Dorado | Puerto Rico | 72051 | 6509 | |
2244849 | 2244849 | 2022-02-23 | Fajardo | Puerto Rico | 72053 | 4459 | |
2244850 | 2244850 | 2022-02-23 | Florida | Puerto Rico | 72054 | 2360 | |
2244851 | 2244851 | 2022-02-23 | Guanica | Puerto Rico | 72055 | 1411 | |
2244852 | 2244852 | 2022-02-23 | Guayama | Puerto Rico | 72057 | 4480 | |
2244853 | 2244853 | 2022-02-23 | Guayanilla | Puerto Rico | 72059 | 1981 | |
2244854 | 2244854 | 2022-02-23 | Guaynabo | Puerto Rico | 72061 | 14789 | |
2244855 | 2244855 | 2022-02-23 | Gurabo | Puerto Rico | 72063 | 7014 | |
2244856 | 2244856 | 2022-02-23 | Hatillo | Puerto Rico | 72065 | 4963 | |
2244857 | 2244857 | 2022-02-23 | Hormigueros | Puerto Rico | 72067 | 1758 | |
2244858 | 2244858 | 2022-02-23 | Humacao | Puerto Rico | 72069 | 7434 | |
2244859 | 2244859 | 2022-02-23 | Isabela | Puerto Rico | 72071 | 6398 | |
2244860 | 2244860 | 2022-02-23 | Jayuya | Puerto Rico | 72073 | 2043 | |
2244861 | 2244861 | 2022-02-23 | Juana Diaz | Puerto Rico | 72075 | 5653 | |
2244862 | 2244862 | 2022-02-23 | Juncos | Puerto Rico | 72077 | 5936 | |
2244863 | 2244863 | 2022-02-23 | Lajas | Puerto Rico | 72079 | 2417 | |
2244864 | 2244864 | 2022-02-23 | Lares | Puerto Rico | 72081 | 3599 | |
2244865 | 2244865 | 2022-02-23 | Las Marias | Puerto Rico | 72083 | 1051 | |
2244866 | 2244866 | 2022-02-23 | Las Piedras | Puerto Rico | 72085 | 5108 | |
2244867 | 2244867 | 2022-02-23 | Loiza | Puerto Rico | 72087 | 3119 | |
2244868 | 2244868 | 2022-02-23 | Luquillo | Puerto Rico | 72089 | 2437 | |
2244869 | 2244869 | 2022-02-23 | Manati | Puerto Rico | 72091 | 5806 | |
2244870 | 2244870 | 2022-02-23 | Maricao | Puerto Rico | 72093 | 548 | |
2244871 | 2244871 | 2022-02-23 | Maunabo | Puerto Rico | 72095 | 1326 | |
2244872 | 2244872 | 2022-02-23 | Mayaguez | Puerto Rico | 72097 | 9371 | |
2244873 | 2244873 | 2022-02-23 | Moca | Puerto Rico | 72099 | 5606 | |
2244874 | 2244874 | 2022-02-23 | Morovis | Puerto Rico | 72101 | 4448 | |
2244875 | 2244875 | 2022-02-23 | Naguabo | Puerto Rico | 72103 | 3221 | |
2244876 | 2244876 | 2022-02-23 | Naranjito | Puerto Rico | 72105 | 4905 | |
2244877 | 2244877 | 2022-02-23 | Orocovis | Puerto Rico | 72107 | 2810 | |
2244878 | 2244878 | 2022-02-23 | Patillas | Puerto Rico | 72109 | 1952 | |
2244879 | 2244879 | 2022-02-23 | Penuelas | Puerto Rico | 72111 | 2182 | |
2244880 | 2244880 | 2022-02-23 | Ponce | Puerto Rico | 72113 | 16948 | |
2244881 | 2244881 | 2022-02-23 | Quebradillas | Puerto Rico | 72115 | 3557 | |
2244882 | 2244882 | 2022-02-23 | Rincon | Puerto Rico | 72117 | 2109 | |
2244883 | 2244883 | 2022-02-23 | Rio Grande | Puerto Rico | 72119 | 7205 | |
2244884 | 2244884 | 2022-02-23 | Sabana Grande | Puerto Rico | 72121 | 2200 | |
2244885 | 2244885 | 2022-02-23 | Salinas | Puerto Rico | 72123 | 3329 | |
2244886 | 2244886 | 2022-02-23 | San German | Puerto Rico | 72125 | 3407 | |
2244887 | 2244887 | 2022-02-23 | San Juan | Puerto Rico | 72127 | 58891 | |
2244888 | 2244888 | 2022-02-23 | San Lorenzo | Puerto Rico | 72129 | 5212 | |
2244889 | 2244889 | 2022-02-23 | San Sebastian | Puerto Rico | 72131 | 6009 | |
2244890 | 2244890 | 2022-02-23 | Santa Isabel | Puerto Rico | 72133 | 2484 | |
2244891 | 2244891 | 2022-02-23 | Toa Alta | Puerto Rico | 72135 | 11606 | |
2244892 | 2244892 | 2022-02-23 | Toa Baja | Puerto Rico | 72137 | 12395 | |
2244893 | 2244893 | 2022-02-23 | Trujillo Alto | Puerto Rico | 72139 | 9625 | |
2244894 | 2244894 | 2022-02-23 | Unknown | Puerto Rico | 16641 | 4088 | |
2244895 | 2244895 | 2022-02-23 | Utuado | Puerto Rico | 72141 | 3200 | |
2244896 | 2244896 | 2022-02-23 | Vega Alta | Puerto Rico | 72143 | 6025 | |
2244897 | 2244897 | 2022-02-23 | Vega Baja | Puerto Rico | 72145 | 10093 | |
2244898 | 2244898 | 2022-02-23 | Vieques | Puerto Rico | 72147 | 704 | |
2244899 | 2244899 | 2022-02-23 | Villalba | Puerto Rico | 72149 | 2917 | |
2244900 | 2244900 | 2022-02-23 | Yabucoa | Puerto Rico | 72151 | 4201 | |
2244901 | 2244901 | 2022-02-23 | Yauco | Puerto Rico | 72153 | 4071 |
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);