json_format

JSON Format

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

Complaints

{
  'data': [
    {
      'occuredDate': '2015-04-08 0:0:00',
      'officerYearsOfService': 42,
      'officerSex': None,
      'disposition': None,
      'officerIdentifier': '8W 7KN FNW',
      'residentAge': '15',
      'beat': 'Evenings',
      'shift': 'Night Beats',
      'residentRace': 'White',
      'division': 'Operational Division',
      'allegationType': 'Off-Duty Employment',
      'precinct': 'Second Precinct',
      'opaqueId': '0 AL2CH85C',
      'allegation': 'Working type of ODE prohibited by general order',
      'officerAge': '29',
      'officerRace': 'Bi-Racial',
      'residentSex': None,
      'source': 'CPCO (Formal)',
      'serviceType': 'Restraining'
    },
    {
      'occuredDate': '2014-01-03 0:0:00',
      'officerYearsOfService': 43,
      'officerSex': 'Male',
      'disposition': 'Partially Sustained',
      'officerIdentifier': '40XOKWX WX',
      'residentAge': '18',
      'beat': 'X21 Zone',
      'shift': 'C Shift',
      'residentRace': 'White ',
      'division': 'Operational Division',
      'allegationType': 'Substandard Performance',
      'precinct': 'Fourth Precinct',
      'opaqueId': 'A JVI2LFB7',
      'allegation': 'Failure to properly investigate crash',
      'officerAge': '40',
      'officerRace': 'Unknown',
      'residentSex': None,
      'source': 'CPCO (Informal)',
      'serviceType': 'Call for Service'
    }
  ]
}

Use of Force

'data': [
  {
    'officerYearsOfService': 7,
    'beat': 'X28 Zone',
    'residentAge': '16',
    'officerSex': None,
    'shift': 'B Shift',
    'division': 'Operational Division',
    'useOfForceReason': 'Fleeing',
    'officerAge': '49',
    'residentRace': 'White ',
    'residentHospitalized': False,
    'residentCondition': 'tazer probes',
    'serviceType': 'Arresting',
    'disposition': 'Withdrawn',
    'residentWeaponUsed': '',
    'opaqueId': ' R3M0PU3EJ',
    'arrestMade': None,
    'officerInjured': True,
    'officerHospitalized': False,
    'officerForceType': 'Less Lethal-BPS Gas',
    'officerCondition': 'Abrasions',
    'residentInjured': None,
    'officerRace': 'White ',
    'precinct': 'First Precinct',
    'occuredDate': '2014-11-14 0:0:00',
    'arrestCharges': 'Violation of Protective Order (M)',
    'officerIdentifier': 'ZFFCD1WW79',
    'residentSex': 'Female'
  },
  {
    'officerYearsOfService': 20,
    'beat': 'Days',
    'residentAge': '58',
    'officerSex': 'Male',
    'shift': 'Auto Theft Unit',
    'division': 'Operational Division',
    'useOfForceReason': 'Non-Compliant',
    'officerAge': '28',
    'residentRace': 'White ',
    'residentHospitalized': True,
    'residentCondition': 'tazer drive stun',
    'serviceType': None,
    'disposition': None,
    'residentWeaponUsed': '',
    'opaqueId': ' X42E59XIX',
    'arrestMade': None,
    'officerInjured': True,
    'officerHospitalized': None,
    'officerForceType': 'Handgun',
    'officerCondition': 'taser probe strike',
    'residentInjured': None,
    'officerRace': None,
    'precinct': 'Detective Bureau',
    'occuredDate': '2015-12-20 0:0:00',
    'arrestCharges': 'Operating a Vehicle with a BAC .08% to .15% (M)',
    'officerIdentifier': 'B O6Z6Q3CN',
    'residentSex': 'Male'
  }
]
}