Home / Companies / SPH2 ENTERPRISE LLC

SPH2 ENTERPRISE 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
SPH2 ENTERPRISE LLC SPH2 ENTERPRISE LLC, SPH2 ENTERPRISE LLC (DBA CARE DENT, SPH2 ENTERPRISE LLC DBA CARE DENTA	1	1	1	FY2016 to FY2016 Latest decision 2016-03-09	3	ASSOCIATE GENERAL DENTIST 1 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	1
Certified LCAs	1
Denied LCAs	0
Role titles	1
Worksites	1
Latest decision	2016-03-09
USCIS approvals	3
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
SPH2 ENTERPRISE LLC, SPH2 ENTERPRISE LLC (DBA CARE DENT, SPH2 ENTERPRISE LLC DBA CARE DENTA	SPH2 ENTERPRISE LLC, SPH2 ENTERPRISE LLC (DBA CARE DENT, SPH2 ENTERPRISE LLC DBA CARE DENTA	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
ASSOCIATE GENERAL DENTIST	29-1021	1	$153,920	$0

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Hartford	CT	06114	1	1	153,920	0	2,016	2,016

Full company payload

Company ID	company:sph2 enterprise
Name	SPH2 ENTERPRISE LLC
Normalized Name	sph2 enterprise
Source Company Ids	company_dol_oflc_lca_sph2_enterprise_llc, company_uscis_h1b_datahub_sph2_enterprise_llc_tax_5497, company_uscis_h1b_datahub_sph2_enterprise_llc_dba_care_dent_tax_5497, company_uscis_h1b_datahub_sph2_enterprise_llc_dba_care_denta_tax_5497
Source Names	SPH2 ENTERPRISE LLC, SPH2 ENTERPRISE LLC (DBA CARE DENT, SPH2 ENTERPRISE LLC DBA CARE DENTA
Aliases	SPH2 ENTERPRISE LLC, SPH2 ENTERPRISE LLC (DBA CARE DENT, SPH2 ENTERPRISE LLC DBA CARE DENTA
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "SPH2 ENTERPRISE LLC",
    "SPH2 ENTERPRISE LLC (DBA CARE DENT",
    "SPH2 ENTERPRISE LLC DBA CARE DENTA"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "SPH2 ENTERPRISE LLC",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SPH2 ENTERPRISE LLC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "SPH2 ENTERPRISE LLC (DBA CARE DENT",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "SPH2 ENTERPRISE LLC DBA CARE DENTA",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

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

LCA Activity

{
  "lca_count": 1,
  "case_count": 1,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 1,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-03",
  "latest_fiscal_year": 2016,
  "latest_decision_date": "2016-03-09",
  "certified_count": 1,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": []
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 3,
  "total_denial": 0,
  "fiscal_years": [
    "2011",
    "2015",
    "2017"
  ],
  "year_metrics": [
    {
      "cities": [
        "Hartford"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06114"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sph2_enterprise_llc_tax_5497_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_016153"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Hartford"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06114"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sph2_enterprise_llc_dba_care_dent_tax_5497_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_026783"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Hartford"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06114"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sph2_enterprise_llc_dba_care_denta_tax_5497_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_017392"
      ],
      "continuing_approval": 1
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "HARTFORD CT 06114",
      "city": "Hartford",
      "state": "CT",
      "postal_code": "06114",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "HARTFORD CT 06114",
      "city": "Hartford",
      "county": "Hartford",
      "state": "CT",
      "postal_code": "06114",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-09",
      "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": [
    "CT"
  ],
  "cities": [
    "Hartford"
  ],
  "postal_codes": [
    "06114"
  ],
  "top_markets": [
    {
      "city": "Hartford",
      "state": "CT",
      "postal_code": "06114",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 153920,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}

Industry

{
  "naics_codes": [
    "62"
  ],
  "naics_breakdown": []
}

Wage Summary

{
  "annualized_low_min": 153920,
  "annualized_high_max": 0,
  "annualized_low_avg": 153920
}

Trend

[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 153920,
    "wage_high_max": 0,
    "wage_low_avg": 153920
  }
]

Links

{
  "roles": "/v1/roles?company=SPH2%20ENTERPRISE%20LLC",
  "wages": "/v1/wages?company=SPH2%20ENTERPRISE%20LLC",
  "trends": "/v1/trends?company=SPH2%20ENTERPRISE%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=sph2+enterprise+llc&limit=5JSON

Docs · Get an API key