musiccaps_details (view)
2 rows where musiccaps_aspects contains "subtle bass line" and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- subtle bass line · 2 ✖
- acoustic pop hits 1
- calming 1
- christian contemporary worship 1
- christian worship song 1
- church 1
- classic pop hits 1
- deteriorated audio quality 1
- devotion 1
- emotional 1
- female singer 1
- flute melody 1
- gratitude 1
- hall reverb 1
- hissing tones 1
- honour 1
- hymn 1
- inspiring 1
- keyboard harmony 1
- live audience 1
- live concert 1
- love 1
- love song 1
- male vocalist 1
- medium tempo 1
- mellow 1
- modern pop 1
- motivational 1
- piano accompaniment 1
- poor audio quality 1
- pop diva 1
- pop hit 1
- pop super hits 1
- praise and worship 1
- reverence 1
- rhythmic acoustic guitar 1
- soft vocals 1
- soothing 1
- soulful singing 1
- steady drumming 1
- story telling 1
- sunday worship 1
youtube_published (date) 2 ✖
- 2008-09-19 1
- 2012-09-29 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
chris tomlin amazing love | A male vocalist sings this soft Christian Worship song. The tempo is medium with a keyboard accompaniment, steady drumming, flute melody, subtle bass line; rhythmic acoustic guitar and soft vocals. The song is a melodious, soothing, prayerful, calm ,contemporary Christian Praise and Worship song. | 2008-09-19T16:22:10Z | floydss1 | worship for you | ["Christian music", "Music"] | ["male vocalist", "medium tempo", "keyboard harmony", "calming", "soothing", "reverence", "devotion", "gratitude", "love", "honour", "steady drumming", "subtle bass line", "flute melody", "mellow", "soft vocals", "praise and worship", "christian worship song", "hymn", "christian contemporary worship", "church", "sunday worship", "rhythmic acoustic guitar"] | 7 | EwoCbcSXlSM | 1601 | |
Adele crying at Royal Albert Hall - Someone like you live HD | A female pop star sings this lilting melody. The song is medium tempo with a piano playing accompaniment with a subtle bass line. The song is emotional and inspiring. The song is a modern pop hit played to a live audience. The song audio quality is poor and deteriorated. | 2012-09-29T19:17:31Z | Nil Iys | XL Records C. http://tinyurl.com/97zvsko Adele crying at Royal Albert Hall after singing someone like you! :) | ["Singing", "Christian music", "Music", "Song"] | ["female singer", "poor audio quality", "pop hit", "live concert", "emotional", "love song", "classic pop hits", "story telling", "live audience", "pop diva", "soulful singing", "piano accompaniment", "deteriorated audio quality", "hissing tones", "acoustic pop hits", "inspiring", "emotional", "love song", "motivational", "subtle bass line", "pop super hits", "modern pop", "hall reverb"] | 1 | nSinUcyFFqg | 4539 |
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;