List of US oil and gas companies: 35,487, 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 oil and gas 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 = 'Oil and Gas'
""").write_csv("us_oil_and_gas_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 25,336 whose headquarters state we know (71.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, 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, wellness and fitness companies, individual and family services companies, marketing companies, training and coaching companies, hospitality companies, law firms, insurance companies, consumer services companies, design companies, food and beverage companies, accounting firms, entertainment companies, media production companies, staffing and recruiting agencies, mental health care providers, automotive companies, event services companies, legal services companies, apparel and fashion retailers, manufacturing companies, architecture and planning firms, spectator sports companies, facilities services companies, information technology and services companies, trucking companies, environmental services companies, telecommunications companies. Every industry, state and size: the free list of US companies.