First 2 rows

Out of roughly 2 rows in texas.pdq_og_county_cycle. Version obs-b847745374ce.

county_nodistrict_nocycle_yearcycle_monthcycle_year_monthcnty_oil_prod_volcnty_oil_allowcnty_oil_ending_balcnty_gas_prod_volcnty_gas_allowcnty_gas_lift_inj_volcnty_cond_prod_volcnty_cond_limitcnty_cond_ending_balcnty_csgd_prod_volcnty_csgd_limitcnty_csgd_gas_liftcnty_oil_tot_dispcnty_gas_tot_dispcnty_cond_tot_dispcnty_csgd_tot_dispcounty_namedistrict_nameoil_gas_codeingested_at
195142008112008110nullnull1758686nullnull1646nullnull0nullnullnullnullnullnullHANSFORD10GJuly 13, 2026, 3:53 a.m.
353101995061995060nullnull2029nullnull72nullnull0nullnullnullnullnullnullNOLAN08GJuly 13, 2026, 3:55 a.m.

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.

county_no

varchar

Sampled
2
Distinct
2
  • 195 1
  • 353 1

cycle_year_month

varchar

Sampled
2
Distinct
2
  • 199506 1
  • 200811 1

district_no

varchar

Sampled
2
Distinct
2
  • 10 1
  • 14 1

oil_gas_code

varchar

Sampled
2
Distinct
1
  • G 2

cycle_year

varchar

Sampled
2
Distinct
2
  • 1995 1
  • 2008 1

cycle_month

varchar

Sampled
2
Distinct
2
  • 06 1
  • 11 1

cnty_oil_prod_vol

int8

Sampled
2
Distinct
1
  • 0 2

cnty_oil_allow

int8

Sampled
2
Distinct
0
Empty
1.0

Take it away

Back to everything we know about PDQ County Production by Cycle