ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72077 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 |
---|---|---|---|---|---|---|---|
1419497 | 1419497 | 2021-06-14 | Juncos | Puerto Rico | 72077 | 2540 | |
1416252 | 1416252 | 2021-06-13 | Juncos | Puerto Rico | 72077 | 2539 | |
1413006 | 1413006 | 2021-06-12 | Juncos | Puerto Rico | 72077 | 2539 | |
1409761 | 1409761 | 2021-06-11 | Juncos | Puerto Rico | 72077 | 2539 | |
1406516 | 1406516 | 2021-06-10 | Juncos | Puerto Rico | 72077 | 2538 | |
1403270 | 1403270 | 2021-06-09 | Juncos | Puerto Rico | 72077 | 2537 | |
1400025 | 1400025 | 2021-06-08 | Juncos | Puerto Rico | 72077 | 2537 | |
1396780 | 1396780 | 2021-06-07 | Juncos | Puerto Rico | 72077 | 2533 | |
1393533 | 1393533 | 2021-06-06 | Juncos | Puerto Rico | 72077 | 2532 | |
1390288 | 1390288 | 2021-06-05 | Juncos | Puerto Rico | 72077 | 2532 | |
1387043 | 1387043 | 2021-06-04 | Juncos | Puerto Rico | 72077 | 2532 | |
1383798 | 1383798 | 2021-06-03 | Juncos | Puerto Rico | 72077 | 2530 | |
1380552 | 1380552 | 2021-06-02 | Juncos | Puerto Rico | 72077 | 2530 | |
1377307 | 1377307 | 2021-06-01 | Juncos | Puerto Rico | 72077 | 2530 | |
1374061 | 1374061 | 2021-05-31 | Juncos | Puerto Rico | 72077 | 2529 | |
1370816 | 1370816 | 2021-05-30 | Juncos | Puerto Rico | 72077 | 2528 | |
1367570 | 1367570 | 2021-05-29 | Juncos | Puerto Rico | 72077 | 2528 | |
1364324 | 1364324 | 2021-05-28 | Juncos | Puerto Rico | 72077 | 2528 | |
1361078 | 1361078 | 2021-05-27 | Juncos | Puerto Rico | 72077 | 2529 | |
1357832 | 1357832 | 2021-05-26 | Juncos | Puerto Rico | 72077 | 2528 | |
1354586 | 1354586 | 2021-05-25 | Juncos | Puerto Rico | 72077 | 2528 | |
1351340 | 1351340 | 2021-05-24 | Juncos | Puerto Rico | 72077 | 2526 | |
1348094 | 1348094 | 2021-05-23 | Juncos | Puerto Rico | 72077 | 2526 | |
1344846 | 1344846 | 2021-05-22 | Juncos | Puerto Rico | 72077 | 2524 | |
1341598 | 1341598 | 2021-05-21 | Juncos | Puerto Rico | 72077 | 2523 | |
1338350 | 1338350 | 2021-05-20 | Juncos | Puerto Rico | 72077 | 2523 | |
1335103 | 1335103 | 2021-05-19 | Juncos | Puerto Rico | 72077 | 2523 | |
1331856 | 1331856 | 2021-05-18 | Juncos | Puerto Rico | 72077 | 2523 | |
1328609 | 1328609 | 2021-05-17 | Juncos | Puerto Rico | 72077 | 2521 | |
1325363 | 1325363 | 2021-05-16 | Juncos | Puerto Rico | 72077 | 2518 | |
1322117 | 1322117 | 2021-05-15 | Juncos | Puerto Rico | 72077 | 2517 | |
1318871 | 1318871 | 2021-05-14 | Juncos | Puerto Rico | 72077 | 2512 | |
1315623 | 1315623 | 2021-05-13 | Juncos | Puerto Rico | 72077 | 2510 | |
1312377 | 1312377 | 2021-05-12 | Juncos | Puerto Rico | 72077 | 2509 | |
1309130 | 1309130 | 2021-05-11 | Juncos | Puerto Rico | 72077 | 2508 | |
1305884 | 1305884 | 2021-05-10 | Juncos | Puerto Rico | 72077 | 2501 | |
1302638 | 1302638 | 2021-05-09 | Juncos | Puerto Rico | 72077 | 2497 | |
1299391 | 1299391 | 2021-05-08 | Juncos | Puerto Rico | 72077 | 2492 | |
1296144 | 1296144 | 2021-05-07 | Juncos | Puerto Rico | 72077 | 2491 | |
1292898 | 1292898 | 2021-05-06 | Juncos | Puerto Rico | 72077 | 2484 | |
1289652 | 1289652 | 2021-05-05 | Juncos | Puerto Rico | 72077 | 2482 | |
1286406 | 1286406 | 2021-05-04 | Juncos | Puerto Rico | 72077 | 2478 | |
1283160 | 1283160 | 2021-05-03 | Juncos | Puerto Rico | 72077 | 2466 | |
1279913 | 1279913 | 2021-05-02 | Juncos | Puerto Rico | 72077 | 2462 | |
1276666 | 1276666 | 2021-05-01 | Juncos | Puerto Rico | 72077 | 2454 | |
1273419 | 1273419 | 2021-04-30 | Juncos | Puerto Rico | 72077 | 2447 | |
1270172 | 1270172 | 2021-04-29 | Juncos | Puerto Rico | 72077 | 2428 | |
1266925 | 1266925 | 2021-04-28 | Juncos | Puerto Rico | 72077 | 2425 | |
1263678 | 1263678 | 2021-04-27 | Juncos | Puerto Rico | 72077 | 2419 | |
1260431 | 1260431 | 2021-04-26 | Juncos | Puerto Rico | 72077 | 2400 | |
1257184 | 1257184 | 2021-04-25 | Juncos | Puerto Rico | 72077 | 2388 | |
1253937 | 1253937 | 2021-04-24 | Juncos | Puerto Rico | 72077 | 2368 | |
1250690 | 1250690 | 2021-04-23 | Juncos | Puerto Rico | 72077 | 2356 | |
1247443 | 1247443 | 2021-04-22 | Juncos | Puerto Rico | 72077 | 2327 | |
1244196 | 1244196 | 2021-04-21 | Juncos | Puerto Rico | 72077 | 2318 | |
1240949 | 1240949 | 2021-04-20 | Juncos | Puerto Rico | 72077 | 2307 | |
1237702 | 1237702 | 2021-04-19 | Juncos | Puerto Rico | 72077 | 2282 | |
1234455 | 1234455 | 2021-04-18 | Juncos | Puerto Rico | 72077 | 2266 | |
1231207 | 1231207 | 2021-04-17 | Juncos | Puerto Rico | 72077 | 2229 | |
1227959 | 1227959 | 2021-04-16 | Juncos | Puerto Rico | 72077 | 2193 | |
1224711 | 1224711 | 2021-04-15 | Juncos | Puerto Rico | 72077 | 2163 | |
1221464 | 1221464 | 2021-04-14 | Juncos | Puerto Rico | 72077 | 2157 | |
1218216 | 1218216 | 2021-04-13 | Juncos | Puerto Rico | 72077 | 2145 | |
1214968 | 1214968 | 2021-04-12 | Juncos | Puerto Rico | 72077 | 2107 | |
1211721 | 1211721 | 2021-04-11 | Juncos | Puerto Rico | 72077 | 2081 | |
1208472 | 1208472 | 2021-04-10 | Juncos | Puerto Rico | 72077 | 2047 | |
1205224 | 1205224 | 2021-04-09 | Juncos | Puerto Rico | 72077 | 2018 | |
1201976 | 1201976 | 2021-04-08 | Juncos | Puerto Rico | 72077 | 1979 | |
1198727 | 1198727 | 2021-04-07 | Juncos | Puerto Rico | 72077 | 1973 | |
1195478 | 1195478 | 2021-04-06 | Juncos | Puerto Rico | 72077 | 1969 | |
1192230 | 1192230 | 2021-04-05 | Juncos | Puerto Rico | 72077 | 1966 | |
1188981 | 1188981 | 2021-04-04 | Juncos | Puerto Rico | 72077 | 1958 | |
1185734 | 1185734 | 2021-04-03 | Juncos | Puerto Rico | 72077 | 1946 | |
1182487 | 1182487 | 2021-04-02 | Juncos | Puerto Rico | 72077 | 1933 | |
1179240 | 1179240 | 2021-04-01 | Juncos | Puerto Rico | 72077 | 1914 | |
1175993 | 1175993 | 2021-03-31 | Juncos | Puerto Rico | 72077 | 1904 | |
1172746 | 1172746 | 2021-03-30 | Juncos | Puerto Rico | 72077 | 1894 | |
1169499 | 1169499 | 2021-03-29 | Juncos | Puerto Rico | 72077 | 1877 | |
1166251 | 1166251 | 2021-03-28 | Juncos | Puerto Rico | 72077 | 1851 | |
1163003 | 1163003 | 2021-03-27 | Juncos | Puerto Rico | 72077 | 1845 | |
1159754 | 1159754 | 2021-03-26 | Juncos | Puerto Rico | 72077 | 1835 | |
1156507 | 1156507 | 2021-03-25 | Juncos | Puerto Rico | 72077 | 1827 | |
1153260 | 1153260 | 2021-03-24 | Juncos | Puerto Rico | 72077 | 1826 | |
1150013 | 1150013 | 2021-03-23 | Juncos | Puerto Rico | 72077 | 1824 | |
1146766 | 1146766 | 2021-03-22 | Juncos | Puerto Rico | 72077 | 1824 | |
1143519 | 1143519 | 2021-03-21 | Juncos | Puerto Rico | 72077 | 1818 | |
1140272 | 1140272 | 2021-03-20 | Juncos | Puerto Rico | 72077 | 1809 | |
1137026 | 1137026 | 2021-03-19 | Juncos | Puerto Rico | 72077 | 1800 | |
1133780 | 1133780 | 2021-03-18 | Juncos | Puerto Rico | 72077 | 1795 | |
1130532 | 1130532 | 2021-03-17 | Juncos | Puerto Rico | 72077 | 1795 | |
1127285 | 1127285 | 2021-03-16 | Juncos | Puerto Rico | 72077 | 1794 | |
1124039 | 1124039 | 2021-03-15 | Juncos | Puerto Rico | 72077 | 1789 | |
1120793 | 1120793 | 2021-03-14 | Juncos | Puerto Rico | 72077 | 1788 | |
1117546 | 1117546 | 2021-03-13 | Juncos | Puerto Rico | 72077 | 1784 | |
1114299 | 1114299 | 2021-03-12 | Juncos | Puerto Rico | 72077 | 1781 | |
1111053 | 1111053 | 2021-03-11 | Juncos | Puerto Rico | 72077 | 1779 | |
1107807 | 1107807 | 2021-03-10 | Juncos | Puerto Rico | 72077 | 1778 | |
1104561 | 1104561 | 2021-03-09 | Juncos | Puerto Rico | 72077 | 1778 | |
1101315 | 1101315 | 2021-03-08 | Juncos | Puerto Rico | 72077 | 1773 | |
1098069 | 1098069 | 2021-03-07 | Juncos | Puerto Rico | 72077 | 1754 |
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);