musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "male voice" and musiccaps_aspects contains "romantic song" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- male voice · 2 ✖
- romantic song · 2 ✖
- slow tempo 2
- ballad 1
- guitar 1
- hand claps 1
- low quality audio 1
- minimal instruments 1
- no percussion 1
- percussion 1
- plucked guitar 1
- pop song 1
- slow song 1
- tambourine 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 |
---|---|---|---|---|---|---|---|---|---|---|
I'd Rather Be Green Than Be Blue MTV | This pop song features a male voice singing the main melody in a foreign language. The melody is repetitive. This is accompanied by percussion playing a simple beat. The bass plays the root notes of the chords. A guitar plays arpeggiated chords using a chorus effect. The mood of this song is romantic. This song can be played in a romantic movie. | 2006-07-02T12:08:31Z | OOLTLS | WARNING: VIEWER'S DISCRETION IS REQUIRED. If you are NOT a LASALLISTA and/or do NOT have a sense of humor, this video is NOT for you. Please do NOT watch this. Those who, in spite of being forewarned about the content (hey, isn't it obvious from the title?), still insist on watching this video, then are offended, have no one to blame but themselves. The song "I'd Rather Be Green Than Be Blue" was composed by Juan Miguel Salvador and first performed live in 2000 at the (then) Ultra (now Philippine Sports Multi-Purpose Arena); and re-recorded in 2005. This MTV, based on the said existing music, was created by students from De La Salle-College of Saint Benilde. The animation was done using Adobe (After Effects, Premiere and Photoshop). The live sequences were shot in La Salle Green Hills. To download this video for your iPod, go to http://video.google.com/videoplay?docid=3016451200235587541& hl=en |'[) |247#3|2 83 G|233|\| 7#4|\| 83 8|_(_)3!!! | ["Music", "Happy music"] | ["romantic song", "pop song", "male voice", "low quality audio", "percussion", "hand claps", "tambourine", "guitar", "slow tempo"] | 0 | 2ctgUIqyaBk | 389 | |
BEST LOVE SONG - "LOVE" original Austin Nix | This song is a ballad which features a male voice singing the main melody. This is accompanied by a plucked guitar playing arpeggiated chords. There are no other instruments. There is no percussion. The mood of this song is romantic. This song can be played in a romantic movie. | 2011-02-12T12:28:39Z | Ken Nix | Other Austin Nix Songs: https://www.youtube.com/watch?v=bgbALOjce3c - Twenty-One https://www.youtube.com/watch?v=KNb3A5xvDZM - Funny Valentine Song Austin Nix New YouTube Channel https://www.youtube.com/channel/UCVZwveAVgdWUOY13YNTdeXQ *****LYRICS***** Love can blind us or leave us deaf rip a beating heart from our chest find us gasping for air for the one who took our breath. love can tie us in a knot say silly words when were taking a shot in the dark to see if she likes us or not. and love is the only thing that seems real other than pain its all i feel The constant stream that melts my mind surreal love, its coarsing through my veins when i see you im finally sane unique and never the same waiting for the change. of love, its coarsing through my brain more addictive than cocaine even harder to explain even harder to obtain. love, takes us for a ride keeps us afraid to close our eyes we can't even chance blinking or she'll disapear by surprise. love, can make the ground tremble beneath our toes sneak around right under our nose keep us moving 'til theres no where left to go. love, can be the greatest feeling on this earth for me she came first no im not cursed, I'm only waiting for her heart to disperse. love, its coarsing through my veins when i see you im finally sane unique and never the same waiting for the change. of love, its coarsing through my brain more addictive than cocaine even harder to explain even harder to obtain. 2018 "best valentine song" | ["Music", "Tender music"] | ["ballad", "plucked guitar", "slow song", "romantic song", "male voice", "slow tempo", "minimal instruments", "no percussion"] | 0 | 8BJljuSm2Aw | 900 |
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;