musiccaps_details (view)
3 rows where musiccaps_aspects contains "noisy", musiccaps_author = 4 and "youtube_published" is on date 2008-07-10
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 |
---|---|---|---|---|---|---|---|---|---|---|
Couperin Prélude 5 L'Art de toucher le Clavecin Mário Trilha | The low quality recording features a harpsichord melody being played. The recording is extremely noisy and it sounds passionate and emotional. | 2008-07-10T09:41:52Z | Mario Marques Trilha | François Couperin(1683-1733) Prélude 5 from L'Art de Toucher le Clavecin Historical Harpsichord by Jacques Germain, Paris 1785 Recorded at The National Music Museum Vermillion South Dakota Harpsichord: Mário Marques Trilha | ["Harpsichord", "Keyboard (musical)"] | ["low quality", "noisy", "harpsichord melody", "passionate", "emotional"] | 4 | 2ZrqWkdwVzo | 382 | |
Cooley's Reel and The Wise Maid | The low quality recording features a picked mandolin solo melody. Even though the recording is noisy and in mono, it gives off joyful and happy vibes. | 2008-07-10T22:49:46Z | tantoonie0 | Again, I play slow through this reel the first couple of times than pick it up to a session tempo (maybe a little faster). The second tune is one I've done on the tenor guitar, but which goes really well in this set, which I learned from a session in Knoxville, Tennessee. | ["Guitar", "Music", "Mandolin", "Plucked string instrument", "Bluegrass"] | ["low quality", "noisy", "mono", "picked mandolin solo melody", "joyful", "happy"] | 4 | pxEmmUYLHrE | 4744 | |
baltimore club house music Spongebob remix- by dj Johnny Blaze | The low quality recording features a club house song that consists of groovy 808 bass, crispy claps, shimmering muffled shakers and high pitched harmonizing male vocals singing over it. The recording is thin and it sounds groovy, fun and happy. | 2008-07-10T13:40:28Z | ihate googleplus | spongebob squarepants by a baltimore club dj Johnny Blaze | ["House music", "Music", "Soundtrack music", "Happy music"] | ["low quality", "club house", "groovy", "noisy", "thin", "groovy 808 bass", "crispy claps", "high pitched harmonized male vocals", "shimmering muffled shakers", "fun", "happy"] | 4 | rGEJVUcFA2U | 4861 |
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;