musiccaps_details (view)
2 rows where musiccaps_aspects contains "passionate", musiccaps_aspects contains "rock" and musiccaps_aspects contains "soulful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- passionate · 2 ✖
- rock · 2 ✖
- soulful · 2 ✖
- choir 1
- church organ chords progression 1
- electric guitar melody 1
- emotional 1
- energetic 1
- energetic drums 1
- funky 1
- funky bass guitar 1
- groovy piano melody 1
- live performance 1
- low quality 1
- mellow kick 1
- passionate electric guitar melody 1
- passionate male vocal 1
- punchy snare 1
- shimmering cymbals 1
- solo brass melody 1
- strummed acoustic rhythm guitar chords progression 1
musiccaps_names (array) 7 ✖
- Music 2
- Rock and roll 1
- Rock music 1
- Singing 1
- Song 1
- Soul music 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Grateful Dead - Ship of Fools | The Rock song features a groovy piano melody followed by passionate electric guitar melody, church organ chord progression, strummed acoustic rhythm guitar chords, shimmering cymbals, punchy snare and mellow kick hits. It sounds emotional, soulful and passionate. | 2011-05-30T15:59:43Z | Istofn | ["Music", "Soul music"] | ["rock", "groovy piano melody", "passionate electric guitar melody", "church organ chords progression", "strummed acoustic rhythm guitar chords progression", "shimmering cymbals", "punchy snare", "mellow kick", "emotional", "soulful", "passionate"] | 4 | 6iZ49s7eH5g | 777 | ||
Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 | The low quality recording features a live performance of a rock song and it consists of passionate male vocal singing over energetic drums, funky bass guitar, electric guitar melody and solo brass melody. At the end of the loop, there is a short snippet of choir singing in harmony. Overall it sounds funky, energetic, soulful and passionate - as a live performance should sound. | 2010-12-07T18:15:11Z | Rock & Roll Hall of Fame | Solomon Burke performs Rock and Roll Hall of Fame Inductions 2001 Visit us! http://rockhall.com/ Subscribe to RockHall : http://www.youtube.com/subscription_center?add_user=rockhall Facebook: http://www.facebook.com/rockandrollhalloffame Twitter: http://twitter.com/rock_hall Google +: http://plus.google.com/u/0/115412030406922618012 Check out all the inductees: http://rockhall.com/inductees/ Upcoming events: http://rockhall.com/events/ | ["Singing", "Music", "Rock music", "Song", "Rock and roll", "Yell"] | ["rock", "low quality", "live performance", "passionate male vocal", "choir", "solo brass melody", "funky bass guitar", "energetic drums", "electric guitar melody", "energetic", "soulful", "passionate", "funky"] | 4 | VfARCp38XtA | 3018 |
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;