musiccaps_details (view)
2 rows where musiccaps_aspects contains "alternative/indie" and musiccaps_names contains "Soul music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- alternative/indie · 2 ✖
- energetic 2
- groovy bass 2
- catchy beat 1
- compelling 1
- electric guitar licks 1
- energetic crash cymbal 1
- enthusiastic 1
- enthusiastic keyboard harmony 1
- fast tempo 1
- groovy basslines 1
- halloween 1
- haunting 1
- indie pop 1
- infectious drumming 1
- male voclaist 1
- new music 1
- punchy kick 1
- synth keys chords 1
- synthesiser arrangement 1
- tambourine beats 1
musiccaps_names (array) 4 ✖
- Music 2
- Soul music · 2 ✖
- Rhythm and blues 1
- Ska 1
youtube_published (date) 2 ✖
- 2010-09-24 1
- 2013-07-19 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
José Cid- Mellotron - O Planeta Fantástico | The Alternative/Indie song features layered punchy kicks, energetic crash cymbals, groovy bass and synth key chords, followed by electric guitar licks. It sounds haunting and energetic, almost like a halloween themed song. | 2010-09-24T02:02:36Z | jerudoriginal91 | ["Music", "Rhythm and blues", "Ska", "Soul music"] | ["alternative/indie", "punchy kick", "groovy bass", "synth keys chords", "electric guitar licks", "energetic crash cymbal", "energetic", "haunting", "halloween"] | 4 | 1Xtkou9dtyA | 285 | ||
Wild Cub - Thunder Clatter lyrics on screen | A male vocalist sings this upbeat pop. The tempo is fast with synthesiser arrangements, hard hitting drums, groovy bass, tambourine beats ,keyboard harmony and choral harmony. The song is an upbeat, catchy , compelling, persuasive, enthusiastic and youthful Indie Pop. | 2013-07-19T08:34:53Z | Brown Leather Wallet | Song from the Bose advert. Enjoy. Dont own the rights to the music. | ["Music", "Soul music"] | ["male voclaist", "fast tempo", "groovy bass", "indie pop", "enthusiastic keyboard harmony", "tambourine beats", "synthesiser arrangement", "infectious drumming", "groovy basslines", "alternative/indie", "new music", "compelling", "enthusiastic", "energetic", "catchy beat"] | 7 | 4jzr88nEdCM | 598 |
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;