musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "easygoing" and musiccaps_aspects contains "shimmering shakers" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- easygoing · 3 ✖
- shimmering shakers · 3 ✖
- electric guitar melody 2
- low quality 2
- pop 2
- soft male vocal 2
- calm 1
- claps 1
- cool 1
- emotional 1
- groovy 1
- groovy bass 1
- groovy bass guitar 1
- mono 1
- noisy 1
- passionate female vocal 1
- piano melody 1
- punchy kick 1
- rock 1
- smooth bass 1
- snappy rimshots 1
- soft crash cymbals 1
- sustained synth strings chords 1
- synth keys melody 1
- tinny percussive elements 1
- uplifting 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ethiopia - Sisay Lukas (Mamila) - Eskemeche - (Offical Music Video) - New Ethiopian Music 2015 | The low quality recording features a pop song that contains a soft male vocal singing over soft crash cymbals, claps, punchy kick, shimmering shakers, groovy bass, piano melody and electric guitar melody. It sounds easygoing. | 2015-01-02T18:45:00Z | Ethio One Love | Subscribe now: Sisay Lukas (Mamila) - Eskemeche - (Offical Music Video) - New ETHIOPIAN MUSIC - Ethiopian. © Copyright: Ethio One Love Any unauthorized use, copying or distribution is strictly prohibited. Like us on Facebook:https://www.facebook.com/Ethio1love | ["Music", "Happy music"] | ["low quality", "pop", "electric guitar melody", "punchy kick", "shimmering shakers", "groovy bass", "claps", "soft crash cymbals", "soft male vocal", "piano melody", "easygoing"] | 4 | 1Rd1w7Ty1ak | 273 | |
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 | |
Nothing In This World - The Kinks | The low quality recording features a rock song that consists of an electric guitar melody, smooth bass, shimmering shakers, snappy rimshots and soft male vocals singing over it. The recording is really noisy and in mono. It sounds cool, groovy and easygoing. | 2008-10-25T20:42:37Z | weeniebobeenie | Nothin in this world can stop me worryin bout that girl | ["Bass guitar", "Guitar", "Music", "Plucked string instrument"] | ["rock", "low quality", "electric guitar melody", "smooth bass", "shimmering shakers", "snappy rimshots", "soft male vocal", "noisy", "mono", "cool", "easygoing", "groovy"] | 4 | hOSzGYKaJGE | 4100 |
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;