musiccaps_details (view)
2 rows where musiccaps_aspects contains "no voice" and musiccaps_names contains "Trumpet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- no voice · 2 ✖
- brass instruments 1
- brass section 1
- hand claps 1
- horn 1
- instrumental 1
- instrumental music 1
- no percussion 1
- orchestral music 1
- piano 1
- relaxing song 1
- romantic theme 1
- slow pop song 1
- slow tempo 1
- symphonic feel 1
- tambourine 1
- trombone 1
musiccaps_names (array) 3 ✖
- Brass instrument 2
- Trombone 2
- Trumpet · 2 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Robots by Dan Mangan | This slow pop song features the brass section playing the main melody in harmony. This is accompanied by hand claps on every alternate count. A tambourine plays a rhythmic beat in the background. Two piano notes are played in the background in the first bar of the song. There are no voices in this song. This instrumental song has a romantic theme. This song can be played in a romantic movie. | 2009-08-20T01:31:13Z | Taylor Jones | This song is called Robots and is preformed by Dan Mangan. This is a compilation of photos. | ["Brass instrument", "Trombone", "Trumpet"] | ["slow pop song", "hand claps", "tambourine", "brass section", "no voice", "instrumental", "piano", "romantic theme"] | 0 | T7khbuOBHbo | 2814 | |
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;