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 >30
county >30
- 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
- …
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);