musiccaps_details (view)
6 rows where musiccaps_aspects contains "live recording" and musiccaps_aspects contains "low fidelity"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- live recording · 6 ✖
- low fidelity · 6 ✖
- crowd noise 2
- instrumental 2
- acoustic guitar 1
- active drums 1
- ambient noise 1
- analog synthesizer 1
- blown out 1
- boomy 1
- boomy bass 1
- bowed bass 1
- bowed violin 1
- camera noise 1
- distorted bass 1
- drum kit 1
- eastern european 1
- electric bass 1
- folk 1
- gaiety 1
- heartfelt 1
- house beat 1
- house music 1
- levity 1
- monosynth 1
- nightclub 1
- no drums 1
- passionate male singer 1
- piano 1
- piano trio 1
- poorly recorded 1
- pretty piano 1
- sidestick 1
- singer-songwriter 1
- small microphone 1
- sound check 1
- string ensemble 1
- strumming 1
- too loud 1
- woman shouting 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Little Apple - 2014 Hot Song in China | A male singer-songwriter accompanied by a strummed acoustic guitar and singing passionately a heartfelt folk song. The recording is somewhat low fidelity and live. | 2014-07-31T04:21:01Z | 2014 Boyz | Hottest Holy Song for Square Dancing | ["Music", "/t/dd00003", "Outside, urban or manmade"] | ["low fidelity", "live recording", "acoustic guitar", "passionate male singer", "singer-songwriter", "strumming", "heartfelt", "folk"] | 8 | 3tK7PpCo0PQ | 512 | |
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 | |
RMI Harmonic Synthesizer quick test | Sounds like a poorly recorded live sound check of an analog mono synthesizer. Low fidelity with ambient noise in the background. | 2016-03-10T20:48:55Z | Vykaar Tones | RMI Harmonic Synthesizer with inexperienced driver in discovery mode. Purely for interest and not for musical entertainment. Manufactured by Allen Organ Company Product : Harmonic Synthesizer Manufacturer : RMI Release date : 1974-1976 | ["Music", "Harmonic"] | ["live recording", "low fidelity", "ambient noise", "analog synthesizer", "sound check", "monosynth"] | 8 | MsEoUVWS59M | 2304 | |
lindby shuffle and jumpstyle | A low fidelity live recording of house music with camera noise from jostling a small microphone. | 2009-07-19T11:42:22Z | xminibby | just some shuffle and jupstyle S.U.B.S.C.R.I.B.E.!? | ["Music", "Shuffle"] | ["low fidelity", "live recording", "house beat", "camera noise", "small microphone"] | 8 | Y3WXrp3JFxU | 3252 | |
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 | |
Nino D'Aprile @ Sound X-Plosion SCRATCH -30.1.10- Tronix AFTERHOUR | Distorted, low fidelity house music live recorded from a nightclub featuring a boomy, blown out bass, male vocal sample and a woman shouting. Poorly recorded music for a boozy night out. | 2010-02-01T14:35:15Z | Save The Vinyl | X-Herford [Eks] Atomix Mr.Twister aka Marc Fisher / Twelve Inch aka Patrick Meier / Who Is Who / Millhouse / Nico De Luxe / Sopradoze aka Hou$egeflippt & No.23 / Dj Deville / Bob Morane / Spedro / NINO / Housegeflippt ( Late Night Beatz ) / G-Maxx / Ed Cee ( Keven Yard Limit Club - Lighthouse loud and proud minden ) / The Tablesliderz / Mr. Deepstar / Mighty Marc ( Go Parc Herford ) / Novel T. & Kay Topic ( Green Mark - Play Room Werry Kidz - Weser Beatz ) / Muzik Twinz ( michimuzik & A_Maze) X-Herford [Eks] Atomix ) Osianixx / 90-sechzig-90 / Booming B. / La Loona / Rekardo Rivalo / Dominic S. / Felix Kröcher / Format B / Moritz Piske / Hanne & Lore / Norman Zube / Rockwell & Landers / Funky Disco House - Minimal - Techno - Tech House - Electro - Speed Garage / Bünde / Herford / Bielefeld / Herford / Bad Qeynhausen / Müster / Melle / Osnabrück / Ego / Go Parc / Tronix / Depot / Dockland / Kick / Phuture Club / Mystic Land / Omen / Weser Beatz / PW / Stemwede / Waldfrieden / Underground / Level / Projekt / Break In / Cafe Europa / Dk Dance / Sound Garten / Aura / Glashaus / Fahrenheit / Relax / Dockland / Fusion / Index / Sfera / Mediahall / Gigaparc / Elephant Club / Stereo / Sams / Impuls / Stellwerk / Index / Bunker / Pollerwiesen / Sonne Mond Und Sterne / Time Warp / Love Family Park / Blauer See / Kiesgrube / Nature One / Loveparade / Street Parade / - DJ - Musik - Music - House - Electro - Minimal - Techhouse - Techno - Speed Garage - Club - Sound - Disco - Scratch - Scratchen - Mix - Mixe - Pioneer - CDJ 400 800 850 900 1000 mk3 mk2 Technics 1210 Turntable Party DJM 400 600 700 800 900 2000 | ["Beatboxing", "Music"] | ["low fidelity", "blown out", "house music", "boomy bass", "distorted bass", "woman shouting", "too loud", "nightclub", "poorly recorded", "live recording"] | 8 | j9hAUlz5kQs | 4240 |
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;