musiccaps_details (view)
2 rows where musiccaps_aspects contains "intense" and musiccaps_names contains "Background music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- instrumental 2
- intense · 2 ✖
- ardent 1
- boomy bass lines 1
- catchy 1
- cello 1
- chimes 1
- edm 1
- eerie 1
- electronic music 1
- electronic sound arrangements 1
- energetic digital drum 1
- fast tempo 1
- frightening 1
- grim 1
- groovy 1
- harpsichord 1
- heavy 1
- horror movie soundtrack 1
- keyboard harmony 1
- perky 1
- punch bass line 1
- sinister 1
- slow tempo 1
- spike chilling 1
- spooky 1
- surround sound 1
- synth pop instrumental 1
- synthesiser arrangement 1
- viola 1
- violin harmony 1
- violin symphony 1
- vivacious 1
musiccaps_names (array) 5 ✖
- Background music · 2 ✖
- Music 2
- Ambient music 1
- Electronica 1
- Scary music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PP,PE film crushing washing drying pelleting.mpg | This music is an instrumental. The tempo is fast with a keyboard harmony, boomy bass lines, chimes and electronic arrangements. The music is catchy, perky, vivacious, groovy, intense and ardent. This music is a Synth pop instrumental. | 2012-02-17T13:03:33Z | droway86 | We are manufacturer of waste plastic processing machines, If you have any questions ,Please contact us: www.recycle-way.com,mail:sales@recycle-way.com,TEL:008613794959740 | ["Background music", "Music", "Ambient music", "Electronica"] | ["instrumental", "fast tempo", "groovy", "synth pop instrumental", "catchy", "perky", "intense", "ardent", "surround sound", "boomy bass lines", "vivacious", "synthesiser arrangement", "chimes", "punch bass line", "edm", "electronic music", "electronic sound arrangements", "energetic digital drum"] | 7 | TcJ7rdYMHiQ | 2852 | |
タワー・オブ・テラーBGM | This music is instrumental. The tempo is slow with an intense violin harmony with heavy bass cello. The music is intense, serious, grim, spooky, eerie, terrifying and spine chilling and sounds like the soundtrack of a horror movie. | 2011-03-05T07:27:08Z | TheDisney0304 | ["Background music", "Music", "Scary music"] | ["instrumental", "slow tempo", "violin harmony", "cello", "viola", "keyboard harmony", "violin symphony", "harpsichord", "intense", "heavy", "sinister", "grim", "spooky", "eerie", "frightening", "spike chilling", "horror movie soundtrack"] | 7 | sGM6xX5laFU | 4935 |
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;