musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic rhythm guitar", musiccaps_aspects contains "groovy bass" and musiccaps_names contains "Happy music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- acoustic rhythm guitar · 2 ✖
- groovy bass · 2 ✖
- fun 1
- groovy piano chords 1
- happy 1
- harmonizing male vocals 1
- hopeful 1
- low quality 1
- passionate 1
- plucked string melody 1
- repetitive flat male vocal 1
- shimmering cymbals 1
- snappy rimshots 1
- soft kick hits 1
- soft rock 1
- sustained organ keys chords 1
- wooden percussions 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Maroon 5 - I Shall Be Released | The Soft Rock song features harmonizing male vocals singing over sustained organ keys chords, shimmering cymbals, groovy piano chords in the left channel, acoustic rhythm guitar in the right channel of the stereo image and groovy bass guitar. It sounds passionate and hopeful, like something you would sing along at concerts. | 2011-12-10T21:15:00Z | missevellyn24 | This is the song that Maroon 5 have recorded for the Album "Chimes of Freedom: The Songs of Bob Dylan Honoring 50 Years of Amnesty International"... Just AMAZING!!!!!! They say everything can be replaced Yet every distance is not near So I remember every face Of every man who put me here I see my light come shining From the west unto the east Any day now, any day now I shall be releassee They say every man needs protection They say every man must fall Yet I swear I see my reflection Some place so high above this wall I see my light come shining From the west unto the east Any day now, any day now I shall be released Standing next to me in this lonely crowd Is a man who swears he's not to blame All day long I hear him shout so loud Crying out that he was framed I see my light come shining From the west unto the east Any day now, any day now I shall be released | ["Singing", "Music", "Happy music"] | ["soft rock", "harmonizing male vocals", "sustained organ keys chords", "shimmering cymbals", "groovy piano chords", "acoustic rhythm guitar", "groovy bass", "passionate", "hopeful"] | 4 | AKI0VrXEDww | 1106 | |
Les noix de coco - chanson pour jeunes enfants | The low quality recording features a song that consists of a repetitive flat male vocal singing over plucked string melody, groovy bass, wooden percussion, snappy rimshots and soft kick hits. It sounds fun and happy - like something kids would listen to. | 2010-11-06T11:56:16Z | Bernard Prima | Rejoignez nous sur notre page facebook: https://www.facebook.com/chansonspourjeunesenfants | ["Music", "Happy music"] | ["low quality", "plucked string melody", "groovy bass", "repetitive flat male vocal", "wooden percussions", "snappy rimshots", "soft kick hits", "acoustic rhythm guitar", "fun", "happy"] | 4 | t5P_HJrrD64 | 5002 |
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;