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

Home / Companies / Columbia College

Columbia 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
Columbia College
COLUMBIA COLLEGE, Columbia College inc, Columbia College
69447FY2016 to FY2026
Latest decision 2026-02-19
64LANGUAGE PROGRAM COORDINATOR
6 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile
Columbia College Chicago
COLUMBIA COLLEGE CHICAGO
16101FY2016 to FY2025
Latest decision 2025-09-09
27ASSISTANT PROFESSOR - INTERACTIVE ARTS & MEDIA
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings69
Certified LCAs68
Denied LCAs0
Role titles44
Worksites7
Latest decision2026-02-19
USCIS approvals64
USCIS denials12

Aliases and source names

AliasesSource NamesSources
COLUMBIA COLLEGE, Columbia College inc, Columbia College, columbia college inc, COLUMBIA COLLEGE INC, COLUMBIA COLLEGE CORPORATIONColumbia College, columbia college inc, COLUMBIA COLLEGE INC, COLUMBIA COLLEGE, COLUMBIA COLLEGE CORPORATIONdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
LANGUAGE PROGRAM COORDINATOR25-9031
INSTRUCTIONAL COORDINATORS
6$66,560$66,560
FINANCIAL ANALYST13-20513$60,320$0
GRAPHIC DESIGNER27-10243$41,600$0
LANGUAGE PROGRAM COORDINATOR25-90313$49,920$0
GRAPHIC DESIGNER27-1024
GRAPHIC DESIGNERS
3$56,160$66,560
AREA COORDINATOR21-10992$28,505$0
Assistant Dean for Student Life11-9033.00
Education Administrators, Postsecondary
2$82,000$82,000
Assistant Professor of Computer Science25-1021.00
Computer Science Teachers, Postsecondary
2$100,000$100,000
Assistant Professor of Special Education25-1199.00
Postsecondary Teachers, All Other
2$32,870$56,000
ESL PROGRAM COORDINATOR25-90312$49,920$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
ViennaVA22182241256,16099,8402,0192,025
ColumbiaMO65216181327,000100,0002,0162,025
ViennaVA2218212841,60002,0172,018
ColumbiaSC2920310932,87060,0002,0162,026
FairfaxVA220313249,92002,0162,016
Silver SpringMD209061152,00002,0182,018
ColumbiaMO652011129,12002,0162,016

Full company payload

Company IDcompany:columbia college
NameColumbia College
Normalized Namecolumbia college
Source Company Idscompany_dol_oflc_lca_columbia_college, company_dol_oflc_lca_columbia_college_inc, company_uscis_h1b_datahub_columbia_college_inc_tax_1345, company_uscis_h1b_datahub_columbia_college_tax_1345, company_uscis_h1b_datahub_columbia_college_tax_5867, company_uscis_h1b_datahub_columbia_college_tax_4915, company_uscis_h1b_datahub_columbia_college_corporation_tax_3741
Source NamesColumbia College, columbia college inc, COLUMBIA COLLEGE INC, COLUMBIA COLLEGE, COLUMBIA COLLEGE CORPORATION
AliasesCOLUMBIA COLLEGE, Columbia College inc, Columbia College, columbia college inc, COLUMBIA COLLEGE INC, COLUMBIA COLLEGE CORPORATION
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Columbia College",
    "columbia college inc",
    "COLUMBIA COLLEGE INC",
    "COLUMBIA COLLEGE",
    "COLUMBIA COLLEGE CORPORATION"
  ],
  "dba_names": [
    "COLUMBIA COLLEGE",
    "Columbia College inc",
    "Columbia College",
    "columbia college inc"
  ],
  "name_variants": [
    {
      "value": "COLUMBIA COLLEGE",
      "filing_count": 21,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Columbia College",
      "filing_count": 18,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "COLUMBIA COLLEGE",
      "filing_count": 11,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Columbia College inc",
      "filing_count": 8,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Columbia College",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Columbia College Inc",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "columbia college inc",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "COLUMBIA COLLEGE INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "COLUMBIA COLLEGE",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "COLUMBIA COLLEGE",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "COLUMBIA COLLEGE",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "COLUMBIA COLLEGE CORPORATION",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "1345",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5867",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "4915",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "3741",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 69,
  "case_count": 69,
  "role_title_count": 44,
  "worksite_count": 7,
  "total_workers": 69,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-01-12",
  "latest_fiscal_year": 2026,
  "latest_decision_date": "2026-02-19",
  "certified_count": 68,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 25,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 18,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 13,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 10,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 45,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "H-1B",
      "filing_count": 24,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "N",
      "filing_count": 24,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Y",
      "filing_count": 24,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "N",
      "filing_count": 13,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 64,
  "total_denial": 12,
  "fiscal_years": [
    "2009",
    "2010",
    "2011",
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2017",
    "2018",
    "2019",
    "2021",
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Fairfax"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22031"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 4,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_inc_tax_1345_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_036766"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Fairfax"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22031"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 7,
      "initial_approval": 6,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_inc_tax_1345_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_038968"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Vienna"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22182"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_inc_tax_1345_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_039461"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Vienna"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22182"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 6,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_inc_tax_1345_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_040294"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Vienna"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22182"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 3,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_inc_tax_1345_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_012243"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Fairfax"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22003",
        "22031"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 6,
      "initial_approval": 4,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_1345_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_042521",
        "sr_uscis_h1b_datahub_2011_row_042522"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Fairfax"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22031"
      ],
      "total_denial": 4,
      "initial_denial": 2,
      "total_approval": 4,
      "initial_approval": 1,
      "continuing_denial": 2,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_1345_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_039006"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Fairfax"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22031"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_1345_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_040456"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Fairfax"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22031"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 6,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_1345_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_035355"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Fairfax"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22031"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_1345_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_038932"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Fairfax"
      ],
      "states": [
        "VA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "22031"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_1345_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_035680"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "65216"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_5867_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_032493"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "65216"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_5867_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_032147"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "65216"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_5867_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_031693"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "65216"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_5867_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_027409"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "65216"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_5867_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_024707"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "65216"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_5867_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_027201"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "65216"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_5867_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_012186"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "MO"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "65216"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_5867_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_006721"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "SC"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "29203"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_4915_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_046429"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "SC"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "29203"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_4915_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_037977"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "SC"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "29203"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_4915_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_043911"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "SC"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "29203"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_4915_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_040154"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Columbia"
      ],
      "states": [
        "SC"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "29203"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_tax_4915_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_036534"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Caguas",
        "San Juan"
      ],
      "states": [
        "PR"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "00726",
        "00925"
      ],
      "total_denial": 2,
      "initial_denial": 2,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_college_corporation_tax_3741_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_012188",
        "sr_uscis_h1b_datahub_2022_row_012189"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "address_line_1": "1301 Columbia College Drive",
      "raw_address": "1301 Columbia College Drive  COLUMBIA SC 29203",
      "city": "Columbia",
      "state": "SC",
      "postal_code": "29203",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-02-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "VIENNA VA 22182",
      "city": "Vienna",
      "state": "VA",
      "postal_code": "22182",
      "filing_count": 22,
      "case_count": 22,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-07-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "COLUMBIA MO 65216",
      "city": "Columbia",
      "state": "MO",
      "postal_code": "65216",
      "filing_count": 19,
      "case_count": 19,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-07-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "COLUMBIA SC 29203",
      "city": "Columbia",
      "state": "SC",
      "postal_code": "29203",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-02-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "FAIRFAX VA 22030",
      "city": "Fairfax",
      "state": "VA",
      "postal_code": "22030",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "VIENNA VA 22182",
      "city": "Vienna",
      "state": "VA",
      "postal_code": "22182",
      "filing_count": 13,
      "case_count": 13,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-08-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "FAIRFAX VA 22031",
      "city": "Fairfax",
      "state": "VA",
      "postal_code": "22031",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "address_line_1": "1301 Columbia College Drive",
      "raw_address": "1301 Columbia College Drive  COLUMBIA SC 29203",
      "city": "Columbia",
      "state": "SC",
      "postal_code": "29203",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026,
      "latest_decision_date": "2026-02-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "VIENNA VA 22182",
      "city": "Vienna",
      "county": "Fairfax",
      "state": "VA",
      "postal_code": "22182",
      "filing_count": 18,
      "case_count": 18,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-05-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBIA MO 65216",
      "city": "Columbia",
      "state": "MO",
      "postal_code": "65216",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-07-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "VIENNA VA 22182",
      "city": "Vienna",
      "state": "VA",
      "postal_code": "22182",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-07-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBIA MO 65216",
      "city": "Columbia",
      "county": "Boone",
      "state": "MO",
      "postal_code": "65216",
      "filing_count": 16,
      "case_count": 16,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-01-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBIA SC 29203",
      "city": "Columbia",
      "county": "Richland",
      "state": "SC",
      "postal_code": "29203",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-02-07",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "VIENNA VA 22182",
      "city": "Vienna",
      "county": "Virginia",
      "state": "VA",
      "postal_code": "22182",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "VIENNA VA 22182",
      "city": "Vienna",
      "county": "Fairfax",
      "state": "VA",
      "postal_code": "22182",
      "filing_count": 12,
      "case_count": 12,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-08-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SILVER SPRING MD 20906",
      "city": "Silver Spring",
      "county": "Montgomery",
      "state": "MD",
      "postal_code": "20906",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBIA MO 65216",
      "city": "Columbia",
      "county": "Missouri",
      "state": "MO",
      "postal_code": "65216",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-05-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FAIRFAX VA 22031",
      "city": "Fairfax",
      "county": "Fairfax",
      "state": "VA",
      "postal_code": "22031",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBIA MO 65201",
      "city": "Columbia",
      "county": "Boone",
      "state": "MO",
      "postal_code": "65201",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-08-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FAIRFAX VA 22031",
      "city": "Fairfax",
      "county": "Fairfax County",
      "state": "VA",
      "postal_code": "22031",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 7,
    "worksite_address_count": 13,
    "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": [
    "VA",
    "MO",
    "SC",
    "MD",
    "PR"
  ],
  "cities": [
    "Vienna",
    "Columbia",
    "Fairfax",
    "Silver Spring",
    "Caguas",
    "San Juan"
  ],
  "postal_codes": [
    "22182",
    "65216",
    "29203",
    "22031",
    "20906",
    "65201",
    "22003",
    "00726",
    "00925"
  ],
  "top_markets": [
    {
      "city": "Vienna",
      "state": "VA",
      "postal_code": "22182",
      "lca_count": 24,
      "role_title_count": 12,
      "wage_low_min": 56160,
      "wage_high_max": 99840,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Columbia",
      "state": "MO",
      "postal_code": "65216",
      "lca_count": 18,
      "role_title_count": 13,
      "wage_low_min": 27000,
      "wage_high_max": 100000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Vienna",
      "state": "VA",
      "postal_code": "22182",
      "lca_count": 12,
      "role_title_count": 8,
      "wage_low_min": 41600,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Columbia",
      "state": "SC",
      "postal_code": "29203",
      "lca_count": 10,
      "role_title_count": 9,
      "wage_low_min": 32870,
      "wage_high_max": 60000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Fairfax",
      "state": "VA",
      "postal_code": "22031",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 49920,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Silver Spring",
      "state": "MD",
      "postal_code": "20906",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 52000,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Columbia",
      "state": "MO",
      "postal_code": "65201",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 29120,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "611310",
    "61"
  ],
  "naics_breakdown": [
    {
      "value": "611310",
      "filing_count": 37,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2026,
      "source": "dol_oflc_lca"
    },
    {
      "value": "611310",
      "filing_count": 24,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 27000,
  "annualized_high_max": 100000,
  "annualized_low_avg": 63998.24444444445
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 8,
    "case_count": 8,
    "role_title_count": 7,
    "worksite_count": 4,
    "wage_low_min": 28505,
    "wage_high_max": 0,
    "wage_low_avg": 42945.625
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 10,
    "case_count": 10,
    "role_title_count": 7,
    "worksite_count": 2,
    "wage_low_min": 41600,
    "wage_high_max": 0,
    "wage_low_avg": 54223.8
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 6,
    "worksite_count": 3,
    "wage_low_min": 28505,
    "wage_high_max": 0,
    "wage_low_avg": 62297.5
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 14,
    "case_count": 14,
    "role_title_count": 6,
    "worksite_count": 2,
    "wage_low_min": 44000,
    "wage_high_max": 72800,
    "wage_low_avg": 55999.15151515155
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 4,
    "worksite_count": 1,
    "wage_low_min": 58240,
    "wage_high_max": 72800,
    "wage_low_avg": 67600
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 62400,
    "wage_high_max": 83200,
    "wage_low_avg": 72800
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 100000,
    "wage_high_max": 100000,
    "wage_low_avg": 100000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 100000,
    "wage_high_max": 100000,
    "wage_low_avg": 100000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 100000,
    "wage_high_max": 100000,
    "wage_low_avg": 100000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 48900,
    "wage_high_max": 48900,
    "wage_low_avg": 48900
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 82000,
    "wage_high_max": 82000,
    "wage_low_avg": 82000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 4,
    "worksite_count": 2,
    "wage_low_min": 52500,
    "wage_high_max": 82000,
    "wage_low_avg": 62000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 5,
    "worksite_count": 3,
    "wage_low_min": 27000,
    "wage_high_max": 72800,
    "wage_low_avg": 60525
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 74880,
    "wage_high_max": 74880,
    "wage_low_avg": 74880
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 2,
    "wage_low_min": 48000,
    "wage_high_max": 60000,
    "wage_low_avg": 56000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 74880,
    "wage_high_max": 87360,
    "wage_low_avg": 81120
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 79040,
    "wage_high_max": 79040,
    "wage_low_avg": 79040
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 87000,
    "wage_high_max": 99840,
    "wage_low_avg": 93420
  },
  {
    "fiscal_year": 2026,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 32870,
    "wage_high_max": 56000,
    "wage_low_avg": 32870
  }
]
Links
{
  "roles": "/v1/roles?company=Columbia%20College",
  "wages": "/v1/wages?company=Columbia%20College",
  "trends": "/v1/trends?company=Columbia%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=columbia+college&limit=5JSON