musiccaps_details (view)
5 rows where musiccaps_aspects contains "live recording", musiccaps_aspects contains "poor audio quality" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- live recording · 5 ✖
- poor audio quality · 5 ✖
- live performance 2
- accordion 1
- acoustic guitar 1
- acoustic guitar strumming 1
- alternative rock 1
- ballad 1
- banjo 1
- banjo playing 1
- barnyard 1
- blues rock 1
- cheerful 1
- cheering fans 1
- crowd cheering 1
- crowd clapping 1
- electric guitar lick 1
- emotional 1
- energetic 1
- fast paced 1
- female singing quarter 1
- folk music 1
- fun 1
- happy 1
- harmonies 1
- live country folk band 1
- outside 1
- rock 1
- sad 1
- southern country gospel music 1
- theremin 1
- twangy female vocalist 1
- upbeat 1
- uptempo 1
- vintage european 1
- violins 1
musiccaps_names (array) 19 ✖
- Music · 5 ✖
- Musical instrument 3
- Bowed string instrument 2
- A capella 1
- Classical music 1
- Country 1
- Drum kit 1
- Guitar 1
- Mandolin 1
- Plucked string instrument 1
- Rock and roll 1
- Rock music 1
- Shout 1
- Speech 1
- Steel guitar, slide guitar 1
- Tambourine 1
- Theremin 1
- Violin, fiddle 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 |
---|---|---|---|---|---|---|---|---|---|---|
Dr. Rockzo. "I'm a Rock n Roll Clown" | This is a recording of a live show performance by a rock band. We hear some cheering fans and then the song starts with an electric guitar lick and a bass guitar, and a kick on the drums. The audio quality is muffled and poor. | 2009-04-11T20:25:15Z | starz7007 | Brenden Small and the School of Rock all stars at the Starland Ballroom. 4-4-09. Dr. Rockzo. "I'm a Rock n Roll Clown" from metalocalypse | ["Drum kit", "Music", "Musical instrument", "Rock music", "Shout", "Rock and roll", "Speech"] | ["live recording", "cheering fans", "live performance", "rock", "poor audio quality", "electric guitar lick", "alternative rock", "blues rock"] | 3 | XHczpbtBhk4 | 3171 | |
Quartet "Salut Salon" | This is a live performance by a female vocal quartet. They harmonise their voices and sing in a vibrant and cheerful way. They sing in French. Later, we hear two violins playing in sync as well as an accordion. The recording quality of the audio is poor. | 2009-07-26T14:05:26Z | Dina Anunziata | "Heartache" concert of the Hamburgs quartet "Salut Salon" performed in St.Petersburg, Russia during "Week of Germany" | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument", "A capella"] | ["live recording", "live performance", "female singing quarter", "poor audio quality", "violins", "accordion", "cheerful", "happy", "upbeat", "harmonies", "vintage european"] | 3 | YErpnsceZw8 | 3268 | |
Sam Bush and the Infamous Stringdusters | This is a fun, upbeat country folk song. We hear a banjo player strum rapidly and then go on to do a solo. We hear cheering and clapping fans, intricate basslines and acoustic guitars being rapidly strummed. It's a fun, uptempo song that would be heard in a barnyard. | 2007-08-19T18:07:06Z | Nina | Otis Mountain Festival, Elizabethtown, NY. 8/18/07 | ["Country", "Guitar", "Music", "Musical instrument", "Tambourine", "Plucked string instrument", "Bowed string instrument"] | ["live country folk band", "folk music", "fast paced", "uptempo", "energetic", "banjo playing", "acoustic guitar strumming", "live recording", "poor audio quality", "crowd cheering", "crowd clapping", "fun", "barnyard"] | 3 | puAclKsCbes | 4741 | |
Molly Kennedy Beyond the Rain | This recording was done live, and the audio quality is poor. The style is country gospel or country worship music. There's a banjo being used to play arpeggios, and acoustic guitar strumming. The singer has a twangy and full-bodied female country voice. | 2014-06-04T09:49:19Z | Wellington Lloyd | Molly Kennedy at a birthday party in Bay Roberts N L.. | ["Music", "Mandolin", "Steel guitar, slide guitar", "Vocal music"] | ["live recording", "banjo", "acoustic guitar", "poor audio quality", "southern country gospel music", "twangy female vocalist"] | 3 | qW4kBJsudLI | 4794 | |
Theremin Player on the Subway | This is an emotional ballad played on the theremin. The audio quality is poor, but still we feel the sad and sombre effects of the melody played by the performer. | 2012-08-01T06:10:15Z | Jijo Tomy | Ilamano Plays Theremin in New York Subway. I couldn't pass up the opportunity to video shoot her on my iPhone. At the very end of the song, a plain clothes police man came up and told her to stop and move on. He was pretty nice though. Even appreciated her music ;) | ["Music", "Theremin"] | ["live recording", "theremin", "poor audio quality", "emotional", "sad", "outside", "ballad"] | 3 | sL01xTmV_Fc | 4943 |
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;