Dataset: Stack Overflow Developer Surveys (2015-2020)

About this Dataset

Stack Overflow Developer Surveys (2015-2020)

Context

Stack Overflow publicly releases its annual developer survey since 2011. The questions range from occupation and salary to favorite IDEs and programming languages (the 2015 survey even included a question about caffeinated beverages!).

Content

This repository contains the raw survey results from 2015 to 2020 -- before 2015, Stack Overflow did not include data scientists in their occupation, so I do not include those years. Each folder (except 2015) has a schema and the raw survey results. The "Tools of the Trade" Notebook has code to load in and analyze the datasets.

Acknowledgements

All credit to Stack Overflow. I just downloaded the surveys and uploaded them :). All the data can be found here: https://insights.stackoverflow.com/survey/.

Tables

N 2015 Stack Overflow Developer Survey Responses

@kaggle.haakakak_stack_overflow_developer_surveys_20152020.n_2015_stack_overflow_developer_survey_responses

1.21 MB
26087 rows
222 columns


CREATE TABLE n_2015_stack_overflow_developer_survey_responses (
  "unnamed_0" VARCHAR,
  "unnamed_1" VARCHAR,
  "unnamed_2" VARCHAR,
  "unnamed_3" VARCHAR,
  "unnamed_4" VARCHAR,
  "unnamed_5" VARCHAR,
  "unnamed_6" VARCHAR,
  "unnamed_7" VARCHAR,
  "select_all_that_apply" VARCHAR,
  "unnamed_9" VARCHAR,
  "unnamed_10" VARCHAR,
  "unnamed_11" VARCHAR,
  "unnamed_12" VARCHAR,
  "unnamed_13" VARCHAR,
  "unnamed_14" VARCHAR,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" VARCHAR,
  "unnamed_23" VARCHAR,
  "unnamed_24" VARCHAR,
  "unnamed_25" VARCHAR,
  "unnamed_26" VARCHAR,
  "unnamed_27" VARCHAR,
  "unnamed_28" VARCHAR,
  "unnamed_29" VARCHAR,
  "unnamed_30" VARCHAR,
  "unnamed_31" VARCHAR,
  "unnamed_32" VARCHAR,
  "unnamed_33" VARCHAR,
  "unnamed_34" VARCHAR,
  "unnamed_35" VARCHAR,
  "unnamed_36" VARCHAR,
  "unnamed_37" VARCHAR,
  "unnamed_38" VARCHAR,
  "unnamed_39" VARCHAR,
  "unnamed_40" VARCHAR,
  "unnamed_41" VARCHAR,
  "unnamed_42" VARCHAR,
  "unnamed_43" VARCHAR,
  "unnamed_44" VARCHAR,
  "unnamed_45" VARCHAR,
  "unnamed_46" VARCHAR,
  "unnamed_47" VARCHAR,
  "unnamed_48" VARCHAR,
  "unnamed_49" VARCHAR,
  "unnamed_50" VARCHAR,
  "select_all_that_apply_1" VARCHAR,
  "unnamed_52" VARCHAR,
  "unnamed_53" VARCHAR,
  "unnamed_54" VARCHAR,
  "unnamed_55" VARCHAR,
  "unnamed_56" VARCHAR,
  "unnamed_57" VARCHAR,
  "unnamed_58" VARCHAR,
  "unnamed_59" VARCHAR,
  "unnamed_60" VARCHAR,
  "unnamed_61" VARCHAR,
  "unnamed_62" VARCHAR,
  "unnamed_63" VARCHAR,
  "unnamed_64" VARCHAR,
  "unnamed_65" VARCHAR,
  "unnamed_66" VARCHAR,
  "unnamed_67" VARCHAR,
  "unnamed_68" VARCHAR,
  "unnamed_69" VARCHAR,
  "unnamed_70" VARCHAR,
  "unnamed_71" VARCHAR,
  "unnamed_72" VARCHAR,
  "unnamed_73" VARCHAR,
  "unnamed_74" VARCHAR,
  "unnamed_75" VARCHAR,
  "unnamed_76" VARCHAR,
  "unnamed_77" VARCHAR,
  "unnamed_78" VARCHAR,
  "unnamed_79" VARCHAR,
  "unnamed_80" VARCHAR,
  "unnamed_81" VARCHAR,
  "unnamed_82" VARCHAR,
  "unnamed_83" VARCHAR,
  "unnamed_84" VARCHAR,
  "unnamed_85" VARCHAR,
  "unnamed_86" VARCHAR,
  "unnamed_87" VARCHAR,
  "unnamed_88" VARCHAR,
  "unnamed_89" VARCHAR,
  "unnamed_90" VARCHAR,
  "unnamed_91" VARCHAR,
  "unnamed_92" VARCHAR,
  "unnamed_93" VARCHAR,
  "select_all_that_apply_2" VARCHAR,
  "unnamed_95" VARCHAR,
  "unnamed_96" VARCHAR,
  "unnamed_97" VARCHAR,
  "unnamed_98" VARCHAR,
  "unnamed_99" VARCHAR
);

N 2016 Stack Overflow Survey Responses

@kaggle.haakakak_stack_overflow_developer_surveys_20152020.n_2016_stack_overflow_survey_responses

3.6 MB
56030 rows
66 columns


CREATE TABLE n_2016_stack_overflow_survey_responses (
  "unnamed_0" BIGINT,
  "collector" VARCHAR,
  "country" VARCHAR,
  "un_subregion" VARCHAR,
  "so_region" VARCHAR,
  "age_range" VARCHAR,
  "age_midpoint" DOUBLE,
  "gender" VARCHAR,
  "self_identification" VARCHAR,
  "occupation" VARCHAR,
  "occupation_group" VARCHAR,
  "experience_range" VARCHAR,
  "experience_midpoint" DOUBLE,
  "salary_range" VARCHAR,
  "salary_midpoint" DOUBLE,
  "big_mac_index" DOUBLE,
  "tech_do" VARCHAR,
  "tech_want" VARCHAR,
  "aliens" VARCHAR,
  "programming_ability" DOUBLE,
  "employment_status" VARCHAR,
  "industry" VARCHAR,
  "company_size_range" VARCHAR,
  "team_size_range" VARCHAR,
  "women_on_team" VARCHAR,
  "remote" VARCHAR,
  "job_satisfaction" VARCHAR,
  "job_discovery" VARCHAR,
  "dev_environment" VARCHAR,
  "commit_frequency" VARCHAR,
  "hobby" VARCHAR,
  "dogs_vs_cats" VARCHAR,
  "desktop_os" VARCHAR,
  "unit_testing" VARCHAR,
  "rep_range" VARCHAR,
  "visit_frequency" VARCHAR,
  "why_learn_new_tech" VARCHAR,
  "education" VARCHAR,
  "open_to_new_job" VARCHAR,
  "new_job_value" VARCHAR,
  "job_search_annoyance" VARCHAR,
  "interview_likelihood" VARCHAR,
  "how_to_improve_interview_process" VARCHAR,
  "star_wars_vs_star_trek" VARCHAR,
  "agree_tech" VARCHAR,
  "agree_notice" VARCHAR,
  "agree_problemsolving" VARCHAR,
  "agree_diversity" VARCHAR,
  "agree_adblocker" VARCHAR,
  "agree_alcohol" VARCHAR,
  "agree_loveboss" VARCHAR,
  "agree_nightcode" VARCHAR,
  "agree_legacy" VARCHAR,
  "agree_mars" VARCHAR,
  "important_variety" VARCHAR,
  "important_control" VARCHAR,
  "important_sameend" VARCHAR,
  "important_newtech" VARCHAR,
  "important_buildnew" VARCHAR,
  "important_buildexisting" VARCHAR,
  "important_promotion" VARCHAR,
  "important_companymission" VARCHAR,
  "important_wfh" VARCHAR,
  "important_ownoffice" VARCHAR,
  "developer_challenges" VARCHAR,
  "why_stack_overflow" VARCHAR
);

Survey Results Public

@kaggle.haakakak_stack_overflow_developer_surveys_20152020.survey_results_public

4.86 MB
51392 rows
154 columns


CREATE TABLE survey_results_public (
  "respondent" BIGINT,
  "professional" VARCHAR,
  "programhobby" VARCHAR,
  "country" VARCHAR,
  "university" VARCHAR,
  "employmentstatus" VARCHAR,
  "formaleducation" VARCHAR,
  "majorundergrad" VARCHAR,
  "homeremote" VARCHAR,
  "companysize" VARCHAR,
  "companytype" VARCHAR,
  "yearsprogram" VARCHAR,
  "yearscodedjob" VARCHAR,
  "yearscodedjobpast" VARCHAR,
  "developertype" VARCHAR,
  "webdevelopertype" VARCHAR,
  "mobiledevelopertype" VARCHAR,
  "nondevelopertype" VARCHAR,
  "careersatisfaction" DOUBLE,
  "jobsatisfaction" DOUBLE,
  "excoderreturn" VARCHAR,
  "excodernotforme" VARCHAR,
  "excoderbalance" VARCHAR,
  "excoder10years" VARCHAR,
  "excoderbelonged" VARCHAR,
  "excoderskills" VARCHAR,
  "excoderwillnotcode" VARCHAR,
  "excoderactive" VARCHAR,
  "pronouncegif" VARCHAR,
  "problemsolving" VARCHAR,
  "buildingthings" VARCHAR,
  "learningnewtech" VARCHAR,
  "boringdetails" VARCHAR,
  "jobsecurity" VARCHAR,
  "diversityimportant" VARCHAR,
  "annoyingui" VARCHAR,
  "friendsdevelopers" VARCHAR,
  "rightwrongway" VARCHAR,
  "understandcomputers" VARCHAR,
  "seriouswork" VARCHAR,
  "investtimetools" VARCHAR,
  "workpaycare" VARCHAR,
  "kinshipdevelopers" VARCHAR,
  "challengemyself" VARCHAR,
  "competepeers" VARCHAR,
  "changeworld" VARCHAR,
  "jobseekingstatus" VARCHAR,
  "hoursperweek" DOUBLE,
  "lastnewjob" VARCHAR,
  "assessjobindustry" VARCHAR,
  "assessjobrole" VARCHAR,
  "assessjobexp" VARCHAR,
  "assessjobdept" VARCHAR,
  "assessjobtech" VARCHAR,
  "assessjobprojects" VARCHAR,
  "assessjobcompensation" VARCHAR,
  "assessjoboffice" VARCHAR,
  "assessjobcommute" VARCHAR,
  "assessjobremote" VARCHAR,
  "assessjobleaders" VARCHAR,
  "assessjobprofdevel" VARCHAR,
  "assessjobdiversity" VARCHAR,
  "assessjobproduct" VARCHAR,
  "assessjobfinances" VARCHAR,
  "importantbenefits" VARCHAR,
  "clickykeys" VARCHAR,
  "jobprofile" VARCHAR,
  "resumeprompted" VARCHAR,
  "learnedhiring" VARCHAR,
  "importanthiringalgorithms" VARCHAR,
  "importanthiringtechexp" VARCHAR,
  "importanthiringcommunication" VARCHAR,
  "importanthiringopensource" VARCHAR,
  "importanthiringpmexp" VARCHAR,
  "importanthiringcompanies" VARCHAR,
  "importanthiringtitles" VARCHAR,
  "importanthiringeducation" VARCHAR,
  "importanthiringrep" VARCHAR,
  "importanthiringgettingthingsdone" VARCHAR,
  "currency" VARCHAR,
  "overpaid" VARCHAR,
  "tabsspaces" VARCHAR,
  "educationimportant" VARCHAR,
  "educationtypes" VARCHAR,
  "selftaughttypes" VARCHAR,
  "timeafterbootcamp" VARCHAR,
  "cousineducation" VARCHAR,
  "workstart" VARCHAR,
  "haveworkedlanguage" VARCHAR,
  "wantworklanguage" VARCHAR,
  "haveworkedframework" VARCHAR,
  "wantworkframework" VARCHAR,
  "haveworkeddatabase" VARCHAR,
  "wantworkdatabase" VARCHAR,
  "haveworkedplatform" VARCHAR,
  "wantworkplatform" VARCHAR,
  "ide" VARCHAR,
  "auditoryenvironment" VARCHAR,
  "methodology" VARCHAR,
  "versioncontrol" VARCHAR
);

Survey Results Schema

@kaggle.haakakak_stack_overflow_developer_surveys_20152020.survey_results_schema

12.08 KB
154 rows
2 columns


CREATE TABLE survey_results_schema (
  "column" VARCHAR,
  "question" VARCHAR
);