musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "trumpets" and musiccaps_names contains "French horn"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- instrumental · 2 ✖
- slow tempo 2
- trumpets · 2 ✖
- bass 1
- bells 1
- calm 1
- christian praise and worship 1
- christian song 1
- christmas song 1
- classical music 1
- contemporary christian music 1
- dulcet 1
- easter song 1
- emotional 1
- euphonious 1
- good friday 1
- gospel music 1
- instrumental cover 1
- mellow 1
- no voices 1
- piano accompaniment 1
- relaxing song 1
- rhythmic acoustic guitar 1
- sentimental 1
- sere 1
- soft 1
- soothing 1
- string section 1
- synthesiser arrangement 1
- trombone harmony 1
- tuba accompaniment 1
- xylophone 1
musiccaps_names (array) 2 ✖
- Brass instrument 2
- French horn · 2 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Thorns in the Straw | This song is an instrumental interlude of the Gospel song ‘Thorns in the Straw. The music is slow with a melancholic trombone and tuba harmony, acoustic guitar accompaniment , bass, steady drumming,and synthesiser arrangements. The music is soft, mellow, poignant,pensive, sentimental,emotional, reflective and serene. This song is a Gospel Instrumental. | 2008-12-22T00:26:42Z | Mike Rutter | A video using 'Thorns in the Straw' by Graham Kendrick | ["Brass instrument", "French horn"] | ["instrumental", "slow tempo", "rhythmic acoustic guitar", "trumpets", "trombone harmony", "tuba accompaniment", "bass", "piano accompaniment", "synthesiser arrangement", "soft", "mellow", "gospel music", "instrumental cover", "christian song", "christian praise and worship", "easter song", "good friday", "christmas song", "contemporary christian music", "mellow", "dulcet", "euphonious", "sentimental", "sere", "calm", "soothing", "emotional"] | 7 | 7OjXHfVoI64 | 843 | |
The hills are alive ( Julie Andrews-The Sound of Music) | This classical song features the main melody played by trumpets. This is accompanied by violins playing two note trills. A xylophone plays notes in the background. Church bells are played in the background. There is no percussion in this song. This is an instrumental song. There are no voices in this song. The mood of this song is relaxing. This song can be played in a magical scene in a movie. | 2012-05-04T04:18:50Z | scarletttarleton | Premier chant de Maria dans "The Sound of Music" (La Mélodie du bonheur) The hills are alive with the sound of music With songs they have sung for a thousand years The hills fill my heart with the sound of music My heart wants to sing every song it heard My heart wants to beat like the wings of the birds that rise from the lake to the trees My heart wants to sigh like the chime that flies from a church on a breeze To laugh like a brook when it trips and falls over stones on its way To sing through the night like a lark who is learning to pray I go to the hills when my heart is lonely I know I will hear what I've heard before My heart will be blessed with the sound of music And I'll sing once more. | ["Brass instrument", "French horn"] | ["classical music", "no voices", "string section", "bells", "trumpets", "instrumental", "relaxing song", "slow tempo", "xylophone"] | 0 | p_-lKpxLK3g | 4722 |
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;