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),
    ]
Пример #2
0
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),
    ]
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),
    ]
Пример #4
0
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),
    ]
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),
    ]
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),
    ]
Пример #7
0
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),
    ]
Пример #8
0
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),
    ]
Пример #9
0
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),
    ]
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,
        ),
    ]
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,
        ),
    ]
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),
    ]
Пример #13
0
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),
    ]
Пример #14
0
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),
    ]
Пример #15
0
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),
    ]
Пример #16
0
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),
    ]
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
        ),
    ]
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,
        ),
    ]
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),
    ]
Пример #20
0
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),
    ]
Пример #21
0
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),
    ]
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),
    ]
Пример #23
0
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),
    ]
Пример #24
0
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),
    ]
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),
    ]