ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Unknown" 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 |
---|---|---|---|---|---|---|---|
1065642 | 1065642 | 2021-02-25 | Unknown | Puerto Rico | 4418 | 2016 | |
1062397 | 1062397 | 2021-02-24 | Unknown | Puerto Rico | 4416 | 2007 | |
1059152 | 1059152 | 2021-02-23 | Unknown | Puerto Rico | 4419 | 1986 | |
1055906 | 1055906 | 2021-02-22 | Unknown | Puerto Rico | 4418 | 1983 | |
1052660 | 1052660 | 2021-02-21 | Unknown | Puerto Rico | 4411 | 1979 | |
1049413 | 1049413 | 2021-02-20 | Unknown | Puerto Rico | 4400 | 1957 | |
1046166 | 1046166 | 2021-02-19 | Unknown | Puerto Rico | 4398 | 1947 | |
1042921 | 1042921 | 2021-02-18 | Unknown | Puerto Rico | 4397 | 1940 | |
1039676 | 1039676 | 2021-02-17 | Unknown | Puerto Rico | 4401 | 1930 | |
1036431 | 1036431 | 2021-02-16 | Unknown | Puerto Rico | 4391 | 1924 | |
1033186 | 1033186 | 2021-02-15 | Unknown | Puerto Rico | 4378 | 1920 | |
1029940 | 1029940 | 2021-02-14 | Unknown | Puerto Rico | 4379 | 1919 | |
1026693 | 1026693 | 2021-02-13 | Unknown | Puerto Rico | 4382 | 1915 | |
1023448 | 1023448 | 2021-02-12 | Unknown | Puerto Rico | 4358 | 1907 | |
1020203 | 1020203 | 2021-02-11 | Unknown | Puerto Rico | 4344 | 1902 | |
1016958 | 1016958 | 2021-02-10 | Unknown | Puerto Rico | 4347 | 1897 | |
1013713 | 1013713 | 2021-02-09 | Unknown | Puerto Rico | 4345 | 1893 | |
1010468 | 1010468 | 2021-02-08 | Unknown | Puerto Rico | 4344 | 1888 | |
1007222 | 1007222 | 2021-02-07 | Unknown | Puerto Rico | 4343 | 1883 | |
1003976 | 1003976 | 2021-02-06 | Unknown | Puerto Rico | 4321 | 1872 | |
1000730 | 1000730 | 2021-02-05 | Unknown | Puerto Rico | 4315 | 1867 | |
997484 | 997484 | 2021-02-04 | Unknown | Puerto Rico | 4334 | 1861 | |
994238 | 994238 | 2021-02-03 | Unknown | Puerto Rico | 4327 | 1853 | |
990992 | 990992 | 2021-02-02 | Unknown | Puerto Rico | 4324 | 1846 | |
987746 | 987746 | 2021-02-01 | Unknown | Puerto Rico | 4321 | 1836 | |
984499 | 984499 | 2021-01-31 | Unknown | Puerto Rico | 4297 | 1829 | |
981252 | 981252 | 2021-01-30 | Unknown | Puerto Rico | 4288 | 1823 | |
978006 | 978006 | 2021-01-29 | Unknown | Puerto Rico | 4260 | 1812 | |
974761 | 974761 | 2021-01-28 | Unknown | Puerto Rico | 4257 | 1801 | |
971516 | 971516 | 2021-01-27 | Unknown | Puerto Rico | 4253 | 1794 | |
968271 | 968271 | 2021-01-26 | Unknown | Puerto Rico | 4252 | 1783 | |
965027 | 965027 | 2021-01-25 | Unknown | Puerto Rico | 4232 | 1778 | |
961782 | 961782 | 2021-01-24 | Unknown | Puerto Rico | 4223 | 1773 | |
958537 | 958537 | 2021-01-23 | Unknown | Puerto Rico | 4214 | 1771 | |
955291 | 955291 | 2021-01-22 | Unknown | Puerto Rico | 4171 | 1761 | |
952046 | 952046 | 2021-01-21 | Unknown | Puerto Rico | 4164 | 1732 | |
948801 | 948801 | 2021-01-20 | Unknown | Puerto Rico | 4162 | 1717 | |
945555 | 945555 | 2021-01-19 | Unknown | Puerto Rico | 4155 | 1703 | |
942308 | 942308 | 2021-01-18 | Unknown | Puerto Rico | 4143 | 1703 | |
939063 | 939063 | 2021-01-17 | Unknown | Puerto Rico | 4137 | 1703 | |
935818 | 935818 | 2021-01-16 | Unknown | Puerto Rico | 4099 | 1703 | |
932573 | 932573 | 2021-01-15 | Unknown | Puerto Rico | 4096 | 1692 | |
929328 | 929328 | 2021-01-14 | Unknown | Puerto Rico | 4051 | 1679 | |
926083 | 926083 | 2021-01-13 | Unknown | Puerto Rico | 4055 | 1659 | |
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 |
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);