musiccaps_details (view)
1 row where musiccaps_aspects contains "male", musiccaps_aspects contains "screaming voice", musiccaps_names contains "Music" and musiccaps_names contains "Rhythm and blues"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Crossfaith - "Jägerbomb" Official Music Video | This song has a bassline that repeats itself playing along with a distorted guitar that supports the melody by playing the low notes along with slight variations and licks. The acoustic drums sound in the background but are played at full force. Fast paced with a lot of hits on different crashes and using a double bass kick. The male voice is screaming full force then a synthesizer lead sound is playing a simple melody that is panned to the right side of the speakers. This song may be playing at a live-concert jumping up and down enjoying the energetic energy of the surrounding and the music. | 2013-01-14T17:00:06Z | CrossfaithOfficial | Crossfaith's new SPECIES EP is out on May 20th (Japan) / 22nd (Worldwide), pre-save / pre-add now: https://unfd.lnk.to/PresaveSPECIESEP Crossfaith on Facebook: https://www.facebook.com/crossfaithof... Crossfaith on Instagram: https://www.instagram.com/crossfaithj... Crossfaith on Twitter: https://twitter.com/CrossfaithJapan New album XENO out now! iTunes - http://apple.co/1gHgZDg // Spotify - http://spoti.fi/1OqiOTT // Amazon - http://amzn.to/1IqjSn7 // UK LP - uk.unfdcentral.com // AU merch - http://bit.ly/24HXeno // US merch - http://merchnow.com/catalogs/crossfaith // EVERYTHING - crossfaith.jp CROSSFAITH headline UK & European tour 2016! Feb 25th - La Laiterie, Strasbourg, France Feb 26th - La Cafe Charbon, Nervers, France Feb 27th - L’orange Bleue, Vitry-Le-Francois, France Feb 28th - Chato Do, Blois, France Mar 1st - Logo, Hamburg, Germany Mar 2nd - Trix Club, Antwerp, Belgium Mar 3rd - Helling, Utrecht, Netherlands Mar 4th - Strom, Munich, Germany Mar 5th - Officina Degli Angeli, Verona, Italy Mar 7th - Dynamo, Zurich, Switzerland Mar 8th - Arena, Vienna, Austria Mar 9th - Rock Cafe, Prague, Czech Republic Mar 11th - Magnet, Berlin, Germany Mar 12th - Luxor, Cologne, Germany Mar 13th - Brise Glace, Annecy, France Mar 14th - Le Trabendo, Paris, France Mar 16th - Chinnerys, Southend, UK Mar 17th - Wedgewood Rooms, Portsmouth, UK Mar 18th - The Haunt, Brighton, UK Mar 19th - Y Plas, Cardiff, UK Mar 20th - The Hub, Plymouth, UK Mar 22nd - Key Club, Leeds, UK Mar 23rd - Sub 89, Reading, UK Mar 24th - Slade Rooms, Wolverhampton, UK Mar 25th - Academy 2, Liverpool, UK Mar 26th - Academy 2, Manchester, UK Mar 28th - King Tuts, Glasgow, UK Mar 29th - Cooperation, Sheffield, UK Mar 30th - Waterfront, Norwich, UK Mar 31st - Electric Brixton, London, UK Apr 2nd - Volta Club, Moscow, Russia Apr 3rd - Club Zal, St.Petersburg, Russia www.crossfaith.jp Follow the band: @KenCrossfaith @HiroCrossfaith @TeruCrossfaith @KazuCrossfaith @TatsuCrossfaith ▼Video Shooting N' Production Directed by INNI VISION http://inn… | ["Blues", "Music", "Rhythm and blues", "Dance music", "Exciting music"] | ["punkrock", "e-guitar", "e-bass", "loud acoustic drums", "male", "screaming voice", "synthesizer lead sound", "energetic", "medium to uptempo"] | 6 | BT4env-Tw2o | 1242 |
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;