A live sample straight out of our copy of the data. Nothing here is edited: this is exactly what an export gives you.
Out of roughly 552.2K rows in
texas.cmpl_production_interval_data.
Version obs-7ae3c461a22c.
tracking_no | packet_id | parent_id | row_no | from_depth | to_depth | bottom_hole_label | lateral_label | open_hole |
|---|---|---|---|---|---|---|---|---|
| 5608 | 8206 | 9356 | 1 | 7452 | 12480 | 2 | 1 | N |
| 1860 | 3229 | 5314 | 1 | 9040 | 9060 | 1 | N | |
| 4635 | 11674 | 9041 | 1 | 6500 | 10602 | 2 | 1 | N |
| 6023 | 8783 | 7778 | 1 | 8560 | 8728 | 2 | 1 | N |
| 6023 | 8783 | 7778 | 2 | 8266 | 8436 | 2 | 1 | N |
| 6023 | 8783 | 7778 | 3 | 7972 | 8142 | 2 | 1 | N |
| 6023 | 8783 | 7778 | 4 | 7678 | 7848 | 2 | 1 | N |
| 9364 | 12905 | 9448 | 1 | 1188 | 1196 | 1 | N | |
| 9364 | 12905 | 9448 | 2 | 1239 | 1243 | 1 | N | |
| 6023 | 8783 | 7778 | 5 | 7384 | 7554 | 2 | 1 | N |
| 6023 | 8783 | 7778 | 6 | 7090 | 7260 | 2 | 1 | N |
| 6023 | 8783 | 7778 | 7 | 6796 | 6966 | 2 | 1 | N |
| 6087 | 8870 | 9336 | 1 | 8628 | 11116 | 2 | 1 | N |
| 6090 | 8877 | 7334 | 1 | 7352 | 12599 | 2 | 1 | N |
| 5363 | 7903 | 6489 | 1 | 11484 | 16125 | 2 | 1 | N |
| 6127 | 8935 | 7139 | 1 | 7736 | 12058 | 2 | 1 | N |
| 3568 | 5479 | 4951 | 1 | 3510 | 3515 | 1 | N | |
| 4055 | 12103 | 9542 | 1 | 11638 | 15270 | 2 | 1 | N |
| 4102 | 6202 | 6425 | 1 | 13550 | 18506 | 2 | 1 | N |
| 4177 | 6304 | 8957 | 1 | 13490 | 16922 | 2 | 1 | N |
| 3707 | 14608 | 11902 | 1 | 4550 | 4640 | 1 | N | |
| 3707 | 14608 | 11902 | 2 | 4330 | 4366 | 1 | N | |
| 3707 | 14608 | 11902 | 3 | 5421 | 7911 | 1 | N | |
| 10303 | 13771 | 11154 | 1 | 3619 | 9551 | 2 | 1 | Y |
| 10303 | 13771 | 11154 | 2 | 3790 | 10619 | 2 | 2 | Y |
| 2260 | 3734 | 3678 | 1 | 7736 | 14080 | 2 | 1 | N |
| 5644 | 12437 | 9850 | 1 | 8302 | 8312 | 1 | N | |
| 5644 | 12437 | 9850 | 2 | 8344 | 8358 | 1 | N | |
| 7030 | 9970 | 10012 | 1 | 2512 | 2523 | 1 | N | |
| 2848 | 4533 | 9839 | 1 | 14872 | 15071 | 2 | 1 | N |
| 2848 | 4533 | 9839 | 2 | 13909 | 14060 | 2 | 1 | N |
| 2848 | 4533 | 9839 | 3 | 13699 | 13850 | 2 | 1 | N |
| 3724 | 5688 | 5886 | 1 | 10263 | 12867 | 2 | 1 | Y |
| 5963 | 12707 | 7020 | 1 | 7300 | 7618 | 2 | 1 | N |
| 5963 | 12707 | 7020 | 2 | 7720 | 8038 | 2 | 1 | N |
| 5963 | 12707 | 7020 | 3 | 8140 | 8458 | 2 | 1 | N |
| 5963 | 12707 | 7020 | 4 | 8560 | 8878 | 2 | 1 | N |
| 5963 | 12707 | 7020 | 5 | 8980 | 9298 | 2 | 1 | N |
| 5963 | 12707 | 7020 | 6 | 9400 | 9718 | 2 | 1 | N |
| 5963 | 12707 | 7020 | 7 | 9820 | 10138 | 2 | 1 | N |
| 5963 | 12707 | 7020 | 8 | 10240 | 10558 | 2 | 1 | N |
| 5963 | 12707 | 7020 | 9 | 10660 | 10978 | 2 | 1 | N |
| 5963 | 12707 | 7020 | 10 | 11080 | 11398 | 2 | 1 | N |
| 6201 | 9016 | 9414 | 1 | 7610 | 9455 | 2 | 1 | N |
| 6421 | 9266 | 7355 | 1 | 7470 | 10874 | 2 | 1 | N |
| 6474 | 12940 | 7405 | 1 | 7900 | 10702 | 2 | 1 | N |
| 6478 | 12942 | 7407 | 1 | 9650 | 11652 | 2 | 1 | N |
| 6532 | 9404 | 7457 | 1 | 7926 | 9276 | 2 | 1 | N |
| 8350 | 11499 | 9634 | 1 | 1618 | 1622 | 1 | 1 | N |
| 8407 | 11570 | 9454 | 1 | 1557 | 1567 | 1 | 1 | N |
| 2848 | 4533 | 9839 | 4 | 13489 | 13640 | 2 | 1 | N |
| 6894 | 13035 | 9253 | 1 | 3875 | 3882 | 1 | 1 | N |
| 6894 | 13035 | 9253 | 2 | 3944 | 3953 | 1 | 1 | N |
| 6894 | 13035 | 9253 | 3 | 3972 | 3977 | 1 | 3 | N |
| 2848 | 4533 | 9839 | 5 | 13279 | 13430 | 2 | 1 | N |
| 2848 | 4533 | 9839 | 6 | 13069 | 13220 | 2 | 1 | N |
| 3996 | 11282 | 8918 | 1 | 4694 | 4736 | 1 | N | |
| 4351 | 13071 | 5283 | 1 | 6920 | 7654 | 1 | N | |
| 4849 | 12891 | 10295 | 1 | 4952 | 4997 | 1 | N | |
| 4849 | 12891 | 10295 | 2 | 5017 | 5257 | 1 | Y | |
| 5010 | 12898 | 10302 | 1 | 7414 | 7715 | 1 | N | |
| 5298 | 7817 | 6376 | 1 | 6907 | 6917 | 1 | N | |
| 2848 | 4533 | 9839 | 7 | 12859 | 13010 | 2 | 1 | N |
| 2848 | 4533 | 9839 | 8 | 12649 | 12800 | 2 | 1 | N |
| 2848 | 4533 | 9839 | 9 | 12439 | 12590 | 2 | 1 | N |
| 5534 | 8120 | 9358 | 1 | 7356 | 12370 | 2 | 1 | N |
| 5607 | 8204 | 9361 | 1 | 7129 | 12115 | 2 | 1 | N |
| 4525 | 6757 | 5500 | 1 | 2874 | 3052 | 1 | N | |
| 2848 | 4533 | 9839 | 10 | 12212 | 12363 | 2 | 1 | N |
| 2848 | 4533 | 9839 | 11 | 12019 | 12170 | 2 | 1 | N |
| 2848 | 4533 | 9839 | 12 | 11877 | 11882 | 2 | 1 | N |
| 2848 | 4533 | 9839 | 13 | 11730 | 11735 | 2 | 1 | N |
| 2848 | 4533 | 9839 | 14 | 11320 | 11325 | 2 | 1 | N |
| 4931 | 7309 | 8954 | 1 | 9835 | 14055 | 2 | 3 | N |
| 6086 | 12724 | 7108 | 1 | 9540 | 9743 | 2 | 1 | N |
| 6086 | 12724 | 7108 | 2 | 9940 | 10143 | 2 | 1 | N |
| 6086 | 12724 | 7108 | 3 | 10734 | 10912 | 2 | 1 | N |
| 6086 | 12724 | 7108 | 4 | 11084 | 11262 | 2 | 1 | N |
| 6086 | 12724 | 7108 | 5 | 11434 | 11612 | 2 | 1 | N |
| 6086 | 12724 | 7108 | 6 | 11784 | 11962 | 2 | 1 | N |
| 5274 | 7781 | 6490 | 1 | 16990 | 17220 | 2 | 1 | N |
| 7007 | 9943 | 7721 | 1 | 13204 | 13224 | 1 | N | |
| 5274 | 7781 | 6490 | 2 | 16700 | 16930 | 2 | 1 | N |
| 5274 | 7781 | 6490 | 3 | 16410 | 16640 | 2 | 1 | N |
| 6082 | 11089 | 7169 | 1 | 1200 | 1212 | 1 | N | |
| 6082 | 11089 | 7169 | 2 | 1234 | 1248 | 1 | N | |
| 6082 | 11089 | 7169 | 3 | 1270 | 1279 | 1 | N | |
| 4623 | 6878 | 5606 | 1 | 7645 | 9981 | 1 | N | |
| 4644 | 6909 | 5626 | 1 | 8095 | 9044 | 1 | N | |
| 4644 | 6909 | 5626 | 2 | 9093 | 10490 | 1 | N | |
| 5274 | 7781 | 6490 | 4 | 16120 | 16350 | 2 | 1 | N |
| 5274 | 7781 | 6490 | 5 | 15830 | 16060 | 2 | 1 | N |
| 5274 | 7781 | 6490 | 6 | 15540 | 15764 | 2 | 1 | N |
| 5274 | 7781 | 6490 | 7 | 15248 | 15480 | 2 | 1 | N |
| 5274 | 7781 | 6490 | 8 | 14960 | 15190 | 2 | 1 | N |
| 5274 | 7781 | 6490 | 9 | 14760 | 14900 | 2 | 1 | N |
| 5274 | 7781 | 6490 | 10 | 14384 | 14610 | 2 | 1 | N |
| 5274 | 7781 | 6490 | 11 | 14090 | 14320 | 2 | 1 | N |
| 5274 | 7781 | 6490 | 12 | 13800 | 14030 | 2 | 1 | N |
| 5600 | 8197 | 8008 | 1 | 11965 | 16802 | 2 | 1 | N |
Sampled, not exhaustive — enough to tell whether this is the data you want without making the database read tens of millions of rows.
tracking_novarchar
12530
79
16504
48
19453
48
10693
47
16240
45
15316
45
10601
45
16695
40
14361
39
39233
36
15288
34
44073
31
packet_idvarchar
25031
79
21104
48
41738
48
14198
47
43237
45
19670
45
14093
45
21350
40
37074
39
61142
36
41640
34
57308
31
parent_idvarchar
22265
79
41102
48
11713
48
41181
48
17158
46
42218
45
34665
45
18446
40
38666
39
25200
38
27931
36
17075
35
row_novarchar
1
23.7K
2
6.7K
3
4.4K
4
3.1K
5
2.3K
6
1.9K
7
1.6K
8
1.3K
9
966
10
771
11
598
12
498
from_depthvarchar
0
85
7900
35
7950
34
8600
34
8150
34
8700
33
8000
32
8300
31
7600
31
7300
30
9200
30
to_depthvarchar
0
84
10450
28
10350
24
10000
23
10500
22
10700
22
10530
21
10030
21
10100
21
10130
20
10010
19
bottom_hole_labelvarchar
1
26.2K
2
21.6K
3
1.2K
6
826
4
138
lateral_labelvarchar
1
22.8K
2
334
3
152
4
80
5
32
6
16
7
11
9
7
8
5
Back to everything we know about Completion Production Intervals