musiccaps_details (view)
2 rows where musiccaps_aspects contains "generic", musiccaps_aspects contains "no singer" and musiccaps_aspects contains "sound effects"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- generic · 2 ✖
- no singer · 2 ✖
- sound effects · 2 ✖
- acoustic drums 1
- action-filled 1
- bass guitar 1
- brass section 1
- electric guitar 1
- electronic drums 1
- energetic 1
- instrumental 1
- instrumental rock 1
- jingle 1
- keyboard 1
- mild 1
- movie music 1
- synth bass 1
- tv series theme 1
- zipper 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
7 jours pour agir: generique | This is an opening theme for a TV series. It is an instrumental piece. The main theme is being played by a loud brass section. There is a groovy synth bass line playing. The rhythmic background consists of a strong electronic drum beat. The atmosphere is energetic. This piece could be used in lifting samples for beat-making. | 2007-04-27T16:05:45Z | nanardu88 | je trouve pas d'épisode! | ["Theme music", "Music"] | ["tv series theme", "no singer", "instrumental", "brass section", "synth bass", "electronic drums", "sound effects", "generic", "action-filled", "energetic", "movie music"] | 9 | LCzldLY3E4g | 2164 | |
Descubre como las Bolsas Zipper de Albal pueden facilitarte la vida con su cierre Zzzzip | This is an instrumental rock piece which is a jingle for an ad. There is a clean electric guitar and a high-pitched keyboard playing the main melody. There is a mild bass guitar in the background supporting the melody. In the rhythmic background, there is a rock beat being played by the acoustic drums. A zipper sound effect can be heard synchronized with the ad. The atmosphere is very generic and calm. It is most suitable as an ad jingle or music behind a tutorial video. | 2014-09-24T11:01:18Z | Albal | Las Bolsas Zipper de Albal permiten conservar, congelar y transportar cualquier tipo de alimento fresco o cocinado con total seguridad. No se sale y se puede llevar a cualquier sitio. | ["Zipper (clothing)", "Music"] | ["instrumental rock", "no singer", "jingle", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "sound effects", "zipper", "generic", "mild"] | 9 | M4yst1q1nlU | 2241 |
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;