What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 128 Stack Exchange communities.

Is it possible to include the tag-wiki associations in the Data Explorer? To do this would require two additional columns in the postTags table that associate a tag wiki excerpt and a tag wiki to their tag.

The tag wiki data is already available in the posts table. But there is no way to associate this data with its tags. The SEDE schema lacks the required columns to link the tag excerpt and the tag wiki to the tags table.

Additionally, the postTypes table only lists three posts types. It makes no mention of tag-wiki and tag excerpt posts. Perhaps the postypes table can be updated to reflect the additional post types?

share|improve this question
3  
This would actually go in the Tags table directly, since there's only ever a single wiki and wiki excerpt for each tag. –  Jon Seigel Jul 25 '11 at 17:11
    
@Jon, good point. I confused myself. –  Mohamad Jul 25 '11 at 22:11
    
This is about Data Explorer data.stackexchange.com and not about downloadable data dump file clearbits.net/creators/146-stack-exchange-data-dump –  Juha Syrjälä Apr 13 '13 at 17:43
add comment

1 Answer 1

This was added at some point:

Tags table

  • ExcerptPostId int
  • WikiPostId int

The PostTypes table lists all exported post types as well.

Example: http://data.stackexchange.com/stackoverflow/query/167810?TagName=c%23

share|improve this answer
add comment

You must log in to answer this question.

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