List of companies in California: 643,538, by city, industry 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. Keep California's:

import duckdb
duckdb.sql("""
  select NAME, URL, HQ_STREET, HQ_CITY, LINKEDIN_INDUSTRY, EMPLOYEE_COUNT_RANGE
  from 'us_smb_mid_market_companies.parquet'
  where HQ_STATE_CODE = 'CA'
""").write_csv("ca_companies.csv")

The people: where STATE_CODE = 'CA' in us_smb_mid_market_persons.parquet. Every column of the companies file: the free list of US companies. The people's: the free US B2B leads dataset.

The ten cities with the most headquarters, all sizes, as LinkedIn gives them (a suburb is its own city).

The ten largest LinkedIn industries in California, all sizes, and how many of each the free file holds.

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.

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

Texas, Florida, New York, Illinois, Pennsylvania, Ohio, Georgia, New Jersey, North Carolina, Michigan, Massachusetts, Washington State, Colorado, Virginia, Arizona, Tennessee, Maryland, Oregon, Minnesota, Wisconsin, Missouri, Indiana, South Carolina, Connecticut, Utah, Alabama, Louisiana, Nevada, Iowa, Oklahoma, Kansas, Kentucky, Washington, D.C., Arkansas, Delaware, Nebraska, Idaho, Mississippi, New Hampshire, New Mexico, Maine, Hawaii, Wyoming, Montana, Rhode Island, West Virginia, Alaska, Vermont, South Dakota, North Dakota. Every state, industry and size: the free list of US companies.