musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "music" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- instrumental · 2 ✖
- music · 2 ✖
- altai instruments 1
- altai music 1
- beep 1
- boisterous 1
- boisterous unrelated 1
- chain saw 1
- chaotic 1
- deafening 1
- dissonant 1
- dissonant unrelated 1
- distorted sounds 1
- engine 1
- fast tempo 1
- folk music 1
- medium fast tempo 1
- multiple tracks playing 1
- native instruments 1
- noisy 1
- nomads 1
- running 1
- shakers 1
- superimposed tracks 1
- swishing sound 1
- telephone busy signal 1
- traditional music 1
- trumpets 1
- unpleasant 1
- vigorous 1
musiccaps_names (array) 5 ✖
- Music 2
- Chainsaw 1
- Folk music 1
- Outside, rural or natural 1
- Roll 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chainsaw art time lapse | This is a multi track audio. There are several things happening. There’s an energetic song in the background with enthusiastic vocals, drumming and trumpets. There’s a loud whirring of an engine, like a chain saw, beeps and a phone dial tone. The audio is loud, confusing, chaotic, boisterous,unrelated , noisy, loud, dissonant and unpleasant. | 2008-06-17T18:46:38Z | dtremko | Four days of carving in 2 minutes | ["Chainsaw", "Music", "Roll"] | ["instrumental", "fast tempo", "engine", "vigorous", "dissonant", "unpleasant", "superimposed tracks", "distorted sounds", "dissonant unrelated", "boisterous", "noisy", "chain saw", "music", "beep", "telephone busy signal", "running", "multiple tracks playing", "trumpets", "noisy", "chaotic", "boisterous unrelated", "deafening", "unpleasant"] | 7 | 7TmKzUgWiRU | 848 | |
The Altai band - Uvgudiin Zahias by GANPUREV Dagvan | This music is an Altai instrumental. The tempo is medium fast with use of traditional and regional instruments. There is use of a droning stringed instrument, shakers and wind instruments. The music is incessant droning, pleasant, unique, close to nature and simple. | 2013-10-11T11:10:58Z | musicagencymn | "ALTAI" - Mongolian folk dance and music band. Title - "Uvgudiin Zahias" composed by GANPUREV Dagvan produced by GANPUREV Dagvan Music - production by Mongolian Music Agency Video - production by LEVEL Studio more www.musicagency.mn | ["Folk music", "Music", "Outside, rural or natural"] | ["instrumental", "medium fast tempo", "shakers", "nomads", "folk music", "native instruments", "swishing sound", "traditional music", "altai music", "altai music", "altai instruments", "music"] | 7 | HrwpdRe7meM | 1841 |
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;