Preview Wellbore Formation Records

First 100 rows

Out of roughly 2.1M rows in texas.wb_formations. Version obs-e2eb50383896.

First 100 rows of `texas.wb_formations`, 6 columns wide
`api_county`	`api_unique`	`formation_cntr`	`formation_name`	`formation_depth`	`ingested_at`
001	00045	1	WOODBINE	4008	Sept. 13, 2026, 10:01 p.m.
001	00046	1	WOODBINE	3979	Sept. 13, 2026, 10:01 p.m.
001	00070	1	AUSTIN	4320	Sept. 13, 2026, 10:01 p.m.
001	00070	2	PALUXY	7410	Sept. 13, 2026, 10:01 p.m.
001	00070	3	RODESSA	9500	Sept. 13, 2026, 10:01 p.m.
001	00070	4	WOODBINE	4985	Sept. 13, 2026, 10:01 p.m.
001	00070	5	MASSIVE ANHYDRITE	8885	Sept. 13, 2026, 10:01 p.m.
001	00070	6	JAMES LIME	9886	Sept. 13, 2026, 10:01 p.m.
001	00071	1	AUSTIN	4320	Sept. 13, 2026, 10:01 p.m.
001	00071	2	WOODBINE	4985	Sept. 13, 2026, 10:01 p.m.
001	00071	3	PALUXY	7410	Sept. 13, 2026, 10:01 p.m.
001	00071	4	MASSIVE ANHYDRITE	8885	Sept. 13, 2026, 10:01 p.m.
001	00071	5	RODESSA	9500	Sept. 13, 2026, 10:01 p.m.
001	00071	6	JAMES LIME	9886	Sept. 13, 2026, 10:01 p.m.
001	00072	1	AUSTIN CHALK	4430	Sept. 13, 2026, 10:01 p.m.
001	00072	2	WOODBINE	5030	Sept. 13, 2026, 10:01 p.m.
001	00072	3	BUDDA	6070	Sept. 13, 2026, 10:01 p.m.
001	00072	4	MASSIVE ANHYDRITE	9248	Sept. 13, 2026, 10:01 p.m.
001	00072	5	RODESSA	9640	Sept. 13, 2026, 10:01 p.m.
001	00072	6	JAMES LIME	9981	Sept. 13, 2026, 10:01 p.m.
001	00078	1	AUSTIN CHALK	4540	Sept. 13, 2026, 10:01 p.m.
001	00078	2	WOODBINE	5100	Sept. 13, 2026, 10:01 p.m.
001	00078	3	BUDA	6105	Sept. 13, 2026, 10:01 p.m.
001	00078	4	MASSIVE ANHYDRITE	9265	Sept. 13, 2026, 10:01 p.m.
001	00078	5	RODESSA	9665	Sept. 13, 2026, 10:01 p.m.
001	00078	6	JAMES LIME	9996	Sept. 13, 2026, 10:01 p.m.
001	00084	1	AUSTIN	4485	Sept. 13, 2026, 10:01 p.m.
001	00084	2	WOODBINE	5037	Sept. 13, 2026, 10:01 p.m.
001	00084	3	RODESSA	9500	Sept. 13, 2026, 10:01 p.m.
001	00084	4	JAMES LIME	9932	Sept. 13, 2026, 10:01 p.m.
001	00084	5	PETTIT	10282	Sept. 13, 2026, 10:01 p.m.
001	00089	1	AUSTIN CHALK	4690	Sept. 13, 2026, 10:01 p.m.
001	00089	2	WOODBINE	5520	Sept. 13, 2026, 10:01 p.m.
001	00089	3	COMANCHE LIME	6220	Sept. 13, 2026, 10:01 p.m.
001	00089	4	JAMES LIME	10060	Sept. 13, 2026, 10:01 p.m.
001	00090	1	WOODBINE	5042	Sept. 13, 2026, 10:01 p.m.
001	00090	2	JAMES LIME	9845	Sept. 13, 2026, 10:01 p.m.
001	00090	3	RODESSA	9526	Sept. 13, 2026, 10:01 p.m.
001	00091	1	AUSTIN CHALK	4530	Sept. 13, 2026, 10:01 p.m.
001	00091	2	WOODBINE	5058	Sept. 13, 2026, 10:01 p.m.
001	00091	3	RODESSA	9512	Sept. 13, 2026, 10:01 p.m.
001	00091	4	JAMES LIME	9872	Sept. 13, 2026, 10:01 p.m.
001	00092	1	AUSTIN CHALK	4510	Sept. 13, 2026, 10:01 p.m.
001	00092	2	WOODBINE	4965	Sept. 13, 2026, 10:01 p.m.
001	00092	3	PAULXY	7210	Sept. 13, 2026, 10:01 p.m.
001	00092	4	MASSIVE ANHYDRITE	9080	Sept. 13, 2026, 10:01 p.m.
001	00092	5	RODESSA	9470	Sept. 13, 2026, 10:01 p.m.
001	00092	6	JAMES LIME	9852	Sept. 13, 2026, 10:01 p.m.
001	00094	1	AUSTIN CHALK	4575	Sept. 13, 2026, 10:01 p.m.
001	00094	2	WOODBINE	4900	Sept. 13, 2026, 10:01 p.m.
001	00094	3	PALUXY	7564	Sept. 13, 2026, 10:01 p.m.
001	00094	4	MASSIVE ANHYDRITE	9180	Sept. 13, 2026, 10:01 p.m.
001	00094	5	RODESSA	8569	Sept. 13, 2026, 10:01 p.m.
001	00094	6	JAMES LIME	9890	Sept. 13, 2026, 10:01 p.m.
001	00101	1	WOODBINE	5105	Sept. 13, 2026, 10:01 p.m.
001	00101	2	RODESSSA	9600	Sept. 13, 2026, 10:01 p.m.
001	00101	3	JAMES LIME	9925	Sept. 13, 2026, 10:01 p.m.
001	00101	4	MASSIVE ANHYDRITE	9230	Sept. 13, 2026, 10:01 p.m.
001	00101	5	RODESSA	9600	Sept. 13, 2026, 10:01 p.m.
001	00101	6	JAMES LIME	9925	Sept. 13, 2026, 10:01 p.m.
001	00106	1	AUSTIN	4750	Sept. 13, 2026, 10:01 p.m.
001	00106	2	WOODBINE	5220	Sept. 13, 2026, 10:01 p.m.
001	00106	3	MASSIVE ANHYDRITE	9365	Sept. 13, 2026, 10:01 p.m.
001	00106	4	RODESSA	9720	Sept. 13, 2026, 10:01 p.m.
001	00106	5	JAMES LIME	10020	Sept. 13, 2026, 10:01 p.m.
001	00106	6	TRAVIS PEAK	10580	Sept. 13, 2026, 10:01 p.m.
001	00110	1	AUSTIN	4640	Sept. 13, 2026, 10:01 p.m.
001	00110	2	WOODBINE	5145	Sept. 13, 2026, 10:01 p.m.
001	00110	3	BUDA	6135	Sept. 13, 2026, 10:01 p.m.
001	00110	4	MASSIVE ANHYDRITE	9250	Sept. 13, 2026, 10:01 p.m.
001	00110	5	RODESSA	9610	Sept. 13, 2026, 10:01 p.m.
001	00110	6	JAMES LIME	9942	Sept. 13, 2026, 10:01 p.m.
001	00111	1	MASSIVE ANHYDRITE	9510	Sept. 13, 2026, 10:01 p.m.
001	00111	2	JAMES LIME	10080	Sept. 13, 2026, 10:01 p.m.
001	00112	1	AUSTIN CHALK	4600	Sept. 13, 2026, 10:01 p.m.
001	00112	2	WOODBINE	5090	Sept. 13, 2026, 10:01 p.m.
001	00112	3	PALUXY	7354	Sept. 13, 2026, 10:01 p.m.
001	00112	4	MASSIVE ANHYDRITE	9187	Sept. 13, 2026, 10:01 p.m.
001	00112	5	JAMES LIME	9872	Sept. 13, 2026, 10:01 p.m.
001	00112	6	PETTIT	10216	Sept. 13, 2026, 10:01 p.m.
001	00113	1	WOODBINE	5150	Sept. 13, 2026, 10:01 p.m.
001	00117	1	JAMES LIME	9846	Sept. 13, 2026, 10:01 p.m.
001	00120	1	MASSIVE ANHYDRITE	8490	Sept. 13, 2026, 10:01 p.m.
001	00120	2	JAMES LIME	9880	Sept. 13, 2026, 10:01 p.m.
001	00120	3	PETTIT	10230	Sept. 13, 2026, 10:01 p.m.
001	00128	1	AUSTIN CHALK	4620	Sept. 13, 2026, 10:01 p.m.
001	00128	2	WOODBINE	5080	Sept. 13, 2026, 10:01 p.m.
001	00128	3	RODESSA	9550	Sept. 13, 2026, 10:01 p.m.
001	00128	4	JAMES LIME	9984	Sept. 13, 2026, 10:01 p.m.
001	00135	1	AUSTIN	4610	Sept. 13, 2026, 10:01 p.m.
001	00135	2	WOODBINE	5115	Sept. 13, 2026, 10:01 p.m.
001	00135	3	MASSIVE ANHYDRITE	9215	Sept. 13, 2026, 10:01 p.m.
001	00135	4	RODESSA	9580	Sept. 13, 2026, 10:01 p.m.
001	00135	5	JAMES LIME	9880	Sept. 13, 2026, 10:01 p.m.
001	00135	6	PETTIT	10210	Sept. 13, 2026, 10:01 p.m.
001	00137	1	AUSTIN	4740	Sept. 13, 2026, 10:01 p.m.
001	00137	2	WOODBINE	5060	Sept. 13, 2026, 10:01 p.m.
001	00137	3	JAMES LIME	9880	Sept. 13, 2026, 10:01 p.m.
001	00137	4	PETTIT	10198	Sept. 13, 2026, 10:01 p.m.
001	00167	1	WOODBINE	3493	Sept. 13, 2026, 10:01 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.

`api_county`

varchar

Sampled: 50K
Distinct: 2

003 46.6K
001 3.4K

`api_unique`

varchar

Sampled: 50K
Distinct: 12.9K

34408 24
33512 21
32791 20
35705 20
30659 18
36089 18
33551 18
04681 18
33509 17
32284 16
35850 16
04673 16

`formation_cntr`

int2

Sampled: 50K
Distinct: 24

1 13.3K
2 11.6K
3 9.8K
4 6.1K
5 3.9K
6 2.6K
7 955
8 651
9 415
10 329
11 96
12 62

`formation_name`

varchar

Sampled: 50K
Distinct: 1.8K
Empty: 0.0002

SAN ANDRES 7K
YATES 4.6K
GRAYBURG 4.1K
QUEEN 1.9K
WOLFCAMP 1.7K
CLEARFORK 1.7K
RUSTLER 1.7K
TUBB 1.2K
LOWER GRAYBURG 1.1K
STRAWN 977
DEVONIAN 944
LOWER CLEARFORK 921

`formation_depth`

int4

Sampled: 50K
Distinct: 8.9K
Empty: 0.0279

4240 192
4560 182
4490 103
4450 98
4400 96
4338 91
4200 90
4250 90
4550 88
4350 88
4340 86
4500 86

`ingested_at`

timestamptz

Sampled: 50K
Distinct: 1

Sept. 13, 2026, 10:01 p.m. 50K

Take it away

Back to everything we know about Wellbore Formation Records