Dataset: 2019 Stack Overflow Developer Survey Random Sample

About this Dataset

2019 Stack Overflow Developer Survey Random Sample

The underlying data is from Stack Overflow's 2019 Developer Survey Responses and can be found: https://stackoverflow.blog/2019/04/09/the-2019-stack-overflow-developer-survey-results-are-in/ Please note my intent with uploading this is to showcase my experience working with the datasets. My goal is to build a centralized portfolio.

Please note that we are using a randomized sample of 1/10th the original data set. Conclusions may not reflect real world.

The goal of this project was to explore, analyze, and visualize.

Follow this link to see the Cognos Dashboard I created: https://dataplatform.cloud.ibm.com/dashboards/ee7bf962-3882-4145-a41c-ecdda9323484/view/4427dc2d63b71c921ee1e6e4079c29002c362d5fe4bb860ad18c7b495d607297f3614099c82f4d5bde135661a7e8400f9d

Feel free to filter and play with the dashboard as you want.

Tables

M1 Survey Data

@kaggle.nolan37_m1surveydata.m1_survey_data

1.08 MB
11552 rows
85 columns


CREATE TABLE m1_survey_data (
  "respondent" BIGINT,
  "mainbranch" VARCHAR,
  "hobbyist" VARCHAR,
  "opensourcer" VARCHAR,
  "opensource" VARCHAR,
  "employment" VARCHAR,
  "country" VARCHAR,
  "student" VARCHAR,
  "edlevel" VARCHAR,
  "undergradmajor" VARCHAR,
  "eduother" VARCHAR,
  "orgsize" VARCHAR,
  "devtype" VARCHAR,
  "yearscode" VARCHAR,
  "age1stcode" VARCHAR,
  "yearscodepro" VARCHAR,
  "careersat" VARCHAR,
  "jobsat" VARCHAR,
  "mgridiot" VARCHAR,
  "mgrmoney" VARCHAR,
  "mgrwant" VARCHAR,
  "jobseek" VARCHAR,
  "lasthiredate" VARCHAR,
  "lastint" VARCHAR,
  "fizzbuzz" VARCHAR,
  "jobfactors" VARCHAR,
  "resumeupdate" VARCHAR,
  "currencysymbol" VARCHAR,
  "currencydesc" VARCHAR,
  "comptotal" DOUBLE,
  "compfreq" VARCHAR,
  "convertedcomp" DOUBLE,
  "workweekhrs" DOUBLE,
  "workplan" VARCHAR,
  "workchallenge" VARCHAR,
  "workremote" VARCHAR,
  "workloc" VARCHAR,
  "impsyn" VARCHAR,
  "coderev" VARCHAR,
  "coderevhrs" DOUBLE,
  "unittests" VARCHAR,
  "purchasehow" VARCHAR,
  "purchasewhat" VARCHAR,
  "languageworkedwith" VARCHAR,
  "languagedesirenextyear" VARCHAR,
  "databaseworkedwith" VARCHAR,
  "databasedesirenextyear" VARCHAR,
  "platformworkedwith" VARCHAR,
  "platformdesirenextyear" VARCHAR,
  "webframeworkedwith" VARCHAR,
  "webframedesirenextyear" VARCHAR,
  "misctechworkedwith" VARCHAR,
  "misctechdesirenextyear" VARCHAR,
  "devenviron" VARCHAR,
  "opsys" VARCHAR,
  "containers" VARCHAR,
  "blockchainorg" VARCHAR,
  "blockchainis" VARCHAR,
  "betterlife" VARCHAR,
  "itperson" VARCHAR,
  "offon" VARCHAR,
  "socialmedia" VARCHAR,
  "extraversion" VARCHAR,
  "screenname" VARCHAR,
  "sovisit1st" VARCHAR,
  "sovisitfreq" VARCHAR,
  "sovisitto" VARCHAR,
  "sofindanswer" VARCHAR,
  "sotimesaved" VARCHAR,
  "sohowmuchtime" VARCHAR,
  "soaccount" VARCHAR,
  "sopartfreq" VARCHAR,
  "sojobs" VARCHAR,
  "entteams" VARCHAR,
  "socomm" VARCHAR,
  "welcomechange" VARCHAR,
  "sonewcontent" VARCHAR,
  "age" DOUBLE,
  "gender" VARCHAR,
  "trans" VARCHAR,
  "sexuality" VARCHAR,
  "ethnicity" VARCHAR,
  "dependents" VARCHAR,
  "surveylength" VARCHAR,
  "surveyease" VARCHAR
);

M5 Survey Data Demographics

@kaggle.nolan37_m1surveydata.m5_survey_data_demographics

576.59 KB
11398 rows
70 columns


CREATE TABLE m5_survey_data_demographics (
  "respondent" BIGINT,
  "mainbranch" VARCHAR,
  "hobbyist" VARCHAR,
  "opensourcer" VARCHAR,
  "opensource" VARCHAR,
  "employment" VARCHAR,
  "country" VARCHAR,
  "student" VARCHAR,
  "edlevel" VARCHAR,
  "undergradmajor" VARCHAR,
  "eduother" VARCHAR,
  "orgsize" VARCHAR,
  "devtype" VARCHAR,
  "yearscode" VARCHAR,
  "age1stcode" VARCHAR,
  "yearscodepro" VARCHAR,
  "careersat" VARCHAR,
  "jobsat" VARCHAR,
  "mgridiot" VARCHAR,
  "mgrmoney" VARCHAR,
  "mgrwant" VARCHAR,
  "jobseek" VARCHAR,
  "lasthiredate" VARCHAR,
  "lastint" VARCHAR,
  "fizzbuzz" VARCHAR,
  "jobfactors" VARCHAR,
  "resumeupdate" VARCHAR,
  "currencysymbol" VARCHAR,
  "currencydesc" VARCHAR,
  "comptotal" DOUBLE,
  "compfreq" VARCHAR,
  "convertedcomp" DOUBLE,
  "workweekhrs" DOUBLE,
  "workplan" VARCHAR,
  "workchallenge" VARCHAR,
  "workremote" VARCHAR,
  "workloc" VARCHAR,
  "impsyn" VARCHAR,
  "coderev" VARCHAR,
  "coderevhrs" DOUBLE,
  "unittests" VARCHAR,
  "purchasehow" VARCHAR,
  "purchasewhat" VARCHAR,
  "betterlife" VARCHAR,
  "itperson" VARCHAR,
  "offon" VARCHAR,
  "socialmedia" VARCHAR,
  "extraversion" VARCHAR,
  "screenname" VARCHAR,
  "sovisit1st" VARCHAR,
  "sovisitfreq" VARCHAR,
  "sovisitto" VARCHAR,
  "sofindanswer" VARCHAR,
  "sotimesaved" VARCHAR,
  "sohowmuchtime" VARCHAR,
  "soaccount" VARCHAR,
  "sopartfreq" VARCHAR,
  "sojobs" VARCHAR,
  "entteams" VARCHAR,
  "socomm" VARCHAR,
  "welcomechange" VARCHAR,
  "sonewcontent" VARCHAR,
  "age" DOUBLE,
  "gender" VARCHAR,
  "trans" VARCHAR,
  "sexuality" VARCHAR,
  "ethnicity" VARCHAR,
  "dependents" VARCHAR,
  "surveylength" VARCHAR,
  "surveyease" VARCHAR
);