musiccaps_details (view)
5 rows where musiccaps_aspects contains "crowd cheering" and musiccaps_aspects contains "joyful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- crowd cheering · 5 ✖
- joyful · 5 ✖
- low quality 4
- emotional 2
- live performance 2
- passionate 2
- pop 2
- sustained strings melody 2
- "4 on the floor" kick pattern 1
- acoustic guitar melody 1
- arpeggiated acoustic guitar melody 1
- chime bells 1
- clapping 1
- drum & pipe band 1
- echoing passionate male vocal 1
- energetic cymbals 1
- exciting 1
- female voice 1
- flat male vocal 1
- folk 1
- groovy synth bass 1
- happy 1
- harmonizing male vocals 1
- heartfelt 1
- male voice 1
- plucked strings melody 1
- scottish bagpipes 1
- shimmering bells melody 1
- shouting 1
- street performance 1
- synth lead melody 1
- talking 1
- vibrant 1
- whistling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Junsu and Changmin singing Timeless | The low quality recording features a live performance of a pop song that consists of harmonizing male vocals singing, while there are crowd cheering noises in the background. It sounds passionate, heartfelt and joyful. | 2007-07-24T20:30:41Z | holdxmexnow | This is a cut from the dbsk special concert. NO COPYRIGHT FRINGEMENT INTENDED! | ["Choir", "/t/dd00003"] | ["low quality", "pop", "harmonizing male vocals", "crowd cheering", "passionate", "heartfelt", "joyful"] | 4 | 56Cm1AkbfbU | 633 | |
Pichenda | The low quality recording features an arpeggiated acoustic guitar melody, shimmering bells melody, plucked strings melody and sustained strings melody, followed by chime bells. There are some crowd cheering noises in the background. It sounds emotional and joyful. | 2007-06-24T01:34:04Z | khmrch1cca | RHM Vol. 52 | ["Bell", "Music"] | ["low quality", "crowd cheering", "arpeggiated acoustic guitar melody", "shimmering bells melody", "chime bells", "plucked strings melody", "sustained strings melody", "emotional", "joyful"] | 4 | LTDle_h2YD8 | 2191 | |
Toshi - Piya Re (UKU) | The low quality recording features a live performance of a folk song that consists of an echoing passionate male vocal singing over sustained strings melody, acoustic guitar melody and some crowd cheering and whistling sounds in the background. It sounds joyful, passionate and emotional overall. | 2009-04-12T19:01:17Z | MariumSaeed | ["Singing", "Music of Asia", "Music"] | ["low quality", "folk", "live performance", "echoing passionate male vocal", "sustained strings melody", "acoustic guitar melody", "crowd cheering", "whistling", "joyful", "passionate", "emotional"] | 4 | e1PG31QlQmc | 3836 | ||
[FANCAM] 101230 kbs gayo opening - Last Festival (Junho focus) | The low quality recording features a live performance of a pop song that contains flat male vocals talking on a microphone over a song played on playback and some crowd cheering noises. The song consists of a "4 on the floor" kick pattern, energetic cymbals, groovy synth bass, claps and synth lead melody. It sounds happy, joyful and exciting. | 2010-12-30T19:35:19Z | casey (emperornuneo) | Credit: AboutABoy | ["Singing", "Music", "Pop music", "Yell"] | ["low quality", "live performance", "pop", "crowd cheering", "flat male vocal", "clapping", "synth lead melody", "\"4 on the floor\" kick pattern", "energetic cymbals", "groovy synth bass", "happy", "joyful", "exciting"] | 4 | mB2FAS0DNkk | 4451 | |
Clanadonia - Freak Music - Scotland | This is a street performance by a drum & pipe band. In the beginning, there is a female voice talking. Then, she starts playing the Scottish bagpipes in a joyful manner. A male voice shouts at the crowd to get them into mood and the crowd starts cheering. The atmosphere is vibrant. This piece could be used in the soundtrack of a historical drama movie that takes place in Scotland. | 2009-08-03T19:16:55Z | FreakMusicLtd | Hire Clanadonia with Freak Music - http://www.freakmusic.co.uk Clanadonia are leading exponents of traditional Celtic folk with an emphasis on tribal percussion. Although the band's musical roots have been passed down from their ancestors, this five piece have been cited as something more than just another Scottish pipes and drums band. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["street performance", "drum & pipe band", "female voice", "talking", "scottish bagpipes", "male voice", "shouting", "crowd cheering", "vibrant", "joyful"] | 9 | yOJtRE-617I | 5404 |
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;