Return to Answer

• Id
• PostId
• PostNoticeTypeId
  _{1 = Citation needed
  2 = Current event
  3 = Insufficient explanation
  10 = Current answers are outdated
  11 = Draw attention
  12 = Improve details
  13 = Authoritative reference needed
  14 = Canonical answer required
  15 = Reward existing answer
  20 = Content dispute
  21 = Offtopic comments
  22 = Historical significance
  23 = Wiki Answer}
• CreationDate
• DeletionDate
• ExpiryDate
• Body (when present contains the custom text shown with the notice)
• OwnerUserId
• DeletionUserId

• Id
• PostId
• PostNoticeTypeId
  _{1 = Citation needed
  2 = Current event
  3 = Insufficient explanation
  10 = Current answers are outdated
  11 = Draw attention
  12 = Improve details
  13 = Authoritative reference needed
  14 = Canonical answer required
  15 = Reward existing answer
  20 = Content dispute
  21 = Offtopic comments
  22 = Historical significance
  23 = Wiki Answer
  24 = Policy Lock (SO Collectives)
  25 = Recommended Answer (SO Collectives)
  26 = Posted by Recognized Member/Admin (SO Collectives)
  27 = Endorsed Edit (SO Collectives)
  28 = Obsolete (SO Collectives)
  1000 = Redditted (SO)
  9001 = DCMA Takedown}
• CreationDate
• DeletionDate
• ExpiryDate
• Body (when present contains the custom text shown with the notice)
• OwnerUserId
• DeletionUserId

Views / Stored Procedures

To support queries across multiple databases (aka sites) the following views and stored procedure exist in each database. See Create a view that provides a list of databases for usage scenarios.

sede_databases

• database_id
• database_name
• site_name
• tiny_name
• long_name
• site_type main_site or meta_site
• site_url
• sede_url
• api_site_parameter
• initialized Datetime when we started populating that database.
• made_available Datetime when the database came online and was ready for queries
• processing_time The duration between initialized and made_available, in hh:mm:ss.fff format
• questions Total number of questions in this site at the time of the current refresh
• answers Total number of answers in this site at the time of the current refresh
• latest_post The timestamp of the last post captured in this refresh
• notes This will be non-NULL when a database is in transition

sede_databases_markdown

• rn row number, for sorting by "long name"
• content markdown with headers

sede_tables

• database_id from sys.databases
• database_name from sys.databases
• table_name from sys.tables
• latest_date The latest timestamp (e.g. CreationDate) for tables that have such a column.
• row_count Number of rows in the table, according to sys.partitions. Note: For Posts, this is PostsWithDeleted; if you want non-deleted total number of Posts, use answers + questions from dbo.sede_databases
• initialized Timestamp of initial table creation
• made_available Timestamp of final operation against table.
• processing_time Duration of initialized -> made_available, in {hh:mm:ss.fff} format.

sede_sites

• site_name
• site_url
• database_name
• long_name
• site_id

sede_users

• account_id
• site_id
• user_id
• reputation
• question_count
• answer_count

sede_ineachdb

note: this is a stored procedure!

See this answer for usage details.

All timestamps are UTC, default format: yyyy-MM-dd hh:mm:ss (stored with milliseconds).

SELECT GetDate() At Time Zone 'UTC' At Time Zone 'Pacific Standard Time'

_{To list time zones: SELECT * FROM sys.time_zone_info}

All timestamps are UTC, default format: yyyy-MM-dd hh:mm:ss.fff (stored with three digits of millisecond precision as implemented by SQL Server, making the "end" of a day 23:59:59.997).

SELECT GetDate() At Time Zone 'UTC' At Time Zone 'Pacific Standard Time';

_{The time zones do not have great names, as they imply that you would have to use 'Pacific Daylight Time' and know something about DST. To list available time zones: SELECT * FROM sys.time_zone_info}