musiccaps_details (view)

6 rows where musiccaps_aspects contains "amateur recording" and musiccaps_author = 8

✎ View and edit SQL

This data as json, CSV (advanced)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
John Catalano Music : Dean Patton Rumba Flamenco in the States Two Talented Young Guitarist Amateur recording of two nylon string guitars playing in flamenco style. The playing is technically challenging yet sloppy. 2007-02-18T02:35:10Z John Catalano facebook.com/jphncatalanomusic 717-623-7166 John Catalano Teacher Saturday Classes in Gypsy Rumba at Catalano Music . Flamenca Rumba is lively music and developing in the United States Of America as here shown by the young guitar players. Gypsy Rumba In the 1990s the French group Gypsy Kings of Spanish descent became a popular New Flamenco group by playing Rumba Flamenca (or rumba gitana, Catalan rumba) music. ["Blues", "Flamenco", "Music", "Independent music", "Rhythm and blues"] ["amateur recording", "two acoustic guitars", "flamenco", "nylon string guitar", "technically challenging", "sloppy"] 8 -_OzT7Xyvok 64
Frontside - Nowy Utwór (by longas) Harsh amateur recording of hardcore aggressive speed metal. The recording is blown out and distorted. Male scream vocals can be heard as well as loud drums and distorted guitar. 2008-04-05T19:02:55Z 1ongas Coffins, Madvision, Fateborn, Frontside - 04.04.2008 - Lublin - Graffiti ["Music", "Rock music", "Pulse"] ["harsh", "agressive", "blown out", "distorted", "amateur recording", "speed metal", "hardcore", "male scream vocals", "loud drums", "distorted guitar"] 8 8pit9UV69S8 951
SummerQueen's 1st Scratch lesson Live, amateur recording of record scratching over an instrumental old-school hip hop beat. 2007-06-30T13:28:54Z SummerQueen Summie aan het scratchen voor de eerste keer in januari 2005 ["Scratching (performance technique)", "Electronic music", "Music", "Scratch"] ["record scratching", "old-school hip hop", "amateur recording", "live recording", "instrumental"] 8 9YnYlDFKn-U 1019
Beatboxen! Amateur recording of solo beat boxing of a cover of a popular song. 2008-02-02T23:04:30Z Lerg0n isch eifach hammergeil wie das tönt! ["Funk", "Music"] ["beat boxing", "cover", "popular song", "amateur recording"] 8 FtskdD6Py7Y 1673
Portable Roll up Digital USB Drum Pad Kit Instrument with Drumsticks CTL-9612 (2).mp4 Amateur recording of electronic drum sounds played in free time. The sound is quiet, low fidelity and instrumental. 2012-10-18T09:22:57Z vitebsk666 http://www.tinydeal.com/ru/portable-roll-up-usb-drum-kit-with-drumsticks-p-9720.html ["Wood block", "Drum", "Percussion"] ["quiet", "electronic drum sounds", "free time", "low fidelity", "amateur recording", "instrumental"] 8 T2pIUdaDMuA 2806
How to play - You don't know - Milow - on guitar - guitar lesson - gratismuziekschool.nl Amateur recording of solo acoustic guitar strumming. Tape hiss, room reverb and unintentional mic clipping is audible throughout. 2010-01-19T19:13:20Z Fast Track Music Lessons Click here for more free Guitarlessons http://www.gratismuziekschool.nl/gitaarles.html ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] ["acoustic guitar strumming", "room reverb", "tape hiss", "amateur recording", "unintentional mic clipping"] 8 Wh5JSj89tW8 3124

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;