musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic dance music", musiccaps_aspects contains "instrumental" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- electronic dance music · 2 ✖
- electronic drums 2
- instrumental · 2 ✖
- ambient synth 1
- breakbeat 1
- dance 1
- danceable 1
- hip 1
- melodic pad 1
- no singer 1
- pad 1
- strings 1
- synth bass 1
- trippy 1
- urban 1
musiccaps_names (array) 4 ✖
- Music 1
- New-age music 1
- Rapping 1
- Tire squeal 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1986 mustang GT 5.0 burning out and tearing up the town | This is a breakbeat piece. There is a groovy electronic drum beat providing the rhythmic structure. A medium pitched pad is playing a repeated theme. There is a synth bass in the background. Occasional string stab hits can be heard. This piece could fit well in the soundtracks of crime movies taking place in the city and car racing video games. | 2009-10-17T18:37:44Z | Champalamp Johnson | clownin in como. drifting | ["Music", "Rapping", "Tire squeal"] | ["breakbeat", "electronic dance music", "instrumental", "electronic drums", "synth bass", "pad", "strings", "dance", "urban", "hip"] | 9 | 9TkW1M_ZRr0 | 1010 | |
Need for Speed Most Wanted Secret Area (Trainer Used) | This is an electronic dance music piece. It is an instrumental piece. There is an ambient synth holding a note in the background while a melodic pad is playing the main tune. The rhythmic background consists of a medium tempo electronic drum beat. The atmosphere is danceable and trippy. This piece could be playing in the background at a nightclub or a dance club. It could also work well in the soundtrack of a sci-fi video game with a dystopian future setting. | 2007-05-06T18:56:24Z | himuraBattosi | This is the end game area with the bridge jump, it also shows you whats beyond the bridge. Also I used a trainer in this video. Link to the trainers: http://www.cheathappens.com/show_download.asp?ID=19996 | ["New-age music"] | ["electronic dance music", "no singer", "instrumental", "ambient synth", "melodic pad", "electronic drums", "danceable", "trippy"] | 9 | jXi1dFAB0n8 | 4260 |
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;