search

caciviclab / disclosure-backend-static

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

Fix filings that have 'pending' as the Filer_ID #327

Closed mikeubell closed 10 months ago

mikeubell commented 10 months ago

Candidates can file reports with a 'pending' Filer_ID. At some later point they can file an amended filing but in the meantime after they get their ID we mark them in the has_pending column of the candidates sheet. This code can then update the tables with the ID.
(Current example is Jorge Lerma)

mikeubell commented 10 months ago
Build diff from Commit 89a0a516c0c333783d44890cdc7fa41658673012: ```diff diff --git a/build/_candidates/oakland/2023-11-07/jorge-c-lerma.md b/build/_candidates/oakland/2023-11-07/jorge-c-lerma.md index 0a26a31..5e5527b 100644 --- a/build/_candidates/oakland/2023-11-07/jorge-c-lerma.md +++ b/build/_candidates/oakland/2023-11-07/jorge-c-lerma.md @@ -1,6 +1,6 @@ --- election: _elections/oakland/2023-11-07.md -committee_name: Jorge Lerma for Oakland School Board 2023 +committee_name: Jorge Lerma For Oakland School Board 2023 filer_id: '1463520' is_incumbent: false name: Jorge C. Lerma diff --git a/build/_committees/1463520.md b/build/_committees/1463520.md index 0ac77f4..1b027a5 100644 --- a/build/_committees/1463520.md +++ b/build/_committees/1463520.md @@ -1,7 +1,7 @@ --- filer_id: '1463520' -name: Jorge Lerma for Oakland School Board 2023 +name: Jorge Lerma For Oakland School Board 2023 candidate_controlled_id: '' data_warning: -title: Jorge Lerma for Oakland School Board 2023 +title: Jorge Lerma For Oakland School Board 2023 --- 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 d6630f9..677347f 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": 30188.51, + "total_supporting_independent": 50172.51, "support_list": [ { - "Total": 7900.0, + "Total": 15800.0, "Cand_ID": 1460829, "Filer_ID": "1433122", "Filer_NamL": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021" }, { - "Total": 18108.57, + "Total": 30192.57, "Cand_ID": 1460829, "Filer_ID": "1345259", "Filer_NamL": "Oakland Education Association Political Action Committee" diff --git a/build/_data/candidates/oakland/2023-11-07/jorge-c-lerma.json b/build/_data/candidates/oakland/2023-11-07/jorge-c-lerma.json index 5a8d081..bd5760a 100644 --- a/build/_data/candidates/oakland/2023-11-07/jorge-c-lerma.json +++ b/build/_data/candidates/oakland/2023-11-07/jorge-c-lerma.json @@ -13,7 +13,7 @@ "ballot_item": 17, "office_election": 17, "bio": null, - "committee_name": "Jorge Lerma for Oakland School Board 2023", + "committee_name": "Jorge Lerma For Oakland School Board 2023", "is_accepted_expenditure_ceiling": null, "is_incumbent": false, "occupation": "Educator, Administrator, Community Activist", @@ -21,20 +21,27 @@ "is_winner": null, "filer_id": 1463520, "supporting_money": { - "contributions_received": 0.0, - "total_contributions": 0.0, - "total_expenditures": null, - "total_loans_received": null, + "contributions_received": 5885.0, + "total_contributions": 5885.0, + "total_expenditures": 678.1, + "total_loans_received": 0.0, "total_supporting_independent": 0.0, "support_list": [ ], "contributions_by_type": { + "Individual": 5600.0, + "Unitemized": 285.0 }, "contributions_by_origin": { + "Out of State": 1200.0, + "Within Oakland": 3500.0, + "Within California": 900.0 }, - "total_small_contributions": null, + "total_small_contributions": 285.0, "expenditures_by_type": { + "Polling and Survey Research": 195.0, + "Information Technology Costs (Internet, E-mail)": 444.75 }, "supporting_by_type": { } @@ -47,7 +54,7 @@ ] }, - "total_contributions": 0.0, - "total_expenditures": null, - "total_loans_received": null + "total_contributions": 5885.0, + "total_expenditures": 678.1, + "total_loans_received": 0.0 } 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/committees/1463520.json b/build/_data/committees/1463520.json index d4486af..3b5cc68 100644 --- a/build/_data/committees/1463520.json +++ b/build/_data/committees/1463520.json @@ -1,6 +1,181 @@ { - "total_contributions": 0, + "total_contributions": 5600.0, "contributions": [ - + { + "Filer_ID": "1463520", + "Tran_Emp": "Oakland Unified schools", + "Tran_Occ": "Administrator as needed", + "Entity_Cd": "Individual", + "Tran_Amt1": 100.0, + "Tran_Date": "2023-10-04", + "Tran_NamF": "Maureen", + "Tran_NamL": "Hartney", + "Tran_Zip4": "94602" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "Salesforce", + "Tran_Occ": "Decision Scientist", + "Entity_Cd": "Individual", + "Tran_Amt1": 100.0, + "Tran_Date": "2023-10-04", + "Tran_NamF": "Brandon", + "Tran_NamL": "Wall", + "Tran_Zip4": "94602-1146" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "Rogers Family Foundation", + "Tran_Occ": "NONPROFIT", + "Entity_Cd": "Individual", + "Tran_Amt1": 100.0, + "Tran_Date": "2023-10-05", + "Tran_NamF": "Sara", + "Tran_NamL": "Levine", + "Tran_Zip4": "94610" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "Not Employed", + "Tran_Occ": "Not Employed", + "Entity_Cd": "Individual", + "Tran_Amt1": 100.0, + "Tran_Date": "2023-10-06", + "Tran_NamF": "Steven", + "Tran_NamL": "Fajardo", + "Tran_Zip4": "94608" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "Momentive", + "Tran_Occ": "Lawyer", + "Entity_Cd": "Individual", + "Tran_Amt1": 100.0, + "Tran_Date": "2023-10-06", + "Tran_NamF": "Nina", + "Tran_NamL": "Senn", + "Tran_Zip4": "94611" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "Donahue Fitzgerald LLP", + "Tran_Occ": "Attorney", + "Entity_Cd": "Individual", + "Tran_Amt1": 100.0, + "Tran_Date": "2023-10-06", + "Tran_NamF": "David", + "Tran_NamL": "Stein", + "Tran_Zip4": "94501" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "City of Oakland", + "Tran_Occ": "Policy Analyst", + "Entity_Cd": "Individual", + "Tran_Amt1": 100.0, + "Tran_Date": "2023-10-07", + "Tran_NamF": "Caleb", + "Tran_NamL": "Smith", + "Tran_Zip4": "94610" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "Self Employed", + "Tran_Occ": "Handyman", + "Entity_Cd": "Individual", + "Tran_Amt1": 600.0, + "Tran_Date": "2023-10-10", + "Tran_NamF": "Ricky", + "Tran_NamL": "Cantu", + "Tran_Zip4": "77339" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "Self Employed", + "Tran_Occ": "Self Employed", + "Entity_Cd": "Individual", + "Tran_Amt1": 600.0, + "Tran_Date": "2023-10-10", + "Tran_NamF": "Emmanuel", + "Tran_NamL": "Gomez", + "Tran_Zip4": "94601" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "Retired", + "Tran_Occ": "Retired", + "Entity_Cd": "Individual", + "Tran_Amt1": 600.0, + "Tran_Date": "2023-10-10", + "Tran_NamF": "Onaida", + "Tran_NamL": "Lerma", + "Tran_Zip4": "94602" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "Self Employed", + "Tran_Occ": "Self Employed", + "Entity_Cd": "Individual", + "Tran_Amt1": 600.0, + "Tran_Date": "2023-10-10", + "Tran_NamF": "Jose", + "Tran_NamL": "Robledo", + "Tran_Zip4": "89122" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "Self Employed", + "Tran_Occ": "student", + "Entity_Cd": "Individual", + "Tran_Amt1": 600.0, + "Tran_Date": "2023-10-10", + "Tran_NamF": "Maassa", + "Tran_NamL": "Zamora", + "Tran_Zip4": "94601" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "Oakland Unified Public Schools", + "Tran_Occ": "Education District Leader", + "Entity_Cd": "Individual", + "Tran_Amt1": 200.0, + "Tran_Date": "2023-10-11", + "Tran_NamF": "Leroy", + "Tran_NamL": "Gaines", + "Tran_Zip4": "94518" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "La Clinica de la Raza", + "Tran_Occ": "Nurse Practitioner", + "Entity_Cd": "Individual", + "Tran_Amt1": 600.0, + "Tran_Date": "2023-10-16", + "Tran_NamF": "Maria", + "Tran_NamL": "Massella", + "Tran_Zip4": "94606" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "HP Investors LLC", + "Tran_Occ": "Finance", + "Entity_Cd": "Individual", + "Tran_Amt1": 600.0, + "Tran_Date": "2023-10-17", + "Tran_NamF": "Isaac", + "Tran_NamL": "Abid", + "Tran_Zip4": "94611" + }, + { + "Filer_ID": "1463520", + "Tran_Emp": "RCR Inc.", + "Tran_Occ": "Business Owner", + "Entity_Cd": "Individual", + "Tran_Amt1": 500.0, + "Tran_Date": "2023-10-20", + "Tran_NamF": "Blanca", + "Tran_NamL": "Perez", + "Tran_Zip4": "94542" + } ] } diff --git a/build/_data/elections/oakland/2022-11-08.json b/build/_data/elections/oakland/2022-11-08.json index b906816..f716008 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.869999998, + "Individual": 2507910.870000002, "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 94f3225..f22bc36 100644 --- a/build/_data/elections/oakland/2023-11-07.json +++ b/build/_data/elections/oakland/2023-11-07.json @@ -1,21 +1,21 @@ { - "total_contributions": 17530.0, + "total_contributions": 23415.0, "total_contributions_by_source": { - "Out of State": 100.0, - "Within Oakland": 8896.0, - "Within California": 6976.0 + "Out of State": 1300.0, + "Within Oakland": 12396.0, + "Within California": 7876.0 }, "contributions_by_type": { "Committee": 6000.0, - "Individual": 9972.0, - "Unitemized": 1558.0 + "Individual": 15572.0, + "Unitemized": 1843.0 }, "most_expensive_races": [ { "slug": "school-board-district-5", "type": "office", "title": "School Board District 5", - "amount": 17530.0 + "amount": 23415.0 } ], "largest_small_proportion": [ @@ -26,18 +26,26 @@ "candidate": "Alexandra Ritzie-Hernandez", "proportion": 0.0966343411294923, "office_title": "School Board District 5" + }, + { + "slug": "jorge-c-lerma", + "type": "office", + "title": "Oakland November 7th, 2023 Special Election", + "candidate": "Jorge C. Lerma", + "proportion": 0.048428207306711976, + "office_title": "School Board District 5" } ], "largest_independent_expenditures": [ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 18108.57 + "total_spending": 30192.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 7900.0 + "total_spending": 15800.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", diff --git a/build/_data/stats.json b/build/_data/stats.json index 65f3ec2..f0b04ca 100644 --- a/build/_data/stats.json +++ b/build/_data/stats.json @@ -1,3 +1,3 @@ { - "date_processed": "2023-10-27 00:07:27 -0700" + "date_processed": "2023-10-29 00:07:45 -0700" } diff --git a/build/_data/totals.json b/build/_data/totals.json index 06119e0..8055f08 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.869999998, + "Individual": 2507910.870000002, "Unitemized": 135828.3, "Self Funding": 2711.0, "Other (includes Businesses)": 2638453.6399999997 @@ -1312,23 +1312,23 @@ ] }, "oakland-2023": { - "total_contributions": 17530.0, + "total_contributions": 23415.0, "total_contributions_by_source": { - "Out of State": 100.0, - "Within Oakland": 8896.0, - "Within California": 6976.0 + "Out of State": 1300.0, + "Within Oakland": 12396.0, + "Within California": 7876.0 }, "contributions_by_type": { "Committee": 6000.0, - "Individual": 9972.0, - "Unitemized": 1558.0 + "Individual": 15572.0, + "Unitemized": 1843.0 }, "most_expensive_races": [ { "slug": "school-board-district-5", "type": "office", "title": "School Board District 5", - "amount": 17530.0 + "amount": 23415.0 } ], "largest_small_proportion": [ @@ -1339,18 +1339,26 @@ "candidate": "Alexandra Ritzie-Hernandez", "proportion": 0.0966343411294923, "office_title": "School Board District 5" + }, + { + "slug": "jorge-c-lerma", + "type": "office", + "title": "Oakland November 7th, 2023 Special Election", + "candidate": "Jorge C. Lerma", + "proportion": 0.048428207306711976, + "office_title": "School Board District 5" } ], "largest_independent_expenditures": [ { "name": "Oakland Education Association Political Action Committee", "election_name": "oakland-2023", - "total_spending": 18108.57 + "total_spending": 30192.57 }, { "name": "California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021", "election_name": "oakland-2023", - "total_spending": 7900.0 + "total_spending": 15800.0 }, { "name": "Oakland Rising Committee sponsored by Center for Empowered Politics", diff --git a/build/_office_elections/oakland/2023-11-07/school-board-district-5.md b/build/_office_elections/oakland/2023-11-07/school-board-district-5.md index ddf979f..932b9b9 100644 --- a/build/_office_elections/oakland/2023-11-07/school-board-district-5.md +++ b/build/_office_elections/oakland/2023-11-07/school-board-district-5.md @@ -2,8 +2,8 @@ election: _elections/oakland/2023-11-07.md candidates: - alexandra-ritzie-hernandez -- christian-miguel-martinez - jorge-c-lerma +- christian-miguel-martinez title: School Board District 5 label: Oakland Unified School District --- ```