musiccaps_details (view)
4 rows where musiccaps_aspects contains "medium fast tempo", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "percussive bass line"
This data as json, CSV (advanced)
musiccaps_aspects (array) 64 ✖
- medium fast tempo · 4 ✖
- passionate · 4 ✖
- percussive bass line · 4 ✖
- backup singers 2
- drum rolls 2
- emotional 2
- exciting 2
- keyboard accompaniment 2
- poor audio quality 2
- romantic 2
- spirited 2
- steady drumming rhythm 2
- adventurous 1
- arcade game soundtrack 1
- building tension 1
- crooners 1
- cymbal crashes 1
- cymbals crashing 1
- dance with you all night 1
- dangerous journey 1
- distortion guitar playing lead 1
- dragon quest 1
- energetic 1
- enthusiastic 1
- female singer 1
- finale singer 1
- game play 1
- groovy 1
- groovy dance rhythm 1
- groovy drum rhythm 1
- groovy music 1
- groovy rhythm 1
- guitar accompaniment 1
- guitar rhythm 1
- horns playing trumpets 1
- instrumental music 1
- intense battle 1
- i’m in love 1
- keybiard accompaniment 1
- love sing 1
- love song 1
- male singer 1
- male singers 1
- metal music 1
- modern day romance 1
- reggae music 1
- retro dance hits 1
- retro game tracks 1
- retro love songs 1
- retro pop 1
- retro pop hits 1
- sonic effects 1
- soul singer 1
- story telling 1
- suoerfats drumming rhythm 1
- tero pop hits 1
- together forever 1
- valour and pride 1
- video games 1
- virtuoso guitar lead 1
- vocal duet 1
- vocal harmony 1
- warriors fight 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 4
- Afrobeat 1
- Cacophony 1
- Grunge 1
- Heavy metal 1
- Hip hop music 1
- Independent music 1
- Pop 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 | |
Zwan - Lyric (Video Version) | A male and female singer sing this vocal duet. The song is medium fast tempo with a guitar accompaniment, steady drumming rhythm with exciting drum rolls, cymbals crashes and a percussive bass line. The song is romantic and exciting. The song is retro pop with a bad audio quality. | 2009-10-27T01:54:19Z | Warner Records Vault | © 2005 WMG Lyric (Video Version) | ["Music", "Independent music", "Pop music", "Grunge"] | ["male singer", "female singer", "guitar accompaniment", "keyboard accompaniment", "vocal duet", "retro pop hits", "medium fast tempo", "poor audio quality", "groovy rhythm", "steady drumming rhythm", "percussive bass line", "keyboard accompaniment", "drum rolls", "cymbals crashing", "romantic", "exciting", "emotional", "adventurous", "passionate", "retro pop hits"] | 1 | CwmUMySSNQc | 1417 | |
Northern Soul .. I'll never stop loving you. | A female singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a percussive bass line, groovy drumming rhythm, keyboard accompaniment and other percussive hits. The song is a retro pop love song. | 2010-12-15T10:18:33Z | docludi | Once acclaimed the Queen of Memphis Soul. Carla Thomas, daughter of Rufus Thomas was born on December 21, 1942 in Memphis, Tennessee. This 1963 Fantasy recording remained unreleased until 1991. "I'll never stop loving you" Video excerpts from Story of the Who, Quadraphenia and other scooter oddments of the period. Twisted Wheel website. http://www.twistedwheel.co.uk | ["Music", "Ska"] | ["finale singer", "retro pop", "backup singers", "passionate", "love sing", "together forever", "i’m in love", "dance with you all night", "modern day romance", "youthful", "soul singer", "percussive bass line", "steady drumming rhythm", "guitar rhythm", "groovy", "romantic", "emotional", "love song", "retro love songs", "crooners", "medium fast tempo"] | 1 | ZwLfj7tvpdc | 3427 | |
bakugan dimensions game play | The song is an instrumental. The tempo is medium fast with a percussive bass line, super fast metal drumming with cymbal crashes and fast drum rolls and a distorted guitar playing a virtuoso lead. The song is energetic and animated. The song has poor audio quality. | 2010-07-12T05:45:38Z | bradjr10 | more game play of bakugan dimensions | ["Heavy metal", "Music", "Cacophony"] | ["instrumental music", "metal music", "poor audio quality", "energetic", "passionate", "building tension", "warriors fight", "dragon quest", "dangerous journey", "valour and pride", "groovy music", "intense battle", "medium fast tempo", "arcade game soundtrack", "suoerfats drumming rhythm", "distortion guitar playing lead", "percussive bass line", "virtuoso guitar lead", "spirited", "cymbal crashes", "drum rolls", "game play", "video games", "retro game tracks"] | 1 | nT_R3O0OK6U | 4541 |
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;