musiccaps_details (view)
2 rows where musiccaps_aspects contains "keyboard harmony", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "steady drumming"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- keyboard harmony · 2 ✖
- passionate · 2 ✖
- steady drumming · 2 ✖
- youthful 2
- ardent 1
- boomy bass line 1
- cheering 1
- crackling sound 1
- electro pop 1
- electronic music 1
- emotional 1
- energetic 1
- female singer 1
- fervent 1
- impactful 1
- inferior quality audio 1
- inspiring 1
- instrumental 1
- intense electric guitar 1
- intense musical medium tempo 1
- medium tempo 1
- melodic 1
- muffled audio 1
- muffled sounds 1
- people chanting 1
- pleasant 1
- pop rock 1
- rustling sound 1
- soft rock 1
- synth pop 1
- synthesiser arrangements 1
- urgent 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DELIJE - HELL Rises at The NORTH GATES | This song is an instrumental. The tempo is medium with an enthusiastic keyboard harmony, steady drumming and boomy bass lines with rustling , whooshing sounds, muffled voices of people cheering or chanting and crackling sounds. The song is intense, passionate, youthful, inspiring, impactful and fervent. The audio quality is inferior so the music is muddy and incoherent. | 2008-06-02T21:36:25Z | noztankz | What really goes on behind the NORTH GATES of the Marakana.... | ["Music", "Angry music"] | ["instrumental", "intense musical medium tempo", "inspiring", "impactful", "cheering", "muffled sounds", "muffled audio", "crackling sound", "people chanting", "keyboard harmony", "boomy bass line", "steady drumming", "youthful", "energetic", "urgent", "passionate", "fervent", "ardent", "inferior quality audio", "rustling sound"] | 7 | 8WnXfe3ud4E | 924 | |
{Hetalia} Hetaoni: Never enter the mansion. | A female vocalist sings this melodic Soft Rock. The tempo is medium with intense electric guitar harmony, keyboard accompaniment, synthesiser arrangements, steady drumming and subtle bass. The vocals are soft and melodic . The song is passionate, emotional, euphonious, simple, fresh and pleasant. This song is contemporary soft rock. | 2011-12-11T14:23:00Z | kaida55 | ♥Hetalia MEP video♥ ♥Watch in HD ♥ ---------------------- 100+ fav in less than a week? Thanks from everyone who made a part in this video. And again people, thank you so much! Thanks for the 600+ fav in less than a half year time :D Thanks for 1500+ fav! -------------------------------- Parts: 0:00 -- 0:20 hetaliafan41 0:20 -- 0:40 EndlessxRequiem 0:40 -- 1:00 sxrlove06 1:00 -- 1:20 001Dragonheart 1:20 -- 1:40 Irosama0410 1:40 -- 2:00 rose103097 2:00 -- 2:20 XxSilverCharmxX2 2:20 -- 2:40 TimefulAngel 2:40 -- 3:00 Goldenstar7z 3:00 -- 3:20 kaida55 3:20 -- 3:40 melancholywish 3:40 -- 3:56 animerockz290 HetaOni images, and the latest uploads: http://hetaoni.tumblr.com/ | ["Independent music"] | ["female singer", "medium tempo", "intense electric guitar", "keyboard harmony", "steady drumming", "keyboard harmony", "synthesiser arrangements", "electronic music", "electro pop", "synth pop", "melodic", "youthful", "passionate", "emotional", "pleasant", "pop rock", "soft rock"] | 7 | EHm7vLZewS0 | 1542 |
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;