musiccaps_details (view)
2 rows where musiccaps_aspects contains "happy", musiccaps_aspects contains "nostalgic" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- euphoric 2
- happy · 2 ✖
- nostalgic · 2 ✖
- pop · 2 ✖
- christmas song 1
- energetic crash cymbals 1
- groovy bass guitar 1
- groovy piano melody 1
- harmonized vocals 1
- live performance 1
- passionate female vocal 1
- punchy snare 1
- short drum break 1
- smooth bass 1
- snappy rimshots 1
- snaps 1
- soft kick hits 1
- sustained strings melody 1
- wide electric guitars melody 1
- wide shimmering shakers 1
musiccaps_names (array) 4 ✖
- Music 2
- Independent music 1
- Music of Asia 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
3 ohin jingle bell | The recording features a live performance of a pop song that consists of passionate female vocal singing over groovy piano melody, sustained strings melody, smooth bass, widely spread shimmering shaker, snaps and snappy rimshots. It sounds euphoric, as it brings a Christmassy vibe, and is also happy and nostalgic. | 2012-12-19T10:33:32Z | Ganaa Jigee | ["Music of Asia", "Music", "Song"] | ["live performance", "pop", "passionate female vocal", "sustained strings melody", "groovy piano melody", "smooth bass", "wide shimmering shakers", "snaps", "snappy rimshots", "euphoric", "happy", "nostalgic"] | 4 | 20Vh6z6Ie0E | 325 | ||
TOKIO - ding-dong KARAOKE | The Pop song features harmonizing vocals singing over energetic crash cymbals, groovy bass guitar, wide electric guitar melody, punchy snare and soft kick hits. There is a short drum break at the very beginning of the loop. It sounds happy, nostalgic and euphoric, as it gives off vibes of a Christmas song. | 2015-12-24T09:53:22Z | Sandra B | Merry Christmas! My Christmas gift to the TOKIO-fan community is here. Thank you so much for being so welcoming even if I'm a bit late to the party. I am so glad I was able to finish this on time and I hope you like it. For those who don't know this was the first pv Mabo directed (and I really wish he still was because they are absolutely adorable). Music by: TOKIO Song: ding-dong Edited by: Sandra Bergholm Lyrics credit: JpopAsia (http://www.jpopasia.com/lyrics/15166/tokio/ding-dong.html) Program: Vegas Pro 12.0 Please note that I make no claim to the music or video footage. I only claim to be responsible for the editing and I do not or will ever make money off this video. | ["Music", "Independent music"] | ["harmonized vocals", "pop", "energetic crash cymbals", "short drum break", "groovy bass guitar", "wide electric guitars melody", "punchy snare", "soft kick hits", "happy", "nostalgic", "euphoric", "christmas song"] | 4 | _3OlK_1yQOk | 3440 |
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;