musiccaps_details (view)
4 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "passionate", musiccaps_aspects contains "piano accompaniment" and musiccaps_author = 1
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
𝐒𝐀𝐋𝐒𝐀 - 𝐛𝐚𝐢𝐥𝐚 𝐂𝐮𝐛𝐚𝐧 𝐬𝐭𝐲𝐥𝐞 - 𝐄𝐱𝐜𝐢𝐭𝐢𝐧𝐠 𝐒𝐚𝐥𝐬𝐚 ! | A male singer sings this Latin melody with backup singers in vocal harmony. The song is medium tempo with a brass band accompaniment, latin percussion and guitar accompaniment. The song is exciting and spirited. The song is perfect for Latin dancing. The song has a poor audio quality. | 2013-02-17T03:55:26Z | MrHaagsesjonny1 | 𝗱𝗮𝗻𝗰𝗲 𝘃𝗶𝗱𝗲𝗼: 𝘀𝗮𝗹𝘀𝗮 𝗱𝗮𝗻𝗰𝗶𝗻𝗴 - 𝘀𝗮𝗹𝘀𝗮 𝗰𝘂𝗯𝗮𝗻𝗮 - 𝗖𝗮𝘀𝗶𝗻𝗼 - 𝗮𝗻𝗱 𝗲𝘅𝗰𝗶𝘁𝗶𝗻𝗴 𝗱𝗮𝗻𝗰𝗲 𝘄𝗶𝘁𝗵 𝗖𝘂𝗯𝗮𝗻 𝗯𝗼𝗿𝗻 𝗠𝗮𝘆𝗸𝗲𝗹 𝗙𝗼𝗻𝘁𝘀 | ["Music", "Salsa music"] | ["latin dance music", "male singer", "live band performance", "trumpets blaring", "vocal harmony", "piano accompaniment", "exciting", "energetic", "passionate", "latin dance", "salsa", "passionate", "adrenaline rush", "groovy rhythm", "backup singers", "vocal harmony", "ttrumelts blaring", "brass band", "barking tones", "latin percussions", "guitar rhythm", "poor audio quality", "live performance"] | 1 | RlrNPBfOowg | 2722 | |
Chuck Mangione - Sun Shower | The song is an instrumental. The tempo is fast with trumpets playing percussively along with other brass instruments, piano accompaniment, groovy bass line jazz drumming rhythm. The song is energetic and passionate. The song is a retro big band jazz classic with poor audio quality. | 2011-01-29T01:59:44Z | Henry Cooper | From 1971's Together. Sampled by Tonex for "Sonshine" | ["Music", "Steelpan"] | ["instrumental music", "jazz music", "fast jazz drumming", "energetic", "passionate", "retro jazz classics", "jazz super hits", "jazz legends", "big band hits", "trumpets playing percussively", "fast tempo", "piano accompaniment", "fats jazz drumming", "brass section harmony", "groovy bass line", "big band", "poor audio quality", "jazz band"] | 1 | lNg2y6SRZPo | 4392 | |
La Maraca | A male Latin singer sings this energetic vocal with male backup singers in vocal harmony. The song is fast tempo with quick Latin percussions, groovy bass line, keyboard accompaniment and trumpets blaring. The song is energetic and passionate. The song has poor audio quality. | 2008-04-10T19:01:41Z | adonismasgozadera | AdonisGozadera.com | ["Music", "Song", "Salsa music", "Maraca"] | ["male latin singer", "backup singers", "screaming vocals", "rapping vocals", "street music", "fast tempo", "poor audio quality", "piano accompaniment", "latin percussions", "percussive bass line", "fast drumming rhythm", "energetic", "youthful", "romantic", "love performance", "brass band", "trumpets blaring", "groovy", "passionate", "latin dancers", "latin dance rhythm"] | 1 | zNSV9GkpRfM | 5468 |
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;