StackLite: Stack Overflow Questions And Tags

Stack Overflow questions and tags, without text included

@kaggle.stackoverflow_stacklite

Table List

2 tables(518.75 MB)

Questions

@kaggle.stackoverflow_stacklite.questions

303.54 MB
17203824 rows
7 columns

id Id	creationdate CreationDate	closeddate ClosedDate	deletiondate DeletionDate	score Score	owneruserid OwnerUserId	answercount AnswerCount
1	Thu Jul 31 2008 21:26:37 GMT+0000 (Coordinated Universal Time)		Mon Mar 28 2011 00:53:47 GMT+0000 (Coordinated Universal Time)	1
4	Thu Jul 31 2008 21:42:52 GMT+0000 (Coordinated Universal Time)			458	8	13
6	Thu Jul 31 2008 22:08:08 GMT+0000 (Coordinated Universal Time)			207	9	5
8	Thu Jul 31 2008 23:33:19 GMT+0000 (Coordinated Universal Time)	Mon Jun 03 2013 04:00:25 GMT+0000 (Coordinated Universal Time)	Wed Feb 11 2015 08:26:40 GMT+0000 (Coordinated Universal Time)	42		8
9	Thu Jul 31 2008 23:40:59 GMT+0000 (Coordinated Universal Time)			1410	1	58
11	Thu Jul 31 2008 23:55:37 GMT+0000 (Coordinated Universal Time)			1129	1	33
13	Fri Aug 01 2008 00:42:38 GMT+0000 (Coordinated Universal Time)			451	9	25
14	Fri Aug 01 2008 00:59:11 GMT+0000 (Coordinated Universal Time)			290	11	8
16	Fri Aug 01 2008 04:59:33 GMT+0000 (Coordinated Universal Time)			78	2	5
17	Fri Aug 01 2008 05:09:55 GMT+0000 (Coordinated Universal Time)			114	2	11


CREATE TABLE questions (
  "id" BIGINT,
  "creationdate" TIMESTAMP,
  "closeddate" TIMESTAMP,
  "deletiondate" TIMESTAMP,
  "score" BIGINT,
  "owneruserid" DOUBLE,
  "answercount" DOUBLE
);