ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72085 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 |
---|---|---|---|---|---|---|---|
1065614 | 1065614 | 2021-02-25 | Las Piedras | Puerto Rico | 72085 | 1418 | |
1062369 | 1062369 | 2021-02-24 | Las Piedras | Puerto Rico | 72085 | 1417 | |
1059124 | 1059124 | 2021-02-23 | Las Piedras | Puerto Rico | 72085 | 1417 | |
1055878 | 1055878 | 2021-02-22 | Las Piedras | Puerto Rico | 72085 | 1413 | |
1052632 | 1052632 | 2021-02-21 | Las Piedras | Puerto Rico | 72085 | 1411 | |
1049385 | 1049385 | 2021-02-20 | Las Piedras | Puerto Rico | 72085 | 1409 | |
1046138 | 1046138 | 2021-02-19 | Las Piedras | Puerto Rico | 72085 | 1407 | |
1042893 | 1042893 | 2021-02-18 | Las Piedras | Puerto Rico | 72085 | 1405 | |
1039648 | 1039648 | 2021-02-17 | Las Piedras | Puerto Rico | 72085 | 1404 | |
1036403 | 1036403 | 2021-02-16 | Las Piedras | Puerto Rico | 72085 | 1404 | |
1033158 | 1033158 | 2021-02-15 | Las Piedras | Puerto Rico | 72085 | 1397 | |
1029912 | 1029912 | 2021-02-14 | Las Piedras | Puerto Rico | 72085 | 1386 | |
1026665 | 1026665 | 2021-02-13 | Las Piedras | Puerto Rico | 72085 | 1382 | |
1023420 | 1023420 | 2021-02-12 | Las Piedras | Puerto Rico | 72085 | 1378 | |
1020175 | 1020175 | 2021-02-11 | Las Piedras | Puerto Rico | 72085 | 1370 | |
1016930 | 1016930 | 2021-02-10 | Las Piedras | Puerto Rico | 72085 | 1369 | |
1013685 | 1013685 | 2021-02-09 | Las Piedras | Puerto Rico | 72085 | 1365 | |
1010440 | 1010440 | 2021-02-08 | Las Piedras | Puerto Rico | 72085 | 1356 | |
1007194 | 1007194 | 2021-02-07 | Las Piedras | Puerto Rico | 72085 | 1354 | |
1003948 | 1003948 | 2021-02-06 | Las Piedras | Puerto Rico | 72085 | 1342 | |
1000702 | 1000702 | 2021-02-05 | Las Piedras | Puerto Rico | 72085 | 1341 | |
997456 | 997456 | 2021-02-04 | Las Piedras | Puerto Rico | 72085 | 1341 | |
994210 | 994210 | 2021-02-03 | Las Piedras | Puerto Rico | 72085 | 1339 | |
990964 | 990964 | 2021-02-02 | Las Piedras | Puerto Rico | 72085 | 1332 | |
987718 | 987718 | 2021-02-01 | Las Piedras | Puerto Rico | 72085 | 1324 | |
984471 | 984471 | 2021-01-31 | Las Piedras | Puerto Rico | 72085 | 1310 | |
981224 | 981224 | 2021-01-30 | Las Piedras | Puerto Rico | 72085 | 1302 | |
977978 | 977978 | 2021-01-29 | Las Piedras | Puerto Rico | 72085 | 1297 | |
974733 | 974733 | 2021-01-28 | Las Piedras | Puerto Rico | 72085 | 1286 | |
971488 | 971488 | 2021-01-27 | Las Piedras | Puerto Rico | 72085 | 1283 | |
968243 | 968243 | 2021-01-26 | Las Piedras | Puerto Rico | 72085 | 1279 | |
964999 | 964999 | 2021-01-25 | Las Piedras | Puerto Rico | 72085 | 1273 | |
961754 | 961754 | 2021-01-24 | Las Piedras | Puerto Rico | 72085 | 1269 | |
958509 | 958509 | 2021-01-23 | Las Piedras | Puerto Rico | 72085 | 1254 | |
955263 | 955263 | 2021-01-22 | Las Piedras | Puerto Rico | 72085 | 1233 | |
952018 | 952018 | 2021-01-21 | Las Piedras | Puerto Rico | 72085 | 1232 | |
948773 | 948773 | 2021-01-20 | Las Piedras | Puerto Rico | 72085 | 1230 | |
945527 | 945527 | 2021-01-19 | Las Piedras | Puerto Rico | 72085 | 1230 | |
942280 | 942280 | 2021-01-18 | Las Piedras | Puerto Rico | 72085 | 1229 | |
939035 | 939035 | 2021-01-17 | Las Piedras | Puerto Rico | 72085 | 1221 | |
935790 | 935790 | 2021-01-16 | Las Piedras | Puerto Rico | 72085 | 1188 | |
932545 | 932545 | 2021-01-15 | Las Piedras | Puerto Rico | 72085 | 1187 | |
929300 | 929300 | 2021-01-14 | Las Piedras | Puerto Rico | 72085 | 1182 | |
926055 | 926055 | 2021-01-13 | Las Piedras | Puerto Rico | 72085 | 1180 | |
922809 | 922809 | 2021-01-12 | Las Piedras | Puerto Rico | 72085 | 1180 | |
919564 | 919564 | 2021-01-11 | Las Piedras | Puerto Rico | 72085 | 1169 | |
916319 | 916319 | 2021-01-10 | Las Piedras | Puerto Rico | 72085 | 1167 | |
913074 | 913074 | 2021-01-09 | Las Piedras | Puerto Rico | 72085 | 1165 | |
909829 | 909829 | 2021-01-08 | Las Piedras | Puerto Rico | 72085 | 1159 | |
906584 | 906584 | 2021-01-07 | Las Piedras | Puerto Rico | 72085 | 1128 | |
903338 | 903338 | 2021-01-06 | Las Piedras | Puerto Rico | 72085 | 1128 | |
900093 | 900093 | 2021-01-05 | Las Piedras | Puerto Rico | 72085 | 1130 | |
896848 | 896848 | 2021-01-04 | Las Piedras | Puerto Rico | 72085 | 1129 | |
893602 | 893602 | 2021-01-03 | Las Piedras | Puerto Rico | 72085 | 1124 | |
890356 | 890356 | 2021-01-02 | Las Piedras | Puerto Rico | 72085 | 1123 | |
887109 | 887109 | 2021-01-01 | Las Piedras | Puerto Rico | 72085 | 1119 | |
883864 | 883864 | 2020-12-31 | Las Piedras | Puerto Rico | 72085 | 1118 | |
880619 | 880619 | 2020-12-30 | Las Piedras | Puerto Rico | 72085 | 1117 | |
877374 | 877374 | 2020-12-29 | Las Piedras | Puerto Rico | 72085 | 1117 | |
874129 | 874129 | 2020-12-28 | Las Piedras | Puerto Rico | 72085 | 1054 | |
870884 | 870884 | 2020-12-27 | Las Piedras | Puerto Rico | 72085 | 1021 | |
867639 | 867639 | 2020-12-26 | Las Piedras | Puerto Rico | 72085 | 1001 | |
864394 | 864394 | 2020-12-25 | Las Piedras | Puerto Rico | 72085 | 988 | |
861149 | 861149 | 2020-12-24 | Las Piedras | Puerto Rico | 72085 | 984 | |
857904 | 857904 | 2020-12-23 | Las Piedras | Puerto Rico | 72085 | 982 | |
854659 | 854659 | 2020-12-22 | Las Piedras | Puerto Rico | 72085 | 971 | |
851414 | 851414 | 2020-12-21 | Las Piedras | Puerto Rico | 72085 | 956 | |
848169 | 848169 | 2020-12-20 | Las Piedras | Puerto Rico | 72085 | 951 | |
844924 | 844924 | 2020-12-19 | Las Piedras | Puerto Rico | 72085 | 934 | |
841678 | 841678 | 2020-12-18 | Las Piedras | Puerto Rico | 72085 | 924 | |
838433 | 838433 | 2020-12-17 | Las Piedras | Puerto Rico | 72085 | 914 | |
835187 | 835187 | 2020-12-16 | Las Piedras | Puerto Rico | 72085 | 902 | |
831941 | 831941 | 2020-12-15 | Las Piedras | Puerto Rico | 72085 | 899 | |
828694 | 828694 | 2020-12-14 | Las Piedras | Puerto Rico | 72085 | 899 | |
825448 | 825448 | 2020-12-13 | Las Piedras | Puerto Rico | 72085 | 897 | |
822201 | 822201 | 2020-12-12 | Las Piedras | Puerto Rico | 72085 | 886 | |
818955 | 818955 | 2020-12-11 | Las Piedras | Puerto Rico | 72085 | 879 | |
815709 | 815709 | 2020-12-10 | Las Piedras | Puerto Rico | 72085 | 872 | |
812463 | 812463 | 2020-12-09 | Las Piedras | Puerto Rico | 72085 | 870 | |
809219 | 809219 | 2020-12-08 | Las Piedras | Puerto Rico | 72085 | 867 | |
805974 | 805974 | 2020-12-07 | Las Piedras | Puerto Rico | 72085 | 863 | |
802729 | 802729 | 2020-12-06 | Las Piedras | Puerto Rico | 72085 | 861 | |
799484 | 799484 | 2020-12-05 | Las Piedras | Puerto Rico | 72085 | 856 | |
796239 | 796239 | 2020-12-04 | Las Piedras | Puerto Rico | 72085 | 855 | |
792994 | 792994 | 2020-12-03 | Las Piedras | Puerto Rico | 72085 | 852 | |
789749 | 789749 | 2020-12-02 | Las Piedras | Puerto Rico | 72085 | 848 | |
786504 | 786504 | 2020-12-01 | Las Piedras | Puerto Rico | 72085 | 848 | |
783260 | 783260 | 2020-11-30 | Las Piedras | Puerto Rico | 72085 | 844 | |
780015 | 780015 | 2020-11-29 | Las Piedras | Puerto Rico | 72085 | 840 | |
776769 | 776769 | 2020-11-28 | Las Piedras | Puerto Rico | 72085 | 840 | |
773524 | 773524 | 2020-11-27 | Las Piedras | Puerto Rico | 72085 | 835 | |
770279 | 770279 | 2020-11-26 | Las Piedras | Puerto Rico | 72085 | 831 | |
767033 | 767033 | 2020-11-25 | Las Piedras | Puerto Rico | 72085 | 831 | |
763788 | 763788 | 2020-11-24 | Las Piedras | Puerto Rico | 72085 | 831 | |
760543 | 760543 | 2020-11-23 | Las Piedras | Puerto Rico | 72085 | 829 | |
757298 | 757298 | 2020-11-22 | Las Piedras | Puerto Rico | 72085 | 825 | |
754051 | 754051 | 2020-11-21 | Las Piedras | Puerto Rico | 72085 | 821 | |
750805 | 750805 | 2020-11-20 | Las Piedras | Puerto Rico | 72085 | 807 | |
747559 | 747559 | 2020-11-19 | Las Piedras | Puerto Rico | 72085 | 799 | |
744313 | 744313 | 2020-11-18 | Las Piedras | Puerto Rico | 72085 | 781 |
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);