monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

32 rows where employer = 2927 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, report_date, report_start_date, report_end_date, election_date, transaction_id, last_name, first_name, city, zipcode, occupation, transaction_date, transaction_amt, year_to_date, memo_reference_number, report_date (date), report_start_date (date), report_end_date (date), election_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
43867 43867 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-01-30 2018-10-21 2018-12-31   INC6870 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2018-10-27 41.68 183.88     INC6870
42456 42456 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-11-05 2018-09-23 2018-10-20 2018-11-06 INC6665 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2018-09-27 41.68 142.2     INC6665
45598 45598 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-10-25 2018-09-23 2018-10-20 2018-11-06 INC6665 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2018-09-27 41.68 142.2     INC6665
47337 47337 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-27 2018-07-01 2018-09-22 2018-11-06 INC5340 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2018-07-27 41.68 100.52     INC5340
47475 47475 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2018-09-27 2018-07-01 2018-09-22 2018-11-06 INC6315 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2018-08-27 41.68 100.52     INC6315
49319 49319 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC3963 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2018-01-11 8.58 17.16     INC3963
49450 49450 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4090 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2018-02-09 8.58 17.16     INC4090
36286 36286 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3339 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2017-09-09 8.58 34.32     INC3339
36407 36407 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3470 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2017-10-12 8.58 34.32     INC3470
36517 36517 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3694 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2017-11-06 8.58 34.32     INC3694
36649 36649 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3837 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2017-12-15 8.58 34.32     INC3837
33296 33296 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC2759 IND TOWNS RONALD   OAKLAND CA 94606 LEADERSHIP PUBLIC SCHOOLS 2927 ACADEMIC DEAN/MATH TEACHER n   2016-07-27 40 40      
22942 22942 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2016-02-01 2015-07-01 2015-12-31   INC1824 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-07-08 100 1200      
22956 22956 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2016-02-01 2015-07-01 2015-12-31   INC1841 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-08-08 100 1200      
23005 23005 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2016-02-01 2015-07-01 2015-12-31   INC1890 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-09-08 100 1200      
23048 23048 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2016-02-01 2015-07-01 2015-12-31   INC1937 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-10-08 100 1200      
23084 23084 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2016-02-01 2015-07-01 2015-12-31   INC1980 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-11-08 100 1200      
23121 23121 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2016-02-01 2015-07-01 2015-12-31   INC2025 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-12-08 100 1200      
27625 27625 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-07-28 2015-01-01 2015-06-30   INC1705 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-01-08 100 600      
27644 27644 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-07-28 2015-01-01 2015-06-30   INC1730 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-02-08 100 600      
27660 27660 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-07-28 2015-01-01 2015-06-30   INC1747 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-03-08 100 600      
27677 27677 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-07-28 2015-01-01 2015-06-30   INC1767 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-04-08 100 600      
27693 27693 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-07-28 2015-01-01 2015-06-30   INC1794 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-05-09 100 600      
27708 27708 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-07-28 2015-01-01 2015-06-30   INC1801 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2015-06-08 100 600      
11106 11106 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-03-23 2014-10-19 2014-12-31   INC1646 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2014-11-08 100 375      
11126 11126 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-03-23 2014-10-19 2014-12-31   INC1681 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2014-12-08 100 375      
9089 9089 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-02-02 2014-07-01 2014-09-30 2014-11-04 INC1542 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2014-09-23 75 75     INC1542
10616 10616 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-02-02 2014-10-01 2014-10-18 2014-11-04 INC1562 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2014-10-08 100 175      
13039 13039 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-01-27 2014-10-19 2014-12-31   INC1646 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2014-11-08 100 375      
13059 13059 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2015-01-27 2014-10-19 2014-12-31   INC1681 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2014-12-08 100 375      
14634 14634 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2014-10-23 2014-10-01 2014-10-18 2014-11-04 INC1562 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 EDUCATOR n   2014-10-08 100 175      
16407 16407 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GREAT OAKLAND PUBLIC SCHOOLS 30 2014-10-06 2014-07-01 2014-09-30 2014-11-04 INC1542 IND WATERS LOUISE   UNION CITY CA 94587 LEADERSHIP PUBLIC SCHOOLS 2927 SUPT & CEO n   2014-09-23 75 75     INC1542

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");