Twenty One Pilots Discography

Metrics and audio features

@kaggle.federicoseijo_twenty_one_pilots_discography

Table List

1 table(27.25 KB)

Twentyscience

@kaggle.federicoseijo_twenty_one_pilots_discography.twentyscience

27.25 KB
130 rows
26 columns

unnamed_0 Unnamed: 0	album_release_date Album Release Date	album_release_year Album Release Year	danceability Danceability	energy Energy	key Key	loudness Loudness	mode Mode	speechiness Speechiness	acousticness Acousticness	instrumentalness Instrumentalness	liveness Liveness	valence Valence	tempo Tempo	time_signature Time Signature	disc_number Disc Number	duration_ms Duration Ms	track_name Track Name	track_number Track Number	type Type	album_name Album Name	key_name Key Name	mode_name Mode Name	key_mode Key Mode
1	Fri May 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	0.684	0.677	7	-7.355	1	0.0401	0.11	0.00975	0.34	0.37	142.048	4	1	204400	Good Day	1	track	Scaled And Icy	G	major	G major
2	Fri May 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	0.7	0.664	7	-8.211	1	0.0394	0.306	0.0000189	0.249	0.585	142.009	4	1	223065	Choker	2	track	Scaled And Icy	G	major	G major
3	Fri May 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	0.588	0.856	9	-5.242		0.0316	0.000818	0.0739	0.238	0.635	96.966	4	1	175044	Shy Away	3	track	Scaled And Icy	A	minor	A minor
4	Fri May 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	0.785	0.623	11	-6.923	1	0.0403	0.0505	0.125	0.0539	0.711	100.991	4	1	216758	The Outside	4	track	Scaled And Icy	B	major	B major
5	Fri May 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	0.687	0.89	8	-5.99	1	0.0344	0.00396	0.000939	0.0436	0.854	113.06	4	1	172232	Saturday	5	track	Scaled And Icy	G#	major	G# major
6	Fri May 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	0.747	0.733	9	-5.724	1	0.0278	0.00997	0.0043	0.0703	0.775	117.973	4	1	212706	Never Take It	6	track	Scaled And Icy	A	major	A major
7	Fri May 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	0.674	0.535	2	-7.114	1	0.0518	0.0138		0.326	0.716	170.188	4	1	224398	Mulberry Street	7	track	Scaled And Icy	D	major	D major
8	Fri May 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	0.653	0.559	6	-6.758		0.0276	0.00983	0.000473	0.062	0.731	137.006	4	1	176324	Formidable	8	track	Scaled And Icy	F#	minor	F# minor
9	Fri May 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	0.704	0.696	4	-6.48		0.0568	0.269	0.00029	0.326	0.577	141.955	4	1	185438	Bounce Man	9	track	Scaled And Icy	E	minor	E minor
10	Fri May 21 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	0.667	0.54	7	-7.301	1	0.0629	0.15	0.0184	0.218	0.0882	139.984	4	1	226449	No Chances	10	track	Scaled And Icy	G	major	G major


CREATE TABLE twentyscience (
  "unnamed_0" BIGINT,
  "album_release_date" TIMESTAMP,
  "album_release_year" BIGINT,
  "danceability" DOUBLE,
  "energy" DOUBLE,
  "key" BIGINT,
  "loudness" DOUBLE,
  "mode" BIGINT,
  "speechiness" DOUBLE,
  "acousticness" DOUBLE,
  "instrumentalness" DOUBLE,
  "liveness" DOUBLE,
  "valence" DOUBLE,
  "tempo" DOUBLE,
  "time_signature" BIGINT,
  "disc_number" BIGINT,
  "duration_ms" BIGINT,
  "explicit" BOOLEAN,
  "is_local" BOOLEAN,
  "track_name" VARCHAR,
  "track_number" BIGINT,
  "type" VARCHAR,
  "album_name" VARCHAR,
  "key_name" VARCHAR,
  "mode_name" VARCHAR,
  "key_mode" VARCHAR
);