class TuitionYc(Tuition, CipId):
__tablename__ = "tuition_yc"
median_moe = 1
year = db.Column(db.Integer(), primary_key=True)
oos_tuition_rank = db.Column(db.Integer())
state_tuition_rank = db.Column(db.Integer())
class TuitionYcs(Tuition, CipId, SectorId):
__tablename__ = "tuition_ycs"
median_moe = 1
year = db.Column(db.Integer(), primary_key=True)
num_universities = db.Column(db.Integer())
@classmethod
def get_supported_levels(cls):
return {"cip": CipId.LEVELS, "sector": [ALL]}
class TuitionYcu(Tuition, CipId, UniversityId):
__tablename__ = "tuition_ycu"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
grads_total = db.Column(db.Integer())
@classmethod
def get_supported_levels(cls):
return {"cip": CipId.LEVELS, "university": UniversityId.LEVELS}
class GradsYud(Grads, UniversityId, DegreeId):
__tablename__ = "grads_yud"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
grads_total = db.Column(db.Integer())
@classmethod
def get_supported_levels(cls):
return {"university": UniversityId.LEVELS, "degree": [ALL]}
class DefaultsYure(BaseEd, UniversityCols):
__tablename__ = "yure_defaults"
median_moe = 3
year = db.Column(db.Integer(), primary_key=True)
rate_type = db.Column(db.String(), primary_key=True)
ethnic_code = db.Column(db.Integer(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {
"year": [ALL],
"university": [ALL],
"opeid": [ALL],
"rate_type": [ALL],
"ethnic_code": [ALL],
}
class ISSalariesYus(ISSalariesBase, UniversityId, SexId):
__tablename__ = "instructional_salaries_yus"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {"year": [ALL], "sex": [ALL], "university": UniversityId.LEVELS}
class ExpensesYu(ExpensesBase, UniversityId):
__tablename__ = "expenses_yu"
median_moe = 1
year = db.Column(db.Integer(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {"year": [ALL], "university": UniversityId.LEVELS}
class AdmissionsY(Admissions):
__tablename__ = "adm_undergrad_y"
year = db.Column(db.Integer(), primary_key=True)
median_moe = 0
@classmethod
def get_supported_levels(cls):
return {"year": [ALL]}
class EnrollmentEfaYus(EnrollmentEfa, UniversityId, SexId):
__tablename__ = "enrollment_efa_yus"
year = db.Column(db.Integer(), primary_key=True)
median_moe = 2
@classmethod
def get_supported_levels(cls):
return {"year": [ALL], "university": UniversityId.LEVELS, "sex": [ALL]}
class TuitionYgs(Tuition, GeoId, SectorId):
__tablename__ = "tuition_ygs"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {"geo": GeoId.LEVELS, "sector": [ALL]}
class AdmissionsYu(Admissions, UniversityId):
__tablename__ = "adm_undergrad_yu"
median_moe = 1
year = db.Column(db.Integer(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {"university": UniversityId.LEVELS}
class GradsYu(Grads, UniversityId):
__tablename__ = "grads_yu"
median_moe = 1
year = db.Column(db.Integer(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {"university": UniversityId.LEVELS}
class GradsYcd(Grads, CipId, DegreeId):
__tablename__ = "grads_ycd"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {"cip": CipId.LEVELS, "degree": [ALL]}
class LivingArrangementSfaYa(SfaLivingBase, LivingArrangementId):
__tablename__ = "living_sfa_ya"
year = db.Column(db.Integer(), primary_key=True)
median_moe = 1
@classmethod
def get_supported_levels(cls):
return {"year": [ALL], "living_arrangement": [ALL]}
class LivingArrangementSfaYu(SfaLivingBase, UniversityId):
__tablename__ = "living_sfa_yu"
year = db.Column(db.Integer(), primary_key=True)
median_moe = 1
@classmethod
def get_supported_levels(cls):
return {"year": [ALL], "university": UniversityId.LEVELS}
class ICMaxLivingExpensesYua(BaseIpeds, UniversityId):
__tablename__ = "ic_max_living_expenses_yu"
median_moe = 1
year = db.Column(db.Integer(), primary_key=True)
max_other_expenses = db.Column(db.Float())
max_room_and_board = db.Column(db.Float())
@classmethod
def get_supported_levels(cls):
return {"year": [ALL], "university": UniversityId.LEVELS}
class FinancialsYu(FinancialsBase, UniversityId):
__tablename__ = "financials_yu"
year = db.Column(db.Integer(), primary_key=True)
median_moe = 1
@classmethod
def get_supported_levels(cls):
return {"year": [ALL], "university": UniversityId.LEVELS}
class TuitionYu(Tuition, UniversityId):
__tablename__ = "tuition_yu"
median_moe = 1
year = db.Column(db.Integer(), primary_key=True)
books_and_supplies = db.Column(db.Float())
@classmethod
def get_supported_levels(cls):
return {"university": UniversityId.LEVELS}
class GradRateGrYus(GradRateBase, UniversityId, SexId):
__tablename__ = "gradrate_gr_yus"
year = db.Column(db.Integer(), primary_key=True)
median_moe = 2
@classmethod
def get_supported_levels(cls):
return {"year": [ALL], "university": UniversityId.LEVELS, "sex": [ALL]}
class GradsYgu(Grads, GeoId, UniversityId):
__tablename__ = "grads_ygu"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
grads_total_growth = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
return {"university": UniversityId.LEVELS, GEO: GeoId.LEVELS}
class GradsYgs(Grads, GeoId, SectorId):
__tablename__ = "grads_ygs"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
grads_total_growth = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
return {"sector": [ALL], GEO: GeoId.LEVELS}
class GradsYc(Grads, CipId):
__tablename__ = "grads_yc"
median_moe = 0
year = db.Column(db.Integer(), primary_key=True)
grads_rank = db.Column(db.Integer)
@classmethod
def get_supported_levels(cls):
return {"cip": CipId.LEVELS}
class FAFYod(BaseFreight, OriginGeo, DestGeo):
__tablename__ = "yod_faf"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {
"origin_geo": [STATE, COUNTY, ALL],
"destination_geo": [STATE, COUNTY, ALL]
}
class GradsYgcd(Grads, GeoId, CipId, DegreeId):
__tablename__ = "grads_ygcd"
median_moe = 3
year = db.Column(db.Integer(), primary_key=True)
grads_total_growth = db.Column(db.Float)
grads_total_rca = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
return {"cip": CipId.LEVELS, GEO: GeoId.LEVELS, "degree": [ALL]}
class NonMedUsePainMeds(BaseOpiods):
__tablename__ = "non_medical_use_of_pain_releivers"
median_moe = 1
source_title = 'National Survey on Drug Use and Health'
source_org = 'SAMHSA, Center for Behavioral Health Statistics and Quality'
source_link = 'https://nsduhweb.rti.org/respweb/homepage.cfm'
start_year = db.Column(db.Integer(), primary_key=True)
year = db.Column(db.Integer(), primary_key=True)
non_medical_use_of_pain_relievers = db.Column(db.String())
non_medical_use_of_pain_relievers_lci = db.Column(db.String())
non_medical_use_of_pain_relievers_uci = db.Column(db.String())
@classmethod
def get_supported_levels(cls):
return {
"year": [ALL],
"start_year": [ALL],
"geo": [ALL, NATION, STATE]
}
class Enrollment(BaseIpeds):
__abstract__ = True
enrolled_total = db.Column(db.Integer())
enrolled_men = db.Column(db.Integer())
enrolled_women = db.Column(db.Integer())
enrolled_black = db.Column(db.Integer())
enrolled_asian = db.Column(db.Integer())
enrolled_native = db.Column(db.Integer())
enrolled_unknown = db.Column(db.Integer())
class FAFYdp(BaseFreight, DestGeo, Product):
__tablename__ = "ydp_faf"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {
"destination_geo": [STATE, COUNTY, ALL],
"sctg": [ALL],
"napcs": [ALL]
}
class FAFYom(BaseFreight, OriginGeo):
__tablename__ = "yom_faf"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
transportation_mode = db.Column(db.String(), primary_key=True)
@classmethod
def get_supported_levels(cls):
return {
"origin_geo": [STATE, COUNTY, ALL],
"sctg": [ALL],
"transportation_mode": [ALL]
}
class DefaultsYg(BaseEd, GeoId):
__tablename__ = "yg_defaults"
median_moe = 1.1
year = db.Column(db.Integer(), primary_key=True)
rate_type = db.Column(db.String())
default_rate = db.Column(db.Float)
num_defaults = db.Column(db.Integer)
num_borrowers = db.Column(db.Integer)
@classmethod
def get_supported_levels(cls):
return {"year": [ALL], "geo": GeoId.LEVELS}
class NISSalariesYuo(NISSalariesBase, UniversityId, IPedsOccId):
__tablename__ = "noninstructional_salaries_yuo"
median_moe = 2
year = db.Column(db.Integer(), primary_key=True)
num_noninstructional_staff_rca = db.Column(db.Float)
@classmethod
def get_supported_levels(cls):
return {
"year": [ALL],
"ipeds_occ": [ALL],
"university": UniversityId.LEVELS
}
