Loading recorded transformations...
See what Metrka changed in the source data before publishing this version.
fdc_obis.inmate_active · 2026-01
54 routine steps on this page across 28 fields
Data formats
Values were stored in the formats declared by the data contract.
19 fields
Case Number
370,407 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": 370407
}Charge Description
370,458 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": 370458
}County Of Conviction
370,458 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": 370458
}Custody Level
87,583 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": 87583
}Detainer Sequence
79,757 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": 79757
}Detainer Type Code
79,757 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": 79757
}Detainer Type Name
79,757 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": 79757
}Facility Name
90,428 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": 90428
}First Name
453,455 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": 453455
}First Name
90,428 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": 90428
}Last Name
487,627 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": 487627
}Last Name
90,427 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": 90427
}Middle Name
289,652 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": 289652
}Middle Name
68,916 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": 68916
}Name Suffix
31,501 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": 31501
}Name Suffix
7,368 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": 7368
}Person Id
487,690 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": 487690
}Person Id
79,757 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": 79757
}Person Id
197,427 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": 197427
}Person Id
370,458 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": 370458
}Person Id
90,428 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": 90428
}Prison Term
370,458 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": 370458
}Race Code
90,428 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": 90428
}Race Name
90,428 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": 90428
}Requesting Authority
79,757 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": 79757
}Sequence
370,458 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": 370458
}Sex Code
90,428 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": 90428
}Dates
Source date values were interpreted and stored consistently.
9 fields
Adjudication Date
370,458 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": 370458,
"source_non_null_count": 370458,
"coerced_to_missing_count": 0
}Birth Date
90,428 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": 90428,
"source_non_null_count": 90428,
"coerced_to_missing_count": 0
}Custody Start Date
90,428 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": 90428,
"source_non_null_count": 90428,
"coerced_to_missing_count": 0
}Detainer End Date
47,032 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": 47032,
"source_non_null_count": 47032,
"coerced_to_missing_count": 0
}Detainer Start Date
79,757 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": 79757,
"source_non_null_count": 79757,
"coerced_to_missing_count": 0
}Incarceration End Date
107,022 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": 107022,
"source_non_null_count": 107022,
"coerced_to_missing_count": 0
}Incarceration Start Date
197,427 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": 197427,
"source_non_null_count": 197427,
"coerced_to_missing_count": 0
}Offense Date
370,458 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": 370458,
"source_non_null_count": 370458,
"coerced_to_missing_count": 0
}Prison Release Date
74,319 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": 74319,
"source_non_null_count": 74319,
"coerced_to_missing_count": 0
}Text formatting
Text capitalization and surrounding whitespace were standardized.
14 fields
Charge Description
Text formatting was standardized in 370,458 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": 370458,
"case_changed_value_count": 370458
}County Of Conviction
Text formatting was standardized in 370,458 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": 370458,
"case_changed_value_count": 370458
}Custody Level
Text formatting was standardized in 87,583 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": 87583,
"case_changed_value_count": 87583
}Detainer Type 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": 79757,
"case_changed_value_count": 0
}Detainer Type Name
Text formatting was standardized in 79,757 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": 79757,
"case_changed_value_count": 79757
}Facility Name
Text formatting was standardized in 136 values.
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": 90428,
"case_changed_value_count": 136
}First Name
Text formatting was standardized in 451,812 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": 453455,
"case_changed_value_count": 451812
}First Name
Text formatting was standardized in 90,401 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": 90428,
"case_changed_value_count": 90401
}Last Name
Text formatting was standardized in 481,710 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": 487627,
"case_changed_value_count": 481710
}Last Name
Text formatting was standardized in 90,427 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": 90427,
"case_changed_value_count": 90427
}Middle Name
Text formatting was standardized in 180,776 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": 289652,
"case_changed_value_count": 180776
}Middle Name
The source data already matched this preparation rule, so no values needed adjustment.
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": 68916,
"case_changed_value_count": 0
}Name Suffix
Text formatting was standardized in 30,246 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": 31501,
"case_changed_value_count": 30246
}Name Suffix
Text formatting was standardized in 7,328 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": 7368,
"case_changed_value_count": 7328
}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": 90428,
"case_changed_value_count": 0
}Race Name
Text formatting was standardized in 90,428 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": 90428,
"case_changed_value_count": 90428
}Requesting Authority
Text formatting was standardized in 72,683 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": 79757,
"case_changed_value_count": 72683
}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": 90428,
"case_changed_value_count": 0
}