musiccaps_details (view)
4 rows where musiccaps_aspects contains "live performance", musiccaps_author = 4 and musiccaps_names contains "Middle Eastern music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- live performance · 4 ✖
- low quality 4
- mono 2
- noisy 2
- traditional 2
- accordion melody 1
- acoustic rhythm guitar 1
- emotional 1
- energetic 1
- flat female vocal 1
- flat male vocal 1
- folk 1
- fruity male vocal 1
- groovy 1
- groovy bass 1
- harmonized male vocals 1
- harmonizing male vocals 1
- harsh microphone feedback 1
- hopeful 1
- muddy 1
- muffled 1
- muffled drums 1
- passionate 1
- plucked strings melody 1
- reverberant fruity male vocal 1
- shimmering bells 1
- short strings licks 1
- smooth bass 1
- soulful 1
- strings melody 1
- wooden percussions 1
- wooden percussive elements 1
musiccaps_names (array) 5 ✖
- Middle Eastern music · 4 ✖
- Music 4
- Acoustic guitar 1
- Folk music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Arany Zoltán & World Music Syndicate - La molinera | The low quality recording features a live performance that consists of fruity male vocal singing over accordion melody, acoustic rhythm guitar chords and shimmering bells. It sounds emotional and hopeful. The recording is a bit noisy and in mono, as it was probably recorded with a phone. | 2013-12-20T09:55:03Z | Arany Zoltán | https://www.facebook.com/Arany-Zolt%C3%A1n-Music-274856225999515/ http://aranyzoltan.hu/ Arany Zoltán - fiddle Gonda Szabolcs - guitar Gonda "Sikh" Zoltán - bass Huszti László - percussion Mangu Róbert - percussion Made by Kilincsfilm | ["Folk music", "Acoustic guitar", "Music", "Middle Eastern music"] | ["low quality", "live performance", "fruity male vocal", "accordion melody", "acoustic rhythm guitar", "shimmering bells", "emotional", "hopeful", "mono", "noisy"] | 4 | -nlkWWphiaM | 85 | |
`` Da Hujrey Mijlas `` | The low quality recording features a live performance of a traditional song that consists of harmonizing male vocals singing over plucked strings melody and wooden percussion. It sounds passionate and soulful, but the recording is very noisy and in mono. | 2009-12-19T20:50:04Z | alijk81 | `` Da Hujrey Mijlas `` | ["Music", "Middle Eastern music"] | ["low quality", "live performance", "traditional", "mono", "noisy", "wooden percussions", "plucked strings melody", "harmonizing male vocals", "passionate", "soulful"] | 4 | 8ZK1ajW598M | 930 | |
حفل الدوحه | " نجوى كرم" عم يرجف | The low quality recording features a live performance of a folk song that consists of flat female vocals, harmonizing low male vocals, muffled drums, some wooden percussive elements, groovy bass and short strings licks. It sounds energetic and groovy, but the drums are really poorly recorded. | 2010-12-28T01:13:19Z | Tn7Tv1 | ["Singing", "Music", "Middle Eastern music"] | ["low quality", "live performance", "folk", "short strings licks", "muffled drums", "harmonized male vocals", "flat female vocal", "groovy bass", "groovy", "energetic", "wooden percussive elements"] | 4 | Grtmre_r9yI | 1757 | ||
موال اريد انعى على الراح ونسة الرجعة موال حزين عن الفراك 2016 | The low quality recording features a live performance of a traditional song and it consists of flat male vocal and reverberant fruity male vocal singing over smooth bass and strings melody. It sounds very muddy, muffled and there is a harsh microphone feedback sound. The recording is noisy itself. | 2015-08-18T07:30:02Z | lamassat Production | اشترك بقناة لمسات برودكشن يرجى الاشتراك وتفعيل الجرس https://bit.ly/2q4rU1M ادعمنا بأشتراكك بالقناة وبلايك وتعال ويانه يوميه حفلة جديده . توزيع الدجيتال شركة العود للانتاج والتوزيع الفني OUD Production L.L.C جميع الحقوق محفوظة شركة العود للانتاج الفني © 2018 OUD PRODUCTION ALL RIGHTS RESERVED https://www.facebook.com/oudproduction/ http://oudproduction.com/home.html mustafa@oudproduction.com Copyright Manager & Music Publishing: OUD-Production - Mustafa Alaly | ["Music", "Middle Eastern music"] | ["low quality", "traditional", "harsh microphone feedback", "flat male vocal", "reverberant fruity male vocal", "smooth bass", "strings melody", "muddy", "muffled", "live performance"] | 4 | dl1ljByerd8 | 3811 |
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;