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

Home / Companies / STURNER ADVISORY LLC

STURNER ADVISORY 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
STURNER ADVISORY LLC432FY2019 to FY2021
Latest decision 2021-09-30
0ADVISOR
2 filings
dol_oflc_lcaProfile

Activity summary

LCA filings4
Certified LCAs3
Denied LCAs1
Role titles3
Worksites2
Latest decision2021-09-30
USCIS approvals0
USCIS denials0

Aliases and source names

AliasesSource NamesSources
-STURNER ADVISORY LLCdol_oflc_lca

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
ADVISOR11-1021
GENERAL AND OPERATIONS MANAGERS
2$56,000$56,000
Business Operations Manager11-1021.00
General and Operations Managers
1$79,040$79,040
FINANCIAL ADVISOR13-2051
FINANCIAL ANALYSTS
1$70,000$70,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
ColumbusOH432013256,00070,0002,0192,019
BrooklynNY112011179,04079,0402,0212,021

Full company payload

Company IDcompany:sturner advisory
NameSTURNER ADVISORY LLC
Normalized Namesturner advisory
Source Company Idscompany_dol_oflc_lca_sturner_advisory_llc
Source NamesSTURNER ADVISORY LLC
Aliases-
Identifiers-
Sourcesdol_oflc_lca
Names
{
  "source_names": [
    "STURNER ADVISORY LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "STURNER ADVISORY LLC",
      "filing_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Sturner Advisory LLC",
      "filing_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}
LCA Activity
{
  "lca_count": 4,
  "case_count": 4,
  "role_title_count": 3,
  "worksite_count": 2,
  "total_workers": 4,
  "first_fiscal_year": 2019,
  "first_received_date": "2019-08-19",
  "latest_fiscal_year": 2021,
  "latest_decision_date": "2021-09-30",
  "certified_count": 3,
  "denied_count": 1,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "E-3 Australian",
      "filing_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "N",
      "filing_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "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": "COLUMBUS OH 43201",
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43201",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-09-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "BROOKLYN NY 11201",
      "city": "Brooklyn",
      "county": "Kings",
      "state": "NY",
      "postal_code": "11201",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-09-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBUS OH 43201",
      "city": "Columbus",
      "county": "Franklin",
      "state": "OH",
      "postal_code": "43201",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-09-06",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBUS OH 43201",
      "city": "Columbus",
      "county": "Ohio",
      "state": "OH",
      "postal_code": "43201",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-08-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 3,
    "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": [
    "OH",
    "NY"
  ],
  "cities": [
    "Columbus",
    "Brooklyn"
  ],
  "postal_codes": [
    "43201",
    "11201"
  ],
  "top_markets": [
    {
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43201",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 56000,
      "wage_high_max": 70000,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Brooklyn",
      "state": "NY",
      "postal_code": "11201",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 79040,
      "wage_high_max": 79040,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021
    }
  ]
}
Industry
{
  "naics_codes": [
    "541611"
  ],
  "naics_breakdown": [
    {
      "value": "541611",
      "filing_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 56000,
  "annualized_high_max": 79040,
  "annualized_low_avg": 65260
}
Trend
[
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 56000,
    "wage_high_max": 70000,
    "wage_low_avg": 60666.6666666667
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 79040,
    "wage_high_max": 79040,
    "wage_low_avg": 79040
  }
]
Links
{
  "roles": "/v1/roles?company=STURNER%20ADVISORY%20LLC",
  "wages": "/v1/wages?company=STURNER%20ADVISORY%20LLC",
  "trends": "/v1/trends?company=STURNER%20ADVISORY%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=sturner+advisory+llc&limit=5JSON