musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "strings" and musiccaps_names contains "Double bass"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- instrumental · 2 ✖
- strings · 2 ✖
- brass section 1
- downcast 1
- emotional 1
- horn section 1
- melancholic 1
- no percussion 1
- no singer 1
- no voices 1
- orchestra 1
- piano 1
- soap opera music 1
- symphonic song 1
- theme of impending danger 1
- uplifting mood 1
musiccaps_names (array) 7 ✖
- Bowed string instrument 2
- Cello 2
- Double bass · 2 ✖
- Brass instrument 1
- French horn 1
- Orchestra 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 |
---|---|---|---|---|---|---|---|---|---|---|
Sad Music - Emanetin Bende Sakli - Toygar Isikli | This is an instrumental music piece that was made for a soap opera soundtrack. The piano and the strings are playing gently in a melancholic manner. The atmosphere of the piece is emotional. This piece could be used in the soundtrack of a drama movie during scenes of hopelessness or heartbreak. | 2012-12-02T00:07:15Z | Moustafa Hodroj | ["Cello", "Double bass", "Bowed string instrument"] | ["soap opera music", "no singer", "instrumental", "piano", "strings", "melancholic", "emotional", "downcast"] | 9 | P4aTFrJws40 | 2501 | ||
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;