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

Home / Companies / BARTELL MACHINERY SYSTEMS, LLC

BARTELL MACHINERY SYSTEMS, 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
BARTELL MACHINERY SYSTEMS, LLC
BARTELL MACHINERY SYSTEMS LLC
111FY2018 to FY2018
Latest decision 2018-07-06
2OIL & GAS ENGINEERING MANAGER
1 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings1
Certified LCAs1
Denied LCAs0
Role titles1
Worksites1
Latest decision2018-07-06
USCIS approvals2
USCIS denials0

Aliases and source names

AliasesSource NamesSources
BARTELL MACHINERY SYSTEMS LLCBARTELL MACHINERY SYSTEMS, LLC, BARTELL MACHINERY SYSTEMS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
OIL & GAS ENGINEERING MANAGER11-30511$104,857$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
RomeNY1344011104,85702,0182,018

Full company payload

Company IDcompany:bartell machinery systems
NameBARTELL MACHINERY SYSTEMS, LLC
Normalized Namebartell machinery systems
Source Company Idscompany_dol_oflc_lca_bartell_machinery_systems_llc, company_uscis_h1b_datahub_bartell_machinery_systems_llc_tax_5371
Source NamesBARTELL MACHINERY SYSTEMS, LLC, BARTELL MACHINERY SYSTEMS LLC
AliasesBARTELL MACHINERY SYSTEMS LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "BARTELL MACHINERY SYSTEMS, LLC",
    "BARTELL MACHINERY SYSTEMS LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "BARTELL MACHINERY SYSTEMS, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "BARTELL MACHINERY SYSTEMS LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5371",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 1,
  "case_count": 1,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 1,
  "first_fiscal_year": 2018,
  "first_received_date": "2018-06-30",
  "latest_fiscal_year": 2018,
  "latest_decision_date": "2018-07-06",
  "certified_count": 1,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 2,
  "total_denial": 0,
  "fiscal_years": [
    "2015",
    "2018"
  ],
  "year_metrics": [
    {
      "cities": [
        "Rome"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "13440"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_bartell_machinery_systems_llc_tax_5371_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_023169"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Rome"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "13440"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_bartell_machinery_systems_llc_tax_5371_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_023570"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "ROME NY 13440",
      "city": "Rome",
      "state": "NY",
      "postal_code": "13440",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-07-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ROME NY 13440",
      "city": "Rome",
      "county": "Oneida",
      "state": "NY",
      "postal_code": "13440",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-07-06",
      "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": [
    "NY"
  ],
  "cities": [
    "Rome"
  ],
  "postal_codes": [
    "13440"
  ],
  "top_markets": [
    {
      "city": "Rome",
      "state": "NY",
      "postal_code": "13440",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 104857,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "3332",
    "33"
  ],
  "naics_breakdown": [
    {
      "value": "3332",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 104857,
  "annualized_high_max": 0,
  "annualized_low_avg": 104857
}
Trend
[
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 104857,
    "wage_high_max": 0,
    "wage_low_avg": 104857
  }
]
Links
{
  "roles": "/v1/roles?company=BARTELL%20MACHINERY%20SYSTEMS%2C%20LLC",
  "wages": "/v1/wages?company=BARTELL%20MACHINERY%20SYSTEMS%2C%20LLC",
  "trends": "/v1/trends?company=BARTELL%20MACHINERY%20SYSTEMS%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=bartell+machinery+systems+llc&limit=5JSON