musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "generic", musiccaps_aspects contains "rock music" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- electric guitar 2
- generic · 2 ✖
- rock music · 2 ✖
- acoustic drums 1
- acoustic sounding drums 1
- advertisement 1
- common sounding 1
- drill sounds 1
- instrumental 1
- jingle 1
- keyboard 1
- loud 1
- simple tune 1
- sound effects 1
- tutorial 1
- underwater 1
musiccaps_names (array) 3 ✖
- Music · 2 ✖
- Dental drill, dentist's drill 1
- Gurgling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Water Wolf Camera Tutorial | This is a rock music piece playing in the background of a tutorial video. There is an electric guitar playing a simple tune as the lead while another provides a rhythmic backing by playing the same note repeatedly in rapid procession. There is an acoustic drum beat playing. There are water sound effects related to the video. The piece has a generic feeling. It does not evoke much excitement. It could be used as a jingle for an advertisement or in the background of an instructive video. | 2014-06-27T08:50:52Z | Savage Gear | ["Music", "Gurgling"] | ["rock music", "tutorial", "electric guitar", "acoustic drums", "sound effects", "underwater", "loud", "generic", "common sounding"] | 9 | -taO6N-rxv4 | 96 | ||
電鑽佬-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;