musiccaps_details (view)
2 rows where musiccaps_aspects contains "background music", musiccaps_aspects contains "instrumental" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- background music · 2 ✖
- instrumental · 2 ✖
- ambient nature sounds 1
- ambient sounds 1
- amplified guitar 1
- attack 1
- birds chirping loudly 1
- brass instruments 1
- classic rock 1
- electric guitar harmony 1
- food 1
- grunting 1
- heavy rock 1
- hunt 1
- incoherent backup music 1
- loud feedback 1
- metal 1
- painful cry 1
- prey 1
- roaring 1
- rock 1
- scuffling 1
- sinister cello drone 1
- slow tempo 1
- sonic power 1
- squealing 1
- stringed instrument 1
- struggle 1
- subdued background music 1
- tense melody 1
- trumpet melody 1
- wild animals 1
- wild boar 1
- wild life 1
- wildlife 1
- wolf pack 1
- wolves attacking 1
- wolves growling 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
EHYLT lobos cazan jabali.avi | This audio is an instrumental playing in the background. The music is sinister and anticipatory of something bad. There are ambient sounds of nature like roaring, grunting, scuffling, wild boar squealing,birds chirping loudly and painful cries, indicative that this is an animal being hunted. | 2011-05-02T11:43:23Z | Candido Vicente | El hombre y la Tierra | ["Canidae, dogs, wolves", "Roar", "Music", "Pig", "Roaring cats (lions, tigers)"] | ["instrumental", "background music", "birds chirping loudly", "brass instruments", "tense melody", "wolf pack", "trumpet melody", "wild boar", "squealing", "wolves attacking", "wolves growling", "hunt", "wildlife", "wild animals", "prey", "food", "attack", "roaring", "grunting", "scuffling", "struggle", "wild life", "painful cry", "sinister cello drone", "ambient nature sounds"] | 7 | 6ieXDFjLKNo | 778 | |
Marshall JTM-45 Bluesbreaker + Gibson SG + Slide | This music is an electric guitar instrumental. The tempo is slow with an electric guitar harmony and a subdued, incoherent background score. This music is classic Rock. | 2007-01-13T11:30:16Z | Claudio Crotti | JTM-45 Bluesbreaker and Gibson SG Slide | ["Tapping (guitar technique)", "Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["instrumental", "slow tempo", "electric guitar harmony", "classic rock", "incoherent backup music", "background music", "subdued background music", "ambient sounds", "loud feedback", "amplified guitar", "sonic power", "stringed instrument", "rock", "heavy rock", "metal"] | 7 | wLQiZ-0VW4c | 5258 |
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;