musiccaps_details (view)
2 rows where musiccaps_aspects contains "crowd clapping", musiccaps_author = 4 and musiccaps_names contains "Music of Asia"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- crowd clapping · 2 ✖
- live performance 2
- low quality 2
- addictive 1
- crowd cheering 1
- crowd talking 1
- emotional 1
- energetic 1
- exciting 1
- groovy synth bass 1
- harp melody 1
- mixed harmonized vocals 1
- passionate 1
- passionate boy vocal 1
- passionate female vocal 1
- playback 1
- pop 1
- punchy bass 1
- punchy kick 1
- reversed crash riser 1
- shimmering hi hats 1
- simple bass 1
- soul 1
- sustained strings melody 1
- sustained synth bass 1
- wide synth melody 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
St Julian's School flashmob | The low quality recording features a crowd talking and clapping to a soul song that is played on a playback. The song consists of a passionate female vocal, alongside mixed harmonizing vocals, singing over sustained strings melody, simple bass and harp melody. It sounds emotional and passionate. | 2015-07-16T19:47:33Z | SouthWalesArgus | St Julian's School flashmob for Mrs Gabica | ["Singing", "Music of Asia", "Music"] | ["low quality", "crowd talking", "crowd clapping", "simple bass", "harp melody", "passionate female vocal", "mixed harmonized vocals", "sustained strings melody", "soul", "passionate", "emotional", "live performance", "playback"] | 4 | PuJxL6tLxm4 | 2575 | |
Soufjan - Applause (Lady Gaga) - The Voice Kids Germany Audition 28/03/2014 | The low quality recording features a live performance of a pop song and it consists of a passionate boy vocal singing over wide synth melody, reversed crash riser, punchy kick and snare hits, shimmering hi hats, groovy synth bass and later sustained synth bass. There is some crowd noise and cheering sounds. It sounds addictive, energetic and exciting. | 2014-03-29T11:06:31Z | MusicDriveUsCrazy | Lady Gaga. Soufjan - Applause (Auftritt) - The Voice Kids Germany 2014 - Blind Audition 2 vom 28.3.2014, Team Johannes, | ["Applause", "Music of Asia", "Music"] | ["low quality", "pop", "live performance", "crowd cheering", "crowd clapping", "passionate boy vocal", "wide synth melody", "reversed crash riser", "punchy kick", "punchy bass", "sustained synth bass", "groovy synth bass", "shimmering hi hats", "energetic", "exciting", "addictive"] | 4 | pHj8U-3RHc4 | 4696 |
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;