Preview PDQ Lease Summary (master)

First 100 rows

Out of roughly 1.1M rows in texas.pdq_og_summary_master_large. Version obs-34ca1c475736.

First 100 rows of `texas.pdq_og_summary_master_large`, 12 columns wide
`oil_gas_code`	`district_no`	`lease_no`	`operator_no`	`field_no`	`cycle_year_month_min`	`cycle_year_month_max`	`district_name`	`lease_name`	`operator_name`	`field_name`	`ingested_at`
G	01	293671	253162	27135700	202207	202609	01	SHENANDOAH E	EOG RESOURCES, INC.	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
G	01	293188	085408	27135700	202206	202609	01	STS C-STS NORTH 12	BPX OPERATING COMPANY	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
G	01	297283	102886	27135700	202503	202609	01	ALTITO A 25A UNIT	VERDUN OIL EF II LLC	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
G	01	299825	728874	27135700	202409	202609	01	BRACKEN NORTH	ROSEWOOD RESOURCES, INC.	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
G	03	071081	847710	71940142	200806	202609	03	PLEDGER GAS FIELD UNIT	TEXAS PETROLEUM INVESTMENT CO.	PLEDGER (FRIO 6500-6800)	Sept. 6, 2026, 11:02 p.m.
G	03	159507	521544	34733500	202510	202609	03	MEYER, B. UNIT	MAGNOLIA OIL & GAS OPERATING LLC	GIDDINGS (AUSTIN CHALK-3)	Sept. 6, 2026, 11:02 p.m.
G	03	159991	521544	34733500	202510	202609	03	NEUMANN UNIT	MAGNOLIA OIL & GAS OPERATING LLC	GIDDINGS (AUSTIN CHALK-3)	Sept. 6, 2026, 11:02 p.m.
G	03	206394	073161	09571600	200912	202603	03	ST 369 L NE/4	BLACK ELK ENERGY OFFSHORE OP LLC	BLOCK 368-L (5250 F.B.-1)	Sept. 6, 2026, 11:02 p.m.
G	03	294692	521544	34733500	202510	202609	03	PRUEGNER UNIT	MAGNOLIA OIL & GAS OPERATING LLC	GIDDINGS (AUSTIN CHALK-3)	Sept. 6, 2026, 11:02 p.m.
G	03	278886	668802	00006001	201501	202609	03	HBR RUBEL	POCO LLC	WILDCAT	Sept. 6, 2026, 11:02 p.m.
G	03	301673	521516	55468430	202607	202609	03	ANDERSON	MAGNUM PRODUCING, LP	LUCKY (SLOAN)	Sept. 6, 2026, 11:02 p.m.
G	04	087777	029652	16724300	202101	202609	04	MARTIN, S.J.	ARETE OPERATING COMPANY II, LLC	CERRITO CREEK (LOBO CONS.)	Sept. 6, 2026, 11:02 p.m.
G	04	144564	386310	50925015	201601	202609	04	CANALES	HILCORP ENERGY COMPANY	LA PERLA (LOBO CONS.)	Sept. 6, 2026, 11:02 p.m.
G	04	139638	386310	04789237	201601	202609	04	B.M.T.	HILCORP ENERGY COMPANY	B.M.T. (LOBO CONS.)	Sept. 6, 2026, 11:02 p.m.
G	04	140870	386310	04789237	201601	202609	04	SALDIVAR ESTATE	HILCORP ENERGY COMPANY	B.M.T. (LOBO CONS.)	Sept. 6, 2026, 11:02 p.m.
G	04	155199	019786	71723426	201001	202609	04	PITA ISLAND FIELD GAS UNIT NO. 2	AMERRIL ENERGY LLC	PITA ISLAND (I-79)	Sept. 6, 2026, 11:02 p.m.
G	04	146275	386310	05993600	201409	202609	04	C-BRUNI MINERAL TRUST	HILCORP ENERGY COMPANY	BASHARA-HEREFORD (7300)	Sept. 6, 2026, 11:02 p.m.
G	04	171431	386310	93215400	201601	202609	04	VERGARA, G. B.	HILCORP ENERGY COMPANY	VAQUILLAS RANCH (LOBO CONS.)	Sept. 6, 2026, 11:02 p.m.
G	04	184470	879035	67346360	201407	202604	04	WELDER RANCH	URBAN OIL & GAS GROUP, LLC	ONEIL (5300)	Sept. 6, 2026, 11:02 p.m.
G	04	227246	627136	54889200	202305	202609	04	PEAL RANCH	ORX RESOURCES, L.L.C.	LOPEZ, SE. (CONSOLIDATED)	Sept. 6, 2026, 11:02 p.m.
G	05	250920	386310	30321300	202401	202609	05	GEORGE FULTON GAS UNIT NO. 1	HILCORP ENERGY COMPANY	FARRAR (COTTON VALLEY LIME)	Sept. 6, 2026, 11:02 p.m.
G	04	266025	460054	55878300	201208	202609	04	HALL, C. M. -A-	KILLAM OIL CO., LTD.	LYDA (VICKSBURG LOWER)	Sept. 6, 2026, 11:02 p.m.
G	04	274874	789662	99549001	201405	202603	04	CHAPOTAL LAND CO. A	SMITH PRODUCTION INC.	YTURRIA	Sept. 6, 2026, 11:02 p.m.
G	05	170049	386310	24478379	202401	202609	05	GLAZENER, WILLIAM C. GU	HILCORP ENERGY COMPANY	DEW (TRAVIS PEAK)	Sept. 6, 2026, 11:02 p.m.
G	05	192734	386310	30321300	202401	202609	05	CHANDLER GAS UNIT NO. 1	HILCORP ENERGY COMPANY	FARRAR (COTTON VALLEY LIME)	Sept. 6, 2026, 11:02 p.m.
G	06	170195	106406	52002800	202504	202609	06	WILLIAMS, IVY HEIRS	BUFFCO PRODUCTION INC.	LANSING, NORTH (TRAVIS PEAK)	Sept. 6, 2026, 11:02 p.m.
G	05	230639	386310	30321300	202401	202609	05	FULTON, GEORGE GAS UNIT NO. 1	HILCORP ENERGY COMPANY	FARRAR (COTTON VALLEY LIME)	Sept. 6, 2026, 11:02 p.m.
G	05	229210	386310	30321300	202401	202609	05	BEACHCOMBER GAS UNIT NO. 2	HILCORP ENERGY COMPANY	FARRAR (COTTON VALLEY LIME)	Sept. 6, 2026, 11:02 p.m.
G	06	179588	945936	07528500	200603	202609	06	LAWLESS UNIT	XTO ENERGY INC.	BETHANY, EAST (COTTON VALLEY)	Sept. 6, 2026, 11:02 p.m.
G	06	196059	101804	67849150	202607	202609	06	LYLES	WTR OPERATING LLC	OVERTON (COTTON VALLEY SAND)	Sept. 6, 2026, 11:02 p.m.
G	06	225466	775851	07528500	202001	202604	06	LEWIS UNIT	SHERIDAN PRODUCTION CO III, LLC	BETHANY, EAST (COTTON VALLEY)	Sept. 6, 2026, 11:02 p.m.
G	06	244545	101634	61792380	202601	202609	06	YOUNGBLOOD, ROBERT	EQV OPERATING LLC	MINDEN (TRAVIS PEAK CONS.)	Sept. 6, 2026, 11:02 p.m.
G	06	298645	103925	61792380	202601	202601	06	SPIKES GAS UNIT NO. 1	SABINE ENERGY INC.	MINDEN (TRAVIS PEAK CONS.)	Sept. 6, 2026, 11:02 p.m.
G	06	267761	101634	40356200	202601	202609	06	BESS RAYFORD GU - SILER HEIRS GU	EQV OPERATING LLC	HENDERSON, E. (COTTON VALLEY)	Sept. 6, 2026, 11:02 p.m.
G	09	030762	386310	28278333	202605	202609	7C	WHITTEN -A-	HILCORP ENERGY COMPANY	ELDORADO (CANYON)	Sept. 6, 2026, 11:02 p.m.
G	08	247145	695232	85948100	201604	202609	7B	PILGRIM	RAY HERRING OPERATING CO., LLC	STEPHENS COUNTY REGULAR (GAS)	Sept. 6, 2026, 11:02 p.m.
G	08	171499	453142	85948100	199809	202609	7B	HARRIS, MAGGIE ET AL	KEATING ENERGY, INC.	STEPHENS COUNTY REGULAR (GAS)	Sept. 6, 2026, 11:02 p.m.
G	09	148636	875310	84646500	201904	202609	7C	WARD	UPP OPERATING, LLC	SONORA (CANYON UPPER)	Sept. 6, 2026, 11:02 p.m.
G	10	139649	285002	70129116	202405	202609	08	REDMOND "B"	FREE REIN OPERATING LLC	PECOS VALLEY (DEVONIAN)	Sept. 6, 2026, 11:02 p.m.
G	09	232626	760218	23365750	202502	202609	7C	DAVIDSON A	SCOUT ENERGY MANAGEMENT LLC	DAVIDSON RANCH (PENN. 7890)	Sept. 6, 2026, 11:02 p.m.
G	09	239775	760218	23365750	202502	202609	7C	WILKINS "A"	SCOUT ENERGY MANAGEMENT LLC	DAVIDSON RANCH (PENN. 7890)	Sept. 6, 2026, 11:02 p.m.
G	13	283611	328354	05430438	202607	202609	09	CANTWELL, J. A.	GREAT AMERICAN RESOURCES INC.	BANDERA-LILA-LYN (VIOLA)	Sept. 6, 2026, 11:02 p.m.
G	14	096150	465296	38797558	202104	202609	10	PORTER	KING OPERATING CORPORATION	HANSFORD (MORROW, LOWER)	Sept. 6, 2026, 11:02 p.m.
O	01	16390	881167	27135700	201210	202609	01	JEANES-JPP UNIT (ALLOC)	VALENCE OPERATING COMPANY	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
G	14	221237	488260	38797558	202002	202609	10	YANDA ET AL GU	LATIGO PETROLEUM, LLC	HANSFORD (MORROW, LOWER)	Sept. 6, 2026, 11:02 p.m.
O	01	16222	037775	27135700	201806	202609	01	TINSLEY	AUTERRA OPERATING, LLC	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	01	15614	424176	27135700	202304	202609	01	THURMAN NORTH LAS	INEOS USA OIL & GAS LLC	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	01	06406	102118	88824001	202408	202609	01	BROWN, SADIE	AMS ENERGY SOLUTIONS LLP	TENNEY CREEK	Sept. 6, 2026, 11:02 p.m.
O	01	16739	424176	27135700	202304	202609	01	GRAY UNIT I LAS	INEOS USA OIL & GAS LLC	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	01	16122	521544	27135700	202412	202609	01	CROZIER WILLIAMSON UNIT	MAGNOLIA OIL & GAS OPERATING LLC	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	01	18695	102886	27135700	202503	202609	01	WHITWELL M UNIT	VERDUN OIL EF II LLC	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	01	17204	870209	27135700	201809	202609	01	FORREST WHEELER 'B'	TRINITY OPERATING (USG), LLC	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	01	19204	100351	27135700	202502	202609	01	BROWN TRUST-SS ALLOC E	JAVELIN ENERGY PARTNERS MGMT LLC	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	01	19200	424176	27135700	202304	202609	01	JEA HC6 LAS	INEOS USA OIL & GAS LLC	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	01	18530	594675	27135700	201504	202609	01	MCCOMAS UNIT D	MURPHY EXPL. & PROD. CO. - USA	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	01	20240	253162	27135700	202001	202609	01	ALBACORE C	EOG RESOURCES, INC.	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	01	20185	525398	27135700	202003	202609	01	DEATLEY HOLLUB MAY SA 3	MARATHON OIL EF LLC	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	01	21351	253162	27135700	202404	202609	01	COOK N	EOG RESOURCES, INC.	EAGLEVILLE (EAGLE FORD-1)	Sept. 6, 2026, 11:02 p.m.
O	03	16577	521544	34733500	202109	202609	03	ROHDE UNIT	MAGNOLIA OIL & GAS OPERATING LLC	GIDDINGS (AUSTIN CHALK-3)	Sept. 6, 2026, 11:02 p.m.
O	03	21788	923444	34733500	202303	202609	03	LISA-HERRMANN	WILDFIRE ENERGY OPERATING LLC	GIDDINGS (AUSTIN CHALK-3)	Sept. 6, 2026, 11:02 p.m.
O	03	15144	521544	34733500	202109	202609	03	HAVEMANN UNIT	MAGNOLIA OIL & GAS OPERATING LLC	GIDDINGS (AUSTIN CHALK-3)	Sept. 6, 2026, 11:02 p.m.
O	03	23133	923444	34733500	202303	202609	03	KRUG UNIT	WILDFIRE ENERGY OPERATING LLC	GIDDINGS (AUSTIN CHALK-3)	Sept. 6, 2026, 11:02 p.m.
O	03	22739	567103	93832062	200104	202609	03	EAST TEXAS OIL CO. FEE "C"	MILESTONE OPERATING, INC.	VILLAGE MILLS EAST (Q)	Sept. 6, 2026, 11:02 p.m.
O	03	18842	253480	97502500	199405	202609	03	MORTON "A"	ERNEST OPERATING COMPANY	WILLARD (NAVARRO)	Sept. 6, 2026, 11:02 p.m.
O	03	20877	923444	34733500	202303	202609	03	SCARMARDO, SANDYR	WILDFIRE ENERGY OPERATING LLC	GIDDINGS (AUSTIN CHALK-3)	Sept. 6, 2026, 11:02 p.m.
O	03	19304	923444	34733500	202303	202609	03	RYCHLIK, E. "A"	WILDFIRE ENERGY OPERATING LLC	GIDDINGS (AUSTIN CHALK-3)	Sept. 6, 2026, 11:02 p.m.
O	03	22661	521544	34733500	201808	202609	03	EHLERT UNIT NO. 1	MAGNOLIA OIL & GAS OPERATING LLC	GIDDINGS (AUSTIN CHALK-3)	Sept. 6, 2026, 11:02 p.m.
O	03	28273	923444	34733500	202602	202609	03	JUSTICE	WILDFIRE ENERGY OPERATING LLC	GIDDINGS (AUSTIN CHALK-3)	Sept. 6, 2026, 11:02 p.m.
O	06	10292	097320	77807280	199301	202609	06	LODI GAS UNIT #2	BROOKS OIL COMPANY	RODESSA (GLOYD)	Sept. 6, 2026, 11:02 p.m.
O	05	02123	427617	71908500	201803	202609	05	WARD, SEALE, ET AL	J.F.W. EQUIPMENT, INC.	PLEASANT RIDGE (WOODBINE)	Sept. 6, 2026, 11:02 p.m.
O	08	21638	830282	57186125	199501	202609	7B	O'CONNOR	SUPERIOR OPERATING COMPANY	MANNING-OCONNOR (BEND CONGL.)	Sept. 6, 2026, 11:02 p.m.
O	06	15675	486640	61792380	201902	202609	06	BEARDEN	LARGO OIL COMPANY	MINDEN (TRAVIS PEAK CONS.)	Sept. 6, 2026, 11:02 p.m.
O	06	15136	103925	61792380	202601	202609	06	COBRA #2	SABINE ENERGY INC.	MINDEN (TRAVIS PEAK CONS.)	Sept. 6, 2026, 11:02 p.m.
O	06	15667	195834	30035400	201807	202609	06	HAMILL FOUNDATION , ET AL	CYPRESS OPERATING, INC.	FAIRWAY (MASSIVE ANHYDRITE)	Sept. 6, 2026, 11:02 p.m.
O	08	20021	100298	02376001	201502	202609	7B	ROBERTSON, I. W. ESTATE	BROWN INDUSTRIAL GAS OP, INC.	AMITY	Sept. 6, 2026, 11:02 p.m.
O	08	22800	708778	16916700	199402	202609	7B	BILLINGS	RICHARDSON RESOURCES INC	CHANEY-YOCHAM (UPPER GRAY)	Sept. 6, 2026, 11:02 p.m.
O	08	30655	101718	46840500	202401	202609	7B	TSCHACHER	GRAYROCK ENERGY II, LLC	JOHN DAN (NOODLE CREEK LIME)	Sept. 6, 2026, 11:02 p.m.
O	10	42337	646827	62718690	202109	202609	08	THORPE 1-74 LOV	PDEH LLC	MOORE-HOOPER (WLFCMP\PENN CONS)	Sept. 6, 2026, 11:02 p.m.
O	10	34371	108799	20101500	202201	202609	08	STERLING 'Y' FEE	BURK ROYALTY CO., LTD.	CONGER, SW (PENN)	Sept. 6, 2026, 11:02 p.m.
O	11	61622	473105	55975600	199301	202609	8A	MORRISON "B"	KNOX INDUSTRIES, INC.	LYN-KAY (6200)	Sept. 6, 2026, 11:02 p.m.
O	10	32541	760960	73933500	200206	202609	08	QUITO WEST UNIT	SEABOARD OPERATING CO.	QUITO, WEST (DELAWARE)	Sept. 6, 2026, 11:02 p.m.
O	10	62103	825820	33998500	202509	202609	08	XRAY	STRAWN PETROLEUM OPERATING, LLC	GARDEN CITY, S. (WOLFCAMP)	Sept. 6, 2026, 11:02 p.m.
O	11	61723	040209	49460500	202509	202609	8A	COVINGTON, JANIE ET AL	BCE-MACH III LLC	KINGDOM (ABO REEF)	Sept. 6, 2026, 11:02 p.m.
O	14	03271	487415	68887001	200003	202609	10	TARBOX -A-	LASATER & CO, INC.	PANHANDLE HUTCHINSON COUNTY FLD.	Sept. 6, 2026, 11:02 p.m.
O	13	17710	108799	97331001	202205	202609	09	WAGGONER DM	BURK ROYALTY CO., LTD.	WILBARGER COUNTY REGULAR	Sept. 6, 2026, 11:02 p.m.
O	14	01616	486623	68887001	202110	202609	10	HILL	LARGE OPERATING LLC	PANHANDLE HUTCHINSON COUNTY FLD.	Sept. 6, 2026, 11:02 p.m.
O	13	30398	887951	79656050	202602	202609	09	PHILLIPS	W&W OIL AND GAS, INC.	ST. JO RIDGE (BARNETT SHALE)	Sept. 6, 2026, 11:02 p.m.
O	13	31899	186660	43431600	202605	202609	09	WILSON SPR	CRAMPTON, FREDDIE	HULL-SILK-SIKES (ELLEN)	Sept. 6, 2026, 11:02 p.m.
O	14	04077	108799	68887001	202605	202609	10	PERKY	BURK ROYALTY CO., LTD.	PANHANDLE HUTCHINSON COUNTY FLD.	Sept. 6, 2026, 11:02 p.m.
G	02	219427	386310	90534315	200601	202609	02	O'CONNOR, THOMAS "C"	HILCORP ENERGY COMPANY	TOM OCONNOR (4200)	Sept. 6, 2026, 11:02 p.m.
G	02	244796	260268	69845200	202601	202609	02	JOHNSTON GAS UNIT 1	FALCON PRODUCTION LLC	PAWNEE (EDWARDS)	Sept. 6, 2026, 11:02 p.m.
G	02	283778	525398	86950600	201604	202609	02	SIENKIEWICZ UNIT	MARATHON OIL EF LLC	SUGARKANE (EAGLE FORD)	Sept. 6, 2026, 11:02 p.m.
G	02	231079	386310	90534001	200709	202609	02	LAMBERT, M. F.	HILCORP ENERGY COMPANY	TOM OCONNOR	Sept. 6, 2026, 11:02 p.m.
G	02	277286	525398	86950600	201502	202609	02	LUNA UNIT	MARATHON OIL EF LLC	SUGARKANE (EAGLE FORD)	Sept. 6, 2026, 11:02 p.m.
G	02	301458	103593	86950600	202602	202609	02	THREE RIVERS UNIT C	CATURUS ENERGY, LLC	SUGARKANE (EAGLE FORD)	Sept. 6, 2026, 11:02 p.m.
G	02	289567	525398	86950600	201407	202609	02	REYNOLDS GAS UNIT 1	MARATHON OIL EF LLC	SUGARKANE (EAGLE FORD)	Sept. 6, 2026, 11:02 p.m.
G	02	282123	703462	86950600	201912	202609	02	WESSENDORFF 5-WESSENDORFF 7 (SA)	REPSOL OIL & GAS USA, LLC	SUGARKANE (EAGLE FORD)	Sept. 6, 2026, 11:02 p.m.
G	02	280399	525398	86950600	202303	202609	02	OETKEN 01	MARATHON OIL EF LLC	SUGARKANE (EAGLE FORD)	Sept. 6, 2026, 11:02 p.m.
G	02	295684	703462	86950600	202301	202609	02	ROYAL UNIT B-SMITH (SA) D3	REPSOL OIL & GAS USA, LLC	SUGARKANE (EAGLE FORD)	Sept. 6, 2026, 11:02 p.m.
G	04	192864	386310	39818250	201301	202609	04	JACOBA	HILCORP ENERGY COMPANY	HAYNES (MIDDLE WILCOX CONS.)	Sept. 6, 2026, 11:02 p.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.

`oil_gas_code`

varchar

Sampled: 50K
Distinct: 1

G 50K

`district_no`

varchar

Sampled: 50K
Distinct: 2

01 33.7K
02 16.3K

`lease_no`

varchar

Sampled: 50K
Distinct: 19.3K

139234 15
116557 13
079465 13
141534 13
100629 13
113782 13
067270 13
103176 13
100977 13
096618 13
098582 13
111599 12

`operator_no`

varchar

Sampled: 50K
Distinct: 2.6K

100351 1.7K
020528 1.7K
797102 1.7K
499978 1.6K
781915 1.3K
833348 936
103575 833
788997 828
085408 600
020542 571
147699 541
102824 538

`field_no`

varchar

Sampled: 50K
Distinct: 3.9K

12018200 10K
39744500 4K
00256500 2.7K
27135700 2K
87251500 851
83704300 656
00002001 620
54928500 514
16340500 456
30379500 417
07856250 383
93874100 372

`cycle_year_month_min`

int8

Sampled: 50K
Distinct: 404

199301 6.3K
201904 467
200801 459
201410 451
201301 369
200004 369
202001 346
202605 331
202401 303
201411 290
200204 288
200212 287

`cycle_year_month_max`

int8

Sampled: 50K
Distinct: 405

202609 11K
201409 461
200712 377
201903 374
200003 371
200308 361
201212 351
201912 348
202604 347
200112 286
202009 269
201410 269

`district_name`

varchar

Sampled: 50K
Distinct: 13

08 6.6K
04 5.8K
09 5.6K
7C 5.5K
06 5.4K
10 4.7K
03 3.8K
01 3.3K
7B 3.2K
02 2.6K
05 1.9K
8A 1.3K

Take it away

Back to everything we know about PDQ Lease Summary (master)