List of companies in Washington, D.C.: 27,903, by 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 Washington, D.C.'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 = 'DC'
""").write_csv("dc_companies.csv")

The people: where STATE_CODE = 'DC' 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.

Left out of this page's numbers: 217 companies of Caracas and Bogotá, capital districts too, whose LinkedIn address gives the region's code, DC. The files hold them under District of Columbia; their HQ_CITY tells them apart.

The ten largest LinkedIn industries in Washington, D.C., 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.

California, 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, 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.