ripa-2018-db

Data license: ODbL · Data source: Open Justice

Custom SQL query

Appendix B Table 3

CLOSEST_CITY, COUNTY, CHP, LAPD, LASD, RCSD, SBSD, SDPD, SDSD...

777 rows

aa_main_table

UNIQUE_ID, DOJ_RECORD_ID, PERSON_NUMBER, AGENCY_ORI, AGENCY_ORI_2, AGENCY_NAME, TIME_OF_STOP, DATE_OF_STOP, STOP_DURATION...

1,800,054 rows

action_taken

UNIQUE_ID, ADS_REMOVED_VEHICLE_ORDER, ADS_REMOVED_VEHICLE_PHYCONTACT, ADS_SOBRIETY_TEST, ADS_CURB_DETENT, ADS_HANDCUFFED, ADS_PATCAR_DETENT, ADS_CANINE_SEARCH, ADS_FIREARM_POINT...

1,800,054 rows

age_groups_codes

CODE, AGE_GROUP

9 rows

basis_for_property_seizure

UNIQUE_ID, BPS_SAFEKEEPING, BPS_CONTRABAND, BPS_EVIDENCE, BPS_IMPOUND_VEHICLE, BPS_ABANDON_PROP, BPS_VIOLATE_SCHOOL

1,800,054 rows

basis_for_search

UNIQUE_ID, BFS_CONSENT_GIVEN, BFS_OFFICER_SAFETY, BFS_SEARCH_WARRANT, BFS_PAROLE, BFS_SUSPECT_WEAPON, BFS_VISIBLE_CONTRABAND, BFS_ODOR_CONTRABAND, BFS_CANINE_DETECT...

1,800,054 rows

contraband_evidence_discovered

UNIQUE_ID, CED_NONE_CONTRABAND, CED_FIREARM, CED_AMMUNITION, CED_WEAPON, CED_DRUGS, CED_ALCOHOL, CED_MONEY, CED_DRUG_PARAPHERNALIA...

1,800,054 rows

disability

UNIQUE_ID, PD_FULL, PD_DEAFNESS_HEARING, PD_SPEECH_IMPAIR, PD_BLIND, PD_MENTAL_HEALTH, PD_DEVEL_DISAB, PD_HYPERACTIVITY_DISABILITY, PD_OTHER...

1,800,054 rows

disability_codes

CODE, DISABILITY

9 rows

gender

UNIQUE_ID, G_FULL, G_MALE, G_FEMALE, G_TRANSGENDER_MAN, G_TRANSGENDER_WOMAN, G_GENDER_NONCONFORMING, G_MULTIGENDER

1,800,054 rows

gender_codes

CODE, GENDER

5 rows

race_ethnicity

UNIQUE_ID, RAE_FULL, RAE_ASIAN, RAE_BLACK_AFRICAN_AMERICAN, RAE_HISPANIC_LATINO, RAE_MIDDLE_EASTERN_SOUTH_ASIAN, RAE_NATIVE_AMERICAN, RAE_PACIFIC_ISLANDER, RAE_WHITE...

1,800,054 rows

race_ethnicity_codes

CODE, RACE_ETHNICITY

8 rows

reason_for_stop

UNIQUE_ID, RFS_TRAFFIC_VIOLATION_TYPE, RFS_TRAFFIC_VIOLATION_CODE, RFS_RS_CODE, RFS_RS_OFF_WITNESS, RFS_RS_MATCH_SUSPECT, RFS_RS_WITNESS_ID, RFS_RS_CARRY_SUS_OBJECT, RFS_RS_ACTIONS_INDICATIVE...

1,800,054 rows

reason_for_stop_codes

CODE, REASON_FOR_STOP

8 rows

result_of_stop

UNIQUE_ID, ROS_NO_ACTION, ROS_WARNING, ROS_CITATION, ROS_IN_FIELD_CITE_RELEASE, ROS_CUSTODIAL_WARRANT, ROS_CUSTODIAL_WITHOUT_WARRANT, ROS_FIELD_INTERVIEW_CARD, ROS_NONCRIMINAL_TRANSPORT...

1,800,054 rows

rfs_codes

CODE, REASON_FOR_STOP

8 rows

type_of_property_seized

UNIQUE_ID, TPS_FIREARM, TPS_AMMUNITION, TPS_WEAPON, TPS_DRUGS, TPS_ALCOHOL, TPS_MONEY, TPS_DRUG_PARAPHERNALIA, TPS_STOLEN_PROP...

1,800,054 rows

Queries

Download SQLite DB: ripa-2018-db.db 753.5 MB