musiccaps_details (view)
3 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "percussion", musiccaps_aspects contains "tambourine" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Funktomas - How G Is The Party | This funk song features a male voice singing the main melody. Other voices sing backing vocals in harmony. A saxophone plays a repetitive melody. This is accompanied by percussion playing a funk beat. The bass plays a funky bassline. A guitar plays muted chords using a tron effect. This song is upbeat and has a happy mood. This song can be played at a retro style disco. | 2011-06-14T20:17:22Z | drean1964 | Label : Goodgroove Records - 2009 - -Select 720p for better sound- "Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use." | ["Funk", "Music", "Exciting music"] | ["funk song", "male voice", "backing voices", "tambourine", "saxophone", "percussion", "guitar", "funk bass", "moderate tempo", "upbeat", "repetitive melody", "guitar tron effect"] | 0 | 4a1a-lmDVaY | 587 | |
LaurelBellydance - Middle Eastern Music & Dance Camp 2011 | This middle-eastern song features a male voice singing the main melody. An oud plays the same melody as the voice. This is accompanied by middle-eastern percussion instruments played with the hands. A tambourine is played to accent the percussion beats. After the voice, the main melody is played on a flute. This is accompanied by a qanun. This song can be played for a belly dance programme. | 2011-09-04T20:49:36Z | LaurelBellydance | www.laurelbellydance.com | ["Folk music", "Music", "Middle Eastern music", "Bluegrass", "Bowed string instrument"] | ["middle eastern song", "flute", "oud", "qanun", "percussion", "tambourine", "song for belly dance", "male voice", "moderate tempo"] | 0 | NHA1l_Czm38 | 2327 | |
Saturday Night Revival Service ,Singing,Shouting, and Praising | This is a low audio clip. This song is a contemporary gospel song. This song features a male voice. This is accompanied by a tambourine and hand claps. The bass plays the root notes of the chords. The piano plays chords and fills. The sounds of the crowd are heard in this clip. The tempo of this song is moderate. | 2011-04-17T06:35:32Z | Joe Estep | sharts rd road good church video people from kentucky such as wayne Gifford and his people from his church for A 3 day revival service.praising the Lord Jesus Christ 4-15-2011 holiness joe estep | ["Singing", "Music", "Tambourine"] | ["low quality audio", "percussion", "contemporary gospel song", "hand claps", "crowd noise", "tambourine", "bass guitar", "male voice", "piano", "moderate tempo"] | 0 | kAE7Ceg4VgQ | 4303 |
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;