musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate" and musiccaps_aspects contains "reggae music" sorted by musiccaps_rowid
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- passionate · 2 ✖
- reggae music · 2 ✖
- vocal harmony 2
- backup singer 1
- backup singers 1
- band recording 1
- bass guitar 1
- classy 1
- dance rhythm 1
- enthusiastic 1
- exciting 1
- funky jazz 1
- groovy bass line 1
- groovy dance rhythm 1
- groovy drum rhythm 1
- guitar accompaniment 1
- horns playing trumpets 1
- jazz hits 1
- jazz music 1
- joyful 1
- keybiard accompaniment 1
- keyboard accompaniment 1
- life’s truths 1
- male singer 1
- male singers 1
- medium fast tempo 1
- medium tempo 1
- people dancing 1
- percussive bass line 1
- percussive horn section 1
- retro dance hits 1
- saxophones harmony 1
- ska band 1
- ska orchestra 1
- sonic effects 1
- spirited 1
- story telling 1
- syncopated vocals 1
- tero pop hits 1
musiccaps_names (array) 4 ✖
- Music 2
- Afrobeat 1
- Hip hop 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|
Ghana Hiplife: VIP : Manenko | A male singer sings this reggae melody with backup singers in vocal harmony. The song is medium fast tempo with a groovy drum drumming rhythm, keyboard accompaniment, percussive bass line and various percussive effects. The song is groovy and enthusiastic with a reggae influence. | 2007-07-10T10:45:13Z | vyrusnana | vission in progress | ["Afrobeat", "Music", "Hip hop music"] | ["male singers", "backup singers", "vocal harmony", "keyboard accompaniment", "reggae music", "tero pop hits", "retro dance hits", "groovy dance rhythm", "percussive bass line", "groovy drum rhythm", "keybiard accompaniment", "sonic effects", "horns playing trumpets", "passionate", "story telling", "spirited", "enthusiastic", "exciting", "medium fast tempo"] | 1 | 4Lk8pUeLCwQ | 559 | |
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;