musiccaps_details (view)
2 rows where musiccaps_author = 7, musiccaps_names contains "Choir" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) >30 ✖
- medium tempo 2
- acoustic guitar 1
- ambient sounds 1
- choral backup 1
- christian gospel song 1
- christian music 1
- christian song 1
- christmas concert 1
- christmas song 1
- christmas time 1
- clapping 1
- devotional 1
- earnest 1
- electric guitar 1
- emotional 1
- emphatic vocals 1
- female singer 1
- fervent 1
- groovy bass 1
- heavy reverb 1
- hymns 1
- incoherent music 1
- keyboard accompaniment 1
- keyboard harmony 1
- live audience 1
- live performance 1
- male singer 1
- passionate 1
- poor audio quality 1
- praise and worship 1
- …
musiccaps_names (array) 7 ✖
- Choir · 2 ✖
- Music 2
- Singing · 2 ✖
- Christian music 1
- Christmas music 1
- Crowd 1
- Gospel music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Coro Gospel AGUAVIVA en Albacete 1 | A female vocalist sings this Gospel song. The tempo is medium with groovy bass lines, keyboard accompaniment, electric guitar and acoustic guitar rhythm,tambourine beats and choral harmony. The song is a spirited,emotional,fervent, earnest and devotional Christian Worship Song. | 2010-02-07T02:22:15Z | MakinGospel | Video Oficial producido por MAKINGOSPEL del concierto del Coro Gospel Aguaviva en Albacete el 21-03-09, primera parte. | ["Singing", "Gospel music", "Christian music", "Crowd", "Music", "Choir"] | ["female singer", "medium tempo", "electric guitar", "groovy bass", "keyboard accompaniment", "choral backup", "christian music", "christian song", "hymns", "christian gospel song", "devotional", "praise and worship", "fervent", "earnest", "passionate", "emotional", "acoustic guitar"] | 7 | 0oIFGARD9xE | 210 | |
Justin Bieber singing Christmas songs in Washington 2011 (perfoming for Obama!).mp4 | A male vocalist sings this Christmas song. The tempo is medium with minimal instruments like keyboard harmony and steady drumming. The audio quality is inferior so the music is incoherent. This is a live performance with ambient sounds of people clapping and cheering. This is a contemporary Christmas Song. | 2012-03-17T20:04:17Z | virgi92dT | Yeeeee!!! 1. Mistletoe 2. Away in a manger 3. a classic Christmas song featuring with Obama | ["Christmas music", "Singing", "Music", "Choir"] | ["male singer", "teen singer", "medium tempo", "vocal backup", "keyboard harmony", "steady drumming", "poor audio quality", "incoherent music", "emphatic vocals", "live performance", "ambient sounds", "clapping", "christmas song", "christmas time", "christmas concert", "live performance", "live audience", "heavy reverb"] | 7 | ZNGJN30LCwM | 3369 |
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;