Loading recorded transformations...
See what Metrka changed in the source data before publishing this version.
fdc_obis.offender · 2026-01
42 routine steps on this page across 28 fields
Data formats
Values were stored in the formats declared by the data contract.
23 fields
Address Line 1
120,559 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 120559
}Address Line 2
29,774 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 29774
}Case Number
370,435 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 370435
}Charge Description
371,014 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 371014
}City
90,985 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 90985
}Country Code
113,414 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 113414
}County Of Conviction
371,014 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 371014
}First Name
138,361 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 138361
}Last Name
138,361 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 138361
}Middle Name
88,039 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 88039
}Name Suffix
4,905 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 4905
}Parole Term
371,014 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 371014
}Person Id
371,014 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 371014
}Person Id
120,563 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 120563
}Person Id
138,366 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 138366
}Postal Code
90,725 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 90725
}Probation Term
371,014 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 371014
}Race Code
138,366 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 138366
}Race Name
138,366 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 138366
}Sequence
371,014 populated source values were prepared as whole numbers.
Values were converted to the int type declared in the data contract.
{
"target_type": "int",
"source_dtype": "str",
"published_dtype": "Int64",
"failed_value_count": 0,
"non_null_value_count": 371014
}Sex Code
138,366 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 138366
}State Code
99,774 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 99774
}Supervision Office
138,366 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 138366
}Supervision Status
137,607 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 137607
}Supervision Type
137,534 populated source values were prepared as text.
Values were converted to the string type declared in the data contract.
{
"target_type": "string",
"source_dtype": "str",
"published_dtype": "string",
"failed_value_count": 0,
"non_null_value_count": 137534
}Dates
Source date values were interpreted and stored consistently.
5 fields
Adjudication Date
371,014 date values were recognized successfully.
Values were parsed using the %m/%d/%Y source date format declared in the data contract.
{
"target_type": "date",
"source_format": "%m/%d/%Y",
"parsed_value_count": 371014,
"source_non_null_count": 371014,
"coerced_to_missing_count": 0
}Birth Date
138,366 date values were recognized successfully.
Values were parsed using the %m/%d/%Y source date format declared in the data contract.
{
"target_type": "date",
"source_format": "%m/%d/%Y",
"parsed_value_count": 138366,
"source_non_null_count": 138366,
"coerced_to_missing_count": 0
}Offense Date
371,014 date values were recognized successfully.
Values were parsed using the %m/%d/%Y source date format declared in the data contract.
{
"target_type": "date",
"source_format": "%m/%d/%Y",
"parsed_value_count": 371014,
"source_non_null_count": 371014,
"coerced_to_missing_count": 0
}Supervision End Date
137,702 date values were recognized successfully.
Values were parsed using the %m/%d/%Y source date format declared in the data contract.
{
"target_type": "date",
"source_format": "%m/%d/%Y",
"parsed_value_count": 137702,
"source_non_null_count": 137702,
"coerced_to_missing_count": 0
}Supervision Start Date
138,366 date values were recognized successfully.
Values were parsed using the %m/%d/%Y source date format declared in the data contract.
{
"target_type": "date",
"source_format": "%m/%d/%Y",
"parsed_value_count": 138366,
"source_non_null_count": 138366,
"coerced_to_missing_count": 0
}Text formatting
Text capitalization and surrounding whitespace were standardized.
12 fields
Charge Description
Text formatting was standardized in 370,981 values.
Text values were stripped and converted to title case as declared in the data contract.
{
"mode": "title",
"trimmed_value_count": 0,
"non_null_value_count": 371014,
"case_changed_value_count": 370981
}County Of Conviction
Text formatting was standardized in 371,014 values.
Text values were stripped and converted to title case as declared in the data contract.
{
"mode": "title",
"trimmed_value_count": 0,
"non_null_value_count": 371014,
"case_changed_value_count": 371014
}First Name
Text formatting was standardized in 138,308 values.
Text values were stripped and converted to title case as declared in the data contract.
{
"mode": "title",
"trimmed_value_count": 0,
"non_null_value_count": 138361,
"case_changed_value_count": 138308
}Last Name
Text formatting was standardized in 138,360 values.
Text values were stripped and converted to title case as declared in the data contract.
{
"mode": "title",
"trimmed_value_count": 0,
"non_null_value_count": 138361,
"case_changed_value_count": 138360
}Middle Name
Text formatting was standardized in 74,666 values.
Text values were stripped and converted to title case as declared in the data contract.
{
"mode": "title",
"trimmed_value_count": 0,
"non_null_value_count": 88039,
"case_changed_value_count": 74666
}Name Suffix
Text formatting was standardized in 4,775 values.
Text values were stripped and converted to title case as declared in the data contract.
{
"mode": "title",
"trimmed_value_count": 0,
"non_null_value_count": 4905,
"case_changed_value_count": 4775
}Race Code
The source data already matched this preparation rule, so no values needed adjustment.
Text values were stripped and converted to upper case as declared in the data contract.
{
"mode": "upper",
"trimmed_value_count": 0,
"non_null_value_count": 138366,
"case_changed_value_count": 0
}Race Name
Text formatting was standardized in 138,366 values.
Text values were stripped and converted to title case as declared in the data contract.
{
"mode": "title",
"trimmed_value_count": 0,
"non_null_value_count": 138366,
"case_changed_value_count": 138366
}Sex Code
The source data already matched this preparation rule, so no values needed adjustment.
Text values were stripped and converted to upper case as declared in the data contract.
{
"mode": "upper",
"trimmed_value_count": 0,
"non_null_value_count": 138366,
"case_changed_value_count": 0
}Supervision Office
Text formatting was standardized in 138,366 values.
Text values were stripped and converted to title case as declared in the data contract.
{
"mode": "title",
"trimmed_value_count": 0,
"non_null_value_count": 138366,
"case_changed_value_count": 138366
}Supervision Status
Text formatting was standardized in 137,607 values.
Text values were stripped and converted to title case as declared in the data contract.
{
"mode": "title",
"trimmed_value_count": 0,
"non_null_value_count": 137607,
"case_changed_value_count": 137607
}Supervision Type
Text formatting was standardized in 137,534 values.
Text values were stripped and converted to title case as declared in the data contract.
{
"mode": "title",
"trimmed_value_count": 0,
"non_null_value_count": 137534,
"case_changed_value_count": 137534
}