musiccaps_details (view)
1 row where musiccaps_aspects contains "shooting sounds", musiccaps_author = 0 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The best extended Pinhead remix EVER you will find on youtube | This low quality recording features an electropop song. At the beginning, there is a shooting sound. This is followed by cartoon voices. A fast paced vocal chop sequence is used for the main voice. Toward the end, another quirky voice joins in with another vocal chop sequence. This is accompanied by programmed percussion playing an electropop beat. A synth plays a repetitive lick. The bass follows the root notes of the chords. This song can be played at a club. | 2009-11-19T01:50:38Z | blahblahblehblehbleh | MP3: http://download451.mediafire.com/ixvwy4wywung/2vzlmmmndmu/SuperPinheadRemix.mp3 ALL RIGHT PINHEAD! I FINISHED YOUR REMIX! I do not own Spongebob. FUN FACTS: This took 18 hours to make The rendering took an hour and a half I got very hungry while making this somehow I made an MP3 if you didn't know Reg. Pattern: 11_11_111_1_1_11222_2_222_222_2 EPIC PATTERN: 1*__1*_332*_1_1_11__1_1*_113_3_22221*_3_1*_332*1_1_111_11311111111111 4_4 4_4444_44 | ["Music", "Cacophony"] | ["low quality recording", "cartoon noises", "synth", "vocal chop sequences", "electropop song", "quirky sounds", "moderate tempo", "dance music", "shooting sounds"] | 0 | n7yLkcSfiuM | 4520 |
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;