llead
Tables
allegation
uid, tracking_id_og, tracking_id, case_number, allegation_uid, allegation, investigation_status, assigned_department, assigned_division, traffic_stop, body_worn_camera_available, app_used, citizen_arrested, disposition, complainant_name, action, initial_action, agency, incident_type, supervisor_uid, supervisor_rank, badge_no, department_code, department_desc, employment_status, investigator, investigator_uid, investigator_rank, shift_supervisor, allegation_desc, allegation_sub_desc, investigating_department, referred_by, incident_location, disposition_desc, item_number, race, sex, age, arresting_officer_uid, investigating_supervisor_uid, reporting_officer_uid
21,890 rows
citizens
citizen_uid, allegation_uid, uof_uid, stop_and_search_uid, complainant_type, complainant_sex, complainant_race, citizen_influencing_factors, citizen_distance_from_officer, citizen_arrested, citizen_arrest_charges, citizen_hospitalized, citizen_injured, citizen_age, citizen_race, citizen_sex, citizen_id, citizen_height, citizen_weight, citizen_hair_color, citizen_eye_color, citizen_driver_license_state, agency
841,673 rows
documents
docid, page_count, pdf_db_path, pdf_db_id, pdf_db_content_hash, txt_db_path, txt_db_id, txt_db_content_hash, hrg_type, year, month, day, dt_source, hrg_no, accused, matched_uid, hrg_text, title, agency
649 rows
event
event_uid, kind, year, month, day, time, raw_date, uid, allegation_uid, appeal_uid, uof_uid, agency, badge_no, employee_id, department_code, department_desc, division_desc, unit_desc, unit_sub_desc, employee_class, rank_code, rank_desc, employment_status, sworn, officer_inactive, salary, overtime_annual_total, overtime_location, overtime_freq, salary_freq, award, award_comments, left_reason, left_reason_desc, years_of_service, source_agency, brady_uid
145,875 rows
personnel
uid, last_name, middle_name, first_name, birth_year, birth_month, birth_day, race, sex, agency
50,402 rows
stop-and-search
stop_and_search_uid, tracking_id_og, tracking_id, item_number, id, district, zone, stop_reason, vehicle_year, vehicle_make, vehicle_model, vehicle_style, vehicle_color, vehicle_number, zip_code, stop_and_search_location, assigned_district, assigned_department, stop_results, subject_type, search_occurred, evidence_seized, evidence_types, strip_body_cavity_search, legal_basis, consent_to_search, consent_form_completed, search_types, exit_vehicle, first_name, middle_name, last_name, badge_number, stop_and_search_year, stop_and_search_month, stop_and_search_day, stop_and_search_time, agency, uid
243,081 rows
use-of-force
uid, uof_uid, tracking_id_og, tracking_id, investigation_status, service_type, light_condition, weather_condition, shift_time, disposition, division, division_level, unit, originating_bureau, use_of_force_description, use_of_force_level, use_of_force_effective, age, years_of_service, officer_injured, agency, use_of_force_reason
3,787 rows
Download SQLite DB: llead.db 223.1 MB