musiccaps_details (view)
2 rows where musiccaps_aspects contains "vocal harmony" and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- vocal harmony · 2 ✖
- backing voice 1
- backup singers 1
- bad audio quality 1
- christian contemporary music 1
- church service 1
- congregational music 1
- dance song 1
- disco song 1
- gospel band 1
- groovy bassline 1
- hymns 1
- male singer 1
- male voice 1
- meditational 1
- medium tempo 1
- moderate tempo 1
- organ accompaniment 1
- percussive bass line 1
- piano acc 1
- praise and worship 1
- prayers 1
- programmed percussion 1
- rejoicing 1
- steady drumming rhythm 1
- synth chords 1
- tambourine percussions 1
musiccaps_names (array) 6 ✖
- Christian music · 2 ✖
- Music 2
- Disco 1
- Gospel music 1
- Song 1
- Soul music 1
youtube_published (date) 2 ✖
- 2007-10-06 1
- 2011-02-02 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
chaz - go for love ~ modern soul | This disco song features a male voice singing the main melody. Another voice sings in harmony with the main voice. This is accompanied by programmed percussion playing a simple melody. There is a distinctive hi-hat ring at alternate strokes giving this a unique sound. The bass plays a groovy bassline using the root notes of the chords. A synth plays chords in the background. This song is at a moderate tempo. This song can be played in a club. | 2011-02-02T23:34:17Z | KentSoul1 | chaz - go for love ~ modern soul | ["Disco", "Christian music", "Music", "Song", "Soul music"] | ["disco song", "groovy bassline", "male voice", "backing voice", "vocal harmony", "programmed percussion", "synth chords", "moderate tempo", "dance song"] | 0 | ZEuY5HnECuo | 3350 | |
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;