ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72043 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 |
---|---|---|---|---|---|---|---|
1279895 | 1279895 | 2021-05-02 | Coamo | Puerto Rico | 72043 | 1136 | |
1276648 | 1276648 | 2021-05-01 | Coamo | Puerto Rico | 72043 | 1133 | |
1273401 | 1273401 | 2021-04-30 | Coamo | Puerto Rico | 72043 | 1129 | |
1270154 | 1270154 | 2021-04-29 | Coamo | Puerto Rico | 72043 | 1125 | |
1266907 | 1266907 | 2021-04-28 | Coamo | Puerto Rico | 72043 | 1124 | |
1263660 | 1263660 | 2021-04-27 | Coamo | Puerto Rico | 72043 | 1123 | |
1260413 | 1260413 | 2021-04-26 | Coamo | Puerto Rico | 72043 | 1122 | |
1257166 | 1257166 | 2021-04-25 | Coamo | Puerto Rico | 72043 | 1122 | |
1253919 | 1253919 | 2021-04-24 | Coamo | Puerto Rico | 72043 | 1116 | |
1250672 | 1250672 | 2021-04-23 | Coamo | Puerto Rico | 72043 | 1109 | |
1247425 | 1247425 | 2021-04-22 | Coamo | Puerto Rico | 72043 | 1104 | |
1244178 | 1244178 | 2021-04-21 | Coamo | Puerto Rico | 72043 | 1102 | |
1240931 | 1240931 | 2021-04-20 | Coamo | Puerto Rico | 72043 | 1102 | |
1237684 | 1237684 | 2021-04-19 | Coamo | Puerto Rico | 72043 | 1095 | |
1234437 | 1234437 | 2021-04-18 | Coamo | Puerto Rico | 72043 | 1086 | |
1231189 | 1231189 | 2021-04-17 | Coamo | Puerto Rico | 72043 | 1077 | |
1227941 | 1227941 | 2021-04-16 | Coamo | Puerto Rico | 72043 | 1063 | |
1224693 | 1224693 | 2021-04-15 | Coamo | Puerto Rico | 72043 | 1057 | |
1221446 | 1221446 | 2021-04-14 | Coamo | Puerto Rico | 72043 | 1055 | |
1218198 | 1218198 | 2021-04-13 | Coamo | Puerto Rico | 72043 | 1054 | |
1214950 | 1214950 | 2021-04-12 | Coamo | Puerto Rico | 72043 | 1047 | |
1211703 | 1211703 | 2021-04-11 | Coamo | Puerto Rico | 72043 | 1037 | |
1208454 | 1208454 | 2021-04-10 | Coamo | Puerto Rico | 72043 | 1029 | |
1205206 | 1205206 | 2021-04-09 | Coamo | Puerto Rico | 72043 | 1022 | |
1201958 | 1201958 | 2021-04-08 | Coamo | Puerto Rico | 72043 | 1013 | |
1198709 | 1198709 | 2021-04-07 | Coamo | Puerto Rico | 72043 | 1013 | |
1195460 | 1195460 | 2021-04-06 | Coamo | Puerto Rico | 72043 | 1010 | |
1192212 | 1192212 | 2021-04-05 | Coamo | Puerto Rico | 72043 | 1010 | |
1188963 | 1188963 | 2021-04-04 | Coamo | Puerto Rico | 72043 | 1009 | |
1185716 | 1185716 | 2021-04-03 | Coamo | Puerto Rico | 72043 | 1005 | |
1182469 | 1182469 | 2021-04-02 | Coamo | Puerto Rico | 72043 | 998 | |
1179222 | 1179222 | 2021-04-01 | Coamo | Puerto Rico | 72043 | 995 | |
1175975 | 1175975 | 2021-03-31 | Coamo | Puerto Rico | 72043 | 990 | |
1172728 | 1172728 | 2021-03-30 | Coamo | Puerto Rico | 72043 | 990 | |
1169481 | 1169481 | 2021-03-29 | Coamo | Puerto Rico | 72043 | 989 | |
1166233 | 1166233 | 2021-03-28 | Coamo | Puerto Rico | 72043 | 987 | |
1162985 | 1162985 | 2021-03-27 | Coamo | Puerto Rico | 72043 | 987 | |
1159736 | 1159736 | 2021-03-26 | Coamo | Puerto Rico | 72043 | 978 | |
1156489 | 1156489 | 2021-03-25 | Coamo | Puerto Rico | 72043 | 978 | |
1153242 | 1153242 | 2021-03-24 | Coamo | Puerto Rico | 72043 | 977 | |
1149995 | 1149995 | 2021-03-23 | Coamo | Puerto Rico | 72043 | 976 | |
1146748 | 1146748 | 2021-03-22 | Coamo | Puerto Rico | 72043 | 976 | |
1143501 | 1143501 | 2021-03-21 | Coamo | Puerto Rico | 72043 | 973 | |
1140254 | 1140254 | 2021-03-20 | Coamo | Puerto Rico | 72043 | 970 | |
1137008 | 1137008 | 2021-03-19 | Coamo | Puerto Rico | 72043 | 965 | |
1133762 | 1133762 | 2021-03-18 | Coamo | Puerto Rico | 72043 | 962 | |
1130514 | 1130514 | 2021-03-17 | Coamo | Puerto Rico | 72043 | 962 | |
1127267 | 1127267 | 2021-03-16 | Coamo | Puerto Rico | 72043 | 961 | |
1124021 | 1124021 | 2021-03-15 | Coamo | Puerto Rico | 72043 | 960 | |
1120775 | 1120775 | 2021-03-14 | Coamo | Puerto Rico | 72043 | 960 | |
1117528 | 1117528 | 2021-03-13 | Coamo | Puerto Rico | 72043 | 960 | |
1114281 | 1114281 | 2021-03-12 | Coamo | Puerto Rico | 72043 | 958 | |
1111035 | 1111035 | 2021-03-11 | Coamo | Puerto Rico | 72043 | 958 | |
1107789 | 1107789 | 2021-03-10 | Coamo | Puerto Rico | 72043 | 956 | |
1104543 | 1104543 | 2021-03-09 | Coamo | Puerto Rico | 72043 | 956 | |
1101297 | 1101297 | 2021-03-08 | Coamo | Puerto Rico | 72043 | 956 | |
1098051 | 1098051 | 2021-03-07 | Coamo | Puerto Rico | 72043 | 955 | |
1094803 | 1094803 | 2021-03-06 | Coamo | Puerto Rico | 72043 | 955 | |
1091557 | 1091557 | 2021-03-05 | Coamo | Puerto Rico | 72043 | 952 | |
1088311 | 1088311 | 2021-03-04 | Coamo | Puerto Rico | 72043 | 953 | |
1085066 | 1085066 | 2021-03-03 | Coamo | Puerto Rico | 72043 | 951 | |
1081820 | 1081820 | 2021-03-02 | Coamo | Puerto Rico | 72043 | 950 | |
1078574 | 1078574 | 2021-03-01 | Coamo | Puerto Rico | 72043 | 950 | |
1075329 | 1075329 | 2021-02-28 | Coamo | Puerto Rico | 72043 | 949 | |
1072083 | 1072083 | 2021-02-27 | Coamo | Puerto Rico | 72043 | 943 | |
1068837 | 1068837 | 2021-02-26 | Coamo | Puerto Rico | 72043 | 943 | |
1065592 | 1065592 | 2021-02-25 | Coamo | Puerto Rico | 72043 | 943 | |
1062347 | 1062347 | 2021-02-24 | Coamo | Puerto Rico | 72043 | 941 | |
1059102 | 1059102 | 2021-02-23 | Coamo | Puerto Rico | 72043 | 941 | |
1055856 | 1055856 | 2021-02-22 | Coamo | Puerto Rico | 72043 | 940 | |
1052610 | 1052610 | 2021-02-21 | Coamo | Puerto Rico | 72043 | 940 | |
1049363 | 1049363 | 2021-02-20 | Coamo | Puerto Rico | 72043 | 938 | |
1046116 | 1046116 | 2021-02-19 | Coamo | Puerto Rico | 72043 | 938 | |
1042871 | 1042871 | 2021-02-18 | Coamo | Puerto Rico | 72043 | 937 | |
1039626 | 1039626 | 2021-02-17 | Coamo | Puerto Rico | 72043 | 937 | |
1036381 | 1036381 | 2021-02-16 | Coamo | Puerto Rico | 72043 | 936 | |
1033136 | 1033136 | 2021-02-15 | Coamo | Puerto Rico | 72043 | 933 | |
1029890 | 1029890 | 2021-02-14 | Coamo | Puerto Rico | 72043 | 933 | |
1026643 | 1026643 | 2021-02-13 | Coamo | Puerto Rico | 72043 | 932 | |
1023398 | 1023398 | 2021-02-12 | Coamo | Puerto Rico | 72043 | 931 | |
1020153 | 1020153 | 2021-02-11 | Coamo | Puerto Rico | 72043 | 931 | |
1016908 | 1016908 | 2021-02-10 | Coamo | Puerto Rico | 72043 | 931 | |
1013663 | 1013663 | 2021-02-09 | Coamo | Puerto Rico | 72043 | 931 | |
1010418 | 1010418 | 2021-02-08 | Coamo | Puerto Rico | 72043 | 929 | |
1007172 | 1007172 | 2021-02-07 | Coamo | Puerto Rico | 72043 | 928 | |
1003926 | 1003926 | 2021-02-06 | Coamo | Puerto Rico | 72043 | 927 | |
1000680 | 1000680 | 2021-02-05 | Coamo | Puerto Rico | 72043 | 925 | |
997434 | 997434 | 2021-02-04 | Coamo | Puerto Rico | 72043 | 926 | |
994188 | 994188 | 2021-02-03 | Coamo | Puerto Rico | 72043 | 921 | |
990942 | 990942 | 2021-02-02 | Coamo | Puerto Rico | 72043 | 919 | |
987696 | 987696 | 2021-02-01 | Coamo | Puerto Rico | 72043 | 917 | |
984449 | 984449 | 2021-01-31 | Coamo | Puerto Rico | 72043 | 915 | |
981202 | 981202 | 2021-01-30 | Coamo | Puerto Rico | 72043 | 914 | |
977956 | 977956 | 2021-01-29 | Coamo | Puerto Rico | 72043 | 911 | |
974711 | 974711 | 2021-01-28 | Coamo | Puerto Rico | 72043 | 906 | |
971466 | 971466 | 2021-01-27 | Coamo | Puerto Rico | 72043 | 905 | |
968221 | 968221 | 2021-01-26 | Coamo | Puerto Rico | 72043 | 904 | |
964977 | 964977 | 2021-01-25 | Coamo | Puerto Rico | 72043 | 902 | |
961732 | 961732 | 2021-01-24 | Coamo | Puerto Rico | 72043 | 899 | |
958487 | 958487 | 2021-01-23 | Coamo | Puerto Rico | 72043 | 894 |
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);