class PlaceStats(BaseStat, GeoId):
__tablename__ = "place"
median_moe = 1.2
parent_counties = db.Column(postgresql.ARRAY(db.String))
places_neighbors = db.Column(postgresql.ARRAY(db.String))
@classmethod
def get_supported_levels(cls):
return {"geo": [consts.PLACE]}
class Acs3_Ygi_MedEarnings(BaseAcs3, AcsIndId, GeoId):
__tablename__ = "ygi_med_earnings"
median_moe = 2
med_earnings = db.Column(db.Float)
med_earnings_moe = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
return {"geo": [NATION, STATE, COUNTY, MSA, PLACE, PUMA, ALL], "acs_ind": ["0", "1", "all"]}
class MSAStats(BaseStat, GeoId):
__tablename__ = "msa"
median_moe = 1.2
top_counties = db.Column(postgresql.ARRAY(db.String))
top_places = db.Column(postgresql.ARRAY(db.String))
@classmethod
def get_supported_levels(cls):
return {"geo": [consts.MSA]}
class PUMAStats(BaseStat, GeoId):
__tablename__ = "puma"
median_moe = 1.2
puma_state_rank = db.Column(db.Integer)
pumas_in_state = db.Column(db.Integer)
puma_neighbors = db.Column(postgresql.ARRAY(db.String))
@classmethod
def get_supported_levels(cls):
return {"geo": [consts.PUMA]}
class Acs3_Ygi_Num_Emp(BaseAcs3, AcsIndId, GeoId):
__tablename__ = "ygi_num_emp"
median_moe = 2
num_emp = db.Column(db.Float)
num_emp_moe = db.Column(db.Float)
num_emp_rca = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
return {"geo": [NATION, STATE, MSA, ALL], "acs_ind": AcsIndId.LEVELS}
class Acs5_Ygi_Num_Emp(BaseAcs5, AcsIndId, GeoId):
__tablename__ = "ygi_num_emp"
median_moe = 1.9
num_emp = db.Column(db.Float)
num_emp_moe = db.Column(db.Float)
num_emp_rca = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
return {"geo": [NATION, STATE, COUNTY, PLACE, MSA, PUMA, ALL],
"acs_ind": ["0", "1", ALL]}
class CountyStats(BaseStat, GeoId):
__tablename__ = "counties"
median_moe = 1.2
year = db.Column(db.Integer, primary_key=True)
county_state_rank = db.Column(db.Integer)
places_in_county = db.Column(db.Integer)
top_places = db.Column(postgresql.ARRAY(db.String))
county_neighbors = db.Column(postgresql.ARRAY(db.String))
@classmethod
def get_supported_levels(cls):
return {"geo": [consts.COUNTY]}
class StateStats(BaseStat, GeoId):
__tablename__ = "state"
median_moe = 1.2
year = db.Column(db.Integer, primary_key=True)
state_rank = db.Column(db.Integer)
top_places = db.Column(postgresql.ARRAY(db.String))
top_counties = db.Column(postgresql.ARRAY(db.String))
state_neighbors = db.Column(postgresql.ARRAY(db.String))
@classmethod
def get_supported_levels(cls):
return {"geo": [consts.STATE]}
class Acs1_Ygas_Health(BaseAcs1, GeoId1, BaseHealth):
__tablename__ = "ygas_health"
median_moe = 3
sex = db.Column(db.String(), primary_key=True)
age_bucket = db.Column(db.String(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {
"geo": [NATION, STATE, COUNTY, PLACE, MSA, PUMA, ALL],
"sex": [ALL],
"age_bucket": [ALL]
}
class Acs1_Ygi_Health(BaseAcs1, GeoId1, BaseHealth):
__tablename__ = "ygi_health"
median_moe = 2
insurance = db.Column(db.String(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {
"geo": [NATION, STATE, COUNTY, PLACE, MSA, PUMA, ALL],
"insurance": [ALL]
}
class Acs5_Ygo_Earnings(BaseAcs5, GeoId, AcsOccId):
__tablename__ = "ygo_med_earnings"
median_moe = 2
med_earnings = db.Column(db.Float)
med_earnings_male = db.Column(db.Float)
med_earnings_female = db.Column(db.Float)
med_earnings_moe = db.Column(db.Float)
med_earnings_moe_female = db.Column(db.Float)
med_earnings_moe_male = db.Column(db.Float)
med_earnings_rca = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
return {"geo": [NATION, STATE, COUNTY, MSA, PLACE, PUMA, ALL], "acs_occ": AcsOccId.LEVELS}
class Acs5_Ygo_Num_Emp(BaseAcs5, GeoId, AcsOccId):
__tablename__ = "ygo_num_emp"
median_moe = 2
num_emp = db.Column(db.Float)
num_emp_moe = db.Column(db.Float)
num_emp_rca = db.Column(db.Float)
num_emp_male = db.Column(db.Float)
num_emp_moe_male = db.Column(db.Float)
num_emp_female = db.Column(db.Float)
num_emp_moe_female = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
return {"geo": [NATION, COUNTY, MSA, PLACE, PUMA, ALL], "acs_occ": AcsOccId.LEVELS}
class Acs5_Yg_Num_Emp(BaseAcs5, GeoId):
__tablename__ = "yg_num_emp"
median_moe = 1
civ_labor_force = db.Column(db.Float)
civ_labor_force_moe = db.Column(db.Float)
emp_survey_total = db.Column(db.Float)
emp_survey_total_moe = db.Column(db.Float)
labor_force = db.Column(db.Float)
labor_force_moe = db.Column(db.Float)
not_in_labor_force = db.Column(db.Float)
not_in_labor_force_moe = db.Column(db.Float)
num_armed_forces = db.Column(db.Float)
num_armed_forces_moe = db.Column(db.Float)
num_emp = db.Column(db.Float)
num_emp_moe = db.Column(db.Float)
num_unemp = db.Column(db.Float)
num_unemp_moe = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
return {"geo": [NATION, COUNTY, MSA, PLACE, PUMA, ALL], "acs_occ": AcsOccId.LEVELS}