musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic" and musiccaps_aspects contains "melancholic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- cheerful 2
- energetic · 2 ✖
- melancholic · 2 ✖
- accordion harmony 1
- accordion trio 1
- average sound quality 1
- casual 1
- female singer 1
- friends get together 1
- groovy bass line 1
- groovy music 1
- gypsy music 1
- hip hop dance music 1
- hip hop music 1
- home music jam 1
- home music video 1
- house party 1
- instrumental music 1
- keyboard harmony 1
- life is beautiful 1
- life is good 1
- life lessons 1
- lilting melody 1
- male backup singers 1
- medium tempo 1
- parisian streets 1
- passionate 1
- peaceful relaxing 1
- rapping vocals 1
- relaxing playlists 1
- retro dance hits 1
- romantic 1
- slow paced 1
- slow tempo 1
- spirited 1
- story telling 1
musiccaps_names (array) 3 ✖
- Accordion 1
- Music 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Vals till Marie | The song is an instrumental. The song is slow tempo with three accordions playing in harmony and in a relaxed manner. The song is beautiful and romantic. The audio quality is average and an amateur home recording. | 2013-02-09T15:57:01Z | Dragzpel | Vals till Marie, Komponerad av Kjell Nilsson i Lidhult.Här framförd av Kjell tillsammans med Siv & Ingvar Karlsson. ZOOM Handy Video Recorder | ["Accordion"] | ["accordion trio", "accordion harmony", "instrumental music", "home music video", "average sound quality", "home music jam", "friends get together", "house party", "slow tempo", "parisian streets", "gypsy music", "lilting melody", "casual", "peaceful relaxing", "energetic", "slow paced", "life is beautiful", "cheerful", "melancholic"] | 1 | NUTaOnEhvzE | 2340 | |
J. Cole - Too Deep For The Intro | Friday Night Lights | A female singer sings this cool melody with male backup singer in harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, keyboard harmony and other percussion hits. The song is groovy with a story telling nature. The song is a retro hip hop dance hit. | 2010-11-12T23:44:00Z | Archive | J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro J. Cole - Too Deep For The Intro http://coastingonadream.tumblr.com/ | ["Music", "Rhythm and blues"] | ["female singer", "male backup singers", "hip hop music", "retro dance hits", "keyboard harmony", "groovy bass line", "rapping vocals", "story telling", "romantic", "groovy music", "energetic", "spirited", "passionate", "life lessons", "melancholic", "cheerful", "life is good", "relaxing playlists", "hip hop dance music", "medium tempo"] | 1 | UfEGX0rNOvA | 2932 |
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;