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

Home / Companies / CONSTELLATION HOME CARE LLC

CONSTELLATION HOME CARE 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.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
CONSTELLATION HOME CARE LLC
CONSTELLATION HOME CARE LLC
414FY2019 to FY2023
Latest decision 2023-06-16
5PHYSICAL THERAPIST
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings4
Certified LCAs4
Denied LCAs0
Role titles1
Worksites4
Latest decision2023-06-16
USCIS approvals5
USCIS denials0

Aliases and source names

AliasesSource NamesSources
CONSTELLATION HOME CARE LLCCONSTELLATION HOME CARE LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
PHYSICAL THERAPIST29-1123
PHYSICAL THERAPISTS
2$85,000$85,000
Physical Therapist29-1123.00
Physical Therapists
2$88,733$93,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
OrangeCT064771188,73388,7332,0232,023
OrangeCT64771185,00085,0002,0192,019
WethersfieldCT061091193,00093,0002,0202,020
WethersfieldCT61091185,00085,0002,0192,019

Full company payload

Company IDcompany:constellation home care
NameCONSTELLATION HOME CARE LLC
Normalized Nameconstellation home care
Source Company Idscompany_dol_oflc_lca_constellation_home_care_llc, company_uscis_h1b_datahub_constellation_home_care_llc_tax_7563
Source NamesCONSTELLATION HOME CARE LLC
AliasesCONSTELLATION HOME CARE LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "CONSTELLATION HOME CARE LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "CONSTELLATION HOME CARE LLC",
      "filing_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Constellation Home Care LLC",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Constellation Home Care, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CONSTELLATION HOME CARE LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7563",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 4,
  "case_count": 4,
  "role_title_count": 1,
  "worksite_count": 4,
  "total_workers": 4,
  "first_fiscal_year": 2019,
  "first_received_date": "2019-03-04",
  "latest_fiscal_year": 2023,
  "latest_decision_date": "2023-06-16",
  "certified_count": 4,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 5,
  "total_denial": 0,
  "fiscal_years": [
    "2012",
    "2019",
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "Norwalk"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "06851"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_constellation_home_care_llc_tax_7563_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_027139"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Norwalk"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06851"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_constellation_home_care_llc_tax_7563_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_020646"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Norwalk"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "62"
      ],
      "postal_codes": [
        "06851",
        "6851"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_constellation_home_care_llc_tax_7563_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_012897",
        "sr_uscis_h1b_datahub_2021_row_012898"
      ],
      "continuing_approval": 2
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "NORWALK CT 06851",
      "city": "Norwalk",
      "state": "CT",
      "postal_code": "06851",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-06-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "NORWALK CT 6851",
      "city": "Norwalk",
      "state": "CT",
      "postal_code": "6851",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ORANGE CT 06477",
      "city": "Orange",
      "county": "New Haven City",
      "state": "CT",
      "postal_code": "06477",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-06-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WETHERSFIELD CT 06109",
      "city": "Wethersfield",
      "county": "Hartford City",
      "state": "CT",
      "postal_code": "06109",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-09-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ORANGE CT 6477",
      "city": "Orange",
      "county": "New Haven",
      "state": "CT",
      "postal_code": "6477",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WETHERSFIELD CT 6109",
      "city": "Wethersfield",
      "county": "Hartford",
      "state": "CT",
      "postal_code": "6109",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 4,
    "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": [
    "Orange",
    "Wethersfield",
    "Norwalk"
  ],
  "postal_codes": [
    "06477",
    "6477",
    "06109",
    "6109",
    "06851",
    "6851"
  ],
  "top_markets": [
    {
      "city": "Orange",
      "state": "CT",
      "postal_code": "06477",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 88733,
      "wage_high_max": 88733,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Orange",
      "state": "CT",
      "postal_code": "6477",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 85000,
      "wage_high_max": 85000,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Wethersfield",
      "state": "CT",
      "postal_code": "06109",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 93000,
      "wage_high_max": 93000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    },
    {
      "city": "Wethersfield",
      "state": "CT",
      "postal_code": "6109",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 85000,
      "wage_high_max": 85000,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    }
  ]
}
Industry
{
  "naics_codes": [
    "621610",
    "62",
    "99"
  ],
  "naics_breakdown": [
    {
      "value": "621610",
      "filing_count": 4,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 85000,
  "annualized_high_max": 93000,
  "annualized_low_avg": 87933.25
}
Trend
[
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 2,
    "wage_low_min": 85000,
    "wage_high_max": 85000,
    "wage_low_avg": 85000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 93000,
    "wage_high_max": 93000,
    "wage_low_avg": 93000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 88733,
    "wage_high_max": 88733,
    "wage_low_avg": 88733
  }
]
Links
{
  "roles": "/v1/roles?company=CONSTELLATION%20HOME%20CARE%20LLC",
  "wages": "/v1/wages?company=CONSTELLATION%20HOME%20CARE%20LLC",
  "trends": "/v1/trends?company=CONSTELLATION%20HOME%20CARE%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=constellation+home+care+llc&limit=5JSON