ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2021-02-18" 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 |
---|---|---|---|---|---|---|---|
1042850 | 1042850 | 2021-02-18 | Adjuntas | Puerto Rico | 72001 | 459 | |
1042851 | 1042851 | 2021-02-18 | Aguada | Puerto Rico | 72003 | 1193 | |
1042852 | 1042852 | 2021-02-18 | Aguadilla | Puerto Rico | 72005 | 1473 | |
1042853 | 1042853 | 2021-02-18 | Aguas Buenas | Puerto Rico | 72007 | 1021 | |
1042854 | 1042854 | 2021-02-18 | Aibonito | Puerto Rico | 72009 | 571 | |
1042855 | 1042855 | 2021-02-18 | Anasco | Puerto Rico | 72011 | 806 | |
1042856 | 1042856 | 2021-02-18 | Arecibo | Puerto Rico | 72013 | 2820 | |
1042857 | 1042857 | 2021-02-18 | Arroyo | Puerto Rico | 72015 | 351 | |
1042858 | 1042858 | 2021-02-18 | Barceloneta | Puerto Rico | 72017 | 713 | |
1042859 | 1042859 | 2021-02-18 | Barranquitas | Puerto Rico | 72019 | 1193 | |
1042860 | 1042860 | 2021-02-18 | Bayamon | Puerto Rico | 72021 | 10004 | |
1042861 | 1042861 | 2021-02-18 | Cabo Rojo | Puerto Rico | 72023 | 905 | |
1042862 | 1042862 | 2021-02-18 | Caguas | Puerto Rico | 72025 | 5537 | |
1042863 | 1042863 | 2021-02-18 | Camuy | Puerto Rico | 72027 | 1101 | |
1042864 | 1042864 | 2021-02-18 | Canovanas | Puerto Rico | 72029 | 1743 | |
1042865 | 1042865 | 2021-02-18 | Carolina | Puerto Rico | 72031 | 7792 | |
1042866 | 1042866 | 2021-02-18 | Catano | Puerto Rico | 72033 | 1212 | |
1042867 | 1042867 | 2021-02-18 | Cayey | Puerto Rico | 72035 | 1284 | |
1042868 | 1042868 | 2021-02-18 | Ceiba | Puerto Rico | 72037 | 397 | |
1042869 | 1042869 | 2021-02-18 | Ciales | Puerto Rico | 72039 | 730 | |
1042870 | 1042870 | 2021-02-18 | Cidra | Puerto Rico | 72041 | 1205 | |
1042871 | 1042871 | 2021-02-18 | Coamo | Puerto Rico | 72043 | 937 | |
1042872 | 1042872 | 2021-02-18 | Comerio | Puerto Rico | 72045 | 675 | |
1042873 | 1042873 | 2021-02-18 | Corozal | Puerto Rico | 72047 | 1592 | |
1042874 | 1042874 | 2021-02-18 | Culebra | Puerto Rico | 72049 | 28 | |
1042875 | 1042875 | 2021-02-18 | Dorado | Puerto Rico | 72051 | 2131 | |
1042876 | 1042876 | 2021-02-18 | Fajardo | Puerto Rico | 72053 | 1259 | |
1042877 | 1042877 | 2021-02-18 | Florida | Puerto Rico | 72054 | 670 | |
1042878 | 1042878 | 2021-02-18 | Guanica | Puerto Rico | 72055 | 247 | |
1042879 | 1042879 | 2021-02-18 | Guayama | Puerto Rico | 72057 | 803 | |
1042880 | 1042880 | 2021-02-18 | Guayanilla | Puerto Rico | 72059 | 424 | |
1042881 | 1042881 | 2021-02-18 | Guaynabo | Puerto Rico | 72061 | 4342 | |
1042882 | 1042882 | 2021-02-18 | Gurabo | Puerto Rico | 72063 | 1798 | |
1042883 | 1042883 | 2021-02-18 | Hatillo | Puerto Rico | 72065 | 1023 | |
1042884 | 1042884 | 2021-02-18 | Hormigueros | Puerto Rico | 72067 | 406 | |
1042885 | 1042885 | 2021-02-18 | Humacao | Puerto Rico | 72069 | 1633 | |
1042886 | 1042886 | 2021-02-18 | Isabela | Puerto Rico | 72071 | 1211 | |
1042887 | 1042887 | 2021-02-18 | Jayuya | Puerto Rico | 72073 | 412 | |
1042888 | 1042888 | 2021-02-18 | Juana Diaz | Puerto Rico | 72075 | 1072 | |
1042889 | 1042889 | 2021-02-18 | Juncos | Puerto Rico | 72077 | 1701 | |
1042890 | 1042890 | 2021-02-18 | Lajas | Puerto Rico | 72079 | 409 | |
1042891 | 1042891 | 2021-02-18 | Lares | Puerto Rico | 72081 | 867 | |
1042892 | 1042892 | 2021-02-18 | Las Marias | Puerto Rico | 72083 | 203 | |
1042893 | 1042893 | 2021-02-18 | Las Piedras | Puerto Rico | 72085 | 1405 | |
1042894 | 1042894 | 2021-02-18 | Loiza | Puerto Rico | 72087 | 964 | |
1042895 | 1042895 | 2021-02-18 | Luquillo | Puerto Rico | 72089 | 659 | |
1042896 | 1042896 | 2021-02-18 | Manati | Puerto Rico | 72091 | 1535 | |
1042897 | 1042897 | 2021-02-18 | Maricao | Puerto Rico | 72093 | 117 | |
1042898 | 1042898 | 2021-02-18 | Maunabo | Puerto Rico | 72095 | 320 | |
1042899 | 1042899 | 2021-02-18 | Mayaguez | Puerto Rico | 72097 | 1930 | |
1042900 | 1042900 | 2021-02-18 | Moca | Puerto Rico | 72099 | 1371 | |
1042901 | 1042901 | 2021-02-18 | Morovis | Puerto Rico | 72101 | 1318 | |
1042902 | 1042902 | 2021-02-18 | Naguabo | Puerto Rico | 72103 | 762 | |
1042903 | 1042903 | 2021-02-18 | Naranjito | Puerto Rico | 72105 | 1568 | |
1042904 | 1042904 | 2021-02-18 | Orocovis | Puerto Rico | 72107 | 788 | |
1042905 | 1042905 | 2021-02-18 | Patillas | Puerto Rico | 72109 | 359 | |
1042906 | 1042906 | 2021-02-18 | Penuelas | Puerto Rico | 72111 | 518 | |
1042907 | 1042907 | 2021-02-18 | Ponce | Puerto Rico | 72113 | 2950 | |
1042908 | 1042908 | 2021-02-18 | Quebradillas | Puerto Rico | 72115 | 697 | |
1042909 | 1042909 | 2021-02-18 | Rincon | Puerto Rico | 72117 | 443 | |
1042910 | 1042910 | 2021-02-18 | Rio Grande | Puerto Rico | 72119 | 1753 | |
1042911 | 1042911 | 2021-02-18 | Sabana Grande | Puerto Rico | 72121 | 405 | |
1042912 | 1042912 | 2021-02-18 | Salinas | Puerto Rico | 72123 | 1000 | |
1042913 | 1042913 | 2021-02-18 | San German | Puerto Rico | 72125 | 605 | |
1042914 | 1042914 | 2021-02-18 | San Juan | Puerto Rico | 72127 | 17758 | |
1042915 | 1042915 | 2021-02-18 | San Lorenzo | Puerto Rico | 72129 | 1440 | |
1042916 | 1042916 | 2021-02-18 | San Sebastian | Puerto Rico | 72131 | 1637 | |
1042917 | 1042917 | 2021-02-18 | Santa Isabel | Puerto Rico | 72133 | 550 | |
1042918 | 1042918 | 2021-02-18 | Toa Alta | Puerto Rico | 72135 | 3626 | |
1042919 | 1042919 | 2021-02-18 | Toa Baja | Puerto Rico | 72137 | 3798 | |
1042920 | 1042920 | 2021-02-18 | Trujillo Alto | Puerto Rico | 72139 | 2860 | |
1042921 | 1042921 | 2021-02-18 | Unknown | Puerto Rico | 4397 | 1940 | |
1042922 | 1042922 | 2021-02-18 | Utuado | Puerto Rico | 72141 | 851 | |
1042923 | 1042923 | 2021-02-18 | Vega Alta | Puerto Rico | 72143 | 1807 | |
1042924 | 1042924 | 2021-02-18 | Vega Baja | Puerto Rico | 72145 | 2666 | |
1042925 | 1042925 | 2021-02-18 | Vieques | Puerto Rico | 72147 | 195 | |
1042926 | 1042926 | 2021-02-18 | Villalba | Puerto Rico | 72149 | 740 | |
1042927 | 1042927 | 2021-02-18 | Yabucoa | Puerto Rico | 72151 | 984 | |
1042928 | 1042928 | 2021-02-18 | Yauco | Puerto Rico | 72153 | 992 |
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);