musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "groovy bass guitar", musiccaps_aspects contains "punchy kick" and musiccaps_names contains "Ska"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- energetic 2
- flat male vocal 2
- groovy bass guitar · 2 ✖
- punchy kick · 2 ✖
- punchy snare 2
- arpeggiated electric guitar melody 1
- exciting 1
- fun 1
- groovy 1
- happy 1
- low quality 1
- punk 1
- rock 1
- shimmering cymbals 1
- shimmering hi hats 1
- unbalanced stereo 1
- upbeat 1
- wide electric guitars 1
musiccaps_names (array) 8 ✖
- Music 2
- Ska · 2 ✖
- Background music 1
- Funk 1
- Happy music 1
- Pop music 1
- Punk rock 1
- Rock music 1
youtube_published (date) 2 ✖
- 2006-09-22 1
- 2012-04-21 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Das Leben ist ein Rodeo Schule Illingen Hiss | The Rock song features a flat male vocal singing over arpeggiated electric guitar melody located in the right channel of the stereo image, groovy bass guitar, punchy kick and snare hits and shimmering hi hats. The stereo image is unbalanced because of the electric guitar, which makes it lean towards the right channel. It sounds energetic, groovy, happy and fun. | 2012-04-21T15:03:23Z | 55alwin | Ein Stopp-Motion Projekt der Klasse H6, GHRS Illingen | ["Funk", "Music", "Rock music", "Ska"] | ["rock", "groovy bass guitar", "punchy snare", "flat male vocal", "shimmering hi hats", "punchy kick", "arpeggiated electric guitar melody", "energetic", "groovy", "unbalanced stereo", "happy", "fun"] | 4 | JNwt0afB1fQ | 1998 | |
Pocket Rocket - See The Problem (Punk Rock Music Video) | The low quality recording features a punk song that contains flat male vocal singing over punchy kick and snare hits, shimmering cymbals, wide electric guitars and groovy bass guitar. It sounds energetic, exciting and upbeat - like something you would jump to at concerts. | 2006-09-22T06:12:51Z | powerswap | The first music video of the aspiring austrian punk-rock-band "Pocket Rocket". | ["Background music", "Music", "Punk rock", "Pop music", "Ska", "Happy music"] | ["punk", "energetic", "exciting", "groovy bass guitar", "wide electric guitars", "shimmering cymbals", "punchy snare", "punchy kick", "flat male vocal", "upbeat", "low quality"] | 4 | pbVYSktQ5jE | 4726 |
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;