musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "no singer" and musiccaps_names contains "Brass instrument" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- bass guitar 2
- instrumental 2
- no singer · 2 ✖
- acoustic sounding drums 1
- calming 1
- cheerful 1
- electronic drums 1
- keyboard 1
- playful 1
- slow tempo 1
- soothing 1
- trumpet 1
- trumpets 1
- upbeat 1
- wind band 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 | |
Mum and the Trumpet Girls (Bugler's Holiday) | This is an instrumental wind band music piece. There are three trumpets playing the main melody while a wind instrument sound is playing a supporting tune. There is a bass guitar playing in the background. The rhythm consists of a simple electronic drum beat. The atmosphere is playful and cheerful. This piece could be used in the soundtrack of a kids TV show. | 2010-10-26T09:13:56Z | krystalstawarz95 | ["Brass instrument", "Trumpet"] | ["no singer", "instrumental", "wind band", "trumpets", "bass guitar", "electronic drums", "playful", "upbeat", "cheerful"] | 9 | Z0O2r0Dl2T4 | 3334 |
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;