musiccaps_details (view)
2 rows where musiccaps_aspects contains "positive" and musiccaps_names contains "Grunge" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- positive · 2 ✖
- adventurous 1
- danceable 1
- distorted electric guitar 1
- distorted guitar lead 1
- electric guitar solo 1
- energetic 1
- exciting 1
- groovy bass line 1
- guitar rhythm 1
- happy 1
- head bangers 1
- male singer 1
- medium tempo 1
- no vocals 1
- people screaming 1
- poor audio quality 1
- powerfull 1
- retro classic rock 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- rock&roll 1
- romantic 1
- screaming vocals 1
- story telling 1
- upbeat drum kit 1
- youthful 1
musiccaps_names (array) 9 ✖
- Grunge · 2 ✖
- Music 2
- Christian music 1
- Guitar 1
- Heavy metal 1
- Progressive rock 1
- Psychedelic rock 1
- Rock music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Whip Ass Gaming: Twisted Metal Gameplay Demo | The song is a rock track that features distorted and energetic guitar strumming chords. A secondary guitar does a solo melody in the foreground. A drum kit plays a typical upbeat rock pattern with an energetic mood. A bass adds deepness to the track while playing the same progression as the strummed guitar. | 2008-05-09T21:11:29Z | Belpowerslave | The video gameplay demo showing off various levels and cars. Please note that this is *video* of gameplay footage, and most of the issues you'll see with the graphics are the fault of the low quality encode on the disc. | ["Music", "Grunge"] | ["rock&roll", "no vocals", "distorted electric guitar", "energetic", "electric guitar solo", "upbeat drum kit", "danceable", "happy", "positive", "powerfull"] | 5 | fxdWwzdeY_o | 3994 | |
Straight way Black or White Christian rock music Doug Middleton lead guitar | A male singer sings this rock melody. The song is medium tempo with a rock drumming rhythm, percussive bass line, distorted guitar accompaniment and keyboard accompaniment. The song is exciting and energetic. The song has poor audio quality. | 2010-01-26T03:10:24Z | tannere1 | Christian music Straight way title black or white doug middleton | ["Christian music", "Guitar", "Heavy metal", "Music", "Psychedelic rock", "Rock music", "Song", "Progressive rock", "Grunge"] | ["poor audio quality", "rock band", "poor audio quality", "retro classic rock", "story telling", "romantic", "adventurous", "rock groupies", "rock hits", "medium tempo", "guitar rhythm", "groovy bass line", "rock drumming rhythm", "people screaming", "distorted guitar lead", "male singer", "screaming vocals", "exciting", "positive", "youthful", "head bangers"] | 1 | njFM8DvmPVU | 4571 |
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;