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

Home / Companies / Sparrow Robot LLC

Sparrow Robot 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
Sparrow Robot LLC
SPARROW ROBOT LLC
421FY2018 to FY2021
Latest decision 2021-04-08
3DEVELOPMENT ENGINEER
1 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings4
Certified LCAs4
Denied LCAs0
Role titles2
Worksites1
Latest decision2021-04-08
USCIS approvals3
USCIS denials0

Aliases and source names

AliasesSource NamesSources
SPARROW ROBOT LLCSparrow Robot LLC, SPARROW ROBOT LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
DEVELOPMENT ENGINEER17-21411$78,000$83,200
DEVELOPMENT ENGINEER17-2141.00
Mechanical Engineers
1$76,000$85,000
LEAD DEVELOPMENT ENGINEER17-2071
ELECTRICAL ENGINEERS
1$78,000$83,200
Lead Development Engineer17-2071.00
Electrical Engineers
1$78,000$83,200

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
ColumbusOH432124276,00085,0002,0182,021

Full company payload

Company IDcompany:sparrow robot
NameSparrow Robot LLC
Normalized Namesparrow robot
Source Company Idscompany_dol_oflc_lca_sparrow_robot_llc, company_uscis_h1b_datahub_sparrow_robot_llc_tax_2491
Source NamesSparrow Robot LLC, SPARROW ROBOT LLC
AliasesSPARROW ROBOT LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Sparrow Robot LLC",
    "SPARROW ROBOT LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Sparrow Robot LLC",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SPARROW ROBOT LLC",
      "filing_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SPARROW ROBOT LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "2491",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 4,
  "case_count": 4,
  "role_title_count": 2,
  "worksite_count": 1,
  "total_workers": 4,
  "first_fiscal_year": 2018,
  "first_received_date": "2018-02-28",
  "latest_fiscal_year": 2021,
  "latest_decision_date": "2021-04-08",
  "certified_count": 4,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CERTIFIED",
      "filing_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 3,
  "total_denial": 0,
  "fiscal_years": [
    "2019",
    "2020",
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "43212"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sparrow_robot_llc_tax_2491_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_024116"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "99"
      ],
      "postal_codes": [
        "43212"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sparrow_robot_llc_tax_2491_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_044841"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Columbus"
      ],
      "states": [
        "OH"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "33"
      ],
      "postal_codes": [
        "43212"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sparrow_robot_llc_tax_2491_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_048927"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "COLUMBUS OH 43212",
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43212",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-04-08",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBUS OH 43212",
      "city": "Columbus",
      "county": "Franklin",
      "state": "OH",
      "postal_code": "43212",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-04-08",
      "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": [
    "OH"
  ],
  "cities": [
    "Columbus"
  ],
  "postal_codes": [
    "43212"
  ],
  "top_markets": [
    {
      "city": "Columbus",
      "state": "OH",
      "postal_code": "43212",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 76000,
      "wage_high_max": 85000,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021
    }
  ]
}
Industry
{
  "naics_codes": [
    "33911",
    "33",
    "99"
  ],
  "naics_breakdown": [
    {
      "value": "33911",
      "filing_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 76000,
  "annualized_high_max": 85000,
  "annualized_low_avg": 77500
}
Trend
[
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 78000,
    "wage_high_max": 83200,
    "wage_low_avg": 78000
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 78000,
    "wage_high_max": 83200,
    "wage_low_avg": 78000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 78000,
    "wage_high_max": 83200,
    "wage_low_avg": 78000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 76000,
    "wage_high_max": 85000,
    "wage_low_avg": 76000
  }
]
Links
{
  "roles": "/v1/roles?company=Sparrow%20Robot%20LLC",
  "wages": "/v1/wages?company=Sparrow%20Robot%20LLC",
  "trends": "/v1/trends?company=Sparrow%20Robot%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=sparrow+robot+llc&limit=5JSON