ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where fips = "" 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 |
---|---|---|---|---|---|---|---|
922837 | 922837 | 2021-01-12 | Unknown | Puerto Rico | 4052 | 1645 | |
919592 | 919592 | 2021-01-11 | Unknown | Puerto Rico | 4016 | 1642 | |
916347 | 916347 | 2021-01-10 | Unknown | Puerto Rico | 4016 | 1630 | |
913102 | 913102 | 2021-01-09 | Unknown | Puerto Rico | 4019 | 1616 | |
909857 | 909857 | 2021-01-08 | Unknown | Puerto Rico | 4006 | 1592 | |
906612 | 906612 | 2021-01-07 | Unknown | Puerto Rico | 3933 | 1588 | |
903366 | 903366 | 2021-01-06 | Unknown | Puerto Rico | 3963 | 1570 | |
900121 | 900121 | 2021-01-05 | Unknown | Puerto Rico | 3980 | 1562 | |
896876 | 896876 | 2021-01-04 | Unknown | Puerto Rico | 3926 | 1555 | |
893630 | 893630 | 2021-01-03 | Unknown | Puerto Rico | 3894 | 1545 | |
890384 | 890384 | 2021-01-02 | Unknown | Puerto Rico | 3896 | 1526 | |
887137 | 887137 | 2021-01-01 | Unknown | Puerto Rico | 3858 | 1521 | |
883892 | 883892 | 2020-12-31 | Unknown | Puerto Rico | 3875 | 1503 | |
880647 | 880647 | 2020-12-30 | Unknown | Puerto Rico | 3870 | 1484 | |
877402 | 877402 | 2020-12-29 | Unknown | Puerto Rico | 3866 | 1460 | |
874157 | 874157 | 2020-12-28 | Unknown | Puerto Rico | 3739 | 1456 | |
870912 | 870912 | 2020-12-27 | Unknown | Puerto Rico | 3743 | 1445 | |
867667 | 867667 | 2020-12-26 | Unknown | Puerto Rico | 3715 | 1432 | |
864422 | 864422 | 2020-12-25 | Unknown | Puerto Rico | 3685 | 1432 | |
861177 | 861177 | 2020-12-24 | Unknown | Puerto Rico | 3656 | 1423 | |
857932 | 857932 | 2020-12-23 | Unknown | Puerto Rico | 3632 | 1408 | |
854687 | 854687 | 2020-12-22 | Unknown | Puerto Rico | 3614 | 1391 | |
851442 | 851442 | 2020-12-21 | Unknown | Puerto Rico | 3541 | 1382 | |
848197 | 848197 | 2020-12-20 | Unknown | Puerto Rico | 3536 | 1368 | |
844952 | 844952 | 2020-12-19 | Unknown | Puerto Rico | 3431 | 1342 | |
841706 | 841706 | 2020-12-18 | Unknown | Puerto Rico | 3384 | 1333 | |
838461 | 838461 | 2020-12-17 | Unknown | Puerto Rico | 3329 | 1323 | |
835215 | 835215 | 2020-12-16 | Unknown | Puerto Rico | 3274 | 1312 | |
831969 | 831969 | 2020-12-15 | Unknown | Puerto Rico | 3274 | 1294 | |
828722 | 828722 | 2020-12-14 | Unknown | Puerto Rico | 3266 | 1282 | |
825476 | 825476 | 2020-12-13 | Unknown | Puerto Rico | 3245 | 1272 | |
822229 | 822229 | 2020-12-12 | Unknown | Puerto Rico | 3237 | 1266 | |
818983 | 818983 | 2020-12-11 | Unknown | Puerto Rico | 3232 | 1249 | |
815737 | 815737 | 2020-12-10 | Unknown | Puerto Rico | 3144 | 1238 | |
812491 | 812491 | 2020-12-09 | Unknown | Puerto Rico | 3130 | 1219 | |
809247 | 809247 | 2020-12-08 | Unknown | Puerto Rico | 3093 | 1205 | |
806002 | 806002 | 2020-12-07 | Unknown | Puerto Rico | 3058 | 1202 | |
802757 | 802757 | 2020-12-06 | Unknown | Puerto Rico | 3028 | 1191 | |
799512 | 799512 | 2020-12-05 | Unknown | Puerto Rico | 2976 | 1184 | |
796267 | 796267 | 2020-12-04 | Unknown | Puerto Rico | 2946 | 1172 | |
793022 | 793022 | 2020-12-03 | Unknown | Puerto Rico | 2937 | 1155 | |
789777 | 789777 | 2020-12-02 | Unknown | Puerto Rico | 2934 | 1144 | |
786532 | 786532 | 2020-12-01 | Unknown | Puerto Rico | 2907 | 1122 | |
783288 | 783288 | 2020-11-30 | Unknown | Puerto Rico | 2868 | 1106 | |
780043 | 780043 | 2020-11-29 | Unknown | Puerto Rico | 2822 | 1094 | |
776797 | 776797 | 2020-11-28 | Unknown | Puerto Rico | 2824 | 1083 | |
773552 | 773552 | 2020-11-27 | Unknown | Puerto Rico | 2792 | 1076 | |
770307 | 770307 | 2020-11-26 | Unknown | Puerto Rico | 2718 | 1069 | |
767061 | 767061 | 2020-11-25 | Unknown | Puerto Rico | 2691 | 1052 | |
763816 | 763816 | 2020-11-24 | Unknown | Puerto Rico | 2682 | 1038 | |
760571 | 760571 | 2020-11-23 | Unknown | Puerto Rico | 2681 | 1032 | |
757326 | 757326 | 2020-11-22 | Unknown | Puerto Rico | 2641 | 1017 | |
754079 | 754079 | 2020-11-21 | Unknown | Puerto Rico | 2597 | 1012 | |
750833 | 750833 | 2020-11-20 | Unknown | Puerto Rico | 2557 | 991 | |
747587 | 747587 | 2020-11-19 | Unknown | Puerto Rico | 2519 | 982 | |
744341 | 744341 | 2020-11-18 | Unknown | Puerto Rico | 2513 | 971 | |
741094 | 741094 | 2020-11-17 | Unknown | Puerto Rico | 2505 | 951 | |
737848 | 737848 | 2020-11-16 | Unknown | Puerto Rico | 2488 | 942 | |
734604 | 734604 | 2020-11-15 | Unknown | Puerto Rico | 2476 | 935 | |
731358 | 731358 | 2020-11-14 | Unknown | Puerto Rico | 2453 | 921 | |
728114 | 728114 | 2020-11-13 | Unknown | Puerto Rico | 2438 | 914 | |
724870 | 724870 | 2020-11-12 | Unknown | Puerto Rico | 2420 | 909 | |
721627 | 721627 | 2020-11-11 | Unknown | Puerto Rico | 2367 | 901 | |
718384 | 718384 | 2020-11-10 | Unknown | Puerto Rico | 2353 | 889 | |
715141 | 715141 | 2020-11-09 | Unknown | Puerto Rico | 2345 | 882 | |
711897 | 711897 | 2020-11-08 | Unknown | Puerto Rico | 2319 | 872 | |
708653 | 708653 | 2020-11-07 | Unknown | Puerto Rico | 3277 | 862 | |
705410 | 705410 | 2020-11-06 | Unknown | Puerto Rico | 2264 | 862 | |
702167 | 702167 | 2020-11-05 | Unknown | Puerto Rico | 2190 | 855 | |
698923 | 698923 | 2020-11-04 | Unknown | Puerto Rico | 2182 | 850 | |
695680 | 695680 | 2020-11-03 | Unknown | Puerto Rico | 2180 | 842 | |
692438 | 692438 | 2020-11-02 | Unknown | Puerto Rico | 2164 | 839 | |
689194 | 689194 | 2020-11-01 | Unknown | Puerto Rico | 2115 | 832 | |
685949 | 685949 | 2020-10-31 | Unknown | Puerto Rico | 2097 | 822 | |
682706 | 682706 | 2020-10-30 | Unknown | Puerto Rico | 2089 | 820 | |
679463 | 679463 | 2020-10-29 | Unknown | Puerto Rico | 2052 | 814 | |
676220 | 676220 | 2020-10-28 | Unknown | Puerto Rico | 1964 | 813 | |
672977 | 672977 | 2020-10-27 | Unknown | Puerto Rico | 1945 | 808 | |
669735 | 669735 | 2020-10-26 | Unknown | Puerto Rico | 1914 | 804 | |
666491 | 666491 | 2020-10-25 | Unknown | Puerto Rico | 1903 | 801 | |
663246 | 663246 | 2020-10-24 | Unknown | Puerto Rico | 1833 | 794 | |
660002 | 660002 | 2020-10-23 | Unknown | Puerto Rico | 1834 | 791 | |
656758 | 656758 | 2020-10-22 | Unknown | Puerto Rico | 1721 | 783 | |
653513 | 653513 | 2020-10-21 | Unknown | Puerto Rico | 1721 | 774 | |
650268 | 650268 | 2020-10-20 | Unknown | Puerto Rico | 1715 | 769 | |
647024 | 647024 | 2020-10-19 | Unknown | Puerto Rico | 1706 | 768 | |
643778 | 643778 | 2020-10-18 | Unknown | Puerto Rico | 1679 | 766 | |
640530 | 640530 | 2020-10-17 | Unknown | Puerto Rico | 1651 | 761 | |
637284 | 637284 | 2020-10-16 | Unknown | Puerto Rico | 1651 | 758 | |
634038 | 634038 | 2020-10-15 | Unknown | Puerto Rico | 1650 | 743 | |
630793 | 630793 | 2020-10-14 | Unknown | Puerto Rico | 1634 | 742 | |
627549 | 627549 | 2020-10-13 | Unknown | Puerto Rico | 1566 | 738 | |
624307 | 624307 | 2020-10-12 | Unknown | Puerto Rico | 1557 | 735 | |
621064 | 621064 | 2020-10-11 | Unknown | Puerto Rico | 1528 | 730 | |
617821 | 617821 | 2020-10-10 | Unknown | Puerto Rico | 1511 | 728 | |
614579 | 614579 | 2020-10-09 | Unknown | Puerto Rico | 1470 | 720 | |
611338 | 611338 | 2020-10-08 | Unknown | Puerto Rico | 1455 | 715 | |
608096 | 608096 | 2020-10-07 | Unknown | Puerto Rico | 1439 | 705 | |
604853 | 604853 | 2020-10-06 | Unknown | Puerto Rico | 1439 | 696 | |
601611 | 601611 | 2020-10-05 | Unknown | Puerto Rico | 1426 | 695 |
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);