musiccaps_details (view)
3 rows where "youtube_published" is on date 2010-03-04 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- instrumental 2
- acoustic guitar 1
- aerophone 1
- brass 1
- brass band 1
- carnatic music 1
- clapping 1
- concert 1
- cozy 1
- devotional 1
- duel 1
- easygoing 1
- emphatic 1
- enthralling 1
- fast tempo 1
- folk music 1
- french horn 1
- french horn solo 1
- ghatak 1
- hindu deities 1
- indian classical 1
- irish 1
- jugalbandi 1
- lively 1
- loud 1
- male vocalist 1
- mandolin 1
- melodic 1
- minimalist 1
- mridangam 1
- muffled audio 1
- no accompaniment 1
- no singer 1
- people cheering 1
- ragas 1
- slow tempo 1
- south indian classical 1
- sruti 1
- stage performance 1
- steady tempo 1
- titanic music 1
- titanic soundtrack 1
- violin 1
- vocal duel 1
- wind instrument 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
MUSIC FROM TITANIC - French Horn Solo - James Stretton | This music is instrumental. The tempo is slow with a French Horn playing the Titanic soundtrack. The music is romantic, emotional, nostalgic, loud, lucid ,sad and poignant, mellow and sentimental. This music is a French Horn instrumental. | 2010-03-04T21:39:14Z | orichalcum1 | Music from Titanic always goes down well....... What's the difference between a French Horn and a Terrorist? Answer - You can negotiate with a terrorist!! The Guinness book of World Records states the most difficult of all musical instruments is - you guessed it THE FRENCH HORN (who am I to disagree) www.orichalcum-worldofbrass.com for further details. | ["Brass instrument", "French horn"] | ["instrumental", "slow tempo", "french horn", "minimalist", "no accompaniment", "wind instrument", "brass", "brass band", "french horn solo", "titanic music", "titanic soundtrack", "loud", "emphatic", "aerophone", "wind instrument"] | 7 | YTYj8Bk0qM8 | 3287 | |
Saint Anne's Reel on Guitar and Mandolin | This is an Irish folk music piece. The melody is being played by an acoustic guitar and a mandolin. The atmosphere of the piece is cozy and easygoing. It has a steady tempo. This piece could be used in the soundtrack of a documentary. It could also be playing in the background at an Irish pub or an Irish cuisine restaurant. | 2010-03-04T00:29:30Z | Ryan Kimm | Ryan Kimm and Mike Hedding doing that old fiddle tune Saint Anne's Reel. Tabs and Practice tracks available for this tune and other fiddle tunes at http://www.musicwithryan.com Check out more fiddle tunes and free lesson videos at http://www.youtube.com/channel/UCjEo6w49rYrwFNy6cXWRe6A | ["Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["irish", "folk music", "no singer", "instrumental", "acoustic guitar", "mandolin", "cozy", "lively", "easygoing", "steady tempo"] | 9 | Ts04bBeY1d4 | 2871 | |
Chembai and Yesudas Shiva Shiva Shiva enarAdA - 2 of 3 | Two male vocalists sing this melodic Indian Classical music. The tempo is medium slow with Carnatic music accompaniments like violin, Ghatak and mridangam. The song is a good natured vocal duel between two carnatically trained vocalists. There is the sound of people cheering and clapping to the beat in the background. | 2010-03-04T07:13:39Z | Sunil Anandatheertha, PhD | This is a classic by "Chembai and Yesudas". In this concert, we get a rare chance to know the Guru-Sishya sambandha of these two great vocalists, wherein, Chembai is actually teaching Yesudas and Yesudas tries very hard to follow his Guru. :) http://vishnuiseverywhere.blog | ["Carnatic music", "Music", "Middle Eastern music", "Classical music"] | ["male vocalist", "fast tempo", "ghatak", "devotional", "hindu deities", "mridangam", "ragas", "sruti", "violin", "carnatic music", "indian classical", "south indian classical", "people cheering", "clapping", "jugalbandi", "duel", "vocal duel", "enthralling", "melodic", "muffled audio", "concert", "stage performance"] | 7 | GHyUAl9Yaos | 1708 |
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;