Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

Seems from a few posts as recent as August 2011 that Migration records used to be included in the DE DB's PostHistory table. They are currently (Nov 2011) omitted and I was just wondering why.

The reason I ask is that some users and I were currently trying to figure out how many migrated-in Questions go unloved. But the data to filter for migrated questions only is missing.

As we've been trying to cleanup questions and trying to do a bit of data-mining related to that effort I have noticed that quite a lot of records are omitted from the DE DBs. If nobody can answer why this information is missing, does anyone have a list of what information is present or missing (the mostly complete schema docs do not mention of what is omitted from the DE DBs).

Update 2:
We have not forgotten about this and nobody has given so much as a lousy non-answer response.

share|improve this question
up vote 6 down vote accepted

Well, it was actually not omitted. It is still exported.

..... However, a few months ago waffles Nick Craver split up the migration post history record so we have 2 different records.

  1. Post migrated away
  2. Post migrated in

This makes it much easier to write migration based queries.

We export a restricted number of post history records, some must remain private as the information is sensitive. The restriction is "white list" based, so any new post history record types are default omitted.

I fixed this and it will be corrected next time we update and the data dumps.

share|improve this answer
It's true, I broke data was for a good cause though! Thanks for fixing the exports again Sam! – Nick Craver Jan 24 '12 at 2:49
Thank you Nick and Sam. I figured there was either a good reason or someone forgot. Thanks again! – Chris S Jan 24 '12 at 4:23

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .