HackerNews Who Is Hiring Listings 2018-2023
Dataset job listings at Ask HN: Who is hiring from 2018 to 2023 (July)
@kaggle.kidrulit_hackernews_who_is_hiring_listings_from_2018
Dataset job listings at Ask HN: Who is hiring from 2018 to 2023 (July)
@kaggle.kidrulit_hackernews_who_is_hiring_listings_from_2018
The dataset being utilized encompasses a comprehensive range of job postings from the HackerNews community, a dynamic platform renowned for its focus on technology, computer science, and entrepreneurship. This dataset spans from 2018 to June 2023, providing a five-year window into the evolving trends and preferences within this vibrant community.
The job description have the following columns:
companyName
: Name of the company (Text)location
: Location of the position (Text)location_city
: City of the position based on the location, can be null (Array of Text)location_country
: Country of the position based on the location, can be null ( Array of Text)is_remote
: Indicates whether the position is remote or not (Boolean)is_remote_country_specific
: Indicates if remote work is constrained by a specific country (Boolean)legalAuthorizationRequirements
: Legal requirements for the position (Text)time_zone_requirements
: Indicates if there are any overlapping time zone requirements for the position (Boolean)is_full_time
: Indicates if the position requires full-time employment (Boolean)is_part_time
: Indicates if the position requires part-time employment (Boolean)is_contractor
: Indicates if the position requires contractor employment (Boolean)subindustry
: Company subindustry within the technology sector, identified from the position description (Text). Please note the field can't be null.companyDescription
: One or two-sentence description of the company (Text)position
: Position title (Text)languageStack
: Array of programming languages required for the position (Array of Text)companyWebsite
: Company's website (URL)emailToContact
: Email of point of contact (Text)CREATE TABLE jobs_2018_2023 (
"id" BIGINT,
"date" TIMESTAMP,
"hn_hiring_month" VARCHAR,
"hn_hiring_year" BIGINT,
"hn_user_link" VARCHAR,
"job_description" VARCHAR
);
CREATE TABLE parsed_jobs_2018_2023 (
"id" BIGINT,
"job_id" BIGINT,
"data" VARCHAR,
"company_name" VARCHAR,
"location" VARCHAR,
"location_city" VARCHAR,
"location_country" VARCHAR,
"is_remote" VARCHAR,
"is_remote_country_specific" VARCHAR,
"compensation" VARCHAR,
"time_zone_requirements" VARCHAR,
"is_full_time" VARCHAR,
"is_part_time" VARCHAR,
"is_contractor" VARCHAR,
"subindustry" VARCHAR,
"company_description" VARCHAR,
"position" VARCHAR,
"language_stack" VARCHAR
);
Anyone who has the link will be able to view this.