iadc_product_specs #27499

id
INTEGER
27499
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
1008136
value
TEXT
GUIDE, STABBING 6-5/8 DRILL PIPE WITH 6-5/8 FH CONNECTION AND 8-1/4 TOOL JOINT | MFR: LMB | P/N: 1008136 | MFG#: STGS0800A
key_normalized
VARCHAR
1008136
value_normalized
VARCHAR
guide, stabbing 6-5/8 drill pipe with 6-5/8 fh connection and 8-1/4 tool joint | mfr: lmb | p/n: 1008136 | mfg#: stgs0800a
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.424777
source_page
INTEGER
null
source_context
TEXT
part_number: 1008136 | description: GUIDE, STABBING 6-5/8 DRILL PIPE WITH 6-5/8 FH CONNECTION AND 8-1/4 TOOL JOINT | manufacturer: LMB | mfg_part_number: STGS0800A | qty_on_hand: 2 | uom: EA