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

Home / Companies / Clarkson College

Clarkson College 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
Clarkson College
CLARKSON COLLEGE
411FY2018 to FY2023
Latest decision 2023-01-11
2DATABASE ENGINEER
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings4
Certified LCAs4
Denied LCAs0
Role titles1
Worksites1
Latest decision2023-01-11
USCIS approvals2
USCIS denials1

Aliases and source names

AliasesSource NamesSources
CLARKSON COLLEGEClarkson College, CLARKSON COLLEGEdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
DATABASE ENGINEER15-1141
DATABASE ADMINISTRATORS
2$70,949$75,468
Database Engineer15-1141.00
Database Administrators
2$78,915$78,915

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
OmahaNE681314170,94978,9152,0182,023

Full company payload

Company IDcompany:clarkson college
NameClarkson College
Normalized Nameclarkson college
Source Company Idscompany_dol_oflc_lca_clarkson_college, company_uscis_h1b_datahub_clarkson_college_tax_9217
Source NamesClarkson College, CLARKSON COLLEGE
AliasesCLARKSON COLLEGE
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Clarkson College",
    "CLARKSON COLLEGE"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Clarkson College",
      "filing_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CLARKSON COLLEGE",
      "filing_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CLARKSON COLLEGE",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9217",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 4,
  "case_count": 4,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 4,
  "first_fiscal_year": 2018,
  "first_received_date": "2018-01-10",
  "latest_fiscal_year": 2023,
  "latest_decision_date": "2023-01-11",
  "certified_count": 4,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 2,
  "total_denial": 1,
  "fiscal_years": [
    "2019",
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "Omaha"
      ],
      "states": [
        "NE"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "68131"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_clarkson_college_tax_9217_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_023281"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Omaha"
      ],
      "states": [
        "NE"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "68131"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_clarkson_college_tax_9217_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_011447"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "OMAHA NE 68131",
      "city": "Omaha",
      "state": "NE",
      "postal_code": "68131",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-01-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "OMAHA NE 68131",
      "city": "Omaha",
      "county": "Douglas",
      "state": "NE",
      "postal_code": "68131",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-01-11",
      "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": [
    "NE"
  ],
  "cities": [
    "Omaha"
  ],
  "postal_codes": [
    "68131"
  ],
  "top_markets": [
    {
      "city": "Omaha",
      "state": "NE",
      "postal_code": "68131",
      "lca_count": 4,
      "role_title_count": 1,
      "wage_low_min": 70949,
      "wage_high_max": 78915,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023
    }
  ]
}
Industry
{
  "naics_codes": [
    "611310",
    "61"
  ],
  "naics_breakdown": [
    {
      "value": "611310",
      "filing_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 70949,
  "annualized_high_max": 78915,
  "annualized_low_avg": 76061.75
}
Trend
[
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 70949,
    "wage_high_max": 0,
    "wage_low_avg": 70949
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 75468,
    "wage_high_max": 75468,
    "wage_low_avg": 75468
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 78915,
    "wage_high_max": 78915,
    "wage_low_avg": 78915
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 78915,
    "wage_high_max": 78915,
    "wage_low_avg": 78915
  }
]
Links
{
  "roles": "/v1/roles?company=Clarkson%20College",
  "wages": "/v1/wages?company=Clarkson%20College",
  "trends": "/v1/trends?company=Clarkson%20College"
}
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=clarkson+college&limit=5JSON