musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate male vocalist" and musiccaps_author = 3
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- passionate male vocalist · 3 ✖
- low quality audio 2
- accordion 1
- arabic music 1
- beeping 1
- dance music 1
- distortion 1
- jungle 1
- rave music 1
- simple drum beat 1
- simple percussion pattern 1
- siren 1
- south asian music 1
- tabla 1
- up tempo 1
- upbeat 1
- vintage middle eastern music 1
- violins 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
NAWAZ SHARIF "SONG"HUM DEKHEN GAY | This is a traditional south asian song. We have an accordion-like instrument for the melodic component and a tabla for percussion. The singer has a passionate voice. The audio quality is poor and the song distorts. | 2010-08-21T08:14:10Z | TheSaifpakiloverboy | ["Music", "Middle Eastern music"] | ["south asian music", "low quality audio", "distortion", "accordion", "tabla", "passionate male vocalist"] | 3 | GjE_iD2BbFg | 1751 | ||
MC Shabba D - No Gunz | The vocalist raps in a way that is more like a spoken story. The song is upbeat and energetic. The genre of music would be suitably described as rave or jungle music. It's an intense feeling song. The drum beat is simple and comes underneath a variety of sound effects like sirens and beeps. | 2006-11-06T15:34:59Z | highlyb | Log onto: www.highlyblesseddownloads.com to download MP3 | ["Drum and bass", "Electronic music", "Music", "Rapping", "Hip hop music"] | ["dance music", "upbeat", "rave music", "beeping", "siren", "jungle", "passionate male vocalist", "simple drum beat", "up tempo"] | 3 | g0AXzsecS5M | 4000 | |
kamaran omar bezarm let كامەران عمر بێزارم لێت | This is a vintage middle eastern song. The male singer sings passionately in Arabic, on top of a simple instrumental which features violins and a simple drum pattern. This song would be heard in an old middle eastern movie. | 2013-09-02T14:13:25Z | Goran Abdulla | https://www.facebook.com/ | ["Singing", "Music", "Middle Eastern music"] | ["low quality audio", "vintage middle eastern music", "arabic music", "passionate male vocalist", "violins", "simple percussion pattern"] | 3 | tMICtalfpSc | 5029 |
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;