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

Home / Companies / WALPOLE PUBLIC SCHOOLS

WALPOLE PUBLIC SCHOOLS 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
WALPOLE PUBLIC SCHOOLS
WALPOLE PUBLIC SCHOOLS
322FY2018 to FY2023
Latest decision 2023-01-27
2MANDARIN TEACHER
2 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings3
Certified LCAs3
Denied LCAs0
Role titles2
Worksites2
Latest decision2023-01-27
USCIS approvals2
USCIS denials0

Aliases and source names

AliasesSource NamesSources
WALPOLE PUBLIC SCHOOLSWALPOLE PUBLIC SCHOOLSdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
MANDARIN TEACHER25-2031.00
Secondary School Teachers, Except Special and Career/Technical Education
2$89,440$89,440
MANDARIN HIGH SCHOOL TEACHER25-20311$68,640$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
WalpoleMA020812268,64089,4402,0182,023
WalpoleMA20811189,44089,4402,0212,021

Full company payload

Company IDcompany:walpole public schools
NameWALPOLE PUBLIC SCHOOLS
Normalized Namewalpole public schools
Source Company Idscompany_dol_oflc_lca_walpole_public_schools, company_uscis_h1b_datahub_walpole_public_schools_tax_1334
Source NamesWALPOLE PUBLIC SCHOOLS
AliasesWALPOLE PUBLIC SCHOOLS
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "WALPOLE PUBLIC SCHOOLS"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "WALPOLE PUBLIC SCHOOLS",
      "filing_count": 2,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WALPOLE PUBLIC SCHOOLS",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "1334",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 3,
  "case_count": 3,
  "role_title_count": 2,
  "worksite_count": 2,
  "total_workers": 3,
  "first_fiscal_year": 2018,
  "first_received_date": "2018-01-03",
  "latest_fiscal_year": 2023,
  "latest_decision_date": "2023-01-27",
  "certified_count": 3,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified - Withdrawn",
      "filing_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "N",
      "filing_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 2,
  "total_denial": 0,
  "fiscal_years": [
    "2018",
    "2022"
  ],
  "year_metrics": [
    {
      "cities": [
        "Walpole"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "02081"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_walpole_public_schools_tax_1334_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_002040"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Walpole"
      ],
      "states": [
        "MA"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "02081"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_walpole_public_schools_tax_1334_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_057633"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "WALPOLE MA 02081",
      "city": "Walpole",
      "state": "MA",
      "postal_code": "02081",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-01-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "WALPOLE MA 2081",
      "city": "Walpole",
      "state": "MA",
      "postal_code": "2081",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-06-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "WALPOLE MA 02081",
      "city": "Walpole",
      "county": "Walpole",
      "state": "MA",
      "postal_code": "02081",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-01-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WALPOLE MA 2081",
      "city": "Walpole",
      "county": "Walpole",
      "state": "MA",
      "postal_code": "2081",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-06-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WALPOLE MA 02081",
      "city": "Walpole",
      "county": "Norfolk",
      "state": "MA",
      "postal_code": "02081",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-01-09",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "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": [
    "MA"
  ],
  "cities": [
    "Walpole"
  ],
  "postal_codes": [
    "02081",
    "2081"
  ],
  "top_markets": [
    {
      "city": "Walpole",
      "state": "MA",
      "postal_code": "02081",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 68640,
      "wage_high_max": 89440,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Walpole",
      "state": "MA",
      "postal_code": "2081",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 89440,
      "wage_high_max": 89440,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021
    }
  ]
}
Industry
{
  "naics_codes": [
    "611110",
    "61"
  ],
  "naics_breakdown": [
    {
      "value": "611110",
      "filing_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2023,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 68640,
  "annualized_high_max": 89440,
  "annualized_low_avg": 82506.6666666667
}
Trend
[
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 68640,
    "wage_high_max": 0,
    "wage_low_avg": 68640
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 89440,
    "wage_high_max": 89440,
    "wage_low_avg": 89440
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 89440,
    "wage_high_max": 89440,
    "wage_low_avg": 89440
  }
]
Links
{
  "roles": "/v1/roles?company=WALPOLE%20PUBLIC%20SCHOOLS",
  "wages": "/v1/wages?company=WALPOLE%20PUBLIC%20SCHOOLS",
  "trends": "/v1/trends?company=WALPOLE%20PUBLIC%20SCHOOLS"
}
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=walpole+public+schools&limit=5JSON