Stack Exchange
log in
help
Stack Exchange Data Explorer
Home
Queries
Users
Compose Query
Editing Query
edit description
Q&A for people looking to bypass life's everyday problems with simple tricks
-- mytag: Enter a tag name, like 'Java' select * from badges where userId = 31503
Database Schema
Posts
Id
int
PostTypeId
tinyint
AcceptedAnswerId
int
ParentId
int
CreationDate
datetime
DeletionDate
datetime
Score
int
ViewCount
int
Body
nvarchar (max)
OwnerUserId
int
OwnerDisplayName
nvarchar (40)
LastEditorUserId
int
LastEditorDisplayName
nvarchar (40)
LastEditDate
datetime
LastActivityDate
datetime
Title
nvarchar (250)
Tags
nvarchar (4000)
AnswerCount
int
CommentCount
int
FavoriteCount
int
ClosedDate
datetime
CommunityOwnedDate
datetime
ContentLicense
varchar (30)
Users
Id
int
Reputation
int
CreationDate
datetime
DisplayName
nvarchar (40)
LastAccessDate
datetime
WebsiteUrl
nvarchar (200)
Location
nvarchar (100)
AboutMe
nvarchar (max)
Views
int
UpVotes
int
DownVotes
int
ProfileImageUrl
nvarchar (200)
EmailHash
varchar (32)
AccountId
int
Comments
Id
int
PostId
int
Score
int
Text
nvarchar (600)
CreationDate
datetime
UserDisplayName
nvarchar (40)
UserId
int
ContentLicense
varchar (30)
Badges
Id
int
UserId
int
Name
nvarchar (50)
Date
datetime
Class
tinyint
TagBased
bit
CloseAsOffTopicReasonTypes
Id
smallint
IsUniversal
bit
InputTitle
nvarchar (100)
MarkdownInputGuidance
nvarchar (500)
MarkdownPostOwnerGuidance
nvarchar (500)
MarkdownPublicGuidance
nvarchar (500)
MarkdownConcensusDescription
nvarchar (500)
CreationDate
datetime
CreationModeratorId
int
ApprovalDate
datetime
ApprovalModeratorId
int
DeactivationDate
datetime
DeactivationModeratorId
int
CloseReasonTypes
Id
tinyint
Name
nvarchar (200)
Description
nvarchar (500)
FlagTypes
Id
tinyint
Name
nvarchar (50)
Description
nvarchar (500)
PendingFlags
Id
int
FlagTypeId
tinyint
PostId
int
CreationDate
date
CloseReasonTypeId
tinyint
CloseAsOffTopicReasonTypeId
smallint
DuplicateOfQuestionId
int
BelongsOnBaseHostAddress
nvarchar (100)
PostFeedback
Id
int
PostId
int
IsAnonymous
bit
VoteTypeId
tinyint
CreationDate
datetime
PostHistory
Id
int
PostHistoryTypeId
tinyint
PostId
int
RevisionGUID
uniqueidentifier
CreationDate
datetime
UserId
int
UserDisplayName
nvarchar (40)
Comment
nvarchar (400)
Text
nvarchar (max)
ContentLicense
varchar (30)
PostHistoryTypes
Id
tinyint
Name
nvarchar (50)
PostLinks
Id
int
CreationDate
datetime
PostId
int
RelatedPostId
int
LinkTypeId
tinyint
PostNotices
Id
int
PostId
int
PostNoticeTypeId
int
CreationDate
datetime
DeletionDate
datetime
ExpiryDate
datetime
Body
nvarchar (max)
OwnerUserId
int
DeletionUserId
int
PostNoticeTypes
Id
int
ClassId
tinyint
Name
nvarchar (80)
Body
nvarchar (max)
IsHidden
bit
Predefined
bit
PostNoticeDurationId
int
PostsWithDeleted
Id
int
PostTypeId
tinyint
AcceptedAnswerId
int
ParentId
int
CreationDate
datetime
DeletionDate
datetime
Score
int
ViewCount
int
Body
nvarchar (max)
OwnerUserId
int
OwnerDisplayName
nvarchar (40)
LastEditorUserId
int
LastEditorDisplayName
nvarchar (40)
LastEditDate
datetime
LastActivityDate
datetime
Title
nvarchar (250)
Tags
nvarchar (4000)
AnswerCount
int
CommentCount
int
FavoriteCount
int
ClosedDate
datetime
CommunityOwnedDate
datetime
ContentLicense
varchar (30)
PostTags
PostId
int
TagId
int
PostTypes
Id
tinyint
Name
nvarchar (50)
RelatedQuestions
PostId
int
RelatedPostId
int
Position
int
Score
decimal
ReviewRejectionReasons
Id
tinyint
Name
nvarchar (100)
Description
nvarchar (300)
PostTypeId
tinyint
ReviewTaskResults
Id
int
ReviewTaskId
int
ReviewTaskResultTypeId
tinyint
CreationDate
date
RejectionReasonId
tinyint
Comment
nvarchar (400)
ReviewTaskResultTypes
Id
tinyint
Name
nvarchar (100)
Description
nvarchar (300)
ReviewTasks
Id
int
ReviewTaskTypeId
tinyint
CreationDate
date
DeletionDate
date
ReviewTaskStateId
tinyint
PostId
int
SuggestedEditId
int
CompletedByReviewTaskId
int
ReviewTaskStates
Id
tinyint
Name
nvarchar (50)
Description
nvarchar (300)
ReviewTaskTypes
Id
tinyint
Name
nvarchar (50)
Description
nvarchar (300)
SuggestedEdits
Id
int
PostId
int
CreationDate
datetime
ApprovalDate
datetime
RejectionDate
datetime
OwnerUserId
int
Comment
nvarchar (800)
Text
nvarchar (max)
Title
nvarchar (250)
Tags
nvarchar (250)
RevisionGUID
uniqueidentifier
SuggestedEditVotes
Id
int
SuggestedEditId
int
UserId
int
VoteTypeId
tinyint
CreationDate
datetime
TargetUserId
int
TargetRepChange
int
Tags
Id
int
TagName
nvarchar (35)
Count
int
ExcerptPostId
int
WikiPostId
int
IsModeratorOnly
bit
IsRequired
bit
TagSynonyms
Id
int
SourceTagName
nvarchar (35)
TargetTagName
nvarchar (35)
CreationDate
datetime
OwnerUserId
int
AutoRenameCount
int
LastAutoRename
datetime
Score
int
ApprovedByUserId
int
ApprovalDate
datetime
Votes
Id
int
PostId
int
VoteTypeId
tinyint
UserId
int
CreationDate
datetime
BountyAmount
int
VoteTypes
Id
tinyint
Name
nvarchar (50)
Revisions
532627
rolfl
dec 29 '15 at 20:31
532621
rolfl
dec 29 '15 at 20:18
522030
rolfl
dec 13 '15 at 19:45
521577
rolfl
dec 12 '15 at 13:22
521407
rolfl
dec 12 '15 at 5:04
516609
rolfl
dec 4 '15 at 14:49
516608
rolfl
dec 4 '15 at 14:49
502642
rolfl
nov 14 '15 at 15:52
489904
rolfl
oct 26 '15 at 20:38
489903
rolfl
oct 26 '15 at 20:38
489902
rolfl
oct 26 '15 at 20:32
489901
rolfl
oct 26 '15 at 20:32
489900
rolfl
oct 26 '15 at 20:32
489899
rolfl
oct 26 '15 at 20:26
489898
rolfl
oct 26 '15 at 20:26
488117
rolfl
oct 22 '15 at 15:24
488116
rolfl
oct 22 '15 at 15:24
488115
rolfl
oct 22 '15 at 15:21
488114
rolfl
oct 22 '15 at 15:20
488113
rolfl
oct 22 '15 at 15:20
477776
rolfl
oct 3 '15 at 4:08
469224
rolfl
sep 15 '15 at 3:00
469223
rolfl
sep 15 '15 at 2:58
469222
rolfl
sep 15 '15 at 2:58
469221
rolfl
sep 15 '15 at 2:56
466194
rolfl
sep 8 '15 at 23:52
466193
rolfl
sep 8 '15 at 23:52
466192
rolfl
sep 8 '15 at 23:50
466189
rolfl
sep 8 '15 at 23:44
466186
rolfl
sep 8 '15 at 23:43
466182
rolfl
sep 8 '15 at 23:41
444935
rolfl
aug 6 '15 at 14:48
444934
rolfl
aug 6 '15 at 14:45
438994
rolfl
jul 26 '15 at 3:30
438993
rolfl
jul 26 '15 at 3:30
438992
rolfl
jul 26 '15 at 3:29
437660
rolfl
jul 22 '15 at 23:56
437659
rolfl
jul 22 '15 at 23:56
434284
rolfl
jul 14 '15 at 16:56
434283
rolfl
jul 14 '15 at 16:53
434282
rolfl
jul 14 '15 at 16:52
434281
rolfl
jul 14 '15 at 16:52
433965
rolfl
jul 13 '15 at 16:12
427255
rolfl
jul 1 '15 at 1:21
426332
rolfl
jun 28 '15 at 20:42
423067
rolfl
jun 18 '15 at 16:34
422360
rolfl
jun 16 '15 at 23:15
422359
rolfl
jun 16 '15 at 23:14
422358
rolfl
jun 16 '15 at 23:14
422357
rolfl
jun 16 '15 at 23:13
422356
rolfl
jun 16 '15 at 23:13
420175
rolfl
jun 11 '15 at 21:04
420174
rolfl
jun 11 '15 at 21:03
420172
rolfl
jun 11 '15 at 21:02
419998
rolfl
jun 11 '15 at 14:41
418864
rolfl
jun 9 '15 at 14:38
418859
rolfl
jun 9 '15 at 14:36
418505
rolfl
jun 8 '15 at 20:10
418504
rolfl
jun 8 '15 at 20:08
418503
rolfl
jun 8 '15 at 20:08
418490
rolfl
jun 8 '15 at 19:09
418484
rolfl
jun 8 '15 at 19:03
418483
rolfl
jun 8 '15 at 19:03
418479
rolfl
jun 8 '15 at 19:00
416998
rolfl
jun 4 '15 at 13:20
416997
rolfl
jun 4 '15 at 13:19
416775
rolfl
jun 4 '15 at 3:37
416774
rolfl
jun 4 '15 at 3:36
416195
rolfl
jun 2 '15 at 16:27
416194
rolfl
jun 2 '15 at 16:26
415159
rolfl
may 31 '15 at 4:21
415158
rolfl
may 31 '15 at 4:16
406429
rolfl
may 13 '15 at 13:03
406419
rolfl
may 13 '15 at 12:55
385100
rolfl
apr 6 '15 at 1:25
367993
rolfl
mar 4 '15 at 17:26
367992
rolfl
mar 4 '15 at 17:26
367580
rolfl
mar 4 '15 at 0:49
360474
rolfl
feb 20 '15 at 1:19
360470
rolfl
feb 20 '15 at 1:14
360469
rolfl
feb 20 '15 at 1:12
350492
rolfl
jan 28 '15 at 2:40
350491
rolfl
jan 28 '15 at 2:38
350445
rolfl
jan 27 '15 at 23:17
350410
rolfl
jan 27 '15 at 21:25
350409
rolfl
jan 27 '15 at 21:22
350407
rolfl
jan 27 '15 at 21:22
350406
rolfl
jan 27 '15 at 21:21
349888
rolfl
jan 26 '15 at 16:08
349887
rolfl
jan 26 '15 at 16:07
349874
rolfl
jan 26 '15 at 15:55
349873
rolfl
jan 26 '15 at 15:55
349872
rolfl
jan 26 '15 at 15:54
345468
rolfl
jan 13 '15 at 17:42
344979
rolfl
jan 12 '15 at 2:04
344747
rolfl
jan 10 '15 at 18:48
343839
rolfl
jan 7 '15 at 13:59
343838
rolfl
jan 7 '15 at 13:58
340651
rolfl
dec 27 '14 at 14:15
340650
rolfl
dec 27 '14 at 13:35
340649
rolfl
dec 27 '14 at 13:34
340648
rolfl
dec 27 '14 at 13:34
340647
rolfl
dec 27 '14 at 13:34
340646
rolfl
dec 27 '14 at 13:32
340645
rolfl
dec 27 '14 at 13:32
340644
rolfl
dec 27 '14 at 13:31
340158
rolfl
dec 24 '14 at 23:57
340155
rolfl
dec 24 '14 at 23:55
338656
rolfl
dec 20 '14 at 0:11
338531
rolfl
dec 19 '14 at 18:19
338527
rolfl
dec 19 '14 at 18:07
338460
rolfl
dec 19 '14 at 13:28
337923
rolfl
dec 17 '14 at 22:41
337922
rolfl
dec 17 '14 at 22:20
337652
rolfl
dec 17 '14 at 6:11
337629
rolfl
dec 17 '14 at 4:20
337624
rolfl
dec 17 '14 at 4:07
337623
rolfl
dec 17 '14 at 3:56
337622
rolfl
dec 17 '14 at 3:56
337621
rolfl
dec 17 '14 at 3:25
337620
rolfl
dec 17 '14 at 3:24
337594
rolfl
dec 17 '14 at 1:09
337593
rolfl
dec 17 '14 at 1:08
337591
rolfl
dec 17 '14 at 0:57
337590
rolfl
dec 17 '14 at 0:54
337589
rolfl
dec 17 '14 at 0:52
337587
rolfl
dec 17 '14 at 0:48
337586
rolfl
dec 17 '14 at 0:48
336524
rolfl
dec 14 '14 at 23:37
335199
rolfl
dec 12 '14 at 18:44
335197
rolfl
dec 12 '14 at 18:44
335195
rolfl
dec 12 '14 at 18:44
335194
rolfl
dec 12 '14 at 18:44
335022
rolfl
dec 12 '14 at 17:17
335021
rolfl
dec 12 '14 at 17:17
335020
rolfl
dec 12 '14 at 17:16
333829
rolfl
dec 11 '14 at 3:36
333787
rolfl
dec 11 '14 at 0:58
333784
rolfl
dec 11 '14 at 0:56
333783
rolfl
dec 11 '14 at 0:54
333774
rolfl
dec 11 '14 at 0:49
333744
rolfl
dec 11 '14 at 0:32
333739
rolfl
dec 11 '14 at 0:30
333734
rolfl
dec 11 '14 at 0:29
333528
rolfl
dec 10 '14 at 19:51
333526
rolfl
dec 10 '14 at 19:47
333521
rolfl
dec 10 '14 at 19:39
332594
rolfl
dec 9 '14 at 2:23
332593
rolfl
dec 9 '14 at 2:22
332592
rolfl
dec 9 '14 at 2:21
332591
rolfl
dec 9 '14 at 2:19
332589
rolfl
dec 9 '14 at 2:18
332588
rolfl
dec 9 '14 at 2:18
332587
rolfl
dec 9 '14 at 2:14
316483
rolfl
nov 3 '14 at 22:08
316470
rolfl
nov 3 '14 at 21:59
316458
rolfl
nov 3 '14 at 21:54
316455
rolfl
nov 3 '14 at 21:53
316449
rolfl
nov 3 '14 at 21:52
316448
rolfl
nov 3 '14 at 21:51
316447
rolfl
nov 3 '14 at 21:50
316444
rolfl
nov 3 '14 at 21:47
316443
rolfl
nov 3 '14 at 21:44
316442
rolfl
nov 3 '14 at 21:42
316441
rolfl
nov 3 '14 at 21:41
316440
rolfl
nov 3 '14 at 21:37
316439
rolfl
nov 3 '14 at 21:35
311547
rolfl
oct 23 '14 at 16:37
311544
rolfl
oct 23 '14 at 16:34
310671
rolfl
oct 21 '14 at 0:24
310656
rolfl
oct 21 '14 at 0:08
308957
rolfl
oct 18 '14 at 22:13
308956
rolfl
oct 18 '14 at 22:13
308954
rolfl
oct 18 '14 at 22:12
308952
rolfl
oct 18 '14 at 22:11
308951
rolfl
oct 18 '14 at 22:11
308313
rolfl
oct 17 '14 at 14:38
304271
rolfl
oct 10 '14 at 17:30
304269
rolfl
oct 10 '14 at 17:30
303330
rolfl
oct 7 '14 at 23:47
303329
rolfl
oct 7 '14 at 23:45
303328
rolfl
oct 7 '14 at 23:43
303327
rolfl
oct 7 '14 at 23:43
295229
rolfl
sep 15 '14 at 0:27
293511
rolfl
sep 9 '14 at 17:57
293510
rolfl
sep 9 '14 at 17:57
293232
rolfl
sep 9 '14 at 1:06
288825
rolfl
aug 23 '14 at 17:44
288824
rolfl
aug 23 '14 at 17:43
288823
rolfl
aug 23 '14 at 17:43
288064
rolfl
aug 22 '14 at 4:51
288063
rolfl
aug 22 '14 at 4:49
288019
rolfl
aug 22 '14 at 1:46
288018
rolfl
aug 22 '14 at 1:45
286496
rolfl
aug 19 '14 at 1:16
286495
rolfl
aug 19 '14 at 1:15
283570
rolfl
aug 11 '14 at 22:53
278022
rolfl
aug 1 '14 at 18:04
278018
rolfl
aug 1 '14 at 18:03
278016
rolfl
aug 1 '14 at 18:02
278014
rolfl
aug 1 '14 at 18:02
276360
rolfl
jul 31 '14 at 17:19
273555
rolfl
jul 23 '14 at 19:25
273553
rolfl
jul 23 '14 at 19:25
273551
rolfl
jul 23 '14 at 19:24
269667
rolfl
jul 9 '14 at 12:03
269441
rolfl
jul 8 '14 at 19:03
269126
rolfl
jul 7 '14 at 21:09
269125
rolfl
jul 7 '14 at 21:09
269124
rolfl
jul 7 '14 at 21:07
269123
rolfl
jul 7 '14 at 21:07
269122
rolfl
jul 7 '14 at 21:07
269121
rolfl
jul 7 '14 at 21:07
269120
rolfl
jul 7 '14 at 21:04
269119
rolfl
jul 7 '14 at 21:04
269116
rolfl
jul 7 '14 at 21:01
268732
rolfl
jul 6 '14 at 4:48
268723
rolfl
jul 6 '14 at 4:11
268570
rolfl
jul 5 '14 at 16:19
268568
rolfl
jul 5 '14 at 16:16
268567
rolfl
jul 5 '14 at 16:15
266799
rolfl
jul 1 '14 at 3:40
266798
rolfl
jul 1 '14 at 3:40
266797
rolfl
jul 1 '14 at 3:39
266796
rolfl
jul 1 '14 at 3:38
266795
rolfl
jul 1 '14 at 3:38
266794
rolfl
jul 1 '14 at 3:36
266792
rolfl
jul 1 '14 at 3:34
265645
rolfl
jun 28 '14 at 4:27
265378
rolfl
jun 27 '14 at 14:58
265373
rolfl
jun 27 '14 at 14:57
264224
rolfl
jun 23 '14 at 23:39
263365
rolfl
jun 21 '14 at 19:46
260283
rolfl
jun 13 '14 at 3:46
260279
rolfl
jun 13 '14 at 3:30
259844
rolfl
jun 12 '14 at 0:53
259843
rolfl
jun 12 '14 at 0:47
259167
rolfl
jun 10 '14 at 10:59
259166
rolfl
jun 10 '14 at 10:58
258035
rolfl
jun 5 '14 at 15:52
255294
rolfl
may 27 '14 at 1:47
255293
rolfl
may 27 '14 at 1:46
255292
rolfl
may 27 '14 at 1:45
255291
rolfl
may 27 '14 at 1:44
255290
rolfl
may 27 '14 at 1:44
255245
rolfl
may 27 '14 at 0:14
254724
rolfl
may 24 '14 at 0:12
254723
rolfl
may 24 '14 at 0:11
254722
rolfl
may 24 '14 at 0:11
254719
rolfl
may 23 '14 at 23:51
254718
rolfl
may 23 '14 at 23:51
254693
rolfl
may 23 '14 at 23:32
254692
rolfl
may 23 '14 at 23:32
254690
rolfl
may 23 '14 at 23:19
254689
rolfl
may 23 '14 at 23:17
254688
rolfl
may 23 '14 at 23:17
254609
rolfl
may 23 '14 at 19:57
254607
rolfl
may 23 '14 at 19:53
253135
rolfl
may 19 '14 at 23:53
250079
rolfl
may 11 '14 at 15:30
250078
rolfl
may 11 '14 at 15:25
249350
rolfl
may 9 '14 at 17:40
249349
rolfl
may 9 '14 at 17:38
237948
rolfl
apr 19 '14 at 2:31
237944
rolfl
apr 19 '14 at 2:27
237935
rolfl
apr 19 '14 at 2:22
237927
rolfl
apr 19 '14 at 2:16
234766
rolfl
apr 10 '14 at 23:22
234765
rolfl
apr 10 '14 at 23:22
234764
rolfl
apr 10 '14 at 23:21
234763
rolfl
apr 10 '14 at 23:20
234761
rolfl
apr 10 '14 at 23:18
234760
rolfl
apr 10 '14 at 23:17
234759
rolfl
apr 10 '14 at 23:16
234757
rolfl
apr 10 '14 at 23:15
234750
rolfl
apr 10 '14 at 23:12
234739
rolfl
apr 10 '14 at 23:04
234737
rolfl
apr 10 '14 at 23:03
234733
rolfl
apr 10 '14 at 23:00
234732
rolfl
apr 10 '14 at 23:00
234731
rolfl
apr 10 '14 at 22:58
233158
rolfl
apr 7 '14 at 0:05
204312
rolfl
jan 17 '14 at 1:09
204310
rolfl
jan 17 '14 at 1:06
204309
rolfl
jan 17 '14 at 1:05
204306
rolfl
jan 17 '14 at 1:04
204287
rolfl
jan 17 '14 at 0:51
permalink
hide sidebar
Enter Parameters
Run Query
Cancel
Options:
Text-only results
Include execution plan
Switch to meta site
Hold tight while we fetch your results
Results
[:current/:total]
Messages
Graph
Execution Plan
Download CSV
Download XML
:records returned in :time ms:cached
Data Explorer works best with JavaScript enabled