ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Aguadilla" 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 |
---|---|---|---|---|---|---|---|
922768 | 922768 | 2021-01-12 | Aguadilla | Puerto Rico | 72005 | 1306 | |
919523 | 919523 | 2021-01-11 | Aguadilla | Puerto Rico | 72005 | 1297 | |
916278 | 916278 | 2021-01-10 | Aguadilla | Puerto Rico | 72005 | 1292 | |
913033 | 913033 | 2021-01-09 | Aguadilla | Puerto Rico | 72005 | 1292 | |
909788 | 909788 | 2021-01-08 | Aguadilla | Puerto Rico | 72005 | 1283 | |
906543 | 906543 | 2021-01-07 | Aguadilla | Puerto Rico | 72005 | 1258 | |
903297 | 903297 | 2021-01-06 | Aguadilla | Puerto Rico | 72005 | 1257 | |
900052 | 900052 | 2021-01-05 | Aguadilla | Puerto Rico | 72005 | 1261 | |
896807 | 896807 | 2021-01-04 | Aguadilla | Puerto Rico | 72005 | 1258 | |
893561 | 893561 | 2021-01-03 | Aguadilla | Puerto Rico | 72005 | 1247 | |
890315 | 890315 | 2021-01-02 | Aguadilla | Puerto Rico | 72005 | 1243 | |
887068 | 887068 | 2021-01-01 | Aguadilla | Puerto Rico | 72005 | 1231 | |
883823 | 883823 | 2020-12-31 | Aguadilla | Puerto Rico | 72005 | 1226 | |
880578 | 880578 | 2020-12-30 | Aguadilla | Puerto Rico | 72005 | 1225 | |
877333 | 877333 | 2020-12-29 | Aguadilla | Puerto Rico | 72005 | 1222 | |
874088 | 874088 | 2020-12-28 | Aguadilla | Puerto Rico | 72005 | 1163 | |
870843 | 870843 | 2020-12-27 | Aguadilla | Puerto Rico | 72005 | 1162 | |
867598 | 867598 | 2020-12-26 | Aguadilla | Puerto Rico | 72005 | 1160 | |
864353 | 864353 | 2020-12-25 | Aguadilla | Puerto Rico | 72005 | 1133 | |
861108 | 861108 | 2020-12-24 | Aguadilla | Puerto Rico | 72005 | 1124 | |
857863 | 857863 | 2020-12-23 | Aguadilla | Puerto Rico | 72005 | 1123 | |
854618 | 854618 | 2020-12-22 | Aguadilla | Puerto Rico | 72005 | 1107 | |
851373 | 851373 | 2020-12-21 | Aguadilla | Puerto Rico | 72005 | 1092 | |
848128 | 848128 | 2020-12-20 | Aguadilla | Puerto Rico | 72005 | 1080 | |
844883 | 844883 | 2020-12-19 | Aguadilla | Puerto Rico | 72005 | 1065 | |
841637 | 841637 | 2020-12-18 | Aguadilla | Puerto Rico | 72005 | 1046 | |
838392 | 838392 | 2020-12-17 | Aguadilla | Puerto Rico | 72005 | 1024 | |
835146 | 835146 | 2020-12-16 | Aguadilla | Puerto Rico | 72005 | 1012 | |
831900 | 831900 | 2020-12-15 | Aguadilla | Puerto Rico | 72005 | 1011 | |
828653 | 828653 | 2020-12-14 | Aguadilla | Puerto Rico | 72005 | 1004 | |
825407 | 825407 | 2020-12-13 | Aguadilla | Puerto Rico | 72005 | 995 | |
822160 | 822160 | 2020-12-12 | Aguadilla | Puerto Rico | 72005 | 987 | |
818914 | 818914 | 2020-12-11 | Aguadilla | Puerto Rico | 72005 | 981 | |
815668 | 815668 | 2020-12-10 | Aguadilla | Puerto Rico | 72005 | 975 | |
812422 | 812422 | 2020-12-09 | Aguadilla | Puerto Rico | 72005 | 947 | |
809178 | 809178 | 2020-12-08 | Aguadilla | Puerto Rico | 72005 | 938 | |
805933 | 805933 | 2020-12-07 | Aguadilla | Puerto Rico | 72005 | 926 | |
802688 | 802688 | 2020-12-06 | Aguadilla | Puerto Rico | 72005 | 909 | |
799443 | 799443 | 2020-12-05 | Aguadilla | Puerto Rico | 72005 | 902 | |
796198 | 796198 | 2020-12-04 | Aguadilla | Puerto Rico | 72005 | 887 | |
792953 | 792953 | 2020-12-03 | Aguadilla | Puerto Rico | 72005 | 882 | |
789708 | 789708 | 2020-12-02 | Aguadilla | Puerto Rico | 72005 | 877 | |
786463 | 786463 | 2020-12-01 | Aguadilla | Puerto Rico | 72005 | 870 | |
783219 | 783219 | 2020-11-30 | Aguadilla | Puerto Rico | 72005 | 852 | |
779974 | 779974 | 2020-11-29 | Aguadilla | Puerto Rico | 72005 | 845 | |
776728 | 776728 | 2020-11-28 | Aguadilla | Puerto Rico | 72005 | 842 | |
773483 | 773483 | 2020-11-27 | Aguadilla | Puerto Rico | 72005 | 837 | |
770238 | 770238 | 2020-11-26 | Aguadilla | Puerto Rico | 72005 | 821 | |
766992 | 766992 | 2020-11-25 | Aguadilla | Puerto Rico | 72005 | 818 | |
763747 | 763747 | 2020-11-24 | Aguadilla | Puerto Rico | 72005 | 818 | |
760502 | 760502 | 2020-11-23 | Aguadilla | Puerto Rico | 72005 | 813 | |
757257 | 757257 | 2020-11-22 | Aguadilla | Puerto Rico | 72005 | 808 | |
754010 | 754010 | 2020-11-21 | Aguadilla | Puerto Rico | 72005 | 794 | |
750764 | 750764 | 2020-11-20 | Aguadilla | Puerto Rico | 72005 | 788 | |
747518 | 747518 | 2020-11-19 | Aguadilla | Puerto Rico | 72005 | 781 | |
744272 | 744272 | 2020-11-18 | Aguadilla | Puerto Rico | 72005 | 779 | |
741025 | 741025 | 2020-11-17 | Aguadilla | Puerto Rico | 72005 | 769 | |
737779 | 737779 | 2020-11-16 | Aguadilla | Puerto Rico | 72005 | 764 | |
734535 | 734535 | 2020-11-15 | Aguadilla | Puerto Rico | 72005 | 758 | |
731289 | 731289 | 2020-11-14 | Aguadilla | Puerto Rico | 72005 | 751 | |
728045 | 728045 | 2020-11-13 | Aguadilla | Puerto Rico | 72005 | 738 | |
724801 | 724801 | 2020-11-12 | Aguadilla | Puerto Rico | 72005 | 728 | |
721558 | 721558 | 2020-11-11 | Aguadilla | Puerto Rico | 72005 | 716 | |
718315 | 718315 | 2020-11-10 | Aguadilla | Puerto Rico | 72005 | 713 | |
715072 | 715072 | 2020-11-09 | Aguadilla | Puerto Rico | 72005 | 706 | |
711828 | 711828 | 2020-11-08 | Aguadilla | Puerto Rico | 72005 | 702 | |
708584 | 708584 | 2020-11-07 | Aguadilla | Puerto Rico | 72005 | 690 | |
705341 | 705341 | 2020-11-06 | Aguadilla | Puerto Rico | 72005 | 690 | |
702098 | 702098 | 2020-11-05 | Aguadilla | Puerto Rico | 72005 | 680 | |
698854 | 698854 | 2020-11-04 | Aguadilla | Puerto Rico | 72005 | 668 | |
695611 | 695611 | 2020-11-03 | Aguadilla | Puerto Rico | 72005 | 667 | |
692369 | 692369 | 2020-11-02 | Aguadilla | Puerto Rico | 72005 | 656 | |
689125 | 689125 | 2020-11-01 | Aguadilla | Puerto Rico | 72005 | 634 | |
685880 | 685880 | 2020-10-31 | Aguadilla | Puerto Rico | 72005 | 620 | |
682637 | 682637 | 2020-10-30 | Aguadilla | Puerto Rico | 72005 | 608 | |
679394 | 679394 | 2020-10-29 | Aguadilla | Puerto Rico | 72005 | 590 | |
676151 | 676151 | 2020-10-28 | Aguadilla | Puerto Rico | 72005 | 581 | |
672908 | 672908 | 2020-10-27 | Aguadilla | Puerto Rico | 72005 | 581 | |
669666 | 669666 | 2020-10-26 | Aguadilla | Puerto Rico | 72005 | 571 | |
666422 | 666422 | 2020-10-25 | Aguadilla | Puerto Rico | 72005 | 558 | |
663177 | 663177 | 2020-10-24 | Aguadilla | Puerto Rico | 72005 | 546 | |
659933 | 659933 | 2020-10-23 | Aguadilla | Puerto Rico | 72005 | 540 | |
656689 | 656689 | 2020-10-22 | Aguadilla | Puerto Rico | 72005 | 532 | |
653444 | 653444 | 2020-10-21 | Aguadilla | Puerto Rico | 72005 | 528 | |
650199 | 650199 | 2020-10-20 | Aguadilla | Puerto Rico | 72005 | 527 | |
646955 | 646955 | 2020-10-19 | Aguadilla | Puerto Rico | 72005 | 522 | |
643709 | 643709 | 2020-10-18 | Aguadilla | Puerto Rico | 72005 | 516 | |
640461 | 640461 | 2020-10-17 | Aguadilla | Puerto Rico | 72005 | 511 | |
637215 | 637215 | 2020-10-16 | Aguadilla | Puerto Rico | 72005 | 506 | |
633969 | 633969 | 2020-10-15 | Aguadilla | Puerto Rico | 72005 | 496 | |
630724 | 630724 | 2020-10-14 | Aguadilla | Puerto Rico | 72005 | 487 | |
627480 | 627480 | 2020-10-13 | Aguadilla | Puerto Rico | 72005 | 483 | |
624238 | 624238 | 2020-10-12 | Aguadilla | Puerto Rico | 72005 | 470 | |
620995 | 620995 | 2020-10-11 | Aguadilla | Puerto Rico | 72005 | 467 | |
617752 | 617752 | 2020-10-10 | Aguadilla | Puerto Rico | 72005 | 464 | |
614510 | 614510 | 2020-10-09 | Aguadilla | Puerto Rico | 72005 | 458 | |
611269 | 611269 | 2020-10-08 | Aguadilla | Puerto Rico | 72005 | 451 | |
608027 | 608027 | 2020-10-07 | Aguadilla | Puerto Rico | 72005 | 450 | |
604784 | 604784 | 2020-10-06 | Aguadilla | Puerto Rico | 72005 | 450 | |
601542 | 601542 | 2020-10-05 | Aguadilla | Puerto Rico | 72005 | 449 |
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);