musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality" and "youtube_published" is on date 2014-08-25
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- low quality · 2 ✖
- noisy 2
- addictive 1
- crowd noises 1
- electric guitar solo melody 1
- emotional 1
- energetic 1
- energetic cymbals 1
- groovy bass guitar 1
- intro 1
- live performance 1
- male laughing 1
- mono 1
- muffled kick hits 1
- muffled snare hits 1
- muffled trumpet melody 1
- passionate male vocal 1
- rock 1
musiccaps_names (array) 6 ✖
- Music 2
- Brass instrument 1
- Foghorn 1
- Musical instrument 1
- Roll 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SPYAIR - Samurai Heart (live) ENG subs | The low quality recording features a live performance of a rock song that consists of passionate male vocal singing over electric guitar solo melody, energetic cymbals, muffled snare and kick hits and groovy bass guitar. There are also some crowd noises, singing along. It sounds energetic, emotional and addictive, thanks to that cadence. | 2014-08-25T16:54:22Z | Rrhae Reyes | Video not mine credit to the owner But the subs are mine xD IKE is so handsome here This is a gintama perf so you can see the anime dubbers here | ["Singing", "Music", "Roll"] | ["low quality", "crowd noises", "noisy", "rock", "live performance", "electric guitar solo melody", "energetic cymbals", "muffled snare hits", "muffled kick hits", "passionate male vocal", "groovy bass guitar", "energetic", "emotional", "addictive"] | 4 | P3ZPbGjHFXE | 2499 | |
REBIRTH BRASS BAND - "Move Your Body" (Live in New Orleans) #JAMINTHEVAN | The low quality recording features a muffled trumpet melody playing. There is a random male laughing sound. The recording is very noisy and in mono. It sounds like an intro of a video. | 2014-08-25T20:17:54Z | Jam In The Van | Rebirth Brass Band - "Move Your Body" Live in New Orleans with Jam in the Van. Subscribe to Jam in the Van! http://bit.ly/subthejamvan Check out Rebirth Brass Band's other video from this session! https://www.youtube.com/watch?v=GaKkoqDa8Ng GET THE AUDIO HERE: http://www.jaminthevan.com/band/rebirth-brass-band/ http://jaminthevan.com http://facebook.com/jaminthevan http://twitter.com/jaminthevan *** About Jam in the Van*** Jam in the Van ==== Where music takes a whole new road. We will be traveling anywhere accessible by road to find and record intimate musical experience's for our fans. If you are interested in our cause let us know. Dig on our cool sponsors: Lagunitas Brewing Company Brewers of fine ales, mystery and romance. In Petaluma, Chicago, & the World. Give us a call! 707.769.4495 Don't click these... www.LAGUNITAS.com #lagunitas on Instagram: http://instagram.com/lagunitasbeer #lagunitas on Twitter: http://twitter.com/lagunitasbruhws #lagunitas on YouTube: http://youtube.com/user/lagunitasbrewing Ploom's got us rethinking music.... http://www.ploom.com/ Harrahs Casino keeps us sheltered http://www.harrahsneworleans.com/ Get the MXL Mic used during this video here: http://www.mxlmics.com Dig on the awesome Orange Amps used in these videos here: http://www.orangeamps.com We keep our gear in Osprey Packs! http://www.ospreypacks.com We use GoPro Cameras! http://www.gopro.com Our thirst is quenched with Aquahydrate! http://www.aquahydrate.com/ QSC Audio Products keeps it sounding heady! http://qsc.com/ Goal Zero helps us harness the power of the sun! http://www.goalzero.com/ *** Credits *** Artists: Rebirth Brass Band Director of Photography: Dave Yeaman Camera Operator: Chris Shashaty Recording Engineer: Jacob Lacally Mixing Engineer: Sean P. Jones Post Production by: Joel Moody Created & Produced by Jam in the Van, LLC Music by: Rebirth Brass Band http://rebirthbrassband.com Tour Dates: http://www.rebirthbrassband.com/events ••••• https://www.facebook.com/rebirthbrassband | ["Brass instrument", "Foghorn", "Music", "Musical instrument"] | ["low quality", "muffled trumpet melody", "male laughing", "noisy", "mono", "intro"] | 4 | wz-7sy_Rin4 | 5296 |
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;