Preview Wellbore Perforation Records

First 100 rows

Out of roughly 1.1M rows in texas.wb_perforations. Version obs-aa1bfb87bf42.

First 100 rows of `texas.wb_perforations`, 7 columns wide
`api_county`	`api_unique`	`perf_count`	`from_perf`	`to_perf`	`open_hole_code`	`ingested_at`
001	00001	1	4021	4023	null	Sept. 13, 2026, 10:01 p.m.
001	00008	1	7392	7420	null	Sept. 13, 2026, 10:01 p.m.
001	00037	1	5911	5920	null	Sept. 13, 2026, 10:01 p.m.
001	00043	1	7484	7506	null	Sept. 13, 2026, 10:01 p.m.
001	00045	1	4014	4026	null	Sept. 13, 2026, 10:01 p.m.
001	00045	2	4036	4046	null	Sept. 13, 2026, 10:01 p.m.
001	00046	1	4052	4063	null	Sept. 13, 2026, 10:01 p.m.
001	00049	1	7504	7522	null	Sept. 13, 2026, 10:01 p.m.
001	00055	1	7552	7574	null	Sept. 13, 2026, 10:01 p.m.
001	00064	1	10170	10176	null	Sept. 13, 2026, 10:01 p.m.
001	00066	1	null	10248	null	Sept. 13, 2026, 10:01 p.m.
001	00068	1	10094	10104	null	Sept. 13, 2026, 10:01 p.m.
001	00069	1	10149	10159	null	Sept. 13, 2026, 10:01 p.m.
001	00070	1	9958	9972	null	Sept. 13, 2026, 10:01 p.m.
001	00070	2	9886	9892	null	Sept. 13, 2026, 10:01 p.m.
001	00070	3	9897	9925	null	Sept. 13, 2026, 10:01 p.m.
001	00070	4	9933	9947	null	Sept. 13, 2026, 10:01 p.m.
001	00071	1	9954	9974	null	Sept. 13, 2026, 10:01 p.m.
001	00071	2	9998	10010	null	Sept. 13, 2026, 10:01 p.m.
001	00072	1	10005	10020	null	Sept. 13, 2026, 10:01 p.m.
001	00072	2	10085	10090	null	Sept. 13, 2026, 10:01 p.m.
001	00072	3	9986	9998	null	Sept. 13, 2026, 10:01 p.m.
001	00072	4	10028	10044	null	Sept. 13, 2026, 10:01 p.m.
001	00078	1	10006	10018	null	Sept. 13, 2026, 10:01 p.m.
001	00078	2	10023	10033	null	Sept. 13, 2026, 10:01 p.m.
001	00084	1	9944	9952	null	Sept. 13, 2026, 10:01 p.m.
001	00084	2	9958	9963	null	Sept. 13, 2026, 10:01 p.m.
001	00084	3	10002	10048	null	Sept. 13, 2026, 10:01 p.m.
001	00084	4	9969	9989	null	Sept. 13, 2026, 10:01 p.m.
001	00086	1	9922	10003	null	Sept. 13, 2026, 10:01 p.m.
001	00089	1	10087	10108	null	Sept. 13, 2026, 10:01 p.m.
001	00089	2	10070	10086	null	Sept. 13, 2026, 10:01 p.m.
001	00090	1	9904	9940	null	Sept. 13, 2026, 10:01 p.m.
001	00091	1	9892	9896	null	Sept. 13, 2026, 10:01 p.m.
001	00091	2	9914	9924	null	Sept. 13, 2026, 10:01 p.m.
001	00091	3	9938	9980	null	Sept. 13, 2026, 10:01 p.m.
001	00092	1	9878	9882	null	Sept. 13, 2026, 10:01 p.m.
001	00092	2	9898	9915	null	Sept. 13, 2026, 10:01 p.m.
001	00092	3	9928	9934	null	Sept. 13, 2026, 10:01 p.m.
001	00094	1	5145	5260	null	Sept. 13, 2026, 10:01 p.m.
001	00094	2	5680	5700	null	Sept. 13, 2026, 10:01 p.m.
001	00094	3	5470	5750	null	Sept. 13, 2026, 10:01 p.m.
001	00094	4	5550	5595	null	Sept. 13, 2026, 10:01 p.m.
001	00094	5	5770	5780	null	Sept. 13, 2026, 10:01 p.m.
001	00094	6	5630	5900	null	Sept. 13, 2026, 10:01 p.m.
001	00094	7	5630	5635	null	Sept. 13, 2026, 10:01 p.m.
001	00094	8	5860	5900	null	Sept. 13, 2026, 10:01 p.m.
001	00096	1	9362	9380	null	Sept. 13, 2026, 10:01 p.m.
001	00101	1	5424	5950	null	Sept. 13, 2026, 10:01 p.m.
001	00101	2	9954	9958	null	Sept. 13, 2026, 10:01 p.m.
001	00101	3	9970	9973	null	Sept. 13, 2026, 10:01 p.m.
001	00101	4	9976	10000	null	Sept. 13, 2026, 10:01 p.m.
001	00104	1	10050	10056	null	Sept. 13, 2026, 10:01 p.m.
001	00106	1	10037	10131	null	Sept. 13, 2026, 10:01 p.m.
001	00109	1	null	9656	null	Sept. 13, 2026, 10:01 p.m.
001	00110	1	9942	10044	null	Sept. 13, 2026, 10:01 p.m.
001	00111	1	null	9515	null	Sept. 13, 2026, 10:01 p.m.
001	00111	2	10036	10040	null	Sept. 13, 2026, 10:01 p.m.
001	00111	3	10045	10050	null	Sept. 13, 2026, 10:01 p.m.
001	00112	1	9878	9902	null	Sept. 13, 2026, 10:01 p.m.
001	00112	2	9910	9944	null	Sept. 13, 2026, 10:01 p.m.
001	00113	1	null	10310	null	Sept. 13, 2026, 10:01 p.m.
001	00117	1	9848	9916	null	Sept. 13, 2026, 10:01 p.m.
001	00120	1	9882	9936	null	Sept. 13, 2026, 10:01 p.m.
001	00120	2	9895	9900	null	Sept. 13, 2026, 10:01 p.m.
001	00120	3	9907	9912	null	Sept. 13, 2026, 10:01 p.m.
001	00120	4	9916	9926	null	Sept. 13, 2026, 10:01 p.m.
001	00120	5	9928	9936	null	Sept. 13, 2026, 10:01 p.m.
001	00128	1	9979	9990	null	Sept. 13, 2026, 10:01 p.m.
001	00128	2	9997	10017	null	Sept. 13, 2026, 10:01 p.m.
001	00128	3	10021	10040	null	Sept. 13, 2026, 10:01 p.m.
001	00130	1	null	10177	null	Sept. 13, 2026, 10:01 p.m.
001	00133	1	null	10180	null	Sept. 13, 2026, 10:01 p.m.
001	00135	1	null	9215	null	Sept. 13, 2026, 10:01 p.m.
001	00135	2	9897	9900	null	Sept. 13, 2026, 10:01 p.m.
001	00135	3	9904	9910	null	Sept. 13, 2026, 10:01 p.m.
001	00135	4	9916	9920	null	Sept. 13, 2026, 10:01 p.m.
001	00135	5	9924	9934	null	Sept. 13, 2026, 10:01 p.m.
001	00137	1	9880	9886	null	Sept. 13, 2026, 10:01 p.m.
001	00139	1	null	10206	null	Sept. 13, 2026, 10:01 p.m.
001	00164	1	null	4680	null	Sept. 13, 2026, 10:01 p.m.
001	00167	1	3493	3559	null	Sept. 13, 2026, 10:01 p.m.
001	00189	1	null	5440	null	Sept. 13, 2026, 10:01 p.m.
001	00209	1	null	3567	null	Sept. 13, 2026, 10:01 p.m.
001	00240	1	3754	3774	null	Sept. 13, 2026, 10:01 p.m.
001	00240	2	3735	3747	null	Sept. 13, 2026, 10:01 p.m.
001	00259	1	null	4706	null	Sept. 13, 2026, 10:01 p.m.
001	00260	1	4686	4690	null	Sept. 13, 2026, 10:01 p.m.
001	00260	2	4692	4701	null	Sept. 13, 2026, 10:01 p.m.
001	00261	1	4664	4668	null	Sept. 13, 2026, 10:01 p.m.
001	00262	1	4644	4676	null	Sept. 13, 2026, 10:01 p.m.
001	00263	1	4626	4662	null	Sept. 13, 2026, 10:01 p.m.
001	00264	1	4650	4654	null	Sept. 13, 2026, 10:01 p.m.
001	00264	2	4679	4686	null	Sept. 13, 2026, 10:01 p.m.
001	00265	1	4670	4678	null	Sept. 13, 2026, 10:01 p.m.
001	00266	1	4643	4684	null	Sept. 13, 2026, 10:01 p.m.
001	00267	1	4640	4648	null	Sept. 13, 2026, 10:01 p.m.
001	00267	2	4640	4648	null	Sept. 13, 2026, 10:01 p.m.
001	00267	3	4630	4637	null	Sept. 13, 2026, 10:01 p.m.
001	00270	1	4606	4634	null	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: 6

003 32.1K
009 8.6K
013 5.1K
001 2.7K
007 870
005 613

`api_unique`

varchar

Sampled: 50K
Distinct: 25.8K

30273 34
35325 29
35323 28
34753 27
35312 27
34785 27
35311 27
34752 27
30288 27
35309 27
35310 26
35324 26

`perf_count`

int2

Sampled: 50K
Distinct: 33

1 36.5K
2 6.4K
3 3K
4 1.5K
5 685
6 418
7 265
8 197
9 155
10 125
11 102
12 82

`open_hole_code`

varchar

Sampled: 50K
Distinct: 1
Empty: 0.9616

OH 1.9K

`from_perf`

int4

Sampled: 50K
Distinct: 10.1K
Empty: 0.105

4510 81
4480 69
4500 69
4470 68
4550 68
4460 66
4430 66
4600 65
4530 63
4420 62
4450 62
4464 60

`to_perf`

int4

Sampled: 50K
Distinct: 12.1K
Empty: 0.0026

4700 531
540 154
4704 145
4400 140
7300 93
4500 92
4540 84
4600 81
4610 80
4590 79
4570 79
490 69

`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 Perforation Records