musiccaps_details (view)
2 rows where musiccaps_aspects contains "advertisement" and musiccaps_aspects contains "jingle"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- advertisement · 2 ✖
- jingle · 2 ✖
- accordion 1
- acoustic sounding drums 1
- bed creaking 1
- drill sounds 1
- electric guitar 1
- generic 1
- goofy tune 1
- instrumental 1
- keyboard 1
- laughter 1
- rock music 1
- simple tune 1
- sound effects 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
電鑽佬-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 | |
Torex Cough Syrup - Wedding Night Film | These are sounds coming from an advertisement. There are sound effects of bed creaking and laughter implying an intercourse is taking place. Then the act is interrupted by a goofy accordion tune. Sounds from this track can be used in soundboards or in beat-making. | 2012-12-20T17:06:07Z | Vihan Suryavanshi | Client - Torque Pharma Director - Vihan Suryavanshi Production Company - Dawn Motion Pictures Cinematography - Mitesh Mirchandani Associate Director - Prasad Shinde Executive Producer - Datta Londhe Creative - Sanjay Talpade Music - Amar Manglurkar Production Design - Mayur Offline - Jayant (In House - Avitel) Online - Chetan (In House - Avitel) Costumes - Deepali Salvi Sound Design - Kunal (4D Studio) Animation - Bikash Padhee Make Up & Hair - Shailesh Pawar Assistant Director - Aayush Saxena Post Studio - Avitel Hard Work... | ["Music", "Thunk"] | ["advertisement", "jingle", "sound effects", "bed creaking", "laughter", "accordion", "goofy tune"] | 9 | DU5pD63Pv30 | 1481 |
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;