videos
2 rows where categoryId = 22 and "publishedAt" is on date 2013-05-13
This data as json, CSV (advanced)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
WEXJSNm_T0o | 2013-05-13T18:29:24Z | UCO5IZjHpLLPX2K78e7wHNHA | FSU AcaBelles - ICCA South Semifinals 2013 | Party opb Beyoncé Arr: Maggie Tobin, Jasmine Edwards, Brianna Calderon Roman, Christine Phillips Solo: Alyse Faour MLK opb U2 Arr: Maggie Tobin, Jasmine Edwards Solo: Marah Oropeza Don't Wake Me Up opb Chris Brown Arr: Courtney Mickens Solo: Sammy Piccirilli Rest of My Life opb Ludacris & Usher Arr: Courtney Mickens Solo: Brittany Morrill & Aria Grosso Choreo: Jenn Lamb & Brittany Taman VP: Jenn Lamb | {"default": {"url": "https://i.ytimg.com/vi/WEXJSNm_T0o/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/WEXJSNm_T0o/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/WEXJSNm_T0o/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/WEXJSNm_T0o/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/WEXJSNm_T0o/maxresdefault.jpg", "width": 1280, "height": 720}} | FSU AcaBelles | 22 | none | {"title": "FSU AcaBelles - ICCA South Semifinals 2013", "description": "Party opb Beyoncé \nArr: Maggie Tobin, Jasmine Edwards, Brianna Calderon Roman, Christine Phillips \nSolo: Alyse Faour \n\nMLK opb U2\nArr: Maggie Tobin, Jasmine Edwards\nSolo: Marah Oropeza\n\nDon't Wake Me Up opb Chris Brown\nArr: Courtney Mickens\nSolo: Sammy Piccirilli \n\nRest of My Life opb Ludacris & Usher \nArr: Courtney Mickens\nSolo: Brittany Morrill & Aria Grosso \n\nChoreo: Jenn Lamb & Brittany Taman \nVP: Jenn Lamb"} | 84822 | 220 | 0 | 4 | |||
uCCdUB7D10U | 2013-05-13T06:03:31Z | UCrf521due-fLVlGznBX9rIQ | Heavy Metal Veteran of the Psychic Wars | {"default": {"url": "https://i.ytimg.com/vi/uCCdUB7D10U/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/uCCdUB7D10U/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/uCCdUB7D10U/hqdefault.jpg", "width": 480, "height": 360}} | MARIO DANIEL DEMAYO | 22 | none | {"title": "Heavy Metal Veteran of the Psychic Wars", "description": " "} | 17862 | 265 | 0 | 17 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [videos] ( [id] TEXT PRIMARY KEY, [publishedAt] TEXT, [channelId] TEXT, [title] TEXT, [description] TEXT, [thumbnails] TEXT, [channelTitle] TEXT, [tags] TEXT, [categoryId] TEXT, [liveBroadcastContent] TEXT, [localized] TEXT, [viewCount] INTEGER, [likeCount] INTEGER, [favoriteCount] INTEGER, [commentCount] INTEGER, [defaultAudioLanguage] TEXT , [defaultLanguage] TEXT);