spdaly

Exploring the FEC Candidates Database (2026)

2026-03-19T18:17:18Z by Showboat 0.6.1

This document explores the FEC 'weball26' dataset — a bulk download of all federal candidate financial summaries for the 2026 election cycle. The data was loaded into fed-data.db using sqlite-utils. Let's start by understanding the shape of the data.

uvx sqlite-utils tables fed-data.db --counts --columns

spdaly

#!/usr/bin/env bash

set -Eeuo pipefail
trap cleanup SIGINT SIGTERM ERR EXIT

script_dir=$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd -P)

usage() {
  cat <<EOF
Usage: $(basename "${BASH_SOURCE[0]}") [-h] [-v] [-f] -p param_value arg1 [arg2...]