bluedoor data·H-1B Jobs API·bluedoor.sh ->

Home / Companies / HALPIN DESIGN, LLC

HALPIN DESIGN, LLC 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.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
HALPIN DESIGN, LLC
HALPIN DESIGN LLC
111FY2016 to FY2016
Latest decision 2016-05-19
2DESIGNER POWERTRAIN
1 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings1
Certified LCAs0
Denied LCAs0
Role titles1
Worksites1
Latest decision2016-05-19
USCIS approvals2
USCIS denials0

Aliases and source names

AliasesSource NamesSources
HALPIN DESIGN LLCHALPIN DESIGN, LLC, HALPIN DESIGN LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
DESIGNER POWERTRAIN27-10211$74,880$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
Rochester HillsMI483091174,88002,0162,016

Full company payload

Company IDcompany:halpin design
NameHALPIN DESIGN, LLC
Normalized Namehalpin design
Source Company Idscompany_dol_oflc_lca_halpin_design_llc, company_uscis_h1b_datahub_halpin_design_llc_tax_3375
Source NamesHALPIN DESIGN, LLC, HALPIN DESIGN LLC
AliasesHALPIN DESIGN LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "HALPIN DESIGN, LLC",
    "HALPIN DESIGN LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "HALPIN DESIGN, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "HALPIN DESIGN LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "3375",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 1,
  "case_count": 1,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 2,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-05-13",
  "latest_fiscal_year": 2016,
  "latest_decision_date": "2016-05-19",
  "certified_count": 0,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": []
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 2,
  "total_denial": 0,
  "fiscal_years": [
    "2012"
  ],
  "year_metrics": [
    {
      "cities": [
        "Sterling Heights"
      ],
      "states": [
        "MI"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "48312"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_halpin_design_llc_tax_3375_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_030618"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "ROCHESTER HILLS MI 48309",
      "city": "Rochester Hills",
      "state": "MI",
      "postal_code": "48309",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-05-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ROCHESTER HILLS MI 48309",
      "city": "Rochester Hills",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48309",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-05-19",
      "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": [
    "MI"
  ],
  "cities": [
    "Rochester Hills",
    "Sterling Heights"
  ],
  "postal_codes": [
    "48309",
    "48312"
  ],
  "top_markets": [
    {
      "city": "Rochester Hills",
      "state": "MI",
      "postal_code": "48309",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 74880,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "54"
  ],
  "naics_breakdown": []
}
Wage Summary
{
  "annualized_low_min": 74880,
  "annualized_high_max": 0,
  "annualized_low_avg": 74880
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 74880,
    "wage_high_max": 0,
    "wage_low_avg": 74880
  }
]
Links
{
  "roles": "/v1/roles?company=HALPIN%20DESIGN%2C%20LLC",
  "wages": "/v1/wages?company=HALPIN%20DESIGN%2C%20LLC",
  "trends": "/v1/trends?company=HALPIN%20DESIGN%2C%20LLC"
}
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=halpin+design+llc&limit=5JSON