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

257218 Eat A Peach jun 3 '14 at 8:45
256840 Eat A Peach jun 2 '14 at 9:16
256778 Eat A Peach jun 2 '14 at 8:04
256776 Eat A Peach jun 2 '14 at 6:44
256775 Eat A Peach jun 2 '14 at 6:43
256774 Eat A Peach jun 2 '14 at 6:39
256773 Eat A Peach jun 2 '14 at 6:36
256772 Eat A Peach jun 2 '14 at 6:34
256770 Eat A Peach jun 2 '14 at 6:33
256769 Eat A Peach jun 2 '14 at 6:31
256768 Eat A Peach jun 2 '14 at 6:29
256767 Eat A Peach jun 2 '14 at 6:29
185689 Eat A Peach nov 25 '13 at 5:43
172444 Eat A Peach oct 1 '13 at 10:04
172443 Eat A Peach oct 1 '13 at 10:03
172442 Eat A Peach oct 1 '13 at 10:02
172441 Eat A Peach oct 1 '13 at 10:02
172440 Eat A Peach oct 1 '13 at 10:02
172439 Eat A Peach oct 1 '13 at 10:01
172438 Eat A Peach oct 1 '13 at 9:54
172437 Eat A Peach oct 1 '13 at 9:54
169306 Eat A Peach sep 18 '13 at 8:11
169305 Eat A Peach sep 18 '13 at 8:10
169304 Eat A Peach sep 18 '13 at 8:04
169302 Eat A Peach sep 18 '13 at 8:00
169301 Eat A Peach sep 18 '13 at 8:00
169300 Eat A Peach sep 18 '13 at 7:57
168832 Eat A Peach sep 17 '13 at 6:36
168830 Eat A Peach sep 17 '13 at 6:20
168829 Eat A Peach sep 17 '13 at 6:20
168828 Eat A Peach sep 17 '13 at 6:19
168827 Eat A Peach sep 17 '13 at 6:17
168825 Eat A Peach sep 17 '13 at 6:11
168824 Eat A Peach sep 17 '13 at 6:10
168823 Eat A Peach sep 17 '13 at 6:06
168822 Eat A Peach sep 17 '13 at 6:06
168821 Eat A Peach sep 17 '13 at 6:06
168577 Eat A Peach sep 16 '13 at 5:14
168576 Eat A Peach sep 16 '13 at 5:14
168574 Eat A Peach sep 16 '13 at 5:13
168573 Eat A Peach sep 16 '13 at 5:13
168572 Eat A Peach sep 16 '13 at 5:11
168571 Eat A Peach sep 16 '13 at 5:08
168570 Eat A Peach sep 16 '13 at 5:08
164946 Eat A Peach sep 3 '13 at 9:44
164945 Eat A Peach sep 3 '13 at 9:40
164944 Eat A Peach sep 3 '13 at 9:37
164943 Eat A Peach sep 3 '13 at 9:35
164941 Eat A Peach sep 3 '13 at 9:31
164940 Eat A Peach sep 3 '13 at 9:30
164939 Eat A Peach sep 3 '13 at 9:29
164602 Eat A Peach sep 2 '13 at 9:22
164601 Eat A Peach sep 2 '13 at 9:21
164600 Eat A Peach sep 2 '13 at 9:21
164599 Eat A Peach sep 2 '13 at 9:20
164598 Eat A Peach sep 2 '13 at 9:19
164597 Eat A Peach sep 2 '13 at 9:18
164596 Eat A Peach sep 2 '13 at 9:17
164595 Eat A Peach sep 2 '13 at 9:13
164594 Eat A Peach sep 2 '13 at 9:11
164593 Eat A Peach sep 2 '13 at 9:11
164592 Eat A Peach sep 2 '13 at 9:07
164591 Eat A Peach sep 2 '13 at 9:06
164590 Eat A Peach sep 2 '13 at 9:05
164589 Eat A Peach sep 2 '13 at 9:04
164588 Eat A Peach sep 2 '13 at 9:04
164587 Eat A Peach sep 2 '13 at 9:00
164585 Eat A Peach sep 2 '13 at 8:44
164584 Eat A Peach sep 2 '13 at 8:44
164583 Eat A Peach sep 2 '13 at 8:41
164582 Eat A Peach sep 2 '13 at 8:39
164581 Eat A Peach sep 2 '13 at 8:39
164580 Eat A Peach sep 2 '13 at 8:38
164579 Eat A Peach sep 2 '13 at 8:38
164578 Eat A Peach sep 2 '13 at 8:37
164577 Eat A Peach sep 2 '13 at 8:36
164576 Eat A Peach sep 2 '13 at 8:32
164031 Eat A Peach aug 30 '13 at 9:04
164030 Eat A Peach aug 30 '13 at 9:02
164029 Eat A Peach aug 30 '13 at 9:01
164028 Eat A Peach aug 30 '13 at 9:01
164027 Eat A Peach aug 30 '13 at 8:52
164026 Eat A Peach aug 30 '13 at 8:49
164025 Eat A Peach aug 30 '13 at 8:48
164024 Eat A Peach aug 30 '13 at 8:48
164021 Eat A Peach aug 30 '13 at 8:35
164020 Eat A Peach aug 30 '13 at 8:35
164019 Eat A Peach aug 30 '13 at 8:34
164018 Eat A Peach aug 30 '13 at 8:33
164017 Eat A Peach aug 30 '13 at 8:30
164015 Eat A Peach aug 30 '13 at 8:29
164014 Eat A Peach aug 30 '13 at 8:28
164013 Eat A Peach aug 30 '13 at 8:27
164012 Eat A Peach aug 30 '13 at 8:27
164011 Eat A Peach aug 30 '13 at 8:26
164010 Eat A Peach aug 30 '13 at 8:26
164009 Eat A Peach aug 30 '13 at 8:26
164008 Eat A Peach aug 30 '13 at 8:17
164007 Eat A Peach aug 30 '13 at 8:14
164006 Eat A Peach aug 30 '13 at 8:06
163928 Eat A Peach aug 30 '13 at 6:42
163926 Eat A Peach aug 30 '13 at 6:41
163925 Eat A Peach aug 30 '13 at 6:41
163923 Eat A Peach aug 30 '13 at 6:41
163919 Eat A Peach aug 30 '13 at 6:35
163914 Eat A Peach aug 30 '13 at 6:33
163910 Eat A Peach aug 30 '13 at 6:31
163821 Eat A Peach aug 30 '13 at 5:20
163820 Eat A Peach aug 30 '13 at 5:17
163819 Eat A Peach aug 30 '13 at 5:16
163818 Eat A Peach aug 30 '13 at 5:14
163817 Eat A Peach aug 30 '13 at 5:11
163816 Eat A Peach aug 30 '13 at 5:08
163815 Eat A Peach aug 30 '13 at 5:04
163814 Eat A Peach aug 30 '13 at 5:04
163813 Eat A Peach aug 30 '13 at 5:03
163812 Eat A Peach aug 30 '13 at 5:03
163811 Eat A Peach aug 30 '13 at 5:03
163810 Eat A Peach aug 30 '13 at 5:02
163809 Eat A Peach aug 30 '13 at 5:02
163808 Eat A Peach aug 30 '13 at 5:01
163807 Eat A Peach aug 30 '13 at 4:52
163806 Eat A Peach aug 30 '13 at 4:50
163805 Eat A Peach aug 30 '13 at 4:47
163804 Eat A Peach aug 30 '13 at 4:46
163803 Eat A Peach aug 30 '13 at 4:45
163802 Eat A Peach aug 30 '13 at 4:44
163801 Eat A Peach aug 30 '13 at 4:43
163660 Eat A Peach aug 29 '13 at 7:46
163654 Eat A Peach aug 29 '13 at 6:16
163652 Eat A Peach aug 29 '13 at 6:12
163650 Eat A Peach aug 29 '13 at 6:11
163649 Eat A Peach aug 29 '13 at 6:10
163648 Eat A Peach aug 29 '13 at 6:08
163647 Eat A Peach aug 29 '13 at 6:05
163645 Eat A Peach aug 29 '13 at 6:01
163300 Eat A Peach aug 28 '13 at 10:37
163299 Eat A Peach aug 28 '13 at 10:36
163297 Eat A Peach aug 28 '13 at 10:36
163293 Eat A Peach aug 28 '13 at 10:31
163291 Eat A Peach aug 28 '13 at 10:29
163290 Eat A Peach aug 28 '13 at 10:27
163286 Eat A Peach aug 28 '13 at 10:18
163282 Eat A Peach aug 28 '13 at 10:16
163065 Eat A Peach aug 27 '13 at 5:07
163061 Eat A Peach aug 27 '13 at 4:43
160023 Eat A Peach aug 16 '13 at 11:18
160022 Eat A Peach aug 16 '13 at 11:17
160021 Eat A Peach aug 16 '13 at 11:16

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