musiccaps_details (view)
5 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "strings melody" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- live performance · 5 ✖
- low quality 5
- strings melody · 5 ✖
- noisy 3
- emotional 2
- energetic drums 2
- mono 2
- passionate 2
- traditional 2
- addictive 1
- brass melody 1
- chaotic 1
- cheering 1
- clapping 1
- crackling 1
- crowd cheering 1
- energetic 1
- flat male vocal 1
- flute melody 1
- folk 1
- harsh microphone feedback 1
- mellow percussions 1
- muddy 1
- muffled 1
- muffled sound 1
- opera 1
- passionate female vocal 1
- resonating bass 1
- reverberant fruity male vocal 1
- smooth bass 1
- soulful 1
- wooden percussion 1
musiccaps_names (array) 12 ✖
- Music 4
- Classical music 1
- Drum 1
- Harmonic 1
- Jazz 1
- Middle Eastern music 1
- Opera 1
- Percussion 1
- Pizzicato 1
- Rock and roll 1
- Singing 1
- Tabla 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Zdop si Zdup - Dj Vasile | The low quality recording features a live performance of folk songs played by flute, strings and energetic drums. The recording is noisy and in mono, as the audio is crackling and it sounds energetic and kind of addictive thanks to that flute and strings melody. | 2010-10-15T16:42:09Z | Ciprian BT | Zdop si Zdup - Dj Vasile | ["Jazz", "Music"] | ["low quality", "folk", "noisy", "mono", "flute melody", "strings melody", "energetic drums", "crackling", "live performance", "energetic", "addictive"] | 4 | 4mtfOkzOvBI | 606 | |
Rag Rageshri - Part 1 | The low quality recording features a live performance of a traditional song that consists of a strings melody played over wooden percussion. The recording is in mono, a bit noisy and it sounds passionate, emotional and soulful. | 2008-10-19T15:54:46Z | bsathien | This is a tabla & sitar recital in rag Rageshri. It is a compilation of two compositions, starting with a piece composed by Pandit Nayan Ghosh, moving on to a piece composed by Ustad Vilayat Khan, and ending with a jhala. On sitar is Dr Debipriya Das, and on tabla is Janan Sathiendran (a student of Sukhdeep Singh Dhanjal). Live recording at Ananthalayas 'Naatha Vinotham'. | ["Tabla", "Drum", "Pizzicato", "Percussion"] | ["low quality", "mono", "noisy", "live performance", "wooden percussion", "strings melody", "passionate", "emotional", "soulful", "traditional"] | 4 | 5ZX1-GAb7IM | 667 | |
butterfingers epitome at harmonic may ochestra MCPA | The low quality recording features a live performance including resonating bass, energetic drums and strings melody. The recording is in a terrible condition, as the bass is resonating much and the sound is overall muffled and muddy. There are some cheering and clapping sounds from a crowd. The listener can barely hear the instruments, as it sounds chaotic. It was definitely recorded with a phone. | 2008-05-16T03:40:16Z | arsany arsad | long lost but not forgotten song.. | ["Music", "Rock and roll", "Harmonic"] | ["low quality", "crowd cheering", "muffled sound", "resonating bass", "live performance", "strings melody", "energetic drums", "cheering", "clapping", "chaotic"] | 4 | LwmwCpAVPWU | 2229 | |
موال اريد انعى على الراح ونسة الرجعة موال حزين عن الفراك 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 | |
Teen Opera Singer Aria Tesolin at 13 | The low quality recording features a live performance of an opera that consists of a passionate female vocal singing over strings melody, brass melody and mellow percussion. It sounds emotional and passionate. | 2007-05-17T22:15:55Z | Aria Tesolin | Teen opera singer, Aria Tesolin sings Mozart aria Voi Che Sapete. The teen talent's videos are Amazing 8 Year Old Child Opera Singing Sensation, Youngest Opera Singer in the World, & Teen Opera Singer Sings Puccini | ["Singing", "Music", "Opera", "Classical music"] | ["low quality", "noisy", "live performance", "opera", "passionate female vocal", "strings melody", "brass melody", "mellow percussions", "passionate", "emotional"] | 4 | hlHb9HwNxk8 | 4136 |
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;