musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic music" and musiccaps_aspects contains "techno dance music" sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- electronic dance music 2
- electronic music · 2 ✖
- techno dance music · 2 ✖
- buddha music 1
- church bells 1
- distorted tones 1
- dj 1
- dubstep music 1
- exciting 1
- flute playing 1
- groovy 1
- groovy drumming rhythm 1
- grunge keyboard tones 1
- instrumental music 1
- instrumentals music 1
- lounge music 1
- lounge techno music 1
- male and female vocals 1
- medium tempo 1
- oriental music 1
- overdriven keyboard harmony 1
- passionate 1
- poor audio quality 1
- relaxing 1
- relaxing playlist 1
- rubbing tones 1
- steady drumming rhythm 1
- strong bass line 1
- synth string pad section 1
- techno drumming rhythm 1
musiccaps_names (array) 4 ✖
- Music 2
- Dubstep 1
- Electronic music 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Baile de Dubstep | The song is an instrumental. The song is medium tempo with a slick drumming rhythm, grunge keyboard tones, overdriven synth tones and string pad section. The song is groovy and exciting. The audio quality is poor in general. | 2013-03-08T02:22:05Z | Rafael Chávez | Mira mi nuevo video y aprende 3 pasos sencillos https://www.youtube.com/watch?v=nhlQRS4vDYo | ["Electronic music", "Music", "Dubstep"] | ["instrumentals music", "dubstep music", "overdriven keyboard harmony", "poor audio quality", "dj", "electronic music", "grunge keyboard tones", "steady drumming rhythm", "distorted tones", "synth string pad section", "electronic dance music", "techno drumming rhythm", "techno dance music", "rubbing tones"] | 1 | MP7KPlqoQW0 | 2262 | |
ILLY NOISE - Voyage | The song is an instrumental with a smattering of female and male vocals. The song is medium tempo with a groovy drum rhythm, church bell accompaniment, slick percussion hits, sustained bass hits, flute playing and vocal chants. The song is relaxing. The song is a techno lounge tune. | 2014-11-28T08:00:03Z | inversic. | ILLY NOISE - Voyage Subscribe for Daily Music ► [http://bit.do/ParadoxiumMusic] Submit Track: [http://www.paradoxium.net/submit-track] Stay Connected » Facebook: http://on.fb.me/1vpsoe0 » Twitter: http://goo.gl/J6Jvnz » Soundcloud: http://goo.gl/dqulbq Purchase Track: / Free Download: https://soundcloud.com/xxx/illy-noise-voyage ▼ Follow https://www.youtube.com/user/illynoisemusic https://www.facebook.com/illynoiseofficial http://www.twitter.com/illynoisemusic https://soundcloud.com/illynoise Picture By: ReneAigner http://reneaigner.deviantart.com/art/The-Narrow-Sea-272550570 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Paradoxium only uploads music along with pictures for the entertainment of others. If any label or artist of either the song or picture removed, Please do not strike the video, ask to have it removed via email, which will be done ASAP paradoxiumsounds@outlook.com | ["Music", "Rhythm and blues"] | ["oriental music", "techno dance music", "electronic music", "relaxing playlist", "flute playing", "male and female vocals", "medium tempo", "groovy drumming rhythm", "strong bass line", "lounge techno music", "electronic dance music", "lounge music", "buddha music", "exciting", "passionate", "relaxing", "groovy", "instrumental music", "church bells"] | 1 | AUPmWhim37Y | 1121 |
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;