Data Tools: Software

AFCARS Foster Care File Linker version 1.2

A WX Python GUI (or CLI) reads multiple AFCARS files (fixed-width text or CSV, zip/gzip/bzip2 compressed or raw), standardizes dates, sorts and classifies (millions of) rows, detects & diagnoses record number linking issues, displays color-coded records in a search-enabled grid, and saves to a new AFCARS file (fixed-width text or CSV) with 2 added fields: 1. removal episode id, and 2. record class.

• Download Microsoft Windows Installer
• AFCARS Row Classification Logic (PDF)
• WX Python Script Source Code

NCANDS File Linker

Coming soon, or as soon as I have some spare time ...

NCANDS to AFCARS File Linker

Coming soon, or as soon as I have some spare time ...