musiccaps_details (view)
2 rows where musiccaps_aspects contains "mysterious", musiccaps_aspects contains "suspenseful" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- instrumental 2
- mysterious · 2 ✖
- sinister 2
- slow tempo 2
- suspenseful · 2 ✖
- amateur video 1
- backup vocal harmony 1
- clock ticking 1
- cymbal ride 1
- dangerous 1
- dark night 1
- documentary 1
- eerie 1
- electronic music 1
- enigmatic 1
- ethereal 1
- gentle breeze 1
- grim 1
- home video 1
- intense 1
- making notes 1
- metal swiping 1
- no vocals 1
- papers ruffling 1
- papers rustling 1
- sound of whirring engine 1
- spooky 1
- story writing 1
- swiping sound 1
- synthesiser articulation 1
- tense 1
- thrilling 1
- vocalisation 1
- xylophone sound 1
musiccaps_names (array) 3 ✖
- Music 2
- Rumble 1
- Vibraphone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
HMV Destroyed | This music clip is an instrumental. The tempo is slow with a steady keyboard harmony, ethereal male vocal harmony, cymbals, electronic sounds, sound of metal swiping,an engine whirring,and breeze. It is mysterious, suspenseful, enigmatic, grim and intense. | 2008-04-28T01:59:13Z | distroyer3000 | SONGS: 0:15 ~ Boulevard of Broken Dreams by green day 0:40 ~ Peanut butter jelly time 0:56 ~ I'm gonna be by proclaimers 1:11 ~ Disco Inferno by The Trammps 1:20 ~ Stronger by Kanye West 1:26 ~ DOOM Theme 1:35 ~ Raining Men by The Weather Girls 1:44 ~ Why cant we be friends by Smash Mouth (Original by WAR) 1:56 ~ Jaws Theme 2:15 ~ Mario Theme 2:28 ~ You Give Love A Bad Name by Bon Jovi 2:37 ~ Kung Fu Fighting by Carl Douglas 2:45 ~ Baby got back by Sir Mix A Lot 2:56 ~ I like to move it by Reel 2 Real 3:05 ~ Highway to hell by ACDC 3:14 ~ Popcorn by Hot Butter 3:22 ~ Reunited by Peaches & Herb 3:42 ~ All by myself by Celine Dion 3:59 ~ Oompa looompa song 4:19 ~ What a wonderful world by Louis Armstrong 4:44 ~ Grandma got runover by a raindeer 4:59 ~ Zelda Theme 5:19 ~ Blow me away by Breaking Benjamin 5:23 ~ Hide and seek by Imogen Heap 5:46 ~ Mr Roboto by Styx 5:53 ~ You Can't Touch This by MC Hammer 6:01 ~ Chariots of Fire by Vangelis 6:28 ~ Thriller by Michael Jackson 6:54 ~ James bond theme 7:03 ~ I got the power by Snap 7:12 ~ Celebration by Kool & The Gang 7:22 ~ Barny Theme song 7:37 ~ Banana phone by Raffi 7:53 ~ One Is The Loneliest Number by Three Dog Night 8:15 ~ We are the champions by Queen 8:29 ~ Sugar Tunes by Dan Balan | ["Music", "Rumble"] | ["instrumental", "slow tempo", "vocalisation", "metal swiping", "gentle breeze", "dark night", "intense", "mysterious", "ethereal", "thrilling", "suspenseful", "backup vocal harmony", "electronic music", "synthesiser articulation", "tense", "sinister", "grim", "dangerous", "enigmatic", "swiping sound", "sound of whirring engine", "cymbal ride"] | 7 | YyHmz1vcob8 | 3327 | |
New Hampshire's coolest trooper pulls me over | This song is an instrumental. The tempo is low with a xylophone like instrument harmony, sound of clock ticking and papers rustling . The music is spooky, eerie, suspenseful and sinister. This song is Pop. | 2012-06-17T07:38:58Z | RidleyReport | Sponsor: http://Libertania.com - New Hampshire's coolest trooper pulls me over. Some of the video in this clip's likely available for you to use commercially. Basically any part of the clip that has the URL "RidleyReport.com" burned into it at the bottom or was obviously shot by me. That is released into the public domain by me. Or it was public domain to begin with. If it says "YouTube.com/WinWinParty" at the bottom, that means the same thing. Here's at least a partial transcript of text that appears inside the video: Westmoreland, NH. May 22, 2012. About 9 p.m. on a Tuesday. I'm running an errand but mistakenly knock on the wrong, very rural door. No one answers, but police are apparently summoned and my car presumably described. Meanwhile I make it to the correct location, finish my errand there and head back north. Just as I'm passing the carcass of the abandoned Cheshire County gulag, blue lights appear behind me. I reach for my camera. As you can hear, I'm muting the audio whenever I speak the addresses. I don't know whether the occupants want them publicized and probably shouldn't even have spoken them to the trooper. How you can buy yourself an advert here: http://RidleyReport.com/ad pulled over new hampshire cool trooper ron paul state troopers 2012 right to record free state project traffic stop dave ridley report cops libertarian police interactions ridleyreport copblock.org the cop block liberty westmorelan staters cheshire county jail public domain footage peace officers live free or die. calm nh rural investigation suspicions suspicious raw news video. good cop | ["Music", "Vibraphone"] | ["instrumental", "slow tempo", "eerie", "sinister", "spooky", "mysterious", "suspenseful", "papers rustling", "no vocals", "amateur video", "home video", "documentary", "story writing", "making notes", "xylophone sound", "clock ticking", "papers ruffling"] | 7 | qlk02ytcnPU | 4815 |
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;