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

Home / Companies / Once Upon a Farm LLC

Once Upon a Farm 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
Once Upon a Farm LLC111FY2022 to FY2022
Latest decision 2022-04-12
0Senior Analyst, DTC & Ecommerce Growth
1 filings
dol_oflc_lcaProfile

Activity summary

LCA filings1
Certified LCAs1
Denied LCAs0
Role titles1
Worksites1
Latest decision2022-04-12
USCIS approvals0
USCIS denials0

Aliases and source names

AliasesSource NamesSources
-Once Upon a Farm LLCdol_oflc_lca

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
Senior Analyst, DTC & Ecommerce Growth15-1199.08
Business Intelligence Analysts
1$75,000$105,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
Kew GardensNY114151175,000105,0002,0222,022

Full company payload

Company IDcompany:once upon a farm
NameOnce Upon a Farm LLC
Normalized Nameonce upon a farm
Source Company Idscompany_dol_oflc_lca_once_upon_a_farm_llc
Source NamesOnce Upon a Farm LLC
Aliases-
Identifiers-
Sourcesdol_oflc_lca
Names
{
  "source_names": [
    "Once Upon a Farm LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "Once Upon a Farm LLC",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}
LCA Activity
{
  "lca_count": 1,
  "case_count": 1,
  "role_title_count": 1,
  "worksite_count": 1,
  "total_workers": 1,
  "first_fiscal_year": 2022,
  "first_received_date": "2022-04-05",
  "latest_fiscal_year": 2022,
  "latest_decision_date": "2022-04-12",
  "certified_count": 1,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "Certified",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "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": "BERKELEY CA 94710",
      "city": "Berkeley",
      "state": "CA",
      "postal_code": "94710",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-04-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "KEW GARDENS NY 11415",
      "city": "Kew Gardens",
      "county": "Queens",
      "state": "NY",
      "postal_code": "11415",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "latest_decision_date": "2022-04-12",
      "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": [
    "NY"
  ],
  "cities": [
    "Kew Gardens"
  ],
  "postal_codes": [
    "11415"
  ],
  "top_markets": [
    {
      "city": "Kew Gardens",
      "state": "NY",
      "postal_code": "11415",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 75000,
      "wage_high_max": 105000,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022
    }
  ]
}
Industry
{
  "naics_codes": [
    "311991"
  ],
  "naics_breakdown": [
    {
      "value": "311991",
      "filing_count": 1,
      "first_fiscal_year": 2022,
      "latest_fiscal_year": 2022,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 75000,
  "annualized_high_max": 105000,
  "annualized_low_avg": 75000
}
Trend
[
  {
    "fiscal_year": 2022,
    "quarter": "Q3",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 75000,
    "wage_high_max": 105000,
    "wage_low_avg": 75000
  }
]
Links
{
  "roles": "/v1/roles?company=Once%20Upon%20a%20Farm%20LLC",
  "wages": "/v1/wages?company=Once%20Upon%20a%20Farm%20LLC",
  "trends": "/v1/trends?company=Once%20Upon%20a%20Farm%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=once+upon+a+farm+llc&limit=5JSON