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

Home / Companies / KEYSTONE CONSULTANTS, INC.

KEYSTONE CONSULTANTS, INC. 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
KEYSTONE CONSULTANTS, INC.
KEYSTONE CONSULTANTS INC
711FY2016 to FY2017
Latest decision 2017-09-11
5ENGINEER I
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings7
Certified LCAs7
Denied LCAs0
Role titles1
Worksites1
Latest decision2017-09-11
USCIS approvals5
USCIS denials0

Aliases and source names

AliasesSource NamesSources
KEYSTONE CONSULTANTS INCKEYSTONE CONSULTANTS, INC., KEYSTONE CONSULTANTS INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
ENGINEER I17-20814$56,725$100,000
ENGINEER I17-20513$54,870$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
CarnegiePA151067154,870100,0002,0162,017

Full company payload

Company IDcompany:keystone consultants
NameKEYSTONE CONSULTANTS, INC.
Normalized Namekeystone consultants
Source Company Idscompany_dol_oflc_lca_keystone_consultants_inc, company_uscis_h1b_datahub_keystone_consultants_inc_tax_9880
Source NamesKEYSTONE CONSULTANTS, INC., KEYSTONE CONSULTANTS INC
AliasesKEYSTONE CONSULTANTS INC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "KEYSTONE CONSULTANTS, INC.",
    "KEYSTONE CONSULTANTS INC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "KEYSTONE CONSULTANTS, INC.",
      "filing_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "KEYSTONE CONSULTANTS INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9880",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 7,
  "case_count": 7,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 11,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-03-04",
  "latest_fiscal_year": 2017,
  "latest_decision_date": "2017-09-11",
  "certified_count": 7,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 4,
      "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": 5,
  "total_denial": 0,
  "fiscal_years": [
    "2014",
    "2015",
    "2016",
    "2017",
    "2018"
  ],
  "year_metrics": [
    {
      "cities": [
        "Carnegie"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "15106"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_keystone_consultants_inc_tax_9880_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_016743"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Carnegie"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "15106"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_keystone_consultants_inc_tax_9880_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_013351"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Carnegie"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "15106"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_keystone_consultants_inc_tax_9880_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_013942"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Carnegie"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "15106"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_keystone_consultants_inc_tax_9880_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_012453"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Carnegie"
      ],
      "states": [
        "PA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "15106"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_keystone_consultants_inc_tax_9880_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_013283"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "CARNEGIE PA 15106",
      "city": "Carnegie",
      "state": "PA",
      "postal_code": "15106",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-09-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "CARNEGIE PA 15106",
      "city": "Carnegie",
      "county": "Allegheny",
      "state": "PA",
      "postal_code": "15106",
      "filing_count": 7,
      "case_count": 7,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-09-11",
      "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": [
    "PA"
  ],
  "cities": [
    "Carnegie"
  ],
  "postal_codes": [
    "15106"
  ],
  "top_markets": [
    {
      "city": "Carnegie",
      "state": "PA",
      "postal_code": "15106",
      "lca_count": 7,
      "role_title_count": 1,
      "wage_low_min": 54870,
      "wage_high_max": 100000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    }
  ]
}
Industry
{
  "naics_codes": [
    "541330",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541330",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 54870,
  "annualized_high_max": 100000,
  "annualized_low_avg": 60953.2857142857
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 54870,
    "wage_high_max": 70000,
    "wage_low_avg": 55488.3333333333
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 54870,
    "wage_high_max": 100000,
    "wage_low_avg": 65052
  }
]
Links
{
  "roles": "/v1/roles?company=KEYSTONE%20CONSULTANTS%2C%20INC.",
  "wages": "/v1/wages?company=KEYSTONE%20CONSULTANTS%2C%20INC.",
  "trends": "/v1/trends?company=KEYSTONE%20CONSULTANTS%2C%20INC."
}
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=keystone+consultants+inc&limit=5JSON