musiccaps_details (view)
3 rows where musiccaps_aspects contains "crowd noise" and musiccaps_aspects contains "live recording"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- crowd noise · 3 ✖
- live recording · 3 ✖
- instrumental 2
- low fidelity 2
- active drums 1
- boomy 1
- bowed bass 1
- bowed violin 1
- drum kit 1
- eastern european 1
- electric bass 1
- gaiety 1
- levity 1
- male voice 1
- no drums 1
- percussion 1
- piano 1
- piano trio 1
- pretty piano 1
- sidestick 1
- string ensemble 1
- techno song 1
- vocoder 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sandor Ciurcui "Sandorica" from Soporul de Campie with MetroFolk - slow csardas (de doi pasi) | Low fidelity live recording of an instrumental eastern European string ensemble with bowed violin, bowed bass. Crowd noise is audible. No drums are present. There is a feeling of gaiety and levity. | 2009-09-28T17:00:45Z | aronszekely | 09/27/09 - Bohemian Hall in Astoria Queens Sandor "Sandorica" Ciurcui - violin Aron Szekely - viola Attila Papp - bass Sandor is is one of the most celebrated Transylvanian violinists. He has toured the globe and has recorded countless albums. MetroFolk is the premier Hungarian-Romanian-Gypsy string band in the New York-New Jersey area. For more info on booking the MetroFolk band or to view upcoming events: http://metrofolk.blogspot.com | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["bowed violin", "gaiety", "levity", "bowed bass", "eastern european", "string ensemble", "instrumental", "no drums", "live recording", "crowd noise", "low fidelity"] | 8 | GPwzpw_47Dg | 1718 | |
Karla Urias singing Amazing Grace w/Gospel Choir | A live recording of an instrumental piano trio. The recording is boomy and low fidelity. The drumming is active and the piano playing is pretty. The drum kit features a sidestick. Electric bass is also present. Crowd noise can be heard. Sounds like gospel music that might be heard at a church service. | 2007-07-31T04:49:03Z | Karla Urias | This was the Gospel Choir + Me singing Amazing Grace 7-29-2007 @ the Fairbanks Summer Arts Festival | ["Gospel music", "Music"] | ["live recording", "boomy", "low fidelity", "piano trio", "instrumental", "drum kit", "sidestick", "piano", "electric bass", "active drums", "pretty piano", "crowd noise"] | 8 | gAURHUoIK0M | 4011 | |
Kobe Bryant - Mama, There Goes That Man! HD | This clip features a live recording of low quality. The song is mixed into a video clip. The sound of crowd cheering is heard. The song features a male voice using a vocoder. The song is in the techno genre. The percussion is programmed and plays a techno beat. The bass plays simple root notes of chords. Synth bursts are played at the beginning and at the end of the song. The referee whistle is heard toward the middle of the clip. | 2009-08-17T06:26:55Z | marjizee | Kobe Bryant puttin' on a clinic. | ["Music", "Inside, public space"] | ["live recording", "crowd noise", "techno song", "vocoder", "male voice", "percussion"] | 0 | hFj0KUzofNg | 4088 |
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;