musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "walking bass line" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 71 ✖
- medium tempo · 4 ✖
- walking bass line · 4 ✖
- bad audio quality 2
- exciting 2
- guitar rhythm 2
- instrumental music 2
- passionate 2
- pleasant 2
- spirited 2
- steady drumming 2
- story telling 2
- accordion melody 1
- adventurous 1
- amateur band 1
- autoharp accompaniment 1
- average audio quality 1
- backup singers 1
- blue band 1
- blues harmonica 1
- blues harp 1
- blues legends 1
- blues progression 1
- blues turn around 1
- cheerful 1
- childhood memories 1
- classic county hits 1
- country classics 1
- country music 1
- cymbals crashes 1
- dance groove 1
- dance rhythm 1
- emotional 1
- energetic 1
- entertaining 1
- enthusiastic 1
- euro pop 1
- everlasting hits 1
- excitement 1
- full of cheer 1
- groovy 1
- groovy bass line 1
- groovy rhythm 1
- guiro percussions 1
- guitar strumming 1
- guitar strumming rhythm 1
- happy 1
- harmonica player 1
- harpist 1
- latin dance band 1
- latin folk singer 1
- latin percussions 1
- male latin singer 1
- male singer 1
- nostalgia 1
- nostalgic 1
- old memories 1
- people dancing 1
- piano accompaniment 1
- poor audio quality 1
- pop super hits 1
- retro hits 1
- romantic 1
- slow dance 1
- soaring melody 1
- soaring vocals 1
- song cover 1
- steady marching drumming rhythm 1
- the blues 1
- train journey 1
- walking bas s line 1
- wonder 1
musiccaps_names (array) 7 ✖
- Music 4
- Blues 1
- Christian music 1
- Christmas music 1
- Music of Africa 1
- Musical instrument 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
el grillo enamorado | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | 2008-09-05T17:39:10Z | Piko | el grillo enamorado con imagenes de grillos | ["Music of Africa", "Music", "Ska"] | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | 1 | 2cxvYC9QZac | 391 | |
Aleksander Mežek - Siva pot | A male singer sings this popular country hit with backup singers in vocal harmony. The song is in medium tempo with a walking bass , acoustic guitar strumming rhythmically, autoharp accompaniment and steady drumming rhythm. The song is an emotional and nostalgic country hit. The audio quality is poor. | 2006-12-19T14:33:29Z | jaki386 | Aleksander Mežek - Siva pot | ["Christian music", "Music", "Musical instrument"] | ["male singer", "backup singers", "guitar strumming", "everlasting hits", "euro pop", "medium tempo", "walking bass line", "autoharp accompaniment", "walking bas s line", "steady drumming", "story telling", "nostalgia", "pleasant", "exciting", "enthusiastic", "old memories", "classic county hits", "pop super hits", "retro hits", "groovy rhythm", "country classics", "bad audio quality", "song cover", "country music"] | 1 | 3KQy3Cajo4E | 456 | |
LGB #26814 German Steam Locomotive Class 99.23 (DCC Sound Decoder) | The song is an instrumental. The song is medium tempo with a walking bass line, steady drumming rhythm with cymbal crashes, guitar strumming rhythm and an accordion playing melody. The song is background music for a toy hobbyist video. The song is cheerful and reminiscent of a childhood adventure. | 2016-07-12T20:16:51Z | TrainWorldTV | LGB #26814 German Steam Locomotive Class 99.23 (DCC Sound Decoder) http://www.trainworld.com The model railroad equipment & accessories we sell are not toys, and are not intended for use by children under the age of 14, | ["Christmas music", "Music"] | ["instrumental music", "steady marching drumming rhythm", "nostalgic", "full of cheer", "average audio quality", "wonder", "accordion melody", "cymbals crashes", "guitar strumming rhythm", "walking bass line", "pleasant", "cheerful", "happy", "energetic", "excitement", "train journey", "childhood memories", "medium tempo", "amateur band"] | 1 | BsLFQV8HVZE | 1298 | |
American Folk Blues Festival 1983 feat. Carey Bell | The song is an instrumental blues song. The song is medium tempo with a blues harmonica playing a cool melody, walking bass line, guitar accompaniment , steady drumming rhythm and other percussion hits. The song is exciting and groovy. The song has a bad audio quality. | 2006-06-16T20:47:21Z | Harpsucker | Carey Bell-voc/harmonica Louisiana Red-git Jimmy Rodgers-git Lovie Lee-piano Queen Sylvia Embry-bass Charles"Honey Boy"Otis-drums rec-live in germany 1983 | ["Blues", "Music"] | ["blues harmonica", "blues harp", "harpist", "instrumental music", "harmonica player", "groovy bass line", "guitar rhythm", "steady drumming", "the blues", "blues progression", "instrumental music", "soaring melody", "bad audio quality", "blue band", "walking bass line", "blues turn around", "blues legends", "medium tempo", "adventurous", "exciting", "groovy", "slow dance", "passionate", "spirited"] | 1 | GT9g4uqK9G8 | 1725 |
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;