ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where date = "2022-01-01" 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 |
---|---|---|---|---|---|---|---|
2072445 | 2072445 | 2022-01-01 | Adjuntas | Puerto Rico | 72001 | 973 | |
2072446 | 2072446 | 2022-01-01 | Aguada | Puerto Rico | 72003 | 3334 | |
2072447 | 2072447 | 2022-01-01 | Aguadilla | Puerto Rico | 72005 | 3955 | |
2072448 | 2072448 | 2022-01-01 | Aguas Buenas | Puerto Rico | 72007 | 2211 | |
2072449 | 2072449 | 2022-01-01 | Aibonito | Puerto Rico | 72009 | 1711 | |
2072450 | 2072450 | 2022-01-01 | Anasco | Puerto Rico | 72011 | 1960 | |
2072451 | 2072451 | 2022-01-01 | Arecibo | Puerto Rico | 72013 | 6401 | |
2072452 | 2072452 | 2022-01-01 | Arroyo | Puerto Rico | 72015 | 822 | |
2072453 | 2072453 | 2022-01-01 | Barceloneta | Puerto Rico | 72017 | 1665 | |
2072454 | 2072454 | 2022-01-01 | Barranquitas | Puerto Rico | 72019 | 2703 | |
2072455 | 2072455 | 2022-01-01 | Bayamon | Puerto Rico | 72021 | 21825 | |
2072456 | 2072456 | 2022-01-01 | Cabo Rojo | Puerto Rico | 72023 | 2929 | |
2072457 | 2072457 | 2022-01-01 | Caguas | Puerto Rico | 72025 | 13094 | |
2072458 | 2072458 | 2022-01-01 | Camuy | Puerto Rico | 72027 | 2399 | |
2072459 | 2072459 | 2022-01-01 | Canovanas | Puerto Rico | 72029 | 4187 | |
2072460 | 2072460 | 2022-01-01 | Carolina | Puerto Rico | 72031 | 18215 | |
2072461 | 2072461 | 2022-01-01 | Catano | Puerto Rico | 72033 | 2522 | |
2072462 | 2072462 | 2022-01-01 | Cayey | Puerto Rico | 72035 | 3149 | |
2072463 | 2072463 | 2022-01-01 | Ceiba | Puerto Rico | 72037 | 825 | |
2072464 | 2072464 | 2022-01-01 | Ciales | Puerto Rico | 72039 | 1424 | |
2072465 | 2072465 | 2022-01-01 | Cidra | Puerto Rico | 72041 | 2947 | |
2072466 | 2072466 | 2022-01-01 | Coamo | Puerto Rico | 72043 | 2177 | |
2072467 | 2072467 | 2022-01-01 | Comerio | Puerto Rico | 72045 | 1412 | |
2072468 | 2072468 | 2022-01-01 | Corozal | Puerto Rico | 72047 | 3482 | |
2072469 | 2072469 | 2022-01-01 | Culebra | Puerto Rico | 72049 | 121 | |
2072470 | 2072470 | 2022-01-01 | Dorado | Puerto Rico | 72051 | 4431 | |
2072471 | 2072471 | 2022-01-01 | Fajardo | Puerto Rico | 72053 | 2848 | |
2072472 | 2072472 | 2022-01-01 | Florida | Puerto Rico | 72054 | 1245 | |
2072473 | 2072473 | 2022-01-01 | Guanica | Puerto Rico | 72055 | 672 | |
2072474 | 2072474 | 2022-01-01 | Guayama | Puerto Rico | 72057 | 2160 | |
2072475 | 2072475 | 2022-01-01 | Guayanilla | Puerto Rico | 72059 | 935 | |
2072476 | 2072476 | 2022-01-01 | Guaynabo | Puerto Rico | 72061 | 9930 | |
2072477 | 2072477 | 2022-01-01 | Gurabo | Puerto Rico | 72063 | 4231 | |
2072478 | 2072478 | 2022-01-01 | Hatillo | Puerto Rico | 72065 | 2527 | |
2072479 | 2072479 | 2022-01-01 | Hormigueros | Puerto Rico | 72067 | 1019 | |
2072480 | 2072480 | 2022-01-01 | Humacao | Puerto Rico | 72069 | 4344 | |
2072481 | 2072481 | 2022-01-01 | Isabela | Puerto Rico | 72071 | 3338 | |
2072482 | 2072482 | 2022-01-01 | Jayuya | Puerto Rico | 72073 | 857 | |
2072483 | 2072483 | 2022-01-01 | Juana Diaz | Puerto Rico | 72075 | 2773 | |
2072484 | 2072484 | 2022-01-01 | Juncos | Puerto Rico | 72077 | 3921 | |
2072485 | 2072485 | 2022-01-01 | Lajas | Puerto Rico | 72079 | 1164 | |
2072486 | 2072486 | 2022-01-01 | Lares | Puerto Rico | 72081 | 1906 | |
2072487 | 2072487 | 2022-01-01 | Las Marias | Puerto Rico | 72083 | 481 | |
2072488 | 2072488 | 2022-01-01 | Las Piedras | Puerto Rico | 72085 | 3162 | |
2072489 | 2072489 | 2022-01-01 | Loiza | Puerto Rico | 72087 | 2159 | |
2072490 | 2072490 | 2022-01-01 | Luquillo | Puerto Rico | 72089 | 1597 | |
2072491 | 2072491 | 2022-01-01 | Manati | Puerto Rico | 72091 | 3378 | |
2072492 | 2072492 | 2022-01-01 | Maricao | Puerto Rico | 72093 | 258 | |
2072493 | 2072493 | 2022-01-01 | Maunabo | Puerto Rico | 72095 | 729 | |
2072494 | 2072494 | 2022-01-01 | Mayaguez | Puerto Rico | 72097 | 5653 | |
2072495 | 2072495 | 2022-01-01 | Moca | Puerto Rico | 72099 | 3104 | |
2072496 | 2072496 | 2022-01-01 | Morovis | Puerto Rico | 72101 | 2624 | |
2072497 | 2072497 | 2022-01-01 | Naguabo | Puerto Rico | 72103 | 1864 | |
2072498 | 2072498 | 2022-01-01 | Naranjito | Puerto Rico | 72105 | 3318 | |
2072499 | 2072499 | 2022-01-01 | Orocovis | Puerto Rico | 72107 | 1661 | |
2072500 | 2072500 | 2022-01-01 | Patillas | Puerto Rico | 72109 | 891 | |
2072501 | 2072501 | 2022-01-01 | Penuelas | Puerto Rico | 72111 | 1106 | |
2072502 | 2072502 | 2022-01-01 | Ponce | Puerto Rico | 72113 | 8403 | |
2072503 | 2072503 | 2022-01-01 | Quebradillas | Puerto Rico | 72115 | 1839 | |
2072504 | 2072504 | 2022-01-01 | Rincon | Puerto Rico | 72117 | 1215 | |
2072505 | 2072505 | 2022-01-01 | Rio Grande | Puerto Rico | 72119 | 4622 | |
2072506 | 2072506 | 2022-01-01 | Sabana Grande | Puerto Rico | 72121 | 1117 | |
2072507 | 2072507 | 2022-01-01 | Salinas | Puerto Rico | 72123 | 1836 | |
2072508 | 2072508 | 2022-01-01 | San German | Puerto Rico | 72125 | 1718 | |
2072509 | 2072509 | 2022-01-01 | San Juan | Puerto Rico | 72127 | 41518 | |
2072510 | 2072510 | 2022-01-01 | San Lorenzo | Puerto Rico | 72129 | 3207 | |
2072511 | 2072511 | 2022-01-01 | San Sebastian | Puerto Rico | 72131 | 3559 | |
2072512 | 2072512 | 2022-01-01 | Santa Isabel | Puerto Rico | 72133 | 1313 | |
2072513 | 2072513 | 2022-01-01 | Toa Alta | Puerto Rico | 72135 | 7853 | |
2072514 | 2072514 | 2022-01-01 | Toa Baja | Puerto Rico | 72137 | 8174 | |
2072515 | 2072515 | 2022-01-01 | Trujillo Alto | Puerto Rico | 72139 | 6411 | |
2072516 | 2072516 | 2022-01-01 | Unknown | Puerto Rico | 8679 | 3308 | |
2072517 | 2072517 | 2022-01-01 | Utuado | Puerto Rico | 72141 | 1637 | |
2072518 | 2072518 | 2022-01-01 | Vega Alta | Puerto Rico | 72143 | 3754 | |
2072519 | 2072519 | 2022-01-01 | Vega Baja | Puerto Rico | 72145 | 6053 | |
2072520 | 2072520 | 2022-01-01 | Vieques | Puerto Rico | 72147 | 360 | |
2072521 | 2072521 | 2022-01-01 | Villalba | Puerto Rico | 72149 | 1502 | |
2072522 | 2072522 | 2022-01-01 | Yabucoa | Puerto Rico | 72151 | 2227 | |
2072523 | 2072523 | 2022-01-01 | Yauco | Puerto Rico | 72153 | 2179 |
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);