musiccaps_details (view)
3 rows where musiccaps_aspects contains "horn section", musiccaps_aspects contains "instrumental" and musiccaps_author = 0
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- brass section 3
- horn section · 3 ✖
- instrumental · 3 ✖
- no percussion 2
- no voices 2
- battle song 1
- classical orchestra 1
- complex arrangement 1
- epic feel 1
- no other instruments 1
- no voice 1
- orchestra 1
- orchestra music 1
- slow tempo 1
- string section 1
- strings 1
- symphonic song 1
- theme of impending danger 1
- timpanie 1
- uplifting mood 1
musiccaps_names (array) 9 ✖
- Brass instrument 2
- French horn 2
- Orchestra 2
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Trombone 1
- Trumpet 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
London Philharmonic Orchestra Plays The 50 Greatest Pieces of Classical Music | This classical song features an orchestra playing a complex song. The string section plays the main melody. The horn section plays the bass harmony. The brass section plays the backing parts. The bass is played on a cello. At the beginning there is no percussion. Toward the end, the timpani is played as part of the percussion. The melody is complex. The mood of this song is epic and victorious. This song can be played in a successful bank robbery scene. | 2009-11-10T16:37:53Z | X5MusicGroup | Behind the scenes footage when London Philharmonic Orchestra records the 50 most beloved pieces of classical music. A unique recording for digital release only. Recorded in Abbey Road Studio and Royal Festival Hall, mastered at Abbey Road. | ["Orchestra"] | ["classical orchestra", "string section", "timpanie", "brass section", "horn section", "epic feel", "no voice", "instrumental", "complex arrangement"] | 0 | 7EvLwfwRrqA | 820 | |
Britten: War Requiem / Rattle · Rundfunkchor Berlin · Berliner Philharmoniker | This song features the main melody played on a french horn and on a trumpet. The first part of the song is played on a french horn and the melody is continued on the trumpet. There are no other instruments in this song. The trumpet plays a battle call pattern. This is an instrumental song. There are no voices in this song. This song can be played just before a battle scene in a movie. | 2013-07-30T09:00:13Z | Berliner Philharmoniker | Full-length concert: http://www.digitalconcerthall.com/concert/3470/?a=youtube&c=true Benjamin Britten: War Requiem / Sir Simon Rattle, conductor · Simon Halsey, chorus master · Rundfunkchor Berlin · Berliner Philharmoniker / Recorded at the Berlin Philharmonie, 15 June 2013. The Berliner Philharmoniker's Digital Concert Hall: http://www.digitalconcerthall.com Subscribe to our newsletter: http://www.digitalconcerthall.com/newsletter Website of the Berliner Philharmoniker: http://www.berliner-philharmoniker.de | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["orchestra music", "horn section", "brass section", "no other instruments", "no percussion", "no voices", "instrumental", "battle song", "slow tempo"] | 0 | IGAzIIZRczw | 1887 | |
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;