ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72055 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 |
---|---|---|---|---|---|---|---|
1419486 | 1419486 | 2021-06-14 | Guanica | Puerto Rico | 72055 | 339 | |
1416241 | 1416241 | 2021-06-13 | Guanica | Puerto Rico | 72055 | 339 | |
1412995 | 1412995 | 2021-06-12 | Guanica | Puerto Rico | 72055 | 339 | |
1409750 | 1409750 | 2021-06-11 | Guanica | Puerto Rico | 72055 | 339 | |
1406505 | 1406505 | 2021-06-10 | Guanica | Puerto Rico | 72055 | 339 | |
1403259 | 1403259 | 2021-06-09 | Guanica | Puerto Rico | 72055 | 339 | |
1400014 | 1400014 | 2021-06-08 | Guanica | Puerto Rico | 72055 | 339 | |
1396769 | 1396769 | 2021-06-07 | Guanica | Puerto Rico | 72055 | 339 | |
1393522 | 1393522 | 2021-06-06 | Guanica | Puerto Rico | 72055 | 339 | |
1390277 | 1390277 | 2021-06-05 | Guanica | Puerto Rico | 72055 | 339 | |
1387032 | 1387032 | 2021-06-04 | Guanica | Puerto Rico | 72055 | 339 | |
1383787 | 1383787 | 2021-06-03 | Guanica | Puerto Rico | 72055 | 339 | |
1380541 | 1380541 | 2021-06-02 | Guanica | Puerto Rico | 72055 | 339 | |
1377296 | 1377296 | 2021-06-01 | Guanica | Puerto Rico | 72055 | 339 | |
1374050 | 1374050 | 2021-05-31 | Guanica | Puerto Rico | 72055 | 339 | |
1370805 | 1370805 | 2021-05-30 | Guanica | Puerto Rico | 72055 | 339 | |
1367559 | 1367559 | 2021-05-29 | Guanica | Puerto Rico | 72055 | 338 | |
1364313 | 1364313 | 2021-05-28 | Guanica | Puerto Rico | 72055 | 338 | |
1361067 | 1361067 | 2021-05-27 | Guanica | Puerto Rico | 72055 | 338 | |
1357821 | 1357821 | 2021-05-26 | Guanica | Puerto Rico | 72055 | 338 | |
1354575 | 1354575 | 2021-05-25 | Guanica | Puerto Rico | 72055 | 338 | |
1351329 | 1351329 | 2021-05-24 | Guanica | Puerto Rico | 72055 | 335 | |
1348083 | 1348083 | 2021-05-23 | Guanica | Puerto Rico | 72055 | 333 | |
1344835 | 1344835 | 2021-05-22 | Guanica | Puerto Rico | 72055 | 333 | |
1341587 | 1341587 | 2021-05-21 | Guanica | Puerto Rico | 72055 | 333 | |
1338339 | 1338339 | 2021-05-20 | Guanica | Puerto Rico | 72055 | 329 | |
1335092 | 1335092 | 2021-05-19 | Guanica | Puerto Rico | 72055 | 329 | |
1331845 | 1331845 | 2021-05-18 | Guanica | Puerto Rico | 72055 | 328 | |
1328598 | 1328598 | 2021-05-17 | Guanica | Puerto Rico | 72055 | 327 | |
1325352 | 1325352 | 2021-05-16 | Guanica | Puerto Rico | 72055 | 324 | |
1322106 | 1322106 | 2021-05-15 | Guanica | Puerto Rico | 72055 | 320 | |
1318860 | 1318860 | 2021-05-14 | Guanica | Puerto Rico | 72055 | 315 | |
1315612 | 1315612 | 2021-05-13 | Guanica | Puerto Rico | 72055 | 312 | |
1312366 | 1312366 | 2021-05-12 | Guanica | Puerto Rico | 72055 | 311 | |
1309119 | 1309119 | 2021-05-11 | Guanica | Puerto Rico | 72055 | 311 | |
1305873 | 1305873 | 2021-05-10 | Guanica | Puerto Rico | 72055 | 311 | |
1302627 | 1302627 | 2021-05-09 | Guanica | Puerto Rico | 72055 | 310 | |
1299380 | 1299380 | 2021-05-08 | Guanica | Puerto Rico | 72055 | 310 | |
1296133 | 1296133 | 2021-05-07 | Guanica | Puerto Rico | 72055 | 309 | |
1292887 | 1292887 | 2021-05-06 | Guanica | Puerto Rico | 72055 | 308 | |
1289641 | 1289641 | 2021-05-05 | Guanica | Puerto Rico | 72055 | 307 | |
1286395 | 1286395 | 2021-05-04 | Guanica | Puerto Rico | 72055 | 307 | |
1283149 | 1283149 | 2021-05-03 | Guanica | Puerto Rico | 72055 | 307 | |
1279902 | 1279902 | 2021-05-02 | Guanica | Puerto Rico | 72055 | 307 | |
1276655 | 1276655 | 2021-05-01 | Guanica | Puerto Rico | 72055 | 305 | |
1273408 | 1273408 | 2021-04-30 | Guanica | Puerto Rico | 72055 | 304 | |
1270161 | 1270161 | 2021-04-29 | Guanica | Puerto Rico | 72055 | 302 | |
1266914 | 1266914 | 2021-04-28 | Guanica | Puerto Rico | 72055 | 301 | |
1263667 | 1263667 | 2021-04-27 | Guanica | Puerto Rico | 72055 | 301 | |
1260420 | 1260420 | 2021-04-26 | Guanica | Puerto Rico | 72055 | 299 | |
1257173 | 1257173 | 2021-04-25 | Guanica | Puerto Rico | 72055 | 296 | |
1253926 | 1253926 | 2021-04-24 | Guanica | Puerto Rico | 72055 | 290 | |
1250679 | 1250679 | 2021-04-23 | Guanica | Puerto Rico | 72055 | 290 | |
1247432 | 1247432 | 2021-04-22 | Guanica | Puerto Rico | 72055 | 286 | |
1244185 | 1244185 | 2021-04-21 | Guanica | Puerto Rico | 72055 | 284 | |
1240938 | 1240938 | 2021-04-20 | Guanica | Puerto Rico | 72055 | 284 | |
1237691 | 1237691 | 2021-04-19 | Guanica | Puerto Rico | 72055 | 284 | |
1234444 | 1234444 | 2021-04-18 | Guanica | Puerto Rico | 72055 | 282 | |
1231196 | 1231196 | 2021-04-17 | Guanica | Puerto Rico | 72055 | 279 | |
1227948 | 1227948 | 2021-04-16 | Guanica | Puerto Rico | 72055 | 278 | |
1224700 | 1224700 | 2021-04-15 | Guanica | Puerto Rico | 72055 | 278 | |
1221453 | 1221453 | 2021-04-14 | Guanica | Puerto Rico | 72055 | 277 | |
1218205 | 1218205 | 2021-04-13 | Guanica | Puerto Rico | 72055 | 275 | |
1214957 | 1214957 | 2021-04-12 | Guanica | Puerto Rico | 72055 | 271 | |
1211710 | 1211710 | 2021-04-11 | Guanica | Puerto Rico | 72055 | 270 | |
1208461 | 1208461 | 2021-04-10 | Guanica | Puerto Rico | 72055 | 269 | |
1205213 | 1205213 | 2021-04-09 | Guanica | Puerto Rico | 72055 | 268 | |
1201965 | 1201965 | 2021-04-08 | Guanica | Puerto Rico | 72055 | 264 | |
1198716 | 1198716 | 2021-04-07 | Guanica | Puerto Rico | 72055 | 263 | |
1195467 | 1195467 | 2021-04-06 | Guanica | Puerto Rico | 72055 | 263 | |
1192219 | 1192219 | 2021-04-05 | Guanica | Puerto Rico | 72055 | 263 | |
1188970 | 1188970 | 2021-04-04 | Guanica | Puerto Rico | 72055 | 263 | |
1185723 | 1185723 | 2021-04-03 | Guanica | Puerto Rico | 72055 | 263 | |
1182476 | 1182476 | 2021-04-02 | Guanica | Puerto Rico | 72055 | 263 | |
1179229 | 1179229 | 2021-04-01 | Guanica | Puerto Rico | 72055 | 263 | |
1175982 | 1175982 | 2021-03-31 | Guanica | Puerto Rico | 72055 | 263 | |
1172735 | 1172735 | 2021-03-30 | Guanica | Puerto Rico | 72055 | 263 | |
1169488 | 1169488 | 2021-03-29 | Guanica | Puerto Rico | 72055 | 261 | |
1166240 | 1166240 | 2021-03-28 | Guanica | Puerto Rico | 72055 | 259 | |
1162992 | 1162992 | 2021-03-27 | Guanica | Puerto Rico | 72055 | 259 | |
1159743 | 1159743 | 2021-03-26 | Guanica | Puerto Rico | 72055 | 258 | |
1156496 | 1156496 | 2021-03-25 | Guanica | Puerto Rico | 72055 | 258 | |
1153249 | 1153249 | 2021-03-24 | Guanica | Puerto Rico | 72055 | 258 | |
1150002 | 1150002 | 2021-03-23 | Guanica | Puerto Rico | 72055 | 257 | |
1146755 | 1146755 | 2021-03-22 | Guanica | Puerto Rico | 72055 | 257 | |
1143508 | 1143508 | 2021-03-21 | Guanica | Puerto Rico | 72055 | 257 | |
1140261 | 1140261 | 2021-03-20 | Guanica | Puerto Rico | 72055 | 257 | |
1137015 | 1137015 | 2021-03-19 | Guanica | Puerto Rico | 72055 | 257 | |
1133769 | 1133769 | 2021-03-18 | Guanica | Puerto Rico | 72055 | 256 | |
1130521 | 1130521 | 2021-03-17 | Guanica | Puerto Rico | 72055 | 256 | |
1127274 | 1127274 | 2021-03-16 | Guanica | Puerto Rico | 72055 | 256 | |
1124028 | 1124028 | 2021-03-15 | Guanica | Puerto Rico | 72055 | 256 | |
1120782 | 1120782 | 2021-03-14 | Guanica | Puerto Rico | 72055 | 256 | |
1117535 | 1117535 | 2021-03-13 | Guanica | Puerto Rico | 72055 | 256 | |
1114288 | 1114288 | 2021-03-12 | Guanica | Puerto Rico | 72055 | 256 | |
1111042 | 1111042 | 2021-03-11 | Guanica | Puerto Rico | 72055 | 256 | |
1107796 | 1107796 | 2021-03-10 | Guanica | Puerto Rico | 72055 | 256 | |
1104550 | 1104550 | 2021-03-09 | Guanica | Puerto Rico | 72055 | 256 | |
1101304 | 1101304 | 2021-03-08 | Guanica | Puerto Rico | 72055 | 256 | |
1098058 | 1098058 | 2021-03-07 | Guanica | Puerto Rico | 72055 | 254 |
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);