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

Home / Companies / SPICY CITY

SPICY CITY 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
SPICY CITY
SPICY CITY
111FY2018 to FY2018
Latest decision 2018-08-23
0SOFTWARE DEVELOPER
1 filings
dol_oflc_lcaProfile

Activity summary

LCA filings1
Certified LCAs1
Denied LCAs0
Role titles1
Worksites1
Latest decision2018-08-23
USCIS approvals0
USCIS denials0

Aliases and source names

AliasesSource NamesSources
SPICY CITYSPICY CITYdol_oflc_lca

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SOFTWARE DEVELOPER15-11321$105,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
RedmondWA9805211105,00002,0182,018

Full company payload

Company IDcompany:spicy city
NameSPICY CITY
Normalized Namespicy city
Source Company Idscompany_dol_oflc_lca_authentic_chinese_cuisine_llc
Source NamesSPICY CITY
AliasesSPICY CITY
Identifiers-
Sourcesdol_oflc_lca
Names
{
  "source_names": [
    "SPICY CITY"
  ],
  "dba_names": [
    "SPICY CITY"
  ],
  "name_variants": [
    {
      "value": "SPICY CITY",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
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-08-17",
  "latest_fiscal_year": 2018,
  "latest_decision_date": "2018-08-23",
  "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": 0,
  "total_denial": 0,
  "fiscal_years": [],
  "year_metrics": []
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "REDMOND WA 98052",
      "city": "Redmond",
      "state": "WA",
      "postal_code": "98052",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-08-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "REDMOND WA 98052",
      "city": "Redmond",
      "county": "Washington",
      "state": "WA",
      "postal_code": "98052",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-08-23",
      "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": [
    "WA"
  ],
  "cities": [
    "Redmond"
  ],
  "postal_codes": [
    "98052"
  ],
  "top_markets": [
    {
      "city": "Redmond",
      "state": "WA",
      "postal_code": "98052",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 105000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "722511"
  ],
  "naics_breakdown": [
    {
      "value": "722511",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 105000,
  "annualized_high_max": 0,
  "annualized_low_avg": 105000
}
Trend
[
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 105000,
    "wage_high_max": 0,
    "wage_low_avg": 105000
  }
]
Links
{
  "roles": "/v1/roles?company=SPICY%20CITY",
  "wages": "/v1/wages?company=SPICY%20CITY",
  "trends": "/v1/trends?company=SPICY%20CITY"
}
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=spicy+city&limit=5JSON