ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72069 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 |
---|---|---|---|---|---|---|---|
1065606 | 1065606 | 2021-02-25 | Humacao | Puerto Rico | 72069 | 1646 | |
1062361 | 1062361 | 2021-02-24 | Humacao | Puerto Rico | 72069 | 1644 | |
1059116 | 1059116 | 2021-02-23 | Humacao | Puerto Rico | 72069 | 1644 | |
1055870 | 1055870 | 2021-02-22 | Humacao | Puerto Rico | 72069 | 1642 | |
1052624 | 1052624 | 2021-02-21 | Humacao | Puerto Rico | 72069 | 1640 | |
1049377 | 1049377 | 2021-02-20 | Humacao | Puerto Rico | 72069 | 1635 | |
1046130 | 1046130 | 2021-02-19 | Humacao | Puerto Rico | 72069 | 1633 | |
1042885 | 1042885 | 2021-02-18 | Humacao | Puerto Rico | 72069 | 1633 | |
1039640 | 1039640 | 2021-02-17 | Humacao | Puerto Rico | 72069 | 1634 | |
1036395 | 1036395 | 2021-02-16 | Humacao | Puerto Rico | 72069 | 1631 | |
1033150 | 1033150 | 2021-02-15 | Humacao | Puerto Rico | 72069 | 1625 | |
1029904 | 1029904 | 2021-02-14 | Humacao | Puerto Rico | 72069 | 1615 | |
1026657 | 1026657 | 2021-02-13 | Humacao | Puerto Rico | 72069 | 1608 | |
1023412 | 1023412 | 2021-02-12 | Humacao | Puerto Rico | 72069 | 1603 | |
1020167 | 1020167 | 2021-02-11 | Humacao | Puerto Rico | 72069 | 1598 | |
1016922 | 1016922 | 2021-02-10 | Humacao | Puerto Rico | 72069 | 1598 | |
1013677 | 1013677 | 2021-02-09 | Humacao | Puerto Rico | 72069 | 1596 | |
1010432 | 1010432 | 2021-02-08 | Humacao | Puerto Rico | 72069 | 1589 | |
1007186 | 1007186 | 2021-02-07 | Humacao | Puerto Rico | 72069 | 1580 | |
1003940 | 1003940 | 2021-02-06 | Humacao | Puerto Rico | 72069 | 1574 | |
1000694 | 1000694 | 2021-02-05 | Humacao | Puerto Rico | 72069 | 1573 | |
997448 | 997448 | 2021-02-04 | Humacao | Puerto Rico | 72069 | 1573 | |
994202 | 994202 | 2021-02-03 | Humacao | Puerto Rico | 72069 | 1571 | |
990956 | 990956 | 2021-02-02 | Humacao | Puerto Rico | 72069 | 1566 | |
987710 | 987710 | 2021-02-01 | Humacao | Puerto Rico | 72069 | 1562 | |
984463 | 984463 | 2021-01-31 | Humacao | Puerto Rico | 72069 | 1552 | |
981216 | 981216 | 2021-01-30 | Humacao | Puerto Rico | 72069 | 1547 | |
977970 | 977970 | 2021-01-29 | Humacao | Puerto Rico | 72069 | 1537 | |
974725 | 974725 | 2021-01-28 | Humacao | Puerto Rico | 72069 | 1533 | |
971480 | 971480 | 2021-01-27 | Humacao | Puerto Rico | 72069 | 1529 | |
968235 | 968235 | 2021-01-26 | Humacao | Puerto Rico | 72069 | 1528 | |
964991 | 964991 | 2021-01-25 | Humacao | Puerto Rico | 72069 | 1519 | |
961746 | 961746 | 2021-01-24 | Humacao | Puerto Rico | 72069 | 1503 | |
958501 | 958501 | 2021-01-23 | Humacao | Puerto Rico | 72069 | 1484 | |
955255 | 955255 | 2021-01-22 | Humacao | Puerto Rico | 72069 | 1470 | |
952010 | 952010 | 2021-01-21 | Humacao | Puerto Rico | 72069 | 1468 | |
948765 | 948765 | 2021-01-20 | Humacao | Puerto Rico | 72069 | 1467 | |
945519 | 945519 | 2021-01-19 | Humacao | Puerto Rico | 72069 | 1467 | |
942272 | 942272 | 2021-01-18 | Humacao | Puerto Rico | 72069 | 1464 | |
939027 | 939027 | 2021-01-17 | Humacao | Puerto Rico | 72069 | 1460 | |
935782 | 935782 | 2021-01-16 | Humacao | Puerto Rico | 72069 | 1446 | |
932537 | 932537 | 2021-01-15 | Humacao | Puerto Rico | 72069 | 1439 | |
929292 | 929292 | 2021-01-14 | Humacao | Puerto Rico | 72069 | 1420 | |
926047 | 926047 | 2021-01-13 | Humacao | Puerto Rico | 72069 | 1420 | |
922801 | 922801 | 2021-01-12 | Humacao | Puerto Rico | 72069 | 1419 | |
919556 | 919556 | 2021-01-11 | Humacao | Puerto Rico | 72069 | 1407 | |
916311 | 916311 | 2021-01-10 | Humacao | Puerto Rico | 72069 | 1404 | |
913066 | 913066 | 2021-01-09 | Humacao | Puerto Rico | 72069 | 1400 | |
909821 | 909821 | 2021-01-08 | Humacao | Puerto Rico | 72069 | 1392 | |
906576 | 906576 | 2021-01-07 | Humacao | Puerto Rico | 72069 | 1351 | |
903330 | 903330 | 2021-01-06 | Humacao | Puerto Rico | 72069 | 1351 | |
900085 | 900085 | 2021-01-05 | Humacao | Puerto Rico | 72069 | 1347 | |
896840 | 896840 | 2021-01-04 | Humacao | Puerto Rico | 72069 | 1345 | |
893594 | 893594 | 2021-01-03 | Humacao | Puerto Rico | 72069 | 1343 | |
890348 | 890348 | 2021-01-02 | Humacao | Puerto Rico | 72069 | 1343 | |
887101 | 887101 | 2021-01-01 | Humacao | Puerto Rico | 72069 | 1339 | |
883856 | 883856 | 2020-12-31 | Humacao | Puerto Rico | 72069 | 1322 | |
880611 | 880611 | 2020-12-30 | Humacao | Puerto Rico | 72069 | 1319 | |
877366 | 877366 | 2020-12-29 | Humacao | Puerto Rico | 72069 | 1318 | |
874121 | 874121 | 2020-12-28 | Humacao | Puerto Rico | 72069 | 1252 | |
870876 | 870876 | 2020-12-27 | Humacao | Puerto Rico | 72069 | 1224 | |
867631 | 867631 | 2020-12-26 | Humacao | Puerto Rico | 72069 | 1200 | |
864386 | 864386 | 2020-12-25 | Humacao | Puerto Rico | 72069 | 1184 | |
861141 | 861141 | 2020-12-24 | Humacao | Puerto Rico | 72069 | 1181 | |
857896 | 857896 | 2020-12-23 | Humacao | Puerto Rico | 72069 | 1179 | |
854651 | 854651 | 2020-12-22 | Humacao | Puerto Rico | 72069 | 1163 | |
851406 | 851406 | 2020-12-21 | Humacao | Puerto Rico | 72069 | 1145 | |
848161 | 848161 | 2020-12-20 | Humacao | Puerto Rico | 72069 | 1136 | |
844916 | 844916 | 2020-12-19 | Humacao | Puerto Rico | 72069 | 1126 | |
841670 | 841670 | 2020-12-18 | Humacao | Puerto Rico | 72069 | 1116 | |
838425 | 838425 | 2020-12-17 | Humacao | Puerto Rico | 72069 | 1110 | |
835179 | 835179 | 2020-12-16 | Humacao | Puerto Rico | 72069 | 1095 | |
831933 | 831933 | 2020-12-15 | Humacao | Puerto Rico | 72069 | 1093 | |
828686 | 828686 | 2020-12-14 | Humacao | Puerto Rico | 72069 | 1092 | |
825440 | 825440 | 2020-12-13 | Humacao | Puerto Rico | 72069 | 1089 | |
822193 | 822193 | 2020-12-12 | Humacao | Puerto Rico | 72069 | 1077 | |
818947 | 818947 | 2020-12-11 | Humacao | Puerto Rico | 72069 | 1067 | |
815701 | 815701 | 2020-12-10 | Humacao | Puerto Rico | 72069 | 1060 | |
812455 | 812455 | 2020-12-09 | Humacao | Puerto Rico | 72069 | 1059 | |
809211 | 809211 | 2020-12-08 | Humacao | Puerto Rico | 72069 | 1054 | |
805966 | 805966 | 2020-12-07 | Humacao | Puerto Rico | 72069 | 1049 | |
802721 | 802721 | 2020-12-06 | Humacao | Puerto Rico | 72069 | 1043 | |
799476 | 799476 | 2020-12-05 | Humacao | Puerto Rico | 72069 | 1034 | |
796231 | 796231 | 2020-12-04 | Humacao | Puerto Rico | 72069 | 1029 | |
792986 | 792986 | 2020-12-03 | Humacao | Puerto Rico | 72069 | 1025 | |
789741 | 789741 | 2020-12-02 | Humacao | Puerto Rico | 72069 | 1014 | |
786496 | 786496 | 2020-12-01 | Humacao | Puerto Rico | 72069 | 1007 | |
783252 | 783252 | 2020-11-30 | Humacao | Puerto Rico | 72069 | 1005 | |
780007 | 780007 | 2020-11-29 | Humacao | Puerto Rico | 72069 | 999 | |
776761 | 776761 | 2020-11-28 | Humacao | Puerto Rico | 72069 | 1000 | |
773516 | 773516 | 2020-11-27 | Humacao | Puerto Rico | 72069 | 995 | |
770271 | 770271 | 2020-11-26 | Humacao | Puerto Rico | 72069 | 983 | |
767025 | 767025 | 2020-11-25 | Humacao | Puerto Rico | 72069 | 974 | |
763780 | 763780 | 2020-11-24 | Humacao | Puerto Rico | 72069 | 972 | |
760535 | 760535 | 2020-11-23 | Humacao | Puerto Rico | 72069 | 964 | |
757290 | 757290 | 2020-11-22 | Humacao | Puerto Rico | 72069 | 958 | |
754043 | 754043 | 2020-11-21 | Humacao | Puerto Rico | 72069 | 952 | |
750797 | 750797 | 2020-11-20 | Humacao | Puerto Rico | 72069 | 944 | |
747551 | 747551 | 2020-11-19 | Humacao | Puerto Rico | 72069 | 932 | |
744305 | 744305 | 2020-11-18 | Humacao | Puerto Rico | 72069 | 930 |
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);