musiccaps_details (view)
2 rows where musiccaps_aspects contains "catchy", musiccaps_aspects contains "romantic" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- catchy · 2 ✖
- pleasant 2
- romantic · 2 ✖
- amplified flute 1
- amplified ney 1
- amplified piano 1
- beautiful 1
- bongos 1
- breezy fresh 1
- bulgarian 1
- burgeoning melody 1
- captivating 1
- club music 1
- congas 1
- dance music 1
- dance pop 1
- electronic music 1
- euphonious 1
- female vocalist 1
- groovy 1
- hand percussion 1
- instrumental 1
- keyboard 1
- medium fast tempo 1
- medium tempo 1
- mellifluous 1
- middle eastern music 1
- ney 1
- oud 1
- oud rhythm 1
- perky 1
- piano harmony 1
- pop folk 1
- punchy 1
- simple melody 1
- soft introduction 1
- steady drumming 1
- synthesiser arrangements 1
- tambourine beats 1
- warm 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ANDREA (SAHARA) ft Kristali - NA EKS - produced by COSTI 2011 | A female vocalist sings this spirited pop. The tempo is medium fast with percussion accompaniment like congas, bongos and drums , tambourine beats,along with amplified flute like the Ney and rhythmic oud. The music is catchy, youthful, groovy, breezy, romantic, pleasant and spirited. This music is contemporary Folk Pop. | 2011-04-27T13:59:10Z | FORZZA MUSIC | Subscribe to my channel: https://bit.ly/ForzzaMusic Subscribe 👉https://bit.ly/2Siqg8P 🔝🎶 NA EKS - produced by COSTI COSTI Grammy Nominated Producer Billboard Hot💯🇺🇸🇷🇴 producer, songwriter, top-liner, compozitor & artist. FORTZAAAA 🔝🎶 Powered by Doctor Music® 2017 Productions & Booking : drstudio@costi.ro International PR Department : office@doctormusic.ro http://www.facebook.com/DrCosti.TheProducer http://twitter.com/CostiOfficial https://instagram.com/costiofficial/ http://www.soundcloud.com/CostiOfficial Costi (The Music Producer) - the first Romanian producer with a Grammy Nomination (Grammy Awards 2012) All rights reserved. Unauthorized reproduction is a violation of applicable laws. | ["Music of Africa", "Music"] | ["female vocalist", "medium fast tempo", "simple melody", "romantic", "breezy fresh", "pleasant", "groovy", "dance music", "dance pop", "club music", "tambourine beats", "catchy", "punchy", "perky", "amplified flute", "ney", "oud", "electronic music", "pop folk", "bulgarian", "middle eastern music", "hand percussion", "congas", "bongos", "steady drumming", "synthesiser arrangements", "amplified ney", "oud rhythm"] | 7 | tJHFSRTPyew | 5026 | |
Imogen Heap - Hide and Seek (piano) | This music is instrumental. The tempo is medium with a beautiful piano harmony. The music starts softly and builds up to a beautiful melody. It is mellow, romantic, warm, cheerful and pleasant. This is a Piano Instrumental. | 2008-12-02T06:41:43Z | ModistOne | My piano rendition of Imogen Heap's "Hide and Seek". High Quality Mp3: http://www.megaupload.com/?d=835H56F0 Questions? Check the FAQ in my profile! And be sure to check out my other videos! | ["Electric piano", "Keyboard (musical)"] | ["instrumental", "medium tempo", "piano harmony", "pleasant", "euphonious", "warm", "keyboard", "amplified piano", "soft introduction", "burgeoning melody", "beautiful", "mellifluous", "captivating", "catchy", "romantic"] | 7 | zYRI-R2gxUI | 5489 |
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;