2e:null 2f:["$","title",null,{"children":"Montana 2024 Senate race independent expenditures | Eric Dietrich | Observable"}] 34:T8a9,expenditures = { const raw = await FileAttachment("2024-10-16-mtsen-independent-expenditures@2.csv").csv() const NAMES = { 'SHEEHY, TIM': 'Sheehy', 'TESTER, JON': 'Tester', 'BARB, ROBERT': 'Barb', } const COMMITTEE_NAMES = { 'AMERICAN POLICE AND TROOPERS COALITION PAC': 'American Police and Troopers Coalition PAC', 'BLUEWAVEAMERICA': 'Blue Wave America', 'MORE JOBS, LESS GOVERNMENT': 'More Jobs, Less Government', 'SAVE OUR COUNTRY': 'Save our Country', 'SENATE CONSERVATIVES FUND': 'Senate Conservatives Fund', 'SENATE CONSERVATIVES ACTION': 'Senate Conservatives Action', 'Americans for Prosperity Action, Inc. (AFP Action) DBA CVA Action and DBA LIBRE Action': 'Americans for Prosperity Action, Inc.', 'Americans for Constitutional Liberty dba The Conservative Caucus': 'Americans for Constitutional Liberty', 'JEFFERSON RISING': 'Jefferson Rising', 'HARDWORKING AMERICANS INC.': 'Hardworking Americans Inc.', 'RED SENATE': 'Red Senate', 'NATIONAL ASSOCIATION OF HOME BUILDERS': 'National Association of Home Builders', 'CLUB FOR GROWTH PAC': 'Club for Growth PAC', 'DSCC': 'Democratic Senatorial Campaign Committee', 'YOUR COMMUNITY PAC': 'Your Community PAC', 'DEMOCRATIC POWER, INC.': 'Democratic Power, Inc.', 'NATIONAL RIFLE ASSOCIATION OF AMERICA POLITICAL VICTORY FUND': 'National Rifle Association of America Political Victory Fund', 'MONTANA HUNTERS AND ANGLERS LEADERSHIP FUND': 'Montana Hunters and Anglers Leadership Fund', 'RETIRED AMERICANS PAC': 'Retired Americans PAC', 'MOVING MONTANA FORWARD': 'Moving Montana Forward', 'CLIMATE EMERGENCY ADVOCATES': 'Climate Emergency Advocates', 'SCHOOL FREEDOM FUND': 'School Freedom Fund', 'GOA VICTORY FUND': 'GOA Victory Fund', 'NATIONAL VICTORY ACTION FUND': 'National Victory Action Fund', 'GREAT OPPORTUNITY PAC, INC.': 'Great Opportunity PAC, Inc.', 'HUNTER ACTION FUND (HAF)': 'Hunter Action Fund (HAF)', } return raw.map(d => { return { committee: COMMITTEE_NAMES[d.spe_nam] || d.spe_nam, candidate: NAMES[d.cand_name], position: d.sup_opp, amount: +d.exp_amo, } }) }35:T444,byCommittee = Array.from(new Set(expenditures.map(d => d.committee))).map(name => { const committeeExpenditures = expenditures.filter(d => d.committee === name) return { committee: name, spending: { Tester: { support: d3.sum( committeeExpenditures .filter(d => d.candidate === 'Tester') .filter(d => d.position === 'S'), d => d.amount ), opposition: d3.sum( committeeExpenditures .filter(d => d.candidate === 'Tester') .filter(d => d.position === 'O'), d => d.amount ), }, Sheehy: { support: d3.sum( committeeExpenditures .filter(d => d.candidate === 'Sheehy') .filter(d => d.position === 'S'), d => d.amount ), opposition: d3.sum( committeeExpenditures .filter(d => d.candidate === 'Sheehy') .filter(d => d.position === 'O'), d => d.amount ), }, }, total: d3.sum(committeeExpenditures, d => d.amount) } })36:Tc5b,embedTable = { const proTester = byCommittee .filter(d => d.spending.Tester.support > 0 || d.spending.Sheehy.opposition > 0) .sort((a,b) => b.total - a.total) const proSheehy = byCommittee .filter(d => d.spending.Sheehy.support > 0 || d.spending.Tester.opposition > 0) .sort((a,b) => b.total - a.total) return html` ${tableStyle}

Spending by pro-Tester groups

💰 ${dollarFormat(d3.sum(proTester, d => d.total))} total as of ${updateDate}

${proTester.map(d => ``)}

	✅ For Tester	❌ Against Sheehy
${d.committee}	${dollarFormat(d.spending.Tester.support)}	${dollarFormat(d.spending.Sheehy.opposition)}
	${dollarFormat(d3.sum(proTester, d => d.spending.Tester.support))}	${dollarFormat(d3.sum(proTester, d => d.spending.Sheehy.opposition))}

Spending by pro-Sheehy groups

💰 ${dollarFormat(d3.sum(proSheehy, d => d.total))} total as of ${updateDate}

${proSheehy.map(d => ``)}

	✅ For Sheehy	❌ Against Tester
${d.committee}	${dollarFormat(d.spending.Sheehy.support)}	${dollarFormat(d.spending.Tester.opposition)}
	${dollarFormat(d3.sum(proSheehy, d => d.spending.Sheehy.support))}	${dollarFormat(d3.sum(proSheehy, d => d.spending.Tester.opposition))}

More Jobs, Less Government has also reported spending ${dollarFormat(d3.sum(barbSpending, d => d.amount))} against Green Party candidate Robert Barb.

Data: Federal Election Commission.

` }37:[{"id":"ea43a94509713344681178431c1d9c51cac9242674f5f2baad754238d11cf9b0ef812b2dbc0f0f592e9a598ef25c25c1bbdf57df09a6549048f786c902295e56","href":"https://static.observableusercontent.com/files/ea43a94509713344681178431c1d9c51cac9242674f5f2baad754238d11cf9b0ef812b2dbc0f0f592e9a598ef25c25c1bbdf57df09a6549048f786c902295e56","name":"2024-08-30-mtsen-independent-expenditures.csv","type":"text/csv","lastModified":1725046281215.144,"size":206741},{"id":"ea43a94509713344681178431c1d9c51cac9242674f5f2baad754238d11cf9b0ef812b2dbc0f0f592e9a598ef25c25c1bbdf57df09a6549048f786c902295e56","href":"https://static.observableusercontent.com/files/ea43a94509713344681178431c1d9c51cac9242674f5f2baad754238d11cf9b0ef812b2dbc0f0f592e9a598ef25c25c1bbdf57df09a6549048f786c902295e56","name":"2024-08-30-mtsen-independent-expenditures@1.csv","type":"text/csv","lastModified":1725053180382.53,"size":206741},{"id":"6ac9c0914f6d04bb9221aca1a6b02ffecc61638cf4a281c09b080805baf7eb12694febaa75e4d9ccc794470b66317cd062b9f0ca773f1617b0d633abde1fb7fe","href":"https://static.observableusercontent.com/files/6ac9c0914f6d04bb9221aca1a6b02ffecc61638cf4a281c09b080805baf7eb12694febaa75e4d9ccc794470b66317cd062b9f0ca773f1617b0d633abde1fb7fe","name":"2024-08-30-mtsen-independent-expenditures@2.csv","type":"text/csv","lastModified":1725060329911.532,"size":200922},{"id":"6cfc816e474cba67ce019f0d783d4ac8d6aa8565e0e6788b187d0c68e63c6c686bfb2d8cc276ca500dd137308ef6a9030f3c78a6f3f97475d046bb2d2d6be7ca","href":"https://static.observableusercontent.com/files/6cfc816e474cba67ce019f0d783d4ac8d6aa8565e0e6788b187d0c68e63c6c686bfb2d8cc276ca500dd137308ef6a9030f3c78a6f3f97475d046bb2d2d6be7ca","name":"2024-10-16-mtsen-independent-expenditures.csv","type":"text/csv","lastModified":1729091372757.572,"size":346320},{"id":"6cfc816e474cba67ce019f0d783d4ac8d6aa8565e0e6788b187d0c68e63c6c686bfb2d8cc276ca500dd137308ef6a9030f3c78a6f3f97475d046bb2d2d6be7ca","href":"https://static.observableusercontent.com/files/6cfc816e474cba67ce019f0d783d4ac8d6aa8565e0e6788b187d0c68e63c6c686bfb2d8cc276ca500dd137308ef6a9030f3c78a6f3f97475d046bb2d2d6be7ca","name":"2024-10-16-mtsen-independent-expenditures@1.csv","type":"text/csv","lastModified":1729093939622.139,"size":346320},{"id":"305b277d31ddc30badc231c148868be91e4f31dee532b057b019ff8012220c4706124edfd3b2d881692a975cd42ce25ddedcce52b272a7b0407852cc20dbda85","href":"https://static.observableusercontent.com/files/305b277d31ddc30badc231c148868be91e4f31dee532b057b019ff8012220c4706124edfd3b2d881692a975cd42ce25ddedcce52b272a7b0407852cc20dbda85","name":"2024-10-16-mtsen-independent-expenditures@2.csv","type":"text/csv","lastModified":1729094894814.961,"size":350172},{"id":"ce7b96004cf5d428d1a0d8947ba0e3c5e3f27f80d4aff43adcc679a975a7391c8db37c7910a85e89f4320d373ccb7fba3ed58bc64f7e43a6d9869bd20b470ebf","href":"https://static.observableusercontent.com/files/ce7b96004cf5d428d1a0d8947ba0e3c5e3f27f80d4aff43adcc679a975a7391c8db37c7910a85e89f4320d373ccb7fba3ed58bc64f7e43a6d9869bd20b470ebf","name":"2024-07-30-mtsen-independent-expenditures.csv","type":"text/csv","lastModified":1722442228677.834,"size":129083}] 32:{"id":"dfdfac10744ab459","slug":"montana-2024-senate-race-independent-expenditures","title":"Montana 2024 Senate race independent expenditures","thumbnail":"b7b0a071bce1cf656969a1a262a30dcf442088ab055b6c2c4d2f963653a813ce","access_level":"unlisted","create_time":"$D2024-07-30T20:57:42.311Z","update_time":"$D2025-07-15T17:10:01.370Z","view_time":null,"first_public_time":null,"has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"8fa547b9c358d4e8","login":"eidietrich","name":"Eric Dietrich","avatar_url":"https://avatars-next.observableusercontent.com/6a4f9d38834facbf55e9160551ff5c73115e28ebaddfbfc0116118b6d82c216d","tier":"starter_2024"},"version":266,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"4bd52d95d518f450","login":"eidietrich","name":"Eric Dietrich","avatar_url":"https://avatars-next.observableusercontent.com/6a4f9d38834facbf55e9160551ff5c73115e28ebaddfbfc0116118b6d82c216d","tier":null}],"members":[{"type":"individual","id":"4bd52d95d518f450","login":"eidietrich","name":"Eric Dietrich","avatar_url":"https://avatars-next.observableusercontent.com/6a4f9d38834facbf55e9160551ff5c73115e28ebaddfbfc0116118b6d82c216d","tier":null,"role":"editor"},{"type":"team","id":"8fa547b9c358d4e8","login":"eidietrich","name":"Eric Dietrich","avatar_url":"https://avatars-next.observableusercontent.com/6a4f9d38834facbf55e9160551ff5c73115e28ebaddfbfc0116118b6d82c216d","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Montana 2024 Senate race independent expenditures","cells":[{"id":0,"value":"# Montana 2024 Senate race independent expenditures\n\nSourced to Federal Election Commission data.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":135,"value":"updateDate = 'Oct. 16, 2024'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":253,"value":"barbSpending = expenditures.filter(d => d.candidate === 'Barb')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"$36","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"tableStyle = `\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"dollarFormat = d => {\n if (d === 0) return ' - '\n return d3.format('$,.0f')(d)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":194,"value":"fillColor = d => {\n const scale = d3.scaleThreshold()\n .domain([1e3, 1e6, 1e7, 1e8])\n .range(['#ffffd4','#fee391','#fec44f','#fe9929','#ec7014',])\n if (d === 0) return 'none'\n return scale(d)\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W37","stdlib":"1","titling":"auto"}} 33:"$32:body"