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

Home / Companies / Merchants Insurance Group

Merchants Insurance Group 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
Merchants Insurance Group
MERCHANTS INSURANCE GROUP
312FY2018 to FY2021
Latest decision 2021-01-28
6Sr. Programmer Analyst III
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings3
Certified LCAs3
Denied LCAs0
Role titles1
Worksites2
Latest decision2021-01-28
USCIS approvals6
USCIS denials0

Aliases and source names

AliasesSource NamesSources
MERCHANTS INSURANCE GROUPMerchants Insurance Group, MERCHANTS INSURANCE GROUPdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Sr. Programmer Analyst III15-1132.00
Software Developers, Applications
2$94,547$94,547
SR. PROGRAMMER ANALYST III15-11321$84,876$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
East AmherstNY140512194,54794,5472,0212,021
BuffaloNY142021184,87602,0182,018

Full company payload

Company IDcompany:merchants insurance group
NameMerchants Insurance Group
Normalized Namemerchants insurance group
Source Company Idscompany_dol_oflc_lca_merchants_insurance_group, company_uscis_h1b_datahub_merchants_insurance_group_tax_0140
Source NamesMerchants Insurance Group, MERCHANTS INSURANCE GROUP
AliasesMERCHANTS INSURANCE GROUP
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Merchants Insurance Group",
    "MERCHANTS INSURANCE GROUP"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Merchants Insurance Group",
      "filing_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "MERCHANTS INSURANCE GROUP",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "0140",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 3,
  "case_count": 3,
  "role_title_count": 1,
  "worksite_count": 2,
  "total_workers": 3,
  "first_fiscal_year": 2018,
  "first_received_date": "2018-01-05",
  "latest_fiscal_year": 2021,
  "latest_decision_date": "2021-01-28",
  "certified_count": 3,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "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": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "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": [
    "2012",
    "2015",
    "2018",
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "Buffalo"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "14202"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_merchants_insurance_group_tax_0140_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_008543"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Buffalo"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "14202"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_merchants_insurance_group_tax_0140_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_006184"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Buffalo"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "14202"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_merchants_insurance_group_tax_0140_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_006086"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Buffalo"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "52"
      ],
      "postal_codes": [
        "14202"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_merchants_insurance_group_tax_0140_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_033539"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "BUFFALO NY 14202",
      "city": "Buffalo",
      "state": "NY",
      "postal_code": "14202",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-01-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "EAST AMHERST NY 14051",
      "city": "East Amherst",
      "county": "Erie",
      "state": "NY",
      "postal_code": "14051",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-01-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BUFFALO NY 14202",
      "city": "Buffalo",
      "county": "Erie",
      "state": "NY",
      "postal_code": "14202",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-01-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 2,
    "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": [
    "East Amherst",
    "Buffalo"
  ],
  "postal_codes": [
    "14051",
    "14202"
  ],
  "top_markets": [
    {
      "city": "East Amherst",
      "state": "NY",
      "postal_code": "14051",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 94547,
      "wage_high_max": 94547,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021
    },
    {
      "city": "Buffalo",
      "state": "NY",
      "postal_code": "14202",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 84876,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "524126",
    "52"
  ],
  "naics_breakdown": [
    {
      "value": "524126",
      "filing_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 84876,
  "annualized_high_max": 94547,
  "annualized_low_avg": 91323.3333333333
}
Trend
[
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 84876,
    "wage_high_max": 0,
    "wage_low_avg": 84876
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 94547,
    "wage_high_max": 94547,
    "wage_low_avg": 94547
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 94547,
    "wage_high_max": 94547,
    "wage_low_avg": 94547
  }
]
Links
{
  "roles": "/v1/roles?company=Merchants%20Insurance%20Group",
  "wages": "/v1/wages?company=Merchants%20Insurance%20Group",
  "trends": "/v1/trends?company=Merchants%20Insurance%20Group"
}
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=merchants+insurance+group&limit=5JSON