musiccaps_details (view)
3 rows where musiccaps_aspects contains "marching rhythm" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- marching rhythm · 3 ✖
- medium tempo 3
- spirited · 3 ✖
- bad audio quality 1
- badly distorted harmony section 1
- congregational 1
- congregational singing 1
- cymbals crashing 1
- devotional 1
- drummer solo 1
- emotional 1
- enteric 1
- exciting 1
- game play 1
- game soundtrack 1
- groovy 1
- groovy rhythm 1
- guitar rhythm 1
- inspiring 1
- instrumental music 1
- interactive game music 1
- majestic 1
- male singer 1
- motivational 1
- motor running sounds 1
- music game 1
- muslim prayer anthem 1
- national anthem 1
- national fervour 1
- noisy hum 1
- old school music 1
- ominous 1
- passionate 1
- percussive bass line 1
- percussive play 1
- poor audio quality 1
- positive cheerful 1
- prayer 1
- retro pop music 1
- room echoes 1
- royal entry 1
- sense of duty 1
- serious business 1
- singers chanting 1
- snare hits 1
- soldiers match 1
- spirited singing 1
- steady drumming rhythm 1
- story telling 1
- timpani playing percussively 1
- victory march 1
- vintage hits 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PSO2 ルームグッズ 楽器 トライアングル トランペット ヴォーカルマイク サイドギター ティンパニ コントラバス | The song is instrumental. The tempo is medium with timpani’s playing in a marching rhythm with room echoes. The song is energetic and has a sense of duty like a battle march. The song is an interactive game play soundtrack. | 2013-07-17T22:08:26Z | Tom Kannaduki | (C)SEGA 『PHANTASY STAR ONLINE 2』公式サイト http://pso2.jp/ | ["Timpani", "Music"] | ["instrumental music", "interactive game music", "percussive play", "drummer solo", "music game", "game play", "timpani playing percussively", "room echoes", "ominous", "medium tempo", "groovy", "victory march", "majestic", "royal entry", "serious business", "game soundtrack", "passionate", "spirited", "sense of duty", "soldiers match", "marching rhythm"] | 1 | GU782ddSBvk | 1726 | |
الحمام الزاجل في جدة | Singers sing this prayer song in a congregational unison. The song is medium tempo with a heavily distorted harmony section. The song is of very bad quality with humming and whirring noises. | 2007-12-16T14:40:46Z | محمد علي عبدالله هويدي | هذه الحمام من لوفت الحسن والشافعي جدة | ["Music", "Synthetic singing"] | ["bad audio quality", "singers chanting", "devotional", "muslim prayer anthem", "prayer", "medium tempo", "spirited", "inspiring", "congregational", "national fervour", "spirited", "noisy hum", "badly distorted harmony section", "national anthem", "marching rhythm", "motor running sounds", "congregational singing", "medium tempo", "inspiring", "motivational"] | 1 | aPafZ1Mx-BE | 3537 | |
Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | A male singer sings this cool spirited melody. The song is medium tempo with a steady drumming rhythm, guitar playing lead, guitar strumming, strong bass line and various percussion hits. The song is exciting and energetic. The song has poor audio quality. | 2009-05-26T06:56:15Z | SirHenryII | Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | ["Music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["male singer", "guitar rhythm", "percussive bass line", "medium tempo", "groovy rhythm", "old school music", "spirited singing", "retro pop music", "story telling", "steady drumming rhythm", "marching rhythm", "cymbals crashing", "snare hits", "enteric", "exciting", "positive cheerful", "spirited", "emotional", "vintage hits", "poor audio quality"] | 1 | ckOe-8qdaew | 3736 |
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;