ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Guayama" 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 |
---|---|---|---|---|---|---|---|
1279903 | 1279903 | 2021-05-02 | Guayama | Puerto Rico | 72057 | 1062 | |
1276656 | 1276656 | 2021-05-01 | Guayama | Puerto Rico | 72057 | 1061 | |
1273409 | 1273409 | 2021-04-30 | Guayama | Puerto Rico | 72057 | 1058 | |
1270162 | 1270162 | 2021-04-29 | Guayama | Puerto Rico | 72057 | 1056 | |
1266915 | 1266915 | 2021-04-28 | Guayama | Puerto Rico | 72057 | 1054 | |
1263668 | 1263668 | 2021-04-27 | Guayama | Puerto Rico | 72057 | 1053 | |
1260421 | 1260421 | 2021-04-26 | Guayama | Puerto Rico | 72057 | 1047 | |
1257174 | 1257174 | 2021-04-25 | Guayama | Puerto Rico | 72057 | 1045 | |
1253927 | 1253927 | 2021-04-24 | Guayama | Puerto Rico | 72057 | 1039 | |
1250680 | 1250680 | 2021-04-23 | Guayama | Puerto Rico | 72057 | 1038 | |
1247433 | 1247433 | 2021-04-22 | Guayama | Puerto Rico | 72057 | 1027 | |
1244186 | 1244186 | 2021-04-21 | Guayama | Puerto Rico | 72057 | 1023 | |
1240939 | 1240939 | 2021-04-20 | Guayama | Puerto Rico | 72057 | 1020 | |
1237692 | 1237692 | 2021-04-19 | Guayama | Puerto Rico | 72057 | 1013 | |
1234445 | 1234445 | 2021-04-18 | Guayama | Puerto Rico | 72057 | 999 | |
1231197 | 1231197 | 2021-04-17 | Guayama | Puerto Rico | 72057 | 990 | |
1227949 | 1227949 | 2021-04-16 | Guayama | Puerto Rico | 72057 | 979 | |
1224701 | 1224701 | 2021-04-15 | Guayama | Puerto Rico | 72057 | 976 | |
1221454 | 1221454 | 2021-04-14 | Guayama | Puerto Rico | 72057 | 973 | |
1218206 | 1218206 | 2021-04-13 | Guayama | Puerto Rico | 72057 | 972 | |
1214958 | 1214958 | 2021-04-12 | Guayama | Puerto Rico | 72057 | 959 | |
1211711 | 1211711 | 2021-04-11 | Guayama | Puerto Rico | 72057 | 944 | |
1208462 | 1208462 | 2021-04-10 | Guayama | Puerto Rico | 72057 | 934 | |
1205214 | 1205214 | 2021-04-09 | Guayama | Puerto Rico | 72057 | 926 | |
1201966 | 1201966 | 2021-04-08 | Guayama | Puerto Rico | 72057 | 918 | |
1198717 | 1198717 | 2021-04-07 | Guayama | Puerto Rico | 72057 | 914 | |
1195468 | 1195468 | 2021-04-06 | Guayama | Puerto Rico | 72057 | 912 | |
1192220 | 1192220 | 2021-04-05 | Guayama | Puerto Rico | 72057 | 907 | |
1188971 | 1188971 | 2021-04-04 | Guayama | Puerto Rico | 72057 | 903 | |
1185724 | 1185724 | 2021-04-03 | Guayama | Puerto Rico | 72057 | 900 | |
1182477 | 1182477 | 2021-04-02 | Guayama | Puerto Rico | 72057 | 895 | |
1179230 | 1179230 | 2021-04-01 | Guayama | Puerto Rico | 72057 | 895 | |
1175983 | 1175983 | 2021-03-31 | Guayama | Puerto Rico | 72057 | 895 | |
1172736 | 1172736 | 2021-03-30 | Guayama | Puerto Rico | 72057 | 894 | |
1169489 | 1169489 | 2021-03-29 | Guayama | Puerto Rico | 72057 | 890 | |
1166241 | 1166241 | 2021-03-28 | Guayama | Puerto Rico | 72057 | 889 | |
1162993 | 1162993 | 2021-03-27 | Guayama | Puerto Rico | 72057 | 883 | |
1159744 | 1159744 | 2021-03-26 | Guayama | Puerto Rico | 72057 | 882 | |
1156497 | 1156497 | 2021-03-25 | Guayama | Puerto Rico | 72057 | 881 | |
1153250 | 1153250 | 2021-03-24 | Guayama | Puerto Rico | 72057 | 877 | |
1150003 | 1150003 | 2021-03-23 | Guayama | Puerto Rico | 72057 | 875 | |
1146756 | 1146756 | 2021-03-22 | Guayama | Puerto Rico | 72057 | 872 | |
1143509 | 1143509 | 2021-03-21 | Guayama | Puerto Rico | 72057 | 872 | |
1140262 | 1140262 | 2021-03-20 | Guayama | Puerto Rico | 72057 | 871 | |
1137016 | 1137016 | 2021-03-19 | Guayama | Puerto Rico | 72057 | 867 | |
1133770 | 1133770 | 2021-03-18 | Guayama | Puerto Rico | 72057 | 858 | |
1130522 | 1130522 | 2021-03-17 | Guayama | Puerto Rico | 72057 | 858 | |
1127275 | 1127275 | 2021-03-16 | Guayama | Puerto Rico | 72057 | 858 | |
1124029 | 1124029 | 2021-03-15 | Guayama | Puerto Rico | 72057 | 856 | |
1120783 | 1120783 | 2021-03-14 | Guayama | Puerto Rico | 72057 | 853 | |
1117536 | 1117536 | 2021-03-13 | Guayama | Puerto Rico | 72057 | 850 | |
1114289 | 1114289 | 2021-03-12 | Guayama | Puerto Rico | 72057 | 848 | |
1111043 | 1111043 | 2021-03-11 | Guayama | Puerto Rico | 72057 | 843 | |
1107797 | 1107797 | 2021-03-10 | Guayama | Puerto Rico | 72057 | 840 | |
1104551 | 1104551 | 2021-03-09 | Guayama | Puerto Rico | 72057 | 840 | |
1101305 | 1101305 | 2021-03-08 | Guayama | Puerto Rico | 72057 | 835 | |
1098059 | 1098059 | 2021-03-07 | Guayama | Puerto Rico | 72057 | 831 | |
1094811 | 1094811 | 2021-03-06 | Guayama | Puerto Rico | 72057 | 831 | |
1091565 | 1091565 | 2021-03-05 | Guayama | Puerto Rico | 72057 | 827 | |
1088319 | 1088319 | 2021-03-04 | Guayama | Puerto Rico | 72057 | 821 | |
1085074 | 1085074 | 2021-03-03 | Guayama | Puerto Rico | 72057 | 820 | |
1081828 | 1081828 | 2021-03-02 | Guayama | Puerto Rico | 72057 | 818 | |
1078582 | 1078582 | 2021-03-01 | Guayama | Puerto Rico | 72057 | 817 | |
1075337 | 1075337 | 2021-02-28 | Guayama | Puerto Rico | 72057 | 814 | |
1072091 | 1072091 | 2021-02-27 | Guayama | Puerto Rico | 72057 | 811 | |
1068845 | 1068845 | 2021-02-26 | Guayama | Puerto Rico | 72057 | 808 | |
1065600 | 1065600 | 2021-02-25 | Guayama | Puerto Rico | 72057 | 808 | |
1062355 | 1062355 | 2021-02-24 | Guayama | Puerto Rico | 72057 | 808 | |
1059110 | 1059110 | 2021-02-23 | Guayama | Puerto Rico | 72057 | 808 | |
1055864 | 1055864 | 2021-02-22 | Guayama | Puerto Rico | 72057 | 808 | |
1052618 | 1052618 | 2021-02-21 | Guayama | Puerto Rico | 72057 | 807 | |
1049371 | 1049371 | 2021-02-20 | Guayama | Puerto Rico | 72057 | 803 | |
1046124 | 1046124 | 2021-02-19 | Guayama | Puerto Rico | 72057 | 803 | |
1042879 | 1042879 | 2021-02-18 | Guayama | Puerto Rico | 72057 | 803 | |
1039634 | 1039634 | 2021-02-17 | Guayama | Puerto Rico | 72057 | 803 | |
1036389 | 1036389 | 2021-02-16 | Guayama | Puerto Rico | 72057 | 803 | |
1033144 | 1033144 | 2021-02-15 | Guayama | Puerto Rico | 72057 | 800 | |
1029898 | 1029898 | 2021-02-14 | Guayama | Puerto Rico | 72057 | 799 | |
1026651 | 1026651 | 2021-02-13 | Guayama | Puerto Rico | 72057 | 797 | |
1023406 | 1023406 | 2021-02-12 | Guayama | Puerto Rico | 72057 | 795 | |
1020161 | 1020161 | 2021-02-11 | Guayama | Puerto Rico | 72057 | 793 | |
1016916 | 1016916 | 2021-02-10 | Guayama | Puerto Rico | 72057 | 793 | |
1013671 | 1013671 | 2021-02-09 | Guayama | Puerto Rico | 72057 | 793 | |
1010426 | 1010426 | 2021-02-08 | Guayama | Puerto Rico | 72057 | 791 | |
1007180 | 1007180 | 2021-02-07 | Guayama | Puerto Rico | 72057 | 790 | |
1003934 | 1003934 | 2021-02-06 | Guayama | Puerto Rico | 72057 | 789 | |
1000688 | 1000688 | 2021-02-05 | Guayama | Puerto Rico | 72057 | 787 | |
997442 | 997442 | 2021-02-04 | Guayama | Puerto Rico | 72057 | 780 | |
994196 | 994196 | 2021-02-03 | Guayama | Puerto Rico | 72057 | 777 | |
990950 | 990950 | 2021-02-02 | Guayama | Puerto Rico | 72057 | 776 | |
987704 | 987704 | 2021-02-01 | Guayama | Puerto Rico | 72057 | 776 | |
984457 | 984457 | 2021-01-31 | Guayama | Puerto Rico | 72057 | 774 | |
981210 | 981210 | 2021-01-30 | Guayama | Puerto Rico | 72057 | 772 | |
977964 | 977964 | 2021-01-29 | Guayama | Puerto Rico | 72057 | 769 | |
974719 | 974719 | 2021-01-28 | Guayama | Puerto Rico | 72057 | 767 | |
971474 | 971474 | 2021-01-27 | Guayama | Puerto Rico | 72057 | 766 | |
968229 | 968229 | 2021-01-26 | Guayama | Puerto Rico | 72057 | 766 | |
964985 | 964985 | 2021-01-25 | Guayama | Puerto Rico | 72057 | 763 | |
961740 | 961740 | 2021-01-24 | Guayama | Puerto Rico | 72057 | 756 | |
958495 | 958495 | 2021-01-23 | Guayama | Puerto Rico | 72057 | 752 |
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);