class CampaignDetail(models.Model): filer_id = models.IntegerField( primary_key=True, default=0, help_text="2384 unique integers identifying each committee.") candidate_name = models.TextField( blank=True, null=True, help_text="Not unique_together (candidate_name, committee_name, race)." ) committee_name = models.LongCharField( max_length=-1, blank=True, null=True, help_text='Nonunique identifying name.') race = models.TextField(blank=True, null=True) website = models.TextField(blank=True, null=True) phone = models.LongCharField(max_length=-1, blank=True, null=True) total = models.FloatField(blank=True, null=True) total_spent = models.FloatField(blank=True, null=True) grassroots = models.FloatField(blank=True, null=True) instate = models.FloatField(blank=True, null=True) election = models.TextField(blank=True, null=True) party = models.TextField(blank=True, null=True) num_transactions = models.BigIntegerField(blank=True, null=True) committee_type = models.LongCharField(max_length=-1, blank=True, null=True) committee_subtype = models.LongCharField(max_length=-1, blank=True, null=True) db_update_status = models.TextField(blank=True, null=True) class Meta: managed = True app_label = 'pacs' db_table = 'campaign_detail'
class CampaignDetail(models.Model): filer_id = models.IntegerField(primary_key=True, default=0) candidate_name = models.TextField(blank=True, null=True) committee_name = models.LongCharField(max_length=-1, blank=True, null=True) race = models.TextField(blank=True, null=True) website = models.TextField(blank=True, null=True) phone = models.LongCharField(max_length=-1, blank=True, null=True) total = models.FloatField(blank=True, null=True) total_spent = models.FloatField(blank=True, null=True) grassroots = models.FloatField(blank=True, null=True) instate = models.FloatField(blank=True, null=True) election = models.TextField(blank=True, null=True) party = models.TextField(blank=True, null=True) num_transactions = models.BigIntegerField(blank=True, null=True) committee_type = models.LongCharField(max_length=-1, blank=True, null=True) committee_subtype = models.LongCharField(max_length=-1, blank=True, null=True) db_update_status = models.TextField(blank=True, null=True) IMPORTANT_FIELDS = ['filer_id', 'committee_name', 'committee_type', 'committee_subtype', 'candidate_name', 'website', 'party', 'race'] def __str__(self): return representation(self) class Meta: app_label = 'pacs' managed = True db_table = 'campaign_detail'
class CcGrassRootsInState(models.Model): filer_id = models.IntegerField(blank=True, primary_key=True) filer = models.LongCharField(max_length=-1, blank=True, null=True) num_transactions = models.BigIntegerField(blank=True, null=True) in_state = models.FloatField(blank=True, null=True) grass_roots = models.FloatField(blank=True, null=True) total_contributions = models.FloatField(blank=True, null=True) total_money = models.FloatField(blank=True, null=True) total_money_out = models.FloatField(blank=True, null=True) percent_grass_roots = models.FloatField(blank=True, null=True) percent_in_state = models.FloatField(blank=True, null=True) IMPORTANT_FIELDS = [ 'filer_id', 'filer', 'total_money', 'percent_grass_roots', 'percent_in_state' ] def __str__(self): return representation(self) class Meta: verbose_name = 'grass roots in-state total' verbose_name_plural = 'grass roots in-state totals' managed = False db_table = 'cc_grass_roots_in_state'
class CcGrassRootsInState(models.Model): filer_id = models.IntegerField(blank=True, null=True) filer = models.LongCharField(max_length=-1, blank=True, null=True) num_transactions = models.BigIntegerField(blank=True, null=True) in_state = models.FloatField(blank=True, null=True) grass_roots = models.FloatField(blank=True, null=True) total_contributions = models.FloatField(blank=True, null=True) total_money = models.FloatField(blank=True, null=True) total_money_out = models.FloatField(blank=True, null=True) percent_grass_roots = models.FloatField(blank=True, null=True) percent_in_state = models.FloatField(blank=True, null=True) class Meta: managed = True app_label = 'pacs' db_table = 'cc_grass_roots_in_state'
class CampaignDetail(models.Model): filer_id = models.IntegerField(primary_key=True, default=0) candidate_name = models.TextField(blank=True, null=True) committee_name = models.LongCharField(max_length=-1, blank=True, null=True) race = models.TextField(blank=True, null=True) website = models.TextField(blank=True, null=True) phone = models.LongCharField(max_length=-1, blank=True, null=True) total = models.FloatField(blank=True, null=True) total_spent = models.FloatField(blank=True, null=True) grassroots = models.FloatField(blank=True, null=True) instate = models.FloatField(blank=True, null=True) election = models.TextField(blank=True, null=True) party = models.TextField(blank=True, null=True) num_transactions = models.BigIntegerField(blank=True, null=True) committee_type = models.LongCharField(max_length=-1, blank=True, null=True) committee_subtype = models.LongCharField(max_length=-1, blank=True, null=True) db_update_status = models.TextField(blank=True, null=True) class Meta: managed = True app_label = 'pacs' db_table = 'campaign_detail'