ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72019 and state = "Puerto Rico" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
430107 | 430107 | 2020-08-13 | Barranquitas | Puerto Rico | 72019 | 267 | |
433333 | 433333 | 2020-08-14 | Barranquitas | Puerto Rico | 72019 | 269 | |
436560 | 436560 | 2020-08-15 | Barranquitas | Puerto Rico | 72019 | 273 | |
439785 | 439785 | 2020-08-16 | Barranquitas | Puerto Rico | 72019 | 275 | |
443012 | 443012 | 2020-08-17 | Barranquitas | Puerto Rico | 72019 | 280 | |
446238 | 446238 | 2020-08-18 | Barranquitas | Puerto Rico | 72019 | 288 | |
449466 | 449466 | 2020-08-19 | Barranquitas | Puerto Rico | 72019 | 288 | |
452694 | 452694 | 2020-08-20 | Barranquitas | Puerto Rico | 72019 | 289 | |
455922 | 455922 | 2020-08-21 | Barranquitas | Puerto Rico | 72019 | 297 | |
459150 | 459150 | 2020-08-22 | Barranquitas | Puerto Rico | 72019 | 301 | |
462378 | 462378 | 2020-08-23 | Barranquitas | Puerto Rico | 72019 | 303 | |
465607 | 465607 | 2020-08-24 | Barranquitas | Puerto Rico | 72019 | 313 | |
468835 | 468835 | 2020-08-25 | Barranquitas | Puerto Rico | 72019 | 314 | |
472067 | 472067 | 2020-08-26 | Barranquitas | Puerto Rico | 72019 | 316 | |
475301 | 475301 | 2020-08-27 | Barranquitas | Puerto Rico | 72019 | 323 | |
478534 | 478534 | 2020-08-28 | Barranquitas | Puerto Rico | 72019 | 326 | |
481768 | 481768 | 2020-08-29 | Barranquitas | Puerto Rico | 72019 | 329 | |
485003 | 485003 | 2020-08-30 | Barranquitas | Puerto Rico | 72019 | 331 | |
488236 | 488236 | 2020-08-31 | Barranquitas | Puerto Rico | 72019 | 332 | |
491469 | 491469 | 2020-09-01 | Barranquitas | Puerto Rico | 72019 | 333 | |
494703 | 494703 | 2020-09-02 | Barranquitas | Puerto Rico | 72019 | 347 | |
497936 | 497936 | 2020-09-03 | Barranquitas | Puerto Rico | 72019 | 347 | |
501170 | 501170 | 2020-09-04 | Barranquitas | Puerto Rico | 72019 | 347 | |
504404 | 504404 | 2020-09-05 | Barranquitas | Puerto Rico | 72019 | 350 | |
507636 | 507636 | 2020-09-06 | Barranquitas | Puerto Rico | 72019 | 350 | |
510869 | 510869 | 2020-09-07 | Barranquitas | Puerto Rico | 72019 | 361 | |
514102 | 514102 | 2020-09-08 | Barranquitas | Puerto Rico | 72019 | 361 | |
517337 | 517337 | 2020-09-09 | Barranquitas | Puerto Rico | 72019 | 361 | |
520573 | 520573 | 2020-09-10 | Barranquitas | Puerto Rico | 72019 | 370 | |
523809 | 523809 | 2020-09-11 | Barranquitas | Puerto Rico | 72019 | 370 | |
527045 | 527045 | 2020-09-12 | Barranquitas | Puerto Rico | 72019 | 372 | |
530282 | 530282 | 2020-09-13 | Barranquitas | Puerto Rico | 72019 | 372 | |
533517 | 533517 | 2020-09-14 | Barranquitas | Puerto Rico | 72019 | 373 | |
536753 | 536753 | 2020-09-15 | Barranquitas | Puerto Rico | 72019 | 377 | |
539990 | 539990 | 2020-09-16 | Barranquitas | Puerto Rico | 72019 | 378 | |
543226 | 543226 | 2020-09-17 | Barranquitas | Puerto Rico | 72019 | 388 | |
546463 | 546463 | 2020-09-18 | Barranquitas | Puerto Rico | 72019 | 393 | |
549702 | 549702 | 2020-09-19 | Barranquitas | Puerto Rico | 72019 | 406 | |
552941 | 552941 | 2020-09-20 | Barranquitas | Puerto Rico | 72019 | 412 | |
556178 | 556178 | 2020-09-21 | Barranquitas | Puerto Rico | 72019 | 414 | |
559415 | 559415 | 2020-09-22 | Barranquitas | Puerto Rico | 72019 | 414 | |
562652 | 562652 | 2020-09-23 | Barranquitas | Puerto Rico | 72019 | 414 | |
565893 | 565893 | 2020-09-24 | Barranquitas | Puerto Rico | 72019 | 420 | |
569134 | 569134 | 2020-09-25 | Barranquitas | Puerto Rico | 72019 | 436 | |
572376 | 572376 | 2020-09-26 | Barranquitas | Puerto Rico | 72019 | 437 | |
575620 | 575620 | 2020-09-27 | Barranquitas | Puerto Rico | 72019 | 446 | |
578861 | 578861 | 2020-09-28 | Barranquitas | Puerto Rico | 72019 | 456 | |
582101 | 582101 | 2020-09-29 | Barranquitas | Puerto Rico | 72019 | 476 | |
585341 | 585341 | 2020-09-30 | Barranquitas | Puerto Rico | 72019 | 488 | |
588581 | 588581 | 2020-10-01 | Barranquitas | Puerto Rico | 72019 | 489 | |
591822 | 591822 | 2020-10-02 | Barranquitas | Puerto Rico | 72019 | 497 | |
595063 | 595063 | 2020-10-03 | Barranquitas | Puerto Rico | 72019 | 499 | |
598306 | 598306 | 2020-10-04 | Barranquitas | Puerto Rico | 72019 | 499 | |
601549 | 601549 | 2020-10-05 | Barranquitas | Puerto Rico | 72019 | 502 | |
604791 | 604791 | 2020-10-06 | Barranquitas | Puerto Rico | 72019 | 504 | |
608034 | 608034 | 2020-10-07 | Barranquitas | Puerto Rico | 72019 | 504 | |
611276 | 611276 | 2020-10-08 | Barranquitas | Puerto Rico | 72019 | 507 | |
614517 | 614517 | 2020-10-09 | Barranquitas | Puerto Rico | 72019 | 510 | |
617759 | 617759 | 2020-10-10 | Barranquitas | Puerto Rico | 72019 | 514 | |
621002 | 621002 | 2020-10-11 | Barranquitas | Puerto Rico | 72019 | 515 | |
624245 | 624245 | 2020-10-12 | Barranquitas | Puerto Rico | 72019 | 518 | |
627487 | 627487 | 2020-10-13 | Barranquitas | Puerto Rico | 72019 | 518 | |
630731 | 630731 | 2020-10-14 | Barranquitas | Puerto Rico | 72019 | 532 | |
633976 | 633976 | 2020-10-15 | Barranquitas | Puerto Rico | 72019 | 537 | |
637222 | 637222 | 2020-10-16 | Barranquitas | Puerto Rico | 72019 | 537 | |
640468 | 640468 | 2020-10-17 | Barranquitas | Puerto Rico | 72019 | 537 | |
643716 | 643716 | 2020-10-18 | Barranquitas | Puerto Rico | 72019 | 543 | |
646962 | 646962 | 2020-10-19 | Barranquitas | Puerto Rico | 72019 | 547 | |
650206 | 650206 | 2020-10-20 | Barranquitas | Puerto Rico | 72019 | 548 | |
653451 | 653451 | 2020-10-21 | Barranquitas | Puerto Rico | 72019 | 548 | |
656696 | 656696 | 2020-10-22 | Barranquitas | Puerto Rico | 72019 | 546 | |
659940 | 659940 | 2020-10-23 | Barranquitas | Puerto Rico | 72019 | 581 | |
663184 | 663184 | 2020-10-24 | Barranquitas | Puerto Rico | 72019 | 583 | |
666429 | 666429 | 2020-10-25 | Barranquitas | Puerto Rico | 72019 | 602 | |
669673 | 669673 | 2020-10-26 | Barranquitas | Puerto Rico | 72019 | 604 | |
672915 | 672915 | 2020-10-27 | Barranquitas | Puerto Rico | 72019 | 605 | |
676158 | 676158 | 2020-10-28 | Barranquitas | Puerto Rico | 72019 | 606 | |
679401 | 679401 | 2020-10-29 | Barranquitas | Puerto Rico | 72019 | 624 | |
682644 | 682644 | 2020-10-30 | Barranquitas | Puerto Rico | 72019 | 634 | |
685887 | 685887 | 2020-10-31 | Barranquitas | Puerto Rico | 72019 | 635 | |
689132 | 689132 | 2020-11-01 | Barranquitas | Puerto Rico | 72019 | 640 | |
692376 | 692376 | 2020-11-02 | Barranquitas | Puerto Rico | 72019 | 651 | |
695618 | 695618 | 2020-11-03 | Barranquitas | Puerto Rico | 72019 | 653 | |
698861 | 698861 | 2020-11-04 | Barranquitas | Puerto Rico | 72019 | 654 | |
702105 | 702105 | 2020-11-05 | Barranquitas | Puerto Rico | 72019 | 657 | |
705348 | 705348 | 2020-11-06 | Barranquitas | Puerto Rico | 72019 | 676 | |
708591 | 708591 | 2020-11-07 | Barranquitas | Puerto Rico | 72019 | 676 | |
711835 | 711835 | 2020-11-08 | Barranquitas | Puerto Rico | 72019 | 681 | |
715079 | 715079 | 2020-11-09 | Barranquitas | Puerto Rico | 72019 | 686 | |
718322 | 718322 | 2020-11-10 | Barranquitas | Puerto Rico | 72019 | 688 | |
721565 | 721565 | 2020-11-11 | Barranquitas | Puerto Rico | 72019 | 691 | |
724808 | 724808 | 2020-11-12 | Barranquitas | Puerto Rico | 72019 | 710 | |
728052 | 728052 | 2020-11-13 | Barranquitas | Puerto Rico | 72019 | 715 | |
731296 | 731296 | 2020-11-14 | Barranquitas | Puerto Rico | 72019 | 723 | |
734542 | 734542 | 2020-11-15 | Barranquitas | Puerto Rico | 72019 | 731 | |
737786 | 737786 | 2020-11-16 | Barranquitas | Puerto Rico | 72019 | 740 | |
741032 | 741032 | 2020-11-17 | Barranquitas | Puerto Rico | 72019 | 748 | |
744279 | 744279 | 2020-11-18 | Barranquitas | Puerto Rico | 72019 | 749 | |
747525 | 747525 | 2020-11-19 | Barranquitas | Puerto Rico | 72019 | 757 | |
750771 | 750771 | 2020-11-20 | Barranquitas | Puerto Rico | 72019 | 764 |
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);