musiccaps_details (view)
3 rows where musiccaps_aspects contains "home music video" and musiccaps_aspects contains "melancholic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- home music video · 3 ✖
- instrumental music 3
- melancholic · 3 ✖
- slow tempo 2
- accordion harmony 1
- accordion trio 1
- acoustic guitar session 1
- amateur player 1
- average audio quality 1
- average sound quality 1
- casual 1
- changing tones 1
- cheerful 1
- classic guitars music 1
- delay effects 1
- dissonant tones 1
- distortion tones 1
- echoes 1
- effects pedal 1
- emotional 1
- energetic 1
- friends get together 1
- groovy 1
- guitar echo pedal 1
- guitar effects module demonstration 1
- guitar harmony 1
- gypsy music 1
- high gain 1
- high gain tones 1
- home music jam 1
- homemjsic video 1
- house party 1
- life is beautiful 1
- lilting melody 1
- medium tempo 1
- moody 1
- noisy 1
- nostalgia 1
- out of tune 1
- overuse of effect 1
- parisian streets 1
- peaceful relaxing 1
- pensive 1
- poignant 1
- poor audio quality 1
- relaxing 1
- slow paced 1
- soloist 1
- soothing 1
- splits 1
- subtle bass line 1
- virtuosos playing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Malekko LoFi Ekko 616 Pt.2 | The song is an instrumental. The tempo is medium with a guitar playing lead and rhythm with differences ranging from echo tones to distorted high gains. The song is a guitar reverb pedal test or demonstration. The audio quality is poor with high gains. | 2011-08-16T20:08:31Z | ProGuitarShopDemos | Buy Now: https://goo.gl/Jdhg4j Welcome back to ProGuitarShop, where we're taking another look at the Malekko LoFi Ekko 616 analog delay. This pedal produces some seriously etheral echo tones rich with choir-like upper harmonics, and its external modulation controls can really take you into uncharted sonic territory. This time around we're pairing the Malekko LoFi Ekko 616 with some dirt and harmonizer pedals to make the most of the haunting overtones that pop out at longer delay settings. | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument"] | ["instrumental music", "high gain", "dissonant tones", "home music video", "poor audio quality", "effects pedal", "high gain tones", "changing tones", "echoes", "delay effects", "distortion tones", "guitar effects module demonstration", "homemjsic video", "guitar echo pedal", "overuse of effect", "melancholic", "poignant", "groovy", "amateur player", "soloist", "out of tune", "medium tempo", "noisy"] | 1 | KXRngbBe0bg | 2091 | |
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 | |
Berceuse - Lullaby | The song is an instrumental. The tempo is slow with a classical guitar playing harmony style with a subtle bass line and no other instrumentation. The song is emotional and relaxing. The audio quality is worth average. | 2009-01-13T21:16:18Z | bernard vdd | Compo perso pour Timeo. Play with a gibson j45. For stereo sound try this link: http://fr.youtube.com/watch?v=jS9u6X6TQmk&fmt=18 | ["Guitar", "Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["guitar harmony", "splits", "classic guitars music", "average audio quality", "melancholic", "nostalgia", "soothing", "virtuosos playing", "instrumental music", "subtle bass line", "guitar harmony", "slow tempo", "acoustic guitar session", "home music video", "emotional", "pensive", "moody", "relaxing", "emotional"] | 1 | jS9u6X6TQmk | 4255 |
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;