musiccaps_details (view)
3 rows where musiccaps_aspects contains "noisy", musiccaps_aspects contains "passionate male vocal" and musiccaps_aspects contains "shimmering shakers"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- low quality 3
- noisy · 3 ✖
- passionate male vocal · 3 ✖
- shimmering shakers · 3 ✖
- mono 2
- passionate 2
- soulful 2
- 4 on the floor kick 1
- dynamic 1
- emotional 1
- folk 1
- funk 1
- funky keys melody 1
- groovy bass 1
- groovy piano melody 1
- harmonizing male vocals 1
- shimmering open hat 1
- smooth bass 1
- sustained strings melody 1
- unbalanced stereo 1
- wooden percussions 1
- wooden percussive elements 1
musiccaps_names (array) 6 ✖
- Music 2
- Funk 1
- Music of Africa 1
- Music of Asia 1
- Percussion 1
- Wood block 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Wildfire - Dance With Me - FUNK | The low quality recording features a funk song that consists of passionate male vocal singing over shimmering open hats and shakers, funky and groovy keys melody, groovy bass, wooden percussive elements and "4 on the floor" kick pattern. It is noisy, but also funky and the stereo image is unbalanced, as the song is leaning towards the right channel. | 2015-06-21T00:15:31Z | Djegu | Wild Fire – WFP-0003 http://www.discogs.com/Wildfire-Time-Is-The-Answer/release/3557173 http://www.juno.co.uk/products/tropical-disco-hustle-volume-2/569473-01/ | ["Music of Africa", "Funk", "Music"] | ["low quality", "funk", "funky keys melody", "shimmering shakers", "shimmering open hat", "passionate male vocal", "wooden percussive elements", "groovy bass", "4 on the floor kick", "noisy", "unbalanced stereo"] | 4 | DdxW_JziHTA | 1500 | |
OTIGBA UMUNOHA 2 | The low quality recording features a passionate male vocal chant, followed by harmonizing male vocals chants, after which a shimmering shaker and wooden percussion start playing. It sounds soulful, passionate and dynamic. The recording is mono and noisy. | 2012-12-22T07:55:13Z | nwaOkechi Nwafo Nnoha | ["Wood block", "Percussion"] | ["low quality", "wooden percussions", "passionate male vocal", "harmonizing male vocals", "dynamic", "passionate", "soulful", "shimmering shakers", "noisy", "mono"] | 4 | UxT3KG4AHAI | 2960 | ||
Kaun Hai Jo Sapnon Mein Aaya | Rajendra Kumar | Saira Banu | Jhuk Gaya Aasman Songs {HD}| Mohd. Rafi | The low quality recording features a folk song that consists of passionate male vocal singing over shimmering shakers, smooth bass, sustained strings melody and groovy piano melody. It sounds emotional, soulful and passionate - like something you would hear in movies. | 2012-06-20T08:40:04Z | Shemaroo Filmi Gaane | Movie : Jhuk Gaya Aasman (1968) Song: Kaun Hai Jo Sapnon Mein Aaya Starcast: Rajendra Kumar, Saira Banu Music Director: Shanker Jaikishan Singers: Mohammad Rafi Director: Lekh Tandon SUBSCRIBE now to FilmiGaane: https://goo.gl/mx4zPe To see all the latest music playlists that we've created just for you, click here https://www.youtube.com/user/filmigaane/playlists Download FilmiGaane App - http://twd.bz/fg Connect with us on:- Facebook - http://www.Facebook.com/FilmiGaane Twitter - http://Twitter.com/FilmiGaane Join us on Pinterest - http://pinterest.com/shemaroo Circle & Follow us on google.com/+filmigaane Sign up for Free and get daily updates on New Videos, exclusive Web Shows, contests & much more: http://youtube.shemaroo.com/default.aspx Send us your feedback and suggestions at connect@shemaroo.com Download the app now and share it with all the asli fans https://shemaroome.app.link/fjmW99wk3W Give a missed call on 18002665151 www.shemaroome.com Your one-stop destination for authentic Indian content now with the biggest cashback offer! Get upto 100% Paytm cashback on purchasing any pack worth Rs.129 or more! Hurry & subscribe now:https://shemaroome.app.link/Liw2f3z14bb | ["Music of Asia", "Music"] | ["low quality", "folk", "noisy", "mono", "passionate male vocal", "sustained strings melody", "shimmering shakers", "smooth bass", "groovy piano melody", "emotional", "passionate", "soulful"] | 4 | exD5okdopWc | 3911 |
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;