Preview Oil Detail Well

First 100 rows

Out of roughly 85.8K rows in texas.oil_detail_well. Version obs-6d686587892d.

First 100 rows of `texas.oil_detail_well`, 27 columns wide
`district`	`field_no`	`operator_no`	`lease_no`	`rec_no`	`well_no`	`county_code`	`type_well`	`ex14b_code`	`ex14b_yyyymm`	`test_eff`	`test1_date`	`test1_oil_bbl`	`test1_prd_method`	`test2_date`	`test2_oil_bbl`	`test2_prd_method`	`form_lacking`	`delq_form`	`date_last_utilized_yyyymm`
01	6469001	102014	31	1	2	325	P	0	null	8	May 13, 2024	1.0	1	March 8, 2025	1.0	1	0	0	null
01	6469001	102014	31	1	3	325	P	0	null	8	May 20, 2024	1.0	1	March 9, 2025	1.0	1	0	0	null
01	6469001	102014	31	1	4	325	P	0	null	8	May 28, 2024	1.0	1	March 10, 2025	1.0	1	0	0	null
01	7850001	534219	3380	1	1	163	S	4	202109	0	Dec. 11, 1990	0.0	0	Dec. 11, 1990	0.0	0	0	1	null
01	7850001	534219	3380	1	2	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	3	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	4	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	5	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	6	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	9	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	11	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	12	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	13	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	14	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	15	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	16	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	17	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	17A	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	18	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	23	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	0	1	null
01	7850001	534219	3380	1	23A	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	24	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	25	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	27	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	31	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	32	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	33	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	34	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	40	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	41	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	42	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	43	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	44	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	46	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	47	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	48	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	49	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	51	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	52	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	53	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	54	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	55	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	56	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	58	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	59	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	59A	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	61	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	62	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	63	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	64	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	65	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	68	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	69	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	70	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	71	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	72	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	73	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	76	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	78	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	79	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	79A	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	79AI	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	81	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	82	163	S	4	202109	0	Jan. 1, 2013	0.0	0	Jan. 1, 2013	0.0	0	0	1	null
01	7850001	534219	3380	1	83	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	85	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	87	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	89	163	S	4	202109	0	Oct. 15, 1999	0.0	0	Oct. 15, 1999	0.0	0	0	1	null
01	7850001	534219	3380	1	90	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	91	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	92	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	94	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	95AI	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	96	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	96A	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	97A	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	98	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	99	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	100	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	101	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	102	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	103	163	S	H	202209	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	103A	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	105	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	108	163	S	4	202109	0	Nov. 18, 1987	0.0	0	Nov. 18, 1987	0.0	0	0	1	null
01	7850001	534219	3380	1	109	163	S	H	202109	0	Oct. 1, 2023	0.0	0	Oct. 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	110	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	111	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	112	163	S	H	202209	0	Oct. 1, 2023	0.0	0	Oct. 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	113	163	S	H	202109	0	Oct. 1, 2023	0.0	0	Oct. 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	114	163	S	H	202109	0	Oct. 1, 2023	0.0	0	Oct. 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	115	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	116	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	117	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	118	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	119	163	S	H	202109	0	March 1, 2023	0.0	0	March 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	120	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null
01	7850001	534219	3380	1	121	163	S	H	202209	0	Oct. 1, 2023	0.0	0	Oct. 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	123	163	S	4	202109	0	Oct. 1, 2023	0.0	0	Oct. 1, 2023	0.0	0	1	0	null
01	7850001	534219	3380	1	125I	163	S	4	202109	0	Jan. 1, 1995	0.0	0	Jan. 1, 1995	0.0	0	0	1	null

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: 11

08 28.8K
01 5K
07B 4.7K
08A 3.6K
07C 2.9K
06 1.6K
03 1.1K
02 772
05 592
06E 525
04 473

`field_no`

int4

Sampled: 50K
Distinct: 519

53411001 2.8K
59337001 1.9K
42971200 1.9K
35652062 1.7K
62528001 1.5K
48583001 1.5K
3446001 1.4K
21289001 1.4K
44148500 1.2K
60137001 1.2K
33230001 1.2K
20350001 937

`operator_no`

int4

Sampled: 50K
Distinct: 514

386310 7.9K
40209 4.4K
103962 2.9K
53974 2.3K
102117 1.8K
276959 1.5K
154235 1.4K
101718 1.2K
103919 873
149477 851
385847 721
99955 716

`lease_no`

int4

Sampled: 50K
Distinct: 2K

3137 1.5K
24061 1.3K
1770 1.1K
17503 994
20164 993
20831 908
7338 890
2082 851
4161 716
7337 712
20377 687
5743 567

`rec_no`

varchar

Sampled: 50K
Distinct: 10

1 42.8K
A 6.3K
B 604
C 139
I 108
2 37
3 8
6 3
D 1
H 1

`well_no`

varchar

Sampled: 50K
Distinct: 16.5K

1 729
2 699
3 683
4 617
5 566
6 526
7 521
8 474
10 399
9 391
11 367
12 343

`county_code`

int2

Sampled: 50K
Distinct: 126

135 7.1K
3 5.2K
103 2.9K
227 2.6K
335 2.5K
371 2.4K
475 2.4K
495 1.6K
461 1.6K
429 1.3K
105 1.1K
187 1K

`type_well`

varchar

Sampled: 50K
Distinct: 5
Empty: 0.0389

P 20K
E 14.3K
S 13.7K
X 63
N 1

Take it away

Back to everything we know about Oil Detail Well