musiccaps_details (view)
4 rows where musiccaps_author = 3 and musiccaps_names contains "Rock and roll"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Peter, Bjorn & John - "Young Folks" @ Laneway Festival 2007 | This is a recording of a live indie rock performance. The recording is distorted and of a low quality. There are two male singers singing in an indie style with a lot of reverb applied to their vocals. The bass is rumbling and low and constant. | 2007-03-04T14:57:51Z | onelinergirl | With special guest - Traceyanne Campbell of Camera Obscura - 2nd annual Laneway Festival, Circular Quay, Sydney, Sunday March 4, 2007 | ["Singing", "Music", "Rock music", "Roll", "Rock and roll"] | ["live recording", "indie rock", "alternative rock", "upbeat", "low quality audio", "fuzzy audio", "distorted audio", "indie male vocalist", "reverb", "bass rumbling"] | 3 | 9JlifkCmUOk | 993 | |
| Yellowcard - Breathing (Live) | This is a punk rock song with an energetic, youthful feel that is still grungy and gritty. The guitar is dark and powerful in the low tones, contrasted by another electric guitar that's bright and warm on the off beats. The drummer plays a high octane drum beat with drum fills between each line of the lyrics. | 2006-10-11T05:14:12Z | Oscar Jara | $$$~Yellowcard~$$$ | ["Heavy metal", "Music", "Rock and roll", "Progressive rock"] | ["punk rock", "rock", "punk", "energetic", "charged up", "bouncy", "gritty", "grungy", "youthful", "heavy grungy electric guitar strumming", "energetic emo vocalist"] | 3 | NzVg-cFQJbE | 2386 | |
| Dr. Rockzo. "I'm a Rock n Roll Clown" | This is a recording of a live show performance by a rock band. We hear some cheering fans and then the song starts with an electric guitar lick and a bass guitar, and a kick on the drums. The audio quality is muffled and poor. | 2009-04-11T20:25:15Z | starz7007 | Brenden Small and the School of Rock all stars at the Starland Ballroom. 4-4-09. Dr. Rockzo. "I'm a Rock n Roll Clown" from metalocalypse | ["Drum kit", "Music", "Musical instrument", "Rock music", "Shout", "Rock and roll", "Speech"] | ["live recording", "cheering fans", "live performance", "rock", "poor audio quality", "electric guitar lick", "alternative rock", "blues rock"] | 3 | XHczpbtBhk4 | 3171 | |
| Country Swing Dancing - Moves Tricks Lifts Aerials Dips Flips | The song is a country rock song with a charged up, potent sound. The guitar is grungry, and gives punchy and gritty energy. The singer has a smooth voice and sings with charisma and suave charm. | 2011-06-06T20:49:56Z | ForeverCountryDancing | Check out more dance clips and country swing dance instruction on our YouTube channel and https://forevercountry.intelivideo.com/. Purchase your Forever Country t-shirt at https://www.redbubble.com/people/forevercountry3/explore?asc=u&page=1&sortOrder=recent | ["Country", "Music", "Rock and roll"] | ["country rock", "banjos", "grungy electric guitar", "simple rock drumming", "electric guitar lick", "charged up", "high octane", "rock"] | 3 | ewI4q7_4TBQ | 3910 |
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;