List of US medical practices: 187,114, 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 medical practices:

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 = 'Medical Practices'
""").write_csv("us_medical_practices_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 176,627 whose headquarters state we know (94.4%), 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, business consulting companies, hospitals and health care companies, IT services and consulting companies, advertising companies, software companies, financial services companies, retail companies, technology and internet companies, restaurants. Every industry, state and size: the free list of US companies.