musiccaps_details (view)
1 row where musiccaps_aspects contains "enthusiastic", musiccaps_aspects contains "hard rock", musiccaps_author = 7 and "youtube_published" is on date 2011-11-25
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 |
---|---|---|---|---|---|---|---|---|---|---|
Ace Pk Session 1 | Maxed Chaotic Pure | 100% Pure Hybridding | Eruption of Pures | A male vocalist sings this spirited Rock song. The tempo is fast with an upbeat Amplified keyboard harmony, hard hitting drums, punchy bass lines and a dominating electric guitar accompaniment. The vocals are subdued for a Rock song. The song is youthful, vibrant, energetic, enthusiastic, buoyant, punchy and vivacious. This song is Classic Hard Rock. | 2011-11-25T01:44:13Z | AceyFiasco | I tried my best guys, all feedback is appreciated. You can join the clan I'm in @ EoP-Rs.com Runescape is owned and operated by Jagex Limited ("JaGeX"), I Do Not own Runescape i make videos for entertainment purposes "Only" and not for the sake of profiting.All music used in my videos is purchased and not for the intent of redistributing it. You Can Play Runescape At: http://www.runescape.com IGNORE THE FOLOWING~~~~~~~~~~~~~ bounty hunter TERMPINATION TERMPINATIONZ BH VID # 1 blue stanger TERPINATIONownage range of ish PD OWN TRILE12 STR B0S 001 runescape bs bh pking bounty hunter pking blue bountyhunter bs bh rs runescape jagex ltd rs elvemage kids ranqe defil3d elf mage pka i ayzee i wildy owns1 spanjol 91 bloodhoun34zezima youbleedred i kasoy i xxphatmagexx dawgsaysftw skychi review best Bounty Hunter video armadylgodsword ownage ko pk whip pks barrow pks spartacus121 best pker in rs best pker pk vid. best pker bounty hunter vid Archer96 Letterbomb05's Dark Bow theunforgiving yogosun yogosun2 fat wrecked zeldagirl8 lvl126inrs sosolid2k maxboisen Tehnoobshow Runescape Zezima Interview max hits high hits Best Lure video ever purple 0wnz bloodhoun34 OMG runescape pking wild pker ownage zezima phat lure KIDS RANQE PURPLE 0WNZ ZEZIMA N0VALYFE PHAT LURE OWNAGE RUNESCAPE WILDY WILDERNESS ELVEMAGE ELVEMAGE RUNESCAPE PKING RUN3 4RR0WPK OWNAGE MAIKEL PRO I MAHATMA I EVO BLOODHOUN34 KIDS RANQE KRAZYFAKEN RUNESCAPE PKER RUNESCAPE PKING INTIATE PURE OWNAGE LURE PHAT 99 1337 PWNAGE PKING PKERS PK PARTYHAT ZEZIMA N0VALYFE RUNESCAPE WILDY BARRAGE ANCIENTS LURING FROSTYDAPKER JETCHIMP BLOOD SEASON BLOODHOUN34 I Mahatma I, Stonecoldpkr,P0ke N Die2, Sourpatchk1d, Krazyfaken, Kids Ranqe ,dragon claws maxxing 1 Pure Devil, Evilsexc, Dizzy Mauler, I Shonomercy, E4t F0od Nub, Im Easy Xp, Iminsan3, Pure insan3, and Xoxofuryxoxo.pvp best loots whipper whip elvemage sv3rige bloofhoun34 is elvemage bloodhoun34 hiei the pk lexmark78 6th outlaw i meleed i ultimate strength hybrid barrage blitz burst 99 range mage krazyfaken f… | ["Music", "Grunge"] | ["male singer", "fast tempo", "rock", "hard rock", "dominating electric guitar", "punchy", "buoyant", "vivacious", "video game music", "animated", "chaotic", "busy", "rock hits", "concert", "hard hitting drums", "loud electric guitar feedback", "amplified keyboard harmony", "funky bass line", "subdued vocals", "imposing music", "youthful", "energetic", "enthusiastic", "spirited", "vivacious", "classic rock", "intense"] | 7 | dHGAXJ9RPJs | 3773 |
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;