musiccaps_details (view)
4 rows where musiccaps_aspects contains "keyboard accompaniment" and musiccaps_aspects contains "sonic effects" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 70 ✖
- keyboard accompaniment · 4 ✖
- sonic effects · 4 ✖
- exciting 2
- instrumental music 2
- movie soundtrack 2
- philharmonic orchestra 2
- poor audio quality 2
- adventure 1
- against all odds 1
- animated movie 1
- auto tuned female vocals 1
- backup singers 1
- bad audio quality 1
- choral harmony 1
- composer 1
- concert hall 1
- conductor 1
- cyberwars 1
- dance club 1
- dance floor 1
- dancers 1
- dangerous game 1
- energetic 1
- entertaining 1
- enthusiastic 1
- ethereal music 1
- ethereal tones 1
- euro pop hits 1
- fast tempo 1
- fight the machines 1
- groovy bass line 1
- groovy dance rhythm 1
- groovy drum rhythm 1
- grunge tones 1
- horns playing trumpets 1
- keybiard accompaniment 1
- magical energy 1
- magical journey 1
- male singer 1
- male singers 1
- medium fast tempo 1
- medium tempo 1
- ominous 1
- opera hall 1
- passionate 1
- percussion hits 1
- percussive bass line 1
- pulsating energy 1
- rap singer 1
- reggae music 1
- retro dance hits 1
- rhythm section 1
- russian pop hits 1
- russian singer 1
- sci-fi movie 1
- slow rap chants 1
- spirited 1
- story telling 1
- string section harmony 1
- super hits 1
- techno dance hits 1
- techno drumming rhythm 1
- tero pop hits 1
- ticking clock percussions 1
- trance party 1
- various percussion effects 1
- various sound effects 1
- violins 1
- vocal harmony 1
- western classical music 1
musiccaps_names (array) 6 ✖
- Music 4
- Scary music 2
- Afrobeat 1
- Electronic music 1
- Hip hop music 1
- Techno 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ghana Hiplife: VIP : Manenko | A male singer sings this reggae melody with backup singers in vocal harmony. The song is medium fast tempo with a groovy drum drumming rhythm, keyboard accompaniment, percussive bass line and various percussive effects. The song is groovy and enthusiastic with a reggae influence. | 2007-07-10T10:45:13Z | vyrusnana | vission in progress | ["Afrobeat", "Music", "Hip hop music"] | ["male singers", "backup singers", "vocal harmony", "keyboard accompaniment", "reggae music", "tero pop hits", "retro dance hits", "groovy dance rhythm", "percussive bass line", "groovy drum rhythm", "keybiard accompaniment", "sonic effects", "horns playing trumpets", "passionate", "story telling", "spirited", "enthusiastic", "exciting", "medium fast tempo"] | 1 | 4Lk8pUeLCwQ | 559 | |
Harry Potter And The Prisoner Of Askaban - Expecto Patronum | The song is an instrumental. The tempo is slow with a choir harmonising and creating ethereal chants, string section and a philharmonic orchestra harmony backing. The song is ethereal and magical. The song has poor audio quality. | 2012-01-03T20:03:03Z | GillyWeed | Harry Cunjur's a patronus to save him and his god father sirus black, I DO NOT OWN ANY OF THS CONTENT IT ALL BELONGS TO WARNER BROTHERS ECT ,, THANKS FOR WATCHING (Y) | ["Music", "Scary music"] | ["instrumental music", "movie soundtrack", "ethereal music", "philharmonic orchestra", "slow rap chants", "choral harmony", "magical energy", "magical journey", "violins", "string section harmony", "rhythm section", "ethereal tones", "pulsating energy", "bad audio quality", "concert hall", "opera hall", "conductor", "composer", "western classical music", "sonic effects", "keyboard accompaniment"] | 1 | xlxxWFENWr8 | 5351 | |
Russen Techno Remix | A male Russian singer sings this rap vocals with a female backup singer in vocal harmony. The song is fast tempo with techno drumming rhythm, percussive bass line, keyboard accompaniment and sonic effects. The song is a techno dance hit. The audio quality is poor. | 2008-10-23T14:40:58Z | CoolerRussenking | Russische Musik mit Verschiedenen Bildern. | ["Electronic music", "Music", "Techno"] | ["russian singer", "male singer", "rap singer", "poor audio quality", "fast tempo", "techno drumming rhythm", "groovy bass line", "keyboard accompaniment", "grunge tones", "sonic effects", "auto tuned female vocals", "exciting", "energetic", "entertaining", "dancers", "dance floor", "dance club", "trance party", "russian pop hits", "euro pop hits", "techno dance hits"] | 1 | dDKUjMHerLs | 3770 | |
Transformers 3 Soundtrack #3 Lost Signal- Steve Jablonsky | The song is instrumental. The tempo is medium with a steady percussive rhythm, keyboard accompaniment, string section harmony and various sound effects. The song is ominous and full of suspense. The song is a movie soundtrack and has poor audio quality. | 2011-07-01T17:15:00Z | TheP1291pictures | soundtrack | ["Music", "Scary music"] | ["movie soundtrack", "sci-fi movie", "instrumental music", "poor audio quality", "various percussion effects", "dangerous game", "adventure", "against all odds", "fight the machines", "cyberwars", "animated movie", "super hits", "sonic effects", "philharmonic orchestra", "ticking clock percussions", "various sound effects", "percussion hits", "ominous", "instrumental music", "medium tempo", "keyboard accompaniment"] | 1 | zSq2D_GF00o | 5479 |
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;