musiccaps_details (view)
5 rows where musiccaps_aspects contains "punchy snare" and musiccaps_names contains "Roll"
This data as json, CSV (advanced)
| 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 | |
| Gwen Owens - Just Say You're Wanted (And Needed) | The low quality recording features a Northern Soul song sung by passionate female vocalists and background harmonizing female vocals over punchy snare, groovy bass and sustained brass melody. It sounds upbeat, crushed, vintage, emotional and funky. The recording is noisy and in mono. | 2009-10-08T07:53:03Z | bricomaligno | Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favour of fair use. | ["Music", "Roll"] | ["low quality", "vintage", "northern soul", "passionate female vocal", "background harmonizing female vocals", "punchy snare", "noisy", "groovy bass", "sustained brass melody", "crushed", "mono", "distorted", "funky", "emotional", "upbeat"] | 4 | EZAwPnGOJPE | 1567 | |
| Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin | The low quality recording features a live performance of a rock song that consists of echoing, energetic male vocals that are singing over wide electric guitar chord progression, energetic crash cymbals, punchy snare, boomy kick and groovy bass guitar. It sounds energetic and exciting. | 2012-12-27T03:55:00Z | saveyouckufer | Foo Fighters - Rock and Roll - Kennedy Center Honors - Led Zeppelin Celebration Day http://amzn.to/TFuvtc | ["Music", "Roll", "Rock and roll"] | ["low quality", "echoing energetic male vocal", "wide electric guitar chord progression", "energetic crash cymbals", "punchy snare", "boomy kick", "groovy bass guitar", "rock", "live performance", "energetic", "exciting"] | 4 | Q8f6y2IcVg0 | 2600 | |
| Rock and Roll Dance in Radio Planeta 2 | The low quality recording features an uptempo rock song that consists of suspenseful electric guitar melody, punchy snare, simple kick pattern, groovy bass guitar, tinny percussive elements and passionate male vocal singing over it. The recording is in mono and it sounds energetic, groovy and like something you would dance to with your friends. | 2012-11-15T13:07:30Z | Bertjuh Chevy | ["Music", "Roll", "Rock and roll"] | ["rock", "suspenseful electric guitar melody", "punchy snare", "simple kick pattern", "groovy bass guitar", "passionate male vocal", "mono", "low quality", "energetic", "uptempo", "tinny percussive elements"] | 4 | lHlOSsnP48c | 4388 | ||
| Iron Eagle - Old Enough to Rock and Roll.flv | The low quality recording features a rock song that consists of groovy electric guitar chord progression, smooth bass guitar, punchy snare and kick hits, shimmering hi hats and flat female vocals singing over it. At the end of the first half of the loop, there is a short snare roll alongside glissando organ keys melody, sliding perfectly into the next section, which begins with the energetic crash hit. It sounds energetic, groovy, and kind of vintage and warm, since it really sounds old - especially because the song is in mono. | 2010-06-21T07:13:17Z | 2kgt | ["Music", "Roll", "Rock and roll"] | ["low quality", "mono", "groovy electric guitar chords progression", "smooth bass guitar", "punchy snare", "punchy kick", "short snare roll", "flat female vocal", "rock", "shimmering hi hats", "organ keys glissando", "energetic", "groovy", "energetic crash", "vintage", "warm"] | 4 | lOIzOWKd47E | 4393 |
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;