Home / Companies / dba SP Foundry

dba SP Foundry H-1B company data

Employer profile assembled from DOL OFLC LCA rows and USCIS H-1B Employer Data Hub petition summaries. Rows below include aliases, source IDs, filing coverage, petition counts, role coverage, worksite coverage, and wage summary fields when present.

Role rows Wage rows Trends

Employer	LCA filings	Role titles	Worksites	Coverage	USCIS approvals	Top role	Sources	Open
dba SP Foundry DBA SP FOUNDRY, SP Foundry, SP FOUNDRY	15	10	1	FY2018 to FY2024 Latest decision 2024-06-26	0	INDUSTRIAL ENGINEER 2 filings	dol_oflc_lca	Profile

Activity summary

LCA filings	15
Certified LCAs	12
Denied LCAs	0
Role titles	10
Worksites	1
Latest decision	2024-06-26
USCIS approvals	0
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
DBA SP FOUNDRY, SP Foundry, SP FOUNDRY, dba SP Foundry	dba SP Foundry	dol_oflc_lca

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
INDUSTRIAL ENGINEER	17-2112 INDUSTRIAL ENGINEERS	2	$41,850	$56,347
Melting Coordinator	19-2031.00 Chemists	2	$65,000	$65,000
Project Coordinator	17-2199.00 Engineers, All Other	2	$80,000	$85,000
TECHNICAL SERVICE ENGINEER	17-2141 MECHANICAL ENGINEERS	2	$75,000	$80,000
Asst Manager, PPC (Production Planning & Control)	17-2112.00 Industrial Engineers	1	$77,597	$77,597
CONTROLS ENGINEER	17-2071 ELECTRICAL ENGINEERS	1	$57,886	$57,886
Industrial Engineer	17-2112.00 Industrial Engineers	1	$55,000	$55,000
Maintenance Manager	11-3051.00 Industrial Production Managers	1	$80,000	$80,000
MANUFACTURING ENGINEER	17-2141	1	$72,000	$0
MECHANICAL ENGINEER	17-2141 MECHANICAL ENGINEERS	1	$61,069	$61,069

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
South Coffeyville	OK	74072	15	10	41,850	85,000	2,018	2,024

Full company payload

Company ID	company:sp foundry
Name	dba SP Foundry
Normalized Name	sp foundry
Source Company Ids	company_dol_oflc_lca_star_pipe_usa_llc
Source Names	dba SP Foundry
Aliases	DBA SP FOUNDRY, SP Foundry, SP FOUNDRY, dba SP Foundry
Identifiers	-
Sources	dol_oflc_lca

Names

{
  "source_names": [
    "dba SP Foundry"
  ],
  "dba_names": [
    "DBA SP FOUNDRY",
    "SP Foundry",
    "SP FOUNDRY",
    "dba SP Foundry"
  ],
  "name_variants": [
    {
      "value": "DBA SP FOUNDRY",
      "filing_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SP Foundry",
      "filing_count": 4,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SP FOUNDRY",
      "filing_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "dba SP Foundry",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Star Pipe USA, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}

LCA Activity

{
  "lca_count": 15,
  "case_count": 15,
  "role_title_count": 10,
  "worksite_count": 1,
  "total_workers": 15,
  "first_fiscal_year": 2018,
  "first_received_date": "2018-03-20",
  "latest_fiscal_year": 2024,
  "latest_decision_date": "2024-06-26",
  "certified_count": 12,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 6,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 6,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Withdrawn",
      "filing_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 15,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 15,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 0,
  "total_denial": 0,
  "fiscal_years": [],
  "year_metrics": []
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "HOUSTON TX 77082",
      "city": "Houston",
      "state": "TX",
      "postal_code": "77082",
      "filing_count": 15,
      "case_count": 15,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-06-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "SOUTH COFFEYVILLE OK 74072",
      "city": "South Coffeyville",
      "county": "Nowata",
      "state": "OK",
      "postal_code": "74072",
      "filing_count": 15,
      "case_count": 15,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-06-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 1,
    "has_street_address_evidence": true,
    "caveat": "LCA employer/worksite addresses are capped filing evidence scoped to matched source company names and should not be treated as verified headquarters without external validation."
  }
}

Geography

{
  "states": [
    "OK"
  ],
  "cities": [
    "South Coffeyville"
  ],
  "postal_codes": [
    "74072"
  ],
  "top_markets": [
    {
      "city": "South Coffeyville",
      "state": "OK",
      "postal_code": "74072",
      "lca_count": 15,
      "role_title_count": 10,
      "wage_low_min": 41850,
      "wage_high_max": 85000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2024
    }
  ]
}

Industry

{
  "naics_codes": [
    "333511"
  ],
  "naics_breakdown": [
    {
      "value": "333511",
      "filing_count": 15,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 41850,
  "annualized_high_max": 85000,
  "annualized_low_avg": 67449.9333333333
}

Trend

[
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 60000,
    "wage_high_max": 0,
    "wage_low_avg": 66000
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 4,
    "worksite_count": 1,
    "wage_low_min": 41850,
    "wage_high_max": 80000,
    "wage_low_avg": 62025.3333333333
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 55000,
    "wage_high_max": 55000,
    "wage_low_avg": 55000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 65000,
    "wage_high_max": 65000,
    "wage_low_avg": 65000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 80000,
    "wage_high_max": 80000,
    "wage_low_avg": 80000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 77597,
    "wage_high_max": 77597,
    "wage_low_avg": 77597
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 65000,
    "wage_high_max": 85000,
    "wage_low_avg": 76666.6666666667
  }
]

Links

{
  "roles": "/v1/roles?company=dba%20SP%20Foundry",
  "wages": "/v1/wages?company=dba%20SP%20Foundry",
  "trends": "/v1/trends?company=dba%20SP%20Foundry"
}

Get this page with API

Rendered from the bluedoor H-1B Jobs API. Reproduce it:

GET https://api.bluedoor.sh/h1b-jobs/v1/companies?q=dba+sp+foundry&limit=5JSON

Docs · Get an API key