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

Home / Companies / Ipsos Public Affairs, LLC

Ipsos Public Affairs, 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.

EmployerLCA filingsRole titlesWorksitesCoverageUSCIS approvalsTop roleSourcesOpen
Ipsos Public Affairs, LLC
IPSOS PUBLIC AFFAIRS LLC
642FY2018 to FY2021
Latest decision 2021-07-19
2PUBLIC RELATIONS AND MARKETING COORDINATOR
3 filings
dol_oflc_lca, uscis_h1b_employer_data_hubProfile

Activity summary

LCA filings6
Certified LCAs6
Denied LCAs0
Role titles4
Worksites2
Latest decision2021-07-19
USCIS approvals2
USCIS denials1

Aliases and source names

AliasesSource NamesSources
IPSOS PUBLIC AFFAIRS LLCIpsos Public Affairs, LLC, IPSOS PUBLIC AFFAIRS LLCdol_oflc_lca, uscis_h1b_employer_data_hub

Top roles

TitleSOCLCA filingsLow wage minHigh wage max
PUBLIC RELATIONS AND MARKETING COORDINATOR27-3031
PUBLIC RELATIONS SPECIALISTS
3$62,000$62,000
ASSISTANT STATISTICIAN43-91111$60,000$0
Associate Statistician15-2041.00
Statisticians
1$78,042$78,042
Machine Learning Engineer15-1111.00
Computer and Information Research Scientists
1$123,000$123,000

Top markets

CityStatePostal CodeLCA CountRole Title CountWage Low MinWage High MaxFirst Fiscal YearLatest Fiscal Year
WashingtonDC200065360,00078,0422,0182,021
New YorkNY1001011123,000123,0002,0202,020

Full company payload

Company IDcompany:ipsos public affairs
NameIpsos Public Affairs, LLC
Normalized Nameipsos public affairs
Source Company Idscompany_dol_oflc_lca_ipsos_public_affairs_llc, company_uscis_h1b_datahub_ipsos_public_affairs_llc_tax_1602
Source NamesIpsos Public Affairs, LLC, IPSOS PUBLIC AFFAIRS LLC
AliasesIPSOS PUBLIC AFFAIRS LLC
Sourcesdol_oflc_lca, uscis_h1b_employer_data_hub
Names
{
  "source_names": [
    "Ipsos Public Affairs, LLC",
    "IPSOS PUBLIC AFFAIRS LLC"
  ],
  "dba_names": [],
  "name_variants": [
    {
      "value": "IPSOS PUBLIC AFFAIRS LLC",
      "filing_count": 5,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Ipsos Public Affairs, LLC",
      "filing_count": 1,
      "first_fiscal_year": 2021,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "IPSOS PUBLIC AFFAIRS LLC",
      "source": "uscis_h1b_employer_data_hub"
    }
  ]
}
Identifiers
[
  {
    "identifier_type": "tax_id_last_four",
    "identifier_value": "1602",
    "source": "uscis_h1b_employer_data_hub"
  }
]
LCA Activity
{
  "lca_count": 6,
  "case_count": 6,
  "role_title_count": 4,
  "worksite_count": 2,
  "total_workers": 6,
  "first_fiscal_year": 2018,
  "first_received_date": "2018-03-20",
  "latest_fiscal_year": 2021,
  "latest_decision_date": "2021-07-19",
  "certified_count": 6,
  "denied_count": 0,
  "status_breakdown": [
    {
      "value": "CERTIFIED",
      "filing_count": 4,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2019,
      "source": "dol_oflc_lca"
    },
    {
      "value": "Certified",
      "filing_count": 2,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "visa_class_breakdown": [
    {
      "value": "H-1B",
      "filing_count": 6,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ],
  "full_time_position_breakdown": [
    {
      "value": "Y",
      "filing_count": 6,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    }
  ]
}
Petition Activity
{
  "initial_approval": 0,
  "initial_denial": 0,
  "continuing_approval": 0,
  "continuing_denial": 0,
  "total_approval": 2,
  "total_denial": 1,
  "fiscal_years": [
    "2019",
    "2021"
  ],
  "year_metrics": [
    {
      "cities": [
        "Chicago",
        "Norwalk"
      ],
      "states": [
        "CT",
        "IL"
      ],
      "fiscal_year": 2019,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "06851",
        "60606"
      ],
      "total_denial": 1,
      "initial_denial": 1,
      "total_approval": 1,
      "initial_approval": 1,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ipsos_public_affairs_llc_tax_1602_2019",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2019_row_022807",
        "sr_uscis_h1b_datahub_2019_row_022808"
      ],
      "continuing_approval": 0
    },
    {
      "cities": [
        "Norwalk"
      ],
      "states": [
        "CT"
      ],
      "fiscal_year": 2021,
      "naics_codes": [
        "54"
      ],
      "postal_codes": [
        "06851"
      ],
      "total_denial": 0,
      "initial_denial": 0,
      "total_approval": 1,
      "initial_approval": 0,
      "continuing_denial": 0,
      "petition_count_id": "petition_count_uscis_h1b_archive_ipsos_public_affairs_llc_tax_1602_2021",
      "source_record_ids": [
        "sr_uscis_h1b_datahub_2021_row_027320"
      ],
      "continuing_approval": 1
    }
  ]
}
Addresses
{
  "office_addresses": [
    {
      "address_kind": "office",
      "raw_address": "NORWALK CT 6851",
      "city": "Norwalk",
      "state": "CT",
      "postal_code": "6851",
      "filing_count": 2,
      "case_count": 2,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-07-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "CHICAGO IL 60606",
      "city": "Chicago",
      "state": "IL",
      "postal_code": "60606",
      "filing_count": 3,
      "case_count": 3,
      "first_fiscal_year": 2019,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-02-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "office",
      "raw_address": "NORWALK CT 06851",
      "city": "Norwalk",
      "state": "CT",
      "postal_code": "06851",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2018,
      "latest_decision_date": "2018-03-26",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "worksite_addresses": [
    {
      "address_kind": "worksite",
      "raw_address": "WASHINGTON DC 20006",
      "city": "Washington",
      "county": "District Of Columbia",
      "state": "DC",
      "postal_code": "20006",
      "filing_count": 5,
      "case_count": 5,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "latest_decision_date": "2021-07-19",
      "source_ids": [
        "dol_oflc_lca"
      ]
    },
    {
      "address_kind": "worksite",
      "raw_address": "NEW YORK NY 10010",
      "city": "New York",
      "county": "New York",
      "state": "NY",
      "postal_code": "10010",
      "filing_count": 1,
      "case_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "latest_decision_date": "2020-02-21",
      "source_ids": [
        "dol_oflc_lca"
      ]
    }
  ],
  "summary": {
    "office_address_count": 3,
    "worksite_address_count": 2,
    "has_street_address_evidence": true,
    "caveat": "LCA employer/worksite addresses are capped filing evidence scoped to matched source company names and should not be treated as verified headquarters without external validation."
  }
}
Geography
{
  "states": [
    "DC",
    "NY",
    "CT",
    "IL"
  ],
  "cities": [
    "Washington",
    "New York",
    "Chicago",
    "Norwalk"
  ],
  "postal_codes": [
    "20006",
    "10010",
    "06851",
    "60606"
  ],
  "top_markets": [
    {
      "city": "Washington",
      "state": "DC",
      "postal_code": "20006",
      "lca_count": 5,
      "role_title_count": 3,
      "wage_low_min": 60000,
      "wage_high_max": 78042,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021
    },
    {
      "city": "New York",
      "state": "NY",
      "postal_code": "10010",
      "lca_count": 1,
      "role_title_count": 1,
      "wage_low_min": 123000,
      "wage_high_max": 123000,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020
    }
  ]
}
Industry
{
  "naics_codes": [
    "541910",
    "54"
  ],
  "naics_breakdown": [
    {
      "value": "541910",
      "filing_count": 5,
      "first_fiscal_year": 2018,
      "latest_fiscal_year": 2021,
      "source": "dol_oflc_lca"
    },
    {
      "value": "541613",
      "filing_count": 1,
      "first_fiscal_year": 2020,
      "latest_fiscal_year": 2020,
      "source": "dol_oflc_lca"
    }
  ]
}
Wage Summary
{
  "annualized_low_min": 60000,
  "annualized_high_max": 123000,
  "annualized_low_avg": 74507
}
Trend
[
  {
    "fiscal_year": 2018,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 60000,
    "wage_high_max": 0,
    "wage_low_avg": 60000
  },
  {
    "fiscal_year": 2019,
    "quarter": "Q2",
    "lca_count": 3,
    "case_count": 3,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 62000,
    "wage_high_max": 62000,
    "wage_low_avg": 62000
  },
  {
    "fiscal_year": 2020,
    "quarter": "Q2",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 123000,
    "wage_high_max": 123000,
    "wage_low_avg": 123000
  },
  {
    "fiscal_year": 2021,
    "quarter": "Q4",
    "lca_count": 1,
    "case_count": 1,
    "role_title_count": 1,
    "worksite_count": 1,
    "wage_low_min": 78042,
    "wage_high_max": 78042,
    "wage_low_avg": 78042
  }
]
Links
{
  "roles": "/v1/roles?company=Ipsos%20Public%20Affairs%2C%20LLC",
  "wages": "/v1/wages?company=Ipsos%20Public%20Affairs%2C%20LLC",
  "trends": "/v1/trends?company=Ipsos%20Public%20Affairs%2C%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=ipsos+public+affairs+llc&limit=5JSON