musiccaps_details (view)
4 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "traditional"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- medium tempo · 4 ✖
- traditional · 4 ✖
- string instruments 2
- amateur recording 1
- arabic music 1
- bass 1
- beautiful 1
- captivating 1
- celticmusic 1
- classical music 1
- crickets chirping 1
- drums 1
- eastern classical 1
- epic 1
- flute 1
- flutes 1
- folk music 1
- guitarlike instrument 1
- guzheng 1
- hand percussion 1
- higher pitch 1
- instrumental 1
- male voice singing 1
- mesmerising 1
- middle eastern music 1
- nostalgic 1
- oud 1
- percussion 1
- pleasant 1
- regional music 1
- romantic 1
- santoor 1
- santoor harmony 1
- string instrument 1
- tabla accompaniment 1
- violins 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Celtic Music - The Gael (Promontory) | This audio contains a big soft kick drum hit along with a soft bassline changing into an even deeper octave. On top of that, violins and an acoustic guitar-like instrument are playing a melody. This recording has some reverb on it. This song may be playing in an adventure movie scene. | 2012-09-21T09:09:07Z | Serendipity | The music from The last of the Mohicans movie | ["Blues", "Music"] | ["celticmusic", "violins", "drums", "bass", "guitarlike instrument", "medium tempo", "traditional", "epic"] | 6 | 7B1OAtD_VIA | 818 | |
ทยอยใน เถา วงเครื่องสาย คณะศิลปกรรมศาสตร์ จุฬาลงกรณ์มหาวิทยาลัย | This song contains string instruments being played with a bow playing the main melody. Coming in after a flute starts playing the melody. An acoustic instrument is providing the rhythm. A guzheng is playing the same melody in a lower register. In the background you can hear crickets chirping. This song may be playing as a live performance from a music school. | 2012-03-05T21:28:19Z | Saisaw | ทยอยใน เถา จุฬาวาทิต ครั้งที่ ๑๗๐ วงเครื่องสาย คณะศิลปกรรมศาสตร์ จุฬาลงกรณ์มหาวิทยาลัย ควบคุมการบรรเลงโดย ศาสตราภิชานปกรณ์ รอดช้างเผื่อน และคณะ วันศุกร์ที่ ๒ มีนาคม ๒๕๕๕ เวลา ๑๗.๓๐ น. | ["Music", "Rattle (instrument)", "Bowed string instrument"] | ["traditional", "string instruments", "guzheng", "flute", "crickets chirping", "amateur recording", "medium tempo"] | 6 | 9m0tNvskmTc | 1039 | |
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 | |
U disco@Touch srey leak wedding jombok roiy | This recording is full of flutes and string instruments played with a bow. All of them are playing melodies spread across the sides of the speakers. Someone is playing a percussion instrument and a male voice is singing in a higher key. To me it sounds overloaded with too many melodies playing at the same time. This song may be playing in a traditional presentation. | 2007-06-09T23:25:10Z | Samang Mech | U disco@Touch srey leak wedding jombok roiy by Chin vonthanear | ["Folk music", "Music", "Wedding music"] | ["traditional", "flutes", "percussion", "male voice singing", "higher pitch", "string instruments", "medium tempo"] | 6 | jlmCu2GMoG4 | 4281 |
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;