ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72041 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 |
---|---|---|---|---|---|---|---|
1055855 | 1055855 | 2021-02-22 | Cidra | Puerto Rico | 72041 | 1213 | |
1052609 | 1052609 | 2021-02-21 | Cidra | Puerto Rico | 72041 | 1210 | |
1049362 | 1049362 | 2021-02-20 | Cidra | Puerto Rico | 72041 | 1209 | |
1046115 | 1046115 | 2021-02-19 | Cidra | Puerto Rico | 72041 | 1207 | |
1042870 | 1042870 | 2021-02-18 | Cidra | Puerto Rico | 72041 | 1205 | |
1039625 | 1039625 | 2021-02-17 | Cidra | Puerto Rico | 72041 | 1205 | |
1036380 | 1036380 | 2021-02-16 | Cidra | Puerto Rico | 72041 | 1203 | |
1033135 | 1033135 | 2021-02-15 | Cidra | Puerto Rico | 72041 | 1199 | |
1029889 | 1029889 | 2021-02-14 | Cidra | Puerto Rico | 72041 | 1198 | |
1026642 | 1026642 | 2021-02-13 | Cidra | Puerto Rico | 72041 | 1195 | |
1023397 | 1023397 | 2021-02-12 | Cidra | Puerto Rico | 72041 | 1193 | |
1020152 | 1020152 | 2021-02-11 | Cidra | Puerto Rico | 72041 | 1188 | |
1016907 | 1016907 | 2021-02-10 | Cidra | Puerto Rico | 72041 | 1188 | |
1013662 | 1013662 | 2021-02-09 | Cidra | Puerto Rico | 72041 | 1186 | |
1010417 | 1010417 | 2021-02-08 | Cidra | Puerto Rico | 72041 | 1184 | |
1007171 | 1007171 | 2021-02-07 | Cidra | Puerto Rico | 72041 | 1180 | |
1003925 | 1003925 | 2021-02-06 | Cidra | Puerto Rico | 72041 | 1173 | |
1000679 | 1000679 | 2021-02-05 | Cidra | Puerto Rico | 72041 | 1170 | |
997433 | 997433 | 2021-02-04 | Cidra | Puerto Rico | 72041 | 1170 | |
994187 | 994187 | 2021-02-03 | Cidra | Puerto Rico | 72041 | 1169 | |
990941 | 990941 | 2021-02-02 | Cidra | Puerto Rico | 72041 | 1168 | |
987695 | 987695 | 2021-02-01 | Cidra | Puerto Rico | 72041 | 1166 | |
984448 | 984448 | 2021-01-31 | Cidra | Puerto Rico | 72041 | 1161 | |
981201 | 981201 | 2021-01-30 | Cidra | Puerto Rico | 72041 | 1159 | |
977955 | 977955 | 2021-01-29 | Cidra | Puerto Rico | 72041 | 1154 | |
974710 | 974710 | 2021-01-28 | Cidra | Puerto Rico | 72041 | 1148 | |
971465 | 971465 | 2021-01-27 | Cidra | Puerto Rico | 72041 | 1143 | |
968220 | 968220 | 2021-01-26 | Cidra | Puerto Rico | 72041 | 1143 | |
964976 | 964976 | 2021-01-25 | Cidra | Puerto Rico | 72041 | 1142 | |
961731 | 961731 | 2021-01-24 | Cidra | Puerto Rico | 72041 | 1134 | |
958486 | 958486 | 2021-01-23 | Cidra | Puerto Rico | 72041 | 1121 | |
955240 | 955240 | 2021-01-22 | Cidra | Puerto Rico | 72041 | 1109 | |
951995 | 951995 | 2021-01-21 | Cidra | Puerto Rico | 72041 | 1102 | |
948750 | 948750 | 2021-01-20 | Cidra | Puerto Rico | 72041 | 1098 | |
945504 | 945504 | 2021-01-19 | Cidra | Puerto Rico | 72041 | 1097 | |
942257 | 942257 | 2021-01-18 | Cidra | Puerto Rico | 72041 | 1093 | |
939012 | 939012 | 2021-01-17 | Cidra | Puerto Rico | 72041 | 1087 | |
935767 | 935767 | 2021-01-16 | Cidra | Puerto Rico | 72041 | 1074 | |
932522 | 932522 | 2021-01-15 | Cidra | Puerto Rico | 72041 | 1069 | |
929277 | 929277 | 2021-01-14 | Cidra | Puerto Rico | 72041 | 1058 | |
926032 | 926032 | 2021-01-13 | Cidra | Puerto Rico | 72041 | 1048 | |
922786 | 922786 | 2021-01-12 | Cidra | Puerto Rico | 72041 | 1046 | |
919541 | 919541 | 2021-01-11 | Cidra | Puerto Rico | 72041 | 1030 | |
916296 | 916296 | 2021-01-10 | Cidra | Puerto Rico | 72041 | 1018 | |
913051 | 913051 | 2021-01-09 | Cidra | Puerto Rico | 72041 | 1009 | |
909806 | 909806 | 2021-01-08 | Cidra | Puerto Rico | 72041 | 1006 | |
906561 | 906561 | 2021-01-07 | Cidra | Puerto Rico | 72041 | 994 | |
903315 | 903315 | 2021-01-06 | Cidra | Puerto Rico | 72041 | 989 | |
900070 | 900070 | 2021-01-05 | Cidra | Puerto Rico | 72041 | 987 | |
896825 | 896825 | 2021-01-04 | Cidra | Puerto Rico | 72041 | 983 | |
893579 | 893579 | 2021-01-03 | Cidra | Puerto Rico | 72041 | 977 | |
890333 | 890333 | 2021-01-02 | Cidra | Puerto Rico | 72041 | 972 | |
887086 | 887086 | 2021-01-01 | Cidra | Puerto Rico | 72041 | 966 | |
883841 | 883841 | 2020-12-31 | Cidra | Puerto Rico | 72041 | 957 | |
880596 | 880596 | 2020-12-30 | Cidra | Puerto Rico | 72041 | 936 | |
877351 | 877351 | 2020-12-29 | Cidra | Puerto Rico | 72041 | 935 | |
874106 | 874106 | 2020-12-28 | Cidra | Puerto Rico | 72041 | 912 | |
870861 | 870861 | 2020-12-27 | Cidra | Puerto Rico | 72041 | 908 | |
867616 | 867616 | 2020-12-26 | Cidra | Puerto Rico | 72041 | 895 | |
864371 | 864371 | 2020-12-25 | Cidra | Puerto Rico | 72041 | 885 | |
861126 | 861126 | 2020-12-24 | Cidra | Puerto Rico | 72041 | 877 | |
857881 | 857881 | 2020-12-23 | Cidra | Puerto Rico | 72041 | 866 | |
854636 | 854636 | 2020-12-22 | Cidra | Puerto Rico | 72041 | 857 | |
851391 | 851391 | 2020-12-21 | Cidra | Puerto Rico | 72041 | 845 | |
848146 | 848146 | 2020-12-20 | Cidra | Puerto Rico | 72041 | 840 | |
844901 | 844901 | 2020-12-19 | Cidra | Puerto Rico | 72041 | 823 | |
841655 | 841655 | 2020-12-18 | Cidra | Puerto Rico | 72041 | 809 | |
838410 | 838410 | 2020-12-17 | Cidra | Puerto Rico | 72041 | 784 | |
835164 | 835164 | 2020-12-16 | Cidra | Puerto Rico | 72041 | 769 | |
831918 | 831918 | 2020-12-15 | Cidra | Puerto Rico | 72041 | 766 | |
828671 | 828671 | 2020-12-14 | Cidra | Puerto Rico | 72041 | 766 | |
825425 | 825425 | 2020-12-13 | Cidra | Puerto Rico | 72041 | 758 | |
822178 | 822178 | 2020-12-12 | Cidra | Puerto Rico | 72041 | 757 | |
818932 | 818932 | 2020-12-11 | Cidra | Puerto Rico | 72041 | 743 | |
815686 | 815686 | 2020-12-10 | Cidra | Puerto Rico | 72041 | 719 | |
812440 | 812440 | 2020-12-09 | Cidra | Puerto Rico | 72041 | 713 | |
809196 | 809196 | 2020-12-08 | Cidra | Puerto Rico | 72041 | 707 | |
805951 | 805951 | 2020-12-07 | Cidra | Puerto Rico | 72041 | 703 | |
802706 | 802706 | 2020-12-06 | Cidra | Puerto Rico | 72041 | 685 | |
799461 | 799461 | 2020-12-05 | Cidra | Puerto Rico | 72041 | 645 | |
796216 | 796216 | 2020-12-04 | Cidra | Puerto Rico | 72041 | 637 | |
792971 | 792971 | 2020-12-03 | Cidra | Puerto Rico | 72041 | 628 | |
789726 | 789726 | 2020-12-02 | Cidra | Puerto Rico | 72041 | 627 | |
786481 | 786481 | 2020-12-01 | Cidra | Puerto Rico | 72041 | 623 | |
783237 | 783237 | 2020-11-30 | Cidra | Puerto Rico | 72041 | 617 | |
779992 | 779992 | 2020-11-29 | Cidra | Puerto Rico | 72041 | 611 | |
776746 | 776746 | 2020-11-28 | Cidra | Puerto Rico | 72041 | 609 | |
773501 | 773501 | 2020-11-27 | Cidra | Puerto Rico | 72041 | 598 | |
770256 | 770256 | 2020-11-26 | Cidra | Puerto Rico | 72041 | 588 | |
767010 | 767010 | 2020-11-25 | Cidra | Puerto Rico | 72041 | 585 | |
763765 | 763765 | 2020-11-24 | Cidra | Puerto Rico | 72041 | 584 | |
760520 | 760520 | 2020-11-23 | Cidra | Puerto Rico | 72041 | 580 | |
757275 | 757275 | 2020-11-22 | Cidra | Puerto Rico | 72041 | 577 | |
754028 | 754028 | 2020-11-21 | Cidra | Puerto Rico | 72041 | 569 | |
750782 | 750782 | 2020-11-20 | Cidra | Puerto Rico | 72041 | 560 | |
747536 | 747536 | 2020-11-19 | Cidra | Puerto Rico | 72041 | 551 | |
744290 | 744290 | 2020-11-18 | Cidra | Puerto Rico | 72041 | 543 | |
741043 | 741043 | 2020-11-17 | Cidra | Puerto Rico | 72041 | 542 | |
737797 | 737797 | 2020-11-16 | Cidra | Puerto Rico | 72041 | 531 | |
734553 | 734553 | 2020-11-15 | Cidra | Puerto Rico | 72041 | 524 |
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);