musiccaps_details (view)
2 rows where musiccaps_aspects contains "piano" and musiccaps_aspects contains "rising pattern"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- piano · 2 ✖
- rising pattern · 2 ✖
- acoustic drums 1
- bass guitar 1
- beep 1
- choir 1
- dramatic singing 1
- eerie 1
- electric guitar 1
- electronic drums 1
- energetic 1
- jingle 1
- male vocal 1
- rock opera 1
- sound effects 1
- synth 1
- toy 1
- uneasy 1
- vibrant 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Praying Mantis Eats Cricket | This is a rock opera piece. There is a male vocalist singing passionately with a choir of backing vocals. The piano plays the main theme with the electric guitar while a bass guitar plays in the background. The rhythmic background is provided by the acoustic drums playing a simple rock beat. There is an energetic atmosphere to the piece. This piece could be used at sports venues. It could also be playing in the background of a bar. | 2008-05-05T19:45:40Z | caz50 | One of my mantis nymphs munching on a cricket. | ["Music", "Punk rock", "Grunge"] | ["rock opera", "male vocal", "dramatic singing", "choir", "piano", "electric guitar", "bass guitar", "acoustic drums", "rising pattern", "vibrant", "energetic"] | 9 | QqRrZzOY2xw | 2642 | |
CASH REGISTER TOY FOR GIRLS WITH REAL CALCULATOR LCD DISPLAY AND MIC | This is a jingle piece in the background of a toy advertisement. The toy is a cash register toy, so there are a lot of beeping sounds. There is a synth playing the main tune that is constantly rising up to a higher note while a piano is playing staccato chords alongside it. A cymbal-heavy electronic drum beat can be heard. The atmosphere is uneasy. Samples could be lifted from this track to be used in beat-making or in the soundtrack of a horror movie. | 2013-10-05T18:24:36Z | TIENDA JR | New cash registers machines toy for girls with real lcd display and calculator ideal to motivate your child in math, addition subtraction multiply and divide. Includes accessories and even a microphone that real works. Features: LED indicator pulsation real calculator microphone sound when pressed buttons dimensions 34 x 16 x 12.5 cm plastic material uses 3 AA batteries not included Recommended for ages 3+ https://www.tiendajr.com | ["Cash register", "Background music", "Beep, bleep", "Music"] | ["toy", "beep", "jingle", "synth", "rising pattern", "piano", "electronic drums", "uneasy", "eerie", "sound effects"] | 9 | eZ8yopmYtPM | 3878 |
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;