ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 48189 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280261 | 1280261 | 2021-05-02 | Hale | Texas | 48189 | 6111 | 155 |
1277014 | 1277014 | 2021-05-01 | Hale | Texas | 48189 | 6111 | 155 |
1273767 | 1273767 | 2021-04-30 | Hale | Texas | 48189 | 6111 | 155 |
1270520 | 1270520 | 2021-04-29 | Hale | Texas | 48189 | 6111 | 155 |
1267273 | 1267273 | 2021-04-28 | Hale | Texas | 48189 | 6111 | 155 |
1264026 | 1264026 | 2021-04-27 | Hale | Texas | 48189 | 6101 | 155 |
1260779 | 1260779 | 2021-04-26 | Hale | Texas | 48189 | 6101 | 155 |
1257532 | 1257532 | 2021-04-25 | Hale | Texas | 48189 | 6101 | 155 |
1254285 | 1254285 | 2021-04-24 | Hale | Texas | 48189 | 6101 | 155 |
1251038 | 1251038 | 2021-04-23 | Hale | Texas | 48189 | 6101 | 155 |
1247791 | 1247791 | 2021-04-22 | Hale | Texas | 48189 | 6101 | 155 |
1244544 | 1244544 | 2021-04-21 | Hale | Texas | 48189 | 6101 | 155 |
1241297 | 1241297 | 2021-04-20 | Hale | Texas | 48189 | 6092 | 155 |
1238050 | 1238050 | 2021-04-19 | Hale | Texas | 48189 | 6092 | 155 |
1234803 | 1234803 | 2021-04-18 | Hale | Texas | 48189 | 6092 | 155 |
1231555 | 1231555 | 2021-04-17 | Hale | Texas | 48189 | 6092 | 154 |
1228307 | 1228307 | 2021-04-16 | Hale | Texas | 48189 | 6092 | 154 |
1225059 | 1225059 | 2021-04-15 | Hale | Texas | 48189 | 6092 | 154 |
1221812 | 1221812 | 2021-04-14 | Hale | Texas | 48189 | 6092 | 154 |
1218564 | 1218564 | 2021-04-13 | Hale | Texas | 48189 | 6088 | 154 |
1215316 | 1215316 | 2021-04-12 | Hale | Texas | 48189 | 6088 | 153 |
1212069 | 1212069 | 2021-04-11 | Hale | Texas | 48189 | 6088 | 153 |
1208820 | 1208820 | 2021-04-10 | Hale | Texas | 48189 | 6088 | 153 |
1205572 | 1205572 | 2021-04-09 | Hale | Texas | 48189 | 6088 | 153 |
1202324 | 1202324 | 2021-04-08 | Hale | Texas | 48189 | 6088 | 153 |
1199075 | 1199075 | 2021-04-07 | Hale | Texas | 48189 | 6088 | 153 |
1195826 | 1195826 | 2021-04-06 | Hale | Texas | 48189 | 6084 | 153 |
1192578 | 1192578 | 2021-04-05 | Hale | Texas | 48189 | 6084 | 153 |
1189329 | 1189329 | 2021-04-04 | Hale | Texas | 48189 | 6084 | 153 |
1186082 | 1186082 | 2021-04-03 | Hale | Texas | 48189 | 6084 | 153 |
1182835 | 1182835 | 2021-04-02 | Hale | Texas | 48189 | 6084 | 153 |
1179588 | 1179588 | 2021-04-01 | Hale | Texas | 48189 | 6077 | 153 |
1176341 | 1176341 | 2021-03-31 | Hale | Texas | 48189 | 6077 | 153 |
1173094 | 1173094 | 2021-03-30 | Hale | Texas | 48189 | 6077 | 153 |
1169847 | 1169847 | 2021-03-29 | Hale | Texas | 48189 | 6073 | 153 |
1166599 | 1166599 | 2021-03-28 | Hale | Texas | 48189 | 6073 | 153 |
1163351 | 1163351 | 2021-03-27 | Hale | Texas | 48189 | 6073 | 153 |
1160102 | 1160102 | 2021-03-26 | Hale | Texas | 48189 | 6073 | 153 |
1156855 | 1156855 | 2021-03-25 | Hale | Texas | 48189 | 6067 | 153 |
1153608 | 1153608 | 2021-03-24 | Hale | Texas | 48189 | 6067 | 153 |
1150361 | 1150361 | 2021-03-23 | Hale | Texas | 48189 | 6067 | 153 |
1147114 | 1147114 | 2021-03-22 | Hale | Texas | 48189 | 6067 | 153 |
1143867 | 1143867 | 2021-03-21 | Hale | Texas | 48189 | 6067 | 153 |
1140620 | 1140620 | 2021-03-20 | Hale | Texas | 48189 | 6067 | 153 |
1137374 | 1137374 | 2021-03-19 | Hale | Texas | 48189 | 6067 | 153 |
1134128 | 1134128 | 2021-03-18 | Hale | Texas | 48189 | 6066 | 153 |
1130880 | 1130880 | 2021-03-17 | Hale | Texas | 48189 | 6065 | 153 |
1127633 | 1127633 | 2021-03-16 | Hale | Texas | 48189 | 6063 | 153 |
1124387 | 1124387 | 2021-03-15 | Hale | Texas | 48189 | 6062 | 153 |
1121141 | 1121141 | 2021-03-14 | Hale | Texas | 48189 | 6059 | 153 |
1117894 | 1117894 | 2021-03-13 | Hale | Texas | 48189 | 6059 | 153 |
1114647 | 1114647 | 2021-03-12 | Hale | Texas | 48189 | 6059 | 152 |
1111401 | 1111401 | 2021-03-11 | Hale | Texas | 48189 | 6059 | 152 |
1108155 | 1108155 | 2021-03-10 | Hale | Texas | 48189 | 6058 | 152 |
1104909 | 1104909 | 2021-03-09 | Hale | Texas | 48189 | 6054 | 152 |
1101663 | 1101663 | 2021-03-08 | Hale | Texas | 48189 | 6054 | 152 |
1098417 | 1098417 | 2021-03-07 | Hale | Texas | 48189 | 6054 | 152 |
1095169 | 1095169 | 2021-03-06 | Hale | Texas | 48189 | 6054 | 152 |
1091923 | 1091923 | 2021-03-05 | Hale | Texas | 48189 | 6054 | 152 |
1088677 | 1088677 | 2021-03-04 | Hale | Texas | 48189 | 6051 | 152 |
1085432 | 1085432 | 2021-03-03 | Hale | Texas | 48189 | 6048 | 152 |
1082186 | 1082186 | 2021-03-02 | Hale | Texas | 48189 | 6043 | 152 |
1078940 | 1078940 | 2021-03-01 | Hale | Texas | 48189 | 6037 | 152 |
1075695 | 1075695 | 2021-02-28 | Hale | Texas | 48189 | 6034 | 152 |
1072449 | 1072449 | 2021-02-27 | Hale | Texas | 48189 | 6034 | 152 |
1069203 | 1069203 | 2021-02-26 | Hale | Texas | 48189 | 6034 | 152 |
1065958 | 1065958 | 2021-02-25 | Hale | Texas | 48189 | 6026 | 152 |
1062713 | 1062713 | 2021-02-24 | Hale | Texas | 48189 | 6026 | 152 |
1059468 | 1059468 | 2021-02-23 | Hale | Texas | 48189 | 6015 | 152 |
1056222 | 1056222 | 2021-02-22 | Hale | Texas | 48189 | 6015 | 151 |
1052976 | 1052976 | 2021-02-21 | Hale | Texas | 48189 | 6012 | 151 |
1049729 | 1049729 | 2021-02-20 | Hale | Texas | 48189 | 6012 | 151 |
1046482 | 1046482 | 2021-02-19 | Hale | Texas | 48189 | 6008 | 151 |
1043237 | 1043237 | 2021-02-18 | Hale | Texas | 48189 | 6008 | 151 |
1039992 | 1039992 | 2021-02-17 | Hale | Texas | 48189 | 6003 | 150 |
1036747 | 1036747 | 2021-02-16 | Hale | Texas | 48189 | 5990 | 150 |
1033502 | 1033502 | 2021-02-15 | Hale | Texas | 48189 | 5990 | 150 |
1030256 | 1030256 | 2021-02-14 | Hale | Texas | 48189 | 5990 | 150 |
1027009 | 1027009 | 2021-02-13 | Hale | Texas | 48189 | 5990 | 150 |
1023764 | 1023764 | 2021-02-12 | Hale | Texas | 48189 | 5990 | 150 |
1020519 | 1020519 | 2021-02-11 | Hale | Texas | 48189 | 5976 | 150 |
1017274 | 1017274 | 2021-02-10 | Hale | Texas | 48189 | 5976 | 150 |
1014029 | 1014029 | 2021-02-09 | Hale | Texas | 48189 | 5968 | 150 |
1010784 | 1010784 | 2021-02-08 | Hale | Texas | 48189 | 5942 | 150 |
1007538 | 1007538 | 2021-02-07 | Hale | Texas | 48189 | 5934 | 150 |
1004292 | 1004292 | 2021-02-06 | Hale | Texas | 48189 | 5934 | 150 |
1001046 | 1001046 | 2021-02-05 | Hale | Texas | 48189 | 5934 | 150 |
997800 | 997800 | 2021-02-04 | Hale | Texas | 48189 | 5919 | 148 |
994554 | 994554 | 2021-02-03 | Hale | Texas | 48189 | 5911 | 147 |
991308 | 991308 | 2021-02-02 | Hale | Texas | 48189 | 5874 | 146 |
988062 | 988062 | 2021-02-01 | Hale | Texas | 48189 | 5874 | 146 |
984815 | 984815 | 2021-01-31 | Hale | Texas | 48189 | 5858 | 146 |
981568 | 981568 | 2021-01-30 | Hale | Texas | 48189 | 5858 | 146 |
978322 | 978322 | 2021-01-29 | Hale | Texas | 48189 | 5858 | 144 |
975077 | 975077 | 2021-01-28 | Hale | Texas | 48189 | 5858 | 144 |
971832 | 971832 | 2021-01-27 | Hale | Texas | 48189 | 5825 | 143 |
968587 | 968587 | 2021-01-26 | Hale | Texas | 48189 | 5825 | 141 |
965343 | 965343 | 2021-01-25 | Hale | Texas | 48189 | 5792 | 140 |
962098 | 962098 | 2021-01-24 | Hale | Texas | 48189 | 5774 | 140 |
958853 | 958853 | 2021-01-23 | Hale | Texas | 48189 | 5774 | 140 |
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);