musiccaps_details (view)
2 rows where musiccaps_aspects contains "soft melody" and musiccaps_names contains "Gospel music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- slow tempo 2
- soft melody · 2 ✖
- amateur recording 1
- christian music 1
- christian worship song 1
- classic melody 1
- classic rock 1
- devotional 1
- digital drum 1
- distorted sound 1
- emotional 1
- female vocalist 1
- foreign language 1
- guitar accompaniment 1
- inaudible lyrics 1
- indian classical 1
- indian music 1
- indian percussion 1
- indistinct chatter 1
- inferior audio quality 1
- keyboard arrangement 1
- male singer 1
- mellow 1
- melodic 1
- muffled vocals 1
- pop 1
- retro 1
- retro rock and roll 1
- rhythmic acoustic guitar 1
- rock and rock 1
- saxophone 1
- south indian music 1
- steady drumming 1
- tabla 1
- tambourine 1
- tamil christian worship 1
- tamil music 1
- violin harmony 1
- violin symphony 1
- wood wind 1
musiccaps_names (array) 5 ✖
- Gospel music · 2 ✖
- Music 2
- Independent music 1
- Singing 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BJ Thomas ~ Rock And Roll Lullaby | A male vocalist sings this melodic song. The tempo is medium with muffled vocals, violin harmony, rhythmic guitar , steady drumming and straight bass lines. The language and lyrics of the song are inaudible because of the amateur recording.This song is a Classic Rock and Roll. | 2011-06-25T22:02:46Z | IP Casino Resort Spa | BJ Thomas sings "Rock And Roll Lullaby" in Studio A in the IP Casino Resort Spa on June 24, 2011 | ["Singing", "Gospel music", "Music", "Wedding music"] | ["male singer", "slow tempo", "inaudible lyrics", "amateur recording", "melodic", "indistinct chatter", "soft melody", "emotional", "distorted sound", "violin symphony", "guitar accompaniment", "keyboard arrangement", "muffled vocals", "inferior audio quality", "rock and rock", "classic melody", "pop", "classic rock", "retro", "retro rock and roll", "steady drumming"] | 7 | BUzsQ6WohH4 | 1245 | |
Tamil Christian Song - Nee illatha by Hema John- Zion Music Festival '09 | A female vocalist sings this soft melody. The tempo is slow with violin harmony, keyboard accompaniment, saxophone, digital drum, tabla and tambourine beats. The song is mellow, soft, melodic, soothing, calming , devotional and euphonious. This song is a Tamil Christian Song. | 2010-11-04T07:04:36Z | endtimezionministry | http://www.endtimezionministries.org Through Him (Jesus) all things were made; without Him nothing was made that has been made. In Him was life, and that life was the light of all mankind. John:1:3,4 | ["Gospel music", "Music", "Independent music"] | ["female vocalist", "slow tempo", "foreign language", "wood wind", "rhythmic acoustic guitar", "tabla", "indian percussion", "tambourine", "indian music", "indian classical", "south indian music", "tamil music", "violin harmony", "digital drum", "saxophone", "soft melody", "mellow", "devotional", "christian music", "christian worship song", "tamil christian worship"] | 7 | ghW2xZMvpIQ | 4046 |
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;