musiccaps_details (view)
2 rows where musiccaps_aspects contains "arpeggiated synth lead melody", musiccaps_aspects contains "low quality" and musiccaps_author = 4
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- arpeggiated synth lead melody · 2 ✖
- low quality · 2 ✖
- claps 1
- distorted filtered synth bass 1
- echoing female vocal 1
- groovy bass 1
- muffled 1
- outdoor atmosphere 1
- pop 1
- pulsating synth keys 1
- punchy kick 1
- seductive female vocal 1
- simple hi hats 1
- skateboard sound effects 1
- sustained synth melody 1
- traffic sound effect 1
- wind sound effect 1
musiccaps_names (array) 5 ✖
- Music 2
- Cacophony 1
- Electronica 1
- Music of Asia 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 |
---|---|---|---|---|---|---|---|---|---|---|
Selena Gomez Make Over Photoshop | The low quality recording features a pop song that consists of seductive female vocal singing over arpeggiated synth lead melody, pulsating synth keys, sustained synth melody, punchy kick, claps, simple hi hats and groovy bass that glues everything together. It sounds a bit muffled, probably because of the quality of the mix. | 2009-04-06T19:15:08Z | eclipseprodutions | Putting a little make up and erasing some imperfections with photoshop in a photo of sel gomez(: | ["Music of Asia", "Music", "Rhythm and blues"] | ["low quality", "pop", "arpeggiated synth lead melody", "pulsating synth keys", "sustained synth melody", "punchy kick", "claps", "groovy bass", "seductive female vocal", "simple hi hats", "muffled"] | 4 | 3m4QSVVBMss | 498 | |
LONGBOARD - SALVADOR TOUR 2012 - DIEGO POLITO E VICTOR GARDELLIM | The low quality recording features a distorted, filtered synth bass, echoing female vocal, arpeggiated synth lead melody playing, while there are outdoor sound effects like wind blowing, traffic, skateboard driving in the background. It sounds like a compilation of cool skateboard tricks. | 2012-09-11T18:12:36Z | Diego Polito | Longboarders: Diego Polito e Victor Gardellim Imagens: Victor Gardellim, Diego Polito, Nathalia Savassa e Giovanna Oliveira Edição: Diego Polito Apoio: Surfavel Surfboards, US Boards e Priority Longboard Agradecimentos: Victor Gardellim e Nathalia Savassa por darem toda a assistencia necessaria em Salvador, a Surfavel Surfaboards, US Boards que apoiam o Longboard Brasileiro. | ["Music", "Cacophony", "Electronica"] | ["low quality", "distorted filtered synth bass", "echoing female vocal", "arpeggiated synth lead melody", "outdoor atmosphere", "skateboard sound effects", "wind sound effect", "traffic sound effect"] | 4 | MsjeOXuUYG4 | 2305 |
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;