search

caciviclab / disclosure-backend-static

Campaign finance data powering Open Disclosure California
https://caciviclab.org/odca-jekyll/
15 stars 13 forks source link

Feat: make D expenditures from NetFile V2 API #334

Closed ckingbailey closed 2 months ago

ckingbailey commented 9 months ago

Like with Schedule A - Contributions, this reproduces the Schedule D - Expenditures structure that was returned by the old NetFile API, and on which the Ruby backend depends.

Also included in this work:

mikeubell commented 9 months ago
Build diff from Commit 90ac7411eebe7e0b37f483555451e4729bba3013: ```diff diff --git a/build/_data/candidates/oakland/2018-11-06/pamela-price.json b/build/_data/candidates/oakland/2018-11-06/pamela-price.json index bf8faf6..59f08a3 100644 --- a/build/_data/candidates/oakland/2018-11-06/pamela-price.json +++ b/build/_data/candidates/oakland/2018-11-06/pamela-price.json @@ -23,7 +23,7 @@ "supporting_money": { "contributions_received": 108582.9, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0, "total_supporting_independent": 0.0, "support_list": [ @@ -75,6 +75,6 @@ ] }, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0 } diff --git a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json index 677347f..c42fe7d 100644 --- a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json +++ b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json @@ -25,16 +25,16 @@ "total_contributions": 17530.0, "total_expenditures": 9718.34, "total_loans_received": 0.0, - "total_supporting_independent": 50172.51, + "total_supporting_independent": 71066.51, "support_list": [ { - "Total": 15800.0, + "Total": 23700.0, "Cand_ID": 1460829, "Filer_ID": "1433122", "Filer_NamL": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021" }, { - "Total": 30192.57, + "Total": 43186.57, "Cand_ID": 1460829, "Filer_ID": "1345259", "Filer_NamL": "Oakland Education Association Political Action Committee" diff --git a/build/_data/committees/1410941.json b/build/_data/committees/1410941.json index 178a733..fcb85cd 100644 --- a/build/_data/committees/1410941.json +++ b/build/_data/committees/1410941.json @@ -153,7 +153,7 @@ "Tran_Date": "2018-09-24", "Tran_NamF": null, "Tran_NamL": "Morse Management, Inc.", - "Tran_Zip4": "10022" + "Tran_Zip4": "94661" }, { "Filer_ID": "1410941", @@ -164,7 +164,7 @@ "Tran_Date": "2018-09-24", "Tran_NamF": null, "Tran_NamL": "Morse Management, Inc.", - "Tran_Zip4": "94661" + "Tran_Zip4": "10022" }, { "Filer_ID": "1410941", @@ -813,7 +813,7 @@ "Tran_Date": "2018-10-19", "Tran_NamF": "Garrett", "Tran_NamL": "Riegg", - "Tran_Zip4": "94602" + "Tran_Zip4": "94606" }, { "Filer_ID": "1410941", @@ -824,7 +824,7 @@ "Tran_Date": "2018-10-19", "Tran_NamF": "Garrett", "Tran_NamL": "Riegg", - "Tran_Zip4": "94606" + "Tran_Zip4": "94602" }, { "Filer_ID": "1410941", diff --git a/build/_data/committees/1421001.json b/build/_data/committees/1421001.json index 09cc4a0..ff4043a 100644 --- a/build/_data/committees/1421001.json +++ b/build/_data/committees/1421001.json @@ -1198,7 +1198,7 @@ "Tran_Date": "2020-07-15", "Tran_NamF": "Jonathan", "Tran_NamL": "Williams", - "Tran_Zip4": "94602" + "Tran_Zip4": "94603" }, { "Filer_ID": "1421001", @@ -1209,7 +1209,7 @@ "Tran_Date": "2020-07-15", "Tran_NamF": "Jonathan", "Tran_NamL": "Williams", - "Tran_Zip4": "94603" + "Tran_Zip4": "94602" }, { "Filer_ID": "1421001", diff --git a/build/_data/elections/oakland/2018-06-05.json b/build/_data/elections/oakland/2018-06-05.json index b39b338..140316d 100644 --- a/build/_data/elections/oakland/2018-06-05.json +++ b/build/_data/elections/oakland/2018-06-05.json @@ -57,7 +57,7 @@ "total_contributions": 15000.0 }, { - "name": "Service Employees International Union Local 1021 Issues PAC", + "name": "Oakland Athletics Baseball Company", "type": "Measure", "election_name": "oakland-june-2018", "total_contributions": 10000.0 diff --git a/build/_data/elections/oakland/2022-11-08.json b/build/_data/elections/oakland/2022-11-08.json index f716008..d436f62 100644 --- a/build/_data/elections/oakland/2022-11-08.json +++ b/build/_data/elections/oakland/2022-11-08.json @@ -2,13 +2,13 @@ "total_contributions": 6476065.89, "total_contributions_by_source": { "Out of State": 521147.35, - "Within Oakland": 2632398.1800000006, + "Within Oakland": 2632398.1799999997, "Within California": 3006531.1199999996 }, "contributions_by_type": { "PTY": 15900.0, "Committee": 995101.14, - "Individual": 2507910.870000002, + "Individual": 2507910.869999998, "Unitemized": 135828.3, "Self Funding": 2711.0, "Other (includes Businesses)": 2638453.6399999997 @@ -107,7 +107,7 @@ "total_contributions": 6300.0 }, { - "name": "Russ Taplin", + "name": "John Protopappas", "type": "Office", "election_name": "oakland-2022", "total_contributions": 5400.0 diff --git a/build/_data/elections/oakland/2023-11-07.json b/build/_data/elections/oakland/2023-11-07.json index 73ff78f..c04c7d7 100644 --- a/build/_data/elections/oakland/2023-11-07.json +++ b/build/_data/elections/oakland/2023-11-07.json @@ -32,12 +32,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", @@ -64,19 +64,19 @@ ], "top_contributors_for_offices": [ { - "name": "UA Local 342", + "name": "Service Employees International Union Local 1021 Candidate PAC", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Service Employees International Union Local 1021 Candidate PAC", + "name": "Laborers Local 304", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Laborers Local 304", + "name": "UA Local 342", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 diff --git a/build/_data/elections/oakland/2024-11-05.json b/build/_data/elections/oakland/2024-11-05.json index 129d546..adbcd09 100644 --- a/build/_data/elections/oakland/2024-11-05.json +++ b/build/_data/elections/oakland/2024-11-05.json @@ -49,19 +49,19 @@ ], "top_contributors_for_offices": [ { - "name": "Weylin White", + "name": "Todd Scanlin", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 }, { - "name": "Todd Scanlin", + "name": "Dow Terry", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 }, { - "name": "Jacob Zonn", + "name": "Brooke Levin", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 diff --git a/build/_data/stats.json b/build/_data/stats.json index f0b04ca..cf49212 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2023-10-29 00:07:45 -0700" + "date_processed": "2023-11-25 00:07:01 -0800" } diff --git a/build/_data/totals.json b/build/_data/totals.json index 4d36b47..a7468d2 100644 --- a/build/_data/totals.json +++ b/build/_data/totals.json @@ -782,13 +782,13 @@ "total_contributions": 6476065.89, "total_contributions_by_source": { "Out of State": 521147.35, - "Within Oakland": 2632398.1800000006, + "Within Oakland": 2632398.1799999997, "Within California": 3006531.1199999996 }, "contributions_by_type": { "PTY": 15900.0, "Committee": 995101.14, - "Individual": 2507910.870000002, + "Individual": 2507910.869999998, "Unitemized": 135828.3, "Self Funding": 2711.0, "Other (includes Businesses)": 2638453.6399999997 @@ -887,7 +887,7 @@ "total_contributions": 6300.0 }, { - "name": "Russ Taplin", + "name": "John Protopappas", "type": "Office", "election_name": "oakland-2022", "total_contributions": 5400.0 @@ -1033,7 +1033,7 @@ "total_contributions": 15000.0 }, { - "name": "Service Employees International Union Local 1021 Issues PAC", + "name": "Oakland Athletics Baseball Company", "type": "Measure", "election_name": "oakland-june-2018", "total_contributions": 10000.0 @@ -1345,12 +1345,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", @@ -1377,19 +1377,19 @@ ], "top_contributors_for_offices": [ { - "name": "UA Local 342", + "name": "Service Employees International Union Local 1021 Candidate PAC", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Service Employees International Union Local 1021 Candidate PAC", + "name": "Laborers Local 304", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Laborers Local 304", + "name": "UA Local 342", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 @@ -1493,19 +1493,19 @@ ], "top_contributors_for_offices": [ { - "name": "Weylin White", + "name": "Todd Scanlin", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 }, { - "name": "Todd Scanlin", + "name": "Dow Terry", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 }, { - "name": "Jacob Zonn", + "name": "Brooke Levin", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 ```
mikeubell commented 9 months ago
Build diff from Commit 4697968758c9e8fbe4afc5315c6c049f13e0d713: ```diff diff --git a/build/_data/candidates/oakland/2018-11-06/pamela-price.json b/build/_data/candidates/oakland/2018-11-06/pamela-price.json index bf8faf6..59f08a3 100644 --- a/build/_data/candidates/oakland/2018-11-06/pamela-price.json +++ b/build/_data/candidates/oakland/2018-11-06/pamela-price.json @@ -23,7 +23,7 @@ "supporting_money": { "contributions_received": 108582.9, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0, "total_supporting_independent": 0.0, "support_list": [ @@ -75,6 +75,6 @@ ] }, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0 } diff --git a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json index 677347f..c42fe7d 100644 --- a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json +++ b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json @@ -25,16 +25,16 @@ "total_contributions": 17530.0, "total_expenditures": 9718.34, "total_loans_received": 0.0, - "total_supporting_independent": 50172.51, + "total_supporting_independent": 71066.51, "support_list": [ { - "Total": 15800.0, + "Total": 23700.0, "Cand_ID": 1460829, "Filer_ID": "1433122", "Filer_NamL": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021" }, { - "Total": 30192.57, + "Total": 43186.57, "Cand_ID": 1460829, "Filer_ID": "1345259", "Filer_NamL": "Oakland Education Association Political Action Committee" diff --git a/build/_data/committees/1410941.json b/build/_data/committees/1410941.json index 178a733..fcb85cd 100644 --- a/build/_data/committees/1410941.json +++ b/build/_data/committees/1410941.json @@ -153,7 +153,7 @@ "Tran_Date": "2018-09-24", "Tran_NamF": null, "Tran_NamL": "Morse Management, Inc.", - "Tran_Zip4": "10022" + "Tran_Zip4": "94661" }, { "Filer_ID": "1410941", @@ -164,7 +164,7 @@ "Tran_Date": "2018-09-24", "Tran_NamF": null, "Tran_NamL": "Morse Management, Inc.", - "Tran_Zip4": "94661" + "Tran_Zip4": "10022" }, { "Filer_ID": "1410941", @@ -813,7 +813,7 @@ "Tran_Date": "2018-10-19", "Tran_NamF": "Garrett", "Tran_NamL": "Riegg", - "Tran_Zip4": "94602" + "Tran_Zip4": "94606" }, { "Filer_ID": "1410941", @@ -824,7 +824,7 @@ "Tran_Date": "2018-10-19", "Tran_NamF": "Garrett", "Tran_NamL": "Riegg", - "Tran_Zip4": "94606" + "Tran_Zip4": "94602" }, { "Filer_ID": "1410941", diff --git a/build/_data/committees/1421001.json b/build/_data/committees/1421001.json index 09cc4a0..ff4043a 100644 --- a/build/_data/committees/1421001.json +++ b/build/_data/committees/1421001.json @@ -1198,7 +1198,7 @@ "Tran_Date": "2020-07-15", "Tran_NamF": "Jonathan", "Tran_NamL": "Williams", - "Tran_Zip4": "94602" + "Tran_Zip4": "94603" }, { "Filer_ID": "1421001", @@ -1209,7 +1209,7 @@ "Tran_Date": "2020-07-15", "Tran_NamF": "Jonathan", "Tran_NamL": "Williams", - "Tran_Zip4": "94603" + "Tran_Zip4": "94602" }, { "Filer_ID": "1421001", diff --git a/build/_data/elections/oakland/2018-06-05.json b/build/_data/elections/oakland/2018-06-05.json index b39b338..140316d 100644 --- a/build/_data/elections/oakland/2018-06-05.json +++ b/build/_data/elections/oakland/2018-06-05.json @@ -57,7 +57,7 @@ "total_contributions": 15000.0 }, { - "name": "Service Employees International Union Local 1021 Issues PAC", + "name": "Oakland Athletics Baseball Company", "type": "Measure", "election_name": "oakland-june-2018", "total_contributions": 10000.0 diff --git a/build/_data/elections/oakland/2022-11-08.json b/build/_data/elections/oakland/2022-11-08.json index f716008..d436f62 100644 --- a/build/_data/elections/oakland/2022-11-08.json +++ b/build/_data/elections/oakland/2022-11-08.json @@ -2,13 +2,13 @@ "total_contributions": 6476065.89, "total_contributions_by_source": { "Out of State": 521147.35, - "Within Oakland": 2632398.1800000006, + "Within Oakland": 2632398.1799999997, "Within California": 3006531.1199999996 }, "contributions_by_type": { "PTY": 15900.0, "Committee": 995101.14, - "Individual": 2507910.870000002, + "Individual": 2507910.869999998, "Unitemized": 135828.3, "Self Funding": 2711.0, "Other (includes Businesses)": 2638453.6399999997 @@ -107,7 +107,7 @@ "total_contributions": 6300.0 }, { - "name": "Russ Taplin", + "name": "John Protopappas", "type": "Office", "election_name": "oakland-2022", "total_contributions": 5400.0 diff --git a/build/_data/elections/oakland/2023-11-07.json b/build/_data/elections/oakland/2023-11-07.json index 73ff78f..c04c7d7 100644 --- a/build/_data/elections/oakland/2023-11-07.json +++ b/build/_data/elections/oakland/2023-11-07.json @@ -32,12 +32,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", @@ -64,19 +64,19 @@ ], "top_contributors_for_offices": [ { - "name": "UA Local 342", + "name": "Service Employees International Union Local 1021 Candidate PAC", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Service Employees International Union Local 1021 Candidate PAC", + "name": "Laborers Local 304", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Laborers Local 304", + "name": "UA Local 342", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 diff --git a/build/_data/elections/oakland/2024-11-05.json b/build/_data/elections/oakland/2024-11-05.json index 129d546..adbcd09 100644 --- a/build/_data/elections/oakland/2024-11-05.json +++ b/build/_data/elections/oakland/2024-11-05.json @@ -49,19 +49,19 @@ ], "top_contributors_for_offices": [ { - "name": "Weylin White", + "name": "Todd Scanlin", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 }, { - "name": "Todd Scanlin", + "name": "Dow Terry", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 }, { - "name": "Jacob Zonn", + "name": "Brooke Levin", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 diff --git a/build/_data/stats.json b/build/_data/stats.json index f0b04ca..cf49212 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2023-10-29 00:07:45 -0700" + "date_processed": "2023-11-25 00:07:01 -0800" } diff --git a/build/_data/totals.json b/build/_data/totals.json index 4d36b47..a7468d2 100644 --- a/build/_data/totals.json +++ b/build/_data/totals.json @@ -782,13 +782,13 @@ "total_contributions": 6476065.89, "total_contributions_by_source": { "Out of State": 521147.35, - "Within Oakland": 2632398.1800000006, + "Within Oakland": 2632398.1799999997, "Within California": 3006531.1199999996 }, "contributions_by_type": { "PTY": 15900.0, "Committee": 995101.14, - "Individual": 2507910.870000002, + "Individual": 2507910.869999998, "Unitemized": 135828.3, "Self Funding": 2711.0, "Other (includes Businesses)": 2638453.6399999997 @@ -887,7 +887,7 @@ "total_contributions": 6300.0 }, { - "name": "Russ Taplin", + "name": "John Protopappas", "type": "Office", "election_name": "oakland-2022", "total_contributions": 5400.0 @@ -1033,7 +1033,7 @@ "total_contributions": 15000.0 }, { - "name": "Service Employees International Union Local 1021 Issues PAC", + "name": "Oakland Athletics Baseball Company", "type": "Measure", "election_name": "oakland-june-2018", "total_contributions": 10000.0 @@ -1345,12 +1345,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", @@ -1377,19 +1377,19 @@ ], "top_contributors_for_offices": [ { - "name": "UA Local 342", + "name": "Service Employees International Union Local 1021 Candidate PAC", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Service Employees International Union Local 1021 Candidate PAC", + "name": "Laborers Local 304", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 }, { - "name": "Laborers Local 304", + "name": "UA Local 342", "type": "Office", "election_name": "oakland-2023", "total_contributions": 1200.0 @@ -1493,19 +1493,19 @@ ], "top_contributors_for_offices": [ { - "name": "Weylin White", + "name": "Todd Scanlin", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 }, { - "name": "Todd Scanlin", + "name": "Dow Terry", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 }, { - "name": "Jacob Zonn", + "name": "Brooke Levin", "type": "Office", "election_name": "oakland-2024", "total_contributions": 1800.0 ```
mikeubell commented 9 months ago
Build diff from Commit a6d18e77466337c2685c6943ac473ab150125e7d: ```diff diff --git a/build/_data/candidates/oakland/2018-11-06/pamela-price.json b/build/_data/candidates/oakland/2018-11-06/pamela-price.json index bf8faf6..59f08a3 100644 --- a/build/_data/candidates/oakland/2018-11-06/pamela-price.json +++ b/build/_data/candidates/oakland/2018-11-06/pamela-price.json @@ -23,7 +23,7 @@ "supporting_money": { "contributions_received": 108582.9, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0, "total_supporting_independent": 0.0, "support_list": [ @@ -75,6 +75,6 @@ ] }, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0 } diff --git a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json index 677347f..c42fe7d 100644 --- a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json +++ b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json @@ -25,16 +25,16 @@ "total_contributions": 17530.0, "total_expenditures": 9718.34, "total_loans_received": 0.0, - "total_supporting_independent": 50172.51, + "total_supporting_independent": 71066.51, "support_list": [ { - "Total": 15800.0, + "Total": 23700.0, "Cand_ID": 1460829, "Filer_ID": "1433122", "Filer_NamL": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021" }, { - "Total": 30192.57, + "Total": 43186.57, "Cand_ID": 1460829, "Filer_ID": "1345259", "Filer_NamL": "Oakland Education Association Political Action Committee" diff --git a/build/_data/committees/1421001.json b/build/_data/committees/1421001.json index 09cc4a0..b4205e8 100644 --- a/build/_data/committees/1421001.json +++ b/build/_data/committees/1421001.json @@ -1500,24 +1500,24 @@ { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Owner", + "Tran_Occ": "Operations Manager", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75204" + "Tran_Zip4": "75154" }, { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Operations Manager", + "Tran_Occ": "Owner", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75154" + "Tran_Zip4": "75204" }, { "Filer_ID": "1421001", diff --git a/build/_data/elections/oakland/2023-11-07.json b/build/_data/elections/oakland/2023-11-07.json index 73ff78f..d7dd602 100644 --- a/build/_data/elections/oakland/2023-11-07.json +++ b/build/_data/elections/oakland/2023-11-07.json @@ -32,12 +32,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", diff --git a/build/_data/stats.json b/build/_data/stats.json index f0b04ca..8de529d 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2023-10-29 00:07:45 -0700" + "date_processed": "2023-11-26 00:07:10 -0800" } diff --git a/build/_data/totals.json b/build/_data/totals.json index 4d36b47..aab55c9 100644 --- a/build/_data/totals.json +++ b/build/_data/totals.json @@ -1345,12 +1345,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", ```
mikeubell commented 9 months ago
Build diff from Commit 41e13d746e8e062e9cdd26dee9cc7396ba73a987: ```diff diff --git a/build/_data/candidates/oakland/2018-11-06/pamela-price.json b/build/_data/candidates/oakland/2018-11-06/pamela-price.json index bf8faf6..59f08a3 100644 --- a/build/_data/candidates/oakland/2018-11-06/pamela-price.json +++ b/build/_data/candidates/oakland/2018-11-06/pamela-price.json @@ -23,7 +23,7 @@ "supporting_money": { "contributions_received": 108582.9, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0, "total_supporting_independent": 0.0, "support_list": [ @@ -75,6 +75,6 @@ ] }, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0 } diff --git a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json index 677347f..c42fe7d 100644 --- a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json +++ b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json @@ -25,16 +25,16 @@ "total_contributions": 17530.0, "total_expenditures": 9718.34, "total_loans_received": 0.0, - "total_supporting_independent": 50172.51, + "total_supporting_independent": 71066.51, "support_list": [ { - "Total": 15800.0, + "Total": 23700.0, "Cand_ID": 1460829, "Filer_ID": "1433122", "Filer_NamL": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021" }, { - "Total": 30192.57, + "Total": 43186.57, "Cand_ID": 1460829, "Filer_ID": "1345259", "Filer_NamL": "Oakland Education Association Political Action Committee" diff --git a/build/_data/committees/1421001.json b/build/_data/committees/1421001.json index 09cc4a0..b4205e8 100644 --- a/build/_data/committees/1421001.json +++ b/build/_data/committees/1421001.json @@ -1500,24 +1500,24 @@ { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Owner", + "Tran_Occ": "Operations Manager", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75204" + "Tran_Zip4": "75154" }, { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Operations Manager", + "Tran_Occ": "Owner", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75154" + "Tran_Zip4": "75204" }, { "Filer_ID": "1421001", diff --git a/build/_data/elections/oakland/2022-11-08.json b/build/_data/elections/oakland/2022-11-08.json index f716008..b906816 100644 --- a/build/_data/elections/oakland/2022-11-08.json +++ b/build/_data/elections/oakland/2022-11-08.json @@ -8,7 +8,7 @@ "contributions_by_type": { "PTY": 15900.0, "Committee": 995101.14, - "Individual": 2507910.870000002, + "Individual": 2507910.869999998, "Unitemized": 135828.3, "Self Funding": 2711.0, "Other (includes Businesses)": 2638453.6399999997 diff --git a/build/_data/elections/oakland/2023-11-07.json b/build/_data/elections/oakland/2023-11-07.json index 73ff78f..d7dd602 100644 --- a/build/_data/elections/oakland/2023-11-07.json +++ b/build/_data/elections/oakland/2023-11-07.json @@ -32,12 +32,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", diff --git a/build/_data/stats.json b/build/_data/stats.json index f0b04ca..8413194 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2023-10-29 00:07:45 -0700" + "date_processed": "2023-11-28 00:07:20 -0800" } diff --git a/build/_data/totals.json b/build/_data/totals.json index 4d36b47..59cf9b4 100644 --- a/build/_data/totals.json +++ b/build/_data/totals.json @@ -788,7 +788,7 @@ "contributions_by_type": { "PTY": 15900.0, "Committee": 995101.14, - "Individual": 2507910.870000002, + "Individual": 2507910.869999998, "Unitemized": 135828.3, "Self Funding": 2711.0, "Other (includes Businesses)": 2638453.6399999997 @@ -1345,12 +1345,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", ```
mikeubell commented 9 months ago
Build diff from Commit 2ff3e7438badefea9d463d190b26fb26ef7d64b1: ```diff diff --git a/build/_data/candidates/oakland/2018-11-06/pamela-price.json b/build/_data/candidates/oakland/2018-11-06/pamela-price.json index bf8faf6..59f08a3 100644 --- a/build/_data/candidates/oakland/2018-11-06/pamela-price.json +++ b/build/_data/candidates/oakland/2018-11-06/pamela-price.json @@ -23,7 +23,7 @@ "supporting_money": { "contributions_received": 108582.9, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0, "total_supporting_independent": 0.0, "support_list": [ @@ -75,6 +75,6 @@ ] }, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0 } diff --git a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json index 677347f..c42fe7d 100644 --- a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json +++ b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json @@ -25,16 +25,16 @@ "total_contributions": 17530.0, "total_expenditures": 9718.34, "total_loans_received": 0.0, - "total_supporting_independent": 50172.51, + "total_supporting_independent": 71066.51, "support_list": [ { - "Total": 15800.0, + "Total": 23700.0, "Cand_ID": 1460829, "Filer_ID": "1433122", "Filer_NamL": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021" }, { - "Total": 30192.57, + "Total": 43186.57, "Cand_ID": 1460829, "Filer_ID": "1345259", "Filer_NamL": "Oakland Education Association Political Action Committee" diff --git a/build/_data/committees/1421001.json b/build/_data/committees/1421001.json index 09cc4a0..b4205e8 100644 --- a/build/_data/committees/1421001.json +++ b/build/_data/committees/1421001.json @@ -1500,24 +1500,24 @@ { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Owner", + "Tran_Occ": "Operations Manager", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75204" + "Tran_Zip4": "75154" }, { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Operations Manager", + "Tran_Occ": "Owner", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75154" + "Tran_Zip4": "75204" }, { "Filer_ID": "1421001", diff --git a/build/_data/elections/oakland/2023-11-07.json b/build/_data/elections/oakland/2023-11-07.json index 73ff78f..d7dd602 100644 --- a/build/_data/elections/oakland/2023-11-07.json +++ b/build/_data/elections/oakland/2023-11-07.json @@ -32,12 +32,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", diff --git a/build/_data/stats.json b/build/_data/stats.json index f0b04ca..8413194 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2023-10-29 00:07:45 -0700" + "date_processed": "2023-11-28 00:07:20 -0800" } diff --git a/build/_data/totals.json b/build/_data/totals.json index 4d36b47..aab55c9 100644 --- a/build/_data/totals.json +++ b/build/_data/totals.json @@ -1345,12 +1345,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", ```
mikeubell commented 9 months ago
Build diff from Commit 9bc4eab4bce9241a2ffadd5af46738274fdfb6d6: ```diff diff --git a/build/_data/candidates/oakland/2018-11-06/pamela-price.json b/build/_data/candidates/oakland/2018-11-06/pamela-price.json index bf8faf6..59f08a3 100644 --- a/build/_data/candidates/oakland/2018-11-06/pamela-price.json +++ b/build/_data/candidates/oakland/2018-11-06/pamela-price.json @@ -23,7 +23,7 @@ "supporting_money": { "contributions_received": 108582.9, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0, "total_supporting_independent": 0.0, "support_list": [ @@ -75,6 +75,6 @@ ] }, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0 } diff --git a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json index 677347f..c42fe7d 100644 --- a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json +++ b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json @@ -25,16 +25,16 @@ "total_contributions": 17530.0, "total_expenditures": 9718.34, "total_loans_received": 0.0, - "total_supporting_independent": 50172.51, + "total_supporting_independent": 71066.51, "support_list": [ { - "Total": 15800.0, + "Total": 23700.0, "Cand_ID": 1460829, "Filer_ID": "1433122", "Filer_NamL": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021" }, { - "Total": 30192.57, + "Total": 43186.57, "Cand_ID": 1460829, "Filer_ID": "1345259", "Filer_NamL": "Oakland Education Association Political Action Committee" diff --git a/build/_data/committees/1421001.json b/build/_data/committees/1421001.json index 09cc4a0..b4205e8 100644 --- a/build/_data/committees/1421001.json +++ b/build/_data/committees/1421001.json @@ -1500,24 +1500,24 @@ { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Owner", + "Tran_Occ": "Operations Manager", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75204" + "Tran_Zip4": "75154" }, { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Operations Manager", + "Tran_Occ": "Owner", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75154" + "Tran_Zip4": "75204" }, { "Filer_ID": "1421001", diff --git a/build/_data/elections/oakland/2022-11-08.json b/build/_data/elections/oakland/2022-11-08.json index f716008..b906816 100644 --- a/build/_data/elections/oakland/2022-11-08.json +++ b/build/_data/elections/oakland/2022-11-08.json @@ -8,7 +8,7 @@ "contributions_by_type": { "PTY": 15900.0, "Committee": 995101.14, - "Individual": 2507910.870000002, + "Individual": 2507910.869999998, "Unitemized": 135828.3, "Self Funding": 2711.0, "Other (includes Businesses)": 2638453.6399999997 diff --git a/build/_data/elections/oakland/2023-11-07.json b/build/_data/elections/oakland/2023-11-07.json index 73ff78f..d7dd602 100644 --- a/build/_data/elections/oakland/2023-11-07.json +++ b/build/_data/elections/oakland/2023-11-07.json @@ -32,12 +32,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", diff --git a/build/_data/stats.json b/build/_data/stats.json index f0b04ca..0a08ffa 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2023-10-29 00:07:45 -0700" + "date_processed": "2023-12-05 00:08:16 -0800" } diff --git a/build/_data/totals.json b/build/_data/totals.json index 4d36b47..59cf9b4 100644 --- a/build/_data/totals.json +++ b/build/_data/totals.json @@ -788,7 +788,7 @@ "contributions_by_type": { "PTY": 15900.0, "Committee": 995101.14, - "Individual": 2507910.870000002, + "Individual": 2507910.869999998, "Unitemized": 135828.3, "Self Funding": 2711.0, "Other (includes Businesses)": 2638453.6399999997 @@ -1345,12 +1345,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", ```
mikeubell commented 9 months ago
Build diff from Commit 4b8ba5d56c36be97b322e4c223eaadab462c89e9: ```diff diff --git a/build/_data/candidates/oakland/2018-11-06/pamela-price.json b/build/_data/candidates/oakland/2018-11-06/pamela-price.json index bf8faf6..59f08a3 100644 --- a/build/_data/candidates/oakland/2018-11-06/pamela-price.json +++ b/build/_data/candidates/oakland/2018-11-06/pamela-price.json @@ -23,7 +23,7 @@ "supporting_money": { "contributions_received": 108582.9, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0, "total_supporting_independent": 0.0, "support_list": [ @@ -75,6 +75,6 @@ ] }, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0 } diff --git a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json index 677347f..c42fe7d 100644 --- a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json +++ b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json @@ -25,16 +25,16 @@ "total_contributions": 17530.0, "total_expenditures": 9718.34, "total_loans_received": 0.0, - "total_supporting_independent": 50172.51, + "total_supporting_independent": 71066.51, "support_list": [ { - "Total": 15800.0, + "Total": 23700.0, "Cand_ID": 1460829, "Filer_ID": "1433122", "Filer_NamL": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021" }, { - "Total": 30192.57, + "Total": 43186.57, "Cand_ID": 1460829, "Filer_ID": "1345259", "Filer_NamL": "Oakland Education Association Political Action Committee" diff --git a/build/_data/committees/1421001.json b/build/_data/committees/1421001.json index 09cc4a0..b4205e8 100644 --- a/build/_data/committees/1421001.json +++ b/build/_data/committees/1421001.json @@ -1500,24 +1500,24 @@ { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Owner", + "Tran_Occ": "Operations Manager", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75204" + "Tran_Zip4": "75154" }, { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Operations Manager", + "Tran_Occ": "Owner", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75154" + "Tran_Zip4": "75204" }, { "Filer_ID": "1421001", diff --git a/build/_data/elections/oakland/2023-11-07.json b/build/_data/elections/oakland/2023-11-07.json index 73ff78f..d7dd602 100644 --- a/build/_data/elections/oakland/2023-11-07.json +++ b/build/_data/elections/oakland/2023-11-07.json @@ -32,12 +32,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", diff --git a/build/_data/stats.json b/build/_data/stats.json index f0b04ca..9c37626 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2023-10-29 00:07:45 -0700" + "date_processed": "2023-12-07 00:08:49 -0800" } diff --git a/build/_data/totals.json b/build/_data/totals.json index 4d36b47..aab55c9 100644 --- a/build/_data/totals.json +++ b/build/_data/totals.json @@ -1345,12 +1345,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", ```
mikeubell commented 9 months ago
Build diff from Commit 9f91aca5c9da4e176f24fe985f89a361a67e0897: ```diff diff --git a/build/_data/candidates/oakland/2018-11-06/pamela-price.json b/build/_data/candidates/oakland/2018-11-06/pamela-price.json index bf8faf6..59f08a3 100644 --- a/build/_data/candidates/oakland/2018-11-06/pamela-price.json +++ b/build/_data/candidates/oakland/2018-11-06/pamela-price.json @@ -23,7 +23,7 @@ "supporting_money": { "contributions_received": 108582.9, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0, "total_supporting_independent": 0.0, "support_list": [ @@ -75,6 +75,6 @@ ] }, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0 } diff --git a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json index 677347f..c42fe7d 100644 --- a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json +++ b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json @@ -25,16 +25,16 @@ "total_contributions": 17530.0, "total_expenditures": 9718.34, "total_loans_received": 0.0, - "total_supporting_independent": 50172.51, + "total_supporting_independent": 71066.51, "support_list": [ { - "Total": 15800.0, + "Total": 23700.0, "Cand_ID": 1460829, "Filer_ID": "1433122", "Filer_NamL": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021" }, { - "Total": 30192.57, + "Total": 43186.57, "Cand_ID": 1460829, "Filer_ID": "1345259", "Filer_NamL": "Oakland Education Association Political Action Committee" diff --git a/build/_data/committees/1421001.json b/build/_data/committees/1421001.json index 09cc4a0..b4205e8 100644 --- a/build/_data/committees/1421001.json +++ b/build/_data/committees/1421001.json @@ -1500,24 +1500,24 @@ { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Owner", + "Tran_Occ": "Operations Manager", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75204" + "Tran_Zip4": "75154" }, { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Operations Manager", + "Tran_Occ": "Owner", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75154" + "Tran_Zip4": "75204" }, { "Filer_ID": "1421001", diff --git a/build/_data/elections/oakland/2023-11-07.json b/build/_data/elections/oakland/2023-11-07.json index 73ff78f..d7dd602 100644 --- a/build/_data/elections/oakland/2023-11-07.json +++ b/build/_data/elections/oakland/2023-11-07.json @@ -32,12 +32,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", diff --git a/build/_data/stats.json b/build/_data/stats.json index f0b04ca..9c37626 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2023-10-29 00:07:45 -0700" + "date_processed": "2023-12-07 00:08:49 -0800" } diff --git a/build/_data/totals.json b/build/_data/totals.json index 4d36b47..aab55c9 100644 --- a/build/_data/totals.json +++ b/build/_data/totals.json @@ -1345,12 +1345,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", ```
ckingbailey commented 9 months ago

@ChenglimEar I think I handled all your comments. Please let me know if I overlooked or misinterpreted anything. And let me if the comments are adequate or if I should go more in depth.

mikeubell commented 9 months ago
Build diff from Commit aeb8b3dccb02bb2a4fc661e4d925b3ce44943bc4: ```diff diff --git a/build/_data/candidates/oakland/2018-11-06/pamela-price.json b/build/_data/candidates/oakland/2018-11-06/pamela-price.json index bf8faf6..59f08a3 100644 --- a/build/_data/candidates/oakland/2018-11-06/pamela-price.json +++ b/build/_data/candidates/oakland/2018-11-06/pamela-price.json @@ -23,7 +23,7 @@ "supporting_money": { "contributions_received": 108582.9, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0, "total_supporting_independent": 0.0, "support_list": [ @@ -75,6 +75,6 @@ ] }, "total_contributions": 108582.9, - "total_expenditures": 113488.51, + "total_expenditures": 113768.41, "total_loans_received": 34500.0 } diff --git a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json index 677347f..c42fe7d 100644 --- a/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json +++ b/build/_data/candidates/oakland/2023-11-07/alexandra-ritzie-hernandez.json @@ -25,16 +25,16 @@ "total_contributions": 17530.0, "total_expenditures": 9718.34, "total_loans_received": 0.0, - "total_supporting_independent": 50172.51, + "total_supporting_independent": 71066.51, "support_list": [ { - "Total": 15800.0, + "Total": 23700.0, "Cand_ID": 1460829, "Filer_ID": "1433122", "Filer_NamL": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021" }, { - "Total": 30192.57, + "Total": 43186.57, "Cand_ID": 1460829, "Filer_ID": "1345259", "Filer_NamL": "Oakland Education Association Political Action Committee" diff --git a/build/_data/committees/1421001.json b/build/_data/committees/1421001.json index 09cc4a0..b4205e8 100644 --- a/build/_data/committees/1421001.json +++ b/build/_data/committees/1421001.json @@ -1500,24 +1500,24 @@ { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Owner", + "Tran_Occ": "Operations Manager", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75204" + "Tran_Zip4": "75154" }, { "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Operations Manager", + "Tran_Occ": "Owner", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75154" + "Tran_Zip4": "75204" }, { "Filer_ID": "1421001", diff --git a/build/_data/elections/oakland/2023-11-07.json b/build/_data/elections/oakland/2023-11-07.json index 73ff78f..d7dd602 100644 --- a/build/_data/elections/oakland/2023-11-07.json +++ b/build/_data/elections/oakland/2023-11-07.json @@ -32,12 +32,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", diff --git a/build/_data/stats.json b/build/_data/stats.json index f0b04ca..9c37626 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2023-10-29 00:07:45 -0700" + "date_processed": "2023-12-07 00:08:49 -0800" } diff --git a/build/_data/totals.json b/build/_data/totals.json index 4d36b47..aab55c9 100644 --- a/build/_data/totals.json +++ b/build/_data/totals.json @@ -1345,12 +1345,12 @@ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 30192.57 + "total_spending": 43186.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 15800.0 + "total_spending": 23700.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", ```
ChenglimEar commented 3 months ago

@ckingbailey Sorry, it took so long to get back to this. I went through a number of PRs to get csvkit upgraded so that we can use the version of SQLAlchemy that you will need. I'm reviewing again now and hoping to approve this soon.

ckingbailey commented 3 months ago

@ChenglimEar I've picked up changes from master.

It wasn't my intention for people to install the dependencies from both the "main" project and the "sub-project" of the downloader in one environment. That's why I made a separate requirements.txt, so that we could treat those lists of dependencies as separate.

mikeubell commented 3 months ago
Build diff from Commit 4daf929ee1d16a62d2e6cbaa07f46783aebac024: ```diff diff --git a/build/_data/committees/1421001.json b/build/_data/committees/1421001.json index df32b3d..05f9af2 100644 --- a/build/_data/committees/1421001.json +++ b/build/_data/committees/1421001.json @@ -1416,7 +1416,7 @@ "Tran_Date": "2020-07-15", "Tran_NamF": "Jonathan", "Tran_NamL": "Williams", - "Tran_Zip4": "94603", + "Tran_Zip4": "94602", "election_name": "oakland-2020" }, { @@ -1429,7 +1429,7 @@ "Tran_Date": "2020-07-15", "Tran_NamF": "Jonathan", "Tran_NamL": "Williams", - "Tran_Zip4": "94602", + "Tran_Zip4": "94603", "election_name": "oakland-2020" }, { @@ -1774,26 +1774,26 @@ "title": "Oakland November 3rd, 2020 General Election", "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Operations Manager", + "Tran_Occ": "Owner", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75154", + "Tran_Zip4": "75204", "election_name": "oakland-2020" }, { "title": "Oakland November 3rd, 2020 General Election", "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Owner", + "Tran_Occ": "Operations Manager", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75204", + "Tran_Zip4": "75154", "election_name": "oakland-2020" }, { diff --git a/build/_data/stats.json b/build/_data/stats.json index b6093aa..6981797 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2024-05-24 00:08:18 -0700" + "date_processed": "2024-05-27 00:08:21 -0700" } ```
mikeubell commented 3 months ago
Build diff from Commit 60f865315cffa439c63d16c3f7ca6f222846026d: ```diff diff --git a/build/_data/committees/1421001.json b/build/_data/committees/1421001.json index df32b3d..05f9af2 100644 --- a/build/_data/committees/1421001.json +++ b/build/_data/committees/1421001.json @@ -1416,7 +1416,7 @@ "Tran_Date": "2020-07-15", "Tran_NamF": "Jonathan", "Tran_NamL": "Williams", - "Tran_Zip4": "94603", + "Tran_Zip4": "94602", "election_name": "oakland-2020" }, { @@ -1429,7 +1429,7 @@ "Tran_Date": "2020-07-15", "Tran_NamF": "Jonathan", "Tran_NamL": "Williams", - "Tran_Zip4": "94602", + "Tran_Zip4": "94603", "election_name": "oakland-2020" }, { @@ -1774,26 +1774,26 @@ "title": "Oakland November 3rd, 2020 General Election", "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Operations Manager", + "Tran_Occ": "Owner", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75154", + "Tran_Zip4": "75204", "election_name": "oakland-2020" }, { "title": "Oakland November 3rd, 2020 General Election", "Filer_ID": "1421001", "Tran_Emp": "Jordan Custom Builders", - "Tran_Occ": "Owner", + "Tran_Occ": "Operations Manager", "Entity_Cd": "Individual", "Tran_Amt1": 200.0, "Tran_Date": "2020-07-21", "Tran_NamF": "Billy", "Tran_NamL": "Jordan", - "Tran_Zip4": "75204", + "Tran_Zip4": "75154", "election_name": "oakland-2020" }, { ```