musiccaps_details (view)
3 rows where musiccaps_aspects contains "distortion guitars" and musiccaps_aspects contains "happy mood"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- distortion guitars · 3 ✖
- happy mood · 3 ✖
- bass 2
- heavy metal 2
- moderate tempo 2
- percussion 2
- aggressive percussion 1
- cartoon whistles 1
- chimes 1
- dance music 1
- fast tempo 1
- female voices 1
- gallopping guitar 1
- guitar solo 1
- instrumental 1
- low quality audio 1
- low quality sound 1
- male voice 1
- no voices 1
- pop song 1
- quirky sounds 1
- upbeat song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Iron Maiden - The Clairvoyant | This clip features low quality audio. The song is a heavy metal song where a guitar solo is played on the higher register of the scale. This is accompanied by percussion playing an uptempo beat. The bass plays a heavy riff using open notes and its octave. The distortion guitar plays power chords. There are no voices in this song. This is an instrumental song. This song can be played in a racecar sequence in a movie. | 2006-04-22T14:12:37Z | lammeaap | The Clairvoyant played live at Birmingham during the Seventh Tour of a Seventh Tour. | ["Music", "Rock music", "Inside, large room or hall", "Inside, public space"] | ["low quality sound", "heavy metal", "guitar solo", "no voices", "bass", "percussion", "distortion guitars", "happy mood", "instrumental", "moderate tempo"] | 0 | CdWA-SNcYpM | 1386 | |
World Cup Twinkles 2009 Music | This pop song features female voices singing the main melody. This is accompanied by fast paced drumming. The percussion plays a simple fast paced beat in common time. Distortion guitars play power chords. The bass plays the root notes of the chords. There are quirky sounds played in the background. A cartoon whistle is played in the background. A triangle is also heard in the background. There is the sound of a cartoon laser blast in the background. The mood of the song is happy. This song can be played during the end credits of a college comedy movie. | 2013-11-01T20:57:11Z | WorldCupAllstarCheer | ["Music", "Pop music", "Exciting music"] | ["pop song", "female voices", "quirky sounds", "chimes", "fast tempo", "cartoon whistles", "percussion", "distortion guitars", "upbeat song", "dance music", "happy mood"] | 0 | UvCY9FHpKC8 | 2955 | ||
Dio - King of rock and roll | This heavy metal song features a male voice singing the main melody. This is accompanied by aggressive percussion playing in common time. The distortion guitar plays power chords with a galloping rhythm. The gallop is ended with an ascending lick. The bass follows the same pattern as the distortion guitar but plays only the root notes of the chords. This song is upbeat. The quality of the audio is low. This song can be used when a wrestler enters the WWE arena. | 2007-12-13T15:45:21Z | Henrique Souza | Dio - King of rock and roll | ["Music", "Roll", "Rock and roll"] | ["low quality audio", "distortion guitars", "gallopping guitar", "aggressive percussion", "male voice", "heavy metal", "happy mood", "moderate tempo", "bass"] | 0 | VkVKGyWi2r4 | 3026 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;