Home / Companies / COLUMBIA DENTAL, PC

COLUMBIA DENTAL, PC 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
COLUMBIA DENTAL, PC COLUMBIA DENTAL PC	12	3	7	FY2017 to FY2023 Latest decision 2023-08-24	28	DENTIST 6 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	12
Certified LCAs	12
Denied LCAs	0
Role titles	3
Worksites	7
Latest decision	2023-08-24
USCIS approvals	28
USCIS denials	2

Aliases and source names

Aliases	Source Names	Sources
COLUMBIA DENTAL PC	COLUMBIA DENTAL, PC, COLUMBIA DENTAL PC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
DENTIST	29-1021	6	$90,750	$150,000
GENERAL DENTIST	29-1021	3	$131,040	$0
Computer Network Support Specialist	15-1152.00 Computer Network Support Specialists	1	$59,488	$59,488
Dentist	29-1021.00 Dentists, General	1	$120,640	$120,640
General Dentist	29-1021.00 Dentists, General	1	$107,349	$107,349

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Manchester	CT	06040	4	2	121,451	150,000	2,017	2,018
Manchester	CT	6040	2	2	59,488	107,349	2,020	2,022
New Haven	CT	06519	2	1	90,750	90,750	2,017	2,017
Enfield	CT	06082	1	1	121,451	150,000	2,018	2,018
Hartford	CT	06106	1	1	120,640	120,640	2,023	2,023
New Britain	CT	06051-3516	1	1	121,451	150,000	2,018	2,018
Waterbury	CT	06705	1	1	128,045	128,045	2,017	2,017

Full company payload

Company ID	company:columbia dental pc
Name	COLUMBIA DENTAL, PC
Normalized Name	columbia dental pc
Source Company Ids	company_dol_oflc_lca_columbia_dental_pc, company_uscis_h1b_datahub_columbia_dental_pc_tax_1185
Source Names	COLUMBIA DENTAL, PC, COLUMBIA DENTAL PC
Aliases	COLUMBIA DENTAL PC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "COLUMBIA DENTAL, PC",
    "COLUMBIA DENTAL PC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "COLUMBIA DENTAL PC",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "COLUMBIA DENTAL, PC",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Columbia Dental PC",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Columbia Dental, PC",
      "filing_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "COLUMBIA DENTAL PC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

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

LCA Activity

{
  "lca_count": 12,
  "case_count": 12,
  "role_title_count": 3,
  "worksite_count": 7,
  "total_workers": 12,
  "first_fiscal_year": 2017,
  "first_received_date": "2016-10-04",
  "latest_fiscal_year": 2023,
  "latest_decision_date": "2023-08-24",
  "certified_count": 12,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 9,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 3,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 12,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 8,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "N",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 28,
  "total_denial": 2,
  "fiscal_years": [
    "2012",
    "2013",
    "2014",
    "2015",
    "2017",
    "2018",
    "2020",
    "2021",
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Manchester"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06040"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_dental_pc_tax_1185_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_003539"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Manchester"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06040"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_dental_pc_tax_1185_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_003361"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Manchester"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06040"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 7,
      "initial_approval": 6,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_dental_pc_tax_1185_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_003193"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Enola",
        "Manchester"
      ],
      "states": [
        "CT",
        "PA"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06040",
        "17025"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_dental_pc_tax_1185_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_002637",
        "sr_uscis_h1b_datahub_2015_row_002638"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Manchester"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06040"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_dental_pc_tax_1185_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_002504"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Manchester"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06040"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_dental_pc_tax_1185_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_002658"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Manchester"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06040"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_dental_pc_tax_1185_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_010996"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Manchester"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06040",
        "6040"
      ],
      "total_denial": 2,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 2,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_dental_pc_tax_1185_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_012247",
        "sr_uscis_h1b_datahub_2021_row_012248"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Manchester"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06040"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_dental_pc_tax_1185_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_012191"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Manchester"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06040"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_columbia_dental_pc_tax_1185_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_006722"
      ],
      "continuing_approval": 0
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "MANCHESTER CT 06040",
      "city": "Manchester",
      "state": "CT",
      "postal_code": "06040",
      "filing_count": 10,
      "case_count": 10,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-08-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "MANCHESTER CT 6040",
      "city": "Manchester",
      "state": "CT",
      "postal_code": "6040",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-04-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "HARTFORD CT 06106",
      "city": "Hartford",
      "county": "Hartford City",
      "state": "CT",
      "postal_code": "06106",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-08-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MANCHESTER CT 6040",
      "city": "Manchester",
      "county": "Manchester",
      "state": "CT",
      "postal_code": "6040",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-04-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MANCHESTER CT 06040",
      "city": "Manchester",
      "county": "Hartford",
      "state": "CT",
      "postal_code": "06040",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-11-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW BRITAIN CT 06051-3516",
      "city": "New Britain",
      "county": "Hartford",
      "state": "CT",
      "postal_code": "06051-3516",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-11-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ENFIELD CT 06082",
      "city": "Enfield",
      "county": "Hartford",
      "state": "CT",
      "postal_code": "06082",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2017-11-09",
      "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": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WATERBURY CT 06705",
      "city": "Waterbury",
      "county": "New Haven - Msa Waterbury",
      "state": "CT",
      "postal_code": "06705",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-10-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 7,
    "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",
    "PA"
  ],
  "cities": [
    "Manchester",
    "New Haven",
    "Enfield",
    "Hartford",
    "New Britain",
    "Waterbury",
    "Enola"
  ],
  "postal_codes": [
    "06040",
    "6040",
    "06519",
    "06082",
    "06106",
    "06051-3516",
    "06705",
    "17025"
  ],
  "top_markets": [
    {
      "city": "Manchester",
      "state": "CT",
      "postal_code": "06040",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 121451,
      "wage_high_max": 150000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Manchester",
      "state": "CT",
      "postal_code": "6040",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 59488,
      "wage_high_max": 107349,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2022
    },
    {
      "city": "New Haven",
      "state": "CT",
      "postal_code": "06519",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 90750,
      "wage_high_max": 90750,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Enfield",
      "state": "CT",
      "postal_code": "06082",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 121451,
      "wage_high_max": 150000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Hartford",
      "state": "CT",
      "postal_code": "06106",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 120640,
      "wage_high_max": 120640,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023
    },
    {
      "city": "New Britain",
      "state": "CT",
      "postal_code": "06051-3516",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 121451,
      "wage_high_max": 150000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Waterbury",
      "state": "CT",
      "postal_code": "06705",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 128045,
      "wage_high_max": 128045,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}

Industry

{
  "naics_codes": [
    "621210",
    "62"
  ],
  "naics_breakdown": [
    {
      "value": "621210",
      "filing_count": 9,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "6212",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "62121",
      "filing_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 59488,
  "annualized_high_max": 150000,
  "annualized_low_avg": 112874.583333333
}

Trend

[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 2,
    "worksite_count": 3,
    "wage_low_min": 90750,
    "wage_high_max": 128045,
    "wage_low_avg": 117110.833333333
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 3,
    "wage_low_min": 121451,
    "wage_high_max": 150000,
    "wage_low_avg": 121451
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 59488,
    "wage_high_max": 59488,
    "wage_low_avg": 59488
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 107349,
    "wage_high_max": 107349,
    "wage_low_avg": 107349
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 120640,
    "wage_high_max": 120640,
    "wage_low_avg": 120640
  }
]

Links

{
  "roles": "/v1/roles?company=COLUMBIA%20DENTAL%2C%20PC",
  "wages": "/v1/wages?company=COLUMBIA%20DENTAL%2C%20PC",
  "trends": "/v1/trends?company=COLUMBIA%20DENTAL%2C%20PC"
}

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+dental+pc&limit=5JSON

Docs · Get an API key