ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72055 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 |
---|---|---|---|---|---|---|---|
1055863 | 1055863 | 2021-02-22 | Guanica | Puerto Rico | 72055 | 248 | |
1052617 | 1052617 | 2021-02-21 | Guanica | Puerto Rico | 72055 | 248 | |
1049370 | 1049370 | 2021-02-20 | Guanica | Puerto Rico | 72055 | 248 | |
1046123 | 1046123 | 2021-02-19 | Guanica | Puerto Rico | 72055 | 247 | |
1042878 | 1042878 | 2021-02-18 | Guanica | Puerto Rico | 72055 | 247 | |
1039633 | 1039633 | 2021-02-17 | Guanica | Puerto Rico | 72055 | 247 | |
1036388 | 1036388 | 2021-02-16 | Guanica | Puerto Rico | 72055 | 247 | |
1033143 | 1033143 | 2021-02-15 | Guanica | Puerto Rico | 72055 | 245 | |
1029897 | 1029897 | 2021-02-14 | Guanica | Puerto Rico | 72055 | 245 | |
1026650 | 1026650 | 2021-02-13 | Guanica | Puerto Rico | 72055 | 243 | |
1023405 | 1023405 | 2021-02-12 | Guanica | Puerto Rico | 72055 | 243 | |
1020160 | 1020160 | 2021-02-11 | Guanica | Puerto Rico | 72055 | 243 | |
1016915 | 1016915 | 2021-02-10 | Guanica | Puerto Rico | 72055 | 243 | |
1013670 | 1013670 | 2021-02-09 | Guanica | Puerto Rico | 72055 | 243 | |
1010425 | 1010425 | 2021-02-08 | Guanica | Puerto Rico | 72055 | 243 | |
1007179 | 1007179 | 2021-02-07 | Guanica | Puerto Rico | 72055 | 243 | |
1003933 | 1003933 | 2021-02-06 | Guanica | Puerto Rico | 72055 | 242 | |
1000687 | 1000687 | 2021-02-05 | Guanica | Puerto Rico | 72055 | 242 | |
997441 | 997441 | 2021-02-04 | Guanica | Puerto Rico | 72055 | 240 | |
994195 | 994195 | 2021-02-03 | Guanica | Puerto Rico | 72055 | 239 | |
990949 | 990949 | 2021-02-02 | Guanica | Puerto Rico | 72055 | 239 | |
987703 | 987703 | 2021-02-01 | Guanica | Puerto Rico | 72055 | 238 | |
984456 | 984456 | 2021-01-31 | Guanica | Puerto Rico | 72055 | 238 | |
981209 | 981209 | 2021-01-30 | Guanica | Puerto Rico | 72055 | 238 | |
977963 | 977963 | 2021-01-29 | Guanica | Puerto Rico | 72055 | 238 | |
974718 | 974718 | 2021-01-28 | Guanica | Puerto Rico | 72055 | 238 | |
971473 | 971473 | 2021-01-27 | Guanica | Puerto Rico | 72055 | 237 | |
968228 | 968228 | 2021-01-26 | Guanica | Puerto Rico | 72055 | 237 | |
964984 | 964984 | 2021-01-25 | Guanica | Puerto Rico | 72055 | 236 | |
961739 | 961739 | 2021-01-24 | Guanica | Puerto Rico | 72055 | 236 | |
958494 | 958494 | 2021-01-23 | Guanica | Puerto Rico | 72055 | 236 | |
955248 | 955248 | 2021-01-22 | Guanica | Puerto Rico | 72055 | 236 | |
952003 | 952003 | 2021-01-21 | Guanica | Puerto Rico | 72055 | 236 | |
948758 | 948758 | 2021-01-20 | Guanica | Puerto Rico | 72055 | 235 | |
945512 | 945512 | 2021-01-19 | Guanica | Puerto Rico | 72055 | 235 | |
942265 | 942265 | 2021-01-18 | Guanica | Puerto Rico | 72055 | 235 | |
939020 | 939020 | 2021-01-17 | Guanica | Puerto Rico | 72055 | 235 | |
935775 | 935775 | 2021-01-16 | Guanica | Puerto Rico | 72055 | 236 | |
932530 | 932530 | 2021-01-15 | Guanica | Puerto Rico | 72055 | 234 | |
929285 | 929285 | 2021-01-14 | Guanica | Puerto Rico | 72055 | 232 | |
926040 | 926040 | 2021-01-13 | Guanica | Puerto Rico | 72055 | 231 | |
922794 | 922794 | 2021-01-12 | Guanica | Puerto Rico | 72055 | 231 | |
919549 | 919549 | 2021-01-11 | Guanica | Puerto Rico | 72055 | 231 | |
916304 | 916304 | 2021-01-10 | Guanica | Puerto Rico | 72055 | 231 | |
913059 | 913059 | 2021-01-09 | Guanica | Puerto Rico | 72055 | 230 | |
909814 | 909814 | 2021-01-08 | Guanica | Puerto Rico | 72055 | 230 | |
906569 | 906569 | 2021-01-07 | Guanica | Puerto Rico | 72055 | 228 | |
903323 | 903323 | 2021-01-06 | Guanica | Puerto Rico | 72055 | 227 | |
900078 | 900078 | 2021-01-05 | Guanica | Puerto Rico | 72055 | 227 | |
896833 | 896833 | 2021-01-04 | Guanica | Puerto Rico | 72055 | 227 | |
893587 | 893587 | 2021-01-03 | Guanica | Puerto Rico | 72055 | 227 | |
890341 | 890341 | 2021-01-02 | Guanica | Puerto Rico | 72055 | 227 | |
887094 | 887094 | 2021-01-01 | Guanica | Puerto Rico | 72055 | 226 | |
883849 | 883849 | 2020-12-31 | Guanica | Puerto Rico | 72055 | 223 | |
880604 | 880604 | 2020-12-30 | Guanica | Puerto Rico | 72055 | 223 | |
877359 | 877359 | 2020-12-29 | Guanica | Puerto Rico | 72055 | 223 | |
874114 | 874114 | 2020-12-28 | Guanica | Puerto Rico | 72055 | 219 | |
870869 | 870869 | 2020-12-27 | Guanica | Puerto Rico | 72055 | 219 | |
867624 | 867624 | 2020-12-26 | Guanica | Puerto Rico | 72055 | 219 | |
864379 | 864379 | 2020-12-25 | Guanica | Puerto Rico | 72055 | 219 | |
861134 | 861134 | 2020-12-24 | Guanica | Puerto Rico | 72055 | 219 | |
857889 | 857889 | 2020-12-23 | Guanica | Puerto Rico | 72055 | 219 | |
854644 | 854644 | 2020-12-22 | Guanica | Puerto Rico | 72055 | 217 | |
851399 | 851399 | 2020-12-21 | Guanica | Puerto Rico | 72055 | 217 | |
848154 | 848154 | 2020-12-20 | Guanica | Puerto Rico | 72055 | 217 | |
844909 | 844909 | 2020-12-19 | Guanica | Puerto Rico | 72055 | 217 | |
841663 | 841663 | 2020-12-18 | Guanica | Puerto Rico | 72055 | 215 | |
838418 | 838418 | 2020-12-17 | Guanica | Puerto Rico | 72055 | 215 | |
835172 | 835172 | 2020-12-16 | Guanica | Puerto Rico | 72055 | 215 | |
831926 | 831926 | 2020-12-15 | Guanica | Puerto Rico | 72055 | 215 | |
828679 | 828679 | 2020-12-14 | Guanica | Puerto Rico | 72055 | 215 | |
825433 | 825433 | 2020-12-13 | Guanica | Puerto Rico | 72055 | 214 | |
822186 | 822186 | 2020-12-12 | Guanica | Puerto Rico | 72055 | 214 | |
818940 | 818940 | 2020-12-11 | Guanica | Puerto Rico | 72055 | 214 | |
815694 | 815694 | 2020-12-10 | Guanica | Puerto Rico | 72055 | 214 | |
812448 | 812448 | 2020-12-09 | Guanica | Puerto Rico | 72055 | 213 | |
809204 | 809204 | 2020-12-08 | Guanica | Puerto Rico | 72055 | 212 | |
805959 | 805959 | 2020-12-07 | Guanica | Puerto Rico | 72055 | 212 | |
802714 | 802714 | 2020-12-06 | Guanica | Puerto Rico | 72055 | 210 | |
799469 | 799469 | 2020-12-05 | Guanica | Puerto Rico | 72055 | 209 | |
796224 | 796224 | 2020-12-04 | Guanica | Puerto Rico | 72055 | 208 | |
792979 | 792979 | 2020-12-03 | Guanica | Puerto Rico | 72055 | 208 | |
789734 | 789734 | 2020-12-02 | Guanica | Puerto Rico | 72055 | 207 | |
786489 | 786489 | 2020-12-01 | Guanica | Puerto Rico | 72055 | 207 | |
783245 | 783245 | 2020-11-30 | Guanica | Puerto Rico | 72055 | 198 | |
780000 | 780000 | 2020-11-29 | Guanica | Puerto Rico | 72055 | 197 | |
776754 | 776754 | 2020-11-28 | Guanica | Puerto Rico | 72055 | 197 | |
773509 | 773509 | 2020-11-27 | Guanica | Puerto Rico | 72055 | 197 | |
770264 | 770264 | 2020-11-26 | Guanica | Puerto Rico | 72055 | 197 | |
767018 | 767018 | 2020-11-25 | Guanica | Puerto Rico | 72055 | 197 | |
763773 | 763773 | 2020-11-24 | Guanica | Puerto Rico | 72055 | 197 | |
760528 | 760528 | 2020-11-23 | Guanica | Puerto Rico | 72055 | 193 | |
757283 | 757283 | 2020-11-22 | Guanica | Puerto Rico | 72055 | 193 | |
754036 | 754036 | 2020-11-21 | Guanica | Puerto Rico | 72055 | 193 | |
750790 | 750790 | 2020-11-20 | Guanica | Puerto Rico | 72055 | 191 | |
747544 | 747544 | 2020-11-19 | Guanica | Puerto Rico | 72055 | 188 | |
744298 | 744298 | 2020-11-18 | Guanica | Puerto Rico | 72055 | 186 | |
741051 | 741051 | 2020-11-17 | Guanica | Puerto Rico | 72055 | 186 | |
737805 | 737805 | 2020-11-16 | Guanica | Puerto Rico | 72055 | 186 | |
734561 | 734561 | 2020-11-15 | Guanica | Puerto Rico | 72055 | 184 |
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);