Preview Wellbore Form Dates

First 100 rows

Out of roughly 1.6M rows in texas.wb_dates. Version obs-59f2ede41589.

First 100 rows of `texas.wb_dates`, 24 columns wide
`api_county`	`api_unique`	`file_key`	`file_date`	`except_rule_11`	`cement_affidavit`	`g5_flag`	`w12_flag`	`dir_survey`	`w2_g1_date`	`compl_date`	`drl_compl_date`	`plugb_depth1`	`plugb_depth2`	`water_injection_nbr`	`salt_wtr_nbr`	`remarks_ind`	`elevation`	`elevation_code`	`docket_nbr`	`psa_well_flag`	`allocation_well_flag`	`ingested_at`	`log_file_rba`
001	00001	80159887	Jan. 12, 1984	N	N	N	N	N	Dec. 5, 1963	Oct. 27, 1963	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00008	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00037	80069183	Aug. 16, 1993	N	N	N	N	N	Feb. 25, 1993	null	null	null	null	null	6565	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00037	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00039	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00040	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00041	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00043	80159887	Jan. 12, 1984	N	N	N	N	N	null	Jan. 1, 1963	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00045	80049484	May 15, 1995	N	N	N	N	N	Oct. 11, 1994	Nov. 14, 1935	July 23, 1994	4053	null	null	null	Y	328	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00045	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00046	80049586	April 13, 1995	N	N	N	N	N	Oct. 11, 1994	null	July 22, 1994	4063	null	null	null	Y	295	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00046	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00049	80159887	Jan. 12, 1984	N	N	N	N	N	null	April 16, 1957	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00052	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00055	80159887	Jan. 12, 1984	N	N	N	N	N	null	Oct. 31, 1960	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00064	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00066	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00068	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00069	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00070	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00070	79989476	May 23, 2001	N	N	N	N	N	March 20, 2001	Sept. 27, 2000	Sept. 27, 2000	10038	null	null	null	Y	491	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00070	79989596	April 3, 2001	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00070	79998786	Dec. 13, 2000	N	N	N	N	N	May 21, 2000	null	null	10038	null	null	null	Y	491	DF	06-223894	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00070	80129268	July 31, 1987	N	N	N	N	N	July 16, 1987	April 22, 1963	null	10038	null	null	null	N	491	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00071	79949173	Aug. 26, 2005	N	N	Y	N	N	June 16, 2005	May 30, 2001	May 30, 2001	10065	null	null	null	Y	497	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00071	79949369	June 30, 2005	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00071	79948897	Nov. 2, 2005	N	N	N	N	N	Aug. 12, 2005	July 20, 2003	May 30, 2001	10065	null	null	null	Y	497	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00071	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00072	79989469	May 30, 2001	N	N	Y	N	N	June 19, 2000	April 10, 1962	null	10182	null	null	null	Y	506	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00072	79989596	April 3, 2001	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00072	80129196	Aug. 3, 1987	N	N	N	N	N	July 16, 1987	April 10, 1962	null	10182	null	null	null	Y	506	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00072	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00074	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00078	80059579	April 20, 1994	N	N	N	N	N	Dec. 30, 1993	null	null	8362	null	null	null	Y	476	GL	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00078	80129196	Aug. 3, 1987	N	N	N	N	N	July 16, 1987	Sept. 6, 1961	null	10155	null	null	null	N	476	GR	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00078	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00084	80129268	July 31, 1987	N	N	N	N	N	July 16, 1987	null	null	10116	null	null	null	Y	417	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00084	80159887	Jan. 12, 1984	N	N	N	N	N	Feb. 19, 1962	null	Jan. 30, 1962	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00085	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00086	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00087	80159887	Jan. 12, 1984	N	N	N	N	N	May 9, 1961	null	April 15, 1961	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00089	80129196	Aug. 3, 1987	N	N	N	N	N	July 16, 1987	June 19, 1961	Oct. 7, 1971	10124	null	null	null	Y	569	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00089	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00090	79949272	July 27, 2005	N	N	Y	N	N	March 16, 2005	Feb. 25, 2005	Feb. 25, 2005	9997	null	F 0571	null	Y	388	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00090	79949468	May 31, 2005	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00090	80028789	Dec. 10, 1997	N	N	N	N	N	Oct. 1, 1997	Sept. 20, 1997	Sept. 20, 1997	9997	null	F0571	null	Y	388	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00090	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00091	79959384	June 15, 2004	N	N	N	N	N	April 5, 2004	March 16, 2004	March 13, 2004	9992	null	null	null	Y	392	GL	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00091	80049669	March 30, 1995	N	N	N	N	N	Oct. 6, 1994	Sept. 29, 1994	Sept. 29, 1994	9992	null	F0571	null	Y	392	GL	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00091	80129171	Aug. 28, 1987	N	N	N	N	N	Aug. 7, 1987	March 24, 1961	null	9992	null	null	null	N	392	GL	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00091	80129195	Aug. 4, 1987	N	N	N	N	N	July 16, 1987	March 24, 1961	null	9992	null	null	null	Y	392	GL	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00091	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00092	79959076	Sept. 23, 2004	N	N	N	N	N	July 12, 2004	June 25, 2004	June 25, 2004	9935	null	null	null	Y	380	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00092	79979185	Aug. 14, 2002	N	N	N	N	N	Feb. 15, 2001	Dec. 15, 1995	Dec. 15, 1995	9935	null	F0571	null	Y	380	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00092	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00093	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00094	79989381	June 18, 2001	N	Y	N	N	N	Oct. 25, 2000	Oct. 25, 2000	Oct. 25, 2000	6000	null	null	11406	Y	427	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00094	79989385	June 14, 2001	N	N	N	N	N	Nov. 1, 2000	Oct. 25, 2000	Oct. 25, 2000	6000	null	null	11406	Y	427	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00094	80129196	Aug. 3, 1987	N	N	N	N	N	July 16, 1987	April 22, 1961	Sept. 13, 1967	null	null	null	null	Y	427	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00094	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00095	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00096	80159887	Jan. 12, 1984	N	Y	N	N	N	Feb. 26, 1962	Feb. 19, 1962	Dec. 8, 1961	null	null	null	null	N	418	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00097	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00098	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00100	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00101	79749589	April 10, 2025	N	N	N	N	N	Jan. 10, 2022	Jan. 13, 2006	Jan. 13, 2006	6053	null	null	12209	Y	null	null	null	N	N	Sept. 13, 2026, 10:01 p.m.	null
001	00101	79939379	June 20, 2006	N	Y	N	N	N	Feb. 3, 2006	Jan. 13, 2006	Jan. 13, 2006	6053	null	null	null	Y	419	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00101	79939776	Feb. 23, 2006	N	N	N	N	N	July 16, 1987	Aug. 10, 1962	null	10258	null	null	null	Y	419	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00101	80129268	July 31, 1987	N	N	N	N	N	July 16, 1987	Aug. 10, 1962	null	10258	null	null	null	Y	419	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00101	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00104	80159887	Jan. 12, 1984	N	N	N	N	N	June 4, 1964	May 24, 1964	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00105	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00106	80129196	Aug. 3, 1987	N	N	N	N	N	July 16, 1987	Sept. 29, 1962	null	null	null	null	null	N	471	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00106	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00108	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00109	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00110	80119383	June 16, 1988	N	N	N	N	N	May 3, 1988	Oct. 21, 1961	April 20, 1988	7459	null	null	null	Y	423	KB	null	null	null	Sept. 13, 2026, 10:01 p.m.	5817549
001	00110	80129196	Aug. 3, 1987	N	N	N	N	N	July 16, 1987	Oct. 21, 1961	null	10019	null	null	null	N	423	KB	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00110	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00111	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00111	79779790	Feb. 9, 2022	N	N	N	N	N	Jan. 11, 2022	July 21, 2000	July 21, 2000	6100	null	null	11366	Y	526	DF	null	N	N	Sept. 13, 2026, 10:01 p.m.	null
001	00111	79989385	June 14, 2001	N	N	N	N	N	Aug. 9, 2000	July 21, 2000	July 21, 2000	610	null	null	null	Y	526	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00111	79998791	Dec. 8, 2000	N	N	N	N	N	Aug. 9, 2000	July 21, 2000	Aug. 7, 2000	6100	null	null	null	Y	526	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00111	79998792	Dec. 7, 2000	N	N	N	N	N	July 25, 2000	Sept. 16, 1974	July 11, 2000	10128	null	null	11366	Y	526	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00112	80069486	May 13, 1993	N	N	N	N	N	March 19, 1993	null	Feb. 23, 1991	10004	null	F0571	null	Y	369	GR	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00112	80129268	July 31, 1987	N	N	N	N	N	July 16, 1987	April 4, 1963	Feb. 15, 1963	10004	null	null	null	Y	369	GR	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00112	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00113	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00113	80079579	April 20, 1992	N	N	N	N	N	Jan. 23, 1992	Sept. 17, 1980	Sept. 17, 1980	6048	null	null	2015	Y	439	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00114	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00115	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00117	79839194	Aug. 5, 2016	N	N	Y	N	N	April 20, 2015	Nov. 11, 1961	Nov. 11, 1961	10120	null	null	null	Y	370	DF	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00117	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00117	80039679	March 20, 1996	N	N	N	N	N	Dec. 27, 1995	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00118	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00120	79959877	Jan. 22, 2004	N	N	Y	N	N	Nov. 6, 2003	Oct. 16, 2003	Sept. 11, 2003	10300	null	null	null	Y	412	GR	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00120	79968770	Dec. 29, 2003	N	N	N	N	N	null	null	null	null	null	null	null	Y	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00120	80129171	Aug. 28, 1987	N	N	N	N	N	July 20, 1987	April 23, 1962	Nov. 14, 1966	10300	null	null	null	Y	412	GR	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00120	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	null
001	00122	80159887	Jan. 12, 1984	N	N	N	N	N	null	null	null	null	null	null	null	N	null	null	null	null	null	Sept. 13, 2026, 10:01 p.m.	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.

`api_county`

varchar

Sampled: 50K
Distinct: 2

003 44.9K
001 5.1K

`api_unique`

varchar

Sampled: 50K
Distinct: 19.6K

00333 17
36834 17
04643 15
34319 15
02985 15
36816 14
32292 14
33330 14
31910 14
32323 14
32239 14
34552 13

`file_key`

varchar

Sampled: 50K
Distinct: 7.7K

80159887 11.7K
80089282 108
79888798 101
80048974 86
80058891 83
80159386 79
79909689 77
80119287 76
80149287 70
80079789 69
80048973 69
80109188 62

`elevation_code`

varchar

Sampled: 50K
Distinct: 12
Empty: 0.4986

GR 10.9K
GL 8.7K
KB 2.7K
DF 2.6K
RT 130
DB 15
U 2
G 1
FL 1
GE 1
F 1
KL 1

`file_date`

date

Sampled: 50K
Distinct: 7.7K

Jan. 12, 1984 11.7K
July 17, 1991 108
Dec. 1, 2011 101
Oct. 25, 1995 86
Nov. 8, 1994 83
June 13, 1984 79
March 10, 2009 77
July 12, 1988 76
July 12, 1985 70
Oct. 26, 1995 69
Feb. 10, 1992 69
Aug. 11, 1989 62

`except_rule_11`

varchar

Sampled: 50K
Distinct: 2
Empty: 0.0093

N 49.5K
Y 12

`cement_affidavit`

varchar

Sampled: 50K
Distinct: 2
Empty: 0.0012

N 33.2K
Y 16.7K

`g5_flag`

varchar

Sampled: 50K
Distinct: 2
Empty: 0.0093

N 48.9K
Y 655

Take it away

Back to everything we know about Wellbore Form Dates