Home / Companies / The Constellation Fund

The Constellation Fund 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
The Constellation Fund	2	1	1	FY2024 to FY2024 Latest decision 2024-09-04	0	Research Associate 2 filings	dol_oflc_lca	Profile

Activity summary

LCA filings	2
Certified LCAs	2
Denied LCAs	0
Role titles	1
Worksites	1
Latest decision	2024-09-04
USCIS approvals	0
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
-	The Constellation Fund	dol_oflc_lca

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
Research Associate	19-4061.00 Social Science Research Assistants	2	$68,640	$68,640

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	Wage High Max	First Fiscal Year	Latest Fiscal Year
Minneapolis	MN	55418	2	1	68,640	68,640	2,024	2,024

Full company payload

Company ID	company:the constellation fund
Name	The Constellation Fund
Normalized Name	the constellation fund
Source Company Ids	company_dol_oflc_lca_the_constellation_fund
Source Names	The Constellation Fund
Aliases	-
Identifiers	-
Sources	dol_oflc_lca

Names

{
  "source_names": [
    "The Constellation Fund"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "The Constellation Fund",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}

LCA Activity

{
  "lca_count": 2,
  "case_count": 2,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 2,
  "first_fiscal_year": 2024,
  "first_received_date": "2024-08-14",
  "latest_fiscal_year": 2024,
  "latest_decision_date": "2024-09-04",
  "certified_count": 2,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "N",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 0,
  "total_denial": 0,
  "fiscal_years": [],
  "year_metrics": []
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "MINNEAPOLIS MN 55418",
      "city": "Minneapolis",
      "state": "MN",
      "postal_code": "55418",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-09-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "MINNEAPOLIS MN 55418",
      "city": "Minneapolis",
      "county": "Hennepin",
      "state": "MN",
      "postal_code": "55418",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-09-04",
      "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": [
    "MN"
  ],
  "cities": [
    "Minneapolis"
  ],
  "postal_codes": [
    "55418"
  ],
  "top_markets": [
    {
      "city": "Minneapolis",
      "state": "MN",
      "postal_code": "55418",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 68640,
      "wage_high_max": 68640,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024
    }
  ]
}

Industry

{
  "naics_codes": [
    "81331"
  ],
  "naics_breakdown": [
    {
      "value": "81331",
      "filing_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 68640,
  "annualized_high_max": 68640,
  "annualized_low_avg": 68640
}

Trend

[
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 68640,
    "wage_high_max": 68640,
    "wage_low_avg": 68640
  }
]

Links

{
  "roles": "/v1/roles?company=The%20Constellation%20Fund",
  "wages": "/v1/wages?company=The%20Constellation%20Fund",
  "trends": "/v1/trends?company=The%20Constellation%20Fund"
}

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=the+constellation+fund&limit=5JSON

Docs · Get an API key