musiccaps_details (view)
2 rows where musiccaps_aspects contains "loud", musiccaps_aspects contains "low quality" and musiccaps_aspects contains "suspenseful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- loud · 2 ✖
- low quality · 2 ✖
- suspenseful · 2 ✖
- buzzy synth bass 1
- distorted 1
- distorted electric guitar melody 1
- electro 1
- energetic 1
- floor squeaking sound effect 1
- groovy woodwind melody 1
- gunshots sound effects 1
- harsh 1
- noisy 1
- smooth bass 1
- suspicous music 1
- tinny bells melody 1
- wide stuttering synth melody 1
- wooden impact sound effect 1
- woodwind solo melody 1
musiccaps_names (array) 3 ✖
- Music 2
- Angry music 1
- Noise 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tell Me You Love Me | The low quality recording features an electro song that consists of a widely spread stuttering synth melody, buzzy synth bass and distorted electric guitar melody. It sounds distorted, loud, suspenseful and energetic. | 2012-07-16T02:20:05Z | Sharon Wright | After a brutal attack sustained by Sharon Wright (Co-Director/Lead Actress) she teamed up with partner, Gary C Warren, to make a film as therapy to help her deal with the post traumatic stress associated with the assault. Wright received numerous acting awards for her harrowing performance, including the Withoutabox Best Actress Award for her performance at the Action On Film Intl Film Festival. The film was also used as an Interstitial/PSA and was nominated for 3 Mid america Emmy Awards. "Tell Me You Love Me" has played festivals worldwide and has received numerous other awards including, Best Film, Best Director and Best Editing. For more details about that night - please watch Sharon's candid and emotional video where she opens up about the attack: http://www.youtube.com/watch?v=6coONebv-Qs | ["Music", "Angry music"] | ["loud", "distorted", "wide stuttering synth melody", "buzzy synth bass", "harsh", "energetic", "low quality", "electro", "distorted electric guitar melody", "suspenseful"] | 4 | 2x4694ExyCU | 418 | |
Ultimate Prank Compilation - Air Horn, Train Horn, Loud Noise | The low quality recording features a loud gunshots sound effects, wooden impact and squeaking floor sound effects, while a suspicious background music is playing in the background and it consists groovy woodwind melody, woodwind solo melody, tinny bells melody located in the left channel of the stereo image and smooth bass. The recording is noisy. | 2013-08-03T07:14:48Z | PaulD | Ultimate Prank Compilation - Air Horn, Train Horn, Loud Noise Watch the originals: Funny Air Horn Pranks http://www.youtube.com/watch?v=yhcmPrU3QSk Funny Pranks : Funny Air Horn Prank 2 http://www.youtube.com/watch?v=AzQTkiYlyi4 Jackass: The Movie (9/10) Movie CLIP - Golf Course Airhorn http://www.youtube.com/watch?v=7C1Pr4AU2wc Air Horn Trap Prank http://www.youtube.com/watch?v=zH2rJhuaY0I Air Horn Wake Up Prank 1 http://www.youtube.com/watch?v=LBFvafR4Yzc In Soviet Russia, Airhorn pranks will always go wrong. http://www.youtube.com/watch?v=kl0iKR1B-Ug Funny Pranks : Computer Scare Prank! http://www.youtube.com/watch?v=AYsq4fqbMG8 Funny Prank : Car Crash Scare Prank http://www.youtube.com/watch?v=eaPsMjyPMtU | ["Music", "Noise"] | ["low quality", "noisy", "loud", "gunshots sound effects", "suspicous music", "woodwind solo melody", "groovy woodwind melody", "tinny bells melody", "smooth bass", "suspenseful", "floor squeaking sound effect", "wooden impact sound effect"] | 4 | L_ghM-NrH58 | 2200 |
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;