musiccaps_details (view)
2 rows where musiccaps_aspects contains "distorted", musiccaps_names contains "Pop music" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- distorted · 2 ✖
- live performance 2
- low quality 2
- mono 2
- noisy 2
- bright bells 1
- compilation 1
- crowd cheering 1
- emotional 1
- exciting 1
- harmonizing vocals 1
- loud 1
- mellow piano chords 1
- passionate 1
- punchy kick 1
- punchy snare 1
- resonating sound 1
- shimmering hi hats 1
- simple bass 1
- synth pads 1
- weird 1
musiccaps_names (array) 6 ✖
- Music 2
- Pop music · 2 ✖
- Singing · 2 ✖
- Chink, clink 1
- Music of Asia 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Vlog No. 12 - SHINee's unofficial Vlogs of 2012 - mistakes & unexpected | The low quality recording features a compilation of recordings where the first recording in the loop is a live performance that's distorted, loud and in mono. The second part of the recording is very noisy and it features bright bells, some resonating sounds and it sounds weird. | 2013-01-11T19:53:33Z | maggie198333 | more to come~ please do not re-upload https://twitter.com/maggieline7 http://www.tudou.com/home/maggie198333 | ["Singing", "Music of Asia", "Music", "Pop music", "Chink, clink"] | ["low quality", "live performance", "loud", "distorted", "bright bells", "noisy", "mono", "resonating sound", "weird", "compilation"] | 4 | 6II4JGJDyZo | 740 | |
KC Concepcion in Chicago #8 | The low quality recording features harmonizing vocals singing over punchy kick and snare hits, shimmering hi hats, synth pads, simple bass and mellow piano chords. There are crowd cheering noises in the background as this is a live performance. It sounds passionate, emotional, exciting and the recording is noisy, in mono and slightly distorted. | 2011-10-31T01:02:49Z | TeamKC4life | KC Concepcion as Vivian sings the themesong of Lovers in Paris, Wag Na Wag Mong Sasabihin. Much love & thanks to my honey, John, for being KC's best videographer. | ["Singing", "Music", "Pop music", "Whoop"] | ["live performance", "low quality", "noisy", "mono", "crowd cheering", "distorted", "harmonizing vocals", "punchy snare", "punchy kick", "shimmering hi hats", "synth pads", "simple bass", "mellow piano chords", "passionate", "emotional", "exciting"] | 4 | He63KV_9Pwg | 1823 |
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;