musiccaps_details (view)
5 rows where musiccaps_aspects contains "live recording", musiccaps_aspects contains "low fidelity", musiccaps_author = 8 and musiccaps_names contains "Music"
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 | |
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;