eoir

Immigration court case data including proceedings, hearings, bond decisions, applications for relief, motions, and appeals.

Data license: Public Domain — U.S. Government Work · Data source: DOJ EOIR FOIA Library

Tables

appeals

idnAppeal, idncase, idnProceeding, strAppealCategory, strAppealType, datAppealFiled, strFiledBy, datAttorneyE27, datBIADecision, strBIADecision, strBIADecisionType, strCaseType, strLang, strNat, strProceedingIHP, strCustody, strProbono

1,000 rows

appeals2

idnAppeal, idncase, idnProceeding

1,000 rows

applications

IDNPROCEEDINGAPPLN, IDNPROCEEDING, IDNCASE, APPL_CODE, APPL_RECD_DATE, APPL_DEC

1,000 rows

attorneys

EOIRAttorneyID, OldAttorneyID, BaseCityCode, blnAttorneyActive, Source_Flag, datCreatedOn, datModifiedOn

1,000 rows

bonds

IDNASSOCBOND, IDNPROCEEDING, IDNCASE, OSC_DATE, REC_TYPE, GENERATION, SUB_GENERATION, UPDATE_DATE, UPDATE_TIME, INPUT_DATE, INPUT_TIME, BASE_CITY_CODE, BASE_CITY_NAME, HEARING_LOC_CODE, IJ_CODE, DEC, COMP_DATE, INITIAL_BOND, REL_CON, INS_TA, BOND_HEARING_TELEPHONIC, BOND_HEAR_REQ_DATE, NEW_BOND, APPEAL_REVD, APPEAL_NOT_FILED, DATE_APPEAL_DUE, E_28_DATE, BOND_TYPE, FILING_METHOD, FILING_PARTY, DECISION_DUE_DATE

1,000 rows

case_identifiers

IDNCASEID, IDNCASE, CASE_ID

1,000 rows

case_priority

idnCasePriHistory, casePriority_code, idnCase, DATCREATEDON, DATMODIFIEDON

1,000 rows

cases

IDNCASE, ALIEN_CITY, ALIEN_STATE, ALIEN_ZIPCODE, UPDATED_ZIPCODE, UPDATED_CITY, NAT, LANG, CUSTODY, SITE_TYPE, E_28_DATE, ATTY_NBR, CASE_TYPE, UPDATE_SITE, LATEST_HEARING, LATEST_TIME, LATEST_CAL_TYPE, UP_BOND_DATE, UP_BOND_RSN, CORRECTIONAL_FAC, RELEASE_MONTH, RELEASE_YEAR, INMATE_HOUSING, DATE_OF_ENTRY, C_ASY_TYPE, C_BIRTHDATE, C_RELEASE_DATE, UPDATED_STATE, ADDRESS_CHANGEDON, ZBOND_MRG_FLAG, Sex, DATE_DETAINED, DATE_RELEASED, LPR, DETENTION_DATE, DETENTION_LOCATION, DCO_LOCATION, DETENTION_FACILITY_TYPE, CASEPRIORITY_CODE

1,000 rows

charges

IDNPRCDCHG, IDNCASE, IDNPROCEEDING, CHARGE, CHG_STATUS

1,000 rows

custody_history

IDNCUSTODY, IDNCASE, CUSTODY, DATDETAINED, DATRELEASED

1,000 rows

federal_courts

idnAppealFedCourts, lngAppealID, datRequestedByOIL, strFedCourtDecision

1,000 rows

juvenile_history

idnJuvenileHistory, idnCase, idnProceeding, idnJuvenile, DATCREATEDON, DATMODIFIEDON

1,000 rows

lead_rider

idnLeadRider, idnLeadCase, idnRiderCase, datCreatedOn, datModifiedOn, datSeveredOn, idnLeadProceedingStart, idnLeadProceedingEnd, idnRiderProceedingStart, idnRiderProceedingEnd, blnActive

1,000 rows

motions

IDNMOTION, IDNPROCEEDING, IDNCASE, OSC_DATE, REC_TYPE, GENERATION, SUB_GENERATION, UPDATE_DATE, UPDATE_TIME, INPUT_DATE, INPUT_TIME, REJ_Remove, BASE_CITY_CODE, HEARING_LOC_CODE, IJ_CODE, IJ_NAME_Remove, DEC, COMP_DATE, MOTION_RECD_DATE, DATMOTIONDUE, WU_MSG_Remove, APPEAL_RSVD, APPEAL_NOT_FILED, RESP_DUE_DATE, STAY_GRANT, JURISDICTION, DATE_APPEAL_DUE, DATE_TO_BIA, DECISION_RENDERED_Remove, DATE_MAILED_TO_IJ, DATE_RECD_FROM_BIA, DATE_TO_BIA_UPDATE_Remove, STRFILINGPARTY, STRFILINGMETHOD, STRCERTOFSERVICECODE, E_28_RECPTFLAG_Remove, E_28_DATE, O_CLOCK_OPTION, SCHEDULED_HEAR_LOC_Remove, BLNDELETED_Remove, strDJScenario

1,000 rows

pro_bono

Case_type, DEC_212C, DEC_245, NBR_OF_CHGS, Other_dec1, Other_dec2, P_EOIR42A_DEC, P_EOIR42B_DEC, VD_DEC, WD_DEC, strCorFacility, datTranscriptServedAlien, strProceedingIHP, strFiledby, strNat, strLang, blnOARequestedbyAlien, blnOARequestedbyINS, blnOARequestedbyAmicus, Charge_1, Charge_2, Charge_3, Charge_4, Charge_5, Charge_6, recd_212C, recd_245, VD_recd, WD_recd, P_EOIR42A_Recd, P_EOIR42B_Recd, Dec_Code, other_comp, CRIM_IND, strA1, strA2, strA3, strAlienRegion, strAlienSex, strINSStatus, strPossibility, datROPreview, blnSelectedbyCoordinator, blnSelectedbyScreener, OptionA, DCO_Location, CaseID, Date_Of_Entry, Inmate_Housing, datmailedtoNGO, idnAppeal, datBriefCurrentlyDueAlien, idnRepl, blnIntrpr, strIntrprLang, ScreenerIdn, strDCAddress1, strDCAddress2, strDCCity, strDCState, strDCZip, blnProcessed, datCreatedOn, datModifiedOn, strCustody

1,000 rows

proceedings

IDNPROCEEDING, IDNCASE, OSC_DATE, INPUT_DATE, BASE_CITY_CODE, HEARING_LOC_CODE, IJ_CODE, TRANS_IN_DATE, PREV_HEARING_LOC, PREV_HEARING_BASE, PREV_IJ_CODE, TRANS_NBR, HEARING_DATE, HEARING_TIME, DEC_TYPE, DEC_CODE, DEPORTED_1, DEPORTED_2, OTHER_COMP, APPEAL_RSVD, APPEAL_NOT_FILED, COMP_DATE, ABSENTIA, VENUE_CHG_GRANTED, TRANSFER_TO, DATE_APPEAL_DUE_STATUS, TRANSFER_STATUS, CUSTODY, CASE_TYPE, NAT, LANG, SCHEDULED_HEAR_LOC, CORRECTIONAL_FAC, CRIM_IND, IHP, AGGRAVATE_FELON, DATE_DETAINED, DATE_RELEASED

1,000 rows

reps_assigned

IDNREPSASSIGNED, IDNCASE, STRATTYLEVEL, STRATTYTYPE, PARENT_TABLE, PARENT_IDN, BASE_CITY_CODE, INS_TA_DATE_ASSIGNED, E_27_DATE, E_28_DATE, BLNPRIMEATTY

1,000 rows

schedule

IDNSCHEDULE, IDNPROCEEDING, IDNCASE, OSC_DATE, GENERATION, SUB_GENERATION, REC_TYPE, LANG, HEARING_LOC_CODE, BASE_CITY_CODE, IJ_CODE, INTERPRETER_CODE, INPUT_DATE, INPUT_TIME, UPDATE_DATE, UPDATE_TIME, ASSIGNMENT_PATH, CAL_TYPE, ADJ_DATE, ADJ_TIME_START, ADJ_TIME_STOP, ADJ_RSN, ADJ_MEDIUM, ADJ_MSG, ADJ_ELAP_DAYS, LNGSESSNID, SCHEDULE_TYPE, NOTICE_CODE, BLNCLOCKOVERRIDE, EOIRAttorneyID

1,000 rows

tbl_br_deductcodes

DeductCode, DeductDescription, idnRepl

15 rows

tbladjournmentcodes

idnAdjCode, strcode, strDesciption, Regd_By, datCreatedOn, datModifiedOn, blnActive, asy_clk_stat

122 rows

tblbarcodetype

idnBarCodeType, strBarCodeTypeID, strBarCodeTypeDescription, blnActive, datCreatedOn, datModifiedOn, lngGroupID

141 rows

tbldeccode

idnDecCode, strCode, strDescription, datCreatedOn, datModifiedOn, blnActive

12 rows

tblinmatehousing

idnInmate, Strcity, Strcode, Strdescription, datCreatedOn, datModifiedOn, blnActive

1,000 rows

tblinsoffice

idnINSOffice, strCode, strDescription, datCreatedOn, datModifiedOn, blnActive

72 rows

tbllanguage

idnLang, strCode, strDescription, datCreatedOn, datModifiedOn, blnActive

738 rows

tbllookup3mbrreferredreason

idnReason, strReason, blnActive, datCreatedOn, datModifiedOn

7 rows

tbllookup_appln

idnAppln, strcode, strdescription, strAllowedCaseTypes, strAllowedDecisionCodes, APL_casetype_1, APL_casetype_2, APL_casetype_3, APL_casetype_4, APL_casetype_5, APL_casetype_6, APL_casetype_7, datCreatedOn, datModifiedOn, blnActive

40 rows

tbllookup_biacluster

idnLookupCluster, Report_Classification, Region_Name, Cluster_Name, Cluster_Subgroup, idnBaseCity, Sort_Start, Sort_End

240 rows

tbllookup_casepriority

idnCasePriority, strCode, strDescription, strDays, DATCREATEDON, DATMODIFIEDON, blnActive, blnBypasscal

6 rows

tbllookup_category

strcategory, strDescription, datCreatedOn, datModifiedOn, blnActive, idnCategory

7 rows

tbllookup_ins_clock_entry_status

idnClEnSt, INS_Clock_Entry_Status_Code, INS_Clock_Entry_Status_Desc, datCreatedOn, datModifiedOn, blnActive

8 rows

tbllookup_juvenile

idnJuvenile, strCode, strDescription, DATCREATEDON, DATMODIFIEDON

6 rows

tbllookupaliennat

idnNat, strCode, strDescription, Nacara, blnActive, datCreatedOn, datModifiedOn

256 rows

tbllookupallegationstmt

idnAllegStmt, strcode, strDescription, datCreatedOn, datModifiedOn, blnActive

3 rows

tbllookupappealissues

idnAppealIssues, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

246 rows

tbllookupappealtype

idnAppealType, strApplCode, strApplDescription, datCreatedOn, datModifiedOn, blnActive, blnDDAppeal

19 rows

tbllookupbasecity

idnBaseCity, BASE_CITY_CODE, BASE_CITY_NAME, BaseAutomated, BASE_ST_ADDRESS, BASE_CITY, BASE_STATE, BASE_ZIP_1, BASE_ZIP_2, BASE_PHONE_NO, strRegion, BaseEoir1Flag, BaseEoir1Code, BaseEoir1Suba, BaseEoir1Subb, BaseEoir1Subc, BaseEoir1Subd, BaseEoir1Sube, BaseEoir1Subf, BaseEoir2Flag, BaseEoir2Code, BaseEoir2Suba, BaseEoir2Subb, BaseEoir2Subc, BaseEoir2Subd, BaseEoir2Sube, BaseEoir2Subf, BaseEoir5Flag, BaseEoir5Code, BaseEoir5Suba, BaseEoir5Subb, BaseEoir5Subc, BaseEoir5Subd, BaseEoir5Sube, BaseEoir5Subf, BaseEoir6Flag, BaseEoir6Code, BaseEoir6Suba, BaseEoir6Subb, BaseEoir6Subc, BaseEoir6Subd, BaseEoir6Sube, BaseEoir6Subf, BaseEoir7Flag, BaseEoir7Code, BaseEoir7Suba, BaseEoir7Subb, BaseEoir7Subc, BaseEoir7Subd, BaseEoir7Sube, BaseEoir7Subf, BaseEoir34Flag, BaseEoir34Code, BaseEoir34Suba, BaseEoir34Subb, BaseEoir34Subc, BaseEoir34Subd, BaseEoir34Sube, BaseEoir34Subf, BaseEoir35Flag, BaseEoir35Code, BaseEoir35Suba, BaseEoir35Subb, BaseEoir35Subc, BaseEoir35Subd, BaseEoir35Sube, BaseEoir35Subf, BaseEoir36Flag, BaseEoir36Code, BaseEoir36Suba, BaseEoir36Subb, BaseEoir36Subc, BaseEoir36Subd, BaseEoir36Sube, BaseEoir36Subf, BaseEoir39Flag, BaseEoir39Code, BaseEoir39Suba, BaseEoir39Subb, BaseEoir39Subc, BaseEoir39Subd, BaseEoir39Sube, BaseEoir39Subf, I122Flag, I122Code, I122Suba, I122Subb, I122Subc, I122Subd, I122Sube, I122Subf, RopDefault, RopPrtClass, BaseSplPrtClass, datCreatedOn, datModifiedOn, blnActive, blnBCIS

97 rows

tbllookupbia

idnBIA, strCode, strGroup, blnActive, datCreatedOn, datModifiedOn, strTeam, strPanel, blnSLStatus

867 rows

tbllookupbiadecision

idnBIAdec, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

53 rows

tbllookupbiadecisiontype

idnBIAdecType, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

5 rows

tbllookupboardmotions

idnBoardMotion, strBoardMotionCode, strBoardMotionDescription, datCreatedOn, datModifiedOn, blnActive, strHelp, strAllowedDecisions, intMandatoryResponseDueByDays, intMandatoryIJDecisionByDays

16 rows

tbllookupcal_type

idnCalType, strCalTypeCode, strCalTypeDescription, datCreatedOn, datModifiedOn, blnActive

29 rows

tbllookupcallup_reasons

idnCalTypeReason, strcode, strDesciption, Regd_By, datCreatedOn, datModifiedOn, blnActive

30 rows

tbllookupcaseidentifier

idnCaseIdentifier, strcode, strDescription, datCreatedOn, datModifiedOn, blnActive

110 rows

tbllookupcasetype

idnCaseType, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn, strAnsirCode

13 rows

tbllookupcharges

idnCharges, strCode, strCodeString, strCodeDescription, applicable_case_type1, applicable_case_type2, applicable_case_type3, criminal_flag, aggravate_felon, DatCreatedOn, DatModifiedOn, blnActive

252 rows

tbllookupclaimedissue

idnClaimedIssue, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

4 rows

tbllookupcommenttypeboard

idnCommBrd, strcode, strDescription, datCreatedOn, datModifiedOn, blnActive

9 rows

tbllookupcomponents

idnComp, strCompCode, strCompDescription, datCreatedOn, datModifiedOn, blnActive

4 rows

tbllookupconsultedwith

idnConsultedWith, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

5 rows

tbllookupcontactchange

idnContactChange, strContactChangeCode, strContactChangeDesc, blnActive, datCreatedOn, datModifiedOn

9 rows

tbllookupcountry

idnCountry, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

254 rows

tbllookupcourtappdecisions

idnCourtApplnDec, strCourtApplnDecCode, strCourtApplnDecDesc, blnActive, datCreatedOn, datModifiedOn, Comments

14 rows

tbllookupcourtdecision

idnCourtDecision, strCaseType, strDecCode, strDecDescription, strDecType, strFinalDisposition, blnActive, datCreatedOn, datModifiedOn

217 rows

tbllookupcustodystatus

idnCustodyStatus, strCode, strSelecBoxVal, strDescription, blnActive, datCreatedOn, datModifiedOn

3 rows

tbllookupdddecisiontypes

idnDDDecType, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn, strDecsription, strFinalDisp

23 rows

tbllookupdistrictlocation

idnDestLoc, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

288 rows

tbllookupfedcourtdecision

idnFedCourt, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

4 rows

tbllookupfedcourtremandto

idnFedCourtRem, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

2 rows

tbllookupfeestatus

idnFee, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

5 rows

tbllookupfeetype

idnFeeType, strCode, strDescription, curAmount, blnActive, datCreatedOn, datModifiedOn

3 rows

tbllookupfiledby

idnFiled, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

9 rows

tbllookupfiling_method

idnFilingMethod, strFilingMethodCode, strFilingMethodDesc, datCreatedOn, datModifiedOn, blnActive

4 rows

tbllookupfiling_method_party

idnFilingParty, strFilingPartyCode, strFilingPartyDesc, datCreatedOn, datModifiedOn, blnActive

10 rows

tbllookupfinaldisposition

idnFinDisp, strCode, strDescription, blnActive, datCreatedOn, datModifiedOn

4 rows

tbllookuphloc

idnHloc, HEARING_LOC_CODE, HEARING_LOC_NAME, HEARING_CORR_TITLE, HEARING_ST_ADDRESS, HEARING_CITY, HEARING_STATE, HEARING_ZIP, HEARING_PHONE_NO, HEARING_BASE_CITY, Hear_Admin_Hear_Loc, Hear_Trans_COV_City, Hear_Det_Type, Hear_Active_Flg, datCreatedOn, datModifiedOn, blnActive, ROPLoc, intCalDetainDays, intCalINSAsyPDays, intCalINSAsyMDays, intCalINSDays, intCalEOIRDays, intCalCFRDays, intCalCDRDays, CircuitCourt, blnPrnWksOnAdd, blnPrnRopOnAdd

1,000 rows

tbllookupholdreason

strCode, strDescription, blnActive, datCreatedOn, datModifiedOn, idnRepl

37 rows

tbllookupholidays

idnHoliday, datHoliday, strHoliday, Holiday_Day, blnActive, datCreatedOn, datModifiedOn

613 rows

tbllookupinmate

ID, INMATE_BASE, INMATE_CODE, INMATE_NAME, INMATE_ADDRESS, INMATE_CITY, INMATE_ST, INMATE_ZIP, INMATE_PHONE, datCreatedOn, datModifiedOn, blnActive

1,000 rows

tbllookupinsaddress

idnLookupINSAddress, strCode, strName, strAddress, strCity, strState, strZip, datCreatedOn, datModifiedOn, blnActive

754 rows

tbllookupinsloc

ID, INSLOC_CODE, INSLOC_INFO, INSLOC_ASY, datCreatedOn, datModifiedOn, blnActive

1,000 rows

tbllookupinsta

ID, INSTA_BASE, datCreatedOn, datModifiedOn, blnActive

1,000 rows

tbllookupintrpr

IDNIntrpr, Inhouse_Flag, IntrCode, Base_city, IntrHloc, datCreatedOn, datModifiedOn, blnActive

94 rows

tbllookupintrpragenda

idnIntrPrAgenda, IntrCode, Base_city, LanguageWorkday, LanguageCode, IntrHloc, StartTime, EndTime, BreakStartTime, BreakEndTime, datCreatedOn, datModifiedOn, blnActive

5 rows

tbllookupintrprlang

idnintrprLang, IntrCode, Base_city, LanguageCode, DATCREATEDON, DATMODIFIEDON

14 rows

tbllookupintrprlanggroup

idnIntrLangGroup, LanguageCode, Base_city, MasterGroupFlag, IndivGroupFlag, DATCREATEDON, DATMODIFIEDON

2 rows

tbllookupjudge

idnJudge, JUDGE_CODE, JUDGE_NAME, JUDGE_ST_ADDRESS, JUDGE_CITY, JUDGE_STATE, JUDGE_ZIP_1, JUDGE_ZIP_2, JUDGE_PHONE_NO, datCreatedOn, datModifiedOn, blnActive, blnSkippedOnWheel, blnLastOnWheel, blnSkippedOnWheelMA, blnLastOnWheelMA, intOrderMA, intOrderMM

1,000 rows

tbllookupjudgebasecity

idnJudgeCity, BASE_CITY_CODE, JUDGE_CODE, JUDGE_NAME, JUDGE_ST_ADDRESS, JUDGE_CITY, JUDGE_STATE, JUDGE_ZIP, JUDGE_PHONE_NO, JUBOOKFACT, JUDATE, JUTIME, JULOC, JULOC2, JULOC3, JULOC4, JUCOURTROOM, JUCOURTROOM2, JUCOURTROOM3, JUCOURTROOM4, JUINDATE, JUINTIME, JUMODDATE, JUMODTIME, datCreatedOn, datModifiedOn, blnActive

1,000 rows

tbllookupmotiontype

idnMotionType, strMotionCode, strMotionType, strMotionDesc, strMotionSummary, strFilingPartyCodes, strLegacyCode, datCreatedOn, datModifiedOn, blnActive, blnFilePriortoIJDecision, blnFileAfterIJDecision, intMandatoryIJDecisionByDays, blnFeeRequired, blnFileOrally, blnHearingRequiredtoFile, blnAdminCompleteReq, blnIJGrantPriorToHearing, blnCertServiceReqd, blnAsylClockAffected, blnAsylClockAffectedStart, IntMandatoryResponseDueByDaysDefault

72 rows

... and 6 hidden tables

Views

Download SQLite DB: eoir.db 5.3 MB

EOIR Case Data

Custom SQL query

Tables

Views