ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72097 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 |
---|---|---|---|---|---|---|---|
1065620 | 1065620 | 2021-02-25 | Mayaguez | Puerto Rico | 72097 | 1956 | |
1062375 | 1062375 | 2021-02-24 | Mayaguez | Puerto Rico | 72097 | 1956 | |
1059130 | 1059130 | 2021-02-23 | Mayaguez | Puerto Rico | 72097 | 1954 | |
1055884 | 1055884 | 2021-02-22 | Mayaguez | Puerto Rico | 72097 | 1948 | |
1052638 | 1052638 | 2021-02-21 | Mayaguez | Puerto Rico | 72097 | 1947 | |
1049391 | 1049391 | 2021-02-20 | Mayaguez | Puerto Rico | 72097 | 1942 | |
1046144 | 1046144 | 2021-02-19 | Mayaguez | Puerto Rico | 72097 | 1934 | |
1042899 | 1042899 | 2021-02-18 | Mayaguez | Puerto Rico | 72097 | 1930 | |
1039654 | 1039654 | 2021-02-17 | Mayaguez | Puerto Rico | 72097 | 1928 | |
1036409 | 1036409 | 2021-02-16 | Mayaguez | Puerto Rico | 72097 | 1925 | |
1033164 | 1033164 | 2021-02-15 | Mayaguez | Puerto Rico | 72097 | 1923 | |
1029918 | 1029918 | 2021-02-14 | Mayaguez | Puerto Rico | 72097 | 1920 | |
1026671 | 1026671 | 2021-02-13 | Mayaguez | Puerto Rico | 72097 | 1911 | |
1023426 | 1023426 | 2021-02-12 | Mayaguez | Puerto Rico | 72097 | 1897 | |
1020181 | 1020181 | 2021-02-11 | Mayaguez | Puerto Rico | 72097 | 1891 | |
1016936 | 1016936 | 2021-02-10 | Mayaguez | Puerto Rico | 72097 | 1886 | |
1013691 | 1013691 | 2021-02-09 | Mayaguez | Puerto Rico | 72097 | 1883 | |
1010446 | 1010446 | 2021-02-08 | Mayaguez | Puerto Rico | 72097 | 1878 | |
1007200 | 1007200 | 2021-02-07 | Mayaguez | Puerto Rico | 72097 | 1868 | |
1003954 | 1003954 | 2021-02-06 | Mayaguez | Puerto Rico | 72097 | 1857 | |
1000708 | 1000708 | 2021-02-05 | Mayaguez | Puerto Rico | 72097 | 1854 | |
997462 | 997462 | 2021-02-04 | Mayaguez | Puerto Rico | 72097 | 1852 | |
994216 | 994216 | 2021-02-03 | Mayaguez | Puerto Rico | 72097 | 1844 | |
990970 | 990970 | 2021-02-02 | Mayaguez | Puerto Rico | 72097 | 1843 | |
987724 | 987724 | 2021-02-01 | Mayaguez | Puerto Rico | 72097 | 1841 | |
984477 | 984477 | 2021-01-31 | Mayaguez | Puerto Rico | 72097 | 1821 | |
981230 | 981230 | 2021-01-30 | Mayaguez | Puerto Rico | 72097 | 1820 | |
977984 | 977984 | 2021-01-29 | Mayaguez | Puerto Rico | 72097 | 1817 | |
974739 | 974739 | 2021-01-28 | Mayaguez | Puerto Rico | 72097 | 1811 | |
971494 | 971494 | 2021-01-27 | Mayaguez | Puerto Rico | 72097 | 1801 | |
968249 | 968249 | 2021-01-26 | Mayaguez | Puerto Rico | 72097 | 1798 | |
965005 | 965005 | 2021-01-25 | Mayaguez | Puerto Rico | 72097 | 1778 | |
961760 | 961760 | 2021-01-24 | Mayaguez | Puerto Rico | 72097 | 1770 | |
958515 | 958515 | 2021-01-23 | Mayaguez | Puerto Rico | 72097 | 1719 | |
955269 | 955269 | 2021-01-22 | Mayaguez | Puerto Rico | 72097 | 1717 | |
952024 | 952024 | 2021-01-21 | Mayaguez | Puerto Rico | 72097 | 1709 | |
948779 | 948779 | 2021-01-20 | Mayaguez | Puerto Rico | 72097 | 1708 | |
945533 | 945533 | 2021-01-19 | Mayaguez | Puerto Rico | 72097 | 1701 | |
942286 | 942286 | 2021-01-18 | Mayaguez | Puerto Rico | 72097 | 1694 | |
939041 | 939041 | 2021-01-17 | Mayaguez | Puerto Rico | 72097 | 1686 | |
935796 | 935796 | 2021-01-16 | Mayaguez | Puerto Rico | 72097 | 1673 | |
932551 | 932551 | 2021-01-15 | Mayaguez | Puerto Rico | 72097 | 1664 | |
929306 | 929306 | 2021-01-14 | Mayaguez | Puerto Rico | 72097 | 1638 | |
926061 | 926061 | 2021-01-13 | Mayaguez | Puerto Rico | 72097 | 1637 | |
922815 | 922815 | 2021-01-12 | Mayaguez | Puerto Rico | 72097 | 1636 | |
919570 | 919570 | 2021-01-11 | Mayaguez | Puerto Rico | 72097 | 1630 | |
916325 | 916325 | 2021-01-10 | Mayaguez | Puerto Rico | 72097 | 1623 | |
913080 | 913080 | 2021-01-09 | Mayaguez | Puerto Rico | 72097 | 1618 | |
909835 | 909835 | 2021-01-08 | Mayaguez | Puerto Rico | 72097 | 1613 | |
906590 | 906590 | 2021-01-07 | Mayaguez | Puerto Rico | 72097 | 1603 | |
903344 | 903344 | 2021-01-06 | Mayaguez | Puerto Rico | 72097 | 1599 | |
900099 | 900099 | 2021-01-05 | Mayaguez | Puerto Rico | 72097 | 1596 | |
896854 | 896854 | 2021-01-04 | Mayaguez | Puerto Rico | 72097 | 1594 | |
893608 | 893608 | 2021-01-03 | Mayaguez | Puerto Rico | 72097 | 1585 | |
890362 | 890362 | 2021-01-02 | Mayaguez | Puerto Rico | 72097 | 1580 | |
887115 | 887115 | 2021-01-01 | Mayaguez | Puerto Rico | 72097 | 1574 | |
883870 | 883870 | 2020-12-31 | Mayaguez | Puerto Rico | 72097 | 1570 | |
880625 | 880625 | 2020-12-30 | Mayaguez | Puerto Rico | 72097 | 1568 | |
877380 | 877380 | 2020-12-29 | Mayaguez | Puerto Rico | 72097 | 1568 | |
874135 | 874135 | 2020-12-28 | Mayaguez | Puerto Rico | 72097 | 1516 | |
870890 | 870890 | 2020-12-27 | Mayaguez | Puerto Rico | 72097 | 1514 | |
867645 | 867645 | 2020-12-26 | Mayaguez | Puerto Rico | 72097 | 1508 | |
864400 | 864400 | 2020-12-25 | Mayaguez | Puerto Rico | 72097 | 1500 | |
861155 | 861155 | 2020-12-24 | Mayaguez | Puerto Rico | 72097 | 1492 | |
857910 | 857910 | 2020-12-23 | Mayaguez | Puerto Rico | 72097 | 1489 | |
854665 | 854665 | 2020-12-22 | Mayaguez | Puerto Rico | 72097 | 1481 | |
851420 | 851420 | 2020-12-21 | Mayaguez | Puerto Rico | 72097 | 1472 | |
848175 | 848175 | 2020-12-20 | Mayaguez | Puerto Rico | 72097 | 1468 | |
844930 | 844930 | 2020-12-19 | Mayaguez | Puerto Rico | 72097 | 1457 | |
841684 | 841684 | 2020-12-18 | Mayaguez | Puerto Rico | 72097 | 1450 | |
838439 | 838439 | 2020-12-17 | Mayaguez | Puerto Rico | 72097 | 1435 | |
835193 | 835193 | 2020-12-16 | Mayaguez | Puerto Rico | 72097 | 1413 | |
831947 | 831947 | 2020-12-15 | Mayaguez | Puerto Rico | 72097 | 1412 | |
828700 | 828700 | 2020-12-14 | Mayaguez | Puerto Rico | 72097 | 1410 | |
825454 | 825454 | 2020-12-13 | Mayaguez | Puerto Rico | 72097 | 1403 | |
822207 | 822207 | 2020-12-12 | Mayaguez | Puerto Rico | 72097 | 1400 | |
818961 | 818961 | 2020-12-11 | Mayaguez | Puerto Rico | 72097 | 1392 | |
815715 | 815715 | 2020-12-10 | Mayaguez | Puerto Rico | 72097 | 1372 | |
812469 | 812469 | 2020-12-09 | Mayaguez | Puerto Rico | 72097 | 1366 | |
809225 | 809225 | 2020-12-08 | Mayaguez | Puerto Rico | 72097 | 1359 | |
805980 | 805980 | 2020-12-07 | Mayaguez | Puerto Rico | 72097 | 1352 | |
802735 | 802735 | 2020-12-06 | Mayaguez | Puerto Rico | 72097 | 1344 | |
799490 | 799490 | 2020-12-05 | Mayaguez | Puerto Rico | 72097 | 1336 | |
796245 | 796245 | 2020-12-04 | Mayaguez | Puerto Rico | 72097 | 1321 | |
793000 | 793000 | 2020-12-03 | Mayaguez | Puerto Rico | 72097 | 1312 | |
789755 | 789755 | 2020-12-02 | Mayaguez | Puerto Rico | 72097 | 1306 | |
786510 | 786510 | 2020-12-01 | Mayaguez | Puerto Rico | 72097 | 1303 | |
783266 | 783266 | 2020-11-30 | Mayaguez | Puerto Rico | 72097 | 1295 | |
780021 | 780021 | 2020-11-29 | Mayaguez | Puerto Rico | 72097 | 1295 | |
776775 | 776775 | 2020-11-28 | Mayaguez | Puerto Rico | 72097 | 1293 | |
773530 | 773530 | 2020-11-27 | Mayaguez | Puerto Rico | 72097 | 1279 | |
770285 | 770285 | 2020-11-26 | Mayaguez | Puerto Rico | 72097 | 1257 | |
767039 | 767039 | 2020-11-25 | Mayaguez | Puerto Rico | 72097 | 1249 | |
763794 | 763794 | 2020-11-24 | Mayaguez | Puerto Rico | 72097 | 1246 | |
760549 | 760549 | 2020-11-23 | Mayaguez | Puerto Rico | 72097 | 1246 | |
757304 | 757304 | 2020-11-22 | Mayaguez | Puerto Rico | 72097 | 1241 | |
754057 | 754057 | 2020-11-21 | Mayaguez | Puerto Rico | 72097 | 1223 | |
750811 | 750811 | 2020-11-20 | Mayaguez | Puerto Rico | 72097 | 1188 | |
747565 | 747565 | 2020-11-19 | Mayaguez | Puerto Rico | 72097 | 1177 | |
744319 | 744319 | 2020-11-18 | Mayaguez | Puerto Rico | 72097 | 1173 |
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);