StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1620906
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2009-10-25T13:18:43.150
FavoriteCount
0
LastActivityDate
2009-10-25T19:04:41.080
LastEditDate
2009-10-25T19:04:41.080
LastEditorUserId
190597
OwnerUserId
190597
ParentId
1620889
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
Here is some example code which uses regex to find all the text between <code><body>...</body></code> tags. Although this demonstrates some features of python's re module, note that the <a href="http://www.crummy.com/software/BeautifulSoup/documentation.html" rel="nofollow noreferrer">Beautiful Soup</a> module is very easy to use and is a better tool to use if you plan on parsing HTML or XML. (See below for an example of how you could parse this using BeautifulSoup.) <pre><code>#!/usr/bin/env python import re # Here we have a string with a multiline <body>...</body> fileString='''baz<body>foo baby foo baby foo baby foo </body><body>bar</body>''' # re.DOTALL tells re that '.' should match any character, including newlines. x = re.search('(<body>.*?</body>)', fileString, re.DOTALL) for match in x.groups(): print(match) # <body>foo # baby foo # baby foo # baby foo # </body> </code></pre> If you wish to collect all matches, you could use re.findall: <pre><code>print(re.findall('(<body>.*?</body>)', fileString, re.DOTALL)) # ['<body>foo\nbaby foo\nbaby foo\nbaby foo\n</body>', '<body>bar</body>'] </code></pre> and if you plan to use this pattern more than once, you can pre-compile it: <pre><code>pat=re.compile('(<body>.*?</body>)', re.DOTALL) print(pat.findall(fileString)) # ['<body>foo\nbaby foo\nbaby foo\nbaby foo\n</body>', '<body>bar</body>'] </code></pre> And here is how you could do it with BeautifulSoup: <pre><code>#!/usr/bin/env python from BeautifulSoup import BeautifulSoup fileString='''baz<body>foo baby foo baby foo baby foo </body><body>bar</body>''' soup = BeautifulSoup(fileString) print(soup.body) # <body>foo # baby foo # baby foo # baby foo # </body> print(soup.findAll('body')) # [<body>foo # baby foo # baby foo # baby foo # </body>, <body>bar</body>] </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POPython RegEx skipping the first few characters?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USunutbu
UserOwnerUserId
1. USunutbu
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POPython RegEx skipping the first few characters?
 singulars
 PostTypePostTypeId
 PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTDownMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.