Home / Companies / BLUE ICY WATER LLC

BLUE ICY WATER 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
BLUE ICY WATER LLC BLUE ICY WATER LLC, BLUE ICY WATER	5	2	4	FY2017 to FY2017 Latest decision 2017-05-30	0	COMPUTER SYSTEMS ANALYST 4 filings	dol_oflc_lca	Profile

Activity summary

LCA filings	5
Certified LCAs	4
Denied LCAs	1
Role titles	2
Worksites	4
Latest decision	2017-05-30
USCIS approvals	0
USCIS denials	0

Aliases and source names

Aliases	Source Names	Sources
BLUE ICY WATER LLC, BLUE ICY WATER	BLUE ICY WATER LLC	dol_oflc_lca

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
COMPUTER SYSTEMS ANALYST	15-1121	4	$62,000	$0
BUSINESS INTELLIGENCE ANALYST	15-1199	1	$62,000	$0

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	First Fiscal Year	Latest Fiscal Year
Ann Arbor	MI	48104	2	2	62,000	2,017	2,017
Chicago	MI	60606	1	1	69,000	2,017	2,017
Farmington Hills	MI	48334	1	1	62,000	2,017	2,017
Ann Arbor	OH	48104	1	1	69,000	2,017	2,017

Full company payload

Company ID	company:blue icy water
Name	BLUE ICY WATER LLC
Normalized Name	blue icy water
Source Company Ids	company_dol_oflc_lca_blue_icy_water_llc
Source Names	BLUE ICY WATER LLC
Aliases	BLUE ICY WATER LLC, BLUE ICY WATER
Identifiers	-
Sources	dol_oflc_lca

Names

{
  "source_names": [
    "BLUE ICY WATER LLC"
  ],
  "dba_names": [
    "BLUE ICY WATER LLC",
    "BLUE ICY WATER"
  ],
  "name_variants": [
    {
      "value": "BLUE ICY WATER LLC",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}

LCA Activity

{
  "lca_count": 5,
  "case_count": 5,
  "role_title_count": 2,
  "worksite_count": 4,
  "total_workers": 5,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-03-21",
  "latest_fiscal_year": 2017,
  "latest_decision_date": "2017-05-30",
  "certified_count": 4,
  "denied_count": 1,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "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": "LIVONIA MI 48152",
      "city": "Livonia",
      "state": "MI",
      "postal_code": "48152",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-05-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "FARMINGTON HILLS MI 48334",
      "city": "Farmington Hills",
      "state": "MI",
      "postal_code": "48334",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ANN ARBOR MI 48104",
      "city": "Ann Arbor",
      "county": "Washtenaw",
      "state": "MI",
      "postal_code": "48104",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-05-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ANN ARBOR OH 48104",
      "city": "Ann Arbor",
      "county": "Washtenaw",
      "state": "OH",
      "postal_code": "48104",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-05-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHICAGO MI 60606",
      "city": "Chicago",
      "county": "Cook",
      "state": "MI",
      "postal_code": "60606",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-05-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FARMINGTON HILLS MI 48334",
      "city": "Farmington Hills",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48334",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-27",
      "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": [
    "MI",
    "OH"
  ],
  "cities": [
    "Ann Arbor",
    "Chicago",
    "Farmington Hills"
  ],
  "postal_codes": [
    "48104",
    "60606",
    "48334"
  ],
  "top_markets": [
    {
      "city": "Ann Arbor",
      "state": "MI",
      "postal_code": "48104",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 62000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Chicago",
      "state": "MI",
      "postal_code": "60606",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 69000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Farmington Hills",
      "state": "MI",
      "postal_code": "48334",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 62000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Ann Arbor",
      "state": "OH",
      "postal_code": "48104",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 69000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}

Industry

{
  "naics_codes": [
    "541511"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 62000,
  "annualized_high_max": 0,
  "annualized_low_avg": 66200
}

Trend

[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 2,
    "worksite_count": 4,
    "wage_low_min": 62000,
    "wage_high_max": 0,
    "wage_low_avg": 66200
  }
]

Links

{
  "roles": "/v1/roles?company=BLUE%20ICY%20WATER%20LLC",
  "wages": "/v1/wages?company=BLUE%20ICY%20WATER%20LLC",
  "trends": "/v1/trends?company=BLUE%20ICY%20WATER%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=blue+icy+water+llc&limit=5JSON

Docs · Get an API key