ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
79 rows where "date" is on date 2022-01-05 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|
2085451 | 2085451 | 2022-01-05 | Adjuntas | Puerto Rico | 72001 | 1134 | |
2085452 | 2085452 | 2022-01-05 | Aguada | Puerto Rico | 72003 | 3913 | |
2085453 | 2085453 | 2022-01-05 | Aguadilla | Puerto Rico | 72005 | 4555 | |
2085454 | 2085454 | 2022-01-05 | Aguas Buenas | Puerto Rico | 72007 | 2544 | |
2085455 | 2085455 | 2022-01-05 | Aibonito | Puerto Rico | 72009 | 2074 | |
2085456 | 2085456 | 2022-01-05 | Anasco | Puerto Rico | 72011 | 2271 | |
2085457 | 2085457 | 2022-01-05 | Arecibo | Puerto Rico | 72013 | 7496 | |
2085458 | 2085458 | 2022-01-05 | Arroyo | Puerto Rico | 72015 | 991 | |
2085459 | 2085459 | 2022-01-05 | Barceloneta | Puerto Rico | 72017 | 1862 | |
2085460 | 2085460 | 2022-01-05 | Barranquitas | Puerto Rico | 72019 | 3110 | |
2085461 | 2085461 | 2022-01-05 | Bayamon | Puerto Rico | 72021 | 24267 | |
2085462 | 2085462 | 2022-01-05 | Cabo Rojo | Puerto Rico | 72023 | 3419 | |
2085463 | 2085463 | 2022-01-05 | Caguas | Puerto Rico | 72025 | 14811 | |
2085464 | 2085464 | 2022-01-05 | Camuy | Puerto Rico | 72027 | 2809 | |
2085465 | 2085465 | 2022-01-05 | Canovanas | Puerto Rico | 72029 | 4583 | |
2085466 | 2085466 | 2022-01-05 | Carolina | Puerto Rico | 72031 | 20096 | |
2085467 | 2085467 | 2022-01-05 | Catano | Puerto Rico | 72033 | 2866 | |
2085468 | 2085468 | 2022-01-05 | Cayey | Puerto Rico | 72035 | 3697 | |
2085469 | 2085469 | 2022-01-05 | Ceiba | Puerto Rico | 72037 | 897 | |
2085470 | 2085470 | 2022-01-05 | Ciales | Puerto Rico | 72039 | 1591 | |
2085471 | 2085471 | 2022-01-05 | Cidra | Puerto Rico | 72041 | 3477 | |
2085472 | 2085472 | 2022-01-05 | Coamo | Puerto Rico | 72043 | 2609 | |
2085473 | 2085473 | 2022-01-05 | Comerio | Puerto Rico | 72045 | 1706 | |
2085474 | 2085474 | 2022-01-05 | Corozal | Puerto Rico | 72047 | 3986 | |
2085475 | 2085475 | 2022-01-05 | Culebra | Puerto Rico | 72049 | 137 | |
2085476 | 2085476 | 2022-01-05 | Dorado | Puerto Rico | 72051 | 4742 | |
2085477 | 2085477 | 2022-01-05 | Fajardo | Puerto Rico | 72053 | 3181 | |
2085478 | 2085478 | 2022-01-05 | Florida | Puerto Rico | 72054 | 1430 | |
2085479 | 2085479 | 2022-01-05 | Guanica | Puerto Rico | 72055 | 774 | |
2085480 | 2085480 | 2022-01-05 | Guayama | Puerto Rico | 72057 | 2627 | |
2085481 | 2085481 | 2022-01-05 | Guayanilla | Puerto Rico | 72059 | 1049 | |
2085482 | 2085482 | 2022-01-05 | Guaynabo | Puerto Rico | 72061 | 10821 | |
2085483 | 2085483 | 2022-01-05 | Gurabo | Puerto Rico | 72063 | 4748 | |
2085484 | 2085484 | 2022-01-05 | Hatillo | Puerto Rico | 72065 | 3008 | |
2085485 | 2085485 | 2022-01-05 | Hormigueros | Puerto Rico | 72067 | 1214 | |
2085486 | 2085486 | 2022-01-05 | Humacao | Puerto Rico | 72069 | 4990 | |
2085487 | 2085487 | 2022-01-05 | Isabela | Puerto Rico | 72071 | 3891 | |
2085488 | 2085488 | 2022-01-05 | Jayuya | Puerto Rico | 72073 | 1166 | |
2085489 | 2085489 | 2022-01-05 | Juana Diaz | Puerto Rico | 72075 | 3294 | |
2085490 | 2085490 | 2022-01-05 | Juncos | Puerto Rico | 72077 | 4365 | |
2085491 | 2085491 | 2022-01-05 | Lajas | Puerto Rico | 72079 | 1382 | |
2085492 | 2085492 | 2022-01-05 | Lares | Puerto Rico | 72081 | 2218 | |
2085493 | 2085493 | 2022-01-05 | Las Marias | Puerto Rico | 72083 | 602 | |
2085494 | 2085494 | 2022-01-05 | Las Piedras | Puerto Rico | 72085 | 3516 | |
2085495 | 2085495 | 2022-01-05 | Loiza | Puerto Rico | 72087 | 2292 | |
2085496 | 2085496 | 2022-01-05 | Luquillo | Puerto Rico | 72089 | 1729 | |
2085497 | 2085497 | 2022-01-05 | Manati | Puerto Rico | 72091 | 3736 | |
2085498 | 2085498 | 2022-01-05 | Maricao | Puerto Rico | 72093 | 311 | |
2085499 | 2085499 | 2022-01-05 | Maunabo | Puerto Rico | 72095 | 837 | |
2085500 | 2085500 | 2022-01-05 | Mayaguez | Puerto Rico | 72097 | 6502 | |
2085501 | 2085501 | 2022-01-05 | Moca | Puerto Rico | 72099 | 3601 | |
2085502 | 2085502 | 2022-01-05 | Morovis | Puerto Rico | 72101 | 2926 | |
2085503 | 2085503 | 2022-01-05 | Naguabo | Puerto Rico | 72103 | 2074 | |
2085504 | 2085504 | 2022-01-05 | Naranjito | Puerto Rico | 72105 | 3626 | |
2085505 | 2085505 | 2022-01-05 | Orocovis | Puerto Rico | 72107 | 1839 | |
2085506 | 2085506 | 2022-01-05 | Patillas | Puerto Rico | 72109 | 1093 | |
2085507 | 2085507 | 2022-01-05 | Penuelas | Puerto Rico | 72111 | 1270 | |
2085508 | 2085508 | 2022-01-05 | Ponce | Puerto Rico | 72113 | 10031 | |
2085509 | 2085509 | 2022-01-05 | Quebradillas | Puerto Rico | 72115 | 2128 | |
2085510 | 2085510 | 2022-01-05 | Rincon | Puerto Rico | 72117 | 1444 | |
2085511 | 2085511 | 2022-01-05 | Rio Grande | Puerto Rico | 72119 | 5124 | |
2085512 | 2085512 | 2022-01-05 | Sabana Grande | Puerto Rico | 72121 | 1347 | |
2085513 | 2085513 | 2022-01-05 | Salinas | Puerto Rico | 72123 | 2166 | |
2085514 | 2085514 | 2022-01-05 | San German | Puerto Rico | 72125 | 2109 | |
2085515 | 2085515 | 2022-01-05 | San Juan | Puerto Rico | 72127 | 45535 | |
2085516 | 2085516 | 2022-01-05 | San Lorenzo | Puerto Rico | 72129 | 3606 | |
2085517 | 2085517 | 2022-01-05 | San Sebastian | Puerto Rico | 72131 | 4034 | |
2085518 | 2085518 | 2022-01-05 | Santa Isabel | Puerto Rico | 72133 | 1558 | |
2085519 | 2085519 | 2022-01-05 | Toa Alta | Puerto Rico | 72135 | 8601 | |
2085520 | 2085520 | 2022-01-05 | Toa Baja | Puerto Rico | 72137 | 9043 | |
2085521 | 2085521 | 2022-01-05 | Trujillo Alto | Puerto Rico | 72139 | 6987 | |
2085522 | 2085522 | 2022-01-05 | Unknown | Puerto Rico | 10528 | 3324 | |
2085523 | 2085523 | 2022-01-05 | Utuado | Puerto Rico | 72141 | 1942 | |
2085524 | 2085524 | 2022-01-05 | Vega Alta | Puerto Rico | 72143 | 4100 | |
2085525 | 2085525 | 2022-01-05 | Vega Baja | Puerto Rico | 72145 | 6896 | |
2085526 | 2085526 | 2022-01-05 | Vieques | Puerto Rico | 72147 | 398 | |
2085527 | 2085527 | 2022-01-05 | Villalba | Puerto Rico | 72149 | 1885 | |
2085528 | 2085528 | 2022-01-05 | Yabucoa | Puerto Rico | 72151 | 2562 | |
2085529 | 2085529 | 2022-01-05 | Yauco | Puerto Rico | 72153 | 2584 |
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);