musiccaps_details (view)
4 rows where musiccaps_aspects contains "flute melody", musiccaps_author = 4 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- flute melody · 4 ✖
- low quality 4
- mono 3
- noisy 3
- live performance 2
- passionate 2
- soulful 2
- strings melody 2
- traditional 2
- addictive 1
- claps 1
- crackling 1
- emotional 1
- energetic 1
- energetic drums 1
- folk 1
- fun 1
- groovy piano chords 1
- happy 1
- light snare hits 1
- organ keys chords 1
- outdoor sound effects 1
- passionate female vocal 1
- plastic sound effect 1
- shimmering shakers 1
- soft kick hits 1
- squeaky sound effect 1
- violin melody 1
- wooden percussions 1
- wooden percussive elements 1
musiccaps_names (array) 6 ✖
- Music · 4 ✖
- Jazz 1
- Jingle (music) 1
- Mantra 1
- Middle Eastern music 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
أغدا ألقاك.. أم كلثوم | The low quality recording features a traditional song that consists of passionate female vocal singing over wooden percussive elements, strings and flute melody. It sounds passionate, emotional and soulful and the recording is noisy and in mono. | 2016-04-10T21:37:36Z | shaifize | أغدا ألقاك ؟.. Om Kalthoum Song فارحم القلب الذى يصبو إليك فغداً تملكه بين يديك !! وغداً تأتلق الجنة أنهارا وظلا وغدا ننسى فلا نأسى على ماضٍ تولى وغداً نسموا فلا نعرف للغيب محلا وغداً للحاضر الزاهر نحيا ليس إلا قد يكون الغيب حلوا إنما الحاضر أحلى هكذا أحتمل العمر نعيماً وعذابا مهجة حرى وقلباً مسه الشوق فذابَ | ["Mantra", "Music", "Middle Eastern music"] | ["low quality", "traditional", "mono", "noisy", "passionate female vocal", "wooden percussive elements", "flute melody", "strings melody", "passionate", "emotional", "soulful"] | 4 | 2dyEnOo3yJ8 | 392 | |
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 | |
Traditional Berber Music | The low quality recording features a live performance of a traditional song and it contains wooden percussion, violin melody and flute melody. It sounds soulful, passionate and the recording is noisy and in mono. | 2008-05-22T17:53:23Z | culturexchangeteam | We had the good fortune to attend a concert of Moroccan Berber Music in Marrakesh | ["Traditional music", "Music"] | ["low quality", "live performance", "traditional", "wooden percussions", "violin melody", "flute melody", "soulful", "passionate", "noisy", "mono"] | 4 | W8Xv3Q2kGRA | 3070 | |
Little Heroes 10 - The Spark, The Police Car, The Fire Engine and The Dump Truck | The low quality recording features a children's song that consists of organ keys chords, groovy piano chords, light snare hits, soft kick hits, shimmering hi hats, and flute melody. There are some squeaky sound effects, alongside plastic foley effects and outdoor ambience sounds. It sounds fun and happy, like something kids would listen to. | 2015-09-06T15:11:33Z | New Sky Kids | In Little Heroes Episode 10 the Spark is back and the cops in their kids police car and the firemen in their kids fire engine are trying to catch this fire starting bad guy! The little kid heroes rush to the rescue as he sets a tractor and dump truck on fire. --------- More Little Heroes Episodes from New Sky Kids Little Heroes 1 - Firemen Helping Others: https://youtu.be/WJfVLW6Rn2U Little Heroes 2 - The New Fire Engine, The Mayor and The Spark: https://youtu.be/LvjZ7nPF-b4 Little Heroes 3 - Firemen with their Fire Engine Teaching Darth Vader a Few Lessons: https://youtu.be/8MrH676G4hM Little Heroes 4 - The Stealer, The Fire Engine and The Batmobile: https://youtu.be/i73IBlKr1cg Little Heroes 5 - The Cops, The Fire Engine and The Return of The Spark: https://youtu.be/HOciBhi-GDc Little Heroes 6 - Firemen With Their Fire Engine Teaching Darth Vader Fire Safety: https://youtu.be/KHPy3nnLqcw Little Heroes 7 - The Germ Police And Their Cop Car - With Spiderman, The Hulk, And Darth Vader: https://youtu.be/gcAej0IHjIk Little Heroes 8 - The Spark, The Fire Engine, The Tractor And The Farm Fire: https://youtu.be/KzeIGSDpvhw Little Heroes 9 - The Police Car, The Stealer, The Fire Engine and Spiderman: https://youtu.be/VE3Cy9vmqm4 | ["Jingle (music)", "Music"] | ["low quality", "plastic sound effect", "squeaky sound effect", "light snare hits", "outdoor sound effects", "organ keys chords", "groovy piano chords", "shimmering shakers", "claps", "soft kick hits", "flute melody", "fun", "happy"] | 4 | tWexzTJPxQs | 5046 |
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;