musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "nostalgic" and musiccaps_aspects contains "pop" sorted by youtube_published
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 25 ✖
- nostalgic · 2 ✖
- pop · 2 ✖
- christmas song 1
- emotional 1
- energetic crash cymbals 1
- euphoric 1
- groovy bass guitar 1
- happy 1
- harmonized vocals 1
- male singer 1
- medium tempo 1
- melodic 1
- pleasant 1
- pop hits 1
- punchy snare 1
- rhythmic acoustic guitar 1
- romantic 1
- sentimental 1
- short drum break 1
- soft keyboard harmony 1
- soft kick hits 1
- soft pop 1
- steady drumming 1
- subtle bass line 1
- wide electric guitars melody 1
musiccaps_names (array) 5 ✖
- Music 2
- /t/dd00004 1
- Independent music 1
- Singing 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Arnel Pineda in AMO, 1988, singing "Lights" by Journey | A male vocalist sings this soft melody. The tempo is slow with a mellow keyboard harmony, steady drumming, subtle bass line and acoustic guitar accompaniment. The song is soft, romantic, melodic, emotional , sentimental, melancholic and pleasant. This song is classic Soft Rock. | 2008-03-22T11:10:43Z | ArnelPinedaFan | Audio only. Arnel Pineda with AMO, performing live "Lights" (originally by Journey) in 1998, almost 20 years before he became Journey's lead singer. Photos from Arnel's "journey" accompany the video. NOTE: Sorry I can't approve non-English comments because I don't understand them. | ["Singing", "Music", "Soul music", "/t/dd00004"] | ["male singer", "medium tempo", "soft keyboard harmony", "steady drumming", "subtle bass line", "rhythmic acoustic guitar", "romantic", "pleasant", "soft pop", "pop", "pop hits", "romantic", "sentimental", "emotional", "nostalgic", "melodic"] | 7 | thHSYzhoLo4 | 5057 | |
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;