musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_names contains "Pop music" and musiccaps_names contains "Yell"
This data as json, CSV (advanced)
musiccaps_aspects (array) 42 ✖
- live performance · 3 ✖
- "4 on the floor" kick pattern 2
- crowd cheering 2
- exciting 2
- low quality 2
- pop 2
- addictive synth bass melody 1
- adventurous 1
- ambient crowd noises 1
- bad audio quality 1
- clapping 1
- diva 1
- electric rhythm guitar playing 1
- electro song 1
- energetic 1
- energetic cymbals 1
- female guitarist 1
- flat male vocal 1
- groovy synth bass 1
- guitar solo 1
- happy 1
- hard rock 1
- haze machine sounds 1
- home video 1
- instrumental music 1
- joyful 1
- live concert video 1
- medium fast tempo 1
- medium fats tempo 1
- noisy 1
- people cheering 1
- people screaming 1
- percussive bass line 1
- poor audio recording 1
- punchy snare 1
- rock band 1
- rock drumming 1
- rock guitar solo 1
- shimmering hi hats 1
- synth lead melody 1
- testosterone driven 1
- youthful 1
musiccaps_names (array) 9 ✖
- Music 3
- Pop music · 3 ✖
- Yell · 3 ✖
- Guitar 1
- Inside, large room or hall 1
- Inside, public space 1
- Singing 1
- Speech 1
- Whoop 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Orianthi - Guitar Solo [singfest 3/8/10] | The song is an instrumental. The tempo is medium fast with a strong guitar lead, rock drumming rhythm, percussive bass line and an electric guitar strumming rhythm. The song is high on adrenaline and exciting. The audio quality is very bad with ambient crowd screaming noises. | 2010-08-05T15:37:54Z | Zahara Sulaiman | Orianthi performance during singfest in Singapore. | ["Guitar", "Music", "Pop music", "Whoop", "Yell", "Inside, large room or hall"] | ["live performance", "ambient crowd noises", "medium fast tempo", "live concert video", "home video", "poor audio recording", "testosterone driven", "female guitarist", "exciting", "youthful", "diva", "rock guitar solo", "adventurous", "people screaming", "guitar solo", "rock band", "instrumental music", "people cheering", "bad audio quality", "hard rock", "rock band", "medium fats tempo", "rock drumming", "percussive bass line", "electric rhythm guitar playing"] | 1 | G8iTuTi8ywU | 1694 | |
[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 | |
Burn It Up - Yassi Pressman | The low quality recording features a live performance with an electro song playing in the background and crowd cheering sounds. The song consists of a "4 on the floor" kick pattern, addictive synth bass melody, punchy snare and shimmering hi-hats. It sounds energetic and the recording is noisy as it was probably recorded with a phone. | 2016-04-04T05:54:17Z | dealwithjames | Happy Truck #Happinas Mid Prod Yassi Pressman - Burn It Up | ["Music", "Pop music", "Yell", "Speech", "Inside, public space"] | ["crowd cheering", "electro song", "haze machine sounds", "live performance", "\"4 on the floor\" kick pattern", "pop", "punchy snare", "addictive synth bass melody", "shimmering hi hats", "energetic", "low quality", "noisy"] | 4 | ykkVTInYctY | 5434 |
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;