musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_names contains "Grunge" and musiccaps_names contains "Guitar" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 36 ✖
- acoustic drums 1
- adventurous 1
- advertising 1
- amp 1
- chorus 1
- crunchy 1
- distorted electric guitar 1
- distorted guitar lead 1
- e-bass 1
- e-guitar 1
- exciting 1
- gear showcase 1
- groovy bass line 1
- guitar rhythm 1
- guitar solo 1
- hard-hitting 1
- head bangers 1
- jam 1
- male singer 1
- male voice 1
- male voices singing 1
- medium tempo 1
- medium to uptempo 1
- people screaming 1
- poor audio quality 1
- positive 1
- retro classic rock 1
- rock 1
- rock band 1
- rock drumming rhythm 1
- rock groupies 1
- rock hits 1
- romantic 1
- screaming vocals 1
- story telling 1
- youthful 1
musiccaps_names (array) 14 ✖
- Grunge · 3 ✖
- Guitar · 3 ✖
- Music 3
- Rock music 3
- Heavy metal 2
- Musical instrument 2
- Plucked string instrument 2
- Progressive rock 2
- Christian music 1
- Electric guitar 1
- Electronic music 1
- Psychedelic rock 1
- Song 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
JC-120 Roland Jazz Chorus Amp | This is the recording of a gear showcase. There is a male voice advertising an effect amp. The distorted electric guitar is playing a crunchy-sounding riff with the added effect of the chorus amp. The atmosphere is hard-hitting. Some parts of this recording could be used in heavy guitar samples for beat-making. Such parts could also work in sections of an advertisement jingle. | 2007-03-13T06:13:47Z | nikmarkmedia | Johnny DeMarco and Gary Lenaire Show you the Amazing Powers of the Legendary Roland Jazz Chorus JC-120 | ["Electric guitar", "Guitar", "Heavy metal", "Music", "Musical instrument", "Rock music", "Speech", "Progressive rock", "Grunge", "Plucked string instrument"] | ["gear showcase", "jam", "male voice", "advertising", "distorted electric guitar", "guitar solo", "amp", "chorus", "hard-hitting", "crunchy"] | 9 | hRQJgZVxRX0 | 4103 | |
The Sunshine Underground - Put You In Your Place | This song contains a male voice repeating the same melody in a loop while another male voice is singing on top in a higher register. An acoustic drum is holding a four on the floor groove with a kick on every beat. The e-bass and e-guitar are playing along to the loop, repeating themselves. This song may be playing at a live concert downtown. | 2006-04-17T19:07:34Z | TomasTurbado | Videoclip indie rock | ["Electronic music", "Guitar", "Music", "Musical instrument", "Rock music", "Grunge", "Plucked string instrument"] | ["rock", "e-guitar", "e-bass", "male voices singing", "acoustic drums", "medium to uptempo"] | 6 | x7tOPTm31tQ | 5305 |
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;