musiccaps_details (view)
2 rows where musiccaps_aspects contains "improvisation" and musiccaps_author = 2 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- improvisation · 2 ✖
- brush technique 1
- distortion effect 1
- double bass 1
- drums 1
- electric guitar 1
- jazz genre 1
- low quality audio recording 1
- piano 1
- rock genre 1
- string noise 1
- swing feel 1
musiccaps_names (array) 8 ✖
- Music 2
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Guitar 1
- Harmonic 1
- Jazz 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
jodee frawlee melodic shredding in A harmonic minor/ Aminor | The excerpt features an electric guitar with a distortion effect on playing what sounds to be an improvised passage. The style comes closest to the rock genre. The lower quality of the audio recording coupled with string noises makes me think this is an amateur recording, most probably recorded with a phone. | 2010-11-11T00:32:32Z | jodee Frawlee | Just some shredding w/ an idea I have for a future song | ["Tapping (guitar technique)", "Effects unit", "Electric guitar", "Guitar", "Music", "Harmonic", "Distortion"] | ["electric guitar", "distortion effect", "improvisation", "rock genre", "string noise", "low quality audio recording"] | 2 | XrjkzI6TVwc | 3229 | |
W. Marsalis Quintet & R. Galliano - Sailboat In The Moonlight | The jazz music features a piano improvising with somewhat thick textures. A double bass plays a laid-back melody in the low register, for the most time with one note every two beats. The drummer plays a light rhythm employing a brush technique, rather than using sticks. The music has a swing feel to it. | 2013-03-30T16:50:40Z | swamawi | Wynton Marsalis Quintet & Richard Galliano - Sailboat In The Moonlight Jazz in Marciac Festival 2008 From the album: "From Billie Holiday To Edith Piaf :Live In Marciac CD+DVD" | ["Jazz", "Music"] | ["jazz genre", "improvisation", "piano", "double bass", "drums", "brush technique", "swing feel"] | 2 | qrP_H87vFpo | 4826 |
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;