Daily datasets of USCIS form processing times
The U.S. Citizenship and Immigration Services (USCIS) provides estimated case processing times that vary by form and service center. These estimates include both an estimate of the case adjudication time as well as the case inquiry date, which determines when an applicant may contact USCIS regarding a case that is outside of normal processing times.
Unfortunately, these estimates are updated silently without any notification or record, sometimes multiple times per day. This project is an attempt to provide transparency for applicants who may be surprised to find that their case inquiry date was changed without their knowledge.
The dataset releases are produced on a daily cron schedule that scrapes the USCIS case processing time API and compiles the results into a SQLite database.
The raw JSON results are also collected into a SQLite archive and published as an artifact, in the case of debugging or if there's additional information to extract. These artifacts are not a permanent collection and will be removed eventually based on the artifact retention period.
sqldiff
output to compare daily changesform_types
tableforms
tableCREATE TABLE forms(
name TEXT PRIMARY KEY,
description_en TEXT,
description_es TEXT
) WITHOUT ROWID
offices
tableCREATE TABLE offices(
code TEXT PRIMARY KEY,
description TEXT
) WITHOUT ROWID
processing_time
tableCREATE TABLE processing_time(
"form_name" TEXT,
"office_code" TEXT,
"form_note_en" TEXT,
"form_note_es" TEXT,
"form_subtype" TEXT,
"publication_date" TEXT,
"range_upper" REAL,
"range_upper_unit" TEXT,
"range_lower" REAL,
"range_lower_unit" TEXT,
"service_request_date" TEXT,
"subtype_info_en" TEXT,
"subtype_info_es" TEXT,
"subtype_note_en" TEXT,
"subtype_note_es" TEXT,
PRIMARY KEY("form_name","office_code","form_subtype")
) WITHOUT ROWID
form_types
tableCREATE TABLE form_types(
form_name TEXT,
form_key TEXT,
form_type TEXT,
description_en TEXT,
description_es TEXT,
offices JSON,
PRIMARY KEY("form_name","form_key")
) WITHOUT ROWID
selftest
tableUsed for SQLite database integrity self-tests
forms
tableCREATE TABLE forms(
name TEXT PRIMARY KEY,
description_en TEXT,
description_es TEXT,
offices JSON
) WITHOUT ROWID
offices
tableCREATE TABLE offices(
code TEXT PRIMARY KEY,
description TEXT
) WITHOUT ROWID
processing_time
tableCREATE TABLE processing_time(
"form_name" TEXT,
"office_code" TEXT,
"form_note_en" TEXT,
"form_note_es" TEXT,
"form_subtype" TEXT,
"publication_date" TEXT,
"range_upper" REAL,
"range_upper_unit" TEXT,
"range_lower" REAL,
"range_lower_unit" TEXT,
"service_request_date" TEXT,
"subtype_info_en" TEXT,
"subtype_info_es" TEXT,
"subtype_note_en" TEXT,
"subtype_note_es" TEXT,
PRIMARY KEY("form_name","office_code","form_subtype")
) WITHOUT ROWID
selftest
tableUsed for SQLite database integrity self-tests