musiccaps_details (view)
3 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "groovy rhythm", musiccaps_aspects contains "vocal harmony" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Singing Rats | Animated vocalists singing a choral harmony. The song is medium tempo with no instrumentation, but just voices singing in various harmonic ranges. The song is cheerful and cartoonish. The song is a parody of a modern pop song with western classical music influences. | 2006-12-27T18:04:00Z | Persephone22 | Die singenden Weihnachtselche haben mich zu diesem Clip inspiriert*gg* Hier nun also die singenden Ratties. *vorhang auf schieb* | ["Music", "Synthetic singing"] | ["animated vocals", "chipmunk noises", "medium tempo", "cheerful", "high pitched vocals", "choral section", "dance rhythm", "groovy rhythm", "cartoony sounds", "vocal acapella", "no instrumentation", "vocal harmony", "choral harmony", "auto tuned vocals", "exciting", "parody"] | 1 | PSYURntIjuc | 2538 | |
𝐒𝐀𝐋𝐒𝐀 - 𝐛𝐚𝐢𝐥𝐚 𝐂𝐮𝐛𝐚𝐧 𝐬𝐭𝐲𝐥𝐞 - 𝐄𝐱𝐜𝐢𝐭𝐢𝐧𝐠 𝐒𝐚𝐥𝐬𝐚 ! | 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 | |
*NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | A male singer sings this hip hop dance song. The tempo is medium tempo with a groovy bass line, keyboard harmony and reggae inspired drumming rhythm. The song is story telling and romantic in nature. | 2014-07-16T20:50:50Z | OffDaGroundTV | Pre-Order "New Africa Nation" the Album now here: https://fuseodg.tmstor.es Shop for New Africa Nation Clothing online here : https://newafricanation.bigcartel.com/ / Fuse ODG's Album 'T.I.N.A' on iTunes: http://smarturl.it/FuseODGTINA *NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | ["Music", "Reggae"] | ["male singer", "hip hop music", "exciting", "people dancing", "modern love", "reggae hip hops music", "medium tempo", "dance rhythm", "male backup singers", "vocal harmony", "story telling", "groovy bass line", "guitar rhythm", "string harmony", "romantic", "groovy rhythm", "dance rhythm", "hip hop dance music", "emotional"] | 1 | jQYSfy4DzIc | 4253 |
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;