musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "easygoing", musiccaps_aspects contains "pop" and musiccaps_aspects contains "shimmering shakers"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 19 ✖
- easygoing · 2 ✖
- pop · 2 ✖
- shimmering shakers · 2 ✖
- calm 1
- claps 1
- electric guitar melody 1
- emotional 1
- groovy bass 1
- groovy bass guitar 1
- low quality 1
- passionate female vocal 1
- piano melody 1
- punchy kick 1
- soft crash cymbals 1
- soft male vocal 1
- sustained synth strings chords 1
- synth keys melody 1
- tinny percussive elements 1
- uplifting 1
musiccaps_names (array) 3 ✖
- Music 2
- Happy music 1
- Tender music 1
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 |
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;