ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Galveston" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280250 | 1280250 | 2021-05-02 | Galveston | Texas | 48167 | 39096 | 411 |
1277003 | 1277003 | 2021-05-01 | Galveston | Texas | 48167 | 39033 | 410 |
1273756 | 1273756 | 2021-04-30 | Galveston | Texas | 48167 | 38962 | 409 |
1270509 | 1270509 | 2021-04-29 | Galveston | Texas | 48167 | 38880 | 407 |
1267262 | 1267262 | 2021-04-28 | Galveston | Texas | 48167 | 38808 | 406 |
1264015 | 1264015 | 2021-04-27 | Galveston | Texas | 48167 | 38723 | 406 |
1260768 | 1260768 | 2021-04-26 | Galveston | Texas | 48167 | 38647 | 406 |
1257521 | 1257521 | 2021-04-25 | Galveston | Texas | 48167 | 38647 | 404 |
1254274 | 1254274 | 2021-04-24 | Galveston | Texas | 48167 | 38612 | 404 |
1251027 | 1251027 | 2021-04-23 | Galveston | Texas | 48167 | 38553 | 403 |
1247780 | 1247780 | 2021-04-22 | Galveston | Texas | 48167 | 38491 | 402 |
1244533 | 1244533 | 2021-04-21 | Galveston | Texas | 48167 | 38397 | 401 |
1241286 | 1241286 | 2021-04-20 | Galveston | Texas | 48167 | 38310 | 400 |
1238039 | 1238039 | 2021-04-19 | Galveston | Texas | 48167 | 38196 | 400 |
1234792 | 1234792 | 2021-04-18 | Galveston | Texas | 48167 | 38196 | 400 |
1231544 | 1231544 | 2021-04-17 | Galveston | Texas | 48167 | 38158 | 400 |
1228296 | 1228296 | 2021-04-16 | Galveston | Texas | 48167 | 38128 | 400 |
1225048 | 1225048 | 2021-04-15 | Galveston | Texas | 48167 | 38056 | 399 |
1221801 | 1221801 | 2021-04-14 | Galveston | Texas | 48167 | 38012 | 398 |
1218553 | 1218553 | 2021-04-13 | Galveston | Texas | 48167 | 37941 | 397 |
1215305 | 1215305 | 2021-04-12 | Galveston | Texas | 48167 | 37807 | 397 |
1212058 | 1212058 | 2021-04-11 | Galveston | Texas | 48167 | 37807 | 397 |
1208809 | 1208809 | 2021-04-10 | Galveston | Texas | 48167 | 37747 | 397 |
1205561 | 1205561 | 2021-04-09 | Galveston | Texas | 48167 | 37691 | 397 |
1202313 | 1202313 | 2021-04-08 | Galveston | Texas | 48167 | 37590 | 397 |
1199064 | 1199064 | 2021-04-07 | Galveston | Texas | 48167 | 37525 | 394 |
1195815 | 1195815 | 2021-04-06 | Galveston | Texas | 48167 | 37436 | 393 |
1192567 | 1192567 | 2021-04-05 | Galveston | Texas | 48167 | 37358 | 392 |
1189318 | 1189318 | 2021-04-04 | Galveston | Texas | 48167 | 37358 | 392 |
1186071 | 1186071 | 2021-04-03 | Galveston | Texas | 48167 | 37261 | 392 |
1182824 | 1182824 | 2021-04-02 | Galveston | Texas | 48167 | 37261 | 392 |
1179577 | 1179577 | 2021-04-01 | Galveston | Texas | 48167 | 37190 | 391 |
1176330 | 1176330 | 2021-03-31 | Galveston | Texas | 48167 | 37140 | 389 |
1173083 | 1173083 | 2021-03-30 | Galveston | Texas | 48167 | 37059 | 389 |
1169836 | 1169836 | 2021-03-29 | Galveston | Texas | 48167 | 36946 | 389 |
1166588 | 1166588 | 2021-03-28 | Galveston | Texas | 48167 | 36946 | 389 |
1163340 | 1163340 | 2021-03-27 | Galveston | Texas | 48167 | 36874 | 389 |
1160091 | 1160091 | 2021-03-26 | Galveston | Texas | 48167 | 36788 | 386 |
1156844 | 1156844 | 2021-03-25 | Galveston | Texas | 48167 | 36708 | 386 |
1153597 | 1153597 | 2021-03-24 | Galveston | Texas | 48167 | 36629 | 385 |
1150350 | 1150350 | 2021-03-23 | Galveston | Texas | 48167 | 36559 | 384 |
1147103 | 1147103 | 2021-03-22 | Galveston | Texas | 48167 | 36465 | 384 |
1143856 | 1143856 | 2021-03-21 | Galveston | Texas | 48167 | 36465 | 383 |
1140609 | 1140609 | 2021-03-20 | Galveston | Texas | 48167 | 36383 | 383 |
1137363 | 1137363 | 2021-03-19 | Galveston | Texas | 48167 | 36323 | 382 |
1134117 | 1134117 | 2021-03-18 | Galveston | Texas | 48167 | 36239 | 382 |
1130869 | 1130869 | 2021-03-17 | Galveston | Texas | 48167 | 36197 | 381 |
1127622 | 1127622 | 2021-03-16 | Galveston | Texas | 48167 | 36111 | 377 |
1124376 | 1124376 | 2021-03-15 | Galveston | Texas | 48167 | 35983 | 374 |
1121130 | 1121130 | 2021-03-14 | Galveston | Texas | 48167 | 35983 | 373 |
1117883 | 1117883 | 2021-03-13 | Galveston | Texas | 48167 | 35860 | 372 |
1114636 | 1114636 | 2021-03-12 | Galveston | Texas | 48167 | 35770 | 370 |
1111390 | 1111390 | 2021-03-11 | Galveston | Texas | 48167 | 35686 | 369 |
1108144 | 1108144 | 2021-03-10 | Galveston | Texas | 48167 | 35597 | 367 |
1104898 | 1104898 | 2021-03-09 | Galveston | Texas | 48167 | 35461 | 361 |
1101652 | 1101652 | 2021-03-08 | Galveston | Texas | 48167 | 35354 | 357 |
1098406 | 1098406 | 2021-03-07 | Galveston | Texas | 48167 | 35354 | 357 |
1095158 | 1095158 | 2021-03-06 | Galveston | Texas | 48167 | 35261 | 356 |
1091912 | 1091912 | 2021-03-05 | Galveston | Texas | 48167 | 35073 | 355 |
1088666 | 1088666 | 2021-03-04 | Galveston | Texas | 48167 | 34998 | 354 |
1085421 | 1085421 | 2021-03-03 | Galveston | Texas | 48167 | 34896 | 347 |
1082175 | 1082175 | 2021-03-02 | Galveston | Texas | 48167 | 34736 | 344 |
1078929 | 1078929 | 2021-03-01 | Galveston | Texas | 48167 | 34591 | 341 |
1075684 | 1075684 | 2021-02-28 | Galveston | Texas | 48167 | 34591 | 341 |
1072438 | 1072438 | 2021-02-27 | Galveston | Texas | 48167 | 34431 | 337 |
1069192 | 1069192 | 2021-02-26 | Galveston | Texas | 48167 | 34269 | 337 |
1065947 | 1065947 | 2021-02-25 | Galveston | Texas | 48167 | 34137 | 336 |
1062702 | 1062702 | 2021-02-24 | Galveston | Texas | 48167 | 33958 | 335 |
1059457 | 1059457 | 2021-02-23 | Galveston | Texas | 48167 | 33666 | 332 |
1056211 | 1056211 | 2021-02-22 | Galveston | Texas | 48167 | 33666 | 331 |
1052965 | 1052965 | 2021-02-21 | Galveston | Texas | 48167 | 33666 | 331 |
1049718 | 1049718 | 2021-02-20 | Galveston | Texas | 48167 | 33562 | 328 |
1046471 | 1046471 | 2021-02-19 | Galveston | Texas | 48167 | 33525 | 327 |
1043226 | 1043226 | 2021-02-18 | Galveston | Texas | 48167 | 33142 | 324 |
1039981 | 1039981 | 2021-02-17 | Galveston | Texas | 48167 | 33142 | 322 |
1036736 | 1036736 | 2021-02-16 | Galveston | Texas | 48167 | 33142 | 322 |
1033491 | 1033491 | 2021-02-15 | Galveston | Texas | 48167 | 33142 | 322 |
1030245 | 1030245 | 2021-02-14 | Galveston | Texas | 48167 | 33142 | 321 |
1026998 | 1026998 | 2021-02-13 | Galveston | Texas | 48167 | 33067 | 320 |
1023753 | 1023753 | 2021-02-12 | Galveston | Texas | 48167 | 32846 | 317 |
1020508 | 1020508 | 2021-02-11 | Galveston | Texas | 48167 | 32668 | 313 |
1017263 | 1017263 | 2021-02-10 | Galveston | Texas | 48167 | 32476 | 309 |
1014018 | 1014018 | 2021-02-09 | Galveston | Texas | 48167 | 32317 | 304 |
1010773 | 1010773 | 2021-02-08 | Galveston | Texas | 48167 | 32106 | 301 |
1007527 | 1007527 | 2021-02-07 | Galveston | Texas | 48167 | 32106 | 301 |
1004281 | 1004281 | 2021-02-06 | Galveston | Texas | 48167 | 31958 | 301 |
1001035 | 1001035 | 2021-02-05 | Galveston | Texas | 48167 | 31758 | 298 |
997789 | 997789 | 2021-02-04 | Galveston | Texas | 48167 | 31468 | 296 |
994543 | 994543 | 2021-02-03 | Galveston | Texas | 48167 | 31273 | 296 |
991297 | 991297 | 2021-02-02 | Galveston | Texas | 48167 | 30904 | 292 |
988051 | 988051 | 2021-02-01 | Galveston | Texas | 48167 | 30529 | 290 |
984804 | 984804 | 2021-01-31 | Galveston | Texas | 48167 | 30529 | 290 |
981557 | 981557 | 2021-01-30 | Galveston | Texas | 48167 | 30376 | 287 |
978311 | 978311 | 2021-01-29 | Galveston | Texas | 48167 | 30058 | 285 |
975066 | 975066 | 2021-01-28 | Galveston | Texas | 48167 | 29713 | 280 |
971821 | 971821 | 2021-01-27 | Galveston | Texas | 48167 | 29485 | 275 |
968576 | 968576 | 2021-01-26 | Galveston | Texas | 48167 | 29319 | 270 |
965332 | 965332 | 2021-01-25 | Galveston | Texas | 48167 | 28878 | 268 |
962087 | 962087 | 2021-01-24 | Galveston | Texas | 48167 | 28878 | 268 |
958842 | 958842 | 2021-01-23 | Galveston | Texas | 48167 | 28624 | 267 |
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);