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

Home / Companies / Ferrara Law Office

Ferrara Law Office 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
Ferrara Law Office
Ferrara Law Office
532FY2022 to FY2022
Latest decision 2022-06-22
0Document Management Specialist
3 filings
dol_oflc_lcaProfile

Activity summary

LCA filings5
Certified LCAs5
Denied LCAs0
Role titles3
Worksites2
Latest decision2022-06-22
USCIS approvals0
USCIS denials0

Aliases and source names

AliasesSource NamesSources
Ferrara Law OfficeFerrara Law Officedol_oflc_lca

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Document Management Specialist15-1199.12
Document Management Specialists
3$48,797$68,640
Computer Network Support Specialist15-1152.00
Computer Network Support Specialists
1$60,798$62,500
Computer Network and systems Administrator15-1142.00
Network and Computer Systems Administrators
1$72,800$79,040

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
RosevilleMI480664248,79768,6402,0222,022
RosevilleMI480661172,80079,0402,0222,022

Full company payload

Company IDcompany:ferrara law office
NameFerrara Law Office
Normalized Nameferrara law office
Source Company Idscompany_dol_oflc_lca_law_office_of_andrea_j_ferrara, company_dol_oflc_lca_andrea_j_ferrara
Source NamesFerrara Law Office
AliasesFerrara Law Office
Identifiers-
Sourcesdol_oflc_lca
Names
{
  "source_names": [
    "Ferrara Law Office"
  ],
  "dba_names": [
    "Ferrara Law Office"
  ],
  "name_variants": [
    {
      "value": "Ferrara Law Office",
      "filing_count": 4,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Ferrara Law Office",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}
LCA Activity
{
  "lca_count": 5,
  "case_count": 5,
  "role_title_count": 3,
  "worksite_count": 2,
  "total_workers": 5,
  "first_fiscal_year": 2022,
  "first_received_date": "2022-05-12",
  "latest_fiscal_year": 2022,
  "latest_decision_date": "2022-06-22",
  "certified_count": 5,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 4,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 4,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "H-1B",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "N",
      "filing_count": 2,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Y",
      "filing_count": 2,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "N",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 0,
  "total_denial": 0,
  "fiscal_years": [],
  "year_metrics": []
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "ROSEVILLE MI 48066",
      "city": "Roseville",
      "state": "MI",
      "postal_code": "48066",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-06-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "ROSEVILLE MI 48066",
      "city": "Roseville",
      "state": "MI",
      "postal_code": "48066",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-05-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "ROSEVILLE MI 48066",
      "city": "Roseville",
      "county": "Macomb",
      "state": "MI",
      "postal_code": "48066",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-06-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ROSEVILLE MI 48066",
      "city": "Roseville",
      "county": "Macomb",
      "state": "MI",
      "postal_code": "48066",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-05-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "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": [
    "MI"
  ],
  "cities": [
    "Roseville"
  ],
  "postal_codes": [
    "48066"
  ],
  "top_markets": [
    {
      "city": "Roseville",
      "state": "MI",
      "postal_code": "48066",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 48797,
      "wage_high_max": 68640,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022
    },
    {
      "city": "Roseville",
      "state": "MI",
      "postal_code": "48066",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 72800,
      "wage_high_max": 79040,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022
    }
  ]
}
Industry
{
  "naics_codes": [
    "541110"
  ],
  "naics_breakdown": [
    {
      "value": "541110",
      "filing_count": 4,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541110",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 48797,
  "annualized_high_max": 79040,
  "annualized_low_avg": 66739.375
}
Trend
[
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 5,
    "case_count": 5,
    "role_title_count": 3,
    "worksite_count": 2,
    "wage_low_min": 48797,
    "wage_high_max": 79040,
    "wage_low_avg": 66739.375
  }
]
Links
{
  "roles": "/v1/roles?company=Ferrara%20Law%20Office",
  "wages": "/v1/wages?company=Ferrara%20Law%20Office",
  "trends": "/v1/trends?company=Ferrara%20Law%20Office"
}
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=ferrara+law+office&limit=5JSON