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

Home / Companies / SPARKYPANTS STUDIOS, LLC

SPARKYPANTS STUDIOS, LLC H-1B company data

Summary

SPARKYPANTS STUDIOS, LLC filed 3 H-1B labor condition applications (LCAs) with the U.S. Department of Labor between FY2016-FY2017.

Of those, 3 were certified (a 100% certification rate among adjudicated filings).

The filings span 2 distinct role titles across 1 worksites.

The most-sponsored role was Artist (1 filings), with offered wages from $43,451 to $56,971.

Separately, USCIS H-1B Employer Data Hub records show 2 approved and 0 denied H-1B petitions for this employer.

LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
SPARKYPANTS STUDIOS, LLC
SPARKYPANTS STUDIOS LLC
321FY2016 to FY2017
Latest decision 2017-07-25
2ARTIST
1 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings3
Certified LCAs3
Denied LCAs0
Role titles2
Worksites1
Latest decision2017-07-25
USCIS approvals2
USCIS denials0

Aliases and source names

AliasesSource NamesSources
SPARKYPANTS STUDIOS LLCSPARKYPANTS STUDIOS, LLC, SPARKYPANTS STUDIOS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
ARTIST27-10141$43,451$56,971
ARTIST27-10241$45,906$55,682
LEAD BACKEND PROGRAMMER15-11321$160,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
BaltimoreMD212023243,45156,9712,0162,017

Full company payload

Company IDcompany:sparkypants studios
NameSPARKYPANTS STUDIOS, LLC
Normalized Namesparkypants studios
Source Company Idscompany_dol_oflc_lca_sparkypants_studios_llc, company_uscis_h1b_datahub_sparkypants_studios_llc_tax_3197
Source NamesSPARKYPANTS STUDIOS, LLC, SPARKYPANTS STUDIOS LLC
AliasesSPARKYPANTS STUDIOS LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "SPARKYPANTS STUDIOS, LLC",
    "SPARKYPANTS STUDIOS LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "SPARKYPANTS STUDIOS LLC",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SPARKYPANTS STUDIOS, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "SPARKYPANTS STUDIOS LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "3197",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 3,
  "case_count": 3,
  "role_title_count": 2,
  "worksite_count": 1,
  "total_workers": 3,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-12-02",
  "latest_fiscal_year": 2017,
  "latest_decision_date": "2017-07-25",
  "certified_count": 3,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED-WITHDRAWN",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    },
    {
      "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": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 2,
  "total_denial": 0,
  "fiscal_years": [
    "2012",
    "2016"
  ],
  "year_metrics": [
    {
      "cities": [
        "Baltimore"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "21209"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sparkypants_studios_llc_tax_3197_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_026129"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Baltimore"
      ],
      "states": [
        "MD"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "21202"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_sparkypants_studios_llc_tax_3197_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_020408"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "BALTIMORE MD 21202",
      "city": "Baltimore",
      "state": "MD",
      "postal_code": "21202",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-07-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "BALTIMORE MD 21202",
      "city": "Baltimore",
      "county": "Baltimore City",
      "state": "MD",
      "postal_code": "21202",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-07-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BALTIMORE MD 21202",
      "city": "Baltimore",
      "county": "Baltimore",
      "state": "MD",
      "postal_code": "21202",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-06-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 1,
    "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": [
    "MD"
  ],
  "cities": [
    "Baltimore"
  ],
  "postal_codes": [
    "21202",
    "21209"
  ],
  "top_markets": [
    {
      "city": "Baltimore",
      "state": "MD",
      "postal_code": "21202",
      "lca_count": 3,
      "role_title_count": 2,
      "wage_low_min": 43451,
      "wage_high_max": 56971,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    }
  ]
}
Industry
{
  "naics_codes": [
    "541519",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541519",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 43451,
  "annualized_high_max": 56971,
  "annualized_low_avg": 83119
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 45906,
    "wage_high_max": 55682,
    "wage_low_avg": 102953
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 43451,
    "wage_high_max": 56971,
    "wage_low_avg": 43451
  }
]
Links
{
  "roles": "/v1/roles?company=SPARKYPANTS%20STUDIOS%2C%20LLC",
  "wages": "/v1/wages?company=SPARKYPANTS%20STUDIOS%2C%20LLC",
  "trends": "/v1/trends?company=SPARKYPANTS%20STUDIOS%2C%20LLC"
}

Frequently asked questions

Does SPARKYPANTS STUDIOS, LLC sponsor H-1B visas?
Yes. SPARKYPANTS STUDIOS, LLC filed 3 H-1B labor condition applications with the U.S. Department of Labor (FY2016-FY2017), of which 3 were certified. LCA filings are labor-condition applications certified by the U.S. Department of Labor, not active job postings or approved USCIS H-1B petitions.
How many H-1B applications has SPARKYPANTS STUDIOS, LLC filed?
SPARKYPANTS STUDIOS, LLC has 3 H-1B LCA filings on record spanning FY2016-FY2017 across 2 role titles and 1 worksites.
What roles does SPARKYPANTS STUDIOS, LLC sponsor for H-1B?
The most common H-1B role at SPARKYPANTS STUDIOS, LLC is Artist (1 filings). Other frequent roles include Lead Backend Programmer.
What wages does SPARKYPANTS STUDIOS, LLC offer H-1B workers?
For its most-sponsored role (Artist), SPARKYPANTS STUDIOS, LLC reported offered wages ranging from $43,451 to $56,971 in DOL LCA filings.
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=sparkypants+studios+llc&limit=5JSON