Python TableField Beispiele

Beispiel #1

Datei: nibrs_weapon_type.py Projekt: 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),
    ]

Beispiel #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),
    ]

Beispiel #3

Datei: nibrs_victim_type.py Projekt: 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),
    ]

Beispiel #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),
    ]

Beispiel #5

Datei: nibrs_prop_loss_type.py Projekt: 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),
    ]

Beispiel #6

Datei: nibrs_cleared_except.py Projekt: 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),
    ]

Beispiel #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),
    ]

Beispiel #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),
    ]

Beispiel #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),
    ]

Beispiel #10

Datei: nibrs_arrestee_weapon.py Projekt: 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,
        ),
    ]

Beispiel #11

Datei: nibrs_victim_offender_rel.py Projekt: 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,
        ),
    ]

Beispiel #12

Datei: nibrs_offense_type.py Projekt: 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),
    ]

Beispiel #13

Datei: ref_state.py Projekt: 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),
    ]

Beispiel #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),
    ]

Beispiel #15

Datei: ref_race.py Projekt: 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),
    ]

Beispiel #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),
    ]

Beispiel #17

Datei: nibrs_property_desc.py Projekt: 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
        ),
    ]

Beispiel #18

Datei: nibrs_suspected_drug.py Projekt: 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,
        ),
    ]

Beispiel #19

Datei: nibrs_incident.py Projekt: 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),
    ]

Beispiel #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),
    ]

Beispiel #21

Datei: agencies.py Projekt: 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),
    ]

Beispiel #22

Datei: nibrs_offender.py Projekt: 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),
    ]

Beispiel #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),
    ]

Beispiel #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),
    ]

Beispiel #25

Datei: nibrs_ethnicity.py Projekt: 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),
    ]