musiccaps_details (view)
4 rows where musiccaps_aspects contains "medium tempo", musiccaps_author = 6 and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- medium tempo · 4 ✖
- e-bass 3
- acoustic drums 2
- accordion 1
- acoustic guitar 1
- amateur recording 1
- ballad/pop 1
- bass 1
- choir 1
- digital drums 1
- electric organ 1
- higher key 1
- higher register 1
- jingle 1
- keyboard 1
- male deep voice singing 1
- male voice singing 1
- male voices singing 1
- mixed male voices singing 1
- piano 1
- pop 1
- rock/ballad 1
- strings 1
- timpani 1
musiccaps_names (array) 6 ✖
- Christian music · 4 ✖
- Music 4
- Christmas music 1
- Gospel music 1
- Song 1
- Synthetic singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Wedding Music - The Cathedral Quartet | This audio contains a simple drum groove along with a bassline playing long notes. A piano and keyboard are playing chords and melodies panned to the left and right side of the speakers. Male voices are singing a melody together. Some in the mid and high range and one as a bass voice. This audio may be playing at a celebration event. | 2009-10-18T03:21:22Z | ClassicGospel | From the VHS "The Cathedral Quartet - A Reunion" | ["Gospel music", "Christian music", "Music", "Song"] | ["ballad/pop", "mixed male voices singing", "e-bass", "piano", "keyboard", "acoustic drums", "medium tempo"] | 6 | k4ttuqKjiw0 | 4297 | |
Santa Claus Mic Ebay Item # 290505104184 | A male deep voice is singing along to an accordion sound and a choir providing backing vocals. This song sounds cheerful. This is an amateur recording and of poor audio-quality. This song may be playing at a celebration. | 2009-12-13T12:36:28Z | SantaClaus47579 | Search item # 290505104184 on Ebay for latest. 11-11-2010. This Santa Claus sings and dances to 5 songs. Use the microphone to talk and sing through Santa's mouth and the aux input to play your recorded songs. | ["Christmas music", "Christian music", "Music", "Synthetic singing"] | ["jingle", "amateur recording", "male deep voice singing", "accordion", "choir", "bass", "medium tempo"] | 6 | qKOsbyT8GCU | 4776 | |
Brandon Flowers - Only The Young (Official Video) | A digital drum is playing a simple groove along with an e-bass. An organ is playing long chords with a lot of reverb. On top of that male voices sing a melody in harmony. Their voices sound high. This song may be playing with headphones while running. | 2010-10-13T00:00:08Z | BrandonFlowersVEVO | Music video by Brandon Flowers performing Only The Young. (C) 2010 The Island Def Jam Music Group #BrandonFlowers #OnlyTheYoung #Vevo | ["Christian music", "Music"] | ["pop", "electric organ", "digital drums", "e-bass", "male voices singing", "higher register", "medium tempo"] | 6 | uBENjCPS8LI | 5097 | |
Cristo Rey - Viva Cristo Rey - Jairé | This song comes with a male voice singing in a higher key and strings playing the same melody in the background in the midrange. A timpani hit is playing along with the drums. This song may be playing in a latin country where someone is cleaning the house with open doors and windows listening to this song in a very loud volume. | 2010-11-21T06:05:11Z | GammaJuvenil | Viva Cristo Rey - Jairé Un grito de guerra se escucha en la faz de la tierra y en todo lugar los prestos guerreros empuñan su espada y se enlistan para pelear Para eso han sido entrenados defenderán la verdad y no les será arrebatado el fuego que en su sangre está Viva Cristo Rey, Viva Cristo Rey, el grito de guerra que enciende la tierra Viva Cristo Rey, nuestro soberano señor nuestro capitán y campeón pelear por Él, es todo un honor Sabemos que esta batalla no es fácil y muchos se acobardaran y bajo los dardos de nuestro enemigo sin duda perecerán Yo tendré mi espada en alto como la usa mi Señor a el nada lo ha derrotado su fuerza es la de Dios Viva Cristo Rey, Viva Cristo Rey, el grito de guerra que enciende la tierra Viva Cristo Rey, nuestro soberano señor nuestro capitán y campeón pelear por Él, es todo un honor No conocemos mayor alegría no existe mas honroso afán que con mis hermanos estar en la línea y juntos la vida entregar A Él que merece la gloria y nos recluto por amor ante el la rodilla de dobla y se postra el corazón. Viva Cristo Rey, Viva Cristo Rey, el grito de guerra que enciende la tierra Viva Cristo Rey, nuestro soberano señor nuestro capitán y campeón pelear por Él, es todo un honor. | ["Christian music", "Music"] | ["rock/ballad", "e-bass", "acoustic drums", "timpani", "strings", "acoustic guitar", "male voice singing", "higher key", "medium tempo"] | 6 | xqjpWi83CWM | 5354 |
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;