non_monetary_contributions

FPPC Form 460, Schedule C

Data source: C_Contributions

71 rows where filer_id = 270 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, entity_type, last_name, city, state, transaction_date, year_to_date, transaction_description, committee_id, 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
867 867 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-07-01 2022-09-24 2022-11-08 NON34 OTH Proteus Action League     Amherst CA 01002     n   2022-07-21 1650 3900 Communications support    
868 868 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-07-01 2022-09-24 2022-11-08 NON5 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-09-06 2500 6445.65 Voter Data and Phone Dialer platform (estimate) 933.0  
869 869 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-07-01 2022-09-24 2022-11-08 NON35 OTH Proteus Action League     Amherst CA 01002     n   2022-09-15 2250 3900 Communications support    
870 870 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-07-01 2022-09-24 2022-11-08 NON17 OTH California Common Cause     Alhambra CA 91801     n   2022-09-22 4812.5 4812.5 Staff time    
871 871 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-07-01 2022-09-24 2022-11-08 NON19 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-09-23 3945.65 6445.65 canvass staff time 933.0  
893 893 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON37 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-09-27 746.66 105200.87 List, captioning & interpreting services 935.0  
894 894 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON61 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-09-30 327.75 105200.87 Lists 935.0  
895 895 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON59 OTH California Common Cause     Alhambra CA 91801     n   2022-09-30 490 5302.5 Staff time    
896 896 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON72 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-03 1805.7 105200.87 Texting 935.0  
897 897 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON78 COM Bay Rising Ballot Committee Sponsored by Center for Empowered Politics     Oakland CA 94612     n   2022-10-07 560 568 Photography services 936.0  
898 898 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON77 COM Bay Rising Ballot Committee Sponsored by Center for Empowered Politics     Oakland CA 94612     n   2022-10-07 8 568 Email blast 936.0  
899 899 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON69 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-10-07 6185.05 17661.8 Canvass staff time 933.0  
900 900 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON74 OTH ReThink Media     Berkeley CA 94704     n   2022-10-13 7304 7304 Polling    
901 901 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON95 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-14 764.55 105200.87 Staff time 935.0  
902 902 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON76 OTH Proteus Action League     Amherst CA 01002     n   2022-10-14 1500 45400 Staff time    
903 903 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON80 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-17 192.84 105200.87 Emails 935.0  
904 904 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON81 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-17 897.84 105200.87 Texting 935.0  
905 905 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON82 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-17 438.27 105200.87 Lists 935.0  
906 906 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON89 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-18 6.78 105200.87 Texting 935.0  
907 907 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON96 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-20 4.23 105200.87 Texting 935.0  
908 908 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON99 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-10-21 5031.1 17661.8 Canvass staff time 933.0  
909 909 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON97 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-22 16.25 105200.87 Mileage 935.0  
910 910 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-09-25 2022-10-22 2022-11-08 NON137 OTH Stand Up America     New York NY 10003     n   2022-10-22 540.41 25540.41 Communications    
911 911 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON127 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-24 44.49 107653.88 Texting 935.0  
912 912 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON126 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-10-25 1940.99 31602.79 Voter guide design & distribution 933.0  
913 913 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON128 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-28 950.37 107653.88 Staff Time 935.0  
914 914 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON129 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-10-28 10000 31602.79 Canvass staff time - estimate through election day 933.0  
915 915 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON130 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-10-28 2000 31602.79 Text message platform costs - estimate through election day 933.0  
916 916 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON131 OTH Represent.Us     Florence MA 01062     n   2022-10-31 213.18 281.09 Staff time    
917 917 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON132 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-11-02 299.62 107653.88 Lists 935.0  
918 918 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON133 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-11-02 751.38 107653.88 Texing 935.0  
919 919 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON135 OTH Stand Up America     New York NY 10003     n   2022-11-04 201.88 25909.21 Staff time    
920 920 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON138 OTH Stand Up America     New York NY 10003     n   2022-11-07 19.62 25909.21 Communications    
921 921 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON134 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-11-11 407.15 107653.88 Staff time 935.0  
922 922 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON136 OTH Stand Up America     New York NY 10003     n   2022-11-18 147.3 25909.21 Staff time    
923 923 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-08-08 2022-10-23 2022-12-31   NON139 OTH Represent.Us     Florence MA 01062     n   2022-11-30 34.06 281.09 Staff time    
961 961 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON127 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-24 44.49 107653.88 Texting 935.0  
962 962 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON128 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-28 950.37 107653.88 Staff Time 935.0  
963 963 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON132 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-11-02 299.62 107653.88 Lists 935.0  
964 964 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON133 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-11-02 751.38 107653.88 Texing 935.0  
965 965 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON134 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-11-11 407.15 107653.88 Staff time 935.0  
966 966 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON126 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-10-25 1940.99 31602.79 Voter guide design & distribution 933.0  
967 967 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON129 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-10-28 10000 31602.79 Canvass staff time - estimate through election day 933.0  
968 968 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON130 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-10-28 2000 31602.79 Text message platform costs - estimate through election day 933.0  
969 969 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON131 OTH Represent.Us     Florence MA 01062     n   2022-10-31 213.18 281.09 Staff time    
970 970 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON139 OTH Represent.Us     Florence MA 01062     n   2022-11-30 34.06 281.09 Staff time    
971 971 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON135 OTH Stand Up America     New York NY 10003     n   2022-11-04 201.88 25909.21 Staff time    
972 972 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON138 OTH Stand Up America     New York NY 10003     n   2022-11-07 19.62 25909.21 Communications    
973 973 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2023-01-27 2022-10-23 2022-12-31   NON136 OTH Stand Up America     New York NY 10003     n   2022-11-18 147.3 25909.21 Staff time    
975 975 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON37 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-09-27 746.66 105501.29 List, captioning & interpreting services 935.0  
976 976 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON61 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-09-30 327.75 105501.29 Lists 935.0  
977 977 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON59 OTH California Common Cause     Alhambra CA 91801     n   2022-09-30 490 5302.5 Staff time    
978 978 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON72 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-03 1805.7 105501.29 Texting 935.0  
979 979 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON78 COM Bay Rising Ballot Committee Sponsored by Center for Empowered Politics     Oakland CA 94612     n   2022-10-07 560 568 Photography services 936.0  
980 980 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON77 COM Bay Rising Ballot Committee Sponsored by Center for Empowered Politics     Oakland CA 94612     n   2022-10-07 8 568 Email blast 936.0  
981 981 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON69 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-10-07 6185.05 17661.8 Canvass staff time 933.0  
982 982 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON74 OTH ReThink Media     Berkeley CA 94704     n   2022-10-13 7304 7304 Polling    
983 983 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON95 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-14 764.55 105501.29 Staff time 935.0  
984 984 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON76 OTH Proteus Action League     Amherst CA 01002     n   2022-10-14 1500 45400 Staff time    
985 985 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON80 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-17 192.84 105501.29 Emails 935.0  
986 986 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON81 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-17 1198.26 105501.29 Texting 935.0  
987 987 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON82 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-17 438.27 105501.29 Lists 935.0  
988 988 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON89 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-18 6.78 105501.29 Texting 935.0  
989 989 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON96 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-20 4.23 105501.29 Texting 935.0  
990 990 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON99 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-10-21 5031.1 17661.8 Canvass staff time 933.0  
991 991 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-10-27 2022-09-25 2022-10-22 2022-11-08 NON97 COM ACLU of Northern California Issues Committee     San Francisco CA 94111     n   2022-10-22 16.25 105501.29 Mileage 935.0  
1005 1005 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-09-29 2022-07-01 2022-09-24 2022-11-08 NON17 OTH California Common Cause     Alhambra CA 91801     n   2022-09-22 4812.5 4812.5 Staff time    
1006 1006 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-09-29 2022-07-01 2022-09-24 2022-11-08 NON5 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-09-06 2500 6445.65 Voter Data and Phone Dialer platform (estimate) 38.0  
1007 1007 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-09-29 2022-07-01 2022-09-24 2022-11-08 NON19 COM Oakland Rising Ballot Committee Supporting Measures T & W Sponsored by CEP     Oakland CA 94612     n   2022-09-23 3945.65 6445.65 canvass staff time 38.0  
1008 1008 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-09-29 2022-07-01 2022-09-24 2022-11-08 NON34 OTH Proteus Action League     Amherst CA 01002     n   2022-07-21 1650 3900 Communications support    
1009 1009 1448942 270 Yes on W, Oakland Fair Elections, Sponsored by Civic Advocacy Organizations Committee Address 351 2022-09-29 2022-07-01 2022-09-24 2022-11-08 NON35 OTH Proteus Action League     Amherst CA 01002     n   2022-09-15 2250 3900 Communications support    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "non_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" TEXT,
  "city" TEXT,
  "state" TEXT,
  "zipcode" TEXT,
  "employer" INTEGER,
  "occupation" TEXT,
  "self_employed" TEXT,
  "transaction_type" TEXT,
  "transaction_date" TEXT,
  "transaction_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "transaction_description" TEXT,
  "committee_id" TEXT,
  "memo_reference_number" TEXT
,
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 ["non_monetary_contributions_filer_id"] ON [non_monetary_contributions]("filer_id");
CREATE INDEX ["non_monetary_contributions_filer_name"] ON [non_monetary_contributions]("filer_name");
CREATE INDEX ["non_monetary_contributions_committee_id"] ON [non_monetary_contributions]("committee_id");
CREATE INDEX ["non_monetary_contributions_employer"] ON [non_monetary_contributions]("employer");