Y-combinator Listed Companies
Companies and their information listed on Y-combinator
@kaggle.thedevastator_1000_companies_that_use_laravel
Companies and their information listed on Y-combinator
@kaggle.thedevastator_1000_companies_that_use_laravel
This dataset aims to alow for analysis on the y-combinator listed companies.
There are many ways to use this dataset. Some possible ways include:
- Finding companies that use Laravel in a particular industry or location
- Comparing the investment received by companies that use Laravel to other companies
- Analyzing the descriptions of companies that use Laravel to learn about what they do
- Website column can be used to create a list of companies that use Laravel and reach out to them as potential customers
- Descriptors column can be used to create targeted ads for people who are interested in PHP development
- Headquarters_location column to find Laravel developers in specific areas
The dataset was originally posted here
License
> License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
> No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.
File: companies-that-use-laravel.csv
File: companies.csv
File: san-francisco-tech-companies-06-30-2021.csv
| Column name | Description |
|---|---|
| max | The maximum number of employees at the company. (Numeric) |
| companyname | The name of the company. (String) |
| min_employees | The minimum number of employees at the company. (Numeric) |
| max_employees | The maximum number of employees at the company. (Numeric) |
| website | The company's website. (String) |
| description | A description of the company. (String) |
| headquarters_location | The location of the company's headquarters. (String) |
| year_founded | The year the company was founded. (Numeric) |
| total_investment | The total investment the company has received. (Numeric) |
| descriptors | A list of descriptors for the company. (String) |
File: silicon-valley-companies.csv
File: tech-companies-in-oakland-06-20-2021.csv
| Column name | Description |
|---|---|
| companyname | The name of the company. (String) |
| min_employees | The minimum number of employees at the company. (Numeric) |
| max_employees | The maximum number of employees at the company. (Numeric) |
| website | The company's website. (String) |
| description | A description of the company. (String) |
| headquarters_location | The location of the company's headquarters. (String) |
| year_founded | The year the company was founded. (Numeric) |
| total_investment | The total investment the company has received. (Numeric) |
| descriptors | A list of descriptors for the company. (String) |
File: venture-capital.csv
File: y-combinator-companies.csv
CREATE TABLE companies (
"employbl_company_id" BIGINT,
"company_name" VARCHAR,
"website" VARCHAR,
"address_1" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"company_description" VARCHAR,
"thumbnail_url" VARCHAR
);CREATE TABLE companies_that_use_laravel (
"employbl_company_id" BIGINT,
"company_name" VARCHAR,
"website" VARCHAR,
"address_1" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"company_description" VARCHAR,
"thumbnail_url" VARCHAR
);CREATE TABLE san_francisco_tech_companies_06_30_2021 (
"company_id" BIGINT,
"max" VARCHAR,
"companyname" VARCHAR,
"min_employees" BIGINT,
"max_employees" BIGINT,
"website" VARCHAR,
"description" VARCHAR,
"headquarters_location" VARCHAR,
"year_founded" DOUBLE,
"total_investment" DOUBLE,
"descriptors" VARCHAR
);CREATE TABLE silicon_valley_companies (
"employbl_company_id" BIGINT,
"company_name" VARCHAR,
"website" VARCHAR,
"address_1" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"company_description" VARCHAR,
"thumbnail_url" VARCHAR
);CREATE TABLE tech_companies_in_oakland_06_20_2021 (
"company_id" BIGINT,
"companyname" VARCHAR,
"min_employees" BIGINT,
"max_employees" BIGINT,
"website" VARCHAR,
"description" VARCHAR,
"headquarters_location" VARCHAR,
"year_founded" DOUBLE,
"total_investment" DOUBLE,
"descriptors" VARCHAR
);CREATE TABLE venture_capital (
"employbl_company_id" BIGINT,
"company_name" VARCHAR,
"website" VARCHAR,
"address_1" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"company_description" VARCHAR,
"thumbnail_url" VARCHAR
);CREATE TABLE y_combinator_companies (
"employbl_company_id" BIGINT,
"company_name" VARCHAR,
"website" VARCHAR,
"address_1" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"zip" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"company_description" VARCHAR,
"thumbnail_url" VARCHAR
);Anyone who has the link will be able to view this.