musiccaps_details (view)
3 rows where musiccaps_aspects contains "accordion", musiccaps_author = 9 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- accordion · 3 ✖
- bass guitar 2
- acoustic drums 1
- advertisement 1
- american 1
- bed creaking 1
- cheerful 1
- electronic drums 1
- energetic 1
- erotic 1
- eurodance 1
- female vocal 1
- goofy tune 1
- jingle 1
- keyboard 1
- latin dance 1
- latin percussion 1
- laughter 1
- male vocal 1
- pastoral 1
- poor quality recording 1
- rapid singing 1
- seductive singing 1
- sensual 1
- sound effects 1
- upbeat 1
- yodeling 1
musiccaps_names (array) 5 ✖
- Music · 3 ✖
- /t/dd00032 1
- Music of Latin America 1
- Thunk 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Garcia - Bamboleo (HD) | This is a eurodance/latin dance music piece. The words are sung in the Spanish language by a female vocalist in a seductive manner. The main theme is played by the accordion while elements such as the keyboard and the bass guitar make up the melodic background. The rhythmic background consists of a basic 4/4 electronic drum beat and latin percussive elements. There is a sensual and erotic feel to this piece. It could be playing at latin dance nights at dance clubs. It could also work well as an accompaniment piece at a latin dance course. | 2012-04-15T09:44:28Z | Tin Goose | Garcia was a German eurodance project formed in 1996. They released six singles, two of which reached the top 20 in Germany and charted in Austria and Switzerland. The single "Bamboleo" was from 1997. | ["Music", "/t/dd00032"] | ["eurodance", "latin dance", "female vocal", "seductive singing", "accordion", "keyboard", "bass guitar", "electronic drums", "latin percussion", "sensual", "erotic", "energetic"] | 9 | 2vQTq4QLP8U | 415 | |
Torex Cough Syrup - Wedding Night Film | These are sounds coming from an advertisement. There are sound effects of bed creaking and laughter implying an intercourse is taking place. Then the act is interrupted by a goofy accordion tune. Sounds from this track can be used in soundboards or in beat-making. | 2012-12-20T17:06:07Z | Vihan Suryavanshi | Client - Torque Pharma Director - Vihan Suryavanshi Production Company - Dawn Motion Pictures Cinematography - Mitesh Mirchandani Associate Director - Prasad Shinde Executive Producer - Datta Londhe Creative - Sanjay Talpade Music - Amar Manglurkar Production Design - Mayur Offline - Jayant (In House - Avitel) Online - Chetan (In House - Avitel) Costumes - Deepali Salvi Sound Design - Kunal (4D Studio) Animation - Bikash Padhee Make Up & Hair - Shailesh Pawar Assistant Director - Aayush Saxena Post Studio - Avitel Hard Work... | ["Music", "Thunk"] | ["advertisement", "jingle", "sound effects", "bed creaking", "laughter", "accordion", "goofy tune"] | 9 | DU5pD63Pv30 | 1481 | |
Chicken Yodel - Kerry Christensen | This is a poor quality recording of a yodeling music piece. There is a male vocalist singing rapidly with the yodeling technique. The melody is being played by an accordion. There is a bass guitar playing in the background. The rhythm is provided by an upbeat acoustic drum beat. The atmosphere is cheerful. Despite the quality issue of the recording, it would suit well as a rural radio station music playing inside the car in a movie. | 2007-06-23T22:30:16Z | UnitedFan4Eva1 | Using RuneScape. Thanks To Madcrazykid1 ( Me ) MollyMoo22 ( My Sis ) --They are the main people-- If you wanna contact me, my MSN is josh.dude-@hotmail.co.uk Thanks! | ["Yodeling", "Music", "Music of Latin America"] | ["poor quality recording", "yodeling", "american", "male vocal", "rapid singing", "accordion", "bass guitar", "acoustic drums", "cheerful", "pastoral", "upbeat"] | 9 | s25X6KwBpxw | 4916 |
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;