musiccaps_details (view)
5 rows where musiccaps_aspects contains "inferior audio quality" and musiccaps_aspects contains "pop" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 90 ✖
- inferior audio quality · 5 ✖
- pop · 5 ✖
- male vocalist 3
- muffled audio 3
- vivacious 3
- amateur recording 2
- energetic 2
- fast tempo 2
- keyboard harmony 2
- live performance 2
- people talking 2
- retro 2
- rhythmic acoustic guitar 2
- 90’s hit song 1
- acordion harmony 1
- acoustic guitar rhythm 1
- ambient concert sounds 1
- ambient sounds 1
- animated trumpets 1
- back street boys 1
- boy band 1
- brass band 1
- bright 1
- buoyant 1
- cheering 1
- choral harmony 1
- clapping 1
- classic melody 1
- classic rock 1
- concert 1
- congas beat 1
- dance music 1
- distorted sound 1
- electrifying 1
- emotional 1
- engaging 1
- enthusiastic 1
- fans screaming 1
- female singer 1
- funk 1
- groovy bass line 1
- groovy bass lines 1
- groovy dance beat 1
- guitar accompaniment 1
- hard hitting drumming 1
- hysteria 1
- inaudible lyrics 1
- indistinct chatter 1
- intense electric guitar 1
- jarring 1
- keyboard accompaniment 1
- keyboard arrangement 1
- live audience 1
- lively 1
- loud 1
- male singer 1
- medium fast tempo 1
- medium tempo 1
- melodic 1
- muffled instrumentation 1
- muffled vocals 1
- outdoors 1
- people cheering 1
- pop hit 1
- pop rock 1
- pulsating 1
- punchy drumming 1
- r&b 1
- retro pop 1
- retro rock and roll 1
- rock 1
- rock and rock 1
- rock and roll 1
- slow tempo 1
- soft melody 1
- soul 1
- spanish 1
- spirited 1
- steady drumming 1
- tambourine beats 1
- thumping beats 1
- trombone 1
- vibrant 1
- vigorous 1
- vigorous instrumentation 1
- vigorous vivacious 1
- violin symphony 1
- vital 1
- vocal backup 1
- youthful 1
musiccaps_names (array) 12 ✖
- Music 5
- Singing 3
- Rock music 2
- Roll 2
- Bang 1
- Crowd 1
- Gospel music 1
- Inside, large room or hall 1
- Musical instrument 1
- Rattle (instrument) 1
- Shout 1
- Wedding music 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
BACKSTREET BOYS - BANG @ DUBAI.MPG | A male vocalist sings this Popular 90’s song. The tempo is medium fast with thumping drum beats, keyboard harmony, boomy bass and vocal backup.The song is a live performance at a concert with ambient sounds of fans screaming, clapping and singing along and responding. The audio is incoherent as it is an amateur recording. This song is a Hit 90’s Pop. | 2009-12-18T20:10:01Z | imthiazdxb | Backstreet Boys- Live @ Dubai ON 17th Dec 2009-The Curtain Raiser | ["Crowd", "Music", "Rock music", "Shout", "Bang"] | ["male vocalist", "medium fast tempo", "boy band", "90’s hit song", "pop", "live performance", "live audience", "concert", "back street boys", "ambient concert sounds", "fans screaming", "hysteria", "thumping beats", "inferior audio quality", "muffled audio", "muffled instrumentation", "energetic", "electrifying", "pulsating", "vibrant", "vivacious", "pop hit"] | 7 | ab8V7MYQVyg | 3556 | |
BJ Thomas ~ Rock And Roll Lullaby | A male vocalist sings this melodic song. The tempo is medium with muffled vocals, violin harmony, rhythmic guitar , steady drumming and straight bass lines. The language and lyrics of the song are inaudible because of the amateur recording.This song is a Classic Rock and Roll. | 2011-06-25T22:02:46Z | IP Casino Resort Spa | BJ Thomas sings "Rock And Roll Lullaby" in Studio A in the IP Casino Resort Spa on June 24, 2011 | ["Singing", "Gospel music", "Music", "Wedding music"] | ["male singer", "slow tempo", "inaudible lyrics", "amateur recording", "melodic", "indistinct chatter", "soft melody", "emotional", "distorted sound", "violin symphony", "guitar accompaniment", "keyboard arrangement", "muffled vocals", "inferior audio quality", "rock and rock", "classic melody", "pop", "classic rock", "retro", "retro rock and roll", "steady drumming"] | 7 | BUzsQ6WohH4 | 1245 | |
Chicas Roland's - Cumbia - El Hijo De Tuta | A female vocalist sings this Spanish melody. The tempo is medium with keyboard harmony, tambourine beats, rhythmic congas and acoustic guitar. The song is upbeat, buoyant, groovy, lively, spirited,youthful and engaging. This is an outdoor live performance as there are ambient sounds like gentle wind, people talking, clapping and cheering. This song is a lively Spanish Pop song. | 2008-06-13T21:36:48Z | Palmeras Disco | Video "del Baul De Los Recuerdos" de Las Chicas Roland's interpretando la cumbia "El Hijo De Tuta" en Junio del 2002. Espero les guste... | ["Singing", "Music", "Rattle (instrument)"] | ["female singer", "medium tempo", "pop", "spirited", "lively", "buoyant", "engaging", "vivacious", "spanish", "amateur recording", "muffled audio", "acordion harmony", "congas beat", "keyboard accompaniment", "rhythmic acoustic guitar", "live performance", "outdoors", "ambient sounds", "people talking", "cheering", "clapping", "inferior audio quality", "groovy dance beat", "buoyant", "youthful", "tambourine beats"] | 7 | Py8Vd0-qxYU | 2583 | |
Looking Out My Window - Tom Jones | A male vocalist sings this energetic funk pop. The audio quality is inferior and the song is not clear.The tempo is. Fast with animated trumpets, with a boomy trombone, infectious drumming, keyboard harmony, groovy bass lines, rhythmic electric and acoustic guitar and melodious choral backup. The song is melodic, enthusiastic, energetic, animated and captivating Retro Funk/Pop. | 2008-12-16T18:46:37Z | bomtraumusic | Looking Out My Window Tom Jones | ["Music", "Roll"] | ["male vocalist", "fast tempo", "pop", "retro", "retro pop", "muffled audio", "inferior audio quality", "vivacious", "vigorous", "vital", "funk", "r&b", "soul", "vigorous instrumentation", "brass band", "animated trumpets", "trombone", "hard hitting drumming", "keyboard harmony", "choral harmony", "groovy bass lines", "acoustic guitar rhythm", "brass band"] | 7 | DE6bdmnmPtg | 1454 | |
Rock 'n' Roll Girls -- John Fogerty | A male vocalist sings this spirited rock and rock song. The tempo is fast with bright drumming, intense electric guitar feedback, keyboard harmony and rhythmic acoustic guitar with vocal backup. The song is upbeat, spirited, enthusiastic, vibrant, vivacious, buoyant and youthful with a dance groove. The sound quality is inferior making it difficult to understand the lyrics or the finer elements of this Rock and Roll song. | 2008-09-03T02:10:47Z | zanzkantdance | John Fogerty performs "Rock and Roll Girls" from Centerfield live in Oakland in 1986, set to various background videos. | ["Singing", "Music", "Musical instrument", "Rock music", "Roll", "Inside, large room or hall"] | ["male vocalist", "fast tempo", "intense electric guitar", "punchy drumming", "keyboard harmony", "vocal backup", "rhythmic acoustic guitar", "groovy bass line", "loud", "jarring", "inferior audio quality", "people cheering", "people talking", "energetic", "enthusiastic", "vigorous vivacious", "bright", "enthusiastic", "dance music", "pop", "pop rock", "rock", "rock and roll"] | 7 | 1ZaxqZMs21M | 287 |
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;