Skip to content
Thomas Apodaca edited this page May 25, 2016 · 8 revisions

Incoming JSON Format Guide

The incoming (i.e. source system to Comport) JSON schema for each data set follows:

Complaints

{
    'data': [
        {
            'opaqueId': 'd716e65e8efa304d7b80a36bbd55f664',
            'serviceType': 'Restraining',
            'source': 'CPCO (Formal)',
            'occuredDate': '2015-04-08 0:0:00',
            'division': 'Operational Division',
            'precinct': 'Second Precinct',
            'shift': 'Night Beats',
            'beat': 'Evenings',
            'allegationType': 'Off-Duty Employment',
            'allegation': 'Working type of ODE prohibited by general order',
            'disposition': None,
            'residentRace': 'White',
            'residentSex': 'Female',
            'residentAge': '15',
            'officerIdentifier': '90607ab31c2114e987f7e458680a8f15',
            'officerRace': 'Bi-Racial',
            'officerSex': 'Male',
            'officerAge': '29',
            'officerYearsOfService': 42,
        }
    ]
}

Use of Force

{
    'data': [
        {
            'opaqueId': 'e61040650aeab567fa2ec83a89e8ff4a',
            'occuredDate': '2015-06-26 0:0:00',
            'occuredTime': '2015-06-26 12:37:00',
            'division': 'Operations Division',
            'precinct': 'North District',
            'shift': 'ND Day Shift',
            'beat': 'Day Shift 2nd RC',
            'disposition': 'Unfounded/Exonerated',
            'officerForceType': 'Body Weight Leverage',
            'useOfForceReason': 'Assaulting Citizen(s)',
            'serviceType': 'Traffic Stop',
            'arrestMade': True,
            'arrestCharges': 'Possession of Controlled Substance',
            'residentWeaponUsed': 'Suspect - Unarmed',
            'residentInjured': True,
            'residentHospitalized': False,
            'officerInjured': True,
            'officerHospitalized': False,
            'residentRace': 'Bi-Racial',
            'residentSex': 'Male',
            'residentAge': '40',
            'residentCondition': 'redness and skin damage',
            'officerIdentifier': 'a571abbed982bb06432c995d4095ed23',
            'officerRace': 'White ',
            'officerSex': 'Female',
            'officerAge': '50',
            'officerYearsOfService': '27',
            'officerCondition': 'abraisons'
        }
    ]
}

Officer Involved Shooting

{
    'data': [
        {
            'opaqueId': 'f732197d9f28d25396873573e7067629',
            'serviceType': 'Transporting',
            'occuredDate': '2015-08-09 0:0:00',
            'occuredTime': '2015-08-09 12:37:00',
            'division': 'Investigative Division',
            'precinct': 'Detective Bureau',
            'shift': 'Auto Theft Unit',
            'beat': 'Evenings',
            'disposition': 'Sustained',
            'residentRace': None,
            'residentSex': 'Male',
            'residentAge': '26',
            'residentWeaponUsed': 'Suspect - Unarmed',
            'residentCondition': 'Puncture from Tazer prong',
            'officerIdentifier': '5182b3dd18fa4e745678a2f529bf62c7',
            'officerForceType': 'Duty Handgun',
            'officerRace': 'White',
            'officerSex': 'Female',
            'officerAge': '36',
            'officerYearsOfService': '27',
            'officerCondition': 'pepper spray'
        }
    ]
}