musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "happy", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "noisy"
This data as json, CSV (advanced)
Suggested facets: musiccaps_names
musiccaps_aspects (array) 20 ✖
- happy · 3 ✖
- live performance · 3 ✖
- low quality 3
- noisy · 3 ✖
- fun 2
- acoustic rhythm guitar 1
- acoustic rhythm guitar chords 1
- country 1
- crowd chattering 1
- folk 1
- groovy acoustic rhythm guitar melody 1
- groovy mandoline melody 1
- groovy steel guitars melody 1
- harmonica solo 1
- harmonica solo melody 1
- harmonizing male vocals 1
- joyful 1
- mono 1
- passionate 1
- reverberant 1
musiccaps_names (array) 6 ✖
youtube_published (date) 3 ✖
- 2008-01-22 1
- 2008-08-30 1
- 2009-08-26 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Chicken Reel" Annie & Mac Old Time Music Moment | The low quality recording features a live performance that consists of harmonica solo melody played over acoustic rhythm guitar chords. The recording is noisy, in mono and it sounds happy and joyful. | 2008-01-22T04:52:48Z | annieandmac | Traditional old time mountain stringband tune played here on harmonica with rhythm guitar. http://www.annieandmac.com | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "noisy", "mono", "harmonica solo melody", "acoustic rhythm guitar chords", "happy", "joyful", "live performance"] | 4 | 4VbXYuCz4M0 | 577 | |
Doyle Lawson and Quicksilver performs "Sea of Life" at the High Country Bluegrass Festival | The low quality recording features a live performance of a country song and it consists of harmonizing male vocals singing over groovy steel guitar, groovy mandoline melody and groovy acoustic rhythm guitar chords. There are some crowd chattering noises in the background. It sounds passionate, happy and fun. | 2009-08-26T02:22:15Z | GrasshopperSlim | Doyle Lawson and Quicksilver performs "Sea of Life" at the High Country Bluegrass Festival in Boone North Carolina on July 25, 2009. | ["Banjo", "Country", "Music", "Bluegrass"] | ["low quality", "live performance", "country", "harmonizing male vocals", "groovy steel guitars melody", "noisy", "groovy mandoline melody", "groovy acoustic rhythm guitar melody", "passionate", "happy", "fun", "crowd chattering"] | 4 | ZX2fVPmUidA | 3388 | |
Whiskey Before Breakfast | The low quality recording features a live performance of a folk song and it consists of harmonica solo melody over acoustic rhythm guitar chord progression. It sounds happy and fun. The recording is noisy and a bit reverberant as it was probably recorded with a poor quality microphone. | 2008-08-30T13:29:47Z | HarmonicaAcademy | Tony Eyers - Harmonica John Bridgland - Guitar | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "live performance", "folk", "acoustic rhythm guitar", "harmonica solo", "happy", "fun", "noisy", "reverberant"] | 4 | drqKxGmdf8Y | 3820 |
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;