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)
fips >30
county >30
- Unknown 791
- Aguada 739
- Aguadilla 739
- Aguas Buenas 739
- Aibonito 739
- Anasco 739
- Arecibo 739
- Arroyo 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
- Guanica 739
- Guayama 739
- Guayanilla 739
- Guaynabo 739
- Gurabo 739
- …
state 1
- Puerto Rico · 58,297 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
180723 | 180723 | 2020-05-26 | Maricao | Puerto Rico | 72093 | 3 | |
180748 | 180748 | 2020-05-26 | Utuado | Puerto Rico | 72141 | 3 | |
183773 | 183773 | 2020-05-27 | Maricao | Puerto Rico | 72093 | 3 | |
183798 | 183798 | 2020-05-27 | Utuado | Puerto Rico | 72141 | 3 | |
186830 | 186830 | 2020-05-28 | Maricao | Puerto Rico | 72093 | 3 | |
186855 | 186855 | 2020-05-28 | Utuado | Puerto Rico | 72141 | 3 | |
189892 | 189892 | 2020-05-29 | Maricao | Puerto Rico | 72093 | 3 | |
189917 | 189917 | 2020-05-29 | Utuado | Puerto Rico | 72141 | 3 | |
192957 | 192957 | 2020-05-30 | Maricao | Puerto Rico | 72093 | 3 | |
192982 | 192982 | 2020-05-30 | Utuado | Puerto Rico | 72141 | 3 | |
196026 | 196026 | 2020-05-31 | Maricao | Puerto Rico | 72093 | 3 | |
196051 | 196051 | 2020-05-31 | Utuado | Puerto Rico | 72141 | 3 | |
199099 | 199099 | 2020-06-01 | Maricao | Puerto Rico | 72093 | 3 | |
199124 | 199124 | 2020-06-01 | Utuado | Puerto Rico | 72141 | 3 | |
202174 | 202174 | 2020-06-02 | Maricao | Puerto Rico | 72093 | 3 | |
202199 | 202199 | 2020-06-02 | Utuado | Puerto Rico | 72141 | 3 | |
205251 | 205251 | 2020-06-03 | Maricao | Puerto Rico | 72093 | 3 | |
205276 | 205276 | 2020-06-03 | Utuado | Puerto Rico | 72141 | 3 | |
289359 | 289359 | 2020-06-30 | Culebra | Puerto Rico | 72049 | 3 | |
292511 | 292511 | 2020-07-01 | Culebra | Puerto Rico | 72049 | 3 | |
295667 | 295667 | 2020-07-02 | Culebra | Puerto Rico | 72049 | 3 | |
298826 | 298826 | 2020-07-03 | Culebra | Puerto Rico | 72049 | 3 | |
301990 | 301990 | 2020-07-04 | Culebra | Puerto Rico | 72049 | 3 | |
305153 | 305153 | 2020-07-05 | Culebra | Puerto Rico | 72049 | 3 | |
308320 | 308320 | 2020-07-06 | Culebra | Puerto Rico | 72049 | 3 | |
2221 | 2221 | 2020-03-14 | Unknown | Puerto Rico | 4 | 0 | |
117508 | 117508 | 2020-05-05 | Coamo | Puerto Rico | 72043 | 4 | |
117513 | 117513 | 2020-05-05 | Florida | Puerto Rico | 72054 | 4 | |
117533 | 117533 | 2020-05-05 | Maunabo | Puerto Rico | 72095 | 4 | |
120457 | 120457 | 2020-05-06 | Barceloneta | Puerto Rico | 72017 | 4 | |
120495 | 120495 | 2020-05-06 | Maunabo | Puerto Rico | 72095 | 4 | |
123480 | 123480 | 2020-05-07 | Penuelas | Puerto Rico | 72111 | 4 | |
126463 | 126463 | 2020-05-08 | Penuelas | Puerto Rico | 72111 | 4 | |
129452 | 129452 | 2020-05-09 | Penuelas | Puerto Rico | 72111 | 4 | |
132387 | 132387 | 2020-05-10 | Adjuntas | Puerto Rico | 72001 | 4 | |
132441 | 132441 | 2020-05-10 | Penuelas | Puerto Rico | 72111 | 4 | |
135378 | 135378 | 2020-05-11 | Adjuntas | Puerto Rico | 72001 | 4 | |
135432 | 135432 | 2020-05-11 | Penuelas | Puerto Rico | 72111 | 4 | |
138368 | 138368 | 2020-05-12 | Adjuntas | Puerto Rico | 72001 | 4 | |
141364 | 141364 | 2020-05-13 | Adjuntas | Puerto Rico | 72001 | 4 | |
144360 | 144360 | 2020-05-14 | Adjuntas | Puerto Rico | 72001 | 4 | |
147361 | 147361 | 2020-05-15 | Adjuntas | Puerto Rico | 72001 | 4 | |
147418 | 147418 | 2020-05-15 | Rincon | Puerto Rico | 72117 | 4 | |
150368 | 150368 | 2020-05-16 | Adjuntas | Puerto Rico | 72001 | 4 | |
153379 | 153379 | 2020-05-17 | Adjuntas | Puerto Rico | 72001 | 4 | |
208332 | 208332 | 2020-06-04 | Maricao | Puerto Rico | 72093 | 4 | |
211414 | 211414 | 2020-06-05 | Maricao | Puerto Rico | 72093 | 4 | |
311489 | 311489 | 2020-07-07 | Culebra | Puerto Rico | 72049 | 4 | |
314661 | 314661 | 2020-07-08 | Culebra | Puerto Rico | 72049 | 4 | |
317834 | 317834 | 2020-07-09 | Culebra | Puerto Rico | 72049 | 4 | |
321012 | 321012 | 2020-07-10 | Culebra | Puerto Rico | 72049 | 4 | |
324192 | 324192 | 2020-07-11 | Culebra | Puerto Rico | 72049 | 4 | |
327377 | 327377 | 2020-07-12 | Culebra | Puerto Rico | 72049 | 4 | |
330563 | 330563 | 2020-07-13 | Culebra | Puerto Rico | 72049 | 4 | |
2643 | 2643 | 2020-03-15 | Unknown | Puerto Rico | 5 | 0 | |
3108 | 3108 | 2020-03-16 | Unknown | Puerto Rico | 5 | 0 | |
3638 | 3638 | 2020-03-17 | Unknown | Puerto Rico | 5 | 0 | |
4257 | 4257 | 2020-03-18 | Unknown | Puerto Rico | 5 | 0 | |
117492 | 117492 | 2020-05-05 | Anasco | Puerto Rico | 72011 | 5 | |
117494 | 117494 | 2020-05-05 | Arroyo | Puerto Rico | 72015 | 5 | |
117528 | 117528 | 2020-05-05 | Las Marias | Puerto Rico | 72083 | 5 | |
120454 | 120454 | 2020-05-06 | Anasco | Puerto Rico | 72011 | 5 | |
120456 | 120456 | 2020-05-06 | Arroyo | Puerto Rico | 72015 | 5 | |
120470 | 120470 | 2020-05-06 | Coamo | Puerto Rico | 72043 | 5 | |
120490 | 120490 | 2020-05-06 | Las Marias | Puerto Rico | 72083 | 5 | |
123431 | 123431 | 2020-05-07 | Anasco | Puerto Rico | 72011 | 5 | |
123433 | 123433 | 2020-05-07 | Arroyo | Puerto Rico | 72015 | 5 | |
123434 | 123434 | 2020-05-07 | Barceloneta | Puerto Rico | 72017 | 5 | |
123447 | 123447 | 2020-05-07 | Coamo | Puerto Rico | 72043 | 5 | |
123452 | 123452 | 2020-05-07 | Florida | Puerto Rico | 72054 | 5 | |
123467 | 123467 | 2020-05-07 | Las Marias | Puerto Rico | 72083 | 5 | |
123472 | 123472 | 2020-05-07 | Maunabo | Puerto Rico | 72095 | 5 | |
126416 | 126416 | 2020-05-08 | Arroyo | Puerto Rico | 72015 | 5 | |
126417 | 126417 | 2020-05-08 | Barceloneta | Puerto Rico | 72017 | 5 | |
126435 | 126435 | 2020-05-08 | Florida | Puerto Rico | 72054 | 5 | |
126450 | 126450 | 2020-05-08 | Las Marias | Puerto Rico | 72083 | 5 | |
126455 | 126455 | 2020-05-08 | Maunabo | Puerto Rico | 72095 | 5 | |
129405 | 129405 | 2020-05-09 | Arroyo | Puerto Rico | 72015 | 5 | |
129406 | 129406 | 2020-05-09 | Barceloneta | Puerto Rico | 72017 | 5 | |
129424 | 129424 | 2020-05-09 | Florida | Puerto Rico | 72054 | 5 | |
129439 | 129439 | 2020-05-09 | Las Marias | Puerto Rico | 72083 | 5 | |
129444 | 129444 | 2020-05-09 | Maunabo | Puerto Rico | 72095 | 5 | |
132394 | 132394 | 2020-05-10 | Arroyo | Puerto Rico | 72015 | 5 | |
132395 | 132395 | 2020-05-10 | Barceloneta | Puerto Rico | 72017 | 5 | |
132413 | 132413 | 2020-05-10 | Florida | Puerto Rico | 72054 | 5 | |
132428 | 132428 | 2020-05-10 | Las Marias | Puerto Rico | 72083 | 5 | |
132433 | 132433 | 2020-05-10 | Maunabo | Puerto Rico | 72095 | 5 | |
135386 | 135386 | 2020-05-11 | Barceloneta | Puerto Rico | 72017 | 5 | |
135404 | 135404 | 2020-05-11 | Florida | Puerto Rico | 72054 | 5 | |
135424 | 135424 | 2020-05-11 | Maunabo | Puerto Rico | 72095 | 5 | |
138376 | 138376 | 2020-05-12 | Barceloneta | Puerto Rico | 72017 | 5 | |
138414 | 138414 | 2020-05-12 | Maunabo | Puerto Rico | 72095 | 5 | |
138422 | 138422 | 2020-05-12 | Penuelas | Puerto Rico | 72111 | 5 | |
141372 | 141372 | 2020-05-13 | Barceloneta | Puerto Rico | 72017 | 5 | |
141418 | 141418 | 2020-05-13 | Penuelas | Puerto Rico | 72111 | 5 | |
144368 | 144368 | 2020-05-14 | Barceloneta | Puerto Rico | 72017 | 5 | |
144414 | 144414 | 2020-05-14 | Penuelas | Puerto Rico | 72111 | 5 | |
147415 | 147415 | 2020-05-15 | Penuelas | Puerto Rico | 72111 | 5 | |
150423 | 150423 | 2020-05-16 | Penuelas | Puerto Rico | 72111 | 5 | |
150426 | 150426 | 2020-05-16 | Rincon | Puerto Rico | 72117 | 5 |
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);