Stack Overflow Developer Surveys (2015-2020)
Annual Stack Overflow Developer Surveys
@kaggle.haakakak_stack_overflow_developer_surveys_20152020
Annual Stack Overflow Developer Surveys
@kaggle.haakakak_stack_overflow_developer_surveys_20152020
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!).
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.
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/.
CREATE TABLE n_2015_stack_overflow_developer_survey_responses (
"unnamed_0" VARCHAR -- Unnamed: 0,
"unnamed_1" VARCHAR -- Unnamed: 1,
"unnamed_2" VARCHAR -- Unnamed: 2,
"unnamed_3" VARCHAR -- Unnamed: 3,
"unnamed_4" VARCHAR -- Unnamed: 4,
"unnamed_5" VARCHAR -- Unnamed: 5,
"unnamed_6" VARCHAR -- Unnamed: 6,
"unnamed_7" VARCHAR -- Unnamed: 7,
"select_all_that_apply" VARCHAR,
"unnamed_9" VARCHAR -- Unnamed: 9,
"unnamed_10" VARCHAR -- Unnamed: 10,
"unnamed_11" VARCHAR -- Unnamed: 11,
"unnamed_12" VARCHAR -- Unnamed: 12,
"unnamed_13" VARCHAR -- Unnamed: 13,
"unnamed_14" VARCHAR -- Unnamed: 14,
"unnamed_15" VARCHAR -- Unnamed: 15,
"unnamed_16" VARCHAR -- Unnamed: 16,
"unnamed_17" VARCHAR -- Unnamed: 17,
"unnamed_18" VARCHAR -- Unnamed: 18,
"unnamed_19" VARCHAR -- Unnamed: 19,
"unnamed_20" VARCHAR -- Unnamed: 20,
"unnamed_21" VARCHAR -- Unnamed: 21,
"unnamed_22" VARCHAR -- Unnamed: 22,
"unnamed_23" VARCHAR -- Unnamed: 23,
"unnamed_24" VARCHAR -- Unnamed: 24,
"unnamed_25" VARCHAR -- Unnamed: 25,
"unnamed_26" VARCHAR -- Unnamed: 26,
"unnamed_27" VARCHAR -- Unnamed: 27,
"unnamed_28" VARCHAR -- Unnamed: 28,
"unnamed_29" VARCHAR -- Unnamed: 29,
"unnamed_30" VARCHAR -- Unnamed: 30,
"unnamed_31" VARCHAR -- Unnamed: 31,
"unnamed_32" VARCHAR -- Unnamed: 32,
"unnamed_33" VARCHAR -- Unnamed: 33,
"unnamed_34" VARCHAR -- Unnamed: 34,
"unnamed_35" VARCHAR -- Unnamed: 35,
"unnamed_36" VARCHAR -- Unnamed: 36,
"unnamed_37" VARCHAR -- Unnamed: 37,
"unnamed_38" VARCHAR -- Unnamed: 38,
"unnamed_39" VARCHAR -- Unnamed: 39,
"unnamed_40" VARCHAR -- Unnamed: 40,
"unnamed_41" VARCHAR -- Unnamed: 41,
"unnamed_42" VARCHAR -- Unnamed: 42,
"unnamed_43" VARCHAR -- Unnamed: 43,
"unnamed_44" VARCHAR -- Unnamed: 44,
"unnamed_45" VARCHAR -- Unnamed: 45,
"unnamed_46" VARCHAR -- Unnamed: 46,
"unnamed_47" VARCHAR -- Unnamed: 47,
"unnamed_48" VARCHAR -- Unnamed: 48,
"unnamed_49" VARCHAR -- Unnamed: 49,
"unnamed_50" VARCHAR -- Unnamed: 50,
"select_all_that_apply_1" VARCHAR,
"unnamed_52" VARCHAR -- Unnamed: 52,
"unnamed_53" VARCHAR -- Unnamed: 53,
"unnamed_54" VARCHAR -- Unnamed: 54,
"unnamed_55" VARCHAR -- Unnamed: 55,
"unnamed_56" VARCHAR -- Unnamed: 56,
"unnamed_57" VARCHAR -- Unnamed: 57,
"unnamed_58" VARCHAR -- Unnamed: 58,
"unnamed_59" VARCHAR -- Unnamed: 59,
"unnamed_60" VARCHAR -- Unnamed: 60,
"unnamed_61" VARCHAR -- Unnamed: 61,
"unnamed_62" VARCHAR -- Unnamed: 62,
"unnamed_63" VARCHAR -- Unnamed: 63,
"unnamed_64" VARCHAR -- Unnamed: 64,
"unnamed_65" VARCHAR -- Unnamed: 65,
"unnamed_66" VARCHAR -- Unnamed: 66,
"unnamed_67" VARCHAR -- Unnamed: 67,
"unnamed_68" VARCHAR -- Unnamed: 68,
"unnamed_69" VARCHAR -- Unnamed: 69,
"unnamed_70" VARCHAR -- Unnamed: 70,
"unnamed_71" VARCHAR -- Unnamed: 71,
"unnamed_72" VARCHAR -- Unnamed: 72,
"unnamed_73" VARCHAR -- Unnamed: 73,
"unnamed_74" VARCHAR -- Unnamed: 74,
"unnamed_75" VARCHAR -- Unnamed: 75,
"unnamed_76" VARCHAR -- Unnamed: 76,
"unnamed_77" VARCHAR -- Unnamed: 77,
"unnamed_78" VARCHAR -- Unnamed: 78,
"unnamed_79" VARCHAR -- Unnamed: 79,
"unnamed_80" VARCHAR -- Unnamed: 80,
"unnamed_81" VARCHAR -- Unnamed: 81,
"unnamed_82" VARCHAR -- Unnamed: 82,
"unnamed_83" VARCHAR -- Unnamed: 83,
"unnamed_84" VARCHAR -- Unnamed: 84,
"unnamed_85" VARCHAR -- Unnamed: 85,
"unnamed_86" VARCHAR -- Unnamed: 86,
"unnamed_87" VARCHAR -- Unnamed: 87,
"unnamed_88" VARCHAR -- Unnamed: 88,
"unnamed_89" VARCHAR -- Unnamed: 89,
"unnamed_90" VARCHAR -- Unnamed: 90,
"unnamed_91" VARCHAR -- Unnamed: 91,
"unnamed_92" VARCHAR -- Unnamed: 92,
"unnamed_93" VARCHAR -- Unnamed: 93,
"select_all_that_apply_2" VARCHAR,
"unnamed_95" VARCHAR -- Unnamed: 95,
"unnamed_96" VARCHAR -- Unnamed: 96,
"unnamed_97" VARCHAR -- Unnamed: 97,
"unnamed_98" VARCHAR -- Unnamed: 98,
"unnamed_99" VARCHAR -- Unnamed: 99
);
CREATE TABLE n_2016_stack_overflow_survey_responses (
"unnamed_0" BIGINT -- Unnamed: 0,
"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
);
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
);
CREATE TABLE survey_results_schema (
"column" VARCHAR,
"question" VARCHAR
);
Anyone who has the link will be able to view this.