ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Ciales" 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 |
---|---|---|---|---|---|---|---|
1419477 | 1419477 | 2021-06-14 | Ciales | Puerto Rico | 72039 | 930 | |
1416232 | 1416232 | 2021-06-13 | Ciales | Puerto Rico | 72039 | 930 | |
1412986 | 1412986 | 2021-06-12 | Ciales | Puerto Rico | 72039 | 929 | |
1409741 | 1409741 | 2021-06-11 | Ciales | Puerto Rico | 72039 | 929 | |
1406496 | 1406496 | 2021-06-10 | Ciales | Puerto Rico | 72039 | 929 | |
1403250 | 1403250 | 2021-06-09 | Ciales | Puerto Rico | 72039 | 929 | |
1400005 | 1400005 | 2021-06-08 | Ciales | Puerto Rico | 72039 | 929 | |
1396760 | 1396760 | 2021-06-07 | Ciales | Puerto Rico | 72039 | 929 | |
1393513 | 1393513 | 2021-06-06 | Ciales | Puerto Rico | 72039 | 928 | |
1390268 | 1390268 | 2021-06-05 | Ciales | Puerto Rico | 72039 | 928 | |
1387023 | 1387023 | 2021-06-04 | Ciales | Puerto Rico | 72039 | 928 | |
1383778 | 1383778 | 2021-06-03 | Ciales | Puerto Rico | 72039 | 928 | |
1380532 | 1380532 | 2021-06-02 | Ciales | Puerto Rico | 72039 | 928 | |
1377287 | 1377287 | 2021-06-01 | Ciales | Puerto Rico | 72039 | 928 | |
1374041 | 1374041 | 2021-05-31 | Ciales | Puerto Rico | 72039 | 927 | |
1370796 | 1370796 | 2021-05-30 | Ciales | Puerto Rico | 72039 | 927 | |
1367550 | 1367550 | 2021-05-29 | Ciales | Puerto Rico | 72039 | 927 | |
1364304 | 1364304 | 2021-05-28 | Ciales | Puerto Rico | 72039 | 926 | |
1361058 | 1361058 | 2021-05-27 | Ciales | Puerto Rico | 72039 | 926 | |
1357812 | 1357812 | 2021-05-26 | Ciales | Puerto Rico | 72039 | 924 | |
1354566 | 1354566 | 2021-05-25 | Ciales | Puerto Rico | 72039 | 924 | |
1351320 | 1351320 | 2021-05-24 | Ciales | Puerto Rico | 72039 | 924 | |
1348074 | 1348074 | 2021-05-23 | Ciales | Puerto Rico | 72039 | 922 | |
1344826 | 1344826 | 2021-05-22 | Ciales | Puerto Rico | 72039 | 921 | |
1341578 | 1341578 | 2021-05-21 | Ciales | Puerto Rico | 72039 | 919 | |
1338330 | 1338330 | 2021-05-20 | Ciales | Puerto Rico | 72039 | 918 | |
1335083 | 1335083 | 2021-05-19 | Ciales | Puerto Rico | 72039 | 918 | |
1331836 | 1331836 | 2021-05-18 | Ciales | Puerto Rico | 72039 | 918 | |
1328589 | 1328589 | 2021-05-17 | Ciales | Puerto Rico | 72039 | 917 | |
1325343 | 1325343 | 2021-05-16 | Ciales | Puerto Rico | 72039 | 917 | |
1322097 | 1322097 | 2021-05-15 | Ciales | Puerto Rico | 72039 | 915 | |
1318851 | 1318851 | 2021-05-14 | Ciales | Puerto Rico | 72039 | 912 | |
1315603 | 1315603 | 2021-05-13 | Ciales | Puerto Rico | 72039 | 909 | |
1312357 | 1312357 | 2021-05-12 | Ciales | Puerto Rico | 72039 | 908 | |
1309110 | 1309110 | 2021-05-11 | Ciales | Puerto Rico | 72039 | 907 | |
1305864 | 1305864 | 2021-05-10 | Ciales | Puerto Rico | 72039 | 906 | |
1302618 | 1302618 | 2021-05-09 | Ciales | Puerto Rico | 72039 | 902 | |
1299371 | 1299371 | 2021-05-08 | Ciales | Puerto Rico | 72039 | 901 | |
1296124 | 1296124 | 2021-05-07 | Ciales | Puerto Rico | 72039 | 897 | |
1292878 | 1292878 | 2021-05-06 | Ciales | Puerto Rico | 72039 | 897 | |
1289632 | 1289632 | 2021-05-05 | Ciales | Puerto Rico | 72039 | 897 | |
1286386 | 1286386 | 2021-05-04 | Ciales | Puerto Rico | 72039 | 896 | |
1283140 | 1283140 | 2021-05-03 | Ciales | Puerto Rico | 72039 | 896 | |
1279893 | 1279893 | 2021-05-02 | Ciales | Puerto Rico | 72039 | 895 | |
1276646 | 1276646 | 2021-05-01 | Ciales | Puerto Rico | 72039 | 893 | |
1273399 | 1273399 | 2021-04-30 | Ciales | Puerto Rico | 72039 | 889 | |
1270152 | 1270152 | 2021-04-29 | Ciales | Puerto Rico | 72039 | 889 | |
1266905 | 1266905 | 2021-04-28 | Ciales | Puerto Rico | 72039 | 889 | |
1263658 | 1263658 | 2021-04-27 | Ciales | Puerto Rico | 72039 | 888 | |
1260411 | 1260411 | 2021-04-26 | Ciales | Puerto Rico | 72039 | 886 | |
1257164 | 1257164 | 2021-04-25 | Ciales | Puerto Rico | 72039 | 884 | |
1253917 | 1253917 | 2021-04-24 | Ciales | Puerto Rico | 72039 | 882 | |
1250670 | 1250670 | 2021-04-23 | Ciales | Puerto Rico | 72039 | 876 | |
1247423 | 1247423 | 2021-04-22 | Ciales | Puerto Rico | 72039 | 872 | |
1244176 | 1244176 | 2021-04-21 | Ciales | Puerto Rico | 72039 | 872 | |
1240929 | 1240929 | 2021-04-20 | Ciales | Puerto Rico | 72039 | 871 | |
1237682 | 1237682 | 2021-04-19 | Ciales | Puerto Rico | 72039 | 863 | |
1234435 | 1234435 | 2021-04-18 | Ciales | Puerto Rico | 72039 | 861 | |
1231187 | 1231187 | 2021-04-17 | Ciales | Puerto Rico | 72039 | 856 | |
1227939 | 1227939 | 2021-04-16 | Ciales | Puerto Rico | 72039 | 842 | |
1224691 | 1224691 | 2021-04-15 | Ciales | Puerto Rico | 72039 | 837 | |
1221444 | 1221444 | 2021-04-14 | Ciales | Puerto Rico | 72039 | 837 | |
1218196 | 1218196 | 2021-04-13 | Ciales | Puerto Rico | 72039 | 837 | |
1214948 | 1214948 | 2021-04-12 | Ciales | Puerto Rico | 72039 | 832 | |
1211701 | 1211701 | 2021-04-11 | Ciales | Puerto Rico | 72039 | 824 | |
1208452 | 1208452 | 2021-04-10 | Ciales | Puerto Rico | 72039 | 822 | |
1205204 | 1205204 | 2021-04-09 | Ciales | Puerto Rico | 72039 | 812 | |
1201956 | 1201956 | 2021-04-08 | Ciales | Puerto Rico | 72039 | 802 | |
1198707 | 1198707 | 2021-04-07 | Ciales | Puerto Rico | 72039 | 801 | |
1195458 | 1195458 | 2021-04-06 | Ciales | Puerto Rico | 72039 | 800 | |
1192210 | 1192210 | 2021-04-05 | Ciales | Puerto Rico | 72039 | 800 | |
1188961 | 1188961 | 2021-04-04 | Ciales | Puerto Rico | 72039 | 798 | |
1185714 | 1185714 | 2021-04-03 | Ciales | Puerto Rico | 72039 | 794 | |
1182467 | 1182467 | 2021-04-02 | Ciales | Puerto Rico | 72039 | 787 | |
1179220 | 1179220 | 2021-04-01 | Ciales | Puerto Rico | 72039 | 784 | |
1175973 | 1175973 | 2021-03-31 | Ciales | Puerto Rico | 72039 | 779 | |
1172726 | 1172726 | 2021-03-30 | Ciales | Puerto Rico | 72039 | 777 | |
1169479 | 1169479 | 2021-03-29 | Ciales | Puerto Rico | 72039 | 776 | |
1166231 | 1166231 | 2021-03-28 | Ciales | Puerto Rico | 72039 | 774 | |
1162983 | 1162983 | 2021-03-27 | Ciales | Puerto Rico | 72039 | 774 | |
1159734 | 1159734 | 2021-03-26 | Ciales | Puerto Rico | 72039 | 774 | |
1156487 | 1156487 | 2021-03-25 | Ciales | Puerto Rico | 72039 | 772 | |
1153240 | 1153240 | 2021-03-24 | Ciales | Puerto Rico | 72039 | 772 | |
1149993 | 1149993 | 2021-03-23 | Ciales | Puerto Rico | 72039 | 772 | |
1146746 | 1146746 | 2021-03-22 | Ciales | Puerto Rico | 72039 | 768 | |
1143499 | 1143499 | 2021-03-21 | Ciales | Puerto Rico | 72039 | 766 | |
1140252 | 1140252 | 2021-03-20 | Ciales | Puerto Rico | 72039 | 765 | |
1137006 | 1137006 | 2021-03-19 | Ciales | Puerto Rico | 72039 | 765 | |
1133760 | 1133760 | 2021-03-18 | Ciales | Puerto Rico | 72039 | 761 | |
1130512 | 1130512 | 2021-03-17 | Ciales | Puerto Rico | 72039 | 761 | |
1127265 | 1127265 | 2021-03-16 | Ciales | Puerto Rico | 72039 | 758 | |
1124019 | 1124019 | 2021-03-15 | Ciales | Puerto Rico | 72039 | 756 | |
1120773 | 1120773 | 2021-03-14 | Ciales | Puerto Rico | 72039 | 754 | |
1117526 | 1117526 | 2021-03-13 | Ciales | Puerto Rico | 72039 | 751 | |
1114279 | 1114279 | 2021-03-12 | Ciales | Puerto Rico | 72039 | 751 | |
1111033 | 1111033 | 2021-03-11 | Ciales | Puerto Rico | 72039 | 751 | |
1107787 | 1107787 | 2021-03-10 | Ciales | Puerto Rico | 72039 | 747 | |
1104541 | 1104541 | 2021-03-09 | Ciales | Puerto Rico | 72039 | 747 | |
1101295 | 1101295 | 2021-03-08 | Ciales | Puerto Rico | 72039 | 747 | |
1098049 | 1098049 | 2021-03-07 | Ciales | Puerto Rico | 72039 | 744 |
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);