musiccaps_details (view)
5 rows where musiccaps_aspects contains "live audience", musiccaps_aspects contains "male singer" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 72 ✖
- live audience · 5 ✖
- male singer · 5 ✖
- poor audio quality · 5 ✖
- medium tempo 4
- live performance 3
- folk singer 2
- keyboard harmony 2
- passionate 2
- accordion player 1
- adrenaline rush 1
- amateur music 1
- ambient crowd noises 1
- ambient sounds 1
- ambient street noise 1
- arabic folk singer 1
- arena 1
- bass guitar solo 1
- christmas concert 1
- christmas song 1
- christmas time 1
- clapping 1
- crowd noise 1
- crowds cheering 1
- dance arena 1
- electronic dance music 1
- emotional 1
- emphatic vocals 1
- energetic 1
- euro pop 1
- european folk song 1
- excited vocals 1
- excitement in the air 1
- exciting 1
- family reunion 1
- groovy bass line 1
- groovy music 1
- group singing 1
- guitar accompaniment 1
- heavy reverb 1
- hissing noise 1
- incoherent music 1
- keyboard trance melody 1
- latin percussions 1
- latin pop hits 1
- live band 1
- live in concert 1
- male backup singers 1
- march rhythm drumming 1
- medium fast tempo 1
- memories 1
- modern techno hits 1
- people dancing 1
- people jumping 1
- retro latin hits 1
- rom 1
- saxophone solo 1
- screaming 1
- sentimental 1
- social gathering 1
- spirited 1
- steady drumming 1
- steady drumming rhythm 1
- strong bass drum kicks 1
- strong bass line 1
- strong drumming rhythm 1
- techno drumming rhythm 1
- techno pop song 1
- teen singer 1
- trance music vibes 1
- violin playing solo 1
- vocal backup 1
- wedding music 1
musiccaps_names (array) 11 ✖
- Music 4
- Jazz 2
- Accordion 1
- Choir 1
- Christmas music 1
- Electronica 1
- House music 1
- Orchestra 1
- Singing 1
- Song 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Los Autenticos Decadentes - Veni Raquel (Vivo Pepsi Music 2010) HD | A male singer sings this exciting Latin dance melody. The tempo is medium fast with a saxophone solo, percussive bass line, guitar accompaniment, latin percussion, steady drumming rhythm, and cymbal crashes. The song is exciting with the crowds going crazy. The audio quality is poor. | 2010-11-03T06:42:47Z | popartdiscosvivo | ARTISTA: LOS AUTENTICOS DECADENTES TEMA: VENI RAQUEL EN VIVO EN EL PEPSI MUSIC 2010 - COSTANERA SUR, BUENOS AIRES, ARGENTINA - 23/10/10 | ["Jazz", "Music"] | ["live audience", "saxophone solo", "bass guitar solo", "arena", "excitement in the air", "latin percussions", "strong drumming rhythm", "guitar accompaniment", "latin pop hits", "retro latin hits", "crowds cheering", "poor audio quality", "live in concert", "exciting", "energetic", "passionate", "adrenaline rush", "medium fast tempo", "male singer"] | 1 | 244y56-vLWE | 328 | |
LAS MEJORES ELECTRÓNICAS DEL MUNDO | The song is a techno dance song sung by a male singer and backup singer harmony. The song is medium tempo with a strong bass line, keyboard harmony and steady drumming rhythm with strong bass kicks. The song is passionate and has a strong dance groove. The song is a poor recording of a modern tech pop song played for a live audience. | 2014-10-06T16:48:42Z | 23theshadows1 | AQUI ESTAN LOS NOMBRES DE LAS MUSICAS CON SUS DJ Armin van Buuren & Andrew Rayel - EIFORYA Firebeatz - Bazooka BORGORE & SIKDOPE - Unicorn Zombie Apocalypse TJR & VINAI - Bounce Generation Ibranovski - Vicious Dimitri Vegas, Like Mike, Coone - Madness feat. Lil Jon Sander van Doorn & Yves V - Direct Dizko Coone - Survival Of The Fittest KSHMR & DallasK - Burn Quintino & FTampa - Slammer Blasterjaxx - Gravity MAKJ & Lil Jon - Lets Get Fucked Up Sander van Doorn & Firebeatz - Guitar Track MAKJ & M35 - GO (Showtek Edit) W&W & Headhunterz - Shocker MAKJ & Henry Fong - Encore Stadiumx & Taylr Renee - Howl At The Moon Timmy Trumpet - Nightmare DVBBS & VINAI - Raveology W&W - Bigfoot Dimitri Vegas, Martin Garrix, Like Mike - Tremor | ["House music", "Music", "Song", "Electronica"] | ["poor audio quality", "techno pop song", "male singer", "trance music vibes", "electronic dance music", "male backup singers", "hissing noise", "keyboard harmony", "live audience", "medium tempo", "groovy music", "strong bass line", "techno drumming rhythm", "dance arena", "people jumping", "modern techno hits", "strong bass drum kicks", "keyboard trance melody", "people dancing"] | 1 | WqC-fx3uNVE | 3140 | |
Justin Bieber singing Christmas songs in Washington 2011 (perfoming for Obama!).mp4 | A male vocalist sings this Christmas song. The tempo is medium with minimal instruments like keyboard harmony and steady drumming. The audio quality is inferior so the music is incoherent. This is a live performance with ambient sounds of people clapping and cheering. This is a contemporary Christmas Song. | 2012-03-17T20:04:17Z | virgi92dT | Yeeeee!!! 1. Mistletoe 2. Away in a manger 3. a classic Christmas song featuring with Obama | ["Christmas music", "Singing", "Music", "Choir"] | ["male singer", "teen singer", "medium tempo", "vocal backup", "keyboard harmony", "steady drumming", "poor audio quality", "incoherent music", "emphatic vocals", "live performance", "ambient sounds", "clapping", "christmas song", "christmas time", "christmas concert", "live performance", "live audience", "heavy reverb"] | 7 | ZNGJN30LCwM | 3369 | |
salam- pentru cristofor la udi | A male singer sings this passionate vocal. The song is medium tempo with a groovy bass line, steady drumming rhythm and a violin playing a solo. The song is a live performance by a folk singer. The song has a bad audio quality issue. | 2008-09-28T14:54:29Z | elicsir0515 | talent:X | ["Jazz", "Music", "Orchestra", "Speech"] | ["male singer", "screaming", "poor audio quality", "wedding music", "live band", "arabic folk singer", "excited vocals", "medium tempo", "groovy bass line", "steady drumming rhythm", "crowd noise", "ambient street noise", "folk singer", "live audience", "live performance", "violin playing solo"] | 1 | bZJoTauRldE | 3634 | |
Heligonka archiv Setkání v Lošticích 2007 | A male singer sings this emotional melody. The song is medium tempo with a steady drumming rhythm, accordion accompaniment and people singing together in unison. The song is emotional and sentimental. The song audio quality is poor. | 2011-05-09T16:37:53Z | Vrana1935 | ["Accordion"] | ["male singer", "accordion player", "family reunion", "social gathering", "euro pop", "group singing", "european folk song", "folk singer", "medium tempo", "march rhythm drumming", "live audience", "live performance", "ambient crowd noises", "poor audio quality", "amateur music", "emotional", "sentimental", "rom", "passionate", "spirited", "memories"] | 1 | r4JRDHYukZ4 | 4848 |
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;