ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Juana Diaz" 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 |
---|---|---|---|---|---|---|---|
1065609 | 1065609 | 2021-02-25 | Juana Diaz | Puerto Rico | 72075 | 1088 | |
1062364 | 1062364 | 2021-02-24 | Juana Diaz | Puerto Rico | 72075 | 1086 | |
1059119 | 1059119 | 2021-02-23 | Juana Diaz | Puerto Rico | 72075 | 1086 | |
1055873 | 1055873 | 2021-02-22 | Juana Diaz | Puerto Rico | 72075 | 1085 | |
1052627 | 1052627 | 2021-02-21 | Juana Diaz | Puerto Rico | 72075 | 1084 | |
1049380 | 1049380 | 2021-02-20 | Juana Diaz | Puerto Rico | 72075 | 1080 | |
1046133 | 1046133 | 2021-02-19 | Juana Diaz | Puerto Rico | 72075 | 1074 | |
1042888 | 1042888 | 2021-02-18 | Juana Diaz | Puerto Rico | 72075 | 1072 | |
1039643 | 1039643 | 2021-02-17 | Juana Diaz | Puerto Rico | 72075 | 1070 | |
1036398 | 1036398 | 2021-02-16 | Juana Diaz | Puerto Rico | 72075 | 1070 | |
1033153 | 1033153 | 2021-02-15 | Juana Diaz | Puerto Rico | 72075 | 1068 | |
1029907 | 1029907 | 2021-02-14 | Juana Diaz | Puerto Rico | 72075 | 1062 | |
1026660 | 1026660 | 2021-02-13 | Juana Diaz | Puerto Rico | 72075 | 1061 | |
1023415 | 1023415 | 2021-02-12 | Juana Diaz | Puerto Rico | 72075 | 1058 | |
1020170 | 1020170 | 2021-02-11 | Juana Diaz | Puerto Rico | 72075 | 1055 | |
1016925 | 1016925 | 2021-02-10 | Juana Diaz | Puerto Rico | 72075 | 1054 | |
1013680 | 1013680 | 2021-02-09 | Juana Diaz | Puerto Rico | 72075 | 1051 | |
1010435 | 1010435 | 2021-02-08 | Juana Diaz | Puerto Rico | 72075 | 1051 | |
1007189 | 1007189 | 2021-02-07 | Juana Diaz | Puerto Rico | 72075 | 1047 | |
1003943 | 1003943 | 2021-02-06 | Juana Diaz | Puerto Rico | 72075 | 1044 | |
1000697 | 1000697 | 2021-02-05 | Juana Diaz | Puerto Rico | 72075 | 1039 | |
997451 | 997451 | 2021-02-04 | Juana Diaz | Puerto Rico | 72075 | 1037 | |
994205 | 994205 | 2021-02-03 | Juana Diaz | Puerto Rico | 72075 | 1037 | |
990959 | 990959 | 2021-02-02 | Juana Diaz | Puerto Rico | 72075 | 1037 | |
987713 | 987713 | 2021-02-01 | Juana Diaz | Puerto Rico | 72075 | 1032 | |
984466 | 984466 | 2021-01-31 | Juana Diaz | Puerto Rico | 72075 | 1027 | |
981219 | 981219 | 2021-01-30 | Juana Diaz | Puerto Rico | 72075 | 1026 | |
977973 | 977973 | 2021-01-29 | Juana Diaz | Puerto Rico | 72075 | 1016 | |
974728 | 974728 | 2021-01-28 | Juana Diaz | Puerto Rico | 72075 | 1014 | |
971483 | 971483 | 2021-01-27 | Juana Diaz | Puerto Rico | 72075 | 1009 | |
968238 | 968238 | 2021-01-26 | Juana Diaz | Puerto Rico | 72075 | 1006 | |
964994 | 964994 | 2021-01-25 | Juana Diaz | Puerto Rico | 72075 | 1003 | |
961749 | 961749 | 2021-01-24 | Juana Diaz | Puerto Rico | 72075 | 1000 | |
958504 | 958504 | 2021-01-23 | Juana Diaz | Puerto Rico | 72075 | 995 | |
955258 | 955258 | 2021-01-22 | Juana Diaz | Puerto Rico | 72075 | 987 | |
952013 | 952013 | 2021-01-21 | Juana Diaz | Puerto Rico | 72075 | 984 | |
948768 | 948768 | 2021-01-20 | Juana Diaz | Puerto Rico | 72075 | 978 | |
945522 | 945522 | 2021-01-19 | Juana Diaz | Puerto Rico | 72075 | 977 | |
942275 | 942275 | 2021-01-18 | Juana Diaz | Puerto Rico | 72075 | 975 | |
939030 | 939030 | 2021-01-17 | Juana Diaz | Puerto Rico | 72075 | 964 | |
935785 | 935785 | 2021-01-16 | Juana Diaz | Puerto Rico | 72075 | 958 | |
932540 | 932540 | 2021-01-15 | Juana Diaz | Puerto Rico | 72075 | 954 | |
929295 | 929295 | 2021-01-14 | Juana Diaz | Puerto Rico | 72075 | 928 | |
926050 | 926050 | 2021-01-13 | Juana Diaz | Puerto Rico | 72075 | 922 | |
922804 | 922804 | 2021-01-12 | Juana Diaz | Puerto Rico | 72075 | 918 | |
919559 | 919559 | 2021-01-11 | Juana Diaz | Puerto Rico | 72075 | 908 | |
916314 | 916314 | 2021-01-10 | Juana Diaz | Puerto Rico | 72075 | 900 | |
913069 | 913069 | 2021-01-09 | Juana Diaz | Puerto Rico | 72075 | 876 | |
909824 | 909824 | 2021-01-08 | Juana Diaz | Puerto Rico | 72075 | 870 | |
906579 | 906579 | 2021-01-07 | Juana Diaz | Puerto Rico | 72075 | 863 | |
903333 | 903333 | 2021-01-06 | Juana Diaz | Puerto Rico | 72075 | 859 | |
900088 | 900088 | 2021-01-05 | Juana Diaz | Puerto Rico | 72075 | 855 | |
896843 | 896843 | 2021-01-04 | Juana Diaz | Puerto Rico | 72075 | 853 | |
893597 | 893597 | 2021-01-03 | Juana Diaz | Puerto Rico | 72075 | 847 | |
890351 | 890351 | 2021-01-02 | Juana Diaz | Puerto Rico | 72075 | 844 | |
887104 | 887104 | 2021-01-01 | Juana Diaz | Puerto Rico | 72075 | 832 | |
883859 | 883859 | 2020-12-31 | Juana Diaz | Puerto Rico | 72075 | 827 | |
880614 | 880614 | 2020-12-30 | Juana Diaz | Puerto Rico | 72075 | 814 | |
877369 | 877369 | 2020-12-29 | Juana Diaz | Puerto Rico | 72075 | 814 | |
874124 | 874124 | 2020-12-28 | Juana Diaz | Puerto Rico | 72075 | 807 | |
870879 | 870879 | 2020-12-27 | Juana Diaz | Puerto Rico | 72075 | 807 | |
867634 | 867634 | 2020-12-26 | Juana Diaz | Puerto Rico | 72075 | 802 | |
864389 | 864389 | 2020-12-25 | Juana Diaz | Puerto Rico | 72075 | 800 | |
861144 | 861144 | 2020-12-24 | Juana Diaz | Puerto Rico | 72075 | 797 | |
857899 | 857899 | 2020-12-23 | Juana Diaz | Puerto Rico | 72075 | 794 | |
854654 | 854654 | 2020-12-22 | Juana Diaz | Puerto Rico | 72075 | 789 | |
851409 | 851409 | 2020-12-21 | Juana Diaz | Puerto Rico | 72075 | 786 | |
848164 | 848164 | 2020-12-20 | Juana Diaz | Puerto Rico | 72075 | 785 | |
844919 | 844919 | 2020-12-19 | Juana Diaz | Puerto Rico | 72075 | 774 | |
841673 | 841673 | 2020-12-18 | Juana Diaz | Puerto Rico | 72075 | 753 | |
838428 | 838428 | 2020-12-17 | Juana Diaz | Puerto Rico | 72075 | 747 | |
835182 | 835182 | 2020-12-16 | Juana Diaz | Puerto Rico | 72075 | 742 | |
831936 | 831936 | 2020-12-15 | Juana Diaz | Puerto Rico | 72075 | 742 | |
828689 | 828689 | 2020-12-14 | Juana Diaz | Puerto Rico | 72075 | 741 | |
825443 | 825443 | 2020-12-13 | Juana Diaz | Puerto Rico | 72075 | 735 | |
822196 | 822196 | 2020-12-12 | Juana Diaz | Puerto Rico | 72075 | 725 | |
818950 | 818950 | 2020-12-11 | Juana Diaz | Puerto Rico | 72075 | 715 | |
815704 | 815704 | 2020-12-10 | Juana Diaz | Puerto Rico | 72075 | 710 | |
812458 | 812458 | 2020-12-09 | Juana Diaz | Puerto Rico | 72075 | 700 | |
809214 | 809214 | 2020-12-08 | Juana Diaz | Puerto Rico | 72075 | 694 | |
805969 | 805969 | 2020-12-07 | Juana Diaz | Puerto Rico | 72075 | 690 | |
802724 | 802724 | 2020-12-06 | Juana Diaz | Puerto Rico | 72075 | 680 | |
799479 | 799479 | 2020-12-05 | Juana Diaz | Puerto Rico | 72075 | 671 | |
796234 | 796234 | 2020-12-04 | Juana Diaz | Puerto Rico | 72075 | 666 | |
792989 | 792989 | 2020-12-03 | Juana Diaz | Puerto Rico | 72075 | 664 | |
789744 | 789744 | 2020-12-02 | Juana Diaz | Puerto Rico | 72075 | 662 | |
786499 | 786499 | 2020-12-01 | Juana Diaz | Puerto Rico | 72075 | 655 | |
783255 | 783255 | 2020-11-30 | Juana Diaz | Puerto Rico | 72075 | 651 | |
780010 | 780010 | 2020-11-29 | Juana Diaz | Puerto Rico | 72075 | 650 | |
776764 | 776764 | 2020-11-28 | Juana Diaz | Puerto Rico | 72075 | 650 | |
773519 | 773519 | 2020-11-27 | Juana Diaz | Puerto Rico | 72075 | 639 | |
770274 | 770274 | 2020-11-26 | Juana Diaz | Puerto Rico | 72075 | 626 | |
767028 | 767028 | 2020-11-25 | Juana Diaz | Puerto Rico | 72075 | 619 | |
763783 | 763783 | 2020-11-24 | Juana Diaz | Puerto Rico | 72075 | 614 | |
760538 | 760538 | 2020-11-23 | Juana Diaz | Puerto Rico | 72075 | 612 | |
757293 | 757293 | 2020-11-22 | Juana Diaz | Puerto Rico | 72075 | 608 | |
754046 | 754046 | 2020-11-21 | Juana Diaz | Puerto Rico | 72075 | 601 | |
750800 | 750800 | 2020-11-20 | Juana Diaz | Puerto Rico | 72075 | 588 | |
747554 | 747554 | 2020-11-19 | Juana Diaz | Puerto Rico | 72075 | 574 | |
744308 | 744308 | 2020-11-18 | Juana Diaz | Puerto Rico | 72075 | 563 |
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);