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

Home / Companies / SPEC CONSULTING, LLC

SPEC CONSULTING, 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
SPEC CONSULTING, LLC
SPEC CONSULTING LLC
332FY2017 to FY2019
Latest decision 2019-03-14
2ELECTRICAL ENGINEER
1 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings3
Certified LCAs3
Denied LCAs0
Role titles3
Worksites2
Latest decision2019-03-14
USCIS approvals2
USCIS denials0

Aliases and source names

AliasesSource NamesSources
SPEC CONSULTING LLCSPEC CONSULTING, LLC, SPEC CONSULTING LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
ELECTRICAL ENGINEER17-2071
ELECTRICAL ENGINEERS
1$70,054$70,054
MATERIALS SCIENTIST19-20321$72,134$0
PROCESS ENGINEER17-21311$70,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
HoustonTX770562270,00002,0172,018
AlbanyNY122041170,05470,0542,0192,019

Full company payload

Company IDcompany:spec consulting
NameSPEC CONSULTING, LLC
Normalized Namespec consulting
Source Company Idscompany_dol_oflc_lca_spec_consulting_llc, company_uscis_h1b_datahub_spec_consulting_llc_tax_8499
Source NamesSPEC CONSULTING, LLC, SPEC CONSULTING LLC
AliasesSPEC CONSULTING LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "SPEC CONSULTING, LLC",
    "SPEC CONSULTING LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "SPEC CONSULTING, LLC",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SPEC CONSULTING LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8499",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 3,
  "case_count": 3,
  "role_title_count": 3,
  "worksite_count": 2,
  "total_workers": 3,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-03-03",
  "latest_fiscal_year": 2019,
  "latest_decision_date": "2019-03-14",
  "certified_count": 3,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "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": [
    "2010",
    "2011"
  ],
  "year_metrics": [
    {
      "cities": [
        "Albany"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "12205"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_spec_consulting_llc_tax_8499_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_008849"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Albany"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "12205"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_spec_consulting_llc_tax_8499_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_009693"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "ALBANY NY 12204",
      "city": "Albany",
      "state": "NY",
      "postal_code": "12204",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ALBANY NY 12204",
      "city": "Albany",
      "county": "Albany",
      "state": "NY",
      "postal_code": "12204",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HOUSTON TX 77056",
      "city": "Houston",
      "county": "Harris",
      "state": "TX",
      "postal_code": "77056",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-12",
      "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": [
    "TX",
    "NY"
  ],
  "cities": [
    "Houston",
    "Albany"
  ],
  "postal_codes": [
    "77056",
    "12204",
    "12205"
  ],
  "top_markets": [
    {
      "city": "Houston",
      "state": "TX",
      "postal_code": "77056",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 70000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Albany",
      "state": "NY",
      "postal_code": "12204",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 70054,
      "wage_high_max": 70054,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    }
  ]
}
Industry
{
  "naics_codes": [
    "541330",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541330",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 70000,
  "annualized_high_max": 70054,
  "annualized_low_avg": 70729.3333333333
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 70000,
    "wage_high_max": 0,
    "wage_low_avg": 70000
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 72134,
    "wage_high_max": 0,
    "wage_low_avg": 72134
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 70054,
    "wage_high_max": 70054,
    "wage_low_avg": 70054
  }
]
Links
{
  "roles": "/v1/roles?company=SPEC%20CONSULTING%2C%20LLC",
  "wages": "/v1/wages?company=SPEC%20CONSULTING%2C%20LLC",
  "trends": "/v1/trends?company=SPEC%20CONSULTING%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=spec+consulting+llc&limit=5JSON