musiccaps_details (view)
2 rows where musiccaps_aspects contains "reggae/dub", musiccaps_author = 4 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- punchy snare 2
- reggae/dub · 2 ✖
- addictive 1
- chill 1
- easygoing 1
- echoing guitar pedal effects 1
- energetic 1
- flat male vocal 1
- groovy bass 1
- groovy piano chords 1
- low quality 1
- mono 1
- noisy 1
- punchy 808 bass 1
- shimmering cymbals 1
- shimmering hi hats 1
- soft kick 1
- subtle funky electric guitar melody 1
- wide harmonizing male vocals 1
musiccaps_names (array) 7 ✖
- Music · 2 ✖
- /t/dd00032 1
- Keys jangling 1
- Music of Africa 1
- Reggae 1
- Ska 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Admiral Bailey-Jamaica 80`s Reggae Dancehall- AfricanSymbol Sound | The low quality recording features a reggae/dub song that consists of a flat male vocal singing over punchy 808 bass, punchy snare, shimmering hi hats and groovy piano chords. It sounds energetic, groovy and the recording is noisy and in mono - due to the fact that the sound is coming from the right channel only. | 2010-03-14T21:23:50Z | JAPAMAICAN | African Symbol Soundsystem @Damali Beach Montego Bay,Jamaica,31/Aug/1986 featuring Admiral Bailey and More.ジャマイカ80sサウンドのアフリカンシンボル秘蔵の映像。 http://africansymboljamaica.info http://www.myspace.com/africansymbolja ジャマイカ、モンテゴベイのダマリビーチで催されたフレンド・クラッシュUNIFICATIONⅡのラバダブのステージショー。 1986年8月31日収録。 Admiral Bailey,Echo Minott,Lt.Stichie,Lady G, Wolf Man,White Mice,General Leon...etc | ["Keys jangling", "Music", "Reggae", "Ska"] | ["low quality", "reggae/dub", "mono", "noisy", "flat male vocal", "punchy 808 bass", "punchy snare", "shimmering hi hats", "groovy piano chords", "energetic", "addictive"] | 4 | 03z0rpIkm5g | 115 | |
Pappa Music - Brand New Sound (New Sound Riddim) | The Reggae/Dub song features a subtle funky electric guitar melody with echoing guitar pedal effects on, punchy snare, soft kick hits, groovy bass and shimmering cymbals, while the wide harmonizing male vocals are singing over it. It sounds easygoing and chill, like something you would listen to on a beautiful Sunday afternoon. | 2010-11-17T07:41:15Z | PappaMusic | ANOTHER NEW RIDDIM! Just created today, Tuesday Nov. 16, 2010!! The "New Sound Riddim". AND Againnnn i couldnt wait to release this teaser with this incredible rhythm section!!! If any other reggae artists, selectors and/or collectors wanna get ahold of this riddim, GET AHOLD OF ME!! NEW REGGAE MUSIC FOR THE WELL-SEASONED AVID REGGAE LISTINER!! Pappa Music & Crucial Posse - Brand New Sound (TEASER) MP3 DOWNLOAD: http://www.4shared.com/account/audio/0tJ1ZFK2/Pappa_Music_-_Brand_New_Sound.html FACEBOOK: http://www.facebook.com/PappaMusic TWITTER: http://www.twitter.com/pappamusic REVERBNATION: http://www.reverbnation.com/pappamusic RECORDING STUDIO: http://www.dubshackrecordings.blogspot.com/ enjoy! | ["Music of Africa", "Music", "Song", "/t/dd00032"] | ["reggae/dub", "punchy snare", "subtle funky electric guitar melody", "wide harmonizing male vocals", "echoing guitar pedal effects", "shimmering cymbals", "soft kick", "easygoing", "chill", "groovy bass"] | 4 | S_Z7o4OmU30 | 2776 |
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;