ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72071 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 |
---|---|---|---|---|---|---|---|
1065607 | 1065607 | 2021-02-25 | Isabela | Puerto Rico | 72071 | 1218 | |
1062362 | 1062362 | 2021-02-24 | Isabela | Puerto Rico | 72071 | 1217 | |
1059117 | 1059117 | 2021-02-23 | Isabela | Puerto Rico | 72071 | 1217 | |
1055871 | 1055871 | 2021-02-22 | Isabela | Puerto Rico | 72071 | 1217 | |
1052625 | 1052625 | 2021-02-21 | Isabela | Puerto Rico | 72071 | 1216 | |
1049378 | 1049378 | 2021-02-20 | Isabela | Puerto Rico | 72071 | 1212 | |
1046131 | 1046131 | 2021-02-19 | Isabela | Puerto Rico | 72071 | 1213 | |
1042886 | 1042886 | 2021-02-18 | Isabela | Puerto Rico | 72071 | 1211 | |
1039641 | 1039641 | 2021-02-17 | Isabela | Puerto Rico | 72071 | 1209 | |
1036396 | 1036396 | 2021-02-16 | Isabela | Puerto Rico | 72071 | 1208 | |
1033151 | 1033151 | 2021-02-15 | Isabela | Puerto Rico | 72071 | 1206 | |
1029905 | 1029905 | 2021-02-14 | Isabela | Puerto Rico | 72071 | 1203 | |
1026658 | 1026658 | 2021-02-13 | Isabela | Puerto Rico | 72071 | 1203 | |
1023413 | 1023413 | 2021-02-12 | Isabela | Puerto Rico | 72071 | 1199 | |
1020168 | 1020168 | 2021-02-11 | Isabela | Puerto Rico | 72071 | 1198 | |
1016923 | 1016923 | 2021-02-10 | Isabela | Puerto Rico | 72071 | 1192 | |
1013678 | 1013678 | 2021-02-09 | Isabela | Puerto Rico | 72071 | 1187 | |
1010433 | 1010433 | 2021-02-08 | Isabela | Puerto Rico | 72071 | 1180 | |
1007187 | 1007187 | 2021-02-07 | Isabela | Puerto Rico | 72071 | 1177 | |
1003941 | 1003941 | 2021-02-06 | Isabela | Puerto Rico | 72071 | 1161 | |
1000695 | 1000695 | 2021-02-05 | Isabela | Puerto Rico | 72071 | 1160 | |
997449 | 997449 | 2021-02-04 | Isabela | Puerto Rico | 72071 | 1160 | |
994203 | 994203 | 2021-02-03 | Isabela | Puerto Rico | 72071 | 1154 | |
990957 | 990957 | 2021-02-02 | Isabela | Puerto Rico | 72071 | 1152 | |
987711 | 987711 | 2021-02-01 | Isabela | Puerto Rico | 72071 | 1146 | |
984464 | 984464 | 2021-01-31 | Isabela | Puerto Rico | 72071 | 1139 | |
981217 | 981217 | 2021-01-30 | Isabela | Puerto Rico | 72071 | 1135 | |
977971 | 977971 | 2021-01-29 | Isabela | Puerto Rico | 72071 | 1127 | |
974726 | 974726 | 2021-01-28 | Isabela | Puerto Rico | 72071 | 1119 | |
971481 | 971481 | 2021-01-27 | Isabela | Puerto Rico | 72071 | 1116 | |
968236 | 968236 | 2021-01-26 | Isabela | Puerto Rico | 72071 | 1115 | |
964992 | 964992 | 2021-01-25 | Isabela | Puerto Rico | 72071 | 1114 | |
961747 | 961747 | 2021-01-24 | Isabela | Puerto Rico | 72071 | 1108 | |
958502 | 958502 | 2021-01-23 | Isabela | Puerto Rico | 72071 | 1096 | |
955256 | 955256 | 2021-01-22 | Isabela | Puerto Rico | 72071 | 1095 | |
952011 | 952011 | 2021-01-21 | Isabela | Puerto Rico | 72071 | 1088 | |
948766 | 948766 | 2021-01-20 | Isabela | Puerto Rico | 72071 | 1085 | |
945520 | 945520 | 2021-01-19 | Isabela | Puerto Rico | 72071 | 1085 | |
942273 | 942273 | 2021-01-18 | Isabela | Puerto Rico | 72071 | 1077 | |
939028 | 939028 | 2021-01-17 | Isabela | Puerto Rico | 72071 | 1064 | |
935783 | 935783 | 2021-01-16 | Isabela | Puerto Rico | 72071 | 1058 | |
932538 | 932538 | 2021-01-15 | Isabela | Puerto Rico | 72071 | 1047 | |
929293 | 929293 | 2021-01-14 | Isabela | Puerto Rico | 72071 | 1039 | |
926048 | 926048 | 2021-01-13 | Isabela | Puerto Rico | 72071 | 1037 | |
922802 | 922802 | 2021-01-12 | Isabela | Puerto Rico | 72071 | 1036 | |
919557 | 919557 | 2021-01-11 | Isabela | Puerto Rico | 72071 | 1031 | |
916312 | 916312 | 2021-01-10 | Isabela | Puerto Rico | 72071 | 1029 | |
913067 | 913067 | 2021-01-09 | Isabela | Puerto Rico | 72071 | 1023 | |
909822 | 909822 | 2021-01-08 | Isabela | Puerto Rico | 72071 | 1022 | |
906577 | 906577 | 2021-01-07 | Isabela | Puerto Rico | 72071 | 980 | |
903331 | 903331 | 2021-01-06 | Isabela | Puerto Rico | 72071 | 974 | |
900086 | 900086 | 2021-01-05 | Isabela | Puerto Rico | 72071 | 972 | |
896841 | 896841 | 2021-01-04 | Isabela | Puerto Rico | 72071 | 971 | |
893595 | 893595 | 2021-01-03 | Isabela | Puerto Rico | 72071 | 966 | |
890349 | 890349 | 2021-01-02 | Isabela | Puerto Rico | 72071 | 965 | |
887102 | 887102 | 2021-01-01 | Isabela | Puerto Rico | 72071 | 958 | |
883857 | 883857 | 2020-12-31 | Isabela | Puerto Rico | 72071 | 932 | |
880612 | 880612 | 2020-12-30 | Isabela | Puerto Rico | 72071 | 927 | |
877367 | 877367 | 2020-12-29 | Isabela | Puerto Rico | 72071 | 920 | |
874122 | 874122 | 2020-12-28 | Isabela | Puerto Rico | 72071 | 907 | |
870877 | 870877 | 2020-12-27 | Isabela | Puerto Rico | 72071 | 907 | |
867632 | 867632 | 2020-12-26 | Isabela | Puerto Rico | 72071 | 901 | |
864387 | 864387 | 2020-12-25 | Isabela | Puerto Rico | 72071 | 884 | |
861142 | 861142 | 2020-12-24 | Isabela | Puerto Rico | 72071 | 873 | |
857897 | 857897 | 2020-12-23 | Isabela | Puerto Rico | 72071 | 871 | |
854652 | 854652 | 2020-12-22 | Isabela | Puerto Rico | 72071 | 861 | |
851407 | 851407 | 2020-12-21 | Isabela | Puerto Rico | 72071 | 840 | |
848162 | 848162 | 2020-12-20 | Isabela | Puerto Rico | 72071 | 830 | |
844917 | 844917 | 2020-12-19 | Isabela | Puerto Rico | 72071 | 808 | |
841671 | 841671 | 2020-12-18 | Isabela | Puerto Rico | 72071 | 788 | |
838426 | 838426 | 2020-12-17 | Isabela | Puerto Rico | 72071 | 762 | |
835180 | 835180 | 2020-12-16 | Isabela | Puerto Rico | 72071 | 752 | |
831934 | 831934 | 2020-12-15 | Isabela | Puerto Rico | 72071 | 748 | |
828687 | 828687 | 2020-12-14 | Isabela | Puerto Rico | 72071 | 724 | |
825441 | 825441 | 2020-12-13 | Isabela | Puerto Rico | 72071 | 721 | |
822194 | 822194 | 2020-12-12 | Isabela | Puerto Rico | 72071 | 712 | |
818948 | 818948 | 2020-12-11 | Isabela | Puerto Rico | 72071 | 708 | |
815702 | 815702 | 2020-12-10 | Isabela | Puerto Rico | 72071 | 703 | |
812456 | 812456 | 2020-12-09 | Isabela | Puerto Rico | 72071 | 699 | |
809212 | 809212 | 2020-12-08 | Isabela | Puerto Rico | 72071 | 695 | |
805967 | 805967 | 2020-12-07 | Isabela | Puerto Rico | 72071 | 678 | |
802722 | 802722 | 2020-12-06 | Isabela | Puerto Rico | 72071 | 669 | |
799477 | 799477 | 2020-12-05 | Isabela | Puerto Rico | 72071 | 661 | |
796232 | 796232 | 2020-12-04 | Isabela | Puerto Rico | 72071 | 649 | |
792987 | 792987 | 2020-12-03 | Isabela | Puerto Rico | 72071 | 648 | |
789742 | 789742 | 2020-12-02 | Isabela | Puerto Rico | 72071 | 648 | |
786497 | 786497 | 2020-12-01 | Isabela | Puerto Rico | 72071 | 646 | |
783253 | 783253 | 2020-11-30 | Isabela | Puerto Rico | 72071 | 632 | |
780008 | 780008 | 2020-11-29 | Isabela | Puerto Rico | 72071 | 624 | |
776762 | 776762 | 2020-11-28 | Isabela | Puerto Rico | 72071 | 620 | |
773517 | 773517 | 2020-11-27 | Isabela | Puerto Rico | 72071 | 608 | |
770272 | 770272 | 2020-11-26 | Isabela | Puerto Rico | 72071 | 597 | |
767026 | 767026 | 2020-11-25 | Isabela | Puerto Rico | 72071 | 593 | |
763781 | 763781 | 2020-11-24 | Isabela | Puerto Rico | 72071 | 593 | |
760536 | 760536 | 2020-11-23 | Isabela | Puerto Rico | 72071 | 574 | |
757291 | 757291 | 2020-11-22 | Isabela | Puerto Rico | 72071 | 567 | |
754044 | 754044 | 2020-11-21 | Isabela | Puerto Rico | 72071 | 552 | |
750798 | 750798 | 2020-11-20 | Isabela | Puerto Rico | 72071 | 546 | |
747552 | 747552 | 2020-11-19 | Isabela | Puerto Rico | 72071 | 540 | |
744306 | 744306 | 2020-11-18 | Isabela | Puerto Rico | 72071 | 530 |
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);