musiccaps_details (view)
4 rows where musiccaps_aspects contains "groovy piano melody", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "shimmering shakers"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- groovy piano melody · 4 ✖
- low quality 4
- passionate · 4 ✖
- shimmering shakers · 4 ✖
- emotional 2
- folk 2
- groovy bass 2
- happy 2
- joyful 2
- sustained strings melody 2
- addictive 1
- breathy flute melody 1
- children song 1
- fun 1
- male vocal 1
- mellow 1
- mono 1
- noisy 1
- passionate boys vocals 1
- passionate girls vocals 1
- passionate male vocal 1
- salsa 1
- shimmering chime bells 1
- smooth bass 1
- soft 1
- soft kick 1
- soft snare 1
- soulful 1
- synth lead melody 1
- wooden percussion 1
- wooden percussions 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sozan Namo ( Seny Pr Ihm )* kurdish Music * | The low quality recording features a folk song that consists of a wooden percussion, groovy bass, breathy flute melody, groovy piano melody, shimmering shakers and sustained strings melody. It sounds passionate, joyful and happy. | 2010-05-10T13:43:42Z | Hemmen A M | Best Song .......... | ["Music", "Happy music"] | ["low quality", "folk", "wooden percussions", "groovy bass", "breathy flute melody", "groovy piano melody", "sustained strings melody", "shimmering shakers", "passionate", "happy", "joyful"] | 4 | -mA_bqD1tgU | 83 | |
تعليم اللغة العربية mari belajar bahasa arab | The low quality recording features a children's song that consists of passionate girls and boys singing over soft kick and snare hits, shimmering shakers located in the left channel of the stereo image, groovy bass, synth lead melody and groovy piano melody. It sounds soft, mellow, passionate, happy, fun and joyful - like something kids and babies would listen to. | 2009-01-17T06:13:40Z | Candy Crush Hamidi Lajis | Pengajaran dan pembelajaran Bahasa Arab Tahun 1 di Sekolah Kebangsaan berguna untuk rujukan murid dan guru-guru j-QAF | ["Christmas music", "Music", "Music for children"] | ["low quality", "shimmering shakers", "groovy piano melody", "synth lead melody", "groovy bass", "soft kick", "soft snare", "passionate boys vocals", "passionate girls vocals", "children song", "soft", "mellow", "passionate", "happy", "fun", "joyful"] | 4 | 98YBS2tdpdU | 977 | |
salsa cubana musica cubana inoel regeaton | The low quality recording features a salsa song that consists of a passionate male vocal singing over shimmering chime bells, wooden percussion, shimmering shakers and groovy piano melody. It sounds passionate, emotional and addictive. | 2008-08-02T01:08:58Z | InoelQuiros | New song by Inoel Quiros for the "Pura Salsa Na Ma" CD. Visit Inoel on MySpace @ www.myspace.com/inoelquiros. | ["Music of Africa", "Music", "Salsa music"] | ["low quality", "salsa", "groovy piano melody", "shimmering chime bells", "wooden percussion", "shimmering shakers", "passionate", "male vocal", "passionate", "emotional", "addictive"] | 4 | bTlp5Qr99RY | 3628 | |
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;