ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72053 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 |
---|---|---|---|---|---|---|---|
922792 | 922792 | 2021-01-12 | Fajardo | Puerto Rico | 72053 | 1165 | |
919547 | 919547 | 2021-01-11 | Fajardo | Puerto Rico | 72053 | 1162 | |
916302 | 916302 | 2021-01-10 | Fajardo | Puerto Rico | 72053 | 1159 | |
913057 | 913057 | 2021-01-09 | Fajardo | Puerto Rico | 72053 | 1157 | |
909812 | 909812 | 2021-01-08 | Fajardo | Puerto Rico | 72053 | 1152 | |
906567 | 906567 | 2021-01-07 | Fajardo | Puerto Rico | 72053 | 1106 | |
903321 | 903321 | 2021-01-06 | Fajardo | Puerto Rico | 72053 | 1098 | |
900076 | 900076 | 2021-01-05 | Fajardo | Puerto Rico | 72053 | 1096 | |
896831 | 896831 | 2021-01-04 | Fajardo | Puerto Rico | 72053 | 1089 | |
893585 | 893585 | 2021-01-03 | Fajardo | Puerto Rico | 72053 | 1078 | |
890339 | 890339 | 2021-01-02 | Fajardo | Puerto Rico | 72053 | 1075 | |
887092 | 887092 | 2021-01-01 | Fajardo | Puerto Rico | 72053 | 1046 | |
883847 | 883847 | 2020-12-31 | Fajardo | Puerto Rico | 72053 | 1038 | |
880602 | 880602 | 2020-12-30 | Fajardo | Puerto Rico | 72053 | 1029 | |
877357 | 877357 | 2020-12-29 | Fajardo | Puerto Rico | 72053 | 1027 | |
874112 | 874112 | 2020-12-28 | Fajardo | Puerto Rico | 72053 | 995 | |
870867 | 870867 | 2020-12-27 | Fajardo | Puerto Rico | 72053 | 995 | |
867622 | 867622 | 2020-12-26 | Fajardo | Puerto Rico | 72053 | 982 | |
864377 | 864377 | 2020-12-25 | Fajardo | Puerto Rico | 72053 | 980 | |
861132 | 861132 | 2020-12-24 | Fajardo | Puerto Rico | 72053 | 978 | |
857887 | 857887 | 2020-12-23 | Fajardo | Puerto Rico | 72053 | 976 | |
854642 | 854642 | 2020-12-22 | Fajardo | Puerto Rico | 72053 | 969 | |
851397 | 851397 | 2020-12-21 | Fajardo | Puerto Rico | 72053 | 959 | |
848152 | 848152 | 2020-12-20 | Fajardo | Puerto Rico | 72053 | 957 | |
844907 | 844907 | 2020-12-19 | Fajardo | Puerto Rico | 72053 | 911 | |
841661 | 841661 | 2020-12-18 | Fajardo | Puerto Rico | 72053 | 905 | |
838416 | 838416 | 2020-12-17 | Fajardo | Puerto Rico | 72053 | 897 | |
835170 | 835170 | 2020-12-16 | Fajardo | Puerto Rico | 72053 | 893 | |
831924 | 831924 | 2020-12-15 | Fajardo | Puerto Rico | 72053 | 893 | |
828677 | 828677 | 2020-12-14 | Fajardo | Puerto Rico | 72053 | 890 | |
825431 | 825431 | 2020-12-13 | Fajardo | Puerto Rico | 72053 | 888 | |
822184 | 822184 | 2020-12-12 | Fajardo | Puerto Rico | 72053 | 884 | |
818938 | 818938 | 2020-12-11 | Fajardo | Puerto Rico | 72053 | 884 | |
815692 | 815692 | 2020-12-10 | Fajardo | Puerto Rico | 72053 | 879 | |
812446 | 812446 | 2020-12-09 | Fajardo | Puerto Rico | 72053 | 879 | |
809202 | 809202 | 2020-12-08 | Fajardo | Puerto Rico | 72053 | 878 | |
805957 | 805957 | 2020-12-07 | Fajardo | Puerto Rico | 72053 | 874 | |
802712 | 802712 | 2020-12-06 | Fajardo | Puerto Rico | 72053 | 872 | |
799467 | 799467 | 2020-12-05 | Fajardo | Puerto Rico | 72053 | 870 | |
796222 | 796222 | 2020-12-04 | Fajardo | Puerto Rico | 72053 | 867 | |
792977 | 792977 | 2020-12-03 | Fajardo | Puerto Rico | 72053 | 862 | |
789732 | 789732 | 2020-12-02 | Fajardo | Puerto Rico | 72053 | 853 | |
786487 | 786487 | 2020-12-01 | Fajardo | Puerto Rico | 72053 | 852 | |
783243 | 783243 | 2020-11-30 | Fajardo | Puerto Rico | 72053 | 851 | |
779998 | 779998 | 2020-11-29 | Fajardo | Puerto Rico | 72053 | 848 | |
776752 | 776752 | 2020-11-28 | Fajardo | Puerto Rico | 72053 | 848 | |
773507 | 773507 | 2020-11-27 | Fajardo | Puerto Rico | 72053 | 844 | |
770262 | 770262 | 2020-11-26 | Fajardo | Puerto Rico | 72053 | 841 | |
767016 | 767016 | 2020-11-25 | Fajardo | Puerto Rico | 72053 | 839 | |
763771 | 763771 | 2020-11-24 | Fajardo | Puerto Rico | 72053 | 839 | |
760526 | 760526 | 2020-11-23 | Fajardo | Puerto Rico | 72053 | 836 | |
757281 | 757281 | 2020-11-22 | Fajardo | Puerto Rico | 72053 | 836 | |
754034 | 754034 | 2020-11-21 | Fajardo | Puerto Rico | 72053 | 835 | |
750788 | 750788 | 2020-11-20 | Fajardo | Puerto Rico | 72053 | 834 | |
747542 | 747542 | 2020-11-19 | Fajardo | Puerto Rico | 72053 | 831 | |
744296 | 744296 | 2020-11-18 | Fajardo | Puerto Rico | 72053 | 828 | |
741049 | 741049 | 2020-11-17 | Fajardo | Puerto Rico | 72053 | 828 | |
737803 | 737803 | 2020-11-16 | Fajardo | Puerto Rico | 72053 | 823 | |
734559 | 734559 | 2020-11-15 | Fajardo | Puerto Rico | 72053 | 821 | |
731313 | 731313 | 2020-11-14 | Fajardo | Puerto Rico | 72053 | 819 | |
728069 | 728069 | 2020-11-13 | Fajardo | Puerto Rico | 72053 | 808 | |
724825 | 724825 | 2020-11-12 | Fajardo | Puerto Rico | 72053 | 804 | |
721582 | 721582 | 2020-11-11 | Fajardo | Puerto Rico | 72053 | 801 | |
718339 | 718339 | 2020-11-10 | Fajardo | Puerto Rico | 72053 | 796 | |
715096 | 715096 | 2020-11-09 | Fajardo | Puerto Rico | 72053 | 796 | |
711852 | 711852 | 2020-11-08 | Fajardo | Puerto Rico | 72053 | 792 | |
708608 | 708608 | 2020-11-07 | Fajardo | Puerto Rico | 72053 | 781 | |
705365 | 705365 | 2020-11-06 | Fajardo | Puerto Rico | 72053 | 781 | |
702122 | 702122 | 2020-11-05 | Fajardo | Puerto Rico | 72053 | 778 | |
698878 | 698878 | 2020-11-04 | Fajardo | Puerto Rico | 72053 | 776 | |
695635 | 695635 | 2020-11-03 | Fajardo | Puerto Rico | 72053 | 776 | |
692393 | 692393 | 2020-11-02 | Fajardo | Puerto Rico | 72053 | 773 | |
689149 | 689149 | 2020-11-01 | Fajardo | Puerto Rico | 72053 | 759 | |
685904 | 685904 | 2020-10-31 | Fajardo | Puerto Rico | 72053 | 754 | |
682661 | 682661 | 2020-10-30 | Fajardo | Puerto Rico | 72053 | 750 | |
679418 | 679418 | 2020-10-29 | Fajardo | Puerto Rico | 72053 | 735 | |
676175 | 676175 | 2020-10-28 | Fajardo | Puerto Rico | 72053 | 722 | |
672932 | 672932 | 2020-10-27 | Fajardo | Puerto Rico | 72053 | 722 | |
669690 | 669690 | 2020-10-26 | Fajardo | Puerto Rico | 72053 | 721 | |
666446 | 666446 | 2020-10-25 | Fajardo | Puerto Rico | 72053 | 716 | |
663201 | 663201 | 2020-10-24 | Fajardo | Puerto Rico | 72053 | 707 | |
659957 | 659957 | 2020-10-23 | Fajardo | Puerto Rico | 72053 | 707 | |
656713 | 656713 | 2020-10-22 | Fajardo | Puerto Rico | 72053 | 689 | |
653468 | 653468 | 2020-10-21 | Fajardo | Puerto Rico | 72053 | 682 | |
650223 | 650223 | 2020-10-20 | Fajardo | Puerto Rico | 72053 | 682 | |
646979 | 646979 | 2020-10-19 | Fajardo | Puerto Rico | 72053 | 680 | |
643733 | 643733 | 2020-10-18 | Fajardo | Puerto Rico | 72053 | 674 | |
640485 | 640485 | 2020-10-17 | Fajardo | Puerto Rico | 72053 | 642 | |
637239 | 637239 | 2020-10-16 | Fajardo | Puerto Rico | 72053 | 642 | |
633993 | 633993 | 2020-10-15 | Fajardo | Puerto Rico | 72053 | 641 | |
630748 | 630748 | 2020-10-14 | Fajardo | Puerto Rico | 72053 | 641 | |
627504 | 627504 | 2020-10-13 | Fajardo | Puerto Rico | 72053 | 627 | |
624262 | 624262 | 2020-10-12 | Fajardo | Puerto Rico | 72053 | 625 | |
621019 | 621019 | 2020-10-11 | Fajardo | Puerto Rico | 72053 | 621 | |
617776 | 617776 | 2020-10-10 | Fajardo | Puerto Rico | 72053 | 616 | |
614534 | 614534 | 2020-10-09 | Fajardo | Puerto Rico | 72053 | 613 | |
611293 | 611293 | 2020-10-08 | Fajardo | Puerto Rico | 72053 | 605 | |
608051 | 608051 | 2020-10-07 | Fajardo | Puerto Rico | 72053 | 603 | |
604808 | 604808 | 2020-10-06 | Fajardo | Puerto Rico | 72053 | 603 | |
601566 | 601566 | 2020-10-05 | Fajardo | Puerto Rico | 72053 | 592 |
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);