StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
277537
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2008-11-10T10:25:45.233
FavoriteCount
0
LastActivityDate
2014-05-15T01:01:03.723
LastEditDate
2014-05-15T01:01:03.723
LastEditorUserId
1078031
OwnerUserId
6782
ParentId
274308
PostTypeId
2
Score
37
ViewCount
0
LastEditorDisplayName
Alnitak
text
Body
For what it's worth, I worked at a senior level in the ISP industry for more than a decade so I have quite some experience with this. Large IP ranges are allocated as needed by <a href="http://www.iana.org/" rel="noreferrer">IANA</a> to each of the <a href="http://en.wikipedia.org/wiki/Regional_Internet_Registry" rel="noreferrer">Regional Internet Registries</a>. The regions are generally continental in size - IP addresses are not assigned on a per-country basis. The RIRs in turn then allocate IP addresses to ISPs, who in turn assign them to end-users. Each of the RIRs maintain a <code>whois</code> server which can be queried to find out not only which ISP has been assigned any netblock, but to a certain extent which end-user, and that end-user's address. Note that many ISPs do not fill out this information for every single customer. Hence if you're a residential subscriber of a DSL service, it's likely that the Geo records will give the address of your ISP, and not your own address. The various GeoLocation providers mostly work by mining these <code>whois</code> records. Note that the legality of doing so is something of a gray area - RIPE's database copyright statement is <a href="http://www.ripe.net/db/copyright.html" rel="noreferrer">here</a>. IANA also maintains the root zone for the DNS, but that is completely separate from any IP allocation functions. It is very important to maintain the distinction between domain name operations and IP addresses.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHow does geographic lookup by IP work?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USAbacus
UserOwnerUserId
1. USAlnitak
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. POHow does geographic lookup by IP work?
 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
1. This table or related slice is empty.

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.