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

Home / Companies / CELTIC SHEET METAL, INC.

CELTIC SHEET METAL, INC. 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
CELTIC SHEET METAL, INC.
N/A..., CELTIC SHEET METAL INC
732FY2016 to FY2020
Latest decision 2020-09-28
6MECHANICAL ENGINEER
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings7
Certified LCAs7
Denied LCAs0
Role titles3
Worksites2
Latest decision2020-09-28
USCIS approvals6
USCIS denials0

Aliases and source names

AliasesSource NamesSources
N/A..., CELTIC SHEET METAL INCCELTIC SHEET METAL, INC., CELTIC SHEET METAL INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
MECHANICAL ENGINEER17-21414$61,069$0
MECHANICAL ENGINEER17-2141.00
Mechanical Engineers
1$114,525$145,000
Mechanical Engineers17-2141.00
Mechanical Engineers
1$67,080$67,081
PROJECT MANAGER11-90211$72,467$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
CongersNY109205261,06902,0162,017
New YorkNY109622267,080145,0002,0202,020

Full company payload

Company IDcompany:celtic sheet metal
NameCELTIC SHEET METAL, INC.
Normalized Nameceltic sheet metal
Source Company Idscompany_dol_oflc_lca_celtic_sheet_metal_inc, company_uscis_h1b_datahub_celtic_sheet_metal_inc_tax_2257
Source NamesCELTIC SHEET METAL, INC., CELTIC SHEET METAL INC
AliasesN/A..., CELTIC SHEET METAL INC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "CELTIC SHEET METAL, INC.",
    "CELTIC SHEET METAL INC"
  ],
  "dba_names": [
    "N/A..."
  ],
  "name_variants": [
    {
      "value": "CELTIC SHEET METAL INC.",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CELTIC SHEET METAL, INC",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CELTIC SHEET METAL, INC.",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "N/A...",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CELTIC SHEET METAL INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "2257",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 7,
  "case_count": 7,
  "role_title_count": 3,
  "worksite_count": 2,
  "total_workers": 7,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-17",
  "latest_fiscal_year": 2020,
  "latest_decision_date": "2020-09-28",
  "certified_count": 7,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 6,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 6,
  "total_denial": 0,
  "fiscal_years": [
    "2014",
    "2017",
    "2018",
    "2020",
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "Congers"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "10920"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_celtic_sheet_metal_inc_tax_2257_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_006451"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Congers"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "10920"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_celtic_sheet_metal_inc_tax_2257_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_004791"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Congers"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "10920"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_celtic_sheet_metal_inc_tax_2257_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_005068"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Orangeburg"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "10962"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_celtic_sheet_metal_inc_tax_2257_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_009129"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Orangeburg"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "10962"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_celtic_sheet_metal_inc_tax_2257_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_010229"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10962",
      "city": "New York",
      "state": "NY",
      "postal_code": "10962",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-09-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CONGERS NY 10920",
      "city": "Congers",
      "state": "NY",
      "postal_code": "10920",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-06-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10962",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10962",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-09-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10962",
      "city": "New York",
      "county": "Rockland",
      "state": "NY",
      "postal_code": "10962",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-04-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CONGERS NY 10920",
      "city": "Congers",
      "county": "Rockland",
      "state": "NY",
      "postal_code": "10920",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-06-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CONGERS NY 10920",
      "city": "Congers",
      "county": "Rockland County",
      "state": "NY",
      "postal_code": "10920",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 4,
    "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": [
    "NY"
  ],
  "cities": [
    "Congers",
    "New York",
    "Orangeburg"
  ],
  "postal_codes": [
    "10920",
    "10962"
  ],
  "top_markets": [
    {
      "city": "Congers",
      "state": "NY",
      "postal_code": "10920",
      "lca_count": 5,
      "role_title_count": 2,
      "wage_low_min": 61069,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10962",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 67080,
      "wage_high_max": 145000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    }
  ]
}
Industry
{
  "naics_codes": [
    "332322",
    "33"
  ],
  "naics_breakdown": [
    {
      "value": "332322",
      "filing_count": 6,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 61069,
  "annualized_high_max": 145000,
  "annualized_low_avg": 71266.8571428571
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 61589,
    "wage_high_max": 0,
    "wage_low_avg": 61589
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 61069,
    "wage_high_max": 0,
    "wage_low_avg": 63918.5
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 114525,
    "wage_high_max": 145000,
    "wage_low_avg": 114525
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 67080,
    "wage_high_max": 67081,
    "wage_low_avg": 67080
  }
]
Links
{
  "roles": "/v1/roles?company=CELTIC%20SHEET%20METAL%2C%20INC.",
  "wages": "/v1/wages?company=CELTIC%20SHEET%20METAL%2C%20INC.",
  "trends": "/v1/trends?company=CELTIC%20SHEET%20METAL%2C%20INC."
}
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=celtic+sheet+metal+inc&limit=5JSON