ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Arecibo" 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 |
---|---|---|---|---|---|---|---|
1487625 | 1487625 | 2021-07-05 | Arecibo | Puerto Rico | 72013 | 3570 | |
1484378 | 1484378 | 2021-07-04 | Arecibo | Puerto Rico | 72013 | 3566 | |
1481132 | 1481132 | 2021-07-03 | Arecibo | Puerto Rico | 72013 | 3565 | |
1477885 | 1477885 | 2021-07-02 | Arecibo | Puerto Rico | 72013 | 3562 | |
1474639 | 1474639 | 2021-07-01 | Arecibo | Puerto Rico | 72013 | 3561 | |
1471393 | 1471393 | 2021-06-30 | Arecibo | Puerto Rico | 72013 | 3561 | |
1468148 | 1468148 | 2021-06-29 | Arecibo | Puerto Rico | 72013 | 3561 | |
1464903 | 1464903 | 2021-06-28 | Arecibo | Puerto Rico | 72013 | 3561 | |
1461658 | 1461658 | 2021-06-27 | Arecibo | Puerto Rico | 72013 | 3559 | |
1458413 | 1458413 | 2021-06-26 | Arecibo | Puerto Rico | 72013 | 3558 | |
1455168 | 1455168 | 2021-06-25 | Arecibo | Puerto Rico | 72013 | 3558 | |
1451923 | 1451923 | 2021-06-24 | Arecibo | Puerto Rico | 72013 | 3555 | |
1448677 | 1448677 | 2021-06-23 | Arecibo | Puerto Rico | 72013 | 3554 | |
1445432 | 1445432 | 2021-06-22 | Arecibo | Puerto Rico | 72013 | 3554 | |
1442187 | 1442187 | 2021-06-21 | Arecibo | Puerto Rico | 72013 | 3554 | |
1438942 | 1438942 | 2021-06-20 | Arecibo | Puerto Rico | 72013 | 3553 | |
1435695 | 1435695 | 2021-06-19 | Arecibo | Puerto Rico | 72013 | 3551 | |
1432448 | 1432448 | 2021-06-18 | Arecibo | Puerto Rico | 72013 | 3548 | |
1429202 | 1429202 | 2021-06-17 | Arecibo | Puerto Rico | 72013 | 3544 | |
1425957 | 1425957 | 2021-06-16 | Arecibo | Puerto Rico | 72013 | 3544 | |
1422710 | 1422710 | 2021-06-15 | Arecibo | Puerto Rico | 72013 | 3543 | |
1419464 | 1419464 | 2021-06-14 | Arecibo | Puerto Rico | 72013 | 3544 | |
1416219 | 1416219 | 2021-06-13 | Arecibo | Puerto Rico | 72013 | 3544 | |
1412973 | 1412973 | 2021-06-12 | Arecibo | Puerto Rico | 72013 | 3544 | |
1409728 | 1409728 | 2021-06-11 | Arecibo | Puerto Rico | 72013 | 3543 | |
1406483 | 1406483 | 2021-06-10 | Arecibo | Puerto Rico | 72013 | 3542 | |
1403237 | 1403237 | 2021-06-09 | Arecibo | Puerto Rico | 72013 | 3540 | |
1399992 | 1399992 | 2021-06-08 | Arecibo | Puerto Rico | 72013 | 3540 | |
1396747 | 1396747 | 2021-06-07 | Arecibo | Puerto Rico | 72013 | 3539 | |
1393500 | 1393500 | 2021-06-06 | Arecibo | Puerto Rico | 72013 | 3536 | |
1390255 | 1390255 | 2021-06-05 | Arecibo | Puerto Rico | 72013 | 3534 | |
1387010 | 1387010 | 2021-06-04 | Arecibo | Puerto Rico | 72013 | 3533 | |
1383765 | 1383765 | 2021-06-03 | Arecibo | Puerto Rico | 72013 | 3532 | |
1380519 | 1380519 | 2021-06-02 | Arecibo | Puerto Rico | 72013 | 3532 | |
1377274 | 1377274 | 2021-06-01 | Arecibo | Puerto Rico | 72013 | 3532 | |
1374028 | 1374028 | 2021-05-31 | Arecibo | Puerto Rico | 72013 | 3532 | |
1370783 | 1370783 | 2021-05-30 | Arecibo | Puerto Rico | 72013 | 3532 | |
1367537 | 1367537 | 2021-05-29 | Arecibo | Puerto Rico | 72013 | 3531 | |
1364291 | 1364291 | 2021-05-28 | Arecibo | Puerto Rico | 72013 | 3531 | |
1361045 | 1361045 | 2021-05-27 | Arecibo | Puerto Rico | 72013 | 3527 | |
1357799 | 1357799 | 2021-05-26 | Arecibo | Puerto Rico | 72013 | 3526 | |
1354553 | 1354553 | 2021-05-25 | Arecibo | Puerto Rico | 72013 | 3526 | |
1351307 | 1351307 | 2021-05-24 | Arecibo | Puerto Rico | 72013 | 3526 | |
1348061 | 1348061 | 2021-05-23 | Arecibo | Puerto Rico | 72013 | 3524 | |
1344813 | 1344813 | 2021-05-22 | Arecibo | Puerto Rico | 72013 | 3523 | |
1341565 | 1341565 | 2021-05-21 | Arecibo | Puerto Rico | 72013 | 3519 | |
1338317 | 1338317 | 2021-05-20 | Arecibo | Puerto Rico | 72013 | 3514 | |
1335070 | 1335070 | 2021-05-19 | Arecibo | Puerto Rico | 72013 | 3514 | |
1331823 | 1331823 | 2021-05-18 | Arecibo | Puerto Rico | 72013 | 3513 | |
1328576 | 1328576 | 2021-05-17 | Arecibo | Puerto Rico | 72013 | 3513 | |
1325330 | 1325330 | 2021-05-16 | Arecibo | Puerto Rico | 72013 | 3501 | |
1322084 | 1322084 | 2021-05-15 | Arecibo | Puerto Rico | 72013 | 3496 | |
1318838 | 1318838 | 2021-05-14 | Arecibo | Puerto Rico | 72013 | 3495 | |
1315590 | 1315590 | 2021-05-13 | Arecibo | Puerto Rico | 72013 | 3490 | |
1312344 | 1312344 | 2021-05-12 | Arecibo | Puerto Rico | 72013 | 3489 | |
1309097 | 1309097 | 2021-05-11 | Arecibo | Puerto Rico | 72013 | 3489 | |
1305851 | 1305851 | 2021-05-10 | Arecibo | Puerto Rico | 72013 | 3485 | |
1302605 | 1302605 | 2021-05-09 | Arecibo | Puerto Rico | 72013 | 3475 | |
1299358 | 1299358 | 2021-05-08 | Arecibo | Puerto Rico | 72013 | 3467 | |
1296111 | 1296111 | 2021-05-07 | Arecibo | Puerto Rico | 72013 | 3456 | |
1292865 | 1292865 | 2021-05-06 | Arecibo | Puerto Rico | 72013 | 3442 | |
1289619 | 1289619 | 2021-05-05 | Arecibo | Puerto Rico | 72013 | 3434 | |
1286373 | 1286373 | 2021-05-04 | Arecibo | Puerto Rico | 72013 | 3431 | |
1283127 | 1283127 | 2021-05-03 | Arecibo | Puerto Rico | 72013 | 3420 | |
1279880 | 1279880 | 2021-05-02 | Arecibo | Puerto Rico | 72013 | 3418 | |
1276633 | 1276633 | 2021-05-01 | Arecibo | Puerto Rico | 72013 | 3397 | |
1273386 | 1273386 | 2021-04-30 | Arecibo | Puerto Rico | 72013 | 3383 | |
1270139 | 1270139 | 2021-04-29 | Arecibo | Puerto Rico | 72013 | 3378 | |
1266892 | 1266892 | 2021-04-28 | Arecibo | Puerto Rico | 72013 | 3372 | |
1263645 | 1263645 | 2021-04-27 | Arecibo | Puerto Rico | 72013 | 3367 | |
1260398 | 1260398 | 2021-04-26 | Arecibo | Puerto Rico | 72013 | 3360 | |
1257151 | 1257151 | 2021-04-25 | Arecibo | Puerto Rico | 72013 | 3348 | |
1253904 | 1253904 | 2021-04-24 | Arecibo | Puerto Rico | 72013 | 3325 | |
1250657 | 1250657 | 2021-04-23 | Arecibo | Puerto Rico | 72013 | 3307 | |
1247410 | 1247410 | 2021-04-22 | Arecibo | Puerto Rico | 72013 | 3288 | |
1244163 | 1244163 | 2021-04-21 | Arecibo | Puerto Rico | 72013 | 3273 | |
1240916 | 1240916 | 2021-04-20 | Arecibo | Puerto Rico | 72013 | 3271 | |
1237669 | 1237669 | 2021-04-19 | Arecibo | Puerto Rico | 72013 | 3251 | |
1234422 | 1234422 | 2021-04-18 | Arecibo | Puerto Rico | 72013 | 3219 | |
1231174 | 1231174 | 2021-04-17 | Arecibo | Puerto Rico | 72013 | 3203 | |
1227926 | 1227926 | 2021-04-16 | Arecibo | Puerto Rico | 72013 | 3177 | |
1224678 | 1224678 | 2021-04-15 | Arecibo | Puerto Rico | 72013 | 3165 | |
1221431 | 1221431 | 2021-04-14 | Arecibo | Puerto Rico | 72013 | 3155 | |
1218183 | 1218183 | 2021-04-13 | Arecibo | Puerto Rico | 72013 | 3149 | |
1214935 | 1214935 | 2021-04-12 | Arecibo | Puerto Rico | 72013 | 3132 | |
1211688 | 1211688 | 2021-04-11 | Arecibo | Puerto Rico | 72013 | 3114 | |
1208439 | 1208439 | 2021-04-10 | Arecibo | Puerto Rico | 72013 | 3105 | |
1205191 | 1205191 | 2021-04-09 | Arecibo | Puerto Rico | 72013 | 3092 | |
1201943 | 1201943 | 2021-04-08 | Arecibo | Puerto Rico | 72013 | 3067 | |
1198694 | 1198694 | 2021-04-07 | Arecibo | Puerto Rico | 72013 | 3061 | |
1195445 | 1195445 | 2021-04-06 | Arecibo | Puerto Rico | 72013 | 3056 | |
1192197 | 1192197 | 2021-04-05 | Arecibo | Puerto Rico | 72013 | 3056 | |
1188948 | 1188948 | 2021-04-04 | Arecibo | Puerto Rico | 72013 | 3055 | |
1185701 | 1185701 | 2021-04-03 | Arecibo | Puerto Rico | 72013 | 3044 | |
1182454 | 1182454 | 2021-04-02 | Arecibo | Puerto Rico | 72013 | 3032 | |
1179207 | 1179207 | 2021-04-01 | Arecibo | Puerto Rico | 72013 | 3029 | |
1175960 | 1175960 | 2021-03-31 | Arecibo | Puerto Rico | 72013 | 3020 | |
1172713 | 1172713 | 2021-03-30 | Arecibo | Puerto Rico | 72013 | 3020 | |
1169466 | 1169466 | 2021-03-29 | Arecibo | Puerto Rico | 72013 | 3012 | |
1166218 | 1166218 | 2021-03-28 | Arecibo | Puerto Rico | 72013 | 3006 |
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);