musiccaps_details (view)
3 rows where musiccaps_aspects contains "breathy flute melody", musiccaps_aspects contains "shimmering shakers" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- breathy flute melody · 3 ✖
- low quality 3
- shimmering shakers · 3 ✖
- wooden percussions 2
- addictive 1
- distorted 1
- emotional 1
- folk 1
- groovy bass 1
- groovy piano melody 1
- happy 1
- harsh 1
- joyful 1
- live performance 1
- low layer flute melody 1
- mellow piano melody 1
- noisy 1
- passionate 1
- passionate female vocal 1
- punchy kick 1
- snappy rimshots 1
- soulful 1
- sustained strings melody 1
musiccaps_names (array) 4 ✖
- Music 3
- Happy music 1
- Sad music 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sozan Namo ( Seny Pr Ihm )* kurdish Music * | The low quality recording features a folk song that consists of a wooden percussion, groovy bass, breathy flute melody, groovy piano melody, shimmering shakers and sustained strings melody. It sounds passionate, joyful and happy. | 2010-05-10T13:43:42Z | Hemmen A M | Best Song .......... | ["Music", "Happy music"] | ["low quality", "folk", "wooden percussions", "groovy bass", "breathy flute melody", "groovy piano melody", "sustained strings melody", "shimmering shakers", "passionate", "happy", "joyful"] | 4 | -mA_bqD1tgU | 83 | |
Sad TVB Background Music | The low quality recording features a breathy flute melody layered with low flute melody, followed by mellow piano melody, punchy kick, snappy rimshots and shimmering shakers. It sounds soulful and emotional, but the recording is very noisy, harsh and distorted. | 2010-01-02T05:59:20Z | rimusan | The sound clip is often played in sad scenes of TVB dramas such as: The Duke of Mount Deer, The Legendary Four Aces, and much more. Since TVB does not sell any of their Background music soundtrack (i haven't been able to find one) I extracted this from an episode of the Duke of Mount Deer (Hence the abrupt ending). Made it into a slideshow/movie file so youtube will host it. Images from Wallcoo Since I do not own the right to this song, I cannot provide a download link or send you the file. This is just a fan video. | ["Music", "Sad music"] | ["low quality", "breathy flute melody", "mellow piano melody", "low layer flute melody", "noisy", "emotional", "soulful", "punchy kick", "snappy rimshots", "shimmering shakers", "harsh", "distorted"] | 4 | 9GRNQKSsbvU | 987 | |
Bollywood Dance - Ringa Ringa - Slumdog Millionaire - http://www.bollywooddance.org.uk | The low quality recording features a live performance that consists of shimmering shakers, wooden percussion, breathy flute melody and passionate female vocals singing over it. It sounds very addictive, due to the lead vocal cadence. It is a bit reverberant, as it was recorded in a larger room, with a low quality microphone. | 2010-07-03T13:35:27Z | Mahadev Semwal | Students of Bollywood Dance Worldwide at Reading Berkshire learning Ringa Ringa from Slumdog Millionaire. More workshop related information at http://www.bollywooddance.org.uk/workshops More performance related information at http://www.bollywooddance.org.uk/videos More hen night related information at http://www.bollywooddance.org.uk/hennights | ["Music", "Tambourine"] | ["low quality", "shimmering shakers", "wooden percussions", "passionate female vocal", "live performance", "addictive", "breathy flute melody"] | 4 | uF1KTW5rT-s | 5102 |
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;