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

Home / Companies / HARTFORD PUBLIC SCHOOLS

HARTFORD 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
HARTFORD PUBLIC SCHOOLS
HARTFORD PUBLIC SCHOOLS
111FY2016 to FY2016
Latest decision 2016-02-23
0MANDARIN CHINESE TEACHER
1 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile
WEST HARTFORD PUBLIC SCHOOLS
WEST HARTFORD PUBLIC SCHOOLS
0--FY- to FY-
Latest decision -
5-uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings1
Certified LCAs1
Denied LCAs0
Role titles1
Worksites1
Latest decision2016-02-23
USCIS approvals0
USCIS denials1

Aliases and source names

AliasesSource NamesSources
HARTFORD PUBLIC SCHOOLSHARTFORD PUBLIC SCHOOLSdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
MANDARIN CHINESE TEACHER25-20211$62,711$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
HartfordCT061141162,71102,0162,016

Full company payload

Company IDcompany:hartford public schools
NameHARTFORD PUBLIC SCHOOLS
Normalized Namehartford public schools
Source Company Idscompany_dol_oflc_lca_hartford_public_schools, company_uscis_h1b_datahub_hartford_public_schools_tax_1870
Source NamesHARTFORD PUBLIC SCHOOLS
AliasesHARTFORD PUBLIC SCHOOLS
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "HARTFORD PUBLIC SCHOOLS"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "HARTFORD PUBLIC SCHOOLS",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "HARTFORD PUBLIC SCHOOLS",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "1870",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 1,
  "case_count": 1,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 1,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-02-17",
  "latest_fiscal_year": 2016,
  "latest_decision_date": "2016-02-23",
  "certified_count": 1,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": []
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 0,
  "total_denial": 1,
  "fiscal_years": [
    "2014"
  ],
  "year_metrics": [
    {
      "cities": [
        "Hartford"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "61"
      ],
      "postal_codes": [
        "06103"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hartford_public_schools_tax_1870_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_003359"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "HARTFORD CT 06103",
      "city": "Hartford",
      "state": "CT",
      "postal_code": "06103",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-02-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "HARTFORD CT 06114",
      "city": "Hartford",
      "county": "Hartford",
      "state": "CT",
      "postal_code": "06114",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-02-23",
      "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": [
    "CT"
  ],
  "cities": [
    "Hartford"
  ],
  "postal_codes": [
    "06114",
    "06103"
  ],
  "top_markets": [
    {
      "city": "Hartford",
      "state": "CT",
      "postal_code": "06114",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 62711,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "61"
  ],
  "naics_breakdown": []
}
Wage Summary
{
  "annualized_low_min": 62711,
  "annualized_high_max": 0,
  "annualized_low_avg": 62711
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 62711,
    "wage_high_max": 0,
    "wage_low_avg": 62711
  }
]
Links
{
  "roles": "/v1/roles?company=HARTFORD%20PUBLIC%20SCHOOLS",
  "wages": "/v1/wages?company=HARTFORD%20PUBLIC%20SCHOOLS",
  "trends": "/v1/trends?company=HARTFORD%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=hartford+public+schools&limit=5JSON