musiccaps_details (view)
2 rows where musiccaps_aspects contains "hand percussion" and musiccaps_aspects contains "romantic" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- hand percussion · 2 ✖
- middle eastern music 2
- oud 2
- pleasant 2
- romantic · 2 ✖
- amplified flute 1
- amplified ney 1
- arabic music 1
- beautiful 1
- bongos 1
- breezy fresh 1
- bulgarian 1
- captivating 1
- catchy 1
- classical music 1
- club music 1
- congas 1
- dance music 1
- dance pop 1
- eastern classical 1
- electronic music 1
- female vocalist 1
- folk music 1
- groovy 1
- instrumental 1
- medium fast tempo 1
- medium tempo 1
- mesmerising 1
- ney 1
- nostalgic 1
- oud rhythm 1
- perky 1
- pop folk 1
- punchy 1
- regional music 1
- santoor 1
- santoor harmony 1
- simple melody 1
- steady drumming 1
- string instrument 1
- synthesiser arrangements 1
- tabla accompaniment 1
- tambourine beats 1
- traditional 1
musiccaps_names (array) 5 ✖
- Drum 1
- Music 1
- Music of Africa 1
- Percussion 1
- Tabla 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Kabul Afghanistan 1978-79 - Rabab & Tabla (Rubab) | This music is instrumental. The tempo is medium with a lilting middle eastern kind of melody on a string instrument that sounds like a santoor along with a classical tabla accompaniment. The music is traditional, classical, captivating, romantic and nostalgic. This music is an Eastern Classical instrumental. | 2011-06-18T23:13:06Z | Noor Khan | 'Nastaran' - Recorded one snowy night in Kabul, February 1978 Rabab - Mir Mohammad, Tabla - Jan Mohammad *** More photos plus samples of a new completely different book about Pakistan (Khyber Pukhtunkhwa-NWFP) at http://www.pbase.com/noorkhan | ["Tabla", "Drum", "Percussion"] | ["instrumental", "medium tempo", "middle eastern music", "eastern classical", "santoor", "nostalgic", "romantic", "beautiful", "traditional", "regional music", "folk music", "captivating", "string instrument", "classical music", "oud", "arabic music", "pleasant", "mesmerising", "romantic", "santoor harmony", "tabla accompaniment", "hand percussion"] | 7 | KJHqQ5aKu8U | 2073 | |
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 |
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;