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'
