musiccaps_details (view)
2 rows where musiccaps_aspects contains "backup singers", musiccaps_aspects contains "bad audio quality" and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- backup singers · 2 ✖
- bad audio quality · 2 ✖
- male singer 2
- medium tempo 2
- autoharp accompaniment 1
- christian contemporary music 1
- church service 1
- classic county hits 1
- congregational music 1
- country classics 1
- country music 1
- enthusiastic 1
- euro pop 1
- everlasting hits 1
- exciting 1
- gospel band 1
- groovy rhythm 1
- guitar strumming 1
- hymns 1
- meditational 1
- nostalgia 1
- old memories 1
- organ accompaniment 1
- percussive bass line 1
- piano acc 1
- pleasant 1
- pop super hits 1
- praise and worship 1
- prayers 1
- rejoicing 1
- retro hits 1
- song cover 1
- steady drumming 1
- steady drumming rhythm 1
- story telling 1
- tambourine percussions 1
- vocal harmony 1
- walking bas s line 1
- walking bass line 1
musiccaps_names (array) 4 ✖
- Christian music · 2 ✖
- Music 2
- Gospel music 1
- Musical instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Aleksander Mežek - Siva pot | A male singer sings this popular country hit with backup singers in vocal harmony. The song is in medium tempo with a walking bass , acoustic guitar strumming rhythmically, autoharp accompaniment and steady drumming rhythm. The song is an emotional and nostalgic country hit. The audio quality is poor. | 2006-12-19T14:33:29Z | jaki386 | Aleksander Mežek - Siva pot | ["Christian music", "Music", "Musical instrument"] | ["male singer", "backup singers", "guitar strumming", "everlasting hits", "euro pop", "medium tempo", "walking bass line", "autoharp accompaniment", "walking bas s line", "steady drumming", "story telling", "nostalgia", "pleasant", "exciting", "enthusiastic", "old memories", "classic county hits", "pop super hits", "retro hits", "groovy rhythm", "country classics", "bad audio quality", "song cover", "country music"] | 1 | 3KQy3Cajo4E | 456 | |
Gospel Music - Because He Lives!! | A male singer leads backup singers into a gospel song in vocal harmony. The tempo is medium with a groovy bass line , organ accompaniment, tambourine percussion, guitar strumming and keyboard accompaniment. The song is prayerful and spirited. The song has bad audio quality. | 2007-10-06T00:34:24Z | Leah274 | Im not sure who is actually singing, i know the original guy is in the start then its another guy, i like this version. | ["Gospel music", "Christian music", "Music"] | ["male singer", "backup singers", "vocal harmony", "medium tempo", "percussive bass line", "tambourine percussions", "christian contemporary music", "praise and worship", "meditational", "congregational music", "hymns", "prayers", "rejoicing", "bad audio quality", "organ accompaniment", "gospel band", "church service", "steady drumming rhythm", "piano acc"] | 1 | wPmTJWybq_E | 5263 |
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;