musiccaps_details (view)
3 rows where "youtube_published" is on date 2011-09-16 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- e-bass 2
- acoustic drums 1
- amateur recording 1
- bongos 1
- brass section 1
- cover 1
- e-guitar 1
- e-guitars 1
- energetic 1
- low quality 1
- male voice singing 1
- medium to uptempo 1
- piano 1
- r&b/soul 1
- reverberant groovy piano 1
- rock/pop 1
- tambourine 1
musiccaps_names (array) 14 ✖
- Music 2
- Musical instrument 2
- Chorus effect 1
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Electric piano 1
- Guitar 1
- Keyboard (musical) 1
- Piano 1
- Plucked string instrument 1
- Reggae 1
- Song 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
B1A4 Beautiful Target Piano | The low quality recording features a reverberant groovy piano melody. It sounds like a cover and it is energetic. | 2011-09-16T17:52:22Z | jgmb829 | Download my sheets from 2011 - 2014 here. https://1drv.ms/u/s!AoBvqPi8rKgwaiKmGZ5B1P0hS-8?e=7jA4Wh See my playlist for all the past videos. Sheets: available at http://www.jgmb829.com/ | ["Electric piano", "Keyboard (musical)", "Piano"] | ["low quality", "reverberant groovy piano", "cover", "energetic"] | 4 | hwp7wCKIXg4 | 4153 | |
ARCHIE BELL & THE DRELLS - DANCING TO YOUR MUSIC (GLADES) | This song contains acoustic drums playing a groove along with an e-bass and a tambourine. A brass section is playing along with the drum fills and the bongos. A piano is playing a melody together with a guitar strumming chords in the mid range. The male singer sounds loud and soulful. This song may be playing in a rollerblade disco. | 2011-09-16T12:58:50Z | EddiesSoulSounds | More early 70's brilliance. This one from Texas giants Archie and the Drells who released this cracking mid-tempo dancer on the Miami based Gllades label from 1972. Great stuff! | ["Swing music", "Music", "Musical instrument", "Reggae", "Song"] | ["r&b/soul", "e-bass", "brass section", "e-guitar", "bongos", "acoustic drums", "male voice singing", "tambourine", "piano", "medium to uptempo"] | 6 | vx5iuWuE2Ng | 5220 | |
Z.VEX Effects Instant Lo-Fi Junky Chorus/Vibrato | Two e-guitars playing a melody. An electric bass is playing the rootnotes. They run through a chorus/vibrato effect. This song may be playing at home building a song with a loopstation. | 2011-09-16T20:14:07Z | Prymaxe | The Z.VEX Effects Instant Lo-Fi Junky Chorus/Vibrato provides you with that super unique Lo-fi Loop Junky tone... IN REAL TIME! not quite a compressor or a chorus/vibrato while simultaneously being both, the Z.VEX Effects Instant Lo-Fi Junky Chorus/Vibrato has loads of sounds on tap, whether it be warmer lo-fi comp, or shimmering bell like tones, the Z.VEX Effects Instant Lo-Fi Junky Chorus/Vibrato also features a 3 way wave selector switch to choose your poison, sine, square or triangle, in tandem with the speed and depth knobs for wild pitch vibrato or lush chorus tones! You can pick up the Z.VEX Effects Instant Lo-Fi Junky Chorus/Vibrato by giving us al call at 1-855-PRYMAXE or visiting the new home of tone, https://www.prymaxe.com | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument", "Distortion"] | ["rock/pop", "e-guitars", "e-bass", "amateur recording"] | 6 | kZYBpOwNGZU | 4330 |
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;