musiccaps_details (view)
2 rows where musiccaps_aspects contains "slick drumming", musiccaps_aspects contains "youthful" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- slick drumming · 2 ✖
- youthful · 2 ✖
- acoustic guitar accompaniment 1
- alternative rock 1
- bouncy 1
- classic rock 1
- club music 1
- crowd cheering 1
- crowd hooting 1
- energetic 1
- engaging 1
- enthusiastic 1
- fast tempo 1
- female singer 1
- female vocalist 1
- fresh 1
- fresh punchy 1
- funky 1
- funky bass line 1
- gig 1
- groovy bass lines 1
- keyboard harmony 1
- live performance 1
- lucid vocals 1
- medium tempo 1
- perky vocals 1
- pop 1
- powerful 1
- progressive rock 1
- punchy 1
- rock 1
- soft rock 1
- sound of chatter 1
- spirited 1
- symphonic rock 1
- synthesiser articulation 1
- upbeat groove 1
- vibrant 1
- vibrant electric guitars 1
- vivacious 1
musiccaps_names (array) 10 ✖
- Music 2
- Singing · 2 ✖
- Heavy metal 1
- Independent music 1
- Pop music 1
- Progressive rock 1
- Rock music 1
- Song 1
- Soul music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sallie Ford and the Sound Outside at The Crystal Ballroom 5-23-09 | A female vocalist sings this perky pop. The tempo is medium with rhythmic acoustic guitar , groovy bass lines, keyboard accompaniment and enthusiastic drumming. The song is simple, dulcet, fresh, peppy, youthful, vibrant and punchy with sounds of crowd hooting and cheering and talking. This song is a Pop song. | 2009-05-27T05:02:05Z | ConcordKurve | Great video of Sallie Ford and the Sound Outside singing "Not an animal" at the Crystal Ballroom. They opened for the Avett Brothers on May 22 and 23, 2009. | ["Singing", "Music", "Soul music", "Vocal music"] | ["female singer", "medium tempo", "club music", "keyboard harmony", "lucid vocals", "enthusiastic", "live performance", "energetic", "slick drumming", "spirited", "crowd cheering", "sound of chatter", "gig", "upbeat groove", "punchy", "fresh", "crowd hooting", "perky vocals", "acoustic guitar accompaniment", "funky bass line", "slick drumming", "keyboard harmony", "funky", "youthful", "fresh punchy", "bouncy", "pop"] | 7 | I-Z3gB6pfIA | 1859 | |
Magenta - King Of The Skies | A female vocalist sings this spirited song. The tempo is fast with enthusiastic electric guitar harmony, slick drumming, groovy bass lines and synthesiser arrangements. The song is energetic, youthful, fun, pulsating, engaging and emphatic. This song is Alternative Rock. | 2006-06-21T17:59:15Z | chrismagenta | Track from Magenta's The Gathering DVD. Amazing Welsh Progressive Rock band in the vain of Genesis, Yes and Renaissance. | ["Singing", "Heavy metal", "Music", "Independent music", "Pop music", "Rock music", "Song", "Progressive rock"] | ["female vocalist", "fast tempo", "vibrant electric guitars", "progressive rock", "symphonic rock", "alternative rock", "slick drumming", "synthesiser articulation", "vivacious", "youthful", "vibrant", "groovy bass lines", "engaging", "powerful", "rock", "classic rock", "soft rock"] | 7 | pp6eSGANq0Y | 4737 |
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;