A live sample straight out of our copy of the data. Nothing here is edited: this is exactly what an export gives you.
Out of roughly 277 rows in
texas.pdq_gp_county.
Version obs-38dc684981d3.
county_no | county_fips_code | county_name | district_no | district_name | on_shore_flag | onshore_assc_cnty_flag | ingested_at |
|---|---|---|---|---|---|---|---|
| 363 | 363 | PALO PINTO | 08 | 7B | Y | N | Sept. 6, 2026, 11 p.m. |
| 367 | 367 | PARKER | 08 | 7B | Y | N | Sept. 6, 2026, 11 p.m. |
| 411 | 411 | SAN SABA | 08 | 7B | Y | N | Sept. 6, 2026, 11 p.m. |
| 417 | 417 | SHACKELFORD | 08 | 7B | Y | N | Sept. 6, 2026, 11 p.m. |
| 425 | 425 | SOMERVELL | 08 | 7B | Y | N | Sept. 6, 2026, 11 p.m. |
| 429 | 429 | STEPHENS | 08 | 7B | Y | N | Sept. 6, 2026, 11 p.m. |
| 433 | 433 | STONEWALL | 08 | 7B | Y | N | Sept. 6, 2026, 11 p.m. |
| 441 | 441 | TAYLOR | 08 | 7B | Y | N | Sept. 6, 2026, 11 p.m. |
| 447 | 447 | THROCKMORTON | 08 | 7B | Y | N | Sept. 6, 2026, 11 p.m. |
| 081 | 081 | COKE | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 095 | 095 | CONCHO | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 105 | 105 | CROCKETT | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 235 | 235 | IRION | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 267 | 267 | KIMBLE | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 307 | 307 | MCCULLOCH | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 327 | 327 | MENARD | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 383 | 383 | REAGAN | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 399 | 399 | RUNNELS | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 413 | 413 | SCHLEICHER | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 435 | 435 | SUTTON | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 443 | 443 | TERRELL | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 451 | 451 | TOM GREEN | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 461 | 461 | UPTON | 09 | 7C | Y | N | Sept. 6, 2026, 11 p.m. |
| 013 | 013 | ATASCOSA | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 019 | 019 | BANDERA | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 021 | 021 | BASTROP | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 027 | 027 | BELL | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 029 | 029 | BEXAR | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 031 | 031 | BLANCO | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 053 | 053 | BURNET | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 055 | 055 | CALDWELL | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 091 | 091 | COMAL | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 127 | 127 | DIMMIT | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 137 | 137 | EDWARDS | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 163 | 163 | FRIO | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 171 | 171 | GILLESPIE | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 177 | 177 | GONZALES | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 187 | 187 | GUADALUPE | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 209 | 209 | HAYS | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 259 | 259 | KENDALL | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 265 | 265 | KERR | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 271 | 271 | KINNEY | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 283 | 283 | LA SALLE | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 299 | 299 | LLANO | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 311 | 311 | MCMULLEN | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 319 | 319 | MASON | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 323 | 323 | MAVERICK | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 325 | 325 | MEDINA | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 331 | 331 | MILAM | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 385 | 385 | REAL | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 453 | 453 | TRAVIS | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 463 | 463 | UVALDE | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 465 | 465 | VAL VERDE | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 491 | 491 | WILLIAMSON | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 493 | 493 | WILSON | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 507 | 507 | ZAVALA | 01 | 01 | Y | N | Sept. 6, 2026, 11 p.m. |
| 003 | 003 | ANDREWS | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 043 | 043 | BREWSTER | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 103 | 103 | CRANE | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 109 | 109 | CULBERSON | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 135 | 135 | ECTOR | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 141 | 141 | EL PASO | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 173 | 173 | GLASSCOCK | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 227 | 227 | HOWARD | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 229 | 229 | HUDSPETH | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 243 | 243 | JEFF DAVIS | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 301 | 301 | LOVING | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 317 | 317 | MARTIN | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 329 | 329 | MIDLAND | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 335 | 335 | MITCHELL | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 371 | 371 | PECOS | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 377 | 377 | PRESIDIO | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 389 | 389 | REEVES | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 431 | 431 | STERLING | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 475 | 475 | WARD | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 495 | 495 | WINKLER | 10 | 08 | Y | N | Sept. 6, 2026, 11 p.m. |
| 017 | 017 | BAILEY | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 033 | 033 | BORDEN | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 079 | 079 | COCHRAN | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 101 | 101 | COTTLE | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 107 | 107 | CROSBY | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 115 | 115 | DAWSON | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 125 | 125 | DICKENS | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 153 | 153 | FLOYD | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 165 | 165 | GAINES | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 169 | 169 | GARZA | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 189 | 189 | HALE | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 219 | 219 | HOCKLEY | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 263 | 263 | KENT | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 269 | 269 | KING | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 279 | 279 | LAMB | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 303 | 303 | LUBBOCK | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 305 | 305 | LYNN | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 345 | 345 | MOTLEY | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 415 | 415 | SCURRY | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 445 | 445 | TERRY | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 501 | 501 | YOAKUM | 11 | 8A | Y | N | Sept. 6, 2026, 11 p.m. |
| 009 | 009 | ARCHER | 13 | 09 | Y | N | Sept. 6, 2026, 11 p.m. |
| 023 | 023 | BAYLOR | 13 | 09 | Y | N | Sept. 6, 2026, 11 p.m. |
| 077 | 077 | CLAY | 13 | 09 | Y | N | Sept. 6, 2026, 11 p.m. |
Sampled, not exhaustive — enough to tell whether this is the data you want without making the database read tens of millions of rows.
county_novarchar
065
1
247
1
383
1
121
1
604
1
391
1
039
1
325
1
115
1
033
1
465
1
497
1
county_fips_codevarchar
065
1
247
1
383
1
121
1
604
1
391
1
039
1
325
1
115
1
033
1
465
1
497
1
district_novarchar
03
41
01
33
14
26
05
24
08
24
06
23
04
23
11
21
10
20
13
15
09
14
02
13
county_namevarchar
LAMPASAS
1
MASON
1
LEE
1
KENT
1
DAWSON
1
FISHER
1
PARKER
1
FANNIN
1
GRIMES
1
HARRIS
1
CRANE
1
COCHRAN
1
district_namevarchar
03
41
01
33
10
26
7B
24
05
24
04
23
06
23
8A
21
08
20
09
15
7C
14
02
13
on_shore_flagvarchar
Y
254
N
23
onshore_assc_cnty_flagvarchar
N
265
Y
12
ingested_attimestamptz
Sept. 6, 2026, 11 p.m.
277