Companies data straight from the Employbl production database.
The data comes from a MySQL database and a spreadsheet I've been collecting for many years. All info is available across the free and open internet. For the most part company locations default to the office location of the company's Bay Area location, because that's what I was most interested in :)
Query used to generate the companies.csv file:
select c.id as 'Employbl Company ID',
c.name as 'Company Name',
c.website as 'Website',
c.street as 'Address 1',
c.city as 'City',
c.state as 'State',
c.zip as 'Zip',
c.latitude as 'Latitude',
c.longitude as 'Longitude',
c.description as 'Company Description',
c.image_url as 'Thumbnail URL'
from companies c
where c.deleted_at is null;
To query for companies with a given tag:
select c.id as 'Employbl Company ID',
c.name as 'Company Name',
c.website as 'Website',
c.street as 'Address 1',
c.city as 'City',
c.state as 'State',
c.zip as 'Zip',
c.latitude as 'Latitude',
c.longitude as 'Longitude',
c.description as 'Company Description',
c.image_url as 'Thumbnail URL'
from companies c
join taggables t on t.taggable_id = c.id and t.taggable_type = 'App\\Company' and t.tag_id = 40714
where c.deleted_at is null
group by c.id;
Side note: we're using the laravel/tags PHP package by @spatie (postcard coming to y'all soon!). These queries are mostly here to help me pull the latest data to update the data. If people start contributing we can set up a two-way sync ;)
This is an open source project. The company location in most cases is the location of the company's Bay Area office. We have a more complex table structure on the Employbl website (which is not open source) to account for multiple company locations. If you're interested in using this data or would like to see the project succeed there are a couple ways you can help out:
One quick way to help is to open a pull request and add to the company dataset. All of the data here remains open source. Edits can be made easily by downloading the CSV files from this repo and uploading them to Excel, Number or Airtable -- whatever your spreadsheet viewer of choice is. We're looking to add tech and startup companies in the United States. Our definition of a tech or startup company is pretty broad. Basically if the company employs people to sit in front of computers all day they count. New additions will be judged on a case by case basis. Please enter the data cleanly, no one likes messy data :)
If you work at a tech company or a startup make sure your company is on the list! We use this data to build out company profiles on Employbl dot com. Job seekers can also use this data to seek out new opportunities in the tech industry.
We're open to making more data accessible to candidates and job seekers. Maybe that means collecting richer information about companies like all their office locations or all their job listings. Maybe it means collecting articles about the company to provide more insight. It could be that the depth doesn't matter and it's more important to collect the most startups and tech companies possible. We're still figuring it out tbh. Our mission is to make this information accessible and build a system that helps candidates get jobs at tech companies in an equitable way.
If you like the project or just want to say "hi" you can tweet me or email me directly - [email protected].