musiccaps_details (view)
8 rows where musiccaps_aspects contains "live recording" and musiccaps_author = 8
This data as json, CSV (advanced)
| 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 | |
| SummerQueen's 1st Scratch lesson | Live, amateur recording of record scratching over an instrumental old-school hip hop beat. | 2007-06-30T13:28:54Z | SummerQueen | Summie aan het scratchen voor de eerste keer in januari 2005 | ["Scratching (performance technique)", "Electronic music", "Music", "Scratch"] | ["record scratching", "old-school hip hop", "amateur recording", "live recording", "instrumental"] | 8 | 9YnYlDFKn-U | 1019 | |
| 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 | |
| Ewald - Quintet No. 1, I. Moderato | A live recording of a brass ensemble in a chamber style arrangement. Natural reverb from a recital hall is present. The music features counterpoint amongst the different instruments, and the mood is stately and noble. | 2010-03-03T22:12:00Z | FlatironsBrass | ["Brass instrument", "French horn", "Trombone", "Trumpet"] | ["live recording", "recital hall", "natural reverb", "brass ensemble", "chamber music", "stately", "noble", "counterpoint"] | 8 | dzW5M4sCphI | 3833 | ||
| 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;