musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic music", musiccaps_aspects contains "passionate" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- electronic music · 2 ✖
- medium tempo 2
- passionate · 2 ✖
- buddha music 1
- church bells 1
- dance club 1
- dance rhythm 1
- discotheque 1
- dj 1
- electronic dance music 1
- electronic harmony tones 1
- emotional 1
- energetic 1
- exciting 1
- experimental 1
- female singer 1
- flute playing 1
- groovy 1
- groovy drumming rhythm 1
- groovy mood bass line 1
- instrumental music 1
- lounge music 1
- lounge techno music 1
- male and female vocals 1
- moog bass 1
- music production 1
- oriental music 1
- people dancing 1
- quirky 1
- radio buzzing tones 1
- relaxing 1
- relaxing playlist 1
- retro pop music 1
- romantic 1
- steady drumming rhythm 1
- strong bass line 1
- techno dance music 1
- various frequency tones 1
- vocal monologue 1
- youthful 1
musiccaps_names (array) 8 ✖
- Music 2
- Buzz 1
- Drum and bass 1
- Drum machine 1
- Electronica 1
- Rhythm and blues 1
- Sampler 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
KING Q4 Love Buzz | A female singer sings this vocal monologue. The song is medium tempo with a groovy moog bass line, electro mix keyboard harmony tones, steady drumming rhythm and very quirky electronic tones. The song is groovy and retro dance music. | 2011-07-16T11:15:03Z | KINGQ44 | http://kingq4.bandcamp.com/ http://itunes.apple.com/fr/album/love-buzz-ep/id357022549 King Q4 Love Buzz Help me records 2010 composed by Shocking Blue arranged by King Q4 mixed by Raphael Seguin | ["Sampler", "Drum and bass", "Music", "Techno", "Buzz", "Drum machine", "Electronica"] | ["female singer", "retro pop music", "moog bass", "medium tempo", "energetic", "experimental", "quirky", "romantic", "youthful", "passionate", "people dancing", "dance club", "dance rhythm", "discotheque", "music production", "electronic music", "steady drumming rhythm", "dj", "radio buzzing tones", "various frequency tones", "groovy mood bass line", "dance rhythm", "emotional", "vocal monologue", "electronic harmony tones"] | 1 | dAAwzwexvUQ | 3767 |
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;