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

Home / Companies / ISTANBUL LLC

ISTANBUL 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
ISTANBUL LLC
ADVANCED GRANITE SOLUTIONS, ISTANBUL LLC DBA ADVANCED GRANITE, ISTANBUL LLC D/B/A ADVANCED
211FY2016 to FY2019
Latest decision 2019-08-02
3INTERIOR DESIGNER (KITCHEN & BATH)
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile
ISTANBUL LLC AKA ADVANCED GRANITE
ISTANBUL LLC AKA ADVANCED GRANITE
0--FY- to FY-
Latest decision -
1-uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings2
Certified LCAs2
Denied LCAs0
Role titles1
Worksites1
Latest decision2019-08-02
USCIS approvals3
USCIS denials0

Aliases and source names

AliasesSource NamesSources
ADVANCED GRANITE SOLUTIONS, ISTANBUL LLC DBA ADVANCED GRANITE, ISTANBUL LLC D/B/A ADVANCEDISTANBUL LLC, ISTANBUL LLC DBA ADVANCED GRANITE, ISTANBUL LLC D/B/A ADVANCEDdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
INTERIOR DESIGNER (KITCHEN & BATH)27-1025
INTERIOR DESIGNERS
2$40,000$40,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
EdgewoodMD210402140,00040,0002,0162,019

Full company payload

Company IDcompany:istanbul
NameISTANBUL LLC
Normalized Nameistanbul
Source Company Idscompany_dol_oflc_lca_istanbul_llc, company_uscis_h1b_datahub_istanbul_llc_dba_advanced_granite_tax_7364, company_uscis_h1b_datahub_istanbul_llc_d_b_a_advanced_tax_7364
Source NamesISTANBUL LLC, ISTANBUL LLC DBA ADVANCED GRANITE, ISTANBUL LLC D/B/A ADVANCED
AliasesADVANCED GRANITE SOLUTIONS, ISTANBUL LLC DBA ADVANCED GRANITE, ISTANBUL LLC D/B/A ADVANCED
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "ISTANBUL LLC",
    "ISTANBUL LLC DBA ADVANCED GRANITE",
    "ISTANBUL LLC D/B/A ADVANCED"
  ],
  "dba_names": [
    "ADVANCED GRANITE SOLUTIONS"
  ],
  "name_variants": [
    {
      "value": "ADVANCED GRANITE SOLUTIONS",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "ISTANBUL LLC",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "ISTANBUL LLC DBA ADVANCED GRANITE",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "ISTANBUL LLC D/B/A ADVANCED",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7364",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 2,
  "case_count": 2,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 2,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-22",
  "latest_fiscal_year": 2019,
  "latest_decision_date": "2019-08-02",
  "certified_count": 2,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 3,
  "total_denial": 0,
  "fiscal_years": [
    "2009",
    "2014",
    "2017"
  ],
  "year_metrics": [
    {
      "cities": [
        "Edgewood"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "23"
      ],
      "postal_codes": [
        "21040"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_istanbul_llc_dba_advanced_granite_tax_7364_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_009482"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Edgewood"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "23"
      ],
      "postal_codes": [
        "21040"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_istanbul_llc_dba_advanced_granite_tax_7364_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_007050"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Edgewood"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "23"
      ],
      "postal_codes": [
        "21040"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_istanbul_llc_d_b_a_advanced_tax_7364_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_014936"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "EDGEWOOD MD 21040",
      "city": "Edgewood",
      "state": "MD",
      "postal_code": "21040",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-08-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "EDGEWOOD MD 21040",
      "city": "Edgewood",
      "county": "Maryland",
      "state": "MD",
      "postal_code": "21040",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-08-02",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "EDGEWOOD MD 21040",
      "city": "Edgewood",
      "county": "Howard",
      "state": "MD",
      "postal_code": "21040",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 2,
    "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": [
    "MD"
  ],
  "cities": [
    "Edgewood"
  ],
  "postal_codes": [
    "21040"
  ],
  "top_markets": [
    {
      "city": "Edgewood",
      "state": "MD",
      "postal_code": "21040",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 40000,
      "wage_high_max": 40000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019
    }
  ]
}
Industry
{
  "naics_codes": [
    "238340",
    "23"
  ],
  "naics_breakdown": [
    {
      "value": "238340",
      "filing_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 40000,
  "annualized_high_max": 40000,
  "annualized_low_avg": 40000
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 40000,
    "wage_high_max": 0,
    "wage_low_avg": 40000
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 40000,
    "wage_high_max": 40000,
    "wage_low_avg": 40000
  }
]
Links
{
  "roles": "/v1/roles?company=ISTANBUL%20LLC",
  "wages": "/v1/wages?company=ISTANBUL%20LLC",
  "trends": "/v1/trends?company=ISTANBUL%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=istanbul+llc&limit=5JSON