musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "easygoing", musiccaps_aspects contains "electric guitar" and musiccaps_aspects contains "sentimental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- easygoing · 3 ✖
- electric guitar · 3 ✖
- sentimental · 3 ✖
- acoustic drums 2
- acoustic guitar 2
- bass guitar 2
- alternative rock 1
- catchy 1
- country music 1
- female voice 1
- fiddle 1
- flute 1
- gentle playing 1
- indie 1
- longing 1
- malaysian 1
- male vocal 1
- medium tempo 1
- mellow 1
- melodic singing 1
- pop music 1
- shouting-like singing 1
- slow tempo 1
musiccaps_names (array) 5 ✖
- Music 2
- Country 1
- Happy music 1
- Soul music 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dean Brody - Wildflower | This is a country music piece. There is a fiddle playing the main melody. The acoustic guitar and the electric guitar are playing gently in the background. The song has a slow tempo. The atmosphere is sentimental. This piece can be used in the soundtrack of an American drama movie, especially during the scenes where the feeling of longing is emphasized. | 2010-03-25T14:34:30Z | Dean Brody | ["Country"] | ["country music", "fiddle", "acoustic guitar", "electric guitar", "gentle playing", "slow tempo", "easygoing", "sentimental", "longing"] | 9 | -O9mnfC61Ac | 40 | ||
Tengku Adil - Babak Cinta Official Music Video HD | This is a Malaysian alternative rock music piece. There is a male vocalist singing melodically at the forefront. The main melody is played by the acoustic guitar with the backing of a mellow electric guitar and a simple bass line on the bass guitar. The rhythmic background consists of a basic rock acoustic drum beat. There is a sentimental and easygoing atmosphere to this piece. It could be used in the soundtrack of a drama/romance movie or TV series that takes place in Malaysia. | 2012-02-18T09:35:21Z | tengkuadilmusic | Official Music Video for Babak Cinta. Artiste: Tengku Adil Song: Babak Cinta Director: Helmie Ezfar Production Team: Paint In Motion Studios Location: http://www.morningrocket.com and http://kamarseni.com For bookings and enquiries email to: music.tengkuadil@gmail.com Kord Lagu Verse - D Bm Em Gm Chorus - D Bm Em-Gm Bridge - Bm D G A Solo - Bb C D, Bb C A Outro - D F#m G A# | ["Music", "Wedding music"] | ["malaysian", "alternative rock", "indie", "male vocal", "melodic singing", "acoustic guitar", "electric guitar", "bass guitar", "acoustic drums", "sentimental", "easygoing", "mellow"] | 9 | 1BVSYfNCcv0 | 246 | |
LaLa - Lost Ones ♪ | This is a pop music piece. There is a female vocalist singing in a shout-like style. There is a flute and an electric guitar playing the melody with the bass guitar playing in the background. The rhythm is provided by a medium tempo acoustic drum beat. The tune is catchy. The piece is in the major key and there is an easygoing atmosphere to it. This piece could be used in the soundtrack of a sit-com during the credits section. | 2009-01-11T02:11:54Z | Hysteria | LaLa - Lost Ones DJ Vida V Presents American Mija no copyright to this video | ["Music", "Soul music", "Happy music"] | ["pop music", "female voice", "shouting-like singing", "flute", "electric guitar", "bass guitar", "acoustic drums", "easygoing", "catchy", "sentimental", "medium tempo"] | 9 | svNayU6q3Dg | 4987 |
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;