this post was submitted on 20 Feb 2025
168 points (98.8% liked)

News

25286 readers
3927 users here now

Welcome to the News community!

Rules:

1. Be civil


Attack the argument, not the person. No racism/sexism/bigotry. Good faith argumentation only. This includes accusing another user of being a bot or paid actor. Trolling is uncivil and is grounds for removal and/or a community ban. Do not respond to rule-breaking content; report it and move on.


2. All posts should contain a source (url) that is as reliable and unbiased as possible and must only contain one link.


Obvious right or left wing sources will be removed at the mods discretion. Supporting links can be added in comments or posted seperately but not to the post body.


3. No bots, spam or self-promotion.


Only approved bots, which follow the guidelines for bots set by the instance, are allowed.


4. Post titles should be the same as the article used as source.


Posts which titles don’t match the source won’t be removed, but the autoMod will notify you, and if your title misrepresents the original article, the post will be deleted. If the site changed their headline, the bot might still contact you, just ignore it, we won’t delete your post.


5. Only recent news is allowed.


Posts must be news from the most recent 30 days.


6. All posts must be news articles.


No opinion pieces, Listicles, editorials or celebrity gossip is allowed. All posts will be judged on a case-by-case basis.


7. No duplicate posts.


If a source you used was already posted by someone else, the autoMod will leave a message. Please remove your post if the autoMod is correct. If the post that matches your post is very old, we refer you to rule 5.


8. Misinformation is prohibited.


Misinformation / propaganda is strictly prohibited. Any comment or post containing or linking to misinformation will be removed. If you feel that your post has been removed in error, credible sources must be provided.


9. No link shorteners.


The auto mod will contact you if a link shortener is detected, please delete your post if they are right.


10. Don't copy entire article in your post body


For copyright reasons, you are not allowed to copy an entire article into your post body. This is an instance wide rule, that is strictly enforced in this community.

founded 2 years ago
MODERATORS
 

Of the DOGE list's initial claim of $16 billion in savings, half came from an Immigration and Customs Enforcement (ICE) listing that was entered into the Federal Procurement Data System (FPDS) in 2022 with a whopping $8 billion maximum possible value.

According to a DOGE post on X, that number was a typo that was corrected in the contract database to $8 million on Jan. 22 of this year before being terminated a week later, and DOGE "has always used the correct $8M in its calculations."

But for much of this week, DOGE listed the outdated $8 billion for its savings claims while linking to the termination notice with the smaller ceiling amount.

Some time Tuesday evening, the DOGE link was changed to point at the original $8 billion entry, and on Wednesday morning, the site was revised once again to show $8 million in savings — but still linked to the larger, outdated claim. The site also continues to list $55 billion in total estimated savings — the $8.5 billion in alleged contract savings and another $46.5 billion with no specifically documented source.

Spokespeople for the White House and DOGE did not respond to multiple requests for clarification about the DOGE data and savings claims shared online.

...

Just over half of the contracts touted by DOGE, accounting for $6.5 billion in alleged savings, haven't actually been terminated or closed out as of Wednesday, according to an NPR analysis of a federal government procurement database, even though the site's "wall of receipts" listed these items.

...

In all, estimated savings from the initial DOGE list of just over 500 contracts that NPR found to be cancelled runs closer to $2 billion, with roughly half coming from the gutting of the Department of Education, the Consumer Financial Protection Bureau and the U.S. Agency for International Development.

Archived at https://ghostarchive.org/archive/w8hLJ

top 3 comments
sorted by: hot top controversial new old
[–] IHeartBadCode@fedia.io 25 points 3 days ago (1 children)

The thing is that it's difficult to even get a complete picture because they release so little data.

One screenshot I saw had the PIID in the shot so I looked it up. Doofus indicated he saved $8.2M but that was the total amount for the outlay.

The contract began in 2022 and had already paid out 80% the total $8.2M, meaning only $1.64M was actually "saved".

So I know for a fact that the values they're reporting aren't correct because they're looking at these contracts and having no clue on how to actually read them.

As for the SSN thing where we're paying 150 year old social security. There's likely another table with "in question" that has to be joined to get an actual number.

When I worked for my state this is how we had some data. A master table that you then had to join like five or six exception tables to remove the "questionable" entries from the master.

And on systems like AS400, EXCEPTION JOIN is a thing for a reason because the OS SQL engine has special ways to optimize these kinds of joins. So it's likely this is the case here.

[–] dan@upvote.au 2 points 3 days ago* (last edited 3 days ago)

TIL EXCEPTION JOIN. I thought the SQL dialect I usually use at work for data warehouse queries (Presto) didn't have anything like this, but it does, and calls it EXCEPT: https://prestodb.io/docs/current/sql/select.html#union-intersect-except-clause

Good to know. Beats my usual approach of using WHERE x NOT IN (SELECT ...). I'm mostly a front end developer so these things are outside my comfort zone sometimes.

When I worked for my state this is how we had some data. A master table that you then had to join like five or six exception tables to remove the “questionable” entries from the master.

At my workplace, we'd have a data pipeline (think something like Apache Airflow) that pulls the master table once the daily partition lands, joins the exception tables, then produces a "clean" output table which is the one that people would actually query. At a previous employer, we would have used a materialized/indexed view (we used SQL Server for both OLTP and OLAP). Is that not common in government?

[–] Bieren@lemmy.world 9 points 3 days ago

Of course it doesn’t. Lie and project. That’s all they know. And their base will slurp it up. Especially without an education.