musiccaps_details (view)
3 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "percussion" and musiccaps_aspects contains "shaker"
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 |
---|---|---|---|---|---|---|---|---|---|---|
reggaeton romantico mix 2009 | This reggaeton song features a male voice singing the main melody. This is accompanied by other male voices singing backing vocals. The percussion plays only in the second half of the song. The beat is a reggae beat. A shaker plays a rhythm in the beginning of the song when the main voice sings. Synth sounds are played in the beginning of the song. This synth plays a harpsichord voice. Synth strings are also played in between lines in the song. This song can be played in a club. | 2009-01-09T00:50:08Z | DJAZOGUES | reggaeton romantico | ["Afrobeat", "Music", "Rapping", "Hip hop music"] | ["reggaeton", "percussion", "lead male voice", "male backing voices", "shaker", "moderate tempo", "synth sounds", "hip-hop feel", "dance song", "romantic mood"] | 0 | 9oiSwXk8Nsk | 1045 | |
Joe Torres - The Godfather Of Latin Jazz | The marimba takes the lead melody along with an acoustic piano providing some underlining jazzy chords with a lot of changes. The upright bass sounds round and quiet. The acoustic elements are providing latin grooves. The instruments are all slightly panned to the left and right side of the speakers. This song may be playing in an elevator. | 2012-12-28T23:49:18Z | Raul Rico | Joe Torres and his "Cool Latin Jazz Quartet" - Joe Torres - vibes; Cocho Arbe - piano; Jiovanni Cofino - bass & Leandro Mena - congas Available for all Occasions (703) 324-1224 Joe@coollatinjazz.com | ["Jazz", "Music", "Musical instrument", "Vibraphone"] | ["latin/bossanova", "marimba", "upright bass", "shaker", "percussion", "acoustic piano", "uplifting energy", "moderate tempo"] | 6 | CwHSb1NOi4c | 1414 | |
Cairo Egyptian Folk Song | This Middle eastern folk song features a male singer singing the main melody. This is accompanied by percussion playing a simple beat. A stringed instrument plays the backing melody. A shaker plays in an eight note pattern. This song can be played at a village fair. | 2007-12-07T00:49:47Z | evanmurph1 | Cairo Egyptian Folk Song | ["Folk music", "Music", "Rattle (instrument)"] | ["middle eastern folk music", "low quality audio", "percussion", "shaker", "stringed instrument", "moderate tempo", "male voice"] | 0 | yYpfb_xV--4 | 5417 |
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;