-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathfecfields.py
965 lines (965 loc) · 20.1 KB
/
fecfields.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
fields ="""
11_a_iii_individuals_total
11_a_ii_individuals_unitemized
11_a_i_individuals_itemized
11_b_political_party_committees
11_c_all_other_political_committees_pacs
11_d_the_candidate
11_e_total_contributions
12_transfers_from_other_auth_committees
13_a_loans_made_or_guarn_by_the_candidate
13_b_all_other_loans
13_c_total_loans
14_net_contributions
14_offsets_to_operating_expenditures
15_net_expenditures
15_other_receipts
16_federal_funds
16_total_receipts
17_a_iii_individual_contribution_total
17_a_ii_individuals_unitemized
17_a_i_individuals_itemized
17_a_individuals
17_b_political_party_committees
17_c_other_political_committees_pacs
17_d_the_candidate
17_e_total_contributions_other_than_loans
17_operating_expenditures
18_transfers_from_aff_other_party_committees
18_transfers_to_other_auth_committees
19_a_loan_repayment_by_candidate
19_a_received_from_or_guaranteed_by_candidate
19_b_loan_repayments_all_other_loans
19_b_other_loans
19_c_total_loan_repayments
19_c_total_loans
20_a_operating
20_a_refund_individuals_other_than_pol_cmtes
20_b_fundraising
20_b_refund_political_party_committees
20_c_legal_and_accounting
20_c_refund_other_political_committees
20_d_total_contributions_refunds
20_d_total_offsets_to_operating_expenditures
21_other_disbursements
21_other_receipts
22_total_disbursements
22_total_receipts
23_operating_expenditures
24_transfers_to_other_authorized_committees
25_fundraising_disbursements
26_exempt_legal_and_accounting_disbursements
27_a_made_or_guaranteed_by_the_candidate
27_b_other_repayments
27_c_total_loan_repayments_made
28_a_individuals
28_b_political_party_committees
28_c_other_political_committees
28_d_total_contributions_refunds
29_other_disbursements
30_total_disbursements
6a_total_contributions_no_loans
6b_total_contribution_refunds
6c_net_contributions
7a_total_operating_expenditures
7b_total_offsets_to_operating_expenditures
7c_net_operating_expenditures
account_location_name
activity_general
activity_primary
affiliated_candidate_id_number
affiliated_city
affiliated_committee_id_number
affiliated_committee_name
affiliated_date_f1_filed
affiliated_first_name
affiliated_last_name
affiliated_middle_name
affiliated_prefix
affiliated_relationship_code
affiliated_state
affiliated_street_1
affiliated_street_2
affiliated_suffix
affiliated_zip_code
agent_city
agent_first_name
agent_last_name
agent_middle_name
agent_name
agent_prefix
agent_state
agent_street_1
agent_street_2
agent_suffix
agent_telephone
agent_title
agent_zip_code
aggregate_general_elec_expended
alabama
alaska
amended_cd
amended_code
amendment_date
arizona
arkansas
authorized_committee_city
authorized_committee_id_number
authorized_committee_name
authorized_committee_state
authorized_committee_street_1
authorized_committee_street_2
authorized_committee_zip_code
authorized_first_name
authorized_last_name
authorized_middle_name
authorized_name
authorized_prefix
authorized_suffix
authorized_title
back_reference_sched_name
back_reference_tran_id_number
balance_at_close_this_period
bank2_city
bank2_name
bank2_state
bank2_street_1
bank2_street_2
bank2_zip_code
bank_city
bank_name
bank_state
bank_street_1
bank_street_2
bank_zip_code
beginning_balance_this_period
beneficiary_candidate_district
beneficiary_candidate_fec_id
beneficiary_candidate_first_name
beneficiary_candidate_last_name
beneficiary_candidate_middle_name
beneficiary_candidate_name
beneficiary_candidate_office
beneficiary_candidate_prefix
beneficiary_candidate_state
beneficiary_candidate_suffix
beneficiary_committee_fec_id
beneficiary_committee_name
calendar_y_t_d_per_election_office
california
candidate_city
candidate_district
candidate_first_name
candidate_id
candidate_id_number
candidate_last_name
candidate_middle_name
candidate_name
candidate_office
candidate_party_code
candidate_prefix
candidate_signature_first_name
candidate_signature_last_name
candidate_signature_middle_name
candidate_signature_name
candidate_signature_prefix
candidate_signature_suffix
candidate_state
candidate_street_1
candidate_street_2
candidate_suffix
candidate_zip_code
canonical
category_code
change_of_address
change_of_committee_email
change_of_committee_name
change_of_committee_url
city
col_a_alabama
col_a_alaska
col_a_arizona
col_a_arkansas
col_a_california
col_a_cash_on_hand_beginning_period
col_a_cash_on_hand_beginning_reporting_period
col_a_cash_on_hand_close_of_period
col_a_colorado
col_a_connecticut
col_a_contributions_itemized
col_a_contributions_subtotal
col_a_contributions_to_candidates
col_a_contributions_unitemized
col_a_convention_expenditures
col_a_convention_expenses_itemized
col_a_convention_expenses_subtotal
col_a_convention_expenses_unitemized
col_a_convention_refunds
col_a_convention_refunds_itemized
col_a_convention_refunds_subtotal
col_a_convention_refunds_unitemized
col_a_coordinated_expenditures_by_party_committees
col_a_debts_by
col_a_debts_to
col_a_delaware
col_a_dist_of_columbia
col_a_exempt_legal_accounting_disbursement
col_a_expenditures_subject_to_limits
col_a_federal_election_activity_all_federal
col_a_federal_election_activity_federal_share
col_a_federal_election_activity_levin_share
col_a_federal_election_activity_total
col_a_federal_funds
col_a_florida
col_a_fundraising
col_a_fundraising_disbursements
col_a_georgia
col_a_guam
col_a_hawaii
col_a_idaho
col_a_illinois
col_a_independent_expenditures
col_a_indiana
col_a_individual_contribution_total
col_a_individuals
col_a_individuals_itemized
col_a_individuals_unitemized
col_a_iowa
col_a_items_on_hand_to_be_liquidated
col_a_kansas
col_a_kentucky
col_a_legal_and_accounting
col_a_levin_funds
col_a_loan_disbursements_subtotal
col_a_loan_receipts_subtotal
col_a_loan_repayments_made
col_a_loan_repayments_received
col_a_loans_made
col_a_loans_received
col_a_louisiana
col_a_made_or_guaranteed_by_candidate
col_a_maine
col_a_maryland
col_a_massachusetts
col_a_michigan
col_a_minnesota
col_a_mississippi
col_a_missouri
col_a_montana
col_a_nebraska
col_a_net_contributions
col_a_net_operating_expenditures
col_a_nevada
col_a_new_hampshire
col_a_new_jersey
col_a_new_mexico
col_a_new_york
col_a_north_carolina
col_a_north_dakota
col_a_offsets_to_expenditures
col_a_ohio
col_a_oklahoma
col_a_operating
col_a_operating_expenditures
col_a_oregon
col_a_other_disbursements
col_a_other_disbursements_itemized
col_a_other_disbursements_subtotal
col_a_other_disbursements_unitemized
col_a_other_federal_operating_expenditures
col_a_other_federal_receipts
col_a_other_income_itemized
col_a_other_income_subtotal
col_a_other_income_unitemized
col_a_other_loans
col_a_other_political_committees
col_a_other_political_committees_pacs
col_a_other_receipts
col_a_other_refunds_itemized
col_a_other_refunds_subtotal
col_a_other_refunds_unitemized
col_a_other_repayments
col_a_pennsylvania
col_a_political_party_committees
col_a_political_party_committees_receipts
col_a_political_party_committees_refunds
col_a_prior_expenditures_subject_to_limits
col_a_puerto_rico
col_a_received_from_or_guaranteed_by_cand
col_a_refunds_to_individuals
col_a_refunds_to_other_committees
col_a_refunds_to_party_committees
col_a_rhode_island
col_a_shared_operating_expenditures_federal
col_a_shared_operating_expenditures_nonfederal
col_a_south_carolina
col_a_south_dakota
col_a_subtotal
col_a_tennessee
col_a_texas
col_a_the_candidate
col_a_total_contributions
col_a_total_contributions_refunds
col_a_total_disbursements
col_a_total_expenditures_subject_to_limits
col_a_total_federal_disbursements
col_a_total_federal_operating_expenditures
col_a_total_federal_receipts
col_a_total_loan_repayments_made
col_a_total_loan_repayments_received
col_a_total_loans
col_a_total_nonfederal_transfers
col_a_total_offsets_to_expenditures
col_a_total_operating_expenditures
col_a_total_receipts
col_a_total_refunds
col_a_totals
col_a_transfers_from_aff_other_party_cmttees
col_a_transfers_from_nonfederal_h3
col_a_transfers_to_affiliated
col_a_transfers_to_other_authorized_committees
col_a_utah
col_a_vermont
col_a_virginia
col_a_virgin_islands
col_a_washington
col_a_west_virginia
col_a_wisconsin
col_a_wyoming
col_b_alabama
col_b_alaska
col_b_arizona
col_b_arkansas
col_b_beginning_year
col_b_california
col_b_cash_on_hand_beginning_year
col_b_cash_on_hand_close_of_period
col_b_cash_on_hand_jan_1
col_b_colorado
col_b_connecticut
col_b_contributions_subtotal
col_b_contributions_to_candidates
col_b_convention_expenditures
col_b_convention_expenses_subtotal
col_b_convention_refunds
col_b_convention_refunds_subtotal
col_b_coordinated_expenditures_by_party_committees
col_b_delaware
col_b_dist_of_columbia
col_b_exempt_legal_accounting_disbursement
col_b_expenditures_subject_to_limits
col_b_federal_election_activity_all_federal
col_b_federal_election_activity_federal_share
col_b_federal_election_activity_levin_share
col_b_federal_election_activity_total
col_b_federal_funds
col_b_florida
col_b_fundraising
col_b_fundraising_disbursements
col_b_georgia
col_b_guam
col_b_hawaii
col_b_idaho
col_b_illinois
col_b_independent_expenditures
col_b_indiana
col_b_individual_contribution_total
col_b_individuals
col_b_individuals_itemized
col_b_individuals_unitemized
col_b_iowa
col_b_kansas
col_b_kentucky
col_b_legal_and_accounting
col_b_levin_funds
col_b_loan_disbursements_subtotal
col_b_loan_receipts_subtotal
col_b_loans_made
col_b_louisiana
col_b_made_or_guaranteed_by_the_candidate
col_b_maine
col_b_maryland
col_b_massachusetts
col_b_michigan
col_b_minnesota
col_b_mississippi
col_b_missouri
col_b_montana
col_b_nebraska
col_b_net_contributions
col_b_net_operating_expenditures
col_b_nevada
col_b_new_hampshire
col_b_new_jersey
col_b_new_mexico
col_b_new_york
col_b_north_carolina
col_b_north_dakota
col_b_offsets_to_expenditures
col_b_ohio
col_b_oklahoma
col_b_operating
col_b_operating_expenditures
col_b_oregon
col_b_other_disbursements
col_b_other_disbursements_subtotal
col_b_other_federal_operating_expenditures
col_b_other_federal_receipts
col_b_other_income_subtotal
col_b_other_loans
col_b_other_political_committees
col_b_other_political_committees_pacs
col_b_other_receipts
col_b_other_refunds_subtotal
col_b_other_repayments
col_b_pennsylvania
col_b_political_party_committees
col_b_political_party_committees_receipts
col_b_political_party_committees_refunds
col_b_prior_expendiutres_subject_to_limits
col_b_puerto_rico
col_b_received_from_or_guaranteed_by_cand
col_b_refunds_to_individuals
col_b_refunds_to_other_committees
col_b_refunds_to_party_committees
col_b_rhode_island
col_b_shared_operating_expenditures_federal
col_b_shared_operating_expenditures_nonfederal
col_b_south_carolina
col_b_south_dakota
col_b_subtotal
col_b_tennessee
col_b_texas
col_b_the_candidate
col_b_total_contributions
col_b_total_contributions_other_than_loans
col_b_total_contributions_refunds
col_b_total_disbursements
col_b_total_expenditures_subject_to_limits
col_b_total_federal_disbursements
col_b_total_federal_operating_expenditures
col_b_total_federal_receipts
col_b_total_loan_repayments_made
col_b_total_loan_repayments_received
col_b_total_loans
col_b_total_nonfederal_transfers
col_b_total_offsets_to_expenditures
col_b_total_offsets_to_operating_expenditures
col_b_total_operating_expenditures
col_b_total_receipts
col_b_total_refunds
col_b_totals
col_b_transfers_from_affiliated
col_b_transfers_from_aff_other_party_cmttees
col_b_transfers_from_nonfederal_h3
col_b_transfers_to_affiliated
col_b_transfers_to_other_authorized_committees
col_b_utah
col_b_vermont
col_b_virginia
col_b_virgin_islands
col_b_washington
col_b_west_virginia
col_b_wisconsin
col_b_wyoming
col_b_year
collateral
collateral_value_amount
colorado
COLUMN A REPORT TOTALS
COLUMN B YEAR-TO-DATE TOTALS
COLUMN B YTD TOTALS - LEVIN ACTIVITY
comment
committee_city
committee_email
committee_fax_number
committee_id_number
committee_name
committee_state
committee_street_1
committee_street_2
committee_type
committee_type_description
committee_url
committee_zip_code
communication_date
communication_title
completing_first_name
completing_last_name
completing_middle_name
completing_prefix
completing_suffix
conduit_city
conduit_name
conduit_state
conduit_street1
conduit_street_1
conduit_street2
conduit_street_2
conduit_zip_code
connecticut
contribution_aggregate
contribution_amount
contribution_date
contribution_purpose_code
contribution_purpose_descrip
contributor_city
contributor_employer
contributor_fec_id
contributor_first_name
contributor_last_name
contributor_middle_name
contributor_name
contributor_occupation
contributor_organization_name
contributor_prefix
contributor_state
contributor_street_1
contributor_street_2
contributor_suffix
contributor_zip
contributor_zip_code
controller_city
controller_employer
controller_first_name
controller_last_name
controller_middle_name
controller_occupation
controller_prefix
controller_state
controller_street_1
controller_street_2
controller_suffix
controller_zip_code
coordinated_expenditures
coverage_from_date
coverage_through_date
credit_amount_this_draw
creditor_city
creditor_first_name
creditor_last_name
creditor_middle_name
creditor_name
creditor_organization_name
creditor_prefix
creditor_state
creditor_street_1
creditor_street_2
creditor_suffix
creditor_zip_code
custodian_city
custodian_employer
custodian_first_name
custodian_last_name
custodian_middle_name
custodian_name
custodian_occupation
custodian_prefix
custodian_state
custodian_street_1
custodian_street_2
custodian_suffix
custodian_telephone
custodian_title
custodian_zip_code
date_day_after_general_election
date_general_election
date_notarized
date_notary_commission_expires
date_of_election
date_public_distribution
date_signed
delaware
deposit_acct_auth_date_presidential
description
designated_first_name
designated_last_name
designated_middle_name
designated_prefix
designated_suffix
designating_committee_id_number
designating_committee_name
dist_of_columbia
donation_aggregate_amount
donation_amount
donation_date
donor_candidate_district
donor_candidate_fec_id
donor_candidate_first_name
donor_candidate_last_name
donor_candidate_middle_name
donor_candidate_name
donor_candidate_office
donor_candidate_prefix
donor_candidate_state
donor_candidate_suffix
donor_committee_fec_id
donor_committee_name
effective_date
ef_type
election_code
election_date
election_district
election_other_description
election_state
election_year
entity_type
established_date
estimated_value
expenditure_amount
expenditure_date
expenditure_purpose_code
expenditure_purpose_descrip
F1
F13
F132
F133
F1M
F1S
F2
F24
F2S
F3
F3L
{F3L Semi-annual Bundled}"
F3P
F3P31
F3PS
F3S
F3X
F3Z
F4
F5
F56
F57
F6
F65
F7
F76
F9
F91
F92
F93
F94
F99
f_basis_of_loan_description
fec_candidate_id_number
fec_committee_id_number
fec_version
fifth_candidate_contribution_date
fifth_candidate_district
fifth_candidate_fifth_name
fifth_candidate_id_number
fifth_candidate_last_name
fifth_candidate_middle_name
fifth_candidate_name
fifth_candidate_office
fifth_candidate_prefix
fifth_candidate_state
fifth_candidate_suffix
fifty_first_contributor_date
filer_code
filer_code_description
filer_committee_id_number
first_candidate_contribution_date
first_candidate_district
first_candidate_first_name
first_candidate_id_number
first_candidate_last_name
first_candidate_middle_name
first_candidate_name
first_candidate_office
first_candidate_prefix
first_candidate_state
first_candidate_suffix
florida
form_type
fourth_candidate_contribution_date
fourth_candidate_district
fourth_candidate_fourth_name
fourth_candidate_id_number
fourth_candidate_last_name
fourth_candidate_middle_name
fourth_candidate_name
fourth_candidate_office
fourth_candidate_prefix
fourth_candidate_state
fourth_candidate_suffix
future_income
general_personal_funds_declared
georgia
guam
guaranteed_amount
guarantor_city
guarantor_employer
guarantor_first_name
guarantor_last_name
guarantor_middle_name
guarantor_name
guarantor_occupation
guarantor_prefix
guarantor_state
guarantor_street_1
guarantor_street_2
guarantor_suffix
guarantor_zip_code
hawaii
Header
idaho
illinois
increased_limit
increased_limit_code
incurred_amount_this_period
indiana
individual_employer
individual_first_name
individual_last_name
individual_middle_name
individual_occupation
individual_prefix
individual_suffix
ind_name_as_signed
ind_name_notary
iowa
item_contribution_aquired_date
item_description
item_fair_market_value
kansas
kentucky
leadership_pac
lender_candidate_district
lender_candidate_first_name
lender_candidate_id_number
lender_candidate_last_name
lender_candidate_middle_nm
lender_candidate_name
lender_candidate_office
lender_candidate_prefix
lender_candidate_state
lender_candidate_suffix
lender_city
lender_committee_id_number
lender_first_name
lender_last_name
lender_middle_name
lender_name
lender_organization_name
lender_prefix
lender_state
lender_street_1
lender_street_2
lender_suffix
lender_zip_code
loan_amount
loan_amount_original
loan_balance
loan_due_date
loan_due_date_terms
loan_inccured_date_original
loan_incurred_date
loan_incurred_date_terms
loan_interest_rate
loan_interest_rate_terms
loan_payment_to_date
loan_restructured
lobbyist_registrant_pac
lobbyist_registrant_pac_2
louisiana
maine
maryland
massachusetts
memo_code
memo_text_description
michigan
minnesota
mississippi
missouri
montana
name_delim
nebraska
net_donations
nevada
new_hampshire
new_jersey
(New line 18(b) & 18(c) fields at end of layout)
(New line 30 fields added to end of this layout)
new_mexico
new_york
north_carolina
north_dakota
notary_name
ohio
oklahoma
oregon
organization_name
organization_type
original_amendment_date
original_registration_date
others_liable
party_code
party_type
payee_candidate_district
payee_candidate_first_name
payee_candidate_id_number
payee_candidate_last_name
payee_candidate_middle_name
payee_candidate_name
payee_candidate_office
payee_candidate_prefix
payee_candidate_state
payee_candidate_suffix
payee_city
payee_cmtte_fec_id_number
payee_committee_id_number
payee_employer
payee_first_name
payee_last_name
payee_middle_name
payee_name
payee_occupation
payee_organization_name
payee_prefix
payee_state
payee_street_1
payee_street_2
payee_suffix
payee_zip_code
payment_amount_this_period
pennsylvania
perfected_interest
personal_funds
person_completing_first_name
person_completing_last_name
person_completing_middle_name
person_completing_name
person_completing_prefix
person_completing_suffix
primary_personal_funds_declared
puerto_rico
purpose_of_debt_or_obligation
qualified_committee
qualified_nonprofit
qualified_non_profit
quarterly_monthly_bundled_contributions
receipt_line_number
record_type
reference_code
reference_to_si_or_sl_system_code_that_identifies_the_account
refund_amount
refund_date
refund_or_disposal_of_excess
report_code
report_id
report_number
report_pgi
report_type
requirements_met_date
rhode_island
SchA
SchB
SchC
SchC1
SchC2
SchD
SchE
SchF
SchH1
SchH2
SchH3
SchH4
SchH5
SchH6
SchI
SchL
second_candidate_contribution_date
second_candidate_district
second_candidate_id_number
second_candidate_last_name
second_candidate_middle_name
second_candidate_name
second_candidate_office
second_candidate_prefix
second_candidate_second_name
second_candidate_state
second_candidate_suffix
secured
segregated_bank_account
semi_annual_bundled_contributions
semi_annual_period
semi_annual_period_jan_june
semi_annual_period_jul_dec
semi_annual_refunded_bundled_amt
signature_first_name
signature_last_name
signature_middle_name
signature_name
signature_prefix
signature_suffix
soft_name
soft_ver
south_carolina
south_dakota
state
state_of_election
street_1
street_2
subordinate_city
subordinate_committee_id_number
subordinate_committee_name
subordinate_state
subordinate_street_1
subordinate_street_2
subordinate_zip_code
support_oppose_code
tennessee
texas
TEXT
third_candidate_contribution_date
third_candidate_district
third_candidate_id_number
third_candidate_last_name
third_candidate_middle_name
third_candidate_name
third_candidate_office
third_candidate_prefix
third_candidate_state
third_candidate_suffix
third_candidate_third_name
total_balance
total_contribution
total_disbursements
total_donations
total_donations_accepted
total_donations_refunded
total_independent_expenditure
totals
transaction_code
transaction_description
transaction_id
transaction_id_number
transaction_type
treasurer_city
treasurer_first_name
treasurer_last_name
treasurer_middle_name
treasurer_name
treasurer_prefix
treasurer_state
treasurer_street_1
treasurer_street_2
treasurer_suffix
treasurer_telephone
treasurer_title
treasurer_zip_code
utah
vermont
virginia
virgin_islands
washington
west_virginia
wisconsin
wyoming
zip_code
"""
for x in fields.split():
print "def field_%s() : pass " % x