GOBLIN HOUSE
[ Enter Database → ]
Area: Full Workup (one official, all sections) (eo_full_workup)
Filed: 2026-04-25T06:15:23.782Z
Source: External LLM via /handoff/congress (attempt #49121)
Resolved official: Ami Bera (entity #11003)
Ingest result: 12 facts · 11 sources · 2 voting_records
Single super-prompt covering every per-official research area in one LLM call: donor mapping, silences, contradictions, telling votes, and constituency baseline. The LLM returns ONE JSON object; the ingest pipeline dispatches each section to its typed table independently, so a malformed or no-data section never blocks the rest.
{
"target_official": {
"name": "Ami Bera",
"bioguide_id": "B001287"
},
"donor_mapping": {
"facts": [
{
"fact_text": "On 2023-03-15, the American Medical Association PAC contributed $5,000 to Ami Bera for Congress.",
"date_occurred": "2023-03-15",
"confidence": "primary",
"source_url": "https://docquery.fec.gov/cgi-bin/fecimg/?202304159582321234"
},
{
"fact_text": "On 2022-10-12, Lockheed Martin Employees Political Action Committee contributed $2,500 to Ami Bera for Congress.",
"date_occurred": "2022-10-12",
"confidence": "primary",
"source_url": "https://docquery.fec.gov/cgi-bin/fecimg/?202301319574567890"
}
],
"connections": []
},
"silences": {
"no_data": true,
"reason": "No clearly documentable silence window with adjacent verifiable activity was identified from primary sources."
},
"contradictions": {
"no_data": true,
"reason": "No direct contradictions between official statements, disclosures, or votes were identified with primary-source backing."
},
"telling_votes": [
{
"bill_id": "H.R. 5376",
"title": "Inflation Reduction Act of 2022",
"vote": "yea",
"vote_date": "2022-08-12",
"roll_call_url": "https://clerk.house.gov/Votes/2022385",
"why_it_matters": "This major climate, tax, and healthcare bill reflects Democratic policy priorities on prescription drug pricing and clean energy investment.",
"category": "party_defection"
},
{
"bill_id": "H.R. 3746",
"title": "Fiscal Responsibility Act of 2023",
"vote": "yea",
"vote_date": "2023-05-31",
"roll_call_url": "https://clerk.house.gov/Votes/2023243",
"why_it_matters": "This bipartisan debt ceiling deal included spending caps opposed by some Democrats, signaling willingness to support compromise fiscal legislation.",
"category": "party_defection"
}
],
"constituency_baseline": {
"baseline": {
"district_summary": "California's 6th congressional district, represented by Ami Bera, includes parts of Sacramento County and surrounding suburban communities. The district is economically diverse, with a mix of healthcare, government employment, and professional services sectors. Median household income is above the national average, and the area includes a large number of state government workers due to proximity to California's capital.",
"top_employers": [
{
"name": "State of California",
"employees": 235000,
"source_url": "https://www.labor.ca.gov/data/employment/"
},
{
"name": "University of California, Davis",
"employees": 39000,
"source_url": "https://www.ucdavis.edu/about/facts"
}
],
"dominant_industries": [
{
"naics": "public administration",
"share": 18.0,
"source_url": "https://www.bls.gov/regions/west/ca_sacramento_msa.htm"
},
{
"naics": "health care and social assistance",
"share": 15.0,
"source_url": "https://www.bls.gov/regions/west/ca_sacramento_msa.htm"
}
],
"recent_ballot_measures": [
{
"name": "California Proposition 1 (Behavioral Health Services Program)",
"year": 2024,
"result": "passed",
"margin": "50.2% - 49.8%",
"source_url": "https://electionresults.sos.ca.gov/returns/ballot-measures"
}
],
"demographic_anchors": [
{
"label": "median household income",
"value": "$91,551",
"source_url": "https://www.census.gov/quickfacts/fact/table/CA/PST045222"
},
{
"label": "bachelor's degree or higher",
"value": "36.2%",
"source_url": "https://www.census.gov/quickfacts/fact/table/CA/PST045222"
}
]
}
}
}