ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72054 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 |
---|---|---|---|---|---|---|---|
1065598 | 1065598 | 2021-02-25 | Florida | Puerto Rico | 72054 | 675 | |
1062353 | 1062353 | 2021-02-24 | Florida | Puerto Rico | 72054 | 675 | |
1059108 | 1059108 | 2021-02-23 | Florida | Puerto Rico | 72054 | 675 | |
1055862 | 1055862 | 2021-02-22 | Florida | Puerto Rico | 72054 | 674 | |
1052616 | 1052616 | 2021-02-21 | Florida | Puerto Rico | 72054 | 674 | |
1049369 | 1049369 | 2021-02-20 | Florida | Puerto Rico | 72054 | 673 | |
1046122 | 1046122 | 2021-02-19 | Florida | Puerto Rico | 72054 | 670 | |
1042877 | 1042877 | 2021-02-18 | Florida | Puerto Rico | 72054 | 670 | |
1039632 | 1039632 | 2021-02-17 | Florida | Puerto Rico | 72054 | 670 | |
1036387 | 1036387 | 2021-02-16 | Florida | Puerto Rico | 72054 | 670 | |
1033142 | 1033142 | 2021-02-15 | Florida | Puerto Rico | 72054 | 670 | |
1029896 | 1029896 | 2021-02-14 | Florida | Puerto Rico | 72054 | 669 | |
1026649 | 1026649 | 2021-02-13 | Florida | Puerto Rico | 72054 | 667 | |
1023404 | 1023404 | 2021-02-12 | Florida | Puerto Rico | 72054 | 667 | |
1020159 | 1020159 | 2021-02-11 | Florida | Puerto Rico | 72054 | 667 | |
1016914 | 1016914 | 2021-02-10 | Florida | Puerto Rico | 72054 | 667 | |
1013669 | 1013669 | 2021-02-09 | Florida | Puerto Rico | 72054 | 667 | |
1010424 | 1010424 | 2021-02-08 | Florida | Puerto Rico | 72054 | 667 | |
1007178 | 1007178 | 2021-02-07 | Florida | Puerto Rico | 72054 | 667 | |
1003932 | 1003932 | 2021-02-06 | Florida | Puerto Rico | 72054 | 664 | |
1000686 | 1000686 | 2021-02-05 | Florida | Puerto Rico | 72054 | 663 | |
997440 | 997440 | 2021-02-04 | Florida | Puerto Rico | 72054 | 663 | |
994194 | 994194 | 2021-02-03 | Florida | Puerto Rico | 72054 | 662 | |
990948 | 990948 | 2021-02-02 | Florida | Puerto Rico | 72054 | 662 | |
987702 | 987702 | 2021-02-01 | Florida | Puerto Rico | 72054 | 662 | |
984455 | 984455 | 2021-01-31 | Florida | Puerto Rico | 72054 | 660 | |
981208 | 981208 | 2021-01-30 | Florida | Puerto Rico | 72054 | 660 | |
977962 | 977962 | 2021-01-29 | Florida | Puerto Rico | 72054 | 656 | |
974717 | 974717 | 2021-01-28 | Florida | Puerto Rico | 72054 | 655 | |
971472 | 971472 | 2021-01-27 | Florida | Puerto Rico | 72054 | 655 | |
968227 | 968227 | 2021-01-26 | Florida | Puerto Rico | 72054 | 655 | |
964983 | 964983 | 2021-01-25 | Florida | Puerto Rico | 72054 | 655 | |
961738 | 961738 | 2021-01-24 | Florida | Puerto Rico | 72054 | 655 | |
958493 | 958493 | 2021-01-23 | Florida | Puerto Rico | 72054 | 654 | |
955247 | 955247 | 2021-01-22 | Florida | Puerto Rico | 72054 | 654 | |
952002 | 952002 | 2021-01-21 | Florida | Puerto Rico | 72054 | 654 | |
948757 | 948757 | 2021-01-20 | Florida | Puerto Rico | 72054 | 654 | |
945511 | 945511 | 2021-01-19 | Florida | Puerto Rico | 72054 | 654 | |
942264 | 942264 | 2021-01-18 | Florida | Puerto Rico | 72054 | 652 | |
939019 | 939019 | 2021-01-17 | Florida | Puerto Rico | 72054 | 651 | |
935774 | 935774 | 2021-01-16 | Florida | Puerto Rico | 72054 | 651 | |
932529 | 932529 | 2021-01-15 | Florida | Puerto Rico | 72054 | 650 | |
929284 | 929284 | 2021-01-14 | Florida | Puerto Rico | 72054 | 646 | |
926039 | 926039 | 2021-01-13 | Florida | Puerto Rico | 72054 | 646 | |
922793 | 922793 | 2021-01-12 | Florida | Puerto Rico | 72054 | 646 | |
919548 | 919548 | 2021-01-11 | Florida | Puerto Rico | 72054 | 642 | |
916303 | 916303 | 2021-01-10 | Florida | Puerto Rico | 72054 | 642 | |
913058 | 913058 | 2021-01-09 | Florida | Puerto Rico | 72054 | 642 | |
909813 | 909813 | 2021-01-08 | Florida | Puerto Rico | 72054 | 640 | |
906568 | 906568 | 2021-01-07 | Florida | Puerto Rico | 72054 | 634 | |
903322 | 903322 | 2021-01-06 | Florida | Puerto Rico | 72054 | 634 | |
900077 | 900077 | 2021-01-05 | Florida | Puerto Rico | 72054 | 634 | |
896832 | 896832 | 2021-01-04 | Florida | Puerto Rico | 72054 | 634 | |
893586 | 893586 | 2021-01-03 | Florida | Puerto Rico | 72054 | 634 | |
890340 | 890340 | 2021-01-02 | Florida | Puerto Rico | 72054 | 634 | |
887093 | 887093 | 2021-01-01 | Florida | Puerto Rico | 72054 | 631 | |
883848 | 883848 | 2020-12-31 | Florida | Puerto Rico | 72054 | 625 | |
880603 | 880603 | 2020-12-30 | Florida | Puerto Rico | 72054 | 625 | |
877358 | 877358 | 2020-12-29 | Florida | Puerto Rico | 72054 | 625 | |
874113 | 874113 | 2020-12-28 | Florida | Puerto Rico | 72054 | 624 | |
870868 | 870868 | 2020-12-27 | Florida | Puerto Rico | 72054 | 624 | |
867623 | 867623 | 2020-12-26 | Florida | Puerto Rico | 72054 | 622 | |
864378 | 864378 | 2020-12-25 | Florida | Puerto Rico | 72054 | 621 | |
861133 | 861133 | 2020-12-24 | Florida | Puerto Rico | 72054 | 620 | |
857888 | 857888 | 2020-12-23 | Florida | Puerto Rico | 72054 | 620 | |
854643 | 854643 | 2020-12-22 | Florida | Puerto Rico | 72054 | 620 | |
851398 | 851398 | 2020-12-21 | Florida | Puerto Rico | 72054 | 612 | |
848153 | 848153 | 2020-12-20 | Florida | Puerto Rico | 72054 | 611 | |
844908 | 844908 | 2020-12-19 | Florida | Puerto Rico | 72054 | 609 | |
841662 | 841662 | 2020-12-18 | Florida | Puerto Rico | 72054 | 603 | |
838417 | 838417 | 2020-12-17 | Florida | Puerto Rico | 72054 | 580 | |
835171 | 835171 | 2020-12-16 | Florida | Puerto Rico | 72054 | 555 | |
831925 | 831925 | 2020-12-15 | Florida | Puerto Rico | 72054 | 553 | |
828678 | 828678 | 2020-12-14 | Florida | Puerto Rico | 72054 | 551 | |
825432 | 825432 | 2020-12-13 | Florida | Puerto Rico | 72054 | 551 | |
822185 | 822185 | 2020-12-12 | Florida | Puerto Rico | 72054 | 546 | |
818939 | 818939 | 2020-12-11 | Florida | Puerto Rico | 72054 | 544 | |
815693 | 815693 | 2020-12-10 | Florida | Puerto Rico | 72054 | 534 | |
812447 | 812447 | 2020-12-09 | Florida | Puerto Rico | 72054 | 534 | |
809203 | 809203 | 2020-12-08 | Florida | Puerto Rico | 72054 | 533 | |
805958 | 805958 | 2020-12-07 | Florida | Puerto Rico | 72054 | 533 | |
802713 | 802713 | 2020-12-06 | Florida | Puerto Rico | 72054 | 527 | |
799468 | 799468 | 2020-12-05 | Florida | Puerto Rico | 72054 | 524 | |
796223 | 796223 | 2020-12-04 | Florida | Puerto Rico | 72054 | 520 | |
792978 | 792978 | 2020-12-03 | Florida | Puerto Rico | 72054 | 520 | |
789733 | 789733 | 2020-12-02 | Florida | Puerto Rico | 72054 | 519 | |
786488 | 786488 | 2020-12-01 | Florida | Puerto Rico | 72054 | 518 | |
783244 | 783244 | 2020-11-30 | Florida | Puerto Rico | 72054 | 513 | |
779999 | 779999 | 2020-11-29 | Florida | Puerto Rico | 72054 | 511 | |
776753 | 776753 | 2020-11-28 | Florida | Puerto Rico | 72054 | 510 | |
773508 | 773508 | 2020-11-27 | Florida | Puerto Rico | 72054 | 507 | |
770263 | 770263 | 2020-11-26 | Florida | Puerto Rico | 72054 | 495 | |
767017 | 767017 | 2020-11-25 | Florida | Puerto Rico | 72054 | 493 | |
763772 | 763772 | 2020-11-24 | Florida | Puerto Rico | 72054 | 493 | |
760527 | 760527 | 2020-11-23 | Florida | Puerto Rico | 72054 | 492 | |
757282 | 757282 | 2020-11-22 | Florida | Puerto Rico | 72054 | 488 | |
754035 | 754035 | 2020-11-21 | Florida | Puerto Rico | 72054 | 480 | |
750789 | 750789 | 2020-11-20 | Florida | Puerto Rico | 72054 | 475 | |
747543 | 747543 | 2020-11-19 | Florida | Puerto Rico | 72054 | 467 | |
744297 | 744297 | 2020-11-18 | Florida | Puerto Rico | 72054 | 466 |
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);