musiccaps_details (view)
2 rows where musiccaps_aspects contains "calming", musiccaps_aspects contains "instrumental" and musiccaps_names contains "Brass instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- calming · 2 ✖
- instrumental · 2 ✖
- acoustic sounding drums 1
- bass guitar 1
- classical music 1
- french horn 1
- gentle 1
- keyboard 1
- no singer 1
- piano 1
- serene 1
- slow tempo 1
- soothing 1
- trumpet 1
musiccaps_names (array) 3 ✖
- Brass instrument · 2 ✖
- French horn 1
- Saxophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Francis Dupont - Forever Love (Calming, Relaxing, Soothing Trumpet Music ) | This is an instrumental trumpet music piece. The trumpet is playing a calming main melody while the keyboard and the bass guitar are playing in the background. There is a slow tempo acoustic sounding drum beat playing the rhythm. The atmosphere is soothing.This piece could be used in the soundtrack of an art movie. It could also be playing in the background at a sauna. | 2012-05-24T08:36:32Z | Tatiana Blue | Always in love with nature ... Select the optimal resolution 720p Thank you all for viewing and comments! All the best! http://www.youtube.com/user/bluesensation75?feature=mhee http://www.youtube.com/user/TBluedream?feature=watch | ["Brass instrument", "Saxophone"] | ["no singer", "instrumental", "trumpet", "keyboard", "bass guitar", "acoustic sounding drums", "calming", "soothing", "slow tempo"] | 9 | VlwbDjggUKk | 3030 | |
"Villanelle for Horn" - Paul Dukas. | This is a classical music piece. The french horn is playing the main melody in a gentle manner. In the meantime, the piano is playing a backing tune. There is a serene atmosphere to this piece. This music could go well in the soundtrack of a still life TV series. It could also be playing in the background at a classy restaurant. | 2014-06-06T20:15:12Z | ransome51 | Dennis Brain, horn. Gerald Moore, piano. | ["Brass instrument", "French horn"] | ["classical music", "instrumental", "french horn", "piano", "gentle", "serene", "calming"] | 9 | chwqnnaiYXw | 3733 |
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;