musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "buoyant", musiccaps_aspects contains "fast tempo" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- buoyant · 4 ✖
- fast tempo · 4 ✖
- youthful · 4 ✖
- animated 3
- punchy 3
- vivacious 3
- classic rock 2
- club music 2
- dance music 2
- enthusiastic 2
- female singer 2
- male singer 2
- pop rock 2
- spirited 2
- amplified keyboard harmony 1
- atmospheric synthesiser 1
- auto tune 1
- backup vocals 1
- boomy bass drops 1
- bouncy 1
- bright bass lines 1
- bright vocals 1
- busy 1
- chaotic 1
- children’s song 1
- concert 1
- dance groove 1
- dance hits 1
- digital drumming 1
- dj 1
- …
musiccaps_names (array) 6 ✖
- Music 4
- /t/dd00032 1
- Angry music 1
- Dance music 1
- Grunge 1
- Jazz 1
youtube_published (date) 4 ✖
- 2008-10-01 1
- 2009-08-22 1
- 2011-11-25 1
- 2014-08-15 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sandra Lyng - Electric City (Official Music Video) | A female vocalist sings this spirited pop. The tempo is fast with a spirited, upbeat acoustic guitar accompaniment, synthesiser arrangements, slick drumming, digital drum rhythm, boomy bass drop , added reverb and auto tune for better effects.The song is young, fresh, upbeat, bouncy, punchy, and has a dance groove.this song is a synth pop. | 2014-08-15T16:57:07Z | Sandra Lyng | Offisiell musikkvideo til "Electric City", den nye singelen til Sandra Lyng. Electric City er tilgjengelig på alle digitale plattformer, last ned og stream singelen her: - iTunes: https://itunes.apple.com/no/album/electric-city-single/id893197707?l=nb - Spotify: http://open.spotify.com/album/27Axz7vCZGIw1w1bQgqtIP - Wimp: http://wimp.no/album/31787918 - SoundCloud: https://soundcloud.com/sandra-lyng/sandra-lyng-electric-city | ["Jazz", "Music", "Dance music"] | ["female singer", "fast tempo", "auto tune", "boomy bass drops", "slick drumming", "digital drumming", "dj", "dance hits", "dance music", "club music", "dance groove", "groovy acoustic guitar accompaniment", "atmospheric synthesiser", "synthesised vocals", "vocal backup", "heavy reverb", "punchy", "bouncy", "youthful", "buoyant", "boomy bass drops", "spirited"] | 7 | 33dCbb1MyYU | 439 | |
Ratrace Music Video | A male vocalist sings this simple, peppy melody. The tempo is fast with keyboard harmony, enthusiastic drumming, steady bass line, acoustic guitar rhythm and electronic arrangements. The song is fun, animated, upbeat, catchy, energetic, spirited and vibrant and appealing to children . This song is a Synth Pop/Rock. | 2008-10-01T02:40:34Z | PlasticManFilms | Aniamting to the song Ratrace. clips of many of our videos along with the stort story of a hobo who has a spending problem.PLEASE COMMENT | ["Music", "/t/dd00032"] | ["male singer", "fast tempo", "energetic music", "peppy", "buoyant", "electronic rhythm", "enthusiastic drumming", "rhythmic acoustic guitar", "steady bass line", "fun", "youthful", "animated", "spirted", "vivacious", "happy", "children’s song", "synth arrangements", "synth pop", "pop rock"] | 7 | EaGhKzpkNso | 1574 | |
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 | |
Hawaiian Roller Coaster Ride- Jump 5 (Lyrics) | A female vocalist sings this spirited pop song. The tempo is fast with vigorous drumming, animated electric guitar harmony, keyboard accompaniment and groovy bass lines along with backup vocals. The first bit of the song is sung in foreign language. The song is energetic, youthful, passionate, vibrant and vivacious with a dance groove. This song is Teen Pop/Pop Rock. | 2009-08-22T02:50:00Z | Javiix7 | lyrics this is one of my favorite songs | ["Music", "Angry music"] | ["female singer", "fast tempo", "vigorous drumming", "teen pop", "foreign language introduction", "vibrant", "vivacious", "teen pop", "dance music", "club music", "energetic electric guitar harmony", "bright bass lines", "bright vocals", "backup vocals", "animated", "youthful", "enthusiastic", "dance music", "perky", "punchy", "buoyant", "pop rock", "classic rock", "keyboard accompaniment"] | 7 | id5ibIqjRto | 4208 |
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;