musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "synth sounds" and musiccaps_names contains "Disco"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- bass · 2 ✖
- moderate tempo 2
- programmed percussion 2
- synth sounds · 2 ✖
- dance music 1
- dance song 1
- disco song 1
- female voice 1
- hand claps 1
- house music 1
- male voice 1
- party music 1
- romantic theme 1
- upbeat 1
musiccaps_names (array) 4 ✖
- Disco · 2 ✖
- Music 2
- Dance music 1
- House music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Disco polo mix 2009 dj aro | This disco song features a male voice singing the main melody. This is accompanied by programmed percussion playing a disco beat. The kick is played at every count of the bar. The synth changes chords after two bars to a higher pitch chord, then after one bar to a higher pitch chord, then after one more bar to a higher pitch chord and finally after one more bar to a suspended fourth chord. The instruments pause for 3 counts of the bar while the voice continues to sing. The bass plays the root notes of the chords. The mood of this song is romantic. This song can be played in a club. | 2009-02-17T22:19:55Z | 2211557 | Oceniajcie pzdro | ["Disco", "Music", "Dance music"] | ["disco song", "male voice", "synth sounds", "programmed percussion", "bass", "moderate tempo", "upbeat", "romantic theme", "dance song"] | 0 | 1KN3GrwhY8c | 260 | |
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 |
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;