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

Home / Companies / YELLOWPAGES.COM, LLC

YELLOWPAGES.COM, 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
YELLOWPAGES.COM, LLC
YELLOWPAGES COM LLC, YELLOWPAGES.COM LLC
1453712FY2016 to FY2019
Latest decision 2019-08-12
377SENIOR SOFTWARE ENGINEER
44 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings145
Certified LCAs109
Denied LCAs3
Role titles37
Worksites12
Latest decision2019-08-12
USCIS approvals377
USCIS denials17

Aliases and source names

AliasesSource NamesSources
YELLOWPAGES COM LLC, YELLOWPAGES.COM LLCYELLOWPAGES.COM, LLC, YELLOWPAGES COM LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SENIOR SOFTWARE ENGINEER15-113244$91,900$130,000
SOFTWARE ENGINEER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
35$69,742$95,000
LEAD SOFTWARE ENGINEER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
6$93,163$93,163
SENIOR DATABASE ENGINEER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
4$101,900$101,900
DATA SCIENTIST15-11213$111,613$0
MANAGER, VALUE MANAGEMENT & PRICING ANALYTICS13-20513$93,400$0
SYSTEMS ADMINISTRATOR15-1121
COMPUTER SYSTEMS ANALYSTS
3$70,600$70,600
CAMPAIGN MANAGER13-1161
MARKET RESEARCH ANALYSTS AND MARKETING SPECIALISTS
2$58,783$58,783
LEAD QA ENGINEER15-11322$100,700$0
MARKETING BUSINESS ANALYST15-11212$77,106$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
GlendaleCA912031152860,000155,9002,0162,019
San FranciscoCA94105136110,400130,0002,0162,017
San JoseCA9511354101,900101,9002,0162,019
PleasantonCA9458821100,70002,0172,018
New YorkNY1001622120,22402,0162,016
GrapevineTX760512158,78358,7832,0172,019
DublinCA9456811100,70002,0172,017
FremontCA9453611100,70002,0172,017
FremontCA9455511100,70002,0172,017
NewarkCA9456011100,70002,0172,017

Full company payload

Company IDcompany:yellowpages com
NameYELLOWPAGES.COM, LLC
Normalized Nameyellowpages com
Source Company Idscompany_dol_oflc_lca_yellowpages_com_llc, company_uscis_h1b_datahub_yellowpages_com_llc_tax_4807, company_uscis_h1b_datahub_yellowpages_com_llc_tax_9480
Source NamesYELLOWPAGES.COM, LLC, YELLOWPAGES COM LLC
AliasesYELLOWPAGES COM LLC, YELLOWPAGES.COM LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "4807",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9480",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 145,
  "case_count": 145,
  "role_title_count": 37,
  "worksite_count": 12,
  "first_fiscal_year": 2016,
  "latest_fiscal_year": 2019,
  "latest_decision_date": "2019-08-12",
  "certified_count": 109,
  "denied_count": 3
}
Petition Activity
{
  "total_approval": 377,
  "total_denial": 17,
  "fiscal_years": [
    "2009",
    "2010",
    "2011",
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2017",
    "2018"
  ],
  "year_metrics": [
    {
      "cities": [
        "Dallas"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2009,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "75024",
        "75204"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 34,
      "initial_approval": 9,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_yellowpages_com_llc_tax_4807_2009",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2009_row_015127",
        "sr_uscis_h1b_datahub_2009_row_015128"
      ],
      "continuing_approval": 25
    },
    {
      "cities": [
        "Dallas"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2010,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "75204",
        "75398"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 35,
      "initial_approval": 11,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_yellowpages_com_llc_tax_4807_2010",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2010_row_011306",
        "sr_uscis_h1b_datahub_2010_row_011307"
      ],
      "continuing_approval": 24
    },
    {
      "cities": [
        "Dallas",
        "Houston",
        "San Ramon"
      ],
      "states": [
        "CA",
        "TX"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "75204",
        "77098",
        "94583"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 46,
      "initial_approval": 8,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_yellowpages_com_llc_tax_4807_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_012403",
        "sr_uscis_h1b_datahub_2011_row_012404",
        "sr_uscis_h1b_datahub_2011_row_012405"
      ],
      "continuing_approval": 38
    },
    {
      "cities": [
        "Dallas"
      ],
      "states": [
        "TX"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "75024",
        "75204"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 33,
      "initial_approval": 8,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_yellowpages_com_llc_tax_4807_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_010637",
        "sr_uscis_h1b_datahub_2012_row_010638"
      ],
      "continuing_approval": 25
    },
    {
      "cities": [
        "Dallas",
        "Glendale",
        "Union City"
      ],
      "states": [
        "CA",
        "TX"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "51",
        "54"
      ],
      "postal_codes": [
        "75204",
        "91203",
        "91406",
        "94587"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 37,
      "initial_approval": 2,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_yellowpages_com_llc_tax_4807_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_009919",
        "sr_uscis_h1b_datahub_2013_row_009920",
        "sr_uscis_h1b_datahub_2013_row_009921",
        "sr_uscis_h1b_datahub_2013_row_009922",
        "sr_uscis_h1b_datahub_2013_row_009923"
      ],
      "continuing_approval": 35
    },
    {
      "cities": [
        "Glendale",
        "Tucker",
        "Van Nuys"
      ],
      "states": [
        "CA",
        "GA"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "30084",
        "91203",
        "91406"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 62,
      "initial_approval": 5,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_yellowpages_com_llc_tax_4807_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_009600",
        "sr_uscis_h1b_datahub_2014_row_009601",
        "sr_uscis_h1b_datahub_2014_row_009602",
        "sr_uscis_h1b_datahub_2014_row_009603"
      ],
      "continuing_approval": 57
    },
    {
      "cities": [
        "Glendale",
        "Tucker"
      ],
      "states": [
        "CA",
        "GA"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "30084",
        "91203"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 43,
      "initial_approval": 12,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_yellowpages_com_llc_tax_4807_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_007708",
        "sr_uscis_h1b_datahub_2015_row_007709"
      ],
      "continuing_approval": 31
    },
    {
      "cities": [
        "Glendale"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "91203"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 38,
      "initial_approval": 6,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_yellowpages_com_llc_tax_4807_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_007963"
      ],
      "continuing_approval": 32
    },
    {
      "cities": [
        "Glendale"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "91203"
      ],
      "total_denial": 7,
      "initial_denial": 1,
      "total_approval": 38,
      "initial_approval": 2,
      "continuing_denial": 6,
      "petition_count_id": "petition_count_uscis_h1b_archive_yellowpages_com_llc_tax_4807_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_007157"
      ],
      "continuing_approval": 36
    },
    {
      "cities": [
        "Addison",
        "Dallas",
        "Glendale",
        "Grapevine"
      ],
      "states": [
        "CA",
        "TX"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "51",
        "54"
      ],
      "postal_codes": [
        "75001",
        "75261",
        "76051",
        "91203"
      ],
      "total_denial": 9,
      "initial_denial": 0,
      "total_approval": 10,
      "initial_approval": 6,
      "continuing_denial": 9,
      "petition_count_id": "petition_count_uscis_h1b_archive_yellowpages_com_llc_tax_4807_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_007552",
        "sr_uscis_h1b_datahub_2018_row_007553",
        "sr_uscis_h1b_datahub_2018_row_007554",
        "sr_uscis_h1b_datahub_2018_row_007555"
      ],
      "continuing_approval": 4
    },
    {
      "cities": [
        "Glendale"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "91203"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_yellowpages_com_llc_tax_9480_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_007967"
      ],
      "continuing_approval": 1
    }
  ]
}
Geography
{
  "states": [
    "CA",
    "NY",
    "TX",
    "GA"
  ],
  "cities": [
    "Glendale",
    "San Francisco",
    "San Jose",
    "Pleasanton",
    "New York",
    "Grapevine",
    "Dublin",
    "Fremont",
    "Newark",
    "Tucker",
    "Addison",
    "Dallas",
    "Houston",
    "San Ramon",
    "Union City",
    "Van Nuys"
  ],
  "postal_codes": [
    "91203",
    "94105",
    "95113",
    "94588",
    "10016",
    "76051",
    "94568",
    "94536",
    "94555",
    "94560",
    "30084",
    "75001",
    "75024",
    "75204",
    "75261",
    "75398",
    "77098",
    "91406",
    "94583",
    "94587"
  ],
  "top_markets": [
    {
      "city": "Glendale",
      "state": "CA",
      "postal_code": "91203",
      "lca_count": 115,
      "role_title_count": 28,
      "wage_low_min": 60000,
      "wage_high_max": 155900,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019
    },
    {
      "city": "San Francisco",
      "state": "CA",
      "postal_code": "94105",
      "lca_count": 13,
      "role_title_count": 6,
      "wage_low_min": 110400,
      "wage_high_max": 130000,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "San Jose",
      "state": "CA",
      "postal_code": "95113",
      "lca_count": 5,
      "role_title_count": 4,
      "wage_low_min": 101900,
      "wage_high_max": 101900,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Pleasanton",
      "state": "CA",
      "postal_code": "94588",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 100700,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10016",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 120224,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "Grapevine",
      "state": "TX",
      "postal_code": "76051",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 58783,
      "wage_high_max": 58783,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019
    },
    {
      "city": "Dublin",
      "state": "CA",
      "postal_code": "94568",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 100700,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Fremont",
      "state": "CA",
      "postal_code": "94536",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 100700,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Fremont",
      "state": "CA",
      "postal_code": "94555",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 100700,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Newark",
      "state": "CA",
      "postal_code": "94560",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 100700,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}
Industry
{
  "naics_codes": [
    "541890",
    "51",
    "54"
  ]
}
Wage Summary
{
  "annualized_low_min": 58783,
  "annualized_high_max": 155900,
  "annualized_low_avg": 101450.331034483
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 67,
    "case_count": 67,
    "role_title_count": 26,
    "worksite_count": 5,
    "wage_low_min": 61400,
    "wage_high_max": 130000,
    "wage_low_avg": 106398.432835821
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 55,
    "case_count": 55,
    "role_title_count": 18,
    "worksite_count": 10,
    "wage_low_min": 58783,
    "wage_high_max": 0,
    "wage_low_avg": 99969.4
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 14,
    "case_count": 14,
    "role_title_count": 9,
    "worksite_count": 2,
    "wage_low_min": 60000,
    "wage_high_max": 155900,
    "wage_low_avg": 94464.0714285714
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 9,
    "case_count": 9,
    "role_title_count": 6,
    "worksite_count": 3,
    "wage_low_min": 58783,
    "wage_high_max": 137010,
    "wage_low_avg": 84532.1111111111
  }
]
Links
{
  "roles": "/v1/roles?company=YELLOWPAGES.COM%2C%20LLC",
  "wages": "/v1/wages?company=YELLOWPAGES.COM%2C%20LLC",
  "trends": "/v1/trends?company=YELLOWPAGES.COM%2C%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=yellowpages+com+llc&limit=5JSON