musiccaps_details (view)
3 rows where musiccaps_aspects contains "distorted", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- distorted · 3 ✖
- live performance 3
- low quality 3
- punchy kick · 3 ✖
- punchy snare 3
- crowd cheering 2
- emotional 2
- energetic 2
- messy 2
- mono 2
- noisy 2
- boomy bass 1
- buzzy 1
- distorted bass 1
- electric guitar chords 1
- energetic cymbals 1
- energetic female vocal 1
- exciting 1
- female screams 1
- harmonizing vocals 1
- loud 1
- mellow piano chords 1
- muddy 1
- muffled 1
- passionate 1
- rock 1
- shimmering hi hats 1
- simple bass 1
- synth pads 1
- vocals 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
I Love Rock'n Roll - Anna-Maria Zimmermann | The low quality recording features a live performance of a rock song that consists of an energetic female vocal singing over electric guitar chords, punchy snare and kick hits and distorted bass guitar. The recording is very noisy and buzzy, in mono, muffled and messy, as it was probably recorded with a phone. It still sounds energetic. | 2007-12-02T10:34:45Z | Leni281 | Anna-Maria Zimmermann (von DSDS 2006) singt "I Love Rock'n Roll" Livemitschnitt vom Nevio Konzert vom 09.04.06 in Hirschaid | ["Singing", "Music", "Rock music", "Roll"] | ["low quality", "buzzy", "noisy", "rock", "mono", "energetic", "muffled", "messy", "distorted", "live performance", "punchy kick", "punchy snare", "distorted bass", "energetic female vocal", "electric guitar chords"] | 4 | 7Mv4eKPe850 | 838 | |
KC Concepcion in Chicago #8 | The low quality recording features harmonizing vocals singing over punchy kick and snare hits, shimmering hi hats, synth pads, simple bass and mellow piano chords. There are crowd cheering noises in the background as this is a live performance. It sounds passionate, emotional, exciting and the recording is noisy, in mono and slightly distorted. | 2011-10-31T01:02:49Z | TeamKC4life | KC Concepcion as Vivian sings the themesong of Lovers in Paris, Wag Na Wag Mong Sasabihin. Much love & thanks to my honey, John, for being KC's best videographer. | ["Singing", "Music", "Pop music", "Whoop"] | ["live performance", "low quality", "noisy", "mono", "crowd cheering", "distorted", "harmonizing vocals", "punchy snare", "punchy kick", "shimmering hi hats", "synth pads", "simple bass", "mellow piano chords", "passionate", "emotional", "exciting"] | 4 | He63KV_9Pwg | 1823 | |
Hot Chelle Rae and Demi Lovato - Why Don't You Love Me - Acoustic Christmas 2011 | The low quality recording features a live performance of a song that is barely audible due to distorted sound, loud cheering crowd and female screams. There is definitely at least a boomy bass, punchy kick and snare hits and energetic cymbals, alongside some vocals singing over it. It sounds messy and muddy, but also emotional and energetic. | 2011-12-04T22:58:33Z | bonesrulz13 | Hot Chelle Rae and Demi Lovato performing their song "Why Don't You Love Me" live for the first time on 12/2/2011 at 107.5 The River's Acoustic Christmas event in Nashville, TN at the TPAC War Memorial Auditorium. no copyright infringement intended, just my video from the show for others to see. | ["Singing", "Music", "Yell"] | ["low quality", "crowd cheering", "female screams", "live performance", "punchy snare", "boomy bass", "energetic cymbals", "muddy", "messy", "loud", "distorted", "punchy kick", "vocals", "emotional", "energetic"] | 4 | sTcaIARuemA | 4952 |
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;