monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

39 rows where employer = 4763 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, transaction_id, last_name, first_name, city, zipcode, occupation, transaction_date, 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
30413 30413 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-28 2016-09-25 2016-10-22 2016-11-08 8SdUrG1ZVwTT IND Purcell William   Oakland CA 94506 Self-employed. 4763 Real Estate Broker. n   2016-09-29 125 125      
30416 30416 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-28 2016-09-25 2016-10-22 2016-11-08 KJKfWUGVBLL3 IND Reinhold Sue   Berkeley CA 94708 Self-employed. 4763 Business Consultant. n   2016-09-29 250 568      
30908 30908 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-28 2016-10-23 2016-12-31   ZEwhNvnGIJg2 IND Speiglman Richard   Oakland CA 94609-2618 Self-employed. 4763 Social Research. n   2016-10-24 40 180      
29722 29722 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-27 2016-07-01 2016-09-24 2016-11-08 la56dXlwsDDf IND Speiglman Richard   Oakland CA 94609-2618 Self-employed. 4763 Social Research. n   2016-08-15 40 140      
28701 28701 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   mHbrleljFUUJ IND Kalb Scott   Sherman Oaks CA 91423-4528 Self-employed. 4763 Banker n   2016-02-24 100 100      
28702 28702 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   YglrPeuwblNL IND Matthews Richard   Northridge CA 91326 Self-employed. 4763 Computer System Architect n   2016-02-24 200 200      
28707 28707 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   49oUPN4fF8Dd IND Sidley Michael   Los Angeles CA 90064 Self-employed. 4763 Attorney n   2016-03-03 500 500      
28717 28717 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   OylQT1Pe6HEu IND Schragge Harmon   San Francisco CA 94108 Self-employed. 4763 Real Estate n   2016-04-28 100 100      
28723 28723 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   OgPfX8YsOuAL IND Walker Debra   San Francisco CA 94110-1354 Self-employed. 4763 Artist. n   2016-05-01 100 100      
28731 28731 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   V1ItQOZtRecs IND Burdman Pamela   Berkeley CA 94707 Self-employed. 4763 Policy Analyst. n   2016-05-19 150 150      
28732 28732 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   vZw1NE5CKUfp IND Reinhold Sue   Berkeley CA 94708 Self-employed. 4763 Business Consultant. n   2016-05-19 318 318      
28735 28735 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   nzA6vYFK5VWy IND Krevsky George   San Francisco CA 94618 Self-employed. 4763 Art Gallery Owner n   2016-05-22 136 136      
28740 28740 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   kY5Pwkv3f7E1 IND Speiglman Richard   Oakland CA 94609-2618 Self-employed. 4763 Social Research. n   2016-05-22 100 100      
28742 28742 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   KIQ7BPlfxtJd IND Friedman Matthew   Albany CA 94707 Self-employed. 4763 Architect/Developer. n   2016-05-26 100 100      
28757 28757 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   Zdn4eE6JkBMv IND Bass Michael   Oakland CA 94602 Self-employed. 4763 Illustrator/Designer. n   2016-06-18 100 100      
28758 28758 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   QRkKFiNRGdCT IND Benson Kenneth   Oakland CA 94605 Self-employed. 4763 Consultant. n   2016-06-18 150 150      
28766 28766 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2018-07-26 2016-01-01 2016-06-30   j7AwK95GNmuk IND Levine Shira   Oakland CA 94610 Self-employed. 4763 Consultant n   2016-06-19 150 150      
30969 30969 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2017-07-31 2016-10-23 2016-12-31   ZEwhNvnGIJg2 IND Speiglman Richard   Oakland CA 94609-2618 Self-employed. 4763 Social Research. n   2016-10-24 40 180      
29810 29810 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-10-23 2016-07-01 2016-09-24 2016-11-08 la56dXlwsDDf IND Speiglman Richard   Oakland CA 94609-2618 Self-employed. 4763 Social Research. n   2016-08-15 40 140      
29889 29889 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-10-23 2016-07-01 2016-09-24 2016-11-08 8SdUrG1ZVwTT IND Purcell William   Oakland CA 94506 Self-employed. 4763 Real Estate Broker. n   2016-09-24 125 375      
29890 29890 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-10-23 2016-07-01 2016-09-24 2016-11-08 KJKfWUGVBLL3 IND Reinhold Sue   Berkeley CA 94708 Self-employed. 4763 Business Consultant. n   2016-09-24 250 568      
33014 33014 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-09-29 2016-07-01 2016-09-24 2016-11-08 la56dXlwsDDf IND Speiglman Richard   Oakland CA 94609-2618 Self-employed. 4763 Social Research. n   2016-08-15 40 140      
33093 33093 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-09-29 2016-07-01 2016-09-24 2016-11-08 8SdUrG1ZVwTT IND Purcell William   Oakland CA 94506 Self-employed. 4763 Real Estate Broker. n   2016-09-24 125 375      
33094 33094 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-09-29 2016-07-01 2016-09-24 2016-11-08 KJKfWUGVBLL3 IND Reinhold Sue   Berkeley CA 94708 Self-employed. 4763 Business Consultant. n   2016-09-24 250 568      
34402 34402 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   mHbrleljFUUJ IND Kalb Scott   Sherman Oaks CA 91423-4528 Self-employed. 4763 Banker n   2016-02-24 100 100      
34403 34403 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   YglrPeuwblNL IND Matthews Richard   Northridge CA 91326 Self-employed. 4763 Computer System Architect n   2016-02-24 200 200      
34409 34409 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   49oUPN4fF8Dd IND Sidley Michael   Los Angeles CA 90064 Self-employed. 4763 Attorney n   2016-03-03 500 500      
34419 34419 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   OylQT1Pe6HEu IND Schragge Harmon   San Francisco CA 94108 Self-employed. 4763 Real Estate n   2016-04-28 100 100      
34425 34425 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   OgPfX8YsOuAL IND Walker Debra   San Francisco CA 94110-1354 Self-employed. 4763 Artist. n   2016-05-01 100 100      
34433 34433 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   V1ItQOZtRecs IND Burdman Pamela   Berkeley CA 94707 Self-employed. 4763 Policy Analyst. n   2016-05-19 150 150      
34434 34434 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   vZw1NE5CKUfp IND Reinhold Sue   Berkeley CA 94708 Self-employed. 4763 Business Consultant. n   2016-05-19 318 318      
34437 34437 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   nzA6vYFK5VWy IND Krevsky George   San Francisco CA 94618 Self-employed. 4763 Art Gallery Owner n   2016-05-22 136 136      
34442 34442 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   kY5Pwkv3f7E1 IND Speiglman Richard   Oakland CA 94609-2618 Self-employed. 4763 Social Research. n   2016-05-22 100 100      
34444 34444 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   KIQ7BPlfxtJd IND Friedman Matthew   Albany CA 94707 Self-employed. 4763 Architect/Developer. n   2016-05-26 100 100      
34460 34460 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   Zdn4eE6JkBMv IND Bass Michael   Oakland CA 94602 Self-employed. 4763 Illustrator/Designer. n   2016-06-18 100 100      
34461 34461 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   QRkKFiNRGdCT IND Benson Kenneth   Oakland CA 94605 Self-employed. 4763 Consultant. n   2016-06-18 150 150      
34469 34469 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   j7AwK95GNmuk IND Levine Shira   Oakland CA 94610 Self-employed. 4763 Consultant n   2016-06-19 150 150      
34481 34481 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   5qjp3zBtMMVj IND Purcell William   Oakland CA 94506 Self-employed. 4763 Real Estate Broker. n   2016-06-23 250 250      
34482 34482 1382408 124 Re-Elect Dan Kalb Oakland City Council 2016 142 2016-08-02 2016-01-01 2016-06-30   6pHuFGMBYmY1 IND Raich Robert   Oakland CA 94619 Self-employed. 4763 Attorney. n   2016-06-23 700 700      

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