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 |
---|---|---|---|---|---|---|---|
1055844 | 1055844 | 2021-02-22 | Barranquitas | Puerto Rico | 72019 | 1206 | |
1052598 | 1052598 | 2021-02-21 | Barranquitas | Puerto Rico | 72019 | 1203 | |
1049351 | 1049351 | 2021-02-20 | Barranquitas | Puerto Rico | 72019 | 1199 | |
1046104 | 1046104 | 2021-02-19 | Barranquitas | Puerto Rico | 72019 | 1193 | |
1042859 | 1042859 | 2021-02-18 | Barranquitas | Puerto Rico | 72019 | 1193 | |
1039614 | 1039614 | 2021-02-17 | Barranquitas | Puerto Rico | 72019 | 1193 | |
1036369 | 1036369 | 2021-02-16 | Barranquitas | Puerto Rico | 72019 | 1193 | |
1033124 | 1033124 | 2021-02-15 | Barranquitas | Puerto Rico | 72019 | 1193 | |
1029878 | 1029878 | 2021-02-14 | Barranquitas | Puerto Rico | 72019 | 1192 | |
1026631 | 1026631 | 2021-02-13 | Barranquitas | Puerto Rico | 72019 | 1190 | |
1023386 | 1023386 | 2021-02-12 | Barranquitas | Puerto Rico | 72019 | 1187 | |
1020141 | 1020141 | 2021-02-11 | Barranquitas | Puerto Rico | 72019 | 1186 | |
1016896 | 1016896 | 2021-02-10 | Barranquitas | Puerto Rico | 72019 | 1185 | |
1013651 | 1013651 | 2021-02-09 | Barranquitas | Puerto Rico | 72019 | 1184 | |
1010406 | 1010406 | 2021-02-08 | Barranquitas | Puerto Rico | 72019 | 1180 | |
1007160 | 1007160 | 2021-02-07 | Barranquitas | Puerto Rico | 72019 | 1178 | |
1003914 | 1003914 | 2021-02-06 | Barranquitas | Puerto Rico | 72019 | 1173 | |
1000668 | 1000668 | 2021-02-05 | Barranquitas | Puerto Rico | 72019 | 1172 | |
997422 | 997422 | 2021-02-04 | Barranquitas | Puerto Rico | 72019 | 1172 | |
994176 | 994176 | 2021-02-03 | Barranquitas | Puerto Rico | 72019 | 1167 | |
990930 | 990930 | 2021-02-02 | Barranquitas | Puerto Rico | 72019 | 1165 | |
987684 | 987684 | 2021-02-01 | Barranquitas | Puerto Rico | 72019 | 1163 | |
984437 | 984437 | 2021-01-31 | Barranquitas | Puerto Rico | 72019 | 1146 | |
981190 | 981190 | 2021-01-30 | Barranquitas | Puerto Rico | 72019 | 1144 | |
977944 | 977944 | 2021-01-29 | Barranquitas | Puerto Rico | 72019 | 1139 | |
974699 | 974699 | 2021-01-28 | Barranquitas | Puerto Rico | 72019 | 1137 | |
971454 | 971454 | 2021-01-27 | Barranquitas | Puerto Rico | 72019 | 1134 | |
968209 | 968209 | 2021-01-26 | Barranquitas | Puerto Rico | 72019 | 1130 | |
964965 | 964965 | 2021-01-25 | Barranquitas | Puerto Rico | 72019 | 1124 | |
961720 | 961720 | 2021-01-24 | Barranquitas | Puerto Rico | 72019 | 1113 | |
958475 | 958475 | 2021-01-23 | Barranquitas | Puerto Rico | 72019 | 1101 | |
955229 | 955229 | 2021-01-22 | Barranquitas | Puerto Rico | 72019 | 1090 | |
951984 | 951984 | 2021-01-21 | Barranquitas | Puerto Rico | 72019 | 1085 | |
948739 | 948739 | 2021-01-20 | Barranquitas | Puerto Rico | 72019 | 1082 | |
945493 | 945493 | 2021-01-19 | Barranquitas | Puerto Rico | 72019 | 1082 | |
942246 | 942246 | 2021-01-18 | Barranquitas | Puerto Rico | 72019 | 1081 | |
939001 | 939001 | 2021-01-17 | Barranquitas | Puerto Rico | 72019 | 1076 | |
935756 | 935756 | 2021-01-16 | Barranquitas | Puerto Rico | 72019 | 1075 | |
932511 | 932511 | 2021-01-15 | Barranquitas | Puerto Rico | 72019 | 1072 | |
929266 | 929266 | 2021-01-14 | Barranquitas | Puerto Rico | 72019 | 1067 | |
926021 | 926021 | 2021-01-13 | Barranquitas | Puerto Rico | 72019 | 1065 | |
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 |
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);