ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72011 and state = "Puerto Rico" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
117492 | 117492 | 2020-05-05 | Anasco | Puerto Rico | 72011 | 5 | |
120454 | 120454 | 2020-05-06 | Anasco | Puerto Rico | 72011 | 5 | |
123431 | 123431 | 2020-05-07 | Anasco | Puerto Rico | 72011 | 5 | |
126414 | 126414 | 2020-05-08 | Anasco | Puerto Rico | 72011 | 7 | |
129403 | 129403 | 2020-05-09 | Anasco | Puerto Rico | 72011 | 7 | |
132392 | 132392 | 2020-05-10 | Anasco | Puerto Rico | 72011 | 8 | |
135383 | 135383 | 2020-05-11 | Anasco | Puerto Rico | 72011 | 9 | |
138373 | 138373 | 2020-05-12 | Anasco | Puerto Rico | 72011 | 9 | |
141369 | 141369 | 2020-05-13 | Anasco | Puerto Rico | 72011 | 9 | |
156401 | 156401 | 2020-05-18 | Anasco | Puerto Rico | 72011 | 11 | |
159422 | 159422 | 2020-05-19 | Anasco | Puerto Rico | 72011 | 11 | |
162449 | 162449 | 2020-05-20 | Anasco | Puerto Rico | 72011 | 11 | |
144365 | 144365 | 2020-05-14 | Anasco | Puerto Rico | 72011 | 12 | |
147366 | 147366 | 2020-05-15 | Anasco | Puerto Rico | 72011 | 12 | |
150373 | 150373 | 2020-05-16 | Anasco | Puerto Rico | 72011 | 12 | |
153384 | 153384 | 2020-05-17 | Anasco | Puerto Rico | 72011 | 12 | |
165478 | 165478 | 2020-05-21 | Anasco | Puerto Rico | 72011 | 13 | |
168514 | 168514 | 2020-05-22 | Anasco | Puerto Rico | 72011 | 14 | |
171553 | 171553 | 2020-05-23 | Anasco | Puerto Rico | 72011 | 16 | |
174595 | 174595 | 2020-05-24 | Anasco | Puerto Rico | 72011 | 16 | |
177639 | 177639 | 2020-05-25 | Anasco | Puerto Rico | 72011 | 16 | |
180682 | 180682 | 2020-05-26 | Anasco | Puerto Rico | 72011 | 16 | |
183732 | 183732 | 2020-05-27 | Anasco | Puerto Rico | 72011 | 16 | |
186789 | 186789 | 2020-05-28 | Anasco | Puerto Rico | 72011 | 20 | |
189850 | 189850 | 2020-05-29 | Anasco | Puerto Rico | 72011 | 22 | |
192915 | 192915 | 2020-05-30 | Anasco | Puerto Rico | 72011 | 22 | |
195984 | 195984 | 2020-05-31 | Anasco | Puerto Rico | 72011 | 22 | |
199057 | 199057 | 2020-06-01 | Anasco | Puerto Rico | 72011 | 23 | |
202132 | 202132 | 2020-06-02 | Anasco | Puerto Rico | 72011 | 24 | |
205209 | 205209 | 2020-06-03 | Anasco | Puerto Rico | 72011 | 24 | |
208290 | 208290 | 2020-06-04 | Anasco | Puerto Rico | 72011 | 31 | |
211372 | 211372 | 2020-06-05 | Anasco | Puerto Rico | 72011 | 31 | |
214458 | 214458 | 2020-06-06 | Anasco | Puerto Rico | 72011 | 34 | |
217548 | 217548 | 2020-06-07 | Anasco | Puerto Rico | 72011 | 34 | |
220640 | 220640 | 2020-06-08 | Anasco | Puerto Rico | 72011 | 34 | |
223735 | 223735 | 2020-06-09 | Anasco | Puerto Rico | 72011 | 37 | |
226835 | 226835 | 2020-06-10 | Anasco | Puerto Rico | 72011 | 37 | |
229939 | 229939 | 2020-06-11 | Anasco | Puerto Rico | 72011 | 37 | |
233044 | 233044 | 2020-06-12 | Anasco | Puerto Rico | 72011 | 37 | |
236149 | 236149 | 2020-06-13 | Anasco | Puerto Rico | 72011 | 37 | |
239257 | 239257 | 2020-06-14 | Anasco | Puerto Rico | 72011 | 37 | |
242366 | 242366 | 2020-06-15 | Anasco | Puerto Rico | 72011 | 37 | |
245478 | 245478 | 2020-06-16 | Anasco | Puerto Rico | 72011 | 37 | |
248591 | 248591 | 2020-06-17 | Anasco | Puerto Rico | 72011 | 37 | |
251706 | 251706 | 2020-06-18 | Anasco | Puerto Rico | 72011 | 37 | |
254821 | 254821 | 2020-06-19 | Anasco | Puerto Rico | 72011 | 37 | |
257947 | 257947 | 2020-06-20 | Anasco | Puerto Rico | 72011 | 37 | |
261074 | 261074 | 2020-06-21 | Anasco | Puerto Rico | 72011 | 37 | |
264202 | 264202 | 2020-06-22 | Anasco | Puerto Rico | 72011 | 37 | |
267330 | 267330 | 2020-06-23 | Anasco | Puerto Rico | 72011 | 37 | |
270464 | 270464 | 2020-06-24 | Anasco | Puerto Rico | 72011 | 37 | |
273603 | 273603 | 2020-06-25 | Anasco | Puerto Rico | 72011 | 43 | |
276750 | 276750 | 2020-06-26 | Anasco | Puerto Rico | 72011 | 43 | |
279898 | 279898 | 2020-06-27 | Anasco | Puerto Rico | 72011 | 44 | |
283044 | 283044 | 2020-06-28 | Anasco | Puerto Rico | 72011 | 45 | |
286189 | 286189 | 2020-06-29 | Anasco | Puerto Rico | 72011 | 45 | |
289340 | 289340 | 2020-06-30 | Anasco | Puerto Rico | 72011 | 45 | |
292492 | 292492 | 2020-07-01 | Anasco | Puerto Rico | 72011 | 46 | |
295648 | 295648 | 2020-07-02 | Anasco | Puerto Rico | 72011 | 46 | |
298807 | 298807 | 2020-07-03 | Anasco | Puerto Rico | 72011 | 46 | |
301971 | 301971 | 2020-07-04 | Anasco | Puerto Rico | 72011 | 47 | |
305134 | 305134 | 2020-07-05 | Anasco | Puerto Rico | 72011 | 49 | |
308301 | 308301 | 2020-07-06 | Anasco | Puerto Rico | 72011 | 60 | |
311470 | 311470 | 2020-07-07 | Anasco | Puerto Rico | 72011 | 63 | |
314642 | 314642 | 2020-07-08 | Anasco | Puerto Rico | 72011 | 63 | |
317815 | 317815 | 2020-07-09 | Anasco | Puerto Rico | 72011 | 66 | |
320993 | 320993 | 2020-07-10 | Anasco | Puerto Rico | 72011 | 66 | |
324173 | 324173 | 2020-07-11 | Anasco | Puerto Rico | 72011 | 70 | |
327358 | 327358 | 2020-07-12 | Anasco | Puerto Rico | 72011 | 75 | |
330544 | 330544 | 2020-07-13 | Anasco | Puerto Rico | 72011 | 77 | |
333736 | 333736 | 2020-07-14 | Anasco | Puerto Rico | 72011 | 78 | |
340127 | 340127 | 2020-07-16 | Anasco | Puerto Rico | 72011 | 82 | |
336930 | 336930 | 2020-07-15 | Anasco | Puerto Rico | 72011 | 83 | |
343325 | 343325 | 2020-07-17 | Anasco | Puerto Rico | 72011 | 84 | |
346525 | 346525 | 2020-07-18 | Anasco | Puerto Rico | 72011 | 85 | |
349725 | 349725 | 2020-07-19 | Anasco | Puerto Rico | 72011 | 88 | |
352928 | 352928 | 2020-07-20 | Anasco | Puerto Rico | 72011 | 89 | |
356131 | 356131 | 2020-07-21 | Anasco | Puerto Rico | 72011 | 92 | |
359335 | 359335 | 2020-07-22 | Anasco | Puerto Rico | 72011 | 92 | |
362541 | 362541 | 2020-07-23 | Anasco | Puerto Rico | 72011 | 97 | |
365747 | 365747 | 2020-07-24 | Anasco | Puerto Rico | 72011 | 97 | |
368956 | 368956 | 2020-07-25 | Anasco | Puerto Rico | 72011 | 99 | |
372168 | 372168 | 2020-07-26 | Anasco | Puerto Rico | 72011 | 101 | |
375381 | 375381 | 2020-07-27 | Anasco | Puerto Rico | 72011 | 103 | |
378597 | 378597 | 2020-07-28 | Anasco | Puerto Rico | 72011 | 105 | |
381814 | 381814 | 2020-07-29 | Anasco | Puerto Rico | 72011 | 105 | |
385032 | 385032 | 2020-07-30 | Anasco | Puerto Rico | 72011 | 108 | |
388249 | 388249 | 2020-07-31 | Anasco | Puerto Rico | 72011 | 108 | |
391466 | 391466 | 2020-08-01 | Anasco | Puerto Rico | 72011 | 122 | |
394682 | 394682 | 2020-08-02 | Anasco | Puerto Rico | 72011 | 124 | |
397899 | 397899 | 2020-08-03 | Anasco | Puerto Rico | 72011 | 125 | |
401114 | 401114 | 2020-08-04 | Anasco | Puerto Rico | 72011 | 128 | |
404332 | 404332 | 2020-08-05 | Anasco | Puerto Rico | 72011 | 130 | |
407551 | 407551 | 2020-08-06 | Anasco | Puerto Rico | 72011 | 131 | |
410771 | 410771 | 2020-08-07 | Anasco | Puerto Rico | 72011 | 131 | |
413991 | 413991 | 2020-08-08 | Anasco | Puerto Rico | 72011 | 134 | |
417212 | 417212 | 2020-08-09 | Anasco | Puerto Rico | 72011 | 142 | |
420432 | 420432 | 2020-08-10 | Anasco | Puerto Rico | 72011 | 145 | |
423655 | 423655 | 2020-08-11 | Anasco | Puerto Rico | 72011 | 147 | |
426878 | 426878 | 2020-08-12 | Anasco | Puerto Rico | 72011 | 150 |
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);