musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "punchy", musiccaps_aspects contains "vibrant" and musiccaps_aspects contains "vivacious"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- animated 2
- buoyant 2
- punchy · 2 ✖
- vibrant · 2 ✖
- vivacious · 2 ✖
- youthful 2
- atmospheric synthesiser 1
- auto tune 1
- backup vocals 1
- bright bass lines 1
- bright vocals 1
- burgeoning tempo 1
- catchy beat 1
- classic rock 1
- club music 1
- dance music 1
- edm 1
- electronic music 1
- energetic electric guitar harmony 1
- enthusiastic 1
- fast tempo 1
- female singer 1
- female vocalisation 1
- foreign language introduction 1
- hard hitting drums 1
- keyboard accompaniment 1
- loud electric guitar feed 1
- male singer 1
- mellow piano introduction 1
- multi singer song 1
- music building up 1
- perky 1
- piano accompaniment 1
- pop rock 1
- spirited 1
- teen pop 1
- vigorous drumming 1
musiccaps_names (array) 3 ✖
- Music 2
- Angry music 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
*** DJ Earworm United State of Pop 2012 *** | A male singer sings this high energy EDM. The tempo fast with the song starts with a slow female vocalisation, soft piano accompaniment and takes off to an upbeat groove. The song is groovy, youthful, buoyant, vivacious;punchy and vibrant with atmospheric synthesiser, hard hitting drumming, funky bass line, spirited electric guitar harmony along with enthusiastic vocals. The vocals are auto tuned and the use of heavy electronic instrumentation make it an ultimate EDM. | 2010-07-09T15:14:12Z | RnBxclusiiVe | ***** Comment / Rate / Subscribe ***** * I Don't own this music * | ["Music", "Zing"] | ["electronic music", "male singer", "female vocalisation", "vivacious", "catchy beat", "vibrant", "animated", "burgeoning tempo", "multi singer song", "auto tune", "punchy", "buoyant", "piano accompaniment", "hard hitting drums", "loud electric guitar feed", "mellow piano introduction", "music building up", "edm", "atmospheric synthesiser", "youthful", "spirited"] | 7 | 3tyb0cXoX2g | 516 | |
Hawaiian Roller Coaster Ride- Jump 5 (Lyrics) | A female vocalist sings this spirited pop song. The tempo is fast with vigorous drumming, animated electric guitar harmony, keyboard accompaniment and groovy bass lines along with backup vocals. The first bit of the song is sung in foreign language. The song is energetic, youthful, passionate, vibrant and vivacious with a dance groove. This song is Teen Pop/Pop Rock. | 2009-08-22T02:50:00Z | Javiix7 | lyrics this is one of my favorite songs | ["Music", "Angry music"] | ["female singer", "fast tempo", "vigorous drumming", "teen pop", "foreign language introduction", "vibrant", "vivacious", "teen pop", "dance music", "club music", "energetic electric guitar harmony", "bright bass lines", "bright vocals", "backup vocals", "animated", "youthful", "enthusiastic", "dance music", "perky", "punchy", "buoyant", "pop rock", "classic rock", "keyboard accompaniment"] | 7 | id5ibIqjRto | 4208 |
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;