ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72023 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 |
---|---|---|---|---|---|---|---|
922777 | 922777 | 2021-01-12 | Cabo Rojo | Puerto Rico | 72023 | 795 | |
919532 | 919532 | 2021-01-11 | Cabo Rojo | Puerto Rico | 72023 | 795 | |
916287 | 916287 | 2021-01-10 | Cabo Rojo | Puerto Rico | 72023 | 794 | |
913042 | 913042 | 2021-01-09 | Cabo Rojo | Puerto Rico | 72023 | 790 | |
909797 | 909797 | 2021-01-08 | Cabo Rojo | Puerto Rico | 72023 | 786 | |
906552 | 906552 | 2021-01-07 | Cabo Rojo | Puerto Rico | 72023 | 773 | |
903306 | 903306 | 2021-01-06 | Cabo Rojo | Puerto Rico | 72023 | 770 | |
900061 | 900061 | 2021-01-05 | Cabo Rojo | Puerto Rico | 72023 | 767 | |
896816 | 896816 | 2021-01-04 | Cabo Rojo | Puerto Rico | 72023 | 767 | |
893570 | 893570 | 2021-01-03 | Cabo Rojo | Puerto Rico | 72023 | 762 | |
890324 | 890324 | 2021-01-02 | Cabo Rojo | Puerto Rico | 72023 | 761 | |
887077 | 887077 | 2021-01-01 | Cabo Rojo | Puerto Rico | 72023 | 759 | |
883832 | 883832 | 2020-12-31 | Cabo Rojo | Puerto Rico | 72023 | 757 | |
880587 | 880587 | 2020-12-30 | Cabo Rojo | Puerto Rico | 72023 | 757 | |
877342 | 877342 | 2020-12-29 | Cabo Rojo | Puerto Rico | 72023 | 757 | |
874097 | 874097 | 2020-12-28 | Cabo Rojo | Puerto Rico | 72023 | 750 | |
870852 | 870852 | 2020-12-27 | Cabo Rojo | Puerto Rico | 72023 | 750 | |
867607 | 867607 | 2020-12-26 | Cabo Rojo | Puerto Rico | 72023 | 742 | |
864362 | 864362 | 2020-12-25 | Cabo Rojo | Puerto Rico | 72023 | 740 | |
861117 | 861117 | 2020-12-24 | Cabo Rojo | Puerto Rico | 72023 | 738 | |
857872 | 857872 | 2020-12-23 | Cabo Rojo | Puerto Rico | 72023 | 734 | |
854627 | 854627 | 2020-12-22 | Cabo Rojo | Puerto Rico | 72023 | 733 | |
851382 | 851382 | 2020-12-21 | Cabo Rojo | Puerto Rico | 72023 | 729 | |
848137 | 848137 | 2020-12-20 | Cabo Rojo | Puerto Rico | 72023 | 728 | |
844892 | 844892 | 2020-12-19 | Cabo Rojo | Puerto Rico | 72023 | 722 | |
841646 | 841646 | 2020-12-18 | Cabo Rojo | Puerto Rico | 72023 | 720 | |
838401 | 838401 | 2020-12-17 | Cabo Rojo | Puerto Rico | 72023 | 715 | |
835155 | 835155 | 2020-12-16 | Cabo Rojo | Puerto Rico | 72023 | 704 | |
831909 | 831909 | 2020-12-15 | Cabo Rojo | Puerto Rico | 72023 | 704 | |
828662 | 828662 | 2020-12-14 | Cabo Rojo | Puerto Rico | 72023 | 702 | |
825416 | 825416 | 2020-12-13 | Cabo Rojo | Puerto Rico | 72023 | 696 | |
822169 | 822169 | 2020-12-12 | Cabo Rojo | Puerto Rico | 72023 | 693 | |
818923 | 818923 | 2020-12-11 | Cabo Rojo | Puerto Rico | 72023 | 688 | |
815677 | 815677 | 2020-12-10 | Cabo Rojo | Puerto Rico | 72023 | 683 | |
812431 | 812431 | 2020-12-09 | Cabo Rojo | Puerto Rico | 72023 | 676 | |
809187 | 809187 | 2020-12-08 | Cabo Rojo | Puerto Rico | 72023 | 672 | |
805942 | 805942 | 2020-12-07 | Cabo Rojo | Puerto Rico | 72023 | 669 | |
802697 | 802697 | 2020-12-06 | Cabo Rojo | Puerto Rico | 72023 | 667 | |
799452 | 799452 | 2020-12-05 | Cabo Rojo | Puerto Rico | 72023 | 657 | |
796207 | 796207 | 2020-12-04 | Cabo Rojo | Puerto Rico | 72023 | 648 | |
792962 | 792962 | 2020-12-03 | Cabo Rojo | Puerto Rico | 72023 | 644 | |
789717 | 789717 | 2020-12-02 | Cabo Rojo | Puerto Rico | 72023 | 644 | |
786472 | 786472 | 2020-12-01 | Cabo Rojo | Puerto Rico | 72023 | 640 | |
783228 | 783228 | 2020-11-30 | Cabo Rojo | Puerto Rico | 72023 | 636 | |
779983 | 779983 | 2020-11-29 | Cabo Rojo | Puerto Rico | 72023 | 630 | |
776737 | 776737 | 2020-11-28 | Cabo Rojo | Puerto Rico | 72023 | 631 | |
773492 | 773492 | 2020-11-27 | Cabo Rojo | Puerto Rico | 72023 | 622 | |
770247 | 770247 | 2020-11-26 | Cabo Rojo | Puerto Rico | 72023 | 615 | |
767001 | 767001 | 2020-11-25 | Cabo Rojo | Puerto Rico | 72023 | 614 | |
763756 | 763756 | 2020-11-24 | Cabo Rojo | Puerto Rico | 72023 | 614 | |
760511 | 760511 | 2020-11-23 | Cabo Rojo | Puerto Rico | 72023 | 614 | |
757266 | 757266 | 2020-11-22 | Cabo Rojo | Puerto Rico | 72023 | 609 | |
754019 | 754019 | 2020-11-21 | Cabo Rojo | Puerto Rico | 72023 | 605 | |
750773 | 750773 | 2020-11-20 | Cabo Rojo | Puerto Rico | 72023 | 601 | |
747527 | 747527 | 2020-11-19 | Cabo Rojo | Puerto Rico | 72023 | 599 | |
744281 | 744281 | 2020-11-18 | Cabo Rojo | Puerto Rico | 72023 | 598 | |
741034 | 741034 | 2020-11-17 | Cabo Rojo | Puerto Rico | 72023 | 598 | |
737788 | 737788 | 2020-11-16 | Cabo Rojo | Puerto Rico | 72023 | 595 | |
734544 | 734544 | 2020-11-15 | Cabo Rojo | Puerto Rico | 72023 | 593 | |
731298 | 731298 | 2020-11-14 | Cabo Rojo | Puerto Rico | 72023 | 591 | |
728054 | 728054 | 2020-11-13 | Cabo Rojo | Puerto Rico | 72023 | 586 | |
724810 | 724810 | 2020-11-12 | Cabo Rojo | Puerto Rico | 72023 | 583 | |
721567 | 721567 | 2020-11-11 | Cabo Rojo | Puerto Rico | 72023 | 579 | |
718324 | 718324 | 2020-11-10 | Cabo Rojo | Puerto Rico | 72023 | 573 | |
715081 | 715081 | 2020-11-09 | Cabo Rojo | Puerto Rico | 72023 | 572 | |
711837 | 711837 | 2020-11-08 | Cabo Rojo | Puerto Rico | 72023 | 571 | |
708593 | 708593 | 2020-11-07 | Cabo Rojo | Puerto Rico | 72023 | 561 | |
705350 | 705350 | 2020-11-06 | Cabo Rojo | Puerto Rico | 72023 | 561 | |
702107 | 702107 | 2020-11-05 | Cabo Rojo | Puerto Rico | 72023 | 558 | |
698863 | 698863 | 2020-11-04 | Cabo Rojo | Puerto Rico | 72023 | 557 | |
695620 | 695620 | 2020-11-03 | Cabo Rojo | Puerto Rico | 72023 | 557 | |
692378 | 692378 | 2020-11-02 | Cabo Rojo | Puerto Rico | 72023 | 545 | |
689134 | 689134 | 2020-11-01 | Cabo Rojo | Puerto Rico | 72023 | 540 | |
685889 | 685889 | 2020-10-31 | Cabo Rojo | Puerto Rico | 72023 | 529 | |
682646 | 682646 | 2020-10-30 | Cabo Rojo | Puerto Rico | 72023 | 527 | |
679403 | 679403 | 2020-10-29 | Cabo Rojo | Puerto Rico | 72023 | 522 | |
676160 | 676160 | 2020-10-28 | Cabo Rojo | Puerto Rico | 72023 | 513 | |
672917 | 672917 | 2020-10-27 | Cabo Rojo | Puerto Rico | 72023 | 512 | |
669675 | 669675 | 2020-10-26 | Cabo Rojo | Puerto Rico | 72023 | 504 | |
666431 | 666431 | 2020-10-25 | Cabo Rojo | Puerto Rico | 72023 | 501 | |
663186 | 663186 | 2020-10-24 | Cabo Rojo | Puerto Rico | 72023 | 492 | |
659942 | 659942 | 2020-10-23 | Cabo Rojo | Puerto Rico | 72023 | 490 | |
656698 | 656698 | 2020-10-22 | Cabo Rojo | Puerto Rico | 72023 | 486 | |
653453 | 653453 | 2020-10-21 | Cabo Rojo | Puerto Rico | 72023 | 485 | |
650208 | 650208 | 2020-10-20 | Cabo Rojo | Puerto Rico | 72023 | 485 | |
646964 | 646964 | 2020-10-19 | Cabo Rojo | Puerto Rico | 72023 | 484 | |
643718 | 643718 | 2020-10-18 | Cabo Rojo | Puerto Rico | 72023 | 473 | |
640470 | 640470 | 2020-10-17 | Cabo Rojo | Puerto Rico | 72023 | 463 | |
637224 | 637224 | 2020-10-16 | Cabo Rojo | Puerto Rico | 72023 | 462 | |
633978 | 633978 | 2020-10-15 | Cabo Rojo | Puerto Rico | 72023 | 461 | |
630733 | 630733 | 2020-10-14 | Cabo Rojo | Puerto Rico | 72023 | 456 | |
627489 | 627489 | 2020-10-13 | Cabo Rojo | Puerto Rico | 72023 | 446 | |
624247 | 624247 | 2020-10-12 | Cabo Rojo | Puerto Rico | 72023 | 422 | |
621004 | 621004 | 2020-10-11 | Cabo Rojo | Puerto Rico | 72023 | 390 | |
617761 | 617761 | 2020-10-10 | Cabo Rojo | Puerto Rico | 72023 | 389 | |
614519 | 614519 | 2020-10-09 | Cabo Rojo | Puerto Rico | 72023 | 372 | |
611278 | 611278 | 2020-10-08 | Cabo Rojo | Puerto Rico | 72023 | 368 | |
608036 | 608036 | 2020-10-07 | Cabo Rojo | Puerto Rico | 72023 | 362 | |
604793 | 604793 | 2020-10-06 | Cabo Rojo | Puerto Rico | 72023 | 362 | |
601551 | 601551 | 2020-10-05 | Cabo Rojo | Puerto Rico | 72023 | 360 |
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);