musiccaps_details (view)
3 rows where musiccaps_aspects contains "low quality", musiccaps_aspects contains "passionate male vocal" and musiccaps_names contains "Music of Asia"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- low quality · 3 ✖
- passionate male vocal · 3 ✖
- groovy bass 2
- harmonizing background vocals 2
- passionate 2
- shimmering hi hats 2
- claps 1
- electric guitar chords 1
- emotional 1
- energetic 1
- exciting 1
- folk 1
- groovy 1
- groovy piano melody 1
- mono 1
- noisy 1
- people cheering sounds 1
- pop 1
- shimmering shakers 1
- smooth bass 1
- snappy rimshot 1
- snare roll 1
- soulful 1
- sustained strings melody 1
- tinny snare 1
- wide electric guitar melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
365 Days- Leon Thomas III Ft. Victoria Justice W/Lyrics | The low quality recording features a pop song that consists of a passionate male vocal, alongside harmonizing background vocals, singing over people cheering sounds, shimmering hi hats, claps, snare rolls, groovy bass and wide electric guitar melody. It sounds energetic and exciting. | 2011-10-09T01:46:15Z | stephylove33 | Just in time for October!! Think Pink For Breast Cancer =) XOXO | ["Music of Asia"] | ["low quality", "pop", "harmonizing background vocals", "people cheering sounds", "claps", "shimmering hi hats", "snare roll", "passionate male vocal", "groovy bass", "wide electric guitar melody", "energetic", "exciting"] | 4 | JXS5eW7g4HY | 2016 | |
A Love I Can Feel Riddim (26 songs) - Beres, Sanchez, Frankie Paul, Busy Signal, etc. | The low quality recording features a passionate male vocal, alongside harmonizing background vocals, singing over tinny snares, snappy rimshots, shimmering hi hats, groovy bass and electric guitar chords. It sounds groovy and passionate. | 2012-05-24T15:52:14Z | DJ Riddim | Timeless lover's rock riddim Facebook – https://www.facebook.com/DJRiddimNYC?ref=hl Instagram - http://instagram.com/djriddim_ Twitter – https://twitter.com/DJRiddim_ | ["Music of Asia", "Funk", "Music", "Pop music", "Ska"] | ["low quality", "passionate male vocal", "harmonizing background vocals", "tinny snare", "shimmering hi hats", "snappy rimshot", "groovy bass", "electric guitar chords", "groovy", "passionate"] | 4 | c-85TtcfVSI | 3672 | |
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;