ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2022-03-03" 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 |
---|---|---|---|---|---|---|---|
2270833 | 2270833 | 2022-03-03 | Adjuntas | Puerto Rico | 72001 | 2148 | |
2270834 | 2270834 | 2022-03-03 | Aguada | Puerto Rico | 72003 | 5966 | |
2270835 | 2270835 | 2022-03-03 | Aguadilla | Puerto Rico | 72005 | 6931 | |
2270836 | 2270836 | 2022-03-03 | Aguas Buenas | Puerto Rico | 72007 | 3878 | |
2270837 | 2270837 | 2022-03-03 | Aibonito | Puerto Rico | 72009 | 3459 | |
2270838 | 2270838 | 2022-03-03 | Anasco | Puerto Rico | 72011 | 3454 | |
2270839 | 2270839 | 2022-03-03 | Arecibo | Puerto Rico | 72013 | 12216 | |
2270840 | 2270840 | 2022-03-03 | Arroyo | Puerto Rico | 72015 | 1809 | |
2270841 | 2270841 | 2022-03-03 | Barceloneta | Puerto Rico | 72017 | 3126 | |
2270842 | 2270842 | 2022-03-03 | Barranquitas | Puerto Rico | 72019 | 4585 | |
2270843 | 2270843 | 2022-03-03 | Bayamon | Puerto Rico | 72021 | 33005 | |
2270844 | 2270844 | 2022-03-03 | Cabo Rojo | Puerto Rico | 72023 | 4924 | |
2270845 | 2270845 | 2022-03-03 | Caguas | Puerto Rico | 72025 | 20832 | |
2270846 | 2270846 | 2022-03-03 | Camuy | Puerto Rico | 72027 | 4587 | |
2270847 | 2270847 | 2022-03-03 | Canovanas | Puerto Rico | 72029 | 6294 | |
2270848 | 2270848 | 2022-03-03 | Carolina | Puerto Rico | 72031 | 27045 | |
2270849 | 2270849 | 2022-03-03 | Catano | Puerto Rico | 72033 | 4019 | |
2270850 | 2270850 | 2022-03-03 | Cayey | Puerto Rico | 72035 | 5640 | |
2270851 | 2270851 | 2022-03-03 | Ceiba | Puerto Rico | 72037 | 1344 | |
2270852 | 2270852 | 2022-03-03 | Ciales | Puerto Rico | 72039 | 2475 | |
2270853 | 2270853 | 2022-03-03 | Cidra | Puerto Rico | 72041 | 5436 | |
2270854 | 2270854 | 2022-03-03 | Coamo | Puerto Rico | 72043 | 4365 | |
2270855 | 2270855 | 2022-03-03 | Comerio | Puerto Rico | 72045 | 2739 | |
2270856 | 2270856 | 2022-03-03 | Corozal | Puerto Rico | 72047 | 6000 | |
2270857 | 2270857 | 2022-03-03 | Culebra | Puerto Rico | 72049 | 162 | |
2270858 | 2270858 | 2022-03-03 | Dorado | Puerto Rico | 72051 | 6529 | |
2270859 | 2270859 | 2022-03-03 | Fajardo | Puerto Rico | 72053 | 4476 | |
2270860 | 2270860 | 2022-03-03 | Florida | Puerto Rico | 72054 | 2382 | |
2270861 | 2270861 | 2022-03-03 | Guanica | Puerto Rico | 72055 | 1420 | |
2270862 | 2270862 | 2022-03-03 | Guayama | Puerto Rico | 72057 | 4513 | |
2270863 | 2270863 | 2022-03-03 | Guayanilla | Puerto Rico | 72059 | 1988 | |
2270864 | 2270864 | 2022-03-03 | Guaynabo | Puerto Rico | 72061 | 14871 | |
2270865 | 2270865 | 2022-03-03 | Gurabo | Puerto Rico | 72063 | 7034 | |
2270866 | 2270866 | 2022-03-03 | Hatillo | Puerto Rico | 72065 | 4998 | |
2270867 | 2270867 | 2022-03-03 | Hormigueros | Puerto Rico | 72067 | 1772 | |
2270868 | 2270868 | 2022-03-03 | Humacao | Puerto Rico | 72069 | 7444 | |
2270869 | 2270869 | 2022-03-03 | Isabela | Puerto Rico | 72071 | 6422 | |
2270870 | 2270870 | 2022-03-03 | Jayuya | Puerto Rico | 72073 | 2084 | |
2270871 | 2270871 | 2022-03-03 | Juana Diaz | Puerto Rico | 72075 | 5692 | |
2270872 | 2270872 | 2022-03-03 | Juncos | Puerto Rico | 72077 | 5950 | |
2270873 | 2270873 | 2022-03-03 | Lajas | Puerto Rico | 72079 | 2420 | |
2270874 | 2270874 | 2022-03-03 | Lares | Puerto Rico | 72081 | 3613 | |
2270875 | 2270875 | 2022-03-03 | Las Marias | Puerto Rico | 72083 | 1059 | |
2270876 | 2270876 | 2022-03-03 | Las Piedras | Puerto Rico | 72085 | 5120 | |
2270877 | 2270877 | 2022-03-03 | Loiza | Puerto Rico | 72087 | 3122 | |
2270878 | 2270878 | 2022-03-03 | Luquillo | Puerto Rico | 72089 | 2446 | |
2270879 | 2270879 | 2022-03-03 | Manati | Puerto Rico | 72091 | 5825 | |
2270880 | 2270880 | 2022-03-03 | Maricao | Puerto Rico | 72093 | 548 | |
2270881 | 2270881 | 2022-03-03 | Maunabo | Puerto Rico | 72095 | 1340 | |
2270882 | 2270882 | 2022-03-03 | Mayaguez | Puerto Rico | 72097 | 9400 | |
2270883 | 2270883 | 2022-03-03 | Moca | Puerto Rico | 72099 | 5631 | |
2270884 | 2270884 | 2022-03-03 | Morovis | Puerto Rico | 72101 | 4460 | |
2270885 | 2270885 | 2022-03-03 | Naguabo | Puerto Rico | 72103 | 3240 | |
2270886 | 2270886 | 2022-03-03 | Naranjito | Puerto Rico | 72105 | 4923 | |
2270887 | 2270887 | 2022-03-03 | Orocovis | Puerto Rico | 72107 | 2816 | |
2270888 | 2270888 | 2022-03-03 | Patillas | Puerto Rico | 72109 | 1955 | |
2270889 | 2270889 | 2022-03-03 | Penuelas | Puerto Rico | 72111 | 2192 | |
2270890 | 2270890 | 2022-03-03 | Ponce | Puerto Rico | 72113 | 17049 | |
2270891 | 2270891 | 2022-03-03 | Quebradillas | Puerto Rico | 72115 | 3592 | |
2270892 | 2270892 | 2022-03-03 | Rincon | Puerto Rico | 72117 | 2117 | |
2270893 | 2270893 | 2022-03-03 | Rio Grande | Puerto Rico | 72119 | 7226 | |
2270894 | 2270894 | 2022-03-03 | Sabana Grande | Puerto Rico | 72121 | 2209 | |
2270895 | 2270895 | 2022-03-03 | Salinas | Puerto Rico | 72123 | 3364 | |
2270896 | 2270896 | 2022-03-03 | San German | Puerto Rico | 72125 | 3420 | |
2270897 | 2270897 | 2022-03-03 | San Juan | Puerto Rico | 72127 | 59045 | |
2270898 | 2270898 | 2022-03-03 | San Lorenzo | Puerto Rico | 72129 | 5228 | |
2270899 | 2270899 | 2022-03-03 | San Sebastian | Puerto Rico | 72131 | 6020 | |
2270900 | 2270900 | 2022-03-03 | Santa Isabel | Puerto Rico | 72133 | 2493 | |
2270901 | 2270901 | 2022-03-03 | Toa Alta | Puerto Rico | 72135 | 11645 | |
2270902 | 2270902 | 2022-03-03 | Toa Baja | Puerto Rico | 72137 | 12433 | |
2270903 | 2270903 | 2022-03-03 | Trujillo Alto | Puerto Rico | 72139 | 9650 | |
2270904 | 2270904 | 2022-03-03 | Unknown | Puerto Rico | 16728 | 4128 | |
2270905 | 2270905 | 2022-03-03 | Utuado | Puerto Rico | 72141 | 3207 | |
2270906 | 2270906 | 2022-03-03 | Vega Alta | Puerto Rico | 72143 | 6043 | |
2270907 | 2270907 | 2022-03-03 | Vega Baja | Puerto Rico | 72145 | 10110 | |
2270908 | 2270908 | 2022-03-03 | Vieques | Puerto Rico | 72147 | 706 | |
2270909 | 2270909 | 2022-03-03 | Villalba | Puerto Rico | 72149 | 2924 | |
2270910 | 2270910 | 2022-03-03 | Yabucoa | Puerto Rico | 72151 | 4214 | |
2270911 | 2270911 | 2022-03-03 | Yauco | Puerto Rico | 72153 | 4092 |
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);