monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

34 rows where filer_id = 47 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: last_name, first_name, city, state, zipcode, employer, occupation, transaction_date, transaction_amt, year_to_date, report_date (date), report_start_date (date), report_end_date (date), transaction_date (date)

Link rowid filer_id filer_name report_date ▲ report_start_date report_end_date election_date transaction_id entity_type last_name first_name prefix city state zipcode employer occupation self_employed transaction_type transaction_date transaction_amt year_to_date transaction_description committee_id memo_reference_number
2659 2659 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3XQP9 IND Johnson Michael   Oakland CA 94619-3714 Abbott Diabetes Care 765 Healthcare Adminstration n   2013-07-25 690 905      
2660 2660 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4AM6Y17 IND Miller Jerome         Chevron Refinery 766 Refinery Worker n   2013-08-01 100 100      
2661 2661 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4AMXWX3 IND Isaacs Theresa Ms. Castro Valley CA 94552-5551 Abbott 767 HR Director n   2013-08-13 100 100      
2662 2662 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4AMXRR4 IND Johnson Michael   Oakland CA 94619-3714 Abbott Diabetes Care 765 Healthcare Adminstration n   2013-08-13 10 905      
2663 2663 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4AMZ0N7 IND BANKS DRENNON TIMOTHY   Dallas TX 75218-3471 SARETTA & TAELOR TRUCKING 768 TRUCK DRIVER n   2013-08-14 150 150      
2664 2664 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4AN3BV0 IND Collier Atarius   Spring Hill TN 37174-6224 Abbott Labs 769 Sales n   2013-08-14 100 100      
2665 2665 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4AMYHN4 IND Pervez Mohammad   Concord CA 94521-4335 U Market U 770 Owner n   2013-08-14 100 100      
2666 2666 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4AN7Z50 IND Manderson Sheila   Hidden Valley Lake CA 95467-8315 retired 411 Hospital Administrator n   2013-08-16 100 100      
2667 2667 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4ANZVF9 IND Hogg Sheelah   Hercules CA 94547-1645 Johnson & Johnson 771 Account Manager n   2013-08-17 100 100      
2668 2668 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4AP0255 IND Nalls David   Vallejo CA 94590-3123 Self 228 Retired n   2013-08-17 100 100      
2669 2669 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4AP2Y94 IND Johnson Otha   Oakland CA 94605 Wells Fargo 294 Product Manager n   2013-08-18 200 200      
2670 2670 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4AP30R6 IND Walker Troy   Hayward CA 94544-7616 Fritolay inc. 772 Sales rep n   2013-08-19 100 100      
2671 2671 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3XYK1 IND Eichelberger Alice         Novant Healthcare 773 Respiratory Therapist n   2013-08-21 100 100      
2672 2672 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3XXB5 IND Woodkins Peggy   Cincinnati OH   The Childrens Home of Northern Kentucky 774 Residential Treatment Counselor n   2013-08-21 100 100      
2673 2673 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T384 IND Boyd Alfreda         San Mateo County Probation Department 775 Probation Officer n   2013-08-26 100 100      
2674 2674 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T376 IND Guinn Anna         Oakland Unifed School District 776 Retired n   2013-08-26 100 100      
2675 2675 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3XWM3 IND Guinn Calvin   Oakland CA   C. Guinn Design and Construction 777 General Contractor n   2013-08-26 250 325      
2676 2676 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4AQ0N65 IND Johnson Carolyn   Alameda CA 94501-5068 Self Employed 90 Consultant and Trainer n   2013-08-27 100 100      
2677 2677 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3C5 IND Evans Sybil         Amtrak 778 Media Relations n   2013-08-28 100 100      
2678 2678 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T391 IND Hames Charley         Beebe Memorial Cathedral 779 Pastor n   2013-08-28 100 100      
2679 2679 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3B7 IND Martin Odis   Chicago IL   Abbott Laboratories 780 Manager n   2013-08-28 100 100      
2680 2680 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3G7 IND Baka Karen   Oakland CA   Abbott Laboratories 780 Project Manager n   2013-08-29 200 200      
2681 2681 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3W2 IND Felix Nicole   San Francisco CA 94105-0911 Ernst & Young LLP 781 Chief Connecting Officer n   2013-08-29 100 100      
2682 2682 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3S8 IND Hansen Chris Mrs. Oakland CA 94611-2801 Coldwell Banker 248 Realtor n   2013-08-29 100 100      
2683 2683 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3R0 IND Johnson Marian   Alameda CA 94501-4325 Hogan Lovells US LLP 782 Legal Secretary n   2013-08-29 100 100      
2684 2684 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3F9 IND Luqman Abdul El-Amin         Xfinity/Comcast 783 Sales Manager n   2013-08-29 100 100      
2685 2685 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3RFT6 IND Roby Sheila   Oakland CA   Independent Insurance Agent 784 Insurance Agent n   2013-08-29 100 150      
2686 2686 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3V4 IND Stanchina Sonja   Danville CA 94526-3519 East Bay Regional Park District 785 Human Resource Officer II n   2013-08-29 100 100      
2687 2687 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3T6 IND Stoneham Vickie         Oakland Unifed School District 776 Assistant Principal n   2013-08-29 100 100      
2688 2688 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3E1 IND Wilson Stephanie         Abbott Laboratories 780 Project Manager n   2013-08-29 100 100      
2689 2689 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3Y6Q9 IND Guinn Calvin   Oakland CA   C. Guinn Design and Construction 777 General Contractor n   2013-09-23 75 325      
2690 2690 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3Y6V0 IND Roby Sheila   Oakland CA   Independent Insurance Agent 784 Insurance Agent n   2013-09-23 50 150      
2691 2691 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4BFZAG6 IND Battiste Antoinette   San Jose CA 95135-1009 Educational Pathways with Antoinette Battiste 786 Independent Educational Consultant n   2013-11-18 100 100      
2692 2692 COAK-1536 47 Committee to Elect Michael V. Johnson City Council 2014 40 2014-01-31 2013-07-01 2013-12-31   VN8V4C3T3Y7 IND Clark Danny   Pittsburg CA 94565-3790 USPS 787 Retired n   2013-12-23 100 100      

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "monetary_contributions" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "last_name" TEXT,
  "first_name" TEXT,
  "prefix" INTEGER,
  "city" TEXT,
  "state" TEXT,
  "zipcode" TEXT,
  "employer" INTEGER,
  "occupation" TEXT,
  "self_employed" TEXT,
  "transaction_type" INTEGER,
  "transaction_date" TEXT,
  "transaction_amt" INTEGER,
  "year_to_date" INTEGER,
  "transaction_description" INTEGER,
  "committee_id" TEXT,
  "memo_reference_number" INTEGER
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
    FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id),
    FOREIGN KEY ("employer") REFERENCES [businesses](id));
CREATE INDEX ["monetary_contributions_filer_id"] ON [monetary_contributions]("filer_id");
CREATE INDEX ["monetary_contributions_filer_name"] ON [monetary_contributions]("filer_name");
CREATE INDEX ["monetary_contributions_committee_id"] ON [monetary_contributions]("committee_id");
CREATE INDEX ["monetary_contributions_employer"] ON [monetary_contributions]("employer");