musiccaps_details (view)
2 rows where musiccaps_aspects contains "male singer", musiccaps_aspects contains "motivational" and musiccaps_aspects contains "story telling"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- emotional 2
- male singer · 2 ✖
- motivational · 2 ✖
- story telling · 2 ✖
- backup singers 1
- bad audio quality 1
- dance rhythm 1
- gangs 1
- groovy drumming rhythm 1
- groovy rhythm 1
- grunge string section harmony 1
- guitar rhythm 1
- hip hop dance hits 1
- hip hop hits 1
- hip hop music 1
- hood 1
- inspirational 1
- inspiring 1
- love song 1
- madly in love 1
- medium tempo 1
- memdium tehsil po 1
- memdium tempo 1
- modern pop hits 1
- modern r&b hits 1
- never give up on you 1
- organ accompaniment 1
- percussive bass line 1
- r&b 1
- rapping vocals 1
- romantic 1
- soul singer 1
- steady drumming rhythm 1
- steady rhythm 1
- strong bass line 1
- vocal harmony 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chamillionaire Wont Hear A Sound Freestyle (NEW 3/27/2012) | A male singer sings this hip hop melody with backup singers in vocal harmony. The song is medium tempo with a groovy drum rhythm, steady bass line and a grunge keyboard harmony. The song is exciting and energetic. The song has average audio quality. | 2012-03-27T03:07:58Z | TechnicalPrecision | This is Chamillionaires Wont hear a sound freestyle! Subscribe for quality music! | ["Music", "Rhythm and blues"] | ["male singer", "hip hop music", "backup singers", "rapping vocals", "memdium tehsil po", "groovy drumming rhythm", "strong bass line", "grunge string section harmony", "story telling", "groovy rhythm", "dance rhythm", "steady rhythm", "emotional", "gangs", "hood", "motivational", "inspirational", "hip hop hits", "hip hop dance hits"] | 1 | 67S7s_jFXhc | 726 | |
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;