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

Home / Companies / CELLARSTONE, INC.

CELLARSTONE, INC. 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
CELLARSTONE, INC.
CELLARSTONE INC
422FY2016 to FY2019
Latest decision 2019-04-24
5SOFTWARE ENGINEER
3 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings4
Certified LCAs4
Denied LCAs0
Role titles2
Worksites2
Latest decision2019-04-24
USCIS approvals5
USCIS denials0

Aliases and source names

AliasesSource NamesSources
CELLARSTONE INCCELLARSTONE, INC., CELLARSTONE INCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
SOFTWARE ENGINEER15-1132
SOFTWARE DEVELOPERS, APPLICATIONS
3$120,000$132,000
COMPUTER PROGRAMMER15-11311$67,000$0

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
Half Moon BayCA9401921132,000132,0002,0192,019
San MateoCA944022267,00002,0162,016

Full company payload

Company IDcompany:cellarstone
NameCELLARSTONE, INC.
Normalized Namecellarstone
Source Company Idscompany_dol_oflc_lca_cellarstone_inc, company_uscis_h1b_datahub_cellarstone_inc_tax_9852
Source NamesCELLARSTONE, INC., CELLARSTONE INC
AliasesCELLARSTONE INC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "CELLARSTONE, INC.",
    "CELLARSTONE INC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "CELLARSTONE, INC.",
      "filing_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "source": "dol_oflc_lca"
    },
    {
      "value": "CELLARSTONE INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "9852",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 4,
  "case_count": 4,
  "role_title_count": 2,
  "worksite_count": 2,
  "total_workers": 4,
  "first_fiscal_year": 2016,
  "first_received_date": "2016-03-11",
  "latest_fiscal_year": 2019,
  "latest_decision_date": "2019-04-24",
  "certified_count": 4,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 5,
  "total_denial": 0,
  "fiscal_years": [
    "2011",
    "2013",
    "2014",
    "2017",
    "2019"
  ],
  "year_metrics": [
    {
      "cities": [
        "San Mateo"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94402"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_cellarstone_inc_tax_9852_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_059611"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "San Mateo"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94402"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_cellarstone_inc_tax_9852_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_053390"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "San Mateo"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94402"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_cellarstone_inc_tax_9852_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_054291"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "San Mateo"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2017,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94402"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_cellarstone_inc_tax_9852_2017",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2017_row_048042"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Half Moon Bay"
      ],
      "states": [
        "CA"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "94019"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_cellarstone_inc_tax_9852_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_057574"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "HALF MOON BAY CA 94019",
      "city": "Half Moon Bay",
      "state": "CA",
      "postal_code": "94019",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-04-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "SAN MATEO CA 94402",
      "city": "San Mateo",
      "state": "CA",
      "postal_code": "94402",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-05-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "HALF MOON BAY CA 94019",
      "city": "Half Moon Bay",
      "county": "San Mateo",
      "state": "CA",
      "postal_code": "94019",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-04-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SAN MATEO CA 94402",
      "city": "San Mateo",
      "county": "San Mateo",
      "state": "CA",
      "postal_code": "94402",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-05-12",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "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": [
    "CA"
  ],
  "cities": [
    "Half Moon Bay",
    "San Mateo"
  ],
  "postal_codes": [
    "94019",
    "94402"
  ],
  "top_markets": [
    {
      "city": "Half Moon Bay",
      "state": "CA",
      "postal_code": "94019",
      "lca_count": 2,
      "role_title_count": 1,
      "wage_low_min": 132000,
      "wage_high_max": 132000,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019
    },
    {
      "city": "San Mateo",
      "state": "CA",
      "postal_code": "94402",
      "lca_count": 2,
      "role_title_count": 2,
      "wage_low_min": 67000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016
    }
  ]
}
Industry
{
  "naics_codes": [
    "541511",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 67000,
  "annualized_high_max": 132000,
  "annualized_low_avg": 112750
}
Trend
[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 2,
    "worksite_count": 1,
    "wage_low_min": 67000,
    "wage_high_max": 0,
    "wage_low_avg": 93500
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 2,
    "case_count": 2,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 132000,
    "wage_high_max": 132000,
    "wage_low_avg": 132000
  }
]
Links
{
  "roles": "/v1/roles?company=CELLARSTONE%2C%20INC.",
  "wages": "/v1/wages?company=CELLARSTONE%2C%20INC.",
  "trends": "/v1/trends?company=CELLARSTONE%2C%20INC."
}
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=cellarstone+inc&limit=5JSON