Ejemplos de TableField en Python

Ejemplo n.º 1

Archivo: nibrs_weapon_type.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="WEAPON_ID", sql_type=SQLConfig.Types.INTEGER, is_primary=True),
        TableField(name="WEAPON_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="WEAPON_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="SHR_FLAG", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 2

def get_headers() -> list[TableField]:
    return [
        TableField(
            name="SUSPECT_USING_ID", sql_type=SQLConfig.Types.INTEGER, is_primary=True
        ),
        TableField(name="SUSPECT_USING_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="SUSPECT_USING_NAME", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 3

Archivo: nibrs_victim_type.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="VICTIM_TYPE_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="VICTIM_TYPE_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="VICTIM_TYPE_NAME", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 4

def get_headers() -> list[TableField]:
    return [
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="VICTIM_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="OFFENSE_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
    ]

Ejemplo n.º 5

Archivo: nibrs_prop_loss_type.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="PROP_LOSS_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="PROP_LOSS_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="PROP_LOSS_DESC", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 6

Archivo: nibrs_cleared_except.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(
            name="CLEARED_EXCEPT_ID", sql_type=SQLConfig.Types.INTEGER, is_primary=True
        ),
        TableField(name="CLEARED_EXCEPT_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="CLEARED_EXCEPT_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="CLEARED_EXCEPT_DESC", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 7

def get_headers() -> list[TableField]:
    return [
        TableField(
            name="CIRCUMSTANCES_ID", sql_type=SQLConfig.Types.INTEGER, is_primary=True
        ),
        TableField(name="CIRCUMSTANCES_TYPE", sql_type=SQLConfig.Types.STRING),
        TableField(name="CIRCUMSTANCES_CODE", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="CIRCUMSTANCES_NAME", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 8

def get_headers() -> list[TableField]:
    return [
        TableField(name="JUSTIFIABLE_FORCE_ID",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="JUSTIFIABLE_FORCE_CODE",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="JUSTIFIABLE_FORCE_NAME",
                   sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 9

def get_headers() -> list[TableField]:
    return [
        TableField(name="BIAS_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="BIAS_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="BIAS_CATEGORY", sql_type=SQLConfig.Types.STRING),
        TableField(name="BIAS_DESC", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 10

Archivo: nibrs_arrestee_weapon.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="ARRESTEE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="WEAPON_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(
            name="NIBRS_ARRESTEE_WEAPON_ID",
            sql_type=SQLConfig.Types.INTEGER,
            is_primary=True,
        ),
    ]

Ejemplo n.º 11

Archivo: nibrs_victim_offender_rel.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="VICTIM_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="OFFENDER_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="RELATIONSHIP_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(
            name="NIBRS_VICTIM_OFFENDER_ID",
            sql_type=SQLConfig.Types.INTEGER,
            is_primary=True,
        ),
    ]

Ejemplo n.º 12

Archivo: nibrs_offense_type.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="OFFENSE_TYPE_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="OFFENSE_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="OFFENSE_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="CRIME_AGAINST", sql_type=SQLConfig.Types.STRING),
        TableField(name="CT_FLAG", sql_type=SQLConfig.Types.STRING),
        TableField(name="HC_FLAG", sql_type=SQLConfig.Types.STRING),
        TableField(name="HC_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="OFFENSE_CATEGORY_NAME",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="OFFENSE_GROUP", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 13

Archivo: ref_state.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="STATE_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="DIVISION_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="STATE_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="STATE_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="STATE_ABBR", sql_type=SQLConfig.Types.STRING),
        TableField(name="STATE_POSTAL_ABBR", sql_type=SQLConfig.Types.STRING),
        TableField(name="STATE_FIPS_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="STATE_PUB_FREQ_MONTHS",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="CHANGE_USER", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 14

def get_headers() -> list[TableField]:
    return [
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="OFFENSE_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="INCIDENT_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="OFFENSE_TYPE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="ATTEMPT_COMPLETE_FLAG",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="LOCATION_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="NUM_PREMISES_ENTERED",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="METHOD_ENTRY_CODE", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 15

Archivo: ref_race.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="RACE_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="RACE_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="RACE_DESC", sql_type=SQLConfig.Types.STRING),
        TableField(name="SORT_ORDER", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="START_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="END_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="NOTES", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 16

def get_headers() -> list[TableField]:
    return [
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="PROPERTY_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="INCIDENT_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="PROP_LOSS_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="STOLEN_COUNT", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="RECOVERED_COUNT", sql_type=SQLConfig.Types.INTEGER),
    ]

Ejemplo n.º 17

Archivo: nibrs_property_desc.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="PROPERTY_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="PROP_DESC_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="PROPERTY_VALUE", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="DATE_RECOVERED", sql_type=SQLConfig.Types.DATE),
        TableField(
            name="NIBRS_PROP_DESC_ID", sql_type=SQLConfig.Types.INTEGER, is_primary=True
        ),
    ]

Ejemplo n.º 18

Archivo: nibrs_suspected_drug.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="SUSPECTED_DRUG_TYPE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="PROPERTY_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="EST_DRUG_QTY", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="DRUG_MEASURE_TYPE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(
            name="NIBRS_SUSPECTED_DRUG_ID",
            sql_type=SQLConfig.Types.INTEGER,
            is_primary=True,
        ),
    ]

Ejemplo n.º 19

Archivo: nibrs_incident.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="AGENCY_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="INCIDENT_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="NIBRS_MONTH_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="CARGO_THEFT_FLAG", sql_type=SQLConfig.Types.STRING),
        TableField(name="SUBMISSION_DATE", sql_type=SQLConfig.Types.DATE),
        TableField(name="INCIDENT_DATE", sql_type=SQLConfig.Types.DATE),
        TableField(name="REPORT_DATE_FLAG", sql_type=SQLConfig.Types.STRING),
        TableField(name="INCIDENT_HOUR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="CLEARED_EXCEPT_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="CLEARED_EXCEPT_DATE", sql_type=SQLConfig.Types.DATE),
        TableField(name="INCIDENT_STATUS", sql_type=SQLConfig.Types.STRING),
        TableField(name="DATA_HOME", sql_type=SQLConfig.Types.STRING),
        TableField(name="ORIG_FORMAT", sql_type=SQLConfig.Types.STRING),
        TableField(name="DID", sql_type=SQLConfig.Types.INTEGER),
    ]

Ejemplo n.º 20

def get_headers() -> list[TableField]:
    return [
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="NIBRS_MONTH_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="AGENCY_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="MONTH_NUM", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="REPORTED_STATUS", sql_type=SQLConfig.Types.STRING),
        TableField(name="REPORT_DATE", sql_type=SQLConfig.Types.STRING),
        TableField(name="UPDATE_FLAG", sql_type=SQLConfig.Types.STRING),
        TableField(name="ORIG_FORMAT", sql_type=SQLConfig.Types.STRING),
        TableField(name="DATA_HOME", sql_type=SQLConfig.Types.STRING),
        TableField(name="DDOCNAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="DID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="MONTH_PUB_STATUS", sql_type=SQLConfig.Types.INTEGER),
    ]

Ejemplo n.º 21

Archivo: agencies.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="YEARLY_AGENCY_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="AGENCY_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="ORI", sql_type=SQLConfig.Types.STRING),
        TableField(name="LEGACY_ORI", sql_type=SQLConfig.Types.STRING),
        TableField(name="COVERED_BY_LEGACY_ORI",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="DIRECT_CONTRIBUTOR_FLAG",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="DORMANT_FLAG", sql_type=SQLConfig.Types.STRING),
        TableField(name="DORMANT_YEAR", sql_type=SQLConfig.Types.STRING),
        TableField(name="REPORTING_TYPE", sql_type=SQLConfig.Types.STRING),
        TableField(name="UCR_AGENCY_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="NCIC_AGENCY_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="PUB_AGENCY_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="PUB_AGENCY_UNIT", sql_type=SQLConfig.Types.STRING),
        TableField(name="AGENCY_STATUS", sql_type=SQLConfig.Types.STRING),
        TableField(name="STATE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="STATE_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="STATE_ABBR", sql_type=SQLConfig.Types.STRING),
        TableField(name="STATE_POSTAL_ABBR", sql_type=SQLConfig.Types.STRING),
        TableField(name="DIVISION_CODE", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="DIVISION_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="REGION_CODE", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="REGION_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="REGION_DESC", sql_type=SQLConfig.Types.STRING),
        TableField(name="AGENCY_TYPE_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="POPULATION", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="SUBMITTING_AGENCY_ID",
                   sql_type=SQLConfig.Types.INTEGER),
        TableField(name="SAI", sql_type=SQLConfig.Types.STRING),
        TableField(name="SUBMITTING_AGENCY_NAME",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="SUBURBAN_AREA_FLAG", sql_type=SQLConfig.Types.STRING),
        TableField(name="POPULATION_GROUP_ID",
                   sql_type=SQLConfig.Types.INTEGER),
        TableField(name="POPULATION_GROUP_CODE",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="POPULATION_GROUP_DESC",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="PARENT_POP_GROUP_CODE",
                   sql_type=SQLConfig.Types.INTEGER),
        TableField(name="PARENT_POP_GROUP_DESC",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="MIP_FLAG", sql_type=SQLConfig.Types.STRING),
        TableField(name="POP_SORT_ORDER", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="SUMMARY_RAPE_DEF", sql_type=SQLConfig.Types.STRING),
        TableField(name="PE_REPORTED_FLAG", sql_type=SQLConfig.Types.STRING),
        TableField(name="MALE_OFFICER", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="MALE_CIVILIAN", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="PED.MALE_OFFICER+PED.MALE_CIVILIAN",
                   sql_type=SQLConfig.Types.INTEGER),
        TableField(name="FEMALE_OFFICER", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="FEMALE_CIVILIAN", sql_type=SQLConfig.Types.INTEGER),
        TableField(
            name="PED.FEMALE_CIVILIAN+PED.FEMALE_OFFICER",
            sql_type=SQLConfig.Types.INTEGER,
        ),
        TableField(name="0", sql_type=SQLConfig.Types.STRING),
        TableField(name="0.1", sql_type=SQLConfig.Types.STRING),
        TableField(name="NIBRS_CERT_DATE", sql_type=SQLConfig.Types.DATE),
        TableField(name="NIBRS_START_DATE", sql_type=SQLConfig.Types.DATE),
        TableField(name="NIBRS_LEOKA_START_DATE",
                   sql_type=SQLConfig.Types.DATE),
        TableField(name="NIBRS_CT_START_DATE", sql_type=SQLConfig.Types.DATE),
        TableField(name="NIBRS_MULTI_BIAS_START_DATE",
                   sql_type=SQLConfig.Types.DATE),
        TableField(name="NIBRS_OFF_ETH_START_DATE",
                   sql_type=SQLConfig.Types.DATE),
        TableField(name="COVERED_FLAG", sql_type=SQLConfig.Types.STRING),
        TableField(name="COUNTY_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="MSA_NAME", sql_type=SQLConfig.Types.STRING),
        TableField(name="PUBLISHABLE_FLAG", sql_type=SQLConfig.Types.STRING),
        TableField(name="PARTICIPATED", sql_type=SQLConfig.Types.STRING),
        TableField(name="NIBRS_PARTICIPATED", sql_type=SQLConfig.Types.STRING),
    ]

Ejemplo n.º 22

Archivo: nibrs_offender.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(
            name="OFFENDER_ID", sql_type=SQLConfig.Types.INTEGER, is_primary=True
        ),
        TableField(name="INCIDENT_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="OFFENDER_SEQ_NUM", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="AGE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="AGE_NUM", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="SEX_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="RACE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="ETHNICITY_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="AGE_RANGE_LOW_NUM", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="AGE_RANGE_HIGH_NUM", sql_type=SQLConfig.Types.INTEGER),
    ]

Ejemplo n.º 23

def get_headers() -> list[TableField]:
    return [
        TableField("DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField("ARRESTEE_ID", sql_type=SQLConfig.Types.INTEGER, is_primary=True),
        TableField("INCIDENT_ID", sql_type=SQLConfig.Types.STRING, is_primary=True),
        TableField("ARRESTEE_SEQ_NUM", sql_type=SQLConfig.Types.INTEGER),
        TableField("ARREST_DATE", sql_type=SQLConfig.Types.STRING),
        TableField("ARREST_TYPE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField("MULTIPLE_INDICATOR", sql_type=SQLConfig.Types.STRING),
        TableField("OFFENSE_TYPE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField("AGE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField("AGE_NUM", sql_type=SQLConfig.Types.INTEGER),
        TableField("SEX_CODE", sql_type=SQLConfig.Types.STRING),
        TableField("RACE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField("ETHNICITY_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField("RESIDENT_CODE", sql_type=SQLConfig.Types.STRING),
        TableField("UNDER_18_DISPOSITION_CODE", sql_type=SQLConfig.Types.STRING),
        TableField("CLEARANCE_IND", sql_type=SQLConfig.Types.STRING),
        TableField("AGE_RANGE_LOW_NUM", sql_type=SQLConfig.Types.INTEGER),
        TableField("AGE_RANGE_HIGH_NUM", sql_type=SQLConfig.Types.INTEGER),
    ]

Ejemplo n.º 24

def get_headers() -> list[TableField]:
    return [
        TableField(name="DATA_YEAR", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="VICTIM_ID",
                   sql_type=SQLConfig.Types.INTEGER,
                   is_primary=True),
        TableField(name="INCIDENT_ID",
                   sql_type=SQLConfig.Types.STRING,
                   is_primary=True),
        TableField(name="VICTIM_SEQ_NUM", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="VICTIM_TYPE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="ASSIGNMENT_TYPE_ID",
                   sql_type=SQLConfig.Types.INTEGER),
        TableField(name="ACTIVITY_TYPE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="OUTSIDE_AGENCY_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="AGE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="AGE_NUM", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="SEX_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="RACE_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="ETHNICITY_ID", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="RESIDENT_STATUS_CODE",
                   sql_type=SQLConfig.Types.STRING),
        TableField(name="AGE_RANGE_LOW_NUM", sql_type=SQLConfig.Types.INTEGER),
        TableField(name="AGE_RANGE_HIGH_NUM",
                   sql_type=SQLConfig.Types.INTEGER),
    ]

Ejemplo n.º 25

Archivo: nibrs_ethnicity.py Proyecto: Ydot19/VA-Crime-Data-Explorer

def get_headers() -> list[TableField]:
    return [
        TableField(name="ETHNICITY_ID", sql_type=SQLConfig.Types.STRING),
        TableField(name="ETHNICITY_CODE", sql_type=SQLConfig.Types.STRING),
        TableField(name="ETHNICITY_NAME", sql_type=SQLConfig.Types.STRING),
    ]