musiccaps_details (view)
3 rows where musiccaps_aspects contains "modern pop" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 49 ✖
- modern pop · 3 ✖
- emotional 2
- love song 2
- poor audio quality 2
- steady drumming rhythm 2
- acoustic pop hits 1
- amateur playing 1
- amateur rock band 1
- ambient music 1
- backup singers 1
- casual rock 1
- chill-out music 1
- classic pop hits 1
- classic rock influences 1
- deteriorated audio quality 1
- echo tones 1
- energetic 1
- female singer 1
- filler music 1
- friendship 1
- groovy bass line 1
- guitar lead 1
- hall reverb 1
- hissing tones 1
- home recording 1
- inspiring 1
- key changes 1
- keyboard harmony 1
- live audience 1
- live concert 1
- male singer 1
- medium tempo 1
- motivational 1
- movie soundtrack 1
- out of time 1
- passionate 1
- percussive bass line 1
- piano accompaniment 1
- pop diva 1
- pop hit 1
- pop songs 1
- pop super hits 1
- relaxing 1
- retro pop melody 1
- slow tempo 1
- soulful singing 1
- story telling 1
- subtle bass line 1
- vocal harmony 1
musiccaps_names (array) 10 ✖
- Music 3
- Christian music 1
- Distortion 1
- Electric guitar 1
- Happy music 1
- New-age music 1
- Rock music 1
- Singing 1
- Song 1
- Steel guitar, slide guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Relaxation Music Progressive Rock | The song is an instrumental music piece. The song is slow tempo with an electric guitar playing lead with heavy echoes, steady drumming and a keyboard harmony. The song is casual and slightly out of rhythm. The song is an instrumental with a casual listening vibe. | 2011-10-11T06:06:56Z | Gothenburg Music | Relaxation Music Progressive Rock, Rock jam and improvisation | ["Electric guitar", "New-age music", "Music", "Rock music", "Steel guitar, slide guitar", "Distortion"] | ["slow tempo", "guitar lead", "steady drumming rhythm", "filler music", "relaxing", "home recording", "chill-out music", "modern pop", "classic rock influences", "amateur rock band", "ambient music", "groovy bass line", "echo tones", "relaxing", "out of time", "amateur playing", "keyboard harmony", "casual rock"] | 1 | UrgzGbGVV8I | 2948 | |
Without Love (Harry/Ginny and Ron/Hermione) | A male singer sings this pop melody with backup singers with vocal harmony. The song is medium, with a keyboard accompaniment , steady drumming rhythm and strong bass line. The song is passionate and cheerful. The audio quality is poor. | 2007-12-24T21:37:03Z | iamobsessedandproud | okay, i know everyone and their sister has made this vid, but i just obtained some good clips and i really wanted to try them out. Plus i needed to make a fun vid to make up for the past few really serious ones. Enjoy, and Merry Christmas! Song: "Without Love" From: "Hairspray" Movie Soundtrack | ["Music", "Happy music"] | ["male singer", "medium tempo", "retro pop melody", "key changes", "percussive bass line", "passionate", "energetic", "modern pop", "steady drumming rhythm", "poor audio quality", "backup singers", "backup singers", "vocal harmony", "pop songs", "movie soundtrack", "friendship", "emotional", "passionate", "love song"] | 1 | kjmmzA6i5rk | 4350 | |
Adele crying at Royal Albert Hall - Someone like you live HD | A female pop star sings this lilting melody. The song is medium tempo with a piano playing accompaniment with a subtle bass line. The song is emotional and inspiring. The song is a modern pop hit played to a live audience. The song audio quality is poor and deteriorated. | 2012-09-29T19:17:31Z | Nil Iys | XL Records C. http://tinyurl.com/97zvsko Adele crying at Royal Albert Hall after singing someone like you! :) | ["Singing", "Christian music", "Music", "Song"] | ["female singer", "poor audio quality", "pop hit", "live concert", "emotional", "love song", "classic pop hits", "story telling", "live audience", "pop diva", "soulful singing", "piano accompaniment", "deteriorated audio quality", "hissing tones", "acoustic pop hits", "inspiring", "emotional", "love song", "motivational", "subtle bass line", "pop super hits", "modern pop", "hall reverb"] | 1 | nSinUcyFFqg | 4539 |
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;