musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "keyboard" and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- bass guitar 2
- keyboard · 2 ✖
- cheerful 1
- christmas music 1
- dreamy 1
- electric guitar 1
- electronic drums 1
- emotional 1
- female vocal 1
- female vocals 1
- festive singing 1
- joyful 1
- male vocal 1
- male vocals 1
- melodic singing 1
- r&b 1
- remix 1
- romanian 1
- sleigh bells 1
- slow tempo 1
- soul 1
musiccaps_names (array) 3 ✖
- Christian music · 2 ✖
- Music 2
- Christmas music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
COLINDE SUPERBE NASTACUTA IUGA YouTube | This is a Christmas music piece. There is one male and one female vocalist singing in a festive manner in the Romanian language. There is a keyboard playing the melody and a bass guitar playing in the background. The rhythm is kept by the sleigh bells. The atmosphere is joyful. This piece could be playing in the background at a Christmas event in Romania. | 2012-11-22T21:22:42Z | Giuliano Bungardi | ["Christmas music", "Christian music", "Music"] | ["christmas music", "romanian", "male vocal", "female vocal", "festive singing", "bass guitar", "keyboard", "sleigh bells", "cheerful", "joyful"] | 9 | HTQySJM4Jhg | 1805 | ||
Be Strong ..xX | This is an R&B/soul music piece. There is a whole mix of male and female vocals singing melodically. The tune is being performed by the keyboard while the electric guitar and the bass guitar are playing in the background. There is a slow tempo electronic drum beat in the rhythmic background. The atmosphere is emotional. This piece could be used in the soundtrack of a romance movie, especially during the scenes of resolution. | 2006-10-28T13:51:06Z | xxnicholsonxx | a video made by me for heartbroken girls | ["Christian music", "Music"] | ["r&b", "soul", "remix", "male vocals", "female vocals", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "emotional", "dreamy", "slow tempo"] | 9 | MFxMPOAbUPA | 2250 |
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;