ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72059 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 |
---|---|---|---|---|---|---|---|
922796 | 922796 | 2021-01-12 | Guayanilla | Puerto Rico | 72059 | 364 | |
919551 | 919551 | 2021-01-11 | Guayanilla | Puerto Rico | 72059 | 360 | |
916306 | 916306 | 2021-01-10 | Guayanilla | Puerto Rico | 72059 | 358 | |
913061 | 913061 | 2021-01-09 | Guayanilla | Puerto Rico | 72059 | 358 | |
909816 | 909816 | 2021-01-08 | Guayanilla | Puerto Rico | 72059 | 358 | |
906571 | 906571 | 2021-01-07 | Guayanilla | Puerto Rico | 72059 | 358 | |
903325 | 903325 | 2021-01-06 | Guayanilla | Puerto Rico | 72059 | 356 | |
900080 | 900080 | 2021-01-05 | Guayanilla | Puerto Rico | 72059 | 355 | |
896835 | 896835 | 2021-01-04 | Guayanilla | Puerto Rico | 72059 | 353 | |
893589 | 893589 | 2021-01-03 | Guayanilla | Puerto Rico | 72059 | 352 | |
890343 | 890343 | 2021-01-02 | Guayanilla | Puerto Rico | 72059 | 352 | |
887096 | 887096 | 2021-01-01 | Guayanilla | Puerto Rico | 72059 | 350 | |
883851 | 883851 | 2020-12-31 | Guayanilla | Puerto Rico | 72059 | 349 | |
880606 | 880606 | 2020-12-30 | Guayanilla | Puerto Rico | 72059 | 349 | |
877361 | 877361 | 2020-12-29 | Guayanilla | Puerto Rico | 72059 | 348 | |
874116 | 874116 | 2020-12-28 | Guayanilla | Puerto Rico | 72059 | 346 | |
870871 | 870871 | 2020-12-27 | Guayanilla | Puerto Rico | 72059 | 345 | |
867626 | 867626 | 2020-12-26 | Guayanilla | Puerto Rico | 72059 | 345 | |
864381 | 864381 | 2020-12-25 | Guayanilla | Puerto Rico | 72059 | 344 | |
861136 | 861136 | 2020-12-24 | Guayanilla | Puerto Rico | 72059 | 344 | |
857891 | 857891 | 2020-12-23 | Guayanilla | Puerto Rico | 72059 | 343 | |
854646 | 854646 | 2020-12-22 | Guayanilla | Puerto Rico | 72059 | 343 | |
851401 | 851401 | 2020-12-21 | Guayanilla | Puerto Rico | 72059 | 342 | |
848156 | 848156 | 2020-12-20 | Guayanilla | Puerto Rico | 72059 | 342 | |
844911 | 844911 | 2020-12-19 | Guayanilla | Puerto Rico | 72059 | 341 | |
841665 | 841665 | 2020-12-18 | Guayanilla | Puerto Rico | 72059 | 339 | |
838420 | 838420 | 2020-12-17 | Guayanilla | Puerto Rico | 72059 | 340 | |
835174 | 835174 | 2020-12-16 | Guayanilla | Puerto Rico | 72059 | 336 | |
831928 | 831928 | 2020-12-15 | Guayanilla | Puerto Rico | 72059 | 336 | |
828681 | 828681 | 2020-12-14 | Guayanilla | Puerto Rico | 72059 | 336 | |
825435 | 825435 | 2020-12-13 | Guayanilla | Puerto Rico | 72059 | 335 | |
822188 | 822188 | 2020-12-12 | Guayanilla | Puerto Rico | 72059 | 332 | |
818942 | 818942 | 2020-12-11 | Guayanilla | Puerto Rico | 72059 | 331 | |
815696 | 815696 | 2020-12-10 | Guayanilla | Puerto Rico | 72059 | 329 | |
812450 | 812450 | 2020-12-09 | Guayanilla | Puerto Rico | 72059 | 328 | |
809206 | 809206 | 2020-12-08 | Guayanilla | Puerto Rico | 72059 | 328 | |
805961 | 805961 | 2020-12-07 | Guayanilla | Puerto Rico | 72059 | 325 | |
802716 | 802716 | 2020-12-06 | Guayanilla | Puerto Rico | 72059 | 325 | |
799471 | 799471 | 2020-12-05 | Guayanilla | Puerto Rico | 72059 | 322 | |
796226 | 796226 | 2020-12-04 | Guayanilla | Puerto Rico | 72059 | 320 | |
792981 | 792981 | 2020-12-03 | Guayanilla | Puerto Rico | 72059 | 318 | |
789736 | 789736 | 2020-12-02 | Guayanilla | Puerto Rico | 72059 | 318 | |
786491 | 786491 | 2020-12-01 | Guayanilla | Puerto Rico | 72059 | 318 | |
783247 | 783247 | 2020-11-30 | Guayanilla | Puerto Rico | 72059 | 316 | |
780002 | 780002 | 2020-11-29 | Guayanilla | Puerto Rico | 72059 | 314 | |
776756 | 776756 | 2020-11-28 | Guayanilla | Puerto Rico | 72059 | 314 | |
773511 | 773511 | 2020-11-27 | Guayanilla | Puerto Rico | 72059 | 307 | |
770266 | 770266 | 2020-11-26 | Guayanilla | Puerto Rico | 72059 | 302 | |
767020 | 767020 | 2020-11-25 | Guayanilla | Puerto Rico | 72059 | 300 | |
763775 | 763775 | 2020-11-24 | Guayanilla | Puerto Rico | 72059 | 300 | |
760530 | 760530 | 2020-11-23 | Guayanilla | Puerto Rico | 72059 | 298 | |
757285 | 757285 | 2020-11-22 | Guayanilla | Puerto Rico | 72059 | 296 | |
754038 | 754038 | 2020-11-21 | Guayanilla | Puerto Rico | 72059 | 294 | |
750792 | 750792 | 2020-11-20 | Guayanilla | Puerto Rico | 72059 | 293 | |
747546 | 747546 | 2020-11-19 | Guayanilla | Puerto Rico | 72059 | 291 | |
744300 | 744300 | 2020-11-18 | Guayanilla | Puerto Rico | 72059 | 290 | |
741053 | 741053 | 2020-11-17 | Guayanilla | Puerto Rico | 72059 | 290 | |
737807 | 737807 | 2020-11-16 | Guayanilla | Puerto Rico | 72059 | 290 | |
734563 | 734563 | 2020-11-15 | Guayanilla | Puerto Rico | 72059 | 290 | |
731317 | 731317 | 2020-11-14 | Guayanilla | Puerto Rico | 72059 | 289 | |
728073 | 728073 | 2020-11-13 | Guayanilla | Puerto Rico | 72059 | 289 | |
724829 | 724829 | 2020-11-12 | Guayanilla | Puerto Rico | 72059 | 289 | |
721586 | 721586 | 2020-11-11 | Guayanilla | Puerto Rico | 72059 | 283 | |
718343 | 718343 | 2020-11-10 | Guayanilla | Puerto Rico | 72059 | 282 | |
715100 | 715100 | 2020-11-09 | Guayanilla | Puerto Rico | 72059 | 282 | |
711856 | 711856 | 2020-11-08 | Guayanilla | Puerto Rico | 72059 | 282 | |
708612 | 708612 | 2020-11-07 | Guayanilla | Puerto Rico | 72059 | 280 | |
705369 | 705369 | 2020-11-06 | Guayanilla | Puerto Rico | 72059 | 280 | |
702126 | 702126 | 2020-11-05 | Guayanilla | Puerto Rico | 72059 | 275 | |
698882 | 698882 | 2020-11-04 | Guayanilla | Puerto Rico | 72059 | 273 | |
695639 | 695639 | 2020-11-03 | Guayanilla | Puerto Rico | 72059 | 273 | |
692397 | 692397 | 2020-11-02 | Guayanilla | Puerto Rico | 72059 | 264 | |
689153 | 689153 | 2020-11-01 | Guayanilla | Puerto Rico | 72059 | 260 | |
685908 | 685908 | 2020-10-31 | Guayanilla | Puerto Rico | 72059 | 260 | |
682665 | 682665 | 2020-10-30 | Guayanilla | Puerto Rico | 72059 | 259 | |
679422 | 679422 | 2020-10-29 | Guayanilla | Puerto Rico | 72059 | 256 | |
676179 | 676179 | 2020-10-28 | Guayanilla | Puerto Rico | 72059 | 250 | |
672936 | 672936 | 2020-10-27 | Guayanilla | Puerto Rico | 72059 | 250 | |
669694 | 669694 | 2020-10-26 | Guayanilla | Puerto Rico | 72059 | 248 | |
666450 | 666450 | 2020-10-25 | Guayanilla | Puerto Rico | 72059 | 247 | |
663205 | 663205 | 2020-10-24 | Guayanilla | Puerto Rico | 72059 | 246 | |
659961 | 659961 | 2020-10-23 | Guayanilla | Puerto Rico | 72059 | 240 | |
656717 | 656717 | 2020-10-22 | Guayanilla | Puerto Rico | 72059 | 233 | |
653472 | 653472 | 2020-10-21 | Guayanilla | Puerto Rico | 72059 | 233 | |
650227 | 650227 | 2020-10-20 | Guayanilla | Puerto Rico | 72059 | 233 | |
646983 | 646983 | 2020-10-19 | Guayanilla | Puerto Rico | 72059 | 230 | |
643737 | 643737 | 2020-10-18 | Guayanilla | Puerto Rico | 72059 | 225 | |
640489 | 640489 | 2020-10-17 | Guayanilla | Puerto Rico | 72059 | 224 | |
637243 | 637243 | 2020-10-16 | Guayanilla | Puerto Rico | 72059 | 224 | |
633997 | 633997 | 2020-10-15 | Guayanilla | Puerto Rico | 72059 | 224 | |
630752 | 630752 | 2020-10-14 | Guayanilla | Puerto Rico | 72059 | 221 | |
627508 | 627508 | 2020-10-13 | Guayanilla | Puerto Rico | 72059 | 220 | |
624266 | 624266 | 2020-10-12 | Guayanilla | Puerto Rico | 72059 | 216 | |
621023 | 621023 | 2020-10-11 | Guayanilla | Puerto Rico | 72059 | 214 | |
617780 | 617780 | 2020-10-10 | Guayanilla | Puerto Rico | 72059 | 214 | |
614538 | 614538 | 2020-10-09 | Guayanilla | Puerto Rico | 72059 | 204 | |
611297 | 611297 | 2020-10-08 | Guayanilla | Puerto Rico | 72059 | 202 | |
608055 | 608055 | 2020-10-07 | Guayanilla | Puerto Rico | 72059 | 201 | |
604812 | 604812 | 2020-10-06 | Guayanilla | Puerto Rico | 72059 | 201 | |
601570 | 601570 | 2020-10-05 | Guayanilla | Puerto Rico | 72059 | 197 |
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);