musiccaps_details (view)
3 rows where musiccaps_aspects contains "loud", musiccaps_author = 9 and musiccaps_names contains "Inside, large room or hall"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- loud · 3 ✖
- acoustic drums 2
- bass guitar 2
- energetic 2
- aggressive 1
- alternative metal 1
- child-like vocal 1
- crowd sounds 1
- dance 1
- distorted electric guitar 1
- distorted guitar 1
- electric guitar 1
- electronic drums 1
- female voice 1
- guitar solo 1
- guttural singing 1
- industrial metal 1
- keyboard 1
- live performance 1
- male vocal 1
- pop music 1
- rebellious 1
- rock music 1
- strong bass 1
- synthesizer 1
- violent 1
musiccaps_names (array) 7 ✖
- Inside, large room or hall · 3 ✖
- Music 3
- Singing 2
- Angry music 1
- Cacophony 1
- Heavy metal 1
- Synthetic singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Front Row for Britney Spears performing BIG FAT BASS on Jimmy Kimmel LIVE! HD | This is the live recording of a pop music piece. The track is being performed with playback. There is a female vocal with child-like characteristics. There is a strong electronic drum beat in the rhythmic background. A fuzzy synth bass is playing the melodic part. There are lots of beat repeat effects. The atmosphere is loud and energetic. There are sounds that can be heard coming from the crowd cheering. | 2011-03-31T06:43:19Z | Rene Carta | Steadiest hand yet, you won't get dizzy watching it! =D | ["Singing", "Music", "Synthetic singing", "Inside, large room or hall"] | ["pop music", "live performance", "female voice", "child-like vocal", "electronic drums", "synthesizer", "strong bass", "loud", "energetic", "dance", "crowd sounds"] | 9 | TTytcT_1dmY | 2838 | |
Illidiance - New Millenium Crushers music video HD | This is an industrial metal/alternative metal music piece. There is a male vocal singing in a harsh manner using the guttural technique. The melody is being played by the keyboard and the distorted electric guitar while the bass guitar is playing in the background. The acoustic drums are playing a loud and fast-paced metal beat with heavy use of twin pedals on the kick drum. The atmosphere is violent. This piece could be used in the soundtrack of a gruesome horror video game. | 2010-12-24T09:52:38Z | ModernMelodicMetal | Illidiance new music video for ''New Millenium Crushers'' in High Definition from their latest album ''Damage Theory''. © Mazzar Records 2010 | ["Singing", "Heavy metal", "Music", "Angry music", "Inside, large room or hall"] | ["industrial metal", "alternative metal", "male vocal", "guttural singing", "distorted electric guitar", "keyboard", "bass guitar", "acoustic drums", "loud", "aggressive", "violent"] | 9 | U3TpCc2zHrI | 2884 | |
Chatmonchy - Donaru Denwa Doshaburi LIVE | This is a rock music piece consisting of three instruments. There is a distorted electric lead guitar playing a solo that is increasing from medium to high pitch. The bass guitar is providing tune in the background. There is a loud acoustic drum beat that includes a lot of fills. The song has a vigorous, high energy feel to it. This piece could be played at rock bars. | 2011-01-13T22:04:55Z | modus | I do not claim ownership of "Chatmonchy" or there music. reuploaded after fixing audio sync issue. | ["Music", "Cacophony", "Inside, large room or hall"] | ["rock music", "electric guitar", "guitar solo", "distorted guitar", "bass guitar", "acoustic drums", "loud", "energetic", "rebellious"] | 9 | a4jcJ7QZ-OQ | 3515 |
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;