iadc_product_specs #24539

id
INTEGER
24539
iadc_material_id
INTEGER
2654 → iadc_discovered_materials
spec_type
VARCHAR
spare_part
key
VARCHAR
667109
value
TEXT
VALVE, GATE 2 IN 150 PSI BRONZE UNION BONNET | MFR: GRI | P/N: 667109 | MFG#: 3080-2
key_normalized
VARCHAR
667109
value_normalized
VARCHAR
valve, gate 2 in 150 psi bronze union bonnet | mfr: gri | p/n: 667109 | mfg#: 3080-2
value_numeric
DOUBLE_PRECISION
null
unit
VARCHAR
EA
created_at
TIMESTAMP
2026-06-03T05:55:21.421638
source_page
INTEGER
null
source_context
TEXT
part_number: 667109 | description: VALVE, GATE 2 IN 150 PSI BRONZE UNION BONNET | manufacturer: GRI | mfg_part_number: 3080-2 | qty_on_hand: 1 | uom: EA