musiccaps_details (view)
2 rows where musiccaps_aspects contains "strings", musiccaps_names contains "Bowed string instrument" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- strings · 2 ✖
- bass trombone 1
- brass section 1
- horn section 1
- instrumental 1
- no percussion 1
- no voices 1
- orchestra 1
- orchestral ballade 1
- symphonic song 1
- theme of impending danger 1
- uplifting mood 1
musiccaps_names (array) 8 ✖
- Bowed string instrument · 2 ✖
- Brass instrument · 2 ✖
- Violin, fiddle 2
- Cello 1
- Double bass 1
- French horn 1
- Orchestra 1
- Trombone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ballade for Bass Trombone, Harp and Strings | A bass trombone is playing a melody while violas and violins support with a long melody in the mid and higher register. This song may be playing live. | 2009-04-23T16:43:29Z | KarlWiederwohl | Composed by Eric Ewazen; Karl Wiederwohl, bass trombone. Live recital performance April 7, 2009. Videography by Krishna Bhamidipati. Due to YouTube's time limitations the video has been cut short. | ["Brass instrument", "Trombone", "Violin, fiddle", "Bowed string instrument"] | ["orchestral ballade", "bass trombone", "strings"] | 6 | nY4tpb8O_Rg | 4549 | |
Mahler Symphony No 5, horn solos 3rd mov- Abel Pereira | This symphonic song features an orchestra. At the beginning, a French horn plays a melody. This is followed by a harmony played by the string section and brass section. There is no percussion in this song. This song is uplifting. The mood of this song is suspenseful. This song can be played in a movie where a dangerous scene is taking place. | 2012-05-01T15:03:06Z | brassgang2 | Mahler Symphony No 5, horn solos 3rd mov - Abel Pereira, Porto Symphony Orchestra, Casa da Música, Orquestra Sinfónica do Porto | ["Brass instrument", "Cello", "Double bass", "French horn", "Orchestra", "Violin, fiddle", "Bowed string instrument"] | ["symphonic song", "orchestra", "horn section", "no percussion", "strings", "brass section", "instrumental", "no voices", "uplifting mood", "theme of impending danger"] | 0 | v4sANJkuwP4 | 5151 |
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;