ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
58,397 rows where state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Unknown 693
- Comerio 640
- Corozal 640
- Dorado 640
- Fajardo 640
- Florida 640
- Guanica 640
- Guayama 640
- Guayanilla 640
- Guaynabo 640
- Gurabo 640
- Hatillo 640
- Hormigueros 640
- Humacao 640
- Isabela 640
- Jayuya 640
- Juana Diaz 640
- Juncos 640
- Lajas 640
- Lares 640
- Las Marias 640
- Las Piedras 640
- Loiza 640
- Luquillo 640
- Manati 640
- Maunabo 640
- Mayaguez 640
- Moca 640
- Morovis 640
- Naguabo 640
- …
state 1
- Puerto Rico · 50,554 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2179803 | 2179803 | 2022-02-03 | Comerio | Puerto Rico | 72045 | 2682 | |
2179804 | 2179804 | 2022-02-03 | Corozal | Puerto Rico | 72047 | 5872 | |
2179805 | 2179805 | 2022-02-03 | Culebra | Puerto Rico | 72049 | 160 | |
2179806 | 2179806 | 2022-02-03 | Dorado | Puerto Rico | 72051 | 6372 | |
2179807 | 2179807 | 2022-02-03 | Fajardo | Puerto Rico | 72053 | 4347 | |
2179808 | 2179808 | 2022-02-03 | Florida | Puerto Rico | 72054 | 2310 | |
2179809 | 2179809 | 2022-02-03 | Guanica | Puerto Rico | 72055 | 1378 | |
2179810 | 2179810 | 2022-02-03 | Guayama | Puerto Rico | 72057 | 4354 | |
2179811 | 2179811 | 2022-02-03 | Guayanilla | Puerto Rico | 72059 | 1918 | |
2179812 | 2179812 | 2022-02-03 | Guaynabo | Puerto Rico | 72061 | 14484 | |
2179813 | 2179813 | 2022-02-03 | Gurabo | Puerto Rico | 72063 | 6869 | |
2179814 | 2179814 | 2022-02-03 | Hatillo | Puerto Rico | 72065 | 4858 | |
2179815 | 2179815 | 2022-02-03 | Hormigueros | Puerto Rico | 72067 | 1708 | |
2179816 | 2179816 | 2022-02-03 | Humacao | Puerto Rico | 72069 | 7300 | |
2179817 | 2179817 | 2022-02-03 | Isabela | Puerto Rico | 72071 | 6185 | |
2179818 | 2179818 | 2022-02-03 | Jayuya | Puerto Rico | 72073 | 1966 | |
2179819 | 2179819 | 2022-02-03 | Juana Diaz | Puerto Rico | 72075 | 5449 | |
2179820 | 2179820 | 2022-02-03 | Juncos | Puerto Rico | 72077 | 5867 | |
2179821 | 2179821 | 2022-02-03 | Lajas | Puerto Rico | 72079 | 2329 | |
2179822 | 2179822 | 2022-02-03 | Lares | Puerto Rico | 72081 | 3500 | |
2179823 | 2179823 | 2022-02-03 | Las Marias | Puerto Rico | 72083 | 1015 | |
2179824 | 2179824 | 2022-02-03 | Las Piedras | Puerto Rico | 72085 | 5019 | |
2179825 | 2179825 | 2022-02-03 | Loiza | Puerto Rico | 72087 | 3058 | |
2179826 | 2179826 | 2022-02-03 | Luquillo | Puerto Rico | 72089 | 2375 | |
2179827 | 2179827 | 2022-02-03 | Manati | Puerto Rico | 72091 | 5633 | |
2179828 | 2179828 | 2022-02-03 | Maricao | Puerto Rico | 72093 | 508 | |
2179829 | 2179829 | 2022-02-03 | Maunabo | Puerto Rico | 72095 | 1310 | |
2179830 | 2179830 | 2022-02-03 | Mayaguez | Puerto Rico | 72097 | 9122 | |
2179831 | 2179831 | 2022-02-03 | Moca | Puerto Rico | 72099 | 5452 | |
2179832 | 2179832 | 2022-02-03 | Morovis | Puerto Rico | 72101 | 4344 | |
2179833 | 2179833 | 2022-02-03 | Naguabo | Puerto Rico | 72103 | 3138 | |
2179834 | 2179834 | 2022-02-03 | Naranjito | Puerto Rico | 72105 | 4810 | |
2179835 | 2179835 | 2022-02-03 | Orocovis | Puerto Rico | 72107 | 2713 | |
2179836 | 2179836 | 2022-02-03 | Patillas | Puerto Rico | 72109 | 1900 | |
2179837 | 2179837 | 2022-02-03 | Penuelas | Puerto Rico | 72111 | 2097 | |
2179838 | 2179838 | 2022-02-03 | Ponce | Puerto Rico | 72113 | 16399 | |
2179839 | 2179839 | 2022-02-03 | Quebradillas | Puerto Rico | 72115 | 3439 | |
2179840 | 2179840 | 2022-02-03 | Rincon | Puerto Rico | 72117 | 2057 | |
2179841 | 2179841 | 2022-02-03 | Rio Grande | Puerto Rico | 72119 | 7085 | |
2179842 | 2179842 | 2022-02-03 | Sabana Grande | Puerto Rico | 72121 | 2130 | |
2179843 | 2179843 | 2022-02-03 | Salinas | Puerto Rico | 72123 | 3242 | |
2179844 | 2179844 | 2022-02-03 | San German | Puerto Rico | 72125 | 3324 | |
2179845 | 2179845 | 2022-02-03 | San Juan | Puerto Rico | 72127 | 57953 | |
2179846 | 2179846 | 2022-02-03 | San Lorenzo | Puerto Rico | 72129 | 5072 | |
2179847 | 2179847 | 2022-02-03 | San Sebastian | Puerto Rico | 72131 | 5872 | |
2179848 | 2179848 | 2022-02-03 | Santa Isabel | Puerto Rico | 72133 | 2381 | |
2179849 | 2179849 | 2022-02-03 | Toa Alta | Puerto Rico | 72135 | 11406 | |
2179850 | 2179850 | 2022-02-03 | Toa Baja | Puerto Rico | 72137 | 12202 | |
2179851 | 2179851 | 2022-02-03 | Trujillo Alto | Puerto Rico | 72139 | 9423 | |
2179852 | 2179852 | 2022-02-03 | Unknown | Puerto Rico | 16281 | 3908 | |
2179853 | 2179853 | 2022-02-03 | Utuado | Puerto Rico | 72141 | 3122 | |
2179854 | 2179854 | 2022-02-03 | Vega Alta | Puerto Rico | 72143 | 5890 | |
2179855 | 2179855 | 2022-02-03 | Vega Baja | Puerto Rico | 72145 | 9905 | |
2179856 | 2179856 | 2022-02-03 | Vieques | Puerto Rico | 72147 | 677 | |
2179857 | 2179857 | 2022-02-03 | Villalba | Puerto Rico | 72149 | 2850 | |
2179858 | 2179858 | 2022-02-03 | Yabucoa | Puerto Rico | 72151 | 4105 | |
2179859 | 2179859 | 2022-02-03 | Yauco | Puerto Rico | 72153 | 3956 | |
2176530 | 2176530 | 2022-02-02 | Adjuntas | Puerto Rico | 72001 | 2064 | |
2176531 | 2176531 | 2022-02-02 | Aguada | Puerto Rico | 72003 | 5790 | |
2176532 | 2176532 | 2022-02-02 | Aguadilla | Puerto Rico | 72005 | 6688 | |
2176533 | 2176533 | 2022-02-02 | Aguas Buenas | Puerto Rico | 72007 | 3789 | |
2176534 | 2176534 | 2022-02-02 | Aibonito | Puerto Rico | 72009 | 3331 | |
2176535 | 2176535 | 2022-02-02 | Anasco | Puerto Rico | 72011 | 3306 | |
2176536 | 2176536 | 2022-02-02 | Arecibo | Puerto Rico | 72013 | 11782 | |
2176537 | 2176537 | 2022-02-02 | Arroyo | Puerto Rico | 72015 | 1740 | |
2176538 | 2176538 | 2022-02-02 | Barceloneta | Puerto Rico | 72017 | 2991 | |
2176539 | 2176539 | 2022-02-02 | Barranquitas | Puerto Rico | 72019 | 4399 | |
2176540 | 2176540 | 2022-02-02 | Bayamon | Puerto Rico | 72021 | 32216 | |
2176541 | 2176541 | 2022-02-02 | Cabo Rojo | Puerto Rico | 72023 | 4771 | |
2176542 | 2176542 | 2022-02-02 | Caguas | Puerto Rico | 72025 | 20462 | |
2176543 | 2176543 | 2022-02-02 | Camuy | Puerto Rico | 72027 | 4411 | |
2176544 | 2176544 | 2022-02-02 | Canovanas | Puerto Rico | 72029 | 6162 | |
2176545 | 2176545 | 2022-02-02 | Carolina | Puerto Rico | 72031 | 26436 | |
2176546 | 2176546 | 2022-02-02 | Catano | Puerto Rico | 72033 | 3939 | |
2176547 | 2176547 | 2022-02-02 | Cayey | Puerto Rico | 72035 | 5494 | |
2176548 | 2176548 | 2022-02-02 | Ceiba | Puerto Rico | 72037 | 1280 | |
2176549 | 2176549 | 2022-02-02 | Ciales | Puerto Rico | 72039 | 2395 | |
2176550 | 2176550 | 2022-02-02 | Cidra | Puerto Rico | 72041 | 5277 | |
2176551 | 2176551 | 2022-02-02 | Coamo | Puerto Rico | 72043 | 4179 | |
2176552 | 2176552 | 2022-02-02 | Comerio | Puerto Rico | 72045 | 2673 | |
2176553 | 2176553 | 2022-02-02 | Corozal | Puerto Rico | 72047 | 5854 | |
2176554 | 2176554 | 2022-02-02 | Culebra | Puerto Rico | 72049 | 159 | |
2176555 | 2176555 | 2022-02-02 | Dorado | Puerto Rico | 72051 | 6360 | |
2176556 | 2176556 | 2022-02-02 | Fajardo | Puerto Rico | 72053 | 4331 | |
2176557 | 2176557 | 2022-02-02 | Florida | Puerto Rico | 72054 | 2295 | |
2176558 | 2176558 | 2022-02-02 | Guanica | Puerto Rico | 72055 | 1365 | |
2176559 | 2176559 | 2022-02-02 | Guayama | Puerto Rico | 72057 | 4336 | |
2176560 | 2176560 | 2022-02-02 | Guayanilla | Puerto Rico | 72059 | 1891 | |
2176561 | 2176561 | 2022-02-02 | Guaynabo | Puerto Rico | 72061 | 14430 | |
2176562 | 2176562 | 2022-02-02 | Gurabo | Puerto Rico | 72063 | 6849 | |
2176563 | 2176563 | 2022-02-02 | Hatillo | Puerto Rico | 72065 | 4849 | |
2176564 | 2176564 | 2022-02-02 | Hormigueros | Puerto Rico | 72067 | 1706 | |
2176565 | 2176565 | 2022-02-02 | Humacao | Puerto Rico | 72069 | 7278 | |
2176566 | 2176566 | 2022-02-02 | Isabela | Puerto Rico | 72071 | 6152 | |
2176567 | 2176567 | 2022-02-02 | Jayuya | Puerto Rico | 72073 | 1954 | |
2176568 | 2176568 | 2022-02-02 | Juana Diaz | Puerto Rico | 72075 | 5405 | |
2176569 | 2176569 | 2022-02-02 | Juncos | Puerto Rico | 72077 | 5849 | |
2176570 | 2176570 | 2022-02-02 | Lajas | Puerto Rico | 72079 | 2303 | |
2176571 | 2176571 | 2022-02-02 | Lares | Puerto Rico | 72081 | 3491 | |
2176572 | 2176572 | 2022-02-02 | Las Marias | Puerto Rico | 72083 | 1012 |
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);