musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_author = 9 and musiccaps_names contains "Cymbal" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: musiccaps_names, youtube_published (date)
musiccaps_aspects (array) 25 ✖
- acoustic drums 2
- aggressive 2
- bass guitar 2
- distorted electric guitar 2
- alternative metal 1
- box opening video 1
- clap sounds 1
- common sounding 1
- drum cover 1
- dub 1
- electric guitar 1
- energetic 1
- fast tempo 1
- generic 1
- hard rock 1
- instrumental 1
- kids shouting 1
- loud 1
- loud acoustic drums 1
- male vocal 1
- male voice speaking 1
- melodic singing 1
- punk rock 1
- rock music 1
- violent 1
musiccaps_names (array) 9 ✖
- Bass drum 3
- Cymbal · 3 ✖
- Drum 3
- Drum kit 3
- Hi-hat 3
- Percussion 3
- Rimshot 3
- Snare drum 3
- Drum roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Justin Nelson - DW Drums - Zildjian Cymbals - Dunnett Snare | This is a drum cover of a hard rock/alternative metal music piece. There is a male vocalist singing melodically in the lead. The main tune is being played by the distorted electric guitar. There is a bass guitar playing in the background. The rhythmic background consists of a simple but loud rock acoustic drum beat. The atmosphere is aggressive. | 2009-01-12T18:22:25Z | Justin Nelson | Drums: DW Collectors, Exotic Mapa Burl, Natural to Candy Black Burst Lacquer 14X26 kick 10X13 rack tom 16X18 floor tom 6X14 snare drum | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["drum cover", "acoustic drums", "hard rock", "alternative metal", "male vocal", "melodic singing", "distorted electric guitar", "bass guitar", "loud", "aggressive"] | 9 | FCvs17jk10A | 1622 | |
DUB TRIO - ILLEGAL DUB | This is an instrumental punk rock/dub music piece. There is a distorted electric playing the main tune with a bass guitar in the background. The rhythmic background consists of a loud and rapid acoustic drum beat. The atmosphere is aggressive. This piece could be used in the soundtrack of a violent video game. | 2006-05-02T17:09:19Z | dubtrio | video for ILLEGAL DUB. from DUB TRIO's album, NEW HEAVY. video directed by: Jason Fried | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["punk rock", "dub", "instrumental", "distorted electric guitar", "bass guitar", "loud acoustic drums", "fast tempo", "aggressive", "energetic", "violent"] | 9 | JpMHnsdsCiY | 2036 | |
LITTLE TIKES Bounce & Slide Bouncer by JohnnyAndZoey | This is a box opening video. There is a male voice speaking and kids shouting. A rock music piece starts playing with a common sounding electric guitar tune and a simple acoustic drum beat. The atmosphere is generic. | 2015-07-08T19:43:27Z | Johnny and Zoey | The Little Tikes Bounce and Slider Bouncer is easy to set up and a whole lot of fun to play with. For young kids this bounce house by Little Tikes is virtually indestructible! Be sure to subscribe for more awesome videos: http://www.youtube.com/JohnnyAndZoey Here's a link to our toy channel! Enjoy. http://www.youtube.com/EpicToyChannel Check out some of our recent videos: PAW PATROL Power Wheels Lil Quad w/ Chase and Marshall "Official Paw Patrol Power Wheel 4 Wheeler" https://youtu.be/TooImgnyblU TOWING STACKED POWER WHEELS Including Mercedes Benz, Corvette, Dune Racer and Paw Patrol 4 Wheeler https://youtu.be/zB9_EyGmmlI DISNEYLAND VACATION Surprise with Cars Ride, Lightning McQueen, Cars Land & Splash Mountain https://youtu.be/wJFzaLwZpyE MERCEDES BENZ "Aria Child" Mercedes GL450 Power Wheels Style Car aka: Mercedes for Kids https://youtu.be/eQc7fYBKRd8 POWER WHEELS VIDEO Power Wheels Collection + Off Road Power Wheels http://youtu.be/RGXYUrMGR6I POWER WHEELS "Little Fireman" Saves Cute Kitty in "Power Wheels Dune Racer" http://youtu.be/_OhZiQyprIQ The New Power Wheels 2014 Corvette Stingray with Teenage Mutant Ninja Turtles http://youtu.be/lh0F3M77vWM Music by http://www.audionautix.com Song: Modern Rock Boy Creative Commons | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["box opening video", "male voice speaking", "clap sounds", "kids shouting", "rock music", "electric guitar", "acoustic drums", "generic", "common sounding"] | 9 | KjJj5-HvSvQ | 2111 |
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;