Query Iota - Stack Exchange Data Explorer

Editing Query

edit description

Q&A for users of Iota, the open-source cryptocurrency for IoT that does not use a blockchain

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

Enter Parameters

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