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

Home / Companies / GIANT SPOON LLC

GIANT SPOON 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
GIANT SPOON LLC
GIANT SPOON LLC
753FY2017 to FY2021
Latest decision 2021-08-04
1SENIOR STRATEGIST
3 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings7
Certified LCAs6
Denied LCAs1
Role titles5
Worksites3
Latest decision2021-08-04
USCIS approvals1
USCIS denials0

Aliases and source names

AliasesSource NamesSources
GIANT SPOON LLCGIANT SPOON LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SENIOR STRATEGIST11-2011
ADVERTISING AND PROMOTIONS MANAGERS
3$100,000$105,019
ART DIRECTOR27-1011.00
Art Directors
1$85,000$85,000
Associate Strategy Director11-2011.00
Advertising and Promotions Managers
1$138,000$145,000
PUBLIC RELATIONS SPECIALIST27-30311$47,500$0
VP, ACCOUNT MANAGEMENT11-20111$200,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
New YorkNY1000331100,000105,0192,0172,019
New YorkNY100052285,000145,0002,0202,021
New YorkNY100132247,50002,0182,018

Full company payload

Company IDcompany:giant spoon
NameGIANT SPOON LLC
Normalized Namegiant spoon
Source Company Idscompany_dol_oflc_lca_giant_spoon_llc, company_uscis_h1b_datahub_giant_spoon_llc_tax_5288
Source NamesGIANT SPOON LLC
AliasesGIANT SPOON LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "GIANT SPOON LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "GIANT SPOON LLC",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Giant Spoon LLC",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "GIANT SPOON, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    },
    {
      "value": "GIANT SPOON LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "5288",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 7,
  "case_count": 7,
  "role_title_count": 5,
  "worksite_count": 3,
  "total_workers": 7,
  "first_fiscal_year": 2017,
  "first_received_date": "2017-04-28",
  "latest_fiscal_year": 2021,
  "latest_decision_date": "2021-08-04",
  "certified_count": 6,
  "denied_count": 1,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 4,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "DENIED",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "E-3 Australian",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "H-1B",
      "filing_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 7,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 1,
  "total_denial": 0,
  "fiscal_years": [
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "New York"
      ],
      "states": [
        "NY"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "10005"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_giant_spoon_llc_tax_5288_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_021628"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10005",
      "city": "New York",
      "state": "NY",
      "postal_code": "10005",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-08-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10013",
      "city": "New York",
      "state": "NY",
      "postal_code": "10013",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-02-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "NEW YORK NY 10003",
      "city": "New York",
      "state": "NY",
      "postal_code": "10003",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-05-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10005",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10005",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-08-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10003",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10003",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-02-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10013",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10013",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-15",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "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": [
    "NY"
  ],
  "cities": [
    "New York"
  ],
  "postal_codes": [
    "10003",
    "10005",
    "10013"
  ],
  "top_markets": [
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10003",
      "lca_count": 3,
      "role_title_count": 1,
      "wage_low_min": 100000,
      "wage_high_max": 105019,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10005",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 85000,
      "wage_high_max": 145000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10013",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 47500,
      "wage_high_max": 0,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018
    }
  ]
}
Industry
{
  "naics_codes": [
    "541810",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541810",
      "filing_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541613",
      "filing_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "54181",
      "filing_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 47500,
  "annualized_high_max": 145000,
  "annualized_low_avg": 111505.428571429
}
Trend
[
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 100000,
    "wage_high_max": 0,
    "wage_low_avg": 102509.5
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 47500,
    "wage_high_max": 0,
    "wage_low_avg": 123750
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 105019,
    "wage_high_max": 105019,
    "wage_low_avg": 105019
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q1",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 138000,
    "wage_high_max": 145000,
    "wage_low_avg": 138000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 85000,
    "wage_high_max": 85000,
    "wage_low_avg": 85000
  }
]
Links
{
  "roles": "/v1/roles?company=GIANT%20SPOON%20LLC",
  "wages": "/v1/wages?company=GIANT%20SPOON%20LLC",
  "trends": "/v1/trends?company=GIANT%20SPOON%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=giant+spoon+llc&limit=5JSON