ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72065 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 |
---|---|---|---|---|---|---|---|
1065604 | 1065604 | 2021-02-25 | Hatillo | Puerto Rico | 72065 | 1040 | |
1062359 | 1062359 | 2021-02-24 | Hatillo | Puerto Rico | 72065 | 1039 | |
1059114 | 1059114 | 2021-02-23 | Hatillo | Puerto Rico | 72065 | 1038 | |
1055868 | 1055868 | 2021-02-22 | Hatillo | Puerto Rico | 72065 | 1035 | |
1052622 | 1052622 | 2021-02-21 | Hatillo | Puerto Rico | 72065 | 1033 | |
1049375 | 1049375 | 2021-02-20 | Hatillo | Puerto Rico | 72065 | 1026 | |
1046128 | 1046128 | 2021-02-19 | Hatillo | Puerto Rico | 72065 | 1022 | |
1042883 | 1042883 | 2021-02-18 | Hatillo | Puerto Rico | 72065 | 1023 | |
1039638 | 1039638 | 2021-02-17 | Hatillo | Puerto Rico | 72065 | 1023 | |
1036393 | 1036393 | 2021-02-16 | Hatillo | Puerto Rico | 72065 | 1018 | |
1033148 | 1033148 | 2021-02-15 | Hatillo | Puerto Rico | 72065 | 1008 | |
1029902 | 1029902 | 2021-02-14 | Hatillo | Puerto Rico | 72065 | 1006 | |
1026655 | 1026655 | 2021-02-13 | Hatillo | Puerto Rico | 72065 | 1005 | |
1023410 | 1023410 | 2021-02-12 | Hatillo | Puerto Rico | 72065 | 999 | |
1020165 | 1020165 | 2021-02-11 | Hatillo | Puerto Rico | 72065 | 994 | |
1016920 | 1016920 | 2021-02-10 | Hatillo | Puerto Rico | 72065 | 992 | |
1013675 | 1013675 | 2021-02-09 | Hatillo | Puerto Rico | 72065 | 992 | |
1010430 | 1010430 | 2021-02-08 | Hatillo | Puerto Rico | 72065 | 989 | |
1007184 | 1007184 | 2021-02-07 | Hatillo | Puerto Rico | 72065 | 984 | |
1003938 | 1003938 | 2021-02-06 | Hatillo | Puerto Rico | 72065 | 973 | |
1000692 | 1000692 | 2021-02-05 | Hatillo | Puerto Rico | 72065 | 973 | |
997446 | 997446 | 2021-02-04 | Hatillo | Puerto Rico | 72065 | 973 | |
994200 | 994200 | 2021-02-03 | Hatillo | Puerto Rico | 72065 | 968 | |
990954 | 990954 | 2021-02-02 | Hatillo | Puerto Rico | 72065 | 968 | |
987708 | 987708 | 2021-02-01 | Hatillo | Puerto Rico | 72065 | 967 | |
984461 | 984461 | 2021-01-31 | Hatillo | Puerto Rico | 72065 | 958 | |
981214 | 981214 | 2021-01-30 | Hatillo | Puerto Rico | 72065 | 958 | |
977968 | 977968 | 2021-01-29 | Hatillo | Puerto Rico | 72065 | 954 | |
974723 | 974723 | 2021-01-28 | Hatillo | Puerto Rico | 72065 | 951 | |
971478 | 971478 | 2021-01-27 | Hatillo | Puerto Rico | 72065 | 949 | |
968233 | 968233 | 2021-01-26 | Hatillo | Puerto Rico | 72065 | 949 | |
964989 | 964989 | 2021-01-25 | Hatillo | Puerto Rico | 72065 | 948 | |
961744 | 961744 | 2021-01-24 | Hatillo | Puerto Rico | 72065 | 942 | |
958499 | 958499 | 2021-01-23 | Hatillo | Puerto Rico | 72065 | 935 | |
955253 | 955253 | 2021-01-22 | Hatillo | Puerto Rico | 72065 | 930 | |
952008 | 952008 | 2021-01-21 | Hatillo | Puerto Rico | 72065 | 928 | |
948763 | 948763 | 2021-01-20 | Hatillo | Puerto Rico | 72065 | 927 | |
945517 | 945517 | 2021-01-19 | Hatillo | Puerto Rico | 72065 | 927 | |
942270 | 942270 | 2021-01-18 | Hatillo | Puerto Rico | 72065 | 922 | |
939025 | 939025 | 2021-01-17 | Hatillo | Puerto Rico | 72065 | 922 | |
935780 | 935780 | 2021-01-16 | Hatillo | Puerto Rico | 72065 | 922 | |
932535 | 932535 | 2021-01-15 | Hatillo | Puerto Rico | 72065 | 918 | |
929290 | 929290 | 2021-01-14 | Hatillo | Puerto Rico | 72065 | 912 | |
926045 | 926045 | 2021-01-13 | Hatillo | Puerto Rico | 72065 | 912 | |
922799 | 922799 | 2021-01-12 | Hatillo | Puerto Rico | 72065 | 911 | |
919554 | 919554 | 2021-01-11 | Hatillo | Puerto Rico | 72065 | 904 | |
916309 | 916309 | 2021-01-10 | Hatillo | Puerto Rico | 72065 | 904 | |
913064 | 913064 | 2021-01-09 | Hatillo | Puerto Rico | 72065 | 903 | |
909819 | 909819 | 2021-01-08 | Hatillo | Puerto Rico | 72065 | 902 | |
906574 | 906574 | 2021-01-07 | Hatillo | Puerto Rico | 72065 | 897 | |
903328 | 903328 | 2021-01-06 | Hatillo | Puerto Rico | 72065 | 897 | |
900083 | 900083 | 2021-01-05 | Hatillo | Puerto Rico | 72065 | 897 | |
896838 | 896838 | 2021-01-04 | Hatillo | Puerto Rico | 72065 | 895 | |
893592 | 893592 | 2021-01-03 | Hatillo | Puerto Rico | 72065 | 893 | |
890346 | 890346 | 2021-01-02 | Hatillo | Puerto Rico | 72065 | 893 | |
887099 | 887099 | 2021-01-01 | Hatillo | Puerto Rico | 72065 | 886 | |
883854 | 883854 | 2020-12-31 | Hatillo | Puerto Rico | 72065 | 877 | |
880609 | 880609 | 2020-12-30 | Hatillo | Puerto Rico | 72065 | 874 | |
877364 | 877364 | 2020-12-29 | Hatillo | Puerto Rico | 72065 | 874 | |
874119 | 874119 | 2020-12-28 | Hatillo | Puerto Rico | 72065 | 865 | |
870874 | 870874 | 2020-12-27 | Hatillo | Puerto Rico | 72065 | 865 | |
867629 | 867629 | 2020-12-26 | Hatillo | Puerto Rico | 72065 | 862 | |
864384 | 864384 | 2020-12-25 | Hatillo | Puerto Rico | 72065 | 848 | |
861139 | 861139 | 2020-12-24 | Hatillo | Puerto Rico | 72065 | 845 | |
857894 | 857894 | 2020-12-23 | Hatillo | Puerto Rico | 72065 | 844 | |
854649 | 854649 | 2020-12-22 | Hatillo | Puerto Rico | 72065 | 843 | |
851404 | 851404 | 2020-12-21 | Hatillo | Puerto Rico | 72065 | 835 | |
848159 | 848159 | 2020-12-20 | Hatillo | Puerto Rico | 72065 | 835 | |
844914 | 844914 | 2020-12-19 | Hatillo | Puerto Rico | 72065 | 825 | |
841668 | 841668 | 2020-12-18 | Hatillo | Puerto Rico | 72065 | 805 | |
838423 | 838423 | 2020-12-17 | Hatillo | Puerto Rico | 72065 | 785 | |
835177 | 835177 | 2020-12-16 | Hatillo | Puerto Rico | 72065 | 773 | |
831931 | 831931 | 2020-12-15 | Hatillo | Puerto Rico | 72065 | 773 | |
828684 | 828684 | 2020-12-14 | Hatillo | Puerto Rico | 72065 | 771 | |
825438 | 825438 | 2020-12-13 | Hatillo | Puerto Rico | 72065 | 769 | |
822191 | 822191 | 2020-12-12 | Hatillo | Puerto Rico | 72065 | 766 | |
818945 | 818945 | 2020-12-11 | Hatillo | Puerto Rico | 72065 | 759 | |
815699 | 815699 | 2020-12-10 | Hatillo | Puerto Rico | 72065 | 728 | |
812453 | 812453 | 2020-12-09 | Hatillo | Puerto Rico | 72065 | 723 | |
809209 | 809209 | 2020-12-08 | Hatillo | Puerto Rico | 72065 | 708 | |
805964 | 805964 | 2020-12-07 | Hatillo | Puerto Rico | 72065 | 687 | |
802719 | 802719 | 2020-12-06 | Hatillo | Puerto Rico | 72065 | 661 | |
799474 | 799474 | 2020-12-05 | Hatillo | Puerto Rico | 72065 | 655 | |
796229 | 796229 | 2020-12-04 | Hatillo | Puerto Rico | 72065 | 653 | |
792984 | 792984 | 2020-12-03 | Hatillo | Puerto Rico | 72065 | 649 | |
789739 | 789739 | 2020-12-02 | Hatillo | Puerto Rico | 72065 | 645 | |
786494 | 786494 | 2020-12-01 | Hatillo | Puerto Rico | 72065 | 643 | |
783250 | 783250 | 2020-11-30 | Hatillo | Puerto Rico | 72065 | 632 | |
780005 | 780005 | 2020-11-29 | Hatillo | Puerto Rico | 72065 | 616 | |
776759 | 776759 | 2020-11-28 | Hatillo | Puerto Rico | 72065 | 615 | |
773514 | 773514 | 2020-11-27 | Hatillo | Puerto Rico | 72065 | 604 | |
770269 | 770269 | 2020-11-26 | Hatillo | Puerto Rico | 72065 | 579 | |
767023 | 767023 | 2020-11-25 | Hatillo | Puerto Rico | 72065 | 577 | |
763778 | 763778 | 2020-11-24 | Hatillo | Puerto Rico | 72065 | 576 | |
760533 | 760533 | 2020-11-23 | Hatillo | Puerto Rico | 72065 | 571 | |
757288 | 757288 | 2020-11-22 | Hatillo | Puerto Rico | 72065 | 555 | |
754041 | 754041 | 2020-11-21 | Hatillo | Puerto Rico | 72065 | 547 | |
750795 | 750795 | 2020-11-20 | Hatillo | Puerto Rico | 72065 | 531 | |
747549 | 747549 | 2020-11-19 | Hatillo | Puerto Rico | 72065 | 521 | |
744303 | 744303 | 2020-11-18 | Hatillo | Puerto Rico | 72065 | 517 |
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);