ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72057 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 |
---|---|---|---|---|---|---|---|
1065600 | 1065600 | 2021-02-25 | Guayama | Puerto Rico | 72057 | 808 | |
1062355 | 1062355 | 2021-02-24 | Guayama | Puerto Rico | 72057 | 808 | |
1059110 | 1059110 | 2021-02-23 | Guayama | Puerto Rico | 72057 | 808 | |
1055864 | 1055864 | 2021-02-22 | Guayama | Puerto Rico | 72057 | 808 | |
1052618 | 1052618 | 2021-02-21 | Guayama | Puerto Rico | 72057 | 807 | |
1049371 | 1049371 | 2021-02-20 | Guayama | Puerto Rico | 72057 | 803 | |
1046124 | 1046124 | 2021-02-19 | Guayama | Puerto Rico | 72057 | 803 | |
1042879 | 1042879 | 2021-02-18 | Guayama | Puerto Rico | 72057 | 803 | |
1039634 | 1039634 | 2021-02-17 | Guayama | Puerto Rico | 72057 | 803 | |
1036389 | 1036389 | 2021-02-16 | Guayama | Puerto Rico | 72057 | 803 | |
1033144 | 1033144 | 2021-02-15 | Guayama | Puerto Rico | 72057 | 800 | |
1029898 | 1029898 | 2021-02-14 | Guayama | Puerto Rico | 72057 | 799 | |
1026651 | 1026651 | 2021-02-13 | Guayama | Puerto Rico | 72057 | 797 | |
1023406 | 1023406 | 2021-02-12 | Guayama | Puerto Rico | 72057 | 795 | |
1020161 | 1020161 | 2021-02-11 | Guayama | Puerto Rico | 72057 | 793 | |
1016916 | 1016916 | 2021-02-10 | Guayama | Puerto Rico | 72057 | 793 | |
1013671 | 1013671 | 2021-02-09 | Guayama | Puerto Rico | 72057 | 793 | |
1010426 | 1010426 | 2021-02-08 | Guayama | Puerto Rico | 72057 | 791 | |
1007180 | 1007180 | 2021-02-07 | Guayama | Puerto Rico | 72057 | 790 | |
1003934 | 1003934 | 2021-02-06 | Guayama | Puerto Rico | 72057 | 789 | |
1000688 | 1000688 | 2021-02-05 | Guayama | Puerto Rico | 72057 | 787 | |
997442 | 997442 | 2021-02-04 | Guayama | Puerto Rico | 72057 | 780 | |
994196 | 994196 | 2021-02-03 | Guayama | Puerto Rico | 72057 | 777 | |
990950 | 990950 | 2021-02-02 | Guayama | Puerto Rico | 72057 | 776 | |
987704 | 987704 | 2021-02-01 | Guayama | Puerto Rico | 72057 | 776 | |
984457 | 984457 | 2021-01-31 | Guayama | Puerto Rico | 72057 | 774 | |
981210 | 981210 | 2021-01-30 | Guayama | Puerto Rico | 72057 | 772 | |
977964 | 977964 | 2021-01-29 | Guayama | Puerto Rico | 72057 | 769 | |
974719 | 974719 | 2021-01-28 | Guayama | Puerto Rico | 72057 | 767 | |
971474 | 971474 | 2021-01-27 | Guayama | Puerto Rico | 72057 | 766 | |
968229 | 968229 | 2021-01-26 | Guayama | Puerto Rico | 72057 | 766 | |
964985 | 964985 | 2021-01-25 | Guayama | Puerto Rico | 72057 | 763 | |
961740 | 961740 | 2021-01-24 | Guayama | Puerto Rico | 72057 | 756 | |
958495 | 958495 | 2021-01-23 | Guayama | Puerto Rico | 72057 | 752 | |
955249 | 955249 | 2021-01-22 | Guayama | Puerto Rico | 72057 | 746 | |
952004 | 952004 | 2021-01-21 | Guayama | Puerto Rico | 72057 | 742 | |
948759 | 948759 | 2021-01-20 | Guayama | Puerto Rico | 72057 | 742 | |
945513 | 945513 | 2021-01-19 | Guayama | Puerto Rico | 72057 | 741 | |
942266 | 942266 | 2021-01-18 | Guayama | Puerto Rico | 72057 | 737 | |
939021 | 939021 | 2021-01-17 | Guayama | Puerto Rico | 72057 | 734 | |
935776 | 935776 | 2021-01-16 | Guayama | Puerto Rico | 72057 | 728 | |
932531 | 932531 | 2021-01-15 | Guayama | Puerto Rico | 72057 | 722 | |
929286 | 929286 | 2021-01-14 | Guayama | Puerto Rico | 72057 | 715 | |
926041 | 926041 | 2021-01-13 | Guayama | Puerto Rico | 72057 | 715 | |
922795 | 922795 | 2021-01-12 | Guayama | Puerto Rico | 72057 | 715 | |
919550 | 919550 | 2021-01-11 | Guayama | Puerto Rico | 72057 | 710 | |
916305 | 916305 | 2021-01-10 | Guayama | Puerto Rico | 72057 | 704 | |
913060 | 913060 | 2021-01-09 | Guayama | Puerto Rico | 72057 | 701 | |
909815 | 909815 | 2021-01-08 | Guayama | Puerto Rico | 72057 | 698 | |
906570 | 906570 | 2021-01-07 | Guayama | Puerto Rico | 72057 | 690 | |
903324 | 903324 | 2021-01-06 | Guayama | Puerto Rico | 72057 | 686 | |
900079 | 900079 | 2021-01-05 | Guayama | Puerto Rico | 72057 | 683 | |
896834 | 896834 | 2021-01-04 | Guayama | Puerto Rico | 72057 | 682 | |
893588 | 893588 | 2021-01-03 | Guayama | Puerto Rico | 72057 | 679 | |
890342 | 890342 | 2021-01-02 | Guayama | Puerto Rico | 72057 | 675 | |
887095 | 887095 | 2021-01-01 | Guayama | Puerto Rico | 72057 | 672 | |
883850 | 883850 | 2020-12-31 | Guayama | Puerto Rico | 72057 | 669 | |
880605 | 880605 | 2020-12-30 | Guayama | Puerto Rico | 72057 | 667 | |
877360 | 877360 | 2020-12-29 | Guayama | Puerto Rico | 72057 | 666 | |
874115 | 874115 | 2020-12-28 | Guayama | Puerto Rico | 72057 | 666 | |
870870 | 870870 | 2020-12-27 | Guayama | Puerto Rico | 72057 | 666 | |
867625 | 867625 | 2020-12-26 | Guayama | Puerto Rico | 72057 | 661 | |
864380 | 864380 | 2020-12-25 | Guayama | Puerto Rico | 72057 | 658 | |
861135 | 861135 | 2020-12-24 | Guayama | Puerto Rico | 72057 | 654 | |
857890 | 857890 | 2020-12-23 | Guayama | Puerto Rico | 72057 | 649 | |
854645 | 854645 | 2020-12-22 | Guayama | Puerto Rico | 72057 | 648 | |
851400 | 851400 | 2020-12-21 | Guayama | Puerto Rico | 72057 | 647 | |
848155 | 848155 | 2020-12-20 | Guayama | Puerto Rico | 72057 | 644 | |
844910 | 844910 | 2020-12-19 | Guayama | Puerto Rico | 72057 | 640 | |
841664 | 841664 | 2020-12-18 | Guayama | Puerto Rico | 72057 | 635 | |
838419 | 838419 | 2020-12-17 | Guayama | Puerto Rico | 72057 | 626 | |
835173 | 835173 | 2020-12-16 | Guayama | Puerto Rico | 72057 | 624 | |
831927 | 831927 | 2020-12-15 | Guayama | Puerto Rico | 72057 | 623 | |
828680 | 828680 | 2020-12-14 | Guayama | Puerto Rico | 72057 | 613 | |
825434 | 825434 | 2020-12-13 | Guayama | Puerto Rico | 72057 | 603 | |
822187 | 822187 | 2020-12-12 | Guayama | Puerto Rico | 72057 | 594 | |
818941 | 818941 | 2020-12-11 | Guayama | Puerto Rico | 72057 | 592 | |
815695 | 815695 | 2020-12-10 | Guayama | Puerto Rico | 72057 | 590 | |
812449 | 812449 | 2020-12-09 | Guayama | Puerto Rico | 72057 | 579 | |
809205 | 809205 | 2020-12-08 | Guayama | Puerto Rico | 72057 | 577 | |
805960 | 805960 | 2020-12-07 | Guayama | Puerto Rico | 72057 | 576 | |
802715 | 802715 | 2020-12-06 | Guayama | Puerto Rico | 72057 | 575 | |
799470 | 799470 | 2020-12-05 | Guayama | Puerto Rico | 72057 | 562 | |
796225 | 796225 | 2020-12-04 | Guayama | Puerto Rico | 72057 | 558 | |
792980 | 792980 | 2020-12-03 | Guayama | Puerto Rico | 72057 | 553 | |
789735 | 789735 | 2020-12-02 | Guayama | Puerto Rico | 72057 | 551 | |
786490 | 786490 | 2020-12-01 | Guayama | Puerto Rico | 72057 | 549 | |
783246 | 783246 | 2020-11-30 | Guayama | Puerto Rico | 72057 | 544 | |
780001 | 780001 | 2020-11-29 | Guayama | Puerto Rico | 72057 | 531 | |
776755 | 776755 | 2020-11-28 | Guayama | Puerto Rico | 72057 | 530 | |
773510 | 773510 | 2020-11-27 | Guayama | Puerto Rico | 72057 | 524 | |
770265 | 770265 | 2020-11-26 | Guayama | Puerto Rico | 72057 | 520 | |
767019 | 767019 | 2020-11-25 | Guayama | Puerto Rico | 72057 | 511 | |
763774 | 763774 | 2020-11-24 | Guayama | Puerto Rico | 72057 | 510 | |
760529 | 760529 | 2020-11-23 | Guayama | Puerto Rico | 72057 | 506 | |
757284 | 757284 | 2020-11-22 | Guayama | Puerto Rico | 72057 | 501 | |
754037 | 754037 | 2020-11-21 | Guayama | Puerto Rico | 72057 | 483 | |
750791 | 750791 | 2020-11-20 | Guayama | Puerto Rico | 72057 | 475 | |
747545 | 747545 | 2020-11-19 | Guayama | Puerto Rico | 72057 | 472 | |
744299 | 744299 | 2020-11-18 | Guayama | Puerto Rico | 72057 | 467 |
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);