musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "steady drumming" and musiccaps_names contains "Musical instrument" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- steady drumming · 3 ✖
- country music 2
- instrumental 2
- acoustic guitar accompaniment 1
- amplified guitar riff 1
- auto harp harmony 1
- autoharp accompaniment 1
- backup singers 1
- bad audio quality 1
- banjo 1
- burgeoning harmony 1
- captivating 1
- catchy 1
- classic county hits 1
- classic rock 1
- country classics 1
- country folk song 1
- country pop 1
- country pop instrumental 1
- country song instrumental 1
- dobro 1
- dulcet 1
- engaging 1
- enthusiastic 1
- euro pop 1
- everlasting hits 1
- exciting 1
- funky bass line 1
- groovy 1
- groovy rhythm 1
- guitar strumming 1
- intense 1
- keyboard accompaniment 1
- male singer 1
- medium tempo 1
- mellifluous 1
- mellow 1
- nostalgia 1
- old memories 1
- peaceful 1
- pleasant 1
- pop super hits 1
- retro hits 1
- retro rock 1
- rock 1
- slow tempo 1
- song cover 1
- soothing 1
- story telling 1
- upbeat 1
- walking bas s line 1
- walking bass line 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music 3
- Musical instrument · 3 ✖
- Guitar 2
- Acoustic guitar 1
- Blues 1
- Christian music 1
- Echo 1
- Electric guitar 1
- Plucked string instrument 1
- Steel guitar, slide guitar 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Duquesne Whistle Copyright blocked Audio Joh Pink Rig.Steam Trains, Art, Bob Dylan etc | This song is an instrumental. The tempo is medium with an interesting electric guitar riff and subtle keyboard followed by energetic drumming, Funky bass lines and keyboard arrangement. The song gradually builds up and is catchy, youthful, upbeat, melodious, captivating and groovy. This song is Soft Rock. | 2012-09-25T05:45:20Z | conncork | Copyright Duquesne Whistle blocked replaced by music van google. Audio-informatie voor deze video Artiest: Joh Nummer: Pink Rig Duur: 06:20 Genre: RockSteam Trains America Europe Art Bob Dylan etc. Music Joh Pink Rig van Google. Bob Dylan Duquesne Whistle Tempest Bob Dylan steam trains Duluth, Minnesota America people Lizard Paintings | ["Blues", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "amplified guitar riff", "intense", "captivating", "groovy", "burgeoning harmony", "youthful", "catchy", "upbeat", "engaging", "captivating", "steady drumming", "funky bass line", "keyboard accompaniment", "rock", "classic rock", "retro rock"] | 7 | R-aMYx9f0Ho | 2658 | |
EGIL SKJELNES - LOOK AT US | This music is a country song instrumental. The tempo is slow with a mellifluous Auto Harp harmony, steady drumming, rhythmic acoustic guitar, and subtle bass lines. The music is melodic, soothing, peaceful, nostalgic,mellow and dulcet Country Song Instrumental. | 2012-07-08T07:31:41Z | Steelnes | Homevideo Live July 2012 | ["Echo", "Electric guitar", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar"] | ["instrumental", "slow tempo", "steady drumming", "banjo", "dobro", "dulcet", "country pop instrumental", "peaceful", "acoustic guitar accompaniment", "auto harp harmony", "country music", "country pop", "country folk song", "country song instrumental", "mellow", "soothing", "mellifluous"] | 7 | XaUXJG0BZuk | 3198 |
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;