Home / Companies / COLUMBUS CHEMISTS, LLC

COLUMBUS CHEMISTS, 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
COLUMBUS CHEMISTS, LLC Berney's Pharmacy, BERNEY'S PHARMACY, COLUMBUS CHEMISTS LLC DBA BERNEYS	9	5	2	FY2016 to FY2024 Latest decision 2024-09-25	14	PHARMACY MANAGER (PHARMACIST-IN-CHARGE) 2 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	9
Certified LCAs	9
Denied LCAs	0
Role titles	5
Worksites	2
Latest decision	2024-09-25
USCIS approvals	14
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
Berney's Pharmacy, BERNEY'S PHARMACY, COLUMBUS CHEMISTS LLC DBA BERNEYS, COLUMBUS CHEMISTS LLC DBA BERNEY'S, COLUMBUS CHEMISTS LLC DBA BERNEYS PHARMACY	COLUMBUS CHEMISTS, LLC, COLUMBUS CHEMISTS LLC DBA BERNEYS, COLUMBUS CHEMISTS LLC DBA BERNEY'S, COLUMBUS CHEMISTS LLC DBA BERNEYS PHARMACY	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
PHARMACY MANAGER (PHARMACIST-IN-CHARGE)	29-1051	2	$114,400	$0
PHARMACY MANAGER (Pharmacist-in-Charge)	29-1051.00 Pharmacists	2	$124,800	$137,280
PHARMACIST	29-1051	1	$124,800	$0
PHARMACY MANAGER (PHARMACIST- IN- CHARGE)	29-1051	1	$120,640	$0
Pharmacy Services Manager	11-9111.00 Medical and Health Services Managers	1	$90,000	$90,000
REGULATORY AND COMPLIANCE ANALYST	13-1041	1	$73,500	$0
Regulatory and Compliance Analyst	13-1041.07 Regulatory Affairs Specialists	1	$80,000	$80,000

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
New Haven	CT	06519	7	5	73,500	137,280	2,016	2,024
New Haven	CT	6519	2	2	80,000	124,800	2,021	2,021

Full company payload

Company ID	company:columbus chemists
Name	COLUMBUS CHEMISTS, LLC
Normalized Name	columbus chemists
Source Company Ids	company_dol_oflc_lca_columbus_chemists_llc, company_uscis_h1b_datahub_columbus_chemists_llc_dba_berneys_tax_9712, company_uscis_h1b_datahub_columbus_chemists_llc_dba_berney_s_tax_9712, company_uscis_h1b_datahub_columbus_chemists_llc_dba_berneys_pharmacy_tax_9712
Source Names	COLUMBUS CHEMISTS, LLC, COLUMBUS CHEMISTS LLC DBA BERNEYS, COLUMBUS CHEMISTS LLC DBA BERNEY'S, COLUMBUS CHEMISTS LLC DBA BERNEYS PHARMACY
Aliases	Berney's Pharmacy, BERNEY'S PHARMACY, COLUMBUS CHEMISTS LLC DBA BERNEYS, COLUMBUS CHEMISTS LLC DBA BERNEY'S, COLUMBUS CHEMISTS LLC DBA BERNEYS PHARMACY
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "COLUMBUS CHEMISTS, LLC",
    "COLUMBUS CHEMISTS LLC DBA BERNEYS",
    "COLUMBUS CHEMISTS LLC DBA BERNEY'S",
    "COLUMBUS CHEMISTS LLC DBA BERNEYS PHARMACY"
  ],
  "dba_names": [
    "Berney's Pharmacy",
    "BERNEY'S PHARMACY"
  ],
  "name_variants": [
    {
      "value": "Berney's Pharmacy",
      "filing_count": 4,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "COLUMBUS CHEMISTS, LLC",
      "filing_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "BERNEY'S PHARMACY",
      "filing_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "COLUMBUS CHEMISTS LLC DBA BERNEYS",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "COLUMBUS CHEMISTS LLC DBA BERNEY'S",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "COLUMBUS CHEMISTS LLC DBA BERNEYS PHARMACY",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

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

LCA Activity

{
  "lca_count": 9,
  "case_count": 9,
  "role_title_count": 5,
  "worksite_count": 2,
  "total_workers": 9,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-12-17",
  "latest_fiscal_year": 2024,
  "latest_decision_date": "2024-09-25",
  "certified_count": 9,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 4,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 6,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 14,
  "total_denial": 0,
  "fiscal_years": [
    "2011",
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2019",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "New Haven"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "44"
      ],
      "postal_codes": [
        "06519"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbus_chemists_llc_dba_berneys_tax_9712_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_024723"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "New Haven"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "44"
      ],
      "postal_codes": [
        "06519"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbus_chemists_llc_dba_berneys_tax_9712_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_021554"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "New Haven"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "44"
      ],
      "postal_codes": [
        "06519"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbus_chemists_llc_dba_berneys_tax_9712_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_020167"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "New Haven"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "44"
      ],
      "postal_codes": [
        "06519"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbus_chemists_llc_dba_berneys_tax_9712_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_019813"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "New Haven"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "44"
      ],
      "postal_codes": [
        "06519"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbus_chemists_llc_dba_berneys_tax_9712_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_016514"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "New Haven"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "44"
      ],
      "postal_codes": [
        "06519"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbus_chemists_llc_dba_berneys_tax_9712_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_015678"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "New Haven"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "44"
      ],
      "postal_codes": [
        "06519"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbus_chemists_llc_dba_berney_s_tax_9712_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_015920"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "New Haven"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "44"
      ],
      "postal_codes": [
        "06519"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbus_chemists_llc_dba_berneys_pharmacy_tax_9712_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_012212"
      ],
      "continuing_approval": 2
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "NEW HAVEN CT 06519",
      "city": "New Haven",
      "state": "CT",
      "postal_code": "06519",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-09-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "NEW HAVEN CT 6519",
      "city": "New Haven",
      "state": "CT",
      "postal_code": "6519",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-09-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "NEW HAVEN CT 06519",
      "city": "New Haven",
      "county": "New Haven City",
      "state": "CT",
      "postal_code": "06519",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-09-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW HAVEN CT 6519",
      "city": "New Haven",
      "county": "New Haven City",
      "state": "CT",
      "postal_code": "6519",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-09-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW HAVEN CT 06519",
      "city": "New Haven",
      "county": "New Haven",
      "state": "CT",
      "postal_code": "06519",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-09-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "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": [
    "CT"
  ],
  "cities": [
    "New Haven"
  ],
  "postal_codes": [
    "06519",
    "6519"
  ],
  "top_markets": [
    {
      "city": "New Haven",
      "state": "CT",
      "postal_code": "06519",
      "lca_count": 7,
      "role_title_count": 5,
      "wage_low_min": 73500,
      "wage_high_max": 137280,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024
    },
    {
      "city": "New Haven",
      "state": "CT",
      "postal_code": "6519",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 80000,
      "wage_high_max": 124800,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021
    }
  ]
}

Industry

{
  "naics_codes": [
    "446110",
    "44"
  ],
  "naics_breakdown": [
    {
      "value": "446110",
      "filing_count": 6,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 73500,
  "annualized_high_max": 137280,
  "annualized_low_avg": 110024.444444444
}

Trend

[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 114400,
    "wage_high_max": 0,
    "wage_low_avg": 121333.333333333
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 73500,
    "wage_high_max": 0,
    "wage_low_avg": 97070
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 80000,
    "wage_high_max": 80000,
    "wage_low_avg": 80000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 124800,
    "wage_high_max": 124800,
    "wage_low_avg": 124800
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 90000,
    "wage_high_max": 90000,
    "wage_low_avg": 90000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 137280,
    "wage_high_max": 137280,
    "wage_low_avg": 137280
  }
]

Links

{
  "roles": "/v1/roles?company=COLUMBUS%20CHEMISTS%2C%20LLC",
  "wages": "/v1/wages?company=COLUMBUS%20CHEMISTS%2C%20LLC",
  "trends": "/v1/trends?company=COLUMBUS%20CHEMISTS%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=columbus+chemists+llc&limit=5JSON

Docs · Get an API key