monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

39 rows where employer = 4948 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, entity_type, last_name, first_name, city, zipcode, occupation, transaction_amt, year_to_date, 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
67540 67540 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-07-29 2020-01-01 2020-06-30   INC9468 IND VALADEZ MARIO   ALAMEDA CA 94501 OAKLAND PROMISE 4948 K2C SCHOOL LIAISON n   2020-06-12 8 8     INC9468
53330 53330 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC8532 OTH CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2019-07-01 8.67 95.37     INC8532
53414 53414 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC8406 OTH CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2019-08-01 8.67 95.37     INC8406
53491 53491 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC8608 OTH CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2019-09-01 8.67 95.37     INC8608
53559 53559 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC8746 OTH CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2019-10-01 8.67 95.37     INC8746
53631 53631 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2020-01-27 2019-07-01 2019-12-31   INC8979 OTH CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2019-11-01 8.67 95.37     INC8979
54611 54611 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-07-31 2019-01-01 2019-06-30   INC7265 IND CROUSHORE MAGGIE   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2019-01-01 8.67 52.02     INC7265
54717 54717 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-07-31 2019-01-01 2019-06-30   INC7374 IND CROUSHORE MAGGIE   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2019-02-01 8.67 52.02     INC7374
54818 54818 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-07-31 2019-01-01 2019-06-30   INC7468 IND CROUSHORE MAGGIE   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2019-03-01 8.67 52.02     INC7468
54914 54914 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-07-31 2019-01-01 2019-06-30   INC7567 IND CROUSHORE MAGGIE   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2019-04-01 8.67 52.02     INC7567
55007 55007 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-07-31 2019-01-01 2019-06-30   INC7653 IND CROUSHORE MAGGIE   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2019-05-01 8.67 52.02     INC7653
55093 55093 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-07-31 2019-01-01 2019-06-30   INC7737 IND CROUSHORE MAGGIE   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2019-06-01 8.67 52.02     INC7737
43897 43897 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-01-30 2018-10-21 2018-12-31   INC6773 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2018-11-01 8.67 104.04     INC6773
44020 44020 1331137 36 Families and Educators for Public Education, Sponsored by GO Public Schools Advocates 194 2019-01-30 2018-10-21 2018-12-31   INC7071 IND CROUSHORE MAGGIE   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2018-12-01 8.67 8.67     INC7071
42484 42484 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 INC6465 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2018-10-01 8.67 95.37     INC6465
45626 45626 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 INC6465 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2018-10-01 8.67 95.37     INC6465
47235 47235 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 INC5247 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2018-07-01 8.67 86.7     INC5247
47367 47367 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 INC6221 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2018-08-01 8.67 86.7     INC6221
47505 47505 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 INC6160 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 MANAGER - COMMUNICATIONS & PARTNERSHIP, EDUCATION n   2018-09-01 8.67 86.7     INC6160
49216 49216 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC3916 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2018-01-11 8.67 60.69     INC3916
49315 49315 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC3971 IND VALADEZ MARIO   AMERICAN CANYON CA 94503 OAKLAND PROMISE 4948 STUDENT n   2018-01-11 2.74 19.18     INC3971
49345 49345 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4043 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2018-02-09 8.67 60.69     INC4043
49446 49446 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4100 IND VALADEZ MARIO   AMERICAN CANYON CA 94503 OAKLAND PROMISE 4948 STUDENT n   2018-02-09 2.74 19.18     INC4100
49475 49475 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4248 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2018-03-12 8.67 60.69     INC4248
49580 49580 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4249 IND VALADEZ MARIO   AMERICAN CANYON CA 94503 OAKLAND PROMISE 4948 STUDENT n   2018-03-12 2.74 19.18     INC4249
49608 49608 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4320 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2018-04-06 8.67 60.69     INC4320
49714 49714 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4376 IND VALADEZ MARIO   AMERICAN CANYON CA 94503 OAKLAND PROMISE 4948 STUDENT n   2018-04-06 2.74 19.18     INC4376
49743 49743 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4458 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2018-05-25 8.67 60.69      
49846 49846 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4517 IND VALADEZ MARIO   AMERICAN CANYON CA 94503 OAKLAND PROMISE 4948 STUDENT n   2018-05-25 2.74 19.18      
49855 49855 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4786 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2018-06-01 8.67 60.69     INC4786
49921 49921 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4653 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2018-06-11 8.67 60.69     INC4653
50021 50021 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4654 IND VALADEZ MARIO   AMERICAN CANYON CA 94503 OAKLAND PROMISE 4948 STUDENT n   2018-06-11 2.74 19.18     INC4654
50036 50036 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-07-31 2018-01-01 2018-06-30   INC4787 IND VALADEZ MARIO   AMERICAN CANYON CA 94503 OAKLAND PROMISE 4948 STUDENT n   2018-06-15 2.74 19.18     INC4787
36180 36180 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3241 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2017-07-31 8.67 34.68     INC3241
36312 36312 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3425 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2017-10-12 8.67 34.68     INC3425
36429 36429 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3647 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2017-11-06 8.67 34.68     INC3647
36544 36544 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2018-01-31 2017-07-01 2017-12-31   INC3841 IND CROUSHORE MARGARET   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2017-12-15 8.67 34.68     INC3841
29562 29562 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2017-12-21 2016-07-01 2016-09-24 2016-11-08 INC2787 IND CROUSHORE MAGGIE   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2016-08-11 10 50      
29563 29563 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 2017-12-21 2016-07-01 2016-09-24 2016-11-08 INC2795 IND CROUSHORE MAGGIE   ALAMEDA CA 94502 OAKLAND PROMISE 4948 EDUCATION POLICY n   2016-08-11 40 50      

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