musiccaps_details (view)
4 rows where musiccaps_aspects contains "keyboard accompaniment", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "medium fast tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 65 ✖
- keyboard accompaniment · 4 ✖
- male singer · 4 ✖
- medium fast tempo · 4 ✖
- exciting 3
- emotional 2
- guitar accompaniment 2
- passionate 2
- percussive bass line 2
- retro pop hits 2
- romantic 2
- acoustic guitar 1
- adrenaline rush 1
- adventurous 1
- banjo 1
- beseeching 1
- cheerful 1
- country music 1
- country pop 1
- country song 1
- country songs 1
- cymbals crashing 1
- dance all night long 1
- dance club 1
- dance floor 1
- drum rolls 1
- energetic 1
- enthusiastic 1
- female singer 1
- fiddle 1
- fitness 1
- groovy drumming rhythm 1
- groovy rhythm 1
- guitar rhythm 1
- hip hop music 1
- latin dance groove 1
- latin dance hits 1
- latin dance music 1
- latin percussions 1
- latin pop star 1
- latin singer 1
- mandolin 1
- melodic 1
- party time 1
- people dancing 1
- pleading 1
- poor audio quality 1
- pop dance hits 1
- prayer 1
- regional music 1
- request 1
- resonator 1
- retro pop music 1
- rhythmic drumming 1
- sentimental 1
- soft 1
- spirited string arrangement 1
- steady bass 1
- steady drumming rhythm 1
- story telling 1
- strong bass line 1
- various percussion hits 1
- violin 1
- vocal duet 1
- workout classics 1
- workout playlist 1
musiccaps_names (array) 10 ✖
- Music 4
- Independent music 2
- Afrobeat 1
- Dance music 1
- Disco 1
- Grunge 1
- House music 1
- Music of Africa 1
- Pop music 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
The Commodores - Brick House - Music Video | A male singer sings this exciting melody with backup singers in vocal harmony. The song is medium fast tempo with a steady drumming rhythm, keyboard accompaniment, groovy bass line and various percussion hits. The song is energetic and passionate. The song is a retro pop hit. | 2009-08-22T18:26:20Z | CaptnKiller | She`s a brick house Mighty might just lettin` it all hang out She`s a brick house She`s the one, the only one, who`s built like a amazon She knows she got everything a woman needs to get a man, yeah. How can she lose with what she use 36-24-36, what a winning hand! [Chorus] The clothes she wears, the sexy ways, make an old man wish for younger days She knows she`s built and knows how to please Sure enough to knock a man to his knees [Chorus] Shake it down, shake it down now | ["Disco", "House music", "Music", "Independent music", "Dance music"] | ["male singer", "hip hop music", "percussive bass line", "groovy drumming rhythm", "keyboard accompaniment", "guitar accompaniment", "various percussion hits", "retro pop music", "energetic", "exciting", "retro pop hits", "pop dance hits", "fitness", "workout classics", "workout playlist", "enthusiastic", "adrenaline rush", "medium fast tempo"] | 1 | ILE12hEW5Ck | 1897 | |
15. 1MILLION SOUNDS - JUNIO 2016 (BRUNO TORRES) | A male singer sings this exciting melody. The song is medium fast tempo with a groovy bass line, latin percussion, steady drum rhythm, groovy bass line and keyboard accompaniment. The song is exciting and fun. The song is a modern Latin pop dance hit. | 2016-06-02T12:05:11Z | TemazosMusic TV | Temazos Music 2.0: https://www.youtube.com/channel/UCjCqUvKSd1A8aUnhZekclvA Descargar: http://www92.zippyshare.com/v/pdlnpgp4/file.html FACEBOOK: https://www.facebook.com/TemazosMusicTV TWITTERS: https://twitter.com/TemazosMusicYT https://twitter.com/puchidj | ["Afrobeat", "Music of Africa", "Music"] | ["male singer", "latin singer", "latin pop star", "latin percussions", "story telling", "medium fast tempo", "latin dance music", "latin dance groove", "strong bass line", "guitar rhythm", "people dancing", "dance club", "dance floor", "passionate", "cheerful", "exciting", "romantic", "dance all night long", "party time", "latin dance hits", "keyboard accompaniment"] | 1 | L1s-oPHsOac | 2144 | |
Avenged Sevenfold-Dear God Lyrics | A male vocalist sings this melodious country song. The tempo is medium with rhythmic acoustic guitar, fiddle, resonator, banjo, dobro and mandolin accompaniment, keyboard harmony, steady drumming and straight bass lines. The song is mellow, emotional, prayerful, pleading, sentimental, passionate and melodious. This song is Country Pop. | 2009-12-31T14:57:13Z | ComedyGHN | Avenged Sevenfold - Dear God Lyrics! AMAZING TUNE! SUBSCRIBE ;D | ["Music", "Roll"] | ["male singer", "medium fast tempo", "country song", "pleading", "request", "country pop", "spirited string arrangement", "acoustic guitar", "fiddle", "resonator", "banjo", "mandolin", "violin", "rhythmic drumming", "steady bass", "keyboard accompaniment", "country music", "country songs", "regional music", "soft", "melodic", "prayer", "beseeching", "emotional", "sentimental"] | 7 | OI7S7vaBT4I | 2424 |
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;