musiccaps_details (view)
2 rows where musiccaps_aspects contains "traffic sound effect" and musiccaps_author = 4 sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- low quality 2
- traffic sound effect · 2 ✖
- arpeggiated acoustic guitar melody 1
- arpeggiated synth lead melody 1
- distorted filtered synth bass 1
- echoing female vocal 1
- emotional 1
- live performance 1
- noisy 1
- outdoor atmosphere 1
- passionate male vocal 1
- people chattering sound effect 1
- skateboard sound effects 1
- wind sound effect 1
musiccaps_names (array) 4 ✖
- Music 2
- Cacophony 1
- Electronica 1
- Flamenco 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
La Rumba Amor de un dia | The low quality recording features a live performance of arpeggiated acoustic guitar melody and passionate male vocal singing over it. There are some people chattering and traffic sound effects, probably because it was recorded outside. The recording is noisy, but it sounds emotional regardless. | 2011-05-14T02:07:48Z | Pamela Hack | A fabulous gypsy flamenco band playing in Bourke Street Mall, Melbourne. Got their Cd and loving it. | ["Flamenco", "Music"] | ["low quality", "live performance", "arpeggiated acoustic guitar melody", "passionate male vocal", "traffic sound effect", "people chattering sound effect", "emotional", "noisy"] | 4 | LgKOnHwaCmg | 2214 | |
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;