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

Home / Companies / Uplancer Agency LLC

Uplancer Agency 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
Uplancer Agency LLC
UPLANCER AGENCY LLC
1123FY2021 to FY2022
Latest decision 2022-03-04
2Business Manager
7 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings11
Certified LCAs7
Denied LCAs4
Role titles2
Worksites3
Latest decision2022-03-04
USCIS approvals2
USCIS denials0

Aliases and source names

AliasesSource NamesSources
UPLANCER AGENCY LLCUplancer Agency LLC, UPLANCER AGENCY LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Business Manager15-2031.00
Operations Research Analysts
7$66,643$94,744
Solutions Architect15-1199.02
Computer Systems Engineers/Architects
4$72,883$100,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
HilliardOH430269266,643100,0002,0212,021
OswegoIL605431180,40080,4002,0222,022
ColumbusOH432211178,00078,0002,0212,021

Full company payload

Company IDcompany:uplancer agency
NameUplancer Agency LLC
Normalized Nameuplancer agency
Source Company Idscompany_dol_oflc_lca_uplancer_agency_llc, company_uscis_h1b_datahub_uplancer_agency_llc_tax_2803
Source NamesUplancer Agency LLC, UPLANCER AGENCY LLC
AliasesUPLANCER AGENCY LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Uplancer Agency LLC",
    "UPLANCER AGENCY LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Uplancer Agency LLC",
      "filing_count": 11,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "UPLANCER AGENCY LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "2803",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 11,
  "case_count": 11,
  "role_title_count": 2,
  "worksite_count": 3,
  "total_workers": 11,
  "first_fiscal_year": 2021,
  "first_received_date": "2021-02-26",
  "latest_fiscal_year": 2022,
  "latest_decision_date": "2022-03-04",
  "certified_count": 7,
  "denied_count": 4,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 7,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Denied",
      "filing_count": 4,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 11,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 11,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "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": [
    "2021",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43221"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_uplancer_agency_llc_tax_2803_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_056294"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "43221"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_uplancer_agency_llc_tax_2803_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_055659"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "COLUMBUS OH 43221",
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43221",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-03-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "HILLIARD OH 43026",
      "city": "Hilliard",
      "state": "OH",
      "postal_code": "43026",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-04-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "HILLIARD OH 43110",
      "city": "Hilliard",
      "state": "OH",
      "postal_code": "43110",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-03-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "OSWEGO IL 60543",
      "city": "Oswego",
      "county": "Kendall",
      "state": "IL",
      "postal_code": "60543",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-03-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "HILLIARD OH 43026",
      "city": "Hilliard",
      "county": "Franklin",
      "state": "OH",
      "postal_code": "43026",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-04-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBUS OH 43221",
      "city": "Columbus",
      "county": "Franklin",
      "state": "OH",
      "postal_code": "43221",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-06-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "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",
    "IL"
  ],
  "cities": [
    "Hilliard",
    "Oswego",
    "Columbus"
  ],
  "postal_codes": [
    "43026",
    "60543",
    "43221"
  ],
  "top_markets": [
    {
      "city": "Hilliard",
      "state": "OH",
      "postal_code": "43026",
      "lca_count": 9,
      "role_title_count": 2,
      "wage_low_min": 66643,
      "wage_high_max": 100000,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021
    },
    {
      "city": "Oswego",
      "state": "IL",
      "postal_code": "60543",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 80400,
      "wage_high_max": 80400,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43221",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 78000,
      "wage_high_max": 78000,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021
    }
  ]
}
Industry
{
  "naics_codes": [
    "5416",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "5416",
      "filing_count": 11,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 66643,
  "annualized_high_max": 100000,
  "annualized_low_avg": 75768.3636363636
}
Trend
[
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 66643,
    "wage_high_max": 100000,
    "wage_low_avg": 75631.5
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 66643,
    "wage_high_max": 100000,
    "wage_low_avg": 75087.6666666667
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 80400,
    "wage_high_max": 80400,
    "wage_low_avg": 80400
  }
]
Links
{
  "roles": "/v1/roles?company=Uplancer%20Agency%20LLC",
  "wages": "/v1/wages?company=Uplancer%20Agency%20LLC",
  "trends": "/v1/trends?company=Uplancer%20Agency%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=uplancer+agency+llc&limit=5JSON