musiccaps_details (view)
4 rows where musiccaps_aspects contains "harmonizing vocals" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- harmonizing vocals · 4 ✖
- low quality 4
- pop · 4 ✖
- energetic 3
- groovy bass 3
- punchy snare 3
- addictive 2
- punchy kick 2
- "4 on the floor" kick pattern 1
- emotional 1
- exciting 1
- groovy piano chords 1
- happy fun 1
- muffled female vocal 1
- passionate 1
- passionate male vocal 1
- pulsating synth lead melody 1
- shimmering cymbals 1
- shimmering hi hats 1
- shimmering shakers 1
- straight piano melody 1
- wide claps 1
- wide shimmering tambourine 1
- wooden percussive elements 1
musiccaps_names (array) 7 ✖
- Music 4
- /t/dd00032 1
- Exciting music 1
- Folk music 1
- Happy music 1
- Music of Asia 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Myanmar Funny Gay dancing music video | The low quality recording features a pop song that consists of groovy piano chords, harmonizing background vocals, punchy kick and snare hits, shimmering shakers, groovy bass and muffled female vocals singing over it. It sounds energetic, happy, fun and addictive - like something you would hear on a radio. | 2011-12-30T17:53:01Z | Moe Hein Lay | Myanmar Funny Gay dancing music video | ["Music of Asia", "Music", "/t/dd00032"] | ["low quality", "pop", "muffled female vocal", "punchy snare", "punchy kick", "shimmering shakers", "groovy piano chords", "groovy bass", "harmonizing vocals", "energetic", "addictive", "happy fun"] | 4 | JvqCsVj0I4k | 2045 | |
Far East Movement - She's On The Move HQ | The low quality recording features a pop song that consists of harmonizing vocals singing over punchy snare and kick hits and shimmering cymbals. It sounds energetic and exciting. | 2010-03-19T22:20:52Z | Paweł Szymański | Far East Movement - She's On The Move from Gossip Girl S03E14 'The Lady Vanished' I do not own any right to this video! | ["Music", "Exciting music"] | ["low quality", "pop", "harmonizing vocals", "punchy snare", "shimmering cymbals", "punchy kick", "energetic", "exciting"] | 4 | dT7uHHQEYHQ | 3789 | |
Charlie Puth - Marvin Gaye ft. Meghan Trainor | The low quality recording features a pop song that consists of a passionate male vocal, alongside harmonizing vocals, singing over wide claps, layered with shimmering tambourine, groovy bass and straight piano melody. It sounds emotional and passionate. | 2015-06-28T19:27:02Z | TheBlinkStudios | This video is dedicated to Mr. Charlie Puth... and Meghan Trainor. See you guys July 12th! | ["Singing", "Music", "Happy music"] | ["low quality", "pop", "straight piano melody", "harmonizing vocals", "passionate male vocal", "groovy bass", "wide claps", "wide shimmering tambourine", "passionate", "emotional"] | 4 | hrCf8rMBtA8 | 4146 | |
Ruben Sasunci ft. Gohar Hovhannisyan - Ari Zoravar // Armenian Folk // HF New // HD | The low quality recording features a pop song that consists of harmonizing vocals singing over pulsating synth lead melody, groovy bass, "4 on the floor" kick pattern, punchy snare, shimmering hi hats and some wooden percussive elements. It sounds energetic and addictive. | 2015-09-07T18:32:51Z | HayFanat | http://hayfanat.com Here is "Ari Zoravar" by Ruben Sasunci and Gohar Hovhannisyan. Music & Lyrics by Gusan Haykazun Follow HayFanat also on Facebook http://www.facebook.com/hayfanat Google+ http://www.google.com/+HayFanat Instagram https://instagram.com/hayfanatofficial Twitter https://twitter.com/hayfanat HayFanat.com © 2015. All Rights Reserved. | ["Folk music", "Music"] | ["low quality", "pop", "harmonizing vocals", "pulsating synth lead melody", "groovy bass", "\"4 on the floor\" kick pattern", "punchy snare", "shimmering hi hats", "wooden percussive elements", "energetic", "addictive"] | 4 | qjJ41iwU9LY | 4811 |
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;