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 }