State contributions
Data license: Public records · Data source: FEC, Nebraska Accountability and Disclosure Commission, Clerk of the Legislature, Open States
- candidate_name
- The candidate, if the recipient is a candidate committee.
- filer_name
- The committee that received the money.
- contributor_type
- Individual, business, PAC, party and so on.
- is_itemized
- 0 = lump sum for small donors; not a single person.
- amount
- Negative amounts are refunds or adjustments.
163 rows where contributor_type = "Political Party Committee" and filer_type = "Political Party Committee" sorted by date descending
This data as json, CSV (advanced)
| receipt_id | org_id | filer_type | filer_name | candidate_name | receipt_type | other_funds_type | date ▲ | amount | description | contributor_type | contributor_name | last_name | first_name | city | state | zip5 | employer | occupation | filed_date | amended | is_itemized | file_year | source | run_id | loaded_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 143501 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Monetary | 2026-10-30 | 3938.53 | Political Party Committee | BUFFALO COUNTY REPUBLICAN PARTY | BUFFALO COUNTY REPUBLICAN PARTY | KEARNEY | NE | 68847 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143500 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Monetary | 2026-10-30 | 6454.65 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | DOUGLAS COUNTY REPUBLICAN PARTY | OMAHA | NE | 68145 | 2026-10-30 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143294 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Monetary | 2026-10-26 | 7621.54 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | DOUGLAS COUNTY REPUBLICAN PARTY | OMAHA | NE | 68145 | 2026-10-27 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142088 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Monetary | 2026-10-19 | 2102.35 | Political Party Committee | YORK COUNTY REPUBLICAN PARTY | YORK COUNTY REPUBLICAN PARTY | HENDERSON | NE | 68371 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142087 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Monetary | 2026-10-16 | 2748.68 | Political Party Committee | ADAMS COUNTY REPUBLICANS | ADAMS COUNTY REPUBLICANS | HASTINGS | NE | 68901 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142441 | 8182 | Political Party Committee | ADAMS COUNTY DEMOCRATIC PARTY | Monetary | 2026-10-14 | 500.0 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | NEBRASKA DEMOCRATIC PARTY | LINCOLN | NE | 68510 | 2026-10-25 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142085 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Monetary | 2026-10-13 | 6738.28 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | DOUGLAS COUNTY REPUBLICAN PARTY | OMAHA | NE | 68145 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 142084 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Monetary | 2026-10-08 | 3471.36 | Political Party Committee | CASS COUNTY REPUBLICAN CENTRAL COMMITTEE | CASS COUNTY REPUBLICAN CENTRAL COMMITTEE | ELMWOOD | NE | 68349 | 2026-10-26 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 136006 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Monetary | 2026-09-28 | 10659.41 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | DOUGLAS COUNTY REPUBLICAN PARTY | OMAHA | NE | 68145 | 2026-10-05 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 138551 | 7990 | Political Party Committee | KEITH COUNTY REPUBLICAN PARTY | Monetary | 2026-09-03 | 350.0 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | NEBRASKA REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-10-05 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 138550 | 7990 | Political Party Committee | KEITH COUNTY REPUBLICAN PARTY | Monetary | 2026-09-03 | 125.0 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | NEBRASKA REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-10-05 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 134926 | 10621 | Political Party Committee | OTOE COUNTY DEMOCRATIC CENTRAL COMMITTEE | Monetary | 2026-08-21 | 1110.0 | Political Party Committee | JOHNSON COUNTY DEMOCRATS | JOHNSON COUNTY DEMOCRATS | CRAB ORCHARD | NE | 68332 | 2026-10-05 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 136523 | 8182 | Political Party Committee | ADAMS COUNTY DEMOCRATIC PARTY | Monetary | 2026-08-15 | 1000.0 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | NEBRASKA DEMOCRATIC PARTY | LINCOLN | NE | 68510 | 2026-10-04 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 138774 | 10144 | Political Party Committee | SAUNDERS COUNTY DEMOCRATIC PARTY | Monetary | 2026-07-24 | 750.0 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | NEBRASKA DEMOCRATIC PARTY | LINCOLN | NE | 68510 | 2026-10-05 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 137396 | 7736 | Political Party Committee | LANCASTER COUNTY DEMOCRATS | Monetary | 2026-07-24 | 750.0 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | NEBRASKA DEMOCRATIC PARTY | LINCOLN | NE | 68510 | 2026-10-04 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 129360 | 7810 | Political Party Committee | SARPY COUNTY REPUBLICAN PARTY | Monetary | 2026-07-22 | 269.0 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | NEBRASKA REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-10-02 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143894 | 7730 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | Monetary | 2026-07-13 | 100.0 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | NEBRASKA REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-11-18 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 136004 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Monetary | 2026-07-08 | 600.0 | Political Party Committee | CASS COUNTY REPUBLICAN CENTRAL COMMITTEE | CASS COUNTY REPUBLICAN CENTRAL COMMITTEE | ELMWOOD | NE | 68349 | 2026-10-05 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 139246 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | Monetary | 2026-06-18 | 10.0 | Political Party Committee | SARPY COUNTY DEMOCRATIC PARTY | SARPY COUNTY DEMOCRATIC PARTY | LAVISTA | NE | 68128 | 2026-10-05 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 128804 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | Monetary | 2026-06-12 | 50.0 | Political Party Committee | SARPY COUNTY DEMOCRATIC PARTY | SARPY COUNTY DEMOCRATIC PARTY | LAVISTA | NE | 68128 | 2026-06-22 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 129327 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | In-Kind Contribution | 2026-06-05 | -400.0 | Offset due to delete of filed item - 1/2 PROCESSED HOG | Political Party Committee | BUFFALO COUNTY REPUBLICAN PARTY | BUFFALO COUNTY REPUBLICAN PARTY | KEARNEY | NE | 68847 | 2026-07-18 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 128778 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | In-Kind Contribution | 2026-06-05 | 400.0 | KEARNEY COUNTY BASKET | Political Party Committee | KEARNEY COUNTY GOP | KEARNEY COUNTY GOP | WILCOX | NE | 68982 | 2026-06-22 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 128777 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | In-Kind Contribution | 2026-06-05 | 400.0 | 1/2 PROCESSED HOG | Political Party Committee | BUFFALO COUNTY REPUBLICAN PARTY | BUFFALO COUNTY REPUBLICAN PARTY | KEARNEY | NE | 68847 | 2026-06-22 | Y | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 127417 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Payment Received for Loan Made | 2026-06-05 | 25000.0 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | NEBRASKA REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-06-22 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 128795 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | Monetary | 2026-05-20 | 3000.0 | Political Party Committee | DOUGLAS COUNTY DEMOCRATIC PARTY | DOUGLAS COUNTY DEMOCRATIC PARTY | OMAHA | NE | 68114 | 2026-06-22 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 132193 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | Monetary | 2026-05-07 | -5000.0 | Offset due to delete of filed item | Political Party Committee | LANCASTER COUNTY DEMOCRATS | LANCASTER COUNTY DEMOCRATS | LINCOLN | NE | 68510 | 2026-09-29 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 128797 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | Monetary | 2026-05-07 | 5000.0 | Political Party Committee | LANCASTER COUNTY DEMOCRATS | LANCASTER COUNTY DEMOCRATS | LINCOLN | NE | 68510 | 2026-06-22 | Y | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 123562 | 7736 | Political Party Committee | LANCASTER COUNTY DEMOCRATS | In-Kind Contribution | 2026-04-17 | 7235.65 | COORDINATED CAMPAIGN SERVICE - MAILING TO VOTERS IN LANCASTER COUNTY | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | NEBRASKA DEMOCRATIC PARTY | LINCOLN | NE | 68510 | 2026-05-01 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 121710 | 9700 | Political Party Committee | CASS COUNTY DEMOCRATIC PARTY | Monetary | 2026-04-06 | 1500.0 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | NEBRASKA DEMOCRATIC PARTY | LINCOLN | NE | 68510 | 2026-04-13 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 122115 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | Monetary | 2026-04-03 | 281.21 | Political Party Committee | SARPY COUNTY DEMOCRATIC PARTY | SARPY COUNTY DEMOCRATIC PARTY | LAVISTA | NE | 68128 | 2026-04-13 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 121962 | 7728 | Political Party Committee | DOUGLAS COUNTY DEMOCRATIC PARTY | Monetary | 2026-04-02 | 1140.0 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | NEBRASKA DEMOCRATIC PARTY | LINCOLN | NE | 68510 | 2026-04-13 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 118823 | 7737 | Political Party Committee | LANCASTER COUNTY REPUBLICAN PARTY | Monetary | 2026-04-01 | 1510.0 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | NEBRASKA REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-04-10 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 129336 | 7810 | Political Party Committee | SARPY COUNTY REPUBLICAN PARTY | Monetary | 2026-03-31 | 595.0 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | NEBRASKA REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-07-20 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 123661 | 7809 | Political Party Committee | PERKINS COUNTY REPUBLICAN COMMITTEE | Monetary | 2026-03-26 | 65.0 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | NEBRASKA REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-05-01 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 122116 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | Monetary | 2026-03-25 | 874.02 | Political Party Committee | SAUNDERS COUNTY DEMOCRATIC PARTY | SAUNDERS COUNTY DEMOCRATIC PARTY | LINCOLN | NE | 68510 | 2026-04-13 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 122112 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | Monetary | 2026-03-25 | 766.61 | Political Party Committee | LANCASTER COUNTY DEMOCRATS | LANCASTER COUNTY DEMOCRATS | LINCOLN | NE | 68510 | 2026-04-13 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 116150 | 9177 | Political Party Committee | SEWARD COUNTY NEBRASKA REPUBLICANS | Monetary | 2026-03-23 | 145.0 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | NEBRASKA REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-04-13 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 143903 | 7414 | Political Party Committee | SARPY COUNTY DEMOCRATIC PARTY | Monetary | 2026-03-19 | 1500.0 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | NEBRASKA DEMOCRATIC PARTY | LINCOLN | NE | 68510 | 2026-11-19 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 122732 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | In-Kind Contribution | 2026-03-06 | -550.0 | Offset due to delete of filed item - VOTERFILE ACCESS | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | NEBRASKA DEMOCRATIC PARTY | LINCOLN | NE | 68510 | 2026-04-23 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 122727 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | In-Kind Contribution | 2026-03-06 | 550.0 | VOTERFILE ACCESS | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | NEBRASKA DEMOCRATIC PARTY | LINCOLN | NE | 68510 | 2026-04-23 | Y | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 121374 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Monetary | 2026-02-27 | 1243.83 | Political Party Committee | LANCASTER COUNTY REPUBLICAN PARTY | LANCASTER COUNTY REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-04-13 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 121366 | 7806 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | Monetary | 2026-02-25 | 1000.0 | Political Party Committee | BUFFALO COUNTY REPUBLICAN PARTY | BUFFALO COUNTY REPUBLICAN PARTY | KEARNEY | NE | 68847 | 2026-04-13 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 118480 | 7730 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | Monetary | 2026-02-19 | 1675.0 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | NEBRASKA REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-04-10 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 118820 | 7737 | Political Party Committee | LANCASTER COUNTY REPUBLICAN PARTY | Monetary | 2026-01-08 | 250.0 | Political Party Committee | NEBRASKA REPUBLICAN PARTY | NEBRASKA REPUBLICAN PARTY | LINCOLN | NE | 68508 | 2026-04-10 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 115555 | 7730 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | Monetary | 2025-12-03 | -530.0 | Offset due to update of filed item | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | DOUGLAS COUNTY REPUBLICAN PARTY | OMAHA | NE | 68114 | 2026-03-09 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 107676 | 7730 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | Monetary | 2025-12-03 | 530.0 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | DOUGLAS COUNTY REPUBLICAN PARTY | OMAHA | NE | 68114 | 2026-01-21 | Y | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 114601 | 7789 | Political Party Committee | NEBRASKA DEMOCRATIC PARTY | Monetary | 2025-11-04 | 1500.0 | Political Party Committee | SARPY COUNTY DEMOCRATIC PARTY | SARPY COUNTY DEMOCRATIC PARTY | LAVISTA | NE | 68128 | 2026-02-02 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 115557 | 7730 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | Monetary | 2025-10-28 | -441.0 | Offset due to update of filed item | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | DOUGLAS COUNTY REPUBLICAN PARTY | OMAHA | NE | 68114 | 2026-03-09 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | |||||
| 113963 | 7808 | Political Party Committee | NEBRASKA YOUNG DEMOCRATS | Monetary | 2025-10-28 | 5000.0 | Political Party Committee | DOUGLAS COUNTY DEMOCRATIC PARTY | DOUGLAS COUNTY DEMOCRATIC PARTY | OMAHA | NE | 68114 | 2026-02-02 | N | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 | ||||||
| 107674 | 7730 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | Monetary | 2025-10-28 | 441.0 | Political Party Committee | DOUGLAS COUNTY REPUBLICAN PARTY | DOUGLAS COUNTY REPUBLICAN PARTY | OMAHA | NE | 68114 | 2026-01-21 | Y | 1 | 2026 | nadc | 27 | 2026-11-21T03:37:16+00:00 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE state_contributions (
receipt_id TEXT PRIMARY KEY, -- NADC's unique record ID
org_id TEXT, -- NADC ID of the receiving committee
filer_type TEXT, -- Candidate Committee, PAC, party...
filer_name TEXT, -- receiving committee
candidate_name TEXT, -- candidate, if a candidate committee
receipt_type TEXT, -- Monetary, In-Kind, Loan...
other_funds_type TEXT,
date TEXT, -- ISO yyyy-mm-dd
amount REAL, -- negative = refund or adjustment
description TEXT,
contributor_type TEXT, -- Individual, Business, PAC...
contributor_name TEXT, -- LAST, FIRST for people
last_name TEXT,
first_name TEXT,
city TEXT,
state TEXT,
zip5 TEXT,
employer TEXT,
occupation TEXT,
filed_date TEXT,
amended TEXT,
is_itemized INTEGER, -- 0 = lump-sum line for small donors
file_year INTEGER,
source TEXT NOT NULL DEFAULT 'nadc',
run_id INTEGER,
loaded_at TEXT
);
CREATE INDEX idx_sc_candidate ON state_contributions(candidate_name, date);
CREATE INDEX idx_sc_org ON state_contributions(org_id);
CREATE INDEX idx_sc_contributor ON state_contributions(contributor_name);
CREATE INDEX idx_sc_employer ON state_contributions(employer);
CREATE INDEX idx_sc_date ON state_contributions(date);