musiccaps_details (view)
1 row where musiccaps_aspects contains "abstract", musiccaps_aspects contains "incessant beeping", musiccaps_names contains "Music" and musiccaps_names contains "Sidetone"
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 |
---|---|---|---|---|---|---|---|---|---|---|
[PSP] Digimon Adventure Walkthrough Part 67 - (Special Episode 7 - Tagiru and Arrestardramon) | This music is instrumental. There is no harmony, just an incessant dissonant beep, loud explosive sound and static in the background. The sounds are of those in a video game. | 2013-03-15T16:57:42Z | Bowser Zeki | Meeting Tagiru/Arrestardramon :( Not Gumdramon :(:(:(:(: TRANSLATIONS (credit to Boukenda from Gamefaqs): (Taichi and co walk in, see a battle) Taichi: That's... Gankuumon! Agumon: Who's he with? Tagiru: Awesome! It's a fight with the best heavyweights around! Go get 'em, Arrestdramon! Arrestdramon: RAAWR! Gankuumon: ... Nuisance. (Attacks back) Arrestdramon: Graah! Tagiru: Arrestdramon! Taichi: Found you, Gankuumon! Gankuumon: ... (Disappears) Agumon: Aww... gone again. Taichi: We have to go after him! Tagiru: Dangit. He ran away! Arrestdramon: Sorry, Tagiru. Tagiru: It's fine, it's fine. We'll just look for him again. Taichi: Hey, are you Taiki's friend? Tagiru: Taiki... Ah... AH! Agumon: Whoa! Tagiru: Oh man... I forgot all about Taiki! Tagiru: Arrestdramon, let's head back. Arrestdramon: Tagiru... what about them? Tagiru: Oh shoot, I forgot. You guys wanna come with? Taichi: Uh, sure! AREA 2: Tagiru: I'm Tagiru Akashi, and this is Arrestdramon. Arrestdramon: A pleasure to meet you, Taichi and Agumon. Taichi: Same here! Agumon: Nice to meet ya! Tagiru: I'm Taiki's junior as a Digimon Hunter! Taichi: Wha-? Agumon: A Digimon... Hunter?! Tagiru: Oh it's fine, it's fine! We don't hunt other people's Digimon. Agumon: T-That's good. AREA 3: (Evil Arrestdramon appears) Arrestdramon: That's my clone! Tagiru: It really is! Just like you said! Taichi: Let's do this, guys! {BATTLE} Arrestdramon: We did it Tagiru! Tagiru: That's what I'm talking 'bout, Arrestdramon! Taichi: We beat him, Agumon! Agumon: Yeah, but that was tough... Tagiru: Now Taichi can go home! Arrestdramon: !! Agumon: !! (SUDDENLY, GANKUUMON) Gankuumon: Your efforts are in vain, Chosen Children. Taichi: !! Gankuumon! Agumon: You hurt Hackmon, our friend! Tagiru: This time we're gonna catch you! Arrestdramon: Prepare yourself! Gankuumon: .... Hackmon: Ugh.... uh... Taichi: Hackmon! Hackmon: Taichi... Agumon... Gankuumon: You've finally recovered? Have you trained properly? Hackmon: Did you fall for my powerful punch(line)? Gankuumon: ... Haha… | ["Music", "Sidetone"] | ["instrumental", "static", "intense", "electronic sounds", "whooshing", "incessant beeping", "white noise", "video game sounds", "abstract", "rhythmic beeps", "shooting", "explosions"] | 7 | 0s0Uy0-zBa0 | 215 |
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;