musiccaps_details (view)
3 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2012-10-01
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- ad-libs 1
- cymbal crashes 1
- dramatic orchestral score 1
- eerie 1
- electronic drums 1
- flat male vocal 1
- folk 1
- hip-hop 1
- laser gun sounds 1
- live performance 1
- low quality 1
- male vocal 1
- melodic pad 1
- noisy 1
- passionate 1
- rapping 1
- rocket launcher firing 1
- sound fx 1
- space shuttle take off 1
- steel guitars melodies 1
- strong bass 1
- tense dissonant string harmonies 1
- unnerving 1
- violent 1
musiccaps_names (array) 7 ✖
- Music · 3 ✖
- Banjo 1
- Boom 1
- Guitar 1
- Hip hop music 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dizzy Wright Ft. SwizZz & Hopsin - Independent Living (Official Music Video) | This is a hip-hop music piece. There is a male vocal rapping at the forefront while there are repetitions and ad-libs that can be heard in the background. An eerie sounding melodic pad is playing the melody. There is a strong bass. The rhythmic background is composed of a hip-hop electronic drum beat. The atmosphere is unnerving. This piece could be playing in a scene where criminal activities are occurring in a crime/noir movie taking place in a big city. | 2012-10-01T22:04:34Z | WickedMindzMedia | Dizzy Wright Ft. SwizZz & Hopsin - Independent Living (Official Music Video) http://www.youtube.com/user/DizzyWright http://www.youtube.com/hopsintv http://www.youtube.com/user/SwizZzleFish http://www.youtube.com/brokencomplexrecords http://www.myfunkvolume.com Download this song for FREE: http://myfunkvolume.com/free-hip-hop-download/ SmokeOut Conversations ALBUM available on iTunes: http://bit.ly/Kwws46 Purchase Music Here (Hopsin) http://itunes.apple.com/us/artist/hopsin/id280980359 (Dizzy Wright) http://itunes.apple.com/us/artist/dizzy-wright/id507787273 (SwizZz) http://itunes.apple.com/us/artist/swizzz/id409543118 | ["Music", "Hip hop music"] | ["hip-hop", "male vocal", "rapping", "melodic pad", "strong bass", "electronic drums", "ad-libs", "eerie", "unnerving", "violent"] | 9 | T0OFKHj6878 | 2802 | |
Darth Maul & Savage Opress VS Obi Wan & Adi Gallia | Sound from a cartoon space battle featuring a space shuttle takeoff, laser gun sounds and a rocket launcher firing. Background score is dramatic orchestral, featuring cymbal crashes and tense, dissonant string harmonies. | 2012-10-01T12:28:32Z | Mr Shadows | Duel from The Clone Wars S05E01. | ["Music", "Boom"] | ["sound fx", "space shuttle take off", "laser gun sounds", "rocket launcher firing", "dramatic orchestral score", "cymbal crashes", "tense dissonant string harmonies"] | 8 | aE_CVWMWK74 | 3523 | |
Old Man Luedecke - I'm Fine (I Am, I Am) | The low quality recording features a short snippet of flat male vocals, followed by steel guitar melodies. It sounds passionate, even though the recording is very noisy. | 2012-10-01T19:57:33Z | AnalogSongs | Recorded live on the beach in Chester, NS with Old Man Luedecke and Joel E Hunt on mandolin. From the new album Tender is the Night, released October 2nd, 2012 http://oldmanluedecke.ca Video by Analog Songs: http://www.analogsongs.ca Camera and post production: Stephen Cooper and Katy Hopkins, Audio recording and post production: Cameron Dexter | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["low quality", "noisy", "steel guitars melodies", "flat male vocal", "passionate", "folk", "live performance"] | 4 | kIEEDYowZhA | 4307 |
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;