musiccaps_details (view)
3 rows where musiccaps_aspects contains "dance music", musiccaps_aspects contains "female voice", musiccaps_aspects contains "moderate tempo" and musiccaps_author = 0
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 |
---|---|---|---|---|---|---|---|---|---|---|
Midtown Music Traditional Salsa | This salsa song features a female voice singing the main melody. This is accompanied by the congas. The beat is a dance beat. Trumpets and a saxophone play fills in between lines. A piano plays a melody at the end of the song. The song starts with the voice singing a melody at a moderate tempo. After the piano plays, the tempo of the song increases. Other instruments cannot be heard as the quality of the recording is low. This song can be played in a Latin dance sequence in a movie. | 2011-10-27T17:36:40Z | MidtownMusicUK | http://www.midtownmusic.co.uk Midtown Music Agency is a bespoke music service based in Midtown London, Supplying the top event acts in the country. | ["Music", "Salsa music"] | ["low quality recording", "salsa song", "congas", "saxophone", "trumpet", "piano", "female voice", "moderate tempo", "dance music", "seductive rhythm"] | 0 | CN2QSmhP-HI | 1358 | |
Best House Music In The World [Turn It Around] | This house music features a female voice singing the main melody. This is accompanied by programmed percussion playing a simple beat. The kick is played on every count. Hand claps are played at every alternate count. The bass plays the root notes of the chords. Synth chords are played in the background. This song can be played at a club. | 2009-07-22T20:45:27Z | ALBANIITY | The nEwW BeAtt Off BEst HoUsee MUSiiC iN ThE WOrLDD It iS FroOm A FaMouSs DJ --He LivvEEs in LA LetSSs ReAAddyy FooR HooUseee club hits my first megamix Best house music top house music top electro house best electro house top tribal house best tribal house new house music house music 4 ever hot house music new tribal house best latin house top latin house best prog house hot prog house i love house music megamix number 1 mixed by foOtBaLl7PlaYa | ["Disco", "House music", "Music"] | ["house music", "party music", "female voice", "hand claps", "programmed percussion", "synth sounds", "bass", "moderate tempo", "dance music"] | 0 | ICcASgMtIJ8 | 1879 | |
shakira dance moves | This audio clip features a female voice singing the main melody. The quality of the audio recording is low. The voice is accompanied by Latin style percussion. Male voices sing backing vocals. This is a dance song at a moderate tempo. The sound of a camera shutter is played at the beginning and end of the clip. Other musical instruments are barely audible due to the low quality of audio recording. | 2009-01-10T04:01:19Z | abundatia | dancing shakira | ["Music", "Single-lens reflex camera", "Inside, small room"] | ["low quality recording", "female voice", "latin percussion", "male backing voices", "moderate tempo", "dance music", "camera shutter sound"] | 0 | MEew7OQ17HY | 2249 |
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;