ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Hays" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280271 | 1280271 | 2021-05-02 | Hays | Texas | 48209 | 20360 | 239 |
1277024 | 1277024 | 2021-05-01 | Hays | Texas | 48209 | 20360 | 239 |
1273777 | 1273777 | 2021-04-30 | Hays | Texas | 48209 | 20360 | 239 |
1270530 | 1270530 | 2021-04-29 | Hays | Texas | 48209 | 20275 | 239 |
1267283 | 1267283 | 2021-04-28 | Hays | Texas | 48209 | 20240 | 239 |
1264036 | 1264036 | 2021-04-27 | Hays | Texas | 48209 | 20222 | 239 |
1260789 | 1260789 | 2021-04-26 | Hays | Texas | 48209 | 20190 | 239 |
1257542 | 1257542 | 2021-04-25 | Hays | Texas | 48209 | 20026 | 239 |
1254295 | 1254295 | 2021-04-24 | Hays | Texas | 48209 | 20026 | 239 |
1251048 | 1251048 | 2021-04-23 | Hays | Texas | 48209 | 20026 | 239 |
1247801 | 1247801 | 2021-04-22 | Hays | Texas | 48209 | 19982 | 239 |
1244554 | 1244554 | 2021-04-21 | Hays | Texas | 48209 | 19943 | 239 |
1241307 | 1241307 | 2021-04-20 | Hays | Texas | 48209 | 19884 | 238 |
1238060 | 1238060 | 2021-04-19 | Hays | Texas | 48209 | 19830 | 238 |
1234813 | 1234813 | 2021-04-18 | Hays | Texas | 48209 | 19707 | 238 |
1231565 | 1231565 | 2021-04-17 | Hays | Texas | 48209 | 19707 | 238 |
1228317 | 1228317 | 2021-04-16 | Hays | Texas | 48209 | 19707 | 238 |
1225069 | 1225069 | 2021-04-15 | Hays | Texas | 48209 | 19638 | 241 |
1221822 | 1221822 | 2021-04-14 | Hays | Texas | 48209 | 19592 | 241 |
1218574 | 1218574 | 2021-04-13 | Hays | Texas | 48209 | 19543 | 241 |
1215326 | 1215326 | 2021-04-12 | Hays | Texas | 48209 | 19524 | 241 |
1212079 | 1212079 | 2021-04-11 | Hays | Texas | 48209 | 19363 | 240 |
1208830 | 1208830 | 2021-04-10 | Hays | Texas | 48209 | 19363 | 240 |
1205582 | 1205582 | 2021-04-09 | Hays | Texas | 48209 | 19363 | 240 |
1202334 | 1202334 | 2021-04-08 | Hays | Texas | 48209 | 19362 | 240 |
1199085 | 1199085 | 2021-04-07 | Hays | Texas | 48209 | 19272 | 239 |
1195836 | 1195836 | 2021-04-06 | Hays | Texas | 48209 | 19258 | 238 |
1192588 | 1192588 | 2021-04-05 | Hays | Texas | 48209 | 19236 | 238 |
1189339 | 1189339 | 2021-04-04 | Hays | Texas | 48209 | 19081 | 236 |
1186092 | 1186092 | 2021-04-03 | Hays | Texas | 48209 | 19081 | 236 |
1182845 | 1182845 | 2021-04-02 | Hays | Texas | 48209 | 19081 | 236 |
1179598 | 1179598 | 2021-04-01 | Hays | Texas | 48209 | 19081 | 236 |
1176351 | 1176351 | 2021-03-31 | Hays | Texas | 48209 | 19040 | 236 |
1173104 | 1173104 | 2021-03-30 | Hays | Texas | 48209 | 19012 | 236 |
1169857 | 1169857 | 2021-03-29 | Hays | Texas | 48209 | 19008 | 236 |
1166609 | 1166609 | 2021-03-28 | Hays | Texas | 48209 | 18916 | 236 |
1163361 | 1163361 | 2021-03-27 | Hays | Texas | 48209 | 18916 | 236 |
1160112 | 1160112 | 2021-03-26 | Hays | Texas | 48209 | 18916 | 236 |
1156865 | 1156865 | 2021-03-25 | Hays | Texas | 48209 | 18888 | 236 |
1153618 | 1153618 | 2021-03-24 | Hays | Texas | 48209 | 18827 | 236 |
1150371 | 1150371 | 2021-03-23 | Hays | Texas | 48209 | 18812 | 235 |
1147124 | 1147124 | 2021-03-22 | Hays | Texas | 48209 | 18777 | 235 |
1143877 | 1143877 | 2021-03-21 | Hays | Texas | 48209 | 18738 | 235 |
1140630 | 1140630 | 2021-03-20 | Hays | Texas | 48209 | 18738 | 235 |
1137384 | 1137384 | 2021-03-19 | Hays | Texas | 48209 | 18738 | 235 |
1134138 | 1134138 | 2021-03-18 | Hays | Texas | 48209 | 18717 | 234 |
1130890 | 1130890 | 2021-03-17 | Hays | Texas | 48209 | 18641 | 233 |
1127643 | 1127643 | 2021-03-16 | Hays | Texas | 48209 | 18636 | 232 |
1124397 | 1124397 | 2021-03-15 | Hays | Texas | 48209 | 18608 | 232 |
1121151 | 1121151 | 2021-03-14 | Hays | Texas | 48209 | 18507 | 232 |
1117904 | 1117904 | 2021-03-13 | Hays | Texas | 48209 | 18507 | 232 |
1114657 | 1114657 | 2021-03-12 | Hays | Texas | 48209 | 18507 | 232 |
1111411 | 1111411 | 2021-03-11 | Hays | Texas | 48209 | 18490 | 231 |
1108165 | 1108165 | 2021-03-10 | Hays | Texas | 48209 | 18452 | 229 |
1104919 | 1104919 | 2021-03-09 | Hays | Texas | 48209 | 18425 | 229 |
1101673 | 1101673 | 2021-03-08 | Hays | Texas | 48209 | 18406 | 229 |
1098427 | 1098427 | 2021-03-07 | Hays | Texas | 48209 | 18318 | 227 |
1095179 | 1095179 | 2021-03-06 | Hays | Texas | 48209 | 18318 | 227 |
1091933 | 1091933 | 2021-03-05 | Hays | Texas | 48209 | 18318 | 227 |
1088687 | 1088687 | 2021-03-04 | Hays | Texas | 48209 | 18271 | 225 |
1085442 | 1085442 | 2021-03-03 | Hays | Texas | 48209 | 18244 | 224 |
1082196 | 1082196 | 2021-03-02 | Hays | Texas | 48209 | 18201 | 221 |
1078950 | 1078950 | 2021-03-01 | Hays | Texas | 48209 | 18138 | 216 |
1075705 | 1075705 | 2021-02-28 | Hays | Texas | 48209 | 18059 | 213 |
1072459 | 1072459 | 2021-02-27 | Hays | Texas | 48209 | 18059 | 213 |
1069213 | 1069213 | 2021-02-26 | Hays | Texas | 48209 | 18059 | 213 |
1065968 | 1065968 | 2021-02-25 | Hays | Texas | 48209 | 18013 | 212 |
1062723 | 1062723 | 2021-02-24 | Hays | Texas | 48209 | 17957 | 209 |
1059478 | 1059478 | 2021-02-23 | Hays | Texas | 48209 | 17895 | 209 |
1056232 | 1056232 | 2021-02-22 | Hays | Texas | 48209 | 17807 | 208 |
1052986 | 1052986 | 2021-02-21 | Hays | Texas | 48209 | 17598 | 202 |
1049739 | 1049739 | 2021-02-20 | Hays | Texas | 48209 | 17598 | 202 |
1046492 | 1046492 | 2021-02-19 | Hays | Texas | 48209 | 17598 | 202 |
1043247 | 1043247 | 2021-02-18 | Hays | Texas | 48209 | 17598 | 202 |
1040002 | 1040002 | 2021-02-17 | Hays | Texas | 48209 | 17598 | 202 |
1036757 | 1036757 | 2021-02-16 | Hays | Texas | 48209 | 17598 | 202 |
1033512 | 1033512 | 2021-02-15 | Hays | Texas | 48209 | 17598 | 202 |
1030266 | 1030266 | 2021-02-14 | Hays | Texas | 48209 | 17598 | 202 |
1027019 | 1027019 | 2021-02-13 | Hays | Texas | 48209 | 17598 | 202 |
1023774 | 1023774 | 2021-02-12 | Hays | Texas | 48209 | 17617 | 202 |
1020529 | 1020529 | 2021-02-11 | Hays | Texas | 48209 | 17617 | 202 |
1017284 | 1017284 | 2021-02-10 | Hays | Texas | 48209 | 17553 | 201 |
1014039 | 1014039 | 2021-02-09 | Hays | Texas | 48209 | 17461 | 200 |
1010794 | 1010794 | 2021-02-08 | Hays | Texas | 48209 | 17338 | 198 |
1007548 | 1007548 | 2021-02-07 | Hays | Texas | 48209 | 17121 | 198 |
1004302 | 1004302 | 2021-02-06 | Hays | Texas | 48209 | 17121 | 198 |
1001056 | 1001056 | 2021-02-05 | Hays | Texas | 48209 | 17121 | 198 |
997810 | 997810 | 2021-02-04 | Hays | Texas | 48209 | 17019 | 195 |
994564 | 994564 | 2021-02-03 | Hays | Texas | 48209 | 16896 | 193 |
991318 | 991318 | 2021-02-02 | Hays | Texas | 48209 | 16834 | 192 |
988072 | 988072 | 2021-02-01 | Hays | Texas | 48209 | 16706 | 190 |
984825 | 984825 | 2021-01-31 | Hays | Texas | 48209 | 16383 | 186 |
981578 | 981578 | 2021-01-30 | Hays | Texas | 48209 | 16383 | 186 |
978332 | 978332 | 2021-01-29 | Hays | Texas | 48209 | 16602 | 186 |
975087 | 975087 | 2021-01-28 | Hays | Texas | 48209 | 16602 | 185 |
971842 | 971842 | 2021-01-27 | Hays | Texas | 48209 | 16395 | 181 |
968597 | 968597 | 2021-01-26 | Hays | Texas | 48209 | 16310 | 177 |
965353 | 965353 | 2021-01-25 | Hays | Texas | 48209 | 16139 | 175 |
962108 | 962108 | 2021-01-24 | Hays | Texas | 48209 | 15535 | 171 |
958863 | 958863 | 2021-01-23 | Hays | Texas | 48209 | 15535 | 171 |
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);