musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "piano accompaniment"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 35 ✖
- bad audio quality · 2 ✖
- emotional 2
- medium tempo 2
- passionate · 2 ✖
- piano accompaniment · 2 ✖
- chord changes 1
- classic rock 1
- classic rock song 1
- cult classic 1
- cymbal crashes 1
- electric guitar lead 1
- energetic 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- iconic solo 1
- instrumental music 1
- keybiard accompaniment 1
- love songs 1
- male singer 1
- modern pop songs 1
- new age 1
- pop song 1
- realisation 1
- rock anthem 1
- rock super-hits 1
- romantic song 1
- sadness 1
- sentimental 1
- specials sound effects 1
- spirited 1
- steady drumming rhythm 1
- string bass line 1
- tempo changes 1
- youthful 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Matthew Perryman Jones - Save you lyrics | A male singer sings this poignant love song. The song is medium tempo with a steady drumming rhythm, strong bass line, keyboard accompaniment, guitar accompaniment and percussion hits. The song is emotional and romantic. The song audio quality is bad. | 2010-08-30T19:02:00Z | dionyts91 | Matthew Perryman Jones' official website: http://mpjmusic.com this is one of the KYLE XY 's, ONE TREE HILL 's , PRETTY LITTLE LIARS' soundtracks !! i love it!! I M SORRY FOR POSSIBLE MISTAKES ON THE LYRICS!! i don't own any rights! | ["Christian music", "Music"] | ["male singer", "classic rock", "pop song", "bad audio quality", "medium tempo", "string bass line", "guitar accompaniment", "piano accompaniment", "keybiard accompaniment", "steady drumming rhythm", "emotional", "passionate", "groovy rhythm", "new age", "romantic song", "sadness", "realisation", "modern pop songs", "love songs"] | 1 | Jq2w30NYstQ | 2037 | |
Rock Band 3 - Bohemian Rhapsody [Splitscreen] [100% FC Expert Pro Keys] | The song is an instrumental. The song is medium tempo and tempo changes occur later, with piano accompaniment, guitar solo, chord changes, steady drumming rhythm, rhythm guitar, and strong bass line . The song is an iconic rock hit and has a bad audio quality. | 2011-07-07T00:24:37Z | RockerSVK | Bohemian Rhapsody - Queen XBL Gamertag: RockerSVK My friend lent me a camera so I could finally record my hands playing pro keys as many of you requested that. I ReFCd Bohemian Rhapsody just to show you my hands, I also made it one handed just for you. I even improved my best score :) Also notice this is my first splitscreen video ever so I hope you like it :D Btw I recorded my hands playing 2 other songs I already FCd (you can guess which ones) so stay tuned :) I had to change a pitch of audio track half a semitone up otherwise the video will be blocked in some countries. Sorry for that. | ["Swing music", "Musical instrument", "Keyboard (musical)"] | ["electric guitar lead", "chord changes", "specials sound effects", "groovy bass line", "piano accompaniment", "classic rock song", "instrumental music", "cymbal crashes", "piano accompaniment", "emotional", "sentimental", "rock super-hits", "passionate", "spirited", "cult classic", "bad audio quality", "passionate", "energetic", "youthful", "iconic solo", "rock anthem", "tempo changes", "medium tempo"] | 1 | LR3U4b_fVBc | 2186 |
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;