musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "synthesiser articulation" and musiccaps_names contains "Pop music" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 34 ✖
- synthesiser articulation · 2 ✖
- alternative rock 1
- ambient 1
- classic rock 1
- club music 1
- contemporary pop 1
- dance music 1
- dance pop 1
- digital drumming 1
- electric guitar riff 1
- electro pop 1
- electronic music 1
- emotional 1
- engaging 1
- fast tempo 1
- female singer 1
- female vocalist 1
- groovy bass lines 1
- groovy rhythm 1
- keyboard arrangement 1
- medium fast tempo 1
- powerful 1
- progressive rock 1
- rock 1
- slick drumming 1
- soft rock 1
- symphonic rock 1
- synth pop 1
- upbeat 1
- vibrant 1
- vibrant electric guitars 1
- vivacious 1
- vocal backup 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 2
- Pop music · 2 ✖
- Singing 2
- /m/05zppz 1
- /t/dd00003 1
- Heavy metal 1
- Independent music 1
- Progressive rock 1
- Rock music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gimme More (Britney Spears) - Cover/Male Singing. | A female singer sings soft pop songs. The tempo is medium fast with electronically arranged music, electric guitar harmony, digital drum beats, and melodious vocal backup. The song is simple, soft, emotional, upbeat, catchy, with a dance groove. This song is an Electro Pop song. | 2013-03-03T05:27:25Z | TheMaleBritney | Please Like, Subscribe, Share and Comment :D I Don't Own "Gimme More" Britney Does. Heres the link to buy the original Gimme More: https://itunes.apple.com/au/album/gimme-more-single/id264025647 | ["Singing", "Music", "/m/05zppz", "Pop music", "/t/dd00003"] | ["female singer", "medium fast tempo", "emotional", "contemporary pop", "upbeat", "groovy rhythm", "dance music", "dance pop", "club music", "electro pop", "synth pop", "ambient", "electronic music", "synthesiser articulation", "digital drumming", "keyboard arrangement", "electric guitar riff", "vocal backup"] | 7 | MY0PsDE3xHs | 2279 | |
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;