musiccaps_details (view)
2 rows where musiccaps_aspects contains "exciting", musiccaps_author = 4 and musiccaps_names contains "Whoop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- exciting · 2 ✖
- low quality 2
- mono 2
- noisy 2
- crowd cheering 1
- crowd harmonizing singing 1
- distorted 1
- emotional 1
- energetic 1
- harmonizing vocals 1
- joyful 1
- live performance 1
- loud wooden percussion 1
- mellow piano chords 1
- passionate 1
- phone recording 1
- punchy kick 1
- punchy snare 1
- shimmering hi hats 1
- simple bass 1
- synth pads 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
AIESEC Turkey shout at NATCO before the Opening | The low quality recording features a crowd harmonized singing over loud wooden percussion. The recording is noisy, in mono and it sounds energetic, joyful and exciting. | 2011-05-24T08:40:49Z | Tatish | NATCO 2011 | ["Music", "Whoop"] | ["low quality", "noisy", "mono", "phone recording", "loud wooden percussion", "crowd harmonizing singing", "energetic", "exciting", "joyful"] | 4 | nf3LGAL1LZc | 4568 |
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;