musiccaps_details (view)
3 rows where "youtube_published" is on date 2009-07-05 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- electric guitar 2
- energetic 2
- acoustic drums 1
- alternative 1
- arpeggio sound 1
- bass guitar 1
- digital drums 1
- fast paced bass guitar playing 1
- hard rock 1
- live performance 1
- male vocal 1
- medium to uptempo 1
- nu-metal 1
- punchy drumming 1
- recorded outside 1
- repeated tune 1
- sounds of footsteps 1
- synth bassline 1
- techno/electro 1
- young male speaking 1
musiccaps_names (array) 6 ✖
- Music 3
- Electronica 1
- Exciting music 1
- Heavy metal 1
- Punk rock 1
- Trance music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
3 DOZEN SMOKE BALLS!!! | This is a recording that was done outdoors and later had background music placed over it. There are the sounds of footsteps, and a young male saying something unintelligible. The track placed over it is a high octane rock song with fast electric bass playing, overdriven electric guitar strumming and a rock motif on the electric guitar. | 2009-07-05T00:09:33Z | Money Sandwich | Part 2 is out now! Only took a dozen years. CHECK IT!!!! https://youtu.be/Zc3xqfNaxag Thanks for 8 million views! Stay tuned with our channel Money Sandwich to see some fre$h comedy and music content. This video is in no way attempting to encourage use of illegal fireworks or explosives. Smoke Balls are legal fireworks in America and are some of the safest fireworks you can buy, as they do not even explode. Do not attempt to recreate what you see in this video, unless you are sure it is legal in your area. | ["Heavy metal", "Music", "Punk rock"] | ["hard rock", "electric guitar", "energetic", "punchy drumming", "fast paced bass guitar playing", "young male speaking", "recorded outside", "sounds of footsteps"] | 3 | aTeOMq8ave8 | 3542 | |
Bleep District - Secret Disciples | This song contains digital drums with a loud kick on every beat and a snare hit on the 2 and 4. A synthbass is playing a simple melody. While sound-effect hits are adding rhythmic diversity along with a fast arpeggio sound that is fading out. This song may be playing at the disco. | 2009-07-05T02:49:10Z | Alessandro Battaglini | Artist: BLEEP DISTRICT Title: End Days EP Label: Ornate Music Cat: ORN 002 Format: 12" Released: 18 May, 2009 Genre: Deep House Tracklist: 1. Bleep District - Revelations (Rapture Rub) (6:10) 2. Bleep District - Secret Disciples (7:13) 3. Bleep District - Revelations (Pillar Of Salt Dub) (6:09) 4. Bleep District - Secret Disciples (Jonno & Tommo's New Testament Dub) (6:46) Labels: Deep House, Electronic, EP, Tech House Ratings: 4.80/5.00 on Discogs.com | ["Music", "Trance music", "Electronica"] | ["techno/electro", "digital drums", "arpeggio sound", "synth bassline", "medium to uptempo"] | 6 | b9yT3nGcD_I | 3607 | |
She's All That shouting out Music Music! (live @ Rheinkultur Bonn 2009) | This is a nu-metal piece performed live on the stage. There is a male vocal shouting the words at the end of the song. The electric guitar is repeating the same tune while the bass guitar is playing in the background. The drummer plays fills on the acoustic drums to provide the rhythmic background. There is a high energy atmosphere to this piece. It could be used in an ad targeted for teenagers. | 2009-07-05T21:32:23Z | pnolle | Those Nu-Break-maniacs give you the ultimate thrill on stage, hiding their identity behind bizarre masks. A ferocious mixture of electro, ragga, punk and breakbeat. Visit www.shesallthat.de SATrk09 SuperKid 640x360 | ["Music", "Exciting music"] | ["nu-metal", "alternative", "live performance", "male vocal", "electric guitar", "repeated tune", "bass guitar", "acoustic drums", "energetic"] | 9 | 79tuMIiWMZ4 | 816 |
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;