musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "saxophones"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- amateur recording · 2 ✖
- saxophones · 2 ✖
- baby shaker toy 1
- bass guitar 1
- classical 1
- drums 1
- fast tempo 1
- male backing vocal 1
- male voice 1
- orchestral 1
- rock and roll genre 1
musiccaps_names (array) 5 ✖
youtube_published (date) 2 ✖
- 2011-02-27 1
- 2012-07-29 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shake, rattle an roll | The rock and roll music features a male voice singing a melody and at times singing in unison with a male backing voice. The band that accompanies the singer consists of a drum kit playing a light and simple rhythm, a bass guitar that plays in the style of walking bass, and a section of saxophones. On top of this recording one can hear a rattle that sounds close to a baby shaker toy. The recording quality is not that good, which leads me to believe it's an amateur phone recording of a speaker playing the song. | 2012-07-29T15:34:40Z | Yvonne Bradt | Sesame street babies | ["Music", "Rattle (instrument)"] | ["male voice", "male backing vocal", "saxophones", "bass guitar", "drums", "amateur recording", "baby shaker toy", "rock and roll genre"] | 2 | Xxe6vTEwFvs | 3240 | |
Introduction et variations sur une ronde populaire, Henri Pierné | This audio contains people playing saxophones in all ranges and with a fast melody. This song may be playing as part of an orchestral performance. | 2011-02-27T00:37:25Z | MichiganSaxStudio | Introduction et variations sur une ronde populaire, Henri Pierné Performance by Echo Saxophone Quartet: Spring 2010 Students of Donald Sinta Dan Graser (2nd year Doctoral at time of recording) Katherine Weintraub (Senior at time of recording) Chris Bartz (2nd year Masters at time of recording) Andy Hall (1st year Masters at time of recording) | ["Brass instrument", "Clarinet", "Saxophone"] | ["amateur recording", "orchestral", "saxophones", "fast tempo", "classical"] | 6 | v5SsASLy2c8 | 5154 |
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;