Awesome - do you offer a small widget for the lock screen?

How many of these pose asbestos hazards like the Libby mine?

The Libby mine isn't in the data set because it's no longer operational.

The US, like many countries and regions, has poor coverage of abandoned, closed, and shuttered mine sites despite such sites still posing an ongoing danger in terms of imminent physical danger (collapse, decay, etc) and untreated waste piles and ponds leaching toxins into ground waters, etc.

To answer the question posed, "how many (US?) mine sites pose a danger of type {X}" requires crawling the US BLM datasets, the OSHA datasets, the archived (from when active) MSHA datasets, and having a some luck onside for various specific sites due to large gaps and periods of not caring at all.

See:

* https://www.epa.gov/epcra/does-msha-have-jurisdiction-over-i...

* https://www.blm.gov/programs/aml-environmental-cleanup/aml

Various transnational global mining companies (Rio Tinto, et al) have extensive datasets on global resources and minesites, both operational, and past and potential future sites.

The map has a "Status" predicate.

The HN link for this one is wrong: https://andrewgy8.github.io/hnarcade/games/games/sandspiel

Turning off soap opera setting on every single person I visit... and watching their reaction ... "dude...... I've been arguing with my wife about this and she thinks im crazy!!!"

I love ruby so much

Which was the GTA where you rode around on a dirtbike out in the california mountains, and there was like bootleggers and stuff.... man i have serious memories of that game

ALL YOU HAD TO DO WAS FOLLOW THE DAMN TRAIN, CJ!

Dude............omg..............holy SHIT i forgot about that. NOOOOOOO!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

San Andreas

This is good stuff

Also just let me reference the damn alias in a group by, FUCK

At least in PostgreSQL, both by alias and ordinal are possible:

  localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:02:15 PST 2025]
  > create table test (a_key integer primary key, a_group integer, a_val numeric);
  CREATE TABLE
  Time: 3.102 ms

  localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:02:25 PST 2025]
  > insert into test (a_key, a_group, a_val) values (1, 1, 5.5), (2, 1, 2.6), (3, 2, 1.1), (4, 2, 6.5);
  INSERT 0 4
  Time: 2.302 ms

  localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:02:58 PST 2025]
  > select a_group AS my_group, sum(a_val) from test group by my_group;
   my_group | sum
  ----------+-----
          2 | 7.6
          1 | 8.1
  (2 rows)
  
  Time: 4.124 ms
  localhost(from SCB-MUSE-BOXX).postgres.scb.5432 [Sun Nov 16 12:03:15 PST 2025]
  > select a_group AS my_group, sum(a_val) from test group by 1;
   my_group | sum
  ----------+-----
          2 | 7.6
          1 | 8.1
  (2 rows)
  
  Time: 0.360 ms

Some do. It would also be nice to reference by ordinal number similar to order by. Very handy for quick and dirty queries. I can see the issue though that people start to lean on it too much.

The problem with this and similar requests is that it would change the identifier scoping in incompatible ways and therefore potentially break a lot of existing SQL code.

I think it should be not only in GROUP BY, but in every context, e.g., inside expressions in SELECT, WHERE, etc.

PostgreSQL and DuckDB support this, which makes MSSQL feel like a dinosaur in context.

I imagine it would be no different than current indexing strategies with a temporal aspect baked in... it would act almost like a different site, and maybe roll up the results after the fact by domain

No, I shall not "be worried." Unless you are some spineless blob of agencyless ooze... you should be able to parse reality in such a way that your day not need to be filled with worrying