musiccaps_details (view)
3 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2009-12-12
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
musiccaps_names (array) 10 ✖
- Music · 3 ✖
- Burping, eructation 1
- Christmas music 1
- Guitar 1
- Inside, large room or hall 1
- Jingle (music) 1
- Musical instrument 1
- Plucked string instrument 1
- Pop music 1
- Reverberation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ted Greene Blues Guitar Lesson - Part 1 | The low quality recording features a chill electric guitar melody. It sounds easygoing and relaxing. The recording is noisy and in mono. | 2009-12-12T05:10:57Z | TedGreeneArchives | A rare and wonderful view into Ted's world. Here Ted gives a lesson covering the Blues in all it's aspects. Circa 1992 - Video Credits: Brian Totten My Life with The Chord Chemist: A Memoir of Ted Greene, Apotheosis of Solo Guitar by Barbara Franklin - Available at amazon.com http://www.amazon.com/My-Life-Chord-C... Visit http://www.tedgreene.com for all things Ted | ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, large room or hall"] | ["low quality", "mono", "noisy", "chill electric guitar melody", "easygoing", "relaxing"] | 4 | D-PxXM2I5gY | 1426 | |
Cool Christmas Songs | The music features a male voice singing a melody in the med-high register. The drummer plays a steady and repeating rhythm. The bass guitar, for the most part, plays two repeating notes every beat. A synth sound is playing a melody in the mid-high register. Listening to this song I get Christmas vibes. | 2009-12-12T18:07:55Z | Arvanne H.V.B | Subscribe for more cool music videos! LINK TO THE SECOND VIDEO: http://www.youtube.com/watch?v=9WTTqlja0_U LINK TO THE FIRST TECHNO EDITION!: http://www.youtube.com/watch?v=ljuUIjYFRg8 LINK TO THE SWEDISH TECHNO EDITION!: http://www.youtube.com/watch?v=6M7dnmnnO_o I Love Christmas, and their songs, So I uploaded a video with 4 Christmas songs! Please react and rate! Playlist: Wham- Last Christmas Cher- Chrismas Maria Carey- All I Want For Christmas Dean Martin-Let It Snow | ["Christmas music", "Jingle (music)", "Music", "Pop music"] | ["male voice", "drums", "synth sound", "bass guitar", "christmas vibes"] | 2 | XwhAoMLNYWQ | 3238 | |
Burping Bunnies | The low quality recording features a sipping sound effect and some repetitive, weird burping sounds, while the jazz song is playing in the background. It sounds like it is an audio from some cartoon on a TV, as it sounds mono and a bit noisy too - like it was recorded with a phone. | 2009-12-12T01:36:01Z | Birdlady26 | This video was intended for laughs! It's is cute and funny! | ["Burping, eructation", "Music"] | ["low quality", "noisy", "sipping sound effect", "repetitive weird burping sounds", "mono", "jazz", "mono"] | 4 | YpOHemscGCk | 3312 |
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;