musiccaps_details (view)
4 rows where musiccaps_aspects contains "crowd chattering", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- crowd chattering · 4 ✖
- live performance · 4 ✖
- low quality 4
- passionate · 4 ✖
- noisy 3
- accordion melody 1
- acoustic rhythm guitar 1
- acoustic strings melody 1
- country 1
- echoing male vocal 1
- electric guitar melody 1
- emotional 1
- folk 1
- fun 1
- groovy 1
- groovy acoustic rhythm guitar melody 1
- groovy bass 1
- groovy mandoline melody 1
- groovy steel guitars melody 1
- happy 1
- harmonizing male vocals 1
- indie 1
- laughing 1
- passionate male vocal 1
- plucked strings melody 1
- punchy snare 1
- sad 1
- shimmering hi hats 1
- soft double bass 1
- traditional 1
- wooden percussions 1
musiccaps_names (array) 16 ✖
- Music 3
- Bluegrass 2
- Country 2
- Accordion 1
- Banjo 1
- Drum 1
- Flamenco 1
- Music of Latin America 1
- Musical instrument 1
- Orchestra 1
- Percussion 1
- Singing 1
- Speech 1
- Tabla 1
- Traditional music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Saleem Javeed qawwali Nizampur part 1 | The low quality recording features a live performance of a traditional song and it consists of an echoing male vocal singing over acoustic strings melody, plucked strings melody and wooden percussion. There is a crowd chattering noise in the background. The recording is a bit noisy and it sounds passionate. | 2014-08-05T20:41:31Z | KOKAN MEHFIL-E-QAWWALI | Everyone should watch the video | ["Tabla", "Drum", "Percussion"] | ["low quality", "echoing male vocal", "acoustic strings melody", "crowd chattering", "wooden percussions", "plucked strings melody", "live performance", "traditional", "noisy", "passionate"] | 4 | -6QGvxvaTkI | 15 | |
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 | |
Blind Pilot "Three Rounds and a Sound" (3 of 4) Indie Pop from Portland, OR | The low quality recording features a live performance of an indie song and it features a passionate male vocal singing over acoustic rhythm guitar and soft double bass, There are laughing and crowd chattering noises in the background. It sounds emotional and sad, even though the recording is a bit noisy. | 2010-03-17T20:59:05Z | One Night Music | One Night Music recorded Blind Pilot at Muddy Waters Cafe in Santa Barbara, CA on August 1, 2009. Find all 4 videos and a story at: http://www.onenightmusic.com/blog/post/love-at-muddy-waters-rey-villalobos-and-blind-pilot/ Filmed and edited by Megan Sullivan Audio editing by Ryan Andersen Filmed with VADO HD, audio with Zoom H2. Follow us: http://www.twitter.com/onenightmusic http://www.facebook.com/onenightmusic http://www.onenightmusic.com One Night Music is a San Francisco based collective of volunteers creating high quality video and audio recordings of live performances by quality independent music artists. Learn how to record with us or how to volunteer with us at http://www.OneNightMusic.com/about | ["Country", "Flamenco", "Music", "Bluegrass", "Vocal music"] | ["low quality", "indie", "live performance", "noisy", "passionate male vocal", "acoustic rhythm guitar", "soft double bass", "crowd chattering", "laughing", "passionate", "emotional", "sad"] | 4 | QtjMlA_7dds | 2647 | |
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 |
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;