{"description":"Full business intelligence package","entity":{"id":31634708,"state":"TX","state_id":"Y5E2LL3K9FU1","entity_name":"VAN LEEUWEN PIPE AND TUBE LLC","entity_type":"business | for_profit | NAICS:423830 | CAGE:0YMQ2","entity_type_normalized":"domestic_profit","status":"active","filing_date":"2014-01-09","filing_year":null,"business_age_years":12,"principal_address1":"1225 NORTH LOOP W STE 320","principal_address2":null,"principal_city":"HOUSTON","principal_state":"TX","principal_zip":"77008","principal_country":"USA","mail_address1":null,"mail_address2":null,"mail_city":null,"mail_state":null,"mail_zip":null,"mail_country":null,"location_name":null,"location_address1":null,"location_address2":null,"location_city":null,"location_state":null,"location_zip":null,"fei_ein":"0YMQ2","jurisdiction":"TX","county":null,"last_transaction_date":null,"report_year_1":null,"report_date_1":null,"report_year_2":null,"report_date_2":null,"report_year_3":null,"report_date_3":null,"agent_name":null,"agent_type":null,"agent_address":null,"agent_city":null,"agent_state":null,"agent_zip":null,"process_name":null,"process_address1":null,"process_address2":null,"process_city":null,"process_state":null,"process_zip":null,"source_file":"sam.gov","fetched_at":"2026-06-19T13:35:08.426Z","updated_at":"2026-06-19 13:35:09","last_accessed":null,"status_reason":null},"officers":[],"provenance":{"score":61,"grade":"B","signals":[{"source":"State SoS Registration","weight":20,"detail":"Registered in TX"},{"source":"Active Status","weight":10},{"source":"Business Age","weight":6,"detail":"12 years"},{"source":"SAM.gov Federal Contractor","weight":25,"detail":"UEI: Y5E2LL3K9FU1"}]},"federal":{"sam_registered":true,"sam_entity":{"uei":"Y5E2LL3K9FU1","name":"VAN LEEUWEN PIPE AND TUBE LLC","city":"HOUSTON","state":"TX"},"excluded":false,"exclusions":[],"contract_awards":{"count":0,"total_value":0,"recent":[]},"federal_contracts_url":"https://companies.rootz.global/api/federal-contracts/VAN%20LEEUWEN%20PIPE%20AND%20TUBE%20LLC"},"nonprofit":{"is_nonprofit":false},"web_profile":null,"dot_carriers":[{"id":1111025,"entity_id":31634708,"dot_number":"518565","license_id":null,"match_type":"exact","confidence":0.97,"matched_at":"2026-08-22 04:46:15","dot_name":"VAN LEEUWEN PIPE AND TUBE CORP","power_units":9,"total_drivers":9,"phy_city":"HOUSTON"}],"signals":{"owner_operated":false,"business_age":12,"has_website":false,"has_fleet":true,"is_federal_contractor":true,"is_excluded":false,"is_nonprofit":false,"has_awards":false},"links":{"profile":"https://companies.rootz.global/company/TX/Y5E2LL3K9FU1","provenance":"https://companies.rootz.global/api/provenance/TX/Y5E2LL3K9FU1","property_cross_ref":null,"public_company_cross_ref":"https://companies.rootz.global/api/cross-ref/public?state=TX&state_id=Y5E2LL3K9FU1"},"_ai_instruction":"Complete intelligence for VAN LEEUWEN PIPE AND TUBE LLC. Score 61/100 (B) from 4 sources. Use federal_contracts_url for real-time USAspending.gov data.","_rootz_service":"private.rootz.global"}