musiccaps_details (view)
4 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- addictive · 4 ✖
- low quality 4
- noisy · 4 ✖
- passionate · 4 ✖
- punchy snare 2
- addictive brass melody 1
- addictive strings melody 1
- background pop instrumental 1
- buzzy synth lead melody 1
- cover 1
- echoing male chant 1
- emotional 1
- energetic 1
- energetic crash cymbal 1
- folk 1
- groovy bass 1
- mono 1
- passionate female vocal 1
- punchy kick 1
- roomy 1
- shimmering bells 1
- simple bass 1
- stuttering swing sound effect 1
- thin kick hits 1
- traditional 1
- wide harmonizing vocals 1
- wide toms 1
- wooden percussions 1
musiccaps_names (array) 13 ✖
- Music 2
- /t/dd00004 1
- Bagpipes 1
- Bass drum 1
- Bell 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Percussion 1
- Rimshot 1
- Singing 1
- Snare drum 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Impossible"- Shontelle( Katrina cover) | The low quality recording features a cover of a pop song. It is sung by passionate female vocalists over pop instrumental playing in the background. It is noisy and it sounds roomy as it is probably recorded with a phone or a camera microphone, but it is also emotional, passionate and addictive. | 2010-06-21T03:28:53Z | katrina briones | I DO NOT OWN ANY COPYRIGHTS its so nice to be back. i was just busy these past few days. but yeah lil' somethin for yah guys. i miss youtube!. :) Subscribe to me! yay!. i love ya'll Lyrics: i remember years ago someone told me i should take caution when it comes to love i did, i did and you were strong and i was not my illusion, my mistake i was careless, i forgot i did and now when all is done there is nothing to say you have gone and so effortlessly you have won you can go ahead tell them tell them all i know now shout it from the roof top write it on the skyline all we had is gone now tell them i was happy and my heart is broken all my scars are open tell them what i hoped would be impossible, impossible impossible, impossible falling out of love is hard falling for betrayal is worst broken trust and broken hearts i know, i know thinking all you need is there building faith on love and words empty promises will wear i know (i know) and know when all is gone there is nothing to say and if you're done with embarrassing me on your own you can go ahead tell them tell them all i know now shout it from the roof top write it on the skyline all we had is gone now tell them i was happy and my heart is broken all my scars are open tell them what i hoped would be impossible, impossible impossible, impossible impossible, impossible impossible, impossible impossible, impossible | ["Singing", "Music", "/t/dd00004"] | ["low quality", "cover", "passionate female vocal", "background pop instrumental", "noisy", "roomy", "emotional", "passionate", "addictive"] | 4 | 2f7NnTVQzR0 | 395 | |
Guild Wars 2 Wintersday Bell Choir - Billie Jean | The low quality recording features a shimmering bell melody, followed by some stuttering swing sound effects. It sounds passionate and addictive. | 2012-12-22T04:38:48Z | Hecksa | A cover of Billie Jean (originally by Michael Jackson), produced using only the notes available within the bell choir Wintersday activity in Guild Wars 2. Billie Jean is one of very few well known songs that can be fully (well, almost) played using the notes provided in the bell choir. What's a guy gotta do to get a nice simple major scale around here, eh? Happy Wintersday to all, and thanks to Arenanet for the cool minigame, even if it did use the wrong scale. | ["Bell", "Music"] | ["low quality", "noisy", "shimmering bells", "passionate", "addictive", "stuttering swing sound effect"] | 4 | fU9woCZqemw | 3950 | |
Badke: KVS/les ballets C de la B/A.M. Qattan Foundation (c) Zaina Zarour | The low quality recording features a folk song that consists of an echoing male chant over punchy kick and snare hits, wooden percussion, addictive strings and brass melodies and simple bass. It sounds traditional, addictive, passionate and energetic. The recording is noisy and in mono. | 2014-04-25T11:45:31Z | balletsCdelaB | In 2006, KVS, les ballets C de la B and the A.M. Qattan Foundation launched a series of workshops with young Palestinian performing artists. Now, Koen Augustijnen, Rosalba Torres (les ballets C de la B) and Hildegard De Vuyst (KVS) present the dance production Badke, for which they work with ten Palestinian performers, young autodidacts from various disciplines including contemporary dance, hip hop, circus, etc. The term 'badke' is a distortion of 'dabke', a Palestinian folk dance. The performance starts out from the popular variant: the people's social, festive dabke. The performers go on to confront this locally rooted dance with elements from worldwide pop (dance) culture. Badke becomes a quest for a dabke that not only conveys the unique Palestinian desire to 'belong somewhere', but also the wish to be part of a world beyond that. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["low quality", "mono", "noisy", "folk", "echoing male chant", "punchy snare", "punchy kick", "addictive strings melody", "addictive brass melody", "traditional", "addictive", "passionate", "wooden percussions", "simple bass", "energetic"] | 4 | kMmjr8deHis | 4312 | |
x..FirstLady..x Not okay with change | The low quality recording features a wide harmonizing vocals singing over wide toms, groovy bass, punchy snare, energetic crash cymbal, thin kick hits and buzzy synth lead melody. It sounds passionate and addictive thanks to that synth lead. The recording is noisy. | 2007-04-02T12:17:54Z | Susan Harrison | FABB song :p | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "wide harmonizing vocals", "wide toms", "punchy snare", "groovy bass", "thin kick hits", "buzzy synth lead melody", "addictive", "passionate", "energetic crash cymbal", "noisy"] | 4 | ow12iGt8z5Q | 4667 |
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;