iadc_product_specs #27334

id
INTEGER
27334
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
715810
value
TEXT
UNION, PIPE 2 IN 3000 PSI FORGED STEEL THREADED BLACK | MFR: LAW | P/N: 715810 | MFG#: 83182
key_normalized
VARCHAR
715810
value_normalized
VARCHAR
union, pipe 2 in 3000 psi forged steel threaded black | mfr: law | p/n: 715810 | mfg#: 83182
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.424608
source_page
INTEGER
null
source_context
TEXT
part_number: 715810 | description: UNION, PIPE 2 IN 3000 PSI FORGED STEEL THREADED BLACK | manufacturer: LAW | mfg_part_number: 83182 | qty_on_hand: 0 | uom: EA