ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72031 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 |
---|---|---|---|---|---|---|---|
922781 | 922781 | 2021-01-12 | Carolina | Puerto Rico | 72031 | 7036 | |
919536 | 919536 | 2021-01-11 | Carolina | Puerto Rico | 72031 | 6971 | |
916291 | 916291 | 2021-01-10 | Carolina | Puerto Rico | 72031 | 6947 | |
913046 | 913046 | 2021-01-09 | Carolina | Puerto Rico | 72031 | 6935 | |
909801 | 909801 | 2021-01-08 | Carolina | Puerto Rico | 72031 | 6899 | |
906556 | 906556 | 2021-01-07 | Carolina | Puerto Rico | 72031 | 6744 | |
903310 | 903310 | 2021-01-06 | Carolina | Puerto Rico | 72031 | 6729 | |
900065 | 900065 | 2021-01-05 | Carolina | Puerto Rico | 72031 | 6702 | |
896820 | 896820 | 2021-01-04 | Carolina | Puerto Rico | 72031 | 6639 | |
893574 | 893574 | 2021-01-03 | Carolina | Puerto Rico | 72031 | 6598 | |
890328 | 890328 | 2021-01-02 | Carolina | Puerto Rico | 72031 | 6595 | |
887081 | 887081 | 2021-01-01 | Carolina | Puerto Rico | 72031 | 6527 | |
883836 | 883836 | 2020-12-31 | Carolina | Puerto Rico | 72031 | 6494 | |
880591 | 880591 | 2020-12-30 | Carolina | Puerto Rico | 72031 | 6466 | |
877346 | 877346 | 2020-12-29 | Carolina | Puerto Rico | 72031 | 6465 | |
874101 | 874101 | 2020-12-28 | Carolina | Puerto Rico | 72031 | 6367 | |
870856 | 870856 | 2020-12-27 | Carolina | Puerto Rico | 72031 | 6356 | |
867611 | 867611 | 2020-12-26 | Carolina | Puerto Rico | 72031 | 6315 | |
864366 | 864366 | 2020-12-25 | Carolina | Puerto Rico | 72031 | 6259 | |
861121 | 861121 | 2020-12-24 | Carolina | Puerto Rico | 72031 | 6230 | |
857876 | 857876 | 2020-12-23 | Carolina | Puerto Rico | 72031 | 6213 | |
854631 | 854631 | 2020-12-22 | Carolina | Puerto Rico | 72031 | 6182 | |
851386 | 851386 | 2020-12-21 | Carolina | Puerto Rico | 72031 | 6123 | |
848141 | 848141 | 2020-12-20 | Carolina | Puerto Rico | 72031 | 6103 | |
844896 | 844896 | 2020-12-19 | Carolina | Puerto Rico | 72031 | 6036 | |
841650 | 841650 | 2020-12-18 | Carolina | Puerto Rico | 72031 | 5978 | |
838405 | 838405 | 2020-12-17 | Carolina | Puerto Rico | 72031 | 5918 | |
835159 | 835159 | 2020-12-16 | Carolina | Puerto Rico | 72031 | 5864 | |
831913 | 831913 | 2020-12-15 | Carolina | Puerto Rico | 72031 | 5854 | |
828666 | 828666 | 2020-12-14 | Carolina | Puerto Rico | 72031 | 5842 | |
825420 | 825420 | 2020-12-13 | Carolina | Puerto Rico | 72031 | 5815 | |
822173 | 822173 | 2020-12-12 | Carolina | Puerto Rico | 72031 | 5758 | |
818927 | 818927 | 2020-12-11 | Carolina | Puerto Rico | 72031 | 5730 | |
815681 | 815681 | 2020-12-10 | Carolina | Puerto Rico | 72031 | 5660 | |
812435 | 812435 | 2020-12-09 | Carolina | Puerto Rico | 72031 | 5641 | |
809191 | 809191 | 2020-12-08 | Carolina | Puerto Rico | 72031 | 5604 | |
805946 | 805946 | 2020-12-07 | Carolina | Puerto Rico | 72031 | 5572 | |
802701 | 802701 | 2020-12-06 | Carolina | Puerto Rico | 72031 | 5509 | |
799456 | 799456 | 2020-12-05 | Carolina | Puerto Rico | 72031 | 5424 | |
796211 | 796211 | 2020-12-04 | Carolina | Puerto Rico | 72031 | 5285 | |
792966 | 792966 | 2020-12-03 | Carolina | Puerto Rico | 72031 | 5263 | |
789721 | 789721 | 2020-12-02 | Carolina | Puerto Rico | 72031 | 5250 | |
786476 | 786476 | 2020-12-01 | Carolina | Puerto Rico | 72031 | 5240 | |
783232 | 783232 | 2020-11-30 | Carolina | Puerto Rico | 72031 | 5215 | |
779987 | 779987 | 2020-11-29 | Carolina | Puerto Rico | 72031 | 5165 | |
776741 | 776741 | 2020-11-28 | Carolina | Puerto Rico | 72031 | 5162 | |
773496 | 773496 | 2020-11-27 | Carolina | Puerto Rico | 72031 | 5114 | |
770251 | 770251 | 2020-11-26 | Carolina | Puerto Rico | 72031 | 5039 | |
767005 | 767005 | 2020-11-25 | Carolina | Puerto Rico | 72031 | 5014 | |
763760 | 763760 | 2020-11-24 | Carolina | Puerto Rico | 72031 | 5006 | |
760515 | 760515 | 2020-11-23 | Carolina | Puerto Rico | 72031 | 4993 | |
757270 | 757270 | 2020-11-22 | Carolina | Puerto Rico | 72031 | 4958 | |
754023 | 754023 | 2020-11-21 | Carolina | Puerto Rico | 72031 | 4896 | |
750777 | 750777 | 2020-11-20 | Carolina | Puerto Rico | 72031 | 4832 | |
747531 | 747531 | 2020-11-19 | Carolina | Puerto Rico | 72031 | 4790 | |
744285 | 744285 | 2020-11-18 | Carolina | Puerto Rico | 72031 | 4770 | |
741038 | 741038 | 2020-11-17 | Carolina | Puerto Rico | 72031 | 4757 | |
737792 | 737792 | 2020-11-16 | Carolina | Puerto Rico | 72031 | 4729 | |
734548 | 734548 | 2020-11-15 | Carolina | Puerto Rico | 72031 | 4710 | |
731302 | 731302 | 2020-11-14 | Carolina | Puerto Rico | 72031 | 4672 | |
728058 | 728058 | 2020-11-13 | Carolina | Puerto Rico | 72031 | 4642 | |
724814 | 724814 | 2020-11-12 | Carolina | Puerto Rico | 72031 | 4593 | |
721571 | 721571 | 2020-11-11 | Carolina | Puerto Rico | 72031 | 4511 | |
718328 | 718328 | 2020-11-10 | Carolina | Puerto Rico | 72031 | 4489 | |
715085 | 715085 | 2020-11-09 | Carolina | Puerto Rico | 72031 | 4480 | |
711841 | 711841 | 2020-11-08 | Carolina | Puerto Rico | 72031 | 4444 | |
708597 | 708597 | 2020-11-07 | Carolina | Puerto Rico | 72031 | 4393 | |
705354 | 705354 | 2020-11-06 | Carolina | Puerto Rico | 72031 | 4393 | |
702111 | 702111 | 2020-11-05 | Carolina | Puerto Rico | 72031 | 4339 | |
698867 | 698867 | 2020-11-04 | Carolina | Puerto Rico | 72031 | 4323 | |
695624 | 695624 | 2020-11-03 | Carolina | Puerto Rico | 72031 | 4318 | |
692382 | 692382 | 2020-11-02 | Carolina | Puerto Rico | 72031 | 4295 | |
689138 | 689138 | 2020-11-01 | Carolina | Puerto Rico | 72031 | 4165 | |
685893 | 685893 | 2020-10-31 | Carolina | Puerto Rico | 72031 | 4145 | |
682650 | 682650 | 2020-10-30 | Carolina | Puerto Rico | 72031 | 4120 | |
679407 | 679407 | 2020-10-29 | Carolina | Puerto Rico | 72031 | 4068 | |
676164 | 676164 | 2020-10-28 | Carolina | Puerto Rico | 72031 | 4010 | |
672921 | 672921 | 2020-10-27 | Carolina | Puerto Rico | 72031 | 4009 | |
669679 | 669679 | 2020-10-26 | Carolina | Puerto Rico | 72031 | 3997 | |
666435 | 666435 | 2020-10-25 | Carolina | Puerto Rico | 72031 | 3901 | |
663190 | 663190 | 2020-10-24 | Carolina | Puerto Rico | 72031 | 3837 | |
659946 | 659946 | 2020-10-23 | Carolina | Puerto Rico | 72031 | 3834 | |
656702 | 656702 | 2020-10-22 | Carolina | Puerto Rico | 72031 | 3693 | |
653457 | 653457 | 2020-10-21 | Carolina | Puerto Rico | 72031 | 3692 | |
650212 | 650212 | 2020-10-20 | Carolina | Puerto Rico | 72031 | 3640 | |
646968 | 646968 | 2020-10-19 | Carolina | Puerto Rico | 72031 | 3444 | |
643722 | 643722 | 2020-10-18 | Carolina | Puerto Rico | 72031 | 3415 | |
640474 | 640474 | 2020-10-17 | Carolina | Puerto Rico | 72031 | 3376 | |
637228 | 637228 | 2020-10-16 | Carolina | Puerto Rico | 72031 | 3355 | |
633982 | 633982 | 2020-10-15 | Carolina | Puerto Rico | 72031 | 3336 | |
630737 | 630737 | 2020-10-14 | Carolina | Puerto Rico | 72031 | 3305 | |
627493 | 627493 | 2020-10-13 | Carolina | Puerto Rico | 72031 | 3245 | |
624251 | 624251 | 2020-10-12 | Carolina | Puerto Rico | 72031 | 3237 | |
621008 | 621008 | 2020-10-11 | Carolina | Puerto Rico | 72031 | 3216 | |
617765 | 617765 | 2020-10-10 | Carolina | Puerto Rico | 72031 | 3198 | |
614523 | 614523 | 2020-10-09 | Carolina | Puerto Rico | 72031 | 3185 | |
611282 | 611282 | 2020-10-08 | Carolina | Puerto Rico | 72031 | 3145 | |
608040 | 608040 | 2020-10-07 | Carolina | Puerto Rico | 72031 | 3121 | |
604797 | 604797 | 2020-10-06 | Carolina | Puerto Rico | 72031 | 3121 | |
601555 | 601555 | 2020-10-05 | Carolina | Puerto Rico | 72031 | 3103 |
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);