Yes, deletion watch works now.

@rene Would you be able to upload the data if I send you some SFTP credentials? :) At your convenience, no rush. I can email the credentials to you if you give me an address.

@ArtOfCode I just sent you those credentials too.

Sounds good!

@rene Thanks, returned. :)

# BigQuery Public Datasets Query:
# Stack Overflow questions scoring 25+ deleted between March and December of 2017.

select
  q.score as score,

  concat(
    "https://stackoverflow.com/questions/", string(q.id), "/",
    rtrim(ltrim(regexp_replace(lower(q.title), r'[^0-9a-z]+', '-'), '-'), '-')
  ) as url,

  if(q_june.id is null, "201703March - 201706June", if(
      q_september.id is null, "201706June - 201709Sep", "201709Sep - 201712Dec"))
  as deletion_window

from
  [fh-bigquery:stackoverflow_archive.201703_posts_questions] q

@Shog9 To sate your curiosity. :)

It turns out that BigQuery hasn't just been replacing the data dump each time it's updated, they've been keeping the archived old versions up too.

(Reminder that this is Stack Overflow main only, no metas or other sites.)

It may be possible to get some or all of the old dumps in there too, to allow analysis across the eras of the site.

So we can see how silly the most popular tags in 2009 were, without only seeing the ones that have survived the next 8 years.

@JeremyBanks SFTP? I feel outdated.

This would also finally satisfy my long desire to have a semi-permanent home for the old posts that were deleted from Stack Overflow. It's not browsable, so it's not polluting the internet, but any one who wants to recover a specific post or do analysis across versions can do so, and the Free Tier (no credit card required) should be adequate for light users like that.

This isn't a sure thing yet, but it's a good reason to finally build that perfect complete data dump archive and justify the ongoing costs of safely storing it to me, since I hope to be able to offload most of that before long.

Until next "spring cleaning" by Google, at least.

Was there one this year already?

@FTP Yeah; I hesitate to say "permanent" unreservedly because I don't think they've made any such commitment and many would be skeptical even if they did.

@rene Thanks!

according to my inbox I'm a failure for not taking these totally easy totally in my wheelhouse $450K jobs.

I'd probably get lost on my way to the interview if I actually tried.

> I've demonstrated that I don't like to risk losing useful content. Help me save more of it. I make a particular promise: if elected, I will monitor the deletion log, undeletion vote log, and edits to recently-deleted questions [...]

I may finally satisfy the most-genuine part of my election nomination: content preservation.

If they did, I'd want to check their background very carefully.

@ArtOfCode Even easier! Thanks, got the data. :)

I love it.

I'm not sure I agree with that logic. :P

Zeros as far as the eye can see.

Slack is getting mentioned more often on Twitter in recent weeks, looks like internal chat is migrating in that direction.

If Teams have Slack integration, then Teams team is surely on Slack. Got it.

If I was voting today, it'd be Baum, Rob, and vaultah in some order (alphabetical here)

? "ask an adult in my Microsoft family"

It seems they built some filter into Edge, so Edge by itself is allowed, but other browsers are not.

I liked "I'm not part of a Microsoft family."

> Gonna try out this streaming while coding thing this weekend, what should I code? -- Nick Larsen at 3:52 PM - 15 Mar 2018

I should try out "streaming while grading", or "streaming while drinking coffee"

4 out of 11 proposals currently in commitment are blockchain. area51.stackexchange.com

Final four?

SFTP University is still in the NCAA tournament'