Home / Companies / SHIBRAM BANERJEE, INC.
SHIBRAM BANERJEE, 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.
| Employer | LCA filings | Role titles | Worksites | Coverage | USCIS approvals | Top role | Sources | Open |
|---|---|---|---|---|---|---|---|---|
| SHIBRAM BANERJEE, INC. Pacific Data Integrators, PACIFIC DATA INTEGRATORS, SHIBRAM BANERJEE INC DBA PACIFIC D | 85 | 34 | 12 | FY2016 to FY2026 Latest decision 2026-03-30 | 40 | SOFTWARE DEVELOPER 7 filings | dol_oflc_lca, uscis_h1b_employer_data_hub | Profile |
Activity summary
| LCA filings | 85 |
| Certified LCAs | 80 |
| Denied LCAs | 2 |
| Role titles | 34 |
| Worksites | 12 |
| Latest decision | 2026-03-30 |
| USCIS approvals | 40 |
| USCIS denials | 9 |
Aliases and source names
| Aliases | Source Names | Sources |
|---|---|---|
| Pacific Data Integrators, PACIFIC DATA INTEGRATORS, SHIBRAM BANERJEE INC DBA PACIFIC D, SHIBRAM BANERJEE INC DBA PACIFIC DATA INTEGRATORS, SHIBRAM BANERJEE INC DBA PACIFIC | SHIBRAM BANERJEE, INC., SHIBRAM BANERJEE, INC. DBA PACIFIC DATA INTEGRATORS, SHIBRAM BANERJEE INC DBA PACIFIC D, SHIBRAM BANERJEE INC DBA PACIFIC DATA INTEGRATORS, SHIBRAM BANERJEE INC DBA PACIFIC | dol_oflc_lca, uscis_h1b_employer_data_hub |
Top roles
| Title | SOC | LCA filings | Low wage min | High wage max |
|---|---|---|---|---|
| SOFTWARE DEVELOPER | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 7 | $72,000 | $130,000 |
| Oracle CC&B Developer | 15-1132.00 Software Developers, Applications | 6 | $120,000 | $144,000 |
| INFORMATICA MDM CONSULTANT | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 5 | $90,002 | $95,000 |
| INFORMATION SECURITY INFRASTRUCTURE ARCHITECT | 15-1143 COMPUTER NETWORK ARCHITECTS | 4 | $137,000 | $137,000 |
| Software Engineer | 15-1132.00 Software Developers, Applications | 4 | $113,006 | $147,500 |
| SR. INFORMATICA DEVELOPER | 15-1132 SOFTWARE DEVELOPERS, APPLICATIONS | 4 | $100,000 | $120,000 |
| BUSINESS INTELLIGENCE ANALYST | 15-1199 Business Intelligence Analysts | 3 | $92,000 | $130,000 |
| SENIOR TECHNICAL ARCHITECT | 15-1132 | 3 | $155,000 | $0 |
| Software Developer | 15-1132.00 Software Developers, Applications | 3 | $72,758 | $90,000 |
| Business Intelligence Analyst | 15-1199.08 Business Intelligence Analysts | 2 | $103,775 | $130,000 |
Top markets
| City | State | Postal Code | LCA Count | Role Title Count | Wage Low Min | Wage High Max | First Fiscal Year | Latest Fiscal Year |
|---|---|---|---|---|---|---|---|---|
| Rocklin | CA | 95765 | 42 | 23 | 71,700 | 160,000 | 2,016 | 2,023 |
| San Francisco | CA | 94105 | 19 | 6 | 103,775 | 145,600 | 2,018 | 2,023 |
| Roseville | CA | 95661 | 8 | 6 | 140,000 | 180,000 | 2,024 | 2,026 |
| Pleasanton | CA | 94588 | 3 | 1 | 155,000 | 0 | 2,018 | 2,018 |
| Las Vegas | NV | 89119 | 3 | 1 | 110,000 | 120,000 | 2,018 | 2,019 |
| Jackson | MI | 49201 | 2 | 1 | 92,000 | 92,000 | 2,019 | 2,019 |
| Cincinnati | OH | 45202 | 2 | 1 | 95,000 | 95,000 | 2,019 | 2,019 |
| Rocklin | CA | 95765 | 2 | 2 | 95,000 | 0 | 2,017 | 2,017 |
| Oakland | CA | 94612 | 1 | 1 | 147,368 | 180,000 | 2,024 | 2,024 |
| San Ramon | CA | 94583 | 1 | 1 | 105,780 | 0 | 2,018 | 2,018 |
Full company payload
| Company ID | company:shibram banerjee |
| Name | SHIBRAM BANERJEE, INC. |
| Normalized Name | shibram banerjee |
| Source Company Ids | company_dol_oflc_lca_shibram_banerjee_inc, company_dol_oflc_lca_shibram_banerjee_inc_dba_pacific_data_integrators, company_uscis_h1b_datahub_shibram_banerjee_inc_dba_pacific_d_tax_5284, company_uscis_h1b_datahub_shibram_banerjee_inc_dba_pacific_data_integrators_tax_5284, company_uscis_h1b_datahub_shibram_banerjee_inc_dba_pacific_tax_5284 |
| Source Names | SHIBRAM BANERJEE, INC., SHIBRAM BANERJEE, INC. DBA PACIFIC DATA INTEGRATORS, SHIBRAM BANERJEE INC DBA PACIFIC D, SHIBRAM BANERJEE INC DBA PACIFIC DATA INTEGRATORS, SHIBRAM BANERJEE INC DBA PACIFIC |
| Aliases | Pacific Data Integrators, PACIFIC DATA INTEGRATORS, SHIBRAM BANERJEE INC DBA PACIFIC D, SHIBRAM BANERJEE INC DBA PACIFIC DATA INTEGRATORS, SHIBRAM BANERJEE INC DBA PACIFIC |
| Sources | dol_oflc_lca, uscis_h1b_employer_data_hub |
Names
{
"source_names": [
"SHIBRAM BANERJEE, INC.",
"SHIBRAM BANERJEE, INC. DBA PACIFIC DATA INTEGRATORS",
"SHIBRAM BANERJEE INC DBA PACIFIC D",
"SHIBRAM BANERJEE INC DBA PACIFIC DATA INTEGRATORS",
"SHIBRAM BANERJEE INC DBA PACIFIC"
],
"dba_names": [
"Pacific Data Integrators",
"PACIFIC DATA INTEGRATORS"
],
"name_variants": [
{
"value": "Pacific Data Integrators",
"filing_count": 36,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2025,
"source": "dol_oflc_lca"
},
{
"value": "PACIFIC DATA INTEGRATORS",
"filing_count": 30,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "SHIBRAM BANERJEE, INC.",
"filing_count": 13,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
},
{
"value": "Shibram Banerjee, Inc.",
"filing_count": 3,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
},
{
"value": "SHIBRAM BANERJEE, INC. DBA PACIFIC DATA INTEGRATORS",
"filing_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
},
{
"value": "SHIBRAM BANERJEE INC.",
"filing_count": 1,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
},
{
"value": "SHIBRAM BANERJEE INC DBA PACIFIC D",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "SHIBRAM BANERJEE INC DBA PACIFIC DATA INTEGRATORS",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "SHIBRAM BANERJEE INC DBA PACIFIC",
"source": "uscis_h1b_employer_data_hub"
}
]
}Identifiers
[
{
"identifier_type": "tax_id_last_four",
"identifier_value": "5284",
"source": "uscis_h1b_employer_data_hub"
}
]LCA Activity
{
"lca_count": 85,
"case_count": 85,
"role_title_count": 34,
"worksite_count": 12,
"total_workers": 85,
"first_fiscal_year": 2016,
"first_received_date": "2015-10-09",
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-30",
"certified_count": 80,
"denied_count": 2,
"status_breakdown": [
{
"value": "Certified",
"filing_count": 36,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
},
{
"value": "CERTIFIED",
"filing_count": 34,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "CERTIFIED-WITHDRAWN",
"filing_count": 7,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "CERTIFIED",
"filing_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
},
{
"value": "WITHDRAWN",
"filing_count": 2,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "Certified - Withdrawn",
"filing_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
},
{
"value": "Denied",
"filing_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
},
{
"value": "DENIED",
"filing_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"source": "dol_oflc_lca"
},
{
"value": "Withdrawn",
"filing_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
}
],
"visa_class_breakdown": [
{
"value": "H-1B",
"filing_count": 80,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
},
{
"value": "E-3 Australian",
"filing_count": 3,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"source": "dol_oflc_lca"
},
{
"value": "H-1B",
"filing_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
}
],
"full_time_position_breakdown": [
{
"value": "Y",
"filing_count": 75,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
},
{
"value": "Y",
"filing_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
}
]
}Petition Activity
{
"initial_approval": 0,
"initial_denial": 0,
"continuing_approval": 0,
"continuing_denial": 0,
"total_approval": 40,
"total_denial": 9,
"fiscal_years": [
"2012",
"2013",
"2014",
"2015",
"2016",
"2017",
"2018",
"2019",
"2020",
"2021",
"2022",
"2023"
],
"year_metrics": [
{
"cities": [
"Roseville"
],
"states": [
"CA"
],
"fiscal_year": 2012,
"naics_codes": [
"54"
],
"postal_codes": [
"95747"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_d_tax_5284_2012",
"source_record_ids": [
"sr_uscis_h1b_datahub_2012_row_028692"
],
"continuing_approval": 0
},
{
"cities": [
"Roseville"
],
"states": [
"CA"
],
"fiscal_year": 2013,
"naics_codes": [
"54"
],
"postal_codes": [
"95747"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 2,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_d_tax_5284_2013",
"source_record_ids": [
"sr_uscis_h1b_datahub_2013_row_027100"
],
"continuing_approval": 2
},
{
"cities": [
"Roseville"
],
"states": [
"CA"
],
"fiscal_year": 2014,
"naics_codes": [
"54"
],
"postal_codes": [
"95747"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_d_tax_5284_2014",
"source_record_ids": [
"sr_uscis_h1b_datahub_2014_row_026930"
],
"continuing_approval": 1
},
{
"cities": [
"Rocklin"
],
"states": [
"CA"
],
"fiscal_year": 2015,
"naics_codes": [
"54"
],
"postal_codes": [
"95765"
],
"total_denial": 2,
"initial_denial": 1,
"total_approval": 5,
"initial_approval": 1,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_d_tax_5284_2015",
"source_record_ids": [
"sr_uscis_h1b_datahub_2015_row_021835"
],
"continuing_approval": 4
},
{
"cities": [
"Rocklin"
],
"states": [
"CA"
],
"fiscal_year": 2016,
"naics_codes": [
"54"
],
"postal_codes": [
"95765"
],
"total_denial": 1,
"initial_denial": 0,
"total_approval": 6,
"initial_approval": 1,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_d_tax_5284_2016",
"source_record_ids": [
"sr_uscis_h1b_datahub_2016_row_022709"
],
"continuing_approval": 5
},
{
"cities": [
"Rocklin"
],
"states": [
"CA"
],
"fiscal_year": 2017,
"naics_codes": [
"54"
],
"postal_codes": [
"95765"
],
"total_denial": 2,
"initial_denial": 0,
"total_approval": 2,
"initial_approval": 1,
"continuing_denial": 2,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_d_tax_5284_2017",
"source_record_ids": [
"sr_uscis_h1b_datahub_2017_row_020306"
],
"continuing_approval": 1
},
{
"cities": [
"Rocklin"
],
"states": [
"CA"
],
"fiscal_year": 2018,
"naics_codes": [
"51",
"54"
],
"postal_codes": [
"95765"
],
"total_denial": 1,
"initial_denial": 0,
"total_approval": 4,
"initial_approval": 1,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_d_tax_5284_2018",
"source_record_ids": [
"sr_uscis_h1b_datahub_2018_row_022047",
"sr_uscis_h1b_datahub_2018_row_022048"
],
"continuing_approval": 3
},
{
"cities": [
"Rocklin"
],
"states": [
"CA"
],
"fiscal_year": 2019,
"naics_codes": [
"51",
"54"
],
"postal_codes": [
"95765"
],
"total_denial": 2,
"initial_denial": 0,
"total_approval": 6,
"initial_approval": 3,
"continuing_denial": 2,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_d_tax_5284_2019",
"source_record_ids": [
"sr_uscis_h1b_datahub_2019_row_021983",
"sr_uscis_h1b_datahub_2019_row_021984"
],
"continuing_approval": 3
},
{
"cities": [
"Rocklin"
],
"states": [
"CA"
],
"fiscal_year": 2021,
"naics_codes": [
"51"
],
"postal_codes": [
"95765"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 5,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_d_tax_5284_2021",
"source_record_ids": [
"sr_uscis_h1b_datahub_2021_row_047047"
],
"continuing_approval": 4
},
{
"cities": [
"Rocklin"
],
"states": [
"CA"
],
"fiscal_year": 2022,
"naics_codes": [
"51"
],
"postal_codes": [
"95765"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_d_tax_5284_2022",
"source_record_ids": [
"sr_uscis_h1b_datahub_2022_row_046762"
],
"continuing_approval": 0
},
{
"cities": [
"Rocklin"
],
"states": [
"CA"
],
"fiscal_year": 2022,
"naics_codes": [
"51",
"54"
],
"postal_codes": [
"95765"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 4,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_data_integrators_tax_5284_2022",
"source_record_ids": [
"sr_uscis_h1b_datahub_2022_row_046763",
"sr_uscis_h1b_datahub_2022_row_046764"
],
"continuing_approval": 3
},
{
"cities": [
"Rocklin"
],
"states": [
"CA"
],
"fiscal_year": 2023,
"naics_codes": [
"54"
],
"postal_codes": [
"95765"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_data_integrators_tax_5284_2023",
"source_record_ids": [
"sr_uscis_h1b_datahub_2023_row_025739"
],
"continuing_approval": 0
},
{
"cities": [
"Rocklin"
],
"states": [
"CA"
],
"fiscal_year": 2020,
"naics_codes": [
"51"
],
"postal_codes": [
"95765"
],
"total_denial": 1,
"initial_denial": 1,
"total_approval": 2,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_shibram_banerjee_inc_dba_pacific_tax_5284_2020",
"source_record_ids": [
"sr_uscis_h1b_datahub_2020_row_043203"
],
"continuing_approval": 2
}
]
}Addresses
{
"office_addresses": [
{
"address_kind": "office",
"address_line_1": "3017 Douglas Blvd",
"address_line_2": "Ste 300",
"raw_address": "3017 Douglas Blvd Ste 300 ROSEVILLE CA 95661",
"city": "Roseville",
"state": "CA",
"postal_code": "95661",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-30",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "ROSEVILLE CA 95661",
"city": "Roseville",
"state": "CA",
"postal_code": "95661",
"filing_count": 6,
"case_count": 6,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-06-24",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "ROCKLIN CA 95765",
"city": "Rocklin",
"state": "CA",
"postal_code": "95765",
"filing_count": 74,
"case_count": 74,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-04-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "ROCKLIN CA 95765",
"city": "Rocklin",
"state": "CA",
"postal_code": "95765",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"latest_decision_date": "2017-08-01",
"source_ids": [
"dol_oflc_lca"
]
}
],
"worksite_addresses": [
{
"address_kind": "worksite",
"address_line_1": "3017 Douglas Blvd",
"address_line_2": "Ste 300",
"raw_address": "3017 Douglas Blvd Ste 300 ROSEVILLE CA 95661",
"city": "Roseville",
"state": "CA",
"postal_code": "95661",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2026,
"latest_fiscal_year": 2026,
"latest_decision_date": "2026-03-30",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ROSEVILLE CA 95661",
"city": "Roseville",
"county": "Placer",
"state": "CA",
"postal_code": "95661",
"filing_count": 5,
"case_count": 5,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2025,
"latest_decision_date": "2025-06-24",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "OAKLAND CA 94612",
"city": "Oakland",
"county": "Alameda",
"state": "CA",
"postal_code": "94612",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024,
"latest_decision_date": "2024-01-26",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ROCKLIN CA 95765",
"city": "Rocklin",
"county": "Placer",
"state": "CA",
"postal_code": "95765",
"filing_count": 42,
"case_count": 42,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-04-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SAN FRANCISCO CA 94105",
"city": "San Francisco",
"county": "San Francisco",
"state": "CA",
"postal_code": "94105",
"filing_count": 18,
"case_count": 18,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2023,
"latest_decision_date": "2023-04-19",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SAN FRANCISCO CA 94105",
"city": "San Francisco",
"county": "Placer",
"state": "CA",
"postal_code": "94105",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-06-28",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CANONSBURG PA 15317",
"city": "Canonsburg",
"county": "Washington",
"state": "PA",
"postal_code": "15317",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-09-28",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LAS VEGAS NV 89119",
"city": "Las Vegas",
"county": "Clark",
"state": "NV",
"postal_code": "89119",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-05-29",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "JACKSON MI 49201",
"city": "Jackson",
"county": "Jackson",
"state": "MI",
"postal_code": "49201",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-13",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CINCINNATI OH 45202",
"city": "Cincinnati",
"county": "Hamilton",
"state": "OH",
"postal_code": "45202",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-07",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PLEASANTON CA 94588",
"city": "Pleasanton",
"county": "Alameda",
"state": "CA",
"postal_code": "94588",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-03-05",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SAN RAMON CA 94583",
"city": "San Ramon",
"county": "Contra Costa",
"state": "CA",
"postal_code": "94583",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-05-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "HOUSTON TX 77077",
"city": "Houston",
"county": "Harris",
"state": "TX",
"postal_code": "77077",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018,
"latest_decision_date": "2018-03-21",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ROCKLIN CA 95765",
"city": "Rocklin",
"county": "Placer",
"state": "CA",
"postal_code": "95765",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"latest_decision_date": "2017-08-01",
"source_ids": [
"dol_oflc_lca"
]
}
],
"summary": {
"office_address_count": 4,
"worksite_address_count": 14,
"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",
"NV",
"MI",
"OH",
"PA",
"TX"
],
"cities": [
"Rocklin",
"San Francisco",
"Roseville",
"Pleasanton",
"Las Vegas",
"Jackson",
"Cincinnati",
"Oakland",
"San Ramon",
"Canonsburg",
"Houston"
],
"postal_codes": [
"95765",
"94105",
"95661",
"94588",
"89119",
"49201",
"45202",
"94612",
"94583",
"15317",
"77077",
"95747"
],
"top_markets": [
{
"city": "Rocklin",
"state": "CA",
"postal_code": "95765",
"lca_count": 42,
"role_title_count": 23,
"wage_low_min": 71700,
"wage_high_max": 160000,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2023
},
{
"city": "San Francisco",
"state": "CA",
"postal_code": "94105",
"lca_count": 19,
"role_title_count": 6,
"wage_low_min": 103775,
"wage_high_max": 145600,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2023
},
{
"city": "Roseville",
"state": "CA",
"postal_code": "95661",
"lca_count": 8,
"role_title_count": 6,
"wage_low_min": 140000,
"wage_high_max": 180000,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2026
},
{
"city": "Pleasanton",
"state": "CA",
"postal_code": "94588",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 155000,
"wage_high_max": 0,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018
},
{
"city": "Las Vegas",
"state": "NV",
"postal_code": "89119",
"lca_count": 3,
"role_title_count": 1,
"wage_low_min": 110000,
"wage_high_max": 120000,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2019
},
{
"city": "Jackson",
"state": "MI",
"postal_code": "49201",
"lca_count": 2,
"role_title_count": 1,
"wage_low_min": 92000,
"wage_high_max": 92000,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019
},
{
"city": "Cincinnati",
"state": "OH",
"postal_code": "45202",
"lca_count": 2,
"role_title_count": 1,
"wage_low_min": 95000,
"wage_high_max": 95000,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019
},
{
"city": "Rocklin",
"state": "CA",
"postal_code": "95765",
"lca_count": 2,
"role_title_count": 2,
"wage_low_min": 95000,
"wage_high_max": 0,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017
},
{
"city": "Oakland",
"state": "CA",
"postal_code": "94612",
"lca_count": 1,
"role_title_count": 1,
"wage_low_min": 147368,
"wage_high_max": 180000,
"first_fiscal_year": 2024,
"latest_fiscal_year": 2024
},
{
"city": "San Ramon",
"state": "CA",
"postal_code": "94583",
"lca_count": 1,
"role_title_count": 1,
"wage_low_min": 105780,
"wage_high_max": 0,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2018
}
]
}Industry
{
"naics_codes": [
"541519",
"541511",
"51",
"54"
],
"naics_breakdown": [
{
"value": "518210",
"filing_count": 44,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2022,
"source": "dol_oflc_lca"
},
{
"value": "541511",
"filing_count": 28,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2026,
"source": "dol_oflc_lca"
},
{
"value": "541511",
"filing_count": 2,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2017,
"source": "dol_oflc_lca"
},
{
"value": "541519",
"filing_count": 2,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "5182",
"filing_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"source": "dol_oflc_lca"
}
]
}Wage Summary
{
"annualized_low_min": 71700,
"annualized_high_max": 180000,
"annualized_low_avg": 111181.530120482
}Trend
[
{
"fiscal_year": 2016,
"quarter": "Q2",
"lca_count": 8,
"case_count": 8,
"role_title_count": 7,
"worksite_count": 1,
"wage_low_min": 80000,
"wage_high_max": 140000,
"wage_low_avg": 99375
},
{
"fiscal_year": 2017,
"quarter": "Q2",
"lca_count": 8,
"case_count": 8,
"role_title_count": 8,
"worksite_count": 2,
"wage_low_min": 95000,
"wage_high_max": 100000,
"wage_low_avg": 113390.3333333335
},
{
"fiscal_year": 2018,
"quarter": "Q2",
"lca_count": 12,
"case_count": 12,
"role_title_count": 8,
"worksite_count": 6,
"wage_low_min": 88358,
"wage_high_max": 100000,
"wage_low_avg": 127874.833333333
},
{
"fiscal_year": 2019,
"quarter": "Q2",
"lca_count": 18,
"case_count": 18,
"role_title_count": 8,
"worksite_count": 5,
"wage_low_min": 71700,
"wage_high_max": 137000,
"wage_low_avg": 102983.333333333
},
{
"fiscal_year": 2020,
"quarter": "Q2",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 120000,
"wage_high_max": 120000,
"wage_low_avg": 120000
},
{
"fiscal_year": 2020,
"quarter": "Q3",
"lca_count": 2,
"case_count": 2,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 72758,
"wage_high_max": 89000,
"wage_low_avg": 72758
},
{
"fiscal_year": 2020,
"quarter": "Q4",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 79250,
"wage_high_max": 110000,
"wage_low_avg": 94625
},
{
"fiscal_year": 2021,
"quarter": "Q1",
"lca_count": 3,
"case_count": 3,
"role_title_count": 3,
"worksite_count": 2,
"wage_low_min": 103775,
"wage_high_max": 147500,
"wage_low_avg": 112570.666666667
},
{
"fiscal_year": 2021,
"quarter": "Q2",
"lca_count": 4,
"case_count": 4,
"role_title_count": 3,
"worksite_count": 2,
"wage_low_min": 103775,
"wage_high_max": 147500,
"wage_low_avg": 114182.5
},
{
"fiscal_year": 2021,
"quarter": "Q3",
"lca_count": 4,
"case_count": 4,
"role_title_count": 3,
"worksite_count": 2,
"wage_low_min": 103775,
"wage_high_max": 147500,
"wage_low_avg": 114182.5
},
{
"fiscal_year": 2021,
"quarter": "Q4",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 122346,
"wage_high_max": 140000,
"wage_low_avg": 122346
},
{
"fiscal_year": 2022,
"quarter": "Q1",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 100500,
"wage_high_max": 122345,
"wage_low_avg": 100500
},
{
"fiscal_year": 2022,
"quarter": "Q2",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 125000,
"wage_high_max": 135000,
"wage_low_avg": 125000
},
{
"fiscal_year": 2022,
"quarter": "Q3",
"lca_count": 5,
"case_count": 5,
"role_title_count": 4,
"worksite_count": 2,
"wage_low_min": 75000,
"wage_high_max": 144000,
"wage_low_avg": 104500
},
{
"fiscal_year": 2022,
"quarter": "Q4",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 140000,
"wage_high_max": 160000,
"wage_low_avg": 140000
},
{
"fiscal_year": 2023,
"quarter": "Q2",
"lca_count": 2,
"case_count": 2,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 132870,
"wage_high_max": 145000,
"wage_low_avg": 132870
},
{
"fiscal_year": 2023,
"quarter": "Q3",
"lca_count": 2,
"case_count": 2,
"role_title_count": 1,
"worksite_count": 2,
"wage_low_min": 114400,
"wage_high_max": 145600,
"wage_low_avg": 124800
},
{
"fiscal_year": 2024,
"quarter": "Q2",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 147368,
"wage_high_max": 180000,
"wage_low_avg": 147368
},
{
"fiscal_year": 2024,
"quarter": "Q3",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 1,
"wage_low_min": 140000,
"wage_high_max": 160000,
"wage_low_avg": 140000
},
{
"fiscal_year": 2024,
"quarter": "Q4",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 160000,
"wage_high_max": 180000,
"wage_low_avg": 160000
},
{
"fiscal_year": 2025,
"quarter": "Q1",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 146500,
"wage_high_max": 171000,
"wage_low_avg": 146500
},
{
"fiscal_year": 2025,
"quarter": "Q3",
"lca_count": 1,
"case_count": 1,
"role_title_count": 1,
"worksite_count": 1,
"wage_low_min": 148000,
"wage_high_max": 171000,
"wage_low_avg": 148000
},
{
"fiscal_year": 2026,
"quarter": "Q2",
"lca_count": 3,
"case_count": 3,
"role_title_count": 2,
"worksite_count": 1,
"wage_low_min": 149115,
"wage_high_max": 160000,
"wage_low_avg": 149410
}
]Links
{
"roles": "/v1/roles?company=SHIBRAM%20BANERJEE%2C%20INC.",
"wages": "/v1/wages?company=SHIBRAM%20BANERJEE%2C%20INC.",
"trends": "/v1/trends?company=SHIBRAM%20BANERJEE%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=shibram+banerjee+inc&limit=5JSON