musiccaps_details (view)
6 rows where musiccaps_aspects contains "folk", musiccaps_aspects contains "passionate" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- folk · 6 ✖
- low quality 6
- passionate · 6 ✖
- live performance 5
- noisy 4
- groovy bass 3
- punchy snare 3
- accordion melody 2
- electric guitar melody 2
- shimmering cymbals 2
- unbalanced stereo 2
- acoustic guitar solo melody 1
- acoustic rhythm guitar 1
- acoustic rhythm guitar melody 1
- banjo melody 1
- crowd chattering 1
- crowd noises 1
- easygoing 1
- energetic 1
- flat male vocal 1
- groovy 1
- live perforamnce 1
- nature sounds 1
- passionate female vocal 1
- percussive tambourine 1
- punchy kick 1
- reverberant 1
- saxophone melody 1
- shimmering hi hats 1
- soulful 1
- steel guitar solo melody 1
- steel guitars melodies 1
- trumpet melody 1
- unbalanced stereo image 1
- upbeat 1
- uptempo 1
- violin melody 1
- wide clapping 1
musiccaps_names (array) 15 ✖
- Music 6
- Musical instrument · 6 ✖
- Banjo 3
- Guitar 3
- Plucked string instrument 3
- Accordion 2
- Singing 2
- Country 1
- Music of Latin America 1
- Orchestra 1
- Speech 1
- Swing music 1
- Tambourine 1
- Tap 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
Foggy Mtn Breakdown (Must-Own DVD) | The low quality recording features a live performance of a folk song and it contains a steel guitar solo melody played over, acoustic rhythm guitar, electric guitar melody, shimmering cymbals, punchy snare, groovy bass, followed by violin melody, crowd noises and claps. It sounds passionate, uptempo, soulful and energetic. | 2009-07-15T05:50:54Z | jamesarthurjohnson | From All-Star Bluegrass Celebration DVD - Ricky Skaggs, Earl Scruggs, Vince Gill, Travis Tritt, Jerry Douglas, and on and on... | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "folk", "live performance", "wide clapping", "crowd noises", "steel guitar solo melody", "acoustic rhythm guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "electric guitar melody", "violin melody", "passionate", "uptempo", "soulful", "energetic"] | 4 | GuHDy--gWiM | 1758 | |
Karène Neuville 14 ans - Pasos Lesterps 2015 | The low quality recording features a live performance of a folk song that contains an accordion melody playing over acoustic rhythm guitar, groovy bass, punchy kick and snare hits, shimmering cymbals, saxophone and trumpet melody. It sounds passionate and easygoing, even though the recording is noisy and the stereo image is unbalanced, due to the fact that the sound is leaning towards the left channel. | 2015-07-21T19:29:48Z | Armand Boudet | Je vous invite aujourd'hui à visiter le site www.kareneneuville.fr dans lequel vous trouverez toutes les infos sur l'agenda de Karène et les CD disponibles à la vente | ["Swing music", "Music", "Musical instrument", "Accordion"] | ["low quality", "live performance", "folk", "accordion melody", "acoustic rhythm guitar", "shimmering cymbals", "punchy kick", "punchy snare", "saxophone melody", "trumpet melody", "groovy bass", "noisy", "unbalanced stereo", "passionate", "easygoing"] | 4 | gsIB8HjsRtw | 4064 | |
Old Man Luedecke - I'm Fine (I Am, I Am) | The low quality recording features a short snippet of flat male vocals, followed by steel guitar melodies. It sounds passionate, even though the recording is very noisy. | 2012-10-01T19:57:33Z | AnalogSongs | Recorded live on the beach in Chester, NS with Old Man Luedecke and Joel E Hunt on mandolin. From the new album Tender is the Night, released October 2nd, 2012 http://oldmanluedecke.ca Video by Analog Songs: http://www.analogsongs.ca Camera and post production: Stephen Cooper and Katy Hopkins, Audio recording and post production: Cameron Dexter | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "steel guitars melodies", "flat male vocal", "passionate", "folk", "live performance"] | 4 | kIEEDYowZhA | 4307 | |
VANESA MUELA | The low quality recording features a live performance of a folk song and it consists of passionate female vocal singing over percussive tambourine. The recording is noisy, reverberant and the stereo image is unbalanced - leaning more towards the right channel. It sounds passionate though. | 2011-06-18T13:58:40Z | Surefolk Actividades Culturales | La cantante tradicional vallisoletana, dando un recital de percusión y canto tradicional en el Museo de la Música Étnica de Barranda, con motivo del ciclo "Conciertos sentidos" 2011 del Ayto. de Caravaca | ["Singing", "Music", "Musical instrument", "Tambourine", "Tap"] | ["low quality", "folk", "live performance", "passionate female vocal", "reverberant", "unbalanced stereo image", "percussive tambourine", "noisy", "passionate"] | 4 | pOZWVSiRwv4 | 4706 | |
Willow & Lee - Foggy Mountain Breakdown | The low quality recording features a live performance of a folk song and it consists of acoustic guitar solo melody, followed by banjo melody. The recording is noisy, there are some natural sounds - since it was performed outdoors and the stereo image is unbalanced due to the fact that the instruments are leaning towards the right channel of the stereo image. It still sounds passionate and upbeat. | 2014-06-01T14:36:03Z | WillowOsborne | 13-year Old Willow Osborne & Lee Marcus performs "Foggy Mountain Breakdown" at Dollywood, Pigeon Forge, TN. (May 2014) | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "live perforamnce", "unbalanced stereo", "nature sounds", "acoustic guitar solo melody", "upbeat", "banjo melody", "folk", "passionate"] | 4 | qyCea2TuUV4 | 4840 |
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;