Home / Companies / STONEBRIDGE CONSULTING GROUP LLC
STONEBRIDGE CONSULTING GROUP 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.
| Employer | LCA filings | Role titles | Worksites | Coverage | USCIS approvals | Top role | Sources | Open |
|---|---|---|---|---|---|---|---|---|
| STONEBRIDGE CONSULTING GROUP LLC BLACKCOMB CONSULTANTS, Blackcomb Consultancy, Blackcomb Consultants | 235 | 31 | 59 | FY2016 to FY2023 Latest decision 2023-02-24 | 71 | SENIOR GUIDEWIRE DEVELOPER 38 filings | dol_oflc_lca, uscis_h1b_employer_data_hub | Profile |
| STONEBRIDGE CONSULTING GROUP LLC D STONEBRIDGE CONSULTING GROUP LLC D | 0 | - | - | FY- to FY- Latest decision - | 7 | - | uscis_h1b_employer_data_hub | Profile |
Activity summary
| LCA filings | 235 |
| Certified LCAs | 211 |
| Denied LCAs | 2 |
| Role titles | 31 |
| Worksites | 59 |
| Latest decision | 2023-02-24 |
| USCIS approvals | 71 |
| USCIS denials | 6 |
Aliases and source names
| Aliases | Source Names | Sources |
|---|---|---|
| BLACKCOMB CONSULTANTS, Blackcomb Consultancy, Blackcomb Consultants, BLACKCOMB CONSULTANTS LLC, STONEBRIDGE CONSULTING GROUP LLC | STONEBRIDGE CONSULTING GROUP LLC | dol_oflc_lca, uscis_h1b_employer_data_hub |
Top roles
| Title | SOC | LCA filings | Low wage min | High wage max |
|---|---|---|---|---|
| SENIOR GUIDEWIRE DEVELOPER | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 38 | $85,000 | $110,000 |
| GUIDEWIRE DEVELOPER | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 30 | $65,000 | $98,000 |
| Senior Guidewire Developer | 15-1132.00 Software Developers, Applications | 21 | $98,000 | $170,000 |
| Guidewire Developer | 15-1132.00 Software Developers, Applications | 14 | $95,000 | $105,000 |
| BUSINESS ANALYST | 15-1121 | 10 | $64,150 | $0 |
| QUALITY ASSURANCE ANALYST | 15-1199 | 8 | $65,000 | $0 |
| SENIOR SOFTWARE ENGINEER | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 8 | $85,000 | $105,000 |
| Guidewire Technical Lead | 15-1132.00 Software Developers, Applications | 7 | $110,000 | $127,300 |
| SOFTWARE ENGINEER | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 7 | $68,640 | $94,000 |
| Lead Quality Assurance Analyst | 15-1199.01 Software Quality Assurance Engineers and Testers | 6 | $100,000 | $150,000 |
Top markets
| City | State | Postal Code | LCA Count | Role Title Count | Wage Low Min | Wage High Max | First Fiscal Year | Latest Fiscal Year |
|---|---|---|---|---|---|---|---|---|
| Plano | TX | 75075 | 47 | 8 | 92,000 | 127,300 | 2,018 | 2,021 |
| Marietta | PA | 17547 | 23 | 11 | 75,000 | 140,000 | 2,018 | 2,022 |
| Austin | TX | 78723 | 14 | 2 | 105,000 | 110,000 | 2,017 | 2,022 |
| Montgomery | AL | 36116 | 9 | 4 | 75,000 | 98,000 | 2,017 | 2,022 |
| Warren | NJ | 07059 | 9 | 8 | 64,150 | 0 | 2,017 | 2,018 |
| Madison | WI | 53783 | 9 | 4 | 86,000 | 95,000 | 2,016 | 2,019 |
| Lake Mary | FL | 32746 | 8 | 3 | 65,000 | 0 | 2,017 | 2,017 |
| Columbus | OH | 43215 | 8 | 3 | 80,000 | 100,000 | 2,017 | 2,019 |
| Frisco | TX | 75035 | 6 | 2 | 95,000 | 140,000 | 2,021 | 2,022 |
| Sacramento | CA | 95833 | 5 | 1 | 87,500 | 94,000 | 2,021 | 2,021 |
Full company payload
| Company ID | company:stonebridge consulting group |
| Name | STONEBRIDGE CONSULTING GROUP LLC |
| Normalized Name | stonebridge consulting group |
| Source Company Ids | company_dol_oflc_lca_stonebridge_consulting_group_llc, company_uscis_h1b_datahub_stonebridge_consulting_group_llc_tax_3954 |
| Source Names | STONEBRIDGE CONSULTING GROUP LLC |
| Aliases | BLACKCOMB CONSULTANTS, Blackcomb Consultancy, Blackcomb Consultants, BLACKCOMB CONSULTANTS LLC, STONEBRIDGE CONSULTING GROUP LLC |
| Sources | dol_oflc_lca, uscis_h1b_employer_data_hub |
Names
{
"source_names": [
"STONEBRIDGE CONSULTING GROUP LLC"
],
"dba_names": [
"BLACKCOMB CONSULTANTS",
"Blackcomb Consultancy",
"Blackcomb Consultants",
"BLACKCOMB CONSULTANTS LLC"
],
"name_variants": [
{
"value": "BLACKCOMB CONSULTANTS",
"filing_count": 100,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "Blackcomb Consultancy",
"filing_count": 70,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2022,
"source": "dol_oflc_lca"
},
{
"value": "STONEBRIDGE CONSULTING GROUP LLC",
"filing_count": 43,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "Blackcomb Consultants",
"filing_count": 14,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2023,
"source": "dol_oflc_lca"
},
{
"value": "STONEBRIDGE CONSULTING GROUP, LLC",
"filing_count": 8,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
},
{
"value": "STONEBRIDGE CONSULTING GROUP LLC",
"source": "uscis_h1b_employer_data_hub"
}
]
}Identifiers
[
{
"identifier_type": "tax_id_last_four",
"identifier_value": "3954",
"source": "uscis_h1b_employer_data_hub"
}
]LCA Activity
{
"lca_count": 235,
"case_count": 235,
"role_title_count": 31,
"worksite_count": 59,
"total_workers": 235,
"first_fiscal_year": 2016,
"first_received_date": "2016-05-12",
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-02-24",
"certified_count": 211,
"denied_count": 2,
"status_breakdown": [
{
"value": "CERTIFIED",
"filing_count": 119,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "Certified",
"filing_count": 71,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2023,
"source": "dol_oflc_lca"
},
{
"value": "WITHDRAWN",
"filing_count": 19,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "CERTIFIED-WITHDRAWN",
"filing_count": 11,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "Certified - Withdrawn",
"filing_count": 10,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2022,
"source": "dol_oflc_lca"
},
{
"value": "Withdrawn",
"filing_count": 3,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2023,
"source": "dol_oflc_lca"
},
{
"value": "DENIED",
"filing_count": 2,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
}
],
"visa_class_breakdown": [
{
"value": "H-1B",
"filing_count": 227,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2023,
"source": "dol_oflc_lca"
},
{
"value": "E-3 Australian",
"filing_count": 8,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2021,
"source": "dol_oflc_lca"
}
],
"full_time_position_breakdown": [
{
"value": "Y",
"filing_count": 228,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2023,
"source": "dol_oflc_lca"
}
]
}Petition Activity
{
"initial_approval": 0,
"initial_denial": 0,
"continuing_approval": 0,
"continuing_denial": 0,
"total_approval": 71,
"total_denial": 6,
"fiscal_years": [
"2019",
"2020",
"2021",
"2022",
"2023"
],
"year_metrics": [
{
"cities": [
"Lisle",
"Warrenville"
],
"states": [
"IL"
],
"fiscal_year": 2019,
"naics_codes": [
"54"
],
"postal_codes": [
"60532",
"60555"
],
"total_denial": 5,
"initial_denial": 0,
"total_approval": 21,
"initial_approval": 4,
"continuing_denial": 5,
"petition_count_id": "petition_count_uscis_h1b_archive_stonebridge_consulting_group_llc_tax_3954_2019",
"source_record_ids": [
"sr_uscis_h1b_datahub_2019_row_027118",
"sr_uscis_h1b_datahub_2019_row_027119"
],
"continuing_approval": 17
},
{
"cities": [
"Warrenville"
],
"states": [
"IL"
],
"fiscal_year": 2020,
"naics_codes": [
"54"
],
"postal_codes": [
"60555"
],
"total_denial": 1,
"initial_denial": 0,
"total_approval": 25,
"initial_approval": 4,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_stonebridge_consulting_group_llc_tax_3954_2020",
"source_record_ids": [
"sr_uscis_h1b_datahub_2020_row_045823"
],
"continuing_approval": 21
},
{
"cities": [
"Warrenville"
],
"states": [
"IL"
],
"fiscal_year": 2021,
"naics_codes": [
"54"
],
"postal_codes": [
"60555"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 12,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_stonebridge_consulting_group_llc_tax_3954_2021",
"source_record_ids": [
"sr_uscis_h1b_datahub_2021_row_049973"
],
"continuing_approval": 12
},
{
"cities": [
"Warrenville"
],
"states": [
"IL"
],
"fiscal_year": 2022,
"naics_codes": [
"54"
],
"postal_codes": [
"60555"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 10,
"initial_approval": 2,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_stonebridge_consulting_group_llc_tax_3954_2022",
"source_record_ids": [
"sr_uscis_h1b_datahub_2022_row_049560"
],
"continuing_approval": 8
},
{
"cities": [
"Warrenville"
],
"states": [
"IL"
],
"fiscal_year": 2023,
"naics_codes": [
"54"
],
"postal_codes": [
"60555"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 3,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_stonebridge_consulting_group_llc_tax_3954_2023",
"source_record_ids": [
"sr_uscis_h1b_datahub_2023_row_027307",
"sr_uscis_h1b_datahub_2023_row_027308"
],
"continuing_approval": 3
}
]
}Addresses
{
"office_addresses": [
{
"address_kind": "office",
"raw_address": "WARRENVILLE IL 60555",
"city": "Warrenville",
"state": "IL",
"postal_code": "60555",
"filing_count": 192,
"case_count": 192,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-02-24",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "NAPERVILLE IL 60540",
"city": "Naperville",
"state": "IL",
"postal_code": "60540",
"filing_count": 43,
"case_count": 43,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-08-20",
"source_ids": [
"dol_oflc_lca"
]
}
],
"worksite_addresses": [
{
"address_kind": "worksite",
"raw_address": "THE WOODLANDS TX 77380",
"city": "The Woodlands",
"county": "Montgomery",
"state": "TX",
"postal_code": "77380",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2022-11-15",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PROSPER TX 75078",
"city": "Prosper",
"county": "Collin",
"state": "TX",
"postal_code": "75078",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-02-24",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PROSPER TX 75058",
"city": "Prosper",
"county": "Grayson",
"state": "TX",
"postal_code": "75058",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2023,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-02-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MARIETTA PA 17547",
"city": "Marietta",
"county": "Lancaster",
"state": "PA",
"postal_code": "17547",
"filing_count": 23,
"case_count": 23,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-04-22",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "AUSTIN TX 78723",
"city": "Austin",
"county": "Travis",
"state": "TX",
"postal_code": "78723",
"filing_count": 12,
"case_count": 12,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2022,
"latest_decision_date": "2021-10-28",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MONTGOMERY AL 36116",
"city": "Montgomery",
"county": "Montgomery",
"state": "AL",
"postal_code": "36116",
"filing_count": 9,
"case_count": 9,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-05-09",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "FRISCO TX 75035",
"city": "Frisco",
"county": "Collin",
"state": "TX",
"postal_code": "75035",
"filing_count": 6,
"case_count": 6,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-09-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "IRVING TX 75063",
"city": "Irving",
"county": "Dallas",
"state": "TX",
"postal_code": "75063",
"filing_count": 5,
"case_count": 5,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-05-16",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "RIVERVIEW FL 33578",
"city": "Riverview",
"county": "Hillsborough",
"state": "FL",
"postal_code": "33578",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-07-28",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WARREN NJ 7059",
"city": "Warren",
"county": "Somerset",
"state": "NJ",
"postal_code": "7059",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-07-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SAINT AUGUSTINE FL 32095",
"city": "Saint Augustine",
"county": "St Johns",
"state": "FL",
"postal_code": "32095",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2022,
"latest_decision_date": "2021-11-09",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BERKELEY HEIGHTS NJ 7922",
"city": "Berkeley Heights",
"county": "Union",
"state": "NJ",
"postal_code": "7922",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2022,
"latest_decision_date": "2021-11-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CONCORD NC 28027",
"city": "Concord",
"county": "Cabarrus",
"state": "NC",
"postal_code": "28027",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-06-06",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MONTEREY CA 93940",
"city": "Monterey",
"county": "Monterey",
"state": "CA",
"postal_code": "93940",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-03-01",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PLANO TX 75024",
"city": "Plano",
"county": "Collin",
"state": "TX",
"postal_code": "75024",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2021-11-16",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PLANO TX 75075",
"city": "Plano",
"county": "Collin",
"state": "TX",
"postal_code": "75075",
"filing_count": 47,
"case_count": 47,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-09-17",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SACRAMENTO CA 95833",
"city": "Sacramento",
"county": "Sacramento",
"state": "CA",
"postal_code": "95833",
"filing_count": 5,
"case_count": 5,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-06-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NEW HAVEN CT 6511",
"city": "New Haven",
"county": "New Haven City",
"state": "CT",
"postal_code": "6511",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-05-28",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PLANO TX 75025",
"city": "Plano",
"county": "Collin",
"state": "TX",
"postal_code": "75025",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-03-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ALLEN TX 75013",
"city": "Allen",
"county": "Collin",
"state": "TX",
"postal_code": "75013",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-02-17",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHICAGO IL 60606",
"city": "Chicago",
"county": "Cook",
"state": "IL",
"postal_code": "60606",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-09-15",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHANDLER OK 74834",
"city": "Chandler",
"county": "Lincoln",
"state": "OK",
"postal_code": "74834",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-08-13",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PLANO TX 75074",
"city": "Plano",
"county": "Collin",
"state": "TX",
"postal_code": "75074",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-07-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "AUSTIN TX 78752",
"city": "Austin",
"county": "Travis",
"state": "TX",
"postal_code": "78752",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-04-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BEVERLY MA 01915",
"city": "Beverly",
"county": "Essex",
"state": "MA",
"postal_code": "01915",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-12-24",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WEST TRENTON NJ 8628",
"city": "West Trenton",
"county": "Mercer",
"state": "NJ",
"postal_code": "8628",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-03-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "AUSTIN TX 78723",
"city": "Austin",
"county": "Collin",
"state": "TX",
"postal_code": "78723",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-03-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NEW HAVEN CT 06511",
"city": "New Haven",
"county": "New Haven City",
"state": "CT",
"postal_code": "06511",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-11-13",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MADISON WI 53783",
"city": "Madison",
"county": "Dane",
"state": "WI",
"postal_code": "53783",
"filing_count": 9,
"case_count": 9,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-04-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "COLUMBUS OH 43215",
"city": "Columbus",
"county": "Franklin",
"state": "OH",
"postal_code": "43215",
"filing_count": 8,
"case_count": 8,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019,
"latest_decision_date": "2018-11-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SACRAMENTO CA 95814",
"city": "Sacramento",
"county": "Sacramento",
"state": "CA",
"postal_code": "95814",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-05-07",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HONOLULU HI 96813",
"city": "Honolulu",
"county": "Honolulu",
"state": "HI",
"postal_code": "96813",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2018-12-07",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "AUSTIN TX 78749",
"city": "Austin",
"county": "Travis",
"state": "TX",
"postal_code": "78749",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-08-15",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NEW HAVEN CT 6511",
"city": "New Haven",
"county": "New Haven",
"state": "CT",
"postal_code": "6511",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-07-23",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "JERSEY CITY NJ 7311",
"city": "Jersey City",
"county": "Hudson",
"state": "NJ",
"postal_code": "7311",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-01-03",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "POCATELLO ID 83205",
"city": "Pocatello",
"county": "Bannock",
"state": "ID",
"postal_code": "83205",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"latest_decision_date": "2018-11-09",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MERRILL WI 54452",
"city": "Merrill",
"county": "Lincoln",
"state": "WI",
"postal_code": "54452",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-09-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NEW HEAVEN DC 6511",
"city": "New Heaven",
"county": "New Heaven",
"state": "DC",
"postal_code": "6511",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-07-17",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ST AUGUSTINE FL 32095",
"city": "St Augustine",
"county": "Saint Johns",
"state": "FL",
"postal_code": "32095",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-07-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "BEVERLY MA 1915",
"city": "Beverly",
"county": "Essex",
"state": "MA",
"postal_code": "1915",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-06-28",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WARREN NJ 07059",
"city": "Warren",
"county": "Somerset",
"state": "NJ",
"postal_code": "07059",
"filing_count": 9,
"case_count": 9,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-06-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LINCOLN RI 02865",
"city": "Lincoln",
"county": "Providence",
"state": "RI",
"postal_code": "02865",
"filing_count": 5,
"case_count": 5,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-08-24",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "VACAVILLE CA 95688",
"city": "Vacaville",
"county": "Solano",
"state": "CA",
"postal_code": "95688",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-09-04",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WARWICK RI 02886",
"city": "Warwick",
"county": "Kent",
"state": "RI",
"postal_code": "02886",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-03-13",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "DALLAS TX 75219",
"city": "Dallas",
"county": "Dallas",
"state": "TX",
"postal_code": "75219",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-02-05",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WESTERVILLE OH 43081",
"city": "Westerville",
"county": "Franklin",
"state": "OH",
"postal_code": "43081",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-09-06",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HARLEYSVILLE PA 19438",
"city": "Harleysville",
"county": "Montgomery",
"state": "PA",
"postal_code": "19438",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-03-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WEST TRENTON NJ 08628",
"city": "West Trenton",
"county": "Mercer",
"state": "NJ",
"postal_code": "08628",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-03-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SAN MATEO CA 94403",
"city": "San Mateo",
"county": "San Mateo",
"state": "CA",
"postal_code": "94403",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-02-23",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HASTING MI 49058",
"city": "Hasting",
"county": "Barry",
"state": "MI",
"postal_code": "49058",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-01-18",
"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": [
"TX",
"PA",
"AL",
"NJ",
"WI",
"FL",
"OH",
"CA",
"CT",
"MI",
"RI",
"HI",
"MA",
"ID",
"IL",
"DC",
"NC",
"NY",
"OK",
"SC"
],
"cities": [
"Plano",
"Marietta",
"Austin",
"Montgomery",
"Warren",
"Madison",
"Lake Mary",
"Columbus",
"Frisco",
"Sacramento",
"New Haven",
"Hastings",
"Lincoln",
"Irving",
"Honolulu",
"The Woodlands",
"Vacaville",
"Riverview",
"Beverly",
"Pleasanton",
"Saint Augustine",
"Sarasota",
"Pocatello",
"Berkeley Heights",
"Jersey City",
"West Trenton",
"Warwick",
"Allen",
"Dallas",
"Monterey",
"San Mateo",
"Woodland Hills",
"New Heaven",
"St Augustine",
"Chicago",
"Hasting",
"Concord",
"Princeton",
"New York",
"Westerville",
"Chandler",
"Harleysville",
"Philadelphia",
"Columbia",
"Prosper",
"Merrill",
"Lisle",
"Warrenville"
],
"postal_codes": [
"75075",
"17547",
"78723",
"36116",
"07059",
"53783",
"32746",
"43215",
"75035",
"95833",
"6511",
"49058",
"02865",
"75063",
"95814",
"96813",
"77380",
"95688",
"33578",
"01915",
"78749",
"53703",
"94588",
"32095",
"34232",
"83205",
"7922",
"7311",
"7059",
"8628",
"02886",
"75013",
"75219",
"75025",
"93940",
"94403",
"91367",
"06511",
"60606",
"1915",
"28027",
"08540",
"08628",
"10013",
"43081",
"74834",
"19438",
"19103",
"29201",
"78752",
"75024",
"75074",
"75058",
"75078",
"54452",
"60532",
"60555"
],
"top_markets": [
{
"city": "Plano",
"state": "TX",
"postal_code": "75075",
"lca_count": 47,
"role_title_count": 8,
"wage_low_min": 92000,
"wage_high_max": 127300,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2021
},
{
"city": "Marietta",
"state": "PA",
"postal_code": "17547",
"lca_count": 23,
"role_title_count": 11,
"wage_low_min": 75000,
"wage_high_max": 140000,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2022
},
{
"city": "Austin",
"state": "TX",
"postal_code": "78723",
"lca_count": 14,
"role_title_count": 2,
"wage_low_min": 105000,
"wage_high_max": 110000,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2022
},
{
"city": "Montgomery",
"state": "AL",
"postal_code": "36116",
"lca_count": 9,
"role_title_count": 4,
"wage_low_min": 75000,
"wage_high_max": 98000,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2022
},
{
"city": "Warren",
"state": "NJ",
"postal_code": "07059",
"lca_count": 9,
"role_title_count": 8,
"wage_low_min": 64150,
"wage_high_max": 0,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2018
},
{
"city": "Madison",
"state": "WI",
"postal_code": "53783",
"lca_count": 9,
"role_title_count": 4,
"wage_low_min": 86000,
"wage_high_max": 95000,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019
},
{
"city": "Lake Mary",
"state": "FL",
"postal_code": "32746",
"lca_count": 8,
"role_title_count": 3,
"wage_low_min": 65000,
"wage_high_max": 0,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017
},
{
"city": "Columbus",
"state": "OH",
"postal_code": "43215",
"lca_count": 8,
"role_title_count": 3,
"wage_low_min": 80000,
"wage_high_max": 100000,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019
},
{
"city": "Frisco",
"state": "TX",
"postal_code": "75035",
"lca_count": 6,
"role_title_count": 2,
"wage_low_min": 95000,
"wage_high_max": 140000,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2022
},
{
"city": "Sacramento",
"state": "CA",
"postal_code": "95833",
"lca_count": 5,
"role_title_count": 1,
"wage_low_min": 87500,
"wage_high_max": 94000,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021
}
]
}Industry
{
"naics_codes": [
"541511",
"54"
],
"naics_breakdown": [
{
"value": "541511",
"filing_count": 143,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "54151",
"filing_count": 85,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2023,
"source": "dol_oflc_lca"
}
]
}Wage Summary
{
"annualized_low_min": 64150,
"annualized_high_max": 170000,
"annualized_low_avg": 100346.255319149
}Trend
[
{
"fiscal_year": 2016,
"quarter": "Q2",
"lca_count": 7,
"case_count": 7,
"role_title_count": 4,
"worksite_count": 3,
"wage_low_min": 86000,
"wage_high_max": 0,
"wage_low_avg": 124400
},
{
"fiscal_year": 2017,
"quarter": "Q2",
"lca_count": 37,
"case_count": 37,
"role_title_count": 10,
"worksite_count": 15,
"wage_low_min": 64150,
"wage_high_max": 0,
"wage_low_avg": 82874.3243243243
},
{
"fiscal_year": 2018,
"quarter": "Q2",
"lca_count": 68,
"case_count": 68,
"role_title_count": 18,
"worksite_count": 21,
"wage_low_min": 75000,
"wage_high_max": 0,
"wage_low_avg": 95533.8235294118
},
{
"fiscal_year": 2019,
"quarter": "Q2",
"lca_count": 39,
"case_count": 39,
"role_title_count": 16,
"worksite_count": 18,
"wage_low_min": 68640,
"wage_high_max": 140000,
"wage_low_avg": 98874.8717948718
},
{
"fiscal_year": 2020,
"quarter": "Q1",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 95000,
"wage_high_max": 105000,
"wage_low_avg": 100000
},
{
"fiscal_year": 2020,
"quarter": "Q2",
"lca_count": 6,
"case_count": 6,
"role_title_count": 5,
"worksite_count": 4,
"wage_low_min": 90000,
"wage_high_max": 140000,
"wage_low_avg": 103333.333333333
},
{
"fiscal_year": 2020,
"quarter": "Q3",
"lca_count": 5,
"case_count": 5,
"role_title_count": 3,
"worksite_count": 4,
"wage_low_min": 85000,
"wage_high_max": 105000,
"wage_low_avg": 96000
},
{
"fiscal_year": 2020,
"quarter": "Q4",
"lca_count": 4,
"case_count": 4,
"role_title_count": 4,
"worksite_count": 2,
"wage_low_min": 95000,
"wage_high_max": 115000,
"wage_low_avg": 105500
},
{
"fiscal_year": 2021,
"quarter": "Q1",
"lca_count": 5,
"case_count": 5,
"role_title_count": 2,
"worksite_count": 3,
"wage_low_min": 98000,
"wage_high_max": 127300,
"wage_low_avg": 114520
},
{
"fiscal_year": 2021,
"quarter": "Q2",
"lca_count": 12,
"case_count": 12,
"role_title_count": 4,
"worksite_count": 7,
"wage_low_min": 87500,
"wage_high_max": 127300,
"wage_low_avg": 105300
},
{
"fiscal_year": 2021,
"quarter": "Q3",
"lca_count": 18,
"case_count": 18,
"role_title_count": 6,
"worksite_count": 9,
"wage_low_min": 87500,
"wage_high_max": 127300,
"wage_low_avg": 102700
},
{
"fiscal_year": 2021,
"quarter": "Q4",
"lca_count": 6,
"case_count": 6,
"role_title_count": 3,
"worksite_count": 6,
"wage_low_min": 100000,
"wage_high_max": 140000,
"wage_low_avg": 113333.333333333
},
{
"fiscal_year": 2022,
"quarter": "Q1",
"lca_count": 5,
"case_count": 5,
"role_title_count": 3,
"worksite_count": 5,
"wage_low_min": 100000,
"wage_high_max": 120000,
"wage_low_avg": 107400
},
{
"fiscal_year": 2022,
"quarter": "Q2",
"lca_count": 5,
"case_count": 5,
"role_title_count": 5,
"worksite_count": 4,
"wage_low_min": 85000,
"wage_high_max": 140000,
"wage_low_avg": 114000
},
{
"fiscal_year": 2022,
"quarter": "Q3",
"lca_count": 7,
"case_count": 7,
"role_title_count": 3,
"worksite_count": 5,
"wage_low_min": 85000,
"wage_high_max": 170000,
"wage_low_avg": 124000
},
{
"fiscal_year": 2022,
"quarter": "Q4",
"lca_count": 3,
"case_count": 3,
"role_title_count": 2,
"worksite_count": 3,
"wage_low_min": 125000,
"wage_high_max": 165000,
"wage_low_avg": 143333.333333333
},
{
"fiscal_year": 2023,
"quarter": "Q1",
"lca_count": 2,
"case_count": 2,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 115000,
"wage_high_max": 115000,
"wage_low_avg": 115000
},
{
"fiscal_year": 2023,
"quarter": "Q2",
"lca_count": 4,
"case_count": 4,
"role_title_count": 2,
"worksite_count": 3,
"wage_low_min": 115000,
"wage_high_max": 170000,
"wage_low_avg": 142500
}
]Links
{
"roles": "/v1/roles?company=STONEBRIDGE%20CONSULTING%20GROUP%20LLC",
"wages": "/v1/wages?company=STONEBRIDGE%20CONSULTING%20GROUP%20LLC",
"trends": "/v1/trends?company=STONEBRIDGE%20CONSULTING%20GROUP%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=stonebridge+consulting+group+llc&limit=5JSON