musiccaps_details (view)
1 row where musiccaps_aspects contains "energetic", musiccaps_aspects contains "shimmering hi hats" and "youtube_published" is on date 2008-09-21
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 |
---|---|---|---|---|---|---|---|---|---|---|
How to catch Deoxys on emerald,ruby,sapphire and mew | The low quality recording features a groovy buzzy synth bass with a filter effect on it, followed by punchy "4 on the floor" kick pattern, shimmering hi hats, wide mellow high pitched sound effect and echoing male vocal singing over it. It sounds energetic and groovy. | 2008-09-21T08:21:02Z | Qu Ju | ***CLICK MORE INFO*** http://adf.ly/2SIGT how to get on the island (cheats) *******UPDATE:Thanks if you need gameshark code ask and subscribe********** http://youtube.com/subscription_center?add_user=FizzDexter http://codeman273.com/ This is not fake only way to get on that island is to have Eon ticket;To get Eon ticket go spek to proffesor brich than go to abbandoned ship and speak to other proffesor he will give you ticket to catch deoxys you will need to push thah thing like me (becouse it's only way). HOPE I HELPED :D | ["Music", "Exciting music"] | ["low quality", "groovy buzzy synth bass", "echoing male vocal", "punchy \"4 on the floor\" kick", "electro", "shimmering hi hats", "wide mellow high pitched sound effects", "filter effect", "energetic", "groovy"] | 4 | 1IMi7yfZVVM | 255 |
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;