musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "folk" and musiccaps_names contains "Bluegrass" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- folk · 3 ✖
- acoustic 12 string guitars 1
- acoustic guitar 1
- american 1
- arpeggiated acoustic guitar melody 1
- banjo 1
- bluegrass 1
- cozy 1
- crowd chattering 1
- fast tempo 1
- fun 1
- groovy accordion melody 1
- groovy bass 1
- happy 1
- harmonized vocals 1
- instrumental 1
- live performance 1
- lively 1
- low quality 1
- nature 1
- outdoor recording 1
- violin 1
musiccaps_names (array) 12 ✖
- Bluegrass · 3 ✖
- Music 3
- Guitar 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Banjo 1
- Bowed string instrument 1
- Mandolin 1
- Singing 1
- Violin, fiddle 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Morgan Monroe MM-100SBC | This song contains a composition played on an acoustic 12 string guitar strumming fast chords while another guitar is playing a fast paced melody in a higher key. The whole pattern repeats itself. This song may be playing in an Irish bar. | 2013-08-27T18:21:05Z | Morgan Monroe | Series: Rocky Top Style: Classic F-Style Top: Select Spruce Back: Maple Sides: Maple Neckjoint: Dovetail Fingerboard: Rosewood Bridge: Rosewood Tailpiece: 2 Piece Hardware: Gold Tuners: Pearloid Open Strings: Daddario Case: Deluxe Hardshell LIFETIME WARRANTY Prices accurate as of 8/27/2013. Contact your Morgan Monroe dealer to obtain the latest pricing. List: $1049.95 Street Price: $524.95 | ["Guitar", "Acoustic guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument", "Bluegrass"] | ["folk", "acoustic 12 string guitars", "fast tempo"] | 6 | UoSID1KzWuI | 2945 | |
YODELING IN KOREA | The low quality recording features a live performance of a folk song and it contains harmonized mixed vocals singing over groovy bass, groovy accordion melody and arpeggiated acoustic guitar solo melody. The recording took place outdoors, since there was some crowd chattering and nature sounds. It sounds happy and fun. | 2009-09-13T15:23:28Z | VascoPolonia | Six Korean college students yodeling at Global Fair & Festival in Incheon, South Korea. | ["Singing", "Yodeling", "Music", "Bluegrass"] | ["low quality", "live performance", "folk", "harmonized vocals", "crowd chattering", "outdoor recording", "groovy bass", "groovy accordion melody", "arpeggiated acoustic guitar melody", "happy", "fun", "nature"] | 4 | gNjeps3EbJA | 4026 | |
Wild Oats: Bluegrass Music | This is a bluegrass music piece. The acoustic guitar follows an offbeat strumming pattern, providing a rhythmic background. The violin and the banjo take turns to play rapid, upbeat solos. The atmosphere is very lively. This piece could be used at a definitively American setting such as a rodeo venue. | 2007-03-08T23:27:07Z | Infinitecre8tions | We met these guys in Pigeon Forge, TN as the opening act in Dolly Parton's Dixie Stampede. They agreed to do a private show just for our cameras! | ["Banjo", "Guitar", "Music", "Musical instrument", "Violin, fiddle", "Plucked string instrument", "Bluegrass", "Bowed string instrument"] | ["bluegrass", "instrumental", "violin", "banjo", "acoustic guitar", "american", "folk", "cozy", "lively"] | 9 | hH6thMA3640 | 4090 |
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;