musiccaps_details (view)
5 rows where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "melodic singing", musiccaps_author = 9, musiccaps_names contains "Independent music" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Donovan - Wear your love like heaven. | This is a psychedelic rock music piece. There is a male vocalist singing melodically in the lead. The main melody is being played by the keyboard with the backing of the electric guitar and the bass guitar. The rhythmic background consists of a rock acoustic drum beat. The atmosphere is chill and trippy. This piece could be used in the soundtrack of a drama movie or a TV series that has scenes of hallucinogenic trip sequences. It could also be playing in the background at a hippie coffee shop. | 2007-08-27T17:00:17Z | Zack Taylor | Note: I do not own any of the content in this video Please support me by clicking the ads on my videos :) Thanks Donovan - Wear your love like heaven. Peace out. | ["Music", "Independent music"] | ["psychedelic rock", "folk rock", "male vocal", "melodic singing", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "chill", "trippy", "psychedelic"] | 9 | 5i0zq91Ocz0 | 684 | |
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 | |
september rain | This is a Japanese pop music piece. The music has a 70s feel to it. There is a female vocalist singing melodically at the forefront. There is a keyboard playing a melody while being backed by an electric guitar and a bass guitar. There is a simple acoustic drum beat in the rhythmic background. The piece has a melancholic, haunting atmosphere to it. This piece could be used in drama movies and TV series that take place in Japan. | 2007-06-22T14:57:44Z | kklichiang | kugatsu__ame | ["Music", "Independent music"] | ["japanese pop", "female vocal", "melodic singing", "keyboard", "electric guitar", "bass guitar", "acoustic drums", "melancholic", "haunting", "romantic"] | 9 | Uxyu3XwXEV8 | 2963 | |
ROSE N FLY after MV (korea indie band) | This is a Korean indie rock piece. There is a male vocalist in the lead singing melodically. The main tune is being played by an acoustic guitar with an electric guitar and a bass guitar backing. There is a 4/4 slow tempo acoustic drum beat playing in the rhythmic background. The atmosphere is easygoing. This piece could be used in the soundtrack of a drama movie or TV series that takes place in Korea. | 2010-12-19T12:14:19Z | ROSE N FLY LAUS DEO | ["Singing", "Music", "Independent music", "Pop music", "Song"] | ["korean indie rock", "alternative rock", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "acoustic drums", "gentle", "mellow", "easygoing", "simple tune", "slow tempo"] | 9 | cnvmLwFZr28 | 3742 | ||
Cry In My Heart | This is a Christian rock/CCM piece. There is a male vocalist singing melodically. The main melody is being played by the acoustic guitar. The electric guitar, the piano and the bass guitar are playing in the background. The rhythm consists of an easygoing acoustic drum beat. The atmosphere is religious. This piece could be used in the soundtrack of a gospel movie. It could also be playing in the background at a Christian religious event. | 2008-04-04T03:20:47Z | fansofstarfield | "Cry In My Heart" There's a cry in my heart For Your glory to fall For Your presence to fill up my senses There's a yearning again A thirst for discipline A hunger for things that are deeper Could You take me beyond? Could You carry me through? If I open my heart? Could I go there with You? (For I've been here before But I know there's still more Oh, Lord, I need to know You) For what do I have If I don't have You, Jesus? What in this life Could mean any more? You are my rock You are my glory You are the lifter Of my head Lifter of this head | ["Music", "Independent music"] | ["christian rock", "christian contemporary music", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "piano", "acoustic drums", "easygoing", "religious"] | 9 | nT1YAP4Vy9s | 4540 |
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;