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

Home / Companies / HAMILTON ENTERPRISES, LLC

HAMILTON ENTERPRISES, LLC 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
HAMILTON ENTERPRISES, LLC
FRANKLIN AND TURNER, Franklin and Turner, HAMILTON ENTERPRISES LLC DBA FRANK
3422FY2016 to FY2024
Latest decision 2024-07-17
19STAFF AUDITOR
23 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings34
Certified LCAs33
Denied LCAs0
Role titles2
Worksites2
Latest decision2024-07-17
USCIS approvals19
USCIS denials0

Aliases and source names

AliasesSource NamesSources
FRANKLIN AND TURNER, Franklin and Turner, HAMILTON ENTERPRISES LLC DBA FRANK, HAMILTON ENTERPRISES LLC DBA FRANKLIN AND TURNERHAMILTON ENTERPRISES, LLC, HAMILTON ENTERPRISES LLC DBA FRANK, HAMILTON ENTERPRISES LLC DBA FRANKLIN AND TURNERdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
STAFF AUDITOR13-2011
ACCOUNTANTS AND AUDITORS
23$56,160$70,000
Staff Auditor13-2011.00
Accountants and Auditors
7$60,000$81,500
Senior Auditor13-2011.00
Accountants and Auditors
4$80,000$110,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
GreenbeltMD2077033257,512110,0002,0172,024
GreenbeltMD207541156,16002,0162,016

Full company payload

Company IDcompany:hamilton enterprises
NameHAMILTON ENTERPRISES, LLC
Normalized Namehamilton enterprises
Source Company Idscompany_dol_oflc_lca_hamilton_enterprises_llc, company_uscis_h1b_datahub_hamilton_enterprises_llc_dba_frank_tax_7883, company_uscis_h1b_datahub_hamilton_enterprises_llc_dba_franklin_and_turner_tax_7883, company_uscis_h1b_datahub_hamilton_enterprises_llc_dba_frank_tax_7993
Source NamesHAMILTON ENTERPRISES, LLC, HAMILTON ENTERPRISES LLC DBA FRANK, HAMILTON ENTERPRISES LLC DBA FRANKLIN AND TURNER
AliasesFRANKLIN AND TURNER, Franklin and Turner, HAMILTON ENTERPRISES LLC DBA FRANK, HAMILTON ENTERPRISES LLC DBA FRANKLIN AND TURNER
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "HAMILTON ENTERPRISES, LLC",
    "HAMILTON ENTERPRISES LLC DBA FRANK",
    "HAMILTON ENTERPRISES LLC DBA FRANKLIN AND TURNER"
  ],
  "dba_names": [
    "FRANKLIN AND TURNER",
    "Franklin and Turner"
  ],
  "name_variants": [
    {
      "value": "HAMILTON ENTERPRISES, LLC",
      "filing_count": 13,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Franklin and Turner",
      "filing_count": 11,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "FRANKLIN AND TURNER",
      "filing_count": 10,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "HAMILTON ENTERPRISES LLC DBA FRANK",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "HAMILTON ENTERPRISES LLC DBA FRANKLIN AND TURNER",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "HAMILTON ENTERPRISES LLC DBA FRANK",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7883",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "7993",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 34,
  "case_count": 34,
  "role_title_count": 2,
  "worksite_count": 2,
  "total_workers": 34,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-04-14",
  "latest_fiscal_year": 2024,
  "latest_decision_date": "2024-07-17",
  "certified_count": 33,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 22,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 11,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 34,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 33,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 19,
  "total_denial": 0,
  "fiscal_years": [
    "2016",
    "2017",
    "2018",
    "2019",
    "2020",
    "2021",
    "2022",
    "2023"
  ],
  "year_metrics": [
    {
      "cities": [
        "Dunkirk"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20754"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hamilton_enterprises_llc_dba_frank_tax_7883_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_010271"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Dunkirk",
        "Greenbelt"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20754",
        "20770"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hamilton_enterprises_llc_dba_frank_tax_7883_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_009106",
        "sr_uscis_h1b_datahub_2017_row_009107"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Greenbelt"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20770"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 3,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hamilton_enterprises_llc_dba_frank_tax_7883_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_009676"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Greenbelt"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20770"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hamilton_enterprises_llc_dba_frank_tax_7883_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_009724"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Greenbelt"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20770"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hamilton_enterprises_llc_dba_frank_tax_7883_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_021200"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Greenbelt"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20770"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hamilton_enterprises_llc_dba_frank_tax_7883_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_023198"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Greenbelt"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2022,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20770"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 2,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hamilton_enterprises_llc_dba_franklin_and_turner_tax_7883_2022",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2022_row_023110"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Greenbelt"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2023,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20770"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hamilton_enterprises_llc_dba_franklin_and_turner_tax_7883_2023",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2023_row_012754"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Greenbelt"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "20770"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_hamilton_enterprises_llc_dba_frank_tax_7993_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_009725"
      ],
      "continuing_approval": 0
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "GREENBELT MD 20770",
      "city": "Greenbelt",
      "state": "MD",
      "postal_code": "20770",
      "filing_count": 33,
      "case_count": 33,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-07-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "GREENBELT MD 20754",
      "city": "Greenbelt",
      "state": "MD",
      "postal_code": "20754",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-04-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "GREENBELT MD 20770",
      "city": "Greenbelt",
      "county": "Prince George's",
      "state": "MD",
      "postal_code": "20770",
      "filing_count": 32,
      "case_count": 32,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-07-17",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "GREENBELT MD 20770",
      "city": "Greenbelt",
      "county": "Md",
      "state": "MD",
      "postal_code": "20770",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-04-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "GREENBELT MD 20754",
      "city": "Greenbelt",
      "county": "Prince Georges",
      "state": "MD",
      "postal_code": "20754",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-04-20",
      "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": [
    "MD"
  ],
  "cities": [
    "Greenbelt",
    "Dunkirk"
  ],
  "postal_codes": [
    "20770",
    "20754"
  ],
  "top_markets": [
    {
      "city": "Greenbelt",
      "state": "MD",
      "postal_code": "20770",
      "lca_count": 33,
      "role_title_count": 2,
      "wage_low_min": 57512,
      "wage_high_max": 110000,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024
    },
    {
      "city": "Greenbelt",
      "state": "MD",
      "postal_code": "20754",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 56160,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "541211",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541211",
      "filing_count": 32,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2024,
      "source": "dol_oflc_lca"
    },
    {
      "value": "54121",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 56160,
  "annualized_high_max": 110000,
  "annualized_low_avg": 64685.7058823529
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 56160,
    "wage_high_max": 0,
    "wage_low_avg": 56160
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 12,
    "case_count": 12,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 57512,
    "wage_high_max": 0,
    "wage_low_avg": 57512
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 57512,
    "wage_high_max": 0,
    "wage_low_avg": 57512
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 7,
    "case_count": 7,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 59072,
    "wage_high_max": 70000,
    "wage_low_avg": 62030.8571428571
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 80000,
    "wage_high_max": 80000,
    "wage_low_avg": 80000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 60000,
    "wage_high_max": 60000,
    "wage_low_avg": 60000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 60000,
    "wage_high_max": 60000,
    "wage_low_avg": 60000
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 80000,
    "wage_high_max": 85000,
    "wage_low_avg": 83333.3333333333
  },
  {
    "fiscal_year": 2022,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 110000,
    "wage_high_max": 110000,
    "wage_low_avg": 110000
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 62379,
    "wage_high_max": 62379,
    "wage_low_avg": 62379
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 81500,
    "wage_high_max": 81500,
    "wage_low_avg": 81500
  }
]
Links
{
  "roles": "/v1/roles?company=HAMILTON%20ENTERPRISES%2C%20LLC",
  "wages": "/v1/wages?company=HAMILTON%20ENTERPRISES%2C%20LLC",
  "trends": "/v1/trends?company=HAMILTON%20ENTERPRISES%2C%20LLC"
}
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=hamilton+enterprises+llc&limit=5JSON