ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72054 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 |
---|---|---|---|---|---|---|---|
1279901 | 1279901 | 2021-05-02 | Florida | Puerto Rico | 72054 | 811 | |
1276654 | 1276654 | 2021-05-01 | Florida | Puerto Rico | 72054 | 806 | |
1273407 | 1273407 | 2021-04-30 | Florida | Puerto Rico | 72054 | 802 | |
1270160 | 1270160 | 2021-04-29 | Florida | Puerto Rico | 72054 | 798 | |
1266913 | 1266913 | 2021-04-28 | Florida | Puerto Rico | 72054 | 797 | |
1263666 | 1263666 | 2021-04-27 | Florida | Puerto Rico | 72054 | 793 | |
1260419 | 1260419 | 2021-04-26 | Florida | Puerto Rico | 72054 | 788 | |
1257172 | 1257172 | 2021-04-25 | Florida | Puerto Rico | 72054 | 780 | |
1253925 | 1253925 | 2021-04-24 | Florida | Puerto Rico | 72054 | 774 | |
1250678 | 1250678 | 2021-04-23 | Florida | Puerto Rico | 72054 | 769 | |
1247431 | 1247431 | 2021-04-22 | Florida | Puerto Rico | 72054 | 766 | |
1244184 | 1244184 | 2021-04-21 | Florida | Puerto Rico | 72054 | 765 | |
1240937 | 1240937 | 2021-04-20 | Florida | Puerto Rico | 72054 | 765 | |
1237690 | 1237690 | 2021-04-19 | Florida | Puerto Rico | 72054 | 764 | |
1234443 | 1234443 | 2021-04-18 | Florida | Puerto Rico | 72054 | 749 | |
1231195 | 1231195 | 2021-04-17 | Florida | Puerto Rico | 72054 | 743 | |
1227947 | 1227947 | 2021-04-16 | Florida | Puerto Rico | 72054 | 734 | |
1224699 | 1224699 | 2021-04-15 | Florida | Puerto Rico | 72054 | 731 | |
1221452 | 1221452 | 2021-04-14 | Florida | Puerto Rico | 72054 | 731 | |
1218204 | 1218204 | 2021-04-13 | Florida | Puerto Rico | 72054 | 728 | |
1214956 | 1214956 | 2021-04-12 | Florida | Puerto Rico | 72054 | 723 | |
1211709 | 1211709 | 2021-04-11 | Florida | Puerto Rico | 72054 | 723 | |
1208460 | 1208460 | 2021-04-10 | Florida | Puerto Rico | 72054 | 719 | |
1205212 | 1205212 | 2021-04-09 | Florida | Puerto Rico | 72054 | 716 | |
1201964 | 1201964 | 2021-04-08 | Florida | Puerto Rico | 72054 | 713 | |
1198715 | 1198715 | 2021-04-07 | Florida | Puerto Rico | 72054 | 713 | |
1195466 | 1195466 | 2021-04-06 | Florida | Puerto Rico | 72054 | 713 | |
1192218 | 1192218 | 2021-04-05 | Florida | Puerto Rico | 72054 | 713 | |
1188969 | 1188969 | 2021-04-04 | Florida | Puerto Rico | 72054 | 711 | |
1185722 | 1185722 | 2021-04-03 | Florida | Puerto Rico | 72054 | 706 | |
1182475 | 1182475 | 2021-04-02 | Florida | Puerto Rico | 72054 | 704 | |
1179228 | 1179228 | 2021-04-01 | Florida | Puerto Rico | 72054 | 704 | |
1175981 | 1175981 | 2021-03-31 | Florida | Puerto Rico | 72054 | 703 | |
1172734 | 1172734 | 2021-03-30 | Florida | Puerto Rico | 72054 | 703 | |
1169487 | 1169487 | 2021-03-29 | Florida | Puerto Rico | 72054 | 701 | |
1166239 | 1166239 | 2021-03-28 | Florida | Puerto Rico | 72054 | 699 | |
1162991 | 1162991 | 2021-03-27 | Florida | Puerto Rico | 72054 | 698 | |
1159742 | 1159742 | 2021-03-26 | Florida | Puerto Rico | 72054 | 695 | |
1156495 | 1156495 | 2021-03-25 | Florida | Puerto Rico | 72054 | 694 | |
1153248 | 1153248 | 2021-03-24 | Florida | Puerto Rico | 72054 | 694 | |
1150001 | 1150001 | 2021-03-23 | Florida | Puerto Rico | 72054 | 692 | |
1146754 | 1146754 | 2021-03-22 | Florida | Puerto Rico | 72054 | 692 | |
1143507 | 1143507 | 2021-03-21 | Florida | Puerto Rico | 72054 | 692 | |
1140260 | 1140260 | 2021-03-20 | Florida | Puerto Rico | 72054 | 692 | |
1137014 | 1137014 | 2021-03-19 | Florida | Puerto Rico | 72054 | 692 | |
1133768 | 1133768 | 2021-03-18 | Florida | Puerto Rico | 72054 | 691 | |
1130520 | 1130520 | 2021-03-17 | Florida | Puerto Rico | 72054 | 691 | |
1127273 | 1127273 | 2021-03-16 | Florida | Puerto Rico | 72054 | 691 | |
1124027 | 1124027 | 2021-03-15 | Florida | Puerto Rico | 72054 | 687 | |
1120781 | 1120781 | 2021-03-14 | Florida | Puerto Rico | 72054 | 686 | |
1117534 | 1117534 | 2021-03-13 | Florida | Puerto Rico | 72054 | 684 | |
1114287 | 1114287 | 2021-03-12 | Florida | Puerto Rico | 72054 | 683 | |
1111041 | 1111041 | 2021-03-11 | Florida | Puerto Rico | 72054 | 680 | |
1107795 | 1107795 | 2021-03-10 | Florida | Puerto Rico | 72054 | 680 | |
1104549 | 1104549 | 2021-03-09 | Florida | Puerto Rico | 72054 | 680 | |
1101303 | 1101303 | 2021-03-08 | Florida | Puerto Rico | 72054 | 680 | |
1098057 | 1098057 | 2021-03-07 | Florida | Puerto Rico | 72054 | 676 | |
1094809 | 1094809 | 2021-03-06 | Florida | Puerto Rico | 72054 | 676 | |
1091563 | 1091563 | 2021-03-05 | Florida | Puerto Rico | 72054 | 676 | |
1088317 | 1088317 | 2021-03-04 | Florida | Puerto Rico | 72054 | 676 | |
1085072 | 1085072 | 2021-03-03 | Florida | Puerto Rico | 72054 | 675 | |
1081826 | 1081826 | 2021-03-02 | Florida | Puerto Rico | 72054 | 675 | |
1078580 | 1078580 | 2021-03-01 | Florida | Puerto Rico | 72054 | 675 | |
1075335 | 1075335 | 2021-02-28 | Florida | Puerto Rico | 72054 | 675 | |
1072089 | 1072089 | 2021-02-27 | Florida | Puerto Rico | 72054 | 675 | |
1068843 | 1068843 | 2021-02-26 | Florida | Puerto Rico | 72054 | 675 | |
1065598 | 1065598 | 2021-02-25 | Florida | Puerto Rico | 72054 | 675 | |
1062353 | 1062353 | 2021-02-24 | Florida | Puerto Rico | 72054 | 675 | |
1059108 | 1059108 | 2021-02-23 | Florida | Puerto Rico | 72054 | 675 | |
1055862 | 1055862 | 2021-02-22 | Florida | Puerto Rico | 72054 | 674 | |
1052616 | 1052616 | 2021-02-21 | Florida | Puerto Rico | 72054 | 674 | |
1049369 | 1049369 | 2021-02-20 | Florida | Puerto Rico | 72054 | 673 | |
1046122 | 1046122 | 2021-02-19 | Florida | Puerto Rico | 72054 | 670 | |
1042877 | 1042877 | 2021-02-18 | Florida | Puerto Rico | 72054 | 670 | |
1039632 | 1039632 | 2021-02-17 | Florida | Puerto Rico | 72054 | 670 | |
1036387 | 1036387 | 2021-02-16 | Florida | Puerto Rico | 72054 | 670 | |
1033142 | 1033142 | 2021-02-15 | Florida | Puerto Rico | 72054 | 670 | |
1029896 | 1029896 | 2021-02-14 | Florida | Puerto Rico | 72054 | 669 | |
1026649 | 1026649 | 2021-02-13 | Florida | Puerto Rico | 72054 | 667 | |
1023404 | 1023404 | 2021-02-12 | Florida | Puerto Rico | 72054 | 667 | |
1020159 | 1020159 | 2021-02-11 | Florida | Puerto Rico | 72054 | 667 | |
1016914 | 1016914 | 2021-02-10 | Florida | Puerto Rico | 72054 | 667 | |
1013669 | 1013669 | 2021-02-09 | Florida | Puerto Rico | 72054 | 667 | |
1010424 | 1010424 | 2021-02-08 | Florida | Puerto Rico | 72054 | 667 | |
1007178 | 1007178 | 2021-02-07 | Florida | Puerto Rico | 72054 | 667 | |
1003932 | 1003932 | 2021-02-06 | Florida | Puerto Rico | 72054 | 664 | |
1000686 | 1000686 | 2021-02-05 | Florida | Puerto Rico | 72054 | 663 | |
997440 | 997440 | 2021-02-04 | Florida | Puerto Rico | 72054 | 663 | |
994194 | 994194 | 2021-02-03 | Florida | Puerto Rico | 72054 | 662 | |
990948 | 990948 | 2021-02-02 | Florida | Puerto Rico | 72054 | 662 | |
987702 | 987702 | 2021-02-01 | Florida | Puerto Rico | 72054 | 662 | |
984455 | 984455 | 2021-01-31 | Florida | Puerto Rico | 72054 | 660 | |
981208 | 981208 | 2021-01-30 | Florida | Puerto Rico | 72054 | 660 | |
977962 | 977962 | 2021-01-29 | Florida | Puerto Rico | 72054 | 656 | |
974717 | 974717 | 2021-01-28 | Florida | Puerto Rico | 72054 | 655 | |
971472 | 971472 | 2021-01-27 | Florida | Puerto Rico | 72054 | 655 | |
968227 | 968227 | 2021-01-26 | Florida | Puerto Rico | 72054 | 655 | |
964983 | 964983 | 2021-01-25 | Florida | Puerto Rico | 72054 | 655 | |
961738 | 961738 | 2021-01-24 | Florida | Puerto Rico | 72054 | 655 | |
958493 | 958493 | 2021-01-23 | Florida | Puerto Rico | 72054 | 654 |
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);