musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "strings" and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- acoustic drums 2
- acoustic guitar · 2 ✖
- strings · 2 ✖
- bass guitar 1
- e-bass 1
- female vocal 1
- higher key 1
- longing 1
- male voice singing 1
- medium tempo 1
- melodic singing 1
- minor key 1
- pop rock 1
- rock/ballad 1
- sentimental 1
- timpani 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dota heroes sexy | This is a pop rock piece. There is a female vocalist singing melodically at the forefront. The melody is being played by a wide-sounding strings section and an acoustic guitar. The bass guitar is playing the root notes in the background. The rhythmic structure is provided by a simple acoustic drum beat. The song is in minor key. The atmosphere is sentimental and filled with longing. This piece could be included in the soundtrack of a teenage drama movie or TV series. | 2010-02-13T16:45:07Z | elbertjann benitez | the best hero and my favorite hero my favorite is mirana the best hero of me ^^ | ["Christian music"] | ["pop rock", "female vocal", "melodic singing", "strings", "acoustic guitar", "bass guitar", "acoustic drums", "sentimental", "longing", "minor key"] | 9 | 5P5XAclO8ko | 659 | |
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;