Data Dictionary (Sjerlok Schema)

Descriptions of the fields available in the Sjerlok Case Management (API).

Data Selection

This document contains an overview of the data that can be uploaded to a case. The more information is made available the easier and better we can help to recover stolen vehicles.

Field name	Example	Description	Mandatory
disappear_date	"2017-07-05"	Disappear date. ISO 8061 format	x
case_number	"57483"	Id of case in client system	x
disappear_zip_code	“020806”	Zip code of place of loss
disappear_country	“Romania”	Country name where object was lost, according to ISO 3166-1 (or full country name). The value can be either a full name or a code as seen in this dataset https://datahub.io/core/country-list#data
disappear_city	“Bucharest”	Name of the location where the vehicle was stolen
object_owner__name	“John Doe“	The name of the owner of the stolen vehicle
object_owner__email	“john.doe@company.com”	Valid email of the owner of the vehicle
object_owner__phone_number	“+40785143440“	Valid phone number of the owner of the vehicle
theft_report_number	“200-34-555“	The theft report number
category	“cars”	Name of the category of the case object
object_data			x
object_data__make	“bmw“	The make of the car.	x
object_data__vin	“WDD2130042A060334”	Valid Vehicle Identification Number.	At least one, but preferably both, of the fields 'object_data__vin' or 'object_data__license_plate' should be provided
object_data__license_plate	“B 64 GRK“	The license plate of the vehicle.	At least one, but preferably both, of the fields 'object_data__vin' or 'object_data__license_plate' should be provided
object_data__model	“x6”	The model of the car
object_data__version	“xdrive”	The version of the car
object_data__color	“red”	English color of the paint on the exterior of the car
object_data__production_date	“2019-01-01“	Production date of the car. ISO 8061 format
object_data__first_registration_date	“2019-02-30“	Date of the first registration. ISO 8061 format.