Preview: Certificate of Authorization P-4 (Oil and Gas)

First 100 rows

Out of roughly 548.1K rows in texas.p4_lease. Version obs-ee2c22bafb4c.

First 100 rows of `texas.p4_lease`, 18 columns wide
`oil_gas_code`	`district_no`	`lease_rrcid`	`district`	`field_no`	`off_schedule`	`operator_no`	`remove_reason`	`remove_date`	`stock_on_hand`	`sched_sequence_key`	`sched_sequence_date`	`land_bore_cnt`	`lease_total_depth`
G	01	1	01	621666	Y	739425	06	Sept. 1, 1977	N	99999999	null	0	0
G	01	2	01	2568001	N	342800	null	null	N	79759486	May 13, 2024	1	3748
G	01	3	01	3144500	Y	245800	01	June 1, 1987	N	99999999	null	0	0
G	01	4	01	4391500	Y	302450	99	Oct. 21, 1977	N	99999999	null	0	0
G	01	5	01	4462666	Y	357100	07	Dec. 1, 1978	N	80228996	Oct. 3, 1977	0	0
G	01	6	01	4462666	Y	357130	01	Oct. 1, 1967	N	99999999	null	0	0
G	01	7	01	5122500	Y	731510	99	Oct. 21, 1977	N	99999999	null	0	0
G	01	8	01	5434500	Y	614700	06	Sept. 1, 1991	N	80229598	April 1, 1977	0	0
G	01	9	01	5434500	Y	614700	01	June 1, 1969	N	99999999	null	0	0
G	01	10	01	5434500	Y	614700	01	June 1, 1969	N	99999999	null	0	0
G	01	11	01	6096500	Y	880285	01	Feb. 27, 1993	N	80229598	April 1, 1977	0	0
G	01	12	01	6099500	Y	412930	01	Dec. 1, 1968	N	99999999	null	0	0
G	01	13	01	7856250	Y	886261	01	Aug. 6, 2009	N	80229598	April 1, 1977	1	3422
G	01	14	01	7856250	Y	886261	01	Sept. 28, 2022	N	80229598	April 1, 1977	1	3001
G	01	15	01	7856250	Y	926160	01	Feb. 1, 1987	N	80168869	Nov. 30, 1983	0	0
G	01	17	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3085
G	01	18	01	7856250	Y	286680	99	Jan. 1, 1912	N	99999999	null	0	0
G	01	19	01	7856250	Y	876645	01	March 4, 1996	N	80229598	April 1, 1977	0	0
G	01	20	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3061
G	01	21	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	2930
G	01	22	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3182
G	01	23	01	7856250	Y	886261	01	Aug. 28, 2019	N	80229598	April 1, 1977	1	3172
G	01	24	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3050
G	01	25	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3042
G	01	26	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3029
G	01	27	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	2990
G	01	28	01	7856250	Y	828328	07	July 1, 1981	N	80229598	April 1, 1977	0	0
G	01	29	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3050
G	01	30	01	7856250	Y	886261	01	May 1, 2017	N	80229598	April 1, 1977	1	3155
G	01	31	01	7856250	Y	886261	01	March 5, 2009	N	80229598	April 1, 1977	1	3320
G	01	32	01	7856250	Y	16859	01	June 1, 1991	N	80229598	April 1, 1977	0	0
G	01	33	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3060
G	01	34	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3209
G	01	35	01	7856250	Y	886228	01	April 11, 2005	N	80229598	April 1, 1977	1	3385
G	01	36	01	7856250	Y	886261	01	Jan. 18, 2019	N	80229598	April 1, 1977	1	3359
G	01	37	01	7856250	Y	876645	01	Jan. 10, 1996	N	80229598	April 1, 1977	0	0
G	01	38	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3122
G	01	39	01	7856250	Y	886261	01	Oct. 8, 2008	N	80229598	April 1, 1977	1	3125
G	01	40	01	7856250	Y	100797	01	July 11, 2024	N	80229598	April 1, 1977	1	3155
G	01	41	01	7856250	Y	886261	01	May 11, 2017	N	80229598	April 1, 1977	1	3182
G	01	42	01	7856250	Y	876645	01	April 1, 1996	N	80229598	April 1, 1977	0	0
G	01	43	01	7856250	Y	886261	01	Jan. 11, 2010	N	80229598	April 1, 1977	1	3120
G	01	44	01	7856250	Y	886261	01	June 16, 2015	N	80229598	April 1, 1977	1	2990
G	01	45	01	7856250	Y	16859	01	Sept. 1, 1991	N	80229598	April 1, 1977	0	0
G	01	46	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3058
G	01	47	01	7856250	Y	886261	01	Oct. 5, 2022	N	80229598	April 1, 1977	1	3125
G	01	48	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3120
G	01	49	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	2829
G	01	50	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	2955
G	01	51	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	2985
G	01	52	01	7856250	Y	886261	01	June 24, 2015	N	80229598	April 1, 1977	1	2860
G	01	53	01	7856250	Y	886228	01	Oct. 13, 2005	N	80229598	April 1, 1977	1	3016
G	01	54	01	7856250	Y	886261	01	Jan. 16, 2010	N	80229598	April 1, 1977	1	3067
G	01	55	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3276
G	01	56	01	7856250	Y	876645	01	Dec. 28, 1995	N	80229598	April 1, 1977	0	0
G	01	57	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3060
G	01	58	01	7856250	Y	876645	01	Jan. 3, 1996	N	80229598	April 1, 1977	0	0
G	01	59	01	7856250	Y	876645	01	Dec. 14, 1995	N	80229375	June 24, 1977	0	0
G	01	60	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	2945
G	01	61	01	7856250	N	103834	null	null	N	80229598	April 1, 1977	1	3080
G	01	62	01	7856250	Y	886261	01	March 9, 2009	N	80229598	April 1, 1977	1	2940
G	01	63	01	7856250	Y	886228	01	April 6, 2005	N	80229598	April 1, 1977	1	2964
G	01	64	01	7856250	Y	100797	01	Nov. 27, 2023	N	80229598	April 1, 1977	1	3110
G	01	65	01	7856250	Y	768910	01	June 1, 1968	N	99999999	null	0	0
G	01	66	01	7856250	Y	625182	01	Feb. 1, 1995	N	80229375	June 24, 1977	0	0
G	01	67	01	7856250	Y	837750	01	Dec. 1, 1978	N	80229375	June 24, 1977	0	0
G	01	68	01	7856250	Y	837750	01	Feb. 1, 1979	N	80229375	June 24, 1977	0	0
G	01	69	01	8749666	Y	216990	99	Jan. 1, 1912	N	99999999	null	0	0
G	01	70	01	8749666	Y	348610	01	Nov. 15, 2006	N	80168986	Oct. 13, 1983	1	2650
G	01	71	01	8749666	Y	871250	01	Feb. 1, 1978	N	80229598	April 1, 1977	0	0
G	01	72	01	8749333	Y	348610	01	Nov. 13, 2006	N	80229598	April 1, 1977	1	2600
G	01	73	01	10792333	Y	162025	99	Oct. 21, 1977	N	99999999	null	0	0
G	01	74	01	10951500	Y	84510	01	Nov. 15, 2016	N	80229375	June 24, 1977	1	3170
G	01	75	01	11174500	Y	427960	01	June 1, 1966	N	99999999	null	0	0
G	01	76	01	11176500	Y	427960	99	Jan. 1, 1912	N	99999999	null	0	0
G	01	77	01	11176750	Y	479130	01	Oct. 17, 1995	N	80229598	April 1, 1977	0	0
G	01	78	01	11176750	Y	427960	01	Aug. 1, 1986	N	80229598	April 1, 1977	0	0
G	01	80	01	11176750	Y	479130	01	Oct. 18, 1995	N	80229598	April 1, 1977	0	0
G	01	81	01	11575500	N	891175	null	null	N	80229375	June 24, 1977	1	10614
G	01	82	01	11575750	Y	36550	99	Oct. 21, 1977	N	99999999	null	0	0
G	01	83	01	16340500	Y	685823	01	April 1, 1988	N	80218793	Dec. 6, 1978	0	0
G	01	85	01	14866333	Y	246610	01	Dec. 9, 2016	N	80229375	June 24, 1977	1	415
G	01	86	01	14866333	Y	246610	01	Dec. 9, 2016	N	80229375	June 24, 1977	1	1130
G	01	87	01	14866333	N	871290	null	null	N	79759486	May 13, 2024	1	428
G	01	88	01	14866333	Y	246610	01	Dec. 9, 2016	N	99999999	null	1	415
G	01	89	01	14866666	Y	246610	01	Nov. 1, 1991	N	80229375	June 24, 1977	0	0
G	01	90	01	14866666	Y	246610	01	Nov. 1, 1991	N	99999999	null	0	0
G	01	91	01	14866666	N	246610	null	null	N	80229375	June 24, 1977	1	1138
G	01	92	01	14866666	Y	470570	01	Aug. 1, 1991	N	99999999	null	0	0
G	01	93	01	15142666	Y	36550	99	Oct. 21, 1977	N	99999999	null	0	0
G	01	94	01	15146777	Y	36550	01	April 1, 1967	N	99999999	null	0	0
G	01	95	01	15146777	Y	784155	01	Oct. 1, 2010	N	80229598	April 1, 1977	1	1549
G	01	96	01	15146925	Y	844110	99	Oct. 21, 1977	N	99999999	null	0	0
G	01	97	01	15146148	Y	36550	99	Oct. 21, 1977	N	99999999	null	0	0
G	01	98	01	15146111	Y	226650	06	Nov. 1, 1977	N	80229375	June 24, 1977	0	0
G	01	99	01	15146259	N	292290	null	null	N	80229598	April 1, 1977	1	2651
G	01	101	01	15146259	Y	829430	99	Oct. 21, 1977	N	99999999	null	0	0
G	01	102	01	15146259	Y	844110	99	Oct. 21, 1977	N	99999999	null	0	0
G	01	103	01	15146259	Y	844110	99	Oct. 21, 1977	N	99999999	null	0	0
G	01	104	01	15146370	Y	844110	99	Jan. 1, 1912	N	99999999	null	0	0

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 35.8K
02 14.2K

`lease_rrcid`

int4

Sampled: 50K
Distinct: 36K

4530 4
1385 4
667 3
161 3
1006 3
1613 3
4321 3
176 3
2204 3
1268 3
2773 3
292 3

`district`

varchar

Sampled: 50K
Distinct: 2

01 35.8K
02 14.2K

`field_no`

int4

Sampled: 50K
Distinct: 6.1K

3446001 2.4K
8001 1.8K
6001 1K
5189550 868
256500 826
14001 734
4001 695
2001 679
636500 615
12001 549
16001 533
6648500 503

`operator_no`

int4

Sampled: 50K
Distinct: 2.8K

27200 4.6K
72504 4.5K
20425 2.2K
20528 2K
36550 1.6K
40209 1.4K
36587 980
53974 908
40798 855
29340 785
73056 627
18900 556

`sched_sequence_key`

int4

Sampled: 50K
Distinct: 7.9K

99999999 8.9K
80229598 3K
80229376 2.1K
80229375 1.2K
80139878 219
80139876 73
80189194 71
80219469 64
79759486 63
80219593 60
80229274 59
80219698 57

`off_schedule`

varchar

Sampled: 50K
Distinct: 2

Y 29K
N 21K

Take it away

Back to everything we know about Certificate of Authorization P-4 (Oil and Gas)