ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Gurabo" 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 |
---|---|---|---|---|---|---|---|
1065603 | 1065603 | 2021-02-25 | Gurabo | Puerto Rico | 72063 | 1839 | |
1062358 | 1062358 | 2021-02-24 | Gurabo | Puerto Rico | 72063 | 1839 | |
1059113 | 1059113 | 2021-02-23 | Gurabo | Puerto Rico | 72063 | 1837 | |
1055867 | 1055867 | 2021-02-22 | Gurabo | Puerto Rico | 72063 | 1833 | |
1052621 | 1052621 | 2021-02-21 | Gurabo | Puerto Rico | 72063 | 1825 | |
1049374 | 1049374 | 2021-02-20 | Gurabo | Puerto Rico | 72063 | 1824 | |
1046127 | 1046127 | 2021-02-19 | Gurabo | Puerto Rico | 72063 | 1800 | |
1042882 | 1042882 | 2021-02-18 | Gurabo | Puerto Rico | 72063 | 1798 | |
1039637 | 1039637 | 2021-02-17 | Gurabo | Puerto Rico | 72063 | 1795 | |
1036392 | 1036392 | 2021-02-16 | Gurabo | Puerto Rico | 72063 | 1793 | |
1033147 | 1033147 | 2021-02-15 | Gurabo | Puerto Rico | 72063 | 1779 | |
1029901 | 1029901 | 2021-02-14 | Gurabo | Puerto Rico | 72063 | 1776 | |
1026654 | 1026654 | 2021-02-13 | Gurabo | Puerto Rico | 72063 | 1772 | |
1023409 | 1023409 | 2021-02-12 | Gurabo | Puerto Rico | 72063 | 1766 | |
1020164 | 1020164 | 2021-02-11 | Gurabo | Puerto Rico | 72063 | 1759 | |
1016919 | 1016919 | 2021-02-10 | Gurabo | Puerto Rico | 72063 | 1754 | |
1013674 | 1013674 | 2021-02-09 | Gurabo | Puerto Rico | 72063 | 1752 | |
1010429 | 1010429 | 2021-02-08 | Gurabo | Puerto Rico | 72063 | 1746 | |
1007183 | 1007183 | 2021-02-07 | Gurabo | Puerto Rico | 72063 | 1737 | |
1003937 | 1003937 | 2021-02-06 | Gurabo | Puerto Rico | 72063 | 1710 | |
1000691 | 1000691 | 2021-02-05 | Gurabo | Puerto Rico | 72063 | 1702 | |
997445 | 997445 | 2021-02-04 | Gurabo | Puerto Rico | 72063 | 1700 | |
994199 | 994199 | 2021-02-03 | Gurabo | Puerto Rico | 72063 | 1694 | |
990953 | 990953 | 2021-02-02 | Gurabo | Puerto Rico | 72063 | 1692 | |
987707 | 987707 | 2021-02-01 | Gurabo | Puerto Rico | 72063 | 1684 | |
984460 | 984460 | 2021-01-31 | Gurabo | Puerto Rico | 72063 | 1671 | |
981213 | 981213 | 2021-01-30 | Gurabo | Puerto Rico | 72063 | 1670 | |
977967 | 977967 | 2021-01-29 | Gurabo | Puerto Rico | 72063 | 1666 | |
974722 | 974722 | 2021-01-28 | Gurabo | Puerto Rico | 72063 | 1661 | |
971477 | 971477 | 2021-01-27 | Gurabo | Puerto Rico | 72063 | 1657 | |
968232 | 968232 | 2021-01-26 | Gurabo | Puerto Rico | 72063 | 1656 | |
964988 | 964988 | 2021-01-25 | Gurabo | Puerto Rico | 72063 | 1656 | |
961743 | 961743 | 2021-01-24 | Gurabo | Puerto Rico | 72063 | 1642 | |
958498 | 958498 | 2021-01-23 | Gurabo | Puerto Rico | 72063 | 1622 | |
955252 | 955252 | 2021-01-22 | Gurabo | Puerto Rico | 72063 | 1611 | |
952007 | 952007 | 2021-01-21 | Gurabo | Puerto Rico | 72063 | 1606 | |
948762 | 948762 | 2021-01-20 | Gurabo | Puerto Rico | 72063 | 1605 | |
945516 | 945516 | 2021-01-19 | Gurabo | Puerto Rico | 72063 | 1601 | |
942269 | 942269 | 2021-01-18 | Gurabo | Puerto Rico | 72063 | 1598 | |
939024 | 939024 | 2021-01-17 | Gurabo | Puerto Rico | 72063 | 1594 | |
935779 | 935779 | 2021-01-16 | Gurabo | Puerto Rico | 72063 | 1584 | |
932534 | 932534 | 2021-01-15 | Gurabo | Puerto Rico | 72063 | 1574 | |
929289 | 929289 | 2021-01-14 | Gurabo | Puerto Rico | 72063 | 1559 | |
926044 | 926044 | 2021-01-13 | Gurabo | Puerto Rico | 72063 | 1558 | |
922798 | 922798 | 2021-01-12 | Gurabo | Puerto Rico | 72063 | 1557 | |
919553 | 919553 | 2021-01-11 | Gurabo | Puerto Rico | 72063 | 1539 | |
916308 | 916308 | 2021-01-10 | Gurabo | Puerto Rico | 72063 | 1538 | |
913063 | 913063 | 2021-01-09 | Gurabo | Puerto Rico | 72063 | 1533 | |
909818 | 909818 | 2021-01-08 | Gurabo | Puerto Rico | 72063 | 1521 | |
906573 | 906573 | 2021-01-07 | Gurabo | Puerto Rico | 72063 | 1496 | |
903327 | 903327 | 2021-01-06 | Gurabo | Puerto Rico | 72063 | 1493 | |
900082 | 900082 | 2021-01-05 | Gurabo | Puerto Rico | 72063 | 1489 | |
896837 | 896837 | 2021-01-04 | Gurabo | Puerto Rico | 72063 | 1483 | |
893591 | 893591 | 2021-01-03 | Gurabo | Puerto Rico | 72063 | 1480 | |
890345 | 890345 | 2021-01-02 | Gurabo | Puerto Rico | 72063 | 1477 | |
887098 | 887098 | 2021-01-01 | Gurabo | Puerto Rico | 72063 | 1462 | |
883853 | 883853 | 2020-12-31 | Gurabo | Puerto Rico | 72063 | 1452 | |
880608 | 880608 | 2020-12-30 | Gurabo | Puerto Rico | 72063 | 1452 | |
877363 | 877363 | 2020-12-29 | Gurabo | Puerto Rico | 72063 | 1451 | |
874118 | 874118 | 2020-12-28 | Gurabo | Puerto Rico | 72063 | 1383 | |
870873 | 870873 | 2020-12-27 | Gurabo | Puerto Rico | 72063 | 1349 | |
867628 | 867628 | 2020-12-26 | Gurabo | Puerto Rico | 72063 | 1344 | |
864383 | 864383 | 2020-12-25 | Gurabo | Puerto Rico | 72063 | 1336 | |
861138 | 861138 | 2020-12-24 | Gurabo | Puerto Rico | 72063 | 1332 | |
857893 | 857893 | 2020-12-23 | Gurabo | Puerto Rico | 72063 | 1332 | |
854648 | 854648 | 2020-12-22 | Gurabo | Puerto Rico | 72063 | 1314 | |
851403 | 851403 | 2020-12-21 | Gurabo | Puerto Rico | 72063 | 1299 | |
848158 | 848158 | 2020-12-20 | Gurabo | Puerto Rico | 72063 | 1291 | |
844913 | 844913 | 2020-12-19 | Gurabo | Puerto Rico | 72063 | 1275 | |
841667 | 841667 | 2020-12-18 | Gurabo | Puerto Rico | 72063 | 1257 | |
838422 | 838422 | 2020-12-17 | Gurabo | Puerto Rico | 72063 | 1242 | |
835176 | 835176 | 2020-12-16 | Gurabo | Puerto Rico | 72063 | 1228 | |
831930 | 831930 | 2020-12-15 | Gurabo | Puerto Rico | 72063 | 1220 | |
828683 | 828683 | 2020-12-14 | Gurabo | Puerto Rico | 72063 | 1212 | |
825437 | 825437 | 2020-12-13 | Gurabo | Puerto Rico | 72063 | 1209 | |
822190 | 822190 | 2020-12-12 | Gurabo | Puerto Rico | 72063 | 1207 | |
818944 | 818944 | 2020-12-11 | Gurabo | Puerto Rico | 72063 | 1199 | |
815698 | 815698 | 2020-12-10 | Gurabo | Puerto Rico | 72063 | 1175 | |
812452 | 812452 | 2020-12-09 | Gurabo | Puerto Rico | 72063 | 1168 | |
809208 | 809208 | 2020-12-08 | Gurabo | Puerto Rico | 72063 | 1160 | |
805963 | 805963 | 2020-12-07 | Gurabo | Puerto Rico | 72063 | 1148 | |
802718 | 802718 | 2020-12-06 | Gurabo | Puerto Rico | 72063 | 1141 | |
799473 | 799473 | 2020-12-05 | Gurabo | Puerto Rico | 72063 | 1131 | |
796228 | 796228 | 2020-12-04 | Gurabo | Puerto Rico | 72063 | 1118 | |
792983 | 792983 | 2020-12-03 | Gurabo | Puerto Rico | 72063 | 1113 | |
789738 | 789738 | 2020-12-02 | Gurabo | Puerto Rico | 72063 | 1111 | |
786493 | 786493 | 2020-12-01 | Gurabo | Puerto Rico | 72063 | 1069 | |
783249 | 783249 | 2020-11-30 | Gurabo | Puerto Rico | 72063 | 1060 | |
780004 | 780004 | 2020-11-29 | Gurabo | Puerto Rico | 72063 | 1042 | |
776758 | 776758 | 2020-11-28 | Gurabo | Puerto Rico | 72063 | 1040 | |
773513 | 773513 | 2020-11-27 | Gurabo | Puerto Rico | 72063 | 1026 | |
770268 | 770268 | 2020-11-26 | Gurabo | Puerto Rico | 72063 | 1008 | |
767022 | 767022 | 2020-11-25 | Gurabo | Puerto Rico | 72063 | 1003 | |
763777 | 763777 | 2020-11-24 | Gurabo | Puerto Rico | 72063 | 1002 | |
760532 | 760532 | 2020-11-23 | Gurabo | Puerto Rico | 72063 | 1000 | |
757287 | 757287 | 2020-11-22 | Gurabo | Puerto Rico | 72063 | 996 | |
754040 | 754040 | 2020-11-21 | Gurabo | Puerto Rico | 72063 | 985 | |
750794 | 750794 | 2020-11-20 | Gurabo | Puerto Rico | 72063 | 965 | |
747548 | 747548 | 2020-11-19 | Gurabo | Puerto Rico | 72063 | 950 | |
744302 | 744302 | 2020-11-18 | Gurabo | Puerto Rico | 72063 | 943 |
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);