Free list of US companies to download, by state, industry and size
Datacircle gives away a list of 1,748,139 U.S. companies of 11 to 500 employees, free with a work email: each company's LinkedIn page, website, industry, employee range, headquarters address and founding year, in one Parquet file.
Below, how the 6,700,867 U.S. companies of our October 2026 release split by size, state and industry, counted from the file itself.
Download it
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. From the API, GET /files/ lists it as us_10m. Then keep only what you need:
import duckdb
duckdb.sql("""
select NAME, URL, HQ_CITY, EMPLOYEE_COUNT_RANGE
from 'us_smb_mid_market_companies.parquet'
where HQ_STATE_CODE = 'TX' and LINKEDIN_INDUSTRY = 'Software Development'
""").write_csv("texas_software_companies.csv")The whole file, people included: the free US B2B leads dataset. The owners of those companies, with an email or a phone: build a free B2B leads list with SQL.
US companies by size
All 6,700,867 companies of the 50M+ dataset, by the employee range on their LinkedIn page. The free list holds 1,748,139 companies of 11 to 500 employees; all 6,700,867 unlock once 3 people you invited sign up.
| Employees | Companies | Share |
|---|---|---|
| 1 | 2,729,400 | 40.7% |
| 2-10 | 1,737,911 | 25.9% |
| 11-50 | 1,538,569 | 23.0% |
| 51-200 | 449,063 | 6.7% |
| 201-500 | 125,905 | 1.9% |
| 501-1,000 | 49,313 | 0.7% |
| 1,001-5,000 | 42,828 | 0.6% |
| 5,001-10,000 | 9,445 | 0.1% |
| 10,001+ | 18,433 | 0.3% |
US companies by state
The 4,429,454 companies whose headquarters state we know (66.1%), all sizes and 11 to 500 employees. Both columns count the 50M+ dataset's companies (2,113,537 of 11 to 500 employees); the free list holds 1,748,139 of that size.
| State | All sizes | 11 to 500 employees |
|---|---|---|
| California | 643,538 | 220,297 |
| Texas | 383,752 | 131,910 |
| Florida | 331,578 | 105,840 |
| New York | 319,524 | 110,317 |
| Illinois | 167,891 | 59,413 |
| Pennsylvania | 146,333 | 51,829 |
| Ohio | 137,095 | 50,947 |
| Georgia | 135,706 | 43,123 |
| New Jersey | 125,782 | 46,178 |
| North Carolina | 124,218 | 38,679 |
| Michigan | 119,321 | 42,461 |
| Washington | 118,801 | 39,764 |
| Massachusetts | 114,497 | 40,971 |
| Colorado | 107,377 | 32,261 |
| Virginia | 107,326 | 37,901 |
| Arizona | 87,400 | 28,397 |
| Tennessee | 84,406 | 33,565 |
| Maryland | 75,268 | 26,144 |
| Oregon | 73,454 | 24,839 |
| Minnesota | 71,735 | 25,248 |
| Wisconsin | 68,793 | 24,660 |
| Missouri | 68,142 | 23,967 |
| Indiana | 67,615 | 24,526 |
| South Carolina | 54,945 | 17,507 |
| Connecticut | 48,766 | 17,336 |
| Utah | 47,046 | 16,903 |
| Alabama | 44,648 | 15,810 |
| Louisiana | 42,886 | 15,598 |
| Nevada | 40,763 | 13,420 |
| Iowa | 39,573 | 16,488 |
| Oklahoma | 38,702 | 13,429 |
| Kansas | 37,001 | 13,939 |
| Kentucky | 36,447 | 13,266 |
| District of Columbia | 28,120 | 9,822 |
| Arkansas | 27,379 | 9,411 |
| Delaware | 22,870 | 9,323 |
| Mississippi | 22,435 | 7,945 |
| Nebraska | 22,367 | 7,848 |
| Idaho | 22,232 | 6,965 |
| New Hampshire | 21,246 | 7,421 |
| New Mexico | 19,503 | 6,425 |
| Maine | 18,098 | 6,214 |
| Hawaii | 16,511 | 6,037 |
| Wyoming | 15,841 | 5,400 |
| Montana | 15,779 | 4,843 |
| Rhode Island | 14,473 | 5,210 |
| West Virginia | 12,166 | 4,296 |
| Alaska | 11,102 | 3,168 |
| Vermont | 10,995 | 3,839 |
| South Dakota | 9,441 | 3,340 |
| North Dakota | 8,443 | 3,303 |
| Puerto Rico | 108 | 37 |
| Guam | 16 | 7 |
A state's page has its companies by city, industry and size, and 20 of them picked at random. The state and industry pages leave out the 13,083 companies abroad whose LinkedIn address gives a region code that is also a state's, Perth in Western Australia as WA the largest, which this page's tables count.
US companies by industry: the top 30
LinkedIn's industry, filled for 5,892,571 companies across 494 industries. The largest, Construction, holds 270,515.
| Industry | All sizes | 11 to 500 employees |
|---|---|---|
| Construction | 270,515 | 110,832 |
| Real Estate | 192,553 | 56,625 |
| Medical Practices | 187,218 | 53,008 |
| Business Consulting and Services | 187,146 | 30,163 |
| Hospitals and Health Care | 170,955 | 69,378 |
| IT Services and IT Consulting | 167,778 | 61,277 |
| Advertising Services | 158,574 | 39,939 |
| Software Development | 143,862 | 52,041 |
| Financial Services | 136,657 | 45,350 |
| Retail | 135,125 | 48,926 |
| Non-profit Organizations | 123,878 | 40,644 |
| Technology, Information and Internet | 123,258 | 32,609 |
| Restaurants | 122,786 | 69,342 |
| Wellness and Fitness Services | 106,684 | 28,647 |
| Individual and Family Services | 102,419 | 36,687 |
| Marketing Services | 87,977 | 13,286 |
| Professional Training and Coaching | 72,150 | 8,161 |
| Hospitality | 70,840 | 34,593 |
| Law Practice | 64,700 | 17,789 |
| Insurance | 62,459 | 22,040 |
| Consumer Services | 62,106 | 16,531 |
| Design Services | 61,953 | 7,998 |
| Food and Beverage Services | 60,595 | 22,478 |
| Accounting | 59,372 | 14,210 |
| Entertainment Providers | 57,900 | 15,358 |
| Media Production | 54,180 | 7,642 |
| Higher Education | 52,895 | 26,255 |
| Education Administration Programs | 52,331 | 24,784 |
| Education | 51,160 | 17,368 |
| Staffing and Recruiting | 50,809 | 16,843 |
One page each, with the companies by state and size and 20 of them picked at random: construction companies, real estate companies, medical practices, 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 column
The free list's columns, with their fill rate in the October 2026 release. A field is filled only where we have it: nothing is guessed.
| Field | Type | Nullable | Fill rate | Description |
|---|---|---|---|---|
LINKEDIN_ID |
String | No | 100% | Unique LinkedIn numeric ID for the company |
LINKEDIN_URL |
String | No | 100% | Full LinkedIn company page URL (https://www.linkedin.com/company/...) |
NAME |
String | No | 100% | Company name (acronyms normalized: LLC, PLLC, LLP, DBA, HVAC, USA) |
HEADLINE |
String | Yes | 43.26% | Company tagline/headline from LinkedIn |
ABOUT |
String | Yes | 64.21% | Company description/about section |
FOUNDED |
UInt16 | Yes | 46.46% | Year the company was founded (validated: 1600–current year) |
LOGO_URL |
String | No | 100% | URL to company logo image |
LINKEDIN_FOLLOWERS |
UInt32 | No | 100% | Number of LinkedIn followers |
IS_CLAIMED_PAGE |
Bool | No | 100% | Whether the LinkedIn page is claimed (always true - unclaimed pages are filtered out) |
EMPLOYEE_COUNT_RANGE |
String | No | 100% | Employee count bucket. 10M+ dataset values: 11-50, 51-200, 201-500 |
HQ_CITY |
String | Yes | 74.80% | Headquarters city |
HQ_STATE_CODE |
String | Yes | 73.14% | Headquarters US state code (e.g. CA, NY) |
HQ_STATE_NAME |
String | No | 72.94% | Headquarters US state name (e.g. California, New York). Empty string when unknown. |
HQ_POSTCODE |
String | Yes | 58.48% | Headquarters postal/zip code |
HQ_STREET |
String | Yes | 54.17% | Headquarters street address |
LINKEDIN_INDUSTRY |
String | Yes | 91.34% | LinkedIn industry classification |
TYPE |
String | Yes | 64.58% | Entity type: Privately Held, Public Company, Partnership, Self-Owned |
URL |
String | Yes | 79.47% | Company website URL |
UPDATED_AT |
DateTime | No | 100% | When the record was last refreshed |
Every field of both files: Dataset fields in the docs. A niche already cut, as a CSV: the free lists.
Questions
Where can I download a free list of US companies?
From Datacircle, free with a work email: 1,748,139 US companies of 11 to 500 employees, each with its LinkedIn page, website, industry, size and headquarters, in one Parquet file. Every size, 6,700,867 companies, unlocks once 3 people you invited sign up.
How many US companies have a LinkedIn page?
Our October 2026 release holds 6,700,867 US companies with a claimed LinkedIn page. 2,729,400 of them list 1 employee and 1,737,911 2 to 10; 2,113,537 have 11 to 500.
Which state has the most companies?
California: 643,538 of the 4,429,454 companies whose headquarters state we know (14.5%), then Texas (383,752) and Florida (331,578).
Can I get only one state or one industry?
Download the file and filter it: a few lines of DuckDB, shown on this page. Or take one of our ready-made free lists, each a CSV of one niche.
Does the list include emails and phone numbers?
The companies file holds each company's website and headquarters address, not a phone. The people file next to it, in the same download, holds work emails and mobile phones for the people at these companies, where we have them.
Sign up with your work email: your API key and a $5 credit that never expires are on your dashboard, with the free 10M+ U.S. B2B leads dataset.
Sign up