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

Home / Companies / Spartan Camera

Spartan Camera 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
Spartan Camera
Spartan Camera
1354FY2019 to FY2025
Latest decision 2025-07-03
0SOFTWARE ENGINEER
8 filings
dol_oflc_lcaProfile

Activity summary

LCA filings13
Certified LCAs13
Denied LCAs0
Role titles5
Worksites4
Latest decision2025-07-03
USCIS approvals0
USCIS denials0

Aliases and source names

AliasesSource NamesSources
Spartan CameraSpartan Cameradol_oflc_lca

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SOFTWARE ENGINEER15-1252.00
Software Developers
8$80,101$120,000
Database Administrators15-1242.00
Database Administrators
1$78,000$78,000
OPERATIONS RESEARCH ANALYST15-2031.00
Operations Research Analysts
1$57,803$57,803
PRODUCT DEVELOPMENT MANAGER41-9031
SALES ENGINEERS
1$52,146$52,146
SOFTWARE DEVELOPER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
1$63,710$63,710
SOFTWARE ENGINEER15-1132.00
Software Developers, Applications
1$68,203$68,203

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
Johns CreekGA300976257,80399,0082,0202,023
DuluthGA300963182,971120,0002,0242,025
DuluthGA300973352,14678,0002,0192,024
Farmington HillsMI4833511109,208109,2082,0252,025

Full company payload

Company IDcompany:spartan camera
NameSpartan Camera
Normalized Namespartan camera
Source Company Idscompany_dol_oflc_lca_hco_outdoor_products_llc
Source NamesSpartan Camera
AliasesSpartan Camera
Identifiers-
Sourcesdol_oflc_lca
Names
{
  "source_names": [
    "Spartan Camera"
  ],
  "dba_names": [
    "Spartan Camera"
  ],
  "name_variants": [
    {
      "value": "Spartan Camera",
      "filing_count": 9,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "HCO OUTDOOR PRODUCTS LLC",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "HCO OUTDOOR PRODUCTS, LLC",
      "filing_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
LCA Activity
{
  "lca_count": 13,
  "case_count": 13,
  "role_title_count": 5,
  "worksite_count": 4,
  "total_workers": 13,
  "first_fiscal_year": 2019,
  "first_received_date": "2019-02-08",
  "latest_fiscal_year": 2025,
  "latest_decision_date": "2025-07-03",
  "certified_count": 13,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 11,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 13,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 12,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    },
    {
      "value": "N",
      "filing_count": 1,
      "first_fiscal_year": 2023,
      "latest_fiscal_year": 2023,
      "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": "DULUTH GA 30096",
      "city": "Duluth",
      "state": "GA",
      "postal_code": "30096",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-07-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "DULUTH GA 30097",
      "city": "Duluth",
      "state": "GA",
      "postal_code": "30097",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-08-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "JOHNS CREEK GA 30097",
      "city": "Johns Creek",
      "state": "GA",
      "postal_code": "30097",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-04-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "DULUTH GA 30096",
      "city": "Duluth",
      "county": "Gwinnett",
      "state": "GA",
      "postal_code": "30096",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2024-11-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FARMINGTON HILLS MI 48335",
      "city": "Farmington Hills",
      "county": "Oakland",
      "state": "MI",
      "postal_code": "48335",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2025-07-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DULUTH GA 30096",
      "city": "Duluth",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30096",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025,
      "latest_decision_date": "2024-10-08",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DULUTH GA 30097",
      "city": "Duluth",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30097",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2024,
      "latest_decision_date": "2024-08-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "JOHNS CREEK GA 30097",
      "city": "Johns Creek",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30097",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2023,
      "latest_decision_date": "2023-04-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "JOHNS CREEK GA 30097",
      "city": "Johns Creek",
      "county": "Gwinnett",
      "state": "GA",
      "postal_code": "30097",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-04-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DULUTH GA 30097",
      "city": "Duluth",
      "county": "Gwinnett",
      "state": "GA",
      "postal_code": "30097",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-03-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "worksite_address_count": 7,
    "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": [
    "GA",
    "MI"
  ],
  "cities": [
    "Johns Creek",
    "Duluth",
    "Farmington Hills"
  ],
  "postal_codes": [
    "30097",
    "30096",
    "48335"
  ],
  "top_markets": [
    {
      "city": "Johns Creek",
      "state": "GA",
      "postal_code": "30097",
      "lca_count": 6,
      "role_title_count": 2,
      "wage_low_min": 57803,
      "wage_high_max": 99008,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2023
    },
    {
      "city": "Duluth",
      "state": "GA",
      "postal_code": "30096",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 82971,
      "wage_high_max": 120000,
      "first_fiscal_year": 2024,
      "latest_fiscal_year": 2025
    },
    {
      "city": "Duluth",
      "state": "GA",
      "postal_code": "30097",
      "lca_count": 3,
      "role_title_count": 3,
      "wage_low_min": 52146,
      "wage_high_max": 78000,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2024
    },
    {
      "city": "Farmington Hills",
      "state": "MI",
      "postal_code": "48335",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 109208,
      "wage_high_max": 109208,
      "first_fiscal_year": 2025,
      "latest_fiscal_year": 2025
    }
  ]
}
Industry
{
  "naics_codes": [
    "541990"
  ],
  "naics_breakdown": [
    {
      "value": "541990",
      "filing_count": 13,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2025,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 52146,
  "annualized_high_max": 120000,
  "annualized_low_avg": 82210
}
Trend
[
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 52146,
    "wage_high_max": 63710,
    "wage_low_avg": 57928
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 57803,
    "wage_high_max": 57803,
    "wage_low_avg": 57803
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 68203,
    "wage_high_max": 68203,
    "wage_low_avg": 68203
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 80101,
    "wage_high_max": 99008,
    "wage_low_avg": 89703
  },
  {
    "fiscal_year": 2023,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 81120,
    "wage_high_max": 81120,
    "wage_low_avg": 81120
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 86460,
    "wage_high_max": 86460,
    "wage_low_avg": 86460
  },
  {
    "fiscal_year": 2024,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 78000,
    "wage_high_max": 78000,
    "wage_low_avg": 78000
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q1",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 82971,
    "wage_high_max": 120000,
    "wage_low_avg": 101485.5
  },
  {
    "fiscal_year": 2025,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 109208,
    "wage_high_max": 109208,
    "wage_low_avg": 109208
  }
]
Links
{
  "roles": "/v1/roles?company=Spartan%20Camera",
  "wages": "/v1/wages?company=Spartan%20Camera",
  "trends": "/v1/trends?company=Spartan%20Camera"
}
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=spartan+camera&limit=5JSON