musiccaps_details (view)
3 rows where musiccaps_aspects contains "drum rolls", musiccaps_aspects contains "emotional", musiccaps_aspects contains "poor audio quality" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
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 | |
Az Baraye Ghame Man-Ahmad Zahir.wmv | The song is an instrumental. The song is medium tempo and has a delightful flute solo with keyboard accompaniment groovy bass line and a groovy drumming rhythm. The song has a poor recording quality. The song's middle eastern folk music vibes. | 2011-01-25T19:32:28Z | afgking16 | Ahmad Zahir Az Baraye Ghame Man | ["Music", "Rattle (instrument)"] | ["poor audio quality", "flute solo", "arabian music influences", "medium tempo", "folk music", "instrumental music", "steady drumming rhythm", "folk music", "strong bass line", "drum rolls", "retro songs", "entertaining", "emotional", "romantic", "passionate", "keyboard accompaniment"] | 1 | eHeUipPZHIc | 3853 | |
Lil Wayne - Lose Control (New Music 2012) ft. Brisco [ Song from Tha Carter IV ] | A male singer sings this passionate melody with backup singers in vocal harmony. The song is medium tempo with a slick drumming rhythm, keyboard accompaniment, beep tones, strong bass line and slick percussion hits. The song is groovy and story telling in nature. The song has poor audio quality. | 2011-08-02T20:05:16Z | REDKAN MUSIC | Lil Wayne - Lose Control (New Music 2012) ft. Brisco Lil Wayne - Lose Control (New Music 2011) ft. Brisco Lil Wayne - Lose Control (New Music 2011) ft. Brisco | ["Music", "Exciting music"] | ["male singer", "backup singers", "rap music", "drum rolls", "hip hop music", "hood", "ghetto boys", "piano accompaniment", "slick drumming rhythm", "solid drum play", "story telling", "energetic", "emotional", "beep tones", "hi- hop dance hits", "medium tempo", "hip hop dance hits", "poor audio quality", "strong bass line"] | 1 | jlIbJVfnHB4 | 4280 |
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;