musiccaps_details (view)
3 rows where musiccaps_aspects contains "backup singer" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 57 ✖
- backup singer · 3 ✖
- medium tempo 3
- vocal harmony 3
- keyboard accompaniment 2
- male singer 2
- animated vocals 1
- asanas 1
- bad audio quality 1
- band recording 1
- bass guitar 1
- bell harmony 1
- cheerful 1
- classy 1
- dance rhythm 1
- emotional connection 1
- en wage hits 1
- energetic 1
- entertaining 1
- explore nature 1
- female singer 1
- funky jazz 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar rhythm 1
- healing 1
- horns playing 1
- jazz hits 1
- jazz music 1
- joyful 1
- life’s meanings 1
- life’s truths 1
- meditational 1
- memdium tempo 1
- new age 1
- new age hits 1
- organ accompaniment 1
- passionate 1
- people dancing 1
- percussive horn section 1
- pop song 1
- positive 1
- prayerful 1
- reggae music 1
- relaxing playlist 1
- retro new age hits 1
- saxophones harmony 1
- sensory experiences 1
- ska band 1
- ska orchestra 1
- steady bass line 1
- string synth pad harmony 1
- syncopated vocals 1
- video sound track 1
- vocal chanting 1
- workout playlist 1
- yoga 1
musiccaps_names (array) 5 ✖
- Music 3
- Afrobeat 1
- Music of Africa 1
- New-age music 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
พ่อพันธุ์วัวไทยพื้นเมือง | A male singer sings this cool and animated melody with backup singers in vocal harmony. The song is medium tempo with steady drumming rhythm, groovy bass line, organ accompaniment and horns playing. The song is entertaining and cheerful. The audio quality is bad. | 2012-07-22T11:31:33Z | thanandorn limlek | ขออนุญาตเจ้าของวัวครับ | ["Afrobeat", "Music of Africa", "Music"] | ["male singer", "backup singer", "vocal harmony", "cheerful", "positive", "animated vocals", "video sound track", "guitar rhythm", "horns playing", "organ accompaniment", "steady bass line", "groovy rhythm", "energetic", "entertaining", "bad audio quality", "pop song", "medium tempo", "keyboard accompaniment"] | 1 | Ipow026xzVw | 1945 | |
New Age Music | Va - Celtic Dreams (High Definition Available) | A female singer sings this chanting vocals with backup singers in vocal harmony. The song is medium tempo with bell harmony, keyboard accompaniment, steady rhythm and a string pad harmony. The song is healing and a new age in nature. | 2009-04-05T15:09:10Z | MelancholicDestiny | New Age Music | ["New-age music", "Music"] | ["new age", "female singer", "backup singer", "new age hits", "workout playlist", "medium tempo", "emotional connection", "explore nature", "life’s meanings", "relaxing playlist", "vocal harmony", "bell harmony", "keyboard accompaniment", "string synth pad harmony", "en wage hits", "meditational", "prayerful", "healing", "sensory experiences", "memdium tempo", "retro new age hits", "yoga", "asanas", "vocal chanting", "medium tempo"] | 1 | L_KkjB0Wt_Q | 2198 | |
Melbourne Ska Orchestra - The Best Things In Life Are Free | A male singer sings this jazz melody with the backup singer in vocal harmony. The song is medium tempo, with saxophone harmony, ska drumming rhythm and a good bass line. The song is entertaining and groovy. The song is a classic jazz tune played in ska style. | 2012-12-06T06:35:18Z | Melbourne Ska Orchestra | The Melbourne Ska Orchestra's take on 1920's classic, "The Best Things In Life Are Free" from their 2013 self-titled album. Available here: https://abcmusic.lnk.to/MelbourneSkaOrchestra This music video was filmed at the legendary Allan Eaton Studios in Melbourne, Australia and features vocalist Pat Powell. The track featured on Freeview Australia's national TV campaign with Melbourne Ska Orchestra Conductor/MC Nicky Bomba and members of the orchestra. www.melbourneskaorchestra.com Video Clip produced by Bison Films and Clayton Jacobson | ["Music", "Ska"] | ["male singer", "reggae music", "ska band", "dance rhythm", "people dancing", "band recording", "classy", "medium tempo", "guitar accompaniment", "bass guitar", "saxophones harmony", "backup singer", "vocal harmony", "groovy bass line", "jazz music", "funky jazz", "percussive horn section", "joyful", "passionate", "medium tempo", "syncopated vocals", "ska orchestra", "jazz hits", "life’s truths"] | 1 | xUVvBF9BWdg | 5333 |
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;