musiccaps_details (view)
4 rows where musiccaps_aspects contains "brass section" and musiccaps_aspects contains "male voice"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- brass section · 4 ✖
- male voice · 4 ✖
- anime 1
- bass 1
- bassoon 1
- claves 1
- dramatic 1
- funny speaking 1
- harp 1
- hissing sounds 1
- latin pop 1
- medium to uptempo 1
- mid-range singing 1
- movie music 1
- mystery 1
- opera 1
- orchestra piece 1
- peculiar 1
- percussion 1
- piano 1
- radio play 1
- rising pattern 1
- romantic mood 1
- slow dance song 1
- sneeze 1
- story-telling 1
- string section 1
- theatrical piece 1
- timpani 1
- upright bass 1
musiccaps_names (array) 9 ✖
- Music 4
- Classical music 1
- Music of Latin America 1
- Opera 1
- Salsa music 1
- Scary music 1
- Singing 1
- Speech 1
- Theremin 1
youtube_published (date) 4 ✖
- 2010-03-26 1
- 2011-07-27 1
- 2011-08-21 1
- 2015-07-19 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Orq. Bronco - Duena De Mi Cuerpo | This Latin pop song features a male voice singing the main melody. The voice sings at a high pitch. This is accompanied by Latin style percussion. A variety of percussion is used including the claves and cowbell. The bass plays a groovy bassline. The piano plays chords with a Latin feel. The brass section plays fills in between lines. This song has a romantic mood. This song can be played in a party for a slow dance. | 2010-03-26T03:09:29Z | EdwardMulenze | gran orquesta venezolana de finales de los 80.. se caracteriza por la finura y la cuerda de sus trombones disfrutenlo... | ["Music", "Music of Latin America", "Salsa music"] | ["latin pop", "male voice", "slow dance song", "bass", "percussion", "piano", "brass section", "romantic mood", "claves"] | 0 | 92QYLjfo68Q | 972 | |
Ivan Momirov - Adriana Lecouvreur | This song contains a brass section playing a melody and a string section taking over with a melody. A harp is playing a melody in the background along with plucked celli. An upright bass is playing single notes along. A male voice is singing loud and with an opera technique. This song may be playing while watching an opera. | 2015-07-19T14:34:29Z | Ivo Yordanov | Sandra Mitrovska and Ivan Momirov. Conductor Stefano Romani. Form the opera Adriana Lecouvreur by Francesco Cilea. Production of Macedonian National Opera and Ballet. | ["Singing", "Music", "Opera", "Classical music"] | ["opera", "string section", "harp", "brass section", "upright bass", "male voice", "mid-range singing", "medium to uptempo"] | 6 | AnErEDywInE | 1170 | |
STAA Episode 1 - The Shifting | This is an excerpt from a dubbed anime. There is a male voice speaking in a funny manner. Then, a dramatic orchestra piece starts playing to imply something is about to happen. The brass section and the timpani are playing a rising pattern until a sneeze and hissing sounds can be heard. There is a peculiar feel to this track. Parts of it could be sampled for use in beat-making. | 2011-07-27T19:08:36Z | TheWINChestersInc | Oh yeah. This is happening too. Cass List: Omnibeneficial: Dean, Shapeshifter (sometimes) , Crotch Guy and Old Man ThroneofCipher: Sam xbubblemunkyx: Wife and Catherine TheDeathWombat: Shapeshifter | ["Music", "Speech", "Scary music"] | ["anime", "male voice", "funny speaking", "sneeze", "hissing sounds", "orchestra piece", "brass section", "timpani", "rising pattern", "dramatic", "peculiar"] | 9 | DgVpK6r7JT4 | 1503 | |
X Minus One - A Gun For Dinosaur | This is the recording of a radio play. There is a male voice narrating a story. As a transition piece, the bassoon plays a tune implying mystery and the brass section starts playing a little after. There is a theatrical aura to this piece. It could be used in the soundtrack of a movie as background music during scene transitions. | 2011-08-21T05:52:05Z | VistaRecordsBoard | Broadcast by NBC on March 7, 1956, this is a great story of time travel, dinosaurs, and attempted murder. | ["Music", "Theremin"] | ["radio play", "male voice", "story-telling", "bassoon", "brass section", "mystery", "theatrical piece", "movie music"] | 9 | f1UMPPWbCrU | 3916 |
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;