musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "energetic", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "vocal backup"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- energetic · 2 ✖
- fast tempo 2
- keyboard harmony · 2 ✖
- vocal backup · 2 ✖
- alternative rock 1
- alto sax 1
- bass guitar 1
- bright 1
- dance music 1
- emphatic vocals 1
- enthusiastic 1
- female singer 1
- groovy bass line 1
- inferior audio quality 1
- intense electric guitar 1
- jarring 1
- loud 1
- male vocalist 1
- people cheering 1
- people talking 1
- perky 1
- pop 1
- pop rock 1
- powerful voice 1
- punchy drumming 1
- punk pop 1
- rhythmic acoustic guitar 1
- rock 1
- rock and roll 1
- saxophone 1
- spirited drumming 1
- tambourine 1
- tenor sax 1
- vigorous vivacious 1
- youthful 1
musiccaps_names (array) 13 ✖
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Inside, large room or hall 1
- Music 1
- Musical instrument 1
- Percussion 1
- Rimshot 1
- Rock music 1
- Roll 1
- Singing 1
- Snare drum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
A Motown Tribute to Avril Lavigne [in color] | A female vocalist sings this spirited song. The tempo is fast with an animated keyboard harmony, groovy bass lines, electric guitar, tenor and alto saxophone accompaniment, enthusiastic drumming and tambourine beats with vocal backup. The song is energetic, upbeat, youthful, enthusiastic with emphatic vocals. This song is contemporary alternative rock. | 2012-02-21T22:06:57Z | PostmodernJukebox | Download & Stream Here: http://scottbradlee.bandcamp.com/album/roar-ep Experience PMJ Live: https://pmjlive.com?IQid=yt Shop PMJ Music/Merch: https://smarturl.it/pmjshop?IQid=yt Spotify: https://smarturl.it/pmjcomplete?IQid=yt Annie Goodchild - Vocals Tim Kubart - Tambourine Guy Ben The Sax Guy - Saxophone Adam Kubota - Bass Scott Bradlee - Piano & Arrangement YouTube: http://youtube.com/scottbradlee Facebook: http://facebook.com/scottbradleemusic Instagram: http://instagram.com/scottbradlee Twitter: http://twitter.com/scottbradlee Scott's Book: http://smarturl.it/outsidethejukebox | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["female singer", "fast tempo", "saxophone", "bass guitar", "energetic", "perky", "youthful", "spirited drumming", "tambourine", "keyboard harmony", "vocal backup", "tenor sax", "alto sax", "powerful voice", "emphatic vocals", "alternative rock", "punk pop"] | 7 | kkjNpwNcMWI | 4354 |
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;