musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "engaging" and musiccaps_aspects contains "rock" sorted by musiccaps_author
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 29 ✖
- classic rock 2
- engaging · 2 ✖
- rock · 2 ✖
- youthful 2
- alternative rock 1
- amplified guitar riff 1
- burgeoning harmony 1
- captivating 1
- catchy 1
- fast tempo 1
- female vocalist 1
- funky bass line 1
- groovy 1
- groovy bass lines 1
- instrumental 1
- intense 1
- keyboard accompaniment 1
- powerful 1
- progressive rock 1
- retro rock 1
- slick drumming 1
- soft rock 1
- steady drumming 1
- symphonic rock 1
- synthesiser articulation 1
- upbeat 1
- vibrant 1
- vibrant electric guitars 1
- vivacious 1
musiccaps_names (array) 13 ✖
- Music 2
- Acoustic guitar 1
- Blues 1
- Guitar 1
- Heavy metal 1
- Independent music 1
- Musical instrument 1
- Plucked string instrument 1
- Pop music 1
- Progressive rock 1
- Rock music 1
- Singing 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Duquesne Whistle Copyright blocked Audio Joh Pink Rig.Steam Trains, Art, Bob Dylan etc | This song is an instrumental. The tempo is medium with an interesting electric guitar riff and subtle keyboard followed by energetic drumming, Funky bass lines and keyboard arrangement. The song gradually builds up and is catchy, youthful, upbeat, melodious, captivating and groovy. This song is Soft Rock. | 2012-09-25T05:45:20Z | conncork | Copyright Duquesne Whistle blocked replaced by music van google. Audio-informatie voor deze video Artiest: Joh Nummer: Pink Rig Duur: 06:20 Genre: RockSteam Trains America Europe Art Bob Dylan etc. Music Joh Pink Rig van Google. Bob Dylan Duquesne Whistle Tempest Bob Dylan steam trains Duluth, Minnesota America people Lizard Paintings | ["Blues", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "amplified guitar riff", "intense", "captivating", "groovy", "burgeoning harmony", "youthful", "catchy", "upbeat", "engaging", "captivating", "steady drumming", "funky bass line", "keyboard accompaniment", "rock", "classic rock", "retro rock"] | 7 | R-aMYx9f0Ho | 2658 | |
Magenta - King Of The Skies | A female vocalist sings this spirited song. The tempo is fast with enthusiastic electric guitar harmony, slick drumming, groovy bass lines and synthesiser arrangements. The song is energetic, youthful, fun, pulsating, engaging and emphatic. This song is Alternative Rock. | 2006-06-21T17:59:15Z | chrismagenta | Track from Magenta's The Gathering DVD. Amazing Welsh Progressive Rock band in the vain of Genesis, Yes and Renaissance. | ["Singing", "Heavy metal", "Music", "Independent music", "Pop music", "Rock music", "Song", "Progressive rock"] | ["female vocalist", "fast tempo", "vibrant electric guitars", "progressive rock", "symphonic rock", "alternative rock", "slick drumming", "synthesiser articulation", "vivacious", "youthful", "vibrant", "groovy bass lines", "engaging", "powerful", "rock", "classic rock", "soft rock"] | 7 | pp6eSGANq0Y | 4737 |
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;