Home / Companies / STELLENT SOLUTIONS INC

STELLENT SOLUTIONS 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.

Role rows Wage rows Trends

Employer	LCA filings	Role titles	Worksites	Coverage	USCIS approvals	Top role	Sources	Open
STELLENT SOLUTIONS INC STELLENT SOLUTIONS INC	158	12	64	FY2016 to FY2019 Latest decision 2019-07-05	82	PROGRAMMER ANALYST 103 filings	dol_oflc_lca, uscis_h1b_employer_data_hub	Profile

Activity summary

LCA filings	158
Certified LCAs	157
Denied LCAs	0
Role titles	12
Worksites	64
Latest decision	2019-07-05
USCIS approvals	82
USCIS denials	8

Aliases and source names

Aliases	Source Names	Sources
STELLENT SOLUTIONS INC	STELLENT SOLUTIONS INC	dol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

Title	SOC	LCA filings	Low wage min	High wage max
PROGRAMMER ANALYST	15-1132	103	$52,166	$0
SYSTEM ANALYST	15-1121	39	$52,520	$0
BUSINESS ANALYST	15-1121	4	$70,000	$0
PROGRAMMER ANALYST	15-1131	2	$52,520	$0
SOFTWARE DEVELOPER	15-1132	2	$100,000	$0
NETWORK ENGINEER	15-1142	1	$65,000	$0
ORACLE APPLICATION DEVELOPER	15-1132	1	$100,000	$0
ORACLE PL/SQL DEVELOPER	15-1132	1	$87,000	$0
QA ANALYST	15-1199	1	$60,000	$0
QA PERFORMANCE ENGINEER	15-1199	1	$70,000	$0

Top markets

City	State	Postal Code	LCA Count	Role Title Count	Wage Low Min	First Fiscal Year	Latest Fiscal Year
Westlake Village	CA	91362	10	3	65,000	2,016	2,017
Smithfield	RI	02917	10	1	65,000	2,016	2,017
New York	NY	10010	8	3	70,000	2,016	2,018
Redmond	WA	98052	8	1	67,642	2,016	2,017
Chicago	IL	60606	6	2	52,166	2,016	2,017
Phoenix	AZ	85029	5	1	60,000	2,016	2,017
Sunnyvale	CA	94089	5	1	75,000	2,017	2,017
Dallas	TX	75202	5	1	65,042	2,016	2,017
Enfield	CT	06082	4	2	65,000	2,016	2,017
Chicago	IL	60601	4	1	65,000	2,016	2,017

Full company payload

Company ID	company:stellent solutions
Name	STELLENT SOLUTIONS INC
Normalized Name	stellent solutions
Source Company Ids	company_dol_oflc_lca_stellent_solutions_inc, company_uscis_h1b_datahub_stellent_solutions_inc_tax_3022, company_uscis_h1b_datahub_stellent_solutions_inc_tax_0566
Source Names	STELLENT SOLUTIONS INC
Aliases	STELLENT SOLUTIONS INC
Sources	dol_oflc_lca, uscis_h1b_employer_data_hub

Names

{
  "source_names": [
    "STELLENT SOLUTIONS INC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "STELLENT SOLUTIONS INC",
      "filing_count": 158,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "STELLENT SOLUTIONS INC",
      "source": "uscis_h1b_employer_data_hub"
    },
    {
      "value": "STELLENT SOLUTIONS INC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}

Identifiers

[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "3022",
    "source": "uscis_h1b_employer_data_hub"
  },
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "0566",
    "source": "uscis_h1b_employer_data_hub"
  }
]

LCA Activity

{
  "lca_count": 158,
  "case_count": 158,
  "role_title_count": 12,
  "worksite_count": 64,
  "total_workers": 158,
  "first_fiscal_year": 2016,
  "first_received_date": "2015-09-25",
  "latest_fiscal_year": 2019,
  "latest_decision_date": "2019-07-05",
  "certified_count": 157,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 157,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "WITHDRAWN",
      "filing_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 158,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 87,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}

Petition Activity

{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 82,
  "total_denial": 8,
  "fiscal_years": [
    "2011",
    "2012",
    "2013",
    "2014",
    "2015",
    "2016",
    "2018",
    "2019",
    "2020"
  ],
  "year_metrics": [
    {
      "cities": [
        "Wayne"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "07470"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellent_solutions_inc_tax_3022_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_025637"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Wayne"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "07470"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 5,
      "initial_approval": 3,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellent_solutions_inc_tax_3022_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_024007"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Hoboken",
        "New York",
        "Wayne"
      ],
      "states": [
        "NJ",
        "NY"
      ],
      "fiscal_year": 2014,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "07030",
        "07470",
        "10069"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 17,
      "initial_approval": 14,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellent_solutions_inc_tax_3022_2014",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2014_row_023926",
        "sr_uscis_h1b_datahub_2014_row_023927",
        "sr_uscis_h1b_datahub_2014_row_023928"
      ],
      "continuing_approval": 3
    },
    {
      "cities": [
        "Hoboken",
        "Wayne"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2015,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "07030",
        "07470"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 27,
      "initial_approval": 20,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellent_solutions_inc_tax_3022_2015",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2015_row_019187",
        "sr_uscis_h1b_datahub_2015_row_019188"
      ],
      "continuing_approval": 7
    },
    {
      "cities": [
        "Hoboken",
        "Wayne"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2016,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "07030",
        "07470"
      ],
      "total_denial": 2,
      "initial_denial": 1,
      "total_approval": 21,
      "initial_approval": 9,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellent_solutions_inc_tax_3022_2016",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2016_row_019910",
        "sr_uscis_h1b_datahub_2016_row_019911"
      ],
      "continuing_approval": 12
    },
    {
      "cities": [
        "Hoboken"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2018,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "07030"
      ],
      "total_denial": 3,
      "initial_denial": 0,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 3,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellent_solutions_inc_tax_3022_2018",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2018_row_019147"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Hoboken"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "07030"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellent_solutions_inc_tax_3022_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_018955"
      ],
      "continuing_approval": 1
    },
    {
      "cities": [
        "Hoboken"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2020,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "07030"
      ],
      "total_denial": 1,
      "initial_denial": 0,
      "total_approval": 0,
      "initial_approval": 0,
      "continuing_denial": 1,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellent_solutions_inc_tax_3022_2020",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2020_row_045676"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Mt Laurel"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2011,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "08054"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 4,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellent_solutions_inc_tax_0566_2011",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2011_row_021807"
      ],
      "continuing_approval": 2
    },
    {
      "cities": [
        "Mount Laurel",
        "Mt Laurel"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2012,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "08054"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 2,
      "initial_approval": 2,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellent_solutions_inc_tax_0566_2012",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2012_row_018830",
        "sr_uscis_h1b_datahub_2012_row_018831"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Mount Laurel"
      ],
      "states": [
        "NJ"
      ],
      "fiscal_year": 2013,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "08054"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_stellent_solutions_inc_tax_0566_2013",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2013_row_017618"
      ],
      "continuing_approval": 0
    }
  ]
}

Addresses

{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "HOBOKEN NJ 7030",
      "city": "Hoboken",
      "state": "NJ",
      "postal_code": "7030",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-07-05",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "HOBOKEN NJ 07030",
      "city": "Hoboken",
      "state": "NJ",
      "postal_code": "07030",
      "filing_count": 157,
      "case_count": 157,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-06-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "SMITHFIELD RI 2917",
      "city": "Smithfield",
      "county": "Providence",
      "state": "RI",
      "postal_code": "2917",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2019,
      "latest_decision_date": "2019-07-05",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10010",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10010",
      "filing_count": 8,
      "case_count": 8,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-06-08",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLUMBIA SC 29201",
      "city": "Columbia",
      "county": "Richland",
      "state": "SC",
      "postal_code": "29201",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-06-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "PEAPACK NJ 07977",
      "city": "Peapack",
      "county": "Somerset",
      "state": "NJ",
      "postal_code": "07977",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-01-23",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SMITHFIELD RI 02917",
      "city": "Smithfield",
      "county": "Providence",
      "state": "RI",
      "postal_code": "02917",
      "filing_count": 10,
      "case_count": 10,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WESTLAKE VILLAGE CA 91362",
      "city": "Westlake Village",
      "county": "Ventura",
      "state": "CA",
      "postal_code": "91362",
      "filing_count": 9,
      "case_count": 9,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-04-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "REDMOND WA 98052",
      "city": "Redmond",
      "county": "King",
      "state": "WA",
      "postal_code": "98052",
      "filing_count": 8,
      "case_count": 8,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHICAGO IL 60606",
      "city": "Chicago",
      "county": "Cook",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 6,
      "case_count": 6,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DALLAS TX 75202",
      "city": "Dallas",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75202",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SUNNYVALE CA 94089",
      "city": "Sunnyvale",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "94089",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "PHOENIX AZ 85029",
      "city": "Phoenix",
      "county": "Maricopa",
      "state": "AZ",
      "postal_code": "85029",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHICAGO IL 60601",
      "city": "Chicago",
      "county": "Cook",
      "state": "IL",
      "postal_code": "60601",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DALLAS TX 75201",
      "city": "Dallas",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75201",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-20",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ENFIELD CT 06082",
      "city": "Enfield",
      "county": "Hartford",
      "state": "CT",
      "postal_code": "06082",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SPRINGFIELD MA 01111",
      "city": "Springfield",
      "county": "Hampden",
      "state": "MA",
      "postal_code": "01111",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CHARLOTTE NC 28202",
      "city": "Charlotte",
      "county": "Mecklenburg",
      "state": "NC",
      "postal_code": "28202",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-02-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CINCINNATI OH 45242",
      "city": "Cincinnati",
      "county": "Hamilton",
      "state": "OH",
      "postal_code": "45242",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-04-27",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WAUKESHA WI 53188",
      "city": "Waukesha",
      "county": "Waukesha",
      "state": "WI",
      "postal_code": "53188",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-16",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "WARREN NJ 07059",
      "city": "Warren",
      "county": "Somerset",
      "state": "NJ",
      "postal_code": "07059",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MIDDLETOWN NJ 07748",
      "city": "Middletown",
      "county": "Monmouth",
      "state": "NJ",
      "postal_code": "07748",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-02-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ANN ARBOR MI 48108",
      "city": "Ann Arbor",
      "county": "Washtenaw",
      "state": "MI",
      "postal_code": "48108",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-02-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DALLAS TX 75207",
      "city": "Dallas",
      "county": "Dallas",
      "state": "TX",
      "postal_code": "75207",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-06-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "CULVER CITY CA 90232",
      "city": "Culver City",
      "county": "Los Angeles",
      "state": "CA",
      "postal_code": "90232",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-04-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "COLLIERVILLE TN 38017",
      "city": "Collierville",
      "county": "Shelby",
      "state": "TN",
      "postal_code": "38017",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-13",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "VIRGINIA BEACH VA 23462",
      "city": "Virginia Beach",
      "county": "Virginia Beach City",
      "state": "VA",
      "postal_code": "23462",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "GEORGETOWN KY 40324",
      "city": "Georgetown",
      "county": "Scott",
      "state": "KY",
      "postal_code": "40324",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEWARK DE 19711",
      "city": "Newark",
      "county": "New Castle",
      "state": "DE",
      "postal_code": "19711",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ERLANGER KY 41018",
      "city": "Erlanger",
      "county": "Kenton",
      "state": "KY",
      "postal_code": "41018",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-02-24",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MOORESVILLE NC 28117",
      "city": "Mooresville",
      "county": "Iredell",
      "state": "NC",
      "postal_code": "28117",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-05-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "DEARBORN MI 48126",
      "city": "Dearborn",
      "county": "Wayne",
      "state": "MI",
      "postal_code": "48126",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10038",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10038",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SILVER SPRING MD 20904",
      "city": "Silver Spring",
      "county": "Montgomery",
      "state": "MD",
      "postal_code": "20904",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-03-10",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "REDMOND WI 98052",
      "city": "Redmond",
      "county": "King",
      "state": "WI",
      "postal_code": "98052",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2017-02-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BELLEVUE, WA 98004",
      "city": "Bellevue",
      "county": "King",
      "state": "WA",
      "postal_code": "98004",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-11-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ALBANY NY 12210",
      "city": "Albany",
      "county": "Albany",
      "state": "NY",
      "postal_code": "12210",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-10-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "KIRKLAND WA 98033",
      "city": "Kirkland",
      "county": "King",
      "state": "WA",
      "postal_code": "98033",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-10-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ALPHARETTA GA 30009",
      "city": "Alpharetta",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30009",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-10-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MT LAUREL NJ 08054",
      "city": "Mt Laurel",
      "county": "Burlington",
      "state": "NJ",
      "postal_code": "08054",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017,
      "latest_decision_date": "2016-10-11",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "QUINCY MA 02169",
      "city": "Quincy",
      "county": "Norfolk",
      "state": "MA",
      "postal_code": "02169",
      "filing_count": 4,
      "case_count": 4,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-04-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10019",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10019",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-03-01",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "BENTONVILLE AR 72712",
      "city": "Bentonville",
      "county": "Benton",
      "state": "AR",
      "postal_code": "72712",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-01-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "ALPHARETTA GA 30005",
      "city": "Alpharetta",
      "county": "Fulton",
      "state": "GA",
      "postal_code": "30005",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-04-14",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MADISON WI 53783",
      "city": "Madison",
      "county": "Dane",
      "state": "WI",
      "postal_code": "53783",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-04-04",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "FORT WORTH TX 76155",
      "city": "Fort Worth",
      "county": "Tarrant",
      "state": "TX",
      "postal_code": "76155",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2015-11-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "SANTA CLARA CA 95054",
      "city": "Santa Clara",
      "county": "Santa Clara",
      "state": "CA",
      "postal_code": "95054",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2015-10-30",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "LOS ANGELES CA 90067",
      "city": "Los Angeles",
      "county": "Los Angeles",
      "state": "CA",
      "postal_code": "90067",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-06-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "AUSTIN TX 78759",
      "city": "Austin",
      "county": "Travis",
      "state": "TX",
      "postal_code": "78759",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-06-03",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "LISLE IL 60532",
      "city": "Lisle",
      "county": "Dupage",
      "state": "IL",
      "postal_code": "60532",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-04-28",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "LONG BEACH CA 90802",
      "city": "Long Beach",
      "county": "Los Angles",
      "state": "CA",
      "postal_code": "90802",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-04-25",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "MOON TOWNSHIP PA 15108",
      "city": "Moon Township",
      "county": "Allegheny",
      "state": "PA",
      "postal_code": "15108",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2016,
      "latest_decision_date": "2016-04-22",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 2,
    "worksite_address_count": 50,
    "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",
    "RI",
    "NY",
    "WA",
    "IL",
    "AZ",
    "TX",
    "CT",
    "MA",
    "NC",
    "AR",
    "MI",
    "NJ",
    "OH",
    "VA",
    "WI",
    "DE",
    "GA",
    "KY",
    "TN",
    "LA",
    "MD",
    "MN",
    "PA",
    "SC"
  ],
  "cities": [
    "Westlake Village",
    "Smithfield",
    "New York",
    "Redmond",
    "Chicago",
    "Phoenix",
    "Sunnyvale",
    "Dallas",
    "Enfield",
    "Quincy",
    "Springfield",
    "Charlotte",
    "Bentonville",
    "Ann Arbor",
    "Middletown",
    "Warren",
    "Cincinnati",
    "Virginia Beach",
    "Waukesha",
    "Culver City",
    "Santa Clara",
    "Newark",
    "Alpharetta",
    "Erlanger",
    "Georgetown",
    "Collierville",
    "Fort Worth",
    "Madison",
    "Long Beach",
    "Los Angeles",
    "Deerfield",
    "Lisle",
    "Naperville",
    "Lafayette",
    "Silver Spring",
    "Dearborn",
    "Eagan",
    "Eden Prairie",
    "Richfield",
    "Mooresville",
    "Mt Laurel",
    "Peapack",
    "Albany",
    "Newyork",
    "Moon Township",
    "Columbia",
    "Austin",
    "Houston",
    "Irving",
    "Richardson",
    "Bellevue",
    "Kirkland",
    "Hoboken",
    "Wayne",
    "Mount Laurel"
  ],
  "postal_codes": [
    "91362",
    "02917",
    "10010",
    "98052",
    "60606",
    "85029",
    "94089",
    "75202",
    "06082",
    "60601",
    "02169",
    "01111",
    "28202",
    "75201",
    "72712",
    "48108",
    "07748",
    "07059",
    "10019",
    "45242",
    "23462",
    "53188",
    "90232",
    "95054",
    "19711",
    "30005",
    "41018",
    "40324",
    "38017",
    "75207",
    "76155",
    "53783",
    "90802",
    "90067",
    "30009",
    "60015",
    "60532",
    "60563",
    "70501",
    "20904",
    "48126",
    "55123",
    "55344",
    "55423",
    "28262",
    "28117",
    "08054",
    "07977",
    "12210",
    "10038",
    "15108",
    "2917",
    "29201",
    "78759",
    "77067",
    "75038",
    "75081",
    "98004",
    "98033",
    "53703",
    "07030",
    "07470",
    "10069"
  ],
  "top_markets": [
    {
      "city": "Westlake Village",
      "state": "CA",
      "postal_code": "91362",
      "lca_count": 10,
      "role_title_count": 3,
      "wage_low_min": 65000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Smithfield",
      "state": "RI",
      "postal_code": "02917",
      "lca_count": 10,
      "role_title_count": 1,
      "wage_low_min": 65000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10010",
      "lca_count": 8,
      "role_title_count": 3,
      "wage_low_min": 70000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2018
    },
    {
      "city": "Redmond",
      "state": "WA",
      "postal_code": "98052",
      "lca_count": 8,
      "role_title_count": 1,
      "wage_low_min": 67642,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "lca_count": 6,
      "role_title_count": 2,
      "wage_low_min": 52166,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Phoenix",
      "state": "AZ",
      "postal_code": "85029",
      "lca_count": 5,
      "role_title_count": 1,
      "wage_low_min": 60000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Sunnyvale",
      "state": "CA",
      "postal_code": "94089",
      "lca_count": 5,
      "role_title_count": 1,
      "wage_low_min": 75000,
      "wage_high_max": 0,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Dallas",
      "state": "TX",
      "postal_code": "75202",
      "lca_count": 5,
      "role_title_count": 1,
      "wage_low_min": 65042,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Enfield",
      "state": "CT",
      "postal_code": "06082",
      "lca_count": 4,
      "role_title_count": 2,
      "wage_low_min": 65000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    },
    {
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60601",
      "lca_count": 4,
      "role_title_count": 1,
      "wage_low_min": 65000,
      "wage_high_max": 0,
      "first_fiscal_year": 2016,
      "latest_fiscal_year": 2017
    }
  ]
}

Industry

{
  "naics_codes": [
    "541511",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541511",
      "filing_count": 87,
      "first_fiscal_year": 2017,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    }
  ]
}

Wage Summary

{
  "annualized_low_min": 52166,
  "annualized_high_max": 80000,
  "annualized_low_avg": 67611.1582278481
}

Trend

[
  {
    "fiscal_year": 2016,
    "quarter": "Q2",
    "lca_count": 71,
    "case_count": 71,
    "role_title_count": 4,
    "worksite_count": 44,
    "wage_low_min": 52520,
    "wage_high_max": 0,
    "wage_low_avg": 66668.6056338028
  },
  {
    "fiscal_year": 2017,
    "quarter": "Q2",
    "lca_count": 83,
    "case_count": 83,
    "role_title_count": 6,
    "worksite_count": 35,
    "wage_low_min": 52166,
    "wage_high_max": 0,
    "wage_low_avg": 67555.3253012048
  },
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 3,
    "worksite_count": 3,
    "wage_low_min": 75000,
    "wage_high_max": 0,
    "wage_low_avg": 87333.3333333333
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 80000,
    "wage_high_max": 80000,
    "wage_low_avg": 80000
  }
]

Links

{
  "roles": "/v1/roles?company=STELLENT%20SOLUTIONS%20INC",
  "wages": "/v1/wages?company=STELLENT%20SOLUTIONS%20INC",
  "trends": "/v1/trends?company=STELLENT%20SOLUTIONS%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=stellent+solutions+inc&limit=5JSON

Docs · Get an API key