musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_names contains "Independent music" and musiccaps_names contains "Pop music"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- energetic · 3 ✖
- enthusiastic 2
- melodious 2
- youthful 2
- acoustic drums 1
- alternative 1
- amplified instruments 1
- bass guitar 1
- boy band 1
- bustling 1
- busy 1
- concert 1
- crowd cheering 1
- crowd screaming 1
- droning melody 1
- electric guitar 1
- electronic music 1
- electronica 1
- engaging 1
- fans 1
- fans going berserk 1
- fans going crazy 1
- fast tempo 1
- female singer 1
- female vocal 1
- foreign language 1
- funky bass lines 1
- groovy bass line 1
- hit song 1
- indie 1
- …
musiccaps_names (array) 10 ✖
- Independent music · 3 ✖
- Music 3
- Pop music · 3 ✖
- Folk music 1
- Funk 1
- Heavy metal 1
- Music of Asia 1
- Progressive rock 1
- Rapping 1
- Tick-tock 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
7 o'clock Teaser นี่เธอไม่รู้หรือแกล้งไม่รู้ | This is a rock music piece. It starts with a clock. There is a female vocalist singing melodically in the Thai language. The overdriven electric guitar is strumming the chords of the main tune while the bass guitar is supporting it in the background. The acoustic drum is playing a simple but powerful beat. The general atmosphere is energetic. The piece can be used as a soundtrack in a coming-of-age drama taking place in Thailand. | 2009-09-03T06:40:52Z | Chanin Yanyong | The complete teaser of 7 o'clock นี่เธอไม่รู้หรือแกล้งไม่รู้ | ["Heavy metal", "Music", "Independent music", "Pop music", "Tick-tock", "Progressive rock"] | ["rock music", "thai", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "normal tempo", "sound effects", "energetic"] | 9 | B1beLwV4yzw | 1193 | |
Indie/Pop/Folk Compilation - Christmas Playlist | A female singer sings this spirited song. The tempo is fast with a lively piano accompaniment, punchy drumming, funky bass line, rhythmic acoustic guitar, and a droning synthesiser harmony. The music is loud, busy, chaotic and bustling and the vocals are subdued. This clip sounds like the song climax as the instrumentation is strong and powerful. The song is spirited, melodic,energetic, enthusiastic, youthful and engaging. This song is an Indie Pop song. | 2014-11-24T09:53:53Z | alexrainbirdMusic | Listen to a collection of indie songs perfect for the festive season! Tracklist below... Subscribe to be the first to hear the finest independent music! http://bit.ly/145fFnx Please contact alexrainbirdmusic@gmail.com if you’d like your band to be featured on my channel. Tracklist: 0:00 LAYLA -- 'Winter, You Tease' https://www.facebook.com/listentolayla 3:39 Sugarcult -- 'Freezing' https://www.facebook.com/pages/Sugarcult/122472207779743 5:29 Sleeping At Last -- 'Silver Bells’ https://www.facebook.com/sleepingatlast 8:29 Brighten -- ‘Merry Christmas Baby’ https://www.facebook.com/pages/Brighten/108211255873665 11:39 Golden Youth -- ‘Have Yourself A Merry Little Christmas’ https://www.facebook.com/ourgoldenyouth Find alexrainbirdMusic on: Facebook: https://www.facebook.com/alexrainbirdMusic Twitter: https://twitter.com/alxrnbdMusic Spotify: https://play.spotify.com/user/alxrnbrdmusic Soundcloud: https://soundcloud.com/alexrainbirdmusic Instagram: https://instagram.com/alexrainbirdmusic/ Grab an official t-shirt: UK Store: http://shop.spreadshirt.co.uk/alexrainbirdmusic US Store: http://shop.spreadshirt.com/alexrainbirdmusic About alexrainbirdMusic: Since 2011, Alex Rainbird has been hunting down and showcasing the very best in independent music. Featuring over 45 new artists a month, Alex hopes to provide a platform for underrated musicians to be heard and for viewers to find their new favourite band. Join Alex's +44,000 subscribers today to be the first to hear the finest independent music. | ["Folk music", "Music", "Independent music", "Pop music"] | ["female singer", "fast tempo", "electronic music", "melodious", "youthful", "energetic", "enthusiastic", "song climax", "busy", "bustling", "melodipiano accompaniment", "punchy drumming", "synthesiser arrangements", "funky bass lines", "rhythmic acoustic guitar", "psychedelic background", "droning melody", "synth pop", "electronica", "amplified instruments", "pleasant vocals", "indie", "pop", "alternative"] | 7 | FGZ0sLt4dXA | 1631 | |
BTOB - Beep Beep (Feb 20, 2014) | A male vocalist sings this melodious pop song. The tempo is medium with piano accompaniment, rhythmic acoustic guitar, groovy bass line ,steady drumming and energetic vocal backup. The song is spirited, youthful, vivacious, popular, bright and engaging. The song is a live performance and there are sounds of people cheering, hooting hysterically and singing along. This song is a hit in K-Pop. | 2014-02-21T07:07:36Z | Minhyuk ครับผม | 140220 BTOB - Beep Beep @ M Countdown Comeback Stage | ["Music of Asia", "Funk", "Music", "Independent music", "Pop music", "Rapping"] | ["male singer", "foreign language", "medium tempo", "youthful", "engaging", "energetic", "enthusiastic", "vibrant vivacious", "concert", "teen pop", "k-pop", "live performance", "concert", "live audience", "enthusiastic", "crowd cheering", "crowd screaming", "fans", "fans going crazy", "fans going berserk", "popularity", "hit song", "boy band", "melodious", "steady drumming", "lively piano", "groovy bass line"] | 7 | cADT8fUucLQ | 3686 |
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;