musiccaps_details (view)
3 rows where musiccaps_aspects contains "melodic singing" and musiccaps_aspects contains "sound effects" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- melodic singing · 3 ✖
- sound effects · 3 ✖
- acoustic drums 2
- bass guitar 2
- electric guitar 2
- energetic 2
- normal tempo 2
- ambient synth 1
- breath 1
- dance 1
- easygoing 1
- female vocal 1
- female voice 1
- funky 1
- generic 1
- hardcore 1
- high-pitched 1
- jingle 1
- loud electronic drums 1
- male vocal 1
- pop funk 1
- rave 1
- rock music 1
- stamp 1
- synth 1
- thai 1
musiccaps_names (array) 8 ✖
- Music 3
- Heart murmur 1
- Heavy metal 1
- Independent music 1
- Pop music 1
- Progressive rock 1
- Tick-tock 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects ▼ | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Break You - Yade | This is a hardcore rave music piece. There is a female vocalist singing melodically. The high-pitched synth is playing the main theme while an ambient synth with medium-pitched characteristics is playing in the background. A very loud and fast-paced electronic drum beat carries the rhythmic background. The atmosphere is very energetic. This piece could be used in an anime or a video game. It could also be used in DJ sets at rave venues. | 2011-10-21T17:27:56Z | Desuvi Music | Break You - Yade • Independent Artist Release • Free Download: http://soundcloud.com/yadedhardcore/01-yade-break-you-dj-promo-320 Yade: Listen: https://soundcloud.com/yadedhardcore Like: https://www.facebook.com/YadeHardcore Wanna hear more hardcore rave music? Subscribe! http://goo.gl/LKgneE • jordesuvi Tweet: http://www.twitter.com/jor_desu Tumblr: http://jordesu.tumblr.com/ Google+: http://www.google.com/+jordesuvi Producers submit your song to be promoted on jordesuvi here! http://full.sc/12sr1i7 | ["Music", "Zing"] | ["hardcore", "rave", "synth", "female voice", "melodic singing", "ambient synth", "loud electronic drums", "sound effects", "high-pitched", "energetic", "dance"] | 9 | JvvnL7UnCGA | 2046 | |
Cornetto Love Stories - Cut desktop Trailer eng | This is a pop funk piece used as a jingle for an ad. There is a male vocalist singing melodically while the electric guitar is playing a catchy tune with the bass guitar playing a groovy bass line. A normal tempo acoustic drum beat provides the rhythmic background. There are a couple of sound effects in the end. The piece has an easygoing atmosphere. It is the perfect match for a jingle. It could also be used in DJ sets or remixes. | 2015-07-03T10:38:53Z | Cornetto Netherlands | ["Heart murmur", "Music"] | ["pop funk", "jingle", "male vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "funky", "easygoing", "normal tempo", "sound effects", "breath", "stamp", "generic", "easygoing"] | 9 | H6qzijVEqZQ | 1775 | ||
7 o'clock Teaser นี่เธอไม่รู้หรือแกล้งไม่รู้ | This is a rock music piece. It starts with a clock. There is a female vocalist singing melodically in the Thai language. The overdriven electric guitar is strumming the chords of the main tune while the bass guitar is supporting it in the background. The acoustic drum is playing a simple but powerful beat. The general atmosphere is energetic. The piece can be used as a soundtrack in a coming-of-age drama taking place in Thailand. | 2009-09-03T06:40:52Z | Chanin Yanyong | The complete teaser of 7 o'clock นี่เธอไม่รู้หรือแกล้งไม่รู้ | ["Heavy metal", "Music", "Independent music", "Pop music", "Tick-tock", "Progressive rock"] | ["rock music", "thai", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "normal tempo", "sound effects", "energetic"] | 9 | B1beLwV4yzw | 1193 |
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;