musiccaps_details (view)
2 rows where musiccaps_aspects contains "easygoing" and musiccaps_aspects contains "tinny percussive elements"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- easygoing · 2 ✖
- tinny percussive elements · 2 ✖
- calm 1
- chill 1
- emotional 1
- groovy bass 1
- groovy bass guitar 1
- low quality 1
- muffled snare 1
- noisy 1
- offbeat piano chords 1
- passionate female vocal 1
- pop 1
- reggae 1
- shimmering hi hats 1
- shimmering shakers 1
- sustained synth strings chords 1
- synth keys melody 1
- uplifting 1
- wide harmonizing low male vocals 1
musiccaps_names (array) 4 ✖
- Music 2
- Echo 1
- Reggae 1
- Tender music 1
youtube_published (date) 2 ✖
- 2008-08-31 1
- 2009-06-18 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
You've Made Me Stronger - Regine Velasquez | The Pop song features a passionate female vocal singing over synth keys melody, sustained synth strings chords, groovy bass guitar, shimmering shakers and tinny percussive elements. The second section has only vocals, synth keys, shimmering shakers and some tinny percussion, as it is a way calmer section. It sounds uplifting, emotional and easygoing. | 2008-08-31T06:51:06Z | Beauty et Madness | No copyright infringement intended for the damn who broke not just his promises but also my heart, here's for you.. thanks for all the pain and the tears.. if not because of those, I won't realize something.. YOU'VE MADE ME STRONGER.. Follow me on twitter: https://twitter.com/#!/LHollyCynthL Visit me at http://lamadrid006.webs.com | ["Music", "Tender music"] | ["shimmering shakers", "tinny percussive elements", "passionate female vocal", "groovy bass guitar", "synth keys melody", "sustained synth strings chords", "pop", "uplifting", "easygoing", "emotional", "calm"] | 4 | eSesh6vnek8 | 3863 | |
Echo Sound System - Echo Sound (None A Jah Jah Children Riddim) | The low quality recording features a reggae song that consists of wide harmonizing low male vocals singing over groovy bass, muffled snare, shimmering hi hats, tinny percussive elements and offbeat piano chords. The recording is noisy and it sounds easygoing and chill. | 2009-06-18T03:20:15Z | Voxcesar Selektah | Album:Tempo Vai Dizer, Artist: Echo Sound System & General Smiley Year: 2005 , Label: Phantom , Tracks: 21 | ["Echo", "Music", "Reggae"] | ["reggae", "low quality", "wide harmonizing low male vocals", "offbeat piano chords", "groovy bass", "muffled snare", "tinny percussive elements", "shimmering hi hats", "noisy", "easygoing", "chill"] | 4 | yVWk3yq3Abc | 5415 |
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;