musiccaps_details (view)
3 rows where musiccaps_aspects contains "dramatic" and musiccaps_author = 8 sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- dramatic · 3 ✖
- opera 2
- orchestral accompaniment 2
- bright 1
- concert hall reverb 1
- cymbal crash 1
- delay 1
- effected trumpet 1
- energetic 1
- female singer 1
- glissando 1
- harp 1
- orchestral brass 1
- processed 1
- reverb 1
- solo trumpet 1
- stacatto 1
- string bass 1
- string ensemble 1
musiccaps_names (array) 6 ✖
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Amira Willighagen - O Mio Babbino Caro - Andre Rieu - Maastricht - July 2014 | A female opera singer accompanied by an orchestra featuring string bass, harp and string ensemble. It sounds like it was performed in a concert hall. Dramatic. | 2014-07-13T11:01:00Z | pa1189j | ["Singing", "Music", "Opera"] | ["opera", "female singer", "orchestral accompaniment", "string bass", "harp", "string ensemble", "concert hall reverb", "dramatic"] | 8 | Z0htOHTOtHY | 3336 | ||
Maa Jagdambe Chowki - 3rd March, 2013 | A solo trumpet playing an energetic staccato melody with dramatic glissandi. The trumpet has been processed to add a stereo delay effect and reverb. The tone is very bright. | 2013-03-22T12:15:10Z | Shri Radhe Maa | Maa Jagdambe Chowki in Radhe Maa's sannidhya for more details visit - http://goo.gl/WyEgh To know more about Shri Radhe Maa visit - radhemaa.com or contact Talli Baba ji - +91 982 096 9020 Basic facts about Mamtamai Shri Radhe Guru Maa 1) Mamtamai Shri Radhe Guru Maa is a devotee of Lord Shiva and Maa Durga 2) She considers herself a sevika of God 3) Her darshans have always been free and are open to all without exception 4) She is a guru who guides her followers to pray to Maa Durga and Lord Shiva and has never claimed to be an avatar or Goddess 5) She is not a 'new' guru. Her oldest devotees have been in her service for the last 25 years If you have any doubts/questions/ queries? 1) Visit her website www.radhemaa.com 2) Visit her facebookpage and discuss Shri Radhe Guru Maa with her devotees 3) Call sevadars who offer free service to Guru Maa and discuss what she is about 4) Visit Guru Maa's bhavan in Mumbai and take her darshan. It is free and open to all without exception PS : Info about her facebook page, name and contact numbers of her sevadars and darshan dates are all updated regularly on www.radhemaa.com. Call sevadar on 9820969020 / 9820969020 to know more Copyright All titles in the film & video collection are copyrighted. Unauthorized use or duplication of the content of the video in any manner is strictly prohibited without the prior written permission of its owner. (c) 2012. All Rights Reserved. Sanjeev Gupta | e-mail : sanjeev@globaladvertisers.in | Fax: +91 22 2893 9404 | ["Wind instrument, woodwind instrument", "Shofar"] | ["effected trumpet", "processed", "reverb", "delay", "bright", "energetic", "solo trumpet", "glissando", "stacatto", "dramatic"] | 8 | mBG-st0VUXs | 4452 | |
Sarah Brightman performing 'Music Of the Night' at Queen Mother's 90th Birthday Gala 1990 | Dramatic female opera singer accompanied by orchestra and brass and cymbal crash. | 2010-06-23T02:57:11Z | tapesalvage | Sarah Brightman performing 'Music Of the Night' from Phantom Of the Opera at Queen Mother's 90th Birthday Gala 1990 | ["Singing", "Music", "Opera", "Classical music"] | ["opera", "dramatic", "cymbal crash", "orchestral brass", "orchestral accompaniment"] | 8 | XUzaEsoOlWQ | 3187 |
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;