ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Cayey" 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 |
---|---|---|---|---|---|---|---|
922783 | 922783 | 2021-01-12 | Cayey | Puerto Rico | 72035 | 1132 | |
919538 | 919538 | 2021-01-11 | Cayey | Puerto Rico | 72035 | 1121 | |
916293 | 916293 | 2021-01-10 | Cayey | Puerto Rico | 72035 | 1115 | |
913048 | 913048 | 2021-01-09 | Cayey | Puerto Rico | 72035 | 1110 | |
909803 | 909803 | 2021-01-08 | Cayey | Puerto Rico | 72035 | 1107 | |
906558 | 906558 | 2021-01-07 | Cayey | Puerto Rico | 72035 | 1099 | |
903312 | 903312 | 2021-01-06 | Cayey | Puerto Rico | 72035 | 1092 | |
900067 | 900067 | 2021-01-05 | Cayey | Puerto Rico | 72035 | 1089 | |
896822 | 896822 | 2021-01-04 | Cayey | Puerto Rico | 72035 | 1089 | |
893576 | 893576 | 2021-01-03 | Cayey | Puerto Rico | 72035 | 1087 | |
890330 | 890330 | 2021-01-02 | Cayey | Puerto Rico | 72035 | 1082 | |
887083 | 887083 | 2021-01-01 | Cayey | Puerto Rico | 72035 | 1075 | |
883838 | 883838 | 2020-12-31 | Cayey | Puerto Rico | 72035 | 1050 | |
880593 | 880593 | 2020-12-30 | Cayey | Puerto Rico | 72035 | 1046 | |
877348 | 877348 | 2020-12-29 | Cayey | Puerto Rico | 72035 | 1044 | |
874103 | 874103 | 2020-12-28 | Cayey | Puerto Rico | 72035 | 1035 | |
870858 | 870858 | 2020-12-27 | Cayey | Puerto Rico | 72035 | 1033 | |
867613 | 867613 | 2020-12-26 | Cayey | Puerto Rico | 72035 | 1020 | |
864368 | 864368 | 2020-12-25 | Cayey | Puerto Rico | 72035 | 1017 | |
861123 | 861123 | 2020-12-24 | Cayey | Puerto Rico | 72035 | 1010 | |
857878 | 857878 | 2020-12-23 | Cayey | Puerto Rico | 72035 | 1006 | |
854633 | 854633 | 2020-12-22 | Cayey | Puerto Rico | 72035 | 1003 | |
851388 | 851388 | 2020-12-21 | Cayey | Puerto Rico | 72035 | 993 | |
848143 | 848143 | 2020-12-20 | Cayey | Puerto Rico | 72035 | 984 | |
844898 | 844898 | 2020-12-19 | Cayey | Puerto Rico | 72035 | 962 | |
841652 | 841652 | 2020-12-18 | Cayey | Puerto Rico | 72035 | 943 | |
838407 | 838407 | 2020-12-17 | Cayey | Puerto Rico | 72035 | 932 | |
835161 | 835161 | 2020-12-16 | Cayey | Puerto Rico | 72035 | 924 | |
831915 | 831915 | 2020-12-15 | Cayey | Puerto Rico | 72035 | 923 | |
828668 | 828668 | 2020-12-14 | Cayey | Puerto Rico | 72035 | 916 | |
825422 | 825422 | 2020-12-13 | Cayey | Puerto Rico | 72035 | 903 | |
822175 | 822175 | 2020-12-12 | Cayey | Puerto Rico | 72035 | 896 | |
818929 | 818929 | 2020-12-11 | Cayey | Puerto Rico | 72035 | 883 | |
815683 | 815683 | 2020-12-10 | Cayey | Puerto Rico | 72035 | 864 | |
812437 | 812437 | 2020-12-09 | Cayey | Puerto Rico | 72035 | 859 | |
809193 | 809193 | 2020-12-08 | Cayey | Puerto Rico | 72035 | 856 | |
805948 | 805948 | 2020-12-07 | Cayey | Puerto Rico | 72035 | 849 | |
802703 | 802703 | 2020-12-06 | Cayey | Puerto Rico | 72035 | 830 | |
799458 | 799458 | 2020-12-05 | Cayey | Puerto Rico | 72035 | 811 | |
796213 | 796213 | 2020-12-04 | Cayey | Puerto Rico | 72035 | 792 | |
792968 | 792968 | 2020-12-03 | Cayey | Puerto Rico | 72035 | 786 | |
789723 | 789723 | 2020-12-02 | Cayey | Puerto Rico | 72035 | 786 | |
786478 | 786478 | 2020-12-01 | Cayey | Puerto Rico | 72035 | 776 | |
783234 | 783234 | 2020-11-30 | Cayey | Puerto Rico | 72035 | 766 | |
779989 | 779989 | 2020-11-29 | Cayey | Puerto Rico | 72035 | 755 | |
776743 | 776743 | 2020-11-28 | Cayey | Puerto Rico | 72035 | 750 | |
773498 | 773498 | 2020-11-27 | Cayey | Puerto Rico | 72035 | 735 | |
770253 | 770253 | 2020-11-26 | Cayey | Puerto Rico | 72035 | 704 | |
767007 | 767007 | 2020-11-25 | Cayey | Puerto Rico | 72035 | 700 | |
763762 | 763762 | 2020-11-24 | Cayey | Puerto Rico | 72035 | 698 | |
760517 | 760517 | 2020-11-23 | Cayey | Puerto Rico | 72035 | 689 | |
757272 | 757272 | 2020-11-22 | Cayey | Puerto Rico | 72035 | 669 | |
754025 | 754025 | 2020-11-21 | Cayey | Puerto Rico | 72035 | 655 | |
750779 | 750779 | 2020-11-20 | Cayey | Puerto Rico | 72035 | 640 | |
747533 | 747533 | 2020-11-19 | Cayey | Puerto Rico | 72035 | 633 | |
744287 | 744287 | 2020-11-18 | Cayey | Puerto Rico | 72035 | 625 | |
741040 | 741040 | 2020-11-17 | Cayey | Puerto Rico | 72035 | 625 | |
737794 | 737794 | 2020-11-16 | Cayey | Puerto Rico | 72035 | 616 | |
734550 | 734550 | 2020-11-15 | Cayey | Puerto Rico | 72035 | 612 | |
731304 | 731304 | 2020-11-14 | Cayey | Puerto Rico | 72035 | 606 | |
728060 | 728060 | 2020-11-13 | Cayey | Puerto Rico | 72035 | 597 | |
724816 | 724816 | 2020-11-12 | Cayey | Puerto Rico | 72035 | 593 | |
721573 | 721573 | 2020-11-11 | Cayey | Puerto Rico | 72035 | 577 | |
718330 | 718330 | 2020-11-10 | Cayey | Puerto Rico | 72035 | 577 | |
715087 | 715087 | 2020-11-09 | Cayey | Puerto Rico | 72035 | 575 | |
711843 | 711843 | 2020-11-08 | Cayey | Puerto Rico | 72035 | 572 | |
708599 | 708599 | 2020-11-07 | Cayey | Puerto Rico | 72035 | 563 | |
705356 | 705356 | 2020-11-06 | Cayey | Puerto Rico | 72035 | 563 | |
702113 | 702113 | 2020-11-05 | Cayey | Puerto Rico | 72035 | 562 | |
698869 | 698869 | 2020-11-04 | Cayey | Puerto Rico | 72035 | 556 | |
695626 | 695626 | 2020-11-03 | Cayey | Puerto Rico | 72035 | 556 | |
692384 | 692384 | 2020-11-02 | Cayey | Puerto Rico | 72035 | 550 | |
689140 | 689140 | 2020-11-01 | Cayey | Puerto Rico | 72035 | 541 | |
685895 | 685895 | 2020-10-31 | Cayey | Puerto Rico | 72035 | 533 | |
682652 | 682652 | 2020-10-30 | Cayey | Puerto Rico | 72035 | 524 | |
679409 | 679409 | 2020-10-29 | Cayey | Puerto Rico | 72035 | 510 | |
676166 | 676166 | 2020-10-28 | Cayey | Puerto Rico | 72035 | 497 | |
672923 | 672923 | 2020-10-27 | Cayey | Puerto Rico | 72035 | 496 | |
669681 | 669681 | 2020-10-26 | Cayey | Puerto Rico | 72035 | 491 | |
666437 | 666437 | 2020-10-25 | Cayey | Puerto Rico | 72035 | 488 | |
663192 | 663192 | 2020-10-24 | Cayey | Puerto Rico | 72035 | 481 | |
659948 | 659948 | 2020-10-23 | Cayey | Puerto Rico | 72035 | 484 | |
656704 | 656704 | 2020-10-22 | Cayey | Puerto Rico | 72035 | 461 | |
653459 | 653459 | 2020-10-21 | Cayey | Puerto Rico | 72035 | 452 | |
650214 | 650214 | 2020-10-20 | Cayey | Puerto Rico | 72035 | 452 | |
646970 | 646970 | 2020-10-19 | Cayey | Puerto Rico | 72035 | 452 | |
643724 | 643724 | 2020-10-18 | Cayey | Puerto Rico | 72035 | 446 | |
640476 | 640476 | 2020-10-17 | Cayey | Puerto Rico | 72035 | 439 | |
637230 | 637230 | 2020-10-16 | Cayey | Puerto Rico | 72035 | 434 | |
633984 | 633984 | 2020-10-15 | Cayey | Puerto Rico | 72035 | 429 | |
630739 | 630739 | 2020-10-14 | Cayey | Puerto Rico | 72035 | 427 | |
627495 | 627495 | 2020-10-13 | Cayey | Puerto Rico | 72035 | 425 | |
624253 | 624253 | 2020-10-12 | Cayey | Puerto Rico | 72035 | 418 | |
621010 | 621010 | 2020-10-11 | Cayey | Puerto Rico | 72035 | 406 | |
617767 | 617767 | 2020-10-10 | Cayey | Puerto Rico | 72035 | 401 | |
614525 | 614525 | 2020-10-09 | Cayey | Puerto Rico | 72035 | 394 | |
611284 | 611284 | 2020-10-08 | Cayey | Puerto Rico | 72035 | 390 | |
608042 | 608042 | 2020-10-07 | Cayey | Puerto Rico | 72035 | 388 | |
604799 | 604799 | 2020-10-06 | Cayey | Puerto Rico | 72035 | 388 | |
601557 | 601557 | 2020-10-05 | Cayey | Puerto Rico | 72035 | 385 |
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);