First 100 rows

Out of roughly 232K rows in texas.pd_gas_well. Version obs-22a28e82ea2c.

First 100 rows of texas.pd_gas_well, 7 columns wide
districtgas_rrc_idgas_codegas_oldest_eom_balancecond_oldest_eom_balanceliquid_oldest_eom_balanceundoc_packed_27
012G0000
018G0000
0111G0000
0113G0000
0114G0000
0117G0000
0119G0000
0120G0000
0121G0000
0122G0000
0123G0000
0124G0000
0125G0000
0126G0000
0127G0000
0129G0000
0130G0000
0131G0000
0132G0000
0133G0000
0134G0000
0135G0000
0136G0000
0137G0000
0138G0000
0139G0000
0140G0000
0141G0000
0142G0000
0143G0000
0144G0000
0145G0000
0146G0000
0147G0000
0148G0000
0149G0000
0150G0000
0151G0000
0152G0000
0153G0000
0154G0000
0155G0000
0156G0000
0157G0000
0158G0000
0159G0000
0160G0000
0161G0000
0162G0000
0163G0000
0164G0000
0166G0000
0170G0000
0172G0000
0174G0000
0177G0000
0180G0000
0181G0000
0185G0000
0186G0000
0187G0000
0188G0000
0189G0000
0190G0000
0191G0000
0192G0000
0195G0000
0199G0000
01116G0000
01124G0000
01125G0000
01126G0000
01127G0000
01128G0000
01129G0000
01130G0000
01131G0000
01132G0000
01133G0000
01135G0000
01149G0000
01157G0000
01158G0000
01159G0000
01160G0000
01165G0000
01166G0000
01171G0000
01172G0000
01173G0000
01174G03200
01175G0000
01177G0000
01179G0000
01186G0000
01187G0000
01189G0000
01193G0000
01196G0000
01198G0000

What is in each column

Sampled, not exhaustive — enough to tell whether this is the data you want without making the database read tens of millions of rows.

district

varchar

Sampled
50K
Distinct
3
  • 02 20.2K
  • 03 16.3K
  • 01 13.5K

gas_rrc_id

int4

Sampled
50K
Distinct
50K
  • 47436 1
  • 269565 1
  • 86446 1
  • 160690 1
  • 220674 1
  • 155976 1
  • 271613 1
  • 183585 1
  • 279392 1
  • 274092 1
  • 257631 1
  • 188163 1

gas_code

varchar

Sampled
50K
Distinct
1
  • G 50K

gas_oldest_eom_balance

int4

Sampled
50K
Distinct
1.3K
  • 0 48.6K
  • 1 6
  • 51 5
  • 30 5
  • 143 4
  • 20 4
  • 79 4
  • 59 3
  • 8 3
  • 2 3
  • 13 3
  • 89 3

cond_oldest_eom_balance

int4

Sampled
50K
Distinct
584
  • 0 39.6K
  • 1 418
  • 2 317
  • 3 289
  • 4 274
  • 5 262
  • 7 235
  • 6 229
  • 8 200
  • 9 182
  • 11 174
  • 10 174

liquid_oldest_eom_balance

int4

Sampled
50K
Distinct
1
  • 0 50K

undoc_packed_27

int4

Sampled
50K
Distinct
710
  • 0 47.7K
  • 6082844 139
  • 2656000 98
  • 812151 78
  • 536223 53
  • 70400 45
  • 32000 38
  • 241503 35
  • 912000 35
  • 870511 35
  • 637335 34
  • 64000 30

Take it away

Back to everything we know about Statewide Production Data — Gas