musiccaps_details (view)
2 rows where musiccaps_aspects contains "uplifting", musiccaps_names contains "Music" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- uplifting · 2 ✖
- electric guitar licks 1
- energetic 1
- flat male vocal 1
- groovy bass 1
- happy 1
- harmonizing background vocals 1
- low quality 1
- metallic snare 1
- noisy 1
- offbeat acoustic rhythm guitar chords 1
- passionate male vocal 1
- punchy snare 1
- reggae 1
- rock 1
- saxophone melody 1
- simple hi hats 1
- simple kick 1
- smooth bass 1
- thin kick 1
- vintage 1
- wide background harmonizing female vocals 1
- wide tinny percussive elements 1
musiccaps_names (array) 7 ✖
- Music · 2 ✖
- Music of Africa 2
- Ska · 2 ✖
- Afrobeat 1
- Funk 1
- Mouse 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Eek A Mouse - Talking About The Business | The Reggae song features a flat male vocal singing, alongside wide background harmonizing female vocals, over metallic snare, simple kick hits, offbeat acoustic rhythm guitar chords, groovy bass, electric guitar licks and tinny percussive elements widely spread in the stereo image. Sounds happy and uplifting, like something you can listen to while chilling at the beach. | 2009-08-17T08:56:37Z | GJW | album: eeksperience release: 2001 label: Rfo Records | ["Afrobeat", "Music of Africa", "Funk", "Music", "Mouse", "Ska"] | ["reggae", "offbeat acoustic rhythm guitar chords", "wide background harmonizing female vocals", "flat male vocal", "groovy bass", "electric guitar licks", "metallic snare", "wide tinny percussive elements", "happy", "uplifting", "simple kick"] | 4 | R5JRh08zgMo | 2666 | |
Edsels - Rama Lama Ding Dong - Youngstown Ohio Doo Wop Sound | The low quality recording features a rock song that consists of harmonizing background vocals, alongside passionate male vocals, singing over, at least, punchy snare, simple hi hats, smooth bass, thin kick and punchy snare hits. The recording is so noisy that the actual song can barely be heard, but regardless it sounds vintage, energetic and uplifting. | 2010-04-13T01:59:16Z | PJDooWop | This is a true doo wop classic, coming to you from the very rare original "Lama Rama Ding Dong" pressing on Dub records. | ["Swing music", "Music of Africa", "Music", "Ska"] | ["low quality", "noisy", "vintage", "harmonizing background vocals", "passionate male vocal", "punchy snare", "saxophone melody", "rock", "simple hi hats", "thin kick", "smooth bass", "uplifting", "energetic"] | 4 | s6U8DtBK3Us | 4925 |
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;