MARK SANDFORD
CIVIC INFORMATION DEVELOPER
DETROIT, MICHIGAN
BACKGROUND

PROFESSION: Bartender in Detroit, Michigan developing civic technology as a side project.

PROJECT GOAL: Built CIV.IQ to organize publicly available civic information and present it in an easy-to-understand way. Think of it like a phone book for democracy-your address is the key that unlocks information about who represents you at every level of government.

DEVELOPMENT APPROACH: Using modern development tools including AI assistance to build solutions that integrate government data sources into unified, accessible interfaces.

CURRENT WORK

CIV.IQ - CIVIC INFORMATION UTILITY

A Progressive Web Application that helps people find their representatives and understand government data. Enter your address, get your representatives-federal and state-along with their voting records, campaign donors, and recent news. All the information is already public; CIV.IQ just organizes it in one place.

AUTHENTIC DATA ONLY: Everything comes from real government APIs. No made-up data, no estimates. Coverage includes all 39,495 ZIP codes mapped to congressional districts using Census boundaries, plus state legislature data for all 50 states and DC.

Data sources: Congress.gov API, Senate.gov XML, FEC.gov API, Census.gov API, Congress-Legislators YAML, OpenStates v3 API, NewsAPI + Google News RSS.

TECHNOLOGY STACK:

  • Next.js 16.0.10 (App Router + Server Components)
  • TypeScript 5.8.3 with Strict Mode
  • Progressive Web App with Offline Functionality
  • Redis Caching + SWR Background Revalidation
  • Geometric Design System (8px grid, no shadows)
  • Interactive District Maps (PMTiles Optimization)
  • Campaign Finance Data with Industry Categorization
  • State Legislature Coverage (OpenStates v3)
  • 7,383 State Legislative District Maps
  • News Integration with AI Deduplication
  • 93 API Endpoints
TECHNICAL DETAILS

Built CIV.IQ using Next.js 16.0.10 and TypeScript 5.8.3. The goal was to make government data accessible without sacrificing accuracy or performance.

DESIGN APPROACH: Geometric precision with an 8px grid system, 2px black borders replacing shadows, and a systematic color palette. The design stays out of the way and lets the information speak.

DATA ARCHITECTURE: All 39,495 ZIP codes are mapped to congressional districts using official Census TIGER/Line shapefiles. PMTiles optimization delivers 64MB vector tiles for efficient map rendering. State legislative districts (7,383 total) use the same approach via OpenStates.

WHAT YOU CAN LOOK UP: Federal representatives (House and Senate), state legislators, district boundaries, campaign finance records with donor industry breakdowns, voting records, committee assignments, recent news, and floor schedules.

FUTURE WORK: Interested in building similar tools that make public information more accessible-anything where the data exists but is hard for regular people to find and understand.

VISITOR COUNTER
001247
You are visitor #1247

WEBMASTER
Mark Sandford - Civic Information Developer
Mark Sandford
Detroit, Michigan

DATA SOURCES
Government APIs:
. Congress.gov API
. Senate.gov XML Parser
. FEC.gov API
. Census.gov API
. OpenStates v3 API
. Congress-Legislators YAML
. NewsAPI + Google News RSS
Tech Stack:
. Next.js 16.0.10 App Router
. TypeScript 5.8.3
. Redis + SWR Caching
. Service Worker PWA
. PMTiles Vector Tiles
. Geometric Design System
. 93 API Endpoints
Coverage:
. 39,495 ZIP Codes
. 435 House Districts
. 50 States + DC Legislatures
. 7,383 State Districts
. Campaign Finance Records
. Voting Records
. Committee Assignments

WHAT CIV.IQ DOES
. Look up reps by address or ZIP
. See who funds their campaigns
. Track their voting records
. View district boundaries on maps
. Read recent news about them
. Check committee assignments
. Find state legislators too
. Works offline (PWA)
. 100% real government data ALWAYS!


QUICK LINKS
Congress.gov API
FEC.gov API
US Census APIs
OpenStates v3 API
WHO IS MARK?

He lives in Detroit, plays hockey, has a Pitbull/German Shorthaired Pointer mix named Randy, and enjoys hypertext, cooking, and American history.


Interested in building tools that organize public information and make it easier for people to understand. If you have a similar project in mind, get in touch.

UNDER
CONSTRUCTION
??