musiccaps_details (view)
3 rows where musiccaps_aspects contains "country" and musiccaps_author = 7 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- country · 3 ✖
- instrumental 3
- banjo 2
- folk 2
- medium tempo 2
- melodious 2
- string instrument 2
- 9 stringed instrument 1
- african instrument 1
- american instrument 1
- amplified guitar 1
- banjo lead 1
- blue grass 1
- bluegrass 1
- blues 1
- country music 1
- electric guitar 1
- external amplification 1
- fast tempo 1
- folk song 1
- hard rock 1
- heavy metal 1
- high pitched sounds 1
- home recording 1
- intense 1
- jazz 1
- lead instrument 1
- lively 1
- loud 1
- minimal instrumentation 1
- no accompaniment 1
- plucked string instrument 1
- poor audio quality 1
- pop 1
- powerful 1
- regional music 1
- rock 1
- skilful 1
- sonic power 1
- spirited 1
- stringed instrument 1
- sweet melody 1
- vibrations 1
- world music 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
C Harmonic Minor with a G Phrygian Ending | This music clip is an electric guitar solo lead instrumental. The tempo is fast with the guitarist playing a very emphatic, intense riff. No other instruments have been used. The music is loud, intense, engaging and catchy. | 2006-08-08T20:49:22Z | ahmedgarcia | C harmonic Minor with a G Phrygian ending. | ["Effects unit", "Electric guitar", "Music", "Harmonic", "Distortion"] | ["electric guitar", "instrumental", "string instrument", "external amplification", "vibrations", "skilful", "pop", "jazz", "country", "blues", "heavy metal", "lead instrument", "medium tempo", "sonic power", "amplified guitar", "melodious", "minimal instrumentation", "rock", "hard rock", "intense", "loud", "powerful"] | 7 | kaabXWuPWRg | 4332 | |
Luap plays Old Gray Goose (take 2) | This music clip is of a musician playing a lilting melody on the Banjo. The tempo is medium with a rhythmic lead harmony. There is no other instrument used. The music is soft, mellow, nostalgic, and calming. Soothing and simple. | 2009-01-12T01:39:50Z | llmckee | More practice and improvement | ["Banjo", "Music", "Steel guitar, slide guitar", "Plucked string instrument"] | ["instrumental", "medium tempo", "string instrument", "plucked string instrument", "banjo", "african instrument", "american instrument", "9 stringed instrument", "sweet melody", "folk", "country", "blue grass"] | 7 | YbLR6dgY-K4 | 3297 | |
cluck old hen | This music clip is a Lively Banjo instrumental. The tempo is fast with a spirited Banjo lead harmony. The music is simple, cheerful, happy, festive, upbeat and vivacious. The audio is not very clear as it is a home recording. The music has a country or folk song vibe. | 2009-06-29T15:04:18Z | janepc123 | Played on my newly acquired John Grey open back courtesy of the generosity of Joemac | ["Banjo", "Music", "Bluegrass"] | ["instrumental", "fast tempo", "lively", "spirited", "country music", "folk song", "regional music", "banjo", "banjo lead", "no accompaniment", "world music", "melodious", "poor audio quality", "home recording", "stringed instrument", "country", "bluegrass", "folk", "high pitched sounds"] | 7 | R1RGIgC-xKw | 2661 |
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;