musiccaps_details (view)
5 rows where musiccaps_aspects contains "guitar rhythm", musiccaps_aspects contains "romantic" and musiccaps_aspects contains "story telling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 70 ✖
- guitar rhythm · 5 ✖
- romantic · 5 ✖
- story telling · 5 ✖
- male singer 4
- medium tempo 4
- emotional 3
- exciting 3
- people dancing 3
- dance rhythm 2
- groovy bass line 2
- latin percussions 2
- passionate 2
- poor audio quality 2
- vocal harmony 2
- adventurous 1
- bad audio quality 1
- cheerful 1
- dance all night long 1
- dance club 1
- dance floor 1
- dance groove 1
- distorted guitar lead 1
- entertaining 1
- groovy rhythm 1
- guiro percussions 1
- head bangers 1
- hip hop dance music 1
- hip hop music 1
- inspiring 1
- keyboard accompaniment 1
- latin dance band 1
- latin dance groove 1
- latin dance hits 1
- latin dance music 1
- latin folk singer 1
- latin pop star 1
- latin singer 1
- love song 1
- madly in love 1
- male backup singers 1
- male latin singer 1
- medium fast tempo 1
- memdium tempo 1
- modern love 1
- modern pop hits 1
- modern r&b hits 1
- motivational 1
- never give up on you 1
- organ accompaniment 1
- party time 1
- people screaming 1
- percussive bass line 1
- piano accompaniment 1
- positive 1
- r&b 1
- reggae hip hops music 1
- retro classic rock 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- screaming vocals 1
- soaring vocals 1
- soul singer 1
- spirited 1
- steady drumming rhythm 1
- string harmony 1
- strong bass line 1
- walking bass line 1
- youthful 1
musiccaps_names (array) 14 ✖
- Music 4
- Music of Africa 2
- Afrobeat 1
- Christian music 1
- Grunge 1
- Guitar 1
- Heavy metal 1
- Music of Asia 1
- Progressive rock 1
- Psychedelic rock 1
- Reggae 1
- Rock music 1
- Ska 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
el grillo enamorado | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | 2008-09-05T17:39:10Z | Piko | el grillo enamorado con imagenes de grillos | ["Music of Africa", "Music", "Ska"] | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | 1 | 2cxvYC9QZac | 391 | |
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 | |
*NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | A male singer sings this hip hop dance song. The tempo is medium tempo with a groovy bass line, keyboard harmony and reggae inspired drumming rhythm. The song is story telling and romantic in nature. | 2014-07-16T20:50:50Z | OffDaGroundTV | Pre-Order "New Africa Nation" the Album now here: https://fuseodg.tmstor.es Shop for New Africa Nation Clothing online here : https://newafricanation.bigcartel.com/ / Fuse ODG's Album 'T.I.N.A' on iTunes: http://smarturl.it/FuseODGTINA *NEW UPLOAD* Itz Tiffany ft Fuse ODG - Spanner (Official Video) | ["Music", "Reggae"] | ["male singer", "hip hop music", "exciting", "people dancing", "modern love", "reggae hip hops music", "medium tempo", "dance rhythm", "male backup singers", "vocal harmony", "story telling", "groovy bass line", "guitar rhythm", "string harmony", "romantic", "groovy rhythm", "dance rhythm", "hip hop dance music", "emotional"] | 1 | jQYSfy4DzIc | 4253 | |
Straight way Black or White Christian rock music Doug Middleton lead guitar | A male singer sings this rock melody. The song is medium tempo with a rock drumming rhythm, percussive bass line, distorted guitar accompaniment and keyboard accompaniment. The song is exciting and energetic. The song has poor audio quality. | 2010-01-26T03:10:24Z | tannere1 | Christian music Straight way title black or white doug middleton | ["Christian music", "Guitar", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song", "Progressive rock", "Grunge"] | ["poor audio quality", "rock band", "poor audio quality", "retro classic rock", "story telling", "romantic", "adventurous", "rock groupies", "rock hits", "medium tempo", "guitar rhythm", "groovy bass line", "rock drumming rhythm", "people screaming", "distorted guitar lead", "male singer", "screaming vocals", "exciting", "positive", "youthful", "head bangers"] | 1 | njFM8DvmPVU | 4571 | |
John Legend - Who Did That to You (Lyrics) from Django Unchained Soundtrack | A male singer sings this soulful melody with backup singers in vocal harmony. The song is medium tempo with an organ accompaniment, steady drumming , guitar rhythm and various percussion hits. The song is story telling and passionate in nature. The audio quality is very poor. | 2012-12-29T14:50:41Z | django unchained | The lyrics for John Legend's song - Who Did That To You fro the soundtrack of Quentin Tarantino's movie - Django Unchained buy this song at http://www.amazon.com/Who-Did-That-to-You/dp/B00AL3KI76 | ["Music of Asia"] | ["male singer", "bad audio quality", "modern pop hits", "bad audio quality", "medium tempo", "emotional", "inspiring", "motivational", "romantic", "never give up on you", "madly in love", "love song", "story telling", "soul singer", "vocal harmony", "organ accompaniment", "memdium tempo", "guitar rhythm", "steady drumming rhythm", "percussive bass line", "r&b", "modern r&b hits"] | 1 | ozjs2d_xlSI | 4674 |
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;