Music & Mental Health Survey Results

Survey results on music taste and self-reported mental health

@kaggle.catherinerasgaitis_mxmh_survey_results

Table List

1 table(38.51 KB)

Mxmh Survey Results

@kaggle.catherinerasgaitis_mxmh_survey_results.mxmh_survey_results

38.51 KB
736 rows
33 columns

timestamp Timestamp	age Age	primary_streaming_service Primary Streaming Service	hours_per_day Hours Per Day	while_working While Working	instrumentalist Instrumentalist	composer Composer	fav_genre Fav Genre	exploratory Exploratory	foreign_languages Foreign Languages	bpm BPM	frequency_classical Frequency [Classical]	frequency_country Frequency [Country]	frequency_edm Frequency [EDM]	frequency_folk Frequency [Folk]	frequency_gospel Frequency [Gospel]	frequency_hip_hop Frequency [Hip Hop]	frequency_jazz Frequency [Jazz]	frequency_k_pop Frequency [K Pop]	frequency_latin Frequency [Latin]	frequency_lofi Frequency [Lofi]	frequency_metal Frequency [Metal]	frequency_pop Frequency [Pop]	frequency_r_b Frequency [R\u0026B]	frequency_rap Frequency [Rap]	frequency_rock Frequency [Rock]	frequency_video_game_music Frequency [Video Game Music]	anxiety Anxiety	depression Depression	insomnia Insomnia	ocd OCD	music_effects Music Effects	permissions Permissions
Sat Aug 27 2022 19:29:02 GMT+0000 (Coordinated Universal Time)	18	Spotify	3	Yes	Yes	Yes	Latin	Yes	Yes	156	Rarely	Never	Rarely	Never	Never	Sometimes	Never	Very frequently	Very frequently	Rarely	Never	Very frequently	Sometimes	Very frequently	Never	Sometimes	3		1		nan	I understand.
Sat Aug 27 2022 19:57:31 GMT+0000 (Coordinated Universal Time)	63	Pandora	1.5	Yes	No	No	Rock	Yes	No	119	Sometimes	Never	Never	Rarely	Sometimes	Rarely	Very frequently	Rarely	Sometimes	Rarely	Never	Sometimes	Sometimes	Rarely	Very frequently	Rarely	7	2	2	1	nan	I understand.
Sat Aug 27 2022 21:28:18 GMT+0000 (Coordinated Universal Time)	18	Spotify	4	No	No	No	Video game music	No	Yes	132	Never	Never	Very frequently	Never	Never	Rarely	Rarely	Very frequently	Never	Sometimes	Sometimes	Rarely	Never	Rarely	Rarely	Very frequently	7	7	10	2	No effect	I understand.
Sat Aug 27 2022 21:40:40 GMT+0000 (Coordinated Universal Time)	61	YouTube Music	2.5	Yes	No	Yes	Jazz	Yes	Yes	84	Sometimes	Never	Never	Rarely	Sometimes	Never	Very frequently	Sometimes	Very frequently	Sometimes	Never	Sometimes	Sometimes	Never	Never	Never	9	7	3	3	Improve	I understand.
Sat Aug 27 2022 21:54:47 GMT+0000 (Coordinated Universal Time)	18	Spotify	4	Yes	No	No	R&B	Yes	No	107	Never	Never	Rarely	Never	Rarely	Very frequently	Never	Very frequently	Sometimes	Sometimes	Never	Sometimes	Very frequently	Very frequently	Never	Rarely	7	2	5	9	Improve	I understand.
Sat Aug 27 2022 21:56:50 GMT+0000 (Coordinated Universal Time)	18	Spotify	5	Yes	Yes	Yes	Jazz	Yes	Yes	86	Rarely	Sometimes	Never	Never	Never	Sometimes	Very frequently	Very frequently	Rarely	Very frequently	Rarely	Very frequently	Very frequently	Very frequently	Very frequently	Never	8	8	7	7	Improve	I understand.
Sat Aug 27 2022 22:00:29 GMT+0000 (Coordinated Universal Time)	18	YouTube Music	3	Yes	Yes	No	Video game music	Yes	Yes	66	Sometimes	Never	Rarely	Sometimes	Rarely	Rarely	Sometimes	Never	Rarely	Rarely	Rarely	Rarely	Rarely	Never	Never	Sometimes	4	8	6		Improve	I understand.
Sat Aug 27 2022 22:18:59 GMT+0000 (Coordinated Universal Time)	21	Spotify	1	Yes	No	No	K pop	Yes	Yes	95	Never	Never	Rarely	Never	Never	Very frequently	Rarely	Very frequently	Never	Sometimes	Never	Sometimes	Sometimes	Rarely	Never	Rarely	5	3	5	3	Improve	I understand.
Sat Aug 27 2022 22:33:05 GMT+0000 (Coordinated Universal Time)	19	Spotify	6	Yes	No	No	Rock	No	No	94	Never	Very frequently	Never	Sometimes	Never	Never	Never	Never	Never	Never	Very frequently	Never	Never	Never	Very frequently	Never	2				Improve	I understand.
Sat Aug 27 2022 22:44:03 GMT+0000 (Coordinated Universal Time)	18	I do not use a streaming service.	1	Yes	No	No	R&B	Yes	Yes	155	Rarely	Rarely	Rarely	Rarely	Sometimes	Rarely	Rarely	Never	Rarely	Rarely	Never	Sometimes	Sometimes	Rarely	Sometimes	Sometimes	2	2	5	1	Improve	I understand.


CREATE TABLE mxmh_survey_results (
  "timestamp" TIMESTAMP,
  "age" DOUBLE,
  "primary_streaming_service" VARCHAR,
  "hours_per_day" DOUBLE,
  "while_working" VARCHAR,
  "instrumentalist" VARCHAR,
  "composer" VARCHAR,
  "fav_genre" VARCHAR,
  "exploratory" VARCHAR,
  "foreign_languages" VARCHAR,
  "bpm" DOUBLE,
  "frequency_classical" VARCHAR,
  "frequency_country" VARCHAR,
  "frequency_edm" VARCHAR,
  "frequency_folk" VARCHAR,
  "frequency_gospel" VARCHAR,
  "frequency_hip_hop" VARCHAR,
  "frequency_jazz" VARCHAR,
  "frequency_k_pop" VARCHAR,
  "frequency_latin" VARCHAR,
  "frequency_lofi" VARCHAR,
  "frequency_metal" VARCHAR,
  "frequency_pop" VARCHAR,
  "frequency_r_b" VARCHAR,
  "frequency_rap" VARCHAR,
  "frequency_rock" VARCHAR,
  "frequency_video_game_music" VARCHAR,
  "anxiety" DOUBLE,
  "depression" DOUBLE,
  "insomnia" DOUBLE,
  "ocd" DOUBLE,
  "music_effects" VARCHAR,
  "permissions" VARCHAR
);