musiccaps_details (view)
7 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "medium to uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- acoustic guitar · 7 ✖
- amateur recording · 7 ✖
- medium to uptempo · 7 ✖
- djembe 2
- male voice singing 2
- upright bass 2
- accordion 1
- background voices 1
- bagpipe 1
- banjo 1
- bluegrass 1
- cheerful atmosphere 1
- country/folk 1
- crowd cheering and clapping 1
- digital bass 1
- digital drum 1
- electro 1
- energetic energy 1
- folkmusic 1
- frame drum 1
- guitar-like instrument 1
- high pitch 1
- higher pitch 1
- male and female voices singing 1
- male singer 1
- male voice speaking 1
- mandolin 1
- percussion 1
- rock/country 1
- scratching 1
- singer-songwriter/pop 1
- traditional/folkmusic 1
- violin 1
- voice sample 1
musiccaps_names (array) 19 ✖
- Music 5
- Acoustic guitar 2
- Banjo 2
- Musical instrument 2
- Plucked string instrument 2
- Accordion 1
- Bluegrass 1
- Blues 1
- Bowed string instrument 1
- Country 1
- Guitar 1
- Harmonica 1
- Mandolin 1
- Outside, rural or natural 1
- Speech 1
- Steel guitar, slide guitar 1
- Theremin 1
- Violin, fiddle 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bluegrass jam ( Rebecca) | An acoustic guitar is strumming chords while a banjo is playing a fast melody over it. In the background you can hear an upright bass playing a fast walking bassline. Also in the background noises of people speaking can be heard. This song may be playing live on the streets performed by buskers. | 2006-11-06T22:08:09Z | monrobro | Jamming at Memramcook Festival with True Blue Banjo- Dominic Cormier Bass- Jean-Marc Boucher Mandolin- Ron Girouard Guitar- 1st Break Michael Alain Guitar- 2nd Break Richard Bourque | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bluegrass"] | ["bluegrass", "amateur recording", "banjo", "acoustic guitar", "upright bass", "background voices", "medium to uptempo"] | 6 | 669Fk7afszw | 724 | |
Tartan Terrors - Stump the Piper | This song contains someone playing a rhythm on a djembe along with a frame drum. Someone is strumming chords on guitar while the bagpipes are taking the main melody. Then a male voice starts speaking and the crowd is cheering and clapping their hands. This song may be playing live at a traditional concert. | 2006-10-20T03:14:46Z | jayedeye | Bagpipes with flair... from the Pennsylvania Rennaissance Faire 10-14-06. This is stump the bagpiper | ["Harmonica", "Wind instrument, woodwind instrument"] | ["traditional/folkmusic", "acoustic guitar", "djembe", "frame drum", "bagpipe", "male voice speaking", "crowd cheering and clapping", "medium to uptempo", "amateur recording"] | 6 | Q2Omtt4A8ls | 2591 | |
Selflessness & Tattoo | This audio seems to contain two songs. In the beginning someone is strumming chords on acoustic drums while a male voice is singing in a high pitch. Then the song switches to a robotic voice sample singing. Then a digital drum comes in with a fat kick and bass sound creating the base together with the vocal sample. In the background you can hear scratching sounds. This song may be playing while working out. | 2015-09-11T05:36:12Z | Nick Bare | SUBSCRIBE TO MY CHANNEL: http://full.sc/1GSFia3 SUPPORT MY COMPANY: www.bareperformancenutrition.com "INSTA10" - 10% off online store APPAREL: http://bareperformancenutrition.spreadshirt.com/ FACEBOOK: http://facebook.com/bareperformancenutrition TWITTER: http://twitter.com/BPN_Supplements INSTAGRAM: http://instagram.com/bareperformancenutrition MYFITNESSPAL: http://myfitnesspal.com/barepn For Business Inquires Only: nick@bareperformancenutrition.com Intro by Kenny Gonzales KGBgraphics www.youtube.com/kgbgraphics | ["Music", "Theremin", "Outside, rural or natural"] | ["amateur recording", "electro", "digital drum", "digital bass", "voice sample", "scratching", "male voice singing", "high pitch", "acoustic guitar", "medium to uptempo", "energetic energy"] | 6 | eZrrzGgTpfk | 3882 | |
ライオンハート SMAP cover, Gibson Humming bird ( ギター 弾き語り スマップカバー ギブソン ハミングバード) | Someone is strumming an acoustic guitar while a male voice is singing along. This may be playing at a bonfire. | 2015-05-31T09:04:29Z | MA channel | ライオンハート SMAP cover 8曲目のアップとなります!是非!聞いてください。 | ["Blues", "Acoustic guitar", "Music", "Steel guitar, slide guitar"] | ["singer-songwriter/pop", "acoustic guitar", "male voice singing", "medium to uptempo", "amateur recording"] | 6 | em7akjDUsWk | 3895 | |
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 | |
GETULIO VARGAS cavalo amarelo. | This song contains someone playing an accordion melody and chords along with an acoustic guitar strumming the same chords. Someone is playing an acoustic instrument while a male voice is singing in a higher key. This song may be playing in the countryside. | 2011-03-06T17:18:58Z | ALOCHECULTURAGAUCHA | CLIP gravado por NELSON OLIVEIRA para o programa Alô Chê do IVAN TABORDA. | ["Accordion"] | ["folkmusic", "accordion", "acoustic guitar", "male singer", "higher pitch", "percussion", "medium to uptempo", "amateur recording", "cheerful atmosphere"] | 6 | nJ3tuDmcdTs | 4531 | |
Cherokee Shuffle on mandolin | Someone is playing an acoustic guitar along with someone playing a solo melody on top with another plucked string instrument. They are accompanied by someone playing a djembe or another percussive instrument. This song may be playing sitting around a bonfire. | 2009-04-19T19:44:26Z | Bill Macy | Cherokee Shuffle on mandolin | ["Acoustic guitar", "Music", "Mandolin", "Plucked string instrument"] | ["rock/country", "acoustic guitar", "guitar-like instrument", "djembe", "medium to uptempo", "amateur recording"] | 6 | vgpV6F9tge8 | 5197 |
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;