musiccaps_details (view)
3 rows where musiccaps_aspects contains "engaging", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "soothing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- engaging · 3 ✖
- instrumental · 3 ✖
- soothing · 3 ✖
- steady drumming 3
- pleasant 2
- simple melody 2
- ambient 1
- amplified cello harmony 1
- boomy bass 1
- bow stringed instrument 1
- captivating 1
- cheerful 1
- cymbals 1
- digital drumming 1
- electric guitar 1
- electric guitar melody 1
- emotional 1
- euphonious 1
- fast tempo 1
- four stringed instrument 1
- groovy bass lines 1
- inspiring 1
- keyboard harmony 1
- lingering 1
- medium tempo 1
- mellifluous 1
- melodic 1
- melodious 1
- mesmerising 1
- pleasant melody 1
- pop 1
- rhythmic acoustic guitar 1
- romantic 1
- sedate 1
- sentimental 1
- simple 1
- slow tempo 1
- soft 1
- soft pop 1
- soft rock 1
- steady rhythm 1
- string instrument 1
- string instruments 1
- subtle bass lines 1
- synthesiser arrangement 1
- tambourine beats 1
- ukelele accompaniment 1
- violin 1
musiccaps_names (array) 9 ✖
- Music 2
- Bowed string instrument 1
- Cello 1
- Distortion 1
- Double bass 1
- Electric guitar 1
- Ping 1
- Pizzicato 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Missing from YouTube | This is a melodious instrumental. The tempo is slow with a cello harmony, ukulele accompaniment, boomy bass and steady drumming. The music is soft, mellow, ethereal, classic, soothing, captivating and mellifluous. | ["Cello", "Double bass", "Pizzicato", "Bowed string instrument"] | ["instrumental", "slow tempo", "amplified cello harmony", "bow stringed instrument", "four stringed instrument", "string instrument", "digital drumming", "ukelele accompaniment", "boomy bass", "violin", "steady drumming", "soft", "soothing", "engaging", "captivating", "mesmerising", "melodious"] | 7 | 2344 | |||||
NapoliTube | Maradona: palleggio con pallone, palla da tennis e pallina da ping pong! | RIP D10S! | This music is instrumental. The tempo is fast with rhythmic acoustic guitar, steady drumming, keyboard harmony, groovy bass line and electric guitar accompaniment. The music is mellow,nostalgic, emotional, simple, pleasant, charming and melodic pop. | 2013-11-19T20:26:34Z | NapoliTube | NAPOLITUBE | La Videoenciclopedia del Napoli: https://www.napolitube.eu SEGUI TUTTA LA STORIA DEL NAPOLI IN VIDEO SU https://www.napolitube.eu LA VIDEOENCICLOPEDIA DEL NAPOLI! | ["Music", "Ping"] | ["instrumental", "fast tempo", "rhythmic acoustic guitar", "pop", "steady drumming", "simple melody", "pleasant", "mellifluous", "inspiring", "emotional", "string instruments", "keyboard harmony", "steady drumming", "groovy bass lines", "electric guitar melody", "pleasant melody", "simple", "steady rhythm", "soothing", "engaging"] | 7 | aYoRcnmz6ZE | 3553 | |
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 |
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;