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 cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 79
- - 792
- 72001 739
- 72003 739
- 72005 739
- 72007 739
- 72009 739
- 72011 739
- 72013 739
- 72015 739
- 72017 739
- 72019 739
- 72021 739
- 72023 739
- 72025 739
- 72027 739
- 72029 739
- 72031 739
- 72033 739
- 72035 739
- 72037 739
- 72039 739
- 72041 739
- 72043 739
- 72045 739
- 72047 739
- 72051 739
- 72053 739
- 72054 739
- 72055 739
- 72057 739
- 72059 739
- 72061 739
- 72063 739
- 72065 739
- 72067 739
- 72069 739
- 72071 739
- 72073 739
- 72075 739
- 72077 739
- 72079 739
- 72081 739
- 72083 739
- 72085 739
- 72087 739
- 72089 739
- 72091 739
- 72095 739
- 72097 739
- 72099 739
- 72101 739
- 72103 739
- 72105 739
- 72107 739
- 72109 739
- 72111 739
- 72113 739
- 72115 739
- 72117 739
- 72119 739
- 72121 739
- 72123 739
- 72125 739
- 72127 739
- 72129 739
- 72131 739
- 72133 739
- 72135 739
- 72137 739
- 72139 739
- 72141 739
- 72143 739
- 72145 739
- 72149 739
- 72151 739
- 72153 739
- 72147 737
- 72093 728
- 72049 715
county 79
- Unknown 792
- Adjuntas 739
- Aguada 739
- Aguadilla 739
- Aguas Buenas 739
- Aibonito 739
- Anasco 739
- Arecibo 739
- Arroyo 739
- Barceloneta 739
- Barranquitas 739
- Bayamon 739
- Cabo Rojo 739
- Caguas 739
- Camuy 739
- Canovanas 739
- Carolina 739
- Catano 739
- Cayey 739
- Ceiba 739
- Ciales 739
- Cidra 739
- Coamo 739
- Comerio 739
- Corozal 739
- Dorado 739
- Fajardo 739
- Florida 739
- Guanica 739
- Guayama 739
- Guayanilla 739
- Guaynabo 739
- Gurabo 739
- Hatillo 739
- Hormigueros 739
- Humacao 739
- Isabela 739
- Jayuya 739
- Juana Diaz 739
- Juncos 739
- Lajas 739
- Lares 739
- Las Marias 739
- Las Piedras 739
- Loiza 739
- Luquillo 739
- Manati 739
- Maunabo 739
- Mayaguez 739
- Moca 739
- Morovis 739
- Naguabo 739
- Naranjito 739
- Orocovis 739
- Patillas 739
- Penuelas 739
- Ponce 739
- Quebradillas 739
- Rincon 739
- Rio Grande 739
- Sabana Grande 739
- Salinas 739
- San German 739
- San Juan 739
- San Lorenzo 739
- San Sebastian 739
- Santa Isabel 739
- Toa Alta 739
- Toa Baja 739
- Trujillo Alto 739
- Utuado 739
- Vega Alta 739
- Vega Baja 739
- Villalba 739
- Yabucoa 739
- Yauco 739
- Vieques 737
- Maricao 728
- Culebra 715
state 1
- Puerto Rico · 58,397 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
150414 | 150414 | 2020-05-16 | Maricao | Puerto Rico | 72093 | 1 | |
153425 | 153425 | 2020-05-17 | Maricao | Puerto Rico | 72093 | 1 | |
156442 | 156442 | 2020-05-18 | Maricao | Puerto Rico | 72093 | 1 | |
159463 | 159463 | 2020-05-19 | Maricao | Puerto Rico | 72093 | 1 | |
189869 | 189869 | 2020-05-29 | Culebra | Puerto Rico | 72049 | 1 | |
192934 | 192934 | 2020-05-30 | Culebra | Puerto Rico | 72049 | 1 | |
196003 | 196003 | 2020-05-31 | Culebra | Puerto Rico | 72049 | 1 | |
199076 | 199076 | 2020-06-01 | Culebra | Puerto Rico | 72049 | 1 | |
202151 | 202151 | 2020-06-02 | Culebra | Puerto Rico | 72049 | 1 | |
205228 | 205228 | 2020-06-03 | Culebra | Puerto Rico | 72049 | 1 | |
208309 | 208309 | 2020-06-04 | Culebra | Puerto Rico | 72049 | 1 | |
211391 | 211391 | 2020-06-05 | Culebra | Puerto Rico | 72049 | 1 | |
214477 | 214477 | 2020-06-06 | Culebra | Puerto Rico | 72049 | 1 | |
217567 | 217567 | 2020-06-07 | Culebra | Puerto Rico | 72049 | 1 | |
220659 | 220659 | 2020-06-08 | Culebra | Puerto Rico | 72049 | 1 | |
223754 | 223754 | 2020-06-09 | Culebra | Puerto Rico | 72049 | 1 | |
117523 | 117523 | 2020-05-05 | Jayuya | Puerto Rico | 72073 | 2 | |
117541 | 117541 | 2020-05-05 | Penuelas | Puerto Rico | 72111 | 2 | |
117544 | 117544 | 2020-05-05 | Rincon | Puerto Rico | 72117 | 2 | |
117557 | 117557 | 2020-05-05 | Utuado | Puerto Rico | 72141 | 2 | |
120485 | 120485 | 2020-05-06 | Jayuya | Puerto Rico | 72073 | 2 | |
120503 | 120503 | 2020-05-06 | Penuelas | Puerto Rico | 72111 | 2 | |
120506 | 120506 | 2020-05-06 | Rincon | Puerto Rico | 72117 | 2 | |
120519 | 120519 | 2020-05-06 | Utuado | Puerto Rico | 72141 | 2 | |
123462 | 123462 | 2020-05-07 | Jayuya | Puerto Rico | 72073 | 2 | |
123483 | 123483 | 2020-05-07 | Rincon | Puerto Rico | 72117 | 2 | |
123496 | 123496 | 2020-05-07 | Utuado | Puerto Rico | 72141 | 2 | |
126445 | 126445 | 2020-05-08 | Jayuya | Puerto Rico | 72073 | 2 | |
126466 | 126466 | 2020-05-08 | Rincon | Puerto Rico | 72117 | 2 | |
129434 | 129434 | 2020-05-09 | Jayuya | Puerto Rico | 72073 | 2 | |
129455 | 129455 | 2020-05-09 | Rincon | Puerto Rico | 72117 | 2 | |
132423 | 132423 | 2020-05-10 | Jayuya | Puerto Rico | 72073 | 2 | |
132444 | 132444 | 2020-05-10 | Rincon | Puerto Rico | 72117 | 2 | |
135414 | 135414 | 2020-05-11 | Jayuya | Puerto Rico | 72073 | 2 | |
135435 | 135435 | 2020-05-11 | Rincon | Puerto Rico | 72117 | 2 | |
138404 | 138404 | 2020-05-12 | Jayuya | Puerto Rico | 72073 | 2 | |
138425 | 138425 | 2020-05-12 | Rincon | Puerto Rico | 72117 | 2 | |
141400 | 141400 | 2020-05-13 | Jayuya | Puerto Rico | 72073 | 2 | |
141421 | 141421 | 2020-05-13 | Rincon | Puerto Rico | 72117 | 2 | |
144396 | 144396 | 2020-05-14 | Jayuya | Puerto Rico | 72073 | 2 | |
147397 | 147397 | 2020-05-15 | Jayuya | Puerto Rico | 72073 | 2 | |
150404 | 150404 | 2020-05-16 | Jayuya | Puerto Rico | 72073 | 2 | |
153415 | 153415 | 2020-05-17 | Jayuya | Puerto Rico | 72073 | 2 | |
156432 | 156432 | 2020-05-18 | Jayuya | Puerto Rico | 72073 | 2 | |
159453 | 159453 | 2020-05-19 | Jayuya | Puerto Rico | 72073 | 2 | |
162480 | 162480 | 2020-05-20 | Jayuya | Puerto Rico | 72073 | 2 | |
162490 | 162490 | 2020-05-20 | Maricao | Puerto Rico | 72093 | 2 | |
165509 | 165509 | 2020-05-21 | Jayuya | Puerto Rico | 72073 | 2 | |
226854 | 226854 | 2020-06-10 | Culebra | Puerto Rico | 72049 | 2 | |
229958 | 229958 | 2020-06-11 | Culebra | Puerto Rico | 72049 | 2 | |
233063 | 233063 | 2020-06-12 | Culebra | Puerto Rico | 72049 | 2 | |
236168 | 236168 | 2020-06-13 | Culebra | Puerto Rico | 72049 | 2 | |
239276 | 239276 | 2020-06-14 | Culebra | Puerto Rico | 72049 | 2 | |
242385 | 242385 | 2020-06-15 | Culebra | Puerto Rico | 72049 | 2 | |
245497 | 245497 | 2020-06-16 | Culebra | Puerto Rico | 72049 | 2 | |
248610 | 248610 | 2020-06-17 | Culebra | Puerto Rico | 72049 | 2 | |
251725 | 251725 | 2020-06-18 | Culebra | Puerto Rico | 72049 | 2 | |
254840 | 254840 | 2020-06-19 | Culebra | Puerto Rico | 72049 | 2 | |
257966 | 257966 | 2020-06-20 | Culebra | Puerto Rico | 72049 | 2 | |
261093 | 261093 | 2020-06-21 | Culebra | Puerto Rico | 72049 | 2 | |
264221 | 264221 | 2020-06-22 | Culebra | Puerto Rico | 72049 | 2 | |
267349 | 267349 | 2020-06-23 | Culebra | Puerto Rico | 72049 | 2 | |
270483 | 270483 | 2020-06-24 | Culebra | Puerto Rico | 72049 | 2 | |
273622 | 273622 | 2020-06-25 | Culebra | Puerto Rico | 72049 | 2 | |
276769 | 276769 | 2020-06-26 | Culebra | Puerto Rico | 72049 | 2 | |
279917 | 279917 | 2020-06-27 | Culebra | Puerto Rico | 72049 | 2 | |
283063 | 283063 | 2020-06-28 | Culebra | Puerto Rico | 72049 | 2 | |
286208 | 286208 | 2020-06-29 | Culebra | Puerto Rico | 72049 | 2 | |
1859 | 1859 | 2020-03-13 | Unknown | Puerto Rico | 3 | 0 | |
117487 | 117487 | 2020-05-05 | Adjuntas | Puerto Rico | 72001 | 3 | |
117495 | 117495 | 2020-05-05 | Barceloneta | Puerto Rico | 72017 | 3 | |
120449 | 120449 | 2020-05-06 | Adjuntas | Puerto Rico | 72001 | 3 | |
120475 | 120475 | 2020-05-06 | Florida | Puerto Rico | 72054 | 3 | |
123426 | 123426 | 2020-05-07 | Adjuntas | Puerto Rico | 72001 | 3 | |
126409 | 126409 | 2020-05-08 | Adjuntas | Puerto Rico | 72001 | 3 | |
126479 | 126479 | 2020-05-08 | Utuado | Puerto Rico | 72141 | 3 | |
129398 | 129398 | 2020-05-09 | Adjuntas | Puerto Rico | 72001 | 3 | |
129468 | 129468 | 2020-05-09 | Utuado | Puerto Rico | 72141 | 3 | |
132457 | 132457 | 2020-05-10 | Utuado | Puerto Rico | 72141 | 3 | |
135448 | 135448 | 2020-05-11 | Utuado | Puerto Rico | 72141 | 3 | |
138438 | 138438 | 2020-05-12 | Utuado | Puerto Rico | 72141 | 3 | |
141434 | 141434 | 2020-05-13 | Utuado | Puerto Rico | 72141 | 3 | |
144417 | 144417 | 2020-05-14 | Rincon | Puerto Rico | 72117 | 3 | |
144430 | 144430 | 2020-05-14 | Utuado | Puerto Rico | 72141 | 3 | |
147431 | 147431 | 2020-05-15 | Utuado | Puerto Rico | 72141 | 3 | |
150439 | 150439 | 2020-05-16 | Utuado | Puerto Rico | 72141 | 3 | |
153450 | 153450 | 2020-05-17 | Utuado | Puerto Rico | 72141 | 3 | |
156467 | 156467 | 2020-05-18 | Utuado | Puerto Rico | 72141 | 3 | |
159488 | 159488 | 2020-05-19 | Utuado | Puerto Rico | 72141 | 3 | |
162515 | 162515 | 2020-05-20 | Utuado | Puerto Rico | 72141 | 3 | |
165519 | 165519 | 2020-05-21 | Maricao | Puerto Rico | 72093 | 3 | |
165544 | 165544 | 2020-05-21 | Utuado | Puerto Rico | 72141 | 3 | |
168555 | 168555 | 2020-05-22 | Maricao | Puerto Rico | 72093 | 3 | |
168580 | 168580 | 2020-05-22 | Utuado | Puerto Rico | 72141 | 3 | |
171594 | 171594 | 2020-05-23 | Maricao | Puerto Rico | 72093 | 3 | |
171619 | 171619 | 2020-05-23 | Utuado | Puerto Rico | 72141 | 3 | |
174636 | 174636 | 2020-05-24 | Maricao | Puerto Rico | 72093 | 3 | |
174661 | 174661 | 2020-05-24 | Utuado | Puerto Rico | 72141 | 3 | |
177680 | 177680 | 2020-05-25 | Maricao | Puerto Rico | 72093 | 3 | |
177705 | 177705 | 2020-05-25 | Utuado | Puerto Rico | 72141 | 3 |
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);