ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
106 rows where cases = 38 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
- Manati 16
- Adjuntas 7
- Culebra 7
- Coamo 6
- Juncos 5
- Camuy 3
- Corozal 3
- Luquillo 3
- Moca 3
- Sabana Grande 3
- Vega Alta 3
- Villalba 3
- Aguas Buenas 2
- Aibonito 2
- Canovanas 2
- Guayanilla 2
- Gurabo 2
- Hatillo 2
- Hormigueros 2
- Humacao 2
- Isabela 2
- Juana Diaz 2
- Morovis 2
- Naguabo 2
- Patillas 2
- Rincon 2
- Trujillo Alto 2
- Aguadilla 1
- Barceloneta 1
- Ceiba 1
- …
state 1
- Puerto Rico · 106 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1257169 | 1257169 | 2021-04-25 | Culebra | Puerto Rico | 72049 | 38 | |
1253922 | 1253922 | 2021-04-24 | Culebra | Puerto Rico | 72049 | 38 | |
1250675 | 1250675 | 2021-04-23 | Culebra | Puerto Rico | 72049 | 38 | |
1247428 | 1247428 | 2021-04-22 | Culebra | Puerto Rico | 72049 | 38 | |
1244181 | 1244181 | 2021-04-21 | Culebra | Puerto Rico | 72049 | 38 | |
1240934 | 1240934 | 2021-04-20 | Culebra | Puerto Rico | 72049 | 38 | |
1237687 | 1237687 | 2021-04-19 | Culebra | Puerto Rico | 72049 | 38 | |
368998 | 368998 | 2020-07-25 | Maricao | Puerto Rico | 72093 | 38 | |
365784 | 365784 | 2020-07-24 | Las Marias | Puerto Rico | 72083 | 38 | |
352931 | 352931 | 2020-07-20 | Barceloneta | Puerto Rico | 72017 | 38 | |
340140 | 340140 | 2020-07-16 | Ceiba | Puerto Rico | 72037 | 38 | |
324202 | 324202 | 2020-07-11 | Hormigueros | Puerto Rico | 72067 | 38 | |
321022 | 321022 | 2020-07-10 | Hormigueros | Puerto Rico | 72067 | 38 | |
317838 | 317838 | 2020-07-09 | Guanica | Puerto Rico | 72055 | 38 | |
311524 | 311524 | 2020-07-07 | Rincon | Puerto Rico | 72117 | 38 | |
308355 | 308355 | 2020-07-06 | Rincon | Puerto Rico | 72117 | 38 | |
305162 | 305162 | 2020-07-05 | Hatillo | Puerto Rico | 72065 | 38 | |
301999 | 301999 | 2020-07-04 | Hatillo | Puerto Rico | 72065 | 38 | |
295670 | 295670 | 2020-07-02 | Florida | Puerto Rico | 72054 | 38 | |
295720 | 295720 | 2020-07-02 | Yabucoa | Puerto Rico | 72151 | 38 | |
292523 | 292523 | 2020-07-01 | Isabela | Puerto Rico | 72071 | 38 | |
289371 | 289371 | 2020-06-30 | Isabela | Puerto Rico | 72071 | 38 | |
276803 | 276803 | 2020-06-26 | Quebradillas | Puerto Rico | 72115 | 38 | |
270505 | 270505 | 2020-06-24 | Manati | Puerto Rico | 72091 | 38 | |
267370 | 267370 | 2020-06-23 | Luquillo | Puerto Rico | 72089 | 38 | |
267371 | 267371 | 2020-06-23 | Manati | Puerto Rico | 72091 | 38 | |
264210 | 264210 | 2020-06-22 | Camuy | Puerto Rico | 72027 | 38 | |
264242 | 264242 | 2020-06-22 | Luquillo | Puerto Rico | 72089 | 38 | |
264243 | 264243 | 2020-06-22 | Manati | Puerto Rico | 72091 | 38 | |
261082 | 261082 | 2020-06-21 | Camuy | Puerto Rico | 72027 | 38 | |
261090 | 261090 | 2020-06-21 | Coamo | Puerto Rico | 72043 | 38 | |
261099 | 261099 | 2020-06-21 | Guayanilla | Puerto Rico | 72059 | 38 | |
261114 | 261114 | 2020-06-21 | Luquillo | Puerto Rico | 72089 | 38 | |
261115 | 261115 | 2020-06-21 | Manati | Puerto Rico | 72091 | 38 | |
257944 | 257944 | 2020-06-20 | Aguadilla | Puerto Rico | 72005 | 38 | |
257955 | 257955 | 2020-06-20 | Camuy | Puerto Rico | 72027 | 38 | |
257963 | 257963 | 2020-06-20 | Coamo | Puerto Rico | 72043 | 38 | |
257972 | 257972 | 2020-06-20 | Guayanilla | Puerto Rico | 72059 | 38 | |
257988 | 257988 | 2020-06-20 | Manati | Puerto Rico | 72091 | 38 | |
254855 | 254855 | 2020-06-19 | Juncos | Puerto Rico | 72077 | 38 | |
254862 | 254862 | 2020-06-19 | Manati | Puerto Rico | 72091 | 38 | |
254866 | 254866 | 2020-06-19 | Moca | Puerto Rico | 72099 | 38 | |
254868 | 254868 | 2020-06-19 | Naguabo | Puerto Rico | 72103 | 38 | |
251705 | 251705 | 2020-06-18 | Aibonito | Puerto Rico | 72009 | 38 | |
251740 | 251740 | 2020-06-18 | Juncos | Puerto Rico | 72077 | 38 | |
251747 | 251747 | 2020-06-18 | Manati | Puerto Rico | 72091 | 38 | |
251753 | 251753 | 2020-06-18 | Naguabo | Puerto Rico | 72103 | 38 | |
248586 | 248586 | 2020-06-17 | Adjuntas | Puerto Rico | 72001 | 38 | |
248590 | 248590 | 2020-06-17 | Aibonito | Puerto Rico | 72009 | 38 | |
248632 | 248632 | 2020-06-17 | Manati | Puerto Rico | 72091 | 38 | |
245473 | 245473 | 2020-06-16 | Adjuntas | Puerto Rico | 72001 | 38 | |
245494 | 245494 | 2020-06-16 | Coamo | Puerto Rico | 72043 | 38 | |
245519 | 245519 | 2020-06-16 | Manati | Puerto Rico | 72091 | 38 | |
242361 | 242361 | 2020-06-15 | Adjuntas | Puerto Rico | 72001 | 38 | |
242382 | 242382 | 2020-06-15 | Coamo | Puerto Rico | 72043 | 38 | |
242400 | 242400 | 2020-06-15 | Juncos | Puerto Rico | 72077 | 38 | |
242407 | 242407 | 2020-06-15 | Manati | Puerto Rico | 72091 | 38 | |
239252 | 239252 | 2020-06-14 | Adjuntas | Puerto Rico | 72001 | 38 | |
239273 | 239273 | 2020-06-14 | Coamo | Puerto Rico | 72043 | 38 | |
239291 | 239291 | 2020-06-14 | Juncos | Puerto Rico | 72077 | 38 | |
239298 | 239298 | 2020-06-14 | Manati | Puerto Rico | 72091 | 38 | |
239302 | 239302 | 2020-06-14 | Moca | Puerto Rico | 72099 | 38 | |
236144 | 236144 | 2020-06-13 | Adjuntas | Puerto Rico | 72001 | 38 | |
236165 | 236165 | 2020-06-13 | Coamo | Puerto Rico | 72043 | 38 | |
236190 | 236190 | 2020-06-13 | Manati | Puerto Rico | 72091 | 38 | |
236194 | 236194 | 2020-06-13 | Moca | Puerto Rico | 72099 | 38 | |
233078 | 233078 | 2020-06-12 | Juncos | Puerto Rico | 72077 | 38 | |
233085 | 233085 | 2020-06-12 | Manati | Puerto Rico | 72091 | 38 | |
233115 | 233115 | 2020-06-12 | Villalba | Puerto Rico | 72149 | 38 | |
229934 | 229934 | 2020-06-11 | Adjuntas | Puerto Rico | 72001 | 38 | |
229957 | 229957 | 2020-06-11 | Corozal | Puerto Rico | 72047 | 38 | |
229974 | 229974 | 2020-06-11 | Lajas | Puerto Rico | 72079 | 38 | |
229980 | 229980 | 2020-06-11 | Manati | Puerto Rico | 72091 | 38 | |
230010 | 230010 | 2020-06-11 | Villalba | Puerto Rico | 72149 | 38 | |
226830 | 226830 | 2020-06-10 | Adjuntas | Puerto Rico | 72001 | 38 | |
226853 | 226853 | 2020-06-10 | Corozal | Puerto Rico | 72047 | 38 | |
226876 | 226876 | 2020-06-10 | Manati | Puerto Rico | 72091 | 38 | |
226891 | 226891 | 2020-06-10 | Sabana Grande | Puerto Rico | 72121 | 38 | |
226906 | 226906 | 2020-06-10 | Villalba | Puerto Rico | 72149 | 38 | |
223753 | 223753 | 2020-06-09 | Corozal | Puerto Rico | 72047 | 38 | |
223776 | 223776 | 2020-06-09 | Manati | Puerto Rico | 72091 | 38 | |
223791 | 223791 | 2020-06-09 | Sabana Grande | Puerto Rico | 72121 | 38 | |
220696 | 220696 | 2020-06-08 | Sabana Grande | Puerto Rico | 72121 | 38 | |
211422 | 211422 | 2020-06-05 | Patillas | Puerto Rico | 72109 | 38 | |
208340 | 208340 | 2020-06-04 | Patillas | Puerto Rico | 72109 | 38 | |
199055 | 199055 | 2020-06-01 | Aguas Buenas | Puerto Rico | 72007 | 38 | |
199103 | 199103 | 2020-06-01 | Morovis | Puerto Rico | 72101 | 38 | |
195982 | 195982 | 2020-05-31 | Aguas Buenas | Puerto Rico | 72007 | 38 | |
196020 | 196020 | 2020-05-31 | Lares | Puerto Rico | 72081 | 38 | |
196030 | 196030 | 2020-05-31 | Morovis | Puerto Rico | 72101 | 38 | |
186857 | 186857 | 2020-05-28 | Vega Baja | Puerto Rico | 72145 | 38 | |
180742 | 180742 | 2020-05-26 | San Sebastian | Puerto Rico | 72131 | 38 | |
177706 | 177706 | 2020-05-25 | Vega Alta | Puerto Rico | 72143 | 38 | |
174627 | 174627 | 2020-05-24 | Juana Diaz | Puerto Rico | 72075 | 38 | |
174662 | 174662 | 2020-05-24 | Vega Alta | Puerto Rico | 72143 | 38 | |
171582 | 171582 | 2020-05-23 | Humacao | Puerto Rico | 72069 | 38 | |
171585 | 171585 | 2020-05-23 | Juana Diaz | Puerto Rico | 72075 | 38 | |
171620 | 171620 | 2020-05-23 | Vega Alta | Puerto Rico | 72143 | 38 | |
168543 | 168543 | 2020-05-22 | Humacao | Puerto Rico | 72069 | 38 | |
165504 | 165504 | 2020-05-21 | Gurabo | Puerto Rico | 72063 | 38 |
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);