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 791
- Coamo 738
- Comerio 738
- Corozal 738
- Dorado 738
- Fajardo 738
- Florida 738
- Guanica 738
- Guayama 738
- Guayanilla 738
- Guaynabo 738
- Gurabo 738
- Hatillo 738
- Hormigueros 738
- Humacao 738
- Isabela 738
- Jayuya 738
- Juana Diaz 738
- Juncos 738
- Lajas 738
- Lares 738
- Las Marias 738
- Las Piedras 738
- Loiza 738
- Luquillo 738
- Manati 738
- Maunabo 738
- Mayaguez 738
- Moca 738
- Morovis 738
- …
state 1
- Puerto Rico · 58,297 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498677 | 2498677 | 2022-05-12 | Coamo | Puerto Rico | 72043 | 5899 | |
2498678 | 2498678 | 2022-05-12 | Comerio | Puerto Rico | 72045 | 3327 | |
2498679 | 2498679 | 2022-05-12 | Corozal | Puerto Rico | 72047 | 7208 | |
2498680 | 2498680 | 2022-05-12 | Culebra | Puerto Rico | 72049 | 207 | |
2498681 | 2498681 | 2022-05-12 | Dorado | Puerto Rico | 72051 | 7773 | |
2498682 | 2498682 | 2022-05-12 | Fajardo | Puerto Rico | 72053 | 5353 | |
2498683 | 2498683 | 2022-05-12 | Florida | Puerto Rico | 72054 | 2886 | |
2498684 | 2498684 | 2022-05-12 | Guanica | Puerto Rico | 72055 | 1760 | |
2498685 | 2498685 | 2022-05-12 | Guayama | Puerto Rico | 72057 | 6246 | |
2498686 | 2498686 | 2022-05-12 | Guayanilla | Puerto Rico | 72059 | 2743 | |
2498687 | 2498687 | 2022-05-12 | Guaynabo | Puerto Rico | 72061 | 18340 | |
2498688 | 2498688 | 2022-05-12 | Gurabo | Puerto Rico | 72063 | 8609 | |
2498689 | 2498689 | 2022-05-12 | Hatillo | Puerto Rico | 72065 | 6232 | |
2498690 | 2498690 | 2022-05-12 | Hormigueros | Puerto Rico | 72067 | 2450 | |
2498691 | 2498691 | 2022-05-12 | Humacao | Puerto Rico | 72069 | 9147 | |
2498692 | 2498692 | 2022-05-12 | Isabela | Puerto Rico | 72071 | 7631 | |
2498693 | 2498693 | 2022-05-12 | Jayuya | Puerto Rico | 72073 | 2885 | |
2498694 | 2498694 | 2022-05-12 | Juana Diaz | Puerto Rico | 72075 | 7613 | |
2498695 | 2498695 | 2022-05-12 | Juncos | Puerto Rico | 72077 | 7251 | |
2498696 | 2498696 | 2022-05-12 | Lajas | Puerto Rico | 72079 | 3322 | |
2498697 | 2498697 | 2022-05-12 | Lares | Puerto Rico | 72081 | 4980 | |
2498698 | 2498698 | 2022-05-12 | Las Marias | Puerto Rico | 72083 | 1375 | |
2498699 | 2498699 | 2022-05-12 | Las Piedras | Puerto Rico | 72085 | 6314 | |
2498700 | 2498700 | 2022-05-12 | Loiza | Puerto Rico | 72087 | 3806 | |
2498701 | 2498701 | 2022-05-12 | Luquillo | Puerto Rico | 72089 | 2912 | |
2498702 | 2498702 | 2022-05-12 | Manati | Puerto Rico | 72091 | 7140 | |
2498703 | 2498703 | 2022-05-12 | Maricao | Puerto Rico | 72093 | 704 | |
2498704 | 2498704 | 2022-05-12 | Maunabo | Puerto Rico | 72095 | 1638 | |
2498705 | 2498705 | 2022-05-12 | Mayaguez | Puerto Rico | 72097 | 11704 | |
2498706 | 2498706 | 2022-05-12 | Moca | Puerto Rico | 72099 | 7068 | |
2498707 | 2498707 | 2022-05-12 | Morovis | Puerto Rico | 72101 | 5601 | |
2498708 | 2498708 | 2022-05-12 | Naguabo | Puerto Rico | 72103 | 3902 | |
2498709 | 2498709 | 2022-05-12 | Naranjito | Puerto Rico | 72105 | 5775 | |
2498710 | 2498710 | 2022-05-12 | Orocovis | Puerto Rico | 72107 | 3417 | |
2498711 | 2498711 | 2022-05-12 | Patillas | Puerto Rico | 72109 | 2739 | |
2498712 | 2498712 | 2022-05-12 | Penuelas | Puerto Rico | 72111 | 2770 | |
2498713 | 2498713 | 2022-05-12 | Ponce | Puerto Rico | 72113 | 21697 | |
2498714 | 2498714 | 2022-05-12 | Quebradillas | Puerto Rico | 72115 | 4727 | |
2498715 | 2498715 | 2022-05-12 | Rincon | Puerto Rico | 72117 | 2547 | |
2498716 | 2498716 | 2022-05-12 | Rio Grande | Puerto Rico | 72119 | 8585 | |
2498717 | 2498717 | 2022-05-12 | Sabana Grande | Puerto Rico | 72121 | 2954 | |
2498718 | 2498718 | 2022-05-12 | Salinas | Puerto Rico | 72123 | 4232 | |
2498719 | 2498719 | 2022-05-12 | San German | Puerto Rico | 72125 | 4647 | |
2498720 | 2498720 | 2022-05-12 | San Juan | Puerto Rico | 72127 | 67106 | |
2498721 | 2498721 | 2022-05-12 | San Lorenzo | Puerto Rico | 72129 | 6402 | |
2498722 | 2498722 | 2022-05-12 | San Sebastian | Puerto Rico | 72131 | 7195 | |
2498723 | 2498723 | 2022-05-12 | Santa Isabel | Puerto Rico | 72133 | 3310 | |
2498724 | 2498724 | 2022-05-12 | Toa Alta | Puerto Rico | 72135 | 13772 | |
2498725 | 2498725 | 2022-05-12 | Toa Baja | Puerto Rico | 72137 | 14714 | |
2498726 | 2498726 | 2022-05-12 | Trujillo Alto | Puerto Rico | 72139 | 11656 | |
2498727 | 2498727 | 2022-05-12 | Unknown | Puerto Rico | 20803 | 4245 | |
2498728 | 2498728 | 2022-05-12 | Utuado | Puerto Rico | 72141 | 4048 | |
2498729 | 2498729 | 2022-05-12 | Vega Alta | Puerto Rico | 72143 | 7127 | |
2498730 | 2498730 | 2022-05-12 | Vega Baja | Puerto Rico | 72145 | 11837 | |
2498731 | 2498731 | 2022-05-12 | Vieques | Puerto Rico | 72147 | 924 | |
2498732 | 2498732 | 2022-05-12 | Villalba | Puerto Rico | 72149 | 3990 | |
2498733 | 2498733 | 2022-05-12 | Yabucoa | Puerto Rico | 72151 | 5436 | |
2498734 | 2498734 | 2022-05-12 | Yauco | Puerto Rico | 72153 | 5389 | |
2495398 | 2495398 | 2022-05-11 | Adjuntas | Puerto Rico | 72001 | 2727 | |
2495399 | 2495399 | 2022-05-11 | Aguada | Puerto Rico | 72003 | 7435 | |
2495400 | 2495400 | 2022-05-11 | Aguadilla | Puerto Rico | 72005 | 8404 | |
2495401 | 2495401 | 2022-05-11 | Aguas Buenas | Puerto Rico | 72007 | 4622 | |
2495402 | 2495402 | 2022-05-11 | Aibonito | Puerto Rico | 72009 | 4227 | |
2495403 | 2495403 | 2022-05-11 | Anasco | Puerto Rico | 72011 | 4387 | |
2495404 | 2495404 | 2022-05-11 | Arecibo | Puerto Rico | 72013 | 14887 | |
2495405 | 2495405 | 2022-05-11 | Arroyo | Puerto Rico | 72015 | 2655 | |
2495406 | 2495406 | 2022-05-11 | Barceloneta | Puerto Rico | 72017 | 3968 | |
2495407 | 2495407 | 2022-05-11 | Barranquitas | Puerto Rico | 72019 | 5438 | |
2495408 | 2495408 | 2022-05-11 | Bayamon | Puerto Rico | 72021 | 39037 | |
2495409 | 2495409 | 2022-05-11 | Cabo Rojo | Puerto Rico | 72023 | 6525 | |
2495410 | 2495410 | 2022-05-11 | Caguas | Puerto Rico | 72025 | 24788 | |
2495411 | 2495411 | 2022-05-11 | Camuy | Puerto Rico | 72027 | 5921 | |
2495412 | 2495412 | 2022-05-11 | Canovanas | Puerto Rico | 72029 | 7343 | |
2495413 | 2495413 | 2022-05-11 | Carolina | Puerto Rico | 72031 | 32032 | |
2495414 | 2495414 | 2022-05-11 | Catano | Puerto Rico | 72033 | 4723 | |
2495415 | 2495415 | 2022-05-11 | Cayey | Puerto Rico | 72035 | 7124 | |
2495416 | 2495416 | 2022-05-11 | Ceiba | Puerto Rico | 72037 | 1671 | |
2495417 | 2495417 | 2022-05-11 | Ciales | Puerto Rico | 72039 | 3005 | |
2495418 | 2495418 | 2022-05-11 | Cidra | Puerto Rico | 72041 | 7007 | |
2495419 | 2495419 | 2022-05-11 | Coamo | Puerto Rico | 72043 | 5837 | |
2495420 | 2495420 | 2022-05-11 | Comerio | Puerto Rico | 72045 | 3288 | |
2495421 | 2495421 | 2022-05-11 | Corozal | Puerto Rico | 72047 | 7144 | |
2495422 | 2495422 | 2022-05-11 | Culebra | Puerto Rico | 72049 | 203 | |
2495423 | 2495423 | 2022-05-11 | Dorado | Puerto Rico | 72051 | 7714 | |
2495424 | 2495424 | 2022-05-11 | Fajardo | Puerto Rico | 72053 | 5264 | |
2495425 | 2495425 | 2022-05-11 | Florida | Puerto Rico | 72054 | 2862 | |
2495426 | 2495426 | 2022-05-11 | Guanica | Puerto Rico | 72055 | 1746 | |
2495427 | 2495427 | 2022-05-11 | Guayama | Puerto Rico | 72057 | 6173 | |
2495428 | 2495428 | 2022-05-11 | Guayanilla | Puerto Rico | 72059 | 2718 | |
2495429 | 2495429 | 2022-05-11 | Guaynabo | Puerto Rico | 72061 | 18117 | |
2495430 | 2495430 | 2022-05-11 | Gurabo | Puerto Rico | 72063 | 8519 | |
2495431 | 2495431 | 2022-05-11 | Hatillo | Puerto Rico | 72065 | 6148 | |
2495432 | 2495432 | 2022-05-11 | Hormigueros | Puerto Rico | 72067 | 2419 | |
2495433 | 2495433 | 2022-05-11 | Humacao | Puerto Rico | 72069 | 9048 | |
2495434 | 2495434 | 2022-05-11 | Isabela | Puerto Rico | 72071 | 7560 | |
2495435 | 2495435 | 2022-05-11 | Jayuya | Puerto Rico | 72073 | 2791 | |
2495436 | 2495436 | 2022-05-11 | Juana Diaz | Puerto Rico | 72075 | 7472 | |
2495437 | 2495437 | 2022-05-11 | Juncos | Puerto Rico | 72077 | 7194 | |
2495438 | 2495438 | 2022-05-11 | Lajas | Puerto Rico | 72079 | 3273 | |
2495439 | 2495439 | 2022-05-11 | Lares | Puerto Rico | 72081 | 4897 |
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);