musiccaps_details (view)
1 row where musiccaps_aspects contains "beep", musiccaps_aspects contains "rising pattern" and musiccaps_names contains "Cash register"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;