musiccaps_details (view)
2 rows where musiccaps_aspects contains "flat female vocal" and musiccaps_aspects contains "groovy piano melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- flat female vocal · 2 ✖
- groovy piano melody · 2 ✖
- low quality 2
- baby goat bleating sound effect 1
- bagpipe melody 1
- dark 1
- drum roll 1
- echoing dark rimshot 1
- fade in 1
- fun 1
- groovy bass 1
- happy 1
- mellow 1
- noisy 1
- punchy kick 1
- regional mexican 1
- soft reverberant female vocal 1
- wide acoustic guitar chords 1
musiccaps_names (array) 3 ✖
- Goat 1
- Music 1
- New-age music 1
youtube_published (date) 2 ✖
- 2011-12-28 1
- 2013-03-29 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Megan Fox Glamor Makeup Tutorial | The low quality recording features a flat female vocal shortly talking on a very noisy microphone, after which a song fades in. The song consists of soft, reverberant female vocal singing over echoing dark rimshots, punchy kick and groovy piano melody. Overall it has a dark and mellow vibe to it. | 2011-12-28T01:54:27Z | Julia Graf | My Website ⇒ http://hellojuliagraf.com/ ► SOCIAL MEDIA SNAPCHAT ⇒ https://www.snapchat.com/add/julia_graf INSTAGRAM ⇒ https://www.instagram.com/hellojuliagraf/ FACEBOOK ⇒ http://www.facebook.com/hellojuliagraf TWITTER ⇒ http://twitter.com/hellojuliagraf | ["New-age music"] | ["low quality", "fade in", "soft reverberant female vocal", "noisy", "flat female vocal", "echoing dark rimshot", "punchy kick", "groovy piano melody", "dark", "mellow"] | 4 | LAxCq-s84F8 | 2159 | |
Parto de un cabra murciana|MrSaravillo|. | The low quality recording features a baby goat bleating sound effects and regional Mexican song, that consists of wide acoustic guitar chords, groovy piano melody, drum roll, bagpipe melody and groovy, playing in the background. It sounds fun and happy and it seems like it is some kind of animal related TV show. | 2013-03-29T17:31:44Z | Mr Saravillo | Os invitamos a ver cómo pare una cabra en la cuadra del Queso de Saravillo. Cabritos para el Queso de Saravillo. www.quesodesaravillo.com info@quesodesaravillo.com | ["Goat", "Music"] | ["baby goat bleating sound effect", "regional mexican", "wide acoustic guitar chords", "groovy bass", "drum roll", "bagpipe melody", "flat female vocal", "groovy piano melody", "fun", "happy", "low quality"] | 4 | hTNKYJ6suII | 4108 |
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;