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

Home / Companies / RED BOOK CONNECT, LLC

RED BOOK CONNECT, 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
RED BOOK CONNECT, LLC
RED BOOK CONNECT LLC
442FY2016 to FY2018
Latest decision 2018-07-30
3BUSINESS DEVELOPMENT EXECUTION MANAGER
1 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings4
Certified LCAs4
Denied LCAs0
Role titles4
Worksites2
Latest decision2018-07-30
USCIS approvals3
USCIS denials0

Aliases and source names

AliasesSource NamesSources
RED BOOK CONNECT LLCRED BOOK CONNECT, LLC, RED BOOK CONNECT LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
BUSINESS DEVELOPMENT EXECUTION MANAGER11-20221$90,000$0
LOCAL BUSINESS SALES MANAGER11-20221$68,000$0
LOCAL SALES MANAGER11-20221$91,333$0
PRODUCT SPECIALIST13-11611$85,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
EnglewoodCO801103368,00002,0162,018
San FranciscoCA941051185,00002,0162,016

Full company payload

Company IDcompany:red book connect
NameRED BOOK CONNECT, LLC
Normalized Namered book connect
Source Company Idscompany_dol_oflc_lca_red_book_connect_llc, company_uscis_h1b_datahub_red_book_connect_llc_tax_1558
Source NamesRED BOOK CONNECT, LLC, RED BOOK CONNECT LLC
AliasesRED BOOK CONNECT LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "RED BOOK CONNECT, LLC",
    "RED BOOK CONNECT LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "RED BOOK CONNECT, LLC",
      "filing_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "RED BOOK CONNECT LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "1558",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 4,
  "case_count": 4,
  "role_title_count": 4,
  "worksite_count": 2,
  "total_workers": 4,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-03-19",
  "latest_fiscal_year": 2018,
  "latest_decision_date": "2018-07-30",
  "certified_count": 4,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "E-3 Australian",
      "filing_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "H-1B",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "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": [
    "2014",
    "2015"
  ],
  "year_metrics": [
    {
      "cities": [
        "Alpharetta"
      ],
      "states": [
        "GA"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "51"
      ],
      "postal_codes": [
        "30009"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_red_book_connect_llc_tax_1558_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_050154"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Alpharetta"
      ],
      "states": [
        "GA"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "51"
      ],
      "postal_codes": [
        "30005",
        "30009"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_red_book_connect_llc_tax_1558_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_043147",
        "sr_uscis_h1b_datahub_2015_row_043148"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "ALPHARETTA GA 30005",
      "city": "Alpharetta",
      "state": "GA",
      "postal_code": "30005",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-07-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ENGLEWOOD CO 80110",
      "city": "Englewood",
      "county": "Arapahoe",
      "state": "CO",
      "postal_code": "80110",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-07-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN FRANCISCO CA 94105",
      "city": "San Francisco",
      "county": "San Francisco",
      "state": "CA",
      "postal_code": "94105",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2015-11-16",
      "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": [
    "CO",
    "CA",
    "GA"
  ],
  "cities": [
    "Englewood",
    "San Francisco",
    "Alpharetta"
  ],
  "postal_codes": [
    "80110",
    "94105",
    "30005",
    "30009"
  ],
  "top_markets": [
    {
      "city": "Englewood",
      "state": "CO",
      "postal_code": "80110",
      "lca_count": 3,
      "role_title_count": 3,
      "wage_low_min": 68000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "San Francisco",
      "state": "CA",
      "postal_code": "94105",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 85000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "511210",
    "51"
  ],
  "naics_breakdown": [
    {
      "value": "511210",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 68000,
  "annualized_high_max": 0,
  "annualized_low_avg": 83583.25
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 2,
    "wage_low_min": 68000,
    "wage_high_max": 0,
    "wage_low_avg": 76500
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 90000,
    "wage_high_max": 0,
    "wage_low_avg": 90000
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 91333,
    "wage_high_max": 0,
    "wage_low_avg": 91333
  }
]
Links
{
  "roles": "/v1/roles?company=RED%20BOOK%20CONNECT%2C%20LLC",
  "wages": "/v1/wages?company=RED%20BOOK%20CONNECT%2C%20LLC",
  "trends": "/v1/trends?company=RED%20BOOK%20CONNECT%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=red+book+connect+llc&limit=5JSON