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 |
---|---|---|---|---|---|---|---|
1487640 | 1487640 | 2021-07-05 | Coamo | Puerto Rico | 72043 | 1175 | |
1484393 | 1484393 | 2021-07-04 | Coamo | Puerto Rico | 72043 | 1175 | |
1481147 | 1481147 | 2021-07-03 | Coamo | Puerto Rico | 72043 | 1175 | |
1477900 | 1477900 | 2021-07-02 | Coamo | Puerto Rico | 72043 | 1173 | |
1474654 | 1474654 | 2021-07-01 | Coamo | Puerto Rico | 72043 | 1172 | |
1471408 | 1471408 | 2021-06-30 | Coamo | Puerto Rico | 72043 | 1172 | |
1468163 | 1468163 | 2021-06-29 | Coamo | Puerto Rico | 72043 | 1172 | |
1464918 | 1464918 | 2021-06-28 | Coamo | Puerto Rico | 72043 | 1172 | |
1461673 | 1461673 | 2021-06-27 | Coamo | Puerto Rico | 72043 | 1172 | |
1458428 | 1458428 | 2021-06-26 | Coamo | Puerto Rico | 72043 | 1171 | |
1455183 | 1455183 | 2021-06-25 | Coamo | Puerto Rico | 72043 | 1171 | |
1451938 | 1451938 | 2021-06-24 | Coamo | Puerto Rico | 72043 | 1170 | |
1448692 | 1448692 | 2021-06-23 | Coamo | Puerto Rico | 72043 | 1170 | |
1445447 | 1445447 | 2021-06-22 | Coamo | Puerto Rico | 72043 | 1170 | |
1442202 | 1442202 | 2021-06-21 | Coamo | Puerto Rico | 72043 | 1170 | |
1438957 | 1438957 | 2021-06-20 | Coamo | Puerto Rico | 72043 | 1170 | |
1435710 | 1435710 | 2021-06-19 | Coamo | Puerto Rico | 72043 | 1169 | |
1432463 | 1432463 | 2021-06-18 | Coamo | Puerto Rico | 72043 | 1169 | |
1429217 | 1429217 | 2021-06-17 | Coamo | Puerto Rico | 72043 | 1168 | |
1425972 | 1425972 | 2021-06-16 | Coamo | Puerto Rico | 72043 | 1168 | |
1422725 | 1422725 | 2021-06-15 | Coamo | Puerto Rico | 72043 | 1168 | |
1419479 | 1419479 | 2021-06-14 | Coamo | Puerto Rico | 72043 | 1169 | |
1416234 | 1416234 | 2021-06-13 | Coamo | Puerto Rico | 72043 | 1168 | |
1412988 | 1412988 | 2021-06-12 | Coamo | Puerto Rico | 72043 | 1168 | |
1409743 | 1409743 | 2021-06-11 | Coamo | Puerto Rico | 72043 | 1168 | |
1406498 | 1406498 | 2021-06-10 | Coamo | Puerto Rico | 72043 | 1168 | |
1403252 | 1403252 | 2021-06-09 | Coamo | Puerto Rico | 72043 | 1168 | |
1400007 | 1400007 | 2021-06-08 | Coamo | Puerto Rico | 72043 | 1168 | |
1396762 | 1396762 | 2021-06-07 | Coamo | Puerto Rico | 72043 | 1168 | |
1393515 | 1393515 | 2021-06-06 | Coamo | Puerto Rico | 72043 | 1166 | |
1390270 | 1390270 | 2021-06-05 | Coamo | Puerto Rico | 72043 | 1166 | |
1387025 | 1387025 | 2021-06-04 | Coamo | Puerto Rico | 72043 | 1165 | |
1383780 | 1383780 | 2021-06-03 | Coamo | Puerto Rico | 72043 | 1165 | |
1380534 | 1380534 | 2021-06-02 | Coamo | Puerto Rico | 72043 | 1165 | |
1377289 | 1377289 | 2021-06-01 | Coamo | Puerto Rico | 72043 | 1165 | |
1374043 | 1374043 | 2021-05-31 | Coamo | Puerto Rico | 72043 | 1165 | |
1370798 | 1370798 | 2021-05-30 | Coamo | Puerto Rico | 72043 | 1165 | |
1367552 | 1367552 | 2021-05-29 | Coamo | Puerto Rico | 72043 | 1165 | |
1364306 | 1364306 | 2021-05-28 | Coamo | Puerto Rico | 72043 | 1165 | |
1361060 | 1361060 | 2021-05-27 | Coamo | Puerto Rico | 72043 | 1164 | |
1357814 | 1357814 | 2021-05-26 | Coamo | Puerto Rico | 72043 | 1164 | |
1354568 | 1354568 | 2021-05-25 | Coamo | Puerto Rico | 72043 | 1164 | |
1351322 | 1351322 | 2021-05-24 | Coamo | Puerto Rico | 72043 | 1164 | |
1348076 | 1348076 | 2021-05-23 | Coamo | Puerto Rico | 72043 | 1163 | |
1344828 | 1344828 | 2021-05-22 | Coamo | Puerto Rico | 72043 | 1163 | |
1341580 | 1341580 | 2021-05-21 | Coamo | Puerto Rico | 72043 | 1163 | |
1338332 | 1338332 | 2021-05-20 | Coamo | Puerto Rico | 72043 | 1163 | |
1335085 | 1335085 | 2021-05-19 | Coamo | Puerto Rico | 72043 | 1162 | |
1331838 | 1331838 | 2021-05-18 | Coamo | Puerto Rico | 72043 | 1161 | |
1328591 | 1328591 | 2021-05-17 | Coamo | Puerto Rico | 72043 | 1161 | |
1325345 | 1325345 | 2021-05-16 | Coamo | Puerto Rico | 72043 | 1160 | |
1322099 | 1322099 | 2021-05-15 | Coamo | Puerto Rico | 72043 | 1159 | |
1318853 | 1318853 | 2021-05-14 | Coamo | Puerto Rico | 72043 | 1159 | |
1315605 | 1315605 | 2021-05-13 | Coamo | Puerto Rico | 72043 | 1160 | |
1312359 | 1312359 | 2021-05-12 | Coamo | Puerto Rico | 72043 | 1158 | |
1309112 | 1309112 | 2021-05-11 | Coamo | Puerto Rico | 72043 | 1158 | |
1305866 | 1305866 | 2021-05-10 | Coamo | Puerto Rico | 72043 | 1158 | |
1302620 | 1302620 | 2021-05-09 | Coamo | Puerto Rico | 72043 | 1156 | |
1299373 | 1299373 | 2021-05-08 | Coamo | Puerto Rico | 72043 | 1154 | |
1296126 | 1296126 | 2021-05-07 | Coamo | Puerto Rico | 72043 | 1148 | |
1292880 | 1292880 | 2021-05-06 | Coamo | Puerto Rico | 72043 | 1146 | |
1289634 | 1289634 | 2021-05-05 | Coamo | Puerto Rico | 72043 | 1147 | |
1286388 | 1286388 | 2021-05-04 | Coamo | Puerto Rico | 72043 | 1143 | |
1283142 | 1283142 | 2021-05-03 | Coamo | Puerto Rico | 72043 | 1141 | |
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 |
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);