musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "guitar strumming" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- energetic · 2 ✖
- guitar strumming · 2 ✖
- instrumental music 2
- poor audio quality · 2 ✖
- ambient noises 1
- ambient room noise 1
- casual playing 1
- dance rhythm 1
- delay pedal 1
- echo tones 1
- echoes 1
- exciting 1
- fusion music 1
- groovy rhythm 1
- guitar demo 1
- guitar effects pedal 1
- guitar lead 1
- hindustani music 1
- hissing sounds 1
- improvisational 1
- indian classical music 1
- live audience 1
- medium tempo 1
- passionate 1
- percussive bass line 1
- rehearsals session 1
- reverb peas 1
- spirited 1
- tabla percussions 1
- testing effects 1
- tone generator 1
- turning knobs 1
musiccaps_names (array) 9 ✖
- Music 2
- Country 1
- Distortion 1
- Echo 1
- Effects unit 1
- Flamenco 1
- Guitar 1
- Reverberation 1
- Tapping (guitar technique) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Raygun Fx - Aurora Lofi Delay Reverb (Mini Version) Guitar Fx Pedal Hand made UK | The song is an instrumental. The tempo is medium with a guitar strumming to different settings of an effects delay pedal with echoes and effects being heard. The song is an effects pedal demonstration. The audio quality is poor with hissing sounds. | 2015-01-22T22:59:06Z | RaygunFX | Raygun FX - Aurora LoFi Delay-verb mini All the same features and classic lofi delay tones of the standard Aurora delay From a short Reverb, to Slap back Delay, to a long spaced out delays and a bunch of lofi noises in between! For delay lovers, this freaky delay is an unusual beast, with some warm, but lofi tones. Controls: Blend, Repeat and Speed 9v DC Powered True bypass Green LED Rubber grip feet Quality clicking Jack input/output Medium Enclosure: 111mm x 55mm x 35mm http://fuzzboxes.co.uk/product/aurora-lofi-delay-verb-mini | ["Reverberation", "Tapping (guitar technique)", "Echo", "Effects unit", "Guitar", "Music", "Distortion"] | ["instrumental music", "turning knobs", "delay pedal", "poor audio quality", "hissing sounds", "rehearsals session", "ambient room noise", "guitar effects pedal", "tone generator", "poor audio quality", "guitar strumming", "echo tones", "testing effects", "guitar demo", "energetic", "casual playing", "reverb peas", "echoes", "medium tempo"] | 1 | RczzNAr1T_Q | 2715 | |
Anil Shahi - Maya Mantra (Instrumental) | The song is an instrumental. The song is medium tempo with a percussive tabla rhythm, groovy bass line and a guitar strumming rhythm and playing lead. The song is Indian classical fusion with a poor audio quality. | 2013-02-23T19:05:58Z | NepaliLyricsChords | http://NepaliLyricsChords.com Anil Shahi performing Maya Mantra (Instrumental) in Thamel Square Grand Opening Program Program Name: Thamel Square Grand Opening Location: JP Road, Thamel. Kathmandu Facebook Page (Thamel Square): https://www.facebook.com/ThamelSquare Facebook Page (Nepali Lyrics Chords): http://www.facebook.com/Golomech | ["Country", "Flamenco", "Music"] | ["indian classical music", "hindustani music", "improvisational", "energetic", "exciting", "passionate", "spirited", "live audience", "ambient noises", "dance rhythm", "guitar lead", "poor audio quality", "poor audio quality", "tabla percussions", "groovy rhythm", "guitar strumming", "instrumental music", "percussive bass line", "fusion music"] | 1 | TWm_2QncYXg | 2841 |
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;