musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "urban"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- instrumental · 3 ✖
- urban · 3 ✖
- electronic drums 2
- energetic 2
- no singer 2
- breakbeat 1
- dance 1
- danceable 1
- drum & bass 1
- electronic dance music 1
- electronic music 1
- high tempo 1
- hip 1
- loud electronic drums 1
- modern 1
- pad 1
- piano sound 1
- strings 1
- strong bass 1
- synth bass 1
- techno trance 1
- wobbly bass 1
musiccaps_names (array) 9 ✖
- Music 2
- Electric piano 1
- Electronic music 1
- Electronica 1
- Keyboard (musical) 1
- Piano 1
- Rapping 1
- Tire squeal 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DJ Splash , DJ Inphinity , Capella on keyboard | This is a techno trance music piece being performed on the keyboard. It is an instrumental piece. Initially, a brief tune is being played with the piano sound. Then, a wobbly bass and an electronic drum beat starts playing. The atmosphere is energetic and the sound is urban. This piece could be used in the soundtrack of a mobile car racing game. | 2009-03-21T20:02:39Z | music01234567 | Here i'm trying to play the following songs: DJ Splash-Always and forever (From 2:12-3:12 ??? I just got carried away) DJ Splash-Crying soul DJ Inphinity-12 inch Capella-You got to let the music Hope you like it : ) | ["Electric piano", "Keyboard (musical)", "Piano"] | ["techno trance", "no singer", "instrumental", "piano sound", "wobbly bass", "electronic drums", "energetic", "urban", "danceable"] | 9 | 6XZGmRuaOfo | 765 | |
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 | |
Musica Electronica 2010 | This is a drum & bass electronic music piece. There is no singer. There is a strong and fuzzy feeling bass sound. The rhythmic background consists of a loud and high tempo electronic drum beat. The atmosphere is modern and energetic. This piece could be playing at a nightclub or a dance club. | 2009-12-17T19:53:49Z | DJCRIVIER | Tema inspirado por el Ondelios Concept de Renault | ["Electronic music", "Music", "Trance music", "Electronica"] | ["drum & bass", "electronic music", "no singer", "instrumental", "strong bass", "loud electronic drums", "energetic", "urban", "modern", "high tempo"] | 9 | FFQVVwFjy7s | 1630 |
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;