Steven Wilson Detector
Finding songs that match Steven Wilson's style
@kaggle.danielgrijalvas_steven_wilson_analysis
Finding songs that match Steven Wilson's style
@kaggle.danielgrijalvas_steven_wilson_analysis
CREATE TABLE complete_steven_wilson (
"acousticness" DOUBLE,
"album" VARCHAR,
"analysis_url" VARCHAR,
"artist" VARCHAR,
"danceability" DOUBLE,
"duration_ms" DOUBLE,
"energy" DOUBLE,
"id" VARCHAR,
"instrumentalness" DOUBLE,
"key" BIGINT,
"liveness" DOUBLE,
"loudness" DOUBLE,
"mode" BIGINT,
"name" VARCHAR,
"speechiness" DOUBLE,
"tempo" DOUBLE,
"time_signature" BIGINT,
"track_href" VARCHAR,
"type" VARCHAR,
"uri" VARCHAR,
"valence" DOUBLE,
"lyrics" VARCHAR
);
CREATE TABLE porcupine_tree (
"acousticness" DOUBLE,
"album" VARCHAR,
"analysis_url" VARCHAR,
"artist" VARCHAR,
"danceability" DOUBLE,
"duration_ms" DOUBLE,
"energy" DOUBLE,
"id" VARCHAR,
"instrumentalness" DOUBLE,
"key" BIGINT,
"liveness" DOUBLE,
"loudness" DOUBLE,
"mode" BIGINT,
"name" VARCHAR,
"speechiness" DOUBLE,
"tempo" DOUBLE,
"time_signature" BIGINT,
"track_href" VARCHAR,
"type" VARCHAR,
"uri" VARCHAR,
"valence" DOUBLE,
"lyrics" VARCHAR
);
CREATE TABLE steven_wilson (
"acousticness" DOUBLE,
"album" VARCHAR,
"analysis_url" VARCHAR,
"artist" VARCHAR,
"danceability" DOUBLE,
"duration_ms" DOUBLE,
"energy" DOUBLE,
"id" VARCHAR,
"instrumentalness" DOUBLE,
"key" BIGINT,
"liveness" DOUBLE,
"loudness" DOUBLE,
"mode" BIGINT,
"name" VARCHAR,
"speechiness" DOUBLE,
"tempo" DOUBLE,
"time_signature" BIGINT,
"track_href" VARCHAR,
"type" VARCHAR,
"uri" VARCHAR,
"valence" DOUBLE,
"lyrics" VARCHAR
);
CREATE TABLE test (
"acousticness" DOUBLE,
"album" VARCHAR,
"analysis_url" VARCHAR,
"danceability" DOUBLE,
"duration_ms" BIGINT,
"energy" DOUBLE,
"id" VARCHAR,
"instrumentalness" DOUBLE,
"key" BIGINT,
"liveness" DOUBLE,
"loudness" DOUBLE,
"mode" BIGINT,
"name" VARCHAR,
"speechiness" DOUBLE,
"tempo" DOUBLE,
"time_signature" BIGINT,
"track_href" VARCHAR,
"type" VARCHAR,
"uri" VARCHAR,
"valence" DOUBLE,
"class" DOUBLE
);
CREATE TABLE training (
"acousticness" DOUBLE,
"album" VARCHAR,
"analysis_url" VARCHAR,
"danceability" DOUBLE,
"duration_ms" DOUBLE,
"energy" DOUBLE,
"id" VARCHAR,
"instrumentalness" DOUBLE,
"key" BIGINT,
"liveness" DOUBLE,
"loudness" DOUBLE,
"mode" BIGINT,
"name" VARCHAR,
"speechiness" DOUBLE,
"tempo" DOUBLE,
"time_signature" BIGINT,
"track_href" VARCHAR,
"type" VARCHAR,
"uri" VARCHAR,
"valence" DOUBLE,
"class" BIGINT
);
Anyone who has the link will be able to view this.