musiccaps_details (view)
3 rows where musiccaps_aspects contains "fade out", musiccaps_aspects contains "pop" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- fade out · 3 ✖
- pop · 3 ✖
- low quality 2
- addictive 1
- bell impact 1
- cover 1
- energetic tom rolls 1
- groovy bass 1
- intimate 1
- modern 1
- outro 1
- passionate 1
- passionate female vocal 1
- punchy kick 1
- punchy snare 1
- shimmering cymbals 1
- shimmering shakers 1
- synth pad chords 1
- weird 1
- wide electric guitar melodies 1
- wide synth lead melody 1
musiccaps_names (array) 11 ✖
- Bass drum 1
- Cymbal 1
- Drum 1
- Drum kit 1
- Funk 1
- Hi-hat 1
- Percussion 1
- Rimshot 1
- Singing 1
- Singing bowl 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
What You Waiting For? (Jacques Lu Cont's TWD Mix) | The low quality recording features a wide synth lead melody, synth pad chords and a bell impact at the very end, which slowly fades out. It sounds modern and kind of weird, due to the sudden bell impact. | 2011-12-20T19:55:14Z | Daniel Fierro | Jacques Lu Cont (Aka Stuart Price) remix of Gwen Stefani's 'What You Waiting For?'. Originally released as the first single from the album 'Love. Angel. Music. Baby.' 2004 Interscope. Music owned by Interscope Records. | ["Singing bowl"] | ["pop", "wide synth lead melody", "synth pad chords", "bell impact", "fade out", "low quality", "modern", "weird"] | 4 | 5tNOauvQWQQ | 702 | |
Nasty Girl by Destiny's Child | The Pop song features a passionate female vocal singing over groovy bass, wide electric guitar melodies and shimmering shakers, as the overall audio is slowly fading out. It sounds addictive, passionate and intimate. | 2007-04-15T07:50:17Z | Bubblez1636 | Destiny's Child's song, Nasty Girl, with a compilation of video footage they made AFTERWARDS. Funny | ["Singing", "Funk"] | ["pop", "passionate female vocal", "groovy bass", "wide electric guitar melodies", "shimmering shakers", "fade out", "addictive", "passionate", "intimate"] | 4 | C-7ubPOCeJk | 1314 | |
Fede - Kesha - Your Love is My Drug (Drum Cover) World Version | The low quality recording features a drum cover of a pop song that consists of energetic tom rolls, shimmering cymbals and punchy kick and snare hits. The audio slowly fades out, as it is probably an Outro section of the song. | 2010-11-17T15:24:33Z | FedeRabaquino | Follow me on: Instagram: https://www.instagram.com/federabaquino Facebook: http://www.facebook.com/FedeRabaquinoMusic Twitter: http://www.twitter.com/FedeRabaquino I had to reupload this video due to copyright issues, I appologize for the audio quality, I had to pitch the song 1 semitone lower and touch the eq, to get a different wave of the track to avoid the copyright guys from bolcking my drum cover. I think that people in the US can still watch my original version with hi quality audio. Thank you guys for all the support and comments you leave on each video. About my youtube videos: I have 10 new drum covers, You can watch them in HD 720, I picked the songs, I´ll be uploding new videos every 2 weeks, The drum kit I used in this series is detailed on my youtube page. Please don´t forget to subscribe!!! Kesha - "Your Love is My Drug" from the 2010 release "Animal" Copyrighted property of its owner(s) -{}- Earphones & Headphones: MEElectronics | http://www.meelec.com | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "cover", "pop", "energetic tom rolls", "shimmering cymbals", "punchy kick", "punchy snare", "fade out", "outro"] | 4 | FvdUm5j_oA0 | 1677 |
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;