musiccaps_details (view)
1 row where musiccaps_aspects contains "trumpets", musiccaps_names contains "Ska" and "youtube_published" is on date 2012-04-08
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Best Selection (1) of Old School Ska & Original Reggae 1960's (Vinyl Recordings) Vol. 1 | This ska song features a flute playing the main melody. Other flutes play staccato notes in the background. This is backed by trumpets playing chords in the background. The percussion plays a simple beat in common time. The double bass plays a 12-bar blues style bassline. There are no voices in this song. This is an instrumental. This song can be played at a Broadway event. | 2012-04-08T17:15:32Z | Oscar | Best Selection of Old School Ska & Original Reggae 1960's (Vinyl Recordings) Vol. 1 This is the first of two volumes, a really old compilation that we think my dad bought on cassette in the early 80's from Gaz Mayalls dad at a market stall in Camden. Some nice old school ska and reggae, This lot of music came from Vinyl, was recorded onto cassette and then onto CD, to the computer. hence the sound quality is a bit crackly and truly original! See comments for track listing :) Enjoy! | ["Music", "Ska"] | ["ska song", "flute", "trumpets", "double bass", "percussion", "no voices", "instrumental", "moderate tempo"] | 0 | O40E8bpmONQ | 2396 |
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;