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 692
- Utuado 640
- Vega Alta 640
- Vega Baja 640
- Villalba 640
- Yabucoa 640
- Yauco 640
- Adjuntas 639
- Aguada 639
- Aguadilla 639
- Aguas Buenas 639
- Aibonito 639
- Anasco 639
- Arecibo 639
- Arroyo 639
- Barceloneta 639
- Barranquitas 639
- Bayamon 639
- Cabo Rojo 639
- Caguas 639
- Camuy 639
- Canovanas 639
- Carolina 639
- Catano 639
- Cayey 639
- Ceiba 639
- Ciales 639
- Cidra 639
- Coamo 639
- Comerio 639
- …
state 1
- Puerto Rico · 50,504 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 | |
2176573 | 2176573 | 2022-02-02 | Las Piedras | Puerto Rico | 72085 | 4992 | |
2176574 | 2176574 | 2022-02-02 | Loiza | Puerto Rico | 72087 | 3050 | |
2176575 | 2176575 | 2022-02-02 | Luquillo | Puerto Rico | 72089 | 2366 | |
2176576 | 2176576 | 2022-02-02 | Manati | Puerto Rico | 72091 | 5614 | |
2176577 | 2176577 | 2022-02-02 | Maricao | Puerto Rico | 72093 | 500 | |
2176578 | 2176578 | 2022-02-02 | Maunabo | Puerto Rico | 72095 | 1306 | |
2176579 | 2176579 | 2022-02-02 | Mayaguez | Puerto Rico | 72097 | 9088 | |
2176580 | 2176580 | 2022-02-02 | Moca | Puerto Rico | 72099 | 5440 | |
2176581 | 2176581 | 2022-02-02 | Morovis | Puerto Rico | 72101 | 4333 | |
2176582 | 2176582 | 2022-02-02 | Naguabo | Puerto Rico | 72103 | 3125 | |
2176583 | 2176583 | 2022-02-02 | Naranjito | Puerto Rico | 72105 | 4802 | |
2176584 | 2176584 | 2022-02-02 | Orocovis | Puerto Rico | 72107 | 2697 | |
2176585 | 2176585 | 2022-02-02 | Patillas | Puerto Rico | 72109 | 1897 | |
2176586 | 2176586 | 2022-02-02 | Penuelas | Puerto Rico | 72111 | 2081 | |
2176587 | 2176587 | 2022-02-02 | Ponce | Puerto Rico | 72113 | 16306 | |
2176588 | 2176588 | 2022-02-02 | Quebradillas | Puerto Rico | 72115 | 3432 | |
2176589 | 2176589 | 2022-02-02 | Rincon | Puerto Rico | 72117 | 2048 | |
2176590 | 2176590 | 2022-02-02 | Rio Grande | Puerto Rico | 72119 | 7066 | |
2176591 | 2176591 | 2022-02-02 | Sabana Grande | Puerto Rico | 72121 | 2110 | |
2176592 | 2176592 | 2022-02-02 | Salinas | Puerto Rico | 72123 | 3217 | |
2176593 | 2176593 | 2022-02-02 | San German | Puerto Rico | 72125 | 3309 | |
2176594 | 2176594 | 2022-02-02 | San Juan | Puerto Rico | 72127 | 57783 | |
2176595 | 2176595 | 2022-02-02 | San Lorenzo | Puerto Rico | 72129 | 5064 | |
2176596 | 2176596 | 2022-02-02 | San Sebastian | Puerto Rico | 72131 | 5840 | |
2176597 | 2176597 | 2022-02-02 | Santa Isabel | Puerto Rico | 72133 | 2370 | |
2176598 | 2176598 | 2022-02-02 | Toa Alta | Puerto Rico | 72135 | 11357 | |
2176599 | 2176599 | 2022-02-02 | Toa Baja | Puerto Rico | 72137 | 12174 | |
2176600 | 2176600 | 2022-02-02 | Trujillo Alto | Puerto Rico | 72139 | 9386 | |
2176601 | 2176601 | 2022-02-02 | Unknown | Puerto Rico | 16227 | 3887 | |
2176602 | 2176602 | 2022-02-02 | Utuado | Puerto Rico | 72141 | 3120 | |
2176603 | 2176603 | 2022-02-02 | Vega Alta | Puerto Rico | 72143 | 5872 | |
2176604 | 2176604 | 2022-02-02 | Vega Baja | Puerto Rico | 72145 | 9889 | |
2176605 | 2176605 | 2022-02-02 | Vieques | Puerto Rico | 72147 | 673 | |
2176606 | 2176606 | 2022-02-02 | Villalba | Puerto Rico | 72149 | 2829 | |
2176607 | 2176607 | 2022-02-02 | Yabucoa | Puerto Rico | 72151 | 4078 | |
2176608 | 2176608 | 2022-02-02 | Yauco | Puerto Rico | 72153 | 3934 | |
2173276 | 2173276 | 2022-02-01 | Adjuntas | Puerto Rico | 72001 | 2058 | |
2173277 | 2173277 | 2022-02-01 | Aguada | Puerto Rico | 72003 | 5765 | |
2173278 | 2173278 | 2022-02-01 | Aguadilla | Puerto Rico | 72005 | 6673 | |
2173279 | 2173279 | 2022-02-01 | Aguas Buenas | Puerto Rico | 72007 | 3782 | |
2173280 | 2173280 | 2022-02-01 | Aibonito | Puerto Rico | 72009 | 3316 | |
2173281 | 2173281 | 2022-02-01 | Anasco | Puerto Rico | 72011 | 3295 | |
2173282 | 2173282 | 2022-02-01 | Arecibo | Puerto Rico | 72013 | 11736 | |
2173283 | 2173283 | 2022-02-01 | Arroyo | Puerto Rico | 72015 | 1739 | |
2173284 | 2173284 | 2022-02-01 | Barceloneta | Puerto Rico | 72017 | 2980 | |
2173285 | 2173285 | 2022-02-01 | Barranquitas | Puerto Rico | 72019 | 4394 | |
2173286 | 2173286 | 2022-02-01 | Bayamon | Puerto Rico | 72021 | 32148 | |
2173287 | 2173287 | 2022-02-01 | Cabo Rojo | Puerto Rico | 72023 | 4746 | |
2173288 | 2173288 | 2022-02-01 | Caguas | Puerto Rico | 72025 | 20417 | |
2173289 | 2173289 | 2022-02-01 | Camuy | Puerto Rico | 72027 | 4384 |
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);