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

Home / Companies / INGRAM BOOK GROUP INC.

INGRAM BOOK GROUP 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
INGRAM BOOK GROUP INC.
INGRAM BOOK GROUP INC
542FY2016 to FY2017
Latest decision 2016-10-21
22SENIOR ORACLE DATABASE ADMINISTRATOR
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings5
Certified LCAs4
Denied LCAs1
Role titles4
Worksites2
Latest decision2016-10-21
USCIS approvals22
USCIS denials0

Aliases and source names

AliasesSource NamesSources
INGRAM BOOK GROUP INCINGRAM BOOK GROUP INC., INGRAM BOOK GROUP INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SENIOR ORACLE DATABASE ADMINISTRATOR15-11412$100,568$143,979
DATABASE ADMINISTRATOR15-11411$66,893$93,046
SENIOR PROGRAMMER / ANALYST15-11321$93,236$113,538
SOFTWARE ENGINEER, SENIOR15-11321$93,413$135,476

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
La VergneTN37086-19863366,893135,4762,0162,016
La VergneTN3708621100,568143,9792,0172,017

Full company payload

Company IDcompany:ingram book group
NameINGRAM BOOK GROUP INC.
Normalized Nameingram book group
Source Company Idscompany_dol_oflc_lca_ingram_book_group_inc, company_uscis_h1b_datahub_ingram_book_group_inc_tax_2373
Source NamesINGRAM BOOK GROUP INC., INGRAM BOOK GROUP INC
AliasesINGRAM BOOK GROUP INC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "INGRAM BOOK GROUP INC.",
    "INGRAM BOOK GROUP INC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "INGRAM BOOK GROUP INC.",
      "filing_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "INGRAM BOOK GROUP INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "2373",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 5,
  "case_count": 5,
  "role_title_count": 4,
  "worksite_count": 2,
  "total_workers": 5,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-11-19",
  "latest_fiscal_year": 2017,
  "latest_decision_date": "2016-10-21",
  "certified_count": 4,
  "denied_count": 1,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 2,
      "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": 22,
  "total_denial": 0,
  "fiscal_years": [
    "2011",
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2017"
  ],
  "year_metrics": [
    {
      "cities": [
        "La Vergne"
      ],
      "states": [
        "TN"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "37086"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ingram_book_group_inc_tax_2373_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_046769"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "La Vergne"
      ],
      "states": [
        "TN"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "42"
      ],
      "postal_codes": [
        "37086"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ingram_book_group_inc_tax_2373_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_042616"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "La Vergne"
      ],
      "states": [
        "TN"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "42"
      ],
      "postal_codes": [
        "37086"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ingram_book_group_inc_tax_2373_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_042516"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "La Vergne"
      ],
      "states": [
        "TN"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "42"
      ],
      "postal_codes": [
        "37086"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 7,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ingram_book_group_inc_tax_2373_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_043782"
      ],
      "continuing_approval": 5
    },
    {
      "cities": [
        "La Vergne"
      ],
      "states": [
        "TN"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "42"
      ],
      "postal_codes": [
        "37086"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ingram_book_group_inc_tax_2373_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_038098"
      ],
      "continuing_approval": 5
    },
    {
      "cities": [
        "La Vergne"
      ],
      "states": [
        "TN"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "42"
      ],
      "postal_codes": [
        "37086"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ingram_book_group_inc_tax_2373_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_041845"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "La Vergne"
      ],
      "states": [
        "TN"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "42"
      ],
      "postal_codes": [
        "37086"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ingram_book_group_inc_tax_2373_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_038413"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "LA VERGNE TN 37086",
      "city": "La Vergne",
      "state": "TN",
      "postal_code": "37086",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-10-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "LA VERGNE TN 37086",
      "city": "La Vergne",
      "county": "Rutherford",
      "state": "TN",
      "postal_code": "37086",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-10-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "LA VERGNE TN 37086",
      "city": "La Vergne",
      "county": "Tennessee",
      "state": "TN",
      "postal_code": "37086",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-10-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "LA VERGNE TN 37086-1986",
      "city": "La Vergne",
      "county": "Rutherford",
      "state": "TN",
      "postal_code": "37086-1986",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-02-29",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 3,
    "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": [
    "TN"
  ],
  "cities": [
    "La Vergne"
  ],
  "postal_codes": [
    "37086-1986",
    "37086"
  ],
  "top_markets": [
    {
      "city": "La Vergne",
      "state": "TN",
      "postal_code": "37086-1986",
      "lca_count": 3,
      "role_title_count": 3,
      "wage_low_min": 66893,
      "wage_high_max": 135476,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    },
    {
      "city": "La Vergne",
      "state": "TN",
      "postal_code": "37086",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 100568,
      "wage_high_max": 143979,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}
Industry
{
  "naics_codes": [
    "424920",
    "42",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "424920",
      "filing_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 66893,
  "annualized_high_max": 143979,
  "annualized_low_avg": 90935.6
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 1,
    "wage_low_min": 66893,
    "wage_high_max": 135476,
    "wage_low_avg": 84514
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 100568,
    "wage_high_max": 143979,
    "wage_low_avg": 100568
  }
]
Links
{
  "roles": "/v1/roles?company=INGRAM%20BOOK%20GROUP%20INC.",
  "wages": "/v1/wages?company=INGRAM%20BOOK%20GROUP%20INC.",
  "trends": "/v1/trends?company=INGRAM%20BOOK%20GROUP%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=ingram+book+group+inc&limit=5JSON