musiccaps_details (view)
2 rows where musiccaps_aspects contains "badly tuned strings"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- badly tuned strings · 2 ✖
- medium tempo 2
- amateur musician 1
- bad music 1
- banjo learning video 1
- banjo lessons 1
- banjo player 1
- beginner 1
- cello playing 1
- cheerful 1
- discordant harmonies 1
- groovy cello bass 1
- groovy rhythm 1
- happy 1
- home video 1
- indie music 1
- instrumental music 1
- learning to play 1
- male singers 1
- music video 1
- musicians diary 1
- offbeat 1
- old world charm 1
- playing out of time 1
- poor quality audio 1
- poor video quality 1
- psychedelic pop 1
- quirky and eccentric 1
- story telling 1
- strumming guitars 1
- strumming rhythm 1
- vocal harmony 1
musiccaps_names (array) 8 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
George Formby - Leaning on a Lampost Solo (Normal Speed and Slowed Down) | The song is an instrumental. The tempo is medium and sometimes glitch out if time, with a banjo being played by a beginner. The song is amateurish in quality and not pleasant. The song audio quality is very poor. | 2013-01-26T14:37:58Z | AngusLUkulele | Hope this video helps! | ["Banjo", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["home video", "music video", "banjo learning video", "strumming rhythm", "beginner", "banjo lessons", "amateur musician", "learning to play", "musicians diary", "poor quality audio", "playing out of time", "badly tuned strings", "instrumental music", "bad music", "banjo player", "medium tempo"] | 1 | HrPnGYGrvm0 | 1839 | |
Strobe Light by Luke Janela - Cello Rock Music | Male singers sing this vocal harmony. The song is medium tempo with steady drumming rhythm, cello playing the bass line, guitars strumming rhythm and various percussion hits. The song is chaotic and exciting. The song is an amateur band playing a retro pop song with audio quality. | 2009-10-14T23:46:39Z | Luke Janela | Buy the album, REDWOOD SUMMER on iTunes at: http://itunes.apple.com/us/album/redwood-summer/id336710013 or order the cd at: http://www.cdbaby.com/cd/lukejanela5 Cellist/Songwriter Luke Janela performs the song "Strobe Light" off his album REDWOOD SUMMER. | ["Music", "Punk rock", "Independent music", "Psychedelic rock"] | ["cello playing", "discordant harmonies", "offbeat", "groovy rhythm", "old world charm", "indie music", "poor video quality", "male singers", "vocal harmony", "strumming guitars", "medium tempo", "groovy cello bass", "quirky and eccentric", "badly tuned strings", "cheerful", "happy", "story telling", "psychedelic pop"] | 1 | oYECB7KFJgU | 4639 |
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;