musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "soft" and musiccaps_aspects contains "steady drumming"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- instrumental · 3 ✖
- soft · 3 ✖
- steady drumming · 3 ✖
- ambient 2
- melodious 2
- mood 2
- slow tempo 2
- soothing 2
- acoustic guitar 1
- acoustic guitar accompaniment 1
- amplified cello harmony 1
- atmospheric 1
- boomy bass 1
- bow stringed instrument 1
- calming 1
- captivating 1
- cymbals 1
- digital drum 1
- digital drumming 1
- dulcet 1
- elctronic music 1
- emphatic lead 1
- engaging 1
- enigmatic 1
- ethereal 1
- fluid 1
- four stringed instrument 1
- groovy bass lines 1
- keyboard harmony 1
- medium tempo 1
- melancholic 1
- mellow 1
- melodic electric guitar lead 1
- mesmerising 1
- nostalgic 1
- pleasant 1
- punchy beat 1
- retro pop 1
- rock and roll 1
- romantic 1
- simple melody 1
- soft bass 1
- string instrument 1
- tambourine beats 1
- ukelele accompaniment 1
- violin 1
musiccaps_names (array) 7 ✖
- Music 2
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Pizzicato 1
- Swing music 1
- Tender 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 | |||||
Music Maker 2008 Chillout & Ambient 2 Songs | This song is an instrumental. The tempo is medium with a melodious keyboard harmony, rhythmic guitar accompaniment, punchy drumming, subtle bass line, synth arrangement and tambourine beats. The music is soft, mellow, ambient, pleasant, uplifting, and mellifluous. | 2008-03-10T18:25:25Z | Jonas Bayerlein | magix music maker 2008 | ["Music", "Tender music"] | ["instrumental", "medium tempo", "steady drumming", "acoustic guitar", "keyboard harmony", "soft bass", "digital drum", "cymbals", "ambient", "elctronic music", "tambourine beats", "melodious", "soft", "calming", "soothing", "mood", "atmospheric", "ethereal", "enigmatic", "punchy beat"] | 7 | P240GHf9Eq4 | 2494 | |
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;