ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Luquillo" 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 |
---|---|---|---|---|---|---|---|
1516883 | 1516883 | 2021-07-14 | Luquillo | Puerto Rico | 72089 | 934 | |
1513636 | 1513636 | 2021-07-13 | Luquillo | Puerto Rico | 72089 | 934 | |
1510390 | 1510390 | 2021-07-12 | Luquillo | Puerto Rico | 72089 | 934 | |
1507143 | 1507143 | 2021-07-11 | Luquillo | Puerto Rico | 72089 | 934 | |
1503897 | 1503897 | 2021-07-10 | Luquillo | Puerto Rico | 72089 | 934 | |
1500651 | 1500651 | 2021-07-09 | Luquillo | Puerto Rico | 72089 | 934 | |
1497405 | 1497405 | 2021-07-08 | Luquillo | Puerto Rico | 72089 | 933 | |
1494158 | 1494158 | 2021-07-07 | Luquillo | Puerto Rico | 72089 | 933 | |
1490911 | 1490911 | 2021-07-06 | Luquillo | Puerto Rico | 72089 | 933 | |
1487664 | 1487664 | 2021-07-05 | Luquillo | Puerto Rico | 72089 | 933 | |
1484417 | 1484417 | 2021-07-04 | Luquillo | Puerto Rico | 72089 | 933 | |
1481171 | 1481171 | 2021-07-03 | Luquillo | Puerto Rico | 72089 | 933 | |
1477924 | 1477924 | 2021-07-02 | Luquillo | Puerto Rico | 72089 | 932 | |
1474678 | 1474678 | 2021-07-01 | Luquillo | Puerto Rico | 72089 | 931 | |
1471432 | 1471432 | 2021-06-30 | Luquillo | Puerto Rico | 72089 | 931 | |
1468187 | 1468187 | 2021-06-29 | Luquillo | Puerto Rico | 72089 | 931 | |
1464942 | 1464942 | 2021-06-28 | Luquillo | Puerto Rico | 72089 | 931 | |
1461697 | 1461697 | 2021-06-27 | Luquillo | Puerto Rico | 72089 | 931 | |
1458452 | 1458452 | 2021-06-26 | Luquillo | Puerto Rico | 72089 | 931 | |
1455207 | 1455207 | 2021-06-25 | Luquillo | Puerto Rico | 72089 | 930 | |
1451962 | 1451962 | 2021-06-24 | Luquillo | Puerto Rico | 72089 | 929 | |
1448716 | 1448716 | 2021-06-23 | Luquillo | Puerto Rico | 72089 | 929 | |
1445471 | 1445471 | 2021-06-22 | Luquillo | Puerto Rico | 72089 | 929 | |
1442226 | 1442226 | 2021-06-21 | Luquillo | Puerto Rico | 72089 | 929 | |
1438981 | 1438981 | 2021-06-20 | Luquillo | Puerto Rico | 72089 | 929 | |
1435734 | 1435734 | 2021-06-19 | Luquillo | Puerto Rico | 72089 | 929 | |
1432487 | 1432487 | 2021-06-18 | Luquillo | Puerto Rico | 72089 | 929 | |
1429241 | 1429241 | 2021-06-17 | Luquillo | Puerto Rico | 72089 | 928 | |
1425996 | 1425996 | 2021-06-16 | Luquillo | Puerto Rico | 72089 | 928 | |
1422749 | 1422749 | 2021-06-15 | Luquillo | Puerto Rico | 72089 | 928 | |
1419503 | 1419503 | 2021-06-14 | Luquillo | Puerto Rico | 72089 | 928 | |
1416258 | 1416258 | 2021-06-13 | Luquillo | Puerto Rico | 72089 | 928 | |
1413012 | 1413012 | 2021-06-12 | Luquillo | Puerto Rico | 72089 | 928 | |
1409767 | 1409767 | 2021-06-11 | Luquillo | Puerto Rico | 72089 | 928 | |
1406522 | 1406522 | 2021-06-10 | Luquillo | Puerto Rico | 72089 | 927 | |
1403276 | 1403276 | 2021-06-09 | Luquillo | Puerto Rico | 72089 | 927 | |
1400031 | 1400031 | 2021-06-08 | Luquillo | Puerto Rico | 72089 | 927 | |
1396786 | 1396786 | 2021-06-07 | Luquillo | Puerto Rico | 72089 | 925 | |
1393539 | 1393539 | 2021-06-06 | Luquillo | Puerto Rico | 72089 | 924 | |
1390294 | 1390294 | 2021-06-05 | Luquillo | Puerto Rico | 72089 | 924 | |
1387049 | 1387049 | 2021-06-04 | Luquillo | Puerto Rico | 72089 | 921 | |
1383804 | 1383804 | 2021-06-03 | Luquillo | Puerto Rico | 72089 | 921 | |
1380558 | 1380558 | 2021-06-02 | Luquillo | Puerto Rico | 72089 | 920 | |
1377313 | 1377313 | 2021-06-01 | Luquillo | Puerto Rico | 72089 | 920 | |
1374067 | 1374067 | 2021-05-31 | Luquillo | Puerto Rico | 72089 | 920 | |
1370822 | 1370822 | 2021-05-30 | Luquillo | Puerto Rico | 72089 | 921 | |
1367576 | 1367576 | 2021-05-29 | Luquillo | Puerto Rico | 72089 | 917 | |
1364330 | 1364330 | 2021-05-28 | Luquillo | Puerto Rico | 72089 | 916 | |
1361084 | 1361084 | 2021-05-27 | Luquillo | Puerto Rico | 72089 | 916 | |
1357838 | 1357838 | 2021-05-26 | Luquillo | Puerto Rico | 72089 | 916 | |
1354592 | 1354592 | 2021-05-25 | Luquillo | Puerto Rico | 72089 | 914 | |
1351346 | 1351346 | 2021-05-24 | Luquillo | Puerto Rico | 72089 | 913 | |
1348100 | 1348100 | 2021-05-23 | Luquillo | Puerto Rico | 72089 | 913 | |
1344852 | 1344852 | 2021-05-22 | Luquillo | Puerto Rico | 72089 | 908 | |
1341604 | 1341604 | 2021-05-21 | Luquillo | Puerto Rico | 72089 | 904 | |
1338356 | 1338356 | 2021-05-20 | Luquillo | Puerto Rico | 72089 | 898 | |
1335109 | 1335109 | 2021-05-19 | Luquillo | Puerto Rico | 72089 | 898 | |
1331862 | 1331862 | 2021-05-18 | Luquillo | Puerto Rico | 72089 | 898 | |
1328615 | 1328615 | 2021-05-17 | Luquillo | Puerto Rico | 72089 | 896 | |
1325369 | 1325369 | 2021-05-16 | Luquillo | Puerto Rico | 72089 | 893 | |
1322123 | 1322123 | 2021-05-15 | Luquillo | Puerto Rico | 72089 | 892 | |
1318877 | 1318877 | 2021-05-14 | Luquillo | Puerto Rico | 72089 | 890 | |
1315629 | 1315629 | 2021-05-13 | Luquillo | Puerto Rico | 72089 | 889 | |
1312383 | 1312383 | 2021-05-12 | Luquillo | Puerto Rico | 72089 | 884 | |
1309136 | 1309136 | 2021-05-11 | Luquillo | Puerto Rico | 72089 | 884 | |
1305890 | 1305890 | 2021-05-10 | Luquillo | Puerto Rico | 72089 | 883 | |
1302644 | 1302644 | 2021-05-09 | Luquillo | Puerto Rico | 72089 | 880 | |
1299397 | 1299397 | 2021-05-08 | Luquillo | Puerto Rico | 72089 | 878 | |
1296150 | 1296150 | 2021-05-07 | Luquillo | Puerto Rico | 72089 | 876 | |
1292904 | 1292904 | 2021-05-06 | Luquillo | Puerto Rico | 72089 | 872 | |
1289658 | 1289658 | 2021-05-05 | Luquillo | Puerto Rico | 72089 | 871 | |
1286412 | 1286412 | 2021-05-04 | Luquillo | Puerto Rico | 72089 | 870 | |
1283166 | 1283166 | 2021-05-03 | Luquillo | Puerto Rico | 72089 | 867 | |
1279919 | 1279919 | 2021-05-02 | Luquillo | Puerto Rico | 72089 | 863 | |
1276672 | 1276672 | 2021-05-01 | Luquillo | Puerto Rico | 72089 | 861 | |
1273425 | 1273425 | 2021-04-30 | Luquillo | Puerto Rico | 72089 | 852 | |
1270178 | 1270178 | 2021-04-29 | Luquillo | Puerto Rico | 72089 | 846 | |
1266931 | 1266931 | 2021-04-28 | Luquillo | Puerto Rico | 72089 | 828 | |
1263684 | 1263684 | 2021-04-27 | Luquillo | Puerto Rico | 72089 | 827 | |
1260437 | 1260437 | 2021-04-26 | Luquillo | Puerto Rico | 72089 | 817 | |
1257190 | 1257190 | 2021-04-25 | Luquillo | Puerto Rico | 72089 | 813 | |
1253943 | 1253943 | 2021-04-24 | Luquillo | Puerto Rico | 72089 | 806 | |
1250696 | 1250696 | 2021-04-23 | Luquillo | Puerto Rico | 72089 | 805 | |
1247449 | 1247449 | 2021-04-22 | Luquillo | Puerto Rico | 72089 | 799 | |
1244202 | 1244202 | 2021-04-21 | Luquillo | Puerto Rico | 72089 | 793 | |
1240955 | 1240955 | 2021-04-20 | Luquillo | Puerto Rico | 72089 | 790 | |
1237708 | 1237708 | 2021-04-19 | Luquillo | Puerto Rico | 72089 | 785 | |
1234461 | 1234461 | 2021-04-18 | Luquillo | Puerto Rico | 72089 | 771 | |
1231213 | 1231213 | 2021-04-17 | Luquillo | Puerto Rico | 72089 | 767 | |
1227965 | 1227965 | 2021-04-16 | Luquillo | Puerto Rico | 72089 | 751 | |
1224717 | 1224717 | 2021-04-15 | Luquillo | Puerto Rico | 72089 | 741 | |
1221470 | 1221470 | 2021-04-14 | Luquillo | Puerto Rico | 72089 | 733 | |
1218222 | 1218222 | 2021-04-13 | Luquillo | Puerto Rico | 72089 | 730 | |
1214974 | 1214974 | 2021-04-12 | Luquillo | Puerto Rico | 72089 | 727 | |
1211727 | 1211727 | 2021-04-11 | Luquillo | Puerto Rico | 72089 | 719 | |
1208478 | 1208478 | 2021-04-10 | Luquillo | Puerto Rico | 72089 | 709 | |
1205230 | 1205230 | 2021-04-09 | Luquillo | Puerto Rico | 72089 | 705 | |
1201982 | 1201982 | 2021-04-08 | Luquillo | Puerto Rico | 72089 | 694 | |
1198733 | 1198733 | 2021-04-07 | Luquillo | Puerto Rico | 72089 | 693 | |
1195484 | 1195484 | 2021-04-06 | Luquillo | Puerto Rico | 72089 | 693 |
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);