CREATE TABLE incidents
(
    case_number                TEXT  not null
        primary key,
    date                       DATE          not null,
    location                   TEXT  not null,
    subject_statuses           TEXT  not null,
    subject_weapon             TEXT  not null,
    subjects                   TEXT  not null,
    subject_count              INTEGER           not null,
    officers                  TEXT not null

);
incidents
CREATE TABLE officers
(
    case_number TEXT not null,
    race        TEXT         null,
    gender      TEXT         not null,
    last_name   TEXT not null,
    first_name  TEXT null,
    full_name   TEXT not null,
    foreign key (case_number) references incidents (case_number)
);
officers
CREATE TABLE subjects
(
    case_number TEXT not null,
    race        TEXT         not null,
    gender      TEXT         not null,
    last_name   TEXT not null,
    first_name  TEXT null,
    full_name   TEXT not null,
    foreign key (case_number) references incidents (case_number)
);
subjects
original_column_name,column_name,column_description,data_format,value_description
case_number,case number,case number,text,
race,race,race,text,
gender,,gender,text,"M: male;

F: female"
last_name,last name,last name,text,
first_name,first name,first name,text,
full_name,full name,full name,text,
officers
original_column_name,column_name,column_description,data_format,value_description
case_number,case number,case number,text,
race,race,race,text,
gender,,gender,text,"M: male;

F: female"
last_name,last name,last name,text,
first_name,first name,first name,text,
full_name,full name,full name,text,
subjects
original_column_name,column_name,column_description,data_format,value_description
case_number,case number,case number,text,
date,,date,date,
location,,location,text,
subject_statuses,subject statuses,statuses of the victims ,text,
subject_weapon,subject weapon,subject weapon,text,
subjects,,subjects,text,
subject_count,,subject_count,integer,
officers,,officers,text,
Incidents