ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72029 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 |
---|---|---|---|---|---|---|---|
922780 | 922780 | 2021-01-12 | Canovanas | Puerto Rico | 72029 | 1561 | |
919535 | 919535 | 2021-01-11 | Canovanas | Puerto Rico | 72029 | 1545 | |
916290 | 916290 | 2021-01-10 | Canovanas | Puerto Rico | 72029 | 1541 | |
913045 | 913045 | 2021-01-09 | Canovanas | Puerto Rico | 72029 | 1531 | |
909800 | 909800 | 2021-01-08 | Canovanas | Puerto Rico | 72029 | 1525 | |
906555 | 906555 | 2021-01-07 | Canovanas | Puerto Rico | 72029 | 1500 | |
903309 | 903309 | 2021-01-06 | Canovanas | Puerto Rico | 72029 | 1491 | |
900064 | 900064 | 2021-01-05 | Canovanas | Puerto Rico | 72029 | 1479 | |
896819 | 896819 | 2021-01-04 | Canovanas | Puerto Rico | 72029 | 1471 | |
893573 | 893573 | 2021-01-03 | Canovanas | Puerto Rico | 72029 | 1467 | |
890327 | 890327 | 2021-01-02 | Canovanas | Puerto Rico | 72029 | 1465 | |
887080 | 887080 | 2021-01-01 | Canovanas | Puerto Rico | 72029 | 1456 | |
883835 | 883835 | 2020-12-31 | Canovanas | Puerto Rico | 72029 | 1444 | |
880590 | 880590 | 2020-12-30 | Canovanas | Puerto Rico | 72029 | 1437 | |
877345 | 877345 | 2020-12-29 | Canovanas | Puerto Rico | 72029 | 1436 | |
874100 | 874100 | 2020-12-28 | Canovanas | Puerto Rico | 72029 | 1410 | |
870855 | 870855 | 2020-12-27 | Canovanas | Puerto Rico | 72029 | 1409 | |
867610 | 867610 | 2020-12-26 | Canovanas | Puerto Rico | 72029 | 1399 | |
864365 | 864365 | 2020-12-25 | Canovanas | Puerto Rico | 72029 | 1392 | |
861120 | 861120 | 2020-12-24 | Canovanas | Puerto Rico | 72029 | 1386 | |
857875 | 857875 | 2020-12-23 | Canovanas | Puerto Rico | 72029 | 1382 | |
854630 | 854630 | 2020-12-22 | Canovanas | Puerto Rico | 72029 | 1375 | |
851385 | 851385 | 2020-12-21 | Canovanas | Puerto Rico | 72029 | 1361 | |
848140 | 848140 | 2020-12-20 | Canovanas | Puerto Rico | 72029 | 1352 | |
844895 | 844895 | 2020-12-19 | Canovanas | Puerto Rico | 72029 | 1335 | |
841649 | 841649 | 2020-12-18 | Canovanas | Puerto Rico | 72029 | 1327 | |
838404 | 838404 | 2020-12-17 | Canovanas | Puerto Rico | 72029 | 1318 | |
835158 | 835158 | 2020-12-16 | Canovanas | Puerto Rico | 72029 | 1306 | |
831912 | 831912 | 2020-12-15 | Canovanas | Puerto Rico | 72029 | 1305 | |
828665 | 828665 | 2020-12-14 | Canovanas | Puerto Rico | 72029 | 1290 | |
825419 | 825419 | 2020-12-13 | Canovanas | Puerto Rico | 72029 | 1285 | |
822172 | 822172 | 2020-12-12 | Canovanas | Puerto Rico | 72029 | 1273 | |
818926 | 818926 | 2020-12-11 | Canovanas | Puerto Rico | 72029 | 1266 | |
815680 | 815680 | 2020-12-10 | Canovanas | Puerto Rico | 72029 | 1255 | |
812434 | 812434 | 2020-12-09 | Canovanas | Puerto Rico | 72029 | 1252 | |
809190 | 809190 | 2020-12-08 | Canovanas | Puerto Rico | 72029 | 1249 | |
805945 | 805945 | 2020-12-07 | Canovanas | Puerto Rico | 72029 | 1243 | |
802700 | 802700 | 2020-12-06 | Canovanas | Puerto Rico | 72029 | 1236 | |
799455 | 799455 | 2020-12-05 | Canovanas | Puerto Rico | 72029 | 1221 | |
796210 | 796210 | 2020-12-04 | Canovanas | Puerto Rico | 72029 | 1211 | |
792965 | 792965 | 2020-12-03 | Canovanas | Puerto Rico | 72029 | 1205 | |
789720 | 789720 | 2020-12-02 | Canovanas | Puerto Rico | 72029 | 1183 | |
786475 | 786475 | 2020-12-01 | Canovanas | Puerto Rico | 72029 | 1178 | |
783231 | 783231 | 2020-11-30 | Canovanas | Puerto Rico | 72029 | 1172 | |
779986 | 779986 | 2020-11-29 | Canovanas | Puerto Rico | 72029 | 1165 | |
776740 | 776740 | 2020-11-28 | Canovanas | Puerto Rico | 72029 | 1163 | |
773495 | 773495 | 2020-11-27 | Canovanas | Puerto Rico | 72029 | 1153 | |
770250 | 770250 | 2020-11-26 | Canovanas | Puerto Rico | 72029 | 1125 | |
767004 | 767004 | 2020-11-25 | Canovanas | Puerto Rico | 72029 | 1119 | |
763759 | 763759 | 2020-11-24 | Canovanas | Puerto Rico | 72029 | 1117 | |
760514 | 760514 | 2020-11-23 | Canovanas | Puerto Rico | 72029 | 1116 | |
757269 | 757269 | 2020-11-22 | Canovanas | Puerto Rico | 72029 | 1111 | |
754022 | 754022 | 2020-11-21 | Canovanas | Puerto Rico | 72029 | 1096 | |
750776 | 750776 | 2020-11-20 | Canovanas | Puerto Rico | 72029 | 1084 | |
747530 | 747530 | 2020-11-19 | Canovanas | Puerto Rico | 72029 | 1076 | |
744284 | 744284 | 2020-11-18 | Canovanas | Puerto Rico | 72029 | 1072 | |
741037 | 741037 | 2020-11-17 | Canovanas | Puerto Rico | 72029 | 1068 | |
737791 | 737791 | 2020-11-16 | Canovanas | Puerto Rico | 72029 | 1060 | |
734547 | 734547 | 2020-11-15 | Canovanas | Puerto Rico | 72029 | 1055 | |
731301 | 731301 | 2020-11-14 | Canovanas | Puerto Rico | 72029 | 1048 | |
728057 | 728057 | 2020-11-13 | Canovanas | Puerto Rico | 72029 | 1045 | |
724813 | 724813 | 2020-11-12 | Canovanas | Puerto Rico | 72029 | 1043 | |
721570 | 721570 | 2020-11-11 | Canovanas | Puerto Rico | 72029 | 1028 | |
718327 | 718327 | 2020-11-10 | Canovanas | Puerto Rico | 72029 | 1025 | |
715084 | 715084 | 2020-11-09 | Canovanas | Puerto Rico | 72029 | 1019 | |
711840 | 711840 | 2020-11-08 | Canovanas | Puerto Rico | 72029 | 1008 | |
708596 | 708596 | 2020-11-07 | Canovanas | Puerto Rico | 72029 | 999 | |
705353 | 705353 | 2020-11-06 | Canovanas | Puerto Rico | 72029 | 999 | |
702110 | 702110 | 2020-11-05 | Canovanas | Puerto Rico | 72029 | 988 | |
698866 | 698866 | 2020-11-04 | Canovanas | Puerto Rico | 72029 | 982 | |
695623 | 695623 | 2020-11-03 | Canovanas | Puerto Rico | 72029 | 981 | |
692381 | 692381 | 2020-11-02 | Canovanas | Puerto Rico | 72029 | 970 | |
689137 | 689137 | 2020-11-01 | Canovanas | Puerto Rico | 72029 | 956 | |
685892 | 685892 | 2020-10-31 | Canovanas | Puerto Rico | 72029 | 952 | |
682649 | 682649 | 2020-10-30 | Canovanas | Puerto Rico | 72029 | 946 | |
679406 | 679406 | 2020-10-29 | Canovanas | Puerto Rico | 72029 | 942 | |
676163 | 676163 | 2020-10-28 | Canovanas | Puerto Rico | 72029 | 932 | |
672920 | 672920 | 2020-10-27 | Canovanas | Puerto Rico | 72029 | 930 | |
669678 | 669678 | 2020-10-26 | Canovanas | Puerto Rico | 72029 | 926 | |
666434 | 666434 | 2020-10-25 | Canovanas | Puerto Rico | 72029 | 907 | |
663189 | 663189 | 2020-10-24 | Canovanas | Puerto Rico | 72029 | 884 | |
659945 | 659945 | 2020-10-23 | Canovanas | Puerto Rico | 72029 | 883 | |
656701 | 656701 | 2020-10-22 | Canovanas | Puerto Rico | 72029 | 856 | |
653456 | 653456 | 2020-10-21 | Canovanas | Puerto Rico | 72029 | 850 | |
650211 | 650211 | 2020-10-20 | Canovanas | Puerto Rico | 72029 | 845 | |
646967 | 646967 | 2020-10-19 | Canovanas | Puerto Rico | 72029 | 816 | |
643721 | 643721 | 2020-10-18 | Canovanas | Puerto Rico | 72029 | 811 | |
640473 | 640473 | 2020-10-17 | Canovanas | Puerto Rico | 72029 | 800 | |
637227 | 637227 | 2020-10-16 | Canovanas | Puerto Rico | 72029 | 797 | |
633981 | 633981 | 2020-10-15 | Canovanas | Puerto Rico | 72029 | 794 | |
630736 | 630736 | 2020-10-14 | Canovanas | Puerto Rico | 72029 | 789 | |
627492 | 627492 | 2020-10-13 | Canovanas | Puerto Rico | 72029 | 776 | |
624250 | 624250 | 2020-10-12 | Canovanas | Puerto Rico | 72029 | 774 | |
621007 | 621007 | 2020-10-11 | Canovanas | Puerto Rico | 72029 | 769 | |
617764 | 617764 | 2020-10-10 | Canovanas | Puerto Rico | 72029 | 767 | |
614522 | 614522 | 2020-10-09 | Canovanas | Puerto Rico | 72029 | 766 | |
611281 | 611281 | 2020-10-08 | Canovanas | Puerto Rico | 72029 | 763 | |
608039 | 608039 | 2020-10-07 | Canovanas | Puerto Rico | 72029 | 757 | |
604796 | 604796 | 2020-10-06 | Canovanas | Puerto Rico | 72029 | 755 | |
601554 | 601554 | 2020-10-05 | Canovanas | Puerto Rico | 72029 | 748 |
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);