ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72017 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 |
---|---|---|---|---|---|---|---|
1055843 | 1055843 | 2021-02-22 | Barceloneta | Puerto Rico | 72017 | 717 | |
1052597 | 1052597 | 2021-02-21 | Barceloneta | Puerto Rico | 72017 | 714 | |
1049350 | 1049350 | 2021-02-20 | Barceloneta | Puerto Rico | 72017 | 713 | |
1046103 | 1046103 | 2021-02-19 | Barceloneta | Puerto Rico | 72017 | 713 | |
1042858 | 1042858 | 2021-02-18 | Barceloneta | Puerto Rico | 72017 | 713 | |
1039613 | 1039613 | 2021-02-17 | Barceloneta | Puerto Rico | 72017 | 713 | |
1036368 | 1036368 | 2021-02-16 | Barceloneta | Puerto Rico | 72017 | 713 | |
1033123 | 1033123 | 2021-02-15 | Barceloneta | Puerto Rico | 72017 | 712 | |
1029877 | 1029877 | 2021-02-14 | Barceloneta | Puerto Rico | 72017 | 711 | |
1026630 | 1026630 | 2021-02-13 | Barceloneta | Puerto Rico | 72017 | 709 | |
1023385 | 1023385 | 2021-02-12 | Barceloneta | Puerto Rico | 72017 | 702 | |
1020140 | 1020140 | 2021-02-11 | Barceloneta | Puerto Rico | 72017 | 699 | |
1016895 | 1016895 | 2021-02-10 | Barceloneta | Puerto Rico | 72017 | 699 | |
1013650 | 1013650 | 2021-02-09 | Barceloneta | Puerto Rico | 72017 | 698 | |
1010405 | 1010405 | 2021-02-08 | Barceloneta | Puerto Rico | 72017 | 698 | |
1007159 | 1007159 | 2021-02-07 | Barceloneta | Puerto Rico | 72017 | 698 | |
1003913 | 1003913 | 2021-02-06 | Barceloneta | Puerto Rico | 72017 | 696 | |
1000667 | 1000667 | 2021-02-05 | Barceloneta | Puerto Rico | 72017 | 694 | |
997421 | 997421 | 2021-02-04 | Barceloneta | Puerto Rico | 72017 | 693 | |
994175 | 994175 | 2021-02-03 | Barceloneta | Puerto Rico | 72017 | 691 | |
990929 | 990929 | 2021-02-02 | Barceloneta | Puerto Rico | 72017 | 691 | |
987683 | 987683 | 2021-02-01 | Barceloneta | Puerto Rico | 72017 | 691 | |
984436 | 984436 | 2021-01-31 | Barceloneta | Puerto Rico | 72017 | 688 | |
981189 | 981189 | 2021-01-30 | Barceloneta | Puerto Rico | 72017 | 686 | |
977943 | 977943 | 2021-01-29 | Barceloneta | Puerto Rico | 72017 | 683 | |
974698 | 974698 | 2021-01-28 | Barceloneta | Puerto Rico | 72017 | 680 | |
971453 | 971453 | 2021-01-27 | Barceloneta | Puerto Rico | 72017 | 679 | |
968208 | 968208 | 2021-01-26 | Barceloneta | Puerto Rico | 72017 | 677 | |
964964 | 964964 | 2021-01-25 | Barceloneta | Puerto Rico | 72017 | 673 | |
961719 | 961719 | 2021-01-24 | Barceloneta | Puerto Rico | 72017 | 667 | |
958474 | 958474 | 2021-01-23 | Barceloneta | Puerto Rico | 72017 | 660 | |
955228 | 955228 | 2021-01-22 | Barceloneta | Puerto Rico | 72017 | 657 | |
951983 | 951983 | 2021-01-21 | Barceloneta | Puerto Rico | 72017 | 648 | |
948738 | 948738 | 2021-01-20 | Barceloneta | Puerto Rico | 72017 | 648 | |
945492 | 945492 | 2021-01-19 | Barceloneta | Puerto Rico | 72017 | 648 | |
942245 | 942245 | 2021-01-18 | Barceloneta | Puerto Rico | 72017 | 646 | |
939000 | 939000 | 2021-01-17 | Barceloneta | Puerto Rico | 72017 | 644 | |
935755 | 935755 | 2021-01-16 | Barceloneta | Puerto Rico | 72017 | 643 | |
932510 | 932510 | 2021-01-15 | Barceloneta | Puerto Rico | 72017 | 642 | |
929265 | 929265 | 2021-01-14 | Barceloneta | Puerto Rico | 72017 | 632 | |
926020 | 926020 | 2021-01-13 | Barceloneta | Puerto Rico | 72017 | 631 | |
922774 | 922774 | 2021-01-12 | Barceloneta | Puerto Rico | 72017 | 631 | |
919529 | 919529 | 2021-01-11 | Barceloneta | Puerto Rico | 72017 | 630 | |
916284 | 916284 | 2021-01-10 | Barceloneta | Puerto Rico | 72017 | 630 | |
913039 | 913039 | 2021-01-09 | Barceloneta | Puerto Rico | 72017 | 629 | |
909794 | 909794 | 2021-01-08 | Barceloneta | Puerto Rico | 72017 | 624 | |
906549 | 906549 | 2021-01-07 | Barceloneta | Puerto Rico | 72017 | 622 | |
903303 | 903303 | 2021-01-06 | Barceloneta | Puerto Rico | 72017 | 622 | |
900058 | 900058 | 2021-01-05 | Barceloneta | Puerto Rico | 72017 | 620 | |
896813 | 896813 | 2021-01-04 | Barceloneta | Puerto Rico | 72017 | 616 | |
893567 | 893567 | 2021-01-03 | Barceloneta | Puerto Rico | 72017 | 614 | |
890321 | 890321 | 2021-01-02 | Barceloneta | Puerto Rico | 72017 | 614 | |
887074 | 887074 | 2021-01-01 | Barceloneta | Puerto Rico | 72017 | 612 | |
883829 | 883829 | 2020-12-31 | Barceloneta | Puerto Rico | 72017 | 607 | |
880584 | 880584 | 2020-12-30 | Barceloneta | Puerto Rico | 72017 | 603 | |
877339 | 877339 | 2020-12-29 | Barceloneta | Puerto Rico | 72017 | 603 | |
874094 | 874094 | 2020-12-28 | Barceloneta | Puerto Rico | 72017 | 598 | |
870849 | 870849 | 2020-12-27 | Barceloneta | Puerto Rico | 72017 | 598 | |
867604 | 867604 | 2020-12-26 | Barceloneta | Puerto Rico | 72017 | 597 | |
864359 | 864359 | 2020-12-25 | Barceloneta | Puerto Rico | 72017 | 591 | |
861114 | 861114 | 2020-12-24 | Barceloneta | Puerto Rico | 72017 | 585 | |
857869 | 857869 | 2020-12-23 | Barceloneta | Puerto Rico | 72017 | 584 | |
854624 | 854624 | 2020-12-22 | Barceloneta | Puerto Rico | 72017 | 583 | |
851379 | 851379 | 2020-12-21 | Barceloneta | Puerto Rico | 72017 | 578 | |
848134 | 848134 | 2020-12-20 | Barceloneta | Puerto Rico | 72017 | 578 | |
844889 | 844889 | 2020-12-19 | Barceloneta | Puerto Rico | 72017 | 575 | |
841643 | 841643 | 2020-12-18 | Barceloneta | Puerto Rico | 72017 | 568 | |
838398 | 838398 | 2020-12-17 | Barceloneta | Puerto Rico | 72017 | 552 | |
835152 | 835152 | 2020-12-16 | Barceloneta | Puerto Rico | 72017 | 544 | |
831906 | 831906 | 2020-12-15 | Barceloneta | Puerto Rico | 72017 | 543 | |
828659 | 828659 | 2020-12-14 | Barceloneta | Puerto Rico | 72017 | 537 | |
825413 | 825413 | 2020-12-13 | Barceloneta | Puerto Rico | 72017 | 536 | |
822166 | 822166 | 2020-12-12 | Barceloneta | Puerto Rico | 72017 | 534 | |
818920 | 818920 | 2020-12-11 | Barceloneta | Puerto Rico | 72017 | 528 | |
815674 | 815674 | 2020-12-10 | Barceloneta | Puerto Rico | 72017 | 508 | |
812428 | 812428 | 2020-12-09 | Barceloneta | Puerto Rico | 72017 | 505 | |
809184 | 809184 | 2020-12-08 | Barceloneta | Puerto Rico | 72017 | 500 | |
805939 | 805939 | 2020-12-07 | Barceloneta | Puerto Rico | 72017 | 494 | |
802694 | 802694 | 2020-12-06 | Barceloneta | Puerto Rico | 72017 | 480 | |
799449 | 799449 | 2020-12-05 | Barceloneta | Puerto Rico | 72017 | 471 | |
796204 | 796204 | 2020-12-04 | Barceloneta | Puerto Rico | 72017 | 471 | |
792959 | 792959 | 2020-12-03 | Barceloneta | Puerto Rico | 72017 | 466 | |
789714 | 789714 | 2020-12-02 | Barceloneta | Puerto Rico | 72017 | 464 | |
786469 | 786469 | 2020-12-01 | Barceloneta | Puerto Rico | 72017 | 463 | |
783225 | 783225 | 2020-11-30 | Barceloneta | Puerto Rico | 72017 | 458 | |
779980 | 779980 | 2020-11-29 | Barceloneta | Puerto Rico | 72017 | 455 | |
776734 | 776734 | 2020-11-28 | Barceloneta | Puerto Rico | 72017 | 454 | |
773489 | 773489 | 2020-11-27 | Barceloneta | Puerto Rico | 72017 | 450 | |
770244 | 770244 | 2020-11-26 | Barceloneta | Puerto Rico | 72017 | 441 | |
766998 | 766998 | 2020-11-25 | Barceloneta | Puerto Rico | 72017 | 440 | |
763753 | 763753 | 2020-11-24 | Barceloneta | Puerto Rico | 72017 | 432 | |
760508 | 760508 | 2020-11-23 | Barceloneta | Puerto Rico | 72017 | 427 | |
757263 | 757263 | 2020-11-22 | Barceloneta | Puerto Rico | 72017 | 422 | |
754016 | 754016 | 2020-11-21 | Barceloneta | Puerto Rico | 72017 | 415 | |
750770 | 750770 | 2020-11-20 | Barceloneta | Puerto Rico | 72017 | 408 | |
747524 | 747524 | 2020-11-19 | Barceloneta | Puerto Rico | 72017 | 397 | |
744278 | 744278 | 2020-11-18 | Barceloneta | Puerto Rico | 72017 | 394 | |
741031 | 741031 | 2020-11-17 | Barceloneta | Puerto Rico | 72017 | 393 | |
737785 | 737785 | 2020-11-16 | Barceloneta | Puerto Rico | 72017 | 392 | |
734541 | 734541 | 2020-11-15 | Barceloneta | Puerto Rico | 72017 | 390 |
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);