musiccaps_details (view)
3 rows where musiccaps_aspects contains "electronic drums", musiccaps_author = 9 and musiccaps_names contains "Tender music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- electronic drums · 3 ✖
- groovy 2
- melodic singing 2
- repeated theme 2
- acoustic guitar 1
- bass guitar 1
- danceable 1
- easygoing 1
- energetic 1
- female vocal 1
- keyboard 1
- melancholic 1
- modern r&b 1
- piano 1
- pop music 1
- resentment 1
- somali pop music 1
- teen female vocal 1
- teen pop 1
musiccaps_names (array) 4 ✖
- Music 3
- Tender music · 3 ✖
- Exciting music 1
- Sad music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Why - M2M Lyrics & Music | This is a teen pop music piece. There is a teen female vocalist singing melodically. The main tune is being played by the acoustic guitar. There is a bass guitar playing in the background. The electronic drums provide the rhythmic background. The piece has an easygoing atmosphere. This piece could be an opening theme for a teenage drama movie/TV show. It could also be playing in the background at a clothing store. | 2010-10-27T14:27:44Z | The Global Kiddo | My very first video on YouTube. This lyric video was made for self-expression. Otherwise, it can serve as a lyric video for audiences who want a lyric video. This channel claims no rights over the use of the music. Support my channel: buymeacoff.ee/theglobalkiddo Music owned by: WMG On behalf of: Atlantic Records Song Why Artist M2M Album Why Licensed to YouTube by: WMG (on behalf of Atlantic Records); UMPG Publishing, CMRRA, UNIAO BRASILEIRA DE EDITORAS DE MUSICA - UBEM, LatinAutor - Warner Chappell, Warner Chappell, LatinAutor - UMPG, LatinAutor, PEDL, BMI - Broadcast Music Inc., and 15 Music Rights Societies Attributions: M2M. Why. May 1 2007. https://youtu.be/bPO0ZDZ8qDk | ["Music", "Tender music"] | ["teen pop", "teen female vocal", "melodic singing", "acoustic guitar", "bass guitar", "electronic drums", "repeated theme", "easygoing"] | 9 | 06Brdf83RZE | 119 | |
Mona Lisa "Angel" (Max Sound HD Audio Version) Official Music Video | This is a pop music piece. There is a female vocalist singing melodically at the forefront with muffled repetitions of the same voice in the back. The simple and repeated theme is being played by a piano while the rhythmic background consists of an electronic drum beat with loud kick beats. There is a melancholic aura to this piece and a sense of resentment. This piece could be used in the soundtrack of a drama movie. | 2011-08-03T18:10:14Z | MonaLisaMusicVideos | Now on iTunes!***** "Angel" now on itunes: http://itunes.apple.com/us/album/angel-single/id464099477?uo=4 | ["Music", "Sad music", "Tender music", "Exciting music"] | ["pop music", "modern r&b", "female vocal", "melodic singing", "piano", "repeated theme", "electronic drums", "groovy", "melancholic", "resentment"] | 9 | bVc7-sZAi6s | 3630 | |
Soo Jaleec. Fartuun Omar 2011 - Directed by Nabiil Nur | This is a Somali pop music piece. There are multiple layers of the keyboard providing the melodic structure. The rhythmic structure is provided by an electronic drum beat. The atmosphere is energetic and danceable. This piece could be used in the soundtrack of a Somali sit-com as the opening theme. | 2011-02-19T14:53:50Z | NABIIL NUR | A fartun Omar music Video, Directed & Edited By Nabiil Nur. one of the best somali music arts around the world. this video was shot in Dubai. All copy rights reserved by Nabiil Nur | ["Music", "Tender music"] | ["somali pop music", "keyboard", "electronic drums", "energetic", "danceable", "groovy"] | 9 | vStedb9LiDk | 5184 |
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;