musiccaps_details (view)
3 rows where musiccaps_aspects contains "distortion" and musiccaps_author = 3
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- distortion · 3 ✖
- live recording 2
- accordion 1
- background ambient noise 1
- church bell 1
- distorted audio 1
- electric guitar 1
- high pitched 1
- large bell ringing 1
- low quality audio 1
- passionate male vocalist 1
- poor audio quality 1
- poor quality audio 1
- resonance 1
- south asian music 1
- speaking male 1
- tabla 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
How to tap on guitar (super fast tapping lesson) | This is a tutorial on the electric guitar. The guitar is high-pitched and rapid arpeggio notes are played on it. The audio is of a poor quality. The individual makes a comment at the end of the video. | 2008-05-26T02:36:00Z | Amanda Riddle | just me explaining the best i can how to tap on a guitar and the different kinds of tapping. I also explain how to do what i like to call video game tapping (One, lots of dragonforce stuff) woohoo over 100,000 views :) Thanks alot everyone. I hope that this video has helped you out. In light of this milestone, I plan to be producing more videos very very soon. So subscribe or just keep checking my channel (sp? lol) | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["electric guitar", "distortion", "high pitched", "live recording", "poor quality audio", "distorted audio", "background ambient noise", "speaking male"] | 3 | 8Bu8CkR1xZY | 901 | |
NAWAZ SHARIF "SONG"HUM DEKHEN GAY | This is a traditional south asian song. We have an accordion-like instrument for the melodic component and a tabla for percussion. The singer has a passionate voice. The audio quality is poor and the song distorts. | 2010-08-21T08:14:10Z | TheSaifpakiloverboy | ["Music", "Middle Eastern music"] | ["south asian music", "low quality audio", "distortion", "accordion", "tabla", "passionate male vocalist"] | 3 | GjE_iD2BbFg | 1751 | ||
Cloches - Lausanne (CH-VD) cathédrale réformée Notre-Dame - solos des 7 cloches | There is a very large bell ringing, and we hear the resonance thereafter. The bell rings repeatedly throughout the whole clip. The audio quality of the clip is poor, and we hear distortion in the clip as a result. | 2012-09-03T09:33:33Z | Quasimodo Sonneur-de-Cloches | http://quasimodosonneurdecloches.ch/ ********** Cloche 1, le bourdon, "Marie-Madeleine", coulée par Franz Sermund de Berne en 1583. Note : lab2, poids 5'610kg, diamètre 208cm. Cloche 2, "Clémence", coulée en 1518, de fondeur inconnu. Note : do3, poids 3'428kg, diamètre 173cm. Cloche 3, "Lombarde", de fondeur inconnu, coulée en 1493, sonne tous les jours à midi. Note : mib3, poids 1'512kg, diamètre 139cm. Cloche 4, "Grande Centenaire", coulée par Jules Robert (Nancy) en 1898. Note : fa 3, poids 838kg, diamètre 111cm. Cloche 5, "St François", se trouvait jadis dans le clocher de l'église St-François, avant les travaux d'harmonisation. Coulée par Isaac Jaquier de Lausanne en 1666. Note : lab3, poids 699kg, diamètre 102cm. Cloche 6, "Petite Centenaire", coulée par Jules Robert (Nancy) en 1898. Note : sib3, poids 306kg, diamètre 82cm. Cloche 7, "Couvre-Feu", de fondeur inconnu, coulée entre le 13e et le 14e siècle. Sonnait jadis tous les soirs à 21h l'hiver et à 22h l'été (remplacée depuis 2002 par "St François"). Note : do4, diamètre 81cm. ---------- http://www.facebook.com/Quasimodosonneurdecloches | ["Bell"] | ["poor audio quality", "live recording", "distortion", "large bell ringing", "church bell", "resonance"] | 3 | Npbs_4DZgEQ | 2368 |
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;