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 date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922775 | 922775 | 2021-01-12 | Barranquitas | Puerto Rico | 72019 | 1065 | |
919530 | 919530 | 2021-01-11 | Barranquitas | Puerto Rico | 72019 | 1051 | |
916285 | 916285 | 2021-01-10 | Barranquitas | Puerto Rico | 72019 | 1051 | |
913040 | 913040 | 2021-01-09 | Barranquitas | Puerto Rico | 72019 | 1047 | |
909795 | 909795 | 2021-01-08 | Barranquitas | Puerto Rico | 72019 | 1043 | |
906550 | 906550 | 2021-01-07 | Barranquitas | Puerto Rico | 72019 | 1021 | |
903304 | 903304 | 2021-01-06 | Barranquitas | Puerto Rico | 72019 | 1020 | |
900059 | 900059 | 2021-01-05 | Barranquitas | Puerto Rico | 72019 | 1017 | |
896814 | 896814 | 2021-01-04 | Barranquitas | Puerto Rico | 72019 | 1017 | |
893568 | 893568 | 2021-01-03 | Barranquitas | Puerto Rico | 72019 | 1008 | |
890322 | 890322 | 2021-01-02 | Barranquitas | Puerto Rico | 72019 | 1007 | |
887075 | 887075 | 2021-01-01 | Barranquitas | Puerto Rico | 72019 | 1001 | |
883830 | 883830 | 2020-12-31 | Barranquitas | Puerto Rico | 72019 | 993 | |
880585 | 880585 | 2020-12-30 | Barranquitas | Puerto Rico | 72019 | 992 | |
877340 | 877340 | 2020-12-29 | Barranquitas | Puerto Rico | 72019 | 992 | |
874095 | 874095 | 2020-12-28 | Barranquitas | Puerto Rico | 72019 | 974 | |
870850 | 870850 | 2020-12-27 | Barranquitas | Puerto Rico | 72019 | 974 | |
867605 | 867605 | 2020-12-26 | Barranquitas | Puerto Rico | 72019 | 968 | |
864360 | 864360 | 2020-12-25 | Barranquitas | Puerto Rico | 72019 | 966 | |
861115 | 861115 | 2020-12-24 | Barranquitas | Puerto Rico | 72019 | 964 | |
857870 | 857870 | 2020-12-23 | Barranquitas | Puerto Rico | 72019 | 962 | |
854625 | 854625 | 2020-12-22 | Barranquitas | Puerto Rico | 72019 | 957 | |
851380 | 851380 | 2020-12-21 | Barranquitas | Puerto Rico | 72019 | 953 | |
848135 | 848135 | 2020-12-20 | Barranquitas | Puerto Rico | 72019 | 952 | |
844890 | 844890 | 2020-12-19 | Barranquitas | Puerto Rico | 72019 | 950 | |
841644 | 841644 | 2020-12-18 | Barranquitas | Puerto Rico | 72019 | 938 | |
838399 | 838399 | 2020-12-17 | Barranquitas | Puerto Rico | 72019 | 924 | |
835153 | 835153 | 2020-12-16 | Barranquitas | Puerto Rico | 72019 | 921 | |
831907 | 831907 | 2020-12-15 | Barranquitas | Puerto Rico | 72019 | 921 | |
828660 | 828660 | 2020-12-14 | Barranquitas | Puerto Rico | 72019 | 919 | |
825414 | 825414 | 2020-12-13 | Barranquitas | Puerto Rico | 72019 | 919 | |
822167 | 822167 | 2020-12-12 | Barranquitas | Puerto Rico | 72019 | 917 | |
818921 | 818921 | 2020-12-11 | Barranquitas | Puerto Rico | 72019 | 915 | |
815675 | 815675 | 2020-12-10 | Barranquitas | Puerto Rico | 72019 | 897 | |
812429 | 812429 | 2020-12-09 | Barranquitas | Puerto Rico | 72019 | 895 | |
809185 | 809185 | 2020-12-08 | Barranquitas | Puerto Rico | 72019 | 893 | |
805940 | 805940 | 2020-12-07 | Barranquitas | Puerto Rico | 72019 | 882 | |
802695 | 802695 | 2020-12-06 | Barranquitas | Puerto Rico | 72019 | 874 | |
799450 | 799450 | 2020-12-05 | Barranquitas | Puerto Rico | 72019 | 863 | |
796205 | 796205 | 2020-12-04 | Barranquitas | Puerto Rico | 72019 | 852 | |
792960 | 792960 | 2020-12-03 | Barranquitas | Puerto Rico | 72019 | 851 | |
789715 | 789715 | 2020-12-02 | Barranquitas | Puerto Rico | 72019 | 851 | |
786470 | 786470 | 2020-12-01 | Barranquitas | Puerto Rico | 72019 | 851 | |
783226 | 783226 | 2020-11-30 | Barranquitas | Puerto Rico | 72019 | 843 | |
779981 | 779981 | 2020-11-29 | Barranquitas | Puerto Rico | 72019 | 834 | |
776735 | 776735 | 2020-11-28 | Barranquitas | Puerto Rico | 72019 | 834 | |
773490 | 773490 | 2020-11-27 | Barranquitas | Puerto Rico | 72019 | 824 | |
770245 | 770245 | 2020-11-26 | Barranquitas | Puerto Rico | 72019 | 798 | |
766999 | 766999 | 2020-11-25 | Barranquitas | Puerto Rico | 72019 | 794 | |
763754 | 763754 | 2020-11-24 | Barranquitas | Puerto Rico | 72019 | 794 | |
760509 | 760509 | 2020-11-23 | Barranquitas | Puerto Rico | 72019 | 792 | |
757264 | 757264 | 2020-11-22 | Barranquitas | Puerto Rico | 72019 | 785 | |
754017 | 754017 | 2020-11-21 | Barranquitas | Puerto Rico | 72019 | 775 | |
750771 | 750771 | 2020-11-20 | Barranquitas | Puerto Rico | 72019 | 764 | |
747525 | 747525 | 2020-11-19 | Barranquitas | Puerto Rico | 72019 | 757 | |
744279 | 744279 | 2020-11-18 | Barranquitas | Puerto Rico | 72019 | 749 | |
741032 | 741032 | 2020-11-17 | Barranquitas | Puerto Rico | 72019 | 748 | |
737786 | 737786 | 2020-11-16 | Barranquitas | Puerto Rico | 72019 | 740 | |
734542 | 734542 | 2020-11-15 | Barranquitas | Puerto Rico | 72019 | 731 | |
731296 | 731296 | 2020-11-14 | Barranquitas | Puerto Rico | 72019 | 723 | |
728052 | 728052 | 2020-11-13 | Barranquitas | Puerto Rico | 72019 | 715 | |
724808 | 724808 | 2020-11-12 | Barranquitas | Puerto Rico | 72019 | 710 | |
721565 | 721565 | 2020-11-11 | Barranquitas | Puerto Rico | 72019 | 691 | |
718322 | 718322 | 2020-11-10 | Barranquitas | Puerto Rico | 72019 | 688 | |
715079 | 715079 | 2020-11-09 | Barranquitas | Puerto Rico | 72019 | 686 | |
711835 | 711835 | 2020-11-08 | Barranquitas | Puerto Rico | 72019 | 681 | |
708591 | 708591 | 2020-11-07 | Barranquitas | Puerto Rico | 72019 | 676 | |
705348 | 705348 | 2020-11-06 | Barranquitas | Puerto Rico | 72019 | 676 | |
702105 | 702105 | 2020-11-05 | Barranquitas | Puerto Rico | 72019 | 657 | |
698861 | 698861 | 2020-11-04 | Barranquitas | Puerto Rico | 72019 | 654 | |
695618 | 695618 | 2020-11-03 | Barranquitas | Puerto Rico | 72019 | 653 | |
692376 | 692376 | 2020-11-02 | Barranquitas | Puerto Rico | 72019 | 651 | |
689132 | 689132 | 2020-11-01 | Barranquitas | Puerto Rico | 72019 | 640 | |
685887 | 685887 | 2020-10-31 | Barranquitas | Puerto Rico | 72019 | 635 | |
682644 | 682644 | 2020-10-30 | Barranquitas | Puerto Rico | 72019 | 634 | |
679401 | 679401 | 2020-10-29 | Barranquitas | Puerto Rico | 72019 | 624 | |
676158 | 676158 | 2020-10-28 | Barranquitas | Puerto Rico | 72019 | 606 | |
672915 | 672915 | 2020-10-27 | Barranquitas | Puerto Rico | 72019 | 605 | |
669673 | 669673 | 2020-10-26 | Barranquitas | Puerto Rico | 72019 | 604 | |
666429 | 666429 | 2020-10-25 | Barranquitas | Puerto Rico | 72019 | 602 | |
663184 | 663184 | 2020-10-24 | Barranquitas | Puerto Rico | 72019 | 583 | |
659940 | 659940 | 2020-10-23 | Barranquitas | Puerto Rico | 72019 | 581 | |
656696 | 656696 | 2020-10-22 | Barranquitas | Puerto Rico | 72019 | 546 | |
653451 | 653451 | 2020-10-21 | Barranquitas | Puerto Rico | 72019 | 548 | |
650206 | 650206 | 2020-10-20 | Barranquitas | Puerto Rico | 72019 | 548 | |
646962 | 646962 | 2020-10-19 | Barranquitas | Puerto Rico | 72019 | 547 | |
643716 | 643716 | 2020-10-18 | Barranquitas | Puerto Rico | 72019 | 543 | |
640468 | 640468 | 2020-10-17 | Barranquitas | Puerto Rico | 72019 | 537 | |
637222 | 637222 | 2020-10-16 | Barranquitas | Puerto Rico | 72019 | 537 | |
633976 | 633976 | 2020-10-15 | Barranquitas | Puerto Rico | 72019 | 537 | |
630731 | 630731 | 2020-10-14 | Barranquitas | Puerto Rico | 72019 | 532 | |
627487 | 627487 | 2020-10-13 | Barranquitas | Puerto Rico | 72019 | 518 | |
624245 | 624245 | 2020-10-12 | Barranquitas | Puerto Rico | 72019 | 518 | |
621002 | 621002 | 2020-10-11 | Barranquitas | Puerto Rico | 72019 | 515 | |
617759 | 617759 | 2020-10-10 | Barranquitas | Puerto Rico | 72019 | 514 | |
614517 | 614517 | 2020-10-09 | Barranquitas | Puerto Rico | 72019 | 510 | |
611276 | 611276 | 2020-10-08 | Barranquitas | Puerto Rico | 72019 | 507 | |
608034 | 608034 | 2020-10-07 | Barranquitas | Puerto Rico | 72019 | 504 | |
604791 | 604791 | 2020-10-06 | Barranquitas | Puerto Rico | 72019 | 504 | |
601549 | 601549 | 2020-10-05 | Barranquitas | Puerto Rico | 72019 | 502 |
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);