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

Home / Companies / PingCAP

PingCAP 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
PingCAP
28147FY2019 to FY2026
Latest decision 2026-03-25
0Senior HR Specialist
3 filings
dol_oflc_lcaProfile
PINGCAP US INC
PINGCAP US INC
0--FY- to FY-
Latest decision -
10-uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings28
Certified LCAs28
Denied LCAs0
Role titles14
Worksites7
Latest decision2026-03-25
USCIS approvals0
USCIS denials0

Aliases and source names

AliasesSource NamesSources
PingCAPPingCAPdol_oflc_lca

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Senior HR Specialist13-1071.00
Human Resources Specialists
3$145,000$145,000
Product Manager (Market & Statistical Analyst)13-1161.00
Market Research Analysts and Marketing Specialists
2$110,000$110,000
Product Marketing Lead, Growth15-1299.09
Information Technology Project Managers
2$195,000$195,000
Senior Database Engineer15-1199.00
Computer Occupations, All Other
2$233,280$233,280
Senior Product Manager15-1252.00
Software Developers
2$200,000$200,000
Senior Software Engineer15-1252.00
Software Developers
2$210,000$226,600
Site Reliability Engineer15-1121.00
Computer Systems Analysts
2$154,000$154,000
Software Engineer15-1132.00
Software Developers, Applications
2$220,000$220,000
Technical Account Manager15-1252.00
Software Developers
2$183,500$189,504
Technical Services Engineer15-1252.00
Software Developers
2$160,000$203,700

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
San MateoCA9440386110,000280,0002,0192,022
SunnyvaleCA9408986145,000233,2802,0222,023
SunnyvaleCA9408575160,000226,6002,0232,025
Little ElmTX7506821183,500189,5042,0242,025
IssaquahWA9802911200,000200,0002,0262,026
SeattleWA9805611200,000200,0002,0252,025
SnohomishWA9829611203,700203,7002,0262,026

Full company payload

Company IDcompany:pingcap
NamePingCAP
Normalized Namepingcap
Source Company Idscompany_dol_oflc_lca_pingcap_us_inc
Source NamesPingCAP
AliasesPingCAP
Identifiers-
Sourcesdol_oflc_lca
LCA Activity
{
  "lca_count": 28,
  "case_count": 28,
  "role_title_count": 14,
  "worksite_count": 7,
  "first_fiscal_year": 2019,
  "latest_fiscal_year": 2026,
  "latest_decision_date": "2026-03-25",
  "certified_count": 28,
  "denied_count": 0
}
Petition Activity
{
  "total_approval": 0,
  "total_denial": 0,
  "fiscal_years": [],
  "year_metrics": []
}
Geography
{
  "states": [
    "CA",
    "TX",
    "WA"
  ],
  "cities": [
    "San Mateo",
    "Sunnyvale",
    "Little Elm",
    "Issaquah",
    "Seattle",
    "Snohomish"
  ],
  "postal_codes": [
    "94403",
    "94089",
    "94085",
    "75068",
    "98029",
    "98056",
    "98296"
  ],
  "top_markets": [
    {
      "city": "San Mateo",
      "state": "CA",
      "postal_code": "94403",
      "lca_count": 8,
      "role_title_count": 6,
      "wage_low_min": 110000,
      "wage_high_max": 280000,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Sunnyvale",
      "state": "CA",
      "postal_code": "94089",
      "lca_count": 8,
      "role_title_count": 6,
      "wage_low_min": 145000,
      "wage_high_max": 233280,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Sunnyvale",
      "state": "CA",
      "postal_code": "94085",
      "lca_count": 7,
      "role_title_count": 5,
      "wage_low_min": 160000,
      "wage_high_max": 226600,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Little Elm",
      "state": "TX",
      "postal_code": "75068",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 183500,
      "wage_high_max": 189504,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Issaquah",
      "state": "WA",
      "postal_code": "98029",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 200000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026
    },
    {
      "city": "Seattle",
      "state": "WA",
      "postal_code": "98056",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 200000,
      "wage_high_max": 200000,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Snohomish",
      "state": "WA",
      "postal_code": "98296",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 203700,
      "wage_high_max": 203700,
      "first_fiscal_year": 2026,
      "latest_fiscal_year": 2026
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511"
  ]
}
Wage Summary
{
  "annualized_low_min": 110000,
  "annualized_high_max": 280000,
  "annualized_low_avg": 188334.428571429
}
Trend
[
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 216000,
    "wage_high_max": 216000,
    "wage_low_avg": 216000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 110000,
    "wage_high_max": 110000,
    "wage_low_avg": 110000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 110000,
    "wage_high_max": 220000,
    "wage_low_avg": 161333.333333333
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 280000,
    "wage_high_max": 280000,
    "wage_low_avg": 280000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 6,
    "case_count": 6,
    "role_title_count": 5,
    "worksite_count": 2,
    "wage_low_min": 145000,
    "wage_high_max": 233280,
    "wage_low_avg": 194843.333333333
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 200000,
    "wage_high_max": 200000,
    "wage_low_avg": 200000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 145000,
    "wage_high_max": 145000,
    "wage_low_avg": 145000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 145000,
    "wage_high_max": 145000,
    "wage_low_avg": 145000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 160000,
    "wage_high_max": 160000,
    "wage_low_avg": 160000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 183500,
    "wage_high_max": 183500,
    "wage_low_avg": 183500
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 226600,
    "wage_high_max": 226600,
    "wage_low_avg": 226600
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 210000,
    "wage_high_max": 210000,
    "wage_low_avg": 210000
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 165000,
    "wage_high_max": 165000,
    "wage_low_avg": 165000
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q1",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 195000,
    "wage_high_max": 195000,
    "wage_low_avg": 195000
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 189504,
    "wage_high_max": 189504,
    "wage_low_avg": 189504
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 180000,
    "wage_high_max": 180000,
    "wage_low_avg": 180000
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 200000,
    "wage_high_max": 200000,
    "wage_low_avg": 200000
  },
  {
    "fiscal_year": 2026,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 200000,
    "wage_high_max": 203700,
    "wage_low_avg": 201850
  }
]
Links
{
  "roles": "/v1/roles?company=PingCAP",
  "wages": "/v1/wages?company=PingCAP",
  "trends": "/v1/trends?company=PingCAP"
}
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&limit=5JSON