ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72007 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 |
---|---|---|---|---|---|---|---|
922769 | 922769 | 2021-01-12 | Aguas Buenas | Puerto Rico | 72007 | 873 | |
919524 | 919524 | 2021-01-11 | Aguas Buenas | Puerto Rico | 72007 | 869 | |
916279 | 916279 | 2021-01-10 | Aguas Buenas | Puerto Rico | 72007 | 868 | |
913034 | 913034 | 2021-01-09 | Aguas Buenas | Puerto Rico | 72007 | 865 | |
909789 | 909789 | 2021-01-08 | Aguas Buenas | Puerto Rico | 72007 | 853 | |
906544 | 906544 | 2021-01-07 | Aguas Buenas | Puerto Rico | 72007 | 849 | |
903298 | 903298 | 2021-01-06 | Aguas Buenas | Puerto Rico | 72007 | 846 | |
900053 | 900053 | 2021-01-05 | Aguas Buenas | Puerto Rico | 72007 | 845 | |
896808 | 896808 | 2021-01-04 | Aguas Buenas | Puerto Rico | 72007 | 842 | |
893562 | 893562 | 2021-01-03 | Aguas Buenas | Puerto Rico | 72007 | 842 | |
890316 | 890316 | 2021-01-02 | Aguas Buenas | Puerto Rico | 72007 | 840 | |
887069 | 887069 | 2021-01-01 | Aguas Buenas | Puerto Rico | 72007 | 834 | |
883824 | 883824 | 2020-12-31 | Aguas Buenas | Puerto Rico | 72007 | 829 | |
880579 | 880579 | 2020-12-30 | Aguas Buenas | Puerto Rico | 72007 | 823 | |
877334 | 877334 | 2020-12-29 | Aguas Buenas | Puerto Rico | 72007 | 823 | |
874089 | 874089 | 2020-12-28 | Aguas Buenas | Puerto Rico | 72007 | 747 | |
870844 | 870844 | 2020-12-27 | Aguas Buenas | Puerto Rico | 72007 | 702 | |
867599 | 867599 | 2020-12-26 | Aguas Buenas | Puerto Rico | 72007 | 685 | |
864354 | 864354 | 2020-12-25 | Aguas Buenas | Puerto Rico | 72007 | 673 | |
861109 | 861109 | 2020-12-24 | Aguas Buenas | Puerto Rico | 72007 | 662 | |
857864 | 857864 | 2020-12-23 | Aguas Buenas | Puerto Rico | 72007 | 660 | |
854619 | 854619 | 2020-12-22 | Aguas Buenas | Puerto Rico | 72007 | 646 | |
851374 | 851374 | 2020-12-21 | Aguas Buenas | Puerto Rico | 72007 | 614 | |
848129 | 848129 | 2020-12-20 | Aguas Buenas | Puerto Rico | 72007 | 613 | |
844884 | 844884 | 2020-12-19 | Aguas Buenas | Puerto Rico | 72007 | 607 | |
841638 | 841638 | 2020-12-18 | Aguas Buenas | Puerto Rico | 72007 | 598 | |
838393 | 838393 | 2020-12-17 | Aguas Buenas | Puerto Rico | 72007 | 592 | |
835147 | 835147 | 2020-12-16 | Aguas Buenas | Puerto Rico | 72007 | 588 | |
831901 | 831901 | 2020-12-15 | Aguas Buenas | Puerto Rico | 72007 | 587 | |
828654 | 828654 | 2020-12-14 | Aguas Buenas | Puerto Rico | 72007 | 586 | |
825408 | 825408 | 2020-12-13 | Aguas Buenas | Puerto Rico | 72007 | 582 | |
822161 | 822161 | 2020-12-12 | Aguas Buenas | Puerto Rico | 72007 | 578 | |
818915 | 818915 | 2020-12-11 | Aguas Buenas | Puerto Rico | 72007 | 573 | |
815669 | 815669 | 2020-12-10 | Aguas Buenas | Puerto Rico | 72007 | 565 | |
812423 | 812423 | 2020-12-09 | Aguas Buenas | Puerto Rico | 72007 | 559 | |
809179 | 809179 | 2020-12-08 | Aguas Buenas | Puerto Rico | 72007 | 556 | |
805934 | 805934 | 2020-12-07 | Aguas Buenas | Puerto Rico | 72007 | 550 | |
802689 | 802689 | 2020-12-06 | Aguas Buenas | Puerto Rico | 72007 | 540 | |
799444 | 799444 | 2020-12-05 | Aguas Buenas | Puerto Rico | 72007 | 532 | |
796199 | 796199 | 2020-12-04 | Aguas Buenas | Puerto Rico | 72007 | 525 | |
792954 | 792954 | 2020-12-03 | Aguas Buenas | Puerto Rico | 72007 | 522 | |
789709 | 789709 | 2020-12-02 | Aguas Buenas | Puerto Rico | 72007 | 520 | |
786464 | 786464 | 2020-12-01 | Aguas Buenas | Puerto Rico | 72007 | 518 | |
783220 | 783220 | 2020-11-30 | Aguas Buenas | Puerto Rico | 72007 | 516 | |
779975 | 779975 | 2020-11-29 | Aguas Buenas | Puerto Rico | 72007 | 509 | |
776729 | 776729 | 2020-11-28 | Aguas Buenas | Puerto Rico | 72007 | 508 | |
773484 | 773484 | 2020-11-27 | Aguas Buenas | Puerto Rico | 72007 | 504 | |
770239 | 770239 | 2020-11-26 | Aguas Buenas | Puerto Rico | 72007 | 494 | |
766993 | 766993 | 2020-11-25 | Aguas Buenas | Puerto Rico | 72007 | 491 | |
763748 | 763748 | 2020-11-24 | Aguas Buenas | Puerto Rico | 72007 | 491 | |
760503 | 760503 | 2020-11-23 | Aguas Buenas | Puerto Rico | 72007 | 490 | |
757258 | 757258 | 2020-11-22 | Aguas Buenas | Puerto Rico | 72007 | 489 | |
754011 | 754011 | 2020-11-21 | Aguas Buenas | Puerto Rico | 72007 | 482 | |
750765 | 750765 | 2020-11-20 | Aguas Buenas | Puerto Rico | 72007 | 475 | |
747519 | 747519 | 2020-11-19 | Aguas Buenas | Puerto Rico | 72007 | 471 | |
744273 | 744273 | 2020-11-18 | Aguas Buenas | Puerto Rico | 72007 | 460 | |
741026 | 741026 | 2020-11-17 | Aguas Buenas | Puerto Rico | 72007 | 459 | |
737780 | 737780 | 2020-11-16 | Aguas Buenas | Puerto Rico | 72007 | 451 | |
734536 | 734536 | 2020-11-15 | Aguas Buenas | Puerto Rico | 72007 | 450 | |
731290 | 731290 | 2020-11-14 | Aguas Buenas | Puerto Rico | 72007 | 447 | |
728046 | 728046 | 2020-11-13 | Aguas Buenas | Puerto Rico | 72007 | 446 | |
724802 | 724802 | 2020-11-12 | Aguas Buenas | Puerto Rico | 72007 | 445 | |
721559 | 721559 | 2020-11-11 | Aguas Buenas | Puerto Rico | 72007 | 434 | |
718316 | 718316 | 2020-11-10 | Aguas Buenas | Puerto Rico | 72007 | 430 | |
715073 | 715073 | 2020-11-09 | Aguas Buenas | Puerto Rico | 72007 | 428 | |
711829 | 711829 | 2020-11-08 | Aguas Buenas | Puerto Rico | 72007 | 428 | |
708585 | 708585 | 2020-11-07 | Aguas Buenas | Puerto Rico | 72007 | 425 | |
705342 | 705342 | 2020-11-06 | Aguas Buenas | Puerto Rico | 72007 | 425 | |
702099 | 702099 | 2020-11-05 | Aguas Buenas | Puerto Rico | 72007 | 419 | |
698855 | 698855 | 2020-11-04 | Aguas Buenas | Puerto Rico | 72007 | 419 | |
695612 | 695612 | 2020-11-03 | Aguas Buenas | Puerto Rico | 72007 | 418 | |
692370 | 692370 | 2020-11-02 | Aguas Buenas | Puerto Rico | 72007 | 397 | |
689126 | 689126 | 2020-11-01 | Aguas Buenas | Puerto Rico | 72007 | 386 | |
685881 | 685881 | 2020-10-31 | Aguas Buenas | Puerto Rico | 72007 | 385 | |
682638 | 682638 | 2020-10-30 | Aguas Buenas | Puerto Rico | 72007 | 385 | |
679395 | 679395 | 2020-10-29 | Aguas Buenas | Puerto Rico | 72007 | 379 | |
676152 | 676152 | 2020-10-28 | Aguas Buenas | Puerto Rico | 72007 | 371 | |
672909 | 672909 | 2020-10-27 | Aguas Buenas | Puerto Rico | 72007 | 370 | |
669667 | 669667 | 2020-10-26 | Aguas Buenas | Puerto Rico | 72007 | 367 | |
666423 | 666423 | 2020-10-25 | Aguas Buenas | Puerto Rico | 72007 | 366 | |
663178 | 663178 | 2020-10-24 | Aguas Buenas | Puerto Rico | 72007 | 362 | |
659934 | 659934 | 2020-10-23 | Aguas Buenas | Puerto Rico | 72007 | 359 | |
656690 | 656690 | 2020-10-22 | Aguas Buenas | Puerto Rico | 72007 | 350 | |
653445 | 653445 | 2020-10-21 | Aguas Buenas | Puerto Rico | 72007 | 349 | |
650200 | 650200 | 2020-10-20 | Aguas Buenas | Puerto Rico | 72007 | 345 | |
646956 | 646956 | 2020-10-19 | Aguas Buenas | Puerto Rico | 72007 | 342 | |
643710 | 643710 | 2020-10-18 | Aguas Buenas | Puerto Rico | 72007 | 339 | |
640462 | 640462 | 2020-10-17 | Aguas Buenas | Puerto Rico | 72007 | 336 | |
637216 | 637216 | 2020-10-16 | Aguas Buenas | Puerto Rico | 72007 | 334 | |
633970 | 633970 | 2020-10-15 | Aguas Buenas | Puerto Rico | 72007 | 333 | |
630725 | 630725 | 2020-10-14 | Aguas Buenas | Puerto Rico | 72007 | 327 | |
627481 | 627481 | 2020-10-13 | Aguas Buenas | Puerto Rico | 72007 | 324 | |
624239 | 624239 | 2020-10-12 | Aguas Buenas | Puerto Rico | 72007 | 323 | |
620996 | 620996 | 2020-10-11 | Aguas Buenas | Puerto Rico | 72007 | 318 | |
617753 | 617753 | 2020-10-10 | Aguas Buenas | Puerto Rico | 72007 | 315 | |
614511 | 614511 | 2020-10-09 | Aguas Buenas | Puerto Rico | 72007 | 311 | |
611270 | 611270 | 2020-10-08 | Aguas Buenas | Puerto Rico | 72007 | 307 | |
608028 | 608028 | 2020-10-07 | Aguas Buenas | Puerto Rico | 72007 | 306 | |
604785 | 604785 | 2020-10-06 | Aguas Buenas | Puerto Rico | 72007 | 306 | |
601543 | 601543 | 2020-10-05 | Aguas Buenas | Puerto Rico | 72007 | 303 |
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);