musiccaps_details (view)
2 rows where musiccaps_aspects contains "rising pattern" and musiccaps_aspects contains "synth"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- electronic drums 2
- rising pattern · 2 ✖
- synth · 2 ✖
- amateur recording 1
- beep 1
- eerie 1
- electronic dance 1
- energetic 1
- jingle 1
- live performance 1
- loud 1
- piano 1
- poor quality 1
- sound effects 1
- toy 1
- uneasy 1
- upbeat 1
- vocal sample 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Justice - Stress (live at sónar08) | This is a live performance of an electronic dance music piece. There is a vocal sample repeating the same line. A synth is playing the tune while the electronic drums are playing the rhythm. There is a rising pattern and an energetic atmosphere. If it were not for the poor quality of the recording, this piece would fit nicely at a nightclub. | 2008-06-23T11:12:06Z | djfmv | Justice live! @ Sónar 2008, Barcelona (20.6.08) by DJF | ["Electronic music", "House music", "Crowd", "Music", "Bang"] | ["electronic dance", "live performance", "amateur recording", "vocal sample", "synth", "rising pattern", "electronic drums", "loud", "energetic", "upbeat", "poor quality"] | 9 | G22YfD5xxMU | 1687 | |
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;