ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72007 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
637216 | 637216 | 2020-10-16 | Aguas Buenas | Puerto Rico | 72007 | 334 | |
633970 | 633970 | 2020-10-15 | Aguas Buenas | Puerto Rico | 72007 | 333 | |
630725 | 630725 | 2020-10-14 | Aguas Buenas | Puerto Rico | 72007 | 327 | |
627481 | 627481 | 2020-10-13 | Aguas Buenas | Puerto Rico | 72007 | 324 | |
624239 | 624239 | 2020-10-12 | Aguas Buenas | Puerto Rico | 72007 | 323 | |
620996 | 620996 | 2020-10-11 | Aguas Buenas | Puerto Rico | 72007 | 318 | |
617753 | 617753 | 2020-10-10 | Aguas Buenas | Puerto Rico | 72007 | 315 | |
614511 | 614511 | 2020-10-09 | Aguas Buenas | Puerto Rico | 72007 | 311 | |
611270 | 611270 | 2020-10-08 | Aguas Buenas | Puerto Rico | 72007 | 307 | |
608028 | 608028 | 2020-10-07 | Aguas Buenas | Puerto Rico | 72007 | 306 | |
604785 | 604785 | 2020-10-06 | Aguas Buenas | Puerto Rico | 72007 | 306 | |
601543 | 601543 | 2020-10-05 | Aguas Buenas | Puerto Rico | 72007 | 303 | |
598300 | 598300 | 2020-10-04 | Aguas Buenas | Puerto Rico | 72007 | 302 | |
595057 | 595057 | 2020-10-03 | Aguas Buenas | Puerto Rico | 72007 | 301 | |
591816 | 591816 | 2020-10-02 | Aguas Buenas | Puerto Rico | 72007 | 299 | |
588575 | 588575 | 2020-10-01 | Aguas Buenas | Puerto Rico | 72007 | 295 | |
585335 | 585335 | 2020-09-30 | Aguas Buenas | Puerto Rico | 72007 | 287 | |
582095 | 582095 | 2020-09-29 | Aguas Buenas | Puerto Rico | 72007 | 282 | |
578855 | 578855 | 2020-09-28 | Aguas Buenas | Puerto Rico | 72007 | 270 | |
575614 | 575614 | 2020-09-27 | Aguas Buenas | Puerto Rico | 72007 | 269 | |
572370 | 572370 | 2020-09-26 | Aguas Buenas | Puerto Rico | 72007 | 265 | |
569128 | 569128 | 2020-09-25 | Aguas Buenas | Puerto Rico | 72007 | 265 | |
565887 | 565887 | 2020-09-24 | Aguas Buenas | Puerto Rico | 72007 | 258 | |
562646 | 562646 | 2020-09-23 | Aguas Buenas | Puerto Rico | 72007 | 254 | |
559409 | 559409 | 2020-09-22 | Aguas Buenas | Puerto Rico | 72007 | 253 | |
556172 | 556172 | 2020-09-21 | Aguas Buenas | Puerto Rico | 72007 | 252 | |
552935 | 552935 | 2020-09-20 | Aguas Buenas | Puerto Rico | 72007 | 249 | |
549696 | 549696 | 2020-09-19 | Aguas Buenas | Puerto Rico | 72007 | 245 | |
546457 | 546457 | 2020-09-18 | Aguas Buenas | Puerto Rico | 72007 | 238 | |
543220 | 543220 | 2020-09-17 | Aguas Buenas | Puerto Rico | 72007 | 232 | |
539984 | 539984 | 2020-09-16 | Aguas Buenas | Puerto Rico | 72007 | 230 | |
536747 | 536747 | 2020-09-15 | Aguas Buenas | Puerto Rico | 72007 | 228 | |
533511 | 533511 | 2020-09-14 | Aguas Buenas | Puerto Rico | 72007 | 227 | |
530276 | 530276 | 2020-09-13 | Aguas Buenas | Puerto Rico | 72007 | 224 | |
527039 | 527039 | 2020-09-12 | Aguas Buenas | Puerto Rico | 72007 | 221 | |
523803 | 523803 | 2020-09-11 | Aguas Buenas | Puerto Rico | 72007 | 221 | |
520567 | 520567 | 2020-09-10 | Aguas Buenas | Puerto Rico | 72007 | 218 | |
517331 | 517331 | 2020-09-09 | Aguas Buenas | Puerto Rico | 72007 | 211 | |
514096 | 514096 | 2020-09-08 | Aguas Buenas | Puerto Rico | 72007 | 211 | |
510863 | 510863 | 2020-09-07 | Aguas Buenas | Puerto Rico | 72007 | 210 | |
507630 | 507630 | 2020-09-06 | Aguas Buenas | Puerto Rico | 72007 | 205 | |
504398 | 504398 | 2020-09-05 | Aguas Buenas | Puerto Rico | 72007 | 205 | |
501164 | 501164 | 2020-09-04 | Aguas Buenas | Puerto Rico | 72007 | 204 | |
497930 | 497930 | 2020-09-03 | Aguas Buenas | Puerto Rico | 72007 | 204 | |
494697 | 494697 | 2020-09-02 | Aguas Buenas | Puerto Rico | 72007 | 204 | |
491463 | 491463 | 2020-09-01 | Aguas Buenas | Puerto Rico | 72007 | 202 | |
488230 | 488230 | 2020-08-31 | Aguas Buenas | Puerto Rico | 72007 | 200 | |
484997 | 484997 | 2020-08-30 | Aguas Buenas | Puerto Rico | 72007 | 197 | |
481762 | 481762 | 2020-08-29 | Aguas Buenas | Puerto Rico | 72007 | 193 | |
478528 | 478528 | 2020-08-28 | Aguas Buenas | Puerto Rico | 72007 | 190 | |
475295 | 475295 | 2020-08-27 | Aguas Buenas | Puerto Rico | 72007 | 188 | |
472061 | 472061 | 2020-08-26 | Aguas Buenas | Puerto Rico | 72007 | 184 | |
468829 | 468829 | 2020-08-25 | Aguas Buenas | Puerto Rico | 72007 | 184 | |
465601 | 465601 | 2020-08-24 | Aguas Buenas | Puerto Rico | 72007 | 184 | |
462372 | 462372 | 2020-08-23 | Aguas Buenas | Puerto Rico | 72007 | 182 | |
459144 | 459144 | 2020-08-22 | Aguas Buenas | Puerto Rico | 72007 | 176 | |
455916 | 455916 | 2020-08-21 | Aguas Buenas | Puerto Rico | 72007 | 171 | |
452688 | 452688 | 2020-08-20 | Aguas Buenas | Puerto Rico | 72007 | 168 | |
449460 | 449460 | 2020-08-19 | Aguas Buenas | Puerto Rico | 72007 | 165 | |
446232 | 446232 | 2020-08-18 | Aguas Buenas | Puerto Rico | 72007 | 160 | |
443006 | 443006 | 2020-08-17 | Aguas Buenas | Puerto Rico | 72007 | 155 | |
439779 | 439779 | 2020-08-16 | Aguas Buenas | Puerto Rico | 72007 | 153 | |
436554 | 436554 | 2020-08-15 | Aguas Buenas | Puerto Rico | 72007 | 149 | |
433327 | 433327 | 2020-08-14 | Aguas Buenas | Puerto Rico | 72007 | 145 | |
430101 | 430101 | 2020-08-13 | Aguas Buenas | Puerto Rico | 72007 | 139 | |
426876 | 426876 | 2020-08-12 | Aguas Buenas | Puerto Rico | 72007 | 138 | |
423653 | 423653 | 2020-08-11 | Aguas Buenas | Puerto Rico | 72007 | 137 | |
420430 | 420430 | 2020-08-10 | Aguas Buenas | Puerto Rico | 72007 | 133 | |
417210 | 417210 | 2020-08-09 | Aguas Buenas | Puerto Rico | 72007 | 129 | |
413989 | 413989 | 2020-08-08 | Aguas Buenas | Puerto Rico | 72007 | 126 | |
410769 | 410769 | 2020-08-07 | Aguas Buenas | Puerto Rico | 72007 | 123 | |
407549 | 407549 | 2020-08-06 | Aguas Buenas | Puerto Rico | 72007 | 118 | |
404330 | 404330 | 2020-08-05 | Aguas Buenas | Puerto Rico | 72007 | 117 | |
401112 | 401112 | 2020-08-04 | Aguas Buenas | Puerto Rico | 72007 | 115 | |
397897 | 397897 | 2020-08-03 | Aguas Buenas | Puerto Rico | 72007 | 114 | |
394680 | 394680 | 2020-08-02 | Aguas Buenas | Puerto Rico | 72007 | 111 | |
391464 | 391464 | 2020-08-01 | Aguas Buenas | Puerto Rico | 72007 | 107 | |
388247 | 388247 | 2020-07-31 | Aguas Buenas | Puerto Rico | 72007 | 102 | |
385030 | 385030 | 2020-07-30 | Aguas Buenas | Puerto Rico | 72007 | 102 | |
381812 | 381812 | 2020-07-29 | Aguas Buenas | Puerto Rico | 72007 | 99 | |
378595 | 378595 | 2020-07-28 | Aguas Buenas | Puerto Rico | 72007 | 97 | |
375379 | 375379 | 2020-07-27 | Aguas Buenas | Puerto Rico | 72007 | 94 | |
372166 | 372166 | 2020-07-26 | Aguas Buenas | Puerto Rico | 72007 | 94 | |
368954 | 368954 | 2020-07-25 | Aguas Buenas | Puerto Rico | 72007 | 91 | |
365745 | 365745 | 2020-07-24 | Aguas Buenas | Puerto Rico | 72007 | 87 | |
362539 | 362539 | 2020-07-23 | Aguas Buenas | Puerto Rico | 72007 | 85 | |
359333 | 359333 | 2020-07-22 | Aguas Buenas | Puerto Rico | 72007 | 83 | |
356129 | 356129 | 2020-07-21 | Aguas Buenas | Puerto Rico | 72007 | 82 | |
352926 | 352926 | 2020-07-20 | Aguas Buenas | Puerto Rico | 72007 | 81 | |
349723 | 349723 | 2020-07-19 | Aguas Buenas | Puerto Rico | 72007 | 80 | |
346523 | 346523 | 2020-07-18 | Aguas Buenas | Puerto Rico | 72007 | 77 | |
343323 | 343323 | 2020-07-17 | Aguas Buenas | Puerto Rico | 72007 | 73 | |
340125 | 340125 | 2020-07-16 | Aguas Buenas | Puerto Rico | 72007 | 72 | |
336928 | 336928 | 2020-07-15 | Aguas Buenas | Puerto Rico | 72007 | 72 | |
333734 | 333734 | 2020-07-14 | Aguas Buenas | Puerto Rico | 72007 | 69 | |
330542 | 330542 | 2020-07-13 | Aguas Buenas | Puerto Rico | 72007 | 69 | |
327356 | 327356 | 2020-07-12 | Aguas Buenas | Puerto Rico | 72007 | 68 | |
324171 | 324171 | 2020-07-11 | Aguas Buenas | Puerto Rico | 72007 | 66 | |
320991 | 320991 | 2020-07-10 | Aguas Buenas | Puerto Rico | 72007 | 64 | |
317813 | 317813 | 2020-07-09 | Aguas Buenas | Puerto Rico | 72007 | 63 |
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);