musiccaps_details (view)
2 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2010-01-08
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- acerbic 1
- catchy beat 1
- dj song 1
- drum head 1
- explicit lyrics 1
- hand percussion 1
- instrumental 1
- jingles 1
- male voice 1
- medium fast tempo 1
- metallic sounds 1
- minimal instrumentation 1
- moderate tempo 1
- percussion instrument 1
- portable percussion instrument 1
- programmed percussion 1
- rhythmic beat 1
- rhythmic beats 1
- sharp 1
- small metal plates 1
- soft drum head beat 1
- synth bursts 1
- tambourine beats 1
- techno song 1
- vocal effect 1
musiccaps_names (array) 6 ✖
- Music · 2 ✖
- Drum and bass 1
- Electronic music 1
- Independent music 1
- Speech 1
- Tambourine 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Conversation for Two Tambourines | This music is a percussion instrumental . The tempo is medium fast with a rhythmic tambourine beat. The music is minimal with the sound of the tambourine metal plates clanging and a dull drum head beat. The music is catchy, enthusiastic and has a rhythmic beat. | 2010-01-08T01:22:27Z | jmvdude | A tambourine duet written by my instructor, Bobby Lopez | ["Music", "Tambourine"] | ["instrumental", "medium fast tempo", "percussion instrument", "minimal instrumentation", "soft drum head beat", "catchy beat", "rhythmic beat", "small metal plates", "jingles", "portable percussion instrument", "sharp", "acerbic", "tambourine beats", "hand percussion", "rhythmic beats", "metallic sounds", "drum head"] | 7 | 7_80oVTLkGU | 861 | |
Pendulum - Blood Sugar + Lyrics [HQ] | This techno song starts off with a synth playing a melody followed by another synth playing a burst of two chords. The two chord bursts are accompanied by percussion playing an outro roll. The instruments pause and a male voice starts to narrate a few lines. After two lines, the pitch of the voice is lowered in pitch to reach a bass pitch. This voice fades away to silence. This song can be played in a movie featuring a robot. | 2010-01-08T17:57:19Z | Ascendic | Thanks for 500.000 views, you guys rock! They have returned! https://www.facebook.com/pendulum/photos/a.498356746152.287685.24979476152/10153868789116153/?type=3&theater Lyrics: Ladies and Gentlemen we understand that you have come tonight to bear witness to the sound of drum... and... bass We regret to announce that this is not the case as instead, we come tonight to bring you, the sonic recreation of the end of the World Ladies and Gentlemen prepare to Hold Your Colour! Okay, fuck it, I lied it's drum and bass ... what you gonna do!? | ["Drum and bass", "Electronic music", "Music", "Independent music", "Speech"] | ["techno song", "dj song", "synth bursts", "male voice", "vocal effect", "explicit lyrics", "programmed percussion", "moderate tempo"] | 0 | XPGtOugQ69U | 3182 |
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;