musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "ballad" and musiccaps_names contains "Tender music" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- ballad · 2 ✖
- arpeggiated acoustic guitar melody 1
- cover 1
- emotional 1
- low quality 1
- male voice 1
- messy 1
- minimal instruments 1
- muddy 1
- no percussion 1
- noisy 1
- passionate muddy male vocal 1
- plucked guitar 1
- raw 1
- romantic song 1
- slow song 1
- slow tempo 1
musiccaps_names (array) 7 ✖
- Music 2
- Tender music · 2 ✖
- Acoustic guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Steel guitar, slide guitar 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
林宥嘉 Yoga Lin [ 寵兒 The Loved Ones ] Music Video (電影「我的蛋男情人」主題曲) 陳星合 Acoustic Cover | The low quality recording features a cover of a ballad song that consists of passionate, muddy male vocal singing over arpeggiated acoustic guitar melody. It sounds noisy, muddy and messy, as the frequencies are clashing, but it is also emotional and raw. | 2016-10-01T13:18:56Z | 我是星合HE's channel | 林宥嘉 [ 寵兒 The Loved Ones ] Acoustic Cover 吉他翻唱改編 ►陳星合Facebook粉絲頁 : https://www.facebook.com/shinghemusic ►Instagram : https://www.instagram.com/shinghe0807/ →歡迎追蹤與訂閱← 每週三都會有新的音樂作品哦!!! 希望你們會喜歡這次的翻唱 :) | ["Acoustic guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Strum", "Plucked string instrument", "Tender music"] | ["low quality", "passionate muddy male vocal", "arpeggiated acoustic guitar melody", "noisy", "muddy", "cover", "emotional", "ballad", "raw", "messy"] | 4 | -8cgbhIR_pw | 21 | |
BEST LOVE SONG - "LOVE" original Austin Nix | This song is a ballad which features a male voice singing the main melody. This is accompanied by a plucked guitar playing arpeggiated chords. There are no other instruments. There is no percussion. The mood of this song is romantic. This song can be played in a romantic movie. | 2011-02-12T12:28:39Z | Ken Nix | Other Austin Nix Songs: https://www.youtube.com/watch?v=bgbALOjce3c - Twenty-One https://www.youtube.com/watch?v=KNb3A5xvDZM - Funny Valentine Song Austin Nix New YouTube Channel https://www.youtube.com/channel/UCVZwveAVgdWUOY13YNTdeXQ *****LYRICS***** Love can blind us or leave us deaf rip a beating heart from our chest find us gasping for air for the one who took our breath. love can tie us in a knot say silly words when were taking a shot in the dark to see if she likes us or not. and love is the only thing that seems real other than pain its all i feel The constant stream that melts my mind surreal love, its coarsing through my veins when i see you im finally sane unique and never the same waiting for the change. of love, its coarsing through my brain more addictive than cocaine even harder to explain even harder to obtain. love, takes us for a ride keeps us afraid to close our eyes we can't even chance blinking or she'll disapear by surprise. love, can make the ground tremble beneath our toes sneak around right under our nose keep us moving 'til theres no where left to go. love, can be the greatest feeling on this earth for me she came first no im not cursed, I'm only waiting for her heart to disperse. love, its coarsing through my veins when i see you im finally sane unique and never the same waiting for the change. of love, its coarsing through my brain more addictive than cocaine even harder to explain even harder to obtain. 2018 "best valentine song" | ["Music", "Tender music"] | ["ballad", "plucked guitar", "slow song", "romantic song", "male voice", "slow tempo", "minimal instruments", "no percussion"] | 0 | 8BJljuSm2Aw | 900 |
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;