musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "ambient" and musiccaps_aspects contains "pleasant"
This data as json, CSV (advanced)
musiccaps_aspects (array) 61 ✖
- ambient · 4 ✖
- instrumental 4
- pleasant · 4 ✖
- steady drumming 3
- dulcet 2
- euphonious 2
- medium tempo 2
- melodic 2
- romantic 2
- simple melody 2
- soft rock 2
- soothing 2
- acoustic guitar 1
- acoustic guitar accompaniment 1
- aesthetic 1
- atmospheric 1
- brass band 1
- cello 1
- cheerful 1
- classical 1
- cymbals 1
- electric guitar 1
- electric guitar lead 1
- emphatic lead 1
- engaging 1
- fluid 1
- funk rock 1
- funky 1
- groovy 1
- groovy bass line 1
- groovy bass lines 1
- lingering 1
- lively violin 1
- medium fast tempo 1
- melancholic 1
- mellifluent 1
- mellow 1
- melodic electric guitar lead 1
- melodious viloin 1
- mood 1
- neo soul 1
- nostalgic 1
- orchestral music 1
- pop rock 1
- retro pop 1
- rhythmic acoustic guitar 1
- rock and roll 1
- romantic piano accompaniment 1
- sedate 1
- sentimental 1
- slow tempo 1
- soft 1
- soft pop 1
- soul 1
- subtle bass lines 1
- sweet 1
- synthesiser arrangement 1
- tambourine beats 1
- trumpets 1
- violin symphony 1
- youthful 1
musiccaps_names (array) 7 ✖
- Music 3
- Wedding music 2
- Background music 1
- Blues 1
- Distortion 1
- Electric guitar 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tedeschi Trucks Band - Midnight in Harlem (Live from Atlanta) | This music is a melodic instrumental. The tempo is medium with a captivating electric guitar lead, rhythmic acoustic guitar, funky bass line, keyboard accompaniment, steady drumming and trumpets. The music is soothing, atmospheric, euphonious, youthful, and soulful. This instrumental is a Soft Rock/Funk pop. | 2011-08-18T07:00:00Z | TedeschiTrucksVEVO | Music video by Tedeschi Trucks Band performing Midnight in Harlem (Live from Atlanta). (C) 2011 Sony Music Entertainment | ["Blues"] | ["instrumental", "medium tempo", "electric guitar lead", "ambient", "steady drumming", "groovy bass line", "trumpets", "melodic", "pleasant", "funky", "groovy", "soft rock", "pop rock", "funk rock", "youthful", "atmospheric", "brass band", "soul", "neo soul", "soothing", "rhythmic acoustic guitar"] | 7 | -wVWjl9Kq6U | 104 | |
Dave and John ....pedal steel and telecaster | This music is an electronic guitar instrumental. The tempo is medium with a harmonious electric guitar lead, steady drumming, subtle bass ,tambourine beats and synthesiser arrangement. The music is a pleasant, soothing, unhurried, calm, romantic, sentimental , sedate and lingering Electric Guitar, soft pop instrumental. | 2011-02-03T01:36:36Z | Bob Adams | David Hartley and John Stannard's duet on Chasing Rainbows.. super stuff as ever! At JD's steel meeting in the south of England Jan 2011 | ["Electric guitar", "Music", "Wedding music", "Distortion"] | ["instrumental", "medium tempo", "electric guitar", "lingering", "sedate", "romantic", "sentimental", "soft pop", "soft rock", "subtle bass lines", "steady drumming", "tambourine beats", "melodic", "pleasant", "soothing", "ambient", "romantic", "synthesiser arrangement", "steady drumming", "cymbals", "simple melody", "euphonious", "engaging", "cheerful", "sentimental", "ambient"] | 7 | bt7rDryN7G4 | 3663 | |
Aston - Telephone (Violin-Piano Cover) | This music is a violin instrumental. The tempo is medium fast with the violins going from lively to soft with a romantic piano melody and acoustic guitar accompaniment. The music is orchestral with a dulcet violin symphony. It is pleasant, mellifluous, passionate, romantic; euphonious, emotional, sweet and engaging. This music is a contemporary orchestra . | 2011-01-08T08:49:04Z | Tarek Nour | Lady Gaga's Telephone Cover Enjoy !! =) | ["Background music", "Music", "Wedding music"] | ["instrumental", "medium fast tempo", "lively violin", "classical", "cello", "melodious viloin", "dulcet", "violin symphony", "pleasant", "aesthetic", "ambient", "orchestral music", "euphonious", "mellifluent", "sweet", "romantic piano accompaniment", "acoustic guitar"] | 7 | oqMlq2zWr0c | 4659 | |
Ritchie Valens "MEMORIES" ((R.I.P.Tribute)) | This song is an instrumental. The tempo is medium with a melodious lead on the electric guitar, steady drumming, groovy bass lines and acoustic guitar accompaniment. The melody is simple, mellow, pleasant, melancholic, nostalgic and ambient. This instrumental song is a Classic Rock and Roll. | 2008-02-16T02:42:07Z | JESSE OROS | R.I.P.†DOLORES MARTINEZ† 12/26/12 QUERIDA MADRE http://www.ritchievalens.com/ Ritchie Valens "MEMORIES" (SLEEP-WALK) | ["Swing music", "Music"] | ["retro pop", "slow tempo", "instrumental", "acoustic guitar accompaniment", "emphatic lead", "simple melody", "dulcet", "mood", "fluid", "romantic", "ambient", "melodic electric guitar lead", "steady drumming", "groovy bass lines", "acoustic guitar accompaniment", "mellow", "soft", "pleasant", "melancholic", "nostalgic", "rock and roll"] | 7 | xKc_9B3RiOc | 5318 |
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;