musiccaps_details (view)
2 rows where musiccaps_aspects contains "relaxing song" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- relaxing song · 2 ✖
- slow tempo 2
- bells 1
- brass instruments 1
- classical music 1
- horn 1
- instrumental 1
- instrumental music 1
- no percussion 1
- no voice 1
- no voices 1
- orchestral music 1
- string section 1
- symphonic feel 1
- trombone 1
- trumpets 1
- xylophone 1
musiccaps_names (array) 4 ✖
- Brass instrument · 2 ✖
- French horn 1
- Trombone 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Giovanni Gabrieli Sacra Symphonia Sonata Pian'e Forte | This song features the brass section of a symphonic orchestra. The melody is played on trumpets. It is accompanied by a trombone and a brass horn playing individual parts. This song is at a slow tempo and has a relaxing feel. There are no voices in this song. There is no percussion in this song. This song can be played when a hero is returning victorious from a battle. | 2010-06-23T21:36:58Z | Maurizio De Marco | Zubin Metha conducts The Brass Section of the Bayerische Staatsoper | ["Brass instrument", "Trombone", "Trumpet"] | ["brass instruments", "orchestral music", "trombone", "symphonic feel", "horn", "no percussion", "instrumental music", "no voice", "slow tempo", "relaxing song"] | 0 | rQeikHMQGOM | 4876 |
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;