ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Las Marias" 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 |
---|---|---|---|---|---|---|---|
1419500 | 1419500 | 2021-06-14 | Las Marias | Puerto Rico | 72083 | 323 | |
1416255 | 1416255 | 2021-06-13 | Las Marias | Puerto Rico | 72083 | 323 | |
1413009 | 1413009 | 2021-06-12 | Las Marias | Puerto Rico | 72083 | 322 | |
1409764 | 1409764 | 2021-06-11 | Las Marias | Puerto Rico | 72083 | 322 | |
1406519 | 1406519 | 2021-06-10 | Las Marias | Puerto Rico | 72083 | 322 | |
1403273 | 1403273 | 2021-06-09 | Las Marias | Puerto Rico | 72083 | 322 | |
1400028 | 1400028 | 2021-06-08 | Las Marias | Puerto Rico | 72083 | 321 | |
1396783 | 1396783 | 2021-06-07 | Las Marias | Puerto Rico | 72083 | 320 | |
1393536 | 1393536 | 2021-06-06 | Las Marias | Puerto Rico | 72083 | 318 | |
1390291 | 1390291 | 2021-06-05 | Las Marias | Puerto Rico | 72083 | 317 | |
1387046 | 1387046 | 2021-06-04 | Las Marias | Puerto Rico | 72083 | 317 | |
1383801 | 1383801 | 2021-06-03 | Las Marias | Puerto Rico | 72083 | 314 | |
1380555 | 1380555 | 2021-06-02 | Las Marias | Puerto Rico | 72083 | 314 | |
1377310 | 1377310 | 2021-06-01 | Las Marias | Puerto Rico | 72083 | 314 | |
1374064 | 1374064 | 2021-05-31 | Las Marias | Puerto Rico | 72083 | 314 | |
1370819 | 1370819 | 2021-05-30 | Las Marias | Puerto Rico | 72083 | 314 | |
1367573 | 1367573 | 2021-05-29 | Las Marias | Puerto Rico | 72083 | 309 | |
1364327 | 1364327 | 2021-05-28 | Las Marias | Puerto Rico | 72083 | 306 | |
1361081 | 1361081 | 2021-05-27 | Las Marias | Puerto Rico | 72083 | 306 | |
1357835 | 1357835 | 2021-05-26 | Las Marias | Puerto Rico | 72083 | 302 | |
1354589 | 1354589 | 2021-05-25 | Las Marias | Puerto Rico | 72083 | 302 | |
1351343 | 1351343 | 2021-05-24 | Las Marias | Puerto Rico | 72083 | 302 | |
1348097 | 1348097 | 2021-05-23 | Las Marias | Puerto Rico | 72083 | 302 | |
1344849 | 1344849 | 2021-05-22 | Las Marias | Puerto Rico | 72083 | 299 | |
1341601 | 1341601 | 2021-05-21 | Las Marias | Puerto Rico | 72083 | 298 | |
1338353 | 1338353 | 2021-05-20 | Las Marias | Puerto Rico | 72083 | 297 | |
1335106 | 1335106 | 2021-05-19 | Las Marias | Puerto Rico | 72083 | 295 | |
1331859 | 1331859 | 2021-05-18 | Las Marias | Puerto Rico | 72083 | 294 | |
1328612 | 1328612 | 2021-05-17 | Las Marias | Puerto Rico | 72083 | 294 | |
1325366 | 1325366 | 2021-05-16 | Las Marias | Puerto Rico | 72083 | 294 | |
1322120 | 1322120 | 2021-05-15 | Las Marias | Puerto Rico | 72083 | 293 | |
1318874 | 1318874 | 2021-05-14 | Las Marias | Puerto Rico | 72083 | 293 | |
1315626 | 1315626 | 2021-05-13 | Las Marias | Puerto Rico | 72083 | 291 | |
1312380 | 1312380 | 2021-05-12 | Las Marias | Puerto Rico | 72083 | 291 | |
1309133 | 1309133 | 2021-05-11 | Las Marias | Puerto Rico | 72083 | 291 | |
1305887 | 1305887 | 2021-05-10 | Las Marias | Puerto Rico | 72083 | 291 | |
1302641 | 1302641 | 2021-05-09 | Las Marias | Puerto Rico | 72083 | 291 | |
1299394 | 1299394 | 2021-05-08 | Las Marias | Puerto Rico | 72083 | 288 | |
1296147 | 1296147 | 2021-05-07 | Las Marias | Puerto Rico | 72083 | 288 | |
1292901 | 1292901 | 2021-05-06 | Las Marias | Puerto Rico | 72083 | 286 | |
1289655 | 1289655 | 2021-05-05 | Las Marias | Puerto Rico | 72083 | 285 | |
1286409 | 1286409 | 2021-05-04 | Las Marias | Puerto Rico | 72083 | 285 | |
1283163 | 1283163 | 2021-05-03 | Las Marias | Puerto Rico | 72083 | 284 | |
1279916 | 1279916 | 2021-05-02 | Las Marias | Puerto Rico | 72083 | 282 | |
1276669 | 1276669 | 2021-05-01 | Las Marias | Puerto Rico | 72083 | 276 | |
1273422 | 1273422 | 2021-04-30 | Las Marias | Puerto Rico | 72083 | 275 | |
1270175 | 1270175 | 2021-04-29 | Las Marias | Puerto Rico | 72083 | 272 | |
1266928 | 1266928 | 2021-04-28 | Las Marias | Puerto Rico | 72083 | 270 | |
1263681 | 1263681 | 2021-04-27 | Las Marias | Puerto Rico | 72083 | 267 | |
1260434 | 1260434 | 2021-04-26 | Las Marias | Puerto Rico | 72083 | 261 | |
1257187 | 1257187 | 2021-04-25 | Las Marias | Puerto Rico | 72083 | 259 | |
1253940 | 1253940 | 2021-04-24 | Las Marias | Puerto Rico | 72083 | 256 | |
1250693 | 1250693 | 2021-04-23 | Las Marias | Puerto Rico | 72083 | 253 | |
1247446 | 1247446 | 2021-04-22 | Las Marias | Puerto Rico | 72083 | 253 | |
1244199 | 1244199 | 2021-04-21 | Las Marias | Puerto Rico | 72083 | 248 | |
1240952 | 1240952 | 2021-04-20 | Las Marias | Puerto Rico | 72083 | 242 | |
1237705 | 1237705 | 2021-04-19 | Las Marias | Puerto Rico | 72083 | 238 | |
1234458 | 1234458 | 2021-04-18 | Las Marias | Puerto Rico | 72083 | 234 | |
1231210 | 1231210 | 2021-04-17 | Las Marias | Puerto Rico | 72083 | 231 | |
1227962 | 1227962 | 2021-04-16 | Las Marias | Puerto Rico | 72083 | 229 | |
1224714 | 1224714 | 2021-04-15 | Las Marias | Puerto Rico | 72083 | 228 | |
1221467 | 1221467 | 2021-04-14 | Las Marias | Puerto Rico | 72083 | 228 | |
1218219 | 1218219 | 2021-04-13 | Las Marias | Puerto Rico | 72083 | 228 | |
1214971 | 1214971 | 2021-04-12 | Las Marias | Puerto Rico | 72083 | 225 | |
1211724 | 1211724 | 2021-04-11 | Las Marias | Puerto Rico | 72083 | 223 | |
1208475 | 1208475 | 2021-04-10 | Las Marias | Puerto Rico | 72083 | 221 | |
1205227 | 1205227 | 2021-04-09 | Las Marias | Puerto Rico | 72083 | 220 | |
1201979 | 1201979 | 2021-04-08 | Las Marias | Puerto Rico | 72083 | 219 | |
1198730 | 1198730 | 2021-04-07 | Las Marias | Puerto Rico | 72083 | 217 | |
1195481 | 1195481 | 2021-04-06 | Las Marias | Puerto Rico | 72083 | 216 | |
1192233 | 1192233 | 2021-04-05 | Las Marias | Puerto Rico | 72083 | 216 | |
1188984 | 1188984 | 2021-04-04 | Las Marias | Puerto Rico | 72083 | 215 | |
1185737 | 1185737 | 2021-04-03 | Las Marias | Puerto Rico | 72083 | 212 | |
1182490 | 1182490 | 2021-04-02 | Las Marias | Puerto Rico | 72083 | 211 | |
1179243 | 1179243 | 2021-04-01 | Las Marias | Puerto Rico | 72083 | 210 | |
1175996 | 1175996 | 2021-03-31 | Las Marias | Puerto Rico | 72083 | 210 | |
1172749 | 1172749 | 2021-03-30 | Las Marias | Puerto Rico | 72083 | 210 | |
1169502 | 1169502 | 2021-03-29 | Las Marias | Puerto Rico | 72083 | 210 | |
1166254 | 1166254 | 2021-03-28 | Las Marias | Puerto Rico | 72083 | 209 | |
1163006 | 1163006 | 2021-03-27 | Las Marias | Puerto Rico | 72083 | 209 | |
1159757 | 1159757 | 2021-03-26 | Las Marias | Puerto Rico | 72083 | 209 | |
1156510 | 1156510 | 2021-03-25 | Las Marias | Puerto Rico | 72083 | 208 | |
1153263 | 1153263 | 2021-03-24 | Las Marias | Puerto Rico | 72083 | 208 | |
1150016 | 1150016 | 2021-03-23 | Las Marias | Puerto Rico | 72083 | 208 | |
1146769 | 1146769 | 2021-03-22 | Las Marias | Puerto Rico | 72083 | 208 | |
1143522 | 1143522 | 2021-03-21 | Las Marias | Puerto Rico | 72083 | 207 | |
1140275 | 1140275 | 2021-03-20 | Las Marias | Puerto Rico | 72083 | 207 | |
1137029 | 1137029 | 2021-03-19 | Las Marias | Puerto Rico | 72083 | 207 | |
1133783 | 1133783 | 2021-03-18 | Las Marias | Puerto Rico | 72083 | 207 | |
1130535 | 1130535 | 2021-03-17 | Las Marias | Puerto Rico | 72083 | 206 | |
1127288 | 1127288 | 2021-03-16 | Las Marias | Puerto Rico | 72083 | 206 | |
1124042 | 1124042 | 2021-03-15 | Las Marias | Puerto Rico | 72083 | 206 | |
1120796 | 1120796 | 2021-03-14 | Las Marias | Puerto Rico | 72083 | 206 | |
1117549 | 1117549 | 2021-03-13 | Las Marias | Puerto Rico | 72083 | 206 | |
1114302 | 1114302 | 2021-03-12 | Las Marias | Puerto Rico | 72083 | 206 | |
1111056 | 1111056 | 2021-03-11 | Las Marias | Puerto Rico | 72083 | 206 | |
1107810 | 1107810 | 2021-03-10 | Las Marias | Puerto Rico | 72083 | 206 | |
1104564 | 1104564 | 2021-03-09 | Las Marias | Puerto Rico | 72083 | 206 | |
1101318 | 1101318 | 2021-03-08 | Las Marias | Puerto Rico | 72083 | 207 | |
1098072 | 1098072 | 2021-03-07 | Las Marias | Puerto Rico | 72083 | 205 |
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);