musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "energetic crash cymbals", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "powerful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- energetic 2
- energetic crash cymbals · 2 ✖
- low quality · 2 ✖
- powerful · 2 ✖
- punchy kick 2
- punchy snare 2
- aggressive 1
- crushed 1
- epic 1
- groovy bass 1
- groovy bass guitar 1
- manic 1
- metal 1
- passionate female vocal 1
- rock orchestra 1
- simple hi hats 1
- simple strings melody 1
- sustained synth pad melody 1
- wide aggressive distorted electric guitars 1
- wide electric guitar melody 1
musiccaps_names (array) 5 ✖
- Music 2
- Angry music 1
- Classical music 1
- Opera 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nightwish Amaranth lyrics | The Metal song features wide aggressive distorted electric guitars, punchy kick and snare hits, energetic crash cymbals, simple hi hats, groovy bass guitar, sustained synth pad melody and passionate female vocals singing over it. It sounds energetic, powerful, manic and aggressive - especially in the first part of the loop where there is a drum break. | 2010-09-11T09:47:05Z | Ruben Tomas | This is my second video, its a bit slow at the begginning but i hope you enjoy XD | ["Music", "Angry music"] | ["low quality", "metal", "wide aggressive distorted electric guitars", "punchy kick", "punchy snare", "energetic crash cymbals", "simple hi hats", "passionate female vocal", "crushed", "groovy bass guitar", "sustained synth pad melody", "energetic", "powerful", "manic", "aggressive"] | 4 | dSs4xfvATjc | 3787 | |
not ashamed - boundless worship band | The Rock Orchestra song features energetic crash cymbals, punchy kick and snare hits, groovy bass, wide electric guitar chords and simple strings melody. It sounds epic, powerful and energetic - like a theme song for an opening track of some anime. | 2008-06-20T12:19:31Z | awaefler | not ashamed got very famous in the first weeks. Now we're starting with youtube. | ["Music", "Opera", "Song", "Classical music"] | ["low quality", "rock orchestra", "energetic crash cymbals", "punchy kick", "punchy snare", "groovy bass", "wide electric guitar melody", "simple strings melody", "energetic", "epic", "powerful"] | 4 | qwGT6wvYdLo | 4834 |
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;