musiccaps_details (view)
4 rows where musiccaps_aspects contains "exciting", musiccaps_aspects contains "medium fast tempo" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- exciting · 4 ✖
- medium fast tempo · 4 ✖
- poor audio quality · 4 ✖
- energetic 3
- cymbals crashing 2
- emotional 2
- groovy bas slime 2
- guitar accompaniment 2
- instrumental music 2
- male singer 2
- passionate 2
- strong drumming rhythm 2
- acoustic guitars strumming 1
- adrenaline rush 1
- adventurous 1
- advertisement jingle 1
- african tribal percussions 1
- arena 1
- bass guitar solo 1
- camera click noises 1
- conductor 1
- country music 1
- crowds cheering 1
- dance rhythm 1
- drum rolls 1
- excitement in the air 1
- female singer 1
- groovy bass line 1
- groovy rhythm 1
- guitar band 1
- home music video 1
- horns playing 1
- keyboard accompaniment 1
- latin percussions 1
- latin pop hits 1
- live audience 1
- live in concert 1
- music jam 1
- percussive bass line 1
- philharmonic orchestra 1
- retro latin hits 1
- retro pop hits 1
- romantic 1
- safari adventure 1
- saxophone solo 1
- spirited 1
- steady drumming rhythm 1
- string section 1
- ukulele playing 1
- violins playing 1
- vocal duet 1
- youthful 1
- youtube songs 1
musiccaps_names (array) 12 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Los Autenticos Decadentes - Veni Raquel (Vivo Pepsi Music 2010) HD | A male singer sings this exciting Latin dance melody. The tempo is medium fast with a saxophone solo, percussive bass line, guitar accompaniment, latin percussion, steady drumming rhythm, and cymbal crashes. The song is exciting with the crowds going crazy. The audio quality is poor. | 2010-11-03T06:42:47Z | popartdiscosvivo | ARTISTA: LOS AUTENTICOS DECADENTES TEMA: VENI RAQUEL EN VIVO EN EL PEPSI MUSIC 2010 - COSTANERA SUR, BUENOS AIRES, ARGENTINA - 23/10/10 | ["Jazz", "Music"] | ["live audience", "saxophone solo", "bass guitar solo", "arena", "excitement in the air", "latin percussions", "strong drumming rhythm", "guitar accompaniment", "latin pop hits", "retro latin hits", "crowds cheering", "poor audio quality", "live in concert", "exciting", "energetic", "passionate", "adrenaline rush", "medium fast tempo", "male singer"] | 1 | 244y56-vLWE | 328 | |
Sony A77II - Review On Sony A77 MARK II Digital SLR Camera | The song is an instrumental. The song is medium fast tempo with African folk drumming rhythm, string section, violins playing, horns and woodwinds playing in harmony. The song is adventurous and exciting. The song is an advertisement jingle for a DSLR camera complete with camera click tones. The audio is of poor quality. | 2014-05-02T05:19:05Z | SonyA77II | http://amzn.to/2n9wRW6 - Click the link Now For best offer Sony A77II - Review On Sony A77 MARK II Digital SLR Camera The α77II has the world's fastest continuous shooting speed in its class1—up to 12 frames per second at full resolution. Equipped with a 79 point AF sensor and advanced auto focus tracking, technology, you never have to miss a moment. The α77II outperforms even more expensive rivals with continuous auto focus and auto exposure when shooting at 12fps at full 24.3MP resolution and can capture up to 60 frames in a single burst when in JPEG fine setting. The α77II houses a large APS-C sensor with approx. 24.3 effective megapixels for incredible detail and gorgeous enlargements. Its high resolving power adopts the same gapless on-chip lens structure as the α77II features the latest-generation RGB color filter and other cutting-edge device technologies developed by Sony, the number 1 manufacturer of image sensors https://www.youtube.com/watch?v=2ZfthfWQowE Like US - https://www.facebook.com/Sonya77lldigitalslrcamera Vist for best shopping : www.lykamart.com | ["Music", "Single-lens reflex camera"] | ["instrumental music", "african tribal percussions", "medium fast tempo", "string section", "violins playing", "groovy bas slime", "cymbals crashing", "philharmonic orchestra", "energetic", "poor audio quality", "strong drumming rhythm", "horns playing", "conductor", "advertisement jingle", "exciting", "safari adventure", "camera click noises"] | 1 | 2ZfthfWQowE | 379 | |
Gypsy - Tyler May & The Kentucky School of Bluegrass and Traditional Music Ensemble | The song is an instrumental. The song is medium fast tempo with a groovy bass line, acoustic guitars strumming rhythm, and a ukulele playing lead. The song is spirited and exciting. The song is an instrumental with country music influences. | 2011-04-23T00:46:35Z | Stewart Tyler May | Gypsy © 2011 by Stewart Tyler May Guitar - Josh Reimen Guitar - Leslie Strong Banjo - Jeremy Moses Mandolin - Isaac May Bass - Tina May Fiddle/Clawhammer Banjo - Tyler May | ["Banjo", "Country", "Music", "Mandolin", "Musical instrument", "Steel guitar, slide guitar", "Plucked string instrument"] | ["ukulele playing", "acoustic guitars strumming", "groovy bass line", "dance rhythm", "home music video", "youtube songs", "music jam", "spirited", "poor audio quality", "guitar band", "country music", "groovy bas slime", "energetic", "youthful", "exciting", "emotional", "dance rhythm", "instrumental music", "medium fast tempo"] | 1 | CudxWnS7ukw | 1413 | |
Zwan - Lyric (Video Version) | A male and female singer sing this vocal duet. The song is medium fast tempo with a guitar accompaniment, steady drumming rhythm with exciting drum rolls, cymbals crashes and a percussive bass line. The song is romantic and exciting. The song is retro pop with a bad audio quality. | 2009-10-27T01:54:19Z | Warner Records Vault | © 2005 WMG Lyric (Video Version) | ["Music", "Independent music", "Pop music", "Grunge"] | ["male singer", "female singer", "guitar accompaniment", "keyboard accompaniment", "vocal duet", "retro pop hits", "medium fast tempo", "poor audio quality", "groovy rhythm", "steady drumming rhythm", "percussive bass line", "keyboard accompaniment", "drum rolls", "cymbals crashing", "romantic", "exciting", "emotional", "adventurous", "passionate", "retro pop hits"] | 1 | CwmUMySSNQc | 1417 |
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;