ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72087 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 |
---|---|---|---|---|---|---|---|
1065615 | 1065615 | 2021-02-25 | Loiza | Puerto Rico | 72087 | 985 | |
1062370 | 1062370 | 2021-02-24 | Loiza | Puerto Rico | 72087 | 980 | |
1059125 | 1059125 | 2021-02-23 | Loiza | Puerto Rico | 72087 | 980 | |
1055879 | 1055879 | 2021-02-22 | Loiza | Puerto Rico | 72087 | 976 | |
1052633 | 1052633 | 2021-02-21 | Loiza | Puerto Rico | 72087 | 974 | |
1049386 | 1049386 | 2021-02-20 | Loiza | Puerto Rico | 72087 | 969 | |
1046139 | 1046139 | 2021-02-19 | Loiza | Puerto Rico | 72087 | 969 | |
1042894 | 1042894 | 2021-02-18 | Loiza | Puerto Rico | 72087 | 964 | |
1039649 | 1039649 | 2021-02-17 | Loiza | Puerto Rico | 72087 | 963 | |
1036404 | 1036404 | 2021-02-16 | Loiza | Puerto Rico | 72087 | 963 | |
1033159 | 1033159 | 2021-02-15 | Loiza | Puerto Rico | 72087 | 959 | |
1029913 | 1029913 | 2021-02-14 | Loiza | Puerto Rico | 72087 | 959 | |
1026666 | 1026666 | 2021-02-13 | Loiza | Puerto Rico | 72087 | 959 | |
1023421 | 1023421 | 2021-02-12 | Loiza | Puerto Rico | 72087 | 954 | |
1020176 | 1020176 | 2021-02-11 | Loiza | Puerto Rico | 72087 | 951 | |
1016931 | 1016931 | 2021-02-10 | Loiza | Puerto Rico | 72087 | 951 | |
1013686 | 1013686 | 2021-02-09 | Loiza | Puerto Rico | 72087 | 951 | |
1010441 | 1010441 | 2021-02-08 | Loiza | Puerto Rico | 72087 | 951 | |
1007195 | 1007195 | 2021-02-07 | Loiza | Puerto Rico | 72087 | 947 | |
1003949 | 1003949 | 2021-02-06 | Loiza | Puerto Rico | 72087 | 945 | |
1000703 | 1000703 | 2021-02-05 | Loiza | Puerto Rico | 72087 | 945 | |
997457 | 997457 | 2021-02-04 | Loiza | Puerto Rico | 72087 | 944 | |
994211 | 994211 | 2021-02-03 | Loiza | Puerto Rico | 72087 | 937 | |
990965 | 990965 | 2021-02-02 | Loiza | Puerto Rico | 72087 | 936 | |
987719 | 987719 | 2021-02-01 | Loiza | Puerto Rico | 72087 | 934 | |
984472 | 984472 | 2021-01-31 | Loiza | Puerto Rico | 72087 | 925 | |
981225 | 981225 | 2021-01-30 | Loiza | Puerto Rico | 72087 | 920 | |
977979 | 977979 | 2021-01-29 | Loiza | Puerto Rico | 72087 | 916 | |
974734 | 974734 | 2021-01-28 | Loiza | Puerto Rico | 72087 | 911 | |
971489 | 971489 | 2021-01-27 | Loiza | Puerto Rico | 72087 | 904 | |
968244 | 968244 | 2021-01-26 | Loiza | Puerto Rico | 72087 | 904 | |
965000 | 965000 | 2021-01-25 | Loiza | Puerto Rico | 72087 | 905 | |
961755 | 961755 | 2021-01-24 | Loiza | Puerto Rico | 72087 | 901 | |
958510 | 958510 | 2021-01-23 | Loiza | Puerto Rico | 72087 | 891 | |
955264 | 955264 | 2021-01-22 | Loiza | Puerto Rico | 72087 | 883 | |
952019 | 952019 | 2021-01-21 | Loiza | Puerto Rico | 72087 | 879 | |
948774 | 948774 | 2021-01-20 | Loiza | Puerto Rico | 72087 | 878 | |
945528 | 945528 | 2021-01-19 | Loiza | Puerto Rico | 72087 | 877 | |
942281 | 942281 | 2021-01-18 | Loiza | Puerto Rico | 72087 | 874 | |
939036 | 939036 | 2021-01-17 | Loiza | Puerto Rico | 72087 | 870 | |
935791 | 935791 | 2021-01-16 | Loiza | Puerto Rico | 72087 | 858 | |
932546 | 932546 | 2021-01-15 | Loiza | Puerto Rico | 72087 | 849 | |
929301 | 929301 | 2021-01-14 | Loiza | Puerto Rico | 72087 | 836 | |
926056 | 926056 | 2021-01-13 | Loiza | Puerto Rico | 72087 | 833 | |
922810 | 922810 | 2021-01-12 | Loiza | Puerto Rico | 72087 | 829 | |
919565 | 919565 | 2021-01-11 | Loiza | Puerto Rico | 72087 | 822 | |
916320 | 916320 | 2021-01-10 | Loiza | Puerto Rico | 72087 | 818 | |
913075 | 913075 | 2021-01-09 | Loiza | Puerto Rico | 72087 | 814 | |
909830 | 909830 | 2021-01-08 | Loiza | Puerto Rico | 72087 | 812 | |
906585 | 906585 | 2021-01-07 | Loiza | Puerto Rico | 72087 | 805 | |
903339 | 903339 | 2021-01-06 | Loiza | Puerto Rico | 72087 | 798 | |
900094 | 900094 | 2021-01-05 | Loiza | Puerto Rico | 72087 | 792 | |
896849 | 896849 | 2021-01-04 | Loiza | Puerto Rico | 72087 | 788 | |
893603 | 893603 | 2021-01-03 | Loiza | Puerto Rico | 72087 | 783 | |
890357 | 890357 | 2021-01-02 | Loiza | Puerto Rico | 72087 | 782 | |
887110 | 887110 | 2021-01-01 | Loiza | Puerto Rico | 72087 | 778 | |
883865 | 883865 | 2020-12-31 | Loiza | Puerto Rico | 72087 | 773 | |
880620 | 880620 | 2020-12-30 | Loiza | Puerto Rico | 72087 | 769 | |
877375 | 877375 | 2020-12-29 | Loiza | Puerto Rico | 72087 | 769 | |
874130 | 874130 | 2020-12-28 | Loiza | Puerto Rico | 72087 | 757 | |
870885 | 870885 | 2020-12-27 | Loiza | Puerto Rico | 72087 | 757 | |
867640 | 867640 | 2020-12-26 | Loiza | Puerto Rico | 72087 | 733 | |
864395 | 864395 | 2020-12-25 | Loiza | Puerto Rico | 72087 | 702 | |
861150 | 861150 | 2020-12-24 | Loiza | Puerto Rico | 72087 | 696 | |
857905 | 857905 | 2020-12-23 | Loiza | Puerto Rico | 72087 | 694 | |
854660 | 854660 | 2020-12-22 | Loiza | Puerto Rico | 72087 | 690 | |
851415 | 851415 | 2020-12-21 | Loiza | Puerto Rico | 72087 | 683 | |
848170 | 848170 | 2020-12-20 | Loiza | Puerto Rico | 72087 | 681 | |
844925 | 844925 | 2020-12-19 | Loiza | Puerto Rico | 72087 | 673 | |
841679 | 841679 | 2020-12-18 | Loiza | Puerto Rico | 72087 | 666 | |
838434 | 838434 | 2020-12-17 | Loiza | Puerto Rico | 72087 | 654 | |
835188 | 835188 | 2020-12-16 | Loiza | Puerto Rico | 72087 | 648 | |
831942 | 831942 | 2020-12-15 | Loiza | Puerto Rico | 72087 | 642 | |
828695 | 828695 | 2020-12-14 | Loiza | Puerto Rico | 72087 | 620 | |
825449 | 825449 | 2020-12-13 | Loiza | Puerto Rico | 72087 | 616 | |
822202 | 822202 | 2020-12-12 | Loiza | Puerto Rico | 72087 | 614 | |
818956 | 818956 | 2020-12-11 | Loiza | Puerto Rico | 72087 | 594 | |
815710 | 815710 | 2020-12-10 | Loiza | Puerto Rico | 72087 | 575 | |
812464 | 812464 | 2020-12-09 | Loiza | Puerto Rico | 72087 | 575 | |
809220 | 809220 | 2020-12-08 | Loiza | Puerto Rico | 72087 | 568 | |
805975 | 805975 | 2020-12-07 | Loiza | Puerto Rico | 72087 | 566 | |
802730 | 802730 | 2020-12-06 | Loiza | Puerto Rico | 72087 | 562 | |
799485 | 799485 | 2020-12-05 | Loiza | Puerto Rico | 72087 | 543 | |
796240 | 796240 | 2020-12-04 | Loiza | Puerto Rico | 72087 | 533 | |
792995 | 792995 | 2020-12-03 | Loiza | Puerto Rico | 72087 | 530 | |
789750 | 789750 | 2020-12-02 | Loiza | Puerto Rico | 72087 | 525 | |
786505 | 786505 | 2020-12-01 | Loiza | Puerto Rico | 72087 | 525 | |
783261 | 783261 | 2020-11-30 | Loiza | Puerto Rico | 72087 | 522 | |
780016 | 780016 | 2020-11-29 | Loiza | Puerto Rico | 72087 | 520 | |
776770 | 776770 | 2020-11-28 | Loiza | Puerto Rico | 72087 | 517 | |
773525 | 773525 | 2020-11-27 | Loiza | Puerto Rico | 72087 | 517 | |
770280 | 770280 | 2020-11-26 | Loiza | Puerto Rico | 72087 | 508 | |
767034 | 767034 | 2020-11-25 | Loiza | Puerto Rico | 72087 | 506 | |
763789 | 763789 | 2020-11-24 | Loiza | Puerto Rico | 72087 | 505 | |
760544 | 760544 | 2020-11-23 | Loiza | Puerto Rico | 72087 | 504 | |
757299 | 757299 | 2020-11-22 | Loiza | Puerto Rico | 72087 | 503 | |
754052 | 754052 | 2020-11-21 | Loiza | Puerto Rico | 72087 | 497 | |
750806 | 750806 | 2020-11-20 | Loiza | Puerto Rico | 72087 | 490 | |
747560 | 747560 | 2020-11-19 | Loiza | Puerto Rico | 72087 | 485 | |
744314 | 744314 | 2020-11-18 | Loiza | Puerto Rico | 72087 | 479 |
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);