ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Unknown" 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 |
---|---|---|---|---|---|---|---|
637284 | 637284 | 2020-10-16 | Unknown | Puerto Rico | 1651 | 758 | |
634038 | 634038 | 2020-10-15 | Unknown | Puerto Rico | 1650 | 743 | |
630793 | 630793 | 2020-10-14 | Unknown | Puerto Rico | 1634 | 742 | |
627549 | 627549 | 2020-10-13 | Unknown | Puerto Rico | 1566 | 738 | |
624307 | 624307 | 2020-10-12 | Unknown | Puerto Rico | 1557 | 735 | |
621064 | 621064 | 2020-10-11 | Unknown | Puerto Rico | 1528 | 730 | |
617821 | 617821 | 2020-10-10 | Unknown | Puerto Rico | 1511 | 728 | |
614579 | 614579 | 2020-10-09 | Unknown | Puerto Rico | 1470 | 720 | |
611338 | 611338 | 2020-10-08 | Unknown | Puerto Rico | 1455 | 715 | |
608096 | 608096 | 2020-10-07 | Unknown | Puerto Rico | 1439 | 705 | |
604853 | 604853 | 2020-10-06 | Unknown | Puerto Rico | 1439 | 696 | |
601611 | 601611 | 2020-10-05 | Unknown | Puerto Rico | 1426 | 695 | |
598368 | 598368 | 2020-10-04 | Unknown | Puerto Rico | 1396 | 686 | |
595125 | 595125 | 2020-10-03 | Unknown | Puerto Rico | 1394 | 681 | |
591884 | 591884 | 2020-10-02 | Unknown | Puerto Rico | 1343 | 673 | |
588643 | 588643 | 2020-10-01 | Unknown | Puerto Rico | 1389 | 665 | |
585403 | 585403 | 2020-09-30 | Unknown | Puerto Rico | 1425 | 661 | |
582163 | 582163 | 2020-09-29 | Unknown | Puerto Rico | 1393 | 654 | |
578923 | 578923 | 2020-09-28 | Unknown | Puerto Rico | 1344 | 648 | |
575682 | 575682 | 2020-09-27 | Unknown | Puerto Rico | 1311 | 644 | |
572438 | 572438 | 2020-09-26 | Unknown | Puerto Rico | 1310 | 642 | |
569196 | 569196 | 2020-09-25 | Unknown | Puerto Rico | 1326 | 635 | |
565955 | 565955 | 2020-09-24 | Unknown | Puerto Rico | 1332 | 627 | |
562714 | 562714 | 2020-09-23 | Unknown | Puerto Rico | 1315 | 617 | |
559477 | 559477 | 2020-09-22 | Unknown | Puerto Rico | 1352 | 613 | |
556240 | 556240 | 2020-09-21 | Unknown | Puerto Rico | 1352 | 609 | |
553003 | 553003 | 2020-09-20 | Unknown | Puerto Rico | 1334 | 608 | |
549764 | 549764 | 2020-09-19 | Unknown | Puerto Rico | 1333 | 605 | |
546525 | 546525 | 2020-09-18 | Unknown | Puerto Rico | 1305 | 599 | |
543288 | 543288 | 2020-09-17 | Unknown | Puerto Rico | 1244 | 588 | |
540052 | 540052 | 2020-09-16 | Unknown | Puerto Rico | 1252 | 570 | |
536815 | 536815 | 2020-09-15 | Unknown | Puerto Rico | 1277 | 551 | |
533579 | 533579 | 2020-09-14 | Unknown | Puerto Rico | 1270 | 542 | |
530344 | 530344 | 2020-09-13 | Unknown | Puerto Rico | 1266 | 539 | |
527107 | 527107 | 2020-09-12 | Unknown | Puerto Rico | 1281 | 535 | |
523871 | 523871 | 2020-09-11 | Unknown | Puerto Rico | 1275 | 523 | |
520635 | 520635 | 2020-09-10 | Unknown | Puerto Rico | 1325 | 512 | |
517399 | 517399 | 2020-09-09 | Unknown | Puerto Rico | 1299 | 500 | |
514164 | 514164 | 2020-09-08 | Unknown | Puerto Rico | 1299 | 482 | |
510931 | 510931 | 2020-09-07 | Unknown | Puerto Rico | 1298 | 477 | |
507698 | 507698 | 2020-09-06 | Unknown | Puerto Rico | 1255 | 477 | |
504466 | 504466 | 2020-09-05 | Unknown | Puerto Rico | 1291 | 464 | |
501232 | 501232 | 2020-09-04 | Unknown | Puerto Rico | 1283 | 455 | |
497998 | 497998 | 2020-09-03 | Unknown | Puerto Rico | 1296 | 448 | |
494765 | 494765 | 2020-09-02 | Unknown | Puerto Rico | 1356 | 443 | |
491531 | 491531 | 2020-09-01 | Unknown | Puerto Rico | 1336 | 435 | |
488298 | 488298 | 2020-08-31 | Unknown | Puerto Rico | 1320 | 434 | |
485065 | 485065 | 2020-08-30 | Unknown | Puerto Rico | 1294 | 434 | |
481830 | 481830 | 2020-08-29 | Unknown | Puerto Rico | 1313 | 428 | |
478596 | 478596 | 2020-08-28 | Unknown | Puerto Rico | 1328 | 424 | |
475363 | 475363 | 2020-08-27 | Unknown | Puerto Rico | 1329 | 412 | |
472129 | 472129 | 2020-08-26 | Unknown | Puerto Rico | 1306 | 404 | |
468897 | 468897 | 2020-08-25 | Unknown | Puerto Rico | 1383 | 395 | |
465669 | 465669 | 2020-08-24 | Unknown | Puerto Rico | 1376 | 390 | |
462440 | 462440 | 2020-08-23 | Unknown | Puerto Rico | 1296 | 390 | |
459212 | 459212 | 2020-08-22 | Unknown | Puerto Rico | 1348 | 381 | |
455984 | 455984 | 2020-08-21 | Unknown | Puerto Rico | 1303 | 374 | |
452756 | 452756 | 2020-08-20 | Unknown | Puerto Rico | 1305 | 367 | |
449528 | 449528 | 2020-08-19 | Unknown | Puerto Rico | 1366 | 356 | |
446300 | 446300 | 2020-08-18 | Unknown | Puerto Rico | 1401 | 346 | |
443074 | 443074 | 2020-08-17 | Unknown | Puerto Rico | 1274 | 335 | |
439847 | 439847 | 2020-08-16 | Unknown | Puerto Rico | 1198 | 335 | |
436622 | 436622 | 2020-08-15 | Unknown | Puerto Rico | 1199 | 329 | |
433395 | 433395 | 2020-08-14 | Unknown | Puerto Rico | 1179 | 317 | |
430169 | 430169 | 2020-08-13 | Unknown | Puerto Rico | 1192 | 306 | |
426944 | 426944 | 2020-08-12 | Unknown | Puerto Rico | 1233 | 295 | |
423721 | 423721 | 2020-08-11 | Unknown | Puerto Rico | 1198 | 287 | |
420498 | 420498 | 2020-08-10 | Unknown | Puerto Rico | 1204 | 279 | |
417278 | 417278 | 2020-08-09 | Unknown | Puerto Rico | 1165 | 279 | |
414057 | 414057 | 2020-08-08 | Unknown | Puerto Rico | 1166 | 274 | |
410837 | 410837 | 2020-08-07 | Unknown | Puerto Rico | 1118 | 265 | |
407617 | 407617 | 2020-08-06 | Unknown | Puerto Rico | 1117 | 258 | |
404398 | 404398 | 2020-08-05 | Unknown | Puerto Rico | 1149 | 246 | |
401180 | 401180 | 2020-08-04 | Unknown | Puerto Rico | 1199 | 237 | |
397965 | 397965 | 2020-08-03 | Unknown | Puerto Rico | 1159 | 230 | |
394748 | 394748 | 2020-08-02 | Unknown | Puerto Rico | 1142 | 230 | |
391532 | 391532 | 2020-08-01 | Unknown | Puerto Rico | 1070 | 225 | |
388315 | 388315 | 2020-07-31 | Unknown | Puerto Rico | 970 | 219 | |
385098 | 385098 | 2020-07-30 | Unknown | Puerto Rico | 990 | 214 | |
381880 | 381880 | 2020-07-29 | Unknown | Puerto Rico | 986 | 211 | |
378663 | 378663 | 2020-07-28 | Unknown | Puerto Rico | 969 | 209 | |
375447 | 375447 | 2020-07-27 | Unknown | Puerto Rico | 927 | 201 | |
372234 | 372234 | 2020-07-26 | Unknown | Puerto Rico | 893 | 201 | |
369022 | 369022 | 2020-07-25 | Unknown | Puerto Rico | 833 | 201 | |
365813 | 365813 | 2020-07-24 | Unknown | Puerto Rico | 827 | 191 | |
362607 | 362607 | 2020-07-23 | Unknown | Puerto Rico | 780 | 188 | |
359401 | 359401 | 2020-07-22 | Unknown | Puerto Rico | 798 | 185 | |
356197 | 356197 | 2020-07-21 | Unknown | Puerto Rico | 827 | 180 | |
352994 | 352994 | 2020-07-20 | Unknown | Puerto Rico | 790 | 180 | |
349791 | 349791 | 2020-07-19 | Unknown | Puerto Rico | 742 | 178 | |
346591 | 346591 | 2020-07-18 | Unknown | Puerto Rico | 669 | 178 | |
343391 | 343391 | 2020-07-17 | Unknown | Puerto Rico | 622 | 177 | |
340193 | 340193 | 2020-07-16 | Unknown | Puerto Rico | 509 | 172 | |
336996 | 336996 | 2020-07-15 | Unknown | Puerto Rico | 477 | 171 | |
333802 | 333802 | 2020-07-14 | Unknown | Puerto Rico | 467 | 169 | |
330610 | 330610 | 2020-07-13 | Unknown | Puerto Rico | 449 | 167 | |
327424 | 327424 | 2020-07-12 | Unknown | Puerto Rico | 448 | 167 | |
324239 | 324239 | 2020-07-11 | Unknown | Puerto Rico | 411 | 167 | |
321059 | 321059 | 2020-07-10 | Unknown | Puerto Rico | 383 | 159 | |
317881 | 317881 | 2020-07-09 | Unknown | Puerto Rico | 396 | 159 |
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);