musiccaps_details (view)
5 rows where musiccaps_aspects contains "bass guitar", musiccaps_aspects contains "uplifting", musiccaps_author = 9 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dizzy Sunfist "SULLEY" Official Music Video | This is a Japanese pop-punk music piece. There is a teen female vocalist singing merrily and melodically in the English language. There is a distorted electric guitar playing the main tune with a bass guitar. The rhythmic background consists of a fast-paced punk beat being played on the acoustic drums. The atmosphere is uplifting. This piece could be used in the soundtrack of a teenage/young adult feelgood movie/TV show. It could also take place in the soundtrack of an animation movie or an anime. | 2014-06-25T07:52:11Z | CAFFEINE BOMB OFFICIAL | Dizzy Sunfist 2nd Mini Album"SUPER DELICIOUS"より2本目MV!! Official Web Site http://dizzy-sunfist.com/ facebook https://www.facebook.com/dizzysunfist2006/ Twitter https://twitter.com/_Dizzy_Sunfist_ Instagram https://www.instagram.com/dizzysunfist_official | ["Jazz", "Music"] | ["japanese pop-punk", "teenage female vocal", "melodic singing", "distorted electric guitar", "bass guitar", "fast-paced acoustic drums", "happy", "playful", "uplifting", "high tempo"] | 9 | BEEknOFrVdU | 1219 | |
Christian Music Mix #2, 19 songs!! | This is a poor quality Christian pop music compilation. There are many pieces sung by male and female voices melodically. The usual theme of the instrumental backing consists of a tune played in major key by an electric guitar and a bass guitar alongside a simple acoustic drum beat. The overall atmosphere is uplifting. This mix could be used in a movie to imply the sounds coming from a gospel radio station in passing. | 2009-04-13T01:50:06Z | AudioMan62 | This is The second installment of my christian music mix. be sure to listen my first one! enjoy! Made about 2002. | ["Christian music", "Guitar", "Music", "Musical instrument", "Pop music", "Song"] | ["compilation", "poor quality", "christian pop", "male vocal", "female vocal", "melodic singing", "electric guitar", "bass guitar", "acoustic drums", "major key", "positive", "uplifting", "religious"] | 9 | RPqz3vJYMLQ | 2697 | |
Jingle Ademir Lucas +45 | This is a Brazilian samba piece used as a jingle. The male vocals are singing in a shouting-like manner, repeating a slogan. There is a heavy use of syncopated latin percussion in the rhythmic background. The acoustic guitar and the bass guitar in the background support the melodic structure of the vocals. | 2012-07-22T02:21:22Z | AdemirMais45 | ["Music", "Middle Eastern music", "Salsa music"] | ["samba", "male vocals", "jingle", "percussion", "acoustic guitar", "bass guitar", "brazilian", "energetic", "uplifting"] | 9 | mqyeBqaUeN8 | 4496 | ||
Famous Ramos: Audition for Pharrell Music Video - ("Happy" - Pharrell) | This is a famous pop music piece played over a dance audition video. The male vocalist is singing melodically in one track at a medium pitch and singing the melody at a high pitch in another track. The melody is supported by a bass guitar playing a groovy bassline. A catchy acoustic drum beat and offbeat claps hold the rhythmic background. The atmosphere is jovial and very danceable. This piece could be used in a myriad of different ways from dance videos, online content, sports venues etc. | 2013-09-13T23:39:49Z | Famous Ramos | A teaser to our upcoming video to "Lose Yourself to Dance!" COMING SOON! This was my audition for the casting of Pharrell's video. I booked the job! http://youtu.be/rQD9EBCwlQc?t=56m3s :) It's all improve and a one take performance. Hope you enjoy as much as I did dancing! /Famous | ["Afrobeat", "Music of Africa", "Music", "Pop music"] | ["pop music", "male vocal", "bass guitar", "keyboard", "acoustic drums", "claps", "melodic", "happy", "jovial", "uplifting", "easygoing", "dance"] | 9 | pZgzjL5wbtA | 4721 | |
Doraemon Opening Theme Song (Japanese Version) | This is the theme of a cartoon. There is a female vocalist singing merrily at a medium-to-high pitch in the Japanese language. The melody is being played on the strings and the piano while a simple on-beat bass line can be heard being played in the background. There is a simple 4/4 acoustic drum beat for the rhythm. The piece has an uplifting atmosphere. This piece could be used in the soundtrack of a children's movie. It could also be used in anime soundtracks. | 2012-04-28T03:24:44Z | Jennifer Nguyen | Doraemon Opening Theme Song (Japanese Version) | ["Music", "Happy music"] | ["cartoon theme", "female vocal", "merrily singing", "strings", "piano", "bass guitar", "acoustic drums", "playful", "uplifting", "positive", "childlike", "japanese"] | 9 | wBozBh7BR6k | 5247 |
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;