ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72089 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 |
---|---|---|---|---|---|---|---|
1065616 | 1065616 | 2021-02-25 | Luquillo | Puerto Rico | 72089 | 665 | |
1062371 | 1062371 | 2021-02-24 | Luquillo | Puerto Rico | 72089 | 665 | |
1059126 | 1059126 | 2021-02-23 | Luquillo | Puerto Rico | 72089 | 665 | |
1055880 | 1055880 | 2021-02-22 | Luquillo | Puerto Rico | 72089 | 664 | |
1052634 | 1052634 | 2021-02-21 | Luquillo | Puerto Rico | 72089 | 664 | |
1049387 | 1049387 | 2021-02-20 | Luquillo | Puerto Rico | 72089 | 663 | |
1046140 | 1046140 | 2021-02-19 | Luquillo | Puerto Rico | 72089 | 658 | |
1042895 | 1042895 | 2021-02-18 | Luquillo | Puerto Rico | 72089 | 659 | |
1039650 | 1039650 | 2021-02-17 | Luquillo | Puerto Rico | 72089 | 657 | |
1036405 | 1036405 | 2021-02-16 | Luquillo | Puerto Rico | 72089 | 656 | |
1033160 | 1033160 | 2021-02-15 | Luquillo | Puerto Rico | 72089 | 655 | |
1029914 | 1029914 | 2021-02-14 | Luquillo | Puerto Rico | 72089 | 653 | |
1026667 | 1026667 | 2021-02-13 | Luquillo | Puerto Rico | 72089 | 653 | |
1023422 | 1023422 | 2021-02-12 | Luquillo | Puerto Rico | 72089 | 642 | |
1020177 | 1020177 | 2021-02-11 | Luquillo | Puerto Rico | 72089 | 641 | |
1016932 | 1016932 | 2021-02-10 | Luquillo | Puerto Rico | 72089 | 636 | |
1013687 | 1013687 | 2021-02-09 | Luquillo | Puerto Rico | 72089 | 635 | |
1010442 | 1010442 | 2021-02-08 | Luquillo | Puerto Rico | 72089 | 635 | |
1007196 | 1007196 | 2021-02-07 | Luquillo | Puerto Rico | 72089 | 634 | |
1003950 | 1003950 | 2021-02-06 | Luquillo | Puerto Rico | 72089 | 628 | |
1000704 | 1000704 | 2021-02-05 | Luquillo | Puerto Rico | 72089 | 628 | |
997458 | 997458 | 2021-02-04 | Luquillo | Puerto Rico | 72089 | 628 | |
994212 | 994212 | 2021-02-03 | Luquillo | Puerto Rico | 72089 | 628 | |
990966 | 990966 | 2021-02-02 | Luquillo | Puerto Rico | 72089 | 628 | |
987720 | 987720 | 2021-02-01 | Luquillo | Puerto Rico | 72089 | 626 | |
984473 | 984473 | 2021-01-31 | Luquillo | Puerto Rico | 72089 | 623 | |
981226 | 981226 | 2021-01-30 | Luquillo | Puerto Rico | 72089 | 621 | |
977980 | 977980 | 2021-01-29 | Luquillo | Puerto Rico | 72089 | 615 | |
974735 | 974735 | 2021-01-28 | Luquillo | Puerto Rico | 72089 | 603 | |
971490 | 971490 | 2021-01-27 | Luquillo | Puerto Rico | 72089 | 601 | |
968245 | 968245 | 2021-01-26 | Luquillo | Puerto Rico | 72089 | 598 | |
965001 | 965001 | 2021-01-25 | Luquillo | Puerto Rico | 72089 | 597 | |
961756 | 961756 | 2021-01-24 | Luquillo | Puerto Rico | 72089 | 594 | |
958511 | 958511 | 2021-01-23 | Luquillo | Puerto Rico | 72089 | 594 | |
955265 | 955265 | 2021-01-22 | Luquillo | Puerto Rico | 72089 | 593 | |
952020 | 952020 | 2021-01-21 | Luquillo | Puerto Rico | 72089 | 591 | |
948775 | 948775 | 2021-01-20 | Luquillo | Puerto Rico | 72089 | 584 | |
945529 | 945529 | 2021-01-19 | Luquillo | Puerto Rico | 72089 | 584 | |
942282 | 942282 | 2021-01-18 | Luquillo | Puerto Rico | 72089 | 583 | |
939037 | 939037 | 2021-01-17 | Luquillo | Puerto Rico | 72089 | 577 | |
935792 | 935792 | 2021-01-16 | Luquillo | Puerto Rico | 72089 | 572 | |
932547 | 932547 | 2021-01-15 | Luquillo | Puerto Rico | 72089 | 569 | |
929302 | 929302 | 2021-01-14 | Luquillo | Puerto Rico | 72089 | 565 | |
926057 | 926057 | 2021-01-13 | Luquillo | Puerto Rico | 72089 | 564 | |
922811 | 922811 | 2021-01-12 | Luquillo | Puerto Rico | 72089 | 563 | |
919566 | 919566 | 2021-01-11 | Luquillo | Puerto Rico | 72089 | 556 | |
916321 | 916321 | 2021-01-10 | Luquillo | Puerto Rico | 72089 | 555 | |
913076 | 913076 | 2021-01-09 | Luquillo | Puerto Rico | 72089 | 553 | |
909831 | 909831 | 2021-01-08 | Luquillo | Puerto Rico | 72089 | 553 | |
906586 | 906586 | 2021-01-07 | Luquillo | Puerto Rico | 72089 | 535 | |
903340 | 903340 | 2021-01-06 | Luquillo | Puerto Rico | 72089 | 531 | |
900095 | 900095 | 2021-01-05 | Luquillo | Puerto Rico | 72089 | 530 | |
896850 | 896850 | 2021-01-04 | Luquillo | Puerto Rico | 72089 | 526 | |
893604 | 893604 | 2021-01-03 | Luquillo | Puerto Rico | 72089 | 517 | |
890358 | 890358 | 2021-01-02 | Luquillo | Puerto Rico | 72089 | 514 | |
887111 | 887111 | 2021-01-01 | Luquillo | Puerto Rico | 72089 | 509 | |
883866 | 883866 | 2020-12-31 | Luquillo | Puerto Rico | 72089 | 504 | |
880621 | 880621 | 2020-12-30 | Luquillo | Puerto Rico | 72089 | 493 | |
877376 | 877376 | 2020-12-29 | Luquillo | Puerto Rico | 72089 | 487 | |
874131 | 874131 | 2020-12-28 | Luquillo | Puerto Rico | 72089 | 484 | |
870886 | 870886 | 2020-12-27 | Luquillo | Puerto Rico | 72089 | 480 | |
867641 | 867641 | 2020-12-26 | Luquillo | Puerto Rico | 72089 | 478 | |
864396 | 864396 | 2020-12-25 | Luquillo | Puerto Rico | 72089 | 470 | |
861151 | 861151 | 2020-12-24 | Luquillo | Puerto Rico | 72089 | 470 | |
857906 | 857906 | 2020-12-23 | Luquillo | Puerto Rico | 72089 | 467 | |
854661 | 854661 | 2020-12-22 | Luquillo | Puerto Rico | 72089 | 462 | |
851416 | 851416 | 2020-12-21 | Luquillo | Puerto Rico | 72089 | 456 | |
848171 | 848171 | 2020-12-20 | Luquillo | Puerto Rico | 72089 | 452 | |
844926 | 844926 | 2020-12-19 | Luquillo | Puerto Rico | 72089 | 437 | |
841680 | 841680 | 2020-12-18 | Luquillo | Puerto Rico | 72089 | 434 | |
838435 | 838435 | 2020-12-17 | Luquillo | Puerto Rico | 72089 | 430 | |
835189 | 835189 | 2020-12-16 | Luquillo | Puerto Rico | 72089 | 426 | |
831943 | 831943 | 2020-12-15 | Luquillo | Puerto Rico | 72089 | 426 | |
828696 | 828696 | 2020-12-14 | Luquillo | Puerto Rico | 72089 | 426 | |
825450 | 825450 | 2020-12-13 | Luquillo | Puerto Rico | 72089 | 425 | |
822203 | 822203 | 2020-12-12 | Luquillo | Puerto Rico | 72089 | 425 | |
818957 | 818957 | 2020-12-11 | Luquillo | Puerto Rico | 72089 | 423 | |
815711 | 815711 | 2020-12-10 | Luquillo | Puerto Rico | 72089 | 421 | |
812465 | 812465 | 2020-12-09 | Luquillo | Puerto Rico | 72089 | 416 | |
809221 | 809221 | 2020-12-08 | Luquillo | Puerto Rico | 72089 | 416 | |
805976 | 805976 | 2020-12-07 | Luquillo | Puerto Rico | 72089 | 413 | |
802731 | 802731 | 2020-12-06 | Luquillo | Puerto Rico | 72089 | 411 | |
799486 | 799486 | 2020-12-05 | Luquillo | Puerto Rico | 72089 | 410 | |
796241 | 796241 | 2020-12-04 | Luquillo | Puerto Rico | 72089 | 408 | |
792996 | 792996 | 2020-12-03 | Luquillo | Puerto Rico | 72089 | 405 | |
789751 | 789751 | 2020-12-02 | Luquillo | Puerto Rico | 72089 | 398 | |
786506 | 786506 | 2020-12-01 | Luquillo | Puerto Rico | 72089 | 398 | |
783262 | 783262 | 2020-11-30 | Luquillo | Puerto Rico | 72089 | 393 | |
780017 | 780017 | 2020-11-29 | Luquillo | Puerto Rico | 72089 | 390 | |
776771 | 776771 | 2020-11-28 | Luquillo | Puerto Rico | 72089 | 389 | |
773526 | 773526 | 2020-11-27 | Luquillo | Puerto Rico | 72089 | 388 | |
770281 | 770281 | 2020-11-26 | Luquillo | Puerto Rico | 72089 | 387 | |
767035 | 767035 | 2020-11-25 | Luquillo | Puerto Rico | 72089 | 387 | |
763790 | 763790 | 2020-11-24 | Luquillo | Puerto Rico | 72089 | 386 | |
760545 | 760545 | 2020-11-23 | Luquillo | Puerto Rico | 72089 | 379 | |
757300 | 757300 | 2020-11-22 | Luquillo | Puerto Rico | 72089 | 378 | |
754053 | 754053 | 2020-11-21 | Luquillo | Puerto Rico | 72089 | 377 | |
750807 | 750807 | 2020-11-20 | Luquillo | Puerto Rico | 72089 | 371 | |
747561 | 747561 | 2020-11-19 | Luquillo | Puerto Rico | 72089 | 366 | |
744315 | 744315 | 2020-11-18 | Luquillo | Puerto Rico | 72089 | 365 |
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);