Determine the quantity of committee to committee expenditures for ballot measures about disclosure-backend-static HOT 9 CLOSED

@michaelliu2 What is the total amount, and which committees do it?

I promised you a data dictionary. Here it is:

https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76

I feel like a spreadsheet is still not the optimal format for a data dictionary, but at least it has a little bit of a description about each field 😀

Also, I kind of like the term "transfer" for tabulating this internally but agree with @sfdoran that it probably isn't good terminology to surface to users. The benefit of using a term like that within our codebase is that it gives us a shorthand to refer to those expenditures rather than the longwinded name: "committee to committee expenditures".

from disclosure-backend-static.

Schedule E contains a transfer code:
TSF transfer between committees of the same candidate/sponsor

from disclosure-backend-static.

Initial finds...
Looks like there's 28 contributions to other committees from this query :
SELECT COUNT(*) FROM "efile_COAK_2016_497" WHERE "Cmte_ID" IS NOT NULL;.

Not sure if that's correct or not. Still trying to understand all the forms stuff

from disclosure-backend-static.

I've seen accounting software have 3 fields, income, expenses, and
transfers. We can treat this committee -> committee money as tranfers
rather than expenses. Similarly how we track Loans separate from
contributions to candidates.

Not sure if @sfdoran has better terminology or ideas on how this kind of
money should be visualized. cc @elinaru

Aaron D Borden
Human and Hacker

from disclosure-backend-static.

I wouldn't use the term transfers because it is still a contribution from one committee to another, it just happens that in the particular case both committees have designated themselves as primarily-formed to support this one measure. The other cases that Michael is finding are the more typical - general purpose committees contributing to candidate committees or a single primarily-formed ballot committee. I will keep pondering.

from disclosure-backend-static.

I agree that "transfers" is not ideal for users, but I'm a fan of
matching the Domain vocabulary and the code. That is, the code should
use the actual terminology from the Domain. So I'm leaving the very hard
task to our Domain expert @sfdoran to come up with a good name ;)

Aaron D Borden
Human and Hacker

from disclosure-backend-static.

@tdooner

I think I needed to filter on the form_type for the first query I did.
Looks like $103,668.29 in total contributions to other committees, according to this query:

SELECT SUM("Amount") FROM "efile_COAK_2016_497" WHERE "Cmte_ID" IS NOT NULL AND "Form_Type"= 'F497P2';

Also, Causa Justa :: Just Cause (nonprofit 501(c)(3)) had amount of $59,000, which accounts for more than half

from disclosure-backend-static.

Committees transferring money to other committees and amounts

SELECT "Filer_NamL", "Enty_NamL", "Amount" FROM "efile_COAK_2016_497" WHERE "Cmte_ID" IS NOT NULL AND "Form_Type"= 'F497P2' ORDER BY "Amount" DESC;

from disclosure-backend-static.

Closing for inactivity.

from disclosure-backend-static.