Home / Companies / COLUMN5 CONSULTING, LLC

COLUMN5 CONSULTING, 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.

Role rows Wage rows Trends

Employer	LCA filings	Role titles	Worksites	Coverage	USCIS approvals	Top role	Sources	Open
COLUMN5 CONSULTING, LLC COLUMN5 CONSULTING LLC	3	2	2	FY2016 to FY2019 Latest decision 2018-10-23	6	SOFTWARE APPLICATION ENGINEER 2 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	3
Certified LCAs	3
Denied LCAs	0
Role titles	2
Worksites	2
Latest decision	2018-10-23
USCIS approvals	6
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
COLUMN5 CONSULTING LLC	COLUMN5 CONSULTING, LLC, COLUMN5 CONSULTING LLC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
SOFTWARE APPLICATION ENGINEER	15-1132 SOFTWARE DEVELOPERS, APPLICATIONS	2	$86,674	$99,320
SENIOR CONSULTANT	15-1133	1	$72,883	$0

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Trabuco Canyon	CA	92679	2	1	86,674	99,320	2,016	2,019
Irvine	CA	92618	1	1	72,883	0	2,017	2,017

Full company payload

Company ID	company:column5 consulting
Name	COLUMN5 CONSULTING, LLC
Normalized Name	column5 consulting
Source Company Ids	company_dol_oflc_lca_column5_consulting_llc, company_uscis_h1b_datahub_column5_consulting_llc_tax_3736
Source Names	COLUMN5 CONSULTING, LLC, COLUMN5 CONSULTING LLC
Aliases	COLUMN5 CONSULTING LLC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Identifiers

[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "3736",
    "source": "uscis_h1b_employer_data_hub"
  }
]

LCA Activity

{
  "lca_count": 3,
  "case_count": 3,
  "role_title_count": 2,
  "worksite_count": 2,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2019,
  "latest_decision_date": "2018-10-23",
  "certified_count": 3,
  "denied_count": 0
}

Petition Activity

{
  "total_approval": 6,
  "total_denial": 0,
  "fiscal_years": [
    "2014",
    "2015",
    "2016",
    "2017",
    "2019"
  ],
  "year_metrics": [
    {
      "cities": [
        "Scottsdale"
      ],
      "states": [
        "AZ"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "85251"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_column5_consulting_llc_tax_3736_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_010163"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Scottsdale"
      ],
      "states": [
        "AZ"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "85251"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_column5_consulting_llc_tax_3736_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_008155"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Scottsdale"
      ],
      "states": [
        "AZ"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "85251"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_column5_consulting_llc_tax_3736_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_008428"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Scottsdale"
      ],
      "states": [
        "AZ"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "85251"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_column5_consulting_llc_tax_3736_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_007546"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Scottsdale"
      ],
      "states": [
        "AZ"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "85251"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_column5_consulting_llc_tax_3736_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_008084"
      ],
      "continuing_approval": 1
    }
  ]
}

Geography

{
  "states": [
    "CA",
    "AZ"
  ],
  "cities": [
    "Trabuco Canyon",
    "Irvine",
    "Scottsdale"
  ],
  "postal_codes": [
    "92679",
    "92618",
    "85251"
  ],
  "top_markets": [
    {
      "city": "Trabuco Canyon",
      "state": "CA",
      "postal_code": "92679",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 86674,
      "wage_high_max": 99320,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Irvine",
      "state": "CA",
      "postal_code": "92618",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 72883,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}

Industry

{
  "naics_codes": [
    "54161",
    "54"
  ]
}

Wage Summary

{
  "annualized_low_min": 72883,
  "annualized_high_max": 99320,
  "annualized_low_avg": 86292.3333333333
}

Trend

[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 86674,
    "wage_high_max": 0,
    "wage_low_avg": 86674
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 72883,
    "wage_high_max": 0,
    "wage_low_avg": 72883
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 99320,
    "wage_high_max": 99320,
    "wage_low_avg": 99320
  }
]

Links

{
  "roles": "/v1/roles?company=COLUMN5%20CONSULTING%2C%20LLC",
  "wages": "/v1/wages?company=COLUMN5%20CONSULTING%2C%20LLC",
  "trends": "/v1/trends?company=COLUMN5%20CONSULTING%2C%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=column5+consulting+llc&limit=5JSON

Docs · Get an API key