musiccaps_details (view)
3 rows where musiccaps_aspects contains "mono" and musiccaps_aspects contains "plucked strings melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- low quality 3
- mono · 3 ✖
- noisy 3
- plucked strings melody · 3 ✖
- joyful 2
- passionate 2
- traditional 2
- wooden percussions 2
- children song 1
- church bells melody 1
- clock ticking 1
- emotional 1
- flat female vocal 1
- fun 1
- happy 1
- harmonizing male vocals 1
- live performance 1
- passionate female vocal 1
- soulful 1
- synth lead melody 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 |
---|---|---|---|---|---|---|---|---|---|---|
`` 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 | |
Sukey's Circle! Vol. 1: Tick Tock (expanded version) - (SD) | The low quality recording features a children's song that consists of a clock ticking, church bells melody, plucked strings melody and flat female vocal singing over it. It sounds happy, joyful and fun. The recording is mono and noisy. | 2011-05-02T13:30:42Z | SukeyMolloy | Learn more about Sukeys Circle! at http://www.sukeymolloy.com. Join Sukey Molloy and her favorite friends Sunny and Tick Tock at Sukey’s Circle! for ‘Tick Tock’. Sukey dances, plays, and sings with Tick Tock while rocking, jumping, hopping and clapping. This is the original expanded version. You can also see Tick Tock on Vol. 3, and listen to the Tick Tock song on Sukey’s first CD, Circle Songs created for ages 1-5. | ["Music", "Music for children", "Tick", "Glockenspiel"] | ["low quality", "clock ticking", "church bells melody", "flat female vocal", "plucked strings melody", "happy", "joyful", "fun", "children song", "noisy", "mono"] | 4 | YLlbLSNxdQ4 | 3277 | |
Jamilah sa'ad yemen song | The low quality recording features a passionate female vocalist singing over wooden percussion, synth lead melody and plucked strings melody playing in the background. It sounds passionate, emotional, joyful and traditional. | 2009-01-27T15:22:28Z | girhish | Jamilah sa'ad | ["Singing", "Traditional music", "Music"] | ["low quality", "mono", "noisy", "passionate female vocal", "wooden percussions", "synth lead melody", "plucked strings melody", "passionate", "emotional", "joyful", "traditional"] | 4 | gNpzuFPu6q8 | 4027 |
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;