musiccaps_details (view)
4 rows where musiccaps_aspects contains "low quality", musiccaps_author = 4 and musiccaps_names contains "Rumble"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- low quality · 4 ✖
- aggressive distorted car engine revving sound effects 1
- birds chirping 1
- crowd cheering 1
- crowd whistling 1
- distant traffic 1
- easygoing 1
- electro 1
- exciting 1
- filtered synth bass 1
- footsteps 1
- fruity male vocal 1
- funky electric guitar chords 1
- groovy bass guitar 1
- live performance 1
- low wide suspenseful pad 1
- playback 1
- poor mix 1
- reggae 1
- reverberant "4 on the floor" kick hits 1
- shimmering hi hats 1
- short riser 1
- snappy rimshots 1
- suspenseful synth stab 1
- sustained strings 1
- synth lead riser 1
- thin 1
- wide crackling noises 1
- wind 1
musiccaps_names (array) 9 ✖
- Music 4
- Rumble · 4 ✖
- Dance music 1
- Dubstep 1
- Electronic dance music 1
- Maraca 1
- Music of Latin America 1
- Outside, urban or manmade 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
gensan tuna fest sound system rumble | The low quality recording features an electro song that consists of a reverberant "4 on the floor" kick pattern, followed by suspenseful synth stabs. At the very end of the loop there is a short riser, after which comes the snippet of a filtered synth bass. It sounds thin, as it was poorly mixed. | 2009-09-16T08:22:06Z | ostjay26 | ["Music", "Techno", "Rumble", "Dubstep", "Electronic dance music", "Dance music"] | ["low quality", "reverberant \"4 on the floor\" kick hits", "suspenseful synth stab", "filtered synth bass", "short riser", "electro", "thin", "poor mix"] | 4 | H6rZwBc6aNM | 1776 | ||
HULK in Engfaret (Part one) | The low quality recording features footsteps, birds chirping, distant traffic and wind sound effects. At the very end there is a suspenseful, low, widely spread pad chord. It sounds like it is a sound for some kind of video, or movie. | 2010-03-25T21:46:29Z | youlabus | A short HULK movie made by Norwegian kids during their summer holliday. Part one of two. | ["Music", "Rumble", "Outside, urban or manmade"] | ["low quality", "footsteps", "birds chirping", "distant traffic", "wind", "low wide suspenseful pad"] | 4 | _-kssA-FOzU | 3434 | |
Morgan World Premiere Teaser - Geneva 2015 | The low quality recording features an aggressive, distorted car engine revving sound effect and layered sustained string and synth lead riser in the background. There are some wide crackling noises, which, besides a slight distortion of the actual sound, is making this sound lower in quality. | 2015-02-16T10:58:59Z | Morgan Motor Company | The countdown begins to the impending release... watch this space for the latest updates www.morgan-motor.co.uk/mmc/geneva2015.html | ["Music", "Rumble"] | ["low quality", "aggressive distorted car engine revving sound effects", "sustained strings", "synth lead riser", "wide crackling noises"] | 4 | ywuR9AfpA_E | 5448 | |
Downbeat sound at Irish and chin vintage rumble 2016 amazura | The low quality recording features a live performance of a reggae song and it consists of a fruity male vocal preparing to sing over shimmering hi hats, snappy rimshots, funky electric guitar chords and groovy bass. As it is a live performance, there are some crowd whistling and cheering noises in the background. It sounds easygoing and exciting. | 2016-04-16T14:14:11Z | Kerryannbrown music promotions | Downbeat sound at vintage rumble 2016 Irish and chin sound clash | ["Music", "Rumble", "Music of Latin America", "Maraca"] | ["low quality", "reggae", "crowd whistling", "fruity male vocal", "crowd cheering", "live performance", "playback", "shimmering hi hats", "snappy rimshots", "funky electric guitar chords", "groovy bass guitar", "easygoing", "exciting"] | 4 | zXxJymYt8Z4 | 5487 |
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;