ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72043 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 |
---|---|---|---|---|---|---|---|
1065592 | 1065592 | 2021-02-25 | Coamo | Puerto Rico | 72043 | 943 | |
1062347 | 1062347 | 2021-02-24 | Coamo | Puerto Rico | 72043 | 941 | |
1059102 | 1059102 | 2021-02-23 | Coamo | Puerto Rico | 72043 | 941 | |
1055856 | 1055856 | 2021-02-22 | Coamo | Puerto Rico | 72043 | 940 | |
1052610 | 1052610 | 2021-02-21 | Coamo | Puerto Rico | 72043 | 940 | |
1049363 | 1049363 | 2021-02-20 | Coamo | Puerto Rico | 72043 | 938 | |
1046116 | 1046116 | 2021-02-19 | Coamo | Puerto Rico | 72043 | 938 | |
1042871 | 1042871 | 2021-02-18 | Coamo | Puerto Rico | 72043 | 937 | |
1039626 | 1039626 | 2021-02-17 | Coamo | Puerto Rico | 72043 | 937 | |
1036381 | 1036381 | 2021-02-16 | Coamo | Puerto Rico | 72043 | 936 | |
1033136 | 1033136 | 2021-02-15 | Coamo | Puerto Rico | 72043 | 933 | |
1029890 | 1029890 | 2021-02-14 | Coamo | Puerto Rico | 72043 | 933 | |
1026643 | 1026643 | 2021-02-13 | Coamo | Puerto Rico | 72043 | 932 | |
1023398 | 1023398 | 2021-02-12 | Coamo | Puerto Rico | 72043 | 931 | |
1020153 | 1020153 | 2021-02-11 | Coamo | Puerto Rico | 72043 | 931 | |
1016908 | 1016908 | 2021-02-10 | Coamo | Puerto Rico | 72043 | 931 | |
1013663 | 1013663 | 2021-02-09 | Coamo | Puerto Rico | 72043 | 931 | |
1010418 | 1010418 | 2021-02-08 | Coamo | Puerto Rico | 72043 | 929 | |
1007172 | 1007172 | 2021-02-07 | Coamo | Puerto Rico | 72043 | 928 | |
1003926 | 1003926 | 2021-02-06 | Coamo | Puerto Rico | 72043 | 927 | |
1000680 | 1000680 | 2021-02-05 | Coamo | Puerto Rico | 72043 | 925 | |
997434 | 997434 | 2021-02-04 | Coamo | Puerto Rico | 72043 | 926 | |
994188 | 994188 | 2021-02-03 | Coamo | Puerto Rico | 72043 | 921 | |
990942 | 990942 | 2021-02-02 | Coamo | Puerto Rico | 72043 | 919 | |
987696 | 987696 | 2021-02-01 | Coamo | Puerto Rico | 72043 | 917 | |
984449 | 984449 | 2021-01-31 | Coamo | Puerto Rico | 72043 | 915 | |
981202 | 981202 | 2021-01-30 | Coamo | Puerto Rico | 72043 | 914 | |
977956 | 977956 | 2021-01-29 | Coamo | Puerto Rico | 72043 | 911 | |
974711 | 974711 | 2021-01-28 | Coamo | Puerto Rico | 72043 | 906 | |
971466 | 971466 | 2021-01-27 | Coamo | Puerto Rico | 72043 | 905 | |
968221 | 968221 | 2021-01-26 | Coamo | Puerto Rico | 72043 | 904 | |
964977 | 964977 | 2021-01-25 | Coamo | Puerto Rico | 72043 | 902 | |
961732 | 961732 | 2021-01-24 | Coamo | Puerto Rico | 72043 | 899 | |
958487 | 958487 | 2021-01-23 | Coamo | Puerto Rico | 72043 | 894 | |
955241 | 955241 | 2021-01-22 | Coamo | Puerto Rico | 72043 | 889 | |
951996 | 951996 | 2021-01-21 | Coamo | Puerto Rico | 72043 | 885 | |
948751 | 948751 | 2021-01-20 | Coamo | Puerto Rico | 72043 | 882 | |
945505 | 945505 | 2021-01-19 | Coamo | Puerto Rico | 72043 | 882 | |
942258 | 942258 | 2021-01-18 | Coamo | Puerto Rico | 72043 | 882 | |
939013 | 939013 | 2021-01-17 | Coamo | Puerto Rico | 72043 | 874 | |
935768 | 935768 | 2021-01-16 | Coamo | Puerto Rico | 72043 | 870 | |
932523 | 932523 | 2021-01-15 | Coamo | Puerto Rico | 72043 | 864 | |
929278 | 929278 | 2021-01-14 | Coamo | Puerto Rico | 72043 | 858 | |
926033 | 926033 | 2021-01-13 | Coamo | Puerto Rico | 72043 | 857 | |
922787 | 922787 | 2021-01-12 | Coamo | Puerto Rico | 72043 | 854 | |
919542 | 919542 | 2021-01-11 | Coamo | Puerto Rico | 72043 | 840 | |
916297 | 916297 | 2021-01-10 | Coamo | Puerto Rico | 72043 | 835 | |
913052 | 913052 | 2021-01-09 | Coamo | Puerto Rico | 72043 | 809 | |
909807 | 909807 | 2021-01-08 | Coamo | Puerto Rico | 72043 | 802 | |
906562 | 906562 | 2021-01-07 | Coamo | Puerto Rico | 72043 | 792 | |
903316 | 903316 | 2021-01-06 | Coamo | Puerto Rico | 72043 | 788 | |
900071 | 900071 | 2021-01-05 | Coamo | Puerto Rico | 72043 | 787 | |
896826 | 896826 | 2021-01-04 | Coamo | Puerto Rico | 72043 | 776 | |
893580 | 893580 | 2021-01-03 | Coamo | Puerto Rico | 72043 | 769 | |
890334 | 890334 | 2021-01-02 | Coamo | Puerto Rico | 72043 | 768 | |
887087 | 887087 | 2021-01-01 | Coamo | Puerto Rico | 72043 | 747 | |
883842 | 883842 | 2020-12-31 | Coamo | Puerto Rico | 72043 | 743 | |
880597 | 880597 | 2020-12-30 | Coamo | Puerto Rico | 72043 | 738 | |
877352 | 877352 | 2020-12-29 | Coamo | Puerto Rico | 72043 | 738 | |
874107 | 874107 | 2020-12-28 | Coamo | Puerto Rico | 72043 | 705 | |
870862 | 870862 | 2020-12-27 | Coamo | Puerto Rico | 72043 | 703 | |
867617 | 867617 | 2020-12-26 | Coamo | Puerto Rico | 72043 | 699 | |
864372 | 864372 | 2020-12-25 | Coamo | Puerto Rico | 72043 | 694 | |
861127 | 861127 | 2020-12-24 | Coamo | Puerto Rico | 72043 | 691 | |
857882 | 857882 | 2020-12-23 | Coamo | Puerto Rico | 72043 | 687 | |
854637 | 854637 | 2020-12-22 | Coamo | Puerto Rico | 72043 | 687 | |
851392 | 851392 | 2020-12-21 | Coamo | Puerto Rico | 72043 | 682 | |
848147 | 848147 | 2020-12-20 | Coamo | Puerto Rico | 72043 | 679 | |
844902 | 844902 | 2020-12-19 | Coamo | Puerto Rico | 72043 | 676 | |
841656 | 841656 | 2020-12-18 | Coamo | Puerto Rico | 72043 | 663 | |
838411 | 838411 | 2020-12-17 | Coamo | Puerto Rico | 72043 | 654 | |
835165 | 835165 | 2020-12-16 | Coamo | Puerto Rico | 72043 | 649 | |
831919 | 831919 | 2020-12-15 | Coamo | Puerto Rico | 72043 | 649 | |
828672 | 828672 | 2020-12-14 | Coamo | Puerto Rico | 72043 | 646 | |
825426 | 825426 | 2020-12-13 | Coamo | Puerto Rico | 72043 | 630 | |
822179 | 822179 | 2020-12-12 | Coamo | Puerto Rico | 72043 | 615 | |
818933 | 818933 | 2020-12-11 | Coamo | Puerto Rico | 72043 | 607 | |
815687 | 815687 | 2020-12-10 | Coamo | Puerto Rico | 72043 | 599 | |
812441 | 812441 | 2020-12-09 | Coamo | Puerto Rico | 72043 | 596 | |
809197 | 809197 | 2020-12-08 | Coamo | Puerto Rico | 72043 | 592 | |
805952 | 805952 | 2020-12-07 | Coamo | Puerto Rico | 72043 | 587 | |
802707 | 802707 | 2020-12-06 | Coamo | Puerto Rico | 72043 | 581 | |
799462 | 799462 | 2020-12-05 | Coamo | Puerto Rico | 72043 | 574 | |
796217 | 796217 | 2020-12-04 | Coamo | Puerto Rico | 72043 | 568 | |
792972 | 792972 | 2020-12-03 | Coamo | Puerto Rico | 72043 | 567 | |
789727 | 789727 | 2020-12-02 | Coamo | Puerto Rico | 72043 | 567 | |
786482 | 786482 | 2020-12-01 | Coamo | Puerto Rico | 72043 | 565 | |
783238 | 783238 | 2020-11-30 | Coamo | Puerto Rico | 72043 | 562 | |
779993 | 779993 | 2020-11-29 | Coamo | Puerto Rico | 72043 | 561 | |
776747 | 776747 | 2020-11-28 | Coamo | Puerto Rico | 72043 | 558 | |
773502 | 773502 | 2020-11-27 | Coamo | Puerto Rico | 72043 | 552 | |
770257 | 770257 | 2020-11-26 | Coamo | Puerto Rico | 72043 | 538 | |
767011 | 767011 | 2020-11-25 | Coamo | Puerto Rico | 72043 | 525 | |
763766 | 763766 | 2020-11-24 | Coamo | Puerto Rico | 72043 | 525 | |
760521 | 760521 | 2020-11-23 | Coamo | Puerto Rico | 72043 | 525 | |
757276 | 757276 | 2020-11-22 | Coamo | Puerto Rico | 72043 | 525 | |
754029 | 754029 | 2020-11-21 | Coamo | Puerto Rico | 72043 | 521 | |
750783 | 750783 | 2020-11-20 | Coamo | Puerto Rico | 72043 | 511 | |
747537 | 747537 | 2020-11-19 | Coamo | Puerto Rico | 72043 | 509 | |
744291 | 744291 | 2020-11-18 | Coamo | Puerto Rico | 72043 | 507 |
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);