ramseycounty-us/child-support-case-participant-demographic-data-r6sk-x3g9
 
Readme
Updated 11 months ago
Indexed 17 hours ago

Child Support Case Participant Demographic Data

This data set provides address state and country, plus ZIP code for only addresses in the seven county metro area of the Twin Cities of Minnesota. The data set also includes state and/or country of birth, primary language, and indicates the need for an interpreter for verbal communications for each case participant. Case Participants include the custodian parent (parent or caretaker who the child resides with), non-custodial parent (the parent who may have an obligation to pay child support), and each child under age 22. This data set does not include children in open cases who are over the age of 22. For most U.S. States, the emancipation age does not exceed the age of 22. Children are no longer active in child support cases once they are emancipated. The emancipation age differs for each U.S. State.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
BIRTH COUNTRY NAMEbirth_country_namebirth_country_nameTextThis column spells out the case participant's birth country name.
BIRTH STATEbirth_statebirth_stateTextCase Participant's State of Birth.
ADDRESS STATEaddress_stateaddress_stateTextCase Participant's mailing address State.
Zip Codes:@computed_region_iz2i_7cte:@computed_region_iz2i_7cteNumberThis column was automatically created in order to record in what polygon from the dataset 'Zip Codes' (iz2i-7cte) the point in column 'geocoded_column' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Cities:@computed_region_hbqc_yfq7:@computed_region_hbqc_yfq7NumberThis column was automatically created in order to record in what polygon from the dataset 'Cities' (hbqc-yfq7) the point in column 'geocoded_column' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
INTERPRETER NEEDEDinterpreter_neededinterpreter_neededTextIndicates whether or not a case participant needs an interpreter for verbal communications.
PRIMARY LANGUAGEprimary_languageprimary_languageTextCase Participant's primary communication language.
BIRTH COUNTRY ABBREVIATIONbirth_countrybirth_countryTextCase Participant's Country of Birth abbreviation.
ADDRESS COUNTRY ABBREVIATIONaddress_countryaddress_countryTextCase Participant's mailing address Country abbreviation.
ADDRESS ZIPaddress_zipaddress_zipTextCase Participant's mailing address zip code is included for only addresses in the seven county Twin Cities, Minnesota, area. Zip codes outside this area do not have the zip code listed..
YEAR ENDINGyear_endingyear_endingCalendar dateCalendar year end date.
PERSONS ROLEpersons_rolepersons_roleTextCustodial Parent refers to the parent or caregiver who may be eligible to receive child support. Non-Custodial Parent refers to the parent who may have an obligation to pay child support. Child refers to children under 22 years of age.
GEOREFERENCED ADDRESS ZIPgeocoded_columngeocoded_columnPointCase Participant's mailing address zip code georeferenced.
ADDRESS COUNTRY NAMEaddress_country_nameaddress_country_nameTextThe data in this column spells out the full name of the case participant's address country.
ETHNICITYethnicityethnicityTextCase Participant's ethnicity.
Upstream Metadata