musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass lines" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- bass lines · 2 ✖
- ambient 1
- amplified 1
- amplified guitar 1
- bass electric guitar 1
- bongos 1
- congas 1
- dense sounds 1
- electric guitar 1
- energetic 1
- enthusiastic riff 1
- folk pop 1
- groovy 1
- harp 1
- hawaiian guitar 1
- instructional video 1
- instructions 1
- instrumental 1
- keyboard accompaniment 1
- loud 1
- lower notes 1
- lower octave 1
- male vocals 1
- man talking 1
- mellow 1
- muffled music 1
- people talking 1
- pleasant melody 1
- powerful 1
- regional pop 1
- resonant 1
- skilful 1
- smooth 1
- soft 1
- sonic power 1
- static 1
- steady bass lines 1
- string instrument harmony 1
- stringed guitar 1
- supporting instrument 1
- tutorial 1
- ukele 1
- vibrations 1
- youthful 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fender Rumble 200 Electric Guitar Sound Test | This music clip is a bass electric guitar instrumental. The tempo is medium fast with the guitarist playing an enthusiastic riff after giving instructions. No other instruments are used and the talking at the beginning of the audio clip indicates that this is a tutorial or instructional video. | 2015-09-29T09:57:42Z | Chuckoy Vicuña | Epiphone Les Paul - Korg Pith Black Tuner - Boss SD1 - Electro Harmonix Big Muff Pi - MXR Blow Torch - Fender Rumble 200 | ["Tapping (guitar technique)", "Electric guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["male vocals", "electric guitar", "powerful", "loud", "skilful", "supporting instrument", "groovy", "dense sounds", "bass lines", "vibrations", "resonant", "bass electric guitar", "lower notes", "lower octave", "smooth", "instructional video", "sonic power", "amplified", "stringed guitar", "amplified guitar", "enthusiastic riff", "energetic", "youthful", "man talking", "tutorial", "instructions", "static"] | 7 | JPZlyvPNZj4 | 2003 | |
Jamaica Farewell / Island In The Sun | This song is an instrumental. The tempo is slow with a keyboard harmony, steady bass lines, congas and bongo rhythm and sound of an instrument like a harp and string instrument like a ukelele or Hawaiian guitar.The music is soft, mellow, pleasant and simple with the sound of people talking in the background. This is a Regional/Folk Pop instrumental. | 2008-02-17T15:07:09Z | Steel Drum Music | Now on iTunes → click the little tab button for the link and info → → → Caribbean classics played on steel drums from Trinidad. This song is featured on the 'Steel Drum Gold' album. You can get it at: iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA or directly from Bob Lyons' web site: http://www.SteelDrumMusic.net Steel drums at dinner party, Stranahan House, Fort Lauderdale, 2-13-08 | ["Music", "Musical instrument", "Steelpan"] | ["instrumental", "keyboard accompaniment", "congas", "string instrument harmony", "hawaiian guitar", "ukele", "steady bass lines", "regional pop", "folk pop", "pleasant melody", "bongos", "bass lines", "harp", "people talking", "soft", "mellow", "ambient", "muffled music"] | 7 | P996TZp25PM | 2512 |
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;