musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "upbeat" and musiccaps_names contains "Dance music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- energetic · 2 ✖
- house 2
- upbeat · 2 ✖
- club music 1
- dance 1
- dance pop 1
- danceable 1
- disco music 1
- electronic 1
- electronic drums 1
- female vocal 1
- loud electronic drums 1
- no singer 1
- remix 1
- repeated sample 1
- strong bass 1
- synth 1
- turntable 1
musiccaps_names (array) 4 ✖
- Dance music · 2 ✖
- Music 2
- Disco 1
- Exciting music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
I'm Sexy and I Know It (Official Music Video).By:THECARSIBESIKTAS1903 | This is a house music piece. There is a synth with a crisp sound playing the melody while a lot of turntable scratches can be heard in the background. An electronic drum beat with lots of snare beat repeat sounds provide the rhythm. The atmosphere is energetic and upbeat. This piece could be played at nightclubs or dance clubs. | 2011-12-19T14:18:44Z | TheCarsiBesiktas1903 | The New Video from LMFAO | ["Music", "Dance music", "Exciting music"] | ["house", "disco music", "no singer", "electronic", "synth", "turntable", "electronic drums", "energetic", "dance", "upbeat", "club music"] | 9 | 9PMoI31ncIs | 1001 | |
Sia - The Girl You Lost To Cocaine | This is a house remix of a pop music piece. The female vocal from the original track is being repeated as a sample. There is a strong bass and a loud electronic drum beat in the background. The piece is upbeat and energetic. It could be played at nightclubs, dance clubs and DJ performances. | 2008-03-07T17:33:57Z | miiraah1984 | (Stonebridge Edit) With Lyrics | ["Disco", "Music", "Dance music"] | ["house", "dance pop", "remix", "female vocal", "repeated sample", "strong bass", "loud electronic drums", "upbeat", "energetic", "danceable"] | 9 | YZH-PZBir3E | 3293 |
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;