fedspendingtransparency/usaspending-api

from django.db import models


class SummaryStateView(models.Model):
    duh = models.UUIDField(primary_key=True, help_text="Deterministic Unique Hash")
    fiscal_year = models.IntegerField()
    type = models.TextField()
    distinct_awards = models.TextField()

    pop_country_code = models.TextField()
    pop_state_code = models.TextField()

    generated_pragmatic_obligation = models.DecimalField(max_digits=23, decimal_places=2)
    federal_action_obligation = models.DecimalField(max_digits=23, decimal_places=2)
    original_loan_subsidy_cost = models.DecimalField(max_digits=23, decimal_places=2)
    face_value_loan_guarantee = models.DecimalField(max_digits=23, decimal_places=2)
    counts = models.BigIntegerField()
    total_outlays = models.DecimalField(max_digits=23, decimal_places=2, null=True)

    class Meta:
        managed = True
        db_table = "summary_state_view"