class CommitteeTransactions(models.Model): """Committee transactions cleaned with Grimm's migration Intended for use in aggregates displayed to the user. Other transaction tables are dirty (contain transaction ammendments with the same "original_id"). """ tran_id = models.IntegerField(blank=True, primary_key=True, default=0) original_id = models.IntegerField(blank=True) tran_date = models.DateField(blank=True, null=True) tran_status = models.LongCharField(max_length=-1, blank=True, null=True) filer = models.LongCharField(max_length=-1, blank=True, null=True) contributor_payee = models.LongCharField(max_length=-1, blank=True, null=True) sub_type = models.LongCharField(max_length=-1, blank=True, null=True) amount = models.FloatField(blank=True, null=True) aggregate_amount = models.FloatField(blank=True, null=True) contributor_payee_committee_id = models.IntegerField(blank=True, null=True) filer_id = models.IntegerField(blank=True, null=True) attest_by_name = models.LongCharField(max_length=-1) attest_date = models.DateField() review_by_name = models.LongCharField(max_length=-1, blank=True, null=True) review_date = models.DateField(blank=True, null=True) due_date = models.DateField(blank=True, null=True) occptn_ltr_date = models.LongCharField(max_length=-1, blank=True, null=True) pymt_sched_txt = models.LongCharField(max_length=-1, blank=True, null=True) purp_desc = models.LongCharField(max_length=-1, blank=True, null=True) intrst_rate = models.LongCharField(max_length=-1, blank=True, null=True) check_nbr = models.LongCharField(max_length=-1, blank=True, null=True) tran_stsfd_ind = models.NullBooleanField() filed_by_name = models.LongCharField(max_length=-1, blank=True, null=True) filed_date = models.DateField(blank=True, null=True) addr_book_agent_name = models.LongCharField(max_length=-1, blank=True, null=True) book_type = models.LongCharField(max_length=-1, blank=True, null=True) title_txt = models.LongCharField(max_length=-1, blank=True, null=True) occptn_txt = models.LongCharField(max_length=-1, blank=True, null=True) emp_name = models.LongCharField(max_length=-1, blank=True, null=True) emp_city = models.LongCharField(max_length=-1, blank=True, null=True) emp_state = models.LongCharField(max_length=-1, blank=True, null=True) employ_ind = models.NullBooleanField() self_employ_ind = models.NullBooleanField() addr_line1 = models.LongCharField(max_length=-1, blank=True, null=True) addr_line2 = models.LongCharField(max_length=-1, blank=True, null=True) city = models.LongCharField(max_length=-1, blank=True, null=True) state = models.LongCharField(max_length=-1, blank=True, null=True) zip = models.IntegerField(blank=True, null=True) zip_plus_four = models.IntegerField(blank=True, null=True) county = models.LongCharField(max_length=-1, blank=True, null=True) purpose_codes = models.LongCharField(max_length=-1, blank=True, null=True) exp_date = models.LongCharField(max_length=-1, blank=True, null=True) IMPORTANT_FIELDS = ['tran_id', 'tran_date', 'filer_id', 'filer', 'contributor_payee', 'amount', 'direction', 'purpose_codes'] def __str__(self): return representation(self) class Meta: app_label = 'pacs' verbose_name = 'transaction' verbose_name_plural = 'transactions' managed = True
class RawCommitteeTransactionsAmmendedTransactions(models.Model): #TODO: what does 'amended' mean? Any reason to keep this table? tran_id = models.IntegerField(blank=True, primary_key=True) original_id = models.IntegerField(blank=True, null=True) tran_date = models.DateField(blank=True, null=True) tran_status = models.LongCharField(max_length=-1, blank=True, null=True) filer = models.LongCharField(max_length=-1, blank=True, null=True) contributor_payee = models.LongCharField(max_length=-1, blank=True, null=True) sub_type = models.LongCharField(max_length=-1, blank=True, null=True) amount = models.FloatField(blank=True, null=True) aggregate_amount = models.FloatField(blank=True, null=True) contributor_payee_committee_id = models.IntegerField(blank=True, null=True) filer_id = models.IntegerField(blank=True, null=True) attest_by_name = models.LongCharField(max_length=-1, blank=True, null=True) attest_date = models.DateField(blank=True, null=True) review_by_name = models.LongCharField(max_length=-1, blank=True, null=True) review_date = models.DateField(blank=True, null=True) due_date = models.DateField(blank=True, null=True) occptn_ltr_date = models.LongCharField(max_length=-1, blank=True, null=True) pymt_sched_txt = models.LongCharField(max_length=-1, blank=True, null=True) purp_desc = models.LongCharField(max_length=-1, blank=True, null=True) intrst_rate = models.LongCharField(max_length=-1, blank=True, null=True) check_nbr = models.LongCharField(max_length=-1, blank=True, null=True) tran_stsfd_ind = models.NullBooleanField() filed_by_name = models.LongCharField(max_length=-1, blank=True, null=True) filed_date = models.DateField(blank=True, null=True) addr_book_agent_name = models.LongCharField(max_length=-1, blank=True, null=True) book_type = models.LongCharField(max_length=-1, blank=True, null=True) title_txt = models.LongCharField(max_length=-1, blank=True, null=True) occptn_txt = models.LongCharField(max_length=-1, blank=True, null=True) emp_name = models.LongCharField(max_length=-1, blank=True, null=True) emp_city = models.LongCharField(max_length=-1, blank=True, null=True) emp_state = models.LongCharField(max_length=-1, blank=True, null=True) employ_ind = models.NullBooleanField() self_employ_ind = models.NullBooleanField() addr_line1 = models.LongCharField(max_length=-1, blank=True, null=True) addr_line2 = models.LongCharField(max_length=-1, blank=True, null=True) city = models.LongCharField(max_length=-1, blank=True, null=True) state = models.LongCharField(max_length=-1, blank=True, null=True) zip = models.IntegerField(blank=True, null=True) zip_plus_four = models.IntegerField(blank=True, null=True) county = models.LongCharField(max_length=-1, blank=True, null=True) purpose_codes = models.LongCharField(max_length=-1, blank=True, null=True) exp_date = models.LongCharField(max_length=-1, blank=True, null=True) def __str__(self): return representation(self) class Meta: app_label = 'pacs' verbose_name = 'ammended transaction' verbose_name_plural = 'ammended transactions' managed = False db_table = 'raw_committee_transactions_ammended_transactions'
class RawCommitteeTransactions(models.Model): """Comittee transactions scrapped directly from OR-Star without any cleaning/deduping.""" tran_id = models.IntegerField(primary_key=True, default=0, null=False) original_id = models.IntegerField(blank=True, null=True) tran_date = models.DateField(blank=True, null=True) tran_status = models.LongCharField(max_length=-1, blank=True, null=True) filer = models.LongCharField(max_length=-1, blank=True, null=True) contributor_payee = models.LongCharField(max_length=-1, blank=True, null=True) sub_type = models.LongCharField(max_length=-1, blank=True, null=True) amount = models.FloatField(blank=True, null=True) aggregate_amount = models.FloatField(blank=True, null=True) contributor_payee_committee_id = models.IntegerField(blank=True, null=True) filer_id = models.IntegerField(blank=True, null=True) attest_by_name = models.LongCharField(max_length=-1, blank=True, null=True) attest_date = models.DateField(blank=True, null=True) review_by_name = models.LongCharField(max_length=-1, blank=True, null=True) review_date = models.DateField(blank=True, null=True) due_date = models.DateField(blank=True, null=True) occptn_ltr_date = models.LongCharField(max_length=-1, blank=True, null=True) pymt_sched_txt = models.LongCharField(max_length=-1, blank=True, null=True) purp_desc = models.LongCharField(max_length=-1, blank=True, null=True) intrst_rate = models.LongCharField(max_length=-1, blank=True, null=True) check_nbr = models.LongCharField(max_length=-1, blank=True, null=True) tran_stsfd_ind = models.NullBooleanField() filed_by_name = models.LongCharField(max_length=-1, blank=True, null=True) filed_date = models.DateField(blank=True, null=True) addr_book_agent_name = models.LongCharField(max_length=-1, blank=True, null=True) book_type = models.LongCharField(max_length=-1, blank=True, null=True) title_txt = models.LongCharField(max_length=-1, blank=True, null=True) occptn_txt = models.LongCharField(max_length=-1, blank=True, null=True) emp_name = models.LongCharField(max_length=-1, blank=True, null=True) emp_city = models.LongCharField(max_length=-1, blank=True, null=True) emp_state = models.LongCharField(max_length=-1, blank=True, null=True) employ_ind = models.NullBooleanField() self_employ_ind = models.NullBooleanField() addr_line1 = models.LongCharField(max_length=-1, blank=True, null=True) addr_line2 = models.LongCharField(max_length=-1, blank=True, null=True) city = models.LongCharField(max_length=-1, blank=True, null=True) state = models.LongCharField(max_length=-1, blank=True, null=True) zip = models.IntegerField(blank=True, null=True) zip_plus_four = models.IntegerField(blank=True, null=True) county = models.LongCharField(max_length=-1, blank=True, null=True) purpose_codes = models.LongCharField(max_length=-1, blank=True, null=True) exp_date = models.LongCharField(max_length=-1, blank=True, null=True) IMPORTANT_FIELDS = ['tran_id', 'tran_date', 'filer_id', 'filer', 'contributor_payee', 'amount', 'direction', 'purpose_codes'] def __str__(self): return representation(self) class Meta: app_label = 'pacs' verbose_name = 'raw transaction' verbose_name_plural = 'raw transactions' db_table = 'raw_committee_transactions'
class RawCommitteeTransactionsErrors(models.Model): tran_id = models.IntegerField(blank=True, null=True) original_id = models.IntegerField(blank=True, null=True) tran_date = models.DateField(blank=True, null=True) tran_status = models.LongCharField(max_length=-1, blank=True, null=True) filer = models.LongCharField(max_length=-1, blank=True, null=True) contributor_payee = models.LongCharField(max_length=-1, blank=True, null=True) sub_type = models.LongCharField(max_length=-1, blank=True, null=True) amount = models.FloatField(blank=True, null=True) aggregate_amount = models.FloatField(blank=True, null=True) contributor_payee_committee_id = models.IntegerField(blank=True, null=True) filer_id = models.IntegerField(blank=True, null=True) attest_by_name = models.LongCharField(max_length=-1, blank=True, null=True) attest_date = models.DateField(blank=True, null=True) review_by_name = models.LongCharField(max_length=-1, blank=True, null=True) review_date = models.DateField(blank=True, null=True) due_date = models.DateField(blank=True, null=True) occptn_ltr_date = models.LongCharField(max_length=-1, blank=True, null=True) pymt_sched_txt = models.LongCharField(max_length=-1, blank=True, null=True) purp_desc = models.LongCharField(max_length=-1, blank=True, null=True) intrst_rate = models.LongCharField(max_length=-1, blank=True, null=True) check_nbr = models.LongCharField(max_length=-1, blank=True, null=True) tran_stsfd_ind = models.NullBooleanField() filed_by_name = models.LongCharField(max_length=-1, blank=True, null=True) filed_date = models.DateField(blank=True, null=True) addr_book_agent_name = models.LongCharField(max_length=-1, blank=True, null=True) book_type = models.LongCharField(max_length=-1, blank=True, null=True) title_txt = models.LongCharField(max_length=-1, blank=True, null=True) occptn_txt = models.LongCharField(max_length=-1, blank=True, null=True) emp_name = models.LongCharField(max_length=-1, blank=True, null=True) emp_city = models.LongCharField(max_length=-1, blank=True, null=True) emp_state = models.LongCharField(max_length=-1, blank=True, null=True) employ_ind = models.NullBooleanField() self_employ_ind = models.NullBooleanField() addr_line1 = models.LongCharField(max_length=-1, blank=True, null=True) addr_line2 = models.LongCharField(max_length=-1, blank=True, null=True) city = models.LongCharField(max_length=-1, blank=True, null=True) state = models.LongCharField(max_length=-1, blank=True, null=True) zip = models.IntegerField(blank=True, null=True) zip_plus_four = models.IntegerField(blank=True, null=True) county = models.LongCharField(max_length=-1, blank=True, null=True) purpose_codes = models.LongCharField(max_length=-1, blank=True, null=True) exp_date = models.LongCharField(max_length=-1, blank=True, null=True) class Meta: managed = True app_label = 'pacs' db_table = 'raw_committee_transactions_errors'
class RawCommitteeTransactions(models.Model): tran_id = models.IntegerField(blank=True, null=True, help_text='A single transaction can have multiple tran_ids due to revisions/corrections.') original_id = models.IntegerField(blank=True, null=True, help_text='Nonunique because amendments/corrections must refer to the same original_id.') tran_date = models.DateField(blank=True, null=True) tran_status = models.LongCharField(max_length=-1, blank=True, null=True) filer = models.LongCharField(max_length=-1, blank=True, null=True) contributor_payee = models.LongCharField(max_length=-1, blank=True, null=True) sub_type = models.LongCharField(max_length=-1, blank=True, null=True) amount = models.FloatField(blank=True, null=True) aggregate_amount = models.FloatField(blank=True, null=True) contributor_payee_committee_id = models.IntegerField(blank=True, null=True) filer_id = models.IntegerField(blank=True, null=True, help_text="Unique identifier of a Committee (CommitteeDetail FK)") attest_by_name = models.LongCharField(max_length=-1, blank=True, null=True) attest_date = models.DateField(blank=True, null=True) review_by_name = models.LongCharField(max_length=-1, blank=True, null=True) review_date = models.DateField(blank=True, null=True) due_date = models.DateField(blank=True, null=True) occptn_ltr_date = models.LongCharField(max_length=-1, blank=True, null=True) pymt_sched_txt = models.LongCharField(max_length=-1, blank=True, null=True) purp_desc = models.LongCharField(max_length=-1, blank=True, null=True) intrst_rate = models.LongCharField(max_length=-1, blank=True, null=True) check_nbr = models.LongCharField(max_length=-1, blank=True, null=True) tran_stsfd_ind = models.NullBooleanField() filed_by_name = models.LongCharField(max_length=-1, blank=True, null=True) filed_date = models.DateField(blank=True, null=True) addr_book_agent_name = models.LongCharField(max_length=-1, blank=True, null=True) book_type = models.LongCharField(max_length=-1, blank=True, null=True) title_txt = models.LongCharField(max_length=-1, blank=True, null=True) occptn_txt = models.LongCharField(max_length=-1, blank=True, null=True) emp_name = models.LongCharField(max_length=-1, blank=True, null=True) emp_city = models.LongCharField(max_length=-1, blank=True, null=True) emp_state = models.LongCharField(max_length=-1, blank=True, null=True) employ_ind = models.NullBooleanField() self_employ_ind = models.NullBooleanField() addr_line1 = models.LongCharField(max_length=-1, blank=True, null=True) addr_line2 = models.LongCharField(max_length=-1, blank=True, null=True) city = models.LongCharField(max_length=-1, blank=True, null=True) state = models.LongCharField(max_length=-1, blank=True, null=True) zip = models.IntegerField(blank=True, null=True) zip_plus_four = models.IntegerField(blank=True, null=True) county = models.LongCharField(max_length=-1, blank=True, null=True) purpose_codes = models.LongCharField(max_length=-1, blank=True, null=True) exp_date = models.LongCharField(max_length=-1, blank=True, null=True) class Meta: managed = True app_label = 'pacs' db_table = 'raw_committee_transactions'
class WorkingCandidateFilings(models.Model): election_txt = models.TextField(blank=True, null=True) election_year = models.IntegerField(blank=True, null=True) office_group = models.TextField(blank=True, null=True) id_nbr = models.IntegerField(blank=True, null=True) office = models.TextField(blank=True, null=True) candidate_office = models.TextField(blank=True, null=True) candidate_file_rsn = models.IntegerField(blank=True, null=True) file_mthd_ind = models.TextField(blank=True, null=True) filetype_descr = models.TextField(blank=True, null=True) party_descr = models.TextField(blank=True, null=True) major_party_ind = models.TextField(blank=True, null=True) cand_ballot_name_txt = models.TextField(blank=True, null=True) occptn_txt = models.TextField(blank=True, null=True) education_bckgrnd_txt = models.TextField(blank=True, null=True) occptn_bkgrnd_txt = models.TextField(blank=True, null=True) school_grade_diploma_degree_certificate_course_of_study = models.TextField( blank=True, null=True) prev_govt_bkgrnd_txt = models.TextField(blank=True, null=True) judge_incbnt_ind = models.TextField(blank=True, null=True) qlf_ind = models.TextField(blank=True, null=True) filed_date = models.DateField(blank=True, null=True) file_fee_rfnd_date = models.DateField(blank=True, null=True) witdrw_date = models.DateField(blank=True, null=True) withdrw_resn_txt = models.NullBooleanField() pttn_file_date = models.DateField(blank=True, null=True) pttn_sgnr_rqd_nbr = models.IntegerField(blank=True, null=True) pttn_signr_filed_nbr = models.IntegerField(blank=True, null=True) pttn_cmplt_date = models.DateField(blank=True, null=True) ballot_order_nbr = models.IntegerField(blank=True, null=True) prfx_name_cd = models.TextField(blank=True, null=True) first_name = models.TextField(blank=True, null=True) mdle_name = models.TextField(blank=True, null=True) last_name = models.TextField(blank=True, null=True) sufx_name = models.TextField(blank=True, null=True) title_txt = models.TextField(blank=True, null=True) mailing_addr_line_1 = models.TextField(blank=True, null=True) mailing_addr_line_2 = models.TextField(blank=True, null=True) mailing_city_name = models.TextField(blank=True, null=True) mailing_st_cd = models.TextField(blank=True, null=True) mailing_zip_code = models.IntegerField(blank=True, null=True) mailing_zip_plus_four = models.IntegerField(blank=True, null=True) residence_addr_line_1 = models.TextField(blank=True, null=True) residence_addr_line_2 = models.TextField(blank=True, null=True) residence_city_name = models.TextField(blank=True, null=True) residence_st_cd = models.TextField(blank=True, null=True) residence_zip_code = models.IntegerField(blank=True, null=True) residence_zip_plus_four = models.IntegerField(blank=True, null=True) home_phone = models.TextField(blank=True, null=True) cell_phone = models.TextField(blank=True, null=True) fax_phone = models.TextField(blank=True, null=True) email = models.TextField(blank=True, null=True) work_phone = models.TextField(blank=True, null=True) web_address = models.TextField(blank=True, null=True) class Meta: managed = True app_label = 'pacs' db_table = 'working_candidate_filings'
class RawCandidateFilings(models.Model): candidate_file_rsn = models.IntegerField(blank=True, primary_key=True, default=0) election_txt = models.TextField(blank=True, null=True) election_year = models.IntegerField(blank=True, null=True) office_group = models.TextField(blank=True, null=True) id_nbr = models.IntegerField(blank=True, null=True) office = models.TextField(blank=True, null=True) candidate_office = models.TextField(blank=True, null=True) candidate_file_rsn = models.IntegerField(blank=True, null=True) file_mthd_ind = models.TextField(blank=True, null=True) filetype_descr = models.TextField(blank=True, null=True) party_descr = models.TextField(blank=True, null=True) major_party_ind = models.TextField(blank=True, null=True) cand_ballot_name_txt = models.TextField(blank=True, null=True) occptn_txt = models.TextField(blank=True, null=True) education_bckgrnd_txt = models.TextField(blank=True, null=True) occptn_bkgrnd_txt = models.TextField(blank=True, null=True) school_grade_diploma_degree_certificate_course_of_study = models.TextField(blank=True, null=True) prev_govt_bkgrnd_txt = models.TextField(blank=True, null=True) judge_incbnt_ind = models.TextField(blank=True, null=True) qlf_ind = models.TextField(blank=True, null=True) filed_date = models.DateField(blank=True, null=True) file_fee_rfnd_date = models.DateField(blank=True, null=True) witdrw_date = models.DateField(blank=True, null=True) withdrw_resn_txt = models.NullBooleanField() pttn_file_date = models.DateField(blank=True, null=True) pttn_sgnr_rqd_nbr = models.IntegerField(blank=True, null=True) pttn_signr_filed_nbr = models.IntegerField(blank=True, null=True) pttn_cmplt_date = models.DateField(blank=True, null=True) ballot_order_nbr = models.IntegerField(blank=True, null=True) prfx_name_cd = models.TextField(blank=True, null=True) first_name = models.TextField(blank=True, null=True) mdle_name = models.TextField(blank=True, null=True) last_name = models.TextField(blank=True, null=True) sufx_name = models.TextField(blank=True, null=True) title_txt = models.TextField(blank=True, null=True) mailing_addr_line_1 = models.TextField(blank=True, null=True) mailing_addr_line_2 = models.TextField(blank=True, null=True) mailing_city_name = models.TextField(blank=True, null=True) mailing_st_cd = models.TextField(blank=True, null=True) mailing_zip_code = models.IntegerField(blank=True, null=True) mailing_zip_plus_four = models.IntegerField(blank=True, null=True) residence_addr_line_1 = models.TextField(blank=True, null=True) residence_addr_line_2 = models.TextField(blank=True, null=True) residence_city_name = models.TextField(blank=True, null=True) residence_st_cd = models.TextField(blank=True, null=True) residence_zip_code = models.IntegerField(blank=True, null=True) residence_zip_plus_four = models.IntegerField(blank=True, null=True) home_phone = models.TextField(blank=True, null=True) cell_phone = models.TextField(blank=True, null=True) fax_phone = models.TextField(blank=True, null=True) email = models.TextField(blank=True, null=True) work_phone = models.TextField(blank=True, null=True) web_address = models.TextField(blank=True, null=True) IMPORTANT_FIELDS = ['filer_id', 'filer', 'party_descr', 'major_party_ind', 'first_name', 'mdle_name', 'last_name', 'sufx_name'] def __str__(self): return representation(self) class Meta: verbose_name = 'candidate filing' app_label = 'pacs' managed = True db_table = 'raw_candidate_filings'