@DataRepublican @BasedMikeLee @StephenM @elonmusk @DOGE @ArtChicken4 @ScottPresler
Big need for some DB work. FAST
20 most contested states. Focus on big cities. DB which shows the max number of occupants the mailing address is certified to house
x.com/i/grok/share/40lGZ3Ra3โฆ
Is definitely feasible
x.com/i/grok/share/40lGZ3Ra3โฆ
@AAGDhillon could add the needed data request to the voter rolls already being litigated
Overall, if the goal is detection (as in your hypothetical), it's doable and has been approximated in real-world fraud-detection efforts. States or non-profits could implement it in months with proper resources, enhancing tools like ERIC. If you're thinking of a custom build, start with open-source data from a single state to test.
Step 2: Database Design and Implementation Once data is obtained (e.g., as CSV exports or via APIs), building the DB is simple using standard tools:Tech Stack: Use a relational database like PostgreSQL or MySQL (free and scalable). For larger scales (e.g., nationwide data with millions of records), something like BigQuery or Snowflake for cloud-based querying.
Key Tables:voters: Columns for voter ID, full name, standardized address, registration date.
properties: Columns for standardized address, property type (e.g., "single-family"), estimated max occupancy (inferred from beds/units/sq ft), certification source.
flags: To log anomalies.
Process:Standardize Addresses: Use tools like USPS API or libraries (e.g., Python's usaddress) to normalize addresses (e.g., "123 Main St" vs. "123 Main Street Apt 1").
Aggregate Counts: SQL query to group voters by address and count: SELECT address, COUNT(*) AS reg_count FROM voters GROUP BY address HAVING reg_count > threshold;
Join with Property Data: Merge on address: SELECT v.address, v.reg_count, p.max_occupancy FROM voter_counts v JOIN properties p ON v.address = p.address WHERE v.reg_count > p.max_occupancy;
Flagging Logic: Add rules, e.g., flag if reg_count > max_occupancy * 1.5 (to account for families). Include thresholds for "impossible" scenarios like 1,000 at a small home. Automate with scripts to run periodically.
Output: Generate reports or alerts for flagged addresses.
Time to Build: A developer could prototype this in a day or two with sample data. Scaling to full US data (300M potential records) might take a week, plus optimization for queries.Step 3: Challenges and Feasibility
Technical Ease: High. Similar systems already existโe.g., ERIC cross-checks registrations across states for duplicates or
movers.ericstates.org 1Analyses have found duplicates in voter rolls (e.g., 0.8% in one study of 50M records from 7 states).tilores.ioStates already maintain voter list accuracy, including address
verification.heritage.org 1
Practical Hurdles:Occupancy data isn't uniformly "certified" nationwideโit's local, so you'd need to aggregate from 3,000 counties.
Data Gaps: Not all states provide full access; some redact addresses for
privacy.stateline.org
Legal/Ethical: Must comply with laws against voter intimidation or data misuse. Federal requests for voter data have faced
resistance.statedemocracy.laโฆ.wisc.eduIf done privately, it could raise concerns about building a "federal database" for targeting.stateline.orgFalse Positives: Legit scenarios (e.g., apartment buildings, group homes) could trigger flags, requiring human review.
Cost/Scale: Low for a small state ($1Kโ$5K in data fees); high for nationwide ($50K plus compute).
Existing Precedents: Groups have built similar tools to detect "duplicate voting" by analyzing public rolls.trumpwhitehouse.archives.govElection officials already verify addresses during registration, though same-day processes limit real-time
checks.wral.com
๐จ Over 1,000 people registered to vote at one location in Fulton County, Georgia
Another building has 2,000 people registered to vote at one location
Democrats are using churches to register homeless people to vote and then ballot harvesting FUNDED BY GEORGE SOROS
David Khait โIt's actually a very well organized plan by Democrat donors like George Soros. So Soros poured in millions into an organization here in Atlanta that did what? They went around this entire place and signed up all the homeless people.
It's during the day right now, so you don't see all the homeless people, but usually this place is filled with homeless people. So an organization that supports Democrats received money from people like George Soros to go and register homeless people to be able to vote from one single place.
To make things even crazier, if we turn around, this place is directly across the Georgia Capitol. All it took for me is to find the voter list and to see why is there more than a thousand people able to register from one place to realize that something is wrong here.
- The building right next to 201 Washington Street is actually a Catholic church. Well, guess what?
- This place, 48 Martin Luther King Jr. Drive Southwest has registered over 2,000 people to vote from one single location
And guess who it was? It was the progressive organization signing up homeless people that are literally right across the street.
โ We're outside one of these mega churches that ended up registering more than a thousand people to vote from just one single place.โ