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

Home / Companies / PINGCAP US INC

PINGCAP US 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
PINGCAP US INC
PINGCAP US INC
0--FY- to FY-
Latest decision -
10-uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings0
Certified LCAs0
Denied LCAs0
Role titles-
Worksites-
Latest decision-
USCIS approvals10
USCIS denials0

Aliases and source names

AliasesSource NamesSources
PINGCAP US INCPINGCAP US INCuscis_h1b_employer_data_hub

Top roles

No top-role rows returned.

Full company payload

Company IDcompany:pingcap us
NamePINGCAP US INC
Normalized Namepingcap us
Source Company Idscompany_uscis_h1b_datahub_pingcap_us_inc_tax_5275
Source NamesPINGCAP US INC
AliasesPINGCAP US INC
Sourcesuscis_h1b_employer_data_hub
Trend-
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5275",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 0,
  "case_count": 0,
  "role_title_count": null,
  "worksite_count": null,
  "first_fiscal_year": null,
  "latest_fiscal_year": null,
  "latest_decision_date": null,
  "certified_count": 0,
  "denied_count": 0
}
Petition Activity
{
  "total_approval": 10,
  "total_denial": 0,
  "fiscal_years": [
    "2019",
    "2021",
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "San Mateo"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "94403"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_pingcap_us_inc_tax_5275_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_022642"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "San Mateo"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94403"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_pingcap_us_inc_tax_5275_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_040573"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "San Mateo",
        "Sunnyvale"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94089",
        "94403"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_pingcap_us_inc_tax_5275_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_040520",
        "sr_uscis_h1b_datahub_2022_row_040521",
        "sr_uscis_h1b_datahub_2022_row_040522"
      ],
      "continuing_approval": 5
    },
    {
      "cities": [
        "Sunnyvale"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94089"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_pingcap_us_inc_tax_5275_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_022266"
      ],
      "continuing_approval": 3
    }
  ]
}
Geography
{
  "states": [
    "CA"
  ],
  "cities": [
    "San Mateo",
    "Sunnyvale"
  ],
  "postal_codes": [
    "94089",
    "94403"
  ],
  "top_markets": []
}
Industry
{
  "naics_codes": [
    "54",
    "99"
  ]
}
Wage Summary
{
  "annualized_low_min": null,
  "annualized_high_max": null,
  "annualized_low_avg": null
}
Links
{
  "roles": "/v1/roles?company=PINGCAP%20US%20INC",
  "wages": "/v1/wages?company=PINGCAP%20US%20INC",
  "trends": "/v1/trends?company=PINGCAP%20US%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=pingcap+us+inc&limit=5JSON