musiccaps_details (view)
2 rows where musiccaps_author = 4 and "youtube_published" is on date 2015-08-24
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- acoustic rhythm guitar 1
- addictive 1
- bouncy snare hits 1
- echoing wide pig oink sound effects 1
- electric rhythm guitar melody 1
- energetic 1
- fun 1
- groovy bass 1
- groovy bass guitar 1
- groovy synth keys chords 1
- happy 1
- happy tinny bells melody 1
- harmonizing background vocals 1
- low quality 1
- muffled claps 1
- passionate male vocal 1
- rock 1
- shimmering shakers 1
- shimmering wide cymbals 1
- simple piano 1
- soft kick 1
- soft kick hits 1
- wide toms roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Crags - Please, Sniff The Air (Official) | The low quality recording features a rock song that consists passionate male vocal, alongside, harmonizing background vocals, singing over shimmering wide cymbals, bouncy snare hits, soft kick hits, electric rhythm guitar melody in the left channel, groovy bass guitar, acoustic rhythm guitar in the right channel of the stereo image and some wide toms roll. It sounds addictive and energetic. | 2015-08-24T07:36:04Z | Mathieu Epiney | Please, Sniff The Air by The Crags © 2015 www.thecrags.ch https://www.facebook.com/thecragsmusic Music Video by EPIDEMIC music video epidemic.ch epidemicmusicvideos@gmail.com Recorded & Mixed by Claude Lander @ Taurus Studio | ["Music", "Punk rock", "Grunge", "Soul music"] | ["low quality", "rock", "passionate male vocal", "harmonizing background vocals", "shimmering wide cymbals", "bouncy snare hits", "soft kick hits", "electric rhythm guitar melody", "groovy bass guitar", "wide toms roll", "addictive", "energetic", "acoustic rhythm guitar"] | 4 | U-UF93NA3ko | 2881 | |
PEPPA PIG - En la busqueda del tesoro! | This kids song features groovy synth keys, chords, simple piano melody, echoing and wide pig oink sound effects, shimmering shakers, muffled claps, soft kick hits and groovy bass. It sounds fun and happy - like something that children would listen to in their favorite tv shows. | 2015-08-24T16:32:53Z | eximent | Show en Vivo de Peppa Pig Mayor informacion del evento visite www.eximent.com //Live event under Rights EONE for © for Exim Entertainment (EXIMENT) LIVE SHOWS: | ["Music", "Oink"] | ["simple piano", "groovy synth keys chords", "echoing wide pig oink sound effects", "happy tinny bells melody", "shimmering shakers", "muffled claps", "groovy bass", "soft kick", "fun", "happy"] | 4 | tmabzx6yxqs | 5063 |
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;