musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_names contains "Banjo" and musiccaps_names contains "Bowed string instrument"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 46 ✖
- banjo 3
- acoustic guitar 2
- bluegrass 2
- mandolin 2
- violin 2
- amateur recording 1
- american 1
- announcement 1
- bad audio quality 1
- cheerful 1
- child performers 1
- country bluegrass 1
- country dance music 1
- country folk music 1
- country music 1
- country/folk 1
- cozy 1
- dance rhythm 1
- double bass 1
- emotional 1
- fiddlers 1
- folk 1
- groovy rhythm 1
- guitar 1
- guitar strumming 1
- instrumental 1
- instrumental music 1
- live performance 1
- lively 1
- male and female voices singing 1
- male voice 1
- medium tempo 1
- medium to uptempo 1
- moderate tempo 1
- never give up 1
- no percussion 1
- no vocal melody 1
- passionate 1
- positive 1
- romantic mood 1
- spirited 1
- the country life 1
- the wild west 1
- traditional music 1
- upright bass 1
- violinists 1
musiccaps_names (array) 10 ✖
- Banjo · 4 ✖
- Bowed string instrument · 4 ✖
- Music 4
- Musical instrument 4
- Plucked string instrument 3
- Violin, fiddle 2
- Bluegrass 1
- Country 1
- Guitar 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
sleepy man banjo boys vs mountain rhythm | The song is instrumental. The tempo is medium with a prolific fiddler playing melody and a banjo and guitar accompaniment. The song is adventurous and exciting. The song is a classic country instrumental. The song has poor audio quality. | 2011-05-15T21:20:57Z | RubenProducciones | blatle of banjos. read the description: friends can go to this link and give it a like, would help me a lot to back up videos like this :) http://www.youtube.com/watch?v=g1I7seXs6O4 | ["Banjo", "Country", "Music", "Musical instrument", "Plucked string instrument", "Bowed string instrument"] | ["violinists", "country music", "fiddlers", "child performers", "instrumental music", "guitar strumming", "country folk music", "live performance", "groovy rhythm", "country dance music", "the country life", "the wild west", "dance rhythm", "passionate", "emotional", "spirited", "never give up", "cheerful", "positive", "traditional music", "bad audio quality", "country bluegrass", "banjo", "medium tempo"] | 1 | O84YjlJ_Qw4 | 2402 | |
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 | |
Rooster Song | This song contains an upright bass playing a simple bassline along with an acoustic guitar strumming chords and a mandolin playing a fast paced melody. A violin is ending the phrase in the mid range. Then male and female voices are singing with the female voice being the lead voice. In the background you can hear the crowd laughing. This song may be playing as a local concert. | 2007-01-11T22:59:38Z | Phil Greer | Timberline's most requested song... | ["Banjo", "Music", "Musical instrument", "Violin, fiddle", "Bowed string instrument"] | ["country/folk", "upright bass", "acoustic guitar", "violin", "mandolin", "male and female voices singing", "medium to uptempo", "amateur recording"] | 6 | j0UMI2DrnMA | 4229 | |
We'll Meet Again Sweet Heart- Japanese bluegrass Band in Korea.wmv | This bluegrass song starts off with a male voice making an announcement. The music starts to play. The banjo plays an introductory bluegrass lick. This is accompanied by an acoustic guitar strumming chords. The double bass plays the root note and the fifth of the chord. The mandolin plays the rhythm section in the song. There is no vocal melody in this song. There is no percussion in this song. This song can be played in a movie with a Western theme. | 2010-11-25T14:46:00Z | sun shin | ["Banjo", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bowed string instrument"] | ["bluegrass", "male voice", "announcement", "no percussion", "no vocal melody", "mandolin", "guitar", "banjo", "double bass", "moderate tempo", "romantic mood"] | 0 | oyAAhjGTNvQ | 4671 |
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;