musiccaps_details (view)
5 rows where musiccaps_aspects contains "bass guitar" and musiccaps_names = "["Music", "Ska"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
The Videos - Trickle Trickle | This is a doo wop music piece. There are male vocals singing melodically. The main tune is being played by the electric guitar and the keyboard while the bass guitar is playing in the background. The rhythm is provided by the acoustic drums. The atmosphere is danceable and joyful. This piece could be playing at a dance club for an oldies night. | 2009-03-10T17:37:32Z | chargertom | Oldies favorite "Trickle Trickle" by The Videos. Another record selection from the Oldies Jukebox at www.fhs1961.com | ["Music", "Ska"] | ["doo wop", "rock", "male vocals", "melodic singing", "electric guitar", "bass guitar", "keyboard", "acoustic drums", "danceable", "energetic", "joyful"] | 9 | KV99GJg0tvA | 2089 | |
Ska music band Skalingrad United Skajana | The ska music features a male voice singing and being accompanied by another male backing vocal. The tempo is medium-fast, specific to the ska genre. The drums play a somewhat busy rhythm and the bass guitar plays a simple repeating bass line. In the background a piano accompanies the singer. Towards the end of the music excerpt a saxophone can be heard. | 2013-07-12T17:09:02Z | tunapavel | Skalingrad United - original ska music from The Czech republic. Moreover - www.skajana.cz | ["Music", "Ska"] | ["male voice", "male backing vocal", "piano", "bass guitar", "drums", "ska genre", "medium-fast tempo", "saxophone"] | 2 | WPguqXCBQCI | 3092 | |
Jah prayza-Ngoda | This is an afrobeat music piece. There is a male vocalist singing playfully in the lead. The electric guitar is playing a groovy melody with the bass guitar playing in the background. The rhythm is being played by the acoustic drums. The atmosphere is cheerful. This piece could be used in the soundtrack of a feelgood movie taking place in Africa. | 2013-10-09T16:24:49Z | Edmore Chizororo | Jah Prayza the beast, the best!!! Good work | ["Music", "Ska"] | ["afrobeat", "male vocal", "playful singing", "electric guitar", "bass guitar", "acoustic drums", "cheerful", "chill", "easygoing"] | 9 | asYb6iDz_kM | 3583 | |
Maskatesta - Castillos de Juguete [This Is Ska] | This is a ska punk music piece. There is a male vocalist with a raspy voice singing in the Spanish language. The keyboard and the electric guitar are playing the melody while there is a bass guitar playing in the background. The rhythm consists of fast tempo acoustic drum beats. The atmosphere is lively. This piece can be played at sports venues. | 2010-08-11T05:34:43Z | REBORracho7 | Esta es una de las rolas del nuevo disco de la maskatesta... This Is Ska!!! | ["Music", "Ska"] | ["ska punk", "male vocal", "raspy voice", "spanish language", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "lively", "danceable", "upbeat"] | 9 | nyLpME6YH20 | 4597 | |
Melbourne Ska Orchestra - The Best Things In Life Are Free | A male singer sings this jazz melody with the backup singer in vocal harmony. The song is medium tempo, with saxophone harmony, ska drumming rhythm and a good bass line. The song is entertaining and groovy. The song is a classic jazz tune played in ska style. | 2012-12-06T06:35:18Z | Melbourne Ska Orchestra | The Melbourne Ska Orchestra's take on 1920's classic, "The Best Things In Life Are Free" from their 2013 self-titled album. Available here: https://abcmusic.lnk.to/MelbourneSkaOrchestra This music video was filmed at the legendary Allan Eaton Studios in Melbourne, Australia and features vocalist Pat Powell. The track featured on Freeview Australia's national TV campaign with Melbourne Ska Orchestra Conductor/MC Nicky Bomba and members of the orchestra. www.melbourneskaorchestra.com Video Clip produced by Bison Films and Clayton Jacobson | ["Music", "Ska"] | ["male singer", "reggae music", "ska band", "dance rhythm", "people dancing", "band recording", "classy", "medium tempo", "guitar accompaniment", "bass guitar", "saxophones harmony", "backup singer", "vocal harmony", "groovy bass line", "jazz music", "funky jazz", "percussive horn section", "joyful", "passionate", "medium tempo", "syncopated vocals", "ska orchestra", "jazz hits", "life’s truths"] | 1 | xUVvBF9BWdg | 5333 |
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;