musiccaps_details (view)
2 rows where musiccaps_aspects contains "danceable" and musiccaps_aspects contains "house"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- danceable · 2 ✖
- energetic 2
- house · 2 ✖
- dance pop 1
- electric guitar 1
- electronic dance music 1
- electronic drums 1
- electronic percussion 1
- female vocal 1
- female vocals 1
- keyboard 1
- loud electronic drums 1
- melodic singing 1
- remix 1
- repeated sample 1
- strong bass 1
- upbeat 1
musiccaps_names (array) 4 ✖
- Music 2
- Dance music 1
- Disco 1
- Happy music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
If You Could Read My Mind (Lyrics) - Stars On 54 | This is an electronic dance/house music piece. There are female vocals singing melodically. The melody is being played by the keyboard with the electric guitar samples in the background. The rhythm consists of an electronic drum beat and electronic percussive elements. The atmosphere is danceable and energetic. This piece could be used in the soundtrack of a romantic comedy movie, especially during the scenes where a character is hesitating to open up to their crush. | 2013-01-05T01:57:37Z | SERENDIPITYPATTERN | For educational purposes only and no copyright infringement intended. | ["Music", "Happy music"] | ["electronic dance music", "house", "female vocals", "melodic singing", "keyboard", "electric guitar", "electronic drums", "electronic percussion", "danceable", "energetic"] | 9 | r1W1z_31Obw | 4844 |
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;