✨ Visual Editor

close

palette Canvas & Background

Gradient:arrow_forward
Text Color:
135°

style Card Style

40px
16px

text_fields Typography

16px
DataRepublican (small r)
@DataRepublican
🚨 NGO / GOVERNMENT GRANT TRACKING TOOL 🚨
🔍 FOLLOW THE GRANTS: CONNECT NGOs TO YOUR TAX DOLLARS 💵
Ever wonder exactly which government grants fund nonprofits? Now you can know—because I’ve cracked the code.

Unlike older tools that only sift through nonprofit 990s (which don’t directly show government dollars), I’ve mined the USASpending database to create fuzzy matches between nonprofits and their linked government grants.

All grants are active. All grants are ongoing.

Here’s what this tool can do:
✅ Search by EIN, Keywords, UEI, or Recipient Name: Zero in on the nonprofit or grant you want to investigate.
✅ View the Award ID & Funding Agency: See where the money came from—and how much.
✅ Dollar Amounts Matched to EINs: Transparent numbers, no guesswork.
✅ Location-Based Matching: Only UEIs and grants with address matches to nonprofits are included.

This means you can now trace your tax dollars with precision—from the grant to the nonprofit and back to the government agency funding it.

💡 If you're an advocate, watchdog, or just curious about accountability, this tool will empower you to dig deeper than ever before.

Ready to see how government money flows? Try it now and uncover the truth.

⚠️ Heads-up: It’s data-heavy, but I made it as efficient as possible. Link below! 👇
Thread image
DataRepublican (small r)
@DataRepublican
DataRepublican (small r)
@DataRepublican
Don't forget to check out the other accompanying tools:

501(c)(3) search: joeisdone.github.io/nonprofit
DataRepublican (small r)
@DataRepublican
Grant diagram network:
joeisdone.github.io/expose/
DataRepublican (small r)
@DataRepublican
Please consider subscribing on X or Substack to support efforts! Completely and 100% voluntary.
DataRepublican (small r)
@DataRepublican
Yikes. That's a lot of refugee-related money with the Catholic church.
Thread image
DataRepublican (small r)
@DataRepublican
I pushed in a re-indexing that will boost large grant amounts to the top. So do a browser refresh and try searching for a keyword like "refugee" and be even more enraged.
DataRepublican (small r)
@DataRepublican
FYI - what makes this tool different from USASpending or other search tools is that I built a multi-layer reverse index specifically over the awards description, keywords, etc. This greatly speeds up text search by a factor of like 99%. Not what PostgreSQL is designed to do.
DataRepublican (small r)
@DataRepublican
One of the weirdest criticisms I’ve heard: “You’re just storing data in files.”

Wait until I tell you what a database is... it's storing data in files.

A database is fundamentally a persistent data structure, aka, file. Just as hashmaps, arrays, and linked lists have different properties and trade-offs, so too can files be optimized for specific operations.

Take HBase and Cassandra, for example. HBase is range-partitioned, while Cassandra is hash-partitioned. That choice drastically affects their performance characteristics—determining which types of queries they handle efficiently.

Nothing about row layouts, sorting orders, or file structures is accidental. These design choices exist to enable lightning-fast lookups at minimal cost—something a traditional append-only RDBMS isn’t optimized for without additional indexing mechanisms or plugins.
Generated by Thread Navigator
100%
view_carousel Carousel Studio NEW
Press + S to quick-export