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

Home / Companies / THE CAMPBELL FOUNDATION

THE CAMPBELL FOUNDATION 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
THE CAMPBELL FOUNDATION
THE CAMPBELL FOUNDATION
411FY2017 to FY2017
Latest decision 2017-08-28
3MEDICAL RESEARCHER
4 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings4
Certified LCAs4
Denied LCAs0
Role titles1
Worksites1
Latest decision2017-08-28
USCIS approvals3
USCIS denials0

Aliases and source names

AliasesSource NamesSources
THE CAMPBELL FOUNDATIONTHE CAMPBELL FOUNDATIONdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
MEDICAL RESEARCHER19-10994$31,200$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
GermantownTN381384131,20002,0172,017

Full company payload

Company IDcompany:the campbell foundation
NameTHE CAMPBELL FOUNDATION
Normalized Namethe campbell foundation
Source Company Idscompany_dol_oflc_lca_the_campbell_foundation, company_uscis_h1b_datahub_the_campbell_foundation_tax_8038
Source NamesTHE CAMPBELL FOUNDATION
AliasesTHE CAMPBELL FOUNDATION
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "THE CAMPBELL FOUNDATION"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "THE CAMPBELL FOUNDATION",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "THE CAMPBELL FOUNDATION",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "8038",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 4,
  "case_count": 4,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 4,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-07-14",
  "latest_fiscal_year": 2017,
  "latest_decision_date": "2017-08-28",
  "certified_count": 4,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 4,
      "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": 3,
  "total_denial": 0,
  "fiscal_years": [
    "2012",
    "2015",
    "2018"
  ],
  "year_metrics": [
    {
      "cities": [
        "Germantown"
      ],
      "states": [
        "TN"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "38138"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_the_campbell_foundation_tax_8038_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_042444"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Germantown"
      ],
      "states": [
        "TN"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "38138"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_the_campbell_foundation_tax_8038_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_037986"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Germantown"
      ],
      "states": [
        "TN"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "38138"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_the_campbell_foundation_tax_8038_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_042138"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "GERMANTOWN TN 38138",
      "city": "Germantown",
      "state": "TN",
      "postal_code": "38138",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-08-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "GERMANTOWN TN 38138",
      "city": "Germantown",
      "county": "Shelby",
      "state": "TN",
      "postal_code": "38138",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-08-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "worksite_address_count": 1,
    "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": [
    "Germantown"
  ],
  "postal_codes": [
    "38138"
  ],
  "top_markets": [
    {
      "city": "Germantown",
      "state": "TN",
      "postal_code": "38138",
      "lca_count": 4,
      "role_title_count": 1,
      "wage_low_min": 31200,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    }
  ]
}
Industry
{
  "naics_codes": [
    "54171",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "54171",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 31200,
  "annualized_high_max": 0,
  "annualized_low_avg": 41882
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 4,
    "case_count": 4,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 31200,
    "wage_high_max": 0,
    "wage_low_avg": 41882
  }
]
Links
{
  "roles": "/v1/roles?company=THE%20CAMPBELL%20FOUNDATION",
  "wages": "/v1/wages?company=THE%20CAMPBELL%20FOUNDATION",
  "trends": "/v1/trends?company=THE%20CAMPBELL%20FOUNDATION"
}
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=the+campbell+foundation&limit=5JSON