monetary_contributions
Data source: A_Contributions
12 rows where employer = 14236 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, transaction_id, transaction_date, transaction_amt, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 94926 | 94926 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2025-02-21 | 2024-04-01 | 2024-06-30 | INC378 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | 2024-05-01 | 524.08 | 99 | ||||||
| 94927 | 94927 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2025-02-21 | 2024-04-01 | 2024-06-30 | EXP507 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | R | 2024-05-22 | -524.08 | 99 | |||||
| 95021 | 95021 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2024-12-16 | 2024-04-01 | 2024-06-30 | INC378 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | 2024-05-01 | 524.08 | 99 | ||||||
| 95022 | 95022 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2024-12-16 | 2024-04-01 | 2024-06-30 | EXP507 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | R | 2024-05-22 | -524.08 | 99 | |||||
| 95056 | 95056 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2024-08-21 | 2024-04-01 | 2024-06-30 | INC378 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | 2024-05-01 | 524.08 | 99 | ||||||
| 95086 | 95086 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2024-08-21 | 2024-04-01 | 2024-06-30 | EXP507 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | R | 2024-05-22 | -524.08 | 99 | |||||
| 95211 | 95211 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2024-08-08 | 2024-04-01 | 2024-06-30 | INC378 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | 2024-05-01 | 524.08 | 99 | ||||||
| 95212 | 95212 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2024-08-08 | 2024-04-01 | 2024-06-30 | EXP507 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | R | 2024-05-22 | -524.08 | 99 | |||||
| 95309 | 95309 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2024-08-07 | 2024-04-01 | 2024-06-30 | INC378 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | 2024-05-01 | 524.08 | 99 | ||||||
| 95310 | 95310 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2024-08-07 | 2024-04-01 | 2024-06-30 | EXP507 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | R | 2024-05-22 | -524.08 | 99 | |||||
| 105200 | 105200 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2024-07-30 | 2024-04-01 | 2024-06-30 | INC378 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | 2024-05-01 | 524.08 | 99 | ||||||
| 105201 | 105201 | 1466653 328 | Oakland United To Recall Sheng Thao 447 | 2024-07-30 | 2024-04-01 | 2024-06-30 | EXP507 | IND | Tuck | Elizabeth | Piedmont | CA | 94611 | Your Warm Friend, Inc. 14236 | Marketing Manager | n | R | 2024-05-22 | -524.08 | 99 |
Advanced export
JSON shape: default, array, newline-delimited
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");