ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Fajardo" 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 |
---|---|---|---|---|---|---|---|
1065597 | 1065597 | 2021-02-25 | Fajardo | Puerto Rico | 72053 | 1270 | |
1062352 | 1062352 | 2021-02-24 | Fajardo | Puerto Rico | 72053 | 1269 | |
1059107 | 1059107 | 2021-02-23 | Fajardo | Puerto Rico | 72053 | 1269 | |
1055861 | 1055861 | 2021-02-22 | Fajardo | Puerto Rico | 72053 | 1265 | |
1052615 | 1052615 | 2021-02-21 | Fajardo | Puerto Rico | 72053 | 1262 | |
1049368 | 1049368 | 2021-02-20 | Fajardo | Puerto Rico | 72053 | 1260 | |
1046121 | 1046121 | 2021-02-19 | Fajardo | Puerto Rico | 72053 | 1259 | |
1042876 | 1042876 | 2021-02-18 | Fajardo | Puerto Rico | 72053 | 1259 | |
1039631 | 1039631 | 2021-02-17 | Fajardo | Puerto Rico | 72053 | 1255 | |
1036386 | 1036386 | 2021-02-16 | Fajardo | Puerto Rico | 72053 | 1254 | |
1033141 | 1033141 | 2021-02-15 | Fajardo | Puerto Rico | 72053 | 1252 | |
1029895 | 1029895 | 2021-02-14 | Fajardo | Puerto Rico | 72053 | 1252 | |
1026648 | 1026648 | 2021-02-13 | Fajardo | Puerto Rico | 72053 | 1251 | |
1023403 | 1023403 | 2021-02-12 | Fajardo | Puerto Rico | 72053 | 1249 | |
1020158 | 1020158 | 2021-02-11 | Fajardo | Puerto Rico | 72053 | 1246 | |
1016913 | 1016913 | 2021-02-10 | Fajardo | Puerto Rico | 72053 | 1245 | |
1013668 | 1013668 | 2021-02-09 | Fajardo | Puerto Rico | 72053 | 1245 | |
1010423 | 1010423 | 2021-02-08 | Fajardo | Puerto Rico | 72053 | 1242 | |
1007177 | 1007177 | 2021-02-07 | Fajardo | Puerto Rico | 72053 | 1239 | |
1003931 | 1003931 | 2021-02-06 | Fajardo | Puerto Rico | 72053 | 1237 | |
1000685 | 1000685 | 2021-02-05 | Fajardo | Puerto Rico | 72053 | 1236 | |
997439 | 997439 | 2021-02-04 | Fajardo | Puerto Rico | 72053 | 1235 | |
994193 | 994193 | 2021-02-03 | Fajardo | Puerto Rico | 72053 | 1235 | |
990947 | 990947 | 2021-02-02 | Fajardo | Puerto Rico | 72053 | 1232 | |
987701 | 987701 | 2021-02-01 | Fajardo | Puerto Rico | 72053 | 1231 | |
984454 | 984454 | 2021-01-31 | Fajardo | Puerto Rico | 72053 | 1224 | |
981207 | 981207 | 2021-01-30 | Fajardo | Puerto Rico | 72053 | 1222 | |
977961 | 977961 | 2021-01-29 | Fajardo | Puerto Rico | 72053 | 1219 | |
974716 | 974716 | 2021-01-28 | Fajardo | Puerto Rico | 72053 | 1218 | |
971471 | 971471 | 2021-01-27 | Fajardo | Puerto Rico | 72053 | 1216 | |
968226 | 968226 | 2021-01-26 | Fajardo | Puerto Rico | 72053 | 1214 | |
964982 | 964982 | 2021-01-25 | Fajardo | Puerto Rico | 72053 | 1212 | |
961737 | 961737 | 2021-01-24 | Fajardo | Puerto Rico | 72053 | 1210 | |
958492 | 958492 | 2021-01-23 | Fajardo | Puerto Rico | 72053 | 1205 | |
955246 | 955246 | 2021-01-22 | Fajardo | Puerto Rico | 72053 | 1201 | |
952001 | 952001 | 2021-01-21 | Fajardo | Puerto Rico | 72053 | 1200 | |
948756 | 948756 | 2021-01-20 | Fajardo | Puerto Rico | 72053 | 1197 | |
945510 | 945510 | 2021-01-19 | Fajardo | Puerto Rico | 72053 | 1197 | |
942263 | 942263 | 2021-01-18 | Fajardo | Puerto Rico | 72053 | 1189 | |
939018 | 939018 | 2021-01-17 | Fajardo | Puerto Rico | 72053 | 1187 | |
935773 | 935773 | 2021-01-16 | Fajardo | Puerto Rico | 72053 | 1180 | |
932528 | 932528 | 2021-01-15 | Fajardo | Puerto Rico | 72053 | 1172 | |
929283 | 929283 | 2021-01-14 | Fajardo | Puerto Rico | 72053 | 1166 | |
926038 | 926038 | 2021-01-13 | Fajardo | Puerto Rico | 72053 | 1166 | |
922792 | 922792 | 2021-01-12 | Fajardo | Puerto Rico | 72053 | 1165 | |
919547 | 919547 | 2021-01-11 | Fajardo | Puerto Rico | 72053 | 1162 | |
916302 | 916302 | 2021-01-10 | Fajardo | Puerto Rico | 72053 | 1159 | |
913057 | 913057 | 2021-01-09 | Fajardo | Puerto Rico | 72053 | 1157 | |
909812 | 909812 | 2021-01-08 | Fajardo | Puerto Rico | 72053 | 1152 | |
906567 | 906567 | 2021-01-07 | Fajardo | Puerto Rico | 72053 | 1106 | |
903321 | 903321 | 2021-01-06 | Fajardo | Puerto Rico | 72053 | 1098 | |
900076 | 900076 | 2021-01-05 | Fajardo | Puerto Rico | 72053 | 1096 | |
896831 | 896831 | 2021-01-04 | Fajardo | Puerto Rico | 72053 | 1089 | |
893585 | 893585 | 2021-01-03 | Fajardo | Puerto Rico | 72053 | 1078 | |
890339 | 890339 | 2021-01-02 | Fajardo | Puerto Rico | 72053 | 1075 | |
887092 | 887092 | 2021-01-01 | Fajardo | Puerto Rico | 72053 | 1046 | |
883847 | 883847 | 2020-12-31 | Fajardo | Puerto Rico | 72053 | 1038 | |
880602 | 880602 | 2020-12-30 | Fajardo | Puerto Rico | 72053 | 1029 | |
877357 | 877357 | 2020-12-29 | Fajardo | Puerto Rico | 72053 | 1027 | |
874112 | 874112 | 2020-12-28 | Fajardo | Puerto Rico | 72053 | 995 | |
870867 | 870867 | 2020-12-27 | Fajardo | Puerto Rico | 72053 | 995 | |
867622 | 867622 | 2020-12-26 | Fajardo | Puerto Rico | 72053 | 982 | |
864377 | 864377 | 2020-12-25 | Fajardo | Puerto Rico | 72053 | 980 | |
861132 | 861132 | 2020-12-24 | Fajardo | Puerto Rico | 72053 | 978 | |
857887 | 857887 | 2020-12-23 | Fajardo | Puerto Rico | 72053 | 976 | |
854642 | 854642 | 2020-12-22 | Fajardo | Puerto Rico | 72053 | 969 | |
851397 | 851397 | 2020-12-21 | Fajardo | Puerto Rico | 72053 | 959 | |
848152 | 848152 | 2020-12-20 | Fajardo | Puerto Rico | 72053 | 957 | |
844907 | 844907 | 2020-12-19 | Fajardo | Puerto Rico | 72053 | 911 | |
841661 | 841661 | 2020-12-18 | Fajardo | Puerto Rico | 72053 | 905 | |
838416 | 838416 | 2020-12-17 | Fajardo | Puerto Rico | 72053 | 897 | |
835170 | 835170 | 2020-12-16 | Fajardo | Puerto Rico | 72053 | 893 | |
831924 | 831924 | 2020-12-15 | Fajardo | Puerto Rico | 72053 | 893 | |
828677 | 828677 | 2020-12-14 | Fajardo | Puerto Rico | 72053 | 890 | |
825431 | 825431 | 2020-12-13 | Fajardo | Puerto Rico | 72053 | 888 | |
822184 | 822184 | 2020-12-12 | Fajardo | Puerto Rico | 72053 | 884 | |
818938 | 818938 | 2020-12-11 | Fajardo | Puerto Rico | 72053 | 884 | |
815692 | 815692 | 2020-12-10 | Fajardo | Puerto Rico | 72053 | 879 | |
812446 | 812446 | 2020-12-09 | Fajardo | Puerto Rico | 72053 | 879 | |
809202 | 809202 | 2020-12-08 | Fajardo | Puerto Rico | 72053 | 878 | |
805957 | 805957 | 2020-12-07 | Fajardo | Puerto Rico | 72053 | 874 | |
802712 | 802712 | 2020-12-06 | Fajardo | Puerto Rico | 72053 | 872 | |
799467 | 799467 | 2020-12-05 | Fajardo | Puerto Rico | 72053 | 870 | |
796222 | 796222 | 2020-12-04 | Fajardo | Puerto Rico | 72053 | 867 | |
792977 | 792977 | 2020-12-03 | Fajardo | Puerto Rico | 72053 | 862 | |
789732 | 789732 | 2020-12-02 | Fajardo | Puerto Rico | 72053 | 853 | |
786487 | 786487 | 2020-12-01 | Fajardo | Puerto Rico | 72053 | 852 | |
783243 | 783243 | 2020-11-30 | Fajardo | Puerto Rico | 72053 | 851 | |
779998 | 779998 | 2020-11-29 | Fajardo | Puerto Rico | 72053 | 848 | |
776752 | 776752 | 2020-11-28 | Fajardo | Puerto Rico | 72053 | 848 | |
773507 | 773507 | 2020-11-27 | Fajardo | Puerto Rico | 72053 | 844 | |
770262 | 770262 | 2020-11-26 | Fajardo | Puerto Rico | 72053 | 841 | |
767016 | 767016 | 2020-11-25 | Fajardo | Puerto Rico | 72053 | 839 | |
763771 | 763771 | 2020-11-24 | Fajardo | Puerto Rico | 72053 | 839 | |
760526 | 760526 | 2020-11-23 | Fajardo | Puerto Rico | 72053 | 836 | |
757281 | 757281 | 2020-11-22 | Fajardo | Puerto Rico | 72053 | 836 | |
754034 | 754034 | 2020-11-21 | Fajardo | Puerto Rico | 72053 | 835 | |
750788 | 750788 | 2020-11-20 | Fajardo | Puerto Rico | 72053 | 834 | |
747542 | 747542 | 2020-11-19 | Fajardo | Puerto Rico | 72053 | 831 | |
744296 | 744296 | 2020-11-18 | Fajardo | Puerto Rico | 72053 | 828 |
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);