musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic sounding drums" and musiccaps_aspects contains "keyboard" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 16 ✖
- acoustic sounding drums · 2 ✖
- instrumental 2
- keyboard · 2 ✖
- advertisement 1
- bass guitar 1
- calming 1
- drill sounds 1
- electric guitar 1
- generic 1
- jingle 1
- no singer 1
- rock music 1
- simple tune 1
- slow tempo 1
- soothing 1
- trumpet 1
musiccaps_names (array) 4 ✖
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 | |
電鑽佬-Bosch GSB 1080-2-LI 充電式鋰電電批 (可鑽牆身) | This is a jingle piece played in the background of an advertisement video. There are sounds coming from a drill. The piece in the background is an instrumental rock music piece. There is a keyboard and an electric guitar playing the melody while an acoustic sounding drum beat provides the rhythm. The sounds are bland and generic. The piece could be of some use as an advertisement jingle or it could be playing in the background of an instructive/tutorial video. | 2015-07-19T10:59:44Z | 電鑽佬 | 可到以下網址購買 https://hk.user.auctions.yahoo.com/hk/booth/wing1213142003 | ["Music", "Dental drill, dentist's drill"] | ["advertisement", "jingle", "drill sounds", "rock music", "instrumental", "electric guitar", "keyboard", "acoustic sounding drums", "generic", "simple tune"] | 9 | 0dPx94RPy2M | 193 |
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;