List of US advertising companies: 158,240, by state and size

Sign up with your work email: the 10M+ U.S. dataset is on your dashboard, one zip with the companies and the people who work there. Keep the advertising companies:

import duckdb
duckdb.sql("""
  select NAME, URL, HQ_CITY, HQ_STATE_CODE, EMPLOYEE_COUNT_RANGE, FOUNDED
  from 'us_smb_mid_market_companies.parquet'
  where LINKEDIN_INDUSTRY = 'Advertising Services'
""").write_csv("us_advertising_services_companies.csv")

Every column of the file and its fill rate: the free list of US companies. The people's columns: the free US B2B leads dataset.

By the employee range on their LinkedIn page. The free file holds the companies of 11 to 500 employees; every size, in the 50M+ dataset, unlocks once 3 people you invited sign up.

The 90,235 whose headquarters state we know (57.0%), all sizes, and how many of each state the free file holds.

Rows of the free file with a website of their own, picked at random, as the file holds them.

construction companies, real estate companies, medical practices, business consulting companies, hospitals and health care companies, IT services and consulting companies, software companies, financial services companies, retail companies, technology and internet companies, restaurants. Every industry, state and size: the free list of US companies.