Loading recorded transformations...
See what Metrka changed in the source data before publishing this version.
fdc_obis.inmate_release · 2026-01
42 routine steps on this page across 26 fields
Data formats
Values were stored in the formats declared by the data contract.
18 fields
Case Number
1,395,312 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": 1395312
}Charge Description
1,395,649 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": 1395649
}County Of Conviction
1,395,649 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": 1395649
}Custody Level
459,484 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": 459484
}Detainer Sequence
360,666 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": 360666
}Detainer Type Name
345,622 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": 345622
}First Name
475,277 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": 475277
}Last Name
475,267 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": 475267
}Middle Name
346,395 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": 346395
}Name Suffix
25,994 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": 25994
}Person Id
360,666 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": 360666
}Person Id
925,801 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": 925801
}Person Id
1,395,649 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": 1395649
}Person Id
475,281 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": 475281
}Prison Term
1,395,649 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": 1395649
}Race Code
475,281 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": 475281
}Race Name
475,281 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": 475281
}Release Date Status
475,281 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": 475281
}Requesting Authority
360,666 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": 360666
}Sequence
1,395,649 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": 1395649
}Sex Code
475,281 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": 475281
}Dates
Source date values were interpreted and stored consistently.
8 fields
Adjudication Date
1,395,649 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": 1395649,
"source_non_null_count": 1395649,
"coerced_to_missing_count": 0
}Birth Date
475,278 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": 475278,
"source_non_null_count": 475278,
"coerced_to_missing_count": 0
}Detainer End Date
316,053 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": 316053,
"source_non_null_count": 316053,
"coerced_to_missing_count": 0
}Detainer Start Date
360,666 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": 360666,
"source_non_null_count": 360666,
"coerced_to_missing_count": 0
}Incarceration End Date
925,749 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": 925749,
"source_non_null_count": 925749,
"coerced_to_missing_count": 0
}Incarceration Start Date
925,801 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": 925801,
"source_non_null_count": 925801,
"coerced_to_missing_count": 0
}Offense Date
1,395,649 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": 1395649,
"source_non_null_count": 1395649,
"coerced_to_missing_count": 0
}Prison Release Date
475,281 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": 475281,
"source_non_null_count": 475281,
"coerced_to_missing_count": 0
}Text formatting
Text capitalization and surrounding whitespace were standardized.
13 fields
Charge Description
Text formatting was standardized in 1,395,649 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": 1395649,
"case_changed_value_count": 1395649
}County Of Conviction
Text formatting was standardized in 1,395,649 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": 1395649,
"case_changed_value_count": 1395649
}Custody Level
Text formatting was standardized in 459,484 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": 459484,
"case_changed_value_count": 459484
}Detainer Type Name
Text formatting was standardized in 345,622 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": 345622,
"case_changed_value_count": 345622
}First Name
Text formatting was standardized in 475,016 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": 475277,
"case_changed_value_count": 475016
}Last Name
Text formatting was standardized in 475,266 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": 475267,
"case_changed_value_count": 475266
}Middle Name
Text formatting was standardized in 7 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": 346395,
"case_changed_value_count": 7
}Name Suffix
Text formatting was standardized in 25,794 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": 25994,
"case_changed_value_count": 25794
}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": 475281,
"case_changed_value_count": 0
}Race Name
Text formatting was standardized in 475,281 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": 475281,
"case_changed_value_count": 475281
}Release Date Status
Text formatting was standardized in 475,281 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": 475281,
"case_changed_value_count": 475281
}Requesting Authority
Text formatting was standardized in 342,043 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": 360666,
"case_changed_value_count": 342043
}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": 475281,
"case_changed_value_count": 0
}