musiccaps_details (view)
2 rows where musiccaps_aspects contains "stringed instruments" and musiccaps_names contains "Acoustic guitar"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- folk music 2
- stringed instruments · 2 ✖
- 8 stringed instrument 1
- acoustic guitar accompaniment 1
- animated 1
- arabian nights 1
- arabic music 1
- arabic percussions 1
- bright 1
- cheerful 1
- chirpy 1
- dance music 1
- desert sands 1
- folk instrumental music 1
- gets adventure 1
- happy 1
- high notes 1
- hissing noise 1
- historical 1
- instrumental 1
- instrumental music 1
- lively 1
- lute family 1
- mandolin 1
- mandolin harmony 1
- no percussions 1
- plucking 1
- poignant 1
- poor audio quality 1
- slow tempo 1
- soprano string instrument 1
- spirited 1
- string harmony 1
- strong bass line 1
- subtle percussion rhythm 1
- sunny 1
- traditional muscle 1
- traditional music 1
musiccaps_names (array) 7 ✖
- Acoustic guitar · 2 ✖
- Mandolin 2
- Music 2
- Plucked string instrument 2
- Guitar 1
- Musical instrument 1
- Strum 1
youtube_published (date) 2 ✖
- 2009-04-05 1
- 2011-09-09 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Old Joe Clark - Mandolins | This music is instrumental . The tempo is fast with mandolins playing a lively, spirited rhythmic harmony with acoustic guitar accompaniment. The instrumentation is minimal with emphasis on the mandolin melody. The music is chirpy, perky, cheerful, happy, animated and spirited. | 2011-09-09T13:52:59Z | pstewart0831 | Bluegrass Mandolin Class impromptu jam Lyrics: 1. Old Joe Clark, the preacher's son Preached all over the plain The only text he ever knew Was high low jack and the game [Chorus] Fare thee well Old Joe Clark Fare thee well I'm bound Fare thee well Old Joe Clark Goodbye Betsy Brown 2. Old Joe Clark had a mule His name was Morgan Brown And every tooth in that mule's head Was sixteen inches round Chorus 3. Old Joe Clark had a yellow cat She would neither sing nor pray Stuck her head in a buttermilk jar And washed her sins away Chorus 4. Old joe clark had a house Fifteen stories high And every story in that house Was filled with chicken pie Chorus 5. I went down to Old Joe's house He invited me to supper I stumped my toe on the table leg And stuck my nose in the butter Chorus | ["Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["instrumental", "mandolin", "mandolin harmony", "stringed instruments", "8 stringed instrument", "string harmony", "lute family", "soprano string instrument", "high notes", "plucking", "lively", "cheerful", "happy", "sunny", "chirpy", "bright", "animated", "spirited", "dance music", "folk music", "acoustic guitar accompaniment"] | 7 | D-p9s8y2z_U | 1427 | |
portrait pinting withe water colors A sheiko | The song is an instrumental. The song is a slow tempo with a stringed instrument playing a poignant melody, a strong bass line and a subtle percussive rhythm. The song is rich in tradition and poignant. The song has poor audio quality with hissing disturbances. | 2009-04-05T11:05:58Z | dilba m | slid show | ["Guitar", "Acoustic guitar", "Music", "Mandolin", "Strum", "Plucked string instrument"] | ["instrumental music", "slow tempo", "arabic music", "poor audio quality", "hissing noise", "folk music", "folk instrumental music", "arabic percussions", "stringed instruments", "traditional muscle", "subtle percussion rhythm", "poignant", "desert sands", "arabian nights", "gets adventure", "historical", "traditional music", "strong bass line", "no percussions"] | 1 | VeAomElRCJc | 3016 |
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;