ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72003 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 |
---|---|---|---|---|---|---|---|
922767 | 922767 | 2021-01-12 | Aguada | Puerto Rico | 72003 | 1004 | |
919522 | 919522 | 2021-01-11 | Aguada | Puerto Rico | 72003 | 992 | |
916277 | 916277 | 2021-01-10 | Aguada | Puerto Rico | 72003 | 990 | |
913032 | 913032 | 2021-01-09 | Aguada | Puerto Rico | 72003 | 990 | |
909787 | 909787 | 2021-01-08 | Aguada | Puerto Rico | 72003 | 988 | |
906542 | 906542 | 2021-01-07 | Aguada | Puerto Rico | 72003 | 963 | |
903296 | 903296 | 2021-01-06 | Aguada | Puerto Rico | 72003 | 959 | |
900051 | 900051 | 2021-01-05 | Aguada | Puerto Rico | 72003 | 958 | |
896806 | 896806 | 2021-01-04 | Aguada | Puerto Rico | 72003 | 938 | |
893560 | 893560 | 2021-01-03 | Aguada | Puerto Rico | 72003 | 917 | |
890314 | 890314 | 2021-01-02 | Aguada | Puerto Rico | 72003 | 917 | |
887067 | 887067 | 2021-01-01 | Aguada | Puerto Rico | 72003 | 906 | |
883822 | 883822 | 2020-12-31 | Aguada | Puerto Rico | 72003 | 889 | |
880577 | 880577 | 2020-12-30 | Aguada | Puerto Rico | 72003 | 886 | |
877332 | 877332 | 2020-12-29 | Aguada | Puerto Rico | 72003 | 886 | |
874087 | 874087 | 2020-12-28 | Aguada | Puerto Rico | 72003 | 842 | |
870842 | 870842 | 2020-12-27 | Aguada | Puerto Rico | 72003 | 842 | |
867597 | 867597 | 2020-12-26 | Aguada | Puerto Rico | 72003 | 838 | |
864352 | 864352 | 2020-12-25 | Aguada | Puerto Rico | 72003 | 836 | |
861107 | 861107 | 2020-12-24 | Aguada | Puerto Rico | 72003 | 834 | |
857862 | 857862 | 2020-12-23 | Aguada | Puerto Rico | 72003 | 833 | |
854617 | 854617 | 2020-12-22 | Aguada | Puerto Rico | 72003 | 824 | |
851372 | 851372 | 2020-12-21 | Aguada | Puerto Rico | 72003 | 816 | |
848127 | 848127 | 2020-12-20 | Aguada | Puerto Rico | 72003 | 813 | |
844882 | 844882 | 2020-12-19 | Aguada | Puerto Rico | 72003 | 791 | |
841636 | 841636 | 2020-12-18 | Aguada | Puerto Rico | 72003 | 781 | |
838391 | 838391 | 2020-12-17 | Aguada | Puerto Rico | 72003 | 773 | |
835145 | 835145 | 2020-12-16 | Aguada | Puerto Rico | 72003 | 767 | |
831899 | 831899 | 2020-12-15 | Aguada | Puerto Rico | 72003 | 767 | |
828652 | 828652 | 2020-12-14 | Aguada | Puerto Rico | 72003 | 767 | |
825406 | 825406 | 2020-12-13 | Aguada | Puerto Rico | 72003 | 764 | |
822159 | 822159 | 2020-12-12 | Aguada | Puerto Rico | 72003 | 760 | |
818913 | 818913 | 2020-12-11 | Aguada | Puerto Rico | 72003 | 756 | |
815667 | 815667 | 2020-12-10 | Aguada | Puerto Rico | 72003 | 736 | |
812421 | 812421 | 2020-12-09 | Aguada | Puerto Rico | 72003 | 731 | |
809177 | 809177 | 2020-12-08 | Aguada | Puerto Rico | 72003 | 729 | |
805932 | 805932 | 2020-12-07 | Aguada | Puerto Rico | 72003 | 721 | |
802687 | 802687 | 2020-12-06 | Aguada | Puerto Rico | 72003 | 714 | |
799442 | 799442 | 2020-12-05 | Aguada | Puerto Rico | 72003 | 695 | |
796197 | 796197 | 2020-12-04 | Aguada | Puerto Rico | 72003 | 689 | |
792952 | 792952 | 2020-12-03 | Aguada | Puerto Rico | 72003 | 687 | |
789707 | 789707 | 2020-12-02 | Aguada | Puerto Rico | 72003 | 687 | |
786462 | 786462 | 2020-12-01 | Aguada | Puerto Rico | 72003 | 673 | |
783218 | 783218 | 2020-11-30 | Aguada | Puerto Rico | 72003 | 656 | |
779973 | 779973 | 2020-11-29 | Aguada | Puerto Rico | 72003 | 653 | |
776727 | 776727 | 2020-11-28 | Aguada | Puerto Rico | 72003 | 655 | |
773482 | 773482 | 2020-11-27 | Aguada | Puerto Rico | 72003 | 645 | |
770237 | 770237 | 2020-11-26 | Aguada | Puerto Rico | 72003 | 629 | |
766991 | 766991 | 2020-11-25 | Aguada | Puerto Rico | 72003 | 620 | |
763746 | 763746 | 2020-11-24 | Aguada | Puerto Rico | 72003 | 619 | |
760501 | 760501 | 2020-11-23 | Aguada | Puerto Rico | 72003 | 619 | |
757256 | 757256 | 2020-11-22 | Aguada | Puerto Rico | 72003 | 616 | |
754009 | 754009 | 2020-11-21 | Aguada | Puerto Rico | 72003 | 590 | |
750763 | 750763 | 2020-11-20 | Aguada | Puerto Rico | 72003 | 579 | |
747517 | 747517 | 2020-11-19 | Aguada | Puerto Rico | 72003 | 569 | |
744271 | 744271 | 2020-11-18 | Aguada | Puerto Rico | 72003 | 548 | |
741024 | 741024 | 2020-11-17 | Aguada | Puerto Rico | 72003 | 542 | |
737778 | 737778 | 2020-11-16 | Aguada | Puerto Rico | 72003 | 538 | |
734534 | 734534 | 2020-11-15 | Aguada | Puerto Rico | 72003 | 533 | |
731288 | 731288 | 2020-11-14 | Aguada | Puerto Rico | 72003 | 529 | |
728044 | 728044 | 2020-11-13 | Aguada | Puerto Rico | 72003 | 516 | |
724800 | 724800 | 2020-11-12 | Aguada | Puerto Rico | 72003 | 513 | |
721557 | 721557 | 2020-11-11 | Aguada | Puerto Rico | 72003 | 510 | |
718314 | 718314 | 2020-11-10 | Aguada | Puerto Rico | 72003 | 509 | |
715071 | 715071 | 2020-11-09 | Aguada | Puerto Rico | 72003 | 508 | |
711827 | 711827 | 2020-11-08 | Aguada | Puerto Rico | 72003 | 500 | |
708583 | 708583 | 2020-11-07 | Aguada | Puerto Rico | 72003 | 484 | |
705340 | 705340 | 2020-11-06 | Aguada | Puerto Rico | 72003 | 484 | |
702097 | 702097 | 2020-11-05 | Aguada | Puerto Rico | 72003 | 475 | |
698853 | 698853 | 2020-11-04 | Aguada | Puerto Rico | 72003 | 473 | |
695610 | 695610 | 2020-11-03 | Aguada | Puerto Rico | 72003 | 472 | |
692368 | 692368 | 2020-11-02 | Aguada | Puerto Rico | 72003 | 469 | |
689124 | 689124 | 2020-11-01 | Aguada | Puerto Rico | 72003 | 462 | |
685879 | 685879 | 2020-10-31 | Aguada | Puerto Rico | 72003 | 458 | |
682636 | 682636 | 2020-10-30 | Aguada | Puerto Rico | 72003 | 451 | |
679393 | 679393 | 2020-10-29 | Aguada | Puerto Rico | 72003 | 443 | |
676150 | 676150 | 2020-10-28 | Aguada | Puerto Rico | 72003 | 438 | |
672907 | 672907 | 2020-10-27 | Aguada | Puerto Rico | 72003 | 438 | |
669665 | 669665 | 2020-10-26 | Aguada | Puerto Rico | 72003 | 430 | |
666421 | 666421 | 2020-10-25 | Aguada | Puerto Rico | 72003 | 426 | |
663176 | 663176 | 2020-10-24 | Aguada | Puerto Rico | 72003 | 416 | |
659932 | 659932 | 2020-10-23 | Aguada | Puerto Rico | 72003 | 415 | |
656688 | 656688 | 2020-10-22 | Aguada | Puerto Rico | 72003 | 404 | |
653443 | 653443 | 2020-10-21 | Aguada | Puerto Rico | 72003 | 400 | |
650198 | 650198 | 2020-10-20 | Aguada | Puerto Rico | 72003 | 400 | |
646954 | 646954 | 2020-10-19 | Aguada | Puerto Rico | 72003 | 397 | |
643708 | 643708 | 2020-10-18 | Aguada | Puerto Rico | 72003 | 395 | |
640460 | 640460 | 2020-10-17 | Aguada | Puerto Rico | 72003 | 393 | |
637214 | 637214 | 2020-10-16 | Aguada | Puerto Rico | 72003 | 391 | |
633968 | 633968 | 2020-10-15 | Aguada | Puerto Rico | 72003 | 390 | |
630723 | 630723 | 2020-10-14 | Aguada | Puerto Rico | 72003 | 387 | |
627479 | 627479 | 2020-10-13 | Aguada | Puerto Rico | 72003 | 381 | |
624237 | 624237 | 2020-10-12 | Aguada | Puerto Rico | 72003 | 380 | |
620994 | 620994 | 2020-10-11 | Aguada | Puerto Rico | 72003 | 379 | |
617751 | 617751 | 2020-10-10 | Aguada | Puerto Rico | 72003 | 378 | |
614509 | 614509 | 2020-10-09 | Aguada | Puerto Rico | 72003 | 374 | |
611268 | 611268 | 2020-10-08 | Aguada | Puerto Rico | 72003 | 372 | |
608026 | 608026 | 2020-10-07 | Aguada | Puerto Rico | 72003 | 371 | |
604783 | 604783 | 2020-10-06 | Aguada | Puerto Rico | 72003 | 371 | |
601541 | 601541 | 2020-10-05 | Aguada | Puerto Rico | 72003 | 368 |
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);