Home / Companies / Dell Marketing LP
Dell Marketing LP 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 |
|---|---|---|---|---|---|---|---|---|
| Dell Marketing LP DELL MARKETING LP | 97 | 53 | 29 | FY2016 to FY2022 Latest decision 2022-03-16 | 1,521 | SENIOR ADVISOR, PRODUCT MARKETING 7 filings | dol_oflc_lca, uscis_h1b_employer_data_hub | Profile |
Activity summary
| LCA filings | 97 |
| Certified LCAs | 88 |
| Denied LCAs | 1 |
| Role titles | 53 |
| Worksites | 29 |
| Latest decision | 2022-03-16 |
| USCIS approvals | 1,521 |
| USCIS denials | 22 |
Aliases and source names
| Aliases | Source Names | Sources |
|---|---|---|
| DELL MARKETING LP | Dell Marketing LP, DELL MARKETING LP | dol_oflc_lca, uscis_h1b_employer_data_hub |
Top roles
| Title | SOC | LCA filings | Low wage min | High wage max |
|---|---|---|---|---|
| SENIOR ADVISOR, PRODUCT MARKETING | 13-1161.00 Market Research Analysts and Marketing Specialists | 7 | $120,000 | $137,000 |
| CONSULTANT, BUSINESS INTELLIGENCE | 15-2031.00 Operations Research Analysts | 4 | $126,000 | $126,000 |
| SOFTWARE DEVELOPMENT ADVISOR | 15-1132 | 4 | $87,880 | $0 |
| SENIOR ADVISOR, MERCHANDISING | 13-1161.00 Market Research Analysts and Marketing Specialists | 3 | $105,000 | $115,000 |
| ADVISOR, MARKETING OPERATIONS | 13-1161.00 Market Research Analysts and Marketing Specialists | 2 | $105,000 | $110,000 |
| ADVISOR, PRODUCT MARKETING | 13-1161 MARKET RESEARCH ANALYSTS AND MARKETING SPECIALISTS | 2 | $110,000 | $110,000 |
| Advisor, Product Marketing | 13-1161.00 Market Research Analysts and Marketing Specialists | 2 | $110,000 | $110,000 |
| CONSULTANT, PRODUCT MARKETING | 13-1161 MARKET RESEARCH ANALYSTS AND MARKETING SPECIALISTS | 2 | $130,000 | $140,463 |
| Consultant, Product Marketing | 13-1161.00 Market Research Analysts and Marketing Specialists | 2 | $140,463 | $140,463 |
| Consultant, Sales Planning & Strategy | 15-2031.00 Operations Research Analysts | 2 | $127,000 | $127,000 |
Top markets
| City | State | Postal Code | LCA Count | Role Title Count | Wage Low Min | Wage High Max | First Fiscal Year | Latest Fiscal Year |
|---|---|---|---|---|---|---|---|---|
| Round Rock | TX | 78682 | 49 | 27 | 78,750 | 222,525 | 2,016 | 2,021 |
| Plano | TX | 75075 | 6 | 4 | 85,827 | 0 | 2,016 | 2,016 |
| Austin | TX | 78753 | 5 | 3 | 70,000 | 137,000 | 2,020 | 2,021 |
| Austin | TX | 78751 | 4 | 1 | 126,000 | 126,000 | 2,020 | 2,021 |
| Seattle | WA | 98104 | 4 | 3 | 80,000 | 135,214 | 2,018 | 2,020 |
| Round Rock | TX | 78664 | 3 | 2 | 115,000 | 131,500 | 2,019 | 2,021 |
| Santa Clara | CA | 95054 | 2 | 2 | 115,000 | 130,000 | 2,018 | 2,020 |
| Austin | TX | 78726 | 2 | 1 | 127,000 | 127,000 | 2,021 | 2,021 |
| Round Rock | TX | 78665 | 2 | 2 | 110,000 | 147,662 | 2,020 | 2,020 |
| Anaheim | CA | 92805 | 1 | 1 | 79,664 | 0 | 2,016 | 2,016 |
Full company payload
| Company ID | company:dell marketing lp |
| Name | Dell Marketing LP |
| Normalized Name | dell marketing lp |
| Source Company Ids | company_dol_oflc_lca_dell_marketing_lp, company_uscis_h1b_datahub_dell_marketing_lp_tax_6805, company_uscis_h1b_datahub_dell_marketing_lp_tax_8639, company_uscis_h1b_datahub_dell_marketing_lp_tax_7834, company_uscis_h1b_datahub_dell_marketing_lp_tax_1680, company_uscis_h1b_datahub_dell_marketing_lp_tax_7921, company_uscis_h1b_datahub_dell_marketing_lp_tax_6085, company_uscis_h1b_datahub_dell_marketing_lp_tax_9188 |
| Source Names | Dell Marketing LP, DELL MARKETING LP |
| Aliases | DELL MARKETING LP |
| Sources | dol_oflc_lca, uscis_h1b_employer_data_hub |
Names
{
"source_names": [
"Dell Marketing LP",
"DELL MARKETING LP"
],
"dba_names": [],
"name_variants": [
{
"value": "DELL MARKETING LP",
"filing_count": 54,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2022,
"source": "dol_oflc_lca"
},
{
"value": "Dell Marketing LP",
"filing_count": 30,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2022,
"source": "dol_oflc_lca"
},
{
"value": "DELL MARKETING, LP",
"filing_count": 13,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2018,
"source": "dol_oflc_lca"
},
{
"value": "DELL MARKETING LP",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "DELL MARKETING LP",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "DELL MARKETING LP",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "DELL MARKETING LP",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "DELL MARKETING LP",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "DELL MARKETING LP",
"source": "uscis_h1b_employer_data_hub"
},
{
"value": "DELL MARKETING LP",
"source": "uscis_h1b_employer_data_hub"
}
]
}Identifiers
[
{
"identifier_type": "tax_id_last_four",
"identifier_value": "6805",
"source": "uscis_h1b_employer_data_hub"
},
{
"identifier_type": "tax_id_last_four",
"identifier_value": "8639",
"source": "uscis_h1b_employer_data_hub"
},
{
"identifier_type": "tax_id_last_four",
"identifier_value": "7834",
"source": "uscis_h1b_employer_data_hub"
},
{
"identifier_type": "tax_id_last_four",
"identifier_value": "1680",
"source": "uscis_h1b_employer_data_hub"
},
{
"identifier_type": "tax_id_last_four",
"identifier_value": "7921",
"source": "uscis_h1b_employer_data_hub"
},
{
"identifier_type": "tax_id_last_four",
"identifier_value": "6085",
"source": "uscis_h1b_employer_data_hub"
},
{
"identifier_type": "tax_id_last_four",
"identifier_value": "9188",
"source": "uscis_h1b_employer_data_hub"
}
]LCA Activity
{
"lca_count": 97,
"case_count": 97,
"role_title_count": 53,
"worksite_count": 29,
"total_workers": 97,
"first_fiscal_year": 2016,
"first_received_date": "2013-02-11",
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-03-16",
"certified_count": 88,
"denied_count": 1,
"status_breakdown": [
{
"value": "Certified",
"filing_count": 50,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2022,
"source": "dol_oflc_lca"
},
{
"value": "CERTIFIED",
"filing_count": 27,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2019,
"source": "dol_oflc_lca"
},
{
"value": "WITHDRAWN",
"filing_count": 7,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"source": "dol_oflc_lca"
},
{
"value": "Certified - Withdrawn",
"filing_count": 6,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"source": "dol_oflc_lca"
},
{
"value": "CERTIFIED-WITHDRAWN",
"filing_count": 5,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"source": "dol_oflc_lca"
},
{
"value": "DENIED",
"filing_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"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": 97,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2022,
"source": "dol_oflc_lca"
}
],
"full_time_position_breakdown": [
{
"value": "Y",
"filing_count": 79,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2022,
"source": "dol_oflc_lca"
}
]
}Petition Activity
{
"initial_approval": 0,
"initial_denial": 0,
"continuing_approval": 0,
"continuing_denial": 0,
"total_approval": 1521,
"total_denial": 22,
"fiscal_years": [
"2010",
"2011",
"2012",
"2013",
"2014",
"2015",
"2016",
"2017",
"2018",
"2019",
"2021"
],
"year_metrics": [
{
"cities": [
"Plano"
],
"states": [
"TX"
],
"fiscal_year": 2010,
"naics_codes": [
"54"
],
"postal_codes": [
"75075"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 6,
"initial_approval": 3,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_6805_2010",
"source_record_ids": [
"sr_uscis_h1b_datahub_2010_row_043978"
],
"continuing_approval": 3
},
{
"cities": [
"Dallas",
"Plano",
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2011,
"naics_codes": [
"33",
"54"
],
"postal_codes": [
"75075",
"75204",
"78682"
],
"total_denial": 3,
"initial_denial": 0,
"total_approval": 187,
"initial_approval": 79,
"continuing_denial": 3,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_6805_2011",
"source_record_ids": [
"sr_uscis_h1b_datahub_2011_row_050365",
"sr_uscis_h1b_datahub_2011_row_050366",
"sr_uscis_h1b_datahub_2011_row_050367",
"sr_uscis_h1b_datahub_2011_row_050368"
],
"continuing_approval": 108
},
{
"cities": [
"Plano",
"Raleigh",
"Round Rock"
],
"states": [
"NC",
"TX"
],
"fiscal_year": 2012,
"naics_codes": [
"33",
"54"
],
"postal_codes": [
"27602",
"27622",
"75075",
"75682",
"78682"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 314,
"initial_approval": 207,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_6805_2012",
"source_record_ids": [
"sr_uscis_h1b_datahub_2012_row_045627",
"sr_uscis_h1b_datahub_2012_row_045628",
"sr_uscis_h1b_datahub_2012_row_045629",
"sr_uscis_h1b_datahub_2012_row_045630",
"sr_uscis_h1b_datahub_2012_row_045631",
"sr_uscis_h1b_datahub_2012_row_045632",
"sr_uscis_h1b_datahub_2012_row_045633"
],
"continuing_approval": 107
},
{
"cities": [
"Red Rock",
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2013,
"naics_codes": [
"33",
"99"
],
"postal_codes": [
"78662",
"78682"
],
"total_denial": 2,
"initial_denial": 1,
"total_approval": 337,
"initial_approval": 162,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_6805_2013",
"source_record_ids": [
"sr_uscis_h1b_datahub_2013_row_045403",
"sr_uscis_h1b_datahub_2013_row_045404",
"sr_uscis_h1b_datahub_2013_row_049834"
],
"continuing_approval": 175
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2014,
"naics_codes": [
"33",
"54"
],
"postal_codes": [
"78682"
],
"total_denial": 11,
"initial_denial": 7,
"total_approval": 269,
"initial_approval": 52,
"continuing_denial": 4,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_6805_2014",
"source_record_ids": [
"sr_uscis_h1b_datahub_2014_row_046532",
"sr_uscis_h1b_datahub_2014_row_046533"
],
"continuing_approval": 217
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2015,
"naics_codes": [
"33",
"54"
],
"postal_codes": [
"78682"
],
"total_denial": 2,
"initial_denial": 0,
"total_approval": 249,
"initial_approval": 110,
"continuing_denial": 2,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_6805_2015",
"source_record_ids": [
"sr_uscis_h1b_datahub_2015_row_040227",
"sr_uscis_h1b_datahub_2015_row_040230"
],
"continuing_approval": 139
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2016,
"naics_codes": [
"44",
"52",
"54"
],
"postal_codes": [
"78682"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 46,
"initial_approval": 28,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_6805_2016",
"source_record_ids": [
"sr_uscis_h1b_datahub_2016_row_044061",
"sr_uscis_h1b_datahub_2016_row_044062",
"sr_uscis_h1b_datahub_2016_row_044063"
],
"continuing_approval": 18
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2017,
"naics_codes": [
"44",
"54",
"99"
],
"postal_codes": [
"78682"
],
"total_denial": 2,
"initial_denial": 2,
"total_approval": 13,
"initial_approval": 7,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_6805_2017",
"source_record_ids": [
"sr_uscis_h1b_datahub_2017_row_040447",
"sr_uscis_h1b_datahub_2017_row_040448",
"sr_uscis_h1b_datahub_2017_row_042737"
],
"continuing_approval": 6
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2018,
"naics_codes": [
"33",
"42",
"99"
],
"postal_codes": [
"78682"
],
"total_denial": 2,
"initial_denial": 1,
"total_approval": 51,
"initial_approval": 16,
"continuing_denial": 1,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_6805_2018",
"source_record_ids": [
"sr_uscis_h1b_datahub_2018_row_044251",
"sr_uscis_h1b_datahub_2018_row_044305",
"sr_uscis_h1b_datahub_2018_row_044306"
],
"continuing_approval": 35
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2021,
"naics_codes": [
"42"
],
"postal_codes": [
"78682"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 36,
"initial_approval": 14,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_6805_2021",
"source_record_ids": [
"sr_uscis_h1b_datahub_2021_row_015067"
],
"continuing_approval": 22
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2010,
"naics_codes": [
"54"
],
"postal_codes": [
"78682"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 5,
"initial_approval": 4,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_8639_2010",
"source_record_ids": [
"sr_uscis_h1b_datahub_2010_row_045067"
],
"continuing_approval": 1
},
{
"cities": [
"Plano"
],
"states": [
"TX"
],
"fiscal_year": 2013,
"naics_codes": [
"33"
],
"postal_codes": [
"75075"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_7834_2013",
"source_record_ids": [
"sr_uscis_h1b_datahub_2013_row_045373"
],
"continuing_approval": 0
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2017,
"naics_codes": [
"33"
],
"postal_codes": [
"78682"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 3,
"initial_approval": 2,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_7834_2017",
"source_record_ids": [
"sr_uscis_h1b_datahub_2017_row_040417"
],
"continuing_approval": 1
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2019,
"naics_codes": [
"99"
],
"postal_codes": [
"78682"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_1680_2019",
"source_record_ids": [
"sr_uscis_h1b_datahub_2019_row_045355"
],
"continuing_approval": 1
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2021,
"naics_codes": [
"99"
],
"postal_codes": [
"78682"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_7921_2021",
"source_record_ids": [
"sr_uscis_h1b_datahub_2021_row_015066"
],
"continuing_approval": 1
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2016,
"naics_codes": [
"99"
],
"postal_codes": [
"78682"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 0,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_6085_2016",
"source_record_ids": [
"sr_uscis_h1b_datahub_2016_row_044050"
],
"continuing_approval": 1
},
{
"cities": [
"Round Rock"
],
"states": [
"TX"
],
"fiscal_year": 2010,
"naics_codes": [
"54"
],
"postal_codes": [
"78682"
],
"total_denial": 0,
"initial_denial": 0,
"total_approval": 1,
"initial_approval": 1,
"continuing_denial": 0,
"petition_count_id": "petition_count_uscis_h1b_archive_dell_marketing_lp_tax_9188_2010",
"source_record_ids": [
"sr_uscis_h1b_datahub_2010_row_055165"
],
"continuing_approval": 0
}
]
}Addresses
{
"office_addresses": [
{
"address_kind": "office",
"raw_address": "ROUND ROCK TX 78682",
"city": "Round Rock",
"state": "TX",
"postal_code": "78682",
"filing_count": 94,
"case_count": 94,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-03-16",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "ROUND ROCK TX 78282",
"city": "Round Rock",
"state": "TX",
"postal_code": "78282",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-03-24",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "ROUND ROCK TX 78626",
"city": "Round Rock",
"state": "TX",
"postal_code": "78626",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-03-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "office",
"raw_address": "ROUND ROCK TX 78665",
"city": "Round Rock",
"state": "TX",
"postal_code": "78665",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2019-12-03",
"source_ids": [
"dol_oflc_lca"
]
}
],
"worksite_addresses": [
{
"address_kind": "worksite",
"raw_address": "READING MA 1867",
"city": "Reading",
"county": "Reading",
"state": "MA",
"postal_code": "1867",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-03-16",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "LEANDER TX 78641",
"city": "Leander",
"county": "Williamson",
"state": "TX",
"postal_code": "78641",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2022,
"latest_fiscal_year": 2022,
"latest_decision_date": "2022-02-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ROUND ROCK TX 78682",
"city": "Round Rock",
"county": "Williamson",
"state": "TX",
"postal_code": "78682",
"filing_count": 49,
"case_count": 49,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-05-24",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "AUSTIN TX 78753",
"city": "Austin",
"county": "Travis",
"state": "TX",
"postal_code": "78753",
"filing_count": 5,
"case_count": 5,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-05-24",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "AUSTIN TX 78751",
"city": "Austin",
"county": "Travis",
"state": "TX",
"postal_code": "78751",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2021,
"latest_decision_date": "2020-10-02",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ROUND ROCK TX 78664",
"city": "Round Rock",
"county": "Williamson",
"state": "TX",
"postal_code": "78664",
"filing_count": 3,
"case_count": 3,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-05-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "AUSTIN TX 78726",
"city": "Austin",
"county": "Travis",
"state": "TX",
"postal_code": "78726",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-02-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ATLANTA GA 30318",
"city": "Atlanta",
"county": "Fulton",
"state": "GA",
"postal_code": "30318",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-06-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MERCER ISLAND WA 98040",
"city": "Mercer Island",
"county": "King",
"state": "WA",
"postal_code": "98040",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-05-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ROUND ROCK TX 78681",
"city": "Round Rock",
"county": "Williamson",
"state": "TX",
"postal_code": "78681",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-05-14",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PFLUGERVILLE TX 78660",
"city": "Pflugerville",
"county": "Travis",
"state": "TX",
"postal_code": "78660",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021,
"latest_decision_date": "2021-04-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "SEATTLE WA 98104",
"city": "Seattle",
"county": "King",
"state": "WA",
"postal_code": "98104",
"filing_count": 4,
"case_count": 4,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-09-28",
"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": 2018,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-09-23",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ROUND ROCK TX 78665",
"city": "Round Rock",
"county": "Williamson",
"state": "TX",
"postal_code": "78665",
"filing_count": 2,
"case_count": 2,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-08-11",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "AUSTIN TX 78735",
"city": "Austin",
"county": "Travis",
"state": "TX",
"postal_code": "78735",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020,
"latest_decision_date": "2020-02-28",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "REDMOND WA 98052",
"city": "Redmond",
"county": "King",
"state": "WA",
"postal_code": "98052",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-03-18",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ROUNR ROCK TX 78682",
"city": "Rounr Rock",
"county": "Williamson",
"state": "TX",
"postal_code": "78682",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2019,
"latest_decision_date": "2019-01-04",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PLANO TX 75075",
"city": "Plano",
"county": "Collin",
"state": "TX",
"postal_code": "75075",
"filing_count": 6,
"case_count": 6,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2016-08-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "QUINCY MA 02169",
"city": "Quincy",
"county": "Norfolk",
"state": "MA",
"postal_code": "02169",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2016-08-12",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "STAMFORD CT 06901",
"city": "Stamford",
"county": "Fairfield",
"state": "CT",
"postal_code": "06901",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2016-07-28",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MECHANICSVILLE, VA VA 23116",
"city": "Mechanicsville, Va",
"county": "Hannover",
"state": "VA",
"postal_code": "23116",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2016-06-24",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "MECHANICSVILLE VA 23116",
"city": "Mechanicsville",
"county": "Hanover",
"state": "VA",
"postal_code": "23116",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2016-06-20",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "PROVIDENCE RI 02908",
"city": "Providence",
"county": "Providence",
"state": "RI",
"postal_code": "02908",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2016-06-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "ANAHEIM CA 92805",
"city": "Anaheim",
"county": "Orange",
"state": "CA",
"postal_code": "92805",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2016-05-27",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "NASHUA NH 03062",
"city": "Nashua",
"county": "Hillsborough",
"state": "NH",
"postal_code": "03062",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2016-01-08",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "WELLESLEY MA 02481",
"city": "Wellesley",
"county": "Norfolk",
"state": "MA",
"postal_code": "02481",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2015-12-31",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "CHICAGO IL 60626",
"city": "Chicago",
"county": "Cook",
"state": "IL",
"postal_code": "60626",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2015-10-22",
"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": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2015-10-16",
"source_ids": [
"dol_oflc_lca"
]
},
{
"address_kind": "worksite",
"raw_address": "RICHMOND VA 23223",
"city": "Richmond",
"county": "Richmond City",
"state": "VA",
"postal_code": "23223",
"filing_count": 1,
"case_count": 1,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016,
"latest_decision_date": "2015-10-15",
"source_ids": [
"dol_oflc_lca"
]
}
],
"summary": {
"office_address_count": 4,
"worksite_address_count": 29,
"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",
"WA",
"CA",
"CT",
"GA",
"IL",
"MA",
"NH",
"RI",
"VA",
"NC"
],
"cities": [
"Round Rock",
"Plano",
"Austin",
"Seattle",
"Santa Clara",
"Anaheim",
"Stamford",
"Atlanta",
"Chicago",
"Quincy",
"Reading",
"Wellesley",
"Nashua",
"Providence",
"Leander",
"Pflugerville",
"Rounr Rock",
"Mechanicsville",
"Mechanicsville, Va",
"Richmond",
"Mercer Island",
"Redmond",
"Dallas",
"Raleigh",
"Red Rock"
],
"postal_codes": [
"78682",
"75075",
"78753",
"78751",
"98104",
"78664",
"95054",
"78726",
"78665",
"92805",
"06901",
"30318",
"60626",
"02169",
"1867",
"02481",
"03062",
"02908",
"78735",
"78641",
"78660",
"75024",
"78681",
"23116",
"23223",
"98040",
"98052",
"27602",
"27622",
"75204",
"75682",
"78662"
],
"top_markets": [
{
"city": "Round Rock",
"state": "TX",
"postal_code": "78682",
"lca_count": 49,
"role_title_count": 27,
"wage_low_min": 78750,
"wage_high_max": 222525,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2021
},
{
"city": "Plano",
"state": "TX",
"postal_code": "75075",
"lca_count": 6,
"role_title_count": 4,
"wage_low_min": 85827,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016
},
{
"city": "Austin",
"state": "TX",
"postal_code": "78753",
"lca_count": 5,
"role_title_count": 3,
"wage_low_min": 70000,
"wage_high_max": 137000,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2021
},
{
"city": "Austin",
"state": "TX",
"postal_code": "78751",
"lca_count": 4,
"role_title_count": 1,
"wage_low_min": 126000,
"wage_high_max": 126000,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2021
},
{
"city": "Seattle",
"state": "WA",
"postal_code": "98104",
"lca_count": 4,
"role_title_count": 3,
"wage_low_min": 80000,
"wage_high_max": 135214,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2020
},
{
"city": "Round Rock",
"state": "TX",
"postal_code": "78664",
"lca_count": 3,
"role_title_count": 2,
"wage_low_min": 115000,
"wage_high_max": 131500,
"first_fiscal_year": 2019,
"latest_fiscal_year": 2021
},
{
"city": "Santa Clara",
"state": "CA",
"postal_code": "95054",
"lca_count": 2,
"role_title_count": 2,
"wage_low_min": 115000,
"wage_high_max": 130000,
"first_fiscal_year": 2018,
"latest_fiscal_year": 2020
},
{
"city": "Austin",
"state": "TX",
"postal_code": "78726",
"lca_count": 2,
"role_title_count": 1,
"wage_low_min": 127000,
"wage_high_max": 127000,
"first_fiscal_year": 2021,
"latest_fiscal_year": 2021
},
{
"city": "Round Rock",
"state": "TX",
"postal_code": "78665",
"lca_count": 2,
"role_title_count": 2,
"wage_low_min": 110000,
"wage_high_max": 147662,
"first_fiscal_year": 2020,
"latest_fiscal_year": 2020
},
{
"city": "Anaheim",
"state": "CA",
"postal_code": "92805",
"lca_count": 1,
"role_title_count": 1,
"wage_low_min": 79664,
"wage_high_max": 0,
"first_fiscal_year": 2016,
"latest_fiscal_year": 2016
}
]
}Industry
{
"naics_codes": [
"42343",
"33",
"42",
"44",
"52",
"54",
"99"
],
"naics_breakdown": [
{
"value": "42343",
"filing_count": 79,
"first_fiscal_year": 2017,
"latest_fiscal_year": 2022,
"source": "dol_oflc_lca"
}
]
}Wage Summary
{
"annualized_low_min": 70000,
"annualized_high_max": 222525,
"annualized_low_avg": 115929.195876289
}Trend
[
{
"fiscal_year": 2016,
"quarter": "Q2",
"lca_count": 18,
"case_count": 18,
"role_title_count": 11,
"worksite_count": 13,
"wage_low_min": 72000,
"wage_high_max": 0,
"wage_low_avg": 92073.3333333333
},
{
"fiscal_year": 2017,
"quarter": "Q2",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 1,
"wage_low_min": 100000,
"wage_high_max": 0,
"wage_low_avg": 101000
},
{
"fiscal_year": 2018,
"quarter": "Q2",
"lca_count": 6,
"case_count": 6,
"role_title_count": 6,
"worksite_count": 3,
"wage_low_min": 80000,
"wage_high_max": 0,
"wage_low_avg": 109865.333333333
},
{
"fiscal_year": 2019,
"quarter": "Q2",
"lca_count": 14,
"case_count": 14,
"role_title_count": 13,
"worksite_count": 4,
"wage_low_min": 78750,
"wage_high_max": 149000,
"wage_low_avg": 119093.428571429
},
{
"fiscal_year": 2020,
"quarter": "Q1",
"lca_count": 5,
"case_count": 5,
"role_title_count": 4,
"worksite_count": 2,
"wage_low_min": 110000,
"wage_high_max": 160000,
"wage_low_avg": 128342.4
},
{
"fiscal_year": 2020,
"quarter": "Q2",
"lca_count": 28,
"case_count": 28,
"role_title_count": 16,
"worksite_count": 4,
"wage_low_min": 70000,
"wage_high_max": 150000,
"wage_low_avg": 117849.928571429
},
{
"fiscal_year": 2020,
"quarter": "Q3",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 132000,
"wage_high_max": 222525,
"wage_low_avg": 177262.5
},
{
"fiscal_year": 2020,
"quarter": "Q4",
"lca_count": 4,
"case_count": 4,
"role_title_count": 4,
"worksite_count": 4,
"wage_low_min": 126000,
"wage_high_max": 147662,
"wage_low_avg": 134251
},
{
"fiscal_year": 2021,
"quarter": "Q1",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 126000,
"wage_high_max": 140463,
"wage_low_avg": 133231.5
},
{
"fiscal_year": 2021,
"quarter": "Q2",
"lca_count": 3,
"case_count": 3,
"role_title_count": 3,
"worksite_count": 3,
"wage_low_min": 126000,
"wage_high_max": 140463,
"wage_low_avg": 131154.333333333
},
{
"fiscal_year": 2021,
"quarter": "Q3",
"lca_count": 11,
"case_count": 11,
"role_title_count": 11,
"worksite_count": 9,
"wage_low_min": 94377,
"wage_high_max": 151100,
"wage_low_avg": 121140.272727273
},
{
"fiscal_year": 2022,
"quarter": "Q2",
"lca_count": 2,
"case_count": 2,
"role_title_count": 2,
"worksite_count": 2,
"wage_low_min": 111404,
"wage_high_max": 122400,
"wage_low_avg": 116902
}
]Links
{
"roles": "/v1/roles?company=Dell%20Marketing%20LP",
"wages": "/v1/wages?company=Dell%20Marketing%20LP",
"trends": "/v1/trends?company=Dell%20Marketing%20LP"
}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=dell+marketing+lp&limit=5JSON